Query Mysql - Printable Version

Query Mysql - 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: Query Mysql (/showthread.php?tid=298543)

Query Mysql - fabriziobondi - 21.11.2011

Someone can create me a query mysql to save player stats when a player quit the game?
Here u are the line of DB:

PHP код:



mysql_get_field("Money", fetch);

        PlayerAccount[playerid][Money] = strval(fetch);

        mysql_get_field("CurrentHealth", fetch);

        PlayerAccount[playerid][Health] = strval(fetch);

        mysql_get_field("Level", fetch);

        PlayerAccount[playerid][Level] = strval(fetch);

        mysql_get_field("HouseKey", fetch);

        PlayerAccount[playerid][HouseKey] = strval(fetch);

        mysql_get_field("BizKey", fetch);

        PlayerAccount[playerid][BizKey] = strval(fetch);

        mysql_get_field("Cigarettes", fetch);

        PlayerAccount[playerid][Cigarettes] = strval(fetch);

        mysql_get_field("Rope", fetch);

        PlayerAccount[playerid][Rope] = strval(fetch);

        mysql_get_field("HasGlasses", fetch);

        PlayerAccount[playerid][HasGlasses] = strval(fetch);

        mysql_get_field("Skin", fetch);

        PlayerAccount[playerid][Skin] = strval(fetch);

        mysql_get_field("CurrentX", fetch);

        PlayerAccount[playerid][pPos][0] = strval(fetch);

        mysql_get_field("CurrentY", fetch);

        PlayerAccount[playerid][pPos][1] = strval(fetch);

        mysql_get_field("CurrentZ", fetch);

        PlayerAccount[playerid][pPos][2] = strval(fetch);

        mysql_get_field("CurrentInt", fetch);

        PlayerAccount[playerid][CurrentInt] = strval(fetch);

        mysql_get_field("CurrentVW", fetch);

        PlayerAccount[playerid][CurrentVW] = strval(fetch);

        mysql_get_field("ID", fetch);

        PlayerAccount[playerid][ID] = strval(fetch);

        mysql_get_field("HasMask", fetch);

        PlayerAccount[playerid][HasMask] = strval(fetch);

        mysql_get_field("HasHelmet", fetch);

        PlayerAccount[playerid][HasHelmet] = strval(fetch);

        mysql_get_field("PhoneCredit", fetch);

        PlayerAccount[playerid][PhoneCredit] = strval(fetch);

        mysql_get_field("CurrentArmour", fetch);

        AccountData[playerid][pArmour] = strval(fetch);

        mysql_get_field("Sex", fetch);

        PlayerAccount[playerid][psex] = strval(fetch);

        mysql_get_field("Drug", fetch);

        PlayerAccount[playerid][Drug] = strval(fetch);

        mysql_get_field("Materials", fetch);

        PlayerAccount[playerid][Materials] = strval(fetch);

        mysql_get_field("FightStyle", fetch);

        PlayerAccount[playerid][FightStyle] = strval(fetch);

        mysql_get_field("Walk", fetch);

        PlayerAccount[playerid][Walk] = strval(fetch);

        mysql_get_field("Premium", fetch);

        PlayerAccount[playerid][Premium] = strval(fetch);

        mysql_get_field("WalkieTalkie", fetch);

        PlayerAccount[playerid][WalkieTalkie] = strval(fetch);

        mysql_get_field("Phone", fetch);

        PlayerAccount[playerid][Phone] = strval(fetch);

        mysql_get_field("Clan", fetch);

        PlayerAccount[playerid][Clan] = strval(fetch);

        mysql_get_field("ClanLeader", fetch);

        PlayerAccount[playerid][ClanLeader] = strval(fetch);

        mysql_get_field("Faction", fetch);

        PlayerAccount[playerid][Faction] = strval(fetch);

        mysql_get_field("CurrentDuty", fetch);

        PlayerAccount[playerid][CurrentDuty] = strval(fetch);

        mysql_get_field("Rank", fetch);

        PlayerAccount[playerid][Rank] = strval(fetch);

        mysql_get_field("CurrentDutySkin", fetch);

        PlayerAccount[playerid][CurrentDutySkin] = strval(fetch);

        mysql_get_field("Subfaction", fetch);

        PlayerAccount[playerid][Subfaction] = strval(fetch);

        mysql_get_field("Bank", fetch);

        PlayerAccount[playerid][Bank] = strval(fetch);

        mysql_get_field("Prestito", fetch);

        PlayerAccount[playerid][Prestito] = strval(fetch);

        mysql_get_field("Pay", fetch);

        PlayerAccount[playerid][Pay] = strval(fetch);

        mysql_get_field("Jailed", fetch);

        PlayerAccount[playerid][Jailed] = strval(fetch);

        mysql_get_field("JailTime", fetch);

        PlayerAccount[playerid][JailCell] = strval(fetch);

        mysql_get_field("JailCell", fetch);

        PlayerAccount[playerid][JailTime] = strval(fetch);

        mysql_get_field("Exp", fetch);

        PlayerAccount[playerid][Exp] = strval(fetch);

        mysql_get_field("Years", fetch);

        PlayerAccount[playerid][Years] = strval(fetch);

        mysql_get_field("Pills", fetch);

        PlayerAccount[playerid][Pills] = strval(fetch);

        mysql_get_field("TutorialDone", fetch);

        PlayerAccount[playerid][TutorialDone] = strval(fetch);

        mysql_get_field("Admin", fetch);

        PlayerAccount[playerid][AdminLevel] = strval(fetch);

        mysql_get_field("Banned", fetch);

        PlayerAccount[playerid][Banned] = strval(fetch);

        mysql_get_field("GPS", fetch);

        PlayerAccount[playerid][GPS] = strval(fetch);

        mysql_get_field("Clock", fetch);

        PlayerAccount[playerid][Clock] = strval(fetch);

        mysql_get_field("Poste", fetch);

        PlayerAccount[playerid][Poste] = strval(fetch);

        mysql_get_field("Worker", fetch);

        PlayerAccount[playerid][Worker] = strval(fetch);

        mysql_get_field("Capelli", fetch);

        PlayerAccount[playerid][Capelli] = strval(fetch);

        mysql_get_field("Helper", fetch);

        PlayerAccount[playerid][Helper] = strval(fetch);

        mysql_get_field("MotorBikeLic", fetch);

        PlayerAccount[playerid][License][0] = strval(fetch);

        mysql_get_field("CarLic", fetch);

        PlayerAccount[playerid][License][1] = strval(fetch);

        mysql_get_field("TruckLic", fetch);

        PlayerAccount[playerid][License][2] = strval(fetch);

        mysql_get_field("BusLic", fetch);

        PlayerAccount[playerid][License][3] = strval(fetch);

        mysql_get_field("BoatLic", fetch);

        PlayerAccount[playerid][License][4] = strval(fetch);

        mysql_get_field("FlyLic", fetch);

        PlayerAccount[playerid][License][5] = strval(fetch);

        mysql_get_field("Spawned", fetch);

        PlayerAccount[playerid][Spawned] = strval(fetch);

        mysql_get_field("Spawn", fetch);

        PlayerAccount[playerid][Spawn] = strval(fetch);

        mysql_get_field("Activity", fetch);

        PlayerAccount[playerid][Activity] = strval(fetch);

        mysql_get_field("ActivityLeader", fetch);

        PlayerAccount[playerid][ActivityLeader] = strval(fetch);

        mysql_get_field("exgm", fetch);

        PlayerAccount[playerid][exgm] = strval(fetch);

        mysql_get_field("WepLic", fetch);

        PlayerAccount[playerid][License][6] = strval(fetch);

        mysql_get_field("District", fetch);

        PlayerAccount[playerid][District] = strval(fetch);

        mysql_get_field("SubDistrict", fetch);

        PlayerAccount[playerid][SubDistrict] = strval(fetch);

        mysql_get_field("WeaponString", PlayerAccount[playerid][WepString]);

        mysql_get_field("BanDays", PlayerAccount[playerid][BanDays]);

        mysql_get_field("PremDays", PlayerAccount[playerid][PremDays]);

I need to know where I have to put the query that u'll create. Under OnPlayerDisconnect?
I need this query because when a player quit the game and relog, his account are restored. House and business result at the name of the player that bought these but in /stats appear house 999 and the house menu and business menu don't go.
Thanks for your help.

Re: Query Mysql - FarSe. - 21.11.2011

pawn Код:

format(str,sizeof(str),"UPDATE `players` SET `Money=%d,CurrentHealth=%d,Level=%d,HouseKey=%d,BizKey=%d,Cigarettes=%d,Rope=%d,HasGlasses=%d,Skin=%d,CurrentX=%d,CurrentY=%d,",
PlayerAccount[playerid][Money],PlayerAccount[playerid][Health],PlayerAccount[playerid][Level],PlayerAccount[playerid][HouseKey],PlayerAccount[playerid][BizKey],PlayerAccount[playerid][Cigarettes],PlayerAccount[playerid][Rope],PlayerAccount[playerid][HasGlasses],PlayerAccount[playerid][Skin],PlayerAccount[playerid][pPos][0],PlayerAccount[playerid][pPos][1]);

format(str,sizeof(str),"%sCurrentZ=%d,CurrentInt=%d,CurrentVW=%d,ID=%d,HasMask=%d,HasHelmet=%d,PhoneCredit=%d,CurrentArmour=%d,Sex=%d,Drug=%d,Materials=%d,FightStyle=%d,",str,
PlayerAccount[playerid][pPos][2],PlayerAccount[playerid][CurrentInt],PlayerAccount[playerid][CurrentVW],PlayerAccount[playerid][ID],PlayerAccount[playerid][HasMask],PlayerAccount[playerid][HasHelmet],PlayerAccount[playerid][PhoneCredit],AccountData[playerid][pArmour],PlayerAccount[playerid][psex],PlayerAccount[playerid][Drug],PlayerAccount[playerid][Materials],PlayerAccount[playerid][FightStyle]);

format(str,sizeof(str),"%sWalk=%d,Premium=%d,WalkieTalkie=%d,Phone=%d,Clan=%d,ClanLeader=%d,Faction=%d,CurrentDuty=%d,Rank=%d,CurrentDutySkin=%d,Subfaction=%d,",str,
PlayerAccount[playerid][Walk],PlayerAccount[playerid][Premium],PlayerAccount[playerid][WalkieTalkie],PlayerAccount[playerid][Phone],PlayerAccount[playerid][Clan],PlayerAccount[playerid][ClanLeader],PlayerAccount[playerid][Faction],PlayerAccount[playerid][CurrentDuty],PlayerAccount[playerid][Rank],PlayerAccount[playerid][CurrentDutySkin],PlayerAccount[playerid][Subfaction]);

format(str,sizeof(str),"%sBank=%d,Prestito=%d,Pay=%d,Jailed=%d,JailTime=%d,JailCell=%d,Exp=%d,Years=%d,Pills=%d,TutorialDone=%d,Admin=%d,Banned=%d,GPS=%d,",str,
PlayerAccount[playerid][Bank],PlayerAccount[playerid][Prestito],PlayerAccount[playerid][Pay],PlayerAccount[playerid][Jailed],PlayerAccount[playerid][JailCell],PlayerAccount[playerid][JailTime],PlayerAccount[playerid][Exp],PlayerAccount[playerid][Years],PlayerAccount[playerid][Pills],PlayerAccount[playerid][TutorialDone],PlayerAccount[playerid][AdminLevel],PlayerAccount[playerid][Banned],PlayerAccount[playerid][GPS]);

format(str,sizeof(str),"%sClock=%d,Poste=%d,Worker=%d,Capelli=%d,Helper=%d,MotorBikeLic=%d,CarLic=%d,TruckLic=%d,BusLic=%d,BoatLic=%d,FlyLic=%d,Spawned=%d,",str,
PlayerAccount[playerid][Clock],PlayerAccount[playerid][Poste],PlayerAccount[playerid][Worker],PlayerAccount[playerid][Capelli],PlayerAccount[playerid][Helper],PlayerAccount[playerid][License][0],PlayerAccount[playerid][License][1],PlayerAccount[playerid][License][2],PlayerAccount[playerid][License][3],PlayerAccount[playerid][License][4],PlayerAccount[playerid][License][5],PlayerAccount[playerid][Spawned]);

format(str,sizeof(str),"%sSpawn=%d,Activity=%d,ActivityLeader=%d,exgm=%d,WepLic=%d,District=%d,SubDistrict=%d,WeaponString", ='%s',BanDays", ='%s',PremDays='%s'",str,
PlayerAccount[playerid][Spawn],PlayerAccount[playerid][Activity],PlayerAccount[playerid][ActivityLeader],PlayerAccount[playerid][exgm],PlayerAccount[playerid][License][6],PlayerAccount[playerid][District],PlayerAccount[playerid][SubDistrict],PlayerAccount[playerid][WepString],PlayerAccount[playerid][BanDays],PlayerAccount[playerid][PremDays]);
format(str,sizeof(str),"%s WHERE `name`='%s';",str,NAME);

Viva la REGEX.

Re: Query Mysql - fabriziobondi - 21.11.2011

Quote:

Originally Posted by FarSe.

pawn Код:

format(str,sizeof(str),"UPDATE `players` SET `Money=%d,CurrentHealth=%d,Level=%d,HouseKey=%d,BizKey=%d,Cigarettes=%d,Rope=%d,HasGlasses=%d,Skin=%d,CurrentX=%d,CurrentY=%d,",
PlayerAccount[playerid][Money],PlayerAccount[playerid][Health],PlayerAccount[playerid][Level],PlayerAccount[playerid][HouseKey],PlayerAccount[playerid][BizKey],PlayerAccount[playerid][Cigarettes],PlayerAccount[playerid][Rope],PlayerAccount[playerid][HasGlasses],PlayerAccount[playerid][Skin],PlayerAccount[playerid][pPos][0],PlayerAccount[playerid][pPos][1]);

format(str,sizeof(str),"%sCurrentZ=%d,CurrentInt=%d,CurrentVW=%d,ID=%d,HasMask=%d,HasHelmet=%d,PhoneCredit=%d,CurrentArmour=%d,Sex=%d,Drug=%d,Materials=%d,FightStyle=%d,",str,
PlayerAccount[playerid][pPos][2],PlayerAccount[playerid][CurrentInt],PlayerAccount[playerid][CurrentVW],PlayerAccount[playerid][ID],PlayerAccount[playerid][HasMask],PlayerAccount[playerid][HasHelmet],PlayerAccount[playerid][PhoneCredit],AccountData[playerid][pArmour],PlayerAccount[playerid][psex],PlayerAccount[playerid][Drug],PlayerAccount[playerid][Materials],PlayerAccount[playerid][FightStyle]);

format(str,sizeof(str),"%sWalk=%d,Premium=%d,WalkieTalkie=%d,Phone=%d,Clan=%d,ClanLeader=%d,Faction=%d,CurrentDuty=%d,Rank=%d,CurrentDutySkin=%d,Subfaction=%d,",str,
PlayerAccount[playerid][Walk],PlayerAccount[playerid][Premium],PlayerAccount[playerid][WalkieTalkie],PlayerAccount[playerid][Phone],PlayerAccount[playerid][Clan],PlayerAccount[playerid][ClanLeader],PlayerAccount[playerid][Faction],PlayerAccount[playerid][CurrentDuty],PlayerAccount[playerid][Rank],PlayerAccount[playerid][CurrentDutySkin],PlayerAccount[playerid][Subfaction]);

format(str,sizeof(str),"%sBank=%d,Prestito=%d,Pay=%d,Jailed=%d,JailTime=%d,JailCell=%d,Exp=%d,Years=%d,Pills=%d,TutorialDone=%d,Admin=%d,Banned=%d,GPS=%d,",str,
PlayerAccount[playerid][Bank],PlayerAccount[playerid][Prestito],PlayerAccount[playerid][Pay],PlayerAccount[playerid][Jailed],PlayerAccount[playerid][JailCell],PlayerAccount[playerid][JailTime],PlayerAccount[playerid][Exp],PlayerAccount[playerid][Years],PlayerAccount[playerid][Pills],PlayerAccount[playerid][TutorialDone],PlayerAccount[playerid][AdminLevel],PlayerAccount[playerid][Banned],PlayerAccount[playerid][GPS]);

format(str,sizeof(str),"%sClock=%d,Poste=%d,Worker=%d,Capelli=%d,Helper=%d,MotorBikeLic=%d,CarLic=%d,TruckLic=%d,BusLic=%d,BoatLic=%d,FlyLic=%d,Spawned=%d,",str,
PlayerAccount[playerid][Clock],PlayerAccount[playerid][Poste],PlayerAccount[playerid][Worker],PlayerAccount[playerid][Capelli],PlayerAccount[playerid][Helper],PlayerAccount[playerid][License][0],PlayerAccount[playerid][License][1],PlayerAccount[playerid][License][2],PlayerAccount[playerid][License][3],PlayerAccount[playerid][License][4],PlayerAccount[playerid][License][5],PlayerAccount[playerid][Spawned]);

format(str,sizeof(str),"%sSpawn=%d,Activity=%d,ActivityLeader=%d,exgm=%d,WepLic=%d,District=%d,SubDistrict=%d,WeaponString", ='%s',BanDays", ='%s',PremDays='%s'",str,
PlayerAccount[playerid][Spawn],PlayerAccount[playerid][Activity],PlayerAccount[playerid][ActivityLeader],PlayerAccount[playerid][exgm],PlayerAccount[playerid][License][6],PlayerAccount[playerid][District],PlayerAccount[playerid][SubDistrict],PlayerAccount[playerid][WepString],PlayerAccount[playerid][BanDays],PlayerAccount[playerid][PremDays]);
format(str,sizeof(str),"%s WHERE `name`='%s';",str,NAME);

Viva la REGEX.

Sotto OnPlayerDisconnect? Altrimenti, dove?
Under OnPlayerDisconnect? If not, where?

Re: Query Mysql - iJumbo - 21.11.2011

If u need to save players stats is better use Disconnect ... or you can make it update when player do someting like saving ..

Re: Query Mysql - fabriziobondi - 21.11.2011

My account has been restored after the relog.

This two elements was undefined. I added this two new:

Код HTML:

new str[1024];
	   new NAME[MAX_PLAYER_NAME];

Someone know what could be?

Re: Query Mysql - FarSe. - 21.11.2011

OnPlayerDisconnect...
new ....
GetPlayerName(playerid,NAME,25);
format....
mysql_query....
...
...
...
..
....

Re: Query Mysql - fabriziobondi - 21.11.2011

Quote:

Originally Posted by FarSe.

OnPlayerDisconnect...
new ....
GetPlayerName(playerid,NAME,25);
format....
mysql_query....
...
...
...
..
....

PHP код:



public OnPlayerDisconnect(playerid, reason) {

    new str[1024];

    GetPlayerName(playerid,NAME,25);

    format(str,sizeof(str),"UPDATE `players` SET `Money=%d,CurrentHealth=%d,Level=%d,HouseKey=%d,BizKey=%d,Cigarettes=%d,Rope=%d,HasGlasses=%d,Skin=%d,CurrentX=%d,CurrentY=%d,",

    PlayerAccount[playerid][Money],PlayerAccount[playerid][Health],PlayerAccount[playerid][Level],PlayerAccount[playerid][HouseKey],PlayerAccount[playerid][BizKey],PlayerAccount[playerid][Cigarettes],PlayerAccount[playerid][Rope],PlayerAccount[playerid][HasGlasses],PlayerAccount[playerid][Skin],PlayerAccount[playerid][pPos][0],PlayerAccount[playerid][pPos][1]);

    format(str,sizeof(str),"%sCurrentZ=%d,CurrentInt=%d,CurrentVW=%d,ID=%d,HasMask=%d,HasHelmet=%d,PhoneCredit=%d,CurrentArmour=%d,Sex=%d,Drug=%d,Materials=%d,FightStyle=%d,",str,

    PlayerAccount[playerid][pPos][2],PlayerAccount[playerid][CurrentInt],PlayerAccount[playerid][CurrentVW],PlayerAccount[playerid][ID],PlayerAccount[playerid][HasMask],PlayerAccount[playerid][HasHelmet],PlayerAccount[playerid][PhoneCredit],AccountData[playerid][pArmour],PlayerAccount[playerid][psex],PlayerAccount[playerid][Drug],PlayerAccount[playerid][Materials],PlayerAccount[playerid][FightStyle]);

    format(str,sizeof(str),"%sWalk=%d,Premium=%d,WalkieTalkie=%d,Phone=%d,Clan=%d,ClanLeader=%d,Faction=%d,CurrentDuty=%d,Rank=%d,CurrentDutySkin=%d,Subfaction=%d,",str,

    PlayerAccount[playerid][Walk],PlayerAccount[playerid][Premium],PlayerAccount[playerid][WalkieTalkie],PlayerAccount[playerid][Phone],PlayerAccount[playerid][Clan],PlayerAccount[playerid][ClanLeader],PlayerAccount[playerid][Faction],PlayerAccount[playerid][CurrentDuty],PlayerAccount[playerid][Rank],PlayerAccount[playerid][CurrentDutySkin],PlayerAccount[playerid][Subfaction]);

    format(str,sizeof(str),"%sBank=%d,Prestito=%d,Pay=%d,Jailed=%d,JailTime=%d,JailCell=%d,Exp=%d,Years=%d,Pills=%d,TutorialDone=%d,Admin=%d,Banned=%d,GPS=%d,",str,

    PlayerAccount[playerid][Bank],PlayerAccount[playerid][Prestito],PlayerAccount[playerid][Pay],PlayerAccount[playerid][Jailed],PlayerAccount[playerid][JailCell],PlayerAccount[playerid][JailTime],PlayerAccount[playerid][Exp],PlayerAccount[playerid][Years],PlayerAccount[playerid][Pills],PlayerAccount[playerid][TutorialDone],PlayerAccount[playerid][AdminLevel],PlayerAccount[playerid][Banned],PlayerAccount[playerid][GPS]);

    format(str,sizeof(str),"%sClock=%d,Poste=%d,Worker=%d,Capelli=%d,Helper=%d,MotorBikeLic=%d,CarLic=%d,TruckLic=%d,BusLic=%d,BoatLic=%d,FlyLic=%d,Spawned=%d,",str,

    PlayerAccount[playerid][Clock],PlayerAccount[playerid][Poste],PlayerAccount[playerid][Worker],PlayerAccount[playerid][Capelli],PlayerAccount[playerid][Helper],PlayerAccount[playerid][License][0],PlayerAccount[playerid][License][1],PlayerAccount[playerid][License][2],PlayerAccount[playerid][License][3],PlayerAccount[playerid][License][4],PlayerAccount[playerid][License][5],PlayerAccount[playerid][Spawned]);

    format(str,sizeof(str),"%s WHERE `name`='%s';",str,NAME);

Right?

Re: Query Mysql - AndreT - 21.11.2011

Actually, that is VERY bad. The only variables that need updating on player disconnect are the ones being constantly modified (like money, online time, coordinates, health whatever). Most of things like licenses, jail times, bank amounts can be updated in the database ONLY WHEN NECESSARY.

Let me show some pseudocode to perhaps make it more clear...

pawn Код:

// Your current solution
function, where licenses are modified(playerid)
{
    licensevariable[playerid] = ...;
}

public OnPlayerDisconnect(playerid)
{
    query to update all variables (including license variables for example)
}

pawn Код:

// desired and better solution
function, where licenses are modified(playerid)
{
    licensevariable[playerid] = ...;
    query to update the player's license in the database
}

public OnPlayerDisconnect(playerid)
{
    query to update only necessary variables (definitely excluding license variables which have already been set)
}

Not the best way to put it, but I hope you understand!

Re: Query Mysql - fabriziobondi - 21.11.2011

Quote:

Originally Posted by AndreT

Actually, that is VERY bad. The only variables that need updating on player disconnect are the ones being constantly modified (like money, online time, coordinates, health whatever). Most of things like licenses, jail times, bank amounts can be updated in the database ONLY WHEN NECESSARY.

Let me show some pseudocode to perhaps make it more clear...

pawn Код:

// Your current solution
function, where licenses are modified(playerid)
{
    licensevariable[playerid] = ...;
}

public OnPlayerDisconnect(playerid)
{
    query to update all variables (including license variables for example)
}

pawn Код:

// desired and better solution
function, where licenses are modified(playerid)
{
    licensevariable[playerid] = ...;
    query to update the player's license in the database
}

public OnPlayerDisconnect(playerid)
{
    query to update only necessary variables (definitely excluding license variables which have already been set)
}

Not the best way to put it, but I hope you understand!

So how could I put this query correctly under OnPlayerDisconnect?
Can u post me your code using the line that I putted before?

Re: Query Mysql - fabriziobondi - 21.11.2011

Quote:

Originally Posted by fabriziobondi

PHP код:



public OnPlayerDisconnect(playerid, reason) {

    new str[1024];

    GetPlayerName(playerid,NAME,25);

    format(str,sizeof(str),"UPDATE `players` SET `Money=%d,CurrentHealth=%d,Level=%d,HouseKey=%d,BizKey=%d,Cigarettes=%d,Rope=%d,HasGlasses=%d,Skin=%d,CurrentX=%d,CurrentY=%d,",

    PlayerAccount[playerid][Money],PlayerAccount[playerid][Health],PlayerAccount[playerid][Level],PlayerAccount[playerid][HouseKey],PlayerAccount[playerid][BizKey],PlayerAccount[playerid][Cigarettes],PlayerAccount[playerid][Rope],PlayerAccount[playerid][HasGlasses],PlayerAccount[playerid][Skin],PlayerAccount[playerid][pPos][0],PlayerAccount[playerid][pPos][1]);

    format(str,sizeof(str),"%sCurrentZ=%d,CurrentInt=%d,CurrentVW=%d,ID=%d,HasMask=%d,HasHelmet=%d,PhoneCredit=%d,CurrentArmour=%d,Sex=%d,Drug=%d,Materials=%d,FightStyle=%d,",str,

    PlayerAccount[playerid][pPos][2],PlayerAccount[playerid][CurrentInt],PlayerAccount[playerid][CurrentVW],PlayerAccount[playerid][ID],PlayerAccount[playerid][HasMask],PlayerAccount[playerid][HasHelmet],PlayerAccount[playerid][PhoneCredit],AccountData[playerid][pArmour],PlayerAccount[playerid][psex],PlayerAccount[playerid][Drug],PlayerAccount[playerid][Materials],PlayerAccount[playerid][FightStyle]);

    format(str,sizeof(str),"%sWalk=%d,Premium=%d,WalkieTalkie=%d,Phone=%d,Clan=%d,ClanLeader=%d,Faction=%d,CurrentDuty=%d,Rank=%d,CurrentDutySkin=%d,Subfaction=%d,",str,

    PlayerAccount[playerid][Walk],PlayerAccount[playerid][Premium],PlayerAccount[playerid][WalkieTalkie],PlayerAccount[playerid][Phone],PlayerAccount[playerid][Clan],PlayerAccount[playerid][ClanLeader],PlayerAccount[playerid][Faction],PlayerAccount[playerid][CurrentDuty],PlayerAccount[playerid][Rank],PlayerAccount[playerid][CurrentDutySkin],PlayerAccount[playerid][Subfaction]);

    format(str,sizeof(str),"%sBank=%d,Prestito=%d,Pay=%d,Jailed=%d,JailTime=%d,JailCell=%d,Exp=%d,Years=%d,Pills=%d,TutorialDone=%d,Admin=%d,Banned=%d,GPS=%d,",str,

    PlayerAccount[playerid][Bank],PlayerAccount[playerid][Prestito],PlayerAccount[playerid][Pay],PlayerAccount[playerid][Jailed],PlayerAccount[playerid][JailCell],PlayerAccount[playerid][JailTime],PlayerAccount[playerid][Exp],PlayerAccount[playerid][Years],PlayerAccount[playerid][Pills],PlayerAccount[playerid][TutorialDone],PlayerAccount[playerid][AdminLevel],PlayerAccount[playerid][Banned],PlayerAccount[playerid][GPS]);

    format(str,sizeof(str),"%sClock=%d,Poste=%d,Worker=%d,Capelli=%d,Helper=%d,Spawned=%d,",str,

    PlayerAccount[playerid][Clock],PlayerAccount[playerid][Poste],PlayerAccount[playerid][Worker],PlayerAccount[playerid][Capelli],PlayerAccount[playerid][Helper],PlayerAccount[playerid][License][0],PlayerAccount[playerid][License][1],PlayerAccount[playerid][License][2],PlayerAccount[playerid][License][3],PlayerAccount[playerid][License][4],PlayerAccount[playerid][License][5],PlayerAccount[playerid][Spawned]);

    format(str,sizeof(str),"%s WHERE `name`='%s';",str,NAME);

Right?