Не пишет статистику

Diak · 20 Дек 2020

Установил, всё настроил, к базе данных подключил, всё работает но статистику не пишет, записывает только провелённое время и т.д. приложу скрин,
на сервере в мотд окне показывает только игроков но убийства и смерти нет, на сайте вообще ни чего не отображает, не понимаю в чём причина где я мог ошибиться - Данные БД везде указал как на сервере так и на вебхостинге

Сообщение автоматически объединено: 20 Дек 2020

Вот что пишет в консоли сервера

L 12/20/2020 - 16:36:51: [CsStats MySQL] Соединение с MySQL...
L 12/20/2020 - 16:36:51: Started map "de_dust2" (CRC "1159425449")
Executing AMX Mod X Configuration File
[AMXX] Не найдено ни одного администратора
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] Loading STEAM_0:1:309183 ca 10
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] "1" services was 'Loaded' from database. Total on server: "1" services.
Menu item 17 added to Menus Front-End: "Настр. конваров" from plugin "pluginmenu.amxx"
Menu item 18 added to Menus Front-End: "Настр. команд" from plugin "pluginmenu.amxx"
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] FnFindUserService not found ENERGI 152 RUS STEAM_0:1:209382194
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:1:309183 (abcdefghijklmnopqrstu)
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] FnFindUserService All services STEAM_0:1:309183 Главный админ
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] Searching... "<Diak [Sensation-tm.ru]><STEAM_0:1:309183>" (Account name "STEAM_0:1:309183" / Admin index "10") (Service flags "abcdefghijklmnopqrstu") (Service name "Главный админ") (Expired "2021-01-19 14:48:58")
L 12/20/2020 - 16:36:51: [gamecms_api_5.4.9.amxx] Authentication... "<Diak [Sensation-tm.ru]><STEAM_0:1:309183>" (Account name "STEAM_0:1:309183" / Admin index "10") (Service flags "abcdefghijklmnopqrstu") (Service name "Главный админ")
[CsStats MySQL] Удалено из базы 0 игроков
L 12/20/2020 - 16:36:51: [CsStats MySQL] Удалено из базы 0 игроков
[CsStats MySQL] Успешное соединение с MySQL. Загружено 0 игроков за 1.1540 секунд
L 12/20/2020 - 16:36:51: [CsStats MySQL] Успешное соединение с MySQL. Загружено 0 игроков за 1.1540 секунд
L 12/20/2020 - 16:36:52: World triggered "Round_Start"

Diak · 21 Дек 2020

@DIVIZION, хорошо попробую сменить, на сколько я понял вы говорите про тот квар csstats_reserve_time "1 180 5", если про него то я немного не понимаю, на сколько я понял то этот квар нужен на случай падения сервера или базы, в моём случае падения нету, играю а фраги не пишутся не то что в бд а даже в топ не отображается во время игры

DIVIZION · 21 Дек 2020

@Diak, Вы просто проверьте с дефолтным конфигом.

Diak · 21 Дек 2020

@DIVIZION, по поводу amx возможно вы правы, сервер на майарене там нет 183, установил с панели 182 и перешёл на 183 по этой статье

Для просмотра скрытого содержимого вы должны войти или зарегистрироваться.

, скачал:
1.8.3-dev-git5201-base.tar.gz
1.8.3-dev-git5201-cstrike.tar.gz
Всё остальное делал по инструкцие, может данная статья влияет на работу плагинов???

DIVIZION · 21 Дек 2020

@Diak, Если обновили правильно, то все должно быть хорошо. Там очень подробно автор расписал переход. В общем проверьте и отпишитесь.

Diak · 21 Дек 2020

@DIVIZION, Проверил

L 12/21/2020 - 18:55:19: CREATE TABLE IF NOT EXISTS `csstats_players` (`id` int(11) NOT NULL AUTO_INCREMENT, `nick` varchar(32) NOT NULL, `authid` varchar(32) NOT NULL, `ip` varchar(32) NOT NULL, `frags` int(11) NOT NULL DEFAULT '0',`deaths` int(11) NOT NULL DEFAULT '0',`headshots` int(11) NOT NULL DEFAULT '0',`teamkills` int(11) NOT NULL DEFAULT '0',`shots` int(11) NOT NULL DEFAULT '0',`hits` int(11) NOT NULL DEFAULT '0',`damage` int(11) NOT NULL DEFAULT '0',`suicide` int(11) NOT NULL DEFAULT '0',`defusing` int(11) NOT NULL DEFAULT '0',`defused` int(11) NOT NULL DEFAULT '0',`planted` int(11) NOT NULL DEFAULT '0',`explode` int(11) NOT NULL DEFAULT '0',`place` int(11) NOT NULL DEFAULT '0',`lasttime` int(11) NOT NULL DEFAULT '0',`gametime` int(11) NOT NULL DEFAULT '0',`connects` int(11) NOT NULL DEFAULT '0',`rounds` int(11) NOT NULL DEFAULT '0',`wint` int(11) NOT NULL DEFAULT '0',`winct` int(11) NOT NULL DEFAULT '0',`skill` int(11) NOT NULL DEFAULT '0',`ar_addxp` int(11) NOT NULL DEFAULT '0',`ar_anew` int(11) NOT NULL DEFAULT '0',PRIM
L 12/21/2020 - 18:55:19: CREATE TABLE IF NOT EXISTS `csstats_settings` (`command` varchar(64) NOT NULL, `value` text NOT NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
L 12/21/2020 - 18:55:19: SELECT `value` FROM `csstats_settings` WHERE `command`='table_hash' LIMIT 1
L 12/21/2020 - 18:55:19: cur_hash:9cbbb160ee4abeafdba3c0dfc7d2e369 == sql_hash:9cbbb160ee4abeafdba3c0dfc7d2e369 (не обновляем таблицу настроек)
L 12/21/2020 - 18:55:19: DELETE FROM `csstats_players` WHERE (ar_addxp=0 AND ar_anew=0 AND (lasttime<(UNIX_TIMESTAMP(NOW())-1296000) OR gametime<60 OR frags<=2)) OR (lasttime<(UNIX_TIMESTAMP(NOW())-7776000))
L 12/21/2020 - 18:55:19: SELECT `frags`,`deaths`,`headshots`,`teamkills`,`shots`,`hits`,`damage`,`suicide`,`defusing`,`defused`,`planted`,`explode`,`place`,`lasttime`,`gametime`,`connects`,`rounds`,`wint`,`winct`,`skill`,`ar_addxp`,`ar_anew`,`authid`,`nick`,`ip` FROM `csstats_players`
L 12/21/2020 - 18:55:27: Don't RESERVE STEAM_5:0:273018669 with gametime(5) < 180
L 12/21/2020 - 18:55:27: Don't RESERVE STEAM_5:0:43830550 with gametime(5) < 180
L 12/21/2020 - 18:55:53: Don't RESERVE STEAM_5:0:273018669 with gametime(31) < 180
L 12/21/2020 - 18:55:53: Don't RESERVE STEAM_0:1:309183 with gametime(26) < 180
L 12/21/2020 - 18:55:53: Don't RESERVE STEAM_5:0:340777758 with gametime(10) < 180
L 12/21/2020 - 18:55:53: Don't RESERVE STEAM_5:0:43830550 with gametime(31) < 180
L 12/21/2020 - 18:56:16: Don't RESERVE STEAM_5:0:273018669 with gametime(54) < 180
L 12/21/2020 - 18:56:16: Don't RESERVE STEAM_0:1:309183 with gametime(49) < 180
L 12/21/2020 - 18:56:16: Don't RESERVE STEAM_5:0:340777758 with gametime(33) < 180
L 12/21/2020 - 18:56:16: Don't RESERVE STEAM_5:0:43830550 with gametime(54) < 180
L 12/21/2020 - 18:56:29: Don't RESERVE STEAM_5:0:273018669 with gametime(67) < 180
L 12/21/2020 - 18:56:29: Don't RESERVE STEAM_0:1:309183 with gametime(62) < 180
L 12/21/2020 - 18:56:29: Don't RESERVE STEAM_5:0:340777758 with gametime(46) < 180
L 12/21/2020 - 18:56:29: Don't RESERVE STEAM_5:0:43830550 with gametime(67) < 180
L 12/21/2020 - 18:56:35: Don't INSERT STEAM_5:0:340777758 with gametime(52) < 60
L 12/21/2020 - 18:56:40: Don't RESERVE STEAM_5:0:273018669 with gametime(78) < 180
L 12/21/2020 - 18:56:40: Don't RESERVE STEAM_0:1:309183 with gametime(73) < 180
L 12/21/2020 - 18:56:40: Don't RESERVE STEAM_5:0:43830550 with gametime(78) < 180
L 12/21/2020 - 18:56:50: Don't RESERVE STEAM_5:0:273018669 with gametime(88) < 180
L 12/21/2020 - 18:56:50: Don't RESERVE STEAM_0:1:309183 with gametime(83) < 180
L 12/21/2020 - 18:56:50: Don't RESERVE STEAM_5:0:43830550 with gametime(88) < 180
L 12/21/2020 - 18:57:11: Don't RESERVE STEAM_5:0:273018669 with gametime(109) < 180
L 12/21/2020 - 18:57:11: Don't RESERVE STEAM_0:1:309183 with gametime(104) < 180
L 12/21/2020 - 18:57:11: Don't RESERVE STEAM_5:0:43830550 with gametime(109) < 180
L 12/21/2020 - 18:57:23: Don't RESERVE STEAM_5:0:273018669 with gametime(121) < 180
L 12/21/2020 - 18:57:23: Don't RESERVE STEAM_0:1:309183 with gametime(116) < 180
L 12/21/2020 - 18:57:23: Don't RESERVE STEAM_5:0:1110500970 with gametime(0) < 180
L 12/21/2020 - 18:57:23: Don't RESERVE STEAM_5:0:43830550 with gametime(121) < 180
L 12/21/2020 - 18:57:28: Don't INSERT STEAM_5:0:43830550 with frags(0) < 1
L 12/21/2020 - 18:57:34: Don't RESERVE STEAM_5:0:273018669 with gametime(132) < 180
L 12/21/2020 - 18:57:34: Don't RESERVE STEAM_0:1:309183 with gametime(127) < 180
L 12/21/2020 - 18:57:34: Don't RESERVE STEAM_5:0:1110500970 with gametime(11) < 180
L 12/21/2020 - 18:57:45: Don't RESERVE STEAM_5:0:273018669 with gametime(143) < 180
L 12/21/2020 - 18:57:45: Don't RESERVE STEAM_0:1:309183 with gametime(138) < 180
L 12/21/2020 - 18:57:45: Don't RESERVE STEAM_5:0:1110500970 with gametime(22) < 180
L 12/21/2020 - 18:57:57: Don't RESERVE STEAM_5:0:273018669 with gametime(155) < 180
L 12/21/2020 - 18:57:57: Don't RESERVE STEAM_0:1:309183 with gametime(150) < 180
L 12/21/2020 - 18:57:57: Don't RESERVE STEAM_5:0:1110500970 with gametime(34) < 180
L 12/21/2020 - 18:58:12: Don't RESERVE STEAM_5:0:273018669 with gametime(170) < 180
L 12/21/2020 - 18:58:12: Don't RESERVE STEAM_0:1:309183 with gametime(165) < 180
L 12/21/2020 - 18:58:12: Don't RESERVE STEAM_5:0:1110500970 with gametime(49) < 180
L 12/21/2020 - 18:58:29: Don't RESERVE STEAM_5:0:273018669 with frags(0) < 5
L 12/21/2020 - 18:58:29: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/21/2020 - 18:58:29: Don't RESERVE STEAM_5:0:1110500970 with gametime(66) < 180
L 12/21/2020 - 18:58:37: Don't INSERT STEAM_5:0:273018669 with frags(0) < 1
L 12/21/2020 - 18:58:40: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/21/2020 - 18:58:40: Don't RESERVE STEAM_5:0:1110500970 with gametime(77) < 180
L 12/21/2020 - 18:59:03: Don't RESERVE STEAM_5:0:1252966553 with gametime(13) < 180
L 12/21/2020 - 18:59:03: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/21/2020 - 18:59:03: Don't RESERVE STEAM_5:0:1110500970 with gametime(100) < 180
L 12/21/2020 - 18:59:03: Don't RESERVE STEAM_5:0:1951325753 with gametime(21) < 180
L 12/21/2020 - 18:59:22: Don't RESERVE STEAM_5:0:1252966553 with gametime(32) < 180
L 12/21/2020 - 18:59:22: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/21/2020 - 18:59:22: Don't RESERVE STEAM_5:0:1110500970 with gametime(119) < 180
L 12/21/2020 - 18:59:22: Don't RESERVE STEAM_5:0:130462778 with gametime(12) < 180
L 12/21/2020 - 18:59:22: Don't RESERVE STEAM_5:0:1951325753 with gametime(40) < 180
L 12/21/2020 - 18:59:22: Don't RESERVE STEAM_5:0:1092329727 with gametime(6) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:1252966553 with gametime(62) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:1110500970 with gametime(149) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:130462778 with gametime(42) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:1951325753 with gametime(70) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:1092329727 with gametime(36) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:298256541 with gametime(26) < 180
L 12/21/2020 - 18:59:52: Don't RESERVE STEAM_5:0:1256626009 with gametime(26) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:1252966553 with gametime(87) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:1110500970 with gametime(174) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:130462778 with gametime(67) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:1951325753 with gametime(95) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:1092329727 with gametime(61) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:298256541 with gametime(51) < 180
L 12/21/2020 - 19:00:17: Don't RESERVE STEAM_5:0:1256626009 with gametime(51) < 180
L 12/21/2020 - 19:00:31: UPDATE `csstats_players` SET wint=wint+15,rounds=rounds+17,ar_addxp='0',ar_anew='16',skill='139',nick='Diak [Sensation-tm.ru]',connects=connects+1,gametime=gametime+304,lasttime=UNIX_TIMESTAMP() WHERE authid='STEAM_0:1:309183' LIMIT 1;
L 12/21/2020 - 19:00:34: Don't INSERT STEAM_5:0:1092329727 with frags(0) < 1
L 12/21/2020 - 19:00:39: Don't RESERVE STEAM_5:0:1252966553 with gametime(109) < 180
L 12/21/2020 - 19:00:39: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:00:39: Don't RESERVE STEAM_5:0:130462778 with gametime(89) < 180
L 12/21/2020 - 19:00:39: Don't RESERVE STEAM_5:0:1951325753 with gametime(117) < 180
L 12/21/2020 - 19:00:39: Don't RESERVE STEAM_5:0:298256541 with gametime(73) < 180
L 12/21/2020 - 19:00:39: Don't RESERVE STEAM_5:0:1256626009 with gametime(73) < 180
L 12/21/2020 - 19:00:58: Don't UPDATE STEAM_0:1:309183 with gametime(14) < 30
L 12/21/2020 - 19:01:01: Don't RESERVE STEAM_5:0:1252966553 with gametime(131) < 180
L 12/21/2020 - 19:01:01: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:01:01: Don't RESERVE STEAM_5:0:130462778 with gametime(111) < 180
L 12/21/2020 - 19:01:01: Don't RESERVE STEAM_5:0:1951325753 with gametime(139) < 180
L 12/21/2020 - 19:01:01: Don't RESERVE STEAM_5:0:298256541 with gametime(95) < 180
L 12/21/2020 - 19:01:01: Don't RESERVE STEAM_5:0:1256626009 with gametime(95) < 180
L 12/21/2020 - 19:01:17: Don't RESERVE STEAM_5:0:1252966553 with gametime(147) < 180
L 12/21/2020 - 19:01:17: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:01:17: Don't RESERVE STEAM_5:0:130462778 with gametime(127) < 180
L 12/21/2020 - 19:01:17: Don't RESERVE STEAM_5:0:1951325753 with gametime(155) < 180
L 12/21/2020 - 19:01:17: Don't RESERVE STEAM_5:0:298256541 with gametime(111) < 180
L 12/21/2020 - 19:01:17: Don't RESERVE STEAM_5:0:1256626009 with gametime(111) < 180
L 12/21/2020 - 19:01:17: Don't INSERT STEAM_5:0:1256626009 with frags(0) < 1
L 12/21/2020 - 19:01:31: Don't RESERVE STEAM_5:0:1252966553 with gametime(161) < 180
L 12/21/2020 - 19:01:31: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:01:31: Don't RESERVE STEAM_5:0:130462778 with gametime(141) < 180
L 12/21/2020 - 19:01:31: Don't RESERVE STEAM_5:0:1951325753 with gametime(169) < 180
L 12/21/2020 - 19:01:31: Don't RESERVE STEAM_5:0:298256541 with gametime(125) < 180
L 12/21/2020 - 19:01:47: Don't RESERVE STEAM_5:0:1252966553 with gametime(177) < 180
L 12/21/2020 - 19:01:47: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:01:47: Don't RESERVE STEAM_5:0:130462778 with gametime(157) < 180
L 12/21/2020 - 19:01:47: Don't RESERVE STEAM_5:0:1951325753 with frags(0) < 5
L 12/21/2020 - 19:01:47: Don't RESERVE STEAM_5:0:298256541 with gametime(141) < 180
L 12/21/2020 - 19:02:02: Don't RESERVE STEAM_5:0:1252966553 with frags(0) < 5
L 12/21/2020 - 19:02:02: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:02:02: Don't RESERVE STEAM_5:0:130462778 with gametime(172) < 180
L 12/21/2020 - 19:02:02: Don't RESERVE STEAM_5:0:1951325753 with frags(0) < 5
L 12/21/2020 - 19:02:02: Don't RESERVE STEAM_5:0:298256541 with gametime(156) < 180
L 12/21/2020 - 19:02:21: Don't RESERVE STEAM_5:0:1252966553 with frags(0) < 5
L 12/21/2020 - 19:02:21: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:02:21: Don't RESERVE STEAM_5:0:130462778 with frags(0) < 5
L 12/21/2020 - 19:02:21: Don't RESERVE STEAM_5:0:1951325753 with frags(0) < 5
L 12/21/2020 - 19:02:21: Don't RESERVE STEAM_5:0:298256541 with gametime(175) < 180
L 12/21/2020 - 19:02:33: Don't INSERT STEAM_5:0:1252966553 with frags(0) < 1
L 12/21/2020 - 19:02:36: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:02:36: Don't RESERVE STEAM_5:0:130462778 with frags(0) < 5
L 12/21/2020 - 19:02:36: Don't RESERVE STEAM_5:0:1951325753 with frags(0) < 5
L 12/21/2020 - 19:02:36: Don't RESERVE STEAM_5:0:298256541 with frags(0) < 5
L 12/21/2020 - 19:02:54: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:02:54: Don't RESERVE STEAM_5:0:130462778 with frags(0) < 5
L 12/21/2020 - 19:02:54: Don't RESERVE STEAM_5:0:1951325753 with frags(0) < 5
L 12/21/2020 - 19:02:54: Don't RESERVE STEAM_5:0:298256541 with frags(0) < 5
L 12/21/2020 - 19:03:12: Don't RESERVE STEAM_5:0:2131587224 with gametime(1) < 180
L 12/21/2020 - 19:03:12: Don't RESERVE STEAM_5:0:1110500970 with frags(0) < 5
L 12/21/2020 - 19:03:12: Don't RESERVE STEAM_5:0:130462778 with frags(0) < 5
L 12/21/2020 - 19:03:12: Don't RESERVE STEAM_5:0:1951325753 with frags(0) < 5
L 12/21/2020 - 19:03:12: Don't RESERVE STEAM_5:0:298256541 with frags(0) < 5
L 12/21/2020 - 19:03:35: Don't INSERT STEAM_5:0:2131587224 with gametime(24) < 60
L 12/21/2020 - 19:03:35: Don't INSERT STEAM_5:0:1110500970 with frags(0) < 1
L 12/21/2020 - 19:03:35: Don't INSERT STEAM_5:0:130462778 with frags(0) < 1
L 12/21/2020 - 19:03:35: Don't INSERT STEAM_5:0:1951325753 with frags(0) < 1
L 12/21/2020 - 19:03:35: Don't INSERT STEAM_5:0:298256541 with frags(0) < 1
L 12/21/2020 - 19:03:35: SQL_Tuple != Empty_Handle AND SQL_FreeHandle(SQL_Tuple) 15
L 12/21/2020 - 19:03:35:

L 12/21/2020 - 19:03:35: CREATE TABLE IF NOT EXISTS `csstats_players` (`id` int(11) NOT NULL AUTO_INCREMENT, `nick` varchar(32) NOT NULL, `authid` varchar(32) NOT NULL, `ip` varchar(32) NOT NULL, `frags` int(11) NOT NULL DEFAULT '0',`deaths` int(11) NOT NULL DEFAULT '0',`headshots` int(11) NOT NULL DEFAULT '0',`teamkills` int(11) NOT NULL DEFAULT '0',`shots` int(11) NOT NULL DEFAULT '0',`hits` int(11) NOT NULL DEFAULT '0',`damage` int(11) NOT NULL DEFAULT '0',`suicide` int(11) NOT NULL DEFAULT '0',`defusing` int(11) NOT NULL DEFAULT '0',`defused` int(11) NOT NULL DEFAULT '0',`planted` int(11) NOT NULL DEFAULT '0',`explode` int(11) NOT NULL DEFAULT '0',`place` int(11) NOT NULL DEFAULT '0',`lasttime` int(11) NOT NULL DEFAULT '0',`gametime` int(11) NOT NULL DEFAULT '0',`connects` int(11) NOT NULL DEFAULT '0',`rounds` int(11) NOT NULL DEFAULT '0',`wint` int(11) NOT NULL DEFAULT '0',`winct` int(11) NOT NULL DEFAULT '0',`skill` int(11) NOT NULL DEFAULT '0',`ar_addxp` int(11) NOT NULL DEFAULT '0',`ar_anew` int(11) NOT NULL DEFAULT '0',PRIM
L 12/21/2020 - 19:03:35: CREATE TABLE IF NOT EXISTS `csstats_settings` (`command` varchar(64) NOT NULL, `value` text NOT NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
L 12/21/2020 - 19:03:35: SELECT `value` FROM `csstats_settings` WHERE `command`='table_hash' LIMIT 1
L 12/21/2020 - 19:03:35: cur_hash:9cbbb160ee4abeafdba3c0dfc7d2e369 == sql_hash:9cbbb160ee4abeafdba3c0dfc7d2e369 (не обновляем таблицу настроек)
L 12/21/2020 - 19:03:35: DELETE FROM `csstats_players` WHERE (ar_addxp=0 AND ar_anew=0 AND (lasttime<(UNIX_TIMESTAMP(NOW())-1296000) OR gametime<60 OR frags<=2)) OR (lasttime<(UNIX_TIMESTAMP(NOW())-7776000))
L 12/21/2020 - 19:03:35: SELECT `frags`,`deaths`,`headshots`,`teamkills`,`shots`,`hits`,`damage`,`suicide`,`defusing`,`defused`,`planted`,`explode`,`place`,`lasttime`,`gametime`,`connects`,`rounds`,`wint`,`winct`,`skill`,`ar_addxp`,`ar_anew`,`authid`,`nick`,`ip` FROM `csstats_players`

[ 1] GameCMS_API 5.4.9 zhorzh78 gamecms_api_5.4 running
[ 2] Admin Commands 1.8.2 AMXX Dev Team admincmd.amxx running
[ 3] Slots Reservation 1.8.2 AMXX Dev Team adminslots.amxx running
[ 4] Admin Base (SQL) 1.8.2 AMXX Dev Team admin_sql.amxx running
[ 5] Admin Chat 1.8.M AMXX Dev Team adminchat.amxx running
[ 6] Commands Menu 1.8.2 AMXX Dev Team cmdmenu.amxx running
[ 7] [182] VIP RBS 20.07.20 SKAJIbnEJIb vip_rbs.amxx running
[ 8] [182] Skill ELO 20.06.06 SKAJIbnEJIb skill_elo.amxx running
[ 9] [182] Army Ranks Ultim 20.06.06 SKAJIbnEJIb army_ranks_ulti running
[ 10] [183] Chat RBS 20.06.06 SKAJIbnEJIb chat_rbs.amxx running
[ 11] Stats Configuration 20.06.06 SKAJIbnEJIb & AM statscfg_rbs.am running
[ 12] [182] StatsX RBS 20.06.06 SKAJIbnEJIb & AM statsx_rbs.amxx running
[ 13] [182] CsStats MySQL 20.06.06 SKAJIbnEJIb csstats_mysql.a running
[ 14] [183] Balancing Map Fu 20.06.06 SKAJIbnEJIb balancing_map_f running
[ 15] [183] MapChooser RBS 20.08.02 SKAJIbnEJIb & UF mapchooser_rbs. running
[ 16] [183] Team Balancer 17.10.30 Sanlerus team_balancer.a running
[ 17] [183] AfkKicker RBS 20.08.02 SKAJIbnEJIb afkkicker_rbs.a running
[ 18] [183] Damager RBS 20.06.06 SKAJIbnEJIb damager_rbs.amx running
[ 19] [183] NextMap 18.09.25 SKAJIbnEJIb & AM nextmap.amxx running
[ 20] [183] TimeLeft 18.09.25 SKAJIbnEJIb & AM timeleft.amxx running
[ 21] Menus Front-End 1.8.2 AMXX Dev Team menufront.amxx running
[ 22] Players Menu 1.8.M AMXX Dev Team plmenu.amxx running
[ 23] Restrict Weapons 1.8.2 AMXX Dev Team restmenu.amxx running
[ 24] Plugin Menu 1.8.2 AMXX Dev Team pluginmenu.amxx running
[ 25] drop all HLProxy clien based on Z 1.0 block_HLproxy.a running
[ 26] [SRB] Fix Recoil 0.1 ServerBy905 Team Diak.amxx running
[ 27] ResetScore 0.2.0 aNNakin resetscore.amxx running
[ 28] Block Change Name 1.0 DJ_WEST block_ChangeNam running

Сообщение автоматически объединено: 21 Дек 2020

Почему то и в gamecms тоже не отображает стату http://sensation-tm.ru/stats, хотя на вашей отображает хоть и без фрагов http://sensation-tm.ru/statscs/

SKAJIbnEJIb · 21 Дек 2020

Ну у вас в логах ни одного фрага не сделано. Вы можете заснять видео? Покажите как вы играете на сервере 5 минут. Не просто стоите, а делаете фраги

Diak · 22 Дек 2020

@SKAJIbnEJIb, я же скинул скрин stats и в тот же момент скрин top, по ним же видно то что я играю делаю фраги а в top не отображается, хоршо сделаю видео

Diak · 22 Дек 2020

Для просмотра скрытого содержимого вы должны войти или зарегистрироваться.

SKAJIbnEJIb · 22 Дек 2020

SKAJIbnEJIb написал(а):
Не просто стоите, а делаете фраги

в видео нет ни одного фрага... делаю вывод, что и до видео, вы тестировали так же. Повторяться в очередной раз не вижу смысла, читайте внимательней то, что вам пишут, перечитайте

Diak · 22 Дек 2020

@SKAJIbnEJIb, понятно, сделаем видео с фрагами, до этого фраги были я же уже писал об этом и скидывал скрин stats где показано то что фраги были

SKAJIbnEJIb · 22 Дек 2020

Diak написал(а):
@SKAJIbnEJIb, понятно, сделаем видео с фрагами, до этого фраги были я же уже писал об этом и скидывал скрин stats где показано то что фраги были

Я не знаю, почему у вас не пишутся фраги, я лишь вижу логи, в которых видно, что фрагов вы не делали. И так как подобной проблемы ни у кого нет, тут два варианта:
вы где то просто не так тестируете
или какая то проблема с самим сервом

Diak · 22 Дек 2020

@SKAJIbnEJIb, в поддержку написал вот их ответ:

Добрый день
Соединение есть
L 12/20/2020 - 17:31:06: [CsStats MySQL] Удалено из базы 0 игроков
[CsStats MySQL] Успешное соединение с MySQL. Загружено 0 игроков за 1.1549 секунд
L 12/20/2020 - 17:31:06: [CsStats MySQL] Успешное соединение с MySQL. Загружено 0 игроков за 1.1549 секунд

Почему не пишет, нам неизвестно. Обратитесь к автору плагина.
С уважением, MyArena.ru
Сейчас загружу видео

Сообщение автоматически объединено: 22 Дек 2020

Для просмотра скрытого содержимого вы должны войти или зарегистрироваться.

[ 1] [183] Skill ELO 20.06.06 SKAJIbnEJIb skill_elo.amxx running
[ 2] Stats Configuration 20.06.06 SKAJIbnEJIb & AM statscfg_rbs.am running
[ 3] [183] StatsX RBS 20.06.06 SKAJIbnEJIb & AM statsx_rbs.amxx running
[ 4] [183] CsStats MySQL 20.06.06 SKAJIbnEJIb csstats_mysql.a running
4 plugins, 4 running

[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.8.3-d ini Start ANY
[ 2] Engine RUN - engine_amxx_i386 v1.8.3-d pl1 ANY ANY
[ 3] MySQL RUN - mysql_amxx_i386. v1.8.3-d pl1 ANY ANY
[ 4] FakeMeta RUN - fakemeta_amxx_i3 v1.8.3-d pl1 ANY ANY
[ 5] CSX RUN - csx_amxx_i386.so v1.8.3-d pl1 ANY ANY
[ 6] Ham Sandwich RUN - hamsandwich_amxx v1.8.3-d pl1 ANY ANY
6 plugins, 6 running

amxx version
AMX Mod X 1.8.3-dev+5201 (http://www.amxmodx.org)
Authors:
David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko
Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom
Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher
Borja "faluco" Ferrer, Scott "DS" Ehlert
Compiled: Sep 1 2018 09:52:22
Built from: https://github.com/alliedmodders/amxmodx/commit/8c0f97d
Build ID: 5201:8c0f97d
Core mode: JIT+ASM32

L 12/22/2020 - 14:25:13: Log file started (file "cstrike/addons/amxmodx/logs/csstats_mysql.log") (game "cstrike") (amx "1.8.3-dev+5201")
L 12/22/2020 - 14:25:13: Don't UPDATE STEAM_0:0:197983630 with gametime(15) < 30
L 12/22/2020 - 14:25:19: Don't RESERVE STEAM_0:1:309183 with gametime(26) < 180
L 12/22/2020 - 14:25:19: Don't RESERVE STEAM_0:0:197983630 with gametime(3) < 180
L 12/22/2020 - 14:25:58: Don't RESERVE STEAM_0:1:309183 with gametime(65) < 180
L 12/22/2020 - 14:25:58: Don't RESERVE STEAM_0:0:197983630 with gametime(42) < 180
L 12/22/2020 - 14:26:17: Don't RESERVE STEAM_0:1:309183 with gametime(84) < 180
L 12/22/2020 - 14:26:17: Don't RESERVE STEAM_0:0:197983630 with gametime(61) < 180
L 12/22/2020 - 14:26:44: Don't RESERVE STEAM_0:1:309183 with gametime(111) < 180
L 12/22/2020 - 14:26:44: Don't RESERVE STEAM_0:0:197983630 with gametime(88) < 180
L 12/22/2020 - 14:27:02: Don't RESERVE STEAM_0:1:309183 with gametime(129) < 180
L 12/22/2020 - 14:27:02: Don't RESERVE STEAM_0:0:197983630 with gametime(106) < 180
L 12/22/2020 - 14:27:30: Don't RESERVE STEAM_0:1:309183 with gametime(157) < 180
L 12/22/2020 - 14:27:30: Don't RESERVE STEAM_0:0:197983630 with gametime(134) < 180
L 12/22/2020 - 14:27:45: Don't RESERVE STEAM_0:1:309183 with gametime(172) < 180
L 12/22/2020 - 14:27:45: Don't RESERVE STEAM_0:0:197983630 with gametime(149) < 180
L 12/22/2020 - 14:28:24: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:28:24: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:28:41: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:28:41: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:29:11: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:29:11: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:29:41: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:29:41: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:30:06: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:30:06: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:30:24: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:30:24: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:30:45: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:30:45: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:32:22: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:32:22: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:32:42: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:32:42: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:33:03: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:33:03: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:33:28: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:33:28: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:33:47: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:33:47: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:34:10: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:34:10: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:34:34: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:34:34: Don't RESERVE STEAM_0:0:197983630 with frags(0) < 5
L 12/22/2020 - 14:34:41: UPDATE `csstats_players` SET defusing=defusing+1,winct=winct+8,rounds=rounds+21,skill='108',nick='Sensation_',connects=connects+1,gametime=gametime+565,lasttime=UNIX_TIMESTAMP() WHERE authid='STEAM_0:0:197983630' LIMIT 1;
L 12/22/2020 - 14:35:18: UPDATE `csstats_players` SET planted=planted+1,wint=wint+12,rounds=rounds+21,skill='114',nick='Diak [Sensation-tm.ru]',connects=connects+1,gametime=gametime+625,lasttime=UNIX_TIMESTAMP() WHERE authid='STEAM_0:1:309183' LIMIT 1;
L 12/22/2020 - 14:37:23: Don't RESERVE STEAM_0:1:309183 with gametime(119) < 180
L 12/22/2020 - 14:39:28: Don't RESERVE STEAM_0:1:309183 with frags(0) < 5
L 12/22/2020 - 14:42:14:

L 12/22/2020 - 14:42:15: CREATE TABLE IF NOT EXISTS `csstats_players` (`id` int(11) NOT NULL AUTO_INCREMENT, `nick` varchar(32) NOT NULL, `authid` varchar(32) NOT NULL, `ip` varchar(32) NOT NULL, `frags` int(11) NOT NULL DEFAULT '0',`deaths` int(11) NOT NULL DEFAULT '0',`headshots` int(11) NOT NULL DEFAULT '0',`teamkills` int(11) NOT NULL DEFAULT '0',`shots` int(11) NOT NULL DEFAULT '0',`hits` int(11) NOT NULL DEFAULT '0',`damage` int(11) NOT NULL DEFAULT '0',`suicide` int(11) NOT NULL DEFAULT '0',`defusing` int(11) NOT NULL DEFAULT '0',`defused` int(11) NOT NULL DEFAULT '0',`planted` int(11) NOT NULL DEFAULT '0',`explode` int(11) NOT NULL DEFAULT '0',`place` int(11) NOT NULL DEFAULT '0',`lasttime` int(11) NOT NULL DEFAULT '0',`gametime` int(11) NOT NULL DEFAULT '0',`connects` int(11) NOT NULL DEFAULT '0',`rounds` int(11) NOT NULL DEFAULT '0',`wint` int(11) NOT NULL DEFAULT '0',`winct` int(11) NOT NULL DEFAULT '0',`skill` int(11) NOT NULL DEFAULT '0',`ar_addxp` int(11) NOT NULL DEFAULT '0',`ar_anew` int(11) NOT NULL DEFAULT '0',PRIM
L 12/22/2020 - 14:42:15: CREATE TABLE IF NOT EXISTS `csstats_settings` (`command` varchar(64) NOT NULL, `value` text NOT NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
L 12/22/2020 - 14:42:15: SELECT `value` FROM `csstats_settings` WHERE `command`='table_hash' LIMIT 1
L 12/22/2020 - 14:42:15: cur_hash:4e7f719d20981ee7cd32e8f1bc340c33 == sql_hash:4e7f719d20981ee7cd32e8f1bc340c33 (не обновляем таблицу настроек)
L 12/22/2020 - 14:42:15: DELETE FROM `csstats_players` WHERE (ar_addxp=0 AND ar_anew=0 AND (lasttime<(UNIX_TIMESTAMP(NOW())-1296000) OR gametime<60 OR frags<=2)) OR (lasttime<(UNIX_TIMESTAMP(NOW())-7776000))
L 12/22/2020 - 14:42:15: SELECT `frags`,`deaths`,`headshots`,`teamkills`,`shots`,`hits`,`damage`,`suicide`,`defusing`,`defused`,`planted`,`explode`,`place`,`lasttime`,`gametime`,`connects`,`rounds`,`wint`,`winct`,`skill`,`ar_addxp`,`ar_anew`,`authid`,`nick`,`ip` FROM `csstats_players`

SKAJIbnEJIb · 22 Дек 2020

в общем что то с сервером у вас, он не видит фрагов, чтобы я сделал:
удалил все к херам, поставил последний rehlds с regamedll и прочими нужными модулями, поставил amx190 и эти плагины

Diak · 23 Дек 2020

@SKAJIbnEJIb, сделал, теперь другой вопрос ))) не создаёт таблицу в БД

L 12/23/2020 - 10:11:23: CREATE TABLE IF NOT EXISTS `csstats_players` (`id` int(11) NOT NULL AUTO_INCREMENT, `nick` varchar(32) NOT NULL, `authid` varchar(32) NOT NULL, `ip` varchar(32) NOT NULL, `frags` int(11) NOT NULL DEFAULT '0',`deaths` int(11) NOT NULL DEFAULT '0',`headshots` int(11) NOT NULL DEFAULT '0',`teamkills` int(11) NOT NULL DEFAULT '0',`shots` int(11) NOT NULL DEFAULT '0',`hits` int(11) NOT NULL DEFAULT '0',`damage` int(11) NOT NULL DEFAULT '0',`suicide` int(11) NOT NULL DEFAULT '0',`defusing` int(11) NOT NULL DEFAULT '0',`defused` int(11) NOT NULL DEFAULT '0',`planted` int(11) NOT NULL DEFAULT '0',`explode` int(11) NOT NULL DEFAULT '0',`place` int(11) NOT NULL DEFAULT '0',`lasttime` int(11) NOT NULL DEFAULT '0',`gametime` int(11) NOT NULL DEFAULT '0',`connects` int(11) NOT NULL DEFAULT '0',`rounds` int(11) NOT NULL DEFAULT '0',`wint` int(11) NOT NULL DEFAULT '0',`winct` int(11) NOT NULL DEFAULT '0',`skill` int(11) NOT NULL DEFAULT '0',`ar_addxp` int(11) NOT NULL DEFAULT '0',`ar_anew` int(11) NOT NULL DEFAULT '0',PRIM
L 12/23/2020 - 10:11:23: CREATE TABLE IF NOT EXISTS `csstats_settings` (`command` varchar(64) NOT NULL, `value` text NOT NULL) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;
L 12/23/2020 - 10:11:23: SELECT `value` FROM `csstats_settings` WHERE `command`='table_hash' LIMIT 1
L 12/23/2020 - 10:11:23: cur_hash:9c5016191a3de19e36ea2f447e1ca4cb == sql_hash:9c5016191a3de19e36ea2f447e1ca4cb (не обновляем таблицу настроек)
L 12/23/2020 - 10:11:23: DELETE FROM `csstats_players` WHERE (ar_addxp=0 AND ar_anew=0 AND (lasttime<(UNIX_TIMESTAMP(NOW())-1296000) OR gametime<120 OR frags<=2)) OR (lasttime<(UNIX_TIMESTAMP(NOW())-7776000))
L 12/23/2020 - 10:11:23: SELECT `frags`,`deaths`,`headshots`,`teamkills`,`shots`,`hits`,`damage`,`suicide`,`defusing`,`defused`,`planted`,`explode`,`place`,`lasttime`,`gametime`,`connects`,`rounds`,`wint`,`winct`,`skill`,`ar_addxp`,`ar_anew`,`authid`,`nick`,`ip` FROM `csstats_players`
L 12/23/2020 - 10:11:38: Don't RESERVE STEAM_1:0:78488306 with gametime(12) < 180
L 12/23/2020 - 10:11:38: Don't RESERVE STEAM_1:0:84268067 with gametime(12) < 180
L 12/23/2020 - 10:11:38: Don't RESERVE STEAM_1:0:1279534492 with gametime(5) < 180
L 12/23/2020 - 10:12:01: Don't INSERT STEAM_1:0:78488306 with gametime(35) < 60
L 12/23/2020 - 10:12:01: Don't INSERT STEAM_1:0:84268067 with gametime(35) < 60
L 12/23/2020 - 10:12:01: Don't INSERT STEAM_1:0:1279534492 with gametime(28) < 60
L 12/23/2020 - 10:12:53: Don't INSERT STEAM_0:1:309183 with gametime(58) < 60
L 12/23/2020 - 10:14:05:

SKAJIbnEJIb · 23 Дек 2020

@Diak, судя по логу, создает

Diak · 23 Дек 2020

@SKAJIbnEJIb, Извиняюсь, увидел свой косяк

Не пишет статистику

Diak

Новичок

Вложения

Diak

Новичок

DIVIZION

visibility

Diak

Новичок

DIVIZION

visibility

Diak

Новичок

SKAJIbnEJIb

visibility

Diak

Новичок

Diak

Новичок

SKAJIbnEJIb

visibility

Diak

Новичок

SKAJIbnEJIb

visibility

Diak

Новичок

SKAJIbnEJIb

visibility

Diak

Новичок

SKAJIbnEJIb

visibility

Diak

Новичок

Похожие темы