Инструкция по установке и настройке SourceBans

[The Slavik]

Ребята подскажите как можно сделать чтоб Админка давалась на определенное время допустим на день, неделю, месяц, полгода, год. Или какой плагин это можно сделать?

С помощью какой команды или чего можно посмотреть rate играков, если команда rates не помогает.

p.s. простите я нуб еще в этом))

от онотоле соурбанс, там есть такая функция.

Добавлено через 12 часов 22 минуты
Столкнулся с такой вот проблемой.
Забанил сам себя и пытаюсь разбанить. И получаю вот такую вот надпись
Possible hacking attempt (URL Key mismatch)
и ничего не происходит.
ксс стим 78 версия.
сб от онотоле.

 

[xxxKRESHxxx]

Люди, помогите, пожалуйста, сервера не отображаются в SourceBans (Ошибка подключения), хотя баны заносятся. Внешний доступ настроил.
Хостинг Jino

 

[R1KO]

Добавлено через 12 часов 22 минуты
Столкнулся с такой вот проблемой.
Забанил сам себя и пытаюсь разбанить. И получаю вот такую вот надпись
Possible hacking attempt (URL Key mismatch)
и ничего не происходит.
ксс стим 78 версия.
сб от онотоле.

Решаю простым обновлением страницы.
Обычно мне такое пишет, когда пытаюсь удалить/разбанить, а в сб появились новые баны, но страница не обновлена и они на не не отображены.

 

[Dj_Andrey_01]

Установил, на сайте отобразилось вот:

Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%FC^FC1^FC137016%%page_header.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%FC^FC1^FC137016%%page_header.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%DD^DD3^DD3F9F90%%tab.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%87^873^8730F959%%submenu.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%87^873^8730F959%%submenu.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%6E^6EC^6ECAF77A%%content_header.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%6E^6EC^6ECAF77A%%content_header.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255  Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%42^420^420ABB47%%page_dashboard.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%42^420^420ABB47%%page_dashboard.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%05^05A^05A044C7%%page_footer.tpl.php): failed to open stream: Permission denied in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 Warning: include(): Failed opening '/var/www/admin/data/www/bans.cs-array.ru/themes_c//default^%%05^05A^05A044C7%%page_footer.tpl.php' for inclusion (include_path='.:/php/includes:/var/www/admin/data/www/bans.cs-array.ru/includes/adodb') in /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php on line 1255 
Column 'aid' cannot be null 

SQL Query type: EXECUTE
Script: '/index.php'
SQL Query: INSERT INTO sb_log(type,title,message, function, query, aid, host, created) VALUES ('w','PHP Warning','[512] Smarty error: problem writing temporary file \'/var/www/admin/data/www/bans.cs-array.ru/themes_c/wrt517d5a2f8250f\'
\nError on line 1092 in file /var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php','/var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php - 1092
/var/www/admin/data/www/bans.cs-array.ru/includes/smarty/internals/core.write_file.php - 32
/var/www/admin/data/www/bans.cs-array.ru/includes/smarty/internals/core.write_compiled_resource.php - 29
/var/www/admin/data/www/bans.cs-array.ru/includes/smarty/Smarty.class.php - 1430
','N/A',NULL,'109.172.51.39',1367169583)
SQL Params:

Подскажите, что это и как исправить ?

 

[The Slavik]

Установил, на сайте отобразилось вот:

пройдись по путям(не железнодорожным) в файлы по строчкам которые в ошибке, посмотри что там пишется, прочитай, переведи. И потом уже приходи с вопросом сюда.
И дай больше инфы.
-------------------
варианты.
1 кодировка
2 чьято сборка банлиста - кривая
3 тема кривая
4 права неправильно выставлены
5 файлы повреждены

 

[R1KO]

Dj_Andrey_01, Это официальная версия ? Абсолютно чистая ?
И нет прав.

 

[September]

Dj_Andrey_01, Это официальная версия ? Абсолютно чистая ?
И нет прав.

Оффтоп

о какой сборке может идти речь?:D http://bans.cs-array.ru/

 

[The Slavik]

Оффтоп

о какой сборке может идти речь?:D http://bans.cs-array.ru/

Оффтоп

ну и какой смысл от твоего поста ??

Dj_Andrey_01
Ответь на вопрос. Или ты уже забыл на свой банлист.

 

[Dj_Andrey_01]

Итог:
- в начале качал с офф. сайта sourcebans - результат вот
- потом скачал вот отсюда
Теперь все норм !:)

 

[R1KO]

Dj_Andrey_01, но почему то же у всех официальная пашет ?

 

[R1KO]

Добавлено через 45 секунд

Так всё норм скомпилировалось, щас протестирую.

FormatEx(Query, sizeof(Query), "SELECT bid FROM %s_bans WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULLAND (sid = '%s' OR sid = 0)", DatabasePrefix, auth[8], ip, serverID);

Не работает. Вот что в логах сб:

L 05/11/2013 - 20:11:33: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1

 

[HooLIGUN]

Добавлено через 45 секунд


Не работает. Вот что в логах сб:

яяяяяяяяяяяя не смущает?
Может случайно написал в запрос и не заметил?

 

[R1KO]

HooLIGUN, Вот именно ! Откуда оно берется ? 3-4 раза пересмотрел код.. заново в чистую сб вписывал и компилировал.

 

[Vaio]

На sql-инъекцию похоже (неудачную). Данная ошибка была только 1 раз?

 

[R1KO]

Vaio, нет, спамит логи sourcebans.

Спойлер

L 04/27/2013 - 20:47:54: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:48:19: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:48:43: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:49:07: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:49:34: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:49:56: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:50:21: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:50:44: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:51:07: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:51:32: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:51:55: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:52:20: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:52:44: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:53:09: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:53:35: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:54:00: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:54:23: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:54:48: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:55:11: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:55:36: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:56:00: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:56:24: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:56:51: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:57:13: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:57:39: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:58:04: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:58:27: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:58:52: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:59:19: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:59:41: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:59:57: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 20:59:58: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:00:45: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:00:46: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:01:33: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:01:34: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:02:18: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:02:19: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:03:07: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:03:07: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:03:52: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:03:53: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:04:40: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:04:41: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:05:25: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:05:26: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:06:14: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:06:14: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:07:01: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:07:02: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:07:48: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:07:49: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:08:33: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:08:34: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:08:56: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:09:20: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:09:21: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:09:43: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:10:08: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:10:08: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:10:55: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:10:55: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:11:42: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:11:43: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:12:29: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:12:30: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:13:16: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:13:17: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:14:01: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:14:02: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:14:47: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:14:50: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:14:50: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:15:35: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:15:38: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:15:38: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:16:21: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:16:23: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:16:24: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:17:06: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:17:08: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:17:09: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:17:53: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:17:56: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1
L 04/27/2013 - 21:18:41: [sourcebans.smx] Verify Ban Query Failed: 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 ''яяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяяя' at line 1

 

[R1KO]

Vaio, исходник(менял только это):

Спойлер

public OnClientAuthorized(client, const String:auth[])
{
	/* Do not check bots nor check player with lan steamid. */
	if(auth[0] == 'B' || auth[9] == 'L' || Database == INVALID_HANDLE)
	{
		PlayerStatus[client] = true;
		return;
	}
	
	decl String:Query[256], String:ip[30];
	GetClientIP(client, ip, sizeof(ip));
	FormatEx(Query, sizeof(Query), "SELECT bid FROM %s_bans WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL AND (sid = '%s' OR sid = 0)", DatabasePrefix, auth[8], ip, serverID);
#if defined DEBUG
	LogToFile(logFile, "Checking ban for: %s", auth);
#endif
	
	SQL_TQuery(Database, VerifyBan, Query, GetClientUserId(client), DBPrio_High);
}

Лог в предыдущем посте, интервал ошибок ~25 сек. Ошибки он старта сервера и далее.

 

[Серый™]

Кому интересно вышел официально SourceBans 1.5.0 BETA game plugin , есть русский.

 

[R1KO]

Серый™, посмотрим)
Только серверная часть.

 

[винс]

подскажите что за ошибка Fatal error: Call to undefined function timezone_abbreviations_list() in /var/www/html/bans/init.php on line 263

Добавлено через 14 часов 30 минут
подскажите как исправить Fatal error: Call to undefined function timezone_abbreviations_list() in

Добавлено через 18 часов 34 минуты
проблема подскажите когда добавляешь сервер и пишеш там Rcon пароль и сохраняешь он не меняеться в чом проблема??

 

[R1KO]

Вобщем соиденил это

FormatEx(Query, sizeof(Query), "
SELECT bid FROM %s_bans 
WHERE ((type = 0 AND authid REGEXP '^STEAM_[0-9]:%s$') OR (type = 1 AND ip = '%s')) 
AND (length = '0' OR ends > UNIX_TIMESTAMP()) 
AND RemoveType IS NULL
AND (sid = '%s' OR sid = 0)
", DatabasePrefix, auth[8], ip, serverID);

и это

То что вышло прикрепил внизу.

В итоге всё работает нормально но одна проблема: игрок банится на всех серверах.