Beiträge von Studs

    In der Log Datei steht doch, wieso es scheitert, hast dir das eigentlich mal angeschaut? ^^


    SQL
    [08/25/18 14:09:56] [DEBUG] retrieved and pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115',  `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '1' WHERE `Username` = 'Tstuser01gg''
    [08/25/18 14:09:56] [ERROR] error #1054 while executing query "UPDATE `user` SET  `Gun7` = '0', `Gun8` = '0', `Gun9` = '0', `Gun10` = '0', `Gun11` = '0', `Gun12` = '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 `Ùsername` = 'Tstuser01gg'": Unknown column 'Ùsername' in 'where clause'

    Etwas stimmt mit deinem String, wo du den Spielernamen speicherst.
    Und du solltest deine %d überprüfen, da scheint ein Fehler zu sein...


    Bin mal alle %d s durchgegangen, konnte da jz aber nichts entdecken.



    Hab mal nen string anstatt eines enums genommen beim namen speichern, gucke jz nochmal alle logs durch

    Unterlasse doch bitte vollzitate

    Aufruf...

    ..ja das sage ich seid 3 Posts...printe das doch einfach mal und prüfe es dadurch ^^

    [14:09:59] [debug] Server crashed due to an unknown error
    [14:09:59] [debug] Native backtrace:
    [14:09:59] [debug] #0 004016eb in ?? () from samp-server.exe
    [14:09:59] [debug] #1 61ca35e9 in ?? () from plugins\mysql.dll
    [14:09:59] [debug] #2 61ca6688 in ?? () from plugins\mysql.dll
    [14:09:59] [debug] #3 61c8c52e in ?? () from plugins\mysql.dll
    [14:09:59] [debug] #4 61c8dc7f in ?? () from plugins\mysql.dll
    [14:09:59] [debug] #5 61c8e3d3 in ?? () from plugins\mysql.dll
    [14:09:59] [debug] #6 00469a66 in ?? () from samp-server.exe
    [14:09:59] [debug] #7 0048d4db in ?? () from samp-server.exe
    [14:09:59] [debug] #8 0049b4a1 in ?? () from samp-server.exe
    [14:09:59] [debug] #9 0049b4b1 in ?? () from samp-server.exe
    [14:09:59] [debug] Registers:
    [14:09:59] [debug] EAX: 057ba660 EBX: 00000000 ECX: 057ce020 EDX: 00000008
    [14:09:59] [debug] ESI: 00000038 EDI: ffffd8c1 EBP: 0049b4a1 ESP: 0019fe98
    [14:09:59] [debug] EIP: 0049b4b1 EFLAGS: 00010246
    [14:09:59] [debug] Stack:
    [14:09:59] [debug] ESP+00000000: 004ab4a0 0019ff70 004ab0e1 ffffffff
    [14:09:59] [debug] ESP+00000020: 00000094 00000006 00000002 000023f0
    [14:09:59] [debug] ESP+00000040: 00000000 00000000 00000000 00000000
    [14:09:59] [debug] ESP+00000060: 00000000 00000000 00000000 00000000
    [14:09:59] [debug] ESP+00000080: 00000000 00000000 00000000 00000000
    [14:09:59] [debug] ESP+000000a0: 00000000 00000000 00000000 00000000
    [14:09:59] [debug] ESP+000000c0: 00000000 00000000 c0000005 00000000
    [14:09:59] [debug] ESP+000000e0: 004ba530 00000000 0019ff94 77378674
    [14:09:59] [debug] ESP+00000100: 77ec5d87 003a2000 2154297d 00000000
    [14:09:59] [debug] ESP+00000120: 00000000 00000000 2154297d 0019ffa0
    [14:09:59] [debug] ESP+00000140: 00000000 0019ffec 77ec5d57 ffffffff
    [14:09:59] [debug] ESP+00000160: 003a2000 00000000 78746341 00000020
    [14:09:59] [debug] ESP+00000180: 00000020 00000000 00000014 00000001
    [14:09:59] [debug] ESP+000001a0: 00000000 00000000 00000000 00000000
    [14:09:59] [debug] ESP+000001c0: 00000044 000002e0 0000025c 00000000
    [14:09:59] [debug] ESP+000001e0: 00000342 00000000 2d59495b 000008cc
    [14:09:59] [debug] ESP+00000200: 32ceeacd 00000bfc 00000042 00000c40
    [14:09:59] [debug] ESP+00000220: 0000005e 00000fd0 00000362 00000000
    [14:09:59] [debug] ESP+00000240: 00000392 00000010 00000009 000000ec
    [14:09:59] [debug] ESP+00000260: 00000001 00000002 00001758 000007a0
    [14:09:59] [debug] ESP+00000280: 00000001 00000004 00002d84 00000314
    [14:09:59] [debug] ESP+000002a0: 00000002 00000006 00003130 000000cc
    [14:09:59] [debug] ESP+000002c0: 00000001 00000009 000032ec 00000028
    [14:09:59] [debug] ESP+000002e0: 00000001 64487353 0000002c 00000001
    [14:09:59] [debug] ESP+00000300: 00000001 000015a4 0000002c 0000005e
    [14:09:59] [debug] ESP+00000320: 00000000 00000000 00000000 00000000
    [14:09:59] [debug] ESP+00000340: 00000038 00000000 003a0043 0057005c
    [14:09:59] [debug] ESP+00000360: 006e0069 00780053 005c0073 00000000
    [14:09:59] [debug] ESP+00000380: 0000025c 00000001 f33271ba 000003c0
    [14:09:59] [debug] ESP+000003a0: 2d59495b 00000750 00000032 00000784
    [14:09:59] [debug] ESP+000003c0: 00000042 00000ac4 00000330 00000004
    [14:09:59] [debug] ESP+000003e0: 00000362 00000005 b1280544 000011b8
    [14:09:59] [debug] Loaded modules:
    [14:09:59] [debug] 00400000 - 00519000 samp-server.exe
    [14:09:59] [debug] 77e60000 - 77fec000 ntdll.dll
    [14:09:59] [debug] 77360000 - 77430000 KERNEL32.DLL
    [14:09:59] [debug] 76790000 - 76968000 KERNELBASE.dll
    [14:09:59] [debug] 744e0000 - 75814000 SHELL32.dll
    [14:09:59] [debug] 77c00000 - 77cbd000 msvcrt.dll
    [14:09:59] [debug] 76f50000 - 76f88000 cfgmgr32.dll
    [14:09:59] [debug] 76d80000 - 76e97000 ucrtbase.dll
    [14:09:59] [debug] 77b60000 - 77be8000 shcore.dll
    [14:09:59] [debug] 75c70000 - 75d2e000 RPCRT4.dll
    [14:09:59] [debug] 75bc0000 - 75be0000 SspiCli.dll
    [14:09:59] [debug] 75bb0000 - 75bba000 CRYPTBASE.dll
    [14:09:59] [debug] 770e0000 - 77137000 bcryptPrimitives.dll
    [14:09:59] [debug] 76ea0000 - 76ee3000 sechost.dll
    [14:09:59] [debug] 76970000 - 76bb6000 combase.dll
    [14:09:59] [debug] 761c0000 - 76784000 windows.storage.dll
    [14:09:59] [debug] 76d00000 - 76d78000 advapi32.dll
    [14:09:59] [debug] 76c10000 - 76c55000 shlwapi.dll
    [14:09:59] [debug] 77190000 - 771b2000 GDI32.dll
    [14:09:59] [debug] 77540000 - 7769f000 gdi32full.dll
    [14:09:59] [debug] 774c0000 - 7753c000 msvcp_win.dll
    [14:09:59] [debug] 77cc0000 - 77e35000 USER32.dll
    [14:09:59] [debug] 77430000 - 77446000 win32u.dll
    [14:09:59] [debug] 77bf0000 - 77bfe000 kernel.appcore.dll
    [14:09:59] [debug] 77140000 - 77185000 powrprof.dll
    [14:09:59] [debug] 77e40000 - 77e54000 profapi.dll
    [14:09:59] [debug] 73420000 - 73444000 WINMM.dll
    [14:09:59] [debug] 75af0000 - 75af8000 WSOCK32.dll
    [14:09:59] [debug] 77450000 - 774b6000 WS2_32.dll
    [14:09:59] [debug] 71fc0000 - 71fe3000 winmmbase.dll
    [14:09:59] [debug] 77330000 - 77355000 IMM32.DLL
    [14:09:59] [debug] 75a90000 - 75ae1000 crashdetect.dll
    [14:09:59] [debug] 74230000 - 742ef000 MSVCR100.dll
    [14:09:59] [debug] 74190000 - 741f9000 MSVCP100.dll
    [14:09:59] [debug] 61c80000 - 61cce000 mysql.dll
    [14:09:59] [debug] 75940000 - 759ac000 MSVCP140.dll
    [14:09:59] [debug] 75a20000 - 75a34000 VCRUNTIME140.dll
    [14:09:59] [debug] 6aae0000 - 6aafa000 log-core.dll
    [14:09:59] [debug] 5ea70000 - 5eb3d000 libmariadb.dll
    [14:09:59] [debug] 75fb0000 - 76132000 CRYPT32.dll
    [14:09:59] [debug] 770d0000 - 770de000 MSASN1.dll
    [14:09:59] [debug] 73d40000 - 73d4a000 Secur32.dll
    [14:09:59] [debug] 75a00000 - 75a11000 napinsp.dll
    [14:09:59] [debug] 759e0000 - 759f6000 pnrpnsp.dll
    [14:09:59] [debug] 74200000 - 74213000 NLAapi.dll
    [14:09:59] [debug] 73470000 - 734c5000 mswsock.dll
    [14:09:59] [debug] 71c10000 - 71ca4000 DNSAPI.dll
    [14:09:59] [debug] 75d50000 - 75d57000 NSI.dll
    [14:09:59] [debug] 71d10000 - 71d40000 IPHLPAPI.DLL
    [14:09:59] [debug] 75a70000 - 75a7c000 winrnr.dll
    [14:09:59] [debug] 70290000 - 70298000 rasadhlp.dll
    [14:09:59] [debug] 61c10000 - 61c77000 streamer.dll
    [14:09:59] [debug] 10000000 - 1000f000 sscanf.dll
    [14:09:59] [debug] 70320000 - 7036e000 fwpuclnt.dll


    [14:09:59] [debug] 72cb0000 - 72cc9000 bcrypt.dll












    forward OnSaveUserCheck2(playerid);
    public OnSaveUserCheck2(playerid)
    {
    SendClientMessage(playerid,-1,"der erste abgerufen.");
    printf("der erste abgerufen");
    return 1;
    }
    forward OnSaveUserCheck3(playerid);
    public OnSaveUserCheck3(playerid)
    {
    SendClientMessage(playerid,-1,"der zweite abgerufen.");
    printf("der zweite abgerufen");
    return 1;
    }



    hm jetzt ist er gecrasht










    Lol ?


    Wurde abgerufen
    Wurde abgerufen
    Wurde abgerufen
    Wurde abgerufen
    der erste abgerufen
    der zweite abgerufen



    anscheinend sind das doch nicht die schwarzen schafe





    // EDIT:


    der zweite abgerufen
    der dritte abgerufen
    der vierte abgerufen
    der fuenfte abgerufen
    der siebte abgerufen
    der achte abgerufen



    Alles in korrekter reihenfolge 3 mal kontrolliert und nichts wird doppelt abgerufen laut script

    Brauchst du nicht, es reicht ja, wenn du noch ein print jeweils zu dem Aufruft packst :)


    Denn ich glaube, der letzte Codeblock, wo du die letzten beiden Querys drinnen hast, wird einfach nicht aufgerufen.

    Aufruft ? Was ist das xD


    // edit aso habs im falschen kontext verstanden xD


    Aber kannste das nochmal genau erklären, bin noch nicht so im scripten drinne xD


    Ja glaube auch, denke mal die letzten beide

    Keine Ahnung, was du da machst, wo sind denn die prints dazu?
    Und bei dem letzten hast du das query auskommentiert, da kann also nichts kommen und bei dem anderen, wird dieser Codeblock denn überhaupt aufgerufen?!

    forward OnSaveUserCheck(playerid);
    public OnSaveUserCheck(playerid)
    {
    SendClientMessage(playerid,-1,"Wurde abgerufen.");
    printf("Wurde abgerufen");
    return 1;
    }


    Kann damit nicht genau bestimmen wer abgerufen wird, wer nicht,


    kann ich aber mal kurz machen mit 8 publics für jeden einen.


    //mysql_pquery(handle, query); >> Hab nur das hier auskommentiert damit ich gucken kann obs überhaupt abgerufen wird
    mysql_pquery(handle, query, "OnSaveUserCheck", "d", playerid); > Das nehme ich an der stelle

    Ok hab ich geändert, aber die letzten 2 werden ja trotzdem nicht geladen :/ Kriege nur 6 "wurde abgerufen" nachrichten

    Dann lade mal das crashdetect Plugin, das sagt dir dann genau, wieso er gecrasht ist :)


    Kann man machen, aber ich denke 512 hätten fürs Erste auch gereicht ^^


    mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `CarTime` = '%d', `PayDay` = '%d', `PayDaysHad` = '%d', `CDPlayer` = '%d', `Wins` = '%d', `Loses` = '%d', `AlcoholPerk` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `TraderPerk` = '%d', `Tutorial` = '%d', `Warnings` = '%d', `pAdjustable` = '%d',`FuelKanister` = '%d', `WantedLevel` = '%d', `SpawnChange` = '%d' WHERE `Username` = '%e'",
    PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk], PlayerInfo[playerid][pTut],
    PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pFuel], WantedLevel[playerid], SpawnChange[playerid], PlayerInfo[playerid][PlayerName]);
    //mysql_pquery(handle, query);
    mysql_pquery(handle, query, "OnSaveUserCheck", "d", playerid);



    crasher ? = mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `PlayMinutes` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `Offflucht` = '%d', `Uhr` = '%d', `Handy` = '%d', `Perso` = '%d', `FrakSperre` = '%d' WHERE `id` = '%d'",
    PlayerInfo[playerid][pPlayMinutes], PlayerInfo[playerid][pMinutesSinceAn], PlayerInfo[playerid][pSFPASS], PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid], PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pOwnPerso], PlayerInfo[playerid][pFrakSperre], PlayerInfo[playerid][p_id]);


    // mysql_pquery(handle, query);






    Danke schonmal dafür mit 512 klappts und 6/8 werden aufgerufen


    Hab beim ersten mal id auf Username umgeändert, dann lädt er auch nicht,


    wenn ich jedoch beim letzten id auf Username ändere crasht der server beim verlassen. / oder lädt einfach nicht wie der erste


    LOG:


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [13:26:26] filterscripts = "" (string)
    [13:26:26]
    [13:26:26] Server Plugins
    [13:26:26] --------------
    [13:26:26] Loading plugin: crashdetect.dll
    [13:26:26] CrashDetect plugin 4.19.1
    [13:26:26] Loaded.
    [13:26:26] Loading plugin: mysql.dll
    [13:26:26] >> plugin.mysql: R41-4 successfully loaded.
    [13:26:26] Loaded.
    [13:26:26] Loading plugin: streamer.dll
    [13:26:26]


    *** Streamer Plugin v2.9.3 by Incognito loaded ***


    [13:26:26] Loaded.
    [13:26:26] Loading plugin: sscanf.dll
    [13:26:26]


    [13:26:26] ===============================


    [13:26:26] sscanf plugin loaded.


    [13:26:26] Version: 2.8.2


    [13:26:26] (c) 2012 Alex "Y_Less" Cole


    [13:26:26] ===============================


    [13:26:26] Loaded.
    [13:26:26] Loaded 4 plugins.


    [13:26:26]
    [13:26:26] Ban list
    [13:26:26] --------
    [13:26:26] Loaded: samp.ban
    [13:26:26]
    [13:26:26]
    [13:26:26] Filterscripts
    [13:26:26] ---------------
    [13:26:26] Loaded 0 filterscripts.


    [13:26:26] [MySQL] Verbindungsaufbau...
    [13:26:26] [MySQL] Die Verbindung zur Datenbank wurde erfolgreich hergestellt! Handle: 1
    [13:26:26] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
    [13:26:26] Pickups Max = 2048, Current Pickups = 298
    [13:26:26] _______________________________________
    [13:26:26] Das Script wurde Vollständig geladen!
    [13:26:26] German Reallife: LS/SF/LV
    [13:26:26] _______________________________________
    [13:26:26]
    [13:26:26] Number of vehicle models: 83
    [13:26:43] [connection] 127.0.0.1:55041 requests connection cookie.
    [13:26:44] [connection] incoming connection: 127.0.0.1:55041 id: 0
    [13:26:48] [join] Testuser01 has joined the server (0:127.0.0.1)
    [13:27:03] [chat] [Testuser01]: fertig
    [13:27:03] [debug] Run time error 4: "Array index out of bounds"
    [13:27:03] [debug] Attempted to read/write array element at index 65535 in array of size 1000
    [13:27:03] [debug] AMX backtrace:
    [13:27:03] [debug] #0 00020c3c in public OnPlayerDeath (0, 65535, 255) from gfl.amx
    [13:27:03] [death] Testuser01 died 255
    [13:27:16] [part] Testuser01 has left the server (0:1)
    [13:27:16] Wurde abgerufen
    [13:27:16] Wurde abgerufen
    [13:27:16] Wurde abgerufen
    [13:27:16] Wurde abgerufen
    [13:27:16] Wurde abgerufen
    [13:27:16] Wurde abgerufen



    [part] osfsofxdggg has left the server (0:1)
    Wurde abgerufen
    Wurde abgerufen
    Wurde abgerufen
    Wurde abgerufen
    Wurde abgerufen
    Wurde abgerufen













    MYSQL LOG:

    [08/25/18 13:00:17] [DEBUG] mysql_format(1, 0x0643AB8C, 128, "SELECT id FROM user WHERE Username = '%e'")[08/25/18 13:00:17] [DEBUG] CHandle::EscapeString(this=0x261e058, src='skskgb')[08/25/18 13:00:17] [DEBUG] CConnection::EscapeString(src='skskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:17] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'skskgb'[08/25/18 13:00:17] [DEBUG] mysql_format: return value: '45'[08/25/18 13:00:17] [DEBUG] mysql_pquery(1, "SELECT id FROM user WHERE Username = 'skskgb'", "OnUserCheck", "d")[08/25/18 13:00:17] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnUserCheck', format='d', params=0x643ab74, param_offset=5)[08/25/18 13:00:17] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 179[08/25/18 13:00:17] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:17] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:17] [INFO] Callback 'OnUserCheck' set up for delayed execution.[08/25/18 13:00:17] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:17] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2650518)[08/25/18 13:00:17] [DEBUG] CConnectionPool::Queue(query=0x2650518, this=0x261a438)[08/25/18 13:00:17] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:17] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:17] [DEBUG] CConnection::Execute(query=0x2650518, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:17] [DEBUG] CQuery::Execute(this=0x2650518, connection=0x26373d0)[08/25/18 13:00:17] [INFO] query "SELECT id FROM user WHERE Username = 'skskgb'" successfully executed within 14.925 milliseconds[08/25/18 13:00:17] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='SELECT id FROM user WHERE Username = 'skskgb'')[08/25/18 13:00:17] [DEBUG] created new resultset '0x2650c98'[08/25/18 13:00:17] [DEBUG] fetched MySQL result '0x2654da8'[08/25/18 13:00:17] [DEBUG] allocated 0 bytes for PAWN result[08/25/18 13:00:17] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=179, num_params=1)[08/25/18 13:00:17] [INFO] Executing callback 'OnUserCheck' with 1 parameter...[08/25/18 13:00:17] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:17] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:17] [DEBUG] executing AMX callback with index '179'[08/25/18 13:00:17] [DEBUG] cache_get_row_count(0x0643AF8C)[08/25/18 13:00:17] [DEBUG] cache_get_row_count: return value: '1'[08/25/18 13:00:17] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:17] [INFO] Callback successfully executed.[08/25/18 13:00:18] [DEBUG] mysql_format(1, 0x0643A6C0, 256, "INSERT INTO `user` (`Username`, `Key`) VALUES ('%e', MD5('%e'))")[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString(this=0x261e058, src='skskgb')[08/25/18 13:00:18] [DEBUG] CConnection::EscapeString(src='skskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'skskgb'[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString(this=0x261e058, src='zensiert')[08/25/18 13:00:18] [DEBUG] CConnection::EscapeString(src='zensiert', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:18] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'zensiert'[08/25/18 13:00:18] [DEBUG] mysql_format: return value: '71'[08/25/18 13:00:18] [DEBUG] mysql_pquery(1, "INSERT INTO `user` (`Username`, `Key`) VALUES ('skskgb', MD5('zensiert'))", "OnUserRegister", "d")[08/25/18 13:00:18] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnUserRegister', format='d', params=0x643a6a8, param_offset=5)[08/25/18 13:00:18] [DEBUG] CCallback::Create - callback index for 'OnUserRegister': 181[08/25/18 13:00:18] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:18] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:18] [INFO] Callback 'OnUserRegister' set up for delayed execution.[08/25/18 13:00:18] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:18] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2650518)[08/25/18 13:00:18] [DEBUG] CConnectionPool::Queue(query=0x2650518, this=0x261a438)[08/25/18 13:00:18] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:18] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:18] [DEBUG] CConnection::Execute(query=0x2650518, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:18] [DEBUG] CQuery::Execute(this=0x2650518, connection=0x26411d8)[08/25/18 13:00:19] [INFO] query "INSERT INTO `user` (`Username`, `Key`) VALUES ('skskgb', MD5('ficken'))" successfully executed within 448.236 milliseconds[08/25/18 13:00:19] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='INSERT INTO `user` (`Username`, `Key`) VALUES ('skskgb', MD5('ficken'))')[08/25/18 13:00:19] [DEBUG] created new resultset '0x2650678'[08/25/18 13:00:19] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:19] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=181, num_params=1)[08/25/18 13:00:19] [INFO] Executing callback 'OnUserRegister' with 1 parameter...[08/25/18 13:00:19] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:19] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:19] [DEBUG] executing AMX callback with index '181'[08/25/18 13:00:19] [DEBUG] cache_insert_id()[08/25/18 13:00:19] [DEBUG] cache_insert_id: return value: '12'[08/25/18 13:00:19] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:19] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Level` = '%d', `Money` = '%d', `AdminLevel` = '%d', `DonateRank` = '%d', `UpgradePoint` = '%d', `Registered` = '%d', `Sex` = '%d', `Age` = '%d', `OriginHerkunft` = '%d', `Muted` = '%d', `Bank` = '%d', `Deaths` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString(this=0x261e058, src='sskgb')[08/25/18 13:00:51] [DEBUG] CConnection::EscapeString(src='sskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'sskgb'[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '255'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x26163e0)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x26163e0, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Arrested` = '%d', `Kills` = '%d', `WantedDeaths` = '%d',`Phonebook` = '%d', `LottoNr` = '%d', `Fishes` = '%d', `Job` = '%d', `pPayCheck` = '%d', `Jailed` = '%d',`JailTime` = '%d', `Materials` = '%d', `Drugs` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x26163e0, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString(this=0x261e058, src='sskgb')[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x26163e0, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CConnection::EscapeString(src='sskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'sskgb'[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '250'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654cf0)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654cf0, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654cf0, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654cf0, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Leader` = '%d', `Member` = '%d', `Rank` = '%d', `pChar` = '%d', `ContractTime` = '%d', `DetSkill` = '%d', `SexSkill` = '%d', `BoxSkill` = '%d', `LawSkill` = '%d', `MechSkill` = '%d', `JackSkill` = '%d', `CarSkill` = '%d', `NewsSkill` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654d88)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654d88, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `NewsSkill` = '%d', `DrugsSkill` = '%d', `CookSkill` = '%d', `pHealth` = '%f', `IntInt` = '%d', `Local` = '%d', `PhoneNr` = '%d', `House` = '%d', `Bizz` = '%d', `HandyGeld` = '%d', `Pos_x` = '%f', `Pos_y` = '%f', `Pos_z` = '%f', `CarLic` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654830)[08/25/18 13:00:51] [ERROR] error #1054 while executing query "UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb'": Unknown column 'UpgradePoint' in 'field list'[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654830, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CConnection::GetError(this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654d88, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654d88, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `NewLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d', `FishLic` = '%d', `GunLic` = '%d', `LKWLic` = '%d', `Zig` = '%d', `Zigsucht` = '%d', `Gun1` = '%d', `Gun2` = '%d', `Gun3` = '%d', `Gun4` = '%d', `Gun5` = '%d', `Gun6` = '%d' WHERE `Username` = '%e'")[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString(this=0x261e058, src='sskgb')[08/25/18 13:00:51] [DEBUG] CConnection::EscapeString(src='sskgb', this=0x2619f78, connection=0x25f33f0)[08/25/18 13:00:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'sskgb'[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654960)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654960, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `Gun7` = '%d', `Gun8` = '%d', `Gun9` = '%d', `Gun10` = '%d', `Gun11` = '%d', `Gun12` = '%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 `Ùsername` = '%e'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.875 milliseconds[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] created new resultset '0x265a128'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x2654240)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x2654240, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654830, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654830, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `CarTime` = '%d', `PayDay` = '%d', `PayDaysHad` = '%d', `CDPlayer` = '%d', `Wins` = '%d', `Loses` = '%d', `AlcoholPerk` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `TraderPerk` = '%d', `Tutorial` = '%d', `Warnings` = '%d', `pAdjustable` = '%d',`FuelKanister` = '%d', `WantedLevel` = '%d', `SpawnChange` = '%d' WHERE `id` = '%d'")[08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '0'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x26542d8)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x26542d8, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] mysql_format(1, 0x0643A8B0, 256, "UPDATE `user` SET `PlayMinutes` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `Offflucht` = '%d', `Uhr` = '%d', `Handy` = '%d', `Perso` = '%d', `FrakSperre` = '%d' WHERE `id` = '%d'")[08/25/18 13:00:51] [DEBUG] mysql_format: return value: '194'[08/25/18 13:00:51] [DEBUG] mysql_pquery(1, "UPDATE `user` SET `PlayMinutes` = '0', `MinutesSinceAn` = '0', `SFPASS` = '0', `LVPASS` = '0', `Offflucht` = '0', `Uhr` = '0', `Handy` = '0', `Perso` = '0', `FrakSperre` = '0' WHERE `id` = '12'", "OnSaveUserCheck", "d")[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnSaveUserCheck', format='d', params=0x643a898, param_offset=5)[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnSaveUserCheck': 178[08/25/18 13:00:51] [DEBUG] processing specifier 'd' with parameter index 0[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '0'[08/25/18 13:00:51] [INFO] Callback 'OnSaveUserCheck' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 1 parameter[08/25/18 13:00:51] [DEBUG] CHandle::Execute(this=0x261e058, type=2, query=0x26544a0)[08/25/18 13:00:51] [DEBUG] CConnectionPool::Queue(query=0x26544a0, this=0x261a438)[08/25/18 13:00:51] [DEBUG] CHandle::Execute - return value: true[08/25/18 13:00:51] [DEBUG] mysql_pquery: return value: '1'[08/25/18 13:00:51] [DEBUG] CCallback::Create(amx=0x4a877d0, name='OnQueryError', format='dsssd)[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.841 milliseconds[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.948 milliseconds[08/25/18 13:00:51] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10046[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] processing specifier 'd'[08/25/18 13:00:51] [DEBUG] created new resultset '0x265a208'[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '1054'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] created new resultset '0x2650c28'[08/25/18 13:00:51] [DEBUG] processing specifier 's'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value 'Unknown column 'UpgradePoint' in 'field list''[08/25/18 13:00:51] [DEBUG] processing specifier 's'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value 'OnSaveUserCheck'[08/25/18 13:00:51] [DEBUG] processing specifier 's'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb''[08/25/18 13:00:51] [DEBUG] processing specifier 'd'[08/25/18 13:00:51] [DEBUG] retrieved and pushed value '1'[08/25/18 13:00:51] [INFO] Callback 'OnQueryError' set up for delayed execution.[08/25/18 13:00:51] [DEBUG] created delayed callback with 5 parameters[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=-10046, num_params=5)[08/25/18 13:00:51] [INFO] Executing callback '"ª4' with 5 parameters...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '1' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 's'[08/25/18 13:00:51] [DEBUG] pushed value 'UPDATE `user` SET `Level` = '1', `Money` = '115', `AdminLevel` = '0', `DonateRank` = '0', `UpgradePoint` = '0', `Registered` = '1', `Sex` = '1', `Age` = '27', `OriginHerkunft` = '1', `Muted` = '0', `Bank` = '0', `Deaths` = '2' WHERE `Username` = 'sskgb'' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 's'[08/25/18 13:00:51] [DEBUG] pushed value 'OnSaveUserCheck' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 's'[08/25/18 13:00:51] [DEBUG] pushed value 'Unknown column 'UpgradePoint' in 'field list'' onto AMX stack[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '1054' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '-10046'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654240, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x2654960, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654240, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x2654960, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 15.38 milliseconds[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 15.55 milliseconds[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] created new resultset '0x26509f8'[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] created new resultset '0x265a0f0'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x26542d8, this=0x675c020, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x26542d8, connection=0x26373d0)[08/25/18 13:00:51] [DEBUG] CConnection::Execute(query=0x26544a0, this=0x6921020, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CQuery::Execute(this=0x26544a0, connection=0x26411d8)[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] query "UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'" successfully executed within 14.737 milliseconds[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] CResultSet::Create(connection=0x26373d0, query_str='UPDATE `user` SET `Arrested` = '0', `Kills` = '0', `WantedDeaths` = '0',`Phonebook` = '0', `LottoNr` = '0', `Fishes` = '0', `Job` = '0', `pPayCheck` = '0', `Jailed` = '0',`JailTime` = '0', `Materials` = '0', `Drugs` = '0' WHERE `Username` = 'sskgb'')[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] created new resultset '0x26508a8'[08/25/18 13:00:51] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:51] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:51] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:51] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:51] [DEBUG] pushed value '0' onto AMX stack[08/25/18 13:00:51] [DEBUG] executing AMX callback with index '178'[08/25/18 13:00:51] [DEBUG] AMX callback executed with error '0'[08/25/18 13:00:51] [INFO] Callback successfully executed.[08/25/18 13:00:52] [INFO] query "UPDATE `user` SET `PlayMinutes` = '0', `MinutesSinceAn` = '0', `SFPASS` = '0', `LVPASS` = '0', `Offflucht` = '0', `Uhr` = '0', `Handy` = '0', `Perso` = '0', `FrakSperre` = '0' WHERE `id` = '12'" successfully executed within 299.301 milliseconds[08/25/18 13:00:52] [DEBUG] CResultSet::Create(connection=0x26411d8, query_str='UPDATE `user` SET `PlayMinutes` = '0', `MinutesSinceAn` = '0', `SFPASS` = '0', `LVPASS` = '0', `Offflucht` = '0', `Uhr` = '0', `Handy` = '0', `Perso` = '0', `FrakSperre` = '0' WHERE `id` = '12'')[08/25/18 13:00:52] [DEBUG] created new resultset '0x265a080'[08/25/18 13:00:52] [DEBUG] fetched MySQL result '0x0'[08/25/18 13:00:52] [DEBUG] CCallback::Execute(amx=0x4a877d0, index=178, num_params=1)[08/25/18 13:00:52] [INFO] Executing callback 'OnSaveUserCheck' with 1 parameter...[08/25/18 13:00:52] [DEBUG] processing internal specifier 'c'[08/25/18 13:00:52] [DEBUG] pushed value '0' onto AMX stack


    [08/25/18 13:00:51] [ERROR] mysql_format: destination size '256' is too small


    So das ist der mysql log


    Hab den string query mal auf 1000 gesetzt (kp ob das so möglich ist, danach war es aber nicht mehr zu klein)


    der server ist dann abgestürzt nachdem ich ihn velrassen habe,


    jetzt mit 256 ist aber anscheinend auch zu klein.



    Was kann ich tun?


    mysql_pquery(handle, query, "OnSaveUserCheck", "d", playerid);
    mysql_format(handle, query, sizeof(query), "UPDATE `user` SET `PlayMinutes` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `Offflucht` = '%d', `Uhr` = '%d', `Handy` = '%d', `Perso` = '%d', `FrakSperre` = '%d' WHERE `id` = '%d'",


    PlayerInfo[playerid][pPlayMinutes], PlayerInfo[playerid][pMinutesSinceAn], PlayerInfo[playerid][pSFPASS], PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid], PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pOwnPerso], PlayerInfo[playerid][pFrakSperre], PlayerInfo[playerid][p_id]);


    forward OnSaveUserCheck(playerid);public OnSaveUserCheck(playerid){SendClientMessage(playerid,-1,"Wurde abgerufen.");printf("Wurde abgerufen");return 1;}


    Irgendwas ist da falsch, hab mit OnSaveUserCheck geprüft ob der Public überhaupt abgerufen wird,



    wird er aber nicht. Keine Ahnung was ich noch tun kann.


    Nutze die allerneuste mysql version

    Vielen DanIch auch nicht wirklich, ist halt die Wantedanzahl die bei "aktuelles wantedlevel" angezeigt wird wenn man den befehl /su ausführt & der andere einfach nur um die aktuelle wantedanzahl per format anzeigen zu lassen.

    Vielen Dank!


    Hab auch noch eine andere Zeile gefunden wo das verdoppelt wurde und rausgenommen,


    jetzt funktioniert alles, danke dir !

    Externer Inhalt www.youtube.com
    Inhalte von externen Seiten werden ohne Ihre Zustimmung nicht automatisch geladen und angezeigt.
    Durch die Aktivierung der externen Inhalte erklären Sie sich damit einverstanden, dass personenbezogene Daten an Drittplattformen übermittelt werden. Mehr Informationen dazu haben wir in unserer Datenschutzerklärung zur Verfügung gestellt.

    Was genau hat das jetzt zu bedeuten? Ich erkenne daran nichts.


    Kannst du machen, ich weiß allerdings nicht, ob ich heute noch dazu komme, mir es anzuschauen.

    Ich auch nicht wirklich, ist halt die Wantedanzahl die bei "aktuelles wantedlevel" angezeigt wird wenn man den befehl /su ausführt & der andere einfach nur um die aktuelle wantedanzahl per format anzeigen zu lassen.

    Der Unterschied zwischen Datei und Server kann sich natürlich dadurch erklären, dass der Wert noch nicht fort geschrieben wurde. Da ich den Code nicht kenne, kann ich das aber nicht genau sagen.


    Printf nutzt du so:
    printf("Wanted Level: %d", WantedLevel[pid]);

    Ah okay danke
    Das ist jetzt aus der log.


    Wanted Level bei aktuelles Wantedlevel: 1140850719
    Wanted Level su: 1140850719



    Würde es dir was ausmachen wenn ich dir das script schicken würde?


    Ist nur ein bisschen edtiertes loh script

    Dann liegt die Vermutung nahe, dass an dieser Stelle der Wert nochmal aufaddiert wird.
    Prüfe, wo du überall in die Variable schreibst, setze gegebenenfalls Prints hin, und prüfe dabei, an welcher Stelle sich der Wert verdoppelt.
    Anhand dessen, weißt du dann, woran es liegt und kannst den Code entsprechend anpassen, oder hier posten.


    Okay also in der Datei steht


    WantedLevel=204800


    Bei /Wanted und Aktulles Wantedlevel steht jedoch was anderes (zur gleichen zeit)


    https://www.pic-upload.de/view-35816136/wtds.png.html
    Es wurden immer 50 wtds vergeben.


    Wie genau kann ich diese Befehle beispielsweise WantedLevel[pid] = WantedLevel[pid]+wid;


    denn loggen per printf(geschrieben)

    Wird es denn schon falsch in die Datenbank/Datei gespeichert, oder was steht dort drin, wenn du den Server beendet hast (ohne ihn zu starten)?

    Genau wenn der Server neustartet, habe gerade geguckt genau beim gmx serverneustart gehts von 400 auf 800 wtds.



    EDIT: Wenn ich den server beende passiert nix wantedzahl bleibt gleich nur beim neustart anscheinend verdoppelt


    Ist übrigens eine Datei.

    ocmd:suse(playerid,params[])
    {
    if(gPlayerLogged[playerid] == 0)
    {
    SendClientMessage(playerid, COLOR_GREY, " Du bist noch nicht Eingeloggt !");
    return 1;
    }
    if(IsACop(playerid))
    {
    new pid,wid,reason[64];
    if(sscanf(params,"uis[256]",pid,wid,reason))return SendClientMessage(playerid, COLOR_GRAD2, "BENUTZUNG: (/su)spect [playerid/Name] [Verbrechen]");
    if(IsPlayerConnected(playerid))
    {
    if(OnDuty[playerid] != 1 && PlayerInfo[playerid][pMember] == 1)
    {
    SendClientMessage(playerid, COLOR_GREY, " Du bist nicht im Dienst !");
    return 1;
    }
    if(IsACop(pid)) return SendClientMessage(playerid,-1,"Du kannst keinen Polizisten anklagen!");
    if(!IsPlayerConnected(playerid)) return SendClientMessage(playerid,-1,"Der Spieler ist nicht Online!");
    if(gPlayerLogged[pid] == 0)
    {
    SendClientMessage(pid, COLOR_GREY, " Der Spieler ist noch nicht Eingeloggt !");
    return 1;
    }
    if(wid < 1 || wid > 99) return SendClientMessage(playerid,-1,"Du kannst nicht unter 1 oder höher als 99 Wanteds vergeben!");
    if(WantedLevel[pid] > 99) return SendClientMessage(playerid,-1,"Du kannst keinem Spieler über 99 Wanteds geben!");
    WantedLevel[pid] = WantedLevel[pid]+wid;
    SetPlayerCriminal(pid,playerid, reason);
    SetPVarInt(playerid,"Vergabe",wid);
    return 1;
    // PlayerInfo[playerid][pWantedPoints]=PlayerInfo[playerid][pWantedPoints]+wid;
    }
    }
    return 1;
    }


    public SetPlayerCriminal(playerid,declare,reason[])
    {
    if(IsPlayerConnected(playerid))
    {
    PlayerInfo[playerid][pCrimes] += 1;
    new vergabes = GetPVarInt(playerid,"Vergabe");
    new turned[MAX_PLAYER_NAME];
    new turner[MAX_PLAYER_NAME];
    new turnmes[128];
    new wantedmes[128];
    strmid(PlayerCrime[playerid][pAccusedof], reason, 0, strlen(reason), 255);
    GetPlayerName(playerid, turned, sizeof(turned));
    if (declare == 255)
    {
    format(turner, sizeof(turner), "Unbekannt");
    strmid(PlayerCrime[playerid][pVictim], turner, 0, strlen(turner), 255);
    }
    else
    {
    if(IsPlayerConnected(declare))
    {
    GetPlayerName(declare, turner, sizeof(turner));
    strmid(PlayerCrime[playerid][pVictim], turner, 0, strlen(turner), 255);
    strmid(PlayerCrime[declare][pBplayer], turned, 0, strlen(turned), 255);
    strmid(PlayerCrime[declare][pAccusing], reason, 0, strlen(reason), 255);
    }
    }
    format(turnmes, sizeof(turnmes), "Du hast ein Verbrechen begangen ( %s ). Reporter: %s.",reason,turner);
    SendClientMessage(playerid, COLOR_LIGHTRED, turnmes);
    format(wantedmes, sizeof(wantedmes), "Momentanes Wantedlevel: %d", WantedLevel[playerid]);
    SendClientMessage(playerid, COLOR_YELLOW, wantedmes);
    format(wantedmes, sizeof(wantedmes), "Momentanes Wantedleveld: %d", WantedLevel[playerid]);
    SendClientMessage(playerid, COLOR_YELLOW, wantedmes);
    for(new i = 0; i < MAX_PLAYERS; i++)
    {
    if(IsPlayerConnected(i))
    {
    if(IsACop(i))
    {
    format(cbjstore, sizeof(turnmes), "HQ: Alle Einheiten: Reporter: %s",turner);
    SendClientMessage(i, TEAM_BLUE_COLOR, cbjstore);
    format(cbjstore, sizeof(turnmes), "HQ: Verbrechen: %s, Gesuchter: %s",reason,turned);
    SendClientMessage(i, TEAM_BLUE_COLOR, cbjstore);
    format(cbjstore, sizeof(turnmes), "HQ: Vergebene Wanteds: %d, Aktulles Wantedlevel: %d",vergabes,WantedLevel[playerid]);
    SendClientMessage(i, TEAM_BLUE_COLOR, cbjstore);
    }
    }
    }
    //


    }//not connected vergabes
    }


    Ich gebe beispielsweise jemandem 50 Wanteds, nach einem serverneustart hat dieser aber einfach 200 Wanteds?


    Weiß da nicht genau wo ich suchen soll, hab bereits einiges ausprobiert wie
    if(sscanf(params,"uis[",pid,wid,reason))return SendClientMessage(playerid, COLOR_GRAD2, "BENUTZUNG: (/su)spect [playerid/Name] [Verbrechen]");


    auf


    if(sscanf(params,"uis[256]",pid,wid,reason))return SendClientMessage(playerid, COLOR_GRAD2, "BENUTZUNG: (/su)spect [playerid/Name] [Verbrechen]");



    zu ändern, hat schonmal die sscanf warnings "sscanf warning: Strings without a length are deprecated, please add a destination size."



    gefixt aber das andere nicht. Wenn die Wantedanzahl über die 1000 geht, verdoppelt sich die anzahl auch manchmal einfach obwohl nur 50 vergeben wurde (von 1000 auf 2000)


    Und du hast schon wieder bewiesen, was für ein Schwachkopf du bist.




    "Mein Gott wieso kann man nicht einfach Autoreifen dahin mappen ohne sich Stundenlang gedanken darüber zu machen,


    ob man das in echt auch machen würde..."



    Das hast du wohl überlesen.


    Danke, ja hab ich schon vorher editiert


    http://forum.sa-mp.com/showthread.php?t=467261



    So ne kleine Anzeige oben Rechts wo Knastzeit: x Sekunden steht und dann immer runterzählt bis 0.


    Wie genau kann ich das dann noch machen?