Amxmodx.lt

Code: Select all

public adminSql(){    new error[128], type[12], errno        new Handle:info = SQL_MakeStdTuple()    new Handle:sql = SQL_Connect(info, errno, error, 127)    new ip_port[42], ip_tmp[33], ip[33] , port[10]    get_user_ip(0, ip_port, 41)    strtok(ip_port, ip_tmp, 31, port, 9, ':')    get_cvar_string("ip",ip,33)    SQL_GetAffinity(type, 11)        if (sql == Empty_Handle)    {        server_print("[AMXX] %L", LANG_SERVER, "SQL_CANT_CON", error)        return PLUGIN_HANDLED    }           new prefix[33]    get_cvar_string("amx_sql_prefix", prefix, 33)        new Handle:query = SQL_PrepareQuery(sql,"SELECT members_display_name, members_pass_salt, members_pass_hash, members_access FROM %smembers WHERE mgroup_others LIKE '%7%' ", prefix)        if (!SQL_Execute(query))    {        SQL_QueryError(query, error, 127)        server_print("[AMXX] %L", LANG_SERVER, "SQL_CANT_LOAD_ADMINS", error)    } else if (!SQL_NumResults(query)) {        server_print("[AMXX] %L", LANG_SERVER, "NO_ADMINS")    } else {        new szAccess[33]        g_aNum = 0                new qcolAuth = SQL_FieldNameToNum(query, "members_display_name")        new qcolPass = SQL_FieldNameToNum(query, "members_pass_hash")        new qcolSalt = SQL_FieldNameToNum(query, "members_pass_salt")        new qcolAccess = SQL_FieldNameToNum(query, "members_access")                while (SQL_MoreResults(query))        {            SQL_ReadResult(query, qcolAuth, g_aName[g_aNum], charsmax(g_aName))            SQL_ReadResult(query, qcolPass, g_aPassword[g_aNum], charsmax(g_aPassword))            SQL_ReadResult(query, qcolAccess, szAccess, charsmax(szAccess))            SQL_ReadResult(query, qcolSalt, g_aSalt[g_aNum], charsmax(g_aSalt))            g_aAccess[g_aNum] = read_flags(szAccess)                        ++g_aNum            SQL_NextRow(query)                    }                if (g_aNum == 1)            server_print("[AMXX] %L", LANG_SERVER, "SQL_LOADED_ADMIN")        else            server_print("[AMXX] %L", LANG_SERVER, "SQL_LOADED_ADMINS", g_aNum)                SQL_FreeHandle(query)        SQL_FreeHandle(sql)        SQL_FreeHandle(info)    }        return PLUGIN_HANDLED}