1 odpowiedź w tym temacie

[MisterMalpa]

Witajcie, mam problem z pluginem głowię sie już trochę i sam nie wiem w czym problem.

Mianowicie chodzi o to że ten plugin (niżej code) robi screen'y ale potem nie banuje tego gracza amxbans. Plugin jest połączony z bazą danych na stronie pokazuje że zrobił ss'y no ale w amxbans już cisza nic się nie dzieje i w trakcie robienia screenów w grze po prostu po zrobieniu ss gracza wywala ale nie pisze nic od amxbans i gracz może na nowo wejść na serwer.

 

Link do pluginu ScreenShoot https://amxx.pl/topi...hoty-zapis-sql/

Link do pluginu amxbans  https://amxx.pl/topi...alacja-amxbans/

#include <amxmodx>
#include <amxmisc>
 
#define SQL_ZAPIS
 
#define TASK_SCREEN 56323
 
enum _:cvary { HOST, USER, PASS, DBNAME, MAXSS, INTERVAL, SITE, BAN, BANTIME, BANREASON }
 
new const tag[] = "[USS]";
 
new gCvars[cvary];
new gScreens[33];
 
new g_SyncHud;
 
#if defined SQL_ZAPIS
#include <sqlx>
 
new gMapa[33];
new gNazwa[101];
 
new Handle: g_SqlTuple;
 
public SqlInit() {
new t[4][33];
 
get_pcvar_string(gCvars[HOST],  t[HOST], 32);
get_pcvar_string(gCvars[USER],  t[USER], 32);
get_pcvar_string(gCvars[PASS],  t[PASS], 32);
get_pcvar_string(gCvars[DBNAME],  t[DBNAME], 32);
 
g_SqlTuple = SQL_MakeDbTuple(t[HOST], t[USER], t[PASS], t[DBNAME]);
 
if(g_SqlTuple == Empty_Handle)
set_fail_state("Nie mozna utworzyc uchwytu do polaczenia");
 
new iErr, szError[32];
new Handle:link = SQL_Connect(g_SqlTuple, iErr, szError, 31);
if(link == Empty_Handle) {
log_amx("Error (%d): %s", iErr, szError);
set_fail_state("Brak polaczenia z baza danych");
}
 
new Handle:query;
query = SQL_PrepareQuery(link,
"CREATE TABLE IF NOT EXISTS `screeny` ( \
`id` int(11) NOT NULL auto_increment, \
`uname` varchar(32) NOT NULL, \
`aname` varchar(32) NOT NULL, \
`uip` varchar(20) NOT NULL, \
`usid` varchar(32) NOT NULL, \
`map` varchar(32) NOT NULL, \
`time` int(15) NOT NULL, \
`type` int(1) NOT NULL, \
`amount` int(3) NOT NULL, \
`server` varchar(100) NOT NULL, \
PRIMARY KEY  (`id`) \
)");
 
SQL_Execute(query);
SQL_FreeHandle(query);
}
 
public Query(failstate, Handle:query, error[]) {
if(failstate != TQUERY_SUCCESS) {
log_amx("SQL Insert error: %s", error);
return;
}
}
 
#endif
 
public plugin_init() {
register_plugin("Ultimate ScreenShot", "1.0", "byCZEK");
 
gCvars[HOST]  = register_cvar("ss_hostname", "");
gCvars[USER]  = register_cvar("ss_username", "");
gCvars[PASS]  = register_cvar("ss_password", "");
gCvars[DBNAME]  = register_cvar("ss_database", "");
gCvars[MAXSS] = register_cvar("ss_mscreens", "10");
gCvars[INTERVAL]  = register_cvar("ss_interval", "1.0");
gCvars[SITE] = register_cvar("ss_sitemap", "http://amxx.pl");
gCvars[BAN] = register_cvar("ss_banplayer", "1");
gCvars[BANTIME] = register_cvar("ss_bantime", "0");
gCvars[BANREASON] = register_cvar("ss_banreason", "Wrzuc screeny na forum");
 
register_concmd("amx_ss",  "ZrobScreena", ADMIN_BAN, "<authid, nick or #userid> [screens] [type 0/1]");
register_concmd("amx_screen",  "ZrobScreena", ADMIN_BAN, "<authid, nick or #userid> [screens] [type 0/1]");
 
g_SyncHud = CreateHudSyncObj();
 
#if defined SQL_ZAPIS 
get_mapname(gMapa, 32);
get_user_name(0, gNazwa, 100);
SqlInit();
#endif
}
 
public client_putinserver(id) {
gScreens[id] = 0;
}
 
public ZrobScreena(id, level, cid) {
if(!cmd_access(id, level, cid, 2)) {
return PLUGIN_HANDLED;
}
 
new t[3][33], pid;
 
read_argv(1, t[0], 32);
read_argv(2, t[1], 3);
read_argv(3, t[2], 3);
 
new Screens  = str_to_num(t[1]);
new Type = str_to_num(t[2]);
new MScreens = get_pcvar_num(gCvars[MAXSS]);
 
if(!Screens) Screens = 5;
 
if(Screens > MScreens) {
console_print(id, "%s Nie mozesz zrobic tylu screenow.", tag);
return PLUGIN_HANDLED;
}
 
pid = cmd_target(id, t[0]);
 
if(!pid) 
return PLUGIN_HANDLED;
 
new dane[4];
new Float: Interval = get_pcvar_float(gCvars[INTERVAL]);
 
dane[0] = id;
dane[1] = pid;
dane[2] = Type;
dane[3] = Screens;
 
gScreens[pid] = Screens;
 
set_task(Interval, "ZrobScreena_", TASK_SCREEN + pid, dane, 4, "a", Screens);
 
#if defined SQL_ZAPIS
new z[4][33], buffer[512];
get_user_name(id,  z[0], 32);
get_user_name(pid,  z[1], 32);
get_user_ip(pid,  z[2], 32, 1);
get_user_authid(pid,  z[3], 32);
 
replace_all(z[0], 32, "'", "\'");
replace_all(z[0], 32, "`", "\`");
 
replace_all(z[1], 32, "'", "\'");
replace_all(z[1], 32, "`", "\`");
 
formatex(buffer, charsmax(buffer), "INSERT INTO `screeny` VALUES (NULL, '%s', '%s', '%s', '%s', '%s', %d, %d, %d, '%s');", z[1], z[0], z[2], z[3], gMapa, get_systime(), Type, Screens, gNazwa); 
SQL_ThreadQuery(g_SqlTuple, "Query", buffer); 
#endif
 
return PLUGIN_HANDLED;
}
 
public ZrobScreena_(dane[4]) {
new id  = dane[0];
new pid  = dane[1];
new tid  = dane[2];
 
new t[6][33];
 
get_user_name(id, t[0], 32);
get_user_name(pid, t[1], 32);
get_user_ip(pid, t[2], 20, 1);
 
get_time("%m/%d/%Y - %H:%M:%S", t[3], 31);
 
set_hudmessage(0, 255, 0, -1.0, 0.3, 0, 0.25, 1.0, 0.0, 0.0, 4);
ShowSyncHudMsg(pid, g_SyncHud, "** %s **^n%s", t[1], t[3]);
 
client_print(0, print_chat, "%s Admin: %s zrobil screen graczowi: %s (%s) %s %s", tag, t[0], t[1], t[2], t[3], tid ? "TGA" : "BMP"); 
 
client_cmd(pid, tid ? "screenshot" : "snapshot");
 
if(get_pcvar_num(gCvars[BAN]) && !--gScreens[pid]) {
new czas = get_pcvar_num(gCvars[BANTIME]);
 
get_pcvar_string(gCvars[BANREASON],  t[4], 32);
get_pcvar_string(gCvars[SITE],  t[5], 32);
 
console_print(pid, "%s ==========================================", tag);
console_print(pid, "%s Admin %s zrobil Ci screeny", tag, t[0]);
console_print(pid, "%s Ilosc: %d", tag, dane[3]);
console_print(pid, "%s Typ: %s", tag, tid ? "TGA" : "BMP");
console_print(pid, "%s Umiesc screeny na: %s", tag, t[5]);
console_print(pid, "%s ==========================================", tag);
client_cmd(id, "amx_ban %d #%d ^"%s^"", czas, get_user_userid(pid), t[4]);
}
}

Użytkownik MisterMalpa edytował ten post 24.01.2018 13:38

[MisterMalpa]

Refresh@