Server speichert nicht

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,
    Hab ein Problem: Mein Server speichert Spieler-Daten, wie Geld, Level und so, nicht ab, aber persöliche Waffen schon


    Hier der Code:

    stock SaveAccount(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid) && GetPVarInt(playerid,"Eingeloggt") == 1) //wir überprüfen ob der Spieler überhaupt noch Connected ist und ob er nicht ein NPC ist.
    {
    new mainquery[4000],query[4000],Float:Pos[3];



    for (new i = 0; i < 13; i++)
    {
    GetPlayerWeaponData(playerid, i, Spieler[playerid][pPlayerWeapon][i], Spieler[playerid][pPlayerWeaponAmmo][i]);
    }
    //GEFIXXT BY SYNTRO!
    GetPlayerPos(playerid,Pos[0],Pos[1],Pos[2]);
    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_main SET Online='0',Tutorial='%d',Admin='%d',Verwarnungen='%d',EventMotor='%d',FLeaderRechte='%d',Fraktion='%d',FraktionsRang='%d',FraktionsURang='%d',FraktionsSperre='%d',FraktionsGehalt='%d',Job='%d',JobWarns='%d',JobSperre='%d',ArbeitslosenGeld='%d',",
    Spieler[playerid][pViewTutorial],Spieler[playerid][pAdmin],Spieler[playerid][pWarns],Spieler[playerid][pEventMotor],Spieler[playerid][pLeader],Spieler[playerid][pFraktion],Spieler[playerid][pFraktRang],Spieler[playerid][pFraktURang],Spieler[playerid][pFraktionSperre],
    Spieler[playerid][pFraktionsGehalt],Spieler[playerid][pJob],Spieler[playerid][JobWarns],Spieler[playerid][pJobSperre],Spieler[playerid][pWorkLess]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof(query),"Geschlecht='%d',SpielerAlter='%d',Level='%d',Geld='%d',GWD='%d',ZiviNote='%d',FAbteilung='%d',Bankguthaben='%d',BankPin='%d',WantedSterne='%d',WantedPunkte='%d',Suspects='%d',Wanted_Grund1='%s',Wanted_Grund2='%s',Wanted_Grund3='%s',Wanted_Grund4='%s',Wanted_Grund5='%s',",
    Spieler[playerid][pSex],Spieler[playerid][pYearsOld],GetPlayerLevel(playerid),GetACMoney(playerid),Spieler[playerid][pGrundwehrdienst],Spieler[playerid][pZiviNote],Spieler[playerid][pFraktABTInvite],Spieler[playerid][pBank],Spieler[playerid][pBankPin],GetPlayerWantedLevel(playerid),Spieler[playerid][pWantedPoints],Spieler[playerid][pSuspectPoints],
    pWantedReason1[playerid],pWantedReason2[playerid],pWantedReason3[playerid],pWantedReason4[playerid],pWantedReason5[playerid]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof(query),"Crimes='%d',STVOcrimes='%d',KampfStyle='%d',Handy='%d',Handycoins='%d',HandyStatus='%d',HandyAkku='%f',HandyNummer='%d',Handyflat='%d',Handyflatbuyinbiz='%d',Letzte_X='%f',Letzte_Y='%f',Letzte_Z='%f',Letzte_Interior='%d',Letzte_VirtualWorld='%d',",
    Spieler[playerid][pLastSuspects],Spieler[playerid][pSTVOpoints],GetPlayerFightingStyle(playerid),Spieler[playerid][pHandy],Spieler[playerid][pHandyCoins],Spieler[playerid][pHandystate],Spieler[playerid][pHandyakku],Spieler[playerid][pPhonenumber],Spieler[playerid][pHandyFlat],Spieler[playerid][pHandyBuyByBiz],
    Pos[0],Pos[1],Pos[2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid));
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));
    format(query,sizeof(query),"pSelectHome='%d',HausMieter='%d',Spawn='%d',Hotel='%d',Tod='%d',Tot_X='%f',Tot_Y='%f',Tot_Z='%f',Tot_Interior='%d',Tot_VirtualWorld='%d',TotZeit='%d',Friedhof='%d',FriedhofZeit='%d',ImKnast='%d',KnastZeit='%d',KnastKaution='%d' WHERE Name='%s'",
    Spieler[playerid][pSelectHome],Spieler[playerid][pRentHome],Spieler[playerid][pSpawn],Spieler[playerid][pHotel],Spieler[playerid][pDeath],Spieler[playerid][tot_x],Spieler[playerid][tot_y],Spieler[playerid][tot_z],Spieler[playerid][tot_int],Spieler[playerid][tot_world],Spieler[playerid][pDeathTime],Spieler[playerid][pFriedhof],Spieler[playerid][pFriedhofTime],
    Spieler[playerid][pJailed],Spieler[playerid][pJailTime],Spieler[playerid][pKaution],Spieler[playerid][pName]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));



    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_main SET Muted='%d',MuteZeit='%d',ImPrison='%d',PrisonCheckPointsAbgelaufen='%d',PrisonCheckPointsGegeben='%d',Morde='%d',Tode='%d',SkinID='%d',FraktionSkinID='%d',PaintBallKills='%d',PaintBallTode='%d',PaintBallRang='%d',PaintBallBesuche='%d',AngenommeneReports='%d',KopfGeld='%d',",
    Spieler[playerid][pMuted],Spieler[playerid][pMuteTime],Spieler[playerid][pInPrison],Spieler[playerid][pPrisonCPsgelaufen],Spieler[playerid][pPrisonCPsgegeben],Spieler[playerid][pMorde],Spieler[playerid][pTode],Spieler[playerid][pSkin],Spieler[playerid][pFraktSkin],Spieler[playerid][pPBKills],Spieler[playerid][pPBDeaths],
    Spieler[playerid][pPBRang],Spieler[playerid][pPBVisits],Spieler[playerid][Reports],Spieler[playerid][pHeadMoney]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));



    format(query,sizeof(query),"pWantedDeaths='%d',pBuyTickets='%d',pJailedCount='%d',Bankkonto='%d',pArmyPlaneOrder='%d',pArmyHeliOrder='%d',pArmyWaffenOrder='%d',LevelUPKosten='%d',RespectForLevelUp='%d',RespectFromPayday='%d',TimeAfterRegister='%d',",
    Spieler[playerid][pWantedDeaths],Spieler[playerid][pBuyTickets],Spieler[playerid][pJailedCount],Spieler[playerid][pBankkonto],Spieler[playerid][pArmyPlaneOrder],Spieler[playerid][pArmyHeliOrder],Spieler[playerid][pArmyWaffenOrder],
    Spieler[playerid][pLevelKosten],Spieler[playerid][pRespektToLevelUp],Spieler[playerid][pRespektFromPayday],Spieler[playerid][pTimeAfterRegister]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));



    format(query,sizeof(query),"Time4Payday='%d',TimeoutCrashExeorKick='%d',HabGeworben='%d',RpChat='%d',pPremium='%d',GeworbenerSpieler='%s',pScheinSperre='%d',DigiHud='%d',Bonus='%d',Gutschein='%d',pCoins='%d',",
    Spieler[playerid][pMinutesAfterPayday],Spieler[playerid][pAntiOfflineFlucht],Spieler[playerid][HatGeworben],Spieler[playerid][RpChat],Spieler[playerid][pPremium],Spieler[playerid][GeworbenPlaya],Spieler[playerid][pScheinSperre],
    Spieler[playerid][DigiHud],Spieler[playerid][pStartbonus],Spieler[playerid][pGutschein],Spieler[playerid][pCoins]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));



    format(query,sizeof(query),"pFirmaLeader='%d',pFirmaMember='%d',pOrgLeader='%d',pOrgMember='%d',pLohn='%d',WaitPerso='%d',pMarried='%s',pBuyClothes='%d',pIll='%d',pConterminatedTime='%d',pBitchSkill='%d',pBitchFuckCount='%d',pMedicHealplayerSkill='%d',pMedicHealCount='%d' WHERE Name='%s'",
    Spieler[playerid][pFirmaLeader],Spieler[playerid][pFirmaMember],Spieler[playerid][pOrgLeader],Spieler[playerid][pOrgMember],Spieler[playerid][pLohn],Spieler[playerid][WaitPerso],
    Spieler[playerid][pMarried],Spieler[playerid][pBuyClothes],Spieler[playerid][pIll],Spieler[playerid][pConterminatedTime],Spieler[playerid][pBitchSkill],Spieler[playerid][pBitchFuckCount],Spieler[playerid][pMedicHealplayerSkill],Spieler[playerid][pMedicHealCount],Spieler[playerid][pName]);
    strcat(mainquery,query);
    strdel(query,0,sizeof(query));
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));



    format(mainquery,sizeof(mainquery),"UPDATE "#DATENBANKTAG"_account_weapons SET Waffen0='%d',Waffen1='%d',Waffen2='%d',Waffen3='%d',Waffen4='%d',Waffen5='%d',Waffen6='%d',Waffen7='%d',Waffen8='%d',Waffen9='%d',Waffen10='%d',Waffen11='%d',Waffen12='%d',Ammo0='%d',Ammo1='%d',Ammo2='%d',Ammo3='%d',Ammo4='%d',Ammo5='%d',Ammo6='%d',Ammo7='%d',Ammo8='%d',Ammo9='%d',Ammo10='%d',Ammo11='%d',Ammo12='%d' WHERE Name='%s'",
    Spieler[playerid][pPlayerWeapon][0],Spieler[playerid][pPlayerWeapon][1],Spieler[playerid][pPlayerWeapon][2],Spieler[playerid][pPlayerWeapon][3],Spieler[playerid][pPlayerWeapon][4],Spieler[playerid][pPlayerWeapon][5],Spieler[playerid][pPlayerWeapon][6],
    Spieler[playerid][pPlayerWeapon][7],Spieler[playerid][pPlayerWeapon][8],Spieler[playerid][pPlayerWeapon][9],Spieler[playerid][pPlayerWeapon][10],Spieler[playerid][pPlayerWeapon][11],Spieler[playerid][pPlayerWeapon][12],
    Spieler[playerid][pPlayerWeaponAmmo][0]/2,Spieler[playerid][pPlayerWeaponAmmo][1]/2,Spieler[playerid][pPlayerWeaponAmmo][2]/2,Spieler[playerid][pPlayerWeaponAmmo][3]/2,Spieler[playerid][pPlayerWeaponAmmo][4]/2,Spieler[playerid][pPlayerWeaponAmmo][5]/2,Spieler[playerid][pPlayerWeaponAmmo][6]/2,
    Spieler[playerid][pPlayerWeaponAmmo][7]/2,Spieler[playerid][pPlayerWeaponAmmo][8]/2,Spieler[playerid][pPlayerWeaponAmmo][9]/2,Spieler[playerid][pPlayerWeaponAmmo][10]/2,Spieler[playerid][pPlayerWeaponAmmo][11]/2,Spieler[playerid][pPlayerWeaponAmmo][12]/2,Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    format(mainquery,sizeof(mainquery),"UPDATE "#DATENBANKTAG"_account_fish SET FishID1='%d',FishID2='%d',FishID3='%d',FishID4='%d',FishID5='%d',Fishweight1='%d',Fishweight2='%d',Fishweight3='%d',Fishweight4='%d',Fishweight5='%d' WHERE Name='%s'",
    Spieler[playerid][pFishID][1],Spieler[playerid][pFishID][2],Spieler[playerid][pFishID][3],Spieler[playerid][pFishID][4],Spieler[playerid][pFishID][5],Spieler[playerid][pFischgewicht][1],Spieler[playerid][pFischgewicht][2],Spieler[playerid][pFischgewicht][3],Spieler[playerid][pFischgewicht][4],Spieler[playerid][pFischgewicht][5],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    format(mainquery,sizeof(mainquery),"UPDATE "#DATENBANKTAG"_account_koffer SET Slot0='%d',Slot1='%d',Slot2='%d',Slot3='%d',Slot4='%d',Slot5='%d',Slot6='%d',Slot7='%d',Slot8='%d',Slot9='%d',Slot10='%d' WHERE Name='%s'",
    Spieler[playerid][pKofferItems][0],Spieler[playerid][pKofferItems][1],Spieler[playerid][pKofferItems][2],Spieler[playerid][pKofferItems][3],Spieler[playerid][pKofferItems][4],Spieler[playerid][pKofferItems][5],Spieler[playerid][pKofferItems][6],
    Spieler[playerid][pKofferItems][7],Spieler[playerid][pKofferItems][8],Spieler[playerid][pKofferItems][9],Spieler[playerid][pKofferItems][10],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    strcat(mainquery,"UPDATE "#DATENBANKTAG"_account_blacklist SET ");
    for(new fID=0;fID<MAX_FRAKTIONNEN;fID++)
    {
    if(fID > 0) strcat(mainquery,",");
    format(mainquery,sizeof(mainquery),"%sblacklist%i='%d'",mainquery,fID,Spieler[playerid][pBL][fID]);
    strcat(mainquery,",");
    format(mainquery,sizeof(mainquery),"%sblacklistreason%i='%s'",mainquery,fID,pBLReason[playerid][fID]);
    }
    format(mainquery,sizeof(mainquery),"%s WHERE Name='%s'",mainquery,Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    format(mainquery,sizeof(mainquery),"UPDATE "#DATENBANKTAG"_account_inventar SET c4='%d',materials='%d',material_packs='%d',lunchpackets='%d',navi='%d',helm='%d',angel='%d',angelkoeder='%d',repairboxxes='%d',refillgalons='%d',koffer='%d',zigarrets='%d',alcohol='%d',ganja='%d',kokain='%d',opium='%d',spice='%d',ganjaseats='%d',kokainseats='%d',opiumseats='%d',spiceseats='%d',callbook='%d',condoms='%d',duenger='%d' WHERE Name='%s'",
    Spieler[playerid][pC4],Spieler[playerid][pMaterials],Spieler[playerid][MatsPackete],Spieler[playerid][pLunchpaket],Spieler[playerid][pNavi],Spieler[playerid][pMotorradhelm],Spieler[playerid][pAngel],Spieler[playerid][pAngelKoeder],Spieler[playerid][pRepairVehBoxes],Spieler[playerid][pTankFillBoxes],Spieler[playerid][pKoffer],Spieler[playerid][pZigarets],
    Spieler[playerid][pAlc],Spieler[playerid][pGanja],Spieler[playerid][pKokain],Spieler[playerid][pOpium],Spieler[playerid][pSpice],Spieler[playerid][pGanjaSammen],Spieler[playerid][pKokainSammen],Spieler[playerid][pOpiumSammen],Spieler[playerid][pSpiceSammen],Spieler[playerid][pCallBook],Spieler[playerid][pCondoms],Spieler[playerid][pDuenger],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    format(mainquery,sizeof(mainquery),"UPDATE "#DATENBANKTAG"_account_licenses SET car='%d',bike='%d',roller='%d',boat='%d',plane='%d',helicopter='%d',weapon='%d',fishing='%d',personality='%d' WHERE Name='%s'",
    Spieler[playerid][pAutoLic],Spieler[playerid][pBikeLic],Spieler[playerid][pRollerLic],Spieler[playerid][pBoatLic],Spieler[playerid][pPlaneLic],Spieler[playerid][pHeliLic],Spieler[playerid][pWaffenLic],Spieler[playerid][pFishingLic],Spieler[playerid][pPersoLic],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    format(mainquery,sizeof(mainquery),"UPDATE "#DATENBANKTAG"_account_banksafe SET safetresor='%d',ganja='%d',kokain='%d',opium='%d',spice='%d',materials='%d',c4='%d',lunchpaket='%d',matspackete='%d',bier='%d',zigaretten='%d',werkzeugkaesten='%d',benzinkanister='%d',koeder='%d',kondome='%d',duenger='%d' WHERE Name='%s'",
    Spieler[playerid][pBankSafeSafe],Spieler[playerid][pBankSafeGanja],Spieler[playerid][pBankSafeKokain],Spieler[playerid][pBankSafeOpium],Spieler[playerid][pBankSafeSpice],Spieler[playerid][pBankSafeMaterials],Spieler[playerid][pBankSafeC4],
    Spieler[playerid][pBankSafeLunchpaket],Spieler[playerid][pBankSafeMatspackete],Spieler[playerid][pBankSafeAlc],Spieler[playerid][pBankSafeZigarets],Spieler[playerid][pBankSafeRepairVehBoxes],
    Spieler[playerid][pBankSafeTankFillBoxes],Spieler[playerid][pBankSafeAngelkoeder],Spieler[playerid][pBankSafeCondoms],Spieler[playerid][pBankSafeDuenger],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    strdel(mainquery,0,sizeof(mainquery));
    new slot = 0;
    for(;slot<MAX_PLAYER_VEHS;slot++)
    {
    if(!strcmp(Spieler[playerid][pName],Pfahrzeug[slot][playerid][Besitzer],true))
    {
    if(Pfahrzeug[slot][playerid][modelid] != 0)
    {
    GetVehicleHealth(Pfahrzeug[slot][playerid][Vehicle],Pfahrzeug[slot][playerid][HP]);
    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_vehicle SET modelid='%d',x='%f',y='%f',z='%f',a='%f',interior='%d',world='%d',cc1='%d',cc2='%d',paintjob='%d',vehhp='%f',abgeschlossen='%d',t1='%d',t2='%d',t3='%d',t4='%d',t5='%d',t6='%d',t7='%d',t8='%d',t9='%d',t10='%d',t11='%d',t12='%d',t13='%d',t14='%d',",
    Pfahrzeug[slot][playerid][modelid],Pfahrzeug[slot][playerid][posx],Pfahrzeug[slot][playerid][posy],Pfahrzeug[slot][playerid][posz],Pfahrzeug[slot][playerid][posa],Pfahrzeug[slot][playerid][Interior],Pfahrzeug[slot][playerid][VirtualWorld],Pfahrzeug[slot][playerid][Colour1],Pfahrzeug[slot][playerid][Colour2],
    Pfahrzeug[slot][playerid][Paintjob],Pfahrzeug[slot][playerid][HP],Pfahrzeug[slot][playerid][Abgeschlossen],Pfahrzeug[slot][playerid][Spoiler],Pfahrzeug[slot][playerid][Hood],Pfahrzeug[slot][playerid][Roof],
    Pfahrzeug[slot][playerid][Sideskirt],Pfahrzeug[slot][playerid][Lamps],Pfahrzeug[slot][playerid][Nitro],Pfahrzeug[slot][playerid][Exhaust],Pfahrzeug[slot][playerid][Wheels],Pfahrzeug[slot][playerid][Stereo],
    Pfahrzeug[slot][playerid][Hydraulics],Pfahrzeug[slot][playerid][FrontBumper],Pfahrzeug[slot][playerid][RearBumper],Pfahrzeug[slot][playerid][VentRight],Pfahrzeug[slot][playerid][VentLeft]);
    strcat(mainquery,query);
    format(query,sizeof(query),"angemeldet='%d',atime='%d',atAnmeldung='%d',preis='%d',nummernschild='%s',neon='%d',motordown='%d',tank='%f',km='%d',towed='%d',towedfreeprice='%d',towedreason='%s',kganja='%d',kkokain='%d',kopium='%d',kspice='%d',kmats='%d',klunch='%d',kc4='%d',",
    Pfahrzeug[slot][playerid][Angemeldet],Pfahrzeug[slot][playerid][AnmeldeTime],Pfahrzeug[slot][playerid][AnAnmeldung],Pfahrzeug[slot][playerid][Preis],Pfahrzeug[slot][playerid][Nummernschild],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Neon],
    MotorDown[Pfahrzeug[slot][playerid][Vehicle]],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Tank],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Kilometer],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Abgeschleppt],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][AbgeschlepptPreis],
    vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][AbgeschlepptGrund],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumGanja],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumKokain],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumOpium],
    vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumSpice],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumMaterials],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumLunchpakete],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumC4]);
    strcat(mainquery,query);
    format(query,sizeof(query),"kwkanister='%d',kkanister='%d',handbrake='%d' WHERE name='%s' AND slot='%d'",vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumWerkzeugkasten],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumBenzinkanister],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Handbremse],Pfahrzeug[slot][playerid][Besitzer],slot);
    strcat(mainquery,query);
    mysql_function_query(MySqlConnection,mainquery,false,"","");
    }
    }
    }
    printf("SAVE: %s Account hat gespeichert!",Spieler[playerid][pName]);
    }
    return 1;
    }


    MfG

  • Ab dem Zeitpunkt wo jmd einloggt:



    [15:29:19] >> mysql_ping( Connection handle: 1 )
    [15:29:19] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:19] >> cache_get_data( Connection handle: 1 )
    [15:29:19] >> cache_get_data( Connection handle: 1 )
    [15:29:19] ProcessTick() - The cache has been cleared.
    [15:29:19] Passing query SELECT * FROM pRP_bans WHERE IP='127.0.0.1' OR Name='EINLOGGER_1' | siii
    [15:29:19] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM pRP_bans WHERE IP='127.0.0.1' OR Name='EINLOGGER_1')
    [15:29:19] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
    [15:29:19] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:19] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:19] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:19] OnQueryFinish(siii) - Threaded function called.
    [15:29:19] >> mysql_ping( Connection handle: 1 )
    [15:29:19] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:19] >> cache_get_data( Connection handle: 1 )
    [15:29:19] >> cache_get_data( Connection handle: 1 )
    [15:29:19] ProcessTick() - The cache has been cleared.
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] Passing query SELECT * FROM pRP_account_main WHERE Name = 'Taylor_Swift' | siii
    [15:29:25] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM pRP_account_main WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] OnQueryFinish(siii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_autologin WHERE Name='Taylor_Swift' AND IP='127.0.0.1' | siii
    [15:29:25] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM pRP_account_autologin WHERE Name='Taylor_Swift' AND IP='127.0.0.1')
    [15:29:25] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] OnQueryFinish(siii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_main WHERE Name='Taylor_Swift' | isi
    [15:29:25] ProcessQueryThread(LoadAccount) - Query was successful. (SELECT * FROM pRP_account_main WHERE Name='Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccount) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccount(isi) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(pRP_account_main); - Escaped 16 characters to pRP_account_main.
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(Online); - Escaped 6 characters to Online.
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(Taylor_Swift); - Escaped 12 characters to Taylor_Swift.
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(pRP_account_main); - Escaped 16 characters to pRP_account_main.
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(PropertyClearTime); - Escaped 17 characters to PropertyClearTime.
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
    [15:29:25] >> mysql_real_escape_string( Connection handle: 1 )
    [15:29:25] CMySQLHandler::EscapeString(Taylor_Swift); - Escaped 12 characters to Taylor_Swift.
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] >> mysql_query_callback( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_weapons WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountWeapons) - Query was successful. (SELECT * FROM pRP_account_weapons WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountWeapons) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountWeapons(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_fish WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountFish) - Query was successful. (SELECT * FROM pRP_account_fish WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountFish) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountFish(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_koffer WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountKoffer) - Query was successful. (SELECT * FROM pRP_account_koffer WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountKoffer) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountKoffer(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_blacklist WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountBlacklists) - Query was successful. (SELECT * FROM pRP_account_blacklist WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountBlacklists) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountBlacklists(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_inventar WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountInventar) - Query was successful. (SELECT * FROM pRP_account_inventar WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountInventar) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountInventar(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_licenses WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountLicenses) - Query was successful. (SELECT * FROM pRP_account_licenses WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountLicenses) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountLicenses(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_banksafe WHERE Name = 'Taylor_Swift' | i
    [15:29:25] ProcessQueryThread(LoadAccountBankSafe) - Query was successful. (SELECT * FROM pRP_account_banksafe WHERE Name = 'Taylor_Swift')
    [15:29:25] ProcessQueryThread(LoadAccountBankSafe) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountBankSafe(i) - Threaded function called.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '0' | ii
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Query was successful. (SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '0')
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountVehicles(ii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '1' | ii
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Query was successful. (SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '1')
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountVehicles(ii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '2' | ii
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Query was successful. (SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '2')
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountVehicles(ii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '3' | ii
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Query was successful. (SELECT * FROM pRP_account_vehicle WHERE name = 'Taylor_Swift' AND slot = '3')
    [15:29:25] ProcessQueryThread(LoadAccountVehicles) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] LoadAccountVehicles(ii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query UPDATE pRP_account_main SET Online='1' WHERE Name='Taylor_Swift' |
    [15:29:25] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_main SET Online='1' WHERE Name='Taylor_Swift')
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] () - Threaded function called.
    [15:29:25] Passing query SELECT * FROM pRP_account_autologin WHERE Name='Taylor_Swift' AND IP='127.0.0.1' | siii
    [15:29:25] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM pRP_account_autologin WHERE Name='Taylor_Swift' AND IP='127.0.0.1')
    [15:29:25] ProcessQueryThread(OnQueryFinish) - Data caching enabled.
    [15:29:25] CMySQLHandler::StoreResult() - Result was stored.
    [15:29:25] CMySQLHandler::FreeResult() - Result was successfully free'd.
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] OnQueryFinish(siii) - Threaded function called.
    [15:29:25] >> mysql_ping( Connection handle: 1 )
    [15:29:25] CMySQLHandler::Ping() - Connection is still alive.
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] >> cache_get_data( Connection handle: 1 )
    [15:29:25] ProcessTick() - The cache has been cleared.
    [15:29:25] Passing query UPDATE pRP_account_main SET PropertyClearTime='1451312965' WHERE Name='Taylor_Swift' |
    [15:29:25] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_main SET PropertyClearTime='1451312965' WHERE Name='Taylor_Swift')
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:25] () - Threaded function called.
    [15:29:25] Passing query INSERT INTO onlines (ID, Name) VALUES ('0','Taylor_Swift') |
    [15:29:25] ProcessQueryThread() - Query was successful. (INSERT INTO onlines (ID, Name) VALUES ('0','Taylor_Swift'))
    [15:29:25] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:26] () - Threaded function called.
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] Passing query DELETE FROM onlines WHERE ID = '0' |
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] ProcessQueryThread() - Query was successful. (DELETE FROM onlines WHERE ID = '0')
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] >> mysql_query_callback( Connection handle: 1 )
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0', |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0',UPDATE pRP_account_main SET Geschlecht='1',SpielerAlter='0',Level='0',Geld='0',GWD='0',ZiviNote='0',FAbteilung='0',Bankguthaben='0',BankPin='0',WantedSterne='0',WantedPunkte='0',Suspects='0',Wanted_Grund1='',Wanted_Grund2='',Wanted_Grund3='',Wanted_Grund4='',Wanted_Grund5='', |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0',UPDATE pRP_account_main SET Geschlecht='1',SpielerAlter='0',Level='0',Geld='0',GWD='0',ZiviNote='0',FAbteilung='0',Bankguthaben='0',BankPin='0',WantedSterne='0',WantedPunkte='0',Suspects='0',Wanted_Grund1='',Wanted_Grund2='',Wanted_Grund3='',Wanted_Grund4='',Wanted_Grund5='',UPDATE pRP_account_main SET Crimes='0',STVOcrimes='0',KampfStyle='4',Handy='0',Handycoins='0',HandyStatus='0',HandyAkku='0.000000',HandyNummer='0',Handyflat='0',Handyflatbuyinbiz='0',Letzte_X='1129.346801',Letzte_Y='-1614.661010',Letzte_Z='18.544445',Letzte_Interior='0',Letzte_VirtualWorld='0', |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0',UPDATE pRP_account_main SET Geschlecht='1',SpielerAlter='0',Level='0',Geld='0',GWD='0',ZiviNote='0',FAbteilung='0',Bankguthaben='0',BankPin='0',WantedSterne='0',WantedPunkte='0',Suspects='0',Wanted_Grund1='',Wanted_Grund2='',Wanted_Grund3='',Wanted_Grund4='',Wanted_Grund5='',UPDATE pRP_account_main SET Crimes='0',STVOcrimes='0',KampfStyle='4',Handy='0',Handycoins='0',HandyStatus='0',HandyAkku='0.000000',HandyNummer='0',Handyflat='0',Handyflatbuyinbiz='0',Letzte_X='1129.346801',Letzte_Y='-1614.661010',Letzte_Z='18.544445',Letzte_Interior='0',Letzte_VirtualWorld='0',UPDATE pRP_account_main SET pSelectHome='0',HausMieter='0',Spawn='0',Hotel='0',Tod='0',Tot_X='0.000000',Tot_Y='0.000000',Tot_Z='0.000000',Tot_Interior='0',Tot_VirtualWorld='0',TotZeit='0',Friedhof='0',FriedhofZeit='0',ImKnast='0',KnastZeit='0',KnastKaution='0' WHERE Name='Taylor_Swift' |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='70',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0', |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='70',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',UPDATE pRP_account_main SET pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='1',TimeAfterRegister='57629', |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='70',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',UPDATE pRP_account_main SET pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='1',TimeAfterRegister='57629',UPDATE pRP_account_main SET Time4Payday='3354',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',Bonus='1',Gutschein='0',pCoins='0', |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='70',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',UPDATE pRP_account_main SET pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='1',TimeAfterRegister='57629',UPDATE pRP_account_main SET Time4Payday='3354',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',Bonus='1',Gutschein='0',pCoins='0',UPDATE pRP_account_main SET pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pLohn='0',WaitPerso='1449931371',pMarried='Niemand',pBuyClothes='-1',pIll='0',pConterminatedTime='0',pBitchSkill='0',pBitchFuckCount='0',pMedicHealplayerSkill='0',pMedicHealCount='0' WHERE Name='Taylor_Swift' |
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [15:29:39] OnQueryError() - Called.
    [15:29:39] Passing query UPDATE pRP_account_weapons SET Waffen0='0',Waffen1='0',Waffen2='0',Waffen3='0',Waffen4='0',Waffen5='0',Waffen6='0',Waffen7='0',Waffen8='0',Waffen9='0',Waffen10='0',Waffen11='0',Waffen12='0',Ammo0='0',Ammo1='0',Ammo2='0',Ammo3='0',Ammo4='0',Ammo5='0',Ammo6='0',Ammo7='0',Ammo8='0',Ammo9='0',Ammo10='0',Ammo11='0',Ammo12='0' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_weapons SET Waffen0='0',Waffen1='0',Waffen2='0',Waffen3='0',Waffen4='0',Waffen5='0',Waffen6='0',Waffen7='0',Waffen8='0',Waffen9='0',Waffen10='0',Waffen11='0',Waffen12='0',Ammo0='0',Ammo1='0',Ammo2='0',Ammo3='0',Ammo4='0',Ammo5='0',Ammo6='0',Ammo7='0',Ammo8='0',Ammo9='0',Ammo10='0',Ammo11='0',Ammo12='0' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_fish SET FishID1='-1',FishID2='-1',FishID3='-1',FishID4='-1',FishID5='-1',Fishweight1='0',Fishweight2='0',Fishweight3='0',Fishweight4='0',Fishweight5='0' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_fish SET FishID1='-1',FishID2='-1',FishID3='-1',FishID4='-1',FishID5='-1',Fishweight1='0',Fishweight2='0',Fishweight3='0',Fishweight4='0',Fishweight5='0' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_blacklist SET blacklist0='0',blacklistreason0='0',blacklist1='0',blacklistreason1='0',blacklist2='0',blacklistreason2='0',blacklist3='0',blacklistreason3='0',blacklist4='0',blacklistreason4='0',blacklist5='0',blacklistreason5='0',blacklist6='0',blacklistreason6='0',blacklist7='0',blacklistreason7='0',blacklist8='0',blacklistreason8='0',blacklist9='0',blacklistreason9='0',blacklist10='0',blacklistreason10='0',blacklist11='0',blacklistreason11='0',blacklist12='0',blacklistreason12='0',blacklist13='0',blacklistreason13='0',blacklist14='0',blacklistreason14='0',blacklist15='0',blacklistreason15='0',blacklist16='0',blacklistreason16='0',blacklist17='0',blacklistreason17='0',blacklist18='0',blacklistreason18='0' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_blacklist SET blacklist0='0',blacklistreason0='0',blacklist1='0',blacklistreason1='0',blacklist2='0',blacklistreason2='0',blacklist3='0',blacklistreason3='0',blacklist4='0',blacklistreason4='0',blacklist5='0',blacklistreason5='0',blacklist6='0',blacklistreason6='0',blacklist7='0',blacklistreason7='0',blacklist8='0',blacklistreason8='0',blacklist9='0',blacklistreason9='0',blacklist10='0',blacklistreason10='0',blacklist11='0',blacklistreason11='0',blacklist12='0',blacklistreason12='0',blacklist13='0',blacklistreason13='0',blacklist14='0',blacklistreason14='0',blacklist15='0',blacklistreason15='0',blacklist16='0',blacklistreason16='0',blacklist17='0',blacklistreason17='0',blacklist18='0',blacklistreason18='0' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_inventar SET c4='0',materials='0',material_packs='0',lunchpackets='0',navi='1',helm='2',angel='1',angelkoeder='20',repairboxxes='-1',refillgalons='0',koffer='0',zigarrets='10',alcohol='0',ganja='0',kokain='0',opium='0',spice='0',ganjaseats='0',kokainseats='0',opiumseats='0',spiceseats='0',callbook='1',condoms='10',duenger='0' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_inventar SET c4='0',materials='0',material_packs='0',lunchpackets='0',navi='1',helm='2',angel='1',angelkoeder='20',repairboxxes='-1',refillgalons='0',koffer='0',zigarrets='10',alcohol='0',ganja='0',kokain='0',opium='0',spice='0',ganjaseats='0',kokainseats='0',opiumseats='0',spiceseats='0',callbook='1',condoms='10',duenger='0' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_licenses SET car='1',bike='1',roller='1',boat='1',plane='1',helicopter='1',weapon='3',fishing='1',personality='1' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_licenses SET car='1',bike='1',roller='1',boat='1',plane='1',helicopter='1',weapon='3',fishing='1',personality='1' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_banksafe SET safetresor='0',ganja='0',kokain='0',opium='0',spice='0',materials='0',c4='0',lunchpaket='0',matspackete='0',bier='0',zigaretten='0',werkzeugkaesten='0',benzinkanister='0',koeder='0',kondome='0',duenger='0' WHERE Name='Taylor_Swift' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_banksafe SET safetresor='0',ganja='0',kokain='0',opium='0',spice='0',materials='0',c4='0',lunchpaket='0',matspackete='0',bier='0',zigaretten='0',werkzeugkaesten='0',benzinkanister='0',koeder='0',kondome='0',duenger='0' WHERE Name='Taylor_Swift')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.
    [15:29:39] Passing query UPDATE pRP_account_vehicle SET modelid='411',x='916.096130',y='-1231.203369',z='16.703599',a='269.778686',interior='0',world='0',cc1='18',cc2='136',paintjob='-1',vehhp='1000.000000',abgeschlossen='0',t1='0',t2='0',t3='0',t4='0',t5='0',t6='1010',t7='0',t8='1082',t9='0',t10='0',t11='0',t12='0',t13='0',t14='0',angemeldet='1',atime='0',atAnmeldung='0',preis='299999',nummernschild='SA-TS-411',neon='0',motordown='0',tank='66.399902',km='17897',towed='0',towedfreeprice='2000',towedreason='',kganja='0',kkokain='0',kopium='0',kspice='0',kmats='0',klunch='0',kc4='0',kwkanister='0',kkanister='0',handbrake='0' WHERE name='Taylor_Swift' AND slot='0' |
    [15:29:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_vehicle SET modelid='411',x='916.096130',y='-1231.203369',z='16.703599',a='269.778686',interior='0',world='0',cc1='18',cc2='136',paintjob='-1',vehhp='1000.000000',abgeschlossen='0',t1='0',t2='0',t3='0',t4='0',t5='0',t6='1010',t7='0',t8='1082',t9='0',t10='0',t11='0',t12='0',t13='0',t14='0',angemeldet='1',atime='0',atAnmeldung='0',preis='299999',nummernschild='SA-TS-411',neon='0',motordown='0',tank='66.399902',km='17897',towed='0',towedfreeprice='2000',towedreason='',kganja='0',kkokain='0',kopium='0',kspice='0',kmats='0',klunch='0',kc4='0',kwkanister='0',kkanister='0',handbrake='0' WHERE name='Taylor_Swift' AND slot='0')
    [15:29:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [15:29:39] () - Threaded function called.


    MfG

  • Irgendwie scheint das mit strcat etc nicht wirklich gut zu klappen, nachvollziehen warum es nicht klappt kann ich es aber nicht, der würfelt das Query irgendwie durcheinander.
    Versuche es mal so:
    stock SaveAccount(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid) && GetPVarInt(playerid,"Eingeloggt") == 1) //wir überprüfen ob der Spieler überhaupt noch Connected ist und ob er nicht ein NPC ist.
    {
    new query[4000],Float:Pos[3];


    for (new i = 0; i < 13; i++)
    {
    GetPlayerWeaponData(playerid, i, Spieler[playerid][pPlayerWeapon][i], Spieler[playerid][pPlayerWeaponAmmo][i]);
    }
    //GEFIXXT BY SYNTRO!
    GetPlayerPos(playerid,Pos[0],Pos[1],Pos[2]);
    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_main SET Online='0',Tutorial='%d',Admin='%d',Verwarnungen='%d',EventMotor='%d',FLeaderRechte='%d',Fraktion='%d',FraktionsRang='%d',FraktionsURang='%d',FraktionsSperre='%d',FraktionsGehalt='%d',Job='%d',JobWarns='%d',JobSperre='%d',ArbeitslosenGeld='%d',",
    Spieler[playerid][pViewTutorial],Spieler[playerid][pAdmin],Spieler[playerid][pWarns],Spieler[playerid][pEventMotor],Spieler[playerid][pLeader],Spieler[playerid][pFraktion],Spieler[playerid][pFraktRang],Spieler[playerid][pFraktURang],Spieler[playerid][pFraktionSperre],
    Spieler[playerid][pFraktionsGehalt],Spieler[playerid][pJob],Spieler[playerid][JobWarns],Spieler[playerid][pJobSperre],Spieler[playerid][pWorkLess]);
    format(query,sizeof(query),"%sGeschlecht='%d',SpielerAlter='%d',Level='%d',Geld='%d',GWD='%d',ZiviNote='%d',FAbteilung='%d',Bankguthaben='%d',BankPin='%d',WantedSterne='%d',WantedPunkte='%d',Suspects='%d',Wanted_Grund1='%s',Wanted_Grund2='%s',Wanted_Grund3='%s',Wanted_Grund4='%s',Wanted_Grund5='%s',",query
    Spieler[playerid][pSex],Spieler[playerid][pYearsOld],GetPlayerLevel(playerid),GetACMoney(playerid),Spieler[playerid][pGrundwehrdienst],Spieler[playerid][pZiviNote],Spieler[playerid][pFraktABTInvite],Spieler[playerid][pBank],Spieler[playerid][pBankPin],GetPlayerWantedLevel(playerid),Spieler[playerid][pWantedPoints],Spieler[playerid][pSuspectPoints],
    pWantedReason1[playerid],pWantedReason2[playerid],pWantedReason3[playerid],pWantedReason4[playerid],pWantedReason5[playerid]);
    format(query,sizeof(query),"%sCrimes='%d',STVOcrimes='%d',KampfStyle='%d',Handy='%d',Handycoins='%d',HandyStatus='%d',HandyAkku='%f',HandyNummer='%d',Handyflat='%d',Handyflatbuyinbiz='%d',Letzte_X='%f',Letzte_Y='%f',Letzte_Z='%f',Letzte_Interior='%d',Letzte_VirtualWorld='%d',",query,
    Spieler[playerid][pLastSuspects],Spieler[playerid][pSTVOpoints],GetPlayerFightingStyle(playerid),Spieler[playerid][pHandy],Spieler[playerid][pHandyCoins],Spieler[playerid][pHandystate],Spieler[playerid][pHandyakku],Spieler[playerid][pPhonenumber],Spieler[playerid][pHandyFlat],Spieler[playerid][pHandyBuyByBiz],
    Pos[0],Pos[1],Pos[2],GetPlayerInterior(playerid),GetPlayerVirtualWorld(playerid));
    format(query,sizeof(query),"%spSelectHome='%d',HausMieter='%d',Spawn='%d',Hotel='%d',Tod='%d',Tot_X='%f',Tot_Y='%f',Tot_Z='%f',Tot_Interior='%d',Tot_VirtualWorld='%d',TotZeit='%d',Friedhof='%d',FriedhofZeit='%d',ImKnast='%d',KnastZeit='%d',KnastKaution='%d' WHERE Name='%s'",query,
    Spieler[playerid][pSelectHome],Spieler[playerid][pRentHome],Spieler[playerid][pSpawn],Spieler[playerid][pHotel],Spieler[playerid][pDeath],Spieler[playerid][tot_x],Spieler[playerid][tot_y],Spieler[playerid][tot_z],Spieler[playerid][tot_int],Spieler[playerid][tot_world],Spieler[playerid][pDeathTime],Spieler[playerid][pFriedhof],Spieler[playerid][pFriedhofTime],
    Spieler[playerid][pJailed],Spieler[playerid][pJailTime],Spieler[playerid][pKaution],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");


    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_main SET Muted='%d',MuteZeit='%d',ImPrison='%d',PrisonCheckPointsAbgelaufen='%d',PrisonCheckPointsGegeben='%d',Morde='%d',Tode='%d',SkinID='%d',FraktionSkinID='%d',PaintBallKills='%d',PaintBallTode='%d',PaintBallRang='%d',PaintBallBesuche='%d',AngenommeneReports='%d',KopfGeld='%d',",
    Spieler[playerid][pMuted],Spieler[playerid][pMuteTime],Spieler[playerid][pInPrison],Spieler[playerid][pPrisonCPsgelaufen],Spieler[playerid][pPrisonCPsgegeben],Spieler[playerid][pMorde],Spieler[playerid][pTode],Spieler[playerid][pSkin],Spieler[playerid][pFraktSkin],Spieler[playerid][pPBKills],Spieler[playerid][pPBDeaths],
    Spieler[playerid][pPBRang],Spieler[playerid][pPBVisits],Spieler[playerid][Reports],Spieler[playerid][pHeadMoney]);

    format(query,sizeof(query),"%spWantedDeaths='%d',pBuyTickets='%d',pJailedCount='%d',Bankkonto='%d',pArmyPlaneOrder='%d',pArmyHeliOrder='%d',pArmyWaffenOrder='%d',LevelUPKosten='%d',RespectForLevelUp='%d',RespectFromPayday='%d',TimeAfterRegister='%d',",query,
    Spieler[playerid][pWantedDeaths],Spieler[playerid][pBuyTickets],Spieler[playerid][pJailedCount],Spieler[playerid][pBankkonto],Spieler[playerid][pArmyPlaneOrder],Spieler[playerid][pArmyHeliOrder],Spieler[playerid][pArmyWaffenOrder],
    Spieler[playerid][pLevelKosten],Spieler[playerid][pRespektToLevelUp],Spieler[playerid][pRespektFromPayday],Spieler[playerid][pTimeAfterRegister]);

    format(query,sizeof(query),"%sTime4Payday='%d',TimeoutCrashExeorKick='%d',HabGeworben='%d',RpChat='%d',pPremium='%d',GeworbenerSpieler='%s',pScheinSperre='%d',DigiHud='%d',Bonus='%d',Gutschein='%d',pCoins='%d',",query,
    Spieler[playerid][pMinutesAfterPayday],Spieler[playerid][pAntiOfflineFlucht],Spieler[playerid][HatGeworben],Spieler[playerid][RpChat],Spieler[playerid][pPremium],Spieler[playerid][GeworbenPlaya],Spieler[playerid][pScheinSperre],
    Spieler[playerid][DigiHud],Spieler[playerid][pStartbonus],Spieler[playerid][pGutschein],Spieler[playerid][pCoins]);

    format(query,sizeof(query),"%spFirmaLeader='%d',pFirmaMember='%d',pOrgLeader='%d',pOrgMember='%d',pLohn='%d',WaitPerso='%d',pMarried='%s',pBuyClothes='%d',pIll='%d',pConterminatedTime='%d',pBitchSkill='%d',pBitchFuckCount='%d',pMedicHealplayerSkill='%d',pMedicHealCount='%d' WHERE Name='%s'",query,
    Spieler[playerid][pFirmaLeader],Spieler[playerid][pFirmaMember],Spieler[playerid][pOrgLeader],Spieler[playerid][pOrgMember],Spieler[playerid][pLohn],Spieler[playerid][WaitPerso],
    Spieler[playerid][pMarried],Spieler[playerid][pBuyClothes],Spieler[playerid][pIll],Spieler[playerid][pConterminatedTime],Spieler[playerid][pBitchSkill],Spieler[playerid][pBitchFuckCount],Spieler[playerid][pMedicHealplayerSkill],Spieler[playerid][pMedicHealCount],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_weapons SET Waffen0='%d',Waffen1='%d',Waffen2='%d',Waffen3='%d',Waffen4='%d',Waffen5='%d',Waffen6='%d',Waffen7='%d',Waffen8='%d',Waffen9='%d',Waffen10='%d',Waffen11='%d',Waffen12='%d',Ammo0='%d',Ammo1='%d',Ammo2='%d',Ammo3='%d',Ammo4='%d',Ammo5='%d',Ammo6='%d',Ammo7='%d',Ammo8='%d',Ammo9='%d',Ammo10='%d',Ammo11='%d',Ammo12='%d' WHERE Name='%s'",
    Spieler[playerid][pPlayerWeapon][0],Spieler[playerid][pPlayerWeapon][1],Spieler[playerid][pPlayerWeapon][2],Spieler[playerid][pPlayerWeapon][3],Spieler[playerid][pPlayerWeapon][4],Spieler[playerid][pPlayerWeapon][5],Spieler[playerid][pPlayerWeapon][6],
    Spieler[playerid][pPlayerWeapon][7],Spieler[playerid][pPlayerWeapon][8],Spieler[playerid][pPlayerWeapon][9],Spieler[playerid][pPlayerWeapon][10],Spieler[playerid][pPlayerWeapon][11],Spieler[playerid][pPlayerWeapon][12],
    Spieler[playerid][pPlayerWeaponAmmo][0]/2,Spieler[playerid][pPlayerWeaponAmmo][1]/2,Spieler[playerid][pPlayerWeaponAmmo][2]/2,Spieler[playerid][pPlayerWeaponAmmo][3]/2,Spieler[playerid][pPlayerWeaponAmmo][4]/2,Spieler[playerid][pPlayerWeaponAmmo][5]/2,Spieler[playerid][pPlayerWeaponAmmo][6]/2,
    Spieler[playerid][pPlayerWeaponAmmo][7]/2,Spieler[playerid][pPlayerWeaponAmmo][8]/2,Spieler[playerid][pPlayerWeaponAmmo][9]/2,Spieler[playerid][pPlayerWeaponAmmo][10]/2,Spieler[playerid][pPlayerWeaponAmmo][11]/2,Spieler[playerid][pPlayerWeaponAmmo][12]/2,Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_fish SET FishID1='%d',FishID2='%d',FishID3='%d',FishID4='%d',FishID5='%d',Fishweight1='%d',Fishweight2='%d',Fishweight3='%d',Fishweight4='%d',Fishweight5='%d' WHERE Name='%s'",
    Spieler[playerid][pFishID][1],Spieler[playerid][pFishID][2],Spieler[playerid][pFishID][3],Spieler[playerid][pFishID][4],Spieler[playerid][pFishID][5],Spieler[playerid][pFischgewicht][1],Spieler[playerid][pFischgewicht][2],Spieler[playerid][pFischgewicht][3],Spieler[playerid][pFischgewicht][4],Spieler[playerid][pFischgewicht][5],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_koffer SET Slot0='%d',Slot1='%d',Slot2='%d',Slot3='%d',Slot4='%d',Slot5='%d',Slot6='%d',Slot7='%d',Slot8='%d',Slot9='%d',Slot10='%d' WHERE Name='%s'",
    Spieler[playerid][pKofferItems][0],Spieler[playerid][pKofferItems][1],Spieler[playerid][pKofferItems][2],Spieler[playerid][pKofferItems][3],Spieler[playerid][pKofferItems][4],Spieler[playerid][pKofferItems][5],Spieler[playerid][pKofferItems][6],
    Spieler[playerid][pKofferItems][7],Spieler[playerid][pKofferItems][8],Spieler[playerid][pKofferItems][9],Spieler[playerid][pKofferItems][10],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    query = "";
    strcat(query,"UPDATE "#DATENBANKTAG"_account_blacklist SET ");
    for(new fID=0;fID<MAX_FRAKTIONNEN;fID++)
    {
    if(fID > 0) strcat(query,",");
    format(query,sizeof(query),"%sblacklist%i='%d'",query,fID,Spieler[playerid][pBL][fID]);
    strcat(query,",");
    format(query,sizeof(query),"%sblacklistreason%i='%s'",query,fID,pBLReason[playerid][fID]);
    }
    format(query,sizeof(query),"%s WHERE Name='%s'",query,Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_inventar SET c4='%d',materials='%d',material_packs='%d',lunchpackets='%d',navi='%d',helm='%d',angel='%d',angelkoeder='%d',repairboxxes='%d',refillgalons='%d',koffer='%d',zigarrets='%d',alcohol='%d',ganja='%d',kokain='%d',opium='%d',spice='%d',ganjaseats='%d',kokainseats='%d',opiumseats='%d',spiceseats='%d',callbook='%d',condoms='%d',duenger='%d' WHERE Name='%s'",
    Spieler[playerid][pC4],Spieler[playerid][pMaterials],Spieler[playerid][MatsPackete],Spieler[playerid][pLunchpaket],Spieler[playerid][pNavi],Spieler[playerid][pMotorradhelm],Spieler[playerid][pAngel],Spieler[playerid][pAngelKoeder],Spieler[playerid][pRepairVehBoxes],Spieler[playerid][pTankFillBoxes],Spieler[playerid][pKoffer],Spieler[playerid][pZigarets],
    Spieler[playerid][pAlc],Spieler[playerid][pGanja],Spieler[playerid][pKokain],Spieler[playerid][pOpium],Spieler[playerid][pSpice],Spieler[playerid][pGanjaSammen],Spieler[playerid][pKokainSammen],Spieler[playerid][pOpiumSammen],Spieler[playerid][pSpiceSammen],Spieler[playerid][pCallBook],Spieler[playerid][pCondoms],Spieler[playerid][pDuenger],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_licenses SET car='%d',bike='%d',roller='%d',boat='%d',plane='%d',helicopter='%d',weapon='%d',fishing='%d',personality='%d' WHERE Name='%s'",
    Spieler[playerid][pAutoLic],Spieler[playerid][pBikeLic],Spieler[playerid][pRollerLic],Spieler[playerid][pBoatLic],Spieler[playerid][pPlaneLic],Spieler[playerid][pHeliLic],Spieler[playerid][pWaffenLic],Spieler[playerid][pFishingLic],Spieler[playerid][pPersoLic],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_banksafe SET safetresor='%d',ganja='%d',kokain='%d',opium='%d',spice='%d',materials='%d',c4='%d',lunchpaket='%d',matspackete='%d',bier='%d',zigaretten='%d',werkzeugkaesten='%d',benzinkanister='%d',koeder='%d',kondome='%d',duenger='%d' WHERE Name='%s'",
    Spieler[playerid][pBankSafeSafe],Spieler[playerid][pBankSafeGanja],Spieler[playerid][pBankSafeKokain],Spieler[playerid][pBankSafeOpium],Spieler[playerid][pBankSafeSpice],Spieler[playerid][pBankSafeMaterials],Spieler[playerid][pBankSafeC4],
    Spieler[playerid][pBankSafeLunchpaket],Spieler[playerid][pBankSafeMatspackete],Spieler[playerid][pBankSafeAlc],Spieler[playerid][pBankSafeZigarets],Spieler[playerid][pBankSafeRepairVehBoxes],
    Spieler[playerid][pBankSafeTankFillBoxes],Spieler[playerid][pBankSafeAngelkoeder],Spieler[playerid][pBankSafeCondoms],Spieler[playerid][pBankSafeDuenger],Spieler[playerid][pName]);
    mysql_function_query(MySqlConnection,query,false,"","");

    new slot = 0;
    for(;slot<MAX_PLAYER_VEHS;slot++)
    {
    if(!strcmp(Spieler[playerid][pName],Pfahrzeug[slot][playerid][Besitzer],true))
    {
    if(Pfahrzeug[slot][playerid][modelid] != 0)
    {
    GetVehicleHealth(Pfahrzeug[slot][playerid][Vehicle],Pfahrzeug[slot][playerid][HP]);
    format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_vehicle SET modelid='%d',x='%f',y='%f',z='%f',a='%f',interior='%d',world='%d',cc1='%d',cc2='%d',paintjob='%d',vehhp='%f',abgeschlossen='%d',t1='%d',t2='%d',t3='%d',t4='%d',t5='%d',t6='%d',t7='%d',t8='%d',t9='%d',t10='%d',t11='%d',t12='%d',t13='%d',t14='%d',",
    Pfahrzeug[slot][playerid][modelid],Pfahrzeug[slot][playerid][posx],Pfahrzeug[slot][playerid][posy],Pfahrzeug[slot][playerid][posz],Pfahrzeug[slot][playerid][posa],Pfahrzeug[slot][playerid][Interior],Pfahrzeug[slot][playerid][VirtualWorld],Pfahrzeug[slot][playerid][Colour1],Pfahrzeug[slot][playerid][Colour2],
    Pfahrzeug[slot][playerid][Paintjob],Pfahrzeug[slot][playerid][HP],Pfahrzeug[slot][playerid][Abgeschlossen],Pfahrzeug[slot][playerid][Spoiler],Pfahrzeug[slot][playerid][Hood],Pfahrzeug[slot][playerid][Roof],
    Pfahrzeug[slot][playerid][Sideskirt],Pfahrzeug[slot][playerid][Lamps],Pfahrzeug[slot][playerid][Nitro],Pfahrzeug[slot][playerid][Exhaust],Pfahrzeug[slot][playerid][Wheels],Pfahrzeug[slot][playerid][Stereo],
    Pfahrzeug[slot][playerid][Hydraulics],Pfahrzeug[slot][playerid][FrontBumper],Pfahrzeug[slot][playerid][RearBumper],Pfahrzeug[slot][playerid][VentRight],Pfahrzeug[slot][playerid][VentLeft]);

    format(query,sizeof(query),"%sangemeldet='%d',atime='%d',atAnmeldung='%d',preis='%d',nummernschild='%s',neon='%d',motordown='%d',tank='%f',km='%d',towed='%d',towedfreeprice='%d',towedreason='%s',kganja='%d',kkokain='%d',kopium='%d',kspice='%d',kmats='%d',klunch='%d',kc4='%d',",query,
    Pfahrzeug[slot][playerid][Angemeldet],Pfahrzeug[slot][playerid][AnmeldeTime],Pfahrzeug[slot][playerid][AnAnmeldung],Pfahrzeug[slot][playerid][Preis],Pfahrzeug[slot][playerid][Nummernschild],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Neon],
    MotorDown[Pfahrzeug[slot][playerid][Vehicle]],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Tank],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Kilometer],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Abgeschleppt],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][AbgeschlepptPreis],
    vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][AbgeschlepptGrund],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumGanja],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumKokain],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumOpium],
    vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumSpice],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumMaterials],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumLunchpakete],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumC4]);

    format(query,sizeof(query),"%skwkanister='%d',kkanister='%d',handbrake='%d' WHERE name='%s' AND slot='%d'",query,vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumWerkzeugkasten],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][KofferraumBenzinkanister],vFahrzeug[Pfahrzeug[slot][playerid][Vehicle]][Handbremse],Pfahrzeug[slot][playerid][Besitzer],slot);

    mysql_function_query(MySqlConnection,query,false,"","");
    }
    }
    }
    printf("SAVE: %s Account hat gespeichert!",Spieler[playerid][pName]);
    }
    return 1;
    }


  • [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] Passing query UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0',Geschlecht='1',SpielerAlter='0',Level='0',Geld='10000',GWD='0',ZiviNote='0',FAbteilung='0',Bankguthaben='0',BankPin='0',WantedSterne='0',WantedPunkte='0',Suspects='0',Wanted_Grund1='',Wanted_Grund2='',Wanted_Grund3='',Wanted_Grund4='',Wanted_Grund5='',Crimes='0',STVOcrimes='0',KampfStyle='4',Handy='0',Handycoins='0',HandyStatus='0',HandyAkku='0.000000',HandyNummer='0',Handyflat='0',Handyflatbuyinbiz='0',Letzte_X='1128.671264',Letzte_Y='-1599.754760',Letzte_Z='22.855937',Letzte_Interior='0',Letzte_VirtualWorld='0',pSelectHome='0',HausMieter='0',Spawn='0',Hotel='0',Tod='0',Tot_X='0.000000',Tot_Y='0.000000',Tot_Z='0.000000',Tot_Interior='0',Tot_VirtualWorld='0',TotZeit='0',Friedhof='0',FriedhofZeit='0',ImKnast='0',KnastZeit='0',KnastKaution='0' WHERE Name='Taylor_Swift' |
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] >> mysql_query_callback( Connection handle: 1 )
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [19:24:39] OnQueryError() - Called.
    [19:24:39] Passing query UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='71',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='1',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='0',TimeAfterRegister='54652',Time4Payday='751',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',Bonus='1',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pLohn='0',WaitPerso='1449931371',pMarried='Niemand',pBuyClothes='-1',pIll='0',pConterminatedTime='0',pBitchSkill='0',pBitchFuckCount='0',pMedicHealplayerSkill='0',pMedicHealCount='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='71',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='1',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='0',TimeAfterRegister='54652',Time4Payday='751',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',Bonus='1',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pLohn='0',WaitPerso='1449931371',pMarried='Niemand',pBuyClothes='-1',pIll='0',pConterminatedTime='0',pBitchSkill='0',pBitchFuckCount='0',pMedicHealplayerSkill='0',pMedicHealCount='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_weapons SET Waffen0='0',Waffen1='0',Waffen2='0',Waffen3='0',Waffen4='0',Waffen5='0',Waffen6='0',Waffen7='0',Waffen8='0',Waffen9='0',Waffen10='0',Waffen11='0',Waffen12='0',Ammo0='0',Ammo1='0',Ammo2='0',Ammo3='0',Ammo4='0',Ammo5='0',Ammo6='0',Ammo7='0',Ammo8='0',Ammo9='0',Ammo10='0',Ammo11='0',Ammo12='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_weapons SET Waffen0='0',Waffen1='0',Waffen2='0',Waffen3='0',Waffen4='0',Waffen5='0',Waffen6='0',Waffen7='0',Waffen8='0',Waffen9='0',Waffen10='0',Waffen11='0',Waffen12='0',Ammo0='0',Ammo1='0',Ammo2='0',Ammo3='0',Ammo4='0',Ammo5='0',Ammo6='0',Ammo7='0',Ammo8='0',Ammo9='0',Ammo10='0',Ammo11='0',Ammo12='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_fish SET FishID1='-1',FishID2='-1',FishID3='-1',FishID4='-1',FishID5='-1',Fishweight1='0',Fishweight2='0',Fishweight3='0',Fishweight4='0',Fishweight5='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_fish SET FishID1='-1',FishID2='-1',FishID3='-1',FishID4='-1',FishID5='-1',Fishweight1='0',Fishweight2='0',Fishweight3='0',Fishweight4='0',Fishweight5='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_blacklist SET blacklist0='0',blacklistreason0='0',blacklist1='0',blacklistreason1='0',blacklist2='0',blacklistreason2='0',blacklist3='0',blacklistreason3='0',blacklist4='0',blacklistreason4='0',blacklist5='0',blacklistreason5='0',blacklist6='0',blacklistreason6='0',blacklist7='0',blacklistreason7='0',blacklist8='0',blacklistreason8='0',blacklist9='0',blacklistreason9='0',blacklist10='0',blacklistreason10='0',blacklist11='0',blacklistreason11='0',blacklist12='0',blacklistreason12='0',blacklist13='0',blacklistreason13='0',blacklist14='0',blacklistreason14='0',blacklist15='0',blacklistreason15='0',blacklist16='0',blacklistreason16='0',blacklist17='0',blacklistreason17='0',blacklist18='0',blacklistreason18='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_blacklist SET blacklist0='0',blacklistreason0='0',blacklist1='0',blacklistreason1='0',blacklist2='0',blacklistreason2='0',blacklist3='0',blacklistreason3='0',blacklist4='0',blacklistreason4='0',blacklist5='0',blacklistreason5='0',blacklist6='0',blacklistreason6='0',blacklist7='0',blacklistreason7='0',blacklist8='0',blacklistreason8='0',blacklist9='0',blacklistreason9='0',blacklist10='0',blacklistreason10='0',blacklist11='0',blacklistreason11='0',blacklist12='0',blacklistreason12='0',blacklist13='0',blacklistreason13='0',blacklist14='0',blacklistreason14='0',blacklist15='0',blacklistreason15='0',blacklist16='0',blacklistreason16='0',blacklist17='0',blacklistreason17='0',blacklist18='0',blacklistreason18='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_inventar SET c4='0',materials='0',material_packs='0',lunchpackets='0',navi='1',helm='2',angel='1',angelkoeder='20',repairboxxes='-1',refillgalons='0',koffer='0',zigarrets='10',alcohol='0',ganja='0',kokain='0',opium='0',spice='0',ganjaseats='0',kokainseats='0',opiumseats='0',spiceseats='0',callbook='1',condoms='10',duenger='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_inventar SET c4='0',materials='0',material_packs='0',lunchpackets='0',navi='1',helm='2',angel='1',angelkoeder='20',repairboxxes='-1',refillgalons='0',koffer='0',zigarrets='10',alcohol='0',ganja='0',kokain='0',opium='0',spice='0',ganjaseats='0',kokainseats='0',opiumseats='0',spiceseats='0',callbook='1',condoms='10',duenger='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_licenses SET car='1',bike='1',roller='1',boat='1',plane='1',helicopter='1',weapon='3',fishing='1',personality='1' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_licenses SET car='1',bike='1',roller='1',boat='1',plane='1',helicopter='1',weapon='3',fishing='1',personality='1' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_banksafe SET safetresor='0',ganja='0',kokain='0',opium='0',spice='0',materials='0',c4='0',lunchpaket='0',matspackete='0',bier='0',zigaretten='0',werkzeugkaesten='0',benzinkanister='0',koeder='0',kondome='0',duenger='0' WHERE Name='Taylor_Swift' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_banksafe SET safetresor='0',ganja='0',kokain='0',opium='0',spice='0',materials='0',c4='0',lunchpaket='0',matspackete='0',bier='0',zigaretten='0',werkzeugkaesten='0',benzinkanister='0',koeder='0',kondome='0',duenger='0' WHERE Name='Taylor_Swift')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:39] Passing query UPDATE pRP_account_vehicle SET modelid='411',x='916.096130',y='-1231.203369',z='16.703599',a='269.778686',interior='0',world='0',cc1='18',cc2='136',paintjob='-1',vehhp='1000.000000',abgeschlossen='0',t1='0',t2='0',t3='0',t4='0',t5='0',t6='1010',t7='0',t8='1082',t9='0',t10='0',t11='0',t12='0',t13='0',t14='0',angemeldet='1',atime='0',atAnmeldung='0',preis='299999',nummernschild='SA-TS-411',neon='0',motordown='0',tank='66.399902',km='17897',towed='0',towedfreeprice='2000',towedreason='',kganja='0',kkokain='0',kopium='0',kspice='0',kmats='0',klunch='0',kc4='0',kwkanister='0',kkanister='0',handbrake='0' WHERE name='Taylor_Swift' AND slot='0' |
    [19:24:39] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_vehicle SET modelid='411',x='916.096130',y='-1231.203369',z='16.703599',a='269.778686',interior='0',world='0',cc1='18',cc2='136',paintjob='-1',vehhp='1000.000000',abgeschlossen='0',t1='0',t2='0',t3='0',t4='0',t5='0',t6='1010',t7='0',t8='1082',t9='0',t10='0',t11='0',t12='0',t13='0',t14='0',angemeldet='1',atime='0',atAnmeldung='0',preis='299999',nummernschild='SA-TS-411',neon='0',motordown='0',tank='66.399902',km='17897',towed='0',towedfreeprice='2000',towedreason='',kganja='0',kkokain='0',kopium='0',kspice='0',kmats='0',klunch='0',kc4='0',kwkanister='0',kkanister='0',handbrake='0' WHERE name='Taylor_Swift' AND slot='0')
    [19:24:39] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:39] () - Threaded function called.
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] Passing query DELETE FROM onlines WHERE ID = '0' |
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] ProcessQueryThread() - Query was successful. (DELETE FROM onlines WHERE ID = '0')
    [19:24:40] >> mysql_query_callback( Connection handle: 1 )
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0',Geschlecht='1',SpielerAlter='0',Level='0',Geld='10000',GWD='0',ZiviNote='0',FAbteilung='0',Bankguthaben='0',BankPin='0',WantedSterne='0',WantedPunkte='0',Suspects='0',Wanted_Grund1='',Wanted_Grund2='',Wanted_Grund3='',Wanted_Grund4='',Wanted_Grund5='',Crimes='0',STVOcrimes='0',KampfStyle='4',Handy='0',Handycoins='0',HandyStatus='0',HandyAkku='0.000000',HandyNummer='0',Handyflat='0',Handyflatbuyinbiz='0',Letzte_X='1128.671264',Letzte_Y='-1599.754760',Letzte_Z='22.855937',Letzte_Interior='0',Letzte_VirtualWorld='0',pSelectHome='0',HausMieter='0',Spawn='0',Hotel='0',Tod='0',Tot_X='0.000000',Tot_Y='0.000000',Tot_Z='0.000000',Tot_Interior='0',Tot_VirtualWorld='0',TotZeit='0',Friedhof='0',FriedhofZeit='0',ImKnast='0',KnastZeit='0',KnastKaution='0' WHERE Name='Taylor_Swift' |
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
    [19:24:40] OnQueryError() - Called.
    [19:24:40] Passing query UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='71',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='1',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='0',TimeAfterRegister='54653',Time4Payday='752',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',Bonus='1',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pLohn='0',WaitPerso='1449931371',pMarried='Niemand',pBuyClothes='-1',pIll='0',pConterminatedTime='0',pBitchSkill='0',pBitchFuckCount='0',pMedicHealplayerSkill='0',pMedicHealCount='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='1',FraktionSkinID='71',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='1',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='1',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='1',LevelUPKosten='12000',RespectForLevelUp='45',RespectFromPayday='0',TimeAfterRegister='54653',Time4Payday='752',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',Bonus='1',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pLohn='0',WaitPerso='1449931371',pMarried='Niemand',pBuyClothes='-1',pIll='0',pConterminatedTime='0',pBitchSkill='0',pBitchFuckCount='0',pMedicHealplayerSkill='0',pMedicHealCount='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_weapons SET Waffen0='0',Waffen1='0',Waffen2='0',Waffen3='0',Waffen4='0',Waffen5='0',Waffen6='0',Waffen7='0',Waffen8='0',Waffen9='0',Waffen10='0',Waffen11='0',Waffen12='0',Ammo0='0',Ammo1='0',Ammo2='0',Ammo3='0',Ammo4='0',Ammo5='0',Ammo6='0',Ammo7='0',Ammo8='0',Ammo9='0',Ammo10='0',Ammo11='0',Ammo12='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_weapons SET Waffen0='0',Waffen1='0',Waffen2='0',Waffen3='0',Waffen4='0',Waffen5='0',Waffen6='0',Waffen7='0',Waffen8='0',Waffen9='0',Waffen10='0',Waffen11='0',Waffen12='0',Ammo0='0',Ammo1='0',Ammo2='0',Ammo3='0',Ammo4='0',Ammo5='0',Ammo6='0',Ammo7='0',Ammo8='0',Ammo9='0',Ammo10='0',Ammo11='0',Ammo12='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_fish SET FishID1='-1',FishID2='-1',FishID3='-1',FishID4='-1',FishID5='-1',Fishweight1='0',Fishweight2='0',Fishweight3='0',Fishweight4='0',Fishweight5='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_fish SET FishID1='-1',FishID2='-1',FishID3='-1',FishID4='-1',FishID5='-1',Fishweight1='0',Fishweight2='0',Fishweight3='0',Fishweight4='0',Fishweight5='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_blacklist SET blacklist0='0',blacklistreason0='0',blacklist1='0',blacklistreason1='0',blacklist2='0',blacklistreason2='0',blacklist3='0',blacklistreason3='0',blacklist4='0',blacklistreason4='0',blacklist5='0',blacklistreason5='0',blacklist6='0',blacklistreason6='0',blacklist7='0',blacklistreason7='0',blacklist8='0',blacklistreason8='0',blacklist9='0',blacklistreason9='0',blacklist10='0',blacklistreason10='0',blacklist11='0',blacklistreason11='0',blacklist12='0',blacklistreason12='0',blacklist13='0',blacklistreason13='0',blacklist14='0',blacklistreason14='0',blacklist15='0',blacklistreason15='0',blacklist16='0',blacklistreason16='0',blacklist17='0',blacklistreason17='0',blacklist18='0',blacklistreason18='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_blacklist SET blacklist0='0',blacklistreason0='0',blacklist1='0',blacklistreason1='0',blacklist2='0',blacklistreason2='0',blacklist3='0',blacklistreason3='0',blacklist4='0',blacklistreason4='0',blacklist5='0',blacklistreason5='0',blacklist6='0',blacklistreason6='0',blacklist7='0',blacklistreason7='0',blacklist8='0',blacklistreason8='0',blacklist9='0',blacklistreason9='0',blacklist10='0',blacklistreason10='0',blacklist11='0',blacklistreason11='0',blacklist12='0',blacklistreason12='0',blacklist13='0',blacklistreason13='0',blacklist14='0',blacklistreason14='0',blacklist15='0',blacklistreason15='0',blacklist16='0',blacklistreason16='0',blacklist17='0',blacklistreason17='0',blacklist18='0',blacklistreason18='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_inventar SET c4='0',materials='0',material_packs='0',lunchpackets='0',navi='1',helm='2',angel='1',angelkoeder='20',repairboxxes='-1',refillgalons='0',koffer='0',zigarrets='10',alcohol='0',ganja='0',kokain='0',opium='0',spice='0',ganjaseats='0',kokainseats='0',opiumseats='0',spiceseats='0',callbook='1',condoms='10',duenger='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_inventar SET c4='0',materials='0',material_packs='0',lunchpackets='0',navi='1',helm='2',angel='1',angelkoeder='20',repairboxxes='-1',refillgalons='0',koffer='0',zigarrets='10',alcohol='0',ganja='0',kokain='0',opium='0',spice='0',ganjaseats='0',kokainseats='0',opiumseats='0',spiceseats='0',callbook='1',condoms='10',duenger='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_licenses SET car='1',bike='1',roller='1',boat='1',plane='1',helicopter='1',weapon='3',fishing='1',personality='1' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_licenses SET car='1',bike='1',roller='1',boat='1',plane='1',helicopter='1',weapon='3',fishing='1',personality='1' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_banksafe SET safetresor='0',ganja='0',kokain='0',opium='0',spice='0',materials='0',c4='0',lunchpaket='0',matspackete='0',bier='0',zigaretten='0',werkzeugkaesten='0',benzinkanister='0',koeder='0',kondome='0',duenger='0' WHERE Name='Taylor_Swift' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_banksafe SET safetresor='0',ganja='0',kokain='0',opium='0',spice='0',materials='0',c4='0',lunchpaket='0',matspackete='0',bier='0',zigaretten='0',werkzeugkaesten='0',benzinkanister='0',koeder='0',kondome='0',duenger='0' WHERE Name='Taylor_Swift')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.
    [19:24:40] Passing query UPDATE pRP_account_vehicle SET modelid='411',x='916.096130',y='-1231.203369',z='16.703599',a='269.778686',interior='0',world='0',cc1='18',cc2='136',paintjob='-1',vehhp='1000.000000',abgeschlossen='0',t1='0',t2='0',t3='0',t4='0',t5='0',t6='1010',t7='0',t8='1082',t9='0',t10='0',t11='0',t12='0',t13='0',t14='0',angemeldet='1',atime='0',atAnmeldung='0',preis='299999',nummernschild='SA-TS-411',neon='0',motordown='0',tank='66.399902',km='17897',towed='0',towedfreeprice='2000',towedreason='',kganja='0',kkokain='0',kopium='0',kspice='0',kmats='0',klunch='0',kc4='0',kwkanister='0',kkanister='0',handbrake='0' WHERE name='Taylor_Swift' AND slot='0' |
    [19:24:40] ProcessQueryThread() - Query was successful. (UPDATE pRP_account_vehicle SET modelid='411',x='916.096130',y='-1231.203369',z='16.703599',a='269.778686',interior='0',world='0',cc1='18',cc2='136',paintjob='-1',vehhp='1000.000000',abgeschlossen='0',t1='0',t2='0',t3='0',t4='0',t5='0',t6='1010',t7='0',t8='1082',t9='0',t10='0',t11='0',t12='0',t13='0',t14='0',angemeldet='1',atime='0',atAnmeldung='0',preis='299999',nummernschild='SA-TS-411',neon='0',motordown='0',tank='66.399902',km='17897',towed='0',towedfreeprice='2000',towedreason='',kganja='0',kkokain='0',kopium='0',kspice='0',kmats='0',klunch='0',kc4='0',kwkanister='0',kkanister='0',handbrake='0' WHERE name='Taylor_Swift' AND slot='0')
    [19:24:40] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
    [19:24:40] () - Threaded function called.


    MfG

  • Also der einzige Fehler liegt hier:

    SQL
    UPDATE pRP_account_main SET Online='0',Tutorial='1',Admin='7',Verwarnungen='0',EventMotor='0',FLeaderRechte='0',Fraktion='0',FraktionsRang='0',FraktionsURang='0',FraktionsSperre='0',FraktionsGehalt='0',Job='0',JobWarns='0',JobSperre='0',ArbeitslosenGeld='0',Geschlecht='1',SpielerAlter='0',Level='0',Geld='10000',GWD='0',ZiviNote='0',FAbteilung='0',Bankguthaben='0',BankPin='0',WantedSterne='0',WantedPunkte='0',Suspects='0',Wanted_Grund1='',Wanted_Grund2='',Wanted_Grund3='',Wanted_Grund4='',Wanted_Grund5='',Crimes='0',STVOcrimes='0',KampfStyle='4',Handy='0',Handycoins='0',HandyStatus='0',HandyAkku='0.000000',HandyNummer='0',Handyflat='0',Handyflatbuyinbiz='0',Letzte_X='1128.671264',Letzte_Y='-1599.754760',Letzte_Z='22.855937',Letzte_Interior='0',Letzte_VirtualWorld='0',pSelectHome='0',HausMieter='0',Spawn='0',Hotel='0',Tod='0',Tot_X='0.000000',Tot_Y='0.000000',Tot_Z='0.000000',Tot_Interior='0',Tot_VirtualWorld='0',TotZeit='0',Friedhof='0',FriedhofZeit='0',ImKnast='0',KnastZeit='0',KnastKaution='0' WHERE Name='Taylor_Swift'

    Allerdings ist die Syntax korrekt.


    Füge diesen Code mal in deiner Datenbank im phpMyAdmin-SQL-Fenster ein, und schaue, was dir für ein Fehler ausgegeben wird. Möglicherweise fehlt eine der angegebenen Spalten in der Datenbank.

  • Hey,
    In der MySQL-Tabelle fehlte "EventMotor"
    Funktioniert jetzt


    Aber eine Frage hab ich noch:
    CreateDynamicObject(2780, 2465.7588,-1690.2830,13.5115, -1, -1, -1, 1000.0);
    Wenn das so im Script steht wieso wird das dann erst kurz bevor ich an der stelle gestreamt?


    MfG

  • do.de - Domain-Offensive - Domains für alle und zu super Preisen