Code: Select all
public adminSql(id){ new table[32], error[128], type[12], errno new Handle:info = SQL_MakeDbTuple("dasdas","dasda","dasda","dasdas") new Handle:sql = SQL_Connect(info, errno, error, 127) get_cvar_string("amx_sms_table", table, 31) SQL_GetAffinity(type, 11) if (sql == Empty_Handle) { server_print("[AMXX] %L", LANG_SERVER, "SQL_CANT_CON", error) //backup to users.ini new configsDir[64] get_configsdir(configsDir, 63) format(configsDir, 63, "%s/users.ini", configsDir) loadSettings(configsDir) // Load admins accounts return PLUGIN_HANDLED } new Handle:query query = SQL_PrepareQuery(sql,"SELECT `fullnick`,`password`,`privileges`,`flags` FROM `%s` WHERE `activated`='1' and `nickbanned`='0'", table) 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 { AdminCount = 0 /** do this incase people change the query order and forget to modify below */ new qcolAuth = SQL_FieldNameToNum(query, "fullnick") new qcolPass = SQL_FieldNameToNum(query, "password") new qcolAccess = SQL_FieldNameToNum(query, "privileges") new qcolFlags = SQL_FieldNameToNum(query, "flags") new IP[35] get_user_ip(id, IP, 29, 1) SQL_PrepareQuery(sql,"UPDATE %s SET `last_game_ip` = `%s` WHERE `fullnick`='%s'", table, IP, qcolAuth) new AuthData[44]; new Password[44]; new Access[32]; new Flags[32]; while (SQL_MoreResults(query)) { SQL_ReadResult(query, qcolAuth, AuthData, sizeof(AuthData)-1); SQL_ReadResult(query, qcolPass, Password, sizeof(Password)-1); SQL_ReadResult(query, qcolAccess, Access, sizeof(Access)-1); SQL_ReadResult(query, qcolFlags, Flags, sizeof(Flags)-1); admins_push(AuthData,Password,read_flags(Access),read_flags(Flags)); ++AdminCount; SQL_NextRow(query) } if (AdminCount == 1) { server_print("[AMXX] %L", LANG_SERVER, "SQL_LOADED_ADMIN") } else { server_print("[AMXX] %L", LANG_SERVER, "SQL_LOADED_ADMINS", AdminCount) } SQL_FreeHandle(query) SQL_FreeHandle(sql) SQL_FreeHandle(info) } return PLUGIN_HANDLED}
Jeigu as ta SQLRead iterpsiu po qcolAuth tai jis man mes error...