Hi alle zusammen,
ich hab mal wieder ein Problem. Ich kann mir nicht erklären warum mysql_query nicht ausgeführt wird.
Es sieht wie folgt bei mir aus:
Code
stock SavePlayer(playerid)
{
new query[500];
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
new coin;
if(GetPVarInt(playerid,"Eingeloggt") == 1)
{
print("SAVE 1");
format(query,sizeof(query),"UPDATE `accounts` SET `Level` = '%d', `Geld` = '%d', `Kills` = '%d', `Tode` = '%d', `TLevel` = '%d', `Fraktion` = '%d' `Adminlevel` = '%d', `Banned`= '%d' WHERE `Name` = '%s'", GetPlayerScore(playerid),sInfo[playerid][pGeld],sInfo[playerid][pKills],sInfo[playerid][pTode],sInfo[playerid][pTLevel],sInfo[playerid][pFraktion],sInfo[playerid][pAdminlevel],sInfo[playerid][pBanned],ShowPlayerName(playerid));
printf("%s",query);
coin = mysql_query(query);
if(coin){
print("SAVE");
}else{
print("NOT SAVE");
}
print("SAVE 2");
}
}
return 1;
}
Log:
Code
Console input: gmx
[13:22:50] <-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!
[13:22:50]
----------------------------------
[13:22:50] Blank Gamemode by your name here
[13:22:50] ----------------------------------
[13:22:50] Number of vehicle models: 14
[13:23:09] [connection] 127.0.0.1:50725 requests connection cookie.
[13:23:10] [connection] incoming connection: 127.0.0.1:50725 id: 0
[13:23:10] [join] Natsu has joined the server (0:127.0.0.1)
[13:23:13] 54
[13:23:16] sscanf warning: Strings without a length are deprecated, please add a destination size.
[13:23:16] Es wurde ein neuer Logeintrag bestätigt
[13:23:16] SAVE 1
[13:23:16] UPDATE `accounts` SET `Level` = '0', `Geld` = '0', `Kills` = '0', `Tode` = '0', `TLevel` = '0', `Fraktion` = '0' `Adminlevel` = '6', `Banned`= '1' WHERE `Name` = 'Natsu'
[13:23:16] NOT SAVE
[13:23:16] SAVE 2
[13:23:16] SAVE 1
[13:23:16] UPDATE `accounts` SET `Level` = '0', `Geld` = '0', `Kills` = '0', `Tode` = '0', `TLevel` = '0', `Fraktion` = '0' `Adminlevel` = '6', `Banned`= '1' WHERE `Name` = 'Natsu'
[13:23:16] NOT SAVE
[13:23:16] SAVE 2
[13:23:16] [part] Natsu has left the server (0:2)Hoffe da kann jemand helfen 
