Morgen zusammen
Ich habe ein Problem gerade erkannt.
Undzwar habe ich das Problem, das beim Speichern die Werte in der Tabelle falsch stehen
Ich habe mir den Query mal angeschaut und da stimmte alles
Gut als in die Tabelle reingeschaut habe, sind mir 2 Werte ins Auge gefallen die garnicht stimmen sollten.
Bei mir wird der Jobvertrag aufeinmal zu den Helm eintrag verschoben
Also der Query sagt das: Helm = 0, Jobvertrag = -1
In der Tabelle steht dann das aber
Helm = -1, Jobvertrag = -1
Ich weiß nicht wiso der das macht.
Hier ist mal der Code von den saveplayer
stock SavePlayer(playerid)
{
new query[1000];
mysql_real_escape_string(PlayerInfo[playerid][BanGrund], PlayerInfo[playerid][BanGrund]);
mysql_real_escape_string(PlayerInfo[playerid][BanAdmin], PlayerInfo[playerid][BanAdmin]);
mysql_real_escape_string(PlayerInfo[playerid][IP], PlayerInfo[playerid][IP]);
mysql_real_escape_string(PlayerInfo[playerid][Name], PlayerInfo[playerid][Name]);
format(query, 1000, "UPDATE `player` SET `Admin` = '%d', `Job` = '%d', `Team` = '%d', `Cash` = '%d', `Skin` = '%d', `Level` = '%d', `Respekt` = '%d', `PayDay` = '%d', `PayDayTog` = '%d', `Rank` = '%d', `Leader` = '%d', `Nummer` = '%d', \
`Ban` = '%d', `BanGrund` = '%s', `BanAdmin` = '%s', `IP` = '%s', `SaveBan` = '%d', `Helm` = '%d', `Jobvertrag` = '%d', `Star` = '%d', `VIP` = '%d', `Jailtime` = '%d', ",
PlayerInfo[playerid][Admin],PlayerInfo[playerid][Job],PlayerInfo[playerid][Team],GetPlayerMoney(playerid),PlayerInfo[playerid][Skin],PlayerInfo[playerid][Level],PlayerInfo[playerid][Respekt],PlayerInfo[playerid][PayDay],PlayerInfo[playerid][PayDayTog],PlayerInfo[playerid][Rank],
PlayerInfo[playerid][Leader],PlayerInfo[playerid][Nummer],PlayerInfo[playerid][Banned],PlayerInfo[playerid][BanGrund],PlayerInfo[playerid][BanAdmin],PlayerInfo[playerid][IP],PlayerInfo[playerid][Safeban],PlayerInfo[playerid][Helm],
PlayerInfo[playerid][Jobvertrag],PlayerInfo[playerid][Star],PlayerInfo[playerid][Igvip],PlayerInfo[playerid][Jailtime]);
format(query, 1000, "%s `Carlic` = '%d',`Lkwlic` = '%d',`Bikelic` = '%d',`Helilic` = '%d',`Flylic` = '%d',`Bootlic` = '%d',`SpawnChange` = '%d',`SpawnHaus` = '%d',`Bank` = '%d',`president` = '%d',`Wanted` = '%d',",query,
PlayerInfo[playerid][Carlic],PlayerInfo[playerid][Lkwlic],PlayerInfo[playerid][Bikelic],PlayerInfo[playerid][Helilic],PlayerInfo[playerid][Flylic],PlayerInfo[playerid][Bootlic],
PlayerInfo[playerid][SpawnChange],PlayerInfo[playerid][SpawnHaus],PlayerInfo[playerid][Bank],PlayerInfo[playerid][President],GetPlayerWantedLevel(playerid));
format(query, 1000, "%s `CarPoints` = '%d',`BikePoints` = '%d',`LKWPoints` = '%d',`FlyPoints` = '%d',`HeliPoints` = '%d',`BootPoints` = '%d',`Drogen` = '%d',`Prison`='%d' WHERE `Name` = '%s' AND `id` = '%d'",query,
PlayerInfo[playerid][CarPoints],PlayerInfo[playerid][BikePoints],PlayerInfo[playerid][LKWPoints],PlayerInfo[playerid][FlyPoints],PlayerInfo[playerid][HeliPoints],PlayerInfo[playerid][BootPoints],PlayerInfo[playerid][pDrogen],PlayerInfo[playerid][pPrison],
PlayerInfo[playerid][Name],PlayerInfo[playerid][Userid]);
mysql_query(query, (-1), (0), SQL);
for(new s = 0; s < 3; s++)
{
if(PlayerCar[playerid][s]!=0)
SavePlayerCar(playerid,s);
}
return 1;
}
Ich hoffe, das einer eine Idee dazu hat
