Fraktionssystem geht nicht

Markuslobicher · 14. Oktober 2016

Guten Morgen

@Jeffry Wenn du zeit hast

Ich habe derzeit probleme mit mein Fraktionssystem:

Wie sieht der Fehler aus:

Spieler A = Admin setzt Spieler B zum LSPD-Leader.

Spieler B = benutzt /spawnchange um sein Spawn zum LSPD-Spawn zu setzen.

Spieler B = Stirbt und spawnt nicht am LSPD-Spawn.

Spieler B = Loggt sich aus sollte normal alles gespeichert werden.

Spieler B = Loggt sich wieder ein und ist kein Leader vom LSPD ,mehr.

Hier die Logs:
MYSQL-Log

Spoiler anzeigen

Code

[10/14/16 06:34:38] [INFO] changed log level from 'warning, error' to 'debug, info, warning, error'
[10/14/16 06:35:58] [DEBUG] mysql_format(1, 0xF5488734, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/14/16 06:35:58] [DEBUG] CHandle::EscapeString(this=0x9953ab0, src='Tiriago')
[10/14/16 06:35:58] [DEBUG] CConnection::EscapeString(src='Tiriago', this=0x9a446d0, connection=0x9ac5178)
[10/14/16 06:35:58] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Tiriago'
[10/14/16 06:35:58] [DEBUG] mysql_format: return value: '46' (Nitradoscript.p:270)
[10/14/16 06:35:58] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Tiriago'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/14/16 06:35:58] [DEBUG] CCallback::Create(amx=0x9ac4d38, name='OnUserCheck', format='d', params=0xf548871c, param_offset=5)
[10/14/16 06:35:58] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/14/16 06:35:58] [DEBUG] processing specifier 'd' with parameter index 0
[10/14/16 06:35:58] [DEBUG] retrieved and pushed value '0'
[10/14/16 06:35:58] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/14/16 06:35:58] [DEBUG] created delayed callback with 1 parameter
[10/14/16 06:35:58] [DEBUG] CHandle::Execute(this=0x9953ab0, type=2, query=0x9b14030)
[10/14/16 06:35:58] [DEBUG] CConnectionPool::Queue(query=0x9b14030, this=0x9a4b490)
[10/14/16 06:35:58] [DEBUG] CHandle::Execute - return value: true
[10/14/16 06:35:58] [DEBUG] CConnection::Execute(query=0x9b14030, this=0xf4b5d008, connection=0x9aebb00)
[10/14/16 06:35:58] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/14/16 06:35:58] [DEBUG] CQuery::Execute(this=0x9b14030, connection=0x9aebb00)
[10/14/16 06:35:58] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Tiriago'" successfully executed within 0.309 milliseconds
[10/14/16 06:35:58] [DEBUG] CResultSet::Create(connection=0x9aebb00, query_str='SELECT id FROM Accounts WHERE Name = 'Tiriago'')
[10/14/16 06:35:58] [DEBUG] created new resultset '0xf41004f0'
[10/14/16 06:35:58] [DEBUG] fetched MySQL result '0xf4100768'
[10/14/16 06:35:58] [DEBUG] allocated 20 bytes for PAWN result
[10/14/16 06:35:58] [DEBUG] CCallback::Execute(amx=0x9ac4d38, index=32, num_params=1)
[10/14/16 06:35:58] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/14/16 06:35:58] [DEBUG] processing internal specifier 'c'
[10/14/16 06:35:58] [DEBUG] pushed value '0' onto AMX stack
[10/14/16 06:35:58] [DEBUG] executing AMX callback with index '32'
[10/14/16 06:35:58] [DEBUG] cache_get_row_count(0xF5488934) (Nitradoscript.p:296)
[10/14/16 06:35:58] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/14/16 06:35:58] [DEBUG] AMX callback executed with error '0'
[10/14/16 06:35:58] [INFO] Callback successfully executed.
[10/14/16 06:35:59] [DEBUG] mysql_format(1, 0xF5488528, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/14/16 06:35:59] [DEBUG] mysql_format: return value: '74' (Nitradoscript.p:1069)
[10/14/16 06:35:59] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/14/16 06:35:59] [DEBUG] CCallback::Create(amx=0x9ac4d38, name='OnUserLogin', format='d', params=0xf5488510, param_offset=5)
[10/14/16 06:35:59] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/14/16 06:35:59] [DEBUG] processing specifier 'd' with parameter index 0
[10/14/16 06:35:59] [DEBUG] retrieved and pushed value '0'
[10/14/16 06:35:59] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/14/16 06:35:59] [DEBUG] created delayed callback with 1 parameter
[10/14/16 06:35:59] [DEBUG] CHandle::Execute(this=0x9953ab0, type=2, query=0x9b143e8)
[10/14/16 06:35:59] [DEBUG] CConnectionPool::Queue(query=0x9b143e8, this=0x9a4b490)
[10/14/16 06:35:59] [DEBUG] CHandle::Execute - return value: true
[10/14/16 06:35:59] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/14/16 06:35:59] [DEBUG] CConnection::Execute(query=0x9b143e8, this=0xf42db008, connection=0x9af2150)
[10/14/16 06:35:59] [DEBUG] CQuery::Execute(this=0x9b143e8, connection=0x9af2150)
[10/14/16 06:35:59] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')" successfully executed within 1.271 milliseconds
[10/14/16 06:35:59] [DEBUG] CResultSet::Create(connection=0x9af2150, query_str='SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')')
[10/14/16 06:35:59] [DEBUG] created new resultset '0xf37004f0'
[10/14/16 06:35:59] [DEBUG] fetched MySQL result '0xf37007a8'
[10/14/16 06:35:59] [DEBUG] allocated 100 bytes for PAWN result
[10/14/16 06:35:59] [DEBUG] CCallback::Execute(amx=0x9ac4d38, index=33, num_params=1)
[10/14/16 06:35:59] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/14/16 06:35:59] [DEBUG] processing internal specifier 'c'
[10/14/16 06:35:59] [DEBUG] pushed value '0' onto AMX stack
[10/14/16 06:35:59] [DEBUG] executing AMX callback with index '33'
[10/14/16 06:35:59] [DEBUG] cache_get_row_count(0xF5488934) (Nitradoscript.p:1121)
[10/14/16 06:35:59] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "id", 0xF54735B4) (Nitradoscript.p:1131)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '1' (Nitradoscript.p:1131)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1131)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "Adminlevel", 0xF547361C) (Nitradoscript.p:1132)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '7' (Nitradoscript.p:1132)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1132)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "Level", 0xF5473620) (Nitradoscript.p:1133)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '2' (Nitradoscript.p:1133)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1133)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "Money", 0xF5473624) (Nitradoscript.p:1134)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1134)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1134)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF5473628) (Nitradoscript.p:1135)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1135)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1135)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "Rang", 0xF547362C) (Nitradoscript.p:1136)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1136)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int(0, "Spawn", 0xF5473630) (Nitradoscript.p:1137)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1137)
[10/14/16 06:35:59] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1137)
[10/14/16 06:35:59] [DEBUG] AMX callback executed with error '0'
[10/14/16 06:35:59] [INFO] Callback successfully executed.
[10/14/16 06:38:48] [DEBUG] mysql_pquery(1, "INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('1','411','1705.761108','-2313.811279','13.546875','263.543304')", "carSavedToDB", "i") (Nitradoscript.p:879)
[10/14/16 06:38:48] [DEBUG] CCallback::Create(amx=0x9ac4d38, name='carSavedToDB', format='i', params=0xf5488418, param_offset=5)
[10/14/16 06:38:48] [DEBUG] CCallback::Create - callback index for 'carSavedToDB': -10057
[10/14/16 06:38:48] [DEBUG] processing specifier 'i' with parameter index 0
[10/14/16 06:38:48] [DEBUG] retrieved and pushed value '0'
[10/14/16 06:38:48] [INFO] Callback 'carSavedToDB' set up for delayed execution.
[10/14/16 06:38:48] [DEBUG] created delayed callback with 1 parameter
[10/14/16 06:38:48] [DEBUG] CHandle::Execute(this=0x9953ab0, type=2, query=0x997d380)
[10/14/16 06:38:48] [DEBUG] CConnectionPool::Queue(query=0x997d380, this=0x9a4b490)
[10/14/16 06:38:48] [DEBUG] CHandle::Execute - return value: true
[10/14/16 06:38:48] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:879)
[10/14/16 06:38:48] [DEBUG] CConnection::Execute(query=0x997d380, this=0xf4b5d008, connection=0x9aebb00)
[10/14/16 06:38:48] [DEBUG] CQuery::Execute(this=0x997d380, connection=0x9aebb00)
[10/14/16 06:38:48] [INFO] query "INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('1','411','1705.761108','-2313.811279','13.546875','263.543304')" successfully executed within 2.723 milliseconds
[10/14/16 06:38:48] [DEBUG] CResultSet::Create(connection=0x9aebb00, query_str='INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('1','411','1705.761108','-2313.811279','13.546875','263.543304')')
[10/14/16 06:38:48] [DEBUG] created new resultset '0xf4100800'
[10/14/16 06:38:48] [DEBUG] fetched MySQL result '0x0'
[10/14/16 06:38:48] [DEBUG] CCallback::Execute(amx=0x9ac4d38, index=-10057, num_params=1)
[10/14/16 06:38:48] [INFO] Executing callback '��' with 1 parameter...
[10/14/16 06:38:48] [DEBUG] processing internal specifier 'c'
[10/14/16 06:38:48] [DEBUG] pushed value '0' onto AMX stack
[10/14/16 06:38:48] [DEBUG] executing AMX callback with index '-10057'
[10/14/16 06:38:48] [DEBUG] AMX callback executed with error '0'
[10/14/16 06:38:48] [INFO] Callback successfully executed.
[10/14/16 06:40:20] [DEBUG] mysql_format(1, 0xF5488734, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/14/16 06:40:20] [DEBUG] CHandle::EscapeString(this=0x9953ab0, src='Tiriago')
[10/14/16 06:40:20] [DEBUG] CConnection::EscapeString(src='Tiriago', this=0x9a446d0, connection=0x9ac5178)
[10/14/16 06:40:20] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Tiriago'
[10/14/16 06:40:20] [DEBUG] mysql_format: return value: '46' (Nitradoscript.p:270)
[10/14/16 06:40:20] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Tiriago'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/14/16 06:40:20] [DEBUG] CCallback::Create(amx=0x9ac4d38, name='OnUserCheck', format='d', params=0xf548871c, param_offset=5)
[10/14/16 06:40:20] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/14/16 06:40:20] [DEBUG] processing specifier 'd' with parameter index 0
[10/14/16 06:40:20] [DEBUG] retrieved and pushed value '0'
[10/14/16 06:40:20] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/14/16 06:40:20] [DEBUG] created delayed callback with 1 parameter
[10/14/16 06:40:20] [DEBUG] CHandle::Execute(this=0x9953ab0, type=2, query=0x9b13e88)
[10/14/16 06:40:20] [DEBUG] CConnectionPool::Queue(query=0x9b13e88, this=0x9a4b490)
[10/14/16 06:40:20] [DEBUG] CHandle::Execute - return value: true
[10/14/16 06:40:20] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/14/16 06:40:20] [DEBUG] CConnection::Execute(query=0x9b13e88, this=0xf42db008, connection=0x9af2150)
[10/14/16 06:40:20] [DEBUG] CQuery::Execute(this=0x9b13e88, connection=0x9af2150)
[10/14/16 06:40:20] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Tiriago'" successfully executed within 0.274 milliseconds
[10/14/16 06:40:20] [DEBUG] CResultSet::Create(connection=0x9af2150, query_str='SELECT id FROM Accounts WHERE Name = 'Tiriago'')
[10/14/16 06:40:20] [DEBUG] created new resultset '0xf3700938'
[10/14/16 06:40:20] [DEBUG] fetched MySQL result '0xf3700838'
[10/14/16 06:40:20] [DEBUG] allocated 20 bytes for PAWN result
[10/14/16 06:40:20] [DEBUG] CCallback::Execute(amx=0x9ac4d38, index=32, num_params=1)
[10/14/16 06:40:20] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/14/16 06:40:20] [DEBUG] processing internal specifier 'c'
[10/14/16 06:40:20] [DEBUG] pushed value '0' onto AMX stack
[10/14/16 06:40:20] [DEBUG] executing AMX callback with index '32'
[10/14/16 06:40:20] [DEBUG] cache_get_row_count(0xF5488934) (Nitradoscript.p:296)
[10/14/16 06:40:20] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/14/16 06:40:20] [DEBUG] AMX callback executed with error '0'
[10/14/16 06:40:20] [INFO] Callback successfully executed.
[10/14/16 06:40:22] [DEBUG] mysql_format(1, 0xF5488528, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/14/16 06:40:22] [DEBUG] mysql_format: return value: '74' (Nitradoscript.p:1069)
[10/14/16 06:40:22] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/14/16 06:40:22] [DEBUG] CCallback::Create(amx=0x9ac4d38, name='OnUserLogin', format='d', params=0xf5488510, param_offset=5)
[10/14/16 06:40:22] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/14/16 06:40:22] [DEBUG] processing specifier 'd' with parameter index 0
[10/14/16 06:40:22] [DEBUG] retrieved and pushed value '0'
[10/14/16 06:40:22] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/14/16 06:40:22] [DEBUG] created delayed callback with 1 parameter
[10/14/16 06:40:22] [DEBUG] CHandle::Execute(this=0x9953ab0, type=2, query=0x994bce0)
[10/14/16 06:40:22] [DEBUG] CConnectionPool::Queue(query=0x994bce0, this=0x9a4b490)
[10/14/16 06:40:22] [DEBUG] CHandle::Execute - return value: true
[10/14/16 06:40:22] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/14/16 06:40:22] [DEBUG] CConnection::Execute(query=0x994bce0, this=0xf4b5d008, connection=0x9aebb00)
[10/14/16 06:40:22] [DEBUG] CQuery::Execute(this=0x994bce0, connection=0x9aebb00)
[10/14/16 06:40:22] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')" successfully executed within 0.330 milliseconds
[10/14/16 06:40:22] [DEBUG] CResultSet::Create(connection=0x9aebb00, query_str='SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')')
[10/14/16 06:40:22] [DEBUG] created new resultset '0xf41004f0'
[10/14/16 06:40:22] [DEBUG] fetched MySQL result '0xf41007a8'
[10/14/16 06:40:22] [DEBUG] allocated 100 bytes for PAWN result
[10/14/16 06:40:22] [DEBUG] CCallback::Execute(amx=0x9ac4d38, index=33, num_params=1)
[10/14/16 06:40:22] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/14/16 06:40:22] [DEBUG] processing internal specifier 'c'
[10/14/16 06:40:22] [DEBUG] pushed value '0' onto AMX stack
[10/14/16 06:40:22] [DEBUG] executing AMX callback with index '33'
[10/14/16 06:40:22] [DEBUG] cache_get_row_count(0xF5488934) (Nitradoscript.p:1121)
[10/14/16 06:40:22] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "id", 0xF54735B4) (Nitradoscript.p:1131)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '1' (Nitradoscript.p:1131)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1131)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "Adminlevel", 0xF547361C) (Nitradoscript.p:1132)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '7' (Nitradoscript.p:1132)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1132)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "Level", 0xF5473620) (Nitradoscript.p:1133)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '2' (Nitradoscript.p:1133)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1133)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "Money", 0xF5473624) (Nitradoscript.p:1134)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1134)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1134)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF5473628) (Nitradoscript.p:1135)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1135)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1135)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "Rang", 0xF547362C) (Nitradoscript.p:1136)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1136)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int(0, "Spawn", 0xF5473630) (Nitradoscript.p:1137)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1137)
[10/14/16 06:40:22] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1137)
[10/14/16 06:40:22] [DEBUG] AMX callback executed with error '0'
[10/14/16 06:40:22] [INFO] Callback successfully executed.

Alles anzeigen

Pawn Code für das Fraktionssystem:

Spoiler anzeigen

Enum:

Code

enum playerInfo{
	db_id,
	bool:eingeloggt,
	Name[MAX_PLAYER_NAME],
	Adminlevel,
	Level,
	Money,
	Fraktion,
	Rang,
	Spawn
}
new sInfo[MAX_PLAYER_NAME][playerInfo];


enum frakteEnum{


	f_name[300],
	Float:f_x,
	Float:f_y,
	Float:f_z,
	Float:f_r,
	f_inter,
	f_world,
	f_color
}


new fInfo[][frakteEnum] ={
{"Zivilist",329.0244,-1513.3033,36.0391,225.8344,0,0,weiß},//Zivilist 0
{"SAPD",213.4162,162.7460,1003.0234,274.4569,3,1,blau},//SAPD 1
{"SWAT",2731.5903,-2450.0164,17.5937,272.4424,0,0,helblau},//SWAT2
{"FBI",2286.9651,2431.6011,10.8203,176.4887,0,0,duneklhelblau},//FBI3
{"ARMY",214.2768,1822.5925,6.4141,265.0869,0,0,hellgrün},//ARMY4
{"Medic/Feuerwehr",302.9467,-1505.8025,24.6007,231.6743,0,0,rot},//MEDIC5
{"Fahrschule",2124.3032,-2273.0491,20.6719,221.7338,0,0,orange},//Fahrschule6
{"Aztecas",2788.4141,-1944.7075,13.5469,87.2128,0,0,türkis},//AZTECAS7
{"Vagos",204.6566,39.7421,2.5781,260.2514,0,0,gelb},//Vagos8
{"Ballas",1084.8976,-1226.7927,15.8203,269.7700,0,0,pink},//Ballas9
{"Yakuza",-2188.6282,-2265.0452,30.6250,71.4091,0,0,grau}//Yakuza10
};

Alles anzeigen

Spieler verbindet sich mit dem Server:

Code

public OnPlayerConnect(playerid)
{
	sInfo[playerid][db_id] =0;
	sInfo[playerid][eingeloggt] =false;
	sInfo[playerid][Adminlevel] =0;
	sInfo[playerid][Level] = 0;
	sInfo[playerid][Money] = 0;
	sInfo[playerid][Fraktion] = 0;
	sInfo[playerid][Rang] = 0;
	sInfo[playerid][Spawn] = 0;
	GetPlayerName(playerid,sInfo[playerid][Name],MAX_PLAYER_NAME);
	SetPlayerColor(playerid,weiß);
	sInfo[playerid][Level]=1;
	SetPlayerScore(playerid,sInfo[playerid][Level]);
	return 1;
}

Alles anzeigen

Spieler Speicher/Resten:

Code

resetPlayer(playerid)
{
	for(new i=0; i<sizeof(sInfo[]); i++)
	{
	    sInfo[playerid][playerInfo:i]=0;
	}
	return 1;
}




stock SaveUserStats(playerid)
{
	//Wen der Spieler nicht eingeloggt ist, dann speichere seine Statistiken nicht
	if(!sInfo[playerid][eingeloggt])return 1;
	//Ansonsten speichere Sie ab
	new query[600];
	mysql_format(handle,query,sizeof(query),"UPDATE Accounts Set Name = '%s',Adminlevel = '%d',Level = '%d',Money = '%d',Fraktion = '%i',Rang = '%d',Spawn = '%d'  WHERE id = '%d' ",sInfo[playerid][Adminlevel],sInfo[playerid][Level],sInfo[playerid][Money],sInfo[playerid][Fraktion],sInfo[playerid][Rang],sInfo[playerid][Spawn],sInfo[playerid][db_id]);
	//Das Query wird abgesendet
	mysql_pquery(handle,query);
	return 1;
}

Alles anzeigen

Spieler geht vom Server:

Code

public OnPlayerDisconnect(playerid, reason)
{
	SaveUserStats(playerid);
	resetPlayer(playerid);
	return 1;
}

SpielerSpawnt:

Code

public OnPlayerSpawn(playerid)
{
	if(!isPlayerInFrakt(playerid,0))
	{
		if(sInfo[playerid][Spawn]==1)
		{




			new fID;
			fID= sInfo[playerid][Fraktion];
			SetPlayerPos(playerid,fInfo[fID][f_x],fInfo[fID][f_y],fInfo[fID][f_z]);
			SetPlayerFacingAngle(playerid,fInfo[fID][f_r]);
			SetPlayerInterior(playerid,fInfo[fID][f_inter]);
			SetPlayerVirtualWorld(playerid,fInfo[fID][f_world]);
			SetPlayerColor(playerid,fInfo[fID][f_color]);
		}
	}
	SendClientMessage(playerid,rot,"/hilfe um die Befehle zu sehen!");
	return 1;
}

Alles anzeigen

Fraktionsabfrage:

Code

isPlayerInFrakt(playerid,f_id){
	if(sInfo[playerid][Fraktion]==f_id)return 1;
	return 0;
}

Leadererstellen:

Code

ocmd:leadererstellen(playerid,params[])
{
	if(!isAdmin(playerid,5))return SendClientMessage(playerid,grün,"Du hast keine Berechtigung dazu!");
	new pID, fID;
	if(sscanf(params,"ui",pID,fID))return SendClientMessage(playerid,rot,"INFO: /Leadererstellen[playerid][fraktid]");
	if(fID>= sizeof(fInfo))return SendClientMessage(playerid,rot,"Fraktion existiert nicht.");
	sInfo[pID][Fraktion] = fID;
	sInfo[pID][Rang] = 6;
	new string[128];
	format(string,sizeof(string),"%s hat dich zum Leader der Fraktion %s gemacht",getPlayerName(playerid),fInfo[fID][f_name]);
	SendClientMessage(pID,gelb,string);
	SendClientMessage(playerid,grün,"Du hast einen Spieler zum Leader gemacht.");
	return 1;
}

Alles anzeigen

OnUserLogin:

Code

public OnUserLogin(playerid)
{
	new rows;
	cache_get_row_count(rows);
	if(rows == 0)
	{
			//Der Spieler hat ein falsches Passwort eingegeben
			ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Einloggen","Bitte logge dich ein:\n{0xFF0000FF}Falsches Passwort!","Einloggen","Abbrechen");
	}
	else
	{
		//Es existiert ein Ergebnis,das heißt der Spieler hat das richtige Passwort eingegeben
		//Wir lesen nun die erste Zeile des Caches aus (id 0)
		cache_get_value_name_int(0,"id",sInfo[playerid][db_id]);
		cache_get_value_name_int(0,"Adminlevel",sInfo[playerid][Adminlevel]);
		cache_get_value_name_int(0,"Level",sInfo[playerid][Level]);
		cache_get_value_name_int(0,"Money",sInfo[playerid][Money]);
		cache_get_value_name_int(0,"Fraktion",sInfo[playerid][Fraktion]);
		cache_get_value_name_int(0,"Rang",sInfo[playerid][Rang]);
		cache_get_value_name_int(0,"Spawn",sInfo[playerid][Spawn]);
	}
	return 1;			
}

Alles anzeigen

Jeffry · 15. Oktober 2016

Zitat von Markuslobicher

Ich habe derzeit probleme mit mein Fraktionssystem:

Bei SaveUserStats fehlt im format in den Parametern vor dem Admin Level der Name, deshalb wird nichts gespeichert.
Zum Spawn Befehl kann ich nichts sagen, da du den nicht gepostet hast.

Markuslobicher · 15. Oktober 2016

@Jeffry

Bei OnUserLogin hatte ich ja das mit den Namen nicht drin.

Habe es jetzt so aussehen nach der Änderung:

OnUserLogin:

Code

public OnUserLogin(playerid)
{
	new rows;
	cache_get_row_count(rows);
	if(rows == 0)
	{
			//Der Spieler hat ein falsches Passwort eingegeben
			ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Einloggen","Bitte logge dich ein:\n{0xFF0000FF}Falsches Passwort!","Einloggen","Abbrechen");
	}
	else
	{
		//Es existiert ein Ergebnis,das heißt der Spieler hat das richtige Passwort eingegeben
		//Wir lesen nun die erste Zeile des Caches aus (id 0)
		cache_get_value_name_int(0,"id",sInfo[playerid][db_id]);
		cache_get_value_name_int(0,"Name",sInfo[playerid][Name]);
		cache_get_value_name_int(0,"Adminlevel",sInfo[playerid][Adminlevel]);
		cache_get_value_name_int(0,"Level",sInfo[playerid][Level]);
		cache_get_value_name_int(0,"Money",sInfo[playerid][Money]);
		cache_get_value_name_int(0,"Fraktion",sInfo[playerid][Fraktion]);
		cache_get_value_name_int(0,"Rang",sInfo[playerid][Rang]);
		cache_get_value_name_int(0,"Spawn",sInfo[playerid][Spawn]);
	}
	return 1;			
}

Alles anzeigen

Mein Spawnbefehl:

Code

ocmd:spawnchange(playerid,params[])
{
	if(isPlayerInFrakt(playerid,0)) return SendClientMessage(playerid,rot,"Du bist in keiner Fraktion.");
	if(sInfo[playerid][Spawn] == 0)
	{
		sInfo[playerid][Spawn] = 1;
	}
	if(sInfo[playerid][Spawn]==1)
	{
		sInfo[playerid][Spawn]=0;
	}
	SendClientMessage(playerid,grün,"Spawn geändert");
	return 1;
}

Alles anzeigen

Jeffry · 15. Oktober 2016

Hast du es bei SaveUserStats auch geändert?

Markuslobicher · 15. Oktober 2016

@Jeffry
Spielerspeicher;

Code

stock SaveUserStats(playerid)
{
	//Wen der Spieler nicht eingeloggt ist, dann speichere seine Statistiken nicht
	if(!sInfo[playerid][eingeloggt])return 1;
	//Ansonsten speichere Sie ab
	new query[600];
	mysql_format(handle,query,sizeof(query),"UPDATE Accounts Set Name = '%s',Adminlevel = '%d',Level = '%d',Money = '%d',Fraktion = '%i',Rang = '%d',Spawn = '%d'  WHERE id = '%d' ",sInfo[playerid][Name],sInfo[playerid][Adminlevel],sInfo[playerid][Level],sInfo[playerid][Money],sInfo[playerid][Fraktion],sInfo[playerid][Rang],sInfo[playerid][Spawn],sInfo[playerid][db_id]);
	//Das Query wird abgesendet
	mysql_pquery(handle,query);
	return 1;
}

Alles anzeigen

Jeffry · 15. Oktober 2016

Gut, dann schreibe den Befehl so, sonst wird der Spawn immer wieder direkt nach dem Setzen zu 1 auf 0 geändert (zweites if).
ocmd:spawnchange(playerid,params[])
{
if(isPlayerInFrakt(playerid,0)) return SendClientMessage(playerid,rot,"Du bist in keiner Fraktion.");
if(sInfo[playerid][Spawn] == 0)
{
sInfo[playerid][Spawn] = 1;
}
else
{
sInfo[playerid][Spawn]=0;
}
SendClientMessage(playerid,grün,"Spawn geändert");
return 1;
}

Markuslobicher · 15. Oktober 2016

@Jeffry

Ich habe leider immer noch kein plan warum der den Fraktionsspawn immer noch nicht nach dem Neu Einloggen übernimmt.
Die MySqL_Log habe ich dir auch wieder eingefügt:

Mysql_Log:

Spoiler anzeigen

SQL

[10/15/16 13:35:57] [INFO] changed log level from 'warning, error' to 'debug, info, warning, error'
[10/15/16 13:39:02] [DEBUG] mysql_format(1, 0xF542E7B4, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/15/16 13:39:02] [DEBUG] CHandle::EscapeString(this=0x83d4ab0, src='Hergus')
[10/15/16 13:39:02] [DEBUG] CConnection::EscapeString(src='Hergus', this=0x84c56d0, connection=0x8546178)
[10/15/16 13:39:02] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Hergus'
[10/15/16 13:39:02] [DEBUG] mysql_format: return value: '45' (Nitradoscript.p:270)
[10/15/16 13:39:02] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Hergus'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/15/16 13:39:02] [DEBUG] CCallback::Create(amx=0x8545d38, name='OnUserCheck', format='d', params=0xf542e79c, param_offset=5)
[10/15/16 13:39:02] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/15/16 13:39:02] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 13:39:02] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:39:02] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/15/16 13:39:02] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:39:02] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x8595030)
[10/15/16 13:39:02] [DEBUG] CConnectionPool::Queue(query=0x8595030, this=0x84cc490)
[10/15/16 13:39:02] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:39:02] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/15/16 13:39:02] [DEBUG] CConnection::Execute(query=0x8595030, this=0xf4b03008, connection=0x856cb00)
[10/15/16 13:39:02] [DEBUG] CQuery::Execute(this=0x8595030, connection=0x856cb00)
[10/15/16 13:39:02] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Hergus'" successfully executed within 0.262 milliseconds
[10/15/16 13:39:02] [DEBUG] CResultSet::Create(connection=0x856cb00, query_str='SELECT id FROM Accounts WHERE Name = 'Hergus'')
[10/15/16 13:39:02] [DEBUG] created new resultset '0xf4100688'
[10/15/16 13:39:02] [DEBUG] fetched MySQL result '0xf41008e0'
[10/15/16 13:39:02] [DEBUG] allocated 0 bytes for PAWN result
[10/15/16 13:39:02] [DEBUG] CCallback::Execute(amx=0x8545d38, index=32, num_params=1)
[10/15/16 13:39:02] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/15/16 13:39:02] [DEBUG] processing internal specifier 'c'
[10/15/16 13:39:02] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:39:02] [DEBUG] executing AMX callback with index '32'
[10/15/16 13:39:02] [DEBUG] cache_get_row_count(0xF542E9B4) (Nitradoscript.p:296)
[10/15/16 13:39:02] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/15/16 13:39:02] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:39:02] [INFO] Callback successfully executed.
[10/15/16 13:39:06] [DEBUG] mysql_format(1, 0xF542E5A8, 256, "INSERT INTO Accounts (Name, password) VALUES ('%s', MD5('%s'))") (Nitradoscript.p:1056)
[10/15/16 13:39:06] [DEBUG] mysql_format: return value: '70' (Nitradoscript.p:1056)
[10/15/16 13:39:06] [DEBUG] mysql_pquery(1, "INSERT INTO Accounts (Name, password) VALUES ('Hergus', MD5('jaguar'))", "OnUserRegister", "d") (Nitradoscript.p:1058)
[10/15/16 13:39:06] [DEBUG] CCallback::Create(amx=0x8545d38, name='OnUserRegister', format='d', params=0xf542e590, param_offset=5)
[10/15/16 13:39:06] [DEBUG] CCallback::Create - callback index for 'OnUserRegister': 34
[10/15/16 13:39:06] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 13:39:06] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:39:06] [INFO] Callback 'OnUserRegister' set up for delayed execution.
[10/15/16 13:39:06] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:39:06] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x85953e0)
[10/15/16 13:39:06] [DEBUG] CConnectionPool::Queue(query=0x85953e0, this=0x84cc490)
[10/15/16 13:39:06] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:39:06] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1058)
[10/15/16 13:39:06] [DEBUG] CConnection::Execute(query=0x85953e0, this=0xf4281008, connection=0x8573150)
[10/15/16 13:39:06] [DEBUG] CQuery::Execute(this=0x85953e0, connection=0x8573150)
[10/15/16 13:39:06] [INFO] query "INSERT INTO Accounts (Name, password) VALUES ('Hergus', MD5('jaguar'))" successfully executed within 1.122 milliseconds
[10/15/16 13:39:06] [DEBUG] CResultSet::Create(connection=0x8573150, query_str='INSERT INTO Accounts (Name, password) VALUES ('Hergus', MD5('jaguar'))')
[10/15/16 13:39:06] [DEBUG] created new resultset '0xf3700618'
[10/15/16 13:39:06] [DEBUG] fetched MySQL result '0x0'
[10/15/16 13:39:06] [DEBUG] CCallback::Execute(amx=0x8545d38, index=34, num_params=1)
[10/15/16 13:39:06] [INFO] Executing callback 'OnUserRegister' with 1 parameter...
[10/15/16 13:39:06] [DEBUG] processing internal specifier 'c'
[10/15/16 13:39:06] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:39:06] [DEBUG] executing AMX callback with index '34'
[10/15/16 13:39:06] [DEBUG] cache_insert_id() (Nitradoscript.p:1114)
[10/15/16 13:39:06] [DEBUG] cache_insert_id: return value: '3' (Nitradoscript.p:1114)
[10/15/16 13:39:06] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:39:06] [INFO] Callback successfully executed.
[10/15/16 13:40:37] [DEBUG] mysql_format(1, 0xF542E7B4, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/15/16 13:40:37] [DEBUG] CHandle::EscapeString(this=0x83d4ab0, src='Hergus')
[10/15/16 13:40:37] [DEBUG] CConnection::EscapeString(src='Hergus', this=0x84c56d0, connection=0x8546178)
[10/15/16 13:40:37] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Hergus'
[10/15/16 13:40:37] [DEBUG] mysql_format: return value: '45' (Nitradoscript.p:270)
[10/15/16 13:40:37] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Hergus'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/15/16 13:40:37] [DEBUG] CCallback::Create(amx=0x8545d38, name='OnUserCheck', format='d', params=0xf542e79c, param_offset=5)
[10/15/16 13:40:37] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/15/16 13:40:37] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 13:40:37] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:40:37] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/15/16 13:40:37] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:40:37] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x8594fe0)
[10/15/16 13:40:37] [DEBUG] CConnectionPool::Queue(query=0x8594fe0, this=0x84cc490)
[10/15/16 13:40:37] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:40:37] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/15/16 13:40:37] [DEBUG] CConnection::Execute(query=0x8594fe0, this=0xf4b03008, connection=0x856cb00)
[10/15/16 13:40:37] [DEBUG] CQuery::Execute(this=0x8594fe0, connection=0x856cb00)
[10/15/16 13:40:37] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Hergus'" successfully executed within 0.257 milliseconds
[10/15/16 13:40:37] [DEBUG] CResultSet::Create(connection=0x856cb00, query_str='SELECT id FROM Accounts WHERE Name = 'Hergus'')
[10/15/16 13:40:37] [DEBUG] created new resultset '0xf4100530'
[10/15/16 13:40:37] [DEBUG] fetched MySQL result '0xf41007a8'
[10/15/16 13:40:37] [DEBUG] allocated 20 bytes for PAWN result
[10/15/16 13:40:37] [DEBUG] CCallback::Execute(amx=0x8545d38, index=32, num_params=1)
[10/15/16 13:40:37] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/15/16 13:40:37] [DEBUG] processing internal specifier 'c'
[10/15/16 13:40:37] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:40:37] [DEBUG] executing AMX callback with index '32'
[10/15/16 13:40:37] [DEBUG] cache_get_row_count(0xF542E9B4) (Nitradoscript.p:296)
[10/15/16 13:40:37] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/15/16 13:40:37] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:40:37] [INFO] Callback successfully executed.
[10/15/16 13:40:38] [DEBUG] mysql_format(1, 0xF542E5A8, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/15/16 13:40:38] [DEBUG] mysql_format: return value: '73' (Nitradoscript.p:1069)
[10/15/16 13:40:38] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Hergus' AND password = MD5('jaguar')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/15/16 13:40:38] [DEBUG] CCallback::Create(amx=0x8545d38, name='OnUserLogin', format='d', params=0xf542e590, param_offset=5)
[10/15/16 13:40:38] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/15/16 13:40:38] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 13:40:38] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:40:38] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/15/16 13:40:38] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:40:38] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x8595518)
[10/15/16 13:40:38] [DEBUG] CConnectionPool::Queue(query=0x8595518, this=0x84cc490)
[10/15/16 13:40:38] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:40:38] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/15/16 13:40:38] [DEBUG] CConnection::Execute(query=0x8595518, this=0xf4281008, connection=0x8573150)
[10/15/16 13:40:38] [DEBUG] CQuery::Execute(this=0x8595518, connection=0x8573150)
[10/15/16 13:40:38] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Hergus' AND password = MD5('jaguar')" successfully executed within 0.330 milliseconds
[10/15/16 13:40:38] [DEBUG] CResultSet::Create(connection=0x8573150, query_str='SELECT * FROM Accounts WHERE Name = 'Hergus' AND password = MD5('jaguar')')
[10/15/16 13:40:38] [DEBUG] created new resultset '0xf3700748'
[10/15/16 13:40:38] [DEBUG] fetched MySQL result '0xf3700628'
[10/15/16 13:40:38] [DEBUG] allocated 100 bytes for PAWN result
[10/15/16 13:40:38] [DEBUG] CCallback::Execute(amx=0x8545d38, index=33, num_params=1)
[10/15/16 13:40:38] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/15/16 13:40:38] [DEBUG] processing internal specifier 'c'
[10/15/16 13:40:38] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:40:38] [DEBUG] executing AMX callback with index '33'
[10/15/16 13:40:38] [DEBUG] cache_get_row_count(0xF542E9B4) (Nitradoscript.p:1121)
[10/15/16 13:40:38] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "id", 0xF5419620) (Nitradoscript.p:1131)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '3' (Nitradoscript.p:1131)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1131)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Name", 0xF5419628) (Nitradoscript.p:1132)
[10/15/16 13:40:38] [ERROR] cache_get_value_name_int: value 'Hergus' is not a number (Nitradoscript.p:1132)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Adminlevel", 0xF5419688) (Nitradoscript.p:1133)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '7' (Nitradoscript.p:1133)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1133)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Level", 0xF541968C) (Nitradoscript.p:1134)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '2' (Nitradoscript.p:1134)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1134)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Money", 0xF5419690) (Nitradoscript.p:1135)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1135)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1135)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF5419694) (Nitradoscript.p:1136)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1136)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Rang", 0xF5419698) (Nitradoscript.p:1137)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1137)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1137)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int(0, "Spawn", 0xF541969C) (Nitradoscript.p:1138)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1138)
[10/15/16 13:40:38] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1138)
[10/15/16 13:40:38] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:40:38] [INFO] Callback successfully executed.
[10/15/16 13:41:10] [DEBUG] mysql_pquery(1, "INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('3','411','1707.832519','-2287.573242','-1.231296','44.303760')", "carSavedToDB", "i") (Nitradoscript.p:879)
[10/15/16 13:41:10] [DEBUG] CCallback::Create(amx=0x8545d38, name='carSavedToDB', format='i', params=0xf542e498, param_offset=5)
[10/15/16 13:41:10] [DEBUG] CCallback::Create - callback index for 'carSavedToDB': -10057
[10/15/16 13:41:10] [DEBUG] processing specifier 'i' with parameter index 0
[10/15/16 13:41:10] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:41:10] [INFO] Callback 'carSavedToDB' set up for delayed execution.
[10/15/16 13:41:10] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:41:10] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x8594ee0)
[10/15/16 13:41:10] [DEBUG] CConnectionPool::Queue(query=0x8594ee0, this=0x84cc490)
[10/15/16 13:41:10] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:41:10] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:879)
[10/15/16 13:41:10] [DEBUG] CConnection::Execute(query=0x8594ee0, this=0xf4b03008, connection=0x856cb00)
[10/15/16 13:41:10] [DEBUG] CQuery::Execute(this=0x8594ee0, connection=0x856cb00)
[10/15/16 13:41:10] [INFO] query "INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('3','411','1707.832519','-2287.573242','-1.231296','44.303760')" successfully executed within 1.730 milliseconds
[10/15/16 13:41:10] [DEBUG] CResultSet::Create(connection=0x856cb00, query_str='INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('3','411','1707.832519','-2287.573242','-1.231296','44.303760')')
[10/15/16 13:41:10] [DEBUG] created new resultset '0xf4100808'
[10/15/16 13:41:10] [DEBUG] fetched MySQL result '0x0'
[10/15/16 13:41:10] [DEBUG] CCallback::Execute(amx=0x8545d38, index=-10057, num_params=1)
[10/15/16 13:41:10] [INFO] Executing callback '��' with 1 parameter...
[10/15/16 13:41:10] [DEBUG] processing internal specifier 'c'
[10/15/16 13:41:10] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:41:10] [DEBUG] executing AMX callback with index '-10057'
[10/15/16 13:41:10] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:41:10] [INFO] Callback successfully executed.
[10/15/16 13:42:46] [DEBUG] mysql_format(1, 0xF542E7B4, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/15/16 13:42:46] [DEBUG] CHandle::EscapeString(this=0x83d4ab0, src='Hergus')
[10/15/16 13:42:46] [DEBUG] CConnection::EscapeString(src='Hergus', this=0x84c56d0, connection=0x8546178)
[10/15/16 13:42:46] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Hergus'
[10/15/16 13:42:46] [DEBUG] mysql_format: return value: '45' (Nitradoscript.p:270)
[10/15/16 13:42:46] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Hergus'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/15/16 13:42:46] [DEBUG] CCallback::Create(amx=0x8545d38, name='OnUserCheck', format='d', params=0xf542e79c, param_offset=5)
[10/15/16 13:42:46] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/15/16 13:42:46] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 13:42:46] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:42:46] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/15/16 13:42:46] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:42:46] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x8594ae0)
[10/15/16 13:42:46] [DEBUG] CConnectionPool::Queue(query=0x8594ae0, this=0x84cc490)
[10/15/16 13:42:46] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:42:46] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/15/16 13:42:46] [DEBUG] CConnection::Execute(query=0x8594ae0, this=0xf4281008, connection=0x8573150)
[10/15/16 13:42:46] [DEBUG] CQuery::Execute(this=0x8594ae0, connection=0x8573150)
[10/15/16 13:42:46] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Hergus'" successfully executed within 0.285 milliseconds
[10/15/16 13:42:46] [DEBUG] CResultSet::Create(connection=0x8573150, query_str='SELECT id FROM Accounts WHERE Name = 'Hergus'')
[10/15/16 13:42:46] [DEBUG] created new resultset '0xf3700708'
[10/15/16 13:42:46] [DEBUG] fetched MySQL result '0xf3700a88'
[10/15/16 13:42:46] [DEBUG] allocated 20 bytes for PAWN result
[10/15/16 13:42:46] [DEBUG] CCallback::Execute(amx=0x8545d38, index=32, num_params=1)
[10/15/16 13:42:46] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/15/16 13:42:46] [DEBUG] processing internal specifier 'c'
[10/15/16 13:42:46] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:42:46] [DEBUG] executing AMX callback with index '32'
[10/15/16 13:42:46] [DEBUG] cache_get_row_count(0xF542E9B4) (Nitradoscript.p:296)
[10/15/16 13:42:46] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/15/16 13:42:46] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:42:46] [INFO] Callback successfully executed.
[10/15/16 13:42:48] [DEBUG] mysql_format(1, 0xF542E5A8, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/15/16 13:42:48] [DEBUG] mysql_format: return value: '73' (Nitradoscript.p:1069)
[10/15/16 13:42:48] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Hergus' AND password = MD5('jaguar')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/15/16 13:42:48] [DEBUG] CCallback::Create(amx=0x8545d38, name='OnUserLogin', format='d', params=0xf542e590, param_offset=5)
[10/15/16 13:42:48] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/15/16 13:42:48] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 13:42:48] [DEBUG] retrieved and pushed value '0'
[10/15/16 13:42:48] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/15/16 13:42:48] [DEBUG] created delayed callback with 1 parameter
[10/15/16 13:42:48] [DEBUG] CHandle::Execute(this=0x83d4ab0, type=2, query=0x8595440)
[10/15/16 13:42:48] [DEBUG] CConnectionPool::Queue(query=0x8595440, this=0x84cc490)
[10/15/16 13:42:48] [DEBUG] CHandle::Execute - return value: true
[10/15/16 13:42:48] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/15/16 13:42:48] [DEBUG] CConnection::Execute(query=0x8595440, this=0xf4b03008, connection=0x856cb00)
[10/15/16 13:42:48] [DEBUG] CQuery::Execute(this=0x8595440, connection=0x856cb00)
[10/15/16 13:42:48] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Hergus' AND password = MD5('jaguar')" successfully executed within 0.288 milliseconds
[10/15/16 13:42:48] [DEBUG] CResultSet::Create(connection=0x856cb00, query_str='SELECT * FROM Accounts WHERE Name = 'Hergus' AND password = MD5('jaguar')')
[10/15/16 13:42:48] [DEBUG] created new resultset '0xf41004f0'
[10/15/16 13:42:48] [DEBUG] fetched MySQL result '0xf41007a0'
[10/15/16 13:42:48] [DEBUG] allocated 100 bytes for PAWN result
[10/15/16 13:42:48] [DEBUG] CCallback::Execute(amx=0x8545d38, index=33, num_params=1)
[10/15/16 13:42:48] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/15/16 13:42:48] [DEBUG] processing internal specifier 'c'
[10/15/16 13:42:48] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 13:42:48] [DEBUG] executing AMX callback with index '33'
[10/15/16 13:42:48] [DEBUG] cache_get_row_count(0xF542E9B4) (Nitradoscript.p:1121)
[10/15/16 13:42:48] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "id", 0xF5419620) (Nitradoscript.p:1131)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '3' (Nitradoscript.p:1131)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1131)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Name", 0xF5419628) (Nitradoscript.p:1132)
[10/15/16 13:42:48] [ERROR] cache_get_value_name_int: value 'Hergus' is not a number (Nitradoscript.p:1132)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Adminlevel", 0xF5419688) (Nitradoscript.p:1133)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '7' (Nitradoscript.p:1133)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1133)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Level", 0xF541968C) (Nitradoscript.p:1134)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '2' (Nitradoscript.p:1134)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1134)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Money", 0xF5419690) (Nitradoscript.p:1135)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1135)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1135)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF5419694) (Nitradoscript.p:1136)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1136)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Rang", 0xF5419698) (Nitradoscript.p:1137)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1137)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1137)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Spawn", 0xF541969C) (Nitradoscript.p:1138)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1138)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1138)
[10/15/16 13:42:48] [DEBUG] AMX callback executed with error '0'
[10/15/16 13:42:48] [INFO] Callback successfully executed.

Alles anzeigen

OnUserLogin und SaveUserStats:

Spoiler anzeigen

Jeffry · 15. Oktober 2016

Das liegt daran, dass du in Fraktion 0 bist:
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF5419694) (Nitradoscript.p:1136)
[10/15/16 13:42:48] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)

Prüfe was in deiner Datenbank steht, und setze dem Spieler die korrekte Fraktion.

Markuslobicher · 15. Oktober 2016

Er Speichert ja nicht mal die Accounts richtig und ich weiß nicht Wieso.

Hier alles was mit dem Register/Login so wie Spielerenum und Fraktionsenum zu tun hat:
X = Zensiert!

Dialogdefine:

Spoiler anzeigen

Spieler und Fraktions Enum:

Spoiler anzeigen

OnGamemodeInit und OnGamemodeExit:

Spoiler anzeigen

OnPlayerRequestClass OnPlayerConnect OnUserCheck resetplayer:

Spoiler anzeigen

OnPlayerDisconnect und OnPlayerSpawn:

Spoiler anzeigen

Admin und Fraktionsabfrage:

Spoiler anzeigen

getPlayerName:

Spoiler anzeigen

Fraktionsbefehle und Leadererstellenbefehl:

Spoiler anzeigen

Code

ocmd:annehmen(playerid, params[])
{
	new item[64];
	if(sscanf(params,"s[64]",item))return SendClientMessage(
	    playerid, gelb, "INFO: /accept [invite]");
	if(!strcmp(item, "invite", false))
	{
	    if(GetPVarInt(playerid, "inv_fraktid") == 0)return SendClientMessage(
	        playerid, grün, "Du wurdest in keine Fraktion eingeladen.");
		new fID = GetPVarInt(playerid, "inv_fraktid");
		sInfo[playerid][Fraktion] = fID;
		sInfo[playerid][Rang] = 1;
		new string[128];
		format(string,sizeof(string), "Du bist der Fraktion %s beigetreten.",
		    fInfo[fID][f_name]);
		SendClientMessage(playerid, grün, string);
		format(string,sizeof(string), "%s ist der Fraktion beigetreten.",
			getPlayerName(playerid));
		SendClientMessage(GetPVarInt(playerid, "inv_inviter"), grün,
		    string);
		SetPVarInt(playerid, "inv_fraktid", 0);
		return 1;
	}
	return 1;
}
  ocmd:spawnchange(playerid,params[])
{
	if(isPlayerInFrakt(playerid,0)) return SendClientMessage(playerid,rot,"Du bist in keiner Fraktion.");
	if(sInfo[playerid][Spawn] == 0)
	{
		sInfo[playerid][Spawn] = 1;
	}
	else
	{
		sInfo[playerid][Spawn]=0;
	}
	SendClientMessage(playerid,grün,"Spawn geändert");
	return 1;
}




ocmd:fc(playerid,params[])
{
	if(isPlayerInFrakt(playerid, 0))return SendClientMessage(
	    playerid, rot, "Du bist in keiner Fraktion.");
	new string[128];
	if(sscanf(params, "s[128]", string))return SendClientMessage(
	    playerid, rot, "INFO: /f [nachricht]");
	new fID = sInfo[playerid][Fraktion];
	format(string,sizeof(string), "**(( %s: %s ))**", getPlayerName(playerid), string);
	for(new i=0; i<MAX_PLAYERS; i++)
	{
	    if(!IsPlayerConnected(i))continue;
	    if(!isPlayerInFrakt(i, fID))continue;
	    SendClientMessage(i, helblau, string);
	}
	return 1;
}
ocmd:einladen(playerid,params[])
{
    if(isPlayerInFrakt(playerid, 0))return SendClientMessage(
		playerid, helblau, "Du bist in keiner Fraktion.");
	if(sInfo[playerid][Rang] < 6)return SendClientMessage(
	    playerid, helblau, "Dein Rang ist zu niedrig.");
	new pID, fID;
	fID = sInfo[playerid][Fraktion];
	if(sscanf(params, "u", pID))return SendClientMessage(
	    playerid, gelb, "INFO: /invite [playerid]");
	if(!isPlayerInFrakt(pID, 0))return SendClientMessage(
	    playerid, gelb, "Spieler ist kein Zivilist.");
	new string[128];
	format(string,sizeof(string), "%s hat dich in die Fraktion %s eingeladen.",
		getPlayerName(playerid), fInfo[fID][f_name]);
	SendClientMessage(pID, gelb, string);
	SendClientMessage(pID, gelb,
		"Zum akzeptieren /accept invite eingeben.");
	SetPVarInt(pID, "inv_fraktid", fID);
	SetPVarInt(pID, "inv_inviter", playerid);
	return 1;
}


ocmd:fraktionshilfe(playerid,params[])
{
	if(isPlayerInFrakt(playerid,0))return SendClientMessage(playerid,rot,"Du bist in keiner Fraktion");
	SendClientMessage(playerid,grün,"/fc");
	SendClientMessage(playerid,rot,"/einladen");
	SendClientMessage(playerid,grün,"/annehmen");
	SendClientMessage(playerid,rot,"/spawnchange");
	SendClientMessage(playerid,grün,"/einladen");
	return 1;
}


ocmd:verbrechen(playerid,params[])
{
  if(!isPlayerInFrakt(playerid,1))return SendClientMessage(playerid,rot,"Du bist nicht im SAPD!");
  {
  	new pID,wLevel;
  	if(sscanf(params,"ii",pID,wLevel))return SendClientMessage(playerid,duneklhelblau,"Info: /Fandungslevel[playerid][fandungslevel]");
  	if(wLevel<-1||wLevel>6)return SendClientMessage(playerid,rot,"Falsche Fandungslevel!");
  	SetPlayerWantedLevel(pID,wLevel);
  	return 1;
  }  
}


ocmd:leadererstellen(playerid,params[])
{
	if(!isAdmin(playerid,5))return SendClientMessage(playerid,grün,"Du hast keine Berechtigung dazu!");
	new pID, fID;
	if(sscanf(params,"ui",pID,fID))return SendClientMessage(playerid,rot,"INFO: /Leadererstellen[playerid][fraktid]");
	if(fID>= sizeof(fInfo))return SendClientMessage(playerid,rot,"Fraktion existiert nicht.");
	sInfo[pID][Fraktion] = fID;
	sInfo[pID][Rang] = 6;
	new string[128];
	format(string,sizeof(string),"%s hat dich zum Leader der Fraktion %s gemacht",getPlayerName(playerid),fInfo[fID][f_name]);
	SendClientMessage(pID,gelb,string);
	SendClientMessage(playerid,grün,"Du hast einen Spieler zum Leader gemacht.");
	return 1;
}

Alles anzeigen

OnDialogResponse:

Spoiler anzeigen

MySQL_SetupConnection:

Spoiler anzeigen

OnUserRegister und OnUserLogin:

Spoiler anzeigen

SaveUserStats und SpielerName:

Spoiler anzeigen

Jeffry · 15. Oktober 2016

Lass dir das Query beim Speichern mal mit Print ausgeben und poste was dann im Server Log steht.

Markuslobicher · 15. Oktober 2016

Mysql_Log:

Spoiler anzeigen

SQL

[10/15/16 14:54:56] [INFO] changed log level from 'warning, error' to 'debug, info, warning, error'
[10/15/16 14:56:42] [DEBUG] mysql_format(1, 0xF5459898, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/15/16 14:56:42] [DEBUG] CHandle::EscapeString(this=0x9896ab0, src='Pergus')
[10/15/16 14:56:42] [DEBUG] CConnection::EscapeString(src='Pergus', this=0x99876d0, connection=0x9a08178)
[10/15/16 14:56:42] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Pergus'
[10/15/16 14:56:42] [DEBUG] mysql_format: return value: '45' (Nitradoscript.p:270)
[10/15/16 14:56:42] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Pergus'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/15/16 14:56:42] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserCheck', format='d', params=0xf5459880, param_offset=5)
[10/15/16 14:56:42] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/15/16 14:56:42] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 14:56:42] [DEBUG] retrieved and pushed value '0'
[10/15/16 14:56:42] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/15/16 14:56:42] [DEBUG] created delayed callback with 1 parameter
[10/15/16 14:56:42] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a57038)
[10/15/16 14:56:42] [DEBUG] CConnectionPool::Queue(query=0x9a57038, this=0x998e490)
[10/15/16 14:56:42] [DEBUG] CHandle::Execute - return value: true
[10/15/16 14:56:42] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/15/16 14:56:42] [DEBUG] CConnection::Execute(query=0x9a57038, this=0xf4b2e008, connection=0x9a2eb08)
[10/15/16 14:56:42] [DEBUG] CQuery::Execute(this=0x9a57038, connection=0x9a2eb08)
[10/15/16 14:56:42] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Pergus'" successfully executed within 0.305 milliseconds
[10/15/16 14:56:42] [DEBUG] CResultSet::Create(connection=0x9a2eb08, query_str='SELECT id FROM Accounts WHERE Name = 'Pergus'')
[10/15/16 14:56:42] [DEBUG] created new resultset '0xf41005c8'
[10/15/16 14:56:42] [DEBUG] fetched MySQL result '0xf4100800'
[10/15/16 14:56:42] [DEBUG] allocated 0 bytes for PAWN result
[10/15/16 14:56:42] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=32, num_params=1)
[10/15/16 14:56:42] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/15/16 14:56:42] [DEBUG] processing internal specifier 'c'
[10/15/16 14:56:42] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 14:56:42] [DEBUG] executing AMX callback with index '32'
[10/15/16 14:56:42] [DEBUG] cache_get_row_count(0xF5459A98) (Nitradoscript.p:296)
[10/15/16 14:56:42] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/15/16 14:56:42] [DEBUG] AMX callback executed with error '0'
[10/15/16 14:56:42] [INFO] Callback successfully executed.
[10/15/16 14:56:44] [DEBUG] mysql_format(1, 0xF545968C, 256, "INSERT INTO Accounts (Name, password) VALUES ('%s', MD5('%s'))") (Nitradoscript.p:1056)
[10/15/16 14:56:44] [DEBUG] mysql_format: return value: '70' (Nitradoscript.p:1056)
[10/15/16 14:56:44] [DEBUG] mysql_pquery(1, "INSERT INTO Accounts (Name, password) VALUES ('Pergus', MD5('jagaur'))", "OnUserRegister", "d") (Nitradoscript.p:1058)
[10/15/16 14:56:44] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserRegister', format='d', params=0xf5459674, param_offset=5)
[10/15/16 14:56:44] [DEBUG] CCallback::Create - callback index for 'OnUserRegister': 34
[10/15/16 14:56:44] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 14:56:44] [DEBUG] retrieved and pushed value '0'
[10/15/16 14:56:44] [INFO] Callback 'OnUserRegister' set up for delayed execution.
[10/15/16 14:56:44] [DEBUG] created delayed callback with 1 parameter
[10/15/16 14:56:44] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a57408)
[10/15/16 14:56:44] [DEBUG] CConnectionPool::Queue(query=0x9a57408, this=0x998e490)
[10/15/16 14:56:44] [DEBUG] CHandle::Execute - return value: true
[10/15/16 14:56:44] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1058)
[10/15/16 14:56:44] [DEBUG] CConnection::Execute(query=0x9a57408, this=0xf42ac008, connection=0x9a35158)
[10/15/16 14:56:44] [DEBUG] CQuery::Execute(this=0x9a57408, connection=0x9a35158)
[10/15/16 14:56:44] [INFO] query "INSERT INTO Accounts (Name, password) VALUES ('Pergus', MD5('jagaur'))" successfully executed within 0.537 milliseconds
[10/15/16 14:56:44] [DEBUG] CResultSet::Create(connection=0x9a35158, query_str='INSERT INTO Accounts (Name, password) VALUES ('Pergus', MD5('jagaur'))')
[10/15/16 14:56:44] [DEBUG] created new resultset '0xf3700618'
[10/15/16 14:56:44] [DEBUG] fetched MySQL result '0x0'
[10/15/16 14:56:44] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=34, num_params=1)
[10/15/16 14:56:44] [INFO] Executing callback 'OnUserRegister' with 1 parameter...
[10/15/16 14:56:44] [DEBUG] processing internal specifier 'c'
[10/15/16 14:56:44] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 14:56:44] [DEBUG] executing AMX callback with index '34'
[10/15/16 14:56:44] [DEBUG] cache_insert_id() (Nitradoscript.p:1114)
[10/15/16 14:56:44] [DEBUG] cache_insert_id: return value: '4' (Nitradoscript.p:1114)
[10/15/16 14:56:44] [DEBUG] AMX callback executed with error '0'
[10/15/16 14:56:44] [INFO] Callback successfully executed.
[10/15/16 14:59:23] [DEBUG] mysql_format(1, 0xF5459898, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/15/16 14:59:23] [DEBUG] CHandle::EscapeString(this=0x9896ab0, src='Tiriago')
[10/15/16 14:59:23] [DEBUG] CConnection::EscapeString(src='Tiriago', this=0x99876d0, connection=0x9a08178)
[10/15/16 14:59:23] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Tiriago'
[10/15/16 14:59:23] [DEBUG] mysql_format: return value: '46' (Nitradoscript.p:270)
[10/15/16 14:59:23] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Tiriago'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/15/16 14:59:23] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserCheck', format='d', params=0xf5459880, param_offset=5)
[10/15/16 14:59:23] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/15/16 14:59:23] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 14:59:23] [DEBUG] retrieved and pushed value '0'
[10/15/16 14:59:23] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/15/16 14:59:23] [DEBUG] created delayed callback with 1 parameter
[10/15/16 14:59:23] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a56fe8)
[10/15/16 14:59:23] [DEBUG] CConnectionPool::Queue(query=0x9a56fe8, this=0x998e490)
[10/15/16 14:59:23] [DEBUG] CHandle::Execute - return value: true
[10/15/16 14:59:23] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/15/16 14:59:23] [DEBUG] CConnection::Execute(query=0x9a56fe8, this=0xf4b2e008, connection=0x9a2eb08)
[10/15/16 14:59:23] [DEBUG] CQuery::Execute(this=0x9a56fe8, connection=0x9a2eb08)
[10/15/16 14:59:23] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Tiriago'" successfully executed within 0.290 milliseconds
[10/15/16 14:59:23] [DEBUG] CResultSet::Create(connection=0x9a2eb08, query_str='SELECT id FROM Accounts WHERE Name = 'Tiriago'')
[10/15/16 14:59:23] [DEBUG] created new resultset '0xf4100530'
[10/15/16 14:59:23] [DEBUG] fetched MySQL result '0xf41007a8'
[10/15/16 14:59:23] [DEBUG] allocated 20 bytes for PAWN result
[10/15/16 14:59:23] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=32, num_params=1)
[10/15/16 14:59:23] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/15/16 14:59:23] [DEBUG] processing internal specifier 'c'
[10/15/16 14:59:23] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 14:59:23] [DEBUG] executing AMX callback with index '32'
[10/15/16 14:59:23] [DEBUG] cache_get_row_count(0xF5459A98) (Nitradoscript.p:296)
[10/15/16 14:59:23] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/15/16 14:59:23] [DEBUG] AMX callback executed with error '0'
[10/15/16 14:59:23] [INFO] Callback successfully executed.
[10/15/16 14:59:28] [DEBUG] mysql_format(1, 0xF545968C, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/15/16 14:59:28] [DEBUG] mysql_format: return value: '74' (Nitradoscript.p:1069)
[10/15/16 14:59:28] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/15/16 14:59:28] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserLogin', format='d', params=0xf5459674, param_offset=5)
[10/15/16 14:59:28] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/15/16 14:59:28] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 14:59:28] [DEBUG] retrieved and pushed value '0'
[10/15/16 14:59:28] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/15/16 14:59:28] [DEBUG] created delayed callback with 1 parameter
[10/15/16 14:59:28] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a57520)
[10/15/16 14:59:28] [DEBUG] CConnectionPool::Queue(query=0x9a57520, this=0x998e490)
[10/15/16 14:59:28] [DEBUG] CHandle::Execute - return value: true
[10/15/16 14:59:28] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/15/16 14:59:28] [DEBUG] CConnection::Execute(query=0x9a57520, this=0xf42ac008, connection=0x9a35158)
[10/15/16 14:59:28] [DEBUG] CQuery::Execute(this=0x9a57520, connection=0x9a35158)
[10/15/16 14:59:28] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')" successfully executed within 0.324 milliseconds
[10/15/16 14:59:28] [DEBUG] CResultSet::Create(connection=0x9a35158, query_str='SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')')
[10/15/16 14:59:28] [DEBUG] created new resultset '0xf3700748'
[10/15/16 14:59:28] [DEBUG] fetched MySQL result '0xf3700630'
[10/15/16 14:59:28] [DEBUG] allocated 100 bytes for PAWN result
[10/15/16 14:59:28] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=33, num_params=1)
[10/15/16 14:59:28] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/15/16 14:59:28] [DEBUG] processing internal specifier 'c'
[10/15/16 14:59:28] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 14:59:28] [DEBUG] executing AMX callback with index '33'
[10/15/16 14:59:28] [DEBUG] cache_get_row_count(0xF5459A98) (Nitradoscript.p:1121)
[10/15/16 14:59:28] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "id", 0xF5444648) (Nitradoscript.p:1131)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '1' (Nitradoscript.p:1131)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1131)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Name", 0xF5444650) (Nitradoscript.p:1132)
[10/15/16 14:59:28] [ERROR] cache_get_value_name_int: value 'Tiriago' is not a number (Nitradoscript.p:1132)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Adminlevel", 0xF54446B0) (Nitradoscript.p:1133)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '7' (Nitradoscript.p:1133)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1133)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Level", 0xF54446B4) (Nitradoscript.p:1134)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '2' (Nitradoscript.p:1134)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1134)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Money", 0xF54446B8) (Nitradoscript.p:1135)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1135)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1135)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF54446BC) (Nitradoscript.p:1136)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1136)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Rang", 0xF54446C0) (Nitradoscript.p:1137)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1137)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1137)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int(0, "Spawn", 0xF54446C4) (Nitradoscript.p:1138)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1138)
[10/15/16 14:59:28] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1138)
[10/15/16 14:59:28] [DEBUG] AMX callback executed with error '0'
[10/15/16 14:59:28] [INFO] Callback successfully executed.
[10/15/16 14:59:55] [DEBUG] mysql_pquery(1, "INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('1','411','1708.658203','-2291.018798','-1.224802','323.390472')", "carSavedToDB", "i") (Nitradoscript.p:879)
[10/15/16 14:59:55] [DEBUG] CCallback::Create(amx=0x9a07d38, name='carSavedToDB', format='i', params=0xf545957c, param_offset=5)
[10/15/16 14:59:55] [DEBUG] CCallback::Create - callback index for 'carSavedToDB': -10057
[10/15/16 14:59:55] [DEBUG] processing specifier 'i' with parameter index 0
[10/15/16 14:59:55] [DEBUG] retrieved and pushed value '0'
[10/15/16 14:59:55] [INFO] Callback 'carSavedToDB' set up for delayed execution.
[10/15/16 14:59:55] [DEBUG] created delayed callback with 1 parameter
[10/15/16 14:59:55] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a56ee8)
[10/15/16 14:59:55] [DEBUG] CConnectionPool::Queue(query=0x9a56ee8, this=0x998e490)
[10/15/16 14:59:55] [DEBUG] CHandle::Execute - return value: true
[10/15/16 14:59:55] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:879)
[10/15/16 14:59:55] [DEBUG] CConnection::Execute(query=0x9a56ee8, this=0xf4b2e008, connection=0x9a2eb08)
[10/15/16 14:59:55] [DEBUG] CQuery::Execute(this=0x9a56ee8, connection=0x9a2eb08)
[10/15/16 14:59:55] [INFO] query "INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('1','411','1708.658203','-2291.018798','-1.224802','323.390472')" successfully executed within 1.99 milliseconds
[10/15/16 14:59:55] [DEBUG] CResultSet::Create(connection=0x9a2eb08, query_str='INSERT INTO autos(besitzer,model,x,y,z,r) VALUES('1','411','1708.658203','-2291.018798','-1.224802','323.390472')')
[10/15/16 14:59:55] [DEBUG] created new resultset '0xf4100808'
[10/15/16 14:59:55] [DEBUG] fetched MySQL result '0x0'
[10/15/16 14:59:55] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=-10057, num_params=1)
[10/15/16 14:59:55] [INFO] Executing callback 'Ù' with 1 parameter...
[10/15/16 14:59:55] [DEBUG] processing internal specifier 'c'
[10/15/16 14:59:55] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 14:59:55] [DEBUG] executing AMX callback with index '-10057'
[10/15/16 14:59:55] [DEBUG] AMX callback executed with error '0'
[10/15/16 14:59:55] [INFO] Callback successfully executed.
[10/15/16 15:01:14] [DEBUG] mysql_format(1, 0xF5459898, 128, "SELECT id FROM Accounts WHERE Name = '%e'") (Nitradoscript.p:270)
[10/15/16 15:01:14] [DEBUG] CHandle::EscapeString(this=0x9896ab0, src='Tiriago')
[10/15/16 15:01:14] [DEBUG] CConnection::EscapeString(src='Tiriago', this=0x99876d0, connection=0x9a08178)
[10/15/16 15:01:14] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Tiriago'
[10/15/16 15:01:14] [DEBUG] mysql_format: return value: '46' (Nitradoscript.p:270)
[10/15/16 15:01:14] [DEBUG] mysql_pquery(1, "SELECT id FROM Accounts WHERE Name = 'Tiriago'", "OnUserCheck", "d") (Nitradoscript.p:271)
[10/15/16 15:01:14] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserCheck', format='d', params=0xf5459880, param_offset=5)
[10/15/16 15:01:14] [DEBUG] CCallback::Create - callback index for 'OnUserCheck': 32
[10/15/16 15:01:14] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 15:01:14] [DEBUG] retrieved and pushed value '0'
[10/15/16 15:01:14] [INFO] Callback 'OnUserCheck' set up for delayed execution.
[10/15/16 15:01:14] [DEBUG] created delayed callback with 1 parameter
[10/15/16 15:01:14] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a56ae8)
[10/15/16 15:01:14] [DEBUG] CConnectionPool::Queue(query=0x9a56ae8, this=0x998e490)
[10/15/16 15:01:14] [DEBUG] CHandle::Execute - return value: true
[10/15/16 15:01:14] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:271)
[10/15/16 15:01:14] [DEBUG] CConnection::Execute(query=0x9a56ae8, this=0xf42ac008, connection=0x9a35158)
[10/15/16 15:01:14] [DEBUG] CQuery::Execute(this=0x9a56ae8, connection=0x9a35158)
[10/15/16 15:01:14] [INFO] query "SELECT id FROM Accounts WHERE Name = 'Tiriago'" successfully executed within 0.265 milliseconds
[10/15/16 15:01:14] [DEBUG] CResultSet::Create(connection=0x9a35158, query_str='SELECT id FROM Accounts WHERE Name = 'Tiriago'')
[10/15/16 15:01:14] [DEBUG] created new resultset '0xf37009a8'
[10/15/16 15:01:14] [DEBUG] fetched MySQL result '0xf3700550'
[10/15/16 15:01:14] [DEBUG] allocated 20 bytes for PAWN result
[10/15/16 15:01:14] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=32, num_params=1)
[10/15/16 15:01:14] [INFO] Executing callback 'OnUserCheck' with 1 parameter...
[10/15/16 15:01:14] [DEBUG] processing internal specifier 'c'
[10/15/16 15:01:14] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 15:01:14] [DEBUG] executing AMX callback with index '32'
[10/15/16 15:01:14] [DEBUG] cache_get_row_count(0xF5459A98) (Nitradoscript.p:296)
[10/15/16 15:01:14] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:296)
[10/15/16 15:01:14] [DEBUG] AMX callback executed with error '0'
[10/15/16 15:01:14] [INFO] Callback successfully executed.
[10/15/16 15:01:17] [DEBUG] mysql_format(1, 0xF545968C, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/15/16 15:01:17] [DEBUG] mysql_format: return value: '74' (Nitradoscript.p:1069)
[10/15/16 15:01:17] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jagaur')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/15/16 15:01:17] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserLogin', format='d', params=0xf5459674, param_offset=5)
[10/15/16 15:01:17] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/15/16 15:01:17] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 15:01:17] [DEBUG] retrieved and pushed value '0'
[10/15/16 15:01:17] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/15/16 15:01:17] [DEBUG] created delayed callback with 1 parameter
[10/15/16 15:01:17] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a57448)
[10/15/16 15:01:17] [DEBUG] CConnectionPool::Queue(query=0x9a57448, this=0x998e490)
[10/15/16 15:01:17] [DEBUG] CHandle::Execute - return value: true
[10/15/16 15:01:17] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/15/16 15:01:17] [DEBUG] CConnection::Execute(query=0x9a57448, this=0xf4b2e008, connection=0x9a2eb08)
[10/15/16 15:01:17] [DEBUG] CQuery::Execute(this=0x9a57448, connection=0x9a2eb08)
[10/15/16 15:01:17] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jagaur')" successfully executed within 0.281 milliseconds
[10/15/16 15:01:17] [DEBUG] CResultSet::Create(connection=0x9a2eb08, query_str='SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jagaur')')
[10/15/16 15:01:17] [DEBUG] created new resultset '0xf41004f0'
[10/15/16 15:01:17] [DEBUG] fetched MySQL result '0xf41007a8'
[10/15/16 15:01:17] [DEBUG] allocated 0 bytes for PAWN result
[10/15/16 15:01:17] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=33, num_params=1)
[10/15/16 15:01:17] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/15/16 15:01:17] [DEBUG] processing internal specifier 'c'
[10/15/16 15:01:17] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 15:01:17] [DEBUG] executing AMX callback with index '33'
[10/15/16 15:01:17] [DEBUG] cache_get_row_count(0xF5459A98) (Nitradoscript.p:1121)
[10/15/16 15:01:17] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/15/16 15:01:17] [DEBUG] AMX callback executed with error '0'
[10/15/16 15:01:17] [INFO] Callback successfully executed.
[10/15/16 15:01:20] [DEBUG] mysql_format(1, 0xF545968C, 256, "SELECT * FROM Accounts WHERE Name = '%s' AND password = MD5('%s')") (Nitradoscript.p:1069)
[10/15/16 15:01:20] [DEBUG] mysql_format: return value: '74' (Nitradoscript.p:1069)
[10/15/16 15:01:20] [DEBUG] mysql_pquery(1, "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')", "OnUserLogin", "d") (Nitradoscript.p:1071)
[10/15/16 15:01:20] [DEBUG] CCallback::Create(amx=0x9a07d38, name='OnUserLogin', format='d', params=0xf5459674, param_offset=5)
[10/15/16 15:01:20] [DEBUG] CCallback::Create - callback index for 'OnUserLogin': 33
[10/15/16 15:01:20] [DEBUG] processing specifier 'd' with parameter index 0
[10/15/16 15:01:20] [DEBUG] retrieved and pushed value '0'
[10/15/16 15:01:20] [INFO] Callback 'OnUserLogin' set up for delayed execution.
[10/15/16 15:01:20] [DEBUG] created delayed callback with 1 parameter
[10/15/16 15:01:20] [DEBUG] CHandle::Execute(this=0x9896ab0, type=2, query=0x9a57448)
[10/15/16 15:01:20] [DEBUG] CConnectionPool::Queue(query=0x9a57448, this=0x998e490)
[10/15/16 15:01:20] [DEBUG] CHandle::Execute - return value: true
[10/15/16 15:01:20] [DEBUG] mysql_pquery: return value: '1' (Nitradoscript.p:1071)
[10/15/16 15:01:20] [DEBUG] CConnection::Execute(query=0x9a57448, this=0xf42ac008, connection=0x9a35158)
[10/15/16 15:01:20] [DEBUG] CQuery::Execute(this=0x9a57448, connection=0x9a35158)
[10/15/16 15:01:20] [INFO] query "SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')" successfully executed within 0.332 milliseconds
[10/15/16 15:01:20] [DEBUG] CResultSet::Create(connection=0x9a35158, query_str='SELECT * FROM Accounts WHERE Name = 'Tiriago' AND password = MD5('jaguar')')
[10/15/16 15:01:20] [DEBUG] created new resultset '0xf3700688'
[10/15/16 15:01:20] [DEBUG] fetched MySQL result '0xf3700808'
[10/15/16 15:01:20] [DEBUG] allocated 100 bytes for PAWN result
[10/15/16 15:01:20] [DEBUG] CCallback::Execute(amx=0x9a07d38, index=33, num_params=1)
[10/15/16 15:01:20] [INFO] Executing callback 'OnUserLogin' with 1 parameter...
[10/15/16 15:01:20] [DEBUG] processing internal specifier 'c'
[10/15/16 15:01:20] [DEBUG] pushed value '0' onto AMX stack
[10/15/16 15:01:20] [DEBUG] executing AMX callback with index '33'
[10/15/16 15:01:20] [DEBUG] cache_get_row_count(0xF5459A98) (Nitradoscript.p:1121)
[10/15/16 15:01:20] [DEBUG] cache_get_row_count: return value: '1' (Nitradoscript.p:1121)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "id", 0xF5444648) (Nitradoscript.p:1131)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '1' (Nitradoscript.p:1131)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1131)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Name", 0xF5444650) (Nitradoscript.p:1132)
[10/15/16 15:01:20] [ERROR] cache_get_value_name_int: value 'Tiriago' is not a number (Nitradoscript.p:1132)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Adminlevel", 0xF54446B0) (Nitradoscript.p:1133)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '7' (Nitradoscript.p:1133)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1133)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Level", 0xF54446B4) (Nitradoscript.p:1134)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '2' (Nitradoscript.p:1134)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1134)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Money", 0xF54446B8) (Nitradoscript.p:1135)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1135)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1135)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Fraktion", 0xF54446BC) (Nitradoscript.p:1136)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1136)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1136)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Rang", 0xF54446C0) (Nitradoscript.p:1137)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1137)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1137)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int(0, "Spawn", 0xF54446C4) (Nitradoscript.p:1138)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: assigned value: '0' (Nitradoscript.p:1138)
[10/15/16 15:01:20] [DEBUG] cache_get_value_name_int: return value: '1' (Nitradoscript.p:1138)
[10/15/16 15:01:20] [DEBUG] AMX callback executed with error '0'
[10/15/16 15:01:20] [INFO] Callback successfully executed.

Alles anzeigen

Server_Log:

Spoiler anzeigen

Code

----------
Loaded log file: "server_log.txt".
----------


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


[14:54:56] filterscripts = ""  (string)
[14:54:56] weburl = "www.sa-mp.com"  (string)
[14:54:56] 
[14:54:56] Server Plugins
[14:54:56] --------------
[14:54:56]  Loading plugin: mysql.so
[14:54:56]  >> plugin.mysql: R41 successfully loaded.
[14:54:56]   Loaded.
[14:54:56]  Loading plugin: sscanf.so
[14:54:56] 


[14:54:56]  ===============================


[14:54:56]       sscanf plugin loaded.     


[14:54:56]          Version:  2.8.2        


[14:54:56]    (c) 2012 Alex "Y_Less" Cole  


[14:54:56]  ===============================


[14:54:56]   Loaded.
[14:54:56]  Loading plugin: streamer.so
[14:54:56] 


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


[14:54:56]   Loaded.
[14:54:56]  Loaded 3 plugins.


[14:54:56] 
[14:54:56] Filterscripts
[14:54:56] ---------------
[14:54:56]   Loaded 0 filterscripts.


[14:54:56] [MYSQL] Verbingungsaufbau.........
[14:54:56] 
----------------------------------
[14:54:56]  Selfmade Version 0.2
[14:54:56] ----------------------------------


[14:54:56] Number of vehicle models: 28
[14:56:40] [connection] 91.12.29.170:57654 requests connection cookie.
[14:56:41] [connection] incoming connection: 91.12.29.170:57654 id: 0
[14:56:42] [join] Pergus has joined the server (0:91.12.29.170)
[14:56:57] [part] Pergus has left the server (0:1)
[14:59:21] [connection] 91.12.29.170:61320 requests connection cookie.
[14:59:22] [connection] incoming connection: 91.12.29.170:61320 id: 0
[14:59:22] [join] Tiriago has joined the server (0:91.12.29.170)
[15:00:29] [death] Tiriago died 54
[15:00:36] [part] Tiriago has left the server (0:1)
[15:01:13] [connection] 91.12.29.170:51420 requests connection cookie.
[15:01:14] [connection] incoming connection: 91.12.29.170:51420 id: 0
[15:01:14] [join] Tiriago has joined the server (0:91.12.29.170)
[15:01:25] [part] Tiriago has left the server (0:1)

Alles anzeigen

Jeffry · 15. Oktober 2016

Hast du den Print zu SaveUserStats nach dem format hinzugefügt? Es wird nämlich nichts geprintet.

Markuslobicher · 15. Oktober 2016

Code

stock SaveUserStats(playerid)
{
	//Wen der Spieler nicht eingeloggt ist, dann speichere seine Statistiken nicht
	if(!sInfo[playerid][eingeloggt])return 1;

	//Ansonsten speichere Sie ab
	new query[600];
	mysql_format(handle,query,sizeof(query),"UPDATE Accounts Set Name = '%s',Adminlevel = '%d',Level = '%d',Money = '%d',Fraktion = '%i',Rang = '%d',Spawn = '%d'  WHERE id = '%d' ",sInfo[playerid][Name],sInfo[playerid][Adminlevel],sInfo[playerid][Level],sInfo[playerid][Money],sInfo[playerid][Fraktion],sInfo[playerid][Rang],sInfo[playerid][Spawn],sInfo[playerid][db_id]);
	printf("Speichervorgang der Accountdaten des Spielers!");
	//Das Query wird abgesendet
	mysql_pquery(handle,query);
	return 1;
}

Alles anzeigen

Fraktionssystem geht nicht

breadfish.de 12. März 2022

Ähnliche Themen

Account erstellung geht nicht so wie FraktionsSystem buggt

Verkaufe EMP ( Elegant moderner Pathos) Script

German V Roleplay Servervorstellung

Ränge werden nicht geladen....