lundi 24 mars 2014

SQL: server connection closed

Okay,

/login Write my password

next joind server and close connection

can help me??...:(





((((((((((((((((((((((((((((((((((((((((system)))) )))))))))))))))))))))))))))))))))))))))))))))))))) )

GiveNameSpace(sendername);

//format(string, sizeof(string), "users/%s.ini", PlayerName(playerid));

mysql_real_escape_string(PlayerName(playerid), Escape[2]);

format(string, 128, "SELECT * FROM Accounts WHERE Username = '%s'", Escape[2]);

mysql_query(string);

mysql_store_result();

if(mysql_num_rows() >= 1)

{

format(string, sizeof(string), "Welcome %s!", sendername);

SendClientMessage(playerid,COLOR_WHITE,string);

SendClientMessage(playerid,COLOR_WHITE,"This name is registered, please login into your account /login [password].");

}

else

{

format(string, sizeof(string), "Welcome %s!", sendername);

SendClientMessage(playerid,COLOR_WHITE,string);

format(string, 128, "SELECT * FROM Accounts WHERE Username = '%s'", Escape[2]);

mysql_query(string);

mysql_store_result();

if(mysql_num_rows() >= 1)

{

SendClientMessage(playerid,COLOR_WHITE,"This name is registered, and not yet converted - /login [password]");

return 1;

}

SendClientMessage(playerid,COLOR_WHITE,"This name is not registered, please create an account /register [password].");

}

mysql_free_result();

TogglePlayerSpectatingEx(playerid,1);

PlayerPlaySound(playerid, 1183,-119.9460,23.1096,12.2238);

}

return 1;

}





((((((((((((((DEBUG LOG ))))))))))))



[11:40:11] CMySQLHandler::Query(SELECT AdmName FROM Accounts WHERE Username = 'Erekle_Erekle') - Successfully executed.



[11:40:11] >> mysql_store_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::StoreResult() - Result was stored.



[11:40:11] >> mysql_retrieve_row( Connection handle: 1 )



[11:40:11] >> mysql_fetch_field_row( Connection handle: 1 )



[11:40:11] CMySQLHandler::FetchField("AdmName") -



[11:40:11] >> mysql_free_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::FreeResult() - Result was successfully free'd.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Username); - Escaped 8 characters to Username.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Erekle_Erekle); - Escaped 13 characters to Erekle_Erekle.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Accent); - Escaped 6 characters to Accent.



[11:40:11] >> mysql_query( Connection handle: 1 )



[11:40:11] CMySQLHandler::Query(SELECT Accent FROM Accounts WHERE Username = 'Erekle_Erekle') - Successfully executed.



[11:40:11] >> mysql_store_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::StoreResult() - Result was stored.



[11:40:11] >> mysql_retrieve_row( Connection handle: 1 )



[11:40:11] >> mysql_fetch_field_row( Connection handle: 1 )



[11:40:11] CMySQLHandler::FetchField("Accent") -



[11:40:11] >> mysql_free_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::FreeResult() - Result was successfully free'd.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Erekle_Erekle); - Escaped 13 characters to Erekle_Erekle.



[11:40:11] >> mysql_query( Connection handle: 1 )



[11:40:11] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)



[11:40:11] >> mysql_query( Connection handle: 1 )



[11:40:11] CMySQLHandler::ProcessQueryThread(UPDATE Accounts SET Cash=0,Model=0,Crash=0,Age=0,PosX='50.000000',PosY ='50.000000',PosZ='50.000000',Health='0.000000',Ar mour='0.000000',`Int`=0,World=0,PayDay=0,PayCheck= 41,Account=0,ConnectTime=0,Member=0, Rank=0,Weed=0,Crack=0,Cocaine=0,HouseKey=0,BizKey= 0,CarKey1=0,CarKey2=0,CarKey3=0,Admin=0,Helper=0,B anned=0,DrugTime=0,HouseEnter=0,BizzEnter=0,GunLic =0,DriveLic=0,PhoneNum=0,Job=0,Jailed=0,JailTime=0 WHERE Username = 'Erekle_Erekle') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)



[11:40:11] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: -1)



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Username); - Escaped 8 characters to Username.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Erekle_Erekle); - Escaped 13 characters to Erekle_Erekle.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(Accent); - Escaped 6 characters to Accent.



[11:40:11] >> mysql_real_escape_string( Connection handle: 1 )



[11:40:11] CMySQLHandler::EscapeString(); - Escaped 0 characters to .



[11:40:11] >> mysql_query( Connection handle: 1 )



[11:40:11] CMySQLHandler::Query(UPDATE Accounts SET Accent = '' WHERE Username = 'Erekle_Erekle') - Successfully executed.



[11:40:11] OnQueryFinish(1,"UPDATE Accounts SET Cash=0,Model=0,Crash=0,Age=0,PosX='50.000000',PosY ='50.000000',PosZ='50.000000',Health='0.000000',Ar mour='0.000000',`Int`=0,World=0,PayDay=0,PayCheck= 41,Account=0,ConnectTime=0,Member=0, Rank=0,Weed=0,Crack=0,Cocaine=0,HouseKey=0,BizKey= 0,CarKey1=0,CarKey2=0,CarKey3=0,Admin=0,Helper=0,B anned=0,DrugTime=0,HouseEnter=0,BizzEnter=0,GunLic =0,DriveLic=0,PhoneNum=0,Job=0,Jailed=0,JailTime=0 WHERE Username = 'Erekle_Erekle'") - Called.



[11:40:11] >> mysql_store_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::StoreResult() - No data to store.



[11:40:11] >> mysql_fetch_row_format( Connection handle: 1 )



[11:40:11] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)



[11:40:11] >> mysql_free_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::FreeResult() - The result is already empty.



[11:40:11] CMySQLHandler::ProcessQueryThread(UPDATE Accounts SET Weapon0=0,Weapon1=0,Weapon2=0,Weapon3=0,Weapon4=0, Weapon5=0,Weapon6=0,Weapon7=0,Weapon8=0,Weapon9=0, Weapon10=0,Weapon11=0,Weapon12=0,Ammo0=0,Ammo1=0,A mmo2=0,Ammo3=0,Ammo4=0,Ammo5=0,Ammo6=0,Ammo7=0,Amm o8=0,Ammo9=0,Ammo10=0,Ammo11=0,Ammo12=0,WantedLeve l=0,DonateRank=0,Mask=0,MaskID=0,Cellphone=0,Crime s=0,Arrest=0,Changes=0,Sex=0,Tutorial=0, CarTicket=0 WHERE Username = 'Erekle_Erekle') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)



[11:40:11] OnQueryFinish(1,"UPDATE Accounts SET Weapon0=0,Weapon1=0,Weapon2=0,Weapon3=0,Weapon4=0, Weapon5=0,Weapon6=0,Weapon7=0,Weapon8=0,Weapon9=0, Weapon10=0,Weapon11=0,Weapon12=0,Ammo0=0,Ammo1=0,A mmo2=0,Ammo3=0,Ammo4=0,Ammo5=0,Ammo6=0,Ammo7=0,Amm o8=0,Ammo9=0,Ammo10=0,Ammo11=0,Ammo12=0,WantedLeve l=0,DonateRank=0,Mask=0,MaskID=0,Cellphone=0,Crime s=0,Arrest=0,Changes=0,Sex=0,Tutorial=0, CarTicket=0 WHERE Username = 'Erekle_Erekle'") - Called.



[11:40:11] >> mysql_store_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::StoreResult() - No data to store.



[11:40:11] >> mysql_fetch_row_format( Connection handle: 1 )



[11:40:11] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)



[11:40:11] >> mysql_free_result( Connection handle: 1 )



[11:40:11] CMySQLHandler::FreeResult() - The result is already empty.




Aucun commentaire:

Enregistrer un commentaire