new Float:Pickups[][PickInfo] = {
{1,1726.9751,-1636.3334,20.2171,0,1726.9526,-1638.7334,20.2234,18},
{2,2351.9111,-1168.9744,27.9920,0,2350.7036,-1181.1886,1027.9766,5},
{3,1553.6572,-1675.6367,16.1953,0,288.745971,169.350997,1007.171875,3},
{4,1258.3425,-785.4657,92.0302,0,1262.1348,-785.3854,1091.9063,5},
{5,1298.6053,-798.9628,84.1406,0,1299.1544,-795.9728,1084.0078,5},
{6,1929.5431,-1776.2677,13.5469,0,-27.3968,-30.2565,1003.5573,},
{7,1832.5872,-1842.0410,13.5781,0,-31.0414,-90.7142,1003.5469,180},
{8,1835.8566,-1681.8176,13.3723,0,493.6534,-23.5046,1000.6797,17},
{9,1739.3409,-1582.5289,14.1552,0,384.808624,173.804992,1008.382812,3},
{10,1572.2260,-1334.8035,16.4844,0,1548.6030,-1365.5646,326.2109,0},
{11,1698.5256,-1667.8107,20.1945,0,1701.5145,-1667.8511,20.2188,18}
};
for(new i=0; i<PLAYERS; i++)
{
for(new buildingid = 0; buildingid<MAX_BUILD_PICKUPS;buildingid++)
{
if(PickupsActive[i] == 1)
{
if(PlayerToPoint(2, i, Pickups[buildingid][EnterX], Pickups[buildingid][EnterY], Pickups[buildingid][EnterZ]))
{
SetPlayerPos(i, Pickups[buildingid][ExitX], Pickups[buildingid][ExitY], Pickups[buildingid][ExitZ]);
SetPlayerInterior(i, Pickups[buildingid][ExitInt]);
PickupsActive[i] = 0;
SetTimerEx("EnablePickupsAgain",5000,0,"i",i);
}
else if(PlayerToPoint(2, i, Pickups[buildingid][ExitX], Pickups[buildingid][ExitY], Pickups[buildingid][ExitZ]))
{
SetPlayerPos(i, Pickups[buildingid][EnterX], Pickups[buildingid][EnterY], Pickups[buildingid][EnterZ]);
SetPlayerInterior(i, Pickups[buildingid][EnterInt]);
PickupsActive[i] = 0;
SetTimerEx("EnablePickupsAgain",5000,0,"i",i);
}
}
}
}
new
pName1[MAX_PLAYER_NAME];
resultline[512],
player[35][32];
GetPlayerName(playerid,pName1,sizeof(pName1));
format(query,sizeof(query),"SELECT * FROM `***CENSORED***` WHERE LOWER(Username) = LOWER('%s') LIMIT 1", LoginplayerName);
mysql_query(query);
mysql_store_result();
if (mysql_fetch_row_format(resultline, "|"))
{
split(resultline, player, '|');
PlayerInfo[playerid][pKey] = strval(player[2]);
PlayerInfo[playerid][pAdmin] = strval(player[3]);
PlayerInfo[playerid][pcomportment] = strval(player[4]);
PlayerInfo[playerid][pgunlic] = strval(player[5]);
PlayerInfo[playerid][pCash] = strval(player[6]);
PlayerInfo[playerid][pHit] = strval(player[7]);
PlayerInfo[playerid][pJailed] = strval(player[8]);
PlayerInfo[playerid][pJailTime] = strval(player[9]);
PlayerInfo[playerid][pSkin] = strval(player[10]);
PlayerInfo[playerid][pTeam] = strval(player[11]);
PlayerInfo[playerid][pgivensigs] = strval(player[12]);
PlayerInfo[playerid][pgotecard] = strval(player[13]);
PlayerInfo[playerid][plastloginday] = strval(player[14]);
PlayerInfo[playerid][plastloginmonth] = strval(player[15]);
PlayerInfo[playerid][plastloginyear] = strval(player[16]);
PlayerInfo[playerid][vehlica] = strval(player[17]);
PlayerInfo[playerid][vehlicb] = strval(player[18]);
PlayerInfo[playerid][vehlicc] = strval(player[19]);
PlayerInfo[playerid][vehlicd] = strval(player[20]);
PlayerInfo[playerid][vehlice] = strval(player[21]);
PlayerInfo[playerid][vehlicf] = strval(player[22]);
PlayerInfo[playerid][pGun1] = strval(player[23]);
PlayerInfo[playerid][pGun2] = strval(player[24]);
PlayerInfo[playerid][pGun3] = strval(player[25]);
PlayerInfo[playerid][pGun4] = strval(player[26]);
PlayerInfo[playerid][pAmmo1] = strval(player[27]);
PlayerInfo[playerid][pAmmo2] = strval(player[28]);
PlayerInfo[playerid][pAmmo3] = strval(player[29]);
PlayerInfo[playerid][pAmmo4] = strval(player[30]);
PlayerInfo[playerid][pWanted] = strval(player[31]);
PlayerInfo[playerid][pEmail] = strval(player[32]);
mysql_free_result();
}
Originally Posted by ►☺◄©ookie►☺◄
ahh, this is a question from me... will the lower let mysql ignore if the nickname is Lower or Highercase?
|
oh and I also added "LOWER()" tags within the mysql query so it will ignore case, you can take it out of you want. |