Mehrere Errors beim Wechseln von Dini auf Mysql

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hi,
    ich habe mehrere Errors, vllt kann mir ja jemand helfen :)
    Die Errors kamen beim wechseln von Dini auf Mysql.

    stock SpielerSpeichern(playerid)
    {
    if(GetPVarInt(playerid,"loggedin")==1)
    {
    new name[31],
    Float:health,
    query[100];
    GetPlayerHealth(playerid,health);
    GetPlayerName(playerid,name,31);
    format(query,sizeof(query)," UPDATE `spieler` SET `Level` = '%d', `Geld` = '%d', `Leben` = '%f', `Adminlevel` = '%d', `Fraktion` = '%d', `Fraktionslevel` = '%d', `Warnungen` = '%d', `Baned` = '%d', `timeban` = '%d', `Skin` = '%d', `Job` = '%d',`Führerschein` = '%d', `Fahrpunkte` = '%d', `Bootschein` = '%d', `Flugschein` = '%d', `Perso` = '%d', `Duty` = '%d', `AuftragMoney` = '%d', `Wanteds` = '%d', `lspdschein` = '%d', `PayTime` = '%d', `Tutorial` = '%d', `Premium` = '%d', `Knast` = '%d', `Knastzeit` = '%d', `Lottozahl` = '%d', `Gang` = '%s', `Gangrang` = '%d' WHERE `Name` = '%s'",GetPlayerScore(playerid),GetPlayerMoney(playerid),health,GetPVarInt(playerid,"Adminlevel"),GetPVarInt(playerid,"Fraktion"),GetPVarInt(playerid,"Fraktionslevel"),GetPVarInt(playerid,"Warnungen"),GetPVarInt(playerid,"Baned"),GetPVarInt(playerid,"timeban"),GetPlayerSkin(playerid),GetPVarInt(playerid,"Job"),GetPVarInt(playerid,"Führerschein"),GetPVarInt(playerid,"Fahrpunkte"),GetPVarInt(playerid,"Bootschein"),GetPVarInt(playerid,"Flugschein"),GetPVarInt(playerid,"Perso"),GetPVarInt(playerid,"Duty"),GetPVarInt(playerid,"AuftragMoney"),GetPVarInt(playerid,"Wanteds"),GetPVarInt(playerid,"lspdschein"),GetPVarInt(playerid,"PayTime"),GetPVarInt(playerid,"Tutorial"),GetPVarInt(playerid,"Premium"),GetPVarInt(playerid,"Knast"),GetPVarInt(playerid,"Knastzeit"),GetPVarInt(playerid,"Lottozahl"),gangname,GetPVarInt(playerid,"Gangrang"),name);
    mysql_query(query);
    }
    return 1;
    }

    Errors:

    ***(9) : error 075: input line too long (after substitutions)
    ***(10) : error 037: invalid string (possibly non-terminated string)
    ***(10) : error 017: undefined symbol "UPDATE"
    ***(10) : error 029: invalid expression, assumed zero
    ***(10) : fatal error 107: too many error messages on one line

  • Hey,
    Deine Zeile
    format(query,sizeof(query)," UPDATE `spieler` SET `Level` = '%d', `Geld` = '%d', `Leben` = '%f', `Adminlevel` = '%d', `Fraktion` = '%d', `Fraktionslevel` = '%d', `Warnungen` = '%d', `Baned` = '%d', `timeban` = '%d', `Skin` = '%d', `Job` = '%d',`Führerschein` = '%d', `Fahrpunkte` = '%d', `Bootschein` = '%d', `Flugschein` = '%d', `Perso` = '%d', `Duty` = '%d', `AuftragMoney` = '%d', `Wanteds` = '%d', `lspdschein` = '%d', `PayTime` = '%d', `Tutorial` = '%d', `Premium` = '%d', `Knast` = '%d', `Knastzeit` = '%d', `Lottozahl` = '%d', `Gang` = '%s', `Gangrang` = '%d' WHERE `Name` = '%s'",GetPlayerScore(playerid),GetPlayerMoney(playerid),health,GetPVarInt(playerid,"Adminlevel"),GetPVarInt(playerid,"Fraktion"),GetPVarInt(playerid,"Fraktionslevel"),GetPVarInt(playerid,"Warnungen"),GetPVarInt(playerid,"Baned"),GetPVarInt(playerid,"timeban"),GetPlayerSkin(playerid),GetPVarInt(playerid,"Job"),GetPVarInt(playerid,"Führerschein"),GetPVarInt(playerid,"Fahrpunkte"),GetPVarInt(playerid,"Bootschein"),GetPVarInt(playerid,"Flugschein"),GetPVarInt(playerid,"Perso"),GetPVarInt(playerid,"Duty"),GetPVarInt(playerid,"AuftragMoney"),GetPVarInt(playerid,"Wanteds"),GetPVarInt(playerid,"lspdschein"),GetPVarInt(playerid,"PayTime"),GetPVarInt(playerid,"Tutorial"),GetPVarInt(playerid,"Premium"),GetPVarInt(playerid,"Knast"),GetPVarInt(playerid,"Knastzeit"),GetPVarInt(playerid,"Lottozahl"),gangname,GetPVarInt(playerid,"Gangrang"),name);
    Ist zulang
    Du musst dies kürzen da das zuviel ist
    Einfach zwei bis drei
    format(query,sizeof(query),


    Nutzen