Hallo, dieser Query Will nicht funktionieren
weiss jemand warum ?
stock SpielerSpeichern(playerid)
{
PlayerInfo[playerid][pSkin] = GetPlayerSkin(playerid);
new Query[1300], Ort[32], Tabelle[50],Query1[500], Query2[500];
format(Tabelle,50,"UPDATE `accounts` SET");
format(Ort,32," WHERE `Name` = '%s'",PlayerInfo[playerid][pName]);
format(Query1, 500, " `Nummer` = '%d',`Ban` = '%d',`BanInfo` = '%s',`Geld` = '%d',`Level` = '%d',`Skin` = '%d',`Respekt` = '%d',`PayDay` = '%d', `Admin` = '%d', `Fraktion` = '%d',`Leader` = '%d', `Rang` = '%d', `Auto-Schein` = '%d', `Mottorad-Schein` = '%d',",
PlayerInfo[playerid][pNummer],
PlayerInfo[playerid][pBan],
PlayerInfo[playerid][pBanInfo],
PlayerInfo[playerid][pGeld],
GetPlayerScore(playerid),
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pRespekt],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pAutoschein],
PlayerInfo[playerid][pMotorradschein]
);
format(Query2, 500," `LKW-Schein` = '%d', `Flug-Schein` = '%d', `Waffen-Schein` = '%d', `Spawn` = '%d', `Job` = '%d', `Perso` = '%d', `haus` = '%d', `Premium` = '%d', `Coins` = '%d', `Bank` = '%d'",
PlayerInfo[playerid][pLKWSchein],
PlayerInfo[playerid][pFlugschein],
PlayerInfo[playerid][pWaffenschein],
PlayerInfo[playerid][pSpawn],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPerso],
PlayerInfo[playerid][pHaus],
PlayerInfo[playerid][pPremium],
PlayerInfo[playerid][pCoins],
PlayerInfo[playerid][pBank]
);
strcat(Query, Tabelle),strcat(Query, Query1), strcat(Query, Query2), strcat(Query, Ort);
mysql_query(Query);
return 1;
}
Ich führe in natürlich auch aus bei OnPlayerDisconnect... aber es wird nichts geändert
