Code:
#include <amxmodx>
#include <amxmisc>
#include <dbi>
#define PLUGIN "Nick Protection"
#define VERSION "1.0"
#define AUTHOR "[DumB]SteamSucks"
new clientname[32]
new usersteam[32]
new user_id[32]
new user_steamid[32]
new Sql:dbc
new Result:result
new query[256]
new error[33]
new num
new i
public plugin_init() {
register_plugin(PLUGIN, VERSION, AUTHOR)
dbc = dbi_connect("localhost", "root", "", "dk", error, 32)
if (dbc == SQL_FAILED)
{
server_print("[AMXX] Could Not Connect To SQL Database. Check your login details.")
return PLUGIN_HANDLED
}
result = dbi_query(dbc,"CREATE TABLE IF NOT EXISTS `savednames` (`id` int,`steamid` varchar(30), `name` varchar(30), PRIMARY KEY(`id`))")
server_print("[AMXX] Connected to SQL Database, logging all users.")
dbi_free_result(result)
return PLUGIN_CONTINUE
}
public client_authorized(id){
get_user_name(id,clientname,31)
get_user_authid(id,usersteam,31)
result = dbi_query(dbc,"select * from `savednames` where name = '%s'", clientname)
if (result < RESULT_NONE) {
new err[255]
new errNum = dbi_error(dbc, err, 254)
server_print("error2: %s|%d", err, errNum)
}
num = dbi_num_rows(result)
i = 1
while ( i < num )
{
dbi_nextrow(result)
dbi_result(result,"steamid", user_steamid, 31)
dbi_free_result(result)
dbi_result(result,"name", user_id, 31)
dbi_free_result(result)
i++;
}
if ( contain(user_id,clientname) && contain(user_steamid,usersteam) )
{
server_print("[Logger-ClientAuth-1] Logged into database: %s (%s).", user_id, user_steamid)
return PLUGIN_HANDLED
}
else if(result == RESULT_NONE)
{
server_print("[Logger-ClientAuth-1] ERROR. User(%s)(%s) does not exist in database.", user_id, user_steamid)
return PLUGIN_HANDLED
}
else
{
client_print(id, print_chat, "You are not allowd to use this name please chose another !!!")
server_cmd("kick %d This name cannot be used",id)
client_cmd(id , "disconnect")
}
return PLUGIN_HANDLED
}
L 02/27/2006 - 14:09:22: [AMXX] Displaying debug trace (plugin "NickProtect.amxx")
L 02/27/2006 - 14:09:22: [AMXX] Run time error 10: native error (native "dbi_query")