16.06.2010, 09:55
yo,
i make code /login using mysql... if i login server crash
Code
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;
}