Timeban Fehler

robbi2304 · 17. Februar 2017

Liebe Brotfische,

derzeit habe ich ein Problem beim speichern meines Timebans. Es wird nichts in die Datenbank eingetragen und kein wirklicher Fehler in der MySQL Log ausgegeben. Daher bin ich nun in der hoffnung das Ihr mir ggf helfen könnt.

TimeBan(playerid, const name[25], const reason[30], const admin[25], const dauer)
{
new query[200];
mysql_format(handle, query, 200, "INSERT INTO `timeban` (`Spieler`, `Grund`, `Admin`, `Dauer`) VALUES ('%e', '%e', '%e', '%d)", name, reason, admin, dauer);
printf(name,reason,admin,dauer);
mysql_pquery(handle,query, "", "");
return SetTimerEx("KickTimer",100,false,"i",playerid);
}

ocmd:tban(playerid, params[])
{
new pID, grund[30], zeit, zeitdauer, string[128], name[25], name2[25];
if(sscanf(params,"uds", pID, zeit, grund)) return SendClientMessage(playerid, -1, "Benutze: /tban Playerid/Spielername Zeit Grund");
if(!IsPlayerConnected(pID)) return SendClientMessage(playerid, -1, "Spieler nicht online.");
GetPlayerName(playerid, name, 25), GetPlayerName(pID, name2, 25);
zeitdauer = gettime() + (60*zeit);
TimeBan(pID, name2, grund, name, zeitdauer);
format(string, 128, "Du hast %s für %d Minuten gebannt.", name2, zeit);
SendClientMessage(playerid, -1, string);
return 1;
}

wie schon gesagt es finden keine eintragungen in die Datenbank und es wird auch kein Fehler ausgegeben

printf gibt nur das unterstrichene aus printf(name,reason,admin,dauer);

Jeffry · 17. Februar 2017

printf(name,reason,admin,dauer);
zu:
printf("name=%s | reason=%s | admin=%s | dauer=%d",name,reason,admin,dauer);

robbi2304 · 17. Februar 2017

Der Printf gibt alles richtig aus wie es sein soll. Liegt also entweder an dem mysql_format was nicht abgesendet wird oder k.a die Tabellen sind vorhanden.

Die Error Log gibt nur

Code

[17:40:33] [plugins/mysql]

aus also nichts womit man arbeiten könnte

Jeffry · 17. Februar 2017

Was gibt der MySQL Log aus, wenn du das Query absendest?
Schalte gegebenenfalls den MySQL Debug/Log Modus an.

robbi2304 · 17. Februar 2017

Code

[17:46:06] [DEBUG] mysql_pquery(1, "SELECT * FROM haus WHERE updater = 1", "HausUpdat", "")
[17:46:06] [DEBUG] CCallback::Create(amx=0x9919388, name='HausUpdat', format='', params=0xb5107a78, param_offset=5)
[17:46:06] [DEBUG] CCallback::Create - callback index for 'HausUpdat': 3
[17:46:06] [INFO] Callback 'HausUpdat' set up for delayed execution.
[17:46:06] [DEBUG] created delayed callback with 0 parameter
[17:46:06] [DEBUG] CHandle::Execute(this=0x9919400, type=2, query=0x9981424)
[17:46:06] [DEBUG] CConnectionPool::Queue(query=0x9981424, this=0x97e4928)
[17:46:06] [DEBUG] CConnection::Execute(query=0x9981424, this=0xb2ea2008, connection=0x997a298)
[17:46:06] [DEBUG] CQuery::Execute(this=0x9981424, connection=0x997a298)
[17:46:06] [INFO] query "SELECT * FROM haus WHERE updater = 1" successfully executed within 0.94 milliseconds
[17:46:06] [DEBUG] CResultSet::Create(connection=0x997a298, query_str='SELECT * FROM haus WHERE updater = 1')
[17:46:06] [DEBUG] created new resultset '0xb2300e50'
[17:46:06] [DEBUG] fetched MySQL result '0xb2300bc0'
[17:46:06] [DEBUG] allocated 0 bytes for PAWN result
[17:46:06] [DEBUG] CHandle::Execute - return value: true
[17:46:06] [DEBUG] mysql_pquery: return value: '1'
[17:46:06] [DEBUG] CCallback::Execute(amx=0x9919388, index=3, num_params=0)
[17:46:06] [INFO] Executing callback 'HausUpdat' with 0 parameter...
[17:46:06] [DEBUG] executing AMX callback with index '3'
[17:46:06] [DEBUG] cache_get_row_count(0xB5107A88)
[17:46:06] [DEBUG] cache_get_row_count: return value: '1'
[17:46:06] [DEBUG] AMX callback executed with error '0'
[17:46:06] [INFO] Callback successfully executed.
[17:46:06] [DEBUG] mysql_format(1, 0xB5107348, 200, "INSERT INTO `timeban` (`Spieler`, `Grund`, `Admin`, `Dauer`) VALUES ('%e', '%e', '%e', '%d)")
[17:46:06] [DEBUG] CHandle::EscapeString(this=0x9919400, src='Don_Query')
[17:46:06] [DEBUG] CConnection::EscapeString(src='Don_Query', this=0x98e93a8, connection=0x9954fc0)
[17:46:06] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Don_Query'
[17:46:06] [DEBUG] CHandle::EscapeString(this=0x9919400, src='darum')
[17:46:06] [DEBUG] CConnection::EscapeString(src='darum', this=0x98e93a8, connection=0x9954fc0)
[17:46:06] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'darum'
[17:46:06] [DEBUG] CHandle::EscapeString(this=0x9919400, src='Don_Query')
[17:46:06] [DEBUG] CConnection::EscapeString(src='Don_Query', this=0x98e93a8, connection=0x9954fc0)
[17:46:06] [DEBUG] CHandle::EscapeString - return value: true, escaped string: 'Don_Query'
[17:46:06] [DEBUG] mysql_format: return value: '116'
[17:46:06] [DEBUG] mysql_pquery(1, "INSERT INTO `timeban` (`Spieler`, `Grund`, `Admin`, `Dauer`) VALUES ('Don_Query', 'darum', 'Don_Query', '1487350086)", "", "")
[17:46:06] [DEBUG] CCallback::Create(amx=0x9919388, name='', format='', params=0xb5107334, param_offset=5)
[17:46:06] [DEBUG] CHandle::Execute(this=0x9919400, type=2, query=0x9981424)
[17:46:06] [DEBUG] CConnectionPool::Queue(query=0x9981424, this=0x97e4928)
[17:46:06] [DEBUG] CHandle::Execute - return value: true
[17:46:06] [DEBUG] mysql_pquery: return value: '1'
[17:46:06] [DEBUG] CConnection::Execute(query=0x9981424, this=0xb3924008, connection=0x9973c18)
[17:46:06] [DEBUG] CQuery::Execute(this=0x9981424, connection=0x9973c18)
[17:46:06] [ERROR] 
[17:46:06] [DEBUG] CConnection::GetError(this=0xb3924008, connection=0x9973c18)
[17:46:06] [DEBUG] CCallback::Create(amx=0x9919388, name='OnQueryError', format='dsssd)
[17:46:06] [DEBUG] mysql_format(1, 0xB51073F4, 400, "UPDATE users SET skin='%i',spawn='%i',wanted='%i',jailtime='%i',frakrang='%i',leader='%i',member='%i',punkte='%i',scheine='%i',alevel='%d',jobk='%d',paytime='%d',prpg='%d',jobmoney='%d',konto='%d',respektpunkte='%d',perso='%d',dunger='%d',drogensamen='%d',job='%d',drogens='%d',drogen='%d',matss='%d',mats='%d',level='%d',money='%d',kills='%d',deaths='%d' WHERE id='%d'")
[17:46:06] [DEBUG] mysql_format: return value: '347'
[17:46:06] [DEBUG] mysql_pquery(1, "UPDATE users SET skin='0',spawn='1',wanted='0',jailtime='0',frakrang='0',leader='0',member='0',punkte='0',scheine='0',alevel='0',jobk='0',paytime='3',prpg='8',jobmoney='0',konto='10000',respektpunkte='0',perso='0',dunger='0',drogensamen='0',job='0',drogens='0',drogen='0',matss='0',mats='0',level='1',money='9299',kills='0',deaths='0' WHERE id='5'", "", "")
[17:46:06] [DEBUG] CCallback::Create(amx=0x9919388, name='', format='', params=0xb51073e0, param_offset=5)
[17:46:06] [DEBUG] CHandle::Execute(this=0x9919400, type=2, query=0x99810bc)
[17:46:06] [DEBUG] CConnectionPool::Queue(query=0x99810bc, this=0x97e4928)
[17:46:06] [DEBUG] CConnection::Execute(query=0x99810bc, this=0xb2ea2008, connection=0x997a298)
[17:46:06] [DEBUG] CQuery::Execute(this=0x99810bc, connection=0x997a298)
[17:46:06] [INFO] query "UPDATE users SET skin='0',spawn='1',wanted='0',jailtime='0',frakrang='0',leader='0',member='0',punkte='0',scheine='0',alevel='0',jobk='0',paytime='3',prpg='8',jobmoney='0',konto='10000',respektpunkte='0',perso='0',dunger='0',drogensamen='0',job='0',drogens='0',drogen='0',matss='0',mats='0',level='1',money='9299',kills='0',deaths='0' WHERE id='5'" successfully executed within 1.241 milliseconds
[17:46:06] [DEBUG] CResultSet::Create(connection=0x997a298, query_str='UPDATE users SET skin='0',spawn='1',wanted='0',jailtime='0',frakrang='0',leader='0',member='0',punkte='0',scheine='0',alevel='0',jobk='0',paytime='3',prpg='8',jobmoney='0',konto='10000',respektpunkte='0',perso='0',dunger='0',drogensamen='0',job='0',drogens='0',drogen='0',matss='0',mats='0',level='1',money='9299',kills='0',deaths='0' WHERE id='5'')
[17:46:06] [DEBUG] created new resultset '0xb2300de0'
[17:46:06] [DEBUG] fetched MySQL result '0x0'
[17:46:06] [DEBUG] CHandle::Execute - return value: true
[17:46:06] [DEBUG] mysql_pquery: return value: '1'

Alles anzeigen

Jeffry · 17. Februar 2017

Zitat von robbi2304

[17:46:06] [DEBUG] mysql_pquery(1, "INSERT INTO `timeban` (`Spieler`, `Grund`, `Admin`, `Dauer`) VALUES ('Don_Query', 'darum', 'Don_Query', '1487350086)", "", "")
[17:46:06] [DEBUG] CCallback::Create(amx=0x9919388, name='', format='', params=0xb5107334, param_offset=5)
[17:46:06] [DEBUG] CHandle::Execute(this=0x9919400, type=2, query=0x9981424)
[17:46:06] [DEBUG] CConnectionPool::Queue(query=0x9981424, this=0x97e4928)
[17:46:06] [DEBUG] CHandle::Execute - return value: true
[17:46:06] [DEBUG] mysql_pquery: return value: '1'
[17:46:06] [DEBUG] CConnection::Execute(query=0x9981424, this=0xb3924008, connection=0x9973c18)
[17:46:06] [DEBUG] CQuery::Execute(this=0x9981424, connection=0x9973c18)
[17:46:06] [ERROR]
[17:46:06] [DEBUG] CConnection::GetError(this=0xb3924008, connection=0x9973c18)
[17:46:06] [DEBUG] CCallback::Create(amx=0x9919388, name='OnQueryError', format='dsssd)

Alles anzeigen

Hier geht was schief.

Das Problem liegt hier:
mysql_format(handle, query, 200, "INSERT INTO `timeban` (`Spieler`, `Grund`, `Admin`, `Dauer`) VALUES ('%e', '%e', '%e', '%d)", name, reason, admin, dauer);
zu:
mysql_format(handle, query, 200, "INSERT INTO `timeban` (`Spieler`, `Grund`, `Admin`, `Dauer`) VALUES ('%e', '%e', '%e', '%d')", name, reason, admin, dauer);
(Ganz hinten nach %d ein ' eingefügt)

Timeban Fehler

breadfish.de 12. März 2022

Ähnliche Themen

💎[GF] Reallife SOM Version 0.5 (2016) MySQL R7 + UCP since 2013💎

R37 MySQL Plugin

Stock speichert nicht

MySQL Error

Gebannter spieler bekommt keine Nachricht

TimeBan