http://www.girlshare.ro/2611505.6
#include <amxmodx>
#include <dbi>
#include <sqlx>
#define CHECK_TIME 30.0
public plugin_init() {
register_plugin("Evidenta Redirecte","2.0","Friends")
register_cvar("red_server","ip server")
register_cvar("red_serverport","27015")
register_cvar("red_name","ip server")
register_cvar("proprietar","")
new rand_str[6],codserver[10]
new num = random(200000)
codserver=""
num_to_str(num,rand_str,6)
strcat(codserver,rand_str,10)
register_cvar("codserver",codserver)
set_task(15.0,"open_server")
set_task(CHECK_TIME, "INJECT_SES_END", _, _, _,"b");
return PLUGIN_CONTINUE
}
public INJECT_SES_END()
{
new proprietar[64]
new codserver[10],codxx[40]
get_cvar_string("proprietar",proprietar,63)
get_cvar_string("proprietar",codxx,63)
get_cvar_string("codserver",codserver,6)
strcat(codxx,codserver,40)
//server_print("%s",codxx)
new errnum, error[255]
new Handle:tempinfo = SQL_MakeDbTuple("domeniu.ro:3306", "baza_de_date", "parola_user_baza_de_date", "user_baza_de_date", 2)
new Handle:db = SQL_Connect(tempinfo, errnum, error, 254)
new ip[64];
get_user_ip(0,ip,32);
new Handle:query = SQL_PrepareQuery(db, "UPDATE redirect SET DATAEND=NOW() WHERE codserver='%s' AND owner='%s' AND tip_op='o'",codxx,proprietar)
if (!SQL_Execute(query))
{
errnum = SQL_QueryError(query, error, 254)
server_print("Query failure: [%d] %s", errnum, error)
SQL_FreeHandle(query)
SQL_FreeHandle(db)
return
}
SQL_FreeHandle(query)
SQL_FreeHandle(db)
SQL_FreeHandle(tempinfo)
}
public client_connect(id){
new rd_maxplayers = get_maxplayers() - 2
new rd_name[64]
new rd_server[64]
new name[32]
get_user_name(id, name, 31)
new proprietar[64],codserver[10],codxx[40]
get_cvar_string("proprietar",proprietar,63)
get_cvar_string("proprietar",codxx,63)
get_cvar_string("codserver",codserver,6)
strcat(codxx,codserver,40)
new errnum, error[255]
//new codx[5]
//get_cvar_string("codserver",codx,40)
get_cvar_string("red_server",rd_server,63)
get_cvar_string("red_name",rd_name,63)
if ( get_playersnum() >= rd_maxplayers)
{
new Handle:tempinfo = SQL_MakeDbTuple("domeniu.ro", "baza_de_date", "parola_user_baza_de_date", "user_baza_de_date", 2)
new Handle:db = SQL_Connect(tempinfo, errnum, error, 254)
new ip[64];
get_user_ip(id,ip,32);
new Handle:query = SQL_PrepareQuery(db, "INSERT INTO redirect (codserver,owner,ip,data,tip_op) VALUES('%s','%s','%s',now(),'r')",codxx,proprietar,ip)
if (!SQL_Execute(query))
{
errnum = SQL_QueryError(query, error, 254)
server_print("Query failure: [%d] %s", errnum, error)
SQL_FreeHandle(query)
SQL_FreeHandle(db)
return PLUGIN_CONTINUE
}
new Handle:query1 = SQL_PrepareQuery(db, "update redirect set nrconectari=nrconectari+1 where codserver='%s' and tip_op='o'",codxx)
if (!SQL_Execute(query1))
{
errnum = SQL_QueryError(query1, error, 254)
server_print("Query failure: [%d] %s", errnum, error)
SQL_FreeHandle(query1)
SQL_FreeHandle(db)
return PLUGIN_CONTINUE
}
SQL_FreeHandle(query)
SQL_FreeHandle(query1)
SQL_FreeHandle(db)
client_cmd(id,"echo ^"Esti Redirectionat Pe server:27015^";Connect server:27015")
}
return PLUGIN_CONTINUE
}
public open_server(){
server_print("----------------------------")
server_print("Redirectele au pornit cu succes.")
server_print("----------------------------")
server_print("Salut server")
server_print("Cumpara evidenta redirecte : [email protected]")
new proprietar[64]
new codserver[10],codxx[40]
get_cvar_string("proprietar",proprietar,63)
get_cvar_string("proprietar",codxx,63)
get_cvar_string("codserver",codserver,6)
strcat(codxx,codserver,40)
//server_print("%s",codxx)
new errnum, error[255]
new Handle:tempinfo = SQL_MakeDbTuple("domeniu.ro", "baza_de_date", "parola_user_baza_de_date", "user_baza_de_date", 2)
new Handle:db = SQL_Connect(tempinfo, errnum, error, 254)
new ip[64];
get_user_ip(0,ip,32);
new Handle:query = SQL_PrepareQuery(db, "INSERT INTO redirect (codserver,owner,ip,data,tip_op) VALUES('%s','%s','%s',now(),'o')",codxx,proprietar,ip)
//new Handle:query = SQL_PrepareQuery(db, "INSERT INTO redirect (owner,ip,data,tip_op,codserver) VALUES('%s','%s',now(),'op','%s')",proprietar,ip,codx)
if (!SQL_Execute(query))
{
errnum = SQL_QueryError(query, error, 254)
server_print("Query failure: [%d] %s", errnum, error)
SQL_FreeHandle(query)
SQL_FreeHandle(db)
return
}
SQL_FreeHandle(query)
SQL_FreeHandle(db)
SQL_FreeHandle(tempinfo)
}