Игровой портал провайдера ОАО Электросвязь Скачать Counter-Strike 1.6 ELLCO Группа Вконтакте ELLCO CS 1.6
  • Главная
  • Forum
  • Help

  Секции

  [ELLCO] |CS 1.6| [Zombie] (Все серверы) Логи чата (За последние 28 Дней)

Показать чат с Фильтровать:
ERROR
Database Error

Server Address: 127.0.0.1
Server Username: test

Error Diagnostic:
Bad query.

Server Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND UNIX_TIMESTAMP(hlstats_Events_Chat.eventTime) <= 86400 ORDER BY h' at line 22

Last SQL Query:
				SELECT SQL_NO_CACHE 
					DATE_FORMAT(hlstats_Events_Chat.eventTime, '%T') as eventTime,
					IF(SUBSTR(hlstats_Players.lastName, 1, 20)=hlstats_Players.lastName, hlstats_Players.lastName, CONCAT(SUBSTR(unhex(replace(hex(hlstats_Players.lastName), 'E280AE', '')),1,20),'...')) as lastName,
					IF(hlstats_Events_Chat.message_mode=2, CONCAT('(Team) ', hlstats_Events_Chat.message), IF(hlstats_Events_Chat.message_mode=3, CONCAT('(Squad) ', hlstats_Events_Chat.message), hlstats_Events_Chat.message)) AS message,
					hlstats_Servers.name2 AS serverName,
					hlstats_Events_Chat.playerId,
					hlstats_Players.flag,
					hlstats_Events_Chat.map
				FROM
					hlstats_Events_Chat
				INNER JOIN
					hlstats_Players
				ON
					hlstats_Players.playerId = hlstats_Events_Chat.playerId
				INNER JOIN 
					hlstats_Servers
				ON
					hlstats_Servers.serverId = hlstats_Events_Chat.serverId
				WHERE
					hlstats_Servers.game='zombie' 
					AND UNIX_TIMESTAMP(hlstats_Events_Chat.eventTime) >= 
					AND UNIX_TIMESTAMP(hlstats_Events_Chat.eventTime) <= 86400
				ORDER BY
					hlstats_Events_Chat.id desc
				LIMIT
					0,
					50;