/* Plugin generated by AMXX-Studio */
#include <amxmodx>
#include <amxmisc>
#include <fakemeta>
#include <colorchat>
#include <sqlx>
#define PLUGIN "New Plug-In"
#define VERSION "1.0"
#define AUTHOR "author"
new AkOles[33], M4Oles[33], WpOles[33]
new const SQL_INFO[][] = {
"mysqlweb.clans.hu", // HOST
"asd873321", // USERNAME
"DyqYgYSAhuVA5ed", // PASSWORD
"asd873321" // DATABASE
}
new Handle:g_SqlTuple;
new name[33][32]
public plugin_init() {
register_plugin(PLUGIN, VERSION, AUTHOR)
register_clcmd("say /oles", "Uzenet")
register_event("DeathMsg", "Halal", "a")
register_event("CurWeapon", "Fegyvervaltas", "be", "1=1")
}
public Uzenet(id)
{
ColorChat(id, GREEN, "[Proba] ^1AK47 Ölések:^4 %d / ^1WP Ölések:^4 %d / ^1M4A1 Ölések:^4 %d", AkOles[id], WpOles[id], M4Oles[id])
}
public Halal()
{
new Gyilkos = read_data(1)
new Aldozat = read_data(2)
if(Gyilkos != Aldozat) {
return PLUGIN_HANDLED
}
if(get_user_weapon(Gyilkos) == CSW_AK47)
{
AkOles[Gyilkos]++
}
else if(get_user_weapon(Gyilkos) == CSW_AWP)
{
WpOles[Gyilkos]++
}
else if(get_user_weapon(Gyilkos) == CSW_M4A1)
{
M4Oles[Gyilkos]++
}
return PLUGIN_HANDLED;
}
public plugin_precache()
{
precache_model("models/proba/v_ak47.mdl")
precache_model("models/proba/p_ak47.mdl")
precache_model("models/proba/v_awp.mdl")
precache_model("models/proba/p_awp.mdl")
precache_model("models/proba/v_m4a1.mdl")
precache_model("models/proba/p_m4a1.mdl")
}
public Fegyvervaltas(id) {
new Gun = get_user_weapon(id)
if(AkOles[id] >= 250 && Gun == CSW_AK47)
{
set_pev(id, pev_viewmodel2, "models/proba/v_ak47.mdl")
set_pev(id, pev_weaponmodel2, "models/proba/p_ak47.mdl")
}
if(WpOles[id] >= 250 && Gun == CSW_AWP)
{
set_pev(id, pev_viewmodel2, "models/proba/v_awp.mdl")
set_pev(id, pev_weaponmodel2, "models/proba/p_awp.mdl")
}
if(M4Oles[id] >= 250 && Gun == CSW_M4A1)
{
set_pev(id, pev_viewmodel2, "models/proba/v_m4a1.mdl")
set_pev(id, pev_weaponmodel2, "models/proba/p_m4a1.mdl")
}
}
public plugin_cfg() {
new Query[1024];
g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3])
formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `tabla_neve` (`username` varchar(32) NOT NULL,`valami_ertek` int(11) NOT NULL, `valami_ertek2` int(11) NOT NULL, `valami_ertek3` int(11) NOT NULL,`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)")
SQL_ThreadQuery(g_SqlTuple,"createTableThread", Query)
}
public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED)
set_fail_state("Nem tudtam csatlakozni az adatbazishoz.");
else if(FailState == TQUERY_QUERY_FAILED)
set_fail_state("Query Error");
if(Errcode)
log_amx("Hibat dobtam: %s",Error);
}
public load(id) {
new Query[1024], Data[1]
Data[0] = id
formatex(Query, charsmax(Query), "SELECT * FROM `tabla_neve` WHERE username = ^"%s^";", name[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1)
}
public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
log_amx("%s", Error)
return
}
else {
new id = Data[0];
if(SQL_NumRows(Query) > 0) {
AkOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "valami_ertek"))
WpOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "valami_ertek2"))
M4Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "valami_ertek3"))
}
else {
save(id)
}
}
}
public save(id) {
new text[512];
formatex(text, charsmax(text), "INSERT INTO `tabla_neve` (`username`, `valami_ertek`, `valami_ertek2`, `valami_ertek3`) VALUES (^"%s^", ^"0^", ^"0^", ^"0^");", name[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text)
}
public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
log_amx("%s", Error)
return
}
}
public update(id) {
new text[512];
formatex(text, charsmax(text), "UPDATE `tabla_neve` SET valami_ertek = ^"%i^" SET valami_ertek2 = ^"%i^" SET_valami_ertek3 ^"%i^" WHERE username = ^"%s^";", AkOles[id], WpOles[id], M4Oles[id], name[id])
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text)
}
public client_disconnect(id) {
if(!is_user_bot(id)) {
update(id)
}
AkOles[id] = 0
WpOles[id] = 0
M4Oles[id] =0
copy(name[id], charsmax(name[]), "")
}
public plugin_end() {
SQL_FreeHandle(g_SqlTuple)
}