MySQL Query Problem - Printable Version

MySQL Query 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: MySQL Query Problem (/showthread.php?tid=302000)

MySQL Query Problem - xMichaelx - 06.12.2011

Hey,

I am currently using MySQL thanks to "RealCop228" and currently using "SaveAccount(playerid);" However i get loads of errors and warnings when i try to compile.

pawn Код:

stock SaveAccount(playerid)
{
    new szQuery[2000];
//  PlayerInfo[playerid][pArmour] = GetPlayerArmour(playerid);
//  PlayerInfo[playerid][pHealth] = GetPlayerHealth(playerid);
    PlayerInfo[playerid][pScore] = GetPlayerScore(playerid);
    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
    PlayerInfo[playerid][pWantedLevel] = GetPlayerWantedLevel(playerid);
    format(szQuery, sizeof(szQuery), "UPDATE `Accounts` SET `Admin Level`='%d', `Donator`='%d', `Cheater`='%d', `Banned`='%d', `Muted`='%d', `TimesRobbed`='%d', `Robbed`='%d', `WantedLevelsGained`='%d',`WantedLevel`='%d',`Kills`='%d',`Deaths`='%d',`Score`='%d', `Cash`='%d', `Armour`='%d', `Health`='%d', `Jailed`='%d', `Prisioned`='%d', `LastOnline`='%d', `TimeOnline`='%d'"
    PlayerInfo[playerid][pAdminLevel],PlayerInfo[playerid][pDonator],PlayerInfo[playerid][pCheater],PlayerInfo[playerid][pBanned],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pTimesRobbed],PlayerInfo[playerid][pRobbed],PlayerInfo[playerid][pWantedLevelsGained],PlayerInfo[playerid][pWantedLevel],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pScore],
    PlayerInfo[playerid][pCash],PlayerInfo[playerid][pArmour],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pPrisioned],PlayerInfo[playerid][pLastOn],PlayerInfo[playerid][pTimeOnline]);
    mysql_query(szQuery, qDefault);
    return 1;
}

Код:

C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(153 -- 154) : error 001: expected token: ",", but found "-identifier-"
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154 -- 155) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154 -- 155) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154 -- 155) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154 -- 155) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154 -- 155) : warning 215: expression has no effect
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(154 -- 155) : error 017: undefined symbol "pLastOn"
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(155) : error 029: invalid expression, assumed zero
C:\Users\Admin\Desktop\SAMP\Los Santos Cops And Robbers 0.3d\gamemodes\Final_Incorporated.pwn(155) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


4 Errors.

How could i fix this Rep+ XD

AW: MySQL Query Problem - Sorato - 06.12.2011

Hey,

Try that:

Код:

stock SaveAccount(playerid)
{
    new szQuery[2000];
//  PlayerInfo[playerid][pArmour] = GetPlayerArmour(playerid);
//  PlayerInfo[playerid][pHealth] = GetPlayerHealth(playerid);
    PlayerInfo[playerid][pScore] = GetPlayerScore(playerid);
    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
    PlayerInfo[playerid][pWantedLevel] = GetPlayerWantedLevel(playerid);
    format(szQuery, sizeof(szQuery), "UPDATE `Accounts` SET `Admin Level`='%d', `Donator`='%d', `Cheater`='%d', `Banned`='%d', `Muted`='%d', `TimesRobbed`='%d', `Robbed`='%d', `WantedLevelsGained`='%d',`WantedLevel`='%d',`Kills`='%d',`Deaths`='%d',`Score`='%d', `Cash`='%d', `Armour`='%d', `Health`='%d', `Jailed`='%d', `Prisioned`='%d', `LastOnline`='%d', `TimeOnline`='%d'",
    PlayerInfo[playerid][pAdminLevel],PlayerInfo[playerid][pDonator],PlayerInfo[playerid][pCheater],PlayerInfo[playerid][pBanned],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pTimesRobbed],PlayerInfo[playerid][pRobbed],PlayerInfo[playerid][pWantedLevelsGained],PlayerInfo[playerid][pWantedLevel],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pScore],
    PlayerInfo[playerid][pCash],PlayerInfo[playerid][pArmour],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pPrisioned],PlayerInfo[playerid][pLastOn],PlayerInfo[playerid][pTimeOnline]);
    mysql_query(szQuery, qDefault);
    return 1;
}

Respuesta: AW: MySQL Query Problem - kirk - 06.12.2011

Quote:

Originally Posted by Sorato

Hey,

Try that:

Код:

stock SaveAccount(playerid)
{
    new szQuery[2000];
//  PlayerInfo[playerid][pArmour] = GetPlayerArmour(playerid);
//  PlayerInfo[playerid][pHealth] = GetPlayerHealth(playerid);
    PlayerInfo[playerid][pScore] = GetPlayerScore(playerid);
    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
    PlayerInfo[playerid][pWantedLevel] = GetPlayerWantedLevel(playerid);
    format(szQuery, sizeof(szQuery), "UPDATE `Accounts` SET `Admin Level`='%d', `Donator`='%d', `Cheater`='%d', `Banned`='%d', `Muted`='%d', `TimesRobbed`='%d', `Robbed`='%d', `WantedLevelsGained`='%d',`WantedLevel`='%d',`Kills`='%d',`Deaths`='%d',`Score`='%d', `Cash`='%d', `Armour`='%d', `Health`='%d', `Jailed`='%d', `Prisioned`='%d', `LastOnline`='%d', `TimeOnline`='%d'",
    PlayerInfo[playerid][pAdminLevel],PlayerInfo[playerid][pDonator],PlayerInfo[playerid][pCheater],PlayerInfo[playerid][pBanned],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pTimesRobbed],PlayerInfo[playerid][pRobbed],PlayerInfo[playerid][pWantedLevelsGained],PlayerInfo[playerid][pWantedLevel],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pScore],
    PlayerInfo[playerid][pCash],PlayerInfo[playerid][pArmour],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pPrisioned],PlayerInfo[playerid][pLastOn],PlayerInfo[playerid][pTimeOnline]);
    mysql_query(szQuery, qDefault);
    return 1;
}

Explain him whats wrong.

Anyways you are missing a " , " here `TimeOnline`='%d'",.

Re: MySQL Query Problem - xMichaelx - 06.12.2011

EDIT: Okay, Thanks. Rep+ For you both xD

AW: MySQL Query Problem - Sorato - 06.12.2011

sry kirk my english is very bad, im german

Respuesta: AW: MySQL Query Problem - kirk - 07.12.2011

Quote:

Originally Posted by Sorato

sry kirk my english is very bad, im german

Uh no dont worry i didnt mean to be rude, sorry for going off topic, your reply was helpful mine was a little addition.