Beiträge von ENEF

  • Fahrzeuge in MySQL Speichern

    Perfekt ^^


    Scheint alles zu funktionieren.


    Danke Jeff :thumbup:



    Jeffry:


    Hilfe :D
    Die Fraktionskassen funktionieren nicht wie sie sollen.


    Ich zahle 5000€ in die Fraktionskasse ein, es wird nichts gespeichert.
    Ich mache /fkasse(kassenstand) Betrag ist 5001€
    Wenn ich /fauszahlen mache (eigentlich 5000 drauf) sagt er mir wenn ich 5000 als betrag mache das soviel nicht drauf wäre :/
    fkasse, fauszahlen und frein

    Spoiler anzeigen
    ocmd:frein(playerid,params[])
    {
    if(SpielerInfo[playerid][pLeader] == 0 && SpielerInfo[playerid][pMember] == 0)
    {
    new fsumme,fgeld,fID,string[145];
    fgeld = GetPlayerMoney(playerid);
    if(sscanf(params,"ii",fID,fsumme))return SendClientMessage(playerid, Color_Green,"/feinzahlen [FraktionsID] [Summe]");
    else if (fsumme >= fgeld) return SendClientMessage(playerid, Color_Red, "Du hast nicht soviel Geld auf deiner Hand.");
    if(fID >= sizeof(KassenInfo) || fID < 1)
    {
    return SendClientMessage(playerid, Color_Red, "Diese Fraktion existier nicht!");
    }
    new i = fID;
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    KassenInfo[i][fGeld] += fsumme;
    GivePlayerMoney(playerid, -fsumme);
    format(string, sizeof(string),"Du hast %i€ in die Fraktionskasse eingezahlt! Du hast nun noch %i€ auf der Hand.",fsumme,fgeld-fsumme);
    SendClientMessage(playerid, Color_Green, string);
    //SaveKassen();
    }
    else
    {
    new fsumme,fgeld,string[145];
    fgeld = GetPlayerMoney(playerid);
    if(sscanf(params,"i",fsumme))return SendClientMessage(playerid, Color_Green,"/feinzahlen [Summe]");
    else if (fsumme >= fgeld) return SendClientMessage(playerid, Color_Red, "Du hast nicht soviel Geld auf deiner Hand.");
    if(SpielerInfo[playerid][pLeader] >= sizeof(KassenInfo) || SpielerInfo[playerid][pLeader] < 1)
    {
    return SendClientMessage(playerid, Color_Red, "Du bist in keiner existierenden Fraktion!");
    }
    if(SpielerInfo[playerid][pLeader] != 0)
    {
    new i = SpielerInfo[playerid][pLeader];
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    KassenInfo[i][fGeld] += fsumme;
    GivePlayerMoney(playerid, -fsumme);
    format(string, sizeof(string),"Du hast %i€ in die Fraktionskasse eingezahlt! Du hast nun noch %i€ auf der Hand.",fsumme,fgeld-fsumme);
    SendClientMessage(playerid, Color_Green, string);
    //SaveKassen();
    }
    else
    {
    SendClientMessage(playerid, Color_Red, "Du gehörst nicht zu den Leadern deiner Fraktion!");
    }
    }
    return 1;
    }
    ocmd:fkasse(playerid,params[])
    {
    new string[128];
    new i = SpielerInfo[playerid][pLeader];
    new fmoney = KassenInfo[i][fGeld];
    if(SpielerInfo[playerid][pLeader] >= sizeof(KassenInfo) || SpielerInfo[playerid][pLeader] < 1)
    {
    return SendClientMessage(playerid, Color_Red, "Du bist in keiner existierenden Fraktion!");
    }
    if(SpielerInfo[playerid][pLeader] != 0)
    {
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    format(string, sizeof(string),"Kassenstand %i€",fmoney);
    SendClientMessage(playerid, Color_Green, string);
    //SaveKassen();
    }
    else
    {
    SendClientMessage(playerid, Color_Red, "Du gehörst nicht zu den Leadern deiner Fraktion!");
    }
    return 1;
    }
    ocmd:fauszahlen(playerid,params[])
    {
    new fsumme,string[128];
    new i = SpielerInfo[playerid][pLeader];
    new fmoney = KassenInfo[i][fGeld];
    if(sscanf(params,"i",fsumme))return SendClientMessage(playerid, Color_Green,"/fauszahlen [Summe]");
    else if (fsumme >= fmoney) return SendClientMessage(playerid, Color_Red, "Kasse: So viel Geld haben wir nicht.");
    if(SpielerInfo[playerid][pLeader] >= sizeof(KassenInfo) || SpielerInfo[playerid][pLeader] < 1)
    {
    return SendClientMessage(playerid, Color_Red, "Du bist in keiner existierenden Fraktion!");
    }
    if(SpielerInfo[playerid][pLeader] != 0)
    {
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    KassenInfo[i][fGeld] -= fsumme;
    GivePlayerMoney(playerid, fsumme);
    format(string, sizeof(string),"Du hast %i€ aus der Fraktionskasse ausgezahlt! Kassenstand: %i€",fsumme,fmoney);
    SendClientMessage(playerid, Color_Green, string);
    //SaveKassen();
    }
    else
    {
    SendClientMessage(playerid, Color_Red, "Du gehörst nicht zu den Leadern deiner Fraktion!");
    }
    return 1;
    }


    Save & Load:

    Spoiler anzeigen
    OngameModeinit:
    mysql_tquery(handle, "SELECT * FROM Kassen ORDER BY ID ASC", "LoadKassen", "d", 0);

    Spoiler anzeigen

    Spoiler anzeigen
    forward LoadKassen(secure);
    public LoadKassen(secure)
    {
    new query[128], bool:added, rows = cache_num_rows();
    for(new i=1; i < MAX_FRAKTION; i++)
    {
    if(i > rows || cache_get_field_content_int(i-1, "ID") != i) //i-1 bei den cache-Funktionen, da diese bei 0 anfangen zu zählen
    {
    switch(i)
    {
    case 1: format(KassenInfo[i][fName], 32, "Staatskasse");
    case 2: format(KassenInfo[i][fName], 32, "Test1");
    case 3: format(KassenInfo[i][fName], 32, "Fahrschule");
    case 4: format(KassenInfo[i][fName], 32, "News");
    case 5: format(KassenInfo[i][fName], 32, "ADAC");
    }
    format(query, sizeof(query), "INSERT INTO Kassen (ID, Name) VALUES ('%d', '%s')", i, KassenInfo[i][fName]);
    mysql_tquery(handle, query);
    added = true;
    continue;
    }
    cache_get_field_content(i-1, "Name", KassenInfo[i][fName]);
    KassenInfo[i][fGeld] = cache_get_field_content_int(i-1, "Geld");
    KassenInfo[i][fDrogen] = cache_get_field_content_int(i-1, "Drogen");
    KassenInfo[i][fWaffen] = cache_get_field_content_int(i-1, "Waffen");
    }
    if(added && secure < 10) mysql_tquery(handle, "SELECT * FROM Kassen ORDER BY ID ASC", "LoadKassen", "d", secure+1);
    return 1;
    }
    stock SaveKassen()
    {
    new query[512];
    for(new i=1; i < MAX_FRAKTION; i++)
    {
    format(query, sizeof(query), "UPDATE Kassen SET Name = '%s', Geld = '%d', Drogen = '%d', Waffen = '%d' WHERE ID = '%d'",
    KassenInfo[i][fName], KassenInfo[i][fGeld], KassenInfo[i][fDrogen], KassenInfo[i][fWaffen], i);
    mysql_tquery(handle, query);
    }
    return 1;
    }


    Hoffe du kannst mir noch schnell helfen ^^

  • Fahrzeuge in MySQL Speichern

    Okey, hab ich.
    Nun hier wird alles schön angezeigt und nur in der Datenbank fehlen die einträge..


    Serverlog:

    Spoiler anzeigen

    Code
    [20:03:23] query: UPDATE Auto SET ModellID = '560' Fraktion = '3', PosX = '-2064.277', PosY = '-83.104', PosZ = '34.87', PosR = '180.432', Abgeschleppt = '1', inADAC = '1', Name = 'niddo_189', Grund = 'grundtest', Preis = '500', NewX = '-1821.885', NewY = '34.993', NewZ = '14.828', NewR = '92.188', Farbe1 = '226', Farbe2 = '226' WHERE ID = '36'

    Spoiler anzeigen


    MySQL Log:


    Spoiler anzeigen

    SQL
    [20:03:21] [DEBUG] mysql_format - connection: 1, len: 512, format: "UPDATE Auto SET ModellID = '%d' Fraktion = '%d', PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', Abgeschleppt = '%d', inADAC..."[20:03:23] [DEBUG] mysql_format - connection: 1, len: 512, format: "%sNewX = '%f', NewY = '%f', NewZ = '%f', NewR = '%f', Farbe1 = '%d', Farbe2 = '%d' WHERE ID = '%d'"[20:03:23] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE Auto SET ModellID = '560' Fraktion = '3', PosX = '-2064.2", callback: "(null)", format: "(null)"[20:03:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution[20:03:23] [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 'Fraktion = '3', PosX = '-2064.277', PosY = '-83.104', PosZ = '34.87', PosR = '18' at line 1[20:03:23] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[20:03:23] [DEBUG] Calling callback "OnQueryError"..

    Spoiler anzeigen


    MfG :thumbup:

  • Fahrzeuge in MySQL Speichern

    Perfekt, funktioniert!


    Was ist der Unterschied zwischen SaveVehicle und SaveVehicles? Das hab ich beim alten MySQL schon nicht verstanden :)


    Danke für deine ständige Hilfe Jeff!


    //Sorry :D
    Aber nach dem /oPark wird nichts in der DB gespeichert, mach ich aber oPark ingame kann ich es trotzdem freikaufen, falls es was bringt mein oPark


    Spoiler anzeigen
    ocmd:opark(playerid, params[])
    {
    new preis, grund[34],named[34], string[128];
    GetPlayerName(playerid, named, sizeof(named));
    new Float:NeuX,Float:NeuY,Float:NeuZ, Float:NeuR;
    if(sscanf(params,"is",preis,grund))return SendClientMessage(playerid, Color_Green,"Benutzung: /opark [Preis][Grund]");
    if(SpielerInfo[playerid][pTeam] != 5) return SendClientMessage(playerid, hinweis1,"Du bist kein Mitglied des ADAC's!");
    if(isinADAC[playerid] != 1) return SendClientMessage(playerid, hinweis1, "Du bist nicht in der ADAC Zone!");
    else if(preis < 0 || preis > 1000) return SendClientMessage(playerid, hinweis1,"Du kannst das Bußgeld nicht weniger als 0 und mehr als 1000 kosten lassen!");
    {
    new i = GetFrakVehicleIdx(GetPlayerVehicleID(playerid));
    if(i == -1) return SendClientMessage(playerid, hinweis1, "Du bist nicht in einem abschleppbaren Auto!");
    format(VehInfo[i][Grund], 32, grund);
    format(VehInfo[i][Named], 32, named);
    GetVehiclePos(GetPlayerVehicleID(playerid),NeuX,NeuY,NeuZ);
    GetVehicleZAngle(GetPlayerVehicleID(playerid),NeuR);
    VehInfo[i][Preis] = preis;
    VehInfo[i][inADAC] = 1;
    VehInfo[i][Abgeschleppt] = 1;
    VehInfo[i][NewX] = NeuX;
    VehInfo[i][NewY] = NeuY;
    VehInfo[i][NewZ] = NeuZ;
    VehInfo[i][NewR] = NeuR;
    format(string, sizeof(string),"|Strafzettel| Preis %i€ Grund: %s",preis,grund);
    SendClientMessage(playerid, Color_Green, string);
    SaveVehicle(i);
    SaveVehicles();
    }
    return 1;
    }


    Vorhin war bei LoadVehicles_Data ID nicht definiert, ich hab es einfach so gemacht:
    new query[512], missing, str[64], rows, id;

  • Fahrzeuge in MySQL Speichern

    Perfekt Jeffry ! Vielen Vielen Dank :)


    Da ich in der Zeit noch das SaveVehicles und LoadVehicles gemacht habe, kannst du bei bedarf da auch mal drüber schauen.
    Da hab ich nämlich das Problem, dass in der DB zwar die Einträge erstellt werden, aber ohne Werte also nur '0'
    LoadVehicle, SaveVehicle & SaveVehicles


    Spoiler anzeigen
    stock SaveVehicle(i)
    {
    new query[512];
    if(i < 0 || i >= sizeof(VehInfo)) return 1;
    {
    format(query, sizeof(query), "UPDATE Auto SET ModellID = '%d' Fraktion = '%d', PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', Abgeschleppt = '%d', inADAC = '%d', Name = '%s', Grund = '%s', Preis = '%d', ",
    VehInfo[i][ModellID], VehInfo[i][Fraktion], VehInfo[i][PosX], VehInfo[i][PosY],VehInfo[i][PosZ],VehInfo[i][PosR],VehInfo[i][Abgeschleppt],VehInfo[i][inADAC],VehInfo[i][Named],VehInfo[i][Grund],VehInfo[i][Preis], i);
    format(query, sizeof(query), "NewX = '%f', NewY = '%f', NewZ = '%f', NewR = '%f', Farbe1 = '%d', Farbe2 = '%d' WHERE ID = '%d'",query,
    VehInfo[i][NewX],VehInfo[i][NewY],VehInfo[i][NewZ],VehInfo[i][NewR],VehInfo[i][Farbe1],VehInfo[i][Farbe2],i);
    mysql_tquery(handle, query);
    }
    return 1;
    }
    stock SaveVehicles()
    {
    new query[512];
    for(new i=1; i < MAX_VEHICLES; i++)
    {
    format(query, sizeof(query), "UPDATE Auto SET ModellID = '%d' Fraktion = '%d', PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', Abgeschleppt = '%d', inADAC = '%d', Name = '%s', Grund = '%s', Preis = '%d', ",
    VehInfo[i][ModellID], VehInfo[i][Fraktion], VehInfo[i][PosX], VehInfo[i][PosY],VehInfo[i][PosZ],VehInfo[i][PosR],VehInfo[i][Abgeschleppt],VehInfo[i][inADAC],VehInfo[i][Named],VehInfo[i][Grund],VehInfo[i][Preis], i);
    format(query, sizeof(query), "NewX = '%f', NewY = '%f', NewZ = '%f', NewR = '%f', Farbe1 = '%d', Farbe2 = '%d' WHERE ID = '%d'",query,
    VehInfo[i][NewX],VehInfo[i][NewY],VehInfo[i][NewZ],VehInfo[i][NewR],VehInfo[i][Farbe1],VehInfo[i][Farbe2],i);
    mysql_tquery(handle, query);
    }
    return 1;
    }
    forward LoadVehicles(secure);
    public LoadVehicles(secure)
    {
    new query[128], bool:added, string[3];
    for(new i=0; i < sizeof(FrakAutos); i++)
    {
    format(query, sizeof(query), "INSERT INTO Auto (ID, Name) VALUES ('%d', '%s')", i, VehInfo[i][Named]);
    mysql_tquery(handle, query);
    added = true;
    format(string, sizeof string, "%d", i);
    VehInfo[i][ModellID] = cache_get_field_content_int(i, "ModellID");
    if(VehInfo[i][ModellID] < 400 || VehInfo[i][ModellID] > 611)
    {
    format(query, sizeof(query), "INSERT INTO Auto (ID, ModellID, PosX, PosY, PosZ, PosR, Farbe1, Farbe2, Fraktion) VALUES ('%d', '%d', '%f', '%f', '%f', '%f', '%d', '%d', '%d')", i,
    FrakAutos[i][ModellID],FrakAutos[i][PosX],FrakAutos[i][PosY],FrakAutos[i][PosZ],FrakAutos[i][PosR],FrakAutos[i][Farbe1],FrakAutos[i][Farbe2],FrakAutos[i][Fraktionp]);
    mysql_tquery(handle, query);
    VehInfo[i][ModellID] = FrakAutos[i][ModellID];
    added = true;
    }
    VehInfo[i][ModellID] = cache_get_field_content_int(i-1, "ModellID");
    VehInfo[i][Fraktion] = cache_get_field_content_int(i-1, "Fraktion");
    VehInfo[i][PosX] = cache_get_field_content_float(i-1, "PosX");
    VehInfo[i][PosY] = cache_get_field_content_float(i-1, "PosY");
    VehInfo[i][PosZ] = cache_get_field_content_float(i-1, "PosZ");
    VehInfo[i][PosR] = cache_get_field_content_float(i-1, "PosR");
    VehInfo[i][Abgeschleppt] = cache_get_field_content_int(i-1, "Abgeschleppt");
    VehInfo[i][inADAC] = cache_get_field_content_int(i-1, "inADAC");
    VehInfo[i][Preis] = cache_get_field_content_int(i-1, "Preis");
    cache_get_field_content(i-1, "Grund", VehInfo[i][Grund]);
    cache_get_field_content(i-1, "Name", VehInfo[i][Named]);
    VehInfo[i][NewX] = cache_get_field_content_float(i-1, "NewX");
    VehInfo[i][NewY] = cache_get_field_content_float(i-1, "NewY");
    VehInfo[i][NewZ] = cache_get_field_content_float(i-1, "NewZ");
    VehInfo[i][NewR] = cache_get_field_content_float(i-1, "NewR");
    VehInfo[i][Farbe1] = cache_get_field_content_int(i-1, "Farbe1");
    VehInfo[i][Farbe2] = cache_get_field_content_int(i-1, "Farbe2");
    VehInfo[i][veh_ID] = cache_get_field_content_int(i-1, "veh_ID");
    }
    if(added) SaveVehicles();
    //if(added && secure < 10) mysql_tquery(handle, "SELECT * FROM Auto ORDER BY ID ASC", "LoadVehicles", "d", secure+1);
    return 1;
    }


    Und in OnGameModeInit


    LoadVehicles(); // warning 202: number of arguments does not match definition


    Ich habe mich jetzt einfach irgendwie an den Kassen orientiert, also ich denke es könnte viel Mist dabei herausgekommen sein :D
    Aber ich hab mich erst an das alte MySQL gewöhnt, dass hier ist noch ziemlich kompliziert für mich :)


    Mit freundlichen Grüßen


    TV :thumbup:

  • Fahrzeuge in MySQL Speichern

    Perfekt, jetzt kann ich wenn ich mich in der DB als Admin einschreibe auch Befehle benutzen :)


    Die Log sagt auch:

    Spoiler anzeigen

    Code
    [13:34:15] [join] niddo_189 has joined the server (0:127.0.0.1)[13:34:38] query: UPDATE accounts SET Name = '', Level = '1', Geld = '0', Kills = '0', Tode = '0', Admin = '4', Banned = '0', Leader = '1', Member = '0', Team = '1', Rank = '6', Duty = '0', Skin = '283', Health = '1120403456', xKord = '1557.059692', yKord = '-1631.581420', zKord = '13.382812', Interior = '0' WHERE Name = ''[13:34:38] [part] niddo_189 has left the server (0:1)

    Spoiler anzeigen


    Nur leider wird er in der Datenbank noch nicht eingetragen :/


    //Edit:


    Wenn ich Manuell in der Datenbank sachen einfüge, werden sie auch geladen, also liegt es am SavePlayer?

    Spoiler anzeigen
    stock SavePlayer(playerid)
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    new query[512];
    new Float:xxKord,Float:yyKord,Float:zzKord;
    GetPlayerPos(playerid,xxKord,yyKord,zzKord);
    new typos = GetPlayerSkin(playerid);
    SpielerInfo[playerid][pGeld] = GetPlayerMoney(playerid);//1803
    format(query, sizeof(query), "UPDATE accounts SET Name = '%s', Level = '%d', Geld = '%d', Kills = '%d', Tode = '%d', Admin = '%d', Banned = '%d', Leader = '%d', Member = '%d', Team = '%d', Rank = '%d', Duty = '%d', ",
    SpielerInfo[playerid][pName], SpielerInfo[playerid][pLevel], SpielerInfo[playerid][pGeld], SpielerInfo[playerid][pKills], SpielerInfo[playerid][pTode], SpielerInfo[playerid][pAdmin],
    SpielerInfo[playerid][pBanned], SpielerInfo[playerid][pLeader], SpielerInfo[playerid][pMember], SpielerInfo[playerid][pTeam], SpielerInfo[playerid][pRank], SpielerInfo[playerid][pDuty]);
    format(query, sizeof(query), "%sSkin = '%d', Health = '%d', xKord = '%f', yKord = '%f', zKord = '%f', Interior = '%d' WHERE Name = '%s'", query,
    typos, SpielerInfo[playerid][pHealth], xxKord, yyKord, zzKord, SpielerInfo[playerid][pInterior], SpielerInfo[playerid][pName]);//1807
    mysql_tquery(handle, query);
    printf("query: %s", query);
    }
    return 1;
    }

  • [SAMMELTHREAD] Kleine Scripting Fragen

    for(new i=0;i<sizeof(fVehicleShop);i++)
    {
    if(vehicleid == fShopVehicles[i])
    {
    if(!Spieler[playerid][pFraktion] == 1 || Spieler[playerid][pFraktion] == 0 || Spieler[playerid][pFraktion] == 3 || Spieler[playerid][pFraktion] == 5 || Spieler[playerid][pFraktion] == 9 || Spieler[playerid][pFraktion] == 10 || Spieler[playerid][pFraktion] == 11))
    {
    if(Spieler[playerid][pRank] == RANG_LEADER)
    {
    new Float:Pos[3];
    GetVehicleModelInfo(fVehicleShop[i][fVmodelid], VEHICLE_MODEL_INFO_SIZE, Pos[0], Pos[1], Pos[2]);
    InterpolateCameraPos(playerid,fVehicleShop[i][fVposX],fVehicleShop[i][fVposY],fVehicleShop[i][fVposZ],fVehicleShop[i][fVposX]+Pos[0],fVehicleShop[i][fVposY]-Pos[1],fVehicleShop[i][fVposZ],2500,CAMERA_MOVE);
    InterpolateCameraLookAt(playerid,fVehicleShop[i][fVposX]+Pos[0],fVehicleShop[i][fVposY]-Pos[1],fVehicleShop[i][fVposZ],fVehicleShop[i][fVposX],fVehicleShop[i][fVposY],fVehicleShop[i][fVposZ],2500,CAMERA_MOVE);
    FreezePlayer(playerid);
    strdel(DialogString, 0, sizeof(DialogString));
    format(DialogString, sizeof(DialogString), COLOR_HEX_BLUE"Wang Cars - Fraktionsfahrzeuge\n\n");
    format(DialogString, sizeof(DialogString), "%s"COLOR_HEX_BLUE"Fahrzeug: "COLOR_HEX_WHITE"%s\n"COLOR_HEX_BLUE"Preis: "COLOR_HEX_WHITE"$%d\n"COLOR_HEX_BLUE"Tankverbrauch: "COLOR_HEX_WHITE"%.2fL/KM\n", DialogString, fVehicleShop[i][fVName], fVehicleShop[i][fVPreis], VehicleData[fVehicleShop[i][fVmodelid]-400][vehTankVerbrauch]);
    format(DialogString, sizeof(DialogString), "%s"COLOR_HEX_BLUE"Tankgröße: "COLOR_HEX_WHITE"%.2fL\n\nWenn du dieses Fahrzeug kaufen möchtest, klicke auf den entsprechenden Button.\n", DialogString, VehicleData[fVehicleShop[i][fVmodelid]-400][vehMaxTank]);
    strcat(DialogString, COLOR_HEX_WHITE"Das Geld wird von deiner Hand abgehoben, und das Fahrzeug gehört dann automatisch zur Fraktion an!\nDieses lässt sich nicht auf die privaten Fahrzeuge übertragen, und lässt sich nur durch die Hälfte des Kaufpreises verkaufen!\nÜberleg gut, ob es dir Wert ist!");
    ShowPlayerDialog(playerid, DIALOG_BUYFRAKVEHICLE, DIALOG_STYLE_MSGBOX, "Fraktions Fahrzeug - Kaufen", DialogString, "Kaufen", "Abbrechen");
    return 1;
    }
    }
    else
    {
    FreezePlayer(playerid);
    RemovePlayerFromVehicle(playerid);
    UnfreezePlayer(playerid);
    SendClientMessage(playerid,COLOR_LIGHTBLUE,"** Diese Fahrzeuge können nur Gangs und Mafien kaufen.");
    }
    }
    }
    So geht es doch auch, oder?

  • Fahrzeuge in MySQL Speichern

    LoadPlayer & Checkpasswort sind zwei verschiedene :o
    Loadplayer:

    Spoiler anzeigen
    forward LoadPlayer(playerid);
    public LoadPlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    cache_get_field_content(0, "Name", SpielerInfo[playerid][pName]);
    SpielerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
    SpielerInfo[playerid][pGeld] = cache_get_field_content_int(0, "Geld");
    SpielerInfo[playerid][pKills] = cache_get_field_content_int(0, "Kills");
    SpielerInfo[playerid][pTode] = cache_get_field_content_int(0, "Tode");
    SpielerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "Admin");
    SpielerInfo[playerid][pBanned] = cache_get_field_content_int(0, "Banned");
    SpielerInfo[playerid][pLeader] = cache_get_field_content_int(0, "Leader");
    SpielerInfo[playerid][pMember] = cache_get_field_content_int(0, "Member");
    SpielerInfo[playerid][pTeam] = cache_get_field_content_int(0, "Team");
    SpielerInfo[playerid][pRank] = cache_get_field_content_int(0, "Rank");
    SpielerInfo[playerid][pDuty] = cache_get_field_content_int(0, "Duty");
    SpielerInfo[playerid][pSkin] = cache_get_field_content_int(0, "Skin");
    SpielerInfo[playerid][pHealth] = cache_get_field_content_int(0, "Health");
    SpielerInfo[playerid][xKord] = cache_get_field_content_float(0, "xKord");
    SpielerInfo[playerid][yKord] = cache_get_field_content_float(0, "yKord");
    SpielerInfo[playerid][zKord] = cache_get_field_content_float(0, "zKord");
    SpielerInfo[playerid][pInterior] = cache_get_field_content_int(0, "Interior");
    SetPlayerPos(playerid,SpielerInfo[playerid][xKord], SpielerInfo[playerid][xKord], SpielerInfo[playerid][zKord]);
    SetPlayerInterior(playerid,SpielerInfo[playerid][pInterior]);
    SetPlayerSkin(playerid,SpielerInfo[playerid][pSkin]);

    }
    }

    return 1;
    }

    CheckPW
    Spoiler anzeigen
    forward CheckPassword(playerid);
    public CheckPassword(playerid)
    {
    if(cache_num_rows() != 0)
    {
    SetPVarInt(playerid,"Eingeloggt",1);
    LoadPlayer(playerid);
    SpawnPlayer(playerid);
    }
    else
    {
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Einloggen","Datenbank: Das war das falsche Passwort!","Login","Abbrechen");
    }
    return 1;
    }


    Und klar ich lass ihn speichern, schau
    public OnPlayerDisconnect(playerid, reason)
    {
    DeletePVar(playerid,"Eingeloggt");
    SavePlayer(playerid);


    MfG


    //Edit:


    Spoiler anzeigen

    SQL
    [12:05:05] Incoming connection: 127.0.0.1:64723 id: 0[12:05:05] [join] niddo_189 has joined the server (0:127.0.0.1)[12:05:26] [part] niddo_189 has left the server (0:1)

    Spoiler anzeigen


    Mehr wird in der Log garnicht gespeichert.

  • [SAMMELTHREAD] Kleine Scripting Fragen

    else if(Spieler[playerid][pFraktion] == 1 || Spieler[playerid][pFraktion] == 0 || Spieler[playerid][pFraktion] == 3 || Spieler[playerid][pFraktion] == 5 || Spieler[playerid][pFraktion] == 9 || Spieler[playerid][pFraktion] == 10 || Spieler[playerid][pFraktion] == 11)


    So sollte es funktionieren, du hast immer Spieler[playerid][pFraktion] == 0) //) darf nur am ende sein gemacht

  • San Andreas Sightseeing

    Ich würd Bayside zeigen, find ich das schönste Stück in San Andreas, mit ein wenig aufwand kann man es sogar noch viel schöner machen.


    Mit freundlichen Grüßen


    TV

  • Fahrzeuge in MySQL Speichern

    Ja die Errors sind weg :)


    but, meine Koord. werden nicht gespeichert, mein Adminlevel genau so wenig :/
    Ich verstehe es nicht hier nochmal die Logg...


    Spoiler anzeigen

    SQL
    [22:52:46] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "new_rl", password: "****", port: 3306, autoreconnect: true, pool_size: 2[22:52:46] [DEBUG] CMySQLHandle::Create - creating new connection..[22:52:46] [WARNING] CMySQLHandle::Create - connection already exists[22:52:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:52:46] [DEBUG] CMySQLConnection::Connect - connection was successful[22:52:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:52:46] [DEBUG] mysql_errno - connection: 1[22:52:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:52:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:52:46] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:52:46] [DEBUG] CMySQLConnection::Connect - connection was successful[22:52:46] [DEBUG] CMySQLConnection::Connect - connection was successful[22:52:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Kassen ORDER BY ID ASC", callback: "LoadKassen", format: "d"[22:52:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:52:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:52:46] [DEBUG] CMySQLConnection::Connect - connection was successful[22:52:46] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:52:46] [DEBUG] CMySQLQuery::Execute[LoadKassen] - starting query execution[22:52:46] [DEBUG] CMySQLQuery::Execute[LoadKassen] - query was successfully executed within 0.575 milliseconds[22:52:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[22:52:46] [DEBUG] Calling callback "LoadKassen"..[22:52:46] [DEBUG] cache_get_row_count - connection: 1[22:52:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"[22:52:46] [DEBUG] cache_get_field_content - row: 0, field_name: "Name", connection: 1, max_len: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Name", data: "Staatskasse"[22:52:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geld", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Drogen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Drogen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Waffen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Waffen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"[22:52:46] [DEBUG] cache_get_field_content - row: 1, field_name: "Name", connection: 1, max_len: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Name", data: "Test1"[22:52:46] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Geld", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Geld", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Drogen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Drogen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Waffen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Waffen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"[22:52:46] [DEBUG] cache_get_field_content - row: 2, field_name: "Name", connection: 1, max_len: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Name", data: "Test2"[22:52:46] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Geld", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Geld", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Drogen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Drogen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Waffen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Waffen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 3, field_name: "ID", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "ID", data: "4"[22:52:46] [DEBUG] cache_get_field_content - row: 3, field_name: "Name", connection: 1, max_len: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Name", data: "Test3"[22:52:46] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Geld", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Geld", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Drogen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Drogen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Waffen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Waffen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 4, field_name: "ID", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "ID", data: "5"[22:52:46] [DEBUG] cache_get_field_content - row: 4, field_name: "Name", connection: 1, max_len: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Name", data: "ADAC"[22:52:46] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Geld", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Geld", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Drogen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Drogen", data: "0"[22:52:46] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Waffen", connection: 1[22:52:46] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Waffen", data: "0"[22:52:46] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[22:52:46] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT Name FROM accounts WHERE Name = '%e'"[22:52:46] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189'", callback: "CheckAccount", format: "d"[22:52:46] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution[22:52:46] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.466 milliseconds[22:52:46] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[22:52:46] [DEBUG] Calling callback "CheckAccount"..[22:52:46] [DEBUG] cache_get_row_count - connection: 1[22:52:46] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[22:52:52] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM accounts WHERE Name = '%e' AND Passwort = '%e'"[22:52:52] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts WHERE Name = 'niddo_189' AND Passwort = '", callback: "LoadPlayer", format: "d"[22:52:52] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - starting query execution[22:52:52] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - query was successfully executed within 0.553 milliseconds[22:52:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[22:52:52] [DEBUG] Calling callback "LoadPlayer"..[22:52:52] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[22:53:32] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "new_rl", password: "****", port: 3306, autoreconnect: true, pool_size: 2[22:53:32] [DEBUG] CMySQLHandle::Create - creating new connection..[22:53:32] [WARNING] CMySQLHandle::Create - connection already exists[22:53:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:53:32] [DEBUG] CMySQLConnection::Connect - connection was successful[22:53:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:53:32] [DEBUG] mysql_errno - connection: 1[22:53:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:53:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:53:32] [DEBUG] CMySQLConnection::Connect - connection was successful[22:53:32] [DEBUG] CMySQLConnection::Connect - connection was successful[22:53:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Kassen ORDER BY ID ASC", callback: "LoadKassen", format: "d"[22:53:32] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[22:53:32] [DEBUG] CMySQLConnection::Connect - connection was successful[22:53:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:53:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:53:32] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[22:53:32] [DEBUG] CMySQLQuery::Execute[LoadKassen] - query was successfully executed within 0.585 milliseconds[22:53:32] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[22:53:32] [DEBUG] Calling callback "LoadKassen"..[22:53:32] [DEBUG] cache_get_row_count - connection: 1[22:53:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"[22:53:32] [DEBUG] cache_get_field_content - row: 0, field_name: "Name", connection: 1, max_len: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Name", data: "Staatskasse"[22:53:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geld", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Drogen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Drogen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Waffen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Waffen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"[22:53:32] [DEBUG] cache_get_field_content - row: 1, field_name: "Name", connection: 1, max_len: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Name", data: "Test1"[22:53:32] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Geld", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Geld", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Drogen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Drogen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Waffen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Waffen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"[22:53:32] [DEBUG] cache_get_field_content - row: 2, field_name: "Name", connection: 1, max_len: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Name", data: "Test2"[22:53:32] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Geld", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Geld", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Drogen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Drogen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Waffen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Waffen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 3, field_name: "ID", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "ID", data: "4"[22:53:32] [DEBUG] cache_get_field_content - row: 3, field_name: "Name", connection: 1, max_len: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Name", data: "Test3"[22:53:32] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Geld", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Geld", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Drogen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Drogen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Waffen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Waffen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 4, field_name: "ID", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "ID", data: "5"[22:53:32] [DEBUG] cache_get_field_content - row: 4, field_name: "Name", connection: 1, max_len: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Name", data: "ADAC"[22:53:32] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Geld", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Geld", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Drogen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Drogen", data: "0"[22:53:32] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Waffen", connection: 1[22:53:32] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Waffen", data: "0"[22:53:32] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[22:53:32] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT Name FROM accounts WHERE Name = '%e'"[22:53:32] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189'", callback: "CheckAccount", format: "d"[22:53:32] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution[22:53:32] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.400 milliseconds[22:53:32] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[22:53:32] [DEBUG] Calling callback "CheckAccount"..[22:53:32] [DEBUG] cache_get_row_count - connection: 1[22:53:32] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[22:53:34] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM accounts WHERE Name = '%e' AND Passwort = '%e'"[22:53:34] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts WHERE Name = 'niddo_189' AND Passwort = '", callback: "LoadPlayer", format: "d"[22:53:34] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - starting query execution[22:53:34] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - query was successfully executed within 0.536 milliseconds[22:53:34] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[22:53:34] [DEBUG] Calling callback "LoadPlayer"..[22:53:34] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

    Spoiler anzeigen


    Ich habe alles so eingefügt wie du gesagt hast und trotzdem funktioniert es nicht :/

  • Fahrzeuge in MySQL Speichern

    Danke :D
    Nur noch 1 Error :)
    format(query, sizeof(query), "UPDATE accounts SET Name = '%s', Level = '%d', Geld = '%d', Kills = '%d', Tode = '%d', Admin = '%d', Banned = '%d', Leader = '%d', Member = '%d', Team = '%d', Rank = '%d', Duty = '%d', ",
    SpielerInfo[playerid][pName], SpielerInfo[playerid][pLevel], SpielerInfo[playerid][pGeld], SpielerInfo[playerid][pKills], SpielerInfo[playerid][pTode], SpielerInfo[playerid][pAdmin],
    SpielerInfo[playerid][pBanned], SpielerInfo[playerid][pLeader], SpielerInfo[playerid][pMember], SpielerInfo[playerid][pTeam], SpielerInfo[playerid][pRank], SpielerInfo[playerid][pDuty],
    format(query, sizeof(query), "%sSkin = '%d', Health = '%d', xKord = '%f', yKord = '%f', zKord = '%f', Interior = '%d' WHERE Name = '%s'", query,
    typos, SpielerInfo[playerid][pHealth], xxKord, yyKord, zzKord, SpielerInfo[playerid][pInterior], SpielerInfo[playerid][pName]);//1807


    error 001: expected token: ",", but found ";"

  • Fahrzeuge in MySQL Speichern

    Hi Jeffry,


    danke für die Mühe und Hilfe, aber irgendwie Speichert er meine Kords. immer noch nicht und mein Adminlevel wird immer noch nicht erkannt.
    Ich weiß nicht was ich jetzt wieder falsch gemacht habe :D aber es geht einfach nicht, deswegen falls du kurz Zeit hast hier mal der komplette Code.
    Load&Save

    Spoiler anzeigen
    forward LoadPlayer(playerid);
    public LoadPlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    cache_get_field_content(0, "Name", SpielerInfo[playerid][pName]);
    SpielerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
    SpielerInfo[playerid][pGeld] = cache_get_field_content_int(0, "Geld");
    SpielerInfo[playerid][pKills] = cache_get_field_content_int(0, "Kills");
    SpielerInfo[playerid][pTode] = cache_get_field_content_int(0, "Tode");
    SpielerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "Admin");
    SpielerInfo[playerid][pBanned] = cache_get_field_content_int(0, "Banned");
    SpielerInfo[playerid][pLeader] = cache_get_field_content_int(0, "Leader");
    SpielerInfo[playerid][pMember] = cache_get_field_content_int(0, "Member");
    SpielerInfo[playerid][pTeam] = cache_get_field_content_int(0, "Team");
    SpielerInfo[playerid][pRank] = cache_get_field_content_int(0, "Rank");
    SpielerInfo[playerid][pDuty] = cache_get_field_content_int(0, "Duty");
    SpielerInfo[playerid][pSkin] = cache_get_field_content_int(0, "Skin");
    SpielerInfo[playerid][pHealth] = cache_get_field_content_int(0, "Health");
    SpielerInfo[playerid][xKord] = cache_get_field_content_float(0, "xKord");
    SpielerInfo[playerid][yKord] = cache_get_field_content_float(0, "yKord");
    SpielerInfo[playerid][zKord] = cache_get_field_content_float(0, "zKord");
    SetPlayerPos(playerid,SpielerInfo[playerid][xKord], SpielerInfo[playerid][xKord], SpielerInfo[playerid][zKord]);
    SetPlayerInterior(playerid,SpielerInfo[playerid][pInterior]);
    SetPlayerSkin(playerid,SpielerInfo[playerid][pSkin]);

    }
    }

    return 1;
    }
    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    new query[512];
    new Float:xxKord,Float:yyKord,Float:zzKord;
    GetPlayerPos(playerid,xxKord,yyKord,zzKord);
    new typos = GetPlayerSkin(playerid);
    SpielerInfo[playerid][pGeld] = GetPlayerMoney(playerid);
    format(query, sizeof(query), "UPDATE accounts SET Name = '%s', Level = '%d', Geld = '%d', Kills = '%d', Tode = '%d', Admin = '%d', Banned, Leader = '%d', Member = '%d', Team = '%d', Rank = '%d', Duty = '%d', Skin = '%d', Health = '%d', xKord = '%d', yKord = '%d', zKord, Interior = '%d' = '%d' = '%d' WHERE Name = '%s'",
    SpielerInfo[playerid][pName], SpielerInfo[playerid][pLevel], SpielerInfo[playerid][pGeld], SpielerInfo[playerid][pKills], SpielerInfo[playerid][pTode], SpielerInfo[playerid][pAdmin], SpielerInfo[playerid][pBanned], SpielerInfo[playerid][pLeader], SpielerInfo[playerid][pMember], SpielerInfo[playerid][pTeam], SpielerInfo[playerid][pRank], SpielerInfo[playerid][pDuty], SpielerInfo[playerid][pSkin], SpielerInfo[playerid][pHealth], xxKord, yyKord, zzKord, SpielerInfo[playerid][pInterior], SpielerInfo[playerid][pName]);
    mysql_tquery(handle, query);
    printf("query: %s", query);
    }
    }
    return 1;
    }


    Dann meine Frage, muss ich irgendwo LoadPlayer & SavePlayer machen? Wenn ja, ich hab es versucht dann bekomm ich immer Errors

    Spoiler anzeigen

    C:\Users\Tobi\Desktop\SAMP\samp037_svr_RC1_win32\gamemodes\newrlll.pwn(1805) : error 075: input line too long (after substitutions)
    C:\Users\Tobi\Desktop\SAMP\samp037_svr_RC1_win32\gamemodes\newrlll.pwn(1807) : warning 217: loose indentation
    C:\Users\Tobi\Desktop\SAMP\samp037_svr_RC1_win32\gamemodes\newrlll.pwn(1807) : error 017: undefined symbol "id"
    C:\Users\Tobi\Desktop\SAMP\samp037_svr_RC1_win32\gamemodes\newrlll.pwn(1807) : error 029: invalid expression, assumed zero
    C:\Users\Tobi\Desktop\SAMP\samp037_svr_RC1_win32\gamemodes\newrlll.pwn(1807) : error 029: invalid expression, assumed zero
    C:\Users\Tobi\Desktop\SAMP\samp037_svr_RC1_win32\gamemodes\newrlll.pwn(1807) : fatal error 107: too many error messages on one line

    Spoiler anzeigen

    Spoiler anzeigen


    MySQL Log

    Spoiler anzeigen

    SQL
    [21:47:17] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "new_rl", password: "****", port: 3306, autoreconnect: true, pool_size: 2[21:47:17] [DEBUG] CMySQLHandle::Create - creating new connection..[21:47:17] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called[21:47:17] [DEBUG] CMySQLHandle::Create - connection created (id: 1)[21:47:17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:47:17] [DEBUG] CMySQLConnection::Connect - connection was successful[21:47:17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:47:17] [DEBUG] mysql_errno - connection: 1[21:47:17] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Kassen ORDER BY ID ASC", callback: "LoadKassen", format: "d"[21:47:17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:47:17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:47:17] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:47:17] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts ORDER BY ID ASC", callback: "LoadPlayer", format: "d"[21:47:17] [DEBUG] CMySQLConnection::Connect - connection was successful[21:47:17] [DEBUG] CMySQLConnection::Connect - connection was successful[21:47:17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:47:17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:47:17] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:47:17] [DEBUG] CMySQLQuery::Execute[LoadKassen] - starting query execution[21:47:17] [DEBUG] CMySQLQuery::Execute[LoadKassen] - query was successfully executed within 0.517 milliseconds[21:47:17] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:47:17] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - starting query execution[21:47:17] [DEBUG] Calling callback "LoadKassen"..[21:47:17] [DEBUG] cache_get_row_count - connection: 1[21:47:17] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - query was successfully executed within 0.503 milliseconds[21:47:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"[21:47:17] [DEBUG] cache_get_field_content - row: 0, field_name: "Name", connection: 1, max_len: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Name", data: "Staatskasse"[21:47:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geld", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Drogen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Drogen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Waffen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Waffen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"[21:47:17] [DEBUG] cache_get_field_content - row: 1, field_name: "Name", connection: 1, max_len: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Name", data: "Test1"[21:47:17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Geld", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Geld", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Drogen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Drogen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Waffen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Waffen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"[21:47:17] [DEBUG] cache_get_field_content - row: 2, field_name: "Name", connection: 1, max_len: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Name", data: "Test2"[21:47:17] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Geld", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Geld", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Drogen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Drogen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Waffen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Waffen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 3, field_name: "ID", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "ID", data: "4"[21:47:17] [DEBUG] cache_get_field_content - row: 3, field_name: "Name", connection: 1, max_len: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Name", data: "Test3"[21:47:17] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Geld", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Geld", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Drogen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Drogen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Waffen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Waffen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 4, field_name: "ID", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "ID", data: "5"[21:47:17] [DEBUG] cache_get_field_content - row: 4, field_name: "Name", connection: 1, max_len: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Name", data: "ADAC"[21:47:17] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Geld", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Geld", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Drogen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Drogen", data: "0"[21:47:17] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Waffen", connection: 1[21:47:17] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Waffen", data: "0"[21:47:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:47:17] [DEBUG] Calling callback "LoadPlayer"..[21:47:17] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:47:55] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT Name FROM accounts WHERE Name = '%e'"[21:47:55] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189'", callback: "CheckAccount", format: "d"[21:47:55] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution[21:47:55] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.498 milliseconds[21:47:55] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:47:55] [DEBUG] Calling callback "CheckAccount"..[21:47:55] [DEBUG] cache_get_row_count - connection: 1[21:47:55] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:47:58] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT Name FROM accounts WHERE Name = '%e' AND Passwort = '%e'"[21:47:58] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189' AND Passwort ", callback: "CheckPassword", format: "d"[21:47:58] [DEBUG] CMySQLQuery::Execute[CheckPassword] - starting query execution[21:47:58] [DEBUG] CMySQLQuery::Execute[CheckPassword] - query was successfully executed within 0.481 milliseconds[21:47:58] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:47:58] [DEBUG] Calling callback "CheckPassword"..[21:47:58] [DEBUG] cache_get_row_count - connection: 1[21:47:58] [DEBUG] cache_get_field_content - row: -1, field_name: "Name", connection: 1, max_len: 1[21:47:58] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('-1')[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Level")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Geld")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Kills")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Tode", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Tode")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Admin")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Banned", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Banned")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Leader", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Leader")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Member", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Member")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Team", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Team")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Rank", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Rank")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Duty", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Duty")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Skin", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Skin")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Health", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Health")[21:47:58] [ERROR] cache_get_field_content_int - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_float - row: 0, field_name: "xKord", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("xKord")[21:47:58] [ERROR] cache_get_field_content_float - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_float - row: 0, field_name: "yKord", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("yKord")[21:47:58] [ERROR] cache_get_field_content_float - invalid datatype[21:47:58] [DEBUG] cache_get_field_content_float - row: 0, field_name: "zKord", connection: 1[21:47:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("zKord")[21:47:58] [ERROR] cache_get_field_content_float - invalid datatype[21:47:58] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:48:09] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts ORDER BY ID ASC", callback: "SavePlayer", format: "d"[21:48:09] [DEBUG] CMySQLQuery::Execute[SavePlayer] - starting query execution[21:48:09] [DEBUG] CMySQLQuery::Execute[SavePlayer] - query was successfully executed within 0.603 milliseconds[21:48:09] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:48:09] [DEBUG] Calling callback "SavePlayer"..[21:48:09] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:52:06] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "new_rl", password: "****", port: 3306, autoreconnect: true, pool_size: 2[21:52:06] [DEBUG] CMySQLHandle::Create - creating new connection..[21:52:06] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called[21:52:06] [DEBUG] CMySQLHandle::Create - connection created (id: 1)[21:52:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:52:06] [DEBUG] CMySQLConnection::Connect - connection was successful[21:52:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:52:06] [DEBUG] mysql_errno - connection: 1[21:52:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:52:06] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Kassen ORDER BY ID ASC", callback: "LoadKassen", format: "d"[21:52:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:52:06] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:52:06] [DEBUG] CMySQLConnection::Connect - connection was successful[21:52:06] [DEBUG] CMySQLConnection::Connect - connection was successful[21:52:06] [DEBUG] CMySQLConnection::Connect - connection was successful[21:52:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:52:06] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:52:06] [DEBUG] CMySQLQuery::Execute[LoadKassen] - starting query execution[21:52:06] [DEBUG] CMySQLQuery::Execute[LoadKassen] - query was successfully executed within 0.588 milliseconds[21:52:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:52:06] [DEBUG] Calling callback "LoadKassen"..[21:52:06] [DEBUG] cache_get_row_count - connection: 1[21:52:06] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"[21:52:06] [DEBUG] cache_get_field_content - row: 0, field_name: "Name", connection: 1, max_len: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Name", data: "Staatskasse"[21:52:06] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geld", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Drogen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Drogen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Waffen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Waffen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"[21:52:06] [DEBUG] cache_get_field_content - row: 1, field_name: "Name", connection: 1, max_len: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Name", data: "Test1"[21:52:06] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Geld", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Geld", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Drogen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Drogen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Waffen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Waffen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"[21:52:06] [DEBUG] cache_get_field_content - row: 2, field_name: "Name", connection: 1, max_len: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Name", data: "Test2"[21:52:06] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Geld", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Geld", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Drogen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Drogen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Waffen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Waffen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 3, field_name: "ID", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "ID", data: "4"[21:52:06] [DEBUG] cache_get_field_content - row: 3, field_name: "Name", connection: 1, max_len: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Name", data: "Test3"[21:52:06] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Geld", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Geld", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Drogen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Drogen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Waffen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Waffen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 4, field_name: "ID", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "ID", data: "5"[21:52:06] [DEBUG] cache_get_field_content - row: 4, field_name: "Name", connection: 1, max_len: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Name", data: "ADAC"[21:52:06] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Geld", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Geld", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Drogen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Drogen", data: "0"[21:52:06] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Waffen", connection: 1[21:52:06] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Waffen", data: "0"[21:52:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:52:33] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT Name FROM accounts WHERE Name = '%e'"[21:52:33] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189'", callback: "CheckAccount", format: "d"[21:52:33] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution[21:52:33] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.490 milliseconds[21:52:33] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:52:33] [DEBUG] Calling callback "CheckAccount"..[21:52:33] [DEBUG] cache_get_row_count - connection: 1[21:52:33] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:52:35] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT * FROM users WHERE Name = '%e' AND Passwort = '%e'"[21:52:35] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM users WHERE Name = 'niddo_189' AND Passwort = 'ged", callback: "LoadPlayer", format: "d"[21:52:36] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - starting query execution[21:52:36] [ERROR] CMySQLQuery::Execute[LoadPlayer] - (error #1146) Table 'new_rl.users' doesn't exist[21:52:36] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - error will be triggered in OnQueryError[21:52:36] [DEBUG] Calling callback "OnQueryError"..

    Spoiler anzeigen


    Vielen dank dir :)

  • Fahrzeuge in MySQL Speichern

    Spoiler anzeigen

    SQL
    [21:32:33] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "new_rl", password: "****", port: 3306, autoreconnect: true, pool_size: 2[21:32:33] [DEBUG] CMySQLHandle::Create - creating new connection..[21:32:33] [WARNING] CMySQLHandle::Create - connection already exists[21:32:33] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:32:33] [DEBUG] CMySQLConnection::Connect - connection was successful[21:32:33] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:32:33] [DEBUG] mysql_errno - connection: 1[21:32:33] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:32:33] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM Kassen ORDER BY ID ASC", callback: "LoadKassen", format: "d"[21:32:33] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:32:33] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[21:32:33] [DEBUG] CMySQLConnection::Connect - connection was successful[21:32:33] [DEBUG] CMySQLConnection::Connect - connection was successful[21:32:33] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts ORDER BY ID ASC", callback: "LoadPlayer", format: "d"[21:32:33] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:32:33] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[21:32:33] [DEBUG] CMySQLQuery::Execute[LoadKassen] - starting query execution[21:32:33] [DEBUG] CMySQLQuery::Execute[LoadKassen] - query was successfully executed within 0.555 milliseconds[21:32:33] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:32:33] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - starting query execution[21:32:33] [DEBUG] Calling callback "LoadKassen"..[21:32:33] [DEBUG] cache_get_row_count - connection: 1[21:32:33] [DEBUG] CMySQLQuery::Execute[LoadPlayer] - query was successfully executed within 0.451 milliseconds[21:32:33] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:32:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "1"[21:32:33] [DEBUG] cache_get_field_content - row: 0, field_name: "Name", connection: 1, max_len: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Name", data: "Staatskasse"[21:32:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geld", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Drogen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Drogen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Waffen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Waffen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 1, field_name: "ID", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "ID", data: "2"[21:32:33] [DEBUG] cache_get_field_content - row: 1, field_name: "Name", connection: 1, max_len: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Name", data: "Test1"[21:32:33] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Geld", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Geld", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Drogen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Drogen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 1, field_name: "Waffen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '1', field: "Waffen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 2, field_name: "ID", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "ID", data: "3"[21:32:33] [DEBUG] cache_get_field_content - row: 2, field_name: "Name", connection: 1, max_len: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Name", data: "Test2"[21:32:33] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Geld", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Geld", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Drogen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Drogen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 2, field_name: "Waffen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '2', field: "Waffen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 3, field_name: "ID", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "ID", data: "4"[21:32:33] [DEBUG] cache_get_field_content - row: 3, field_name: "Name", connection: 1, max_len: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Name", data: "Test3"[21:32:33] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Geld", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Geld", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Drogen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Drogen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 3, field_name: "Waffen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '3', field: "Waffen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 4, field_name: "ID", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "ID", data: "5"[21:32:33] [DEBUG] cache_get_field_content - row: 4, field_name: "Name", connection: 1, max_len: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Name", data: "ADAC"[21:32:33] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Geld", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Geld", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Drogen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Drogen", data: "0"[21:32:33] [DEBUG] cache_get_field_content_int - row: 4, field_name: "Waffen", connection: 1[21:32:33] [DEBUG] CMySQLResult::GetRowDataByName - row: '4', field: "Waffen", data: "0"[21:32:33] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:32:33] [DEBUG] Calling callback "LoadPlayer"..[21:32:33] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:32:51] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT Name FROM accounts WHERE Name = '%e'"[21:32:51] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189'", callback: "CheckAccount", format: "d"[21:32:51] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution[21:32:51] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.515 milliseconds[21:32:51] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:32:51] [DEBUG] Calling callback "CheckAccount"..[21:32:52] [DEBUG] cache_get_row_count - connection: 1[21:32:52] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:32:54] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELECT Name FROM accounts WHERE Name = '%e' AND Passwort = '%e'"[21:32:54] [DEBUG] mysql_tquery - connection: 1, query: "SELECT Name FROM accounts WHERE Name = 'niddo_189' AND Passwort ", callback: "CheckPassword", format: "d"[21:32:54] [DEBUG] CMySQLQuery::Execute[CheckPassword] - starting query execution[21:32:54] [DEBUG] CMySQLQuery::Execute[CheckPassword] - query was successfully executed within 0.434 milliseconds[21:32:54] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:32:54] [DEBUG] Calling callback "CheckPassword"..[21:32:54] [DEBUG] cache_get_row_count - connection: 1[21:32:54] [DEBUG] cache_get_field_content - row: -1, field_name: "Name", connection: 1, max_len: 1[21:32:54] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('-1')[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Level")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Geld")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Kills")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Tode", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Tode")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Admin")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Banned", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Banned")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Leader", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Leader")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Member", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Member")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Team", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Team")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Rank", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Rank")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Duty", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Duty")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Skin", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Skin")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Health", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Health")[21:32:54] [ERROR] cache_get_field_content_int - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_float - row: 0, field_name: "xKord", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("xKord")[21:32:54] [ERROR] cache_get_field_content_float - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_float - row: 0, field_name: "yKord", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("yKord")[21:32:54] [ERROR] cache_get_field_content_float - invalid datatype[21:32:54] [DEBUG] cache_get_field_content_float - row: 0, field_name: "zKord", connection: 1[21:32:54] [WARNING] CMySQLResult::GetRowDataByName - field not found ("zKord")[21:32:54] [ERROR] cache_get_field_content_float - invalid datatype[21:32:54] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[21:33:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM accounts ORDER BY ID ASC", callback: "SavePlayer", format: "d"[21:33:08] [DEBUG] CMySQLQuery::Execute[SavePlayer] - starting query execution[21:33:08] [DEBUG] CMySQLQuery::Execute[SavePlayer] - query was successfully executed within 0.533 milliseconds[21:33:08] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[21:33:08] [DEBUG] Calling callback "SavePlayer"..[21:33:08] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

    Spoiler anzeigen


    Ging leider nicht ..

  • Fahrzeuge in MySQL Speichern

    //Doch nicht -.-


    //EDIT: Paar sachen hinzugefügt, trotzdem geht es nicht


    Abfrage :
    if(SpielerInfo[playerid][pAdmin] < 1)return SendClientMessage(playerid,Color_Red,"Diesen Befehl kannst du nicht nutzen. Mindestens benötigter Rang: {00FF5A}Supporter"); {


    und mein Enum, falls du es brauchst


    enum SpielerDaten
    {
    pName[MAX_PLAYER_NAME],
    pLevel,
    pGeld,
    pKills,
    pTode,
    pAdmin,
    pBanned,
    pLeader,
    pMember,
    pTeam,
    pRank,
    pDuty,
    pSkin,
    Float:pHealth,
    Float:xKord,
    Float:yKord,
    Float:zKord,
    pInterior
    }


    forward LoadPlayer(playerid);
    public LoadPlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    cache_get_field_content(playerid-1, "Name", SpielerInfo[playerid][pName]);
    SpielerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
    SpielerInfo[playerid][pGeld] = cache_get_field_content_int(0, "Geld");
    SpielerInfo[playerid][pKills] = cache_get_field_content_int(0, "Kills");
    SpielerInfo[playerid][pTode] = cache_get_field_content_int(0, "Tode");
    SpielerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "Admin");
    SpielerInfo[playerid][pBanned] = cache_get_field_content_int(0, "Banned");
    SpielerInfo[playerid][pLeader] = cache_get_field_content_int(0, "Leader");
    SpielerInfo[playerid][pMember] = cache_get_field_content_int(0, "Member");
    SpielerInfo[playerid][pTeam] = cache_get_field_content_int(0, "Team");
    SpielerInfo[playerid][pRank] = cache_get_field_content_int(0, "Rank");
    SpielerInfo[playerid][pDuty] = cache_get_field_content_int(0, "Duty");
    SpielerInfo[playerid][pSkin] = cache_get_field_content_int(0, "Skin");
    SpielerInfo[playerid][pHealth] = cache_get_field_content_int(0, "Health");
    SpielerInfo[playerid][xKord] = cache_get_field_content_float(0, "xKord");
    SpielerInfo[playerid][yKord] = cache_get_field_content_float(0, "yKord");
    SpielerInfo[playerid][zKord] = cache_get_field_content_float(0, "zKord");
    SetPlayerPos(playerid,SpielerInfo[playerid][xKord], SpielerInfo[playerid][xKord], SpielerInfo[playerid][zKord]);
    SetPlayerInterior(playerid,SpielerInfo[playerid][pInterior]);
    SetPlayerSkin(playerid,SpielerInfo[playerid][pSkin]);

    }
    }

    return 1;
    }
    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    new Float:xxKord,Float:yyKord,Float:zzKord;
    GetPlayerPos(playerid,xxKord,yyKord,zzKord);
    new typos = GetPlayerSkin(playerid);
    SpielerInfo[playerid][pGeld] = GetPlayerMoney(playerid);
    new query[512];
    format(query, sizeof(query), "UPDATE accounts SET Name = '%s', Level = '%d', Geld = '%d', Kills = '%d', Tode = '%d', Admin = '%d', Banned, Leader = '%d', Member = '%d', Team = '%d', Rank = '%d', Duty = '%d', Skin = '%d', Health = '%d', xKord = '%d', yKord = '%d', zKord, Interior = '%d' = '%d' = '%d' WHERE ID = '%d'",
    SpielerInfo[playerid][pName], SpielerInfo[playerid][pName], SpielerInfo[playerid][pLevel], SpielerInfo[playerid][pGeld], SpielerInfo[playerid][pKills], SpielerInfo[playerid][pTode], SpielerInfo[playerid][pAdmin], SpielerInfo[playerid][pBanned], SpielerInfo[playerid][pLeader], SpielerInfo[playerid][pMember], SpielerInfo[playerid][pTeam], SpielerInfo[playerid][pRank], SpielerInfo[playerid][pDuty], SpielerInfo[playerid][pSkin], SpielerInfo[playerid][pHealth], SpielerInfo[playerid][xKord], SpielerInfo[playerid][yKord], SpielerInfo[playerid][zKord], SpielerInfo[playerid][pInterior], playerid);
    mysql_tquery(handle, query);
    }
    }
    return 1;
    }

  • Fahrzeuge in MySQL Speichern

    Oh haha das hab ich jetzt garnicht gesehen, wie peinlich :D


    Sorry :D


    //Edit:


    Ja klar, wenn ich das noch hinbekomme weil es speichert immer noch nicht :/
    Und er sagt mir immer ich bin kein Admin obwohl ich mich in der DB eingetragen habe..
    Brauch ich jetzt ne neue Admin abfrage?