SQL: server connection closed
#1

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.223;
}
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.
Reply
#2

Have you created your tables?

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


Forum Jump:


Users browsing this thread: 1 Guest(s)