15.12.2013, 09:52
Hello my saving system in MySQL have some errors which I don`t know how to fix anyone know?
ERRORS
ERROR lines:
pawn Код:
UpdateAccount(playerid)
{
new Query[710];
printf("IP: %s",pIP[playerid]);
printf("Admin: %d",pInfo[playerid][pAdmin]);
printf("Kills: %d",pInfo[playerid][pKills]);
printf("Deaths: %d",pInfo[playerid][pDeaths]);
printf("Money: %d",GetPlayerMoney(playerid));
printf("Score: %d",GetPlayerScore(playerid));
printf("Vip: %d",pInfo[playerid][pVip]);
printf("CaptureZones: %d",pInfo[playerid][pCaptureZones]);
printf("Ecstasy: %d",pInfo[playerid][pEcstasy]);
printf("Cocaine: %d",pInfo[playerid][pCocaine]);
printf("Heroin: %d",pInfo[playerid][pHeroin]);
printf("Mod Shorter: %d",pMod[playerid][ShorterTimeForCapture]);
format(Query, sizeof(Query),"UPDATE `users` SET \
`IP` = '%s', \
`Admin` = '%d',\
`Kills` = '%d', \
`Deaths` = '%d', \
`Money` = '%d', \
`Score` = '%d', \
`Vip` = '%d', \
`CaptureZones` = '%d', \
`Ecstasy` = '%d', \
`Cocaine` = '%d', \
`Heroin` = '%d', \
`KillingACH` = '%d', \
`CapturingACH` = '%d', \
`CaptureTime` = '%d', \
`SkillM4` = '%d', \
`SkillAK47` = '%d', \
`SkillDesert` = '%d', \
`SkillMP5` = '%d', \
`SkillPistol` = '%d', \
`SkillSniper` = '%d', \
`SkillShotgun` = '%d', \
`SkillSpas` = '%d', \
`SkillSwan` = '%d' \
WHERE `UserName` = '%s'",
pIP[playerid],
pInfo[playerid][pAdmin],
pInfo[playerid][pKills],
pInfo[playerid][pDeaths],
GetPlayerMoney(playerid),
GetPlayerScore(playerid),
pInfo[playerid][pVip],
pInfo[playerid][pCaptureZones],
pInfo[playerid][pEcstasy],
pInfo[playerid][pCocaine],
pInfo[playerid][pHeroin],
pInfo[playerid][pKillingACH],
pInfo[playerid][pCapturingACH],
pMod[playerid][ShorterTimeForCapture],
pInfo[playerid][pSkillM4],
pInfo[playerid][pSkillAK47],
pInfo[playerid][pSkillDesert],
pInfo[playerid][pSkillMP5],
pInfo[playerid][pSkillPistol],
pInfo[playerid][pSkillSniper],
pInfo[playerid][pSkillShotgun],
pInfo[playerid][pSkillSpas],
pInfo[playerid][pSkillSwan],
pName[playerid]);
mysql_query(Query);
return 1;
}
Код:
D:\SA-MP Server Stuff 2\SA-MP Server\gamemodes\battletestv6.pwn(3349) : error 075: input line too long (after substitutions) D:\SA-MP Server Stuff 2\SA-MP Server\gamemodes\battletestv6.pwn(3350) : error 037: invalid string (possibly non-terminated string) D:\SA-MP Server Stuff 2\SA-MP Server\gamemodes\battletestv6.pwn(3350) : error 017: undefined symbol "UPDATE" D:\SA-MP Server Stuff 2\SA-MP Server\gamemodes\battletestv6.pwn(3350) : error 029: invalid expression, assumed zero D:\SA-MP Server Stuff 2\SA-MP Server\gamemodes\battletestv6.pwn(3350) : fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 5 Errors.
pawn Код:
`SkillSpas` = '%d', \
`SkillSwan` = '%d' \
