Ошибка подключения к базе данных gamecms

L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.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` FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = ‘STEAM_0:0:40222965’ OR `users`.`steam_id` = ‘76561198040711658’ OR `users`.`steam_api` = ‘76561198040711658’);
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] Pre FnFindUserService BlasteeM / STEAM_0:0:40222965 / abcdefijlmntu / 0
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:0:40222965 abcdefijlmntu(abcdefghijmnopqrstu)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] while FnFindUserService STEAM_0:0:40222965 3 / 1 / 0
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] native_cmsapi_get_user_services not found STEAM_0:0:40222965 abcdefijlmntu(0)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] native_cmsapi_set_user_flags: STEAM_0:0:40222965 | service Создатель | flags abcdefijlmntu
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] Setting group flags: «<BlasteeM>» (SteamId profile «STEAM_0:0:40222965») (Group flags «abcdefijlmntu») (Group name «Создатель»)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:0:40222965 (abcdefghijmnopqrstu)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] FnFindUserService All services STEAM_0:0:40222965 Admin+VIP For life
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] Searching… «<BlasteeM><STEAM_0:0:40222965>» (Account name «STEAM_0:0:40222965» / Admin index «6») (Service flags «abcdefghijmnopqrstu») (Service name «Admin+VIP For life») (Expired «0000-00-00 00:00:00»)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:0:40222965 (abcdefijlmntu)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] FnFindUserService All services STEAM_0:0:40222965 Создатель
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] Found service: «<BlasteeM><STEAM_0:0:40222965>» (Account name «STEAM_0:0:40222965» / Admin index «-1») (Service flags «abcdefijlmntu») (Service name «Создатель») (Expired «0000-00-00 00:00:00»)
L 12/16/2020 — 11:38:28: [gamecms_api_5.4.9.amxx] Authentication… «<BlasteeM><STEAM_0:0:40222965>» (Account name «STEAM_0:0:40222965» / Admin index «-1») (Service flags «abcdefijlmntughopqrs») (Service name «Создатель + Admin+VIP For life»)
L 12/16/2020 — 11:38:32: [mapsmenu.amxx] Cmd: «BlasteeM<3><STEAM_0:0:40222965><>» changelevel «$2000$»
L 12/16/2020 — 11:38:34: [gamecms_api_5.4.9.amxx] Save on Disconnect- STEAM_0:0:40222965 / UPDATE users SET game_time=game_time+’8′ WHERE id = ‘6’;
L 12/16/2020 — 11:38:34: ——— Mapchange to $2000$ ———
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] CmdAddUserGroup num 1, flags abcdefijlmntu
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] CmdAddUserGroup num 3, flags abcdefijmnprtu
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] CmdAddUserGroup num 4, flags abiqt
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] CmdAddUserGroup num 10, flags abipt
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] CmdAddUserGroup num 11, flags abiprt
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] CmdAddUserGroup num 12, flags abcdefijmnqtu
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] Reading GameCMS settings file… OK
L 12/16/2020 — 11:38:35: [cmsstats_mysql_1.17.2.amxx] CSX is loaded
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] Connection to the GameCMS database is established
L 12/16/2020 — 11:38:35: [gamecms_registration_1.5.amxx] Linking to API plugin 5.4.9… Successfully
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] SELECT `id`, `name` FROM `users__groups`
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.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 `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` = ‘1’ AND (UNIX_TIMESTAMP(`ending_date`) > UNIX_TIMESTAMP(NOW()) OR `ending_date` = ‘0000-00-00 00:00:00’)
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] Loading STEAM_0:0:40222965 ce 6
L 12/16/2020 — 11:38:35: [gamecms_api_5.4.9.amxx] «1» services was ‘Loaded’ from database. Total on server: «1» services.
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.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` FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = ‘STEAM_0:0:40222965’ OR `users`.`steam_id` = ‘76561198040711658’ OR `users`.`steam_api` = ‘76561198040711658’);
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] Pre FnFindUserService BlasteeM / STEAM_0:0:40222965 / abcdefijlmntu / 0
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:0:40222965 abcdefijlmntu(abcdefghijmnopqrstu)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] while FnFindUserService STEAM_0:0:40222965 3 / 1 / 0
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] native_cmsapi_get_user_services not found STEAM_0:0:40222965 abcdefijlmntu(0)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] native_cmsapi_set_user_flags: STEAM_0:0:40222965 | service Создатель | flags abcdefijlmntu
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] Setting group flags: «<BlasteeM>» (SteamId profile «STEAM_0:0:40222965») (Group flags «abcdefijlmntu») (Group name «Создатель»)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:0:40222965 (abcdefghijmnopqrstu)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] FnFindUserService All services STEAM_0:0:40222965 Admin+VIP For life
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] Searching… «<BlasteeM><STEAM_0:0:40222965>» (Account name «STEAM_0:0:40222965» / Admin index «6») (Service flags «abcdefghijmnopqrstu») (Service name «Admin+VIP For life») (Expired «0000-00-00 00:00:00»)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] FnFindUserService Owner Founded STEAM_0:0:40222965 (abcdefijlmntu)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] FnFindUserService All services STEAM_0:0:40222965 Создатель
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] Found service: «<BlasteeM><STEAM_0:0:40222965>» (Account name «STEAM_0:0:40222965» / Admin index «-1») (Service flags «abcdefijlmntu») (Service name «Создатель») (Expired «0000-00-00 00:00:00»)
L 12/16/2020 — 11:38:41: [gamecms_api_5.4.9.amxx] Authentication… «<BlasteeM><STEAM_0:0:40222965>» (Account name «STEAM_0:0:40222965» / Admin index «-1») (Service flags «abcdefijlmntughopqrs») (Service name «Создатель + Admin+VIP For life»)

#include <amxmodx>

#include <sqlx>


#define VERSION "1.2f"


#define TASK_INDEX_MYSQL 1337

#define TASK_INDEX_INFO 2337


#define CVAR_HOSTNAME 0

#define CVAR_USERNAME 1

#define CVAR_PASSWORD 2

#define CVAR_DATABASE 3

#define CVAR_TABLE_USERS 4

#define CVAR_FLAGS 5

#define CVAR_GIVE 6

#define CVAR_TIME 7


static g_iCvars[8];

static Handle:iSql, Handle:iConnect, szTable[64];


public plugin_init() {

    register_plugin("GameCMS Flags", VERSION, "OverGame");

    register_dictionary("gcms_flags.txt");

    
    g_iCvars[CVAR_FLAGS] = register_cvar("gcms_rf_flags", "");

    g_iCvars[CVAR_GIVE] = register_cvar("gcms_rf_info", "");

    g_iCvars[CVAR_TIME] = register_cvar("gcms_rf_time", "");



  


                       
  




    
    g_iCvars[CVAR_HOSTNAME] = register_cvar("gcms_hostname", "");                                        /* Адрес базы данных */

    g_iCvars[CVAR_USERNAME] = register_cvar("gcms_username", "");                                        /* Пользователь базы данных */

    g_iCvars[CVAR_PASSWORD] = register_cvar("gcms_password", "");                                        /* Пароль пользователя */

    g_iCvars[CVAR_DATABASE] = register_cvar("gcms_database", "");                                        /* Имя базы данных */

    g_iCvars[CVAR_TABLE_USERS] = register_cvar("gcms_table_users", "");                                    /* Таблица */

}


public plugin_cfg() {

    new szConfigs[64];

    get_localinfo("amxx_configsdir", szConfigs, charsmax(szConfigs));

    server_cmd("exec %s/gamecms_flags.cfg", szConfigs);

    
    set_task(1.0, "task_mysql_connect", TASK_INDEX_MYSQL);

}


public task_mysql_connect(task) {

    new iError, szError[128];

    
    copy(szTable, charsmax(szTable), cvar_string(g_iCvars[CVAR_TABLE_USERS]));

    
    iSql = SQL_MakeDbTuple(

        cvar_string(g_iCvars[CVAR_HOSTNAME]),

        cvar_string(g_iCvars[CVAR_USERNAME]),

        cvar_string(g_iCvars[CVAR_PASSWORD]),

        cvar_string(g_iCvars[CVAR_DATABASE])

    );

    
    if((iConnect = SQL_Connect(iSql, iError, szError, charsmax(szError))) == Empty_Handle) {

        set_fail_state(szError);

    }

    
    SQL_FreeHandle(iConnect);

}



  


                       
  





public client_putinserver(id) {

    new szSteamId[35], iClient[1], szQuery[512];

    get_user_authid(id, szSteamId, charsmax(szSteamId));

    
    iClient[0] = id;

    
    formatex(szQuery, charsmax(szQuery), "SELECT * FROM `%s` WHERE (`%s`.`steam_id` = '%s')", szTable, szTable, szSteamId);

    SQL_ThreadQuery(iSql, "SQL_Handler", szQuery, iClient, sizeof(iClient));

}


public SQL_Handler(iFailState, Handle:iQuery, szError[], iError, szData[], iDataLen) {

    switch(iFailState) {

        case TQUERY_CONNECT_FAILED: return log_amx("No connect database: %s", szError);

        case TQUERY_QUERY_FAILED: return log_amx("Query error: %s", szError);

    }

    
    new id = szData[0];

    
    if(SQL_NumResults(iQuery)) {

        new szRegDate[32], szCurrent[32], iTime_1, iTime_2;

        SQL_ReadResult(iQuery, SQL_FieldNameToNum(iQuery, "regdate"), szRegDate, charsmax(szRegDate));

        
        get_time("%Y:%m:%d %H:%M:%S", szCurrent, charsmax(szCurrent));

        
        iTime_1 = parse_time(szRegDate, "%Y:%m:%d %H:%M:%S");

        iTime_2 = parse_time(szCurrent, "%Y:%m:%d %H:%M:%S");

        
        client_print(0, print_chat, "%d %d %d", iTime_1, iTime_2, get_pcvar_num(g_iCvars[CVAR_TIME]));

        
        if(iTime_1 + get_pcvar_num(g_iCvars[CVAR_TIME]) > iTime_2) {

            if(get_pcvar_num(g_iCvars[CVAR_GIVE])) {

                set_task(5.0, "task_info", TASK_INDEX_INFO + id);

            }

            
            set_user_flags(id, read_flags(cvar_string(g_iCvars[CVAR_FLAGS])));

        }

    }

    
    return true;

}


public task_info(task) {

    new id = task - TASK_INDEX_INFO;



  


                       
  




    
    client_print_color(id, print_team_default, "%L", id, "GCMS_FLAGS_GIVE_INFO");

    remove_task(task);

}


stock cvar_string(iCvar) {

    new szResult[128];

    get_pcvar_string(iCvar, szResult, charsmax(szResult));

    
    return szResult;

}

Ошибка To run GameCMS requires PHP module IonCube Loader:

1. Если место страницы установки движка возникает ошибка To run GameCMS requires PHP module IonCube Loader, то идем в раздел PHP, выбираем версию PHP, которую выбрали для сайта в пункте 1, жмем на кнопку расширений, там находим расширение ioncube_loader и включаем его

Ошибка License is not valid

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

Ошибка No input file specified

2. Если при переходе на любую страницу, кроме главной, появляется ошибка No input file specified, то идем в папку с сайтом, там находим файл .htaccess, открываем его и заменяем:

# Роутинг:
# Вариант 1:
RewriteRule ^(.*)$ index.php/$1 [L,QSA]
# Вариант 2:
#RewriteRule ^(.*)$ /index.php?/$1 [L,QSA]

на

# Роутинг:
# Вариант 1:
#RewriteRule ^(.*)$ index.php/$1 [L,QSA]
# Вариант 2:
RewriteRule ^(.*)$ /index.php?/$1 [L,QSA]

Ошибка License file is incorrect

Необходимо в настройках php — в php.ini указать для параметра mbstring.func_overload значение 0