MySQL Laden?

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
  • /*stock SpielerSpeichern(playerid)
    {
    if(GetPVarInt(playerid,"loggedin")==1)
    {
    new query[3072];
    format(query, sizeof(query), "UPDATE users SET Alter='%i',Personalausweis='%i',Spawnchange='%i',Geld='%i',Admin='%i',Skin='%i',Hunger='%i',Toilette='%i',Fraktionsrang='%i',Leader='%i',Member='%i',Arbeit='%i',Navigation='%i',Premium='%i',Handynummer='%i',Fraktion='%i',Registration='%i',BankKonto='%i',BankGeld='%i',BankRauben='%i',Level='%i',Respektpunkte='%i',MinutesSinceAn='%i',PlayMinutes='%i',Warnungen='%i',Points='%i',Gesamtspielzeit='%i',Tode='%i', WHERE id='%i'",
    pInfo[playerid][pAlter],pInfo[playerid][pPerso],pInfo[playerid],GetPlayerMoney(playerid),pInfo[playerid][pAdmin],pInfo[playerid][pSkin],pInfo[playerid][pHunger],pInfo[playerid][pHarndrang],pInfo[playerid][pRank],pInfo[playerid][pLeader],pInfo[playerid][pMember],pInfo[playerid][pJob],pInfo[playerid][pNavi],pInfo[playerid][pPremium],
    pInfo[playerid][pHandynummer],pInfo[playerid][pFaction],pInfo[playerid][pReg],pInfo[playerid][pBankKonto],pInfo[playerid][pBankGeld],pInfo[playerid][pBankRauben],pInfo[playerid][pLevel],pInfo[playerid][pExp],pInfo[playerid][pMinutesSinceAn],pInfo[playerid][pPlayMinutes],pInfo[playerid][pWarn],pInfo[playerid][pLoGPoints],pInfo[playerid][pGesamtspielzeit],
    pInfo[playerid][pTode],pInfo[playerid][pGameIntro],pInfo[playerid][pDB]);
    mysql_function_query(dbhandle, query, false, "", "");
    format(query, sizeof(query), "UPDATE users SET Wantedpunkte='%i',carlicense='%i',carlicensepoints='%i',bikelicense='%i',bikelicensepoints='%i',trucklicense='%i',trucklicensepoints='%i',planelicense='%i',planelicensepoints='%i',helilicense='%i',helilicensepoints='%i',bootlicense='%i',bootlicensepoints='%i',jailstate='%i',jailtimemin='%i',jailtimesek='%i',Hotel='%i',CarRepairPacks='%i',HandyGeld='%i',HandyVer='%i',Handymodel='%i',PhoneBook='%i' WHERE id='%i'",
    pInfo[playerid][pWantedpunkte],pInfo[playerid][pcarlicense],pInfo[playerid][pcarlicensepoints],pInfo[playerid][pbikelicense],pInfo[playerid][pbikelicensepoints],pInfo[playerid][ptrucklicense],pInfo[playerid][ptrucklicensepoints],pInfo[playerid][pplanelicense],pInfo[playerid][pplanelicensepoints],pInfo[playerid][phelilicense],pInfo[playerid][phelilicensepoints],pInfo[playerid][pbootlicense],
    pInfo[playerid][pbootlicensepoints],pInfo[playerid][pjailstate],pInfo[playerid][pjailtimemin],pInfo[playerid][pjailtimesek],pInfo[playerid][pHotel],pInfo[playerid][pCarRepairPacks],pInfo[playerid][pHandyGeld],pInfo[playerid][pHandyVer],pInfo[playerid][pHandyID],pInfo[playerid][pHandyID],pInfo[playerid][pDB]);
    mysql_function_query(dbhandle, query, false, "", "");
    }
    return 1;
    }*/
    Wie wäre dann der Lade stock?
    @Jeffry :D

  • so z.b:
    format(query,sizeof(query),"SELECT Name,Passwort,Baned,Timeban FROM user WHERE Name='%s'",SpielerName(playerid));
    musste halt nur anpassen

    Xbox Modding Profi
    Mein Xbox Setup:


    Xbox360 Trinity/Valhalla Reach Edition (Flash , Retail)
    Xbox360 Corona (xk3y, Retail)
    Xbox360 Corona (RGH2)
    Xbox360 Xenon (JTAG)
    2x XboxOne (Retail)