MySQL Query Problem
#1

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
Reply
#2

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;
}
Reply
#3

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'",.
Reply
#4

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

sry kirk my english is very bad, im german
Reply
#6

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)