03.05.2010, 18:45
Quote:
Originally Posted by HighDarren (DarrenReeder)
It is still crashing
![]() Код:
public onPlayerLogin(playerid, password[]){ new playerName[MAX_PLAYER_NAME]; new result[258]; new sqlPlayerName[258]; new pass[258]; new sqlPass[258]; // official pass new sqlPassword[258]; // password enterd GetPlayerName(playerid,playerName,sizeof(playerName)); //Get Player Name samp_mysql_real_escape_string(playerName, sqlPlayerName); //String for samp_mysql format(result,sizeof(result),"SELECT * FROM accounts WHERE user='%s'",sqlPlayerName); // Format my query samp_mysql_query(result); samp_mysql_store_result(); samp_mysql_get_field("pass",pass); samp_mysql_real_escape_string(pass, sqlPass); //String for pass samp_mysql_real_escape_string(password, sqlPassword); //String for pass enterd if(strcmp(sqlPassword,sqlPass,true) == 0){ PlayerLogged[playerid] = 1; SendClientMessage(playerid,COLOR_GREEN,"**You have successfully Logged in!!"); //----------==========Load accoutn info==========---------- new LoadingString[128]; samp_mysql_get_field("ID",LoadingString); //ID PlayerStats[playerid][pId] = strval(LoadingString); samp_mysql_get_field("user",PlayerStats[playerid][pUser]); //Username samp_mysql_get_field("pass",PlayerStats[playerid][pPass]); //Password samp_mysql_get_field("admin", LoadingString); //Admin PlayerStats[playerid][pAdmin] = strval(LoadingString); samp_mysql_get_field("kills", LoadingString); //Kills PlayerStats[playerid][pKills] = strval(LoadingString); samp_mysql_get_field("deaths", LoadingString); //Deaths PlayerStats[playerid][pDeaths] = strval(LoadingString); samp_mysql_get_field("money", LoadingString); //Money PlayerStats[playerid][pMoney] = strval(LoadingString); samp_mysql_get_field("rank", LoadingString); //rank PlayerStats[playerid][pRank] = strval(LoadingString); samp_mysql_get_field("exp", LoadingString); //exp PlayerStats[playerid][pExp] = strval(LoadingString); return 1; } SendClientMessage(playerid,COLOR_RED,"**Sorry, that password is incorrect!!"); return 1; } |