Плагин АМХХ GameCMS API 5.6.3

bloodex · 12 Ноя 2020

Sokol написал(а):
bloodex, Есть такой модуль статистики, туда добавлю сколько за все время было продано услуг.

вы же можете на сайте смотреть , в логах услуги )))) мне кажется это лишнее ...

Sokol · 12 Ноя 2020

bloodex, смотрите я вам мешаю, сам решу что мне делать ок?

Хм. Вроде норм

formula · 12 Ноя 2020

Подскажите, куда рыть, как убрать этот страх, соединение есть, а сервер на сайте не отображается, что делать?

L 11/13/2020 - 00:12:11: -------- Mapchange to de_dust2_2x2 --------
L 11/13/2020 - 00:12:12: [gamecms_api_5.4.7.amxx] Reading GameCMS settings file... OK
L 11/13/2020 - 00:12:12: [gamecms_api_5.4.7.amxx] Connection to the GameCMS database is established
L 11/13/2020 - 00:12:12: [amxbans_rbs.amxx] Login: "N.O formula X<13><STEAM_0:1:86268259><94.31.154.196>" успешно авторизован (account "N.O formula X") (access "abcdefghijklmnopqrtu") (nick "N.O formula X") (static "0") (event "connect")
L 11/13/2020 - 00:12:15: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`, `plugins_settings` , `game_money` ,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:34018223' OR `users`.`steam_id` = '76561198028302175' OR `users`.`steam_api` = '76561198028302175'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:1:34018223' OR `users`.`steam_id` = '76561198028302175' OR `users`.`steam_api` = '76561198028302175');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'plugins_settings' in 'field list' (1054)
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`, `game_money` ,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:1086091' OR `users`.`steam_id` = '76561197962437911' OR `users`.`steam_api` = '76561197962437911'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:1:1086091' OR `users`.`steam_id` = '76561197962437911' OR `users`.`steam_api` = '76561197962437911');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`, `game_money` ,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:189313546' OR `users`.`steam_id` = '76561198338892820' OR `users`.`steam_api` = '76561198338892820'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:0:189313546' OR `users`.`steam_id` = '76561198338892820' OR `users`.`steam_api` = '76561198338892820');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'game_money' in 'field list' (1054)
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:86268259' OR `users`.`steam_id` = '76561198132802247' OR `users`.`steam_api` = '76561198132802247'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:1:86268259' OR `users`.`steam_id` = '76561198132802247' OR `users`.`steam_api` = '76561198132802247');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1301210617' OR `users`.`steam_id` = '765611991642155506' OR `users`.`steam_api` = '765611991642155506'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:0:1301210617' OR `users`.`steam_id` = '765611991642155506' OR `users`.`steam_api` = '765611991642155506');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1136195287' OR `users`.`steam_id` = '765611991312124846' OR `users`.`steam_api` = '765611991312124846'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:0:1136195287' OR `users`.`steam_id` = '765611991312124846' OR `users`.`steam_api` = '765611991312124846');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'game_money' in 'field list' (1054)
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'member_online' in 'field list' (1054)
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:445280991' OR `users`.`steam_id` = '76561198850827710' OR `users`.`steam_api` = '76561198850827710');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:507461281' OR `users`.`steam_id` = '76561198975188290' OR `users`.`steam_api` = '76561198975188290');
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'member_online' in 'field list' (1054)
L 11/13/2020 - 00:12:16: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'member_online' in 'field list' (1054)
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1468019690' OR `users`.`steam_id` = '765611991975773652' OR `users`.`steam_api` = '765611991975773652');
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:113640619' OR `users`.`steam_id` = '76561198187546966' OR `users`.`steam_api` = '76561198187546966');
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:17: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:18: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:448706196' OR `users`.`steam_id` = '76561198857678121' OR `users`.`steam_api` = '76561198857678121');
L 11/13/2020 - 00:12:18: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:43: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:530861095' OR `users`.`steam_id` = '76561199021987918' OR `users`.`steam_api` = '76561199021987918');
L 11/13/2020 - 00:12:43: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:57: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:311758599' OR `users`.`steam_id` = '76561198583782926' OR `users`.`steam_api` = '76561198583782926');
L 11/13/2020 - 00:12:57: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:12:59: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1716351234' OR `users`.`steam_id` = '76561199822530556' OR `users`.`steam_api` = '76561199822530556');
L 11/13/2020 - 00:12:59: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:14:44: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1047228784' OR `users`.`steam_id` = '76561199054723296' OR `users`.`steam_api` = '76561199054723296');
L 11/13/2020 - 00:14:45: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:17:55: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1037230562' OR `users`.`steam_id` = '76561199034726852' OR `users`.`steam_api` = '76561199034726852');
L 11/13/2020 - 00:17:55: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:19:04: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:122046185' OR `users`.`steam_id` = '76561198204358098' OR `users`.`steam_api` = '76561198204358098');
L 11/13/2020 - 00:19:04: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:19:59: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:58199655' OR `users`.`steam_id` = '76561198076665039' OR `users`.`steam_api` = '76561198076665039');
L 11/13/2020 - 00:20:00: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:21:00: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:597681905' OR `users`.`steam_id` = '76561199155629538' OR `users`.`steam_api` = '76561199155629538');
L 11/13/2020 - 00:21:00: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:21:22: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1223607605' OR `users`.`steam_id` = '765611991486949482' OR `users`.`steam_api` = '765611991486949482');
L 11/13/2020 - 00:21:22: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:21:26: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:58511557' OR `users`.`steam_id` = '76561198077288843' OR `users`.`steam_api` = '76561198077288843');
L 11/13/2020 - 00:21:26: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/13/2020 - 00:21:44: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:0:1955754850' OR `users`.`steam_id` = '76561199343723324' OR `users`.`steam_api` = '76561199343723324');
L 11/13/2020 - 00:21:44: [gamecms_api_5.4.7.amxx] SQL_NumResults null

bloodex · 12 Ноя 2020

cms_debug "0" пропиши

L 11/04/2020 - 17:32:22: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'plugins_settings' in 'field list' (1054)

formula · 12 Ноя 2020

bloodex написал(а):
cms_debug "0" пропиши

L 11/04/2020 - 17:32:22: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'plugins_settings' in 'field list' (1054)

Спасибо, стало лучше, правда cms_debug "1" сделал))

pollfank · 21 Ноя 2020

Здравствуйте.
Есть два вопроса:
1. Можно ли выдать привилегию (услугу) на steamID по такому способу

Код:

cmsapi_add_account(id, "c", ......

(вместо флага "a" поставить "c", смотрел с примера какие флаги выдаются если присвоение идет по Нику, IP или SteamID)

2. Если да, то будет ли услуга работать если пароль будет пустым (без пароля)?
Например, я хочу выдать на неделю ВИП на Стим Айди по номеру услуги

Код:

cmsapi_add_account(id, "с", 1440, "", _, 15, false)

zhorzh78 · 21 Ноя 2020

pollfank, 1. Можно
2. Будет
3. Стим без пароля- "се"
4. Включите последний параметр в true и он сам все проверит.

pollfank · 21 Ноя 2020

zhorzh78, при false тоже работает, проверял.

Yamiru · 23 Ноя 2020

all without error, but if I disconnect server console give error:

Executing ReGameDLL Configuration File
L 11/23/2020 - 18:43:59: Server cvar "mp_forcerespawn" = "0"
L 11/23/2020 - 18:43:59: Server cvar "mp_falldamage" = "1"
[ReAuthCheck] Success: Configuration executed.
Executing AMX Mod X Configuration File
Executing AMX Mod X Configuration File
[AMXBans] is starting to execute amxbans.cfg
[AMXBans] amxbans.cfg is fully executed
Executing GameCMS Configuration File
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 1, flags abcdefijlmntu
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 3, flags abcdefijmnprtu
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 4, flags abiqt
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 10, flags abipt
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 11, flags abiprt
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 12, flags abcdefijmnqtu
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] Reading GameCMS settings file... OK
L 11/23/2020 - 18:43:59: [cmsstats_mysql_1.17.2.amxx] CSX is NOT loaded
L 11/23/2020 - 18:43:59: [cmsstats_mysql_1.17.2.amxx] Command: CMSStats is Enabled
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] Connection to the GameCMS database is established
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] SELECT `id`, `name` FROM `users__groups`
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] SELECT `a`.`id`, `a`.`name` as `auth`,`pass`, COALESCE(REPLACE(`ad`.`rights_und`,'none',`s`.`rights`),`ad`.`rights_und`) AS `flags`, `a`.`type`, `ending_date` as `expired`,`ad`.`id` AS `admin_service_id`,`ad`.`service`,`service_time`,`a`.`active`,`a`.`pause`, `s`.`name` as `service_name`, `cause`, UNIX_TIMESTAMP(`ending_date`) as [ReSRDetector] Success: Configuration executed.
L 11/23/2020 - 18:43:59: [gamecms_api_5.4.7.amxx] "0" services was 'Loaded' from database. Total on server: "0" services.
L 11/23/2020 - 18:44:00: Started map "de_dust2_snow" (CRC "-1656894607")
[AMXBans] Loaded 0 admins from database
L 11/23/2020 - 18:44:00: [amxbans_main.amxx] [AMXBans] AMXBans 6.13 je zapnute
[AMXBans] Ziadne dovody nenajdene
[AMXBans] Ziadne dovody neboli najdene v databaze. Boli nacitane staticke.
L 11/23/2020 - 18:44:00: [amxbans_main.amxx] [AMXBans] Ziadne dovody neboli najdene v databaze. Boli nacitane staticke.
L 11/23/2020 - 18:44:01: [cmsstats MySQL] All settings on [csstats_settings] was successfully Updated [0.0108 seconds]
[0] players was removed from DB by configs settings. All players was sorting by rank
L 11/23/2020 - 18:44:01: [cmsstats MySQL] Players count: 0 [Query: 0.0323 seconds][Time: 2.0580]
L 11/23/2020 - 18:44:02: [cmsstats_mysql_1.17.2.amxx] [STATUS] The plugin is successfully activated
L 11/23/2020 - 18:44:07: World triggered "Round_Start"
L 11/23/2020 - 18:46:40: "EamRru<2><STEAM_0:1:33716434><>" connected, address "88.212.54.111:27005"
L 11/23/2020 - 18:46:40: "EamRru<2><STEAM_0:1:33716434><>" STEAM USERID validated
L 11/23/2020 - 18:46:42: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) -> file: (../demoplayer.dll), md5hex: (641d3c2c) for (Yamiru)
L 11/23/2020 - 18:46:42: "EamRru<2><STEAM_0:1:30916434><>" entered the game
L 11/23/2020 - 18:46:42: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/23/2020 - 18:46:43: [cmsstats MySQL] client_putinserver NOT EXIST 1 / STEAM_0:1:30916434 / 1
L 11/23/2020 - 18:46:49: "EamRru<2><STEAM_0:1:33716434><>" joined team "CT"
L 11/23/2020 - 18:46:51: "EamRru<2><STEAM_0:1:33716434><CT>" disconnected
L 11/23/2020 - 18:46:51: World triggered "Round_Draw" (CT "0") (T "0")
L 11/23/2020 - 18:46:51: World triggered "Round_End"
Dropped EamRru from server
Reason: Client sent 'drop'
L 11/23/2020 - 18:46:51: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Field 'teamkills' doesn't have a default value (1364)
L 11/23/2020 - 18:47:02: World triggered "Round_Start"

zhorzh78 · 24 Ноя 2020

Yamiru, https://cs-games.club/index.php?forums/Проблемы-с-плагинами.24/post-thread
Укажите ошибку.

Evgen · 25 Ноя 2020

Прописываю в консоль

C++:

amx_addadmin "Pr0pi" "abcdefghijklmnopqrstu" "y0ur_pass" "a"

В логах

C++:

L 11/25/2020 - 09:53:12: [gamecms_api_5.3.5.amxx] [API-AddAdmin] Установлена авторизация по Ник + пароль
L 11/25/2020 - 09:53:12: [gamecms_api_5.3.5.amxx] [API-AddAdmin] Админ №2805 (услуга  ) успешно добавлен

Пользователя в админах Админцентра движка создаёт, а флаги не выдаёт.
Что может быть не так?

zhorzh78 · 25 Ноя 2020

Evgen, В консоль cms_debug 4
Затем, amx_addadmin "Pr0pi" "abcdefghijklmnopqrstu" "y0ur_pass" "a"
После, лог в тему

Evgen · 25 Ноя 2020

zhorzh78 написал(а):
Evgen, В консоль cms_debug 4
Затем, amx_addadmin "Pr0pi" "abcdefghijklmnopqrstu" "y0ur_pass" "a"
После, лог в тему

C++:

L 11/25/2020 - 15:27:46: [gamecms_api_5.3.5.amxx] [API-AddAdmin] Установлена авторизация по Ник + пароль
L 11/25/2020 - 15:27:46: [gamecms_api_5.3.5.amxx] INSERT IGNORE INTO admins (name, type, pass, server, user_id) values ('Pr0pi', 'a', 'abcdefghijklmnopqrstu', '2', '0');INSERT INTO admins__services (rights_und, service_time, bought_date, ending_date, admin_id, service) values ('y0ur_pass', '0', '2020-11-25 15:27:46', '0000-00-00 00:00:00', LAST_INSERT_ID(), (SELECT `id` FROM `services` WHERE `services`.`rights` = 'y0ur_pass' AND `server` = '2'));
L 11/25/2020 - 15:27:46: [gamecms_api_5.3.5.amxx] [API-AddAdmin] Админ №2809 (услуга  ) успешно добавлен
L 11/25/2020 - 15:27:46: [gamecms_api_5.3.5.amxx] SELECT `a`.`id`,cast(convert(`a`.`name` using utf8)as binary) as `auth`,`pass`,COALESCE(REPLACE(`ad`.`rights_und`,'none',`s`.`rights`),`ad`.`rights_und`) AS `flags`,`a`.`type`,`ending_date` as `expired`,`ad`.`id` AS `admin_service`,`ad`.`service`,`service_time`,`a`.`active`,`a`.`pause`,cast(convert(`s`.`name` using utf8)as binary) as `service_name`,cast(convert(`cause` using utf8) as binary) as `cause`, UNIX_TIMESTAMP(`ending_date`) as `expunix`, UNIX_TIMESTAMP(NOW()) as `nowunix`    FROM `admins` a LEFT JOIN `admins__services` ad ON `ad`.`admin_id`=`a`.`id`LEFT JOIN `servers` sr ON `server`=`sr`.`id` LEFT JOIN `services` s ON `ad`.`service`=`s`.`id`WHERE `sr`.`id` = '2' AND (UNIX_TIMESTAMP(`ending_date`) > UNIX_TIMESTAMP(NOW()) OR `ending_date` = '0000-00-00 00:00:00')     AND `a`.`id`='2809'

zhorzh78 · 25 Ноя 2020

Evgen, Просил, не решать здесь свои проблемы.

C++:

/*======== Обработка консольной команды =============*/
//amx_addadmin "счастливое лицо" "пароль" "флаги" "тип авторизации" "время в минутах"

1. У вас пароль и флаги местами перепутаны
2. Услуга с флагами abcdefghijklmnopqrstu должна быть создана на сайте для данного сервера.

Evgen · 25 Ноя 2020

zhorzh78 написал(а):
Evgen, Просил, не решать здесь свои проблемы.

C++:

/*======== Обработка консольной команды =============*/ //amx_addadmin "счастливое лицо" "пароль" "флаги" "тип авторизации" "время в минутах"

1. У вас пароль и флаги местами перепутаны
2. Услуга с флагами abcdefghijklmnopqrstu должна быть создана на сайте для данного сервера.

Разобрался, спасибо за помощь!

Diak2009 · 30 Ноя 2020

[AMXX] Ошибка SQL: загрузить список администраторов невозможно из 'Неизвестный столбец' auth 'в' списке полей ''
Подскажите из за чего происходит данная ошибка

zhorzh78 · 30 Ноя 2020

Diak2009, https://cs-games.club/index.php?forums/Проблемы-с-плагинами.24/
За столько лет уже можно было уяснить, что гадания здесь не уместны.

Diak2009 · 30 Ноя 2020

[QUOTE = "zhorzh78, post: 6359, member: 1"]
[USER = 35] Diak2009 [/ USER], https://cs-games.club/index.php?forums/Проблемы-с-плагинами.24/
За столько лет уже можно было уяснить, что гадания здесь не уместны.
[/ QUOTE]

всё что есть в логах

L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] CmdAddUserGroup номер 1, флаги abcdefijlmntu
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] CmdAddUserGroup номер 3, флаги abcdefijmnprtu
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] CmdAddUserGroup номер 4, флаги abiqt
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] CmdAddUserGroup номер 10, флаги abipt
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] CmdAddUserGroup номер 11, флаги abiprt
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] CmdAddUserGroup номер 12, флаги abcdefijmnqtu
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] Чтение файла настроек GameCMS ... ОК
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] Установлено соединение с базой данных GameCMS
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] ВЫБЕРИТЕ `a`.`id`,` a`.`name` как `auth`,` pass`, COALESCE (REPLACE (` ad`.`rights_und`, 'none', `s`.`rights`),` ad`.`rights_und`) AS `flags`,` a`.`type`, `end_date` как` expired`, ` ad`.`id` AS `admin_service_id`,` ad`.`service`, `service_time`,` a`.`active`, `a`.`pause`,` s`.`name` как `service_name` , `причина`, UNIX_TIMESTAMP (` end_date`) как `expunix`, UNIX_TIMESTAMP (NOW ()) как` nowunix` ОТ `admins` ЛЕВОЕ СОЕДИНЕНИЕ` admins__services` ad ON `ad`.`admin_id` =` a`. `id`LEFT JOIN` server` sr ON `server` =` sr`.`id` LEFT JOIN` services` s ON `ad`.`service` =` s`.`id`WHERE `sr`.`id `= '1' И (UNIX_TIMESTAMP (` end_date`)> UNIX_TIMESTAMP (NOW ()) OR `end_date` = '0000-00-00 00:00:00')
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] «0» сервисов было «загружено» из базы данных. Итого на сервере: «0» сервисов.

zhorzh78 · 30 Ноя 2020

Diak2009,

Код:

L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] Установлено соединение с базой данных GameCMS
L 30.11.2020 - 10:43:30: [gamecms_api_5.4.7.amxx] «0» сервисов было «загружено» из базы данных. Итого на сервере: «0» сервисов.

Не вижу никаких проблем с данным плагинов. Вам дали ссылку на раздел помощи.

pollfank · 1 Дек 2020

zhorzh78, подскажите пожалуйста, как правильно сделать проверку игрока на его регистрацию на сайте с условием, если есть на сайте то тогда .... и т д.

Плагин АМХХ GameCMS API 5.6.3

bloodex

Sokol

Вложения

formula

bloodex

Вложения

formula

pollfank

zhorzh78

pollfank

Yamiru

zhorzh78

Evgen

zhorzh78

Evgen

zhorzh78

Evgen

Diak2009

zhorzh78

Diak2009

zhorzh78

pollfank