besitzer = 0 in der Datenbank sieht irgendwie falsch aus, meinst du nicht? 
Da ist wohl beim Speichern oder der ID Zuweisung was schief gelaufen...
Carsystem MySQL
- RaPTiiC
- Geschlossen
- Erledigt
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
-
-
-
aber besitzer wurder doch als INT gespeichert
Ja, aber 1 wäre glaube ich richtig und nicht 0.
-
-
Da musst du den Fehler suchen.
Entweder bei der Zuweisung oder bei der Speicherung...printe es halt mal oder zeig uns mal deinen MySQL Log.
(Den aktivierst du indem du unter OnGameModeInit mysql_log(ALL); eingibst)
-
- Bitte nutze kein MD5 beim Passwort, da kannst du es eig schon gleich bleiben lassen...Zudem steht dein Passwort jetzt hier in Klartext...(Hash Verfahren genauer erklärt)
- Das Select query ist nun richtig, aber ich sehe kein Insert query. Lösche nochmal die Sachen aus der Tabelle und mache das von Neu.
- Lösche jetzt die Log Datei, damit sie gleich frisch erstellt wird.
Zeige dann nochmal den Log.
-
Was soll ich den als Verschlüsselung nutzen hab das halt von Jeffry genommen
und wie würde ich das denn jetzt noch ändern (ist es einfach und fix oder recht schwer)?ZitatDas Select query ist nun richtig, aber ich sehe kein Insert query. Lösche nochmal die Sachen aus der Tabelle und mache das von Neu.
Was genau soll ich jetzt in der Tabelle aus der DB löschen (die beiden Fahrzeuge)?
-
Alles anzeigen
Was soll ich den als Verschlüsselung nutzen hab das halt von Jeffry genommen
und wie würde ich das denn jetzt noch ändern (ist es einfach und fix oder recht schwer)?Was genau soll ich jetzt in der Tabelle aus der DB löschen (die beiden Fahrzeuge)?
-
Was soll ich den als Verschlüsselung nutzen hab das halt von Jeffry genommen
und wie würde ich das denn jetzt noch ändern (ist es einfach und fix oder recht schwer)?1. Ist das keine Verschlüsselung, lies dir meinen Beitrag (den ich doch eben verlinkt habe) dazu mal durch.
2. Jeffry solltest das Tutorial mal in dieser Hinsicht updaten, das wirklich keine gute Idee, das so zu gestalten.
Was genau soll ich jetzt in der Tabelle aus der DB löschen (die beiden Fahrzeuge)?
Exakt.
-
-
Habe beide Fahrzeuge aus der Datenbank gelöscht, Habe den MySQL log gecleart, habe den Server gestartet habe den Befehl /createcar [playerid] [vID] eingegeben daraufhin habe ich mich ausgeloggt erneut eingeloggt Fahrzeug stand dort, habe einen gmx gemacht Fahrzeug weg
Code: MySQL Log
Alles anzeigen[23:53:25] [INFO] changed log level from 'warning, error' to 'debug, info, warning, error' [23:53:25] [DEBUG] mysql_connect("127.0.0.1", "root", "*****", "samp_db", 0) [23:53:25] [DEBUG] CHandleManager::Create(this=0x589638, host='127.0.0.1', user='root', pass='****', db='samp_db', options=0x580c48) [23:53:25] [INFO] Creating new connection handle... [23:53:25] [WARNING] mysql_connect: no password specified [23:53:25] [DEBUG] CConnection::CConnection(this=0x58a858, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:53:25] [DEBUG] CConnection::CConnection - new connection = 0x5617b0 [23:53:25] [DEBUG] CConnection::CConnection(this=0x3987020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:53:25] [DEBUG] CConnection::CConnection - new connection = 0x5a1be0 [23:53:25] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3987020, connection=0x3987020) [23:53:25] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x3987020, connection=0x3987020) [23:53:25] [DEBUG] CConnectionPool::CConnectionPool(size=2, this=0x58a3d8) [23:53:25] [DEBUG] CConnection::CConnection(this=0x3b5c020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:53:25] [DEBUG] CConnection::CConnection - new connection = 0x5acf10 [23:53:25] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3b5c020, connection=0x3b5c020) [23:53:25] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x3b5c020, connection=0x3b5c020) [23:53:25] [DEBUG] CConnection::CConnection(this=0x3d2b020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:53:25] [DEBUG] CConnection::CConnection - new connection = 0x5b64c0 [23:53:25] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3d2b020, connection=0x3d2b020) [23:53:25] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x3d2b020, connection=0x3d2b020) [23:53:25] [INFO] Connection handle with id '1' successfully created. [23:53:25] [DEBUG] CHandleManager::Create - new handle = 0x561098 [23:53:25] [DEBUG] mysql_connect: return value: '1' [23:53:25] [DEBUG] mysql_errno(1) [23:53:25] [DEBUG] CHandle::GetErrorId(this=0x561098) [23:53:25] [DEBUG] CConnection::GetError(this=0x58a858, connection=0x5617b0) [23:53:25] [DEBUG] CHandle::GetErrorId - return value: true, error id: '0', error msg: '' [23:53:25] [DEBUG] mysql_errno: return value: '0' [23:53:51] [DEBUG] mysql_format(1, 0x02C1014C, 128, "SELECT id FROM users WHERE name = '%e'") [23:53:51] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin_West') [23:53:51] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a858, connection=0x5617b0) [23:53:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:53:51] [DEBUG] mysql_format: return value: '47' [23:53:51] [DEBUG] mysql_pquery(1, "SELECT id FROM users WHERE name = 'Dustin_West'", "OnUserCheck", "d") [23:53:51] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserCheck', format='d', params=0x2c10134, param_offset=5) [23:53:51] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 33 [23:53:51] [DEBUG] processing specifier 'd' with parameter index 0 [23:53:51] [DEBUG] retrieved and pushed value '0' [23:53:51] [INFO] Callback 'OnUserCheck' set up for delayed execution. [23:53:51] [DEBUG] created delayed callback with 1 parameter [23:53:51] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x598b40) [23:53:51] [DEBUG] CConnectionPool::Queue(query=0x598b40, this=0x58a3d8) [23:53:51] [DEBUG] CHandle::Execute - return value: true [23:53:51] [DEBUG] mysql_pquery: return value: '1' [23:53:51] [DEBUG] CConnection::Execute(query=0x598b40, this=0x3b5c020, connection=0x5acf10) [23:53:51] [DEBUG] CQuery::Execute(this=0x598b40, connection=0x5acf10) [23:53:51] [INFO] query "SELECT id FROM users WHERE name = 'Dustin_West'" successfully executed within 0.302 milliseconds [23:53:51] [DEBUG] CResultSet::Create(connection=0x5acf10, query_str='SELECT id FROM users WHERE name = 'Dustin_West'') [23:53:51] [DEBUG] created new resultset '0x594aa8' [23:53:51] [DEBUG] fetched MySQL result '0x5c4f80' [23:53:51] [DEBUG] allocated 20 bytes for PAWN result [23:53:51] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=33, num_params=1) [23:53:51] [INFO] Executing callback 'OnUserCheck' with 1 parameter... [23:53:51] [DEBUG] processing internal specifier 'c' [23:53:51] [DEBUG] pushed value '0' onto AMX stack [23:53:51] [DEBUG] executing AMX callback with index '33' [23:53:51] [DEBUG] cache_get_row_count(0x02C1034C) [23:53:51] [DEBUG] cache_get_row_count: return value: '1' [23:53:51] [DEBUG] AMX callback executed with error '0' [23:53:51] [INFO] Callback successfully executed. [23:53:53] [DEBUG] mysql_format(1, 0x02C0FF40, 256, "SELECT * FROM users WHERE name = '%e' AND password = MD5('%e')") [23:53:53] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin_West') [23:53:53] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a858, connection=0x5617b0) [23:53:53] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:53:53] [DEBUG] CHandle::EscapeString(this=0x561098, src='´Dustin') [23:53:53] [DEBUG] CConnection::EscapeString(src='´Dustin', this=0x58a858, connection=0x5617b0) [23:53:53] [DEBUG] CHandle::EscapeString - return value: true, escaped string: '´Dustin' [23:53:53] [DEBUG] mysql_format: return value: '76' [23:53:53] [DEBUG] mysql_pquery(1, "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('´Dustin')", "OnUserLogin", "d") [23:53:53] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserLogin', format='d', params=0x2c0ff28, param_offset=5) [23:53:53] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 34 [23:53:53] [DEBUG] processing specifier 'd' with parameter index 0 [23:53:53] [DEBUG] retrieved and pushed value '0' [23:53:53] [INFO] Callback 'OnUserLogin' set up for delayed execution. [23:53:53] [DEBUG] created delayed callback with 1 parameter [23:53:53] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x598718) [23:53:53] [DEBUG] CConnectionPool::Queue(query=0x598718, this=0x58a3d8) [23:53:53] [DEBUG] CHandle::Execute - return value: true [23:53:53] [DEBUG] mysql_pquery: return value: '1' [23:53:53] [DEBUG] CConnection::Execute(query=0x598718, this=0x3d2b020, connection=0x5b64c0) [23:53:53] [DEBUG] CQuery::Execute(this=0x598718, connection=0x5b64c0) [23:53:53] [INFO] query "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('´Dustin')" successfully executed within 0.277 milliseconds [23:53:53] [DEBUG] CResultSet::Create(connection=0x5b64c0, query_str='SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('´Dustin')') [23:53:53] [DEBUG] created new resultset '0x594ed0' [23:53:53] [DEBUG] fetched MySQL result '0x592970' [23:53:53] [DEBUG] allocated 0 bytes for PAWN result [23:53:53] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=34, num_params=1) [23:53:53] [INFO] Executing callback 'OnUserLogin' with 1 parameter... [23:53:53] [DEBUG] processing internal specifier 'c' [23:53:53] [DEBUG] pushed value '0' onto AMX stack [23:53:53] [DEBUG] executing AMX callback with index '34' [23:53:53] [DEBUG] cache_get_row_count(0x02C1034C) [23:53:53] [DEBUG] cache_get_row_count: return value: '1' [23:53:53] [DEBUG] AMX callback executed with error '0' [23:53:53] [INFO] Callback successfully executed. [23:53:55] [DEBUG] mysql_format(1, 0x02C0FF40, 256, "SELECT * FROM users WHERE name = '%e' AND password = MD5('%e')") [23:53:55] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin_West') [23:53:55] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a858, connection=0x5617b0) [23:53:55] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:53:55] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin') [23:53:55] [DEBUG] CConnection::EscapeString(src='Dustin', this=0x58a858, connection=0x5617b0) [23:53:55] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin' [23:53:55] [DEBUG] mysql_format: return value: '75' [23:53:55] [DEBUG] mysql_pquery(1, "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')", "OnUserLogin", "d") [23:53:55] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserLogin', format='d', params=0x2c0ff28, param_offset=5) [23:53:55] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 34 [23:53:55] [DEBUG] processing specifier 'd' with parameter index 0 [23:53:55] [DEBUG] retrieved and pushed value '0' [23:53:55] [INFO] Callback 'OnUserLogin' set up for delayed execution. [23:53:55] [DEBUG] created delayed callback with 1 parameter [23:53:55] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x5984b8) [23:53:55] [DEBUG] CConnectionPool::Queue(query=0x5984b8, this=0x58a3d8) [23:53:55] [DEBUG] CHandle::Execute - return value: true [23:53:55] [DEBUG] mysql_pquery: return value: '1' [23:53:55] [DEBUG] CConnection::Execute(query=0x5984b8, this=0x3b5c020, connection=0x5acf10) [23:53:55] [DEBUG] CQuery::Execute(this=0x5984b8, connection=0x5acf10) [23:53:55] [INFO] query "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')" successfully executed within 0.306 milliseconds [23:53:55] [DEBUG] CResultSet::Create(connection=0x5acf10, query_str='SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')') [23:53:55] [DEBUG] created new resultset '0x594e60' [23:53:55] [DEBUG] fetched MySQL result '0x592c18' [23:53:55] [DEBUG] allocated 124 bytes for PAWN result [23:53:55] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=34, num_params=1) [23:53:55] [INFO] Executing callback 'OnUserLogin' with 1 parameter... [23:53:55] [DEBUG] processing internal specifier 'c' [23:53:55] [DEBUG] pushed value '0' onto AMX stack [23:53:55] [DEBUG] executing AMX callback with index '34' [23:53:55] [DEBUG] cache_get_row_count(0x02C1034C) [23:53:55] [DEBUG] cache_get_row_count: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "id", 0x02BCD32C) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '1' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "level", 0x02BCD394) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '20' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "money", 0x02BCD3A8) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '30000' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "kills", 0x02BCD3AC) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "deaths", 0x02BCD3B4) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "adminlevel", 0x02BCD398) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '3' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "fraktion", 0x02BCD39C) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "rang", 0x02BCD3A0) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '6' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] cache_get_value_name_int(0, "spawnchange", 0x02BCD3A4) [23:53:55] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:53:55] [DEBUG] cache_get_value_name_int: return value: '1' [23:53:55] [DEBUG] mysql_format(1, 0x02C1001C, 200, "SELECT * FROM autos WHERE besitzer=%d") [23:53:55] [DEBUG] mysql_format: return value: '36' [23:53:55] [DEBUG] mysql_tquery(1, "SELECT * FROM autos WHERE besitzer=1", "OnPlayerCarsLoad", "i") [23:53:55] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnPlayerCarsLoad', format='i', params=0x2c10004, param_offset=5) [23:53:55] [DEBUG] CCallback::Create - callback index for 'OnPlayerCarsLoad': 5 [23:53:55] [DEBUG] processing specifier 'i' with parameter index 0 [23:53:55] [DEBUG] retrieved and pushed value '0' [23:53:55] [INFO] Callback 'OnPlayerCarsLoad' set up for delayed execution. [23:53:55] [DEBUG] created delayed callback with 1 parameter [23:53:55] [DEBUG] CHandle::Execute(this=0x561098, type=1, query=0x598bd8) [23:53:55] [DEBUG] CHandle::Execute - return value: true [23:53:55] [DEBUG] mysql_tquery: return value: '1' [23:53:55] [DEBUG] CConnection::Execute(query=0x598bd8, this=0x3987020, connection=0x5a1be0) [23:53:55] [DEBUG] CQuery::Execute(this=0x598bd8, connection=0x5a1be0) [23:53:55] [DEBUG] AMX callback executed with error '0' [23:53:55] [INFO] Callback successfully executed. [23:53:55] [INFO] query "SELECT * FROM autos WHERE besitzer=1" successfully executed within 0.274 milliseconds [23:53:55] [DEBUG] CResultSet::Create(connection=0x5a1be0, query_str='SELECT * FROM autos WHERE besitzer=1') [23:53:55] [DEBUG] created new resultset '0x5bf438' [23:53:55] [DEBUG] fetched MySQL result '0x578a08' [23:53:55] [DEBUG] allocated 0 bytes for PAWN result [23:53:55] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=5, num_params=1) [23:53:55] [INFO] Executing callback 'OnPlayerCarsLoad' with 1 parameter... [23:53:55] [DEBUG] processing internal specifier 'c' [23:53:55] [DEBUG] pushed value '0' onto AMX stack [23:53:55] [DEBUG] executing AMX callback with index '5' [23:53:55] [DEBUG] cache_get_row_count(0x02C1034C) [23:53:55] [DEBUG] cache_get_row_count: return value: '1' [23:53:55] [DEBUG] AMX callback executed with error '0' [23:53:55] [INFO] Callback successfully executed. [23:54:06] [DEBUG] mysql_format(1, 0x02C0FD28, 200, "INSERT INTO autos (besitzer,model,x,y,z,r) VALUES('%i','%i','%f','%f','%f','%f')") [23:54:06] [DEBUG] mysql_format: return value: '110' [23:54:06] [DEBUG] mysql_tquery(1, "INSERT INTO autos (besitzer,model,x,y,z,r) VALUES('0','411','139.157745','-71.552818','1.429688','245.945618')", "", "") [23:54:06] [DEBUG] CCallback::Create(amx=0x2a0a860, name='', format='', params=0x2c0fd14, param_offset=5) [23:54:06] [DEBUG] CHandle::Execute(this=0x561098, type=1, query=0x598b40) [23:54:06] [DEBUG] CHandle::Execute - return value: true [23:54:06] [DEBUG] mysql_tquery: return value: '1' [23:54:06] [DEBUG] CConnection::Execute(query=0x598b40, this=0x3987020, connection=0x5a1be0) [23:54:06] [DEBUG] CQuery::Execute(this=0x598b40, connection=0x5a1be0) [23:54:06] [INFO] query "INSERT INTO autos (besitzer,model,x,y,z,r) VALUES('0','411','139.157745','-71.552818','1.429688','245.945618')" successfully executed within 0.877 milliseconds [23:54:06] [DEBUG] CResultSet::Create(connection=0x5a1be0, query_str='INSERT INTO autos (besitzer,model,x,y,z,r) VALUES('0','411','139.157745','-71.552818','1.429688','245.945618')') [23:54:06] [DEBUG] created new resultset '0x5bf240' [23:54:06] [DEBUG] fetched MySQL result '0x0' [23:54:15] [DEBUG] mysql_format(1, 0x02C0FF28, 256, "UPDATE users SET level = '%d', money = '%d', kills = '%d', deaths = '%d', adminlevel = '%d', fraktion = '%d', rang = '%d', spawnchange = '%d' WHERE id = '%d'") [23:54:15] [DEBUG] mysql_format: return value: '153' [23:54:15] [DEBUG] mysql_pquery(1, "UPDATE users SET level = '20', money = '30000', kills = '0', deaths = '0', adminlevel = '3', fraktion = '0', rang = '6', spawnchange = '0' WHERE id = '1'", "", "") [23:54:15] [DEBUG] CCallback::Create(amx=0x2a0a860, name='', format='', params=0x2c0ff14, param_offset=5) [23:54:15] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x598a10) [23:54:15] [DEBUG] CConnectionPool::Queue(query=0x598a10, this=0x58a3d8) [23:54:15] [DEBUG] CHandle::Execute - return value: true [23:54:15] [DEBUG] mysql_pquery: return value: '1' [23:54:15] [DEBUG] CConnection::Execute(query=0x598a10, this=0x3d2b020, connection=0x5b64c0) [23:54:15] [DEBUG] CQuery::Execute(this=0x598a10, connection=0x5b64c0) [23:54:15] [INFO] query "UPDATE users SET level = '20', money = '30000', kills = '0', deaths = '0', adminlevel = '3', fraktion = '0', rang = '6', spawnchange = '0' WHERE id = '1'" successfully executed within 0.286 milliseconds [23:54:15] [DEBUG] CResultSet::Create(connection=0x5b64c0, query_str='UPDATE users SET level = '20', money = '30000', kills = '0', deaths = '0', adminlevel = '3', fraktion = '0', rang = '6', spawnchange = '0' WHERE id = '1'') [23:54:15] [DEBUG] created new resultset '0x5bf400' [23:54:15] [DEBUG] fetched MySQL result '0x0' [23:54:51] [DEBUG] mysql_format(1, 0x02C1014C, 128, "SELECT id FROM users WHERE name = '%e'") [23:54:51] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin_West') [23:54:51] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a858, connection=0x5617b0) [23:54:51] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:54:51] [DEBUG] mysql_format: return value: '47' [23:54:51] [DEBUG] mysql_pquery(1, "SELECT id FROM users WHERE name = 'Dustin_West'", "OnUserCheck", "d") [23:54:51] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserCheck', format='d', params=0x2c10134, param_offset=5) [23:54:51] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 33 [23:54:51] [DEBUG] processing specifier 'd' with parameter index 0 [23:54:51] [DEBUG] retrieved and pushed value '0' [23:54:51] [INFO] Callback 'OnUserCheck' set up for delayed execution. [23:54:51] [DEBUG] created delayed callback with 1 parameter [23:54:51] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x598a10) [23:54:51] [DEBUG] CConnectionPool::Queue(query=0x598a10, this=0x58a3d8) [23:54:51] [DEBUG] CHandle::Execute - return value: true [23:54:51] [DEBUG] mysql_pquery: return value: '1' [23:54:51] [DEBUG] CConnection::Execute(query=0x598a10, this=0x3b5c020, connection=0x5acf10) [23:54:51] [DEBUG] CQuery::Execute(this=0x598a10, connection=0x5acf10) [23:54:51] [INFO] query "SELECT id FROM users WHERE name = 'Dustin_West'" successfully executed within 0.253 milliseconds [23:54:51] [DEBUG] CResultSet::Create(connection=0x5acf10, query_str='SELECT id FROM users WHERE name = 'Dustin_West'') [23:54:51] [DEBUG] created new resultset '0x5bf048' [23:54:51] [DEBUG] fetched MySQL result '0x569c88' [23:54:51] [DEBUG] allocated 20 bytes for PAWN result [23:54:51] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=33, num_params=1) [23:54:51] [INFO] Executing callback 'OnUserCheck' with 1 parameter... [23:54:51] [DEBUG] processing internal specifier 'c' [23:54:51] [DEBUG] pushed value '0' onto AMX stack [23:54:51] [DEBUG] executing AMX callback with index '33' [23:54:51] [DEBUG] cache_get_row_count(0x02C1034C) [23:54:51] [DEBUG] cache_get_row_count: return value: '1' [23:54:51] [DEBUG] AMX callback executed with error '0' [23:54:51] [INFO] Callback successfully executed. [23:54:54] [DEBUG] mysql_format(1, 0x02C0FF40, 256, "SELECT * FROM users WHERE name = '%e' AND password = MD5('%e')") [23:54:54] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin_West') [23:54:54] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a858, connection=0x5617b0) [23:54:54] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:54:54] [DEBUG] CHandle::EscapeString(this=0x561098, src='Dustin') [23:54:54] [DEBUG] CConnection::EscapeString(src='Dustin', this=0x58a858, connection=0x5617b0) [23:54:54] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin' [23:54:54] [DEBUG] mysql_format: return value: '75' [23:54:54] [DEBUG] mysql_pquery(1, "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')", "OnUserLogin", "d") [23:54:54] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserLogin', format='d', params=0x2c0ff28, param_offset=5) [23:54:54] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 34 [23:54:54] [DEBUG] processing specifier 'd' with parameter index 0 [23:54:54] [DEBUG] retrieved and pushed value '0' [23:54:54] [INFO] Callback 'OnUserLogin' set up for delayed execution. [23:54:54] [DEBUG] created delayed callback with 1 parameter [23:54:54] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x598d08) [23:54:54] [DEBUG] CConnectionPool::Queue(query=0x598d08, this=0x58a3d8) [23:54:54] [DEBUG] CHandle::Execute - return value: true [23:54:54] [DEBUG] mysql_pquery: return value: '1' [23:54:54] [DEBUG] CConnection::Execute(query=0x598d08, this=0x3d2b020, connection=0x5b64c0) [23:54:54] [DEBUG] CQuery::Execute(this=0x598d08, connection=0x5b64c0) [23:54:54] [INFO] query "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')" successfully executed within 0.294 milliseconds [23:54:54] [DEBUG] CResultSet::Create(connection=0x5b64c0, query_str='SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')') [23:54:54] [DEBUG] created new resultset '0x5bf470' [23:54:54] [DEBUG] fetched MySQL result '0x592b08' [23:54:54] [DEBUG] allocated 124 bytes for PAWN result [23:54:54] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=34, num_params=1) [23:54:54] [INFO] Executing callback 'OnUserLogin' with 1 parameter... [23:54:54] [DEBUG] processing internal specifier 'c' [23:54:54] [DEBUG] pushed value '0' onto AMX stack [23:54:54] [DEBUG] executing AMX callback with index '34' [23:54:54] [DEBUG] cache_get_row_count(0x02C1034C) [23:54:54] [DEBUG] cache_get_row_count: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "id", 0x02BCD32C) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '1' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "level", 0x02BCD394) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '20' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "money", 0x02BCD3A8) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '30000' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "kills", 0x02BCD3AC) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "deaths", 0x02BCD3B4) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "adminlevel", 0x02BCD398) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '3' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "fraktion", 0x02BCD39C) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "rang", 0x02BCD3A0) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '6' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] cache_get_value_name_int(0, "spawnchange", 0x02BCD3A4) [23:54:54] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:54:54] [DEBUG] cache_get_value_name_int: return value: '1' [23:54:54] [DEBUG] mysql_format(1, 0x02C1001C, 200, "SELECT * FROM autos WHERE besitzer=%d") [23:54:54] [DEBUG] mysql_format: return value: '36' [23:54:54] [DEBUG] mysql_tquery(1, "SELECT * FROM autos WHERE besitzer=1", "OnPlayerCarsLoad", "i") [23:54:54] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnPlayerCarsLoad', format='i', params=0x2c10004, param_offset=5) [23:54:54] [DEBUG] CCallback::Create - callback index for 'OnPlayerCarsLoad': 5 [23:54:54] [DEBUG] processing specifier 'i' with parameter index 0 [23:54:54] [DEBUG] retrieved and pushed value '0' [23:54:54] [INFO] Callback 'OnPlayerCarsLoad' set up for delayed execution. [23:54:54] [DEBUG] created delayed callback with 1 parameter [23:54:54] [DEBUG] CHandle::Execute(this=0x561098, type=1, query=0x598f68) [23:54:54] [DEBUG] CHandle::Execute - return value: true [23:54:54] [DEBUG] mysql_tquery: return value: '1' [23:54:54] [DEBUG] CConnection::Execute(query=0x598f68, this=0x3987020, connection=0x5a1be0) [23:54:54] [DEBUG] CQuery::Execute(this=0x598f68, connection=0x5a1be0) [23:54:54] [DEBUG] AMX callback executed with error '0' [23:54:54] [INFO] Callback successfully executed. [23:54:54] [INFO] query "SELECT * FROM autos WHERE besitzer=1" successfully executed within 0.249 milliseconds [23:54:54] [DEBUG] CResultSet::Create(connection=0x5a1be0, query_str='SELECT * FROM autos WHERE besitzer=1') [23:54:54] [DEBUG] created new resultset '0x594aa8' [23:54:54] [DEBUG] fetched MySQL result '0x578af8' [23:54:54] [DEBUG] allocated 0 bytes for PAWN result [23:54:54] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=5, num_params=1) [23:54:54] [INFO] Executing callback 'OnPlayerCarsLoad' with 1 parameter... [23:54:54] [DEBUG] processing internal specifier 'c' [23:54:54] [DEBUG] pushed value '0' onto AMX stack [23:54:54] [DEBUG] executing AMX callback with index '5' [23:54:54] [DEBUG] cache_get_row_count(0x02C1034C) [23:54:54] [DEBUG] cache_get_row_count: return value: '1' [23:54:54] [DEBUG] AMX callback executed with error '0' [23:54:54] [INFO] Callback successfully executed. [23:55:00] [DEBUG] mysql_format(1, 0x02C0FF28, 256, "UPDATE users SET level = '%d', money = '%d', kills = '%d', deaths = '%d', adminlevel = '%d', fraktion = '%d', rang = '%d', spawnchange = '%d' WHERE id = '%d'") [23:55:00] [DEBUG] mysql_format: return value: '153' [23:55:00] [DEBUG] mysql_pquery(1, "UPDATE users SET level = '20', money = '30000', kills = '0', deaths = '0', adminlevel = '3', fraktion = '0', rang = '6', spawnchange = '0' WHERE id = '1'", "", "") [23:55:00] [DEBUG] CCallback::Create(amx=0x2a0a860, name='', format='', params=0x2c0ff14, param_offset=5) [23:55:00] [DEBUG] CHandle::Execute(this=0x561098, type=2, query=0x598bd8) [23:55:00] [DEBUG] CConnectionPool::Queue(query=0x598bd8, this=0x58a3d8) [23:55:00] [DEBUG] CHandle::Execute - return value: true [23:55:00] [DEBUG] mysql_pquery: return value: '1' [23:55:00] [DEBUG] CConnection::Execute(query=0x598bd8, this=0x3b5c020, connection=0x5acf10) [23:55:00] [DEBUG] CQuery::Execute(this=0x598bd8, connection=0x5acf10) [23:55:00] [DEBUG] mysql_close(1) [23:55:00] [DEBUG] CHandleManager::Destroy(this=0x589638, handle=0x561098) [23:55:00] [DEBUG] CHandle::~CHandle(this=0x561098) [23:55:00] [DEBUG] CConnection::~CConnection(this=0x58a858, connection=0x5617b0) [23:55:00] [DEBUG] CThreadedConnection::~CThreadedConnection(this=0x3987020, connection=0x3987020) [23:55:00] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3987020, connection=0x3987020) - shutting down [23:55:00] [INFO] query "UPDATE users SET level = '20', money = '30000', kills = '0', deaths = '0', adminlevel = '3', fraktion = '0', rang = '6', spawnchange = '0' WHERE id = '1'" successfully executed within 0.256 milliseconds [23:55:00] [DEBUG] CResultSet::Create(connection=0x5acf10, query_str='UPDATE users SET level = '20', money = '30000', kills = '0', deaths = '0', adminlevel = '3', fraktion = '0', rang = '6', spawnchange = '0' WHERE id = '1'') [23:55:00] [DEBUG] created new resultset '0x594990' [23:55:00] [DEBUG] fetched MySQL result '0x0' [23:55:00] [DEBUG] CConnection::~CConnection(this=0x3987020, connection=0x5a1be0) [23:55:00] [DEBUG] CConnectionPool::~CConnectionPool(this=0x58a3d8) [23:55:00] [DEBUG] CThreadedConnection::~CThreadedConnection(this=0x3d2b020, connection=0x3d2b020) [23:55:00] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3d2b020, connection=0x3d2b020) - shutting down [23:55:00] [DEBUG] CConnection::~CConnection(this=0x3d2b020, connection=0x5b64c0) [23:55:00] [DEBUG] CThreadedConnection::~CThreadedConnection(this=0x3b5c020, connection=0x3b5c020) [23:55:00] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3b5c020, connection=0x3b5c020) - shutting down [23:55:00] [DEBUG] CConnection::~CConnection(this=0x3b5c020, connection=0x5acf10) [23:55:00] [DEBUG] mysql_close: return value: '1' [23:55:12] [INFO] changed log level from 'debug, info, warning, error' to 'debug, info, warning, error' [23:55:12] [DEBUG] mysql_connect("127.0.0.1", "root", "*****", "samp_db", 0) [23:55:12] [DEBUG] CHandleManager::Create(this=0x589638, host='127.0.0.1', user='root', pass='****', db='samp_db', options=0x580c48) [23:55:12] [INFO] Creating new connection handle... [23:55:12] [WARNING] mysql_connect: no password specified [23:55:12] [DEBUG] CConnection::CConnection(this=0x58a798, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:55:12] [DEBUG] CConnection::CConnection - new connection = 0x5617b0 [23:55:12] [DEBUG] CConnection::CConnection(this=0x7ef020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:55:12] [DEBUG] CConnection::CConnection - new connection = 0x5c6798 [23:55:12] [DEBUG] CThreadedConnection::WorkerFunc(this=0x7ef020, connection=0x7ef020) [23:55:12] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x7ef020, connection=0x7ef020) [23:55:12] [DEBUG] CConnectionPool::CConnectionPool(size=2, this=0x58a858) [23:55:12] [DEBUG] CConnection::CConnection(this=0x3a85020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:55:12] [DEBUG] CConnection::CConnection - new connection = 0x5ab4c8 [23:55:12] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3a85020, connection=0x3a85020) [23:55:12] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x3a85020, connection=0x3a85020) [23:55:12] [DEBUG] CConnection::CConnection(this=0x3c16020, host='127.0.0.1', user='root', passw='****', db='samp_db', options=0x580c48) [23:55:12] [DEBUG] CConnection::CConnection - new connection = 0x5ab898 [23:55:12] [DEBUG] CThreadedConnection::WorkerFunc(this=0x3c16020, connection=0x3c16020) [23:55:12] [DEBUG] CThreadedConnection::CThreadedConnection(this=0x3c16020, connection=0x3c16020) [23:55:12] [INFO] Connection handle with id '1' successfully created. [23:55:12] [DEBUG] CHandleManager::Create - new handle = 0x560ff8 [23:55:12] [DEBUG] mysql_connect: return value: '1' [23:55:12] [DEBUG] mysql_errno(1) [23:55:12] [DEBUG] CHandle::GetErrorId(this=0x560ff8) [23:55:12] [DEBUG] CConnection::GetError(this=0x58a798, connection=0x5617b0) [23:55:12] [DEBUG] CHandle::GetErrorId - return value: true, error id: '0', error msg: '' [23:55:12] [DEBUG] mysql_errno: return value: '0' [23:55:12] [DEBUG] mysql_format(1, 0x02BDF69C, 128, "SELECT id FROM users WHERE name = '%e'") [23:55:12] [DEBUG] CHandle::EscapeString(this=0x560ff8, src='Dustin_West') [23:55:12] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a798, connection=0x5617b0) [23:55:12] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:55:12] [DEBUG] mysql_format: return value: '47' [23:55:12] [DEBUG] mysql_pquery(1, "SELECT id FROM users WHERE name = 'Dustin_West'", "OnUserCheck", "d") [23:55:12] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserCheck', format='d', params=0x2bdf684, param_offset=5) [23:55:12] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 33 [23:55:12] [DEBUG] processing specifier 'd' with parameter index 0 [23:55:12] [DEBUG] retrieved and pushed value '0' [23:55:12] [INFO] Callback 'OnUserCheck' set up for delayed execution. [23:55:12] [DEBUG] created delayed callback with 1 parameter [23:55:12] [DEBUG] CHandle::Execute(this=0x560ff8, type=2, query=0x598848) [23:55:12] [DEBUG] CConnectionPool::Queue(query=0x598848, this=0x58a858) [23:55:12] [DEBUG] CHandle::Execute - return value: true [23:55:12] [DEBUG] mysql_pquery: return value: '1' [23:55:12] [DEBUG] CConnection::Execute(query=0x598848, this=0x3a85020, connection=0x5ab4c8) [23:55:12] [DEBUG] CQuery::Execute(this=0x598848, connection=0x5ab4c8) [23:55:12] [INFO] query "SELECT id FROM users WHERE name = 'Dustin_West'" successfully executed within 0.248 milliseconds [23:55:12] [DEBUG] CResultSet::Create(connection=0x5ab4c8, query_str='SELECT id FROM users WHERE name = 'Dustin_West'') [23:55:12] [DEBUG] created new resultset '0x594878' [23:55:12] [DEBUG] fetched MySQL result '0x5a8050' [23:55:12] [DEBUG] allocated 20 bytes for PAWN result [23:55:12] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=33, num_params=1) [23:55:12] [INFO] Executing callback 'OnUserCheck' with 1 parameter... [23:55:12] [DEBUG] processing internal specifier 'c' [23:55:12] [DEBUG] pushed value '0' onto AMX stack [23:55:12] [DEBUG] executing AMX callback with index '33' [23:55:12] [DEBUG] cache_get_row_count(0x02BDF89C) [23:55:12] [DEBUG] cache_get_row_count: return value: '1' [23:55:12] [DEBUG] AMX callback executed with error '0' [23:55:12] [INFO] Callback successfully executed. [23:55:14] [DEBUG] mysql_format(1, 0x02BDF490, 256, "SELECT * FROM users WHERE name = '%e' AND password = MD5('%e')") [23:55:14] [DEBUG] CHandle::EscapeString(this=0x560ff8, src='Dustin_West') [23:55:14] [DEBUG] CConnection::EscapeString(src='Dustin_West', this=0x58a798, connection=0x5617b0) [23:55:14] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin_West' [23:55:14] [DEBUG] CHandle::EscapeString(this=0x560ff8, src='Dustin') [23:55:14] [DEBUG] CConnection::EscapeString(src='Dustin', this=0x58a798, connection=0x5617b0) [23:55:14] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Dustin' [23:55:14] [DEBUG] mysql_format: return value: '75' [23:55:14] [DEBUG] mysql_pquery(1, "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')", "OnUserLogin", "d") [23:55:14] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnUserLogin', format='d', params=0x2bdf478, param_offset=5) [23:55:14] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 34 [23:55:14] [DEBUG] processing specifier 'd' with parameter index 0 [23:55:14] [DEBUG] retrieved and pushed value '0' [23:55:14] [INFO] Callback 'OnUserLogin' set up for delayed execution. [23:55:14] [DEBUG] created delayed callback with 1 parameter [23:55:14] [DEBUG] CHandle::Execute(this=0x560ff8, type=2, query=0x598b40) [23:55:14] [DEBUG] CConnectionPool::Queue(query=0x598b40, this=0x58a858) [23:55:14] [DEBUG] CHandle::Execute - return value: true [23:55:14] [DEBUG] mysql_pquery: return value: '1' [23:55:14] [DEBUG] CConnection::Execute(query=0x598b40, this=0x3c16020, connection=0x5ab898) [23:55:14] [DEBUG] CQuery::Execute(this=0x598b40, connection=0x5ab898) [23:55:14] [INFO] query "SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')" successfully executed within 0.285 milliseconds [23:55:14] [DEBUG] CResultSet::Create(connection=0x5ab898, query_str='SELECT * FROM users WHERE name = 'Dustin_West' AND password = MD5('Dustin')') [23:55:14] [DEBUG] created new resultset '0x594f78' [23:55:14] [DEBUG] fetched MySQL result '0x592068' [23:55:14] [DEBUG] allocated 124 bytes for PAWN result [23:55:14] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=34, num_params=1) [23:55:14] [INFO] Executing callback 'OnUserLogin' with 1 parameter... [23:55:14] [DEBUG] processing internal specifier 'c' [23:55:14] [DEBUG] pushed value '0' onto AMX stack [23:55:14] [DEBUG] executing AMX callback with index '34' [23:55:14] [DEBUG] cache_get_row_count(0x02BDF89C) [23:55:14] [DEBUG] cache_get_row_count: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "id", 0x02B9C87C) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '1' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "level", 0x02B9C8E4) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '20' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "money", 0x02B9C8F8) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '30000' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "kills", 0x02B9C8FC) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "deaths", 0x02B9C904) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "adminlevel", 0x02B9C8E8) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '3' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "fraktion", 0x02B9C8EC) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "rang", 0x02B9C8F0) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '6' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] cache_get_value_name_int(0, "spawnchange", 0x02B9C8F4) [23:55:14] [DEBUG] cache_get_value_name_int: assigned value: '0' [23:55:14] [DEBUG] cache_get_value_name_int: return value: '1' [23:55:14] [DEBUG] mysql_format(1, 0x02BDF56C, 200, "SELECT * FROM autos WHERE besitzer=%d") [23:55:14] [DEBUG] mysql_format: return value: '36' [23:55:14] [DEBUG] mysql_tquery(1, "SELECT * FROM autos WHERE besitzer=1", "OnPlayerCarsLoad", "i") [23:55:14] [DEBUG] CCallback::Create(amx=0x2a0a860, name='OnPlayerCarsLoad', format='i', params=0x2bdf554, param_offset=5) [23:55:14] [DEBUG] CCallback::Create - callback index for 'OnPlayerCarsLoad': 5 [23:55:14] [DEBUG] processing specifier 'i' with parameter index 0 [23:55:14] [DEBUG] retrieved and pushed value '0' [23:55:14] [INFO] Callback 'OnPlayerCarsLoad' set up for delayed execution. [23:55:14] [DEBUG] created delayed callback with 1 parameter [23:55:14] [DEBUG] CHandle::Execute(this=0x560ff8, type=1, query=0x598718) [23:55:14] [DEBUG] CHandle::Execute - return value: true [23:55:14] [DEBUG] mysql_tquery: return value: '1' [23:55:14] [DEBUG] CConnection::Execute(query=0x598718, this=0x7ef020, connection=0x5c6798) [23:55:14] [DEBUG] CQuery::Execute(this=0x598718, connection=0x5c6798) [23:55:14] [DEBUG] AMX callback executed with error '0' [23:55:14] [INFO] Callback successfully executed. [23:55:14] [INFO] query "SELECT * FROM autos WHERE besitzer=1" successfully executed within 0.449 milliseconds [23:55:14] [DEBUG] CResultSet::Create(connection=0x5c6798, query_str='SELECT * FROM autos WHERE besitzer=1') [23:55:14] [DEBUG] created new resultset '0x5beee8' [23:55:14] [DEBUG] fetched MySQL result '0x578468' [23:55:14] [DEBUG] allocated 0 bytes for PAWN result [23:55:14] [DEBUG] CCallback::Execute(amx=0x2a0a860, index=5, num_params=1) [23:55:14] [INFO] Executing callback 'OnPlayerCarsLoad' with 1 parameter... [23:55:14] [DEBUG] processing internal specifier 'c' [23:55:14] [DEBUG] pushed value '0' onto AMX stack [23:55:14] [DEBUG] executing AMX callback with index '5' [23:55:14] [DEBUG] cache_get_row_count(0x02BDF89C) [23:55:14] [DEBUG] cache_get_row_count: return value: '1' [23:55:14] [DEBUG] AMX callback executed with error '0' [23:55:14] [INFO] Callback successfully executed. -
Ja, weil besitzer immernoch auf 0 ist.
Da wird der falsche Wert genommen.
Wie setzt du denn von PlayerInfo die db_id?
Beim laden dieser id machst du irgendwas falsch...
-
Naja, da scheint ja alles richtig zu sein, da ist der Wert ja auf 1.
Wie rufst du denn saveCar auf?
Das wäre mal interessant, in welchem Kontext die Funktion aufgerufen wird.
-
Und wo, bzw wann rufst du das auf?
-
Hab ne Vermutung was die db_id betrifft:
Wird hier geladen
Code
Alles anzeigenpublic OnPlayerCarsLoad() { new num_rows; cache_get_row_count(num_rows); if(!num_rows) return 1; for(new i,id; i<num_rows; i++) { id=getFreeCarID(); cache_get_value_name_int(i, "model", cInfo[id][model]); cache_get_value_name_int(i, "besitzer", cInfo[id][besitzer]); cache_get_value_name_float(i, "x", cInfo[id][c_x]); cache_get_value_name_float(i, "y", cInfo[id][c_y]); cache_get_value_name_float(i, "z", cInfo[id][c_z]); cache_get_value_name_float(i, "r", cInfo[id][c_r]); cache_get_value_name_int(i, "id", PlayerInfo[id][db_id]); <<<<<<<<<<<<<<<<<<<< Wird hier geladen cInfo[id][id_x]=CreateVehicle(cInfo[id][model],cInfo[id][c_x],cInfo[id][c_y],cInfo[id][c_z],cInfo[id][c_r],-1,-1,-1); print("OnPlayerCarsLoad"); } return 1; }Aber nicht hier.
Code
Alles anzeigenpublic OnUserLogin(playerid) { new rows; cache_get_row_count(rows); if(rows == 0) { ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "[RTG]Anmeldung", "Bitte logge dich ein gebe dazu dein Passwort in das Eingabefeld ein:\n{FF0000}Falsches Passwort!", "Bestätigen", "Abbrechen"); } else { //Laden cache_get_value_name_int(0, "id", PlayerInfo[playerid][p_id]); cache_get_value_name_int(0, "level", PlayerInfo[playerid][pLevel]); cache_get_value_name_int(0, "money", PlayerInfo[playerid][pMoney]); cache_get_value_name_int(0, "kills", PlayerInfo[playerid][pKills]); cache_get_value_name_int(0, "deaths", PlayerInfo[playerid][pDeaths]); cache_get_value_name_int(0, "adminlevel", PlayerInfo[playerid][pAdmin]); cache_get_value_name_int(0, "fraktion", PlayerInfo[playerid][pFraktion]); cache_get_value_name_int(0, "rang", PlayerInfo[playerid][pRang]); cache_get_value_name_int(0, "spawnchange", PlayerInfo[playerid][pSpawnchange]); PlayerInfo[playerid][pLoggedIn] = true; SendClientMessage(playerid, COLOR_YELLOW, "[INFO] Du hast dich erfolgreich Eingeloggt."); GivePlayerMoney(playerid, PlayerInfo[playerid][pMoney]); loadPlayerCars(playerid); //das hier? new nachricht[128]; format(nachricht,sizeof(nachricht),"[INFO] Du bist mit der ID %i verbunden.",playerid); SendClientMessage(playerid,COLOR_YELLOW,nachricht); SpawnPlayer(playerid); } return 1; } -
Aber nicht hier.
loadPlayerCars ruft OnPlayerCarsLoad auf.
RaPTiiC ersetzt mal das durch deine loadPlayerCars funktion.
CodeloadPlayerCars(playerid) { new query[128]; mysql_format(handle, query, sizeof(query), "SELECT * FROM autos WHERE besitzer = '%i'", PlayerInfo[playerid][p_id]); mysql_pquery(handle, query, "OnPlayerCarsLoad", "i", playerid); return 1; } -
