SA-MP Forums Archive
OnPlayerConnect - - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: OnPlayerConnect - (/showthread.php?tid=520911)



OnPlayerConnect - - AMouldyLemon - 20.06.2014

pawn Код:
new query[128];
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, Ip[playerid], 16);
    mysql_format(1, query, sizeof(query),"SELECT `mPassword`, `ID` FROM `MainAccount` WHERE `mOriginalUsername` = '%e' LIMIT 1", pname[playerid]);
pawn Код:
(645) : error 017: undefined symbol "name"
(646) : error 017: undefined symbol "Ip"
(646) : warning 215: expression has no effect
(646) : error 001: expected token: ";", but found "]"
(646) : error 029: invalid expression, assumed zero
(646) : fatal error 107: too many error messages on one line



Re: OnPlayerConnect - - Konstantinos - 20.06.2014

You haven't declared "name" nor "Ip". If you want to store them to a global variable so you won't need to re-get the name/ip over and over again:
pawn Код:
// global:
new Player_Name[MAX_PLAYERS][MAX_PLAYER_NAME], Player_Ip[MAX_PLAYERS][16];

// OnPlayerConnect:
GetPlayerName(playerid, Player_Name[playerid], MAX_PLAYER_NAME);
GetPlayerIp(playerid, Player_Ip[playerid], 16);
so the format will be:
pawn Код:
mysql_format(1, query, sizeof(query),"SELECT `mPassword`, `ID` FROM `MainAccount` WHERE `mOriginalUsername` = '%e' LIMIT 1", Player_Name[playerid]);



Re: OnPlayerConnect - - AMouldyLemon - 20.06.2014

Thanks again.