#include <amxmodx>
#include <hamsandwich>
#include <engine>
#include <fakemeta>
#include <cstrike>
#include <sqlx>
//////////////////////////////////////////////////////
#define Tablename "newrangmod" //SQL Tábla neve!//
//////////////////////////////////////////////////////
#define TULAJ ADMIN_IMMUNITY
//#define FOADMIN_
#define ADMIN ADMIN_BAN
#define VIP ADMIN_LEVEL_H
//////////////////////////////////////////////////////
#define KILL_POINT 1 // Sima Ölés
#define HEADSHOT_POINT 2 // Fejlővés
//////////////////////////////////////////////////////
enum _:GunDatas {
M4A1,
AK47,
AWP,
SCOUT,
FAMAS,
GALIL,
AUG,
M3,
XM1014,
KNIFE,
DEAGLE,
USP,
GLOCK
}
new g_SelectedGun[33][GunDatas], g_uPoints[33][GunDatas];
new betoltve[33];
new sSteamID[33];
new Rang[33], Oles[33];
new hudkibe[33];
new gSyncHud;
new Masodpercek[33];
new const gMenuPrefix[] = "\w[~|ChamPs|~]\y";
new const gChatPrefix[] = "~|ChamPs|~";
enum _:DATA {
GunName[512],
ModelName[512],
Points[8]
}
enum _:Rangs { Szint[32], Xp[8] };
new const Rangok[][Rangs] ={
{ "Újonc", 100 },
{ "Honvéd", 200 },
{ "Örvezető", 300 },
{ "Szakaszvezető", 400 },
{ "Őrmester", 500 },
{ "Hadnagy", 600 },
{ "Főhadnagy", 700 },
{ "Százados", 800 },
{ "Örnagy", 900 },
{ "Alezredes", 1000 },
{ "Ezredes", 1100 },
{ "Dandártábornok", 1200 },
{ "Vezérnagy", 1300 },
{ "Altábornok", 1400 },
{ "Vezérezredes", 1500 }
};
new const WeaponM4A1[][DATA] = {
{"M4A1 | Default", "models/v_m4a1.mdl", 0, },
{"M4A1 | Galaxyy", "models/champs_skins/m4a1/v_m4a1_Galaxyy.mdl", 0, }
};
new const WeaponAK47[][DATA] = {
{"AK47 | Default", "models/v_ak47.mdl", 0, }
};
new const WeaponAWP[][DATA] = {
{"AWP | Default", "models/v_awp.mdl", 0, }
};
new const WeaponSCOUT[][DATA] = {
{"SCOUT | Default", "models/v_scout.mdl", 0, }
};
new const WeaponFAMAS[][DATA] = {
{"FAMAS | Default", "models/v_famas.mdl", 0, }
};
new const WeaponGALIL[][DATA] = {
{"GALIL | Default", "models/v_galil.mdl", 0, }
};
new const WeaponAUG[][DATA] = {
{"AUG | Default", "models/v_aug.mdl", 0, }
};
new const WeaponM3[][DATA] = {
{"M3 | Default", "models/v_m3.mdl", 0, }
};
new const WeaponXM1014[][DATA] = {
{"XM1014 | Default", "models/v_xm1014.mdl", 0, }
};
new const WeaponKNIFE[][DATA] = {
{"KNIFE | Default", "models/v_knife.mdl", 0, }
};
new const WeaponDEAGLE[][DATA] = {
{"DEAGLE | Default", "models/v_deagle.mdl", 0, }
};
new const WeaponUSP[][DATA] = {
{"USP | Default", "models/v_usp.mdl", 0, }
};
new const WeaponGLOCK[][DATA] = {
{"GLOCK18 | Default", "models/v_glock18.mdl", 0, }
};
public plugin_init() {
register_plugin("Hlmodra", "valamiverziosiskell?", "szeretjükatejetazbiztos!");
register_clcmd("say /add", "Addolas");
register_clcmd("say /rang", "showrang"); // Rang rendszer //
register_clcmd("say /hud", "hudkibekapcs"); // HUD Rednszer //
register_impulse(201, "main_menu"); // T betü
register_clcmd("say /menu", "main_menu"); // ha nem jelenik meg
register_clcmd("say /menu", "main_menu"); // ha nem jelenik meg
register_event("DeathMsg","Halal","a"); // Kill Ölések //
register_event("DeathMsg","kills","a") // Rang Ölések //
RegisterHam(Ham_Item_Deploy, "weapon_m4a1", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_ak47", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_awp", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_scout", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_famas", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_galil", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_aug", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_m3", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_xm1014", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_knife", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_deagle", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_usp", "WeaponChange_p", 1);
RegisterHam(Ham_Item_Deploy, "weapon_glock18", "WeaponChange_p", 1);
////////////////////////////////////////
//register_clcmd("say", "sayhook"); //Maradjon alul!
////////////////////////////////////////
gSyncHud = CreateHudSyncObj();
set_task(1.0, "hudrendszer",_,_,_,"b");
}
public hudrendszer(id){
if(is_user_alive(id) && hudkibe[id])
{
new iMasodperc, iPerc, iOra, Nev[32];
get_user_name(id, Nev, 31);
iMasodperc = Masodpercek[id] + get_user_time(id);
iPerc = iMasodperc / 60;
iOra = iPerc / 60;
iMasodperc = iMasodperc - iPerc * 60;
iPerc = iPerc - iOra * 60;
set_hudmessage(random(255), random(255), random(255), 0.01, 0.15, 0, 6.0, 1.1, 0.0, 0.0, -1);
ShowSyncHudMsg(id, gSyncHud, "Üdv! %s^nÖlésed: [%d]^nRangod: [%s]^nJátszott idő: [%d] Óra [%d] Perc [%d] Másodperc",Nev, Oles[id],Rangok[Rang[id]][Szint],iOra, iPerc, iMasodperc);
}
else
{
return
}
}
public hudkibekapcs(id)
{
if(hudkibe[id])
{
client_print_color(id, print_team_default, "^4[%s] ^1Kikapcsoltad a hudot.", gChatPrefix);
hudkibe[id] = false;
}
else
{
client_print_color(id, print_team_default, "^4[%s] ^1Bekapcsoltad a hudot.", gChatPrefix);
hudkibe[id] = true;
}
}
public showrang(id)
{
if(Rangok[Rang[id]+1][Szint])
{
client_print_color(id, print_team_default, "^4[%s] ^3Rang: ^4%s ^1| ^3Öléseid: ^4%d ^1| ^3Kell még: ^4%d", gChatPrefix, Rangok[Rang[id]][Szint], Oles[id], Rangok[Rang[id]][Xp]);
}
else
{
client_print_color(id, print_team_default, "^4[%s] ^3Rang: ^4%s ^1| ^3Ölések: ^4%d", gChatPrefix, Rangok[Rang[id]][Szint], Oles[id]);
client_print_color(id, print_team_default, "^4[%s] ^1Elérted a legmagasabb ^3rangot.", gChatPrefix);
}
return PLUGIN_HANDLED;
}
public kills()
{
new Gyilkos = read_data(1);
new Aldozat = read_data(2);
if(Gyilkos == Aldozat)
return PLUGIN_HANDLED;
Oles[Gyilkos] ++;
while(Oles[Gyilkos] >= Rangok[Rang[Gyilkos]][Xp])
Rang[Gyilkos]++;
return PLUGIN_HANDLED;
}
public Addolas(id)
{
g_uPoints[id][M4A1] += 50;
g_uPoints[id][AK47] += 50;
g_uPoints[id][AWP] += 50;
g_uPoints[id][SCOUT] += 50;
g_uPoints[id][FAMAS] += 50;
g_uPoints[id][GALIL] += 50;
g_uPoints[id][AUG] += 50;
g_uPoints[id][M3] += 50;
g_uPoints[id][XM1014] += 50;
g_uPoints[id][KNIFE] += 50;
g_uPoints[id][DEAGLE] += 50;
g_uPoints[id][USP] += 50;
g_uPoints[id][GLOCK] += 50;
}
public plugin_precache() {
for(new i;i < sizeof(WeaponM4A1); i++) precache_model(WeaponM4A1[i][ModelName]);
for(new i;i < sizeof(WeaponAK47); i++) precache_model(WeaponAK47[i][ModelName]);
for(new i;i < sizeof(WeaponAWP); i++) precache_model(WeaponAWP[i][ModelName]);
for(new i;i < sizeof(WeaponSCOUT); i++) precache_model(WeaponSCOUT[i][ModelName]);
for(new i;i < sizeof(WeaponFAMAS); i++) precache_model(WeaponFAMAS[i][ModelName]);
for(new i;i < sizeof(WeaponGALIL); i++) precache_model(WeaponGALIL[i][ModelName]);
for(new i;i < sizeof(WeaponAUG); i++) precache_model(WeaponAUG[i][ModelName]);
for(new i;i < sizeof(WeaponM3); i++) precache_model(WeaponM3[i][ModelName]);
for(new i;i < sizeof(WeaponXM1014); i++) precache_model(WeaponXM1014[i][ModelName]);
for(new i;i < sizeof(WeaponKNIFE); i++) precache_model(WeaponKNIFE[i][ModelName]);
for(new i;i < sizeof(WeaponDEAGLE); i++) precache_model(WeaponDEAGLE[i][ModelName]);
for(new i;i < sizeof(WeaponUSP); i++) precache_model(WeaponUSP[i][ModelName]);
for(new i;i < sizeof(WeaponGLOCK); i++) precache_model(WeaponGLOCK[i][ModelName]);
}
public WeaponChange_p(iEnt)
{
new id = get_pdata_cbase(iEnt, 41, 4);
if(!is_user_alive(id) || !is_user_connected(id))
return HAM_IGNORED;
new Weapon = cs_get_weapon_id(iEnt);
switch(Weapon)
{
case CSW_M4A1: entity_set_string(id, EV_SZ_viewmodel, WeaponM4A1[g_SelectedGun[id][M4A1]][ModelName]);
case CSW_AK47: entity_set_string(id, EV_SZ_viewmodel, WeaponAK47[g_SelectedGun[id][AK47]][ModelName]);
case CSW_AWP: entity_set_string(id, EV_SZ_viewmodel, WeaponAWP[g_SelectedGun[id][AWP]][ModelName]);
case CSW_SCOUT: entity_set_string(id, EV_SZ_viewmodel, WeaponSCOUT[g_SelectedGun[id][SCOUT]][ModelName]);
case CSW_FAMAS: entity_set_string(id, EV_SZ_viewmodel, WeaponFAMAS[g_SelectedGun[id][FAMAS]][ModelName]);
case CSW_GALIL: entity_set_string(id, EV_SZ_viewmodel, WeaponGALIL[g_SelectedGun[id][GALIL]][ModelName]);
case CSW_AUG: entity_set_string(id, EV_SZ_viewmodel, WeaponAUG[g_SelectedGun[id][AUG]][ModelName]);
case CSW_M3: entity_set_string(id, EV_SZ_viewmodel, WeaponM3[g_SelectedGun[id][M3]][ModelName]);
case CSW_XM1014: entity_set_string(id, EV_SZ_viewmodel, WeaponXM1014[g_SelectedGun[id][XM1014]][ModelName]);
case CSW_KNIFE: entity_set_string(id, EV_SZ_viewmodel, WeaponKNIFE[g_SelectedGun[id][KNIFE]][ModelName]);
case CSW_DEAGLE: entity_set_string(id, EV_SZ_viewmodel, WeaponDEAGLE[g_SelectedGun[id][DEAGLE]][ModelName]);
case CSW_USP: entity_set_string(id, EV_SZ_viewmodel, WeaponUSP[g_SelectedGun[id][USP]][ModelName]);
case CSW_GLOCK18: entity_set_string(id, EV_SZ_viewmodel, WeaponGLOCK[g_SelectedGun[id][GLOCK]][ModelName]);
}
return HAM_IGNORED;
}
public Halal() {
new iAttacker = read_data(1);
new iVictim = read_data(2);
new iHs = read_data(3);
if(iAttacker == iVictim || iAttacker == 0) return PLUGIN_HANDLED;
new iPoints = iHs ? HEADSHOT_POINT : KILL_POINT;
switch(get_user_weapon(iAttacker)) {
case CSW_M4A1: g_uPoints[iAttacker][M4A1] += iPoints;
case CSW_AK47: g_uPoints[iAttacker][AK47] += iPoints;
case CSW_AWP: g_uPoints[iAttacker][AWP] += iPoints;
case CSW_SCOUT: g_uPoints[iAttacker][SCOUT] += iPoints;
case CSW_FAMAS: g_uPoints[iAttacker][FAMAS] += iPoints;
case CSW_GALIL: g_uPoints[iAttacker][GALIL] += iPoints;
case CSW_AUG: g_uPoints[iAttacker][AUG] += iPoints;
case CSW_M3: g_uPoints[iAttacker][M3] += iPoints;
case CSW_XM1014: g_uPoints[iAttacker][XM1014] += iPoints;
case CSW_KNIFE: g_uPoints[iAttacker][KNIFE] += iPoints;
case CSW_DEAGLE: g_uPoints[iAttacker][DEAGLE] += iPoints;
case CSW_USP: g_uPoints[iAttacker][USP] += iPoints;
case CSW_GLOCK18: g_uPoints[iAttacker][GLOCK] += iPoints;
}
set_hudmessage(random(256), random(256), random(256), -1.0, 0.20, 0, 6.0, 3.0);
ShowSyncHudMsg(gSyncHud, iAttacker, "+%i Pont", iPoints);
return PLUGIN_CONTINUE;
}
public main_menu(id)
{
new sTitle[128];
format(sTitle, charsmax(sTitle), "[%s] \r» \d[ Főmenü \r]", gMenuPrefix);
new iMenu = menu_create(sTitle, "menu_main_h");
menu_additem(iMenu, "\rFegyver Skinek", "1", 0);
menu_additem(iMenu, "\rBeállitások", "2", 0);
menu_display(id, iMenu, 0);
}
public menu_main_h(id, menu, item)
{
if(item == MENU_EXIT)
{
menu_destroy(menu);
return;
}
new data[9], Name[64];
new access, callback;
menu_item_getinfo(menu, item, access, data,charsmax(data), Name,charsmax(Name), callback);
new key = str_to_num(data);
switch(key)
{
case 1: menu_storage(id);
}
}
public menu_storage(id)
{
new sTitle[128];
format(sTitle, charsmax(sTitle), "[%s] \r» \d[ Fegyver Skinek \r]", gChatPrefix);
new iMenu = menu_create(sTitle, "menu_storage_h");
menu_additem(iMenu, "\rM4A1 \ySkinek", "1", 0);
menu_additem(iMenu, "\rAK47 \ySkinek", "2", 0);
menu_additem(iMenu, "\rAWP \ySkinek", "3", 0);
menu_additem(iMenu, "\rSCOUT \ySkinek", "4", 0);
menu_additem(iMenu, "\rFAMAS \ySkinek", "5", 0);
menu_additem(iMenu, "\rGALIL \ySkinek", "6", 0);
menu_additem(iMenu, "\rAUG \ySkinek", "7", 0);
menu_additem(iMenu, "\rM3 \ySkinek", "8", 0);
menu_additem(iMenu, "\rXM1014 \ySkinek", "9", 0);
menu_additem(iMenu, "\rKNIFE \ySkinek", "10", 0);
menu_additem(iMenu, "\rDEAGLE \ySkinek", "11", 0);
menu_additem(iMenu, "\rUSP \ySkinek", "12", 0);
menu_additem(iMenu, "\rGLOCK18 \ySkinek", "13", 0);
menu_display(id, iMenu, 0);
}
public menu_storage_h(id, menu, item)
{
if(item == MENU_EXIT)
{
menu_destroy(menu);
return;
}
new data[9], Name[64];
new access, callback;
menu_item_getinfo(menu, item, access, data,charsmax(data), Name,charsmax(Name), callback);
new key = str_to_num(data);
switch(key)
{
case 1: m4a1_menu(id);
case 2: ak47_menu(id);
case 3: awp_menu(id);
case 4: scout_menu(id);
case 5: famas_menu(id);
case 6: aug_menu(id);
case 7: galil_menu(id);
case 8: m3_menu(id);
case 9: xm1014_menu(id);
case 10: knife_menu(id);
case 11: deagle_menu(id);
case 12: usp_menu(id);
case 13: glock_menu(id);
}
}
public m4a1_menu(id) {
new sText[256], iSize = sizeof(WeaponM4A1);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wM4A1 Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][M4A1]);
new iMenu = menu_create(sText, "m4a1_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponM4A1[i][Points] <= g_uPoints[id][M4A1] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponM4A1[i][GunName], g_uPoints[id][M4A1], WeaponM4A1[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public m4a1_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponM4A1[item][Points] >= g_uPoints[id][M4A1]) {
g_SelectedGun[id][M4A1] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public ak47_menu(id) {
new sText[256], iSize = sizeof(WeaponAK47);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wAK47 Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][AK47]);
new iMenu = menu_create(sText, "ak47_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponAK47[i][Points] <= g_uPoints[id][AK47] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponAK47[i][GunName], g_uPoints[id][AK47], WeaponAK47[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public ak47_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponAK47[item][Points] <= g_uPoints[id][AK47]) {
g_SelectedGun[id][AK47] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public awp_menu(id) {
new sText[256], iSize = sizeof(WeaponAWP);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wAWP Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][AWP]);
new iMenu = menu_create(sText, "awp_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponAWP[i][Points] <= g_uPoints[id][AWP] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponAWP[i][GunName], g_uPoints[id][AWP], WeaponAWP[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public awp_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponAWP[item][Points] <= g_uPoints[id][AWP]) {
g_SelectedGun[id][AWP] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public scout_menu(id) {
new sText[256], iSize = sizeof(WeaponSCOUT);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wSCOUT Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][SCOUT]);
new iMenu = menu_create(sText, "scout_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponSCOUT[i][Points] <= g_uPoints[id][SCOUT] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponSCOUT[i][GunName], g_uPoints[id][SCOUT], WeaponSCOUT[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public scout_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponSCOUT[item][Points] <= g_uPoints[id][SCOUT]) {
g_SelectedGun[id][SCOUT] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public famas_menu(id) {
new sText[256], iSize = sizeof(WeaponFAMAS);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wFAMAS Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][FAMAS]);
new iMenu = menu_create(sText, "famas_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponFAMAS[i][Points] <= g_uPoints[id][FAMAS] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponFAMAS[i][GunName], g_uPoints[id][FAMAS], WeaponFAMAS[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public famas_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponFAMAS[item][Points] <= g_uPoints[id][FAMAS]) {
g_SelectedGun[id][FAMAS] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public aug_menu(id) {
new sText[256], iSize = sizeof(WeaponAUG);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wAUG Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][AUG]);
new iMenu = menu_create(sText, "galil_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponAUG[i][Points] <= g_uPoints[id][AUG] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponAUG[i][GunName], g_uPoints[id][AUG], WeaponAUG[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public aug_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponAUG[item][Points] <= g_uPoints[id][AUG]) {
g_SelectedGun[id][AUG] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public galil_menu(id) {
new sText[256], iSize = sizeof(WeaponGALIL);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wGALIL Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][GALIL]);
new iMenu = menu_create(sText, "galil_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponFAMAS[i][Points] <= g_uPoints[id][GALIL] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponGALIL[i][GunName], g_uPoints[id][GALIL], WeaponGALIL[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public galil_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponGALIL[item][Points] <= g_uPoints[id][GALIL]) {
g_SelectedGun[id][GALIL] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public m3_menu(id) {
new sText[256], iSize = sizeof(WeaponM3);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wM3 Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][M3]);
new iMenu = menu_create(sText, "m3_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponM3[i][Points] <= g_uPoints[id][M3] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponM3[i][GunName], g_uPoints[id][M3], WeaponM3[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public m3_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponM3[item][Points] <= g_uPoints[id][M3]) {
g_SelectedGun[id][M3] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public xm1014_menu(id) {
new sText[256], iSize = sizeof(WeaponXM1014);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wXM1014 Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][M3]);
new iMenu = menu_create(sText, "xm1014_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponXM1014[i][Points] <= g_uPoints[id][XM1014] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponXM1014[i][GunName], g_uPoints[id][XM1014], WeaponXM1014[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public xm1014_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponXM1014[item][Points] <= g_uPoints[id][XM1014]) {
g_SelectedGun[id][XM1014] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public knife_menu(id) {
new sText[256], iSize = sizeof(WeaponXM1014);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wKNIFE Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][KNIFE]);
new iMenu = menu_create(sText, "knife_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponKNIFE[i][Points] <= g_uPoints[id][KNIFE] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponKNIFE[i][GunName], g_uPoints[id][KNIFE], WeaponKNIFE[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public knife_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponKNIFE[item][Points] <= g_uPoints[id][KNIFE]) {
g_SelectedGun[id][KNIFE] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public deagle_menu(id) {
new sText[256], iSize = sizeof(WeaponDEAGLE);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wDEAGLE Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][DEAGLE]);
new iMenu = menu_create(sText, "deagle_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponDEAGLE[i][Points] <= g_uPoints[id][DEAGLE] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponDEAGLE[i][GunName], g_uPoints[id][DEAGLE], WeaponDEAGLE[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public deagle_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponDEAGLE[item][Points] <= g_uPoints[id][DEAGLE]) {
g_SelectedGun[id][DEAGLE] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public usp_menu(id) {
new sText[256], iSize = sizeof(WeaponUSP);
format(sText, charsmax(sText), "[~|ChamPs|~] \r» \wUSP Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][USP]);
new iMenu = menu_create(sText, "usp_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponUSP[i][Points] <= g_uPoints[id][USP] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponUSP[i][GunName], g_uPoints[id][USP], WeaponUSP[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public usp_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponUSP[item][Points] <= g_uPoints[id][USP]) {
g_SelectedGun[id][USP] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3pontod az öléshez.^3!", gChatPrefix);
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public glock_menu(id) {
new sText[256], iSize = sizeof(WeaponGLOCK);
format(sText, charsmax(sText), "^3[%s]^4 \r» \wGLOCK Skinek \r[\dPontjaid: \y%d\r]", g_uPoints[id][GLOCK]);
new iMenu = menu_create(sText, "glock_handler");
for(new i; i < iSize; i++){
formatex(sText, charsmax(sText), WeaponGLOCK[i][Points] <= g_uPoints[id][GLOCK] ? "\w%s \y[\d%d\w/\r%d\y]":"\w%s \y*Elérve", WeaponGLOCK[i][GunName], g_uPoints[id][GLOCK], WeaponGLOCK[i][Points])
menu_additem(iMenu, sText);
}
menu_setprop(iMenu, MPROP_BACKNAME, "Vissza");
menu_setprop(iMenu, MPROP_NEXTNAME, "Tovább");
menu_setprop(iMenu, MPROP_EXITNAME, "Kilépés");
menu_display(id, iMenu, 0);
}
public glock_handler(id, iMenu, item) {
if( item == MENU_EXIT ) {
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
if(WeaponDEAGLE[item][Points] <= g_uPoints[id][DEAGLE]) {
g_SelectedGun[id][DEAGLE] = item;
} else {
client_print_color(id, print_team_default, "^3[%s]^4 ^1Sajnálom, nincs elegendő ^3Pontod^3!");
}
menu_destroy(iMenu);
return PLUGIN_HANDLED;
}
public client_putinserver(id)
{
if(is_user_bot(id))
return;
set_task(1.0, "hudrendszer", id, _, _, "b");
betoltve[id] = false;
Masodpercek[id] = 0;
Rang[id] = 0;
Oles[id] = 0;
hudkibe[id] = 1;
g_uPoints[id][M4A1] = 0;
g_uPoints[id][AK47] = 0;
g_uPoints[id][AWP] = 0;
g_uPoints[id][SCOUT] = 0;
g_uPoints[id][FAMAS] = 0;
g_uPoints[id][GALIL] = 0;
g_uPoints[id][AUG] = 0;
g_uPoints[id][M3] = 0;
g_uPoints[id][XM1014] = 0;
g_uPoints[id][KNIFE] = 0;
g_uPoints[id][DEAGLE] = 0;
g_uPoints[id][USP] = 0;
g_uPoints[id][GLOCK] = 0;
g_SelectedGun[id][M4A1] = 0;
g_SelectedGun[id][AK47] = 0;
g_SelectedGun[id][AWP] = 0;
g_SelectedGun[id][SCOUT] = 0;
g_SelectedGun[id][FAMAS] = 0;
g_SelectedGun[id][GALIL] = 0;
g_SelectedGun[id][AUG] = 0;
g_SelectedGun[id][M3] = 0;
g_SelectedGun[id][XM1014] = 0;
g_SelectedGun[id][KNIFE] = 0;
g_SelectedGun[id][DEAGLE] = 0;
g_SelectedGun[id][USP] = 0;
g_SelectedGun[id][GLOCK] = 0;
SelectDataTable(id);
}
public client_disconnected(id)
{
if(is_user_bot(id))
return;
TableUpdate(id);
}
new Handle:g_SqlTuple;
public plugin_cfg()
{
//Kiszolgáló | Felhasználó | Jelszó | Adatbázis
g_SqlTuple = SQL_MakeDbTuple("mysql8.srkhost.eu:3306", "u29514_Q9S6QiB1On", "9DuKrQSL4!4z9Rcr9R4.sf1Y", "s29514_valami");
CreateTable();
}
public CreateTable(){
new iLen;
static sQuery[10048];
iLen += formatex(sQuery[iLen], charsmax(sQuery), "CREATE TABLE IF NOT EXISTS \`%s\` ", Tablename);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "( ");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`Id\` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`SteamId\` varchar(64) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`Masodpercek\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`Szint\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`Oles\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`hudkibe\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsM4A1\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsAK47\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsAWP\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsSCOUT\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsFAMAS\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsGALIL\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsAUG\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsM3\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsXM1014\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsKNIFE\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsDEAGLE\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsUSP\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_uPointsGLOCK\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunM4A1\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunAK47\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunAWP\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunSCOUT\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunFAMAS\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunGALIL\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunAUG\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunM3\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunXM1014\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunKNIFE\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunDEAGLE\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunUSP\` int(11) NOT NULL,");
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "\`g_SelectedGunGLOCK\` int(11) NOT NULL)");
SQL_ThreadQuery(g_SqlTuple, "TableCreateThread", sQuery);
}
public TableUpdate(id)
{
if(betoltve[id]) {
static sQuery[10048];
new iLen, sSteamID[64];
get_user_authid(id, sSteamID, charsmax(sSteamID));
iLen += formatex(sQuery[iLen], charsmax(sQuery), "UPDATE \`%s\` SET ", Tablename);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "Szint = ^"%i^", ", Rang[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "Oles = ^"%i^", ", Oles[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "hudkibe = ^"%i^", ", hudkibe[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM4A1 = ^"%i^",", g_uPoints[id][M4A1]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAK47 = ^"%i^",", g_uPoints[id][AK47]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAWP = ^"%i^",", g_uPoints[id][AWP]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsSCOUT = ^"%i^",", g_uPoints[id][SCOUT]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsFAMAS = ^"%i^",", g_uPoints[id][FAMAS]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGALIL = ^"%i^",", g_uPoints[id][GALIL]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAUG = ^"%i^",", g_uPoints[id][AUG]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM3 = ^"%i^",", g_uPoints[id][M3]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsXM1014 = ^"%i^",", g_uPoints[id][XM1014]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsKNIFE = ^"%i^",", g_uPoints[id][KNIFE]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsDEAGLE = ^"%i^",", g_uPoints[id][DEAGLE]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsUSP = ^"%i^",", g_uPoints[id][USP]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGLOCK = ^"%i^",", g_uPoints[id][GLOCK]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAK47 = ^"%i^",", g_SelectedGun[id][AK47]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAWP = ^"%i^",", g_SelectedGun[id][AWP]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunSCOUT = ^"%i^",", g_SelectedGun[id][SCOUT]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunFAMAS = ^"%i^",", g_SelectedGun[id][FAMAS]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGALIL = ^"%i^",", g_SelectedGun[id][GALIL]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAUG = ^"%i^",", g_SelectedGun[id][AUG]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM3 = ^"%i^",", g_SelectedGun[id][M3]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunXM1014 = ^"%i^",", g_SelectedGun[id][XM1014]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunKNIFE = ^"%i^",", g_SelectedGun[id][KNIFE]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunDEAGLE = ^"%i^",", g_SelectedGun[id][DEAGLE]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunUSP = ^"%i^",", g_SelectedGun[id][USP]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGLOCK = ^"%i^",", g_SelectedGun[id][GLOCK]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM4A1 = ^"%i^" WHERE \`SteamId\` = ^"%s^";", g_SelectedGun[id][M4A1], sSteamID);
SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
}
}
public TableCreateThread(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
{
if(iFailState == TQUERY_CONNECT_FAILED)
set_fail_state("[Create] Nem lehet csatlakozni az adatbazishoz!");
else if(iFailState == TQUERY_QUERY_FAILED)
set_fail_state("[Create] Lekerdezesi hiba");
if(iErrcode)
log_amx("[Create] Hiba:**!! %s !!**", sError);
}
public TableInsert(id)
{
static sQuery[10048], sSteamID[64];
get_user_authid(id, sSteamID, charsmax(sSteamID));
formatex(sQuery, charsmax(sQuery), "INSERT INTO \`%s\` (\`SteamId\`) VALUES (^"%s^");", Tablename, sSteamID);
SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
betoltve[id] = true;
}
public SelectDataTable(id)
{
static sQuery[10048];
new sData[1], sSteamID[64];
sData[0] = id;
get_user_authid(id, sSteamID, charsmax(sSteamID));
formatex(sQuery, charsmax(sQuery), "SELECT * FROM \`%s\` WHERE SteamId = ^"%s^";", Tablename, sSteamID);
SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataTable", sQuery, sData, 1);
}
public QuerySelectDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
{
if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
{
log_amx("[Insert] Hiba:**!! %s !!**", sError);
return;
}
else
{
new id = sData[0];
if(SQL_NumRows(sQuery) > 0)
{
Masodpercek[id] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "Masodpercek"));
Rang[id] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "Szint"));
Oles[id] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "Oles"));
hudkibe[id] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "hudkibe"));
g_uPoints[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM4A1"));
g_uPoints[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAK47"));
g_uPoints[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAWP"));
g_uPoints[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsSCOUT"));
g_uPoints[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsFAMAS"));
g_uPoints[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGALIL"));
g_uPoints[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAUG"));
g_uPoints[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM3"));
g_uPoints[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsXM1014"));
g_uPoints[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsKNIFE"));
g_uPoints[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsDEAGLE"));
g_uPoints[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsUSP"));
g_uPoints[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGLOCK"));
g_SelectedGun[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM4A1"));
g_SelectedGun[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAK47"));
g_SelectedGun[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAWP"));
g_SelectedGun[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunSCOUT"));
g_SelectedGun[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunFAMAS"));
g_SelectedGun[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGALIL"));
g_SelectedGun[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAUG"));
g_SelectedGun[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM3"));
g_SelectedGun[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunXM1014"));
g_SelectedGun[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunKNIFE"));
g_SelectedGun[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunDEAGLE"));
g_SelectedGun[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunUSP"));
g_SelectedGun[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGLOCK"));
betoltve[id] = true;
}
else
TableInsert(id);
}
}
public QuerySetDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
{
if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
{
log_amx("[SetData] Hiba:**!! %s !!**", sError);
return;
}
}
/* AMXX-Studio Notes - DO NOT MODIFY BELOW HERE
*{\\ rtf1\\ ansi\\ deff0{\\ fonttbl{\\ f0\\ fnil Tahoma;}}\n\\ viewkind4\\ uc1\\ pard\\ lang1038\\ f0\\ fs16 \n\\ par }
*/