Hallo,
ich habe mir ein paar Thema angeschaut die das Gleiche Problem hatten jedoch haben sie mir nicht wirklich geholfen
hier ist mein Code
stock mysql_PlayerAccountSave(playerid)
{
print("mysql_PlayerAccountSave");
new str1[135], str2[150], str3[145], str4[140], str5[135], str6[105], query[810], escapedName[20];
mysql_real_escape_string(PlayerName(playerid), escapedName);
format(str1, sizeof(str1), "UPDATE `db_accounts` SET `Level` = '%i', `Experience` = '%i', `Health` = '%.2f', `Armour` = '%.2f', `Money` = '%i'", pInfo[playerid][Level], pInfo[playerid][Experience], pInfo[playerid][Health], pInfo[playerid][Armour], pInfo[playerid][Money]);
format(str2, sizeof(str2), ", `Kills` = '%i', `Deaths` = '%i', `KontoCard` = '%i', `VehicleSlot` = '%i', `MaxVehicles` = '%i', `Warnings` = '%i', `Banns` = '%i'", pInfo[playerid][Kills], pInfo[playerid][Deaths], pInfo[playerid][KontoCard], pInfo[playerid][VehicleSlot], pInfo[playerid][MaxVehicles], pInfo[playerid][Warnings], pInfo[playerid][Banns]);
format(str3, sizeof(str3), ", `Hunger` = '%i', `Thirst` = '%i', `Desire` = '%i', `PremiumTime` = '%i', `PremiumPoints` = '%i', `AdminRank` = '%i', `SkinID` = '%i'", pInfo[playerid][Hunger], pInfo[playerid][Thirst], pInfo[playerid][Desire], pInfo[playerid][PremiumTime], pInfo[playerid][PremiumPoints], pInfo[playerid][AdminRank], pInfo[playerid][SkinID]);
format(str4, sizeof(str4), ", `PaydayTime` = '%i', `Job` = '%i', `Faction` = '%i', `FactionSkinID` = '%i', `Wanteds` = '%i', `Hours` = '%i', `Minutes` = '%i'", pInfo[playerid][PaydayTime], pInfo[playerid][Job], pInfo[playerid][Faction], pInfo[playerid][FactionSkinID], pInfo[playerid][Wanteds], pInfo[playerid][Hours], pInfo[playerid][Minutes]);
format(str5, sizeof(str5), ", `BikeLicense` = '%i', `BoatLicense` = '%i', `CarLicense` = '%i', `ChopperLicense` = '%i', `FishingLicense` = '%i', `PlaneLicense` = '%i', `TruckLicense` = '%i'", pInfo[playerid][BikeLicense], pInfo[playerid][BoatLicense], pInfo[playerid][CarLicense], pInfo[playerid][ChopperLicense], pInfo[playerid][FishingLicense], pInfo[playerid][PlaneLicense], pInfo[playerid][TruckLicense]);
format(str6, sizeof(str6), ", `TollLicense` = '%i', `WeaponLicense` = '%i' WHERE `pName` = '%s'", pInfo[playerid][TollLicense], pInfo[playerid][WeaponLicense], escapedName);
format(query, sizeof(query), "%s%s%s%s%s%s", str1, str2, str3, str4, str5, str6);
mysql_function_query(MySQLHandle, query, false, "", "", "");
DeletePVar(playerid, "Login");
return 1;
}
und hier der dazugehörige Error
[15:21:11] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `TollLicense` = '0', `WeaponLicense` = '0' WHERE `pName` = 'Sam'' at line 1
pls help.
mfg tdXkiller