• Уважаемые пользователи! Решение проблем с работой плагинов, компиляцией, падением сервера и прочими обращайтесь в раздел Помощи! Данная тема предназначена для обсуждения плагина, его функционала, принципа работы и предложений.
GameCMS API

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

Нет прав для скачивания

Sokol

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

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

Вложения

Последнее редактирование:

formula

Участник
Подскажите, куда рыть, как убрать этот страх, соединение есть, а сервер на сайте не отображается, что делать?
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
 
Последнее редактирование:

pollfank

Участник
Здравствуйте.
Есть два вопроса:
1. Можно ли выдать привилегию (услугу) на steamID по такому способу
Код:
cmsapi_add_account(id, "c", ......
(вместо флага "a" поставить "c", смотрел с примера какие флаги выдаются если присвоение идет по Нику, IP или SteamID)

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

Код:
cmsapi_add_account(id, "с", 1440, "", _, 15, false)
 

Yamiru

Участник
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"
 

Evgen

Участник
Прописываю в консоль
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 (услуга  ) успешно добавлен
Пользователя в админах Админцентра движка создаёт, а флаги не выдаёт.
Что может быть не так?
 

Evgen

Участник
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

Администратор
Evgen, Просил, не решать здесь свои проблемы.
C++:
/*======== Обработка консольной команды =============*/
//amx_addadmin "счастливое лицо" "пароль" "флаги" "тип авторизации" "время в минутах"
1. У вас пароль и флаги местами перепутаны
2. Услуга с флагами abcdefghijklmnopqrstu должна быть создана на сайте для данного сервера.
 

Evgen

Участник
Evgen, Просил, не решать здесь свои проблемы.
C++:
/*======== Обработка консольной команды =============*/
//amx_addadmin "счастливое лицо" "пароль" "флаги" "тип авторизации" "время в минутах"
1. У вас пароль и флаги местами перепутаны
2. Услуга с флагами abcdefghijklmnopqrstu должна быть создана на сайте для данного сервера.
Разобрался, спасибо за помощь!
 

Diak2009

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

Diak2009

Участник
Решение проблем осуществляется в теме Помощи!
[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

Администратор
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

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