Position saving problem - 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: Position saving problem (/showthread.php?tid=296994)
+- 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: Position saving problem (/showthread.php?tid=296994)
Position saving problem - Tanush123 - 13.11.2011
Well when player quits the X Y Z goes to 0 on my database, how can i make the position saves. I used to use a Timer b4 for saving and position saved but now with disconnect it doesnt. I disable the timer because it was creating a big account bug
pawn Код:
if(Logged[playerid] == 1 && spawned[playerid] == 1)
{
PlayerData[playerid][Interior] = GetPlayerInterior(playerid);
GetPlayerPos(playerid,X,Y,Z);
GetPlayerName(playerid,pname,sizeof(pname));
format(query,sizeof(query),"UPDATE accounts SET AdminLevel = %d,Cash = %d,vip = %d,Member = %d,Leader = %d,IsInOrg = %d,IsLaw = %d,IsGang = %d,IsPriv = %d,WantedLevel = %d,MinutesPlayed = %d,HoursPlayed = %d,Level = %d,Cig= %d,Sprunk = %d,Snack = %d,Lighter = %d WHERE Name = '%s'",
PlayerData[playerid][AdminLevel],hCash[playerid],PlayerData[playerid][vip],PlayerData[playerid][Member],PlayerData[playerid][Leader],PlayerData[playerid][IsInOrg],PlayerData[playerid][IsLaw],PlayerData[playerid][IsGang],PlayerData[playerid][IsPriv],GetPlayerWantedLevel(playerid),PlayerData[playerid][MinutesPlayed],PlayerData[playerid][HoursPlayed],GetPlayerScore(playerid),PlayerData[playerid][Cig],PlayerData[playerid][Sprunk],PlayerData[playerid][Snack],PlayerData[playerid][Lighter],pname);
mysql_query(query);
format(query,sizeof(query),"UPDATE accounts SET FightingStyle = %d,Passport = %d,Bag = %d,GunLicense = %d,Job = %d,Pot = %d,Crack = %d,Bank = %d,BankAccount = %d,CarLicense = %d,Fuelcan = %d,Civilskin = %d,MinutesToNextLevel = %d,simcard = %d,phone = %d,phonebook = %d WHERE Name = '%s'",
PlayerData[playerid][FightingStyle],PlayerData[playerid][Passport],PlayerData[playerid][Bag],PlayerData[playerid][GunLicense],PlayerData[playerid][Job],PlayerData[playerid][Pot],PlayerData[playerid][Crack],PlayerData[playerid][Bank],PlayerData[playerid][BankAccount],PlayerData[playerid][CarLicense],PlayerData[playerid][Fuelcan],PlayerData[playerid][Civilskin],PlayerData[playerid][MinutesToNextLevel],PlayerData[playerid][simcard],PlayerData[playerid][phone],PlayerData[playerid][phonebook],pname);
mysql_query(query);
format(query,sizeof(query),"UPDATE accounts SET X = %f,Y = %f,Z = %f,Interior = %d,BoatLicense = %d,Banned = %d,Achievement = %d,vKeys = %d WHERE Name = '%s'",
X,Y,Z,PlayerData[playerid][Interior],PlayerData[playerid][BoatLicense],PlayerData[playerid][Banned],PlayerData[playerid][Achievement],PlayerData[playerid][vKeys],pname);
mysql_query(query);
}
Re: Position saving problem - TheLazySloth - 13.11.2011
new query[600], Float: x, Float: y, Float: z;
Meybe?
Re: Position saving problem - Tanush123 - 13.11.2011
I added Those on top on my gamemode
Re: Position saving problem - Norn - 13.11.2011
Off topic but why are you executing 3 queries instead of a long one?
Re: Position saving problem - BlackWolf120 - 13.11.2011
are u sure ure getting the coordinates the right way before trying to save them with mysql?
Also activate the log function of ur mysql plugin and check the log to see what has been logged.
(helps alot)
Re: Position saving problem - TheLazySloth - 13.11.2011
If you are using BlueG's version of mysql you could
mysql_debug(1);
// Saving Code here.
mysql_debug(0);
and see if it was successfully executed in the debug..txt that shows up in your Server's folder.
Re: Position saving problem - Tanush123 - 13.11.2011
pawn Код:
if(Logged[playerid] == 1 && spawned[playerid] == 1)
{
mysql_debug(0);
PlayerData[playerid][Interior] = GetPlayerInterior(playerid);
GetPlayerPos(playerid,Float:X,Float:Y,Float:Z);
GetPlayerName(playerid,pname,sizeof(pname));
format(query,sizeof(query),"UPDATE accounts SET AdminLevel = %d,Cash = %d,vip = %d,Member = %d,Leader = %d,IsInOrg = %d,IsLaw = %d,IsGang = %d,IsPriv = %d,WantedLevel = %d,MinutesPlayed = %d,HoursPlayed = %d,Level = %d,Cig= %d,Sprunk = %d,Snack = %d,Lighter = %d WHERE Name = '%s'",
PlayerData[playerid][AdminLevel],hCash[playerid],PlayerData[playerid][vip],PlayerData[playerid][Member],PlayerData[playerid][Leader],PlayerData[playerid][IsInOrg],PlayerData[playerid][IsLaw],PlayerData[playerid][IsGang],PlayerData[playerid][IsPriv],GetPlayerWantedLevel(playerid),PlayerData[playerid][MinutesPlayed],PlayerData[playerid][HoursPlayed],GetPlayerScore(playerid),PlayerData[playerid][Cig],PlayerData[playerid][Sprunk],PlayerData[playerid][Snack],PlayerData[playerid][Lighter],pname);
mysql_query(query);
format(query,sizeof(query),"UPDATE accounts SET FightingStyle = %d,Passport = %d,Bag = %d,GunLicense = %d,Job = %d,Pot = %d,Crack = %d,Bank = %d,BankAccount = %d,CarLicense = %d,Fuelcan = %d,Civilskin = %d,MinutesToNextLevel = %d,simcard = %d,phone = %d,phonebook = %d WHERE Name = '%s'",
PlayerData[playerid][FightingStyle],PlayerData[playerid][Passport],PlayerData[playerid][Bag],PlayerData[playerid][GunLicense],PlayerData[playerid][Job],PlayerData[playerid][Pot],PlayerData[playerid][Crack],PlayerData[playerid][Bank],PlayerData[playerid][BankAccount],PlayerData[playerid][CarLicense],PlayerData[playerid][Fuelcan],PlayerData[playerid][Civilskin],PlayerData[playerid][MinutesToNextLevel],PlayerData[playerid][simcard],PlayerData[playerid][phone],PlayerData[playerid][phonebook],pname);
mysql_query(query);
format(query,sizeof(query),"UPDATE accounts SET X = %f,Y = %f,Z = %f,Interior = %d,BoatLicense = %d,Banned = %d,Achievement = %d,vKeys = %d WHERE Name = '%s'",
Float:X,Float:Y,Float:Z,PlayerData[playerid][Interior],PlayerData[playerid][BoatLicense],PlayerData[playerid][Banned],PlayerData[playerid][Achievement],PlayerData[playerid][vKeys],pname);
mysql_query(query);
}
Re: Position saving problem - BlackWolf120 - 13.11.2011
what plugin do u use?
Re: Position saving problem - Tanush123 - 13.11.2011
mysql.so
https://sampforum.blast.hk/showthread.php?tid=56564
i use new query[1000]
Re: Position saving problem - BlackWolf120 - 13.11.2011
its the plugin TheLazySloth mentioned before by BlueG.
Enable the debug mode and take a look at this usefull callback:
pawn Код:
OnQueryError( errorid, error[], resultid, extraid, callback[], query[], connectionHandle )