Ungültige GUID und PID und Errors in der mod.log

Kolola

Hallo Leute,

wir hatten heute auf unserem Server Leute die meinten Sie müssen uns ärgern.
Sie jointen auf dem Server mit ungülter GUID. Dank des Anti-Empty-GUID Plugins, welches wir etwas modifiziert haben, hat sich anfangs erstmal alles automatisch geklärt.
Späterhin konnten die Spieler auf den Server ohne runter zu fliegen.
Als ich in die mod.log schaute habe ich errors gefunden welche unter anderem das Statistics-Plugin betreffen. Vielleicht könnt ihr mir ja helfen die Fehler zu beheben und eine Möglichkeit zu finden, wie sich sowas in Zukunft verhindern lässt.
Hier der Abschnitt der mod.log

Das kam so 2,3 mal vor

Spoiler anzeigen

Code

13810:12 [30.11.13 16:39:16] Notice: Player 'TheMolinstein' joined, PID: 17, GUID: ØÄ'@¨\O]eU“0¼Z\ÝTpÒa(}lbpYÞ6Y
  13810:12 [30.11.13 16:39:19] Notice: Player 'TheMolinstein' got kicked (by: MOD), reason: Empty GUID is not valid!, PID: 17, GUID: ØÄ'@¨\O]eU“0¼Z\ÝTpÒa(}lbpYÞ6Y
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:523 => sqlite_query(): unrecognized token: "@"
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:524 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:535 => sqlite_query(): unrecognized token: "@"
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:523 => sqlite_query(): unrecognized token: "@"
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:524 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:500 => sqlite_query(): near "AND": syntax error
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:500 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13810:12 [30.11.13 16:39:24] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:502 => sqlite_query(): near ",": syntax error
  13810:15 [30.11.13 16:39:28] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:573 => sqlite_query(): unrecognized token: "@"
  13810:15 [30.11.13 16:39:28] Notice: Player 'TheMolinstein' quit, PID: 17, GUID: ØÄ'@¨\O]eU“0¼Z\ÝTpÒa(}lbpYÞ6Y

Alles anzeigen

Spoiler anzeigen

Code

13823:39 [30.11.13 16:52:42] Notice: Player 'TheMolinstein' joined, PID: 8, GUID: IùV'
  13823:39 [30.11.13 16:52:46] Notice: Player 'TheMolinstein' got kicked (by: MOD), reason: Empty GUID is not valid!, PID: 8, GUID: IùV'
  13823:39 [30.11.13 16:52:51] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:535 => sqlite_query(): near "'IùV'', 0, 0, 0, 0, 0, 0, 0, 1385826771)": syntax error
  13823:39 [30.11.13 16:52:51] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:500 => sqlite_query(): near "AND": syntax error
  13823:39 [30.11.13 16:52:51] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:500 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13823:39 [30.11.13 16:52:51] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:502 => sqlite_query(): near ",": syntax error
  13823:42 [30.11.13 16:52:53] Notice: Player 'TheMolinstein' quit, PID: 8, GUID: IùV'
  13824:07 [30.11.13 16:53:10] Notice: Player 'TheMolinstein' joined, PID: 8, GUID: ˆêskD‡'½nãÔ@cÏHV¿M[ræp5[Søe
  13824:07 [30.11.13 16:53:13] Notice: Player 'TheMolinstein' got kicked (by: MOD), reason: Empty GUID is not valid!, PID: 8, GUID: ˆêskD‡'½nãÔ@cÏHV¿M[ræp5[Søe
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:523 => sqlite_query(): near "½n": syntax error
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:524 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:535 => sqlite_query(): unrecognized token: ""
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:523 => sqlite_query(): near "½n": syntax error
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:524 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:500 => sqlite_query(): near "AND": syntax error
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:500 => sqlite_num_rows() expects parameter 1 to be resource, boolean given
  13824:07 [30.11.13 16:53:19] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:502 => sqlite_query(): near ",": syntax error
  13824:10 [30.11.13 16:53:20] PHP-Error: Warning in :\Server\CoD\CoD4\28960\adminmod\plugins\statistics.php:573 => sqlite_query(): near "½n": syntax error
  13824:10 [30.11.13 16:53:20] Notice: Player 'TheMolinstein' quit, PID: 8, GUID: ˆêskD‡'½nãÔ@cÏHV¿M[ræp5[Søe

Alles anzeigen

Ein anderer Fehler der ab dem Punkt kam war dieser:

Spoiler anzeigen

Code

13812:55 [30.11.13 16:41:58]  !! Warning: DAMAGEGIVEN by player 'world' who is actually not on the server: PID: , GUID: Tr0llz0r
  13812:55 [30.11.13 16:41:58]  !! Warning: DAMAGEGIVEN by player 'world' who is actually not on the server: PID: , GUID: Tr0llz0r
  13812:55 [30.11.13 16:41:58]  !! Warning: DEATH by player '' who is actually not on the server: PID: 0c7372e4cfe2126d071a13e9b7556544, GUID: Tr0llz0r
  13813:03 [30.11.13 16:42:06] Notice: Player '19' changed name to 'allies', PID: iDO?l7†ejrßaLP<Ÿ<, GUID: ¹å™S¿@cd¢™X
  13813:07 [30.11.13 16:42:10]  !! Warning: DAMAGEGIVEN by player 'world' who is actually not on the server: PID: , GUID: Tr0llz0r
  13813:07 [30.11.13 16:42:10]  !! Warning: DAMAGEGIVEN by player 'world' who is actually not on the server: PID: , GUID: Tr0llz0r
  13813:07 [30.11.13 16:42:10]  !! Warning: DEATH by player '' who is actually not on the server: PID: 0c7372e4cfe2126d071a13e9b7556544, GUID: Tr0llz0r

Spoiler anzeigen

Code

13825:08 [30.11.13 16:54:13] Notice: Player 'TheMolinstein' joined, PID: 12, GUID: yÝÓX‘‚
  13825:08 [30.11.13 16:54:16] Notice: Player 'TheMolinstein' got kicked (by: MOD), reason: Empty GUID is not valid!, PID: 12, GUID: yÝÓX‘‚
  13825:09 [30.11.13 16:54:22] Notice: Player 'S4M2UNG' joined, PID: 13, GUID: B–mlö0rÒÉ€H‰XX>áËaŸ(]~ôâMS2^W
  13825:09 [30.11.13 16:54:26] Notice: Player 'S4M2UNG' got kicked (by: MOD), reason: Empty GUID is not valid!, PID: 13, GUID: B–mlö0rÒÉ€H‰XX>áËaŸ(]~ôâMS2^W
  13825:12 [30.11.13 16:54:33] Notice: Player 'TheMolinstein' quit, PID: 12, GUID: yÝÓX‘‚
  13825:22 [30.11.13 16:54:33] Notice: Player 'S4M2UNG' quit, PID: 13, GUID: B–mlö0rÒÉ€H‰XX>áËaŸ(]~ôâMS2^W
  13825:38 [30.11.13 16:54:41] Notice: Player '13' joined, PID: „Ox*ñL™ôçr5½u”ˆlkK®y, GUID: Œ¡ÃKWGÝA
  13825:38 [30.11.13 16:54:44] Notice: Player '13' got kicked (by: MOD), reason: Empty GUID is not valid!, PID: „Ox*ñL™ôçr5½u”ˆlkK®y, GUID: Œ¡ÃKWGÝA
  13826:41 [30.11.13 16:55:44]  !! Warning: DEATH by player '-1' who is actually not on the server: PID: Œ¡ÃKWGÝA, GUID: TheMolinstein
  13826:57 [30.11.13 16:56:00]  !! Warning: DEATH by player '' who is actually not on the server: PID: 872190ac5141eee2ae415d1741c2ed8a, GUID: TheMolinstein
  13827:44 [30.11.13 16:56:47]  !! Warning: DEATH by player '' who is actually not on the server: PID: e454ff0d7d2a09b85d6d0ac8b1e0aa33, GUID: TheMolinstein
  13827:50 [30.11.13 16:56:53]  !! Warning: DAMAGEGIVEN by player 'allies' who is actually not on the server: PID: e454ff0d7d2a09b85d6d0ac8b1e0aa33, GUID: TheMolinstein
  13829:00 [30.11.13 16:58:05]  !! Warning: DAMAGEGIVEN by player 'allies' who is actually not on the server: PID: 9f86a0094b6dfb62bed72109e5a889b1, GUID: TheMolinstein
  13829:00 [30.11.13 16:58:05]  !! Warning: DEATH by player '' who is actually not on the server: PID: 9f86a0094b6dfb62bed72109e5a889b1, GUID: TheMolinstein
  13829:36 [30.11.13 16:58:39]  !! Warning: DAMAGEGIVEN by player 'allies' who is actually not on the server: PID: 9f86a0094b6dfb62bed72109e5a889b1, GUID: TheMolinstein
  13829:36 [30.11.13 16:58:39]  !! Warning: DAMAGEGIVEN by player 'allies' who is actually not on the server: PID: 9f86a0094b6dfb62bed72109e5a889b1, GUID: TheMolinstein
  13829:37 [30.11.13 16:58:40]  !! Warning: DEATH by player '' who is actually not on the server: PID: 9f86a0094b6dfb62bed72109e5a889b1, GUID: TheMolinstein
  13830:24 [30.11.13 16:59:27]  !! Warning: DAMAGEGIVEN by player 'allies' who is actually not on the server: PID: 872190ac5141eee2ae415d1741c2ed8a, GUID: TheMolinstein
  13830:24 [30.11.13 16:59:27]  !! Warning: DEATH by player '' who is actually not on the server: PID: 872190ac5141eee2ae415d1741c2ed8a, GUID: TheMolinstein
  13830:38 [30.11.13 16:59:41]  !! Warning: DAMAGEGIVEN by player 'world' who is actually not on the server: PID: , GUID: TheMolinstein
  13830:45 [30.11.13 16:59:49]  !! Warning: DEATH by player '' who is actually not on the server: PID: e454ff0d7d2a09b85d6d0ac8b1e0aa33, GUID: TheMolinstein

Alles anzeigen

Falls nötig, kann ich noch weitere Sachen posten. Falls jemand helfen kann, das gleiche oder ein ähnliches Problem hat, gebt bitte bescheid.

LG Kolola

Yenz

die entsprechenden Auszüge aus dem Cod-Server-Log wären bestimmt noch hilfreich.

Bezüglich ungültiger GUIDS:
Es gibt ein (inoffizielles) Plugin, welches sich genau damit beschäftigt: Fake GUID Preventation
Eine GUID ist damit nur gültig, wenn sie exakt 32 Stellen lang ist und ausschließlich aus Hex-Zeichen besteht (a-f und 0-9).
Je nach Einstellung wird der Player dann gekickt, gebannt oder getempbannt.

Wegen der SQL-Fehler müsste man sicherlich an einigen Stellen den Code mal anpassen, damit der bei sowas nicht durchdreht

Benutzer online in diesem Thema