Frage wegen Mysql Explode

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
  • Hey ich hab da ein kleines Problem unzwar wenn ich das 79 Feld auslesen möchte kann ich mich nicht mehr einloggen aber wenn ich nur 78 felder auslesen will geht alles wunderbar hier mein code :


    format(string, sizeof(string), "SELECT * FROM accounts WHERE Name = '%s' AND passwort = '%s'", GetName(playerid), key);
    mysql_query(string);
    mysql_store_result();


    if(!mysql_num_rows())
    {
    return 1;
    }
    else
    {
    mysql_fetch_row_format(row, "|");
    explode(row, field, "|");


    sStats[playerid][sAdminlevel] = strval(field[3]);
    sStats[playerid][sLevel] = strval(field[4]);
    sStats[playerid][sAlter] = strval(field[5]);
    sStats[playerid][sJob] = strval(field[6]);
    sStats[playerid][sGeld] = strval(field[7]);
    sStats[playerid][sTutorial] = strval(field[8]);
    sStats[playerid][sSkin] = strval(field[9]);
    sStats[playerid][sGeschlecht] = strval(field[10]);
    sStats[playerid][sMitglied] = strval(field[11]);
    sStats[playerid][sLeiter] = strval(field[12]);
    sStats[playerid][sMute] = strval(field[13]);
    sStats[playerid][sHaus] = strval(field[14]);
    sStats[playerid][sHausE] = strval(field[15]);
    sStats[playerid][sPersonalausweis] = strval(field[16]);
    sStats[playerid][sSpawnChange] = strval(field[17]);
    sStats[playerid][sPremium] = strval(field[18]);
    sStats[playerid][sLink] = strval(field[19]);
    sStats[playerid][sEingeloggt] = strval(field[20]);
    sStats[playerid][sPremiumZeit] = strval(field[21]);
    sStats[playerid][sHandyChange] = strval(field[22]);
    sStats[playerid][sKaufpunkte] = strval(field[23]);
    sStats[playerid][sHandy] = strval(field[24]);
    sStats[playerid][sGuthaben] = strval(field[25]);
    sStats[playerid][sVertrag] = strval(field[26]);
    sStats[playerid][sAkku] = strval(field[27]);
    sStats[playerid][sGPS] = strval(field[28]);
    sStats[playerid][sNummer] = strval(field[29]);
    sStats[playerid][sWanteds] = strval(field[30]);
    sStats[playerid][sWaffenschein] = strval(field[31]);
    sStats[playerid][sTelefonBuch] = strval(field[32]);
    sStats[playerid][sJailed] = strval(field[33]);
    sStats[playerid][sKlingelton] = strval(field[34]);
    sStats[playerid][sAutoschein] = strval(field[35]);
    sStats[playerid][sAnglerschein] = strval(field[36]);
    sStats[playerid][sMotorradschein] = strval(field[37]);
    sStats[playerid][sBootschein] = strval(field[38]);
    sStats[playerid][sFlugschein] = strval(field[39]);
    sStats[playerid][sAngel] = strval(field[40]);
    sStats[playerid][sKoeder] = strval(field[41]);
    sStats[playerid][sKondom] = strval(field[42]);
    sStats[playerid][sMP3Player] = strval(field[43]);
    sStats[playerid][s247Rob] = strval(field[44]);
    sStats[playerid][sPreamie] = strval(field[45]);
    sStats[playerid][sJailTime] = strval(field[46]);
    sStats[playerid][sHotel] = strval(field[47]);
    sStats[playerid][sArbeitslosengeld] = strval(field[48]);
    sStats[playerid][sKrankenver] = strval(field[49]);
    sStats[playerid][sAutover] = strval(field[50]);
    sStats[playerid][sAutos] = strval(field[51]);
    sStats[playerid][sJobTime] = strval(field[52]);
    sStats[playerid][sArztkosten] = strval(field[53]);
    sStats[playerid][sMats] = strval(field[54]);
    sStats[playerid][sSpielstunden] = strval(field[55]);
    sStats[playerid][sDrogen] = strval(field[56]);
    sStats[playerid][sBetrunken] = strval(field[57]);
    format(sStats[playerid][sGeworbenVon], 32, "%s", field[58]);
    sStats[playerid][sQuest] = strval(field[59]);
    sStats[playerid][sGeworbenNach] = strval(field[60]);
    format(sStats[playerid][sHatGeworben], 32, "%s", field[61]);
    sStats[playerid][sHelm] = strval(field[62]);
    sStats[playerid][sErfahrung] = strval(field[63]);
    sStats[playerid][sPPunkte] = strval(field[64]);
    sStats[playerid][sDriftZeit] = strval(field[65]);
    sStats[playerid][sPKlingelton] = strval(field[66]);
    sStats[playerid][sPKlingeltonHat] = strval(field[67]);
    sStats[playerid][sFraktion] = strval(field[68]);
    sStats[playerid][sSonnenbrille] = strval(field[69]);
    sStats[playerid][sbap] = strval(field[70]);
    sStats[playerid][sMission] = strval(field[71]);
    sStats[playerid][sMissionZeit] = strval(field[72]);
    sStats[playerid][sBenzinkanister] = strval(field[73]);
    sStats[playerid][sTimeBan] = strval(field[74]);
    sStats[playerid][sKonto] = strval(field[75]);
    sStats[playerid][sTruckschein] = strval(field[76]);
    sStats[playerid][sPin] = strval(field[77]);
    sStats[playerid][sWarns] = strval(field[78]);
    sStats[playerid][sKarte] = strval(field[79]); <-- damit ist irgendwas



    danke ;)

  • Jop steht was drinn


    //Edit


    hab nochmal nachgeschaut, im phpmyadmin steht was drin, es geht auch bis zum 78 Feld, ab dem 79 geht garnix mehr, kann mysql nur 79 datenstränge übermitteln?

    Einmal editiert, zuletzt von Manapunkte ()