|
楼主 |
发表于 2009-2-2 04:55:55
|
显示全部楼层
来自 中国–江苏–南京
#if defined USING_SQL
}
new table[32]
get_cvar_string("amx_sql_table", table, 31)
new Handle:query = SQL_PrepareQuery(sql, "SELECT * FROM `%s` WHERE (`auth` = '%s')", table, auth)
if (!SQL_Execute(query))
{
SQL_QueryError(query, error, 127)
server_print("[AMXX] %L", LANG_SERVER, "SQL_CANT_LOAD_ADMINS", error)
console_print(id, "[AMXX] %L", LANG_SERVER, "SQL_CANT_LOAD_ADMINS", error)
} else if (SQL_NumResults(query)) {
console_print(id, "[%s] %s already exists!", PLUGINNAME, auth)
} else {
console_print(id, "Adding to database:^n^"%s^" ^"%s^" ^"%s^" ^"%s^"", auth, cspassword, accessflags, flags)
SQL_QueryAndIgnore(sql, "REPLACE INTO `%s` (`auth`, `cspassword`, `access`, `flags`) VALUES ('%s', '%s', '%s', '%s')", table, auth, cspassword, accessflags, flags)
}
SQL_FreeHandle(query)
SQL_FreeHandle(sql)
SQL_FreeHandle(info)
#endif
}
public plugin_cfg()
{
new configFile[64], curMap[32]
get_configsdir(configFile, 31)
get_mapname(curMap, 31)
new len = format(configFile, 63, "%s/maps/%s.cfg", configFile, curMap)
if (file_exists(configFile))
set_task(6.1, "delayed_load", 0, configFile, len + 1)
}
public delayed_load(configFile[])
{
server_cmd("exec %s", configFile)
}
loadSettings(szFilename[])
{
if (!file_exists(szFilename))
return 0
new szText[256], szFlags[32], szAccess[32]
new a, pos = 0
while (g_aNum < MAX_ADMINS && read_file(szFilename, pos++, szText, 255, a))
{
if (szText[0] == ';')
continue
if (parse(szText, g_aName[g_aNum], 31, g_acsPassword[g_aNum], 31, szAccess, 31, szFlags, 31) < 2)
continue
g_aAccess[g_aNum] = read_flags(szAccess)
g_aFlags[g_aNum] = read_flags(szFlags)
++g_aNum
}
if (g_aNum == 1)
server_print("[AMXX] %L", LANG_SERVER, "LOADED_ADMIN")
else
server_print("[AMXX] %L", LANG_SERVER, "LOADED_ADMINS", g_aNum)
return 1
}
#if defined USING_SQL
public adminSql()
{
new table[32], error[128], type[12], errno
new Handle:info = SQL_MakeStdTuple()
new Handle:sql = SQL_Connect(info, errno, error, 127)
get_cvar_string("amx_sql_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
if (equali(type, "sqlite"))
{
if (!sqlite_TableExists(sql, table))
{
SQL_QueryAndIgnore(sql, "CREATE TABLE %s ( auth TEXT NOT NULL DEFAULT '', cspassword TEXT NOT NULL DEFAULT '', access TEXT NOT NULL DEFAULT '', flags TEXT NOT NULL DEFAULT '' )", table)
}
query = SQL_PrepareQuery(sql, "SELECT auth, cspassword, access, flags FROM %s", table)
} else {
SQL_QueryAndIgnore(sql, "CREATE TABLE IF NOT EXISTS `%s` ( `auth` VARCHAR( 32 ) NOT NULL, `cspassword` VARCHAR( 32 ) NOT NULL, `access` VARCHAR( 32 ) NOT NULL, `flags` VARCHAR( 32 ) NOT NULL ) COMMENT = 'AMX Mod X Admins'", table)
query = SQL_PrepareQuery(sql,"SELECT `auth`,`cspassword`,`access`,`flags` FROM `%s`", 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 {
new szFlags[32], szAccess[32]
g_aNum = 0
/** do this incase people change the query order and forget to modify below */
new qcolAuth = SQL_FieldNameToNum(query, "auth")
new qcolPass = SQL_FieldNameToNum(query, "cspassword")
new qcolAccess = SQL_FieldNameToNum(query, "access")
new qcolFlags = SQL_FieldNameToNum(query, "flags")
while ((g_aNum < MAX_ADMINS) && (SQL_MoreResults(query)))
{
SQL_ReadResult(query, qcolAuth, g_aName[g_aNum], 31)
SQL_ReadResult(query, qcolPass, g_acsPassword[g_aNum], 31)
SQL_ReadResult(query, qcolAccess, szAccess, 31)
SQL_ReadResult(query, qcolFlags, szFlags, 31)
g_aAccess[g_aNum] = read_flags(szAccess)
g_aFlags[g_aNum] = read_flags(szFlags)
++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
}
#endif
public cmdReload(id, level, cid)
{
if (!cmd_access(id, level, cid, 1))
return PLUGIN_HANDLED
//strip original flags (patch submitted by mrhunt)
remove_user_flags(0, read_flags("t"))
#if !defined USING_SQL
new filename[128]
get_configsdir(filename, 127)
format(filename, 63, "%s/users.ini", filename)
g_aNum = 0
loadSettings(filename) // Re-Load admins accounts
if (id != 0)
{
if (g_aNum == 1)
console_print(id, "[AMXX] %L", LANG_SERVER, "LOADED_ADMIN")
else
console_print(id, "[AMXX] %L", LANG_SERVER, "LOADED_ADMINS", g_aNum)
}
#else
g_aNum = 0
adminSql()
if (id != 0)
{
if (g_aNum == 1)
console_print(id, "[AMXX] %L", LANG_SERVER, "SQL_LOADED_ADMIN")
else
console_print(id, "[AMXX] %L", LANG_SERVER, "SQL_LOADED_ADMINS", g_aNum)
}
#endif
new players[32], num, pv
new name[32]
get_players(players, num)
for (new i=0; i<num; i++)
{
pv = players[i]
get_user_name(pv, name, 31)
accessUser(pv, name)
}
return PLUGIN_HANDLED
}
getAccess(id, name[], authid[], ip[], cspassword[])
{
new index = -1
new result = 0
for (new i = 0; i < g_aNum; ++i)
{
if (g_aFlags[i] & FLAG_AUTHID)
{
if (equal(authid, g_aName[i]))
{
index = i
break
}
}
else if (g_aFlags[i] & FLAG_IP)
{
new c = strlen(g_aName[i])
if (g_aName[i][c - 1] == '.') /* check if this is not a xxx.xxx. format */
{
if (equal(g_aName[i], ip, c))
{
index = i
break
}
} /* in other case an IP must just match */
else if (equal(ip, g_aName[i]))
{
index = i
break
}
} else {
if (g_aFlags[i] & FLAG_TAG)
{
if (contain(name, g_aName[i]) != -1)
{
index = i
break
}
}
else if (equal(name, g_aName[i]))
{
index = i
break
}
}
}
if (index != -1)
{
if (g_aFlags[index] & FLAG_NOPASS)
{
result |= 8
new sflags[32]
get_flags(g_aAccess[index], sflags, 31)
set_user_flags(id, g_aAccess[index])
log_amx("Login: ^"%s<%d><%s><>^" became an admin (account ^"%s^") (access ^"%s^") (address ^"%s^")", name, get_user_userid(id), authid, g_aName[index], sflags, ip)
}
else if (equal(cspassword, g_acsPassword[index]))
{
result |= 12
set_user_flags(id, g_aAccess[index])
new sflags[32]
get_flags(g_aAccess[index], sflags, 31)
log_amx("Login: ^"%s<%d><%s><>^" became an admin (account ^"%s^") (access ^"%s^") (address ^"%s^")", name, get_user_userid(id), authid, g_aName[index], sflags, ip)
} else {
result |= 1
if (g_aFlags[index] & FLAG_KICK)
{
result |= 2
log_amx("Login: ^"%s<%d><%s><>^" kicked due to invalid csPassword (account ^"%s^") (address ^"%s^")", name, get_user_userid(id), authid, g_aName[index], ip)
}
}
}
else if (get_cvar_float("amx_mode") == 2.0)
{
result |= 2
} else {
new defaccess[32]
get_cvar_string("amx_default_access", defaccess, 31)
if (!strlen(defaccess))
copy(defaccess, 32, "t")
new idefaccess = read_flags(defaccess)
if (idefaccess)
{
result |= 8
set_user_flags(id, idefaccess)
}
}
return result
}
accessUser(id, name[] = "")
{
remove_user_flags(id)
new userip[32], userauthid[32], csPassword[32], passfield[32], username[32]
get_user_ip(id, userip, 31, 1)
get_user_authid(id, userauthid, 31)
if (name[0])
copy(username, 31, name)
else
get_user_name(id, username, 31)
get_cvar_string("amx_csPassword_field", passfield, 31)
get_user_info(id, passfield, csPassword, 31)
new result = getAccess(id, username, userauthid, userip, csPassword)
if (result & 1)
client_cmd(id, "echo ^"* %L^"", id, "INV_PAS")
if (result & 2)
{
client_cmd(id, "echo ^"* %L^".", id, "NO_ENTRY")
client_cmd(id, "%s", g_cmdLoopback)
return PLUGIN_HANDLED
}
if (result & 4)
client_cmd(id, "echo ^"* %L^"", id, "PAS_ACC")
if (result & 8)
client_cmd(id, "echo ^"* %L^"", id, "PRIV_SET")
return PLUGIN_CONTINUE
}
public client_infochanged(id)
{
if (!is_user_connected(id) || !get_cvar_num("amx_mode"))
return PLUGIN_CONTINUE
new newname[32], oldname[32]
get_user_name(id, oldname, 31)
get_user_info(id, "name", newname, 31)
if (!equal(newname, oldname))
accessUser(id, newname)
return PLUGIN_CONTINUE
}
public ackSignal(id)
{
new userid = get_user_userid(id)
server_cmd("kick #%d ^"%L^"", userid, id, "NO_ENTRY")
server_cmd("kick #%d", userid)
return PLUGIN_HANDLED
}
public client_authorized(id)
return get_cvar_num("amx_mode") ? accessUser(id) : PLUGIN_CONTINUE
public client_putinserver(id)
{
if (!is_dedicated_server() && id == 1)
return get_cvar_num("amx_mode") ? accessUser(id) : PLUGIN_CONTINUE
return PLUGIN_CONTINUE
} |
|