Login

Pasa · 15.12.2013, 10:03

Quote:

Originally Posted by Sanady

Hello my saving system in MySQL have some errors which I don`t know how to fix anyone know?

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;
}

ERRORS

Код:

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.

ERROR lines:

pawn Код:

`SkillSpas` = '%d', \
    `SkillSwan` = '%d' \

At the start with mysql i had the same problem (to many data in one string)

Try this:

Код:

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, 450, "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',",
    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]);

	format(Query, sizeof(Query), "%s `CaptureTime` = '%d', `SkillM4` = '%d', `SkillAK47` = '%d', `SkillDesert` = '%d', `SkillMP5` = '%d', `SkillPistol` = '%d', `SkillSniper` = '%d', `SkillShotgun` = '%d', `SkillSpas` = '%d', `SkillSwan` = '%d' WHERE `UserName` = '%s'",
	Query, 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]);
	/*A made the same thing but i puted the string in 2 parts*/
    mysql_query(Query);
    return 1;
}

Login
Username:
Password:	Lost Password?
	Remember me