SA-MP Forums Archive
MySQL UPDATE wont work - 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)
+--- Thread: MySQL UPDATE wont work (/showthread.php?tid=374094)



MySQL UPDATE wont work - marsmarin - 01.09.2012

I tried to make login/reg system in godfather script. Everything works except OnPlayerUpdate function. It wont to change the values in columns.

Код:
public OnPlayerUpdate(playerid)
{
	if(IsPlayerConnected(playerid))
	{
		if(gPlayerLogged[playerid])
		{
			/* new string3[32];
			new playername3[MAX_PLAYER_NAME];
			GetPlayerName(playerid, playername3, sizeof(playername3));
			format(string3, sizeof(string3), "%s.ini", playername3);
			new File: hFile = fopen(string3, io_write);
			if (hFile)
			{
				new var[32];
				format(var, 32, "Key=%s\n", PlayerInfo[playerid][pKey]);fwrite(hFile, var);
				PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
				format(var, 32, "Level=%d\n",PlayerInfo[playerid][pLevel]);fwrite(hFile, var);
				format(var, 32, "AdminLevel=%d\n",PlayerInfo[playerid][pAdmin]);fwrite(hFile, var);
				format(var, 32, "GameMasterLevel=%d\n",PlayerInfo[playerid][pGameMaster]);fwrite(hFile, var);
				format(var, 32, "DonateRank=%d\n",PlayerInfo[playerid][pDonateRank]);fwrite(hFile, var);
				format(var, 32, "UpgradePoints=%d\n",PlayerInfo[playerid][gPupgrade]);fwrite(hFile, var);
				format(var, 32, "ConnectedTime=%d\n",PlayerInfo[playerid][pConnectTime]);fwrite(hFile, var);
				format(var, 32, "Registered=%d\n",PlayerInfo[playerid][pReg]);fwrite(hFile, var);
				format(var, 32, "Sex=%d\n",PlayerInfo[playerid][pSex]);fwrite(hFile, var);
				format(var, 32, "Age=%d\n",PlayerInfo[playerid][pAge]);fwrite(hFile, var);
				format(var, 32, "Origin=%d\n",PlayerInfo[playerid][pOrigin]);fwrite(hFile, var);
				format(var, 32, "CK=%d\n",PlayerInfo[playerid][pCK]);fwrite(hFile, var);
				format(var, 32, "Muted=%d\n",PlayerInfo[playerid][pMuted]);fwrite(hFile, var);
				format(var, 32, "Respect=%d\n",PlayerInfo[playerid][pExp]);fwrite(hFile, var);
				format(var, 32, "Money=%d\n",PlayerInfo[playerid][pCash]);fwrite(hFile, var);
				format(var, 32, "Bank=%d\n",PlayerInfo[playerid][pAccount]);fwrite(hFile, var);
				format(var, 32, "Crimes=%d\n",PlayerInfo[playerid][pCrimes]);fwrite(hFile, var);
				format(var, 32, "Kills=%d\n",PlayerInfo[playerid][pKills]);fwrite(hFile, var);
				format(var, 32, "Deaths=%d\n",PlayerInfo[playerid][pDeaths]);fwrite(hFile, var);
				format(var, 32, "Arrested=%d\n",PlayerInfo[playerid][pArrested]);fwrite(hFile, var);
				format(var, 32, "WantedDeaths=%d\n",PlayerInfo[playerid][pWantedDeaths]);fwrite(hFile, var);
				format(var, 32, "Phonebook=%d\n",PlayerInfo[playerid][pPhoneBook]);fwrite(hFile, var);
				format(var, 32, "Sat=%d\n",PlayerInfo[playerid][pSat]);fwrite(hFile, var);
				format(var, 32, "LottoNr=%d\n",PlayerInfo[playerid][pLottoNr]);fwrite(hFile, var);
				format(var, 32, "Fishes=%d\n",PlayerInfo[playerid][pFishes]);fwrite(hFile, var);
				format(var, 32, "BiggestFish=%d\n",PlayerInfo[playerid][pBiggestFish]);fwrite(hFile, var);
				format(var, 32, "Job=%d\n",PlayerInfo[playerid][pJob]);fwrite(hFile, var);
				format(var, 32, "Paycheck=%d\n",PlayerInfo[playerid][pPayCheck]);fwrite(hFile, var);
				format(var, 32, "HeadValue=%d\n",PlayerInfo[playerid][pHeadValue]);fwrite(hFile, var);
				format(var, 32, "Jailed=%d\n",PlayerInfo[playerid][pJailed]);fwrite(hFile, var);
				format(var, 32, "JailTime=%d\n",PlayerInfo[playerid][pJailTime]);fwrite(hFile, var);
				format(var, 32, "Materials=%d\n",PlayerInfo[playerid][pMats]);fwrite(hFile, var);
				format(var, 32, "Drugs=%d\n",PlayerInfo[playerid][pDrugs]);fwrite(hFile, var);
				format(var, 32, "Leader=%d\n",PlayerInfo[playerid][pLeader]);fwrite(hFile, var);
				format(var, 32, "Member=%d\n",PlayerInfo[playerid][pMember]);fwrite(hFile, var);
				format(var, 32, "FMember=%d\n",PlayerInfo[playerid][pFMember]);fwrite(hFile, var);
				format(var, 32, "Rank=%d\n",PlayerInfo[playerid][pRank]);fwrite(hFile, var);
				format(var, 32, "Char=%d\n",PlayerInfo[playerid][pChar]);fwrite(hFile, var);
				format(var, 32, "ContractTime=%d\n",PlayerInfo[playerid][pContractTime]);fwrite(hFile, var);
				format(var, 32, "DetSkill=%d\n",PlayerInfo[playerid][pDetSkill]);fwrite(hFile, var);
				format(var, 32, "SexSkill=%d\n",PlayerInfo[playerid][pSexSkill]);fwrite(hFile, var);
				format(var, 32, "BoxSkill=%d\n",PlayerInfo[playerid][pBoxSkill]);fwrite(hFile, var);
				format(var, 32, "LawSkill=%d\n",PlayerInfo[playerid][pLawSkill]);fwrite(hFile, var);
				format(var, 32, "MechSkill=%d\n",PlayerInfo[playerid][pMechSkill]);fwrite(hFile, var);
				format(var, 32, "JackSkill=%d\n",PlayerInfo[playerid][pJackSkill]);fwrite(hFile, var);
				format(var, 32, "CarSkill=%d\n",PlayerInfo[playerid][pCarSkill]);fwrite(hFile, var);
				format(var, 32, "NewsSkill=%d\n",PlayerInfo[playerid][pNewsSkill]);fwrite(hFile, var);
				format(var, 32, "DrugsSkill=%d\n",PlayerInfo[playerid][pDrugsSkill]);fwrite(hFile, var);
				format(var, 32, "CookSkill=%d\n",PlayerInfo[playerid][pCookSkill]);fwrite(hFile, var);
				format(var, 32, "FishSkill=%d\n",PlayerInfo[playerid][pFishSkill]);fwrite(hFile, var);
				format(var, 32, "pSHealth=%.1f\n",PlayerInfo[playerid][pSHealth]);fwrite(hFile, var);
	            GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
				format(var, 32, "pHealth=%.1f\n",PlayerInfo[playerid][pHealth]);fwrite(hFile, var);
				format(var, 32, "Int=%d\n",PlayerInfo[playerid][pInt]);fwrite(hFile, var);
				format(var, 32, "Local=%d\n",PlayerInfo[playerid][pLocal]);fwrite(hFile, var);
				format(var, 32, "Team=%d\n",PlayerInfo[playerid][pTeam]);fwrite(hFile, var);
				format(var, 32, "Model=%d\n",PlayerInfo[playerid][pModel]);fwrite(hFile, var);
				format(var, 32, "PhoneNr=%d\n",PlayerInfo[playerid][pPnumber]);fwrite(hFile, var);
				format(var, 32, "House=%d\n",PlayerInfo[playerid][pPhousekey]);fwrite(hFile, var);
				format(var, 32, "Bizz=%d\n",PlayerInfo[playerid][pPbiskey]);fwrite(hFile, var);
				if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
				{
					PlayerInfo[playerid][pPos_x] = 1684.9;
					PlayerInfo[playerid][pPos_y] = -2244.5;
					PlayerInfo[playerid][pPos_z] = 13.5;
				}
				if(Spectate[playerid] != 255)
				{
					PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
					PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
					PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
					PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
					PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
				}
				format(var, 32, "Pos_x=%.1f\n",PlayerInfo[playerid][pPos_x]);fwrite(hFile, var);
				format(var, 32, "Pos_y=%.1f\n",PlayerInfo[playerid][pPos_y]);fwrite(hFile, var);
				format(var, 32, "Pos_z=%.1f\n",PlayerInfo[playerid][pPos_z]);fwrite(hFile, var);
				format(var, 32, "CarLic=%d\n",PlayerInfo[playerid][pCarLic]);fwrite(hFile, var);
                format(var, 32, "FlyLic=%d\n",PlayerInfo[playerid][pFlyLic]);fwrite(hFile, var);
				format(var, 32, "BoatLic=%d\n",PlayerInfo[playerid][pBoatLic]);fwrite(hFile, var);
				format(var, 32, "FishLic=%d\n",PlayerInfo[playerid][pFishLic]);fwrite(hFile, var);
				format(var, 32, "GunLic=%d\n",PlayerInfo[playerid][pGunLic]);fwrite(hFile, var);
				format(var, 32, "Gun1=%d\n",PlayerInfo[playerid][pGun1]);fwrite(hFile, var);
				format(var, 32, "Gun2=%d\n",PlayerInfo[playerid][pGun2]);fwrite(hFile, var);
				format(var, 32, "Gun3=%d\n",PlayerInfo[playerid][pGun3]);fwrite(hFile, var);
				format(var, 32, "Gun4=%d\n",PlayerInfo[playerid][pGun4]);fwrite(hFile, var);
				format(var, 32, "Ammo1=%d\n",PlayerInfo[playerid][pAmmo1]);fwrite(hFile, var);
				format(var, 32, "Ammo2=%d\n",PlayerInfo[playerid][pAmmo2]);fwrite(hFile, var);
				format(var, 32, "Ammo3=%d\n",PlayerInfo[playerid][pAmmo3]);fwrite(hFile, var);
				format(var, 32, "Ammo4=%d\n",PlayerInfo[playerid][pAmmo4]);fwrite(hFile, var);
				format(var, 32, "CarTime=%d\n",PlayerInfo[playerid][pCarTime]);fwrite(hFile, var);
				format(var, 32, "PayDay=%d\n",PlayerInfo[playerid][pPayDay]);fwrite(hFile, var);
				format(var, 32, "PayDayHad=%d\n",PlayerInfo[playerid][pPayDayHad]);fwrite(hFile, var);
				format(var, 32, "CDPlayer=%d\n",PlayerInfo[playerid][pCDPlayer]);fwrite(hFile, var);
				format(var, 32, "Kartica=%d\n",PlayerInfo[playerid][pKartica]);fwrite(hFile, var);
				format(var, 32, "Wins=%d\n",PlayerInfo[playerid][pWins]);fwrite(hFile, var);
				format(var, 32, "Loses=%d\n",PlayerInfo[playerid][pLoses]);fwrite(hFile, var);
				format(var, 32, "AlcoholPerk=%d\n",PlayerInfo[playerid][pAlcoholPerk]);fwrite(hFile, var);
				format(var, 32, "DrugPerk=%d\n",PlayerInfo[playerid][pDrugPerk]);fwrite(hFile, var);
				format(var, 32, "MiserPerk=%d\n",PlayerInfo[playerid][pMiserPerk]);fwrite(hFile, var);
				format(var, 32, "PainPerk=%d\n",PlayerInfo[playerid][pPainPerk]);fwrite(hFile, var);
				format(var, 32, "TraderPerk=%d\n",PlayerInfo[playerid][pTraderPerk]);fwrite(hFile, var);
				format(var, 32, "Tutorial=%d\n",PlayerInfo[playerid][pTut]);fwrite(hFile, var);
				format(var, 32, "Mission=%d\n",PlayerInfo[playerid][pMissionNr]);fwrite(hFile, var);
				format(var, 32, "Warnings=%d\n",PlayerInfo[playerid][pWarns]);fwrite(hFile, var);
				format(var, 32, "Adjustable=%d\n",PlayerInfo[playerid][pAdjustable]);fwrite(hFile, var);
				if(PlayerInfo[playerid][pDonateRank] < 1) { PlayerInfo[playerid][pFuel] = 0; }
				format(var, 32, "Fuel=%d\n",PlayerInfo[playerid][pFuel]);fwrite(hFile, var);
				format(var, 32, "Married=%d\n",PlayerInfo[playerid][pMarried]);fwrite(hFile, var);
				format(var, 32, "MarriedTo=%s\n",PlayerInfo[playerid][pMarriedTo]);fwrite(hFile, var);
				fclose(hFile);
			} */
			new Query2[2048];
			new Query3[2048];
			new Query4[2048];
			new Query5[2048];
			new Query6[2048];
			new Query7[2048];
			if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
			{
				PlayerInfo[playerid][pPos_x] = 1684.9;
				PlayerInfo[playerid][pPos_y] = -2244.5;
				PlayerInfo[playerid][pPos_z] = 13.5;
			}
			if(Spectate[playerid] != 255)
			{
				PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
				PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
				PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
				PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
				PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
			}
			GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
			PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
			new plname[MAX_PLAYERS];
			GetPlayerName(playerid, plname, sizeof(plname));
	mysql_format(gConnectionHandle, Query2, "UPDATE users SET Level='%d', AdminLevel='%d', GameMasterLevel='%d', DonateRank='%d', UpgradePoints='%d', ConnectedTime='%d', Registered='%d', Sex='%d', Age='%d', Origin='%d', CK='%d', Muted='%d', Respect='%d' WHERE Name='%s'", 
	PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pGameMaster], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pCK], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pExp], plname);
    
	mysql_format(gConnectionHandle, Query3, "UPDATE users SET Money='%d', Bank='%d', Crimes='%d', Kills='%d', Deaths='%d', Arrested='%d', WantedDeaths='%d', Phonebook='%d', Sat='%d', LottoNr='%d', Fishes='%d', BiggestFish='%d', Job='%d', Paycheck='%d' WHERE Name='%s'",  
	PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pSat], PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pPayCheck], plname);
	
	mysql_format(gConnectionHandle, Query4, "UPDATE users SET HeadValue='%d', Jailed='%d', JailTime='%d', Materials='%d', Drugs='%d', Leader='%d', Member='%d', FMember='%d', Rank='%d', Char='%d', ContractTime='%d', DetSkill='%d', SexSkill='%d', BoxSkill='%d' WHERE Name='%s'", 
	PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pDrugs], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pMember], PlayerInfo[playerid][pFMember], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar], PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pBoxSkill], plname);
    
	mysql_format(gConnectionHandle, Query5, "UPDATE users SET LawSkill='%d', MechSkill='%d', JackSkill='%d', CarSkill='%d', NewsSkill='%d', DrugsSkill='%d', CookSkill='%d', FishSkill='%d', pSHealth=%.1f WHERE Name=%e WHERE Name=%s", 
	PlayerInfo[playerid][pLawSkill], PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][pCarSkill], PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pSHealth], plname); 
	
	mysql_format(gConnectionHandle, Query6, "UPDATE users SET pHealth=%.1f, Int='%d', Local='%d', Team='%d', Model='%d', PhoneNr='%d', House='%d', Bizz='%d', Pos_x=%.1f, Pos_y=%.1f, Pos_z=%.1f, CarLic='%d', FlyLic='%d', BoatLic='%d', FishLic='%d', GunLic='%d', Gun1='%d', Gun2='%d', Gun3='%d', Gun4='%d', Ammo1='%d' WHERE Name='%s'", 
	PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pLocal], PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pPbiskey], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pFlyLic], 
	PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1], plname);
	
	mysql_format(gConnectionHandle, Query7, "UPDATE users SET Ammo2='%d', Ammo3='%d', Ammo4='%d', CarTime='%d', PayDay='%d', PayDayHad='%d', CDPlayer='%d', Kartica='%d', Wins='%d', Loses='%d', AlcoholPerk='%d', DrugPerk='%d', MiserPerk='%d', PainPerk='%d', TraderPerk='%d', Tutorial='%d', Mission='%d', Warnings='%d', Adjustable='%d', Fuel='%d', Married='%d', MarriedTo='%s' WHERE Name='%s'", 
	PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pKartica], PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk], 
	PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pMissionNr], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pFuel], PlayerInfo[playerid][pMarried], PlayerInfo[playerid][pMarriedTo], plname);
	
			mysql_function_query(gConnectionHandle, Query2, false, "OnQueryFinish", "s", Query2);
			mysql_function_query(gConnectionHandle, Query3, false, "OnQueryFinish", "s", Query3);
			mysql_function_query(gConnectionHandle, Query4, false, "OnQueryFinish", "s", Query4);
			mysql_function_query(gConnectionHandle, Query5, false, "OnQueryFinish", "s", Query5);
			mysql_function_query(gConnectionHandle, Query6, false, "OnQueryFinish", "s", Query6);
			mysql_function_query(gConnectionHandle, Query7, false, "OnQueryFinish", "s", Query7);
		}
	}
	return 1;
}



Re: MySQL UPDATE wont work - doreto - 01.09.2012

Never use OnPlayerUpdate for thing like that use times becose this will kill your server like its did it now and if you sohw as mysql (debug) log that really will help as to find the problem


Re: MySQL UPDATE wont work - marsmarin - 01.09.2012

mysql_log

Код:
[21:41:13] >> mysql_connect(localhost, root, sa-mp, ******) on port 3306
[21:41:13] CMySQLHandler::CMySQLHandler() - constructor called.
[21:41:13] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root"
[21:41:13] CMySQLHandler::Connect() - Connection was successful.
[21:41:13] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[21:41:13]  
[21:41:13]  ** MySQL Debugging enabled (09/01/12)
[21:41:13]  
[21:41:42] >> mysql_store_result( Connection handle: 1 )
[21:41:42] CMySQLHandler::StoreResult() - No data to store.
[21:41:42] >> mysql_format( Connection handle: 1 )
[21:41:42] CMySQLHandler::EscapeString(Marin_Stone); - Escaped 11 characters to Marin_Stone.
[21:41:42] >> mysql_query_callback( Connection handle: 1 )
[21:41:42] >> mysql_num_rows( Connection handle: 1 )
[21:41:42] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[21:41:42] >> mysql_free_result( Connection handle: 1 )
[21:41:42] CMySQLHandler::FreeResult() - The result is already empty.
[21:41:42] Passing query SELECT * FROM `users` WHERE Name = 'Marin_Stone' | s
[21:41:42] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM `users` WHERE Name = 'Marin_Stone')
[21:41:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[21:41:42] OnQueryFinish(s) - Threaded function called.
[21:42:02] >> mysql_format( Connection handle: 1 )
[21:42:02] CMySQLHandler::EscapeString(Marin_Stone); - Escaped 11 characters to Marin_Stone.
[21:42:02] CMySQLHandler::EscapeString(123); - Escaped 3 characters to 123.
[21:42:02] >> mysql_query_callback( Connection handle: 1 )
[21:42:02] CMySQLHandler::ProcessQueryThread() - Reconnection attempt in background thread.
[21:42:02] CMySQLHandler::Connect() - Connection was successful.
[21:42:02] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[21:42:02] Passing query INSERT INTO `users` (`Name`, `Password`) VALUES ('Marin_Stone', '123') | s
[21:42:02] ProcessQueryThread(OnQueryFinish) - Query was successful. (INSERT INTO `users` (`Name`, `Password`) VALUES ('Marin_Stone', '123'))
[21:42:02] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[21:42:02] OnQueryFinish(s) - Threaded function called.
[21:42:04] >> mysql_format( Connection handle: 1 )
[21:42:04] CMySQLHandler::EscapeString(Marin_Stone); - Escaped 11 characters to Marin_Stone.
[21:42:04] CMySQLHandler::EscapeString(123); - Escaped 3 characters to 123.
[21:42:04] >> mysql_query_callback( Connection handle: 1 )
[21:42:04] >> mysql_store_result( Connection handle: 1 )
[21:42:04] CMySQLHandler::StoreResult() - No data to store.
[21:42:04] >> mysql_num_rows( Connection handle: 1 )
[21:42:04] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[21:42:04] >> mysql_free_result( Connection handle: 1 )
[21:42:04] CMySQLHandler::FreeResult() - The result is already empty.
[21:42:04] Passing query SELECT * FROM `users` WHERE Name = 'Marin_Stone' AND Password = '123' | ds
[21:42:04] ProcessQueryThread(LoginPlayer) - Query was successful. (SELECT * FROM `users` WHERE Name = 'Marin_Stone' AND Password = '123')
[21:42:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[21:42:04] LoginPlayer(ds) - Threaded function called.
[21:42:04] >> mysql_store_result( Connection handle: 1 )
[21:42:04] CMySQLHandler::StoreResult() - Result was stored.
[21:42:04] >> mysql_num_rows( Connection handle: 1 )
[21:42:04] CMySQLHandler::NumRows() - Returned 1 row(s)
[21:42:04] >> mysql_retrieve_row( Connection handle: 1 )
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Level") - 1
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("AdminLevel") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("GameMasterLevel") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("DonateRank") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("UpgradePoints") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("ConnectedTime") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Registered") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Sex") - 1
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Age") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Origin") - 1
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("CK") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Muted") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Respect") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Money") - 500
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Bank") - 1000
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Crimes") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Kills") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Deaths") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Arrested") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("WantedDeaths") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Phonebook") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Sat") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("LottoNr") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Fishes") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("BiggestFish") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Job") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Paycheck") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("HeadValue") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Jailed") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("JailTime") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Materials") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Drugs") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Leader") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("FMember") - 255
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Rank") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Char") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("ContractTime") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("DetSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("SexSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("BoxSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("LawSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("MechSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("JackSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("CarSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("NewsSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("DrugsSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("CookSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("FishSkill") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("pSHealth") - 100.0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("pHealth") - 100.0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Int") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Local") - 255
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Team") - 3
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Model") - 264
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("PhoneNr") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("House") - 255
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Bizz") - 255
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Pos_x") - 1684.9
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Pos_y") - -2244.5
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Pos_z") - 13.5
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("CarLic") - 1
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("FlyLic") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("BoatLic") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("FishLic") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("GunLic") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Gun1") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Gun2") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Gun3") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Gun4") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Ammo1") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Ammo2") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Ammo3") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Ammo4") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("CarTime") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("PayDay") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("PayDayHad") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("CDPlayer") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Kartica") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Wins") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Loses") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("AlcoholPerk") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("DrugPerk") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("MiserPerk") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("PainPerk") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("TraderPerk") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Tutorial") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Mission") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Warnings") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Adjustable") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Fuel") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("Married") - 0
[21:42:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:42:04] CMySQLHandler::FetchField("MarriedTo") - No-one
[21:42:04] >> mysql_free_result( Connection handle: 1 )
[21:42:04] CMySQLHandler::FreeResult() - Result was successfully free'd.