Im auftrag von einem Freund:
Undzwar habe ich ein Mysql query Problem
Fehlermeldung:
mysql_query failed: 1064
[15:14:48] QueryInfo: UPDATE `users` SET `WantedDeaths`='0', `NewsSkill`='0', `DrugsSkill`='0', `CookSkill`='0', `FishSkill`='0', `pSHealth`='100.0', `PhoneNr`='676384', `House`='-1', `Biz`='-1', `CarLic`='0', `FlyLic`='0', `BoatLic`='0', `FishLic`='0', `GunLic`='0', WHERE `Name`='peter'
Pawn Script:
format(endstring, sizeof(endstring), "UPDATE `users` SET ");
format(var, sizeof(var), "`WantedDeaths`='%d', ", PlayerInfo[playerid][pWantedDeaths]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`NewsSkill`='%d', ", PlayerInfo[playerid][pNewsSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`DrugsSkill`='%d', ", PlayerInfo[playerid][pDrugsSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CookSkill`='%d', ", PlayerInfo[playerid][pCookSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FishSkill`='%d', ", PlayerInfo[playerid][pFishSkill]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`pSHealth`='%.1f', ", PlayerInfo[playerid][pSHealth]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`PhoneNr`='%d', ", PlayerInfo[playerid][pNummer]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`House`='%d', ", PlayerInfo[playerid][pPhousekey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`Biz`='%d', ", PlayerInfo[playerid][pBizKey]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`CarLic`='%d', ", PlayerInfo[playerid][pCarLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FlyLic`='%d', ", PlayerInfo[playerid][pFlyLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`BoatLic`='%d', ", PlayerInfo[playerid][pBoatLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`FishLic`='%d', ", PlayerInfo[playerid][pFishLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), "`GunLic`='%d', ", PlayerInfo[playerid][pGunLic]);
strcat(endstring, var, sizeof(endstring));
format(var, sizeof(var), " WHERE `Name`='%s'", playername);
strcat(endstring, var, sizeof(endstring));
self_mysql_query(endstring);
sql datei:
`WantedDeaths` int(11) NOT NULL DEFAULT '0',
`NewsSkill` int(11) NOT NULL DEFAULT '0',
`DrugsSkill` int(11) NOT NULL DEFAULT '0',
`CookSkill` int(11) NOT NULL DEFAULT '0',
`FishSkill` int(11) NOT NULL DEFAULT '0',
`pSHealth` float NOT NULL DEFAULT '0',
`PhoneNr` int(11) NOT NULL DEFAULT '0',
`House` int(11) NOT NULL DEFAULT '0',
`Biz` int(11) NOT NULL DEFAULT '0',
`CarLic` int(11) NOT NULL DEFAULT '0',
`FlyLic` int(11) NOT NULL DEFAULT '0',
`BoatLic` int(11) NOT NULL DEFAULT '0',
`FishLic` int(11) NOT NULL DEFAULT '0',
`GunLic` int(11) NOT NULL DEFAULT '0',