/login crash help me - 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)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: /login crash help me (
/showthread.php?tid=154937)
/login crash help me -
ReVo_ - 16.06.2010
yo,
i make code /login using mysql... if i login server crash
Code
pawn Код:
if (strcmp(cmd,"/login", true) == 0)
{
new password[256];
password = strtok(cmdtext,idx);
if(PlayerLogIn[playerid]) return SendClientMessage(playerid, COLOR_GREY," Sei giа loggato");
if(!strlen(password)) return SendClientMessage(playerid, COLOR_GREY," Usa /login (password)");
new query2[256],resultline[256];
format(query2,sizeof(query2),"SELECT * FROM users WHERE username='%s'",Nickname[playerid]);
samp_mysql_query(query2);
samp_mysql_store_result();
if(!samp_mysql_fetch_row(resultline)) return SendClientMessage(playerid, COLOR_GREY," Nickname non registrato");
new tmptemp[256];
samp_mysql_get_field("password", tmptemp);
if(strfind(password,tmptemp,true))
{
SendClientMessage(playerid, COLOR_GREY," Password non corretta.");
return 1;
}
samp_mysql_get_field("kills", tmptemp);
Player[playerid][pKills]=strval(tmptemp);
samp_mysql_get_field("deaths", tmptemp);
Player[playerid][pDeaths]=strval(tmptemp);
samp_mysql_get_field("clan", tmptemp);
Player[playerid][pClan]=strval(tmptemp);
samp_mysql_get_field("rank", tmptemp);
Player[playerid][pRank]=strval(tmptemp);
samp_mysql_get_field("barche", tmptemp);
Player[playerid][pLicenzaBarche]=strval(tmptemp);
samp_mysql_get_field("aerei", tmptemp);
Player[playerid][pLicenzaAerei]=strval(tmptemp);
samp_mysql_get_field("admin", tmptemp);
Player[playerid][pAdmin]=strval(tmptemp);
samp_mysql_get_field("team", tmptemp);
Player[playerid][pTeam]=strval(tmptemp);
samp_mysql_get_field("level", tmptemp);
Player[playerid][pLevel]=strval(tmptemp);
samp_mysql_get_field("rispetto", tmptemp);
Player[playerid][pRespect]=strval(tmptemp);
samp_mysql_get_field("soldi", tmptemp);
Player[playerid][pMoney]=strval(tmptemp);
PlayerLogIn[playerid]=1;
SendClientMessage(playerid, COLOR_GREY," Account loggato con successo");
return 1;
}
Re: /login crash help me -
ReVo_ - 16.06.2010
...and register!
pawn Код:
if (strcmp(cmd,"/register", true) == 0)
{
new password[256];
password = strtok(cmdtext,idx);
if(!strlen(password)) return SendClientMessage(playerid, COLOR_GREY," Usa /register (password)");
new query[256],resultline[256];
format(query,sizeof(query),"SELECT * FROM users WHERE username='%s'",Nickname[playerid]);
samp_mysql_query(query);
samp_mysql_store_result();
if(samp_mysql_fetch_row(resultline)) return SendClientMessage(playerid, COLOR_GREY," Nickname giа registrato");
new string[256];
format(string, 256,"INSERT INTO `users` (username,password,kills,deaths,clan,rank,barche,aerei,admin,team,level,rispetto,soldi) VALUES ('%s','%s','0','0','0','0','0','0','0','0','0','0','0')",Nickname[playerid],
password);
samp_mysql_query(string);
return 1;
}
account register on db after server crashed pls help me!
Re: /login crash help me -
ReVo_ - 16.06.2010
register fixed pls help me for login!