hlmod.hu
https://hlmod.hu/

SQL gond! (Következő pálya után nem tölti be az adatokat)
https://hlmod.hu/viewtopic.php?f=9&t=31361
Oldal: 1 / 1

Szerző:  saxxo [ 2022.10.09. 18:26 ]
Hozzászólás témája:  SQL gond! (Következő pálya után nem tölti be az adatokat)

Sziasztok!

Hiba nincsen nem tudok küldeni!
Következő pályánál már nem tudja betölteni az adatokat amit letölt a szerver!


Köszönöm Előre is!

  1. #include <amxmodx>
  2.     #include <engine>
  3.     #include <fakemeta>
  4.     #include <cstrike>
  5.     #include <sqlx>
  6.      
  7.     #define PLUGIN "New Plug-In"
  8.     #define VERSION "1.0"
  9.     #define AUTHOR "author"
  10.      
  11.     #define KILL_POINT 1
  12.     #define HEADSHOT_POINT 5
  13.     #define Tablename "Hlmodra_tabla_1" //SQL Tábla neve!//
  14.      
  15.     enum _:GunDatas {
  16.         M4A1,
  17.         AK47,
  18.         AWP,
  19.         SCOUT,
  20.         FAMAS,
  21.         GALIL,
  22.         AUG,
  23.         M3,
  24.         XM1014,
  25.         KNIFE,
  26.         DEAGLE,
  27.         USP,
  28.         GLOCK
  29.     }
  30.     new g_SelectedGun[33][GunDatas], g_uPoints[33][GunDatas], g_Wpn[33];
  31.     new sSteamID[64];
  32.      
  33.     new const gMenuPrefix[] = "\w[<<< Night~Warrior >>>]~\y»\yFun";
  34.     new const gChatPrefix[] = "[<<< Night~Warrior >>>]"
  35.      
  36.     enum _:DATA {
  37.         GunName[64],
  38.         ModelName[64],
  39.         Points[8]
  40.     }
  41.     new const WeaponM4A1[][DATA] = {
  42.         {"M4A1 | Default", "models/v_m4a1.mdl", 0, },
  43.     }
  44.     new const WeaponAK47[][DATA] = {
  45.         {"AK47 | Default", "models/v_ak47.mdl", 0, },
  46.     }
  47.     new const WeaponAWP[][DATA] = {
  48.         {"AWP | Default", "models/v_awp.mdl", 0, },
  49.     }
  50.     new const WeaponSCOUT[][DATA] = {
  51.         {"SCOUT | Default", "models/v_scout.mdl", 0, },
  52.     }
  53.     new const WeaponFAMAS[][DATA] = {
  54.         {"FAMAS | Default", "models/v_famas.mdl", 0, },
  55.     }
  56.     new const WeaponGALIL[][DATA] = {
  57.         {"GALIL | Default", "models/v_galil.mdl", 0, },
  58.     }
  59.     new const WeaponAUG[][DATA] = {
  60.         {"AUG | Default", "models/v_aug.mdl", 0, },
  61.     }
  62.     new const WeaponM3[][DATA] = {
  63.         {"M3 | Default", "models/v_m3.mdl", 0, },
  64.     }
  65.     new const WeaponXM1014[][DATA] = {
  66.         {"XM1014 | Default", "models/v_xm1014.mdl", 0, },
  67.     }
  68.     new const WeaponKNIFE[][DATA] = {
  69.         {"KNIFE | Default", "models/v_knife.mdl", 0, },
  70.     }
  71.     new const WeaponDEAGLE[][DATA] = {
  72.         {"DEAGLE | Default", "models/v_deagle.mdl", 0, },
  73.     }
  74.     new const WeaponUSP[][DATA] = {
  75.         {"USP | Default", "models/v_usp.mdl", 0, },
  76.     }
  77.     new const WeaponGLOCK[][DATA] = {
  78.         {"GLOCK18 | Default", "models/v_glock18.mdl", 0, },
  79.     }  
  80.     new const MainStrings[][] = {
  81.         "M4A1 Skinek",
  82.         "AK47 Skinek",
  83.         "AWP Skinek",
  84.         "SCOUT Skinek",
  85.         "FAMAS Skinek",
  86.         "GALIL Skinek",
  87.         "AUG Skinek",
  88.         "M3 Skinek",
  89.         "XM1014 Skinek",
  90.         "KNIFE Skinek",
  91.         "DEAGLE Skinek",
  92.         "USP Skinek",
  93.         "GLOCK18 Skinek"
  94.     }
  95.     public plugin_init() {
  96.         register_plugin(PLUGIN, VERSION, AUTHOR)
  97.         register_clcmd("say /menu", "openMainMenu")
  98.         register_clcmd("say /add", "Addolas")
  99.        
  100.         register_impulse(201, "openMainMenu");
  101.        
  102.         register_event("DeathMsg","Halal","a")
  103.         register_event("CurWeapon", "evChangeWeapon", "be", "1=1")
  104.        
  105.         set_task(15.0,"autoSave",.flags="b")
  106.     }
  107.     public Addolas(id)
  108.     {
  109.         g_uPoints[id][M4A1] += 50
  110.         g_uPoints[id][AK47] += 50
  111.         g_uPoints[id][AWP] += 50
  112.         g_uPoints[id][SCOUT] += 50
  113.         g_uPoints[id][FAMAS] += 50
  114.         g_uPoints[id][GALIL] += 50
  115.         g_uPoints[id][AUG] += 50
  116.         g_uPoints[id][M3] += 50
  117.         g_uPoints[id][XM1014] += 50
  118.         g_uPoints[id][KNIFE] += 50
  119.         g_uPoints[id][DEAGLE] += 50
  120.         g_uPoints[id][USP] += 50
  121.         g_uPoints[id][GLOCK] += 50;
  122.     }
  123.     public plugin_precache() {
  124.         for(new i;i < sizeof(WeaponM4A1); i++) precache_model(WeaponM4A1[i][ModelName])
  125.         for(new i;i < sizeof(WeaponAK47); i++) precache_model(WeaponAK47[i][ModelName])
  126.         for(new i;i < sizeof(WeaponAWP); i++) precache_model(WeaponAWP[i][ModelName])
  127.         for(new i;i < sizeof(WeaponSCOUT); i++) precache_model(WeaponSCOUT[i][ModelName])
  128.         for(new i;i < sizeof(WeaponFAMAS); i++) precache_model(WeaponFAMAS[i][ModelName])
  129.         for(new i;i < sizeof(WeaponGALIL); i++) precache_model(WeaponGALIL[i][ModelName])
  130.         for(new i;i < sizeof(WeaponAUG); i++) precache_model(WeaponAUG[i][ModelName])
  131.         for(new i;i < sizeof(WeaponM3); i++) precache_model(WeaponM3[i][ModelName])
  132.         for(new i;i < sizeof(WeaponXM1014); i++) precache_model(WeaponXM1014[i][ModelName])
  133.         for(new i;i < sizeof(WeaponKNIFE); i++) precache_model(WeaponKNIFE[i][ModelName])
  134.         for(new i;i < sizeof(WeaponDEAGLE); i++) precache_model(WeaponDEAGLE[i][ModelName])
  135.         for(new i;i < sizeof(WeaponUSP); i++) precache_model(WeaponUSP[i][ModelName])
  136.         for(new i;i < sizeof(WeaponGLOCK); i++) precache_model(WeaponGLOCK[i][ModelName])
  137.     }
  138.     public evChangeWeapon(id) {
  139.         switch(get_user_weapon(id)) {
  140.             case CSW_M4A1: entity_set_string(id, EV_SZ_viewmodel, WeaponM4A1[g_SelectedGun[id][M4A1]][ModelName]);
  141.                 case CSW_AK47: entity_set_string(id, EV_SZ_viewmodel, WeaponAK47[g_SelectedGun[id][AK47]][ModelName]);
  142.                 case CSW_AWP: entity_set_string(id, EV_SZ_viewmodel, WeaponAWP[g_SelectedGun[id][AWP]][ModelName]);
  143.                 case CSW_SCOUT: entity_set_string(id, EV_SZ_viewmodel, WeaponSCOUT[g_SelectedGun[id][SCOUT]][ModelName]);
  144.                 case CSW_FAMAS: entity_set_string(id, EV_SZ_viewmodel, WeaponFAMAS[g_SelectedGun[id][FAMAS]][ModelName]);
  145.                 case CSW_GALIL: entity_set_string(id, EV_SZ_viewmodel, WeaponGALIL[g_SelectedGun[id][GALIL]][ModelName]);
  146.                 case CSW_AUG: entity_set_string(id, EV_SZ_viewmodel, WeaponAUG[g_SelectedGun[id][AUG]][ModelName]);
  147.                 case CSW_M3: entity_set_string(id, EV_SZ_viewmodel, WeaponM3[g_SelectedGun[id][M3]][ModelName]);
  148.                 case CSW_XM1014: entity_set_string(id, EV_SZ_viewmodel, WeaponXM1014[g_SelectedGun[id][XM1014]][ModelName]);
  149.                 case CSW_KNIFE: entity_set_string(id, EV_SZ_viewmodel, WeaponKNIFE[g_SelectedGun[id][KNIFE]][ModelName]);
  150.                 case CSW_DEAGLE: entity_set_string(id, EV_SZ_viewmodel, WeaponDEAGLE[g_SelectedGun[id][DEAGLE]][ModelName]);
  151.                 case CSW_USP: entity_set_string(id, EV_SZ_viewmodel, WeaponUSP[g_SelectedGun[id][USP]][ModelName]);
  152.                 case CSW_GLOCK18: entity_set_string(id, EV_SZ_viewmodel, WeaponGLOCK[g_SelectedGun[id][GLOCK]][ModelName]);
  153.             }
  154.         return PLUGIN_CONTINUE
  155.     }
  156.     public Halal() {
  157.        
  158.         new iAttacker = read_data(1)
  159.         new iVictim = read_data(2)
  160.         new iHs = read_data(3)
  161.        
  162.         if(iAttacker == iVictim || iAttacker == 0) return PLUGIN_HANDLED
  163.         new iPoints = iHs ? HEADSHOT_POINT : KILL_POINT
  164.        
  165.         switch(get_user_weapon(iAttacker)) {
  166.             case CSW_M4A1: g_uPoints[iAttacker][M4A1] += iPoints
  167.                 case CSW_AK47: g_uPoints[iAttacker][AK47] += iPoints
  168.                 case CSW_AWP: g_uPoints[iAttacker][AWP] += iPoints
  169.                 case CSW_SCOUT: g_uPoints[iAttacker][SCOUT] += iPoints
  170.                 case CSW_FAMAS: g_uPoints[iAttacker][FAMAS] += iPoints
  171.                 case CSW_GALIL: g_uPoints[iAttacker][GALIL] += iPoints
  172.                 case CSW_AUG: g_uPoints[iAttacker][AUG] += iPoints
  173.                 case CSW_M3: g_uPoints[iAttacker][M3] += iPoints
  174.                 case CSW_XM1014: g_uPoints[iAttacker][XM1014] += iPoints
  175.                 case CSW_KNIFE: g_uPoints[iAttacker][KNIFE] += iPoints
  176.                 case CSW_DEAGLE: g_uPoints[iAttacker][DEAGLE] += iPoints
  177.                 case CSW_USP: g_uPoints[iAttacker][USP] += iPoints
  178.                 case CSW_GLOCK18: g_uPoints[iAttacker][GLOCK] += iPoints
  179.             }
  180.         set_hudmessage(random(256), random(256), random(256), -1.0, 0.20, 0, 6.0, 3.0);
  181.         show_hudmessage(iAttacker, "+%i Pont", iPoints);
  182.         return PLUGIN_CONTINUE;
  183.     }
  184.     public openMainMenu(id) {
  185.         new szMenu[121], String[6]
  186.         formatex(szMenu, charsmax(szMenu), "%s \wFőMenü", gChatPrefix);
  187.         new menu = menu_create(szMenu, "hMainMenu");
  188.        
  189.         for(new i ;i < sizeof(MainStrings); i++) {
  190.             num_to_str(i, String, 5)
  191.             formatex(szMenu, charsmax(szMenu), MainStrings[i]);
  192.             menu_additem(menu, szMenu, String);
  193.         }
  194.         menu_display(id, menu, 0);
  195.         return PLUGIN_HANDLED;
  196.     }
  197.     public hMainMenu(id, menu, item) {
  198.         if(item == MENU_EXIT) {
  199.             menu_destroy(menu);
  200.             return PLUGIN_HANDLED;
  201.         }
  202.         g_Wpn[id] = item+1
  203.         openSkinMenu(id)
  204.         menu_destroy(menu);
  205.         return PLUGIN_HANDLED;
  206.     }
  207.     public openSkinMenu(id) {
  208.         new szMenu[121], szMenu2[64], String[6]
  209.         if(g_Wpn[id] == 1) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][M4A1])
  210.         else if(g_Wpn[id] == 2) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AK47])
  211.             else if(g_Wpn[id] == 3) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AWP])
  212.             else if(g_Wpn[id] == 4) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][SCOUT])
  213.             else if(g_Wpn[id] == 5) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][FAMAS])
  214.             else if(g_Wpn[id] == 6) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][GALIL])
  215.             else if(g_Wpn[id] == 7) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AUG])
  216.             else if(g_Wpn[id] == 8) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][M3])
  217.             else if(g_Wpn[id] == 9) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][XM1014])
  218.             else if(g_Wpn[id] == 10) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][KNIFE])
  219.             else if(g_Wpn[id] == 11) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][DEAGLE])
  220.             else if(g_Wpn[id] == 12) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][USP])
  221.             else if(g_Wpn[id] == 13) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][GLOCK])
  222.         new menu = menu_create(szMenu, "hSkinChooser");
  223.         if(g_Wpn[id] == 1) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  224.         MainStrings[g_Wpn[id]-1], g_uPoints[id][M4A1])
  225.         if(g_Wpn[id] == 2) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  226.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AK47])
  227.         if(g_Wpn[id] == 3) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  228.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AWP])
  229.         if(g_Wpn[id] == 4) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  230.         MainStrings[g_Wpn[id]-1], g_uPoints[id][SCOUT])
  231.         if(g_Wpn[id] == 5) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  232.         MainStrings[g_Wpn[id]-1], g_uPoints[id][FAMAS])
  233.         if(g_Wpn[id] == 6) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  234.         MainStrings[g_Wpn[id]-1], g_uPoints[id][GALIL])
  235.         if(g_Wpn[id] == 7) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  236.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AUG])
  237.         if(g_Wpn[id] == 8) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  238.         MainStrings[g_Wpn[id]-1], g_uPoints[id][M3])
  239.         if(g_Wpn[id] == 9) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  240.         MainStrings[g_Wpn[id]-1], g_uPoints[id][XM1014])
  241.         if(g_Wpn[id] == 10) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  242.         MainStrings[g_Wpn[id]-1], g_uPoints[id][KNIFE])
  243.         if(g_Wpn[id] == 11) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  244.         MainStrings[g_Wpn[id]-1], g_uPoints[id][DEAGLE])
  245.         if(g_Wpn[id] == 12) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  246.         MainStrings[g_Wpn[id]-1], g_uPoints[id][USP])
  247.         if(g_Wpn[id] == 13) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  248.         MainStrings[g_Wpn[id]-1], g_uPoints[id][GLOCK])
  249.        
  250.         if(g_Wpn[id] == 1) {
  251.             for(new i; i < sizeof(WeaponM4A1); i++) {
  252.                 num_to_str(i, String, 5)
  253.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponM4A1[i][Points]);
  254.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponM4A1[i][GunName], g_SelectedGun[id][M4A1] == i ? "\y{Kiválasztva}": szMenu2);
  255.                 menu_additem(menu, szMenu, String);
  256.             }
  257.         }
  258.         else if(g_Wpn[id] == 2) {
  259.             for(new i; i < sizeof(WeaponAK47); i++) {
  260.                 num_to_str(i, String, 5)
  261.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAK47[i][Points]);
  262.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAK47[i][GunName], g_SelectedGun[id][AK47] == i ? "\y{Kiválasztva}": szMenu2);
  263.                 menu_additem(menu, szMenu, String);
  264.             }
  265.         }
  266.         else if(g_Wpn[id] == 3) {
  267.             for(new i; i < sizeof(WeaponAWP); i++) {
  268.                 num_to_str(i, String, 5)
  269.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAWP[i][Points]);
  270.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAWP[i][GunName], g_SelectedGun[id][AWP] == i ? "\y{Kiválasztva}": szMenu2);
  271.                 menu_additem(menu, szMenu, String);
  272.             }
  273.         }
  274.         else if(g_Wpn[id] == 4) {
  275.             for(new i; i < sizeof(WeaponSCOUT); i++) {
  276.                 num_to_str(i, String, 5)
  277.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponSCOUT[i][Points]);
  278.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponSCOUT[i][GunName], g_SelectedGun[id][SCOUT] == i ? "\y{Kiválasztva}": szMenu2);
  279.                 menu_additem(menu, szMenu, String);
  280.             }
  281.         }
  282.         else if(g_Wpn[id] == 5) {
  283.             for(new i; i < sizeof(WeaponFAMAS); i++) {
  284.                 num_to_str(i, String, 5)
  285.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponFAMAS[i][Points]);
  286.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponFAMAS[i][GunName], g_SelectedGun[id][FAMAS] == i ? "\y{Kiválasztva}": szMenu2);
  287.                 menu_additem(menu, szMenu, String);
  288.             }
  289.         }
  290.         else if(g_Wpn[id] == 6) {
  291.             for(new i; i < sizeof(WeaponGALIL); i++) {
  292.                 num_to_str(i, String, 5)
  293.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponGALIL[i][Points]);
  294.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponGALIL[i][GunName], g_SelectedGun[id][GALIL] == i ? "\y{Kiválasztva}": szMenu2);
  295.                 menu_additem(menu, szMenu, String);
  296.             }
  297.         }
  298.         else if(g_Wpn[id] == 7) {
  299.             for(new i; i < sizeof(WeaponAUG); i++) {
  300.                 num_to_str(i, String, 5)
  301.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAUG[i][Points]);
  302.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAUG[i][GunName], g_SelectedGun[id][AUG] == i ? "\y{Kiválasztva}": szMenu2);
  303.                 menu_additem(menu, szMenu, String);
  304.             }
  305.         }
  306.         else if(g_Wpn[id] == 8) {
  307.             for(new i; i < sizeof(WeaponM3); i++) {
  308.                 num_to_str(i, String, 5)
  309.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponM3[i][Points]);
  310.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponM3[i][GunName], g_SelectedGun[id][M3] == i ? "\y{Kiválasztva}": szMenu2);
  311.                 menu_additem(menu, szMenu, String);
  312.             }
  313.         }
  314.         else if(g_Wpn[id] == 9) {
  315.             for(new i; i < sizeof(WeaponXM1014); i++) {
  316.                 num_to_str(i, String, 5)
  317.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponXM1014[i][Points]);
  318.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponXM1014[i][GunName], g_SelectedGun[id][XM1014] == i ? "\y{Kiválasztva}": szMenu2);
  319.                 menu_additem(menu, szMenu, String);
  320.             }
  321.         }
  322.         else if(g_Wpn[id] == 10) {
  323.             for(new i; i < sizeof(WeaponKNIFE); i++) {
  324.                 num_to_str(i, String, 5)
  325.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponKNIFE[i][Points]);
  326.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponKNIFE[i][GunName], g_SelectedGun[id][KNIFE] == i ? "\y{Kiválasztva}": szMenu2);
  327.                 menu_additem(menu, szMenu, String);
  328.             }
  329.         }
  330.         else if(g_Wpn[id] == 11) {
  331.             for(new i; i < sizeof(WeaponDEAGLE); i++) {
  332.                 num_to_str(i, String, 5)
  333.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponDEAGLE[i][Points]);
  334.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponDEAGLE[i][GunName], g_SelectedGun[id][DEAGLE] == i ? "\y{Kiválasztva}": szMenu2);
  335.                 menu_additem(menu, szMenu, String);
  336.             }
  337.         }
  338.         else if(g_Wpn[id] == 12) {
  339.             for(new i; i < sizeof(WeaponUSP); i++) {
  340.                 num_to_str(i, String, 5)
  341.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponUSP[i][Points]);
  342.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponUSP[i][GunName], g_SelectedGun[id][USP] == i ? "\y{Kiválasztva}": szMenu2);
  343.                 menu_additem(menu, szMenu, String);
  344.             }
  345.         }
  346.         else if(g_Wpn[id] == 13) {
  347.             for(new i; i < sizeof(WeaponGLOCK); i++) {
  348.                 num_to_str(i, String, 5)
  349.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponGLOCK[i][Points]);
  350.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponGLOCK[i][GunName], g_SelectedGun[id][GLOCK] == i ? "\y{Kiválasztva}": szMenu2);
  351.                 menu_additem(menu, szMenu, String);
  352.             }
  353.         }
  354.         menu_display(id, menu, 0);
  355.         return PLUGIN_HANDLED;
  356.     }
  357.     public hSkinChooser(id, menu, item) {
  358.         if(item == MENU_EXIT)
  359.         {
  360.             menu_destroy(menu);
  361.             return PLUGIN_CONTINUE;
  362.         }
  363.         switch(g_Wpn[id]) {
  364.             case 1: {
  365.                 if(g_uPoints[id][M4A1] >= WeaponM4A1[item][Points]) {
  366.                     g_SelectedGun[id][M4A1] = item
  367.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  368.                 }
  369.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  370.             }
  371.             case 2: {
  372.                 if(g_uPoints[id][AK47] >= WeaponAK47[item][Points]) {
  373.                     g_SelectedGun[id][AK47] = item
  374.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  375.                 }
  376.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  377.             }
  378.             case 3: {
  379.                 if(g_uPoints[id][AWP] >= WeaponAWP[item][Points]) {
  380.                     g_SelectedGun[id][AWP] = item
  381.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  382.                 }
  383.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  384.             }
  385.             case 4: {
  386.                 if(g_uPoints[id][SCOUT] >= WeaponSCOUT[item][Points]) {
  387.                     g_SelectedGun[id][SCOUT] = item
  388.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  389.                 }
  390.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  391.             }
  392.             case 5: {
  393.                 if(g_uPoints[id][FAMAS] >= WeaponFAMAS[item][Points]) {
  394.                     g_SelectedGun[id][FAMAS] = item
  395.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  396.                 }
  397.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  398.             }
  399.             case 6: {
  400.                 if(g_uPoints[id][GALIL] >= WeaponGALIL[item][Points]) {
  401.                     g_SelectedGun[id][GALIL] = item
  402.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  403.                 }
  404.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  405.             }
  406.             case 7: {
  407.                 if(g_uPoints[id][AUG] >= WeaponAUG[item][Points]) {
  408.                     g_SelectedGun[id][AUG] = item
  409.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  410.                 }
  411.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  412.             }
  413.             case 8: {
  414.                 if(g_uPoints[id][M3] >= WeaponM3[item][Points]) {
  415.                     g_SelectedGun[id][M3] = item
  416.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  417.                 }
  418.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  419.             }
  420.             case 9: {
  421.                 if(g_uPoints[id][XM1014] >= WeaponXM1014[item][Points]) {
  422.                     g_SelectedGun[id][XM1014] = item
  423.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  424.                 }
  425.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  426.             }
  427.             case 10: {
  428.                 if(g_uPoints[id][KNIFE] >= WeaponKNIFE[item][Points]) {
  429.                     g_SelectedGun[id][KNIFE] = item
  430.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  431.                 }
  432.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  433.             }
  434.             case 11: {
  435.                 if(g_uPoints[id][DEAGLE] >= WeaponDEAGLE[item][Points]) {
  436.                     g_SelectedGun[id][DEAGLE] = item
  437.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  438.                 }
  439.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  440.             }
  441.             case 12: {
  442.                 if(g_uPoints[id][USP] >= WeaponUSP[item][Points]) {
  443.                     g_SelectedGun[id][USP] = item
  444.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  445.                 }
  446.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  447.             }
  448.             case 13: {
  449.                 if(g_uPoints[id][GLOCK] >= WeaponGLOCK[item][Points]) {
  450.                     g_SelectedGun[id][GLOCK] = item
  451.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  452.                 }
  453.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  454.             }
  455.         }
  456.         menu_destroy(menu);
  457.         return PLUGIN_HANDLED;
  458.     }
  459.     public client_putinserver(id)
  460.     {
  461.         if(is_user_bot(id))
  462.             return;
  463.        
  464.         g_uPoints[id][M4A1] = 0;
  465.         g_uPoints[id][AK47] = 0;
  466.         g_uPoints[id][AWP] = 0;
  467.         g_uPoints[id][SCOUT] = 0;
  468.         g_uPoints[id][FAMAS] = 0;
  469.         g_uPoints[id][GALIL] = 0;
  470.         g_uPoints[id][AUG] = 0;
  471.         g_uPoints[id][M3] = 0;
  472.         g_uPoints[id][XM1014] = 0;
  473.         g_uPoints[id][KNIFE] = 0;
  474.         g_uPoints[id][DEAGLE] = 0;
  475.         g_uPoints[id][USP] = 0;
  476.         g_uPoints[id][GLOCK] = 0;
  477.         g_SelectedGun[id][M4A1] = 0;
  478.         g_SelectedGun[id][AK47] = 0;
  479.         g_SelectedGun[id][AWP] = 0;
  480.         g_SelectedGun[id][SCOUT] = 0;
  481.         g_SelectedGun[id][FAMAS] = 0;
  482.         g_SelectedGun[id][GALIL] = 0;
  483.         g_SelectedGun[id][AUG] = 0;
  484.         g_SelectedGun[id][M3] = 0;
  485.         g_SelectedGun[id][XM1014] = 0;
  486.         g_SelectedGun[id][KNIFE] = 0;
  487.         g_SelectedGun[id][DEAGLE] = 0;
  488.         g_SelectedGun[id][USP] = 0;
  489.         g_SelectedGun[id][GLOCK] = 0;
  490.        
  491.         SelectDataTable(id);
  492.     }
  493.     public client_disconnected(id)
  494.     {
  495.         if(is_user_bot(id))
  496.             return;
  497.        
  498.         TableUpdate(id);
  499.     }
  500.     new Handle:g_SqlTuple;
  501.     public plugin_cfg()
  502.     {
  503.         //Kiszolgáló | Felhasználó | Jelszó | Adatbázis
  504.        
  505.         g_SqlTuple = SQL_MakeDbTuple("maria.srkhost.eu", "", "", "s17878_newszerver");
  506.         CreateTable();
  507.     }
  508.     public CreateTable(){
  509.         new iLen;
  510.         static sQuery[10048];
  511.        
  512.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "CREATE TABLE IF NOT EXISTS `%s` ", Tablename);
  513.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "( ");
  514.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
  515.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`SteamId` varchar(64) NOT NULL,");
  516.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM4A1` int(11) NOT NULL,");
  517.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAK47` int(11) NOT NULL,");
  518.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAWP` int(11) NOT NULL,");
  519.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsSCOUT` int(11) NOT NULL,");
  520.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsFAMAS` int(11) NOT NULL,");
  521.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGALIL` int(11) NOT NULL,");
  522.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAUG` int(11) NOT NULL,");
  523.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM3` int(11) NOT NULL,");
  524.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsXM1014` int(11) NOT NULL,");
  525.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsKNIFE` int(11) NOT NULL,");
  526.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  527.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsUSP` int(11) NOT NULL,");
  528.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGLOCK` int(11) NOT NULL,");
  529.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  530.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAK47` int(11) NOT NULL,");
  531.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAWP` int(11) NOT NULL,");
  532.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  533.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  534.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  535.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAUG` int(11) NOT NULL,");
  536.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM3` int(11) NOT NULL,");
  537.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  538.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  539.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  540.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunUSP` int(11) NOT NULL,");
  541.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGLOCK` int(11) NOT NULL)");
  542.        
  543.         SQL_ThreadQuery(g_SqlTuple, "TableCreateThread", sQuery);
  544.     }
  545.     public TableUpdate(id)
  546.     {
  547.         static sQuery[10048];
  548.         new iLen, sSteamID[64];
  549.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  550.        
  551.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "UPDATE `%s` SET ", Tablename);
  552.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM4A1 = ^"%i^",", g_uPoints[id][M4A1]);
  553.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAK47 = ^"%i^",", g_uPoints[id][AK47]);
  554.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAWP = ^"%i^",", g_uPoints[id][AWP]);
  555.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsSCOUT = ^"%i^",", g_uPoints[id][SCOUT]);
  556.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsFAMAS = ^"%i^",", g_uPoints[id][FAMAS]);
  557.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGALIL = ^"%i^",", g_uPoints[id][GALIL]);
  558.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAUG = ^"%i^",", g_uPoints[id][AUG]);
  559.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM3 = ^"%i^",", g_uPoints[id][M3]);
  560.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsXM1014 = ^"%i^",", g_uPoints[id][XM1014]);
  561.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsKNIFE = ^"%i^",", g_uPoints[id][KNIFE]);
  562.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsDEAGLE = ^"%i^",", g_uPoints[id][DEAGLE]);
  563.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsUSP = ^"%i^",", g_uPoints[id][USP]);
  564.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGLOCK = ^"%i^",", g_uPoints[id][GLOCK]);
  565.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAK47 = ^"%i^",", g_SelectedGun[id][AK47]);
  566.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAWP = ^"%i^",", g_SelectedGun[id][AWP]);
  567.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunSCOUT = ^"%i^",", g_SelectedGun[id][SCOUT]);
  568.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunFAMAS = ^"%i^",", g_SelectedGun[id][FAMAS]);
  569.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGALIL = ^"%i^",", g_SelectedGun[id][GALIL]);
  570.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAUG = ^"%i^",", g_SelectedGun[id][AUG]);
  571.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM3 = ^"%i^",", g_SelectedGun[id][M3]);
  572.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunXM1014 = ^"%i^",", g_SelectedGun[id][XM1014]);
  573.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunKNIFE = ^"%i^",", g_SelectedGun[id][KNIFE]);
  574.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunDEAGLE = ^"%i^",", g_SelectedGun[id][DEAGLE]);
  575.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunUSP = ^"%i^",", g_SelectedGun[id][USP]);
  576.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGLOCK = ^"%i^",", g_SelectedGun[id][GLOCK]);
  577.        
  578.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM4A1 = ^"%i^" WHERE `SteamId` = ^"%s^";", g_SelectedGun[id][M4A1], sSteamID);
  579.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  580.     }
  581.     public TableCreateThread(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  582.     {
  583.         if(iFailState == TQUERY_CONNECT_FAILED)
  584.             set_fail_state("[Create] Nem lehet csatlakozni az adatbazishoz!");
  585.         else if(iFailState == TQUERY_QUERY_FAILED)
  586.             set_fail_state("[Create] Lekerdezesi hiba");
  587.         if(iErrcode)
  588.             log_amx("[Create] Hiba:**!! %s !!**", sError);
  589.     }
  590.     public TableInsert(id)
  591.     {
  592.         static sQuery[10048], sSteamID[64];
  593.        
  594.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  595.         formatex(sQuery, charsmax(sQuery), "INSERT INTO `%s` (`SteamId`) VALUES (^"%s^");", Tablename, sSteamID);
  596.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  597.     }
  598.     public SelectDataTable(id)
  599.     {
  600.         static sQuery[10048];
  601.         new sData[1], sSteamID[64];
  602.         sData[0] = id;
  603.        
  604.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  605.        
  606.         formatex(sQuery, charsmax(sQuery), "SELECT * FROM `%s` WHERE SteamId = ^"%s^";", Tablename, sSteamID);
  607.         SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataTable", sQuery, sData, 1);
  608.     }
  609.     public QuerySelectDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  610.     {
  611.         if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  612.         {
  613.             log_amx("[Insert] Hiba:**!! %s !!**", sError);
  614.             return;
  615.         }
  616.         else
  617.         {
  618.             new id = sData[0];
  619.            
  620.             if(SQL_NumRows(sQuery) > 0)
  621.             {
  622.                 g_uPoints[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM4A1"));
  623.                 g_uPoints[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAK47"));
  624.                 g_uPoints[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAWP"));
  625.                 g_uPoints[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsSCOUT"));
  626.                 g_uPoints[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsFAMAS"));
  627.                 g_uPoints[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGALIL"));
  628.                 g_uPoints[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAUG"));
  629.                 g_uPoints[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM3"));
  630.                 g_uPoints[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsXM1014"));
  631.                 g_uPoints[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsKNIFE"));
  632.                 g_uPoints[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsDEAGLE"));
  633.                 g_uPoints[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsUSP"));
  634.                 g_uPoints[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGLOCK"));
  635.                 g_SelectedGun[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM4A1"));
  636.                 g_SelectedGun[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAK47"));
  637.                 g_SelectedGun[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAWP"));
  638.                 g_SelectedGun[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunSCOUT"));
  639.                 g_SelectedGun[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunFAMAS"));
  640.                 g_SelectedGun[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGALIL"));
  641.                 g_SelectedGun[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAUG"));
  642.                 g_SelectedGun[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM3"));
  643.                 g_SelectedGun[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunXM1014"));
  644.                 g_SelectedGun[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunKNIFE"));
  645.                 g_SelectedGun[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunDEAGLE"));
  646.                 g_SelectedGun[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunUSP"));
  647.                 g_SelectedGun[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGLOCK"));
  648.             }
  649.             else
  650.                 TableInsert(id);
  651.         }
  652.     }
  653.     public autoSave()
  654.     {
  655.         new pnum, id ,sSteamID[64];
  656.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  657.        
  658.         for(new i; i<pnum; i++)
  659.         {
  660.             id = sSteamID[i]  
  661.             set_task(random_float(0.2, 5.0), "TableUpdate", id)
  662.         }
  663.         return PLUGIN_HANDLED
  664.     }
  665.     public QuerySetDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  666.     {
  667.         if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  668.         {
  669.             log_amx("[SetData] Hiba:**!! %s !!**", sError);
  670.             return;
  671.         }
  672.     }

Szerző:  Csabika20034 [ 2022.10.09. 19:41 ]
Hozzászólás témája:  Re: Mód pls help

saxxo írta:
Sziasztok!

Olyan problémám van, fent van a mód a szerveren,de ha letölti a dolgokat a szerverről (pl: pálya,körvégi,chathangok,Skinek!) Akkor a mentett dolgok eltünnek

Köszönöm Előre is!

  1. #include <amxmodx>
  2.     #include <engine>
  3.     #include <fakemeta>
  4.     #include <cstrike>
  5.     #include <sqlx>
  6.      
  7.     #define PLUGIN "New Plug-In"
  8.     #define VERSION "1.0"
  9.     #define AUTHOR "author"
  10.      
  11.     #define KILL_POINT 1
  12.     #define HEADSHOT_POINT 5
  13.     #define Tablename "Hlmodra_tabla_1" //SQL Tábla neve!//
  14.      
  15.     enum _:GunDatas {
  16.         M4A1,
  17.         AK47,
  18.         AWP,
  19.         SCOUT,
  20.         FAMAS,
  21.         GALIL,
  22.         AUG,
  23.         M3,
  24.         XM1014,
  25.         KNIFE,
  26.         DEAGLE,
  27.         USP,
  28.         GLOCK
  29.     }
  30.     new g_SelectedGun[33][GunDatas], g_uPoints[33][GunDatas], g_Wpn[33];
  31.     new sSteamID[64];
  32.      
  33.     new const gMenuPrefix[] = "\w[<<< Night~Warrior >>>]~\y»\yFun";
  34.     new const gChatPrefix[] = "[<<< Night~Warrior >>>]"
  35.      
  36.     enum _:DATA {
  37.         GunName[64],
  38.         ModelName[64],
  39.         Points[8]
  40.     }
  41.     new const WeaponM4A1[][DATA] = {
  42.         {"M4A1 | Default", "models/v_m4a1.mdl", 0, },
  43.     }
  44.     new const WeaponAK47[][DATA] = {
  45.         {"AK47 | Default", "models/v_ak47.mdl", 0, },
  46.     }
  47.     new const WeaponAWP[][DATA] = {
  48.         {"AWP | Default", "models/v_awp.mdl", 0, },
  49.     }
  50.     new const WeaponSCOUT[][DATA] = {
  51.         {"SCOUT | Default", "models/v_scout.mdl", 0, },
  52.     }
  53.     new const WeaponFAMAS[][DATA] = {
  54.         {"FAMAS | Default", "models/v_famas.mdl", 0, },
  55.     }
  56.     new const WeaponGALIL[][DATA] = {
  57.         {"GALIL | Default", "models/v_galil.mdl", 0, },
  58.     }
  59.     new const WeaponAUG[][DATA] = {
  60.         {"AUG | Default", "models/v_aug.mdl", 0, },
  61.     }
  62.     new const WeaponM3[][DATA] = {
  63.         {"M3 | Default", "models/v_m3.mdl", 0, },
  64.     }
  65.     new const WeaponXM1014[][DATA] = {
  66.         {"XM1014 | Default", "models/v_xm1014.mdl", 0, },
  67.     }
  68.     new const WeaponKNIFE[][DATA] = {
  69.         {"KNIFE | Default", "models/v_knife.mdl", 0, },
  70.     }
  71.     new const WeaponDEAGLE[][DATA] = {
  72.         {"DEAGLE | Default", "models/v_deagle.mdl", 0, },
  73.     }
  74.     new const WeaponUSP[][DATA] = {
  75.         {"USP | Default", "models/v_usp.mdl", 0, },
  76.     }
  77.     new const WeaponGLOCK[][DATA] = {
  78.         {"GLOCK18 | Default", "models/v_glock18.mdl", 0, },
  79.     }  
  80.     new const MainStrings[][] = {
  81.         "M4A1 Skinek",
  82.         "AK47 Skinek",
  83.         "AWP Skinek",
  84.         "SCOUT Skinek",
  85.         "FAMAS Skinek",
  86.         "GALIL Skinek",
  87.         "AUG Skinek",
  88.         "M3 Skinek",
  89.         "XM1014 Skinek",
  90.         "KNIFE Skinek",
  91.         "DEAGLE Skinek",
  92.         "USP Skinek",
  93.         "GLOCK18 Skinek"
  94.     }
  95.     public plugin_init() {
  96.         register_plugin(PLUGIN, VERSION, AUTHOR)
  97.         register_clcmd("say /menu", "openMainMenu")
  98.         register_clcmd("say /add", "Addolas")
  99.        
  100.         register_impulse(201, "openMainMenu");
  101.        
  102.         register_event("DeathMsg","Halal","a")
  103.         register_event("CurWeapon", "evChangeWeapon", "be", "1=1")
  104.        
  105.         set_task(15.0,"autoSave",.flags="b")
  106.     }
  107.     public Addolas(id)
  108.     {
  109.         g_uPoints[id][M4A1] += 50
  110.         g_uPoints[id][AK47] += 50
  111.         g_uPoints[id][AWP] += 50
  112.         g_uPoints[id][SCOUT] += 50
  113.         g_uPoints[id][FAMAS] += 50
  114.         g_uPoints[id][GALIL] += 50
  115.         g_uPoints[id][AUG] += 50
  116.         g_uPoints[id][M3] += 50
  117.         g_uPoints[id][XM1014] += 50
  118.         g_uPoints[id][KNIFE] += 50
  119.         g_uPoints[id][DEAGLE] += 50
  120.         g_uPoints[id][USP] += 50
  121.         g_uPoints[id][GLOCK] += 50;
  122.     }
  123.     public plugin_precache() {
  124.         for(new i;i < sizeof(WeaponM4A1); i++) precache_model(WeaponM4A1[i][ModelName])
  125.         for(new i;i < sizeof(WeaponAK47); i++) precache_model(WeaponAK47[i][ModelName])
  126.         for(new i;i < sizeof(WeaponAWP); i++) precache_model(WeaponAWP[i][ModelName])
  127.         for(new i;i < sizeof(WeaponSCOUT); i++) precache_model(WeaponSCOUT[i][ModelName])
  128.         for(new i;i < sizeof(WeaponFAMAS); i++) precache_model(WeaponFAMAS[i][ModelName])
  129.         for(new i;i < sizeof(WeaponGALIL); i++) precache_model(WeaponGALIL[i][ModelName])
  130.         for(new i;i < sizeof(WeaponAUG); i++) precache_model(WeaponAUG[i][ModelName])
  131.         for(new i;i < sizeof(WeaponM3); i++) precache_model(WeaponM3[i][ModelName])
  132.         for(new i;i < sizeof(WeaponXM1014); i++) precache_model(WeaponXM1014[i][ModelName])
  133.         for(new i;i < sizeof(WeaponKNIFE); i++) precache_model(WeaponKNIFE[i][ModelName])
  134.         for(new i;i < sizeof(WeaponDEAGLE); i++) precache_model(WeaponDEAGLE[i][ModelName])
  135.         for(new i;i < sizeof(WeaponUSP); i++) precache_model(WeaponUSP[i][ModelName])
  136.         for(new i;i < sizeof(WeaponGLOCK); i++) precache_model(WeaponGLOCK[i][ModelName])
  137.     }
  138.     public evChangeWeapon(id) {
  139.         switch(get_user_weapon(id)) {
  140.             case CSW_M4A1: entity_set_string(id, EV_SZ_viewmodel, WeaponM4A1[g_SelectedGun[id][M4A1]][ModelName]);
  141.                 case CSW_AK47: entity_set_string(id, EV_SZ_viewmodel, WeaponAK47[g_SelectedGun[id][AK47]][ModelName]);
  142.                 case CSW_AWP: entity_set_string(id, EV_SZ_viewmodel, WeaponAWP[g_SelectedGun[id][AWP]][ModelName]);
  143.                 case CSW_SCOUT: entity_set_string(id, EV_SZ_viewmodel, WeaponSCOUT[g_SelectedGun[id][SCOUT]][ModelName]);
  144.                 case CSW_FAMAS: entity_set_string(id, EV_SZ_viewmodel, WeaponFAMAS[g_SelectedGun[id][FAMAS]][ModelName]);
  145.                 case CSW_GALIL: entity_set_string(id, EV_SZ_viewmodel, WeaponGALIL[g_SelectedGun[id][GALIL]][ModelName]);
  146.                 case CSW_AUG: entity_set_string(id, EV_SZ_viewmodel, WeaponAUG[g_SelectedGun[id][AUG]][ModelName]);
  147.                 case CSW_M3: entity_set_string(id, EV_SZ_viewmodel, WeaponM3[g_SelectedGun[id][M3]][ModelName]);
  148.                 case CSW_XM1014: entity_set_string(id, EV_SZ_viewmodel, WeaponXM1014[g_SelectedGun[id][XM1014]][ModelName]);
  149.                 case CSW_KNIFE: entity_set_string(id, EV_SZ_viewmodel, WeaponKNIFE[g_SelectedGun[id][KNIFE]][ModelName]);
  150.                 case CSW_DEAGLE: entity_set_string(id, EV_SZ_viewmodel, WeaponDEAGLE[g_SelectedGun[id][DEAGLE]][ModelName]);
  151.                 case CSW_USP: entity_set_string(id, EV_SZ_viewmodel, WeaponUSP[g_SelectedGun[id][USP]][ModelName]);
  152.                 case CSW_GLOCK18: entity_set_string(id, EV_SZ_viewmodel, WeaponGLOCK[g_SelectedGun[id][GLOCK]][ModelName]);
  153.             }
  154.         return PLUGIN_CONTINUE
  155.     }
  156.     public Halal() {
  157.        
  158.         new iAttacker = read_data(1)
  159.         new iVictim = read_data(2)
  160.         new iHs = read_data(3)
  161.        
  162.         if(iAttacker == iVictim || iAttacker == 0) return PLUGIN_HANDLED
  163.         new iPoints = iHs ? HEADSHOT_POINT : KILL_POINT
  164.        
  165.         switch(get_user_weapon(iAttacker)) {
  166.             case CSW_M4A1: g_uPoints[iAttacker][M4A1] += iPoints
  167.                 case CSW_AK47: g_uPoints[iAttacker][AK47] += iPoints
  168.                 case CSW_AWP: g_uPoints[iAttacker][AWP] += iPoints
  169.                 case CSW_SCOUT: g_uPoints[iAttacker][SCOUT] += iPoints
  170.                 case CSW_FAMAS: g_uPoints[iAttacker][FAMAS] += iPoints
  171.                 case CSW_GALIL: g_uPoints[iAttacker][GALIL] += iPoints
  172.                 case CSW_AUG: g_uPoints[iAttacker][AUG] += iPoints
  173.                 case CSW_M3: g_uPoints[iAttacker][M3] += iPoints
  174.                 case CSW_XM1014: g_uPoints[iAttacker][XM1014] += iPoints
  175.                 case CSW_KNIFE: g_uPoints[iAttacker][KNIFE] += iPoints
  176.                 case CSW_DEAGLE: g_uPoints[iAttacker][DEAGLE] += iPoints
  177.                 case CSW_USP: g_uPoints[iAttacker][USP] += iPoints
  178.                 case CSW_GLOCK18: g_uPoints[iAttacker][GLOCK] += iPoints
  179.             }
  180.         set_hudmessage(random(256), random(256), random(256), -1.0, 0.20, 0, 6.0, 3.0);
  181.         show_hudmessage(iAttacker, "+%i Pont", iPoints);
  182.         return PLUGIN_CONTINUE;
  183.     }
  184.     public openMainMenu(id) {
  185.         new szMenu[121], String[6]
  186.         formatex(szMenu, charsmax(szMenu), "%s \wFőMenü", gChatPrefix);
  187.         new menu = menu_create(szMenu, "hMainMenu");
  188.        
  189.         for(new i ;i < sizeof(MainStrings); i++) {
  190.             num_to_str(i, String, 5)
  191.             formatex(szMenu, charsmax(szMenu), MainStrings[i]);
  192.             menu_additem(menu, szMenu, String);
  193.         }
  194.         menu_display(id, menu, 0);
  195.         return PLUGIN_HANDLED;
  196.     }
  197.     public hMainMenu(id, menu, item) {
  198.         if(item == MENU_EXIT) {
  199.             menu_destroy(menu);
  200.             return PLUGIN_HANDLED;
  201.         }
  202.         g_Wpn[id] = item+1
  203.         openSkinMenu(id)
  204.         menu_destroy(menu);
  205.         return PLUGIN_HANDLED;
  206.     }
  207.     public openSkinMenu(id) {
  208.         new szMenu[121], szMenu2[64], String[6]
  209.         if(g_Wpn[id] == 1) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][M4A1])
  210.         else if(g_Wpn[id] == 2) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AK47])
  211.             else if(g_Wpn[id] == 3) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AWP])
  212.             else if(g_Wpn[id] == 4) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][SCOUT])
  213.             else if(g_Wpn[id] == 5) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][FAMAS])
  214.             else if(g_Wpn[id] == 6) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][GALIL])
  215.             else if(g_Wpn[id] == 7) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AUG])
  216.             else if(g_Wpn[id] == 8) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][M3])
  217.             else if(g_Wpn[id] == 9) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][XM1014])
  218.             else if(g_Wpn[id] == 10) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][KNIFE])
  219.             else if(g_Wpn[id] == 11) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][DEAGLE])
  220.             else if(g_Wpn[id] == 12) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][USP])
  221.             else if(g_Wpn[id] == 13) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][GLOCK])
  222.         new menu = menu_create(szMenu, "hSkinChooser");
  223.         if(g_Wpn[id] == 1) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  224.         MainStrings[g_Wpn[id]-1], g_uPoints[id][M4A1])
  225.         if(g_Wpn[id] == 2) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  226.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AK47])
  227.         if(g_Wpn[id] == 3) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  228.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AWP])
  229.         if(g_Wpn[id] == 4) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  230.         MainStrings[g_Wpn[id]-1], g_uPoints[id][SCOUT])
  231.         if(g_Wpn[id] == 5) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  232.         MainStrings[g_Wpn[id]-1], g_uPoints[id][FAMAS])
  233.         if(g_Wpn[id] == 6) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  234.         MainStrings[g_Wpn[id]-1], g_uPoints[id][GALIL])
  235.         if(g_Wpn[id] == 7) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  236.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AUG])
  237.         if(g_Wpn[id] == 8) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  238.         MainStrings[g_Wpn[id]-1], g_uPoints[id][M3])
  239.         if(g_Wpn[id] == 9) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  240.         MainStrings[g_Wpn[id]-1], g_uPoints[id][XM1014])
  241.         if(g_Wpn[id] == 10) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  242.         MainStrings[g_Wpn[id]-1], g_uPoints[id][KNIFE])
  243.         if(g_Wpn[id] == 11) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  244.         MainStrings[g_Wpn[id]-1], g_uPoints[id][DEAGLE])
  245.         if(g_Wpn[id] == 12) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  246.         MainStrings[g_Wpn[id]-1], g_uPoints[id][USP])
  247.         if(g_Wpn[id] == 13) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  248.         MainStrings[g_Wpn[id]-1], g_uPoints[id][GLOCK])
  249.        
  250.         if(g_Wpn[id] == 1) {
  251.             for(new i; i < sizeof(WeaponM4A1); i++) {
  252.                 num_to_str(i, String, 5)
  253.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponM4A1[i][Points]);
  254.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponM4A1[i][GunName], g_SelectedGun[id][M4A1] == i ? "\y{Kiválasztva}": szMenu2);
  255.                 menu_additem(menu, szMenu, String);
  256.             }
  257.         }
  258.         else if(g_Wpn[id] == 2) {
  259.             for(new i; i < sizeof(WeaponAK47); i++) {
  260.                 num_to_str(i, String, 5)
  261.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAK47[i][Points]);
  262.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAK47[i][GunName], g_SelectedGun[id][AK47] == i ? "\y{Kiválasztva}": szMenu2);
  263.                 menu_additem(menu, szMenu, String);
  264.             }
  265.         }
  266.         else if(g_Wpn[id] == 3) {
  267.             for(new i; i < sizeof(WeaponAWP); i++) {
  268.                 num_to_str(i, String, 5)
  269.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAWP[i][Points]);
  270.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAWP[i][GunName], g_SelectedGun[id][AWP] == i ? "\y{Kiválasztva}": szMenu2);
  271.                 menu_additem(menu, szMenu, String);
  272.             }
  273.         }
  274.         else if(g_Wpn[id] == 4) {
  275.             for(new i; i < sizeof(WeaponSCOUT); i++) {
  276.                 num_to_str(i, String, 5)
  277.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponSCOUT[i][Points]);
  278.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponSCOUT[i][GunName], g_SelectedGun[id][SCOUT] == i ? "\y{Kiválasztva}": szMenu2);
  279.                 menu_additem(menu, szMenu, String);
  280.             }
  281.         }
  282.         else if(g_Wpn[id] == 5) {
  283.             for(new i; i < sizeof(WeaponFAMAS); i++) {
  284.                 num_to_str(i, String, 5)
  285.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponFAMAS[i][Points]);
  286.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponFAMAS[i][GunName], g_SelectedGun[id][FAMAS] == i ? "\y{Kiválasztva}": szMenu2);
  287.                 menu_additem(menu, szMenu, String);
  288.             }
  289.         }
  290.         else if(g_Wpn[id] == 6) {
  291.             for(new i; i < sizeof(WeaponGALIL); i++) {
  292.                 num_to_str(i, String, 5)
  293.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponGALIL[i][Points]);
  294.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponGALIL[i][GunName], g_SelectedGun[id][GALIL] == i ? "\y{Kiválasztva}": szMenu2);
  295.                 menu_additem(menu, szMenu, String);
  296.             }
  297.         }
  298.         else if(g_Wpn[id] == 7) {
  299.             for(new i; i < sizeof(WeaponAUG); i++) {
  300.                 num_to_str(i, String, 5)
  301.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAUG[i][Points]);
  302.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAUG[i][GunName], g_SelectedGun[id][AUG] == i ? "\y{Kiválasztva}": szMenu2);
  303.                 menu_additem(menu, szMenu, String);
  304.             }
  305.         }
  306.         else if(g_Wpn[id] == 8) {
  307.             for(new i; i < sizeof(WeaponM3); i++) {
  308.                 num_to_str(i, String, 5)
  309.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponM3[i][Points]);
  310.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponM3[i][GunName], g_SelectedGun[id][M3] == i ? "\y{Kiválasztva}": szMenu2);
  311.                 menu_additem(menu, szMenu, String);
  312.             }
  313.         }
  314.         else if(g_Wpn[id] == 9) {
  315.             for(new i; i < sizeof(WeaponXM1014); i++) {
  316.                 num_to_str(i, String, 5)
  317.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponXM1014[i][Points]);
  318.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponXM1014[i][GunName], g_SelectedGun[id][XM1014] == i ? "\y{Kiválasztva}": szMenu2);
  319.                 menu_additem(menu, szMenu, String);
  320.             }
  321.         }
  322.         else if(g_Wpn[id] == 10) {
  323.             for(new i; i < sizeof(WeaponKNIFE); i++) {
  324.                 num_to_str(i, String, 5)
  325.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponKNIFE[i][Points]);
  326.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponKNIFE[i][GunName], g_SelectedGun[id][KNIFE] == i ? "\y{Kiválasztva}": szMenu2);
  327.                 menu_additem(menu, szMenu, String);
  328.             }
  329.         }
  330.         else if(g_Wpn[id] == 11) {
  331.             for(new i; i < sizeof(WeaponDEAGLE); i++) {
  332.                 num_to_str(i, String, 5)
  333.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponDEAGLE[i][Points]);
  334.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponDEAGLE[i][GunName], g_SelectedGun[id][DEAGLE] == i ? "\y{Kiválasztva}": szMenu2);
  335.                 menu_additem(menu, szMenu, String);
  336.             }
  337.         }
  338.         else if(g_Wpn[id] == 12) {
  339.             for(new i; i < sizeof(WeaponUSP); i++) {
  340.                 num_to_str(i, String, 5)
  341.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponUSP[i][Points]);
  342.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponUSP[i][GunName], g_SelectedGun[id][USP] == i ? "\y{Kiválasztva}": szMenu2);
  343.                 menu_additem(menu, szMenu, String);
  344.             }
  345.         }
  346.         else if(g_Wpn[id] == 13) {
  347.             for(new i; i < sizeof(WeaponGLOCK); i++) {
  348.                 num_to_str(i, String, 5)
  349.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponGLOCK[i][Points]);
  350.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponGLOCK[i][GunName], g_SelectedGun[id][GLOCK] == i ? "\y{Kiválasztva}": szMenu2);
  351.                 menu_additem(menu, szMenu, String);
  352.             }
  353.         }
  354.         menu_display(id, menu, 0);
  355.         return PLUGIN_HANDLED;
  356.     }
  357.     public hSkinChooser(id, menu, item) {
  358.         if(item == MENU_EXIT)
  359.         {
  360.             menu_destroy(menu);
  361.             return PLUGIN_CONTINUE;
  362.         }
  363.         switch(g_Wpn[id]) {
  364.             case 1: {
  365.                 if(g_uPoints[id][M4A1] >= WeaponM4A1[item][Points]) {
  366.                     g_SelectedGun[id][M4A1] = item
  367.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  368.                 }
  369.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  370.             }
  371.             case 2: {
  372.                 if(g_uPoints[id][AK47] >= WeaponAK47[item][Points]) {
  373.                     g_SelectedGun[id][AK47] = item
  374.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  375.                 }
  376.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  377.             }
  378.             case 3: {
  379.                 if(g_uPoints[id][AWP] >= WeaponAWP[item][Points]) {
  380.                     g_SelectedGun[id][AWP] = item
  381.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  382.                 }
  383.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  384.             }
  385.             case 4: {
  386.                 if(g_uPoints[id][SCOUT] >= WeaponSCOUT[item][Points]) {
  387.                     g_SelectedGun[id][SCOUT] = item
  388.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  389.                 }
  390.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  391.             }
  392.             case 5: {
  393.                 if(g_uPoints[id][FAMAS] >= WeaponFAMAS[item][Points]) {
  394.                     g_SelectedGun[id][FAMAS] = item
  395.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  396.                 }
  397.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  398.             }
  399.             case 6: {
  400.                 if(g_uPoints[id][GALIL] >= WeaponGALIL[item][Points]) {
  401.                     g_SelectedGun[id][GALIL] = item
  402.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  403.                 }
  404.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  405.             }
  406.             case 7: {
  407.                 if(g_uPoints[id][AUG] >= WeaponAUG[item][Points]) {
  408.                     g_SelectedGun[id][AUG] = item
  409.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  410.                 }
  411.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  412.             }
  413.             case 8: {
  414.                 if(g_uPoints[id][M3] >= WeaponM3[item][Points]) {
  415.                     g_SelectedGun[id][M3] = item
  416.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  417.                 }
  418.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  419.             }
  420.             case 9: {
  421.                 if(g_uPoints[id][XM1014] >= WeaponXM1014[item][Points]) {
  422.                     g_SelectedGun[id][XM1014] = item
  423.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  424.                 }
  425.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  426.             }
  427.             case 10: {
  428.                 if(g_uPoints[id][KNIFE] >= WeaponKNIFE[item][Points]) {
  429.                     g_SelectedGun[id][KNIFE] = item
  430.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  431.                 }
  432.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  433.             }
  434.             case 11: {
  435.                 if(g_uPoints[id][DEAGLE] >= WeaponDEAGLE[item][Points]) {
  436.                     g_SelectedGun[id][DEAGLE] = item
  437.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  438.                 }
  439.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  440.             }
  441.             case 12: {
  442.                 if(g_uPoints[id][USP] >= WeaponUSP[item][Points]) {
  443.                     g_SelectedGun[id][USP] = item
  444.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  445.                 }
  446.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  447.             }
  448.             case 13: {
  449.                 if(g_uPoints[id][GLOCK] >= WeaponGLOCK[item][Points]) {
  450.                     g_SelectedGun[id][GLOCK] = item
  451.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  452.                 }
  453.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  454.             }
  455.         }
  456.         menu_destroy(menu);
  457.         return PLUGIN_HANDLED;
  458.     }
  459.     public client_putinserver(id)
  460.     {
  461.         if(is_user_bot(id))
  462.             return;
  463.        
  464.         g_uPoints[id][M4A1] = 0;
  465.         g_uPoints[id][AK47] = 0;
  466.         g_uPoints[id][AWP] = 0;
  467.         g_uPoints[id][SCOUT] = 0;
  468.         g_uPoints[id][FAMAS] = 0;
  469.         g_uPoints[id][GALIL] = 0;
  470.         g_uPoints[id][AUG] = 0;
  471.         g_uPoints[id][M3] = 0;
  472.         g_uPoints[id][XM1014] = 0;
  473.         g_uPoints[id][KNIFE] = 0;
  474.         g_uPoints[id][DEAGLE] = 0;
  475.         g_uPoints[id][USP] = 0;
  476.         g_uPoints[id][GLOCK] = 0;
  477.         g_SelectedGun[id][M4A1] = 0;
  478.         g_SelectedGun[id][AK47] = 0;
  479.         g_SelectedGun[id][AWP] = 0;
  480.         g_SelectedGun[id][SCOUT] = 0;
  481.         g_SelectedGun[id][FAMAS] = 0;
  482.         g_SelectedGun[id][GALIL] = 0;
  483.         g_SelectedGun[id][AUG] = 0;
  484.         g_SelectedGun[id][M3] = 0;
  485.         g_SelectedGun[id][XM1014] = 0;
  486.         g_SelectedGun[id][KNIFE] = 0;
  487.         g_SelectedGun[id][DEAGLE] = 0;
  488.         g_SelectedGun[id][USP] = 0;
  489.         g_SelectedGun[id][GLOCK] = 0;
  490.        
  491.         SelectDataTable(id);
  492.     }
  493.     public client_disconnected(id)
  494.     {
  495.         if(is_user_bot(id))
  496.             return;
  497.        
  498.         TableUpdate(id);
  499.     }
  500.     new Handle:g_SqlTuple;
  501.     public plugin_cfg()
  502.     {
  503.         //Kiszolgáló | Felhasználó | Jelszó | Adatbázis
  504.        
  505.         g_SqlTuple = SQL_MakeDbTuple("maria.srkhost.eu", "", "", "s17878_newszerver");
  506.         CreateTable();
  507.     }
  508.     public CreateTable(){
  509.         new iLen;
  510.         static sQuery[10048];
  511.        
  512.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "CREATE TABLE IF NOT EXISTS `%s` ", Tablename);
  513.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "( ");
  514.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
  515.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`SteamId` varchar(64) NOT NULL,");
  516.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM4A1` int(11) NOT NULL,");
  517.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAK47` int(11) NOT NULL,");
  518.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAWP` int(11) NOT NULL,");
  519.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsSCOUT` int(11) NOT NULL,");
  520.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsFAMAS` int(11) NOT NULL,");
  521.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGALIL` int(11) NOT NULL,");
  522.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAUG` int(11) NOT NULL,");
  523.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM3` int(11) NOT NULL,");
  524.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsXM1014` int(11) NOT NULL,");
  525.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsKNIFE` int(11) NOT NULL,");
  526.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  527.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsUSP` int(11) NOT NULL,");
  528.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGLOCK` int(11) NOT NULL,");
  529.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  530.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAK47` int(11) NOT NULL,");
  531.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAWP` int(11) NOT NULL,");
  532.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  533.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  534.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  535.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAUG` int(11) NOT NULL,");
  536.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM3` int(11) NOT NULL,");
  537.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  538.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  539.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  540.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunUSP` int(11) NOT NULL,");
  541.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGLOCK` int(11) NOT NULL)");
  542.        
  543.         SQL_ThreadQuery(g_SqlTuple, "TableCreateThread", sQuery);
  544.     }
  545.     public TableUpdate(id)
  546.     {
  547.         static sQuery[10048];
  548.         new iLen, sSteamID[64];
  549.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  550.        
  551.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "UPDATE `%s` SET ", Tablename);
  552.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM4A1 = ^"%i^",", g_uPoints[id][M4A1]);
  553.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAK47 = ^"%i^",", g_uPoints[id][AK47]);
  554.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAWP = ^"%i^",", g_uPoints[id][AWP]);
  555.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsSCOUT = ^"%i^",", g_uPoints[id][SCOUT]);
  556.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsFAMAS = ^"%i^",", g_uPoints[id][FAMAS]);
  557.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGALIL = ^"%i^",", g_uPoints[id][GALIL]);
  558.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAUG = ^"%i^",", g_uPoints[id][AUG]);
  559.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM3 = ^"%i^",", g_uPoints[id][M3]);
  560.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsXM1014 = ^"%i^",", g_uPoints[id][XM1014]);
  561.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsKNIFE = ^"%i^",", g_uPoints[id][KNIFE]);
  562.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsDEAGLE = ^"%i^",", g_uPoints[id][DEAGLE]);
  563.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsUSP = ^"%i^",", g_uPoints[id][USP]);
  564.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGLOCK = ^"%i^",", g_uPoints[id][GLOCK]);
  565.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAK47 = ^"%i^",", g_SelectedGun[id][AK47]);
  566.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAWP = ^"%i^",", g_SelectedGun[id][AWP]);
  567.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunSCOUT = ^"%i^",", g_SelectedGun[id][SCOUT]);
  568.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunFAMAS = ^"%i^",", g_SelectedGun[id][FAMAS]);
  569.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGALIL = ^"%i^",", g_SelectedGun[id][GALIL]);
  570.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAUG = ^"%i^",", g_SelectedGun[id][AUG]);
  571.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM3 = ^"%i^",", g_SelectedGun[id][M3]);
  572.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunXM1014 = ^"%i^",", g_SelectedGun[id][XM1014]);
  573.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunKNIFE = ^"%i^",", g_SelectedGun[id][KNIFE]);
  574.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunDEAGLE = ^"%i^",", g_SelectedGun[id][DEAGLE]);
  575.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunUSP = ^"%i^",", g_SelectedGun[id][USP]);
  576.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGLOCK = ^"%i^",", g_SelectedGun[id][GLOCK]);
  577.        
  578.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM4A1 = ^"%i^" WHERE `SteamId` = ^"%s^";", g_SelectedGun[id][M4A1], sSteamID);
  579.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  580.     }
  581.     public TableCreateThread(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  582.     {
  583.         if(iFailState == TQUERY_CONNECT_FAILED)
  584.             set_fail_state("[Create] Nem lehet csatlakozni az adatbazishoz!");
  585.         else if(iFailState == TQUERY_QUERY_FAILED)
  586.             set_fail_state("[Create] Lekerdezesi hiba");
  587.         if(iErrcode)
  588.             log_amx("[Create] Hiba:**!! %s !!**", sError);
  589.     }
  590.     public TableInsert(id)
  591.     {
  592.         static sQuery[10048], sSteamID[64];
  593.        
  594.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  595.         formatex(sQuery, charsmax(sQuery), "INSERT INTO `%s` (`SteamId`) VALUES (^"%s^");", Tablename, sSteamID);
  596.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  597.     }
  598.     public SelectDataTable(id)
  599.     {
  600.         static sQuery[10048];
  601.         new sData[1], sSteamID[64];
  602.         sData[0] = id;
  603.        
  604.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  605.        
  606.         formatex(sQuery, charsmax(sQuery), "SELECT * FROM `%s` WHERE SteamId = ^"%s^";", Tablename, sSteamID);
  607.         SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataTable", sQuery, sData, 1);
  608.     }
  609.     public QuerySelectDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  610.     {
  611.         if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  612.         {
  613.             log_amx("[Insert] Hiba:**!! %s !!**", sError);
  614.             return;
  615.         }
  616.         else
  617.         {
  618.             new id = sData[0];
  619.            
  620.             if(SQL_NumRows(sQuery) > 0)
  621.             {
  622.                 g_uPoints[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM4A1"));
  623.                 g_uPoints[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAK47"));
  624.                 g_uPoints[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAWP"));
  625.                 g_uPoints[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsSCOUT"));
  626.                 g_uPoints[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsFAMAS"));
  627.                 g_uPoints[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGALIL"));
  628.                 g_uPoints[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAUG"));
  629.                 g_uPoints[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM3"));
  630.                 g_uPoints[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsXM1014"));
  631.                 g_uPoints[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsKNIFE"));
  632.                 g_uPoints[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsDEAGLE"));
  633.                 g_uPoints[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsUSP"));
  634.                 g_uPoints[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGLOCK"));
  635.                 g_SelectedGun[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM4A1"));
  636.                 g_SelectedGun[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAK47"));
  637.                 g_SelectedGun[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAWP"));
  638.                 g_SelectedGun[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunSCOUT"));
  639.                 g_SelectedGun[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunFAMAS"));
  640.                 g_SelectedGun[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGALIL"));
  641.                 g_SelectedGun[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAUG"));
  642.                 g_SelectedGun[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM3"));
  643.                 g_SelectedGun[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunXM1014"));
  644.                 g_SelectedGun[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunKNIFE"));
  645.                 g_SelectedGun[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunDEAGLE"));
  646.                 g_SelectedGun[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunUSP"));
  647.                 g_SelectedGun[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGLOCK"));
  648.             }
  649.             else
  650.                 TableInsert(id);
  651.         }
  652.     }
  653.     public autoSave()
  654.     {
  655.         new pnum, id ,sSteamID[64];
  656.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  657.        
  658.         for(new i; i<pnum; i++)
  659.         {
  660.             id = sSteamID[i]  
  661.             set_task(random_float(0.2, 5.0), "TableUpdate", id)
  662.         }
  663.         return PLUGIN_HANDLED
  664.     }
  665.     public QuerySetDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  666.     {
  667.         if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  668.         {
  669.             log_amx("[SetData] Hiba:**!! %s !!**", sError);
  670.             return;
  671.         }
  672.     }


Helló!
Nem igaz már hogy nem tudod megoldani ezeket 100x felraktad ugyan ezeket ilyen témákkal.
Legalább 1x próbáld már meg ne más oldja meg helyeted, az ilyen kis dolgokat, ha nem megy akkor ne futass szervert.
Nem leszólás képp.

Szerző:  saxxo [ 2022.10.12. 15:54 ]
Hozzászólás témája:  Re: Mód pls help

Csabika20034 írta:
saxxo írta:
Sziasztok!

Olyan problémám van, fent van a mód a szerveren,de ha letölti a dolgokat a szerverről (pl: pálya,körvégi,chathangok,Skinek!) Akkor a mentett dolgok eltünnek

Köszönöm Előre is!

  1. #include <amxmodx>
  2.     #include <engine>
  3.     #include <fakemeta>
  4.     #include <cstrike>
  5.     #include <sqlx>
  6.      
  7.     #define PLUGIN "New Plug-In"
  8.     #define VERSION "1.0"
  9.     #define AUTHOR "author"
  10.      
  11.     #define KILL_POINT 1
  12.     #define HEADSHOT_POINT 5
  13.     #define Tablename "Hlmodra_tabla_1" //SQL Tábla neve!//
  14.      
  15.     enum _:GunDatas {
  16.         M4A1,
  17.         AK47,
  18.         AWP,
  19.         SCOUT,
  20.         FAMAS,
  21.         GALIL,
  22.         AUG,
  23.         M3,
  24.         XM1014,
  25.         KNIFE,
  26.         DEAGLE,
  27.         USP,
  28.         GLOCK
  29.     }
  30.     new g_SelectedGun[33][GunDatas], g_uPoints[33][GunDatas], g_Wpn[33];
  31.     new sSteamID[64];
  32.      
  33.     new const gMenuPrefix[] = "\w[<<< Night~Warrior >>>]~\y»\yFun";
  34.     new const gChatPrefix[] = "[<<< Night~Warrior >>>]"
  35.      
  36.     enum _:DATA {
  37.         GunName[64],
  38.         ModelName[64],
  39.         Points[8]
  40.     }
  41.     new const WeaponM4A1[][DATA] = {
  42.         {"M4A1 | Default", "models/v_m4a1.mdl", 0, },
  43.     }
  44.     new const WeaponAK47[][DATA] = {
  45.         {"AK47 | Default", "models/v_ak47.mdl", 0, },
  46.     }
  47.     new const WeaponAWP[][DATA] = {
  48.         {"AWP | Default", "models/v_awp.mdl", 0, },
  49.     }
  50.     new const WeaponSCOUT[][DATA] = {
  51.         {"SCOUT | Default", "models/v_scout.mdl", 0, },
  52.     }
  53.     new const WeaponFAMAS[][DATA] = {
  54.         {"FAMAS | Default", "models/v_famas.mdl", 0, },
  55.     }
  56.     new const WeaponGALIL[][DATA] = {
  57.         {"GALIL | Default", "models/v_galil.mdl", 0, },
  58.     }
  59.     new const WeaponAUG[][DATA] = {
  60.         {"AUG | Default", "models/v_aug.mdl", 0, },
  61.     }
  62.     new const WeaponM3[][DATA] = {
  63.         {"M3 | Default", "models/v_m3.mdl", 0, },
  64.     }
  65.     new const WeaponXM1014[][DATA] = {
  66.         {"XM1014 | Default", "models/v_xm1014.mdl", 0, },
  67.     }
  68.     new const WeaponKNIFE[][DATA] = {
  69.         {"KNIFE | Default", "models/v_knife.mdl", 0, },
  70.     }
  71.     new const WeaponDEAGLE[][DATA] = {
  72.         {"DEAGLE | Default", "models/v_deagle.mdl", 0, },
  73.     }
  74.     new const WeaponUSP[][DATA] = {
  75.         {"USP | Default", "models/v_usp.mdl", 0, },
  76.     }
  77.     new const WeaponGLOCK[][DATA] = {
  78.         {"GLOCK18 | Default", "models/v_glock18.mdl", 0, },
  79.     }  
  80.     new const MainStrings[][] = {
  81.         "M4A1 Skinek",
  82.         "AK47 Skinek",
  83.         "AWP Skinek",
  84.         "SCOUT Skinek",
  85.         "FAMAS Skinek",
  86.         "GALIL Skinek",
  87.         "AUG Skinek",
  88.         "M3 Skinek",
  89.         "XM1014 Skinek",
  90.         "KNIFE Skinek",
  91.         "DEAGLE Skinek",
  92.         "USP Skinek",
  93.         "GLOCK18 Skinek"
  94.     }
  95.     public plugin_init() {
  96.         register_plugin(PLUGIN, VERSION, AUTHOR)
  97.         register_clcmd("say /menu", "openMainMenu")
  98.         register_clcmd("say /add", "Addolas")
  99.        
  100.         register_impulse(201, "openMainMenu");
  101.        
  102.         register_event("DeathMsg","Halal","a")
  103.         register_event("CurWeapon", "evChangeWeapon", "be", "1=1")
  104.        
  105.         set_task(15.0,"autoSave",.flags="b")
  106.     }
  107.     public Addolas(id)
  108.     {
  109.         g_uPoints[id][M4A1] += 50
  110.         g_uPoints[id][AK47] += 50
  111.         g_uPoints[id][AWP] += 50
  112.         g_uPoints[id][SCOUT] += 50
  113.         g_uPoints[id][FAMAS] += 50
  114.         g_uPoints[id][GALIL] += 50
  115.         g_uPoints[id][AUG] += 50
  116.         g_uPoints[id][M3] += 50
  117.         g_uPoints[id][XM1014] += 50
  118.         g_uPoints[id][KNIFE] += 50
  119.         g_uPoints[id][DEAGLE] += 50
  120.         g_uPoints[id][USP] += 50
  121.         g_uPoints[id][GLOCK] += 50;
  122.     }
  123.     public plugin_precache() {
  124.         for(new i;i < sizeof(WeaponM4A1); i++) precache_model(WeaponM4A1[i][ModelName])
  125.         for(new i;i < sizeof(WeaponAK47); i++) precache_model(WeaponAK47[i][ModelName])
  126.         for(new i;i < sizeof(WeaponAWP); i++) precache_model(WeaponAWP[i][ModelName])
  127.         for(new i;i < sizeof(WeaponSCOUT); i++) precache_model(WeaponSCOUT[i][ModelName])
  128.         for(new i;i < sizeof(WeaponFAMAS); i++) precache_model(WeaponFAMAS[i][ModelName])
  129.         for(new i;i < sizeof(WeaponGALIL); i++) precache_model(WeaponGALIL[i][ModelName])
  130.         for(new i;i < sizeof(WeaponAUG); i++) precache_model(WeaponAUG[i][ModelName])
  131.         for(new i;i < sizeof(WeaponM3); i++) precache_model(WeaponM3[i][ModelName])
  132.         for(new i;i < sizeof(WeaponXM1014); i++) precache_model(WeaponXM1014[i][ModelName])
  133.         for(new i;i < sizeof(WeaponKNIFE); i++) precache_model(WeaponKNIFE[i][ModelName])
  134.         for(new i;i < sizeof(WeaponDEAGLE); i++) precache_model(WeaponDEAGLE[i][ModelName])
  135.         for(new i;i < sizeof(WeaponUSP); i++) precache_model(WeaponUSP[i][ModelName])
  136.         for(new i;i < sizeof(WeaponGLOCK); i++) precache_model(WeaponGLOCK[i][ModelName])
  137.     }
  138.     public evChangeWeapon(id) {
  139.         switch(get_user_weapon(id)) {
  140.             case CSW_M4A1: entity_set_string(id, EV_SZ_viewmodel, WeaponM4A1[g_SelectedGun[id][M4A1]][ModelName]);
  141.                 case CSW_AK47: entity_set_string(id, EV_SZ_viewmodel, WeaponAK47[g_SelectedGun[id][AK47]][ModelName]);
  142.                 case CSW_AWP: entity_set_string(id, EV_SZ_viewmodel, WeaponAWP[g_SelectedGun[id][AWP]][ModelName]);
  143.                 case CSW_SCOUT: entity_set_string(id, EV_SZ_viewmodel, WeaponSCOUT[g_SelectedGun[id][SCOUT]][ModelName]);
  144.                 case CSW_FAMAS: entity_set_string(id, EV_SZ_viewmodel, WeaponFAMAS[g_SelectedGun[id][FAMAS]][ModelName]);
  145.                 case CSW_GALIL: entity_set_string(id, EV_SZ_viewmodel, WeaponGALIL[g_SelectedGun[id][GALIL]][ModelName]);
  146.                 case CSW_AUG: entity_set_string(id, EV_SZ_viewmodel, WeaponAUG[g_SelectedGun[id][AUG]][ModelName]);
  147.                 case CSW_M3: entity_set_string(id, EV_SZ_viewmodel, WeaponM3[g_SelectedGun[id][M3]][ModelName]);
  148.                 case CSW_XM1014: entity_set_string(id, EV_SZ_viewmodel, WeaponXM1014[g_SelectedGun[id][XM1014]][ModelName]);
  149.                 case CSW_KNIFE: entity_set_string(id, EV_SZ_viewmodel, WeaponKNIFE[g_SelectedGun[id][KNIFE]][ModelName]);
  150.                 case CSW_DEAGLE: entity_set_string(id, EV_SZ_viewmodel, WeaponDEAGLE[g_SelectedGun[id][DEAGLE]][ModelName]);
  151.                 case CSW_USP: entity_set_string(id, EV_SZ_viewmodel, WeaponUSP[g_SelectedGun[id][USP]][ModelName]);
  152.                 case CSW_GLOCK18: entity_set_string(id, EV_SZ_viewmodel, WeaponGLOCK[g_SelectedGun[id][GLOCK]][ModelName]);
  153.             }
  154.         return PLUGIN_CONTINUE
  155.     }
  156.     public Halal() {
  157.        
  158.         new iAttacker = read_data(1)
  159.         new iVictim = read_data(2)
  160.         new iHs = read_data(3)
  161.        
  162.         if(iAttacker == iVictim || iAttacker == 0) return PLUGIN_HANDLED
  163.         new iPoints = iHs ? HEADSHOT_POINT : KILL_POINT
  164.        
  165.         switch(get_user_weapon(iAttacker)) {
  166.             case CSW_M4A1: g_uPoints[iAttacker][M4A1] += iPoints
  167.                 case CSW_AK47: g_uPoints[iAttacker][AK47] += iPoints
  168.                 case CSW_AWP: g_uPoints[iAttacker][AWP] += iPoints
  169.                 case CSW_SCOUT: g_uPoints[iAttacker][SCOUT] += iPoints
  170.                 case CSW_FAMAS: g_uPoints[iAttacker][FAMAS] += iPoints
  171.                 case CSW_GALIL: g_uPoints[iAttacker][GALIL] += iPoints
  172.                 case CSW_AUG: g_uPoints[iAttacker][AUG] += iPoints
  173.                 case CSW_M3: g_uPoints[iAttacker][M3] += iPoints
  174.                 case CSW_XM1014: g_uPoints[iAttacker][XM1014] += iPoints
  175.                 case CSW_KNIFE: g_uPoints[iAttacker][KNIFE] += iPoints
  176.                 case CSW_DEAGLE: g_uPoints[iAttacker][DEAGLE] += iPoints
  177.                 case CSW_USP: g_uPoints[iAttacker][USP] += iPoints
  178.                 case CSW_GLOCK18: g_uPoints[iAttacker][GLOCK] += iPoints
  179.             }
  180.         set_hudmessage(random(256), random(256), random(256), -1.0, 0.20, 0, 6.0, 3.0);
  181.         show_hudmessage(iAttacker, "+%i Pont", iPoints);
  182.         return PLUGIN_CONTINUE;
  183.     }
  184.     public openMainMenu(id) {
  185.         new szMenu[121], String[6]
  186.         formatex(szMenu, charsmax(szMenu), "%s \wFőMenü", gChatPrefix);
  187.         new menu = menu_create(szMenu, "hMainMenu");
  188.        
  189.         for(new i ;i < sizeof(MainStrings); i++) {
  190.             num_to_str(i, String, 5)
  191.             formatex(szMenu, charsmax(szMenu), MainStrings[i]);
  192.             menu_additem(menu, szMenu, String);
  193.         }
  194.         menu_display(id, menu, 0);
  195.         return PLUGIN_HANDLED;
  196.     }
  197.     public hMainMenu(id, menu, item) {
  198.         if(item == MENU_EXIT) {
  199.             menu_destroy(menu);
  200.             return PLUGIN_HANDLED;
  201.         }
  202.         g_Wpn[id] = item+1
  203.         openSkinMenu(id)
  204.         menu_destroy(menu);
  205.         return PLUGIN_HANDLED;
  206.     }
  207.     public openSkinMenu(id) {
  208.         new szMenu[121], szMenu2[64], String[6]
  209.         if(g_Wpn[id] == 1) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][M4A1])
  210.         else if(g_Wpn[id] == 2) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AK47])
  211.             else if(g_Wpn[id] == 3) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AWP])
  212.             else if(g_Wpn[id] == 4) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][SCOUT])
  213.             else if(g_Wpn[id] == 5) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][FAMAS])
  214.             else if(g_Wpn[id] == 6) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][GALIL])
  215.             else if(g_Wpn[id] == 7) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][AUG])
  216.             else if(g_Wpn[id] == 8) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][M3])
  217.             else if(g_Wpn[id] == 9) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][XM1014])
  218.             else if(g_Wpn[id] == 10) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][KNIFE])
  219.             else if(g_Wpn[id] == 11) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][DEAGLE])
  220.             else if(g_Wpn[id] == 12) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][USP])
  221.             else if(g_Wpn[id] == 13) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix, MainStrings[g_Wpn[id]-1], g_uPoints[id][GLOCK])
  222.         new menu = menu_create(szMenu, "hSkinChooser");
  223.         if(g_Wpn[id] == 1) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  224.         MainStrings[g_Wpn[id]-1], g_uPoints[id][M4A1])
  225.         if(g_Wpn[id] == 2) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  226.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AK47])
  227.         if(g_Wpn[id] == 3) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  228.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AWP])
  229.         if(g_Wpn[id] == 4) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  230.         MainStrings[g_Wpn[id]-1], g_uPoints[id][SCOUT])
  231.         if(g_Wpn[id] == 5) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  232.         MainStrings[g_Wpn[id]-1], g_uPoints[id][FAMAS])
  233.         if(g_Wpn[id] == 6) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  234.         MainStrings[g_Wpn[id]-1], g_uPoints[id][GALIL])
  235.         if(g_Wpn[id] == 7) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  236.         MainStrings[g_Wpn[id]-1], g_uPoints[id][AUG])
  237.         if(g_Wpn[id] == 8) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  238.         MainStrings[g_Wpn[id]-1], g_uPoints[id][M3])
  239.         if(g_Wpn[id] == 9) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  240.         MainStrings[g_Wpn[id]-1], g_uPoints[id][XM1014])
  241.         if(g_Wpn[id] == 10) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  242.         MainStrings[g_Wpn[id]-1], g_uPoints[id][KNIFE])
  243.         if(g_Wpn[id] == 11) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  244.         MainStrings[g_Wpn[id]-1], g_uPoints[id][DEAGLE])
  245.         if(g_Wpn[id] == 12) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  246.         MainStrings[g_Wpn[id]-1], g_uPoints[id][USP])
  247.         if(g_Wpn[id] == 13) formatex(szMenu, charsmax(szMenu), "%s \w%s^n\wPontjaid: \y%i\d", gChatPrefix,
  248.         MainStrings[g_Wpn[id]-1], g_uPoints[id][GLOCK])
  249.        
  250.         if(g_Wpn[id] == 1) {
  251.             for(new i; i < sizeof(WeaponM4A1); i++) {
  252.                 num_to_str(i, String, 5)
  253.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponM4A1[i][Points]);
  254.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponM4A1[i][GunName], g_SelectedGun[id][M4A1] == i ? "\y{Kiválasztva}": szMenu2);
  255.                 menu_additem(menu, szMenu, String);
  256.             }
  257.         }
  258.         else if(g_Wpn[id] == 2) {
  259.             for(new i; i < sizeof(WeaponAK47); i++) {
  260.                 num_to_str(i, String, 5)
  261.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAK47[i][Points]);
  262.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAK47[i][GunName], g_SelectedGun[id][AK47] == i ? "\y{Kiválasztva}": szMenu2);
  263.                 menu_additem(menu, szMenu, String);
  264.             }
  265.         }
  266.         else if(g_Wpn[id] == 3) {
  267.             for(new i; i < sizeof(WeaponAWP); i++) {
  268.                 num_to_str(i, String, 5)
  269.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAWP[i][Points]);
  270.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAWP[i][GunName], g_SelectedGun[id][AWP] == i ? "\y{Kiválasztva}": szMenu2);
  271.                 menu_additem(menu, szMenu, String);
  272.             }
  273.         }
  274.         else if(g_Wpn[id] == 4) {
  275.             for(new i; i < sizeof(WeaponSCOUT); i++) {
  276.                 num_to_str(i, String, 5)
  277.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponSCOUT[i][Points]);
  278.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponSCOUT[i][GunName], g_SelectedGun[id][SCOUT] == i ? "\y{Kiválasztva}": szMenu2);
  279.                 menu_additem(menu, szMenu, String);
  280.             }
  281.         }
  282.         else if(g_Wpn[id] == 5) {
  283.             for(new i; i < sizeof(WeaponFAMAS); i++) {
  284.                 num_to_str(i, String, 5)
  285.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponFAMAS[i][Points]);
  286.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponFAMAS[i][GunName], g_SelectedGun[id][FAMAS] == i ? "\y{Kiválasztva}": szMenu2);
  287.                 menu_additem(menu, szMenu, String);
  288.             }
  289.         }
  290.         else if(g_Wpn[id] == 6) {
  291.             for(new i; i < sizeof(WeaponGALIL); i++) {
  292.                 num_to_str(i, String, 5)
  293.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponGALIL[i][Points]);
  294.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponGALIL[i][GunName], g_SelectedGun[id][GALIL] == i ? "\y{Kiválasztva}": szMenu2);
  295.                 menu_additem(menu, szMenu, String);
  296.             }
  297.         }
  298.         else if(g_Wpn[id] == 7) {
  299.             for(new i; i < sizeof(WeaponAUG); i++) {
  300.                 num_to_str(i, String, 5)
  301.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponAUG[i][Points]);
  302.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponAUG[i][GunName], g_SelectedGun[id][AUG] == i ? "\y{Kiválasztva}": szMenu2);
  303.                 menu_additem(menu, szMenu, String);
  304.             }
  305.         }
  306.         else if(g_Wpn[id] == 8) {
  307.             for(new i; i < sizeof(WeaponM3); i++) {
  308.                 num_to_str(i, String, 5)
  309.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponM3[i][Points]);
  310.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponM3[i][GunName], g_SelectedGun[id][M3] == i ? "\y{Kiválasztva}": szMenu2);
  311.                 menu_additem(menu, szMenu, String);
  312.             }
  313.         }
  314.         else if(g_Wpn[id] == 9) {
  315.             for(new i; i < sizeof(WeaponXM1014); i++) {
  316.                 num_to_str(i, String, 5)
  317.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponXM1014[i][Points]);
  318.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponXM1014[i][GunName], g_SelectedGun[id][XM1014] == i ? "\y{Kiválasztva}": szMenu2);
  319.                 menu_additem(menu, szMenu, String);
  320.             }
  321.         }
  322.         else if(g_Wpn[id] == 10) {
  323.             for(new i; i < sizeof(WeaponKNIFE); i++) {
  324.                 num_to_str(i, String, 5)
  325.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponKNIFE[i][Points]);
  326.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponKNIFE[i][GunName], g_SelectedGun[id][KNIFE] == i ? "\y{Kiválasztva}": szMenu2);
  327.                 menu_additem(menu, szMenu, String);
  328.             }
  329.         }
  330.         else if(g_Wpn[id] == 11) {
  331.             for(new i; i < sizeof(WeaponDEAGLE); i++) {
  332.                 num_to_str(i, String, 5)
  333.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponDEAGLE[i][Points]);
  334.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponDEAGLE[i][GunName], g_SelectedGun[id][DEAGLE] == i ? "\y{Kiválasztva}": szMenu2);
  335.                 menu_additem(menu, szMenu, String);
  336.             }
  337.         }
  338.         else if(g_Wpn[id] == 12) {
  339.             for(new i; i < sizeof(WeaponUSP); i++) {
  340.                 num_to_str(i, String, 5)
  341.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponUSP[i][Points]);
  342.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponUSP[i][GunName], g_SelectedGun[id][USP] == i ? "\y{Kiválasztva}": szMenu2);
  343.                 menu_additem(menu, szMenu, String);
  344.             }
  345.         }
  346.         else if(g_Wpn[id] == 13) {
  347.             for(new i; i < sizeof(WeaponGLOCK); i++) {
  348.                 num_to_str(i, String, 5)
  349.                 formatex(szMenu2, charsmax(szMenu2), "\r{%i} Ölés", WeaponGLOCK[i][Points]);
  350.                 formatex(szMenu, charsmax(szMenu), "%s %s", WeaponGLOCK[i][GunName], g_SelectedGun[id][GLOCK] == i ? "\y{Kiválasztva}": szMenu2);
  351.                 menu_additem(menu, szMenu, String);
  352.             }
  353.         }
  354.         menu_display(id, menu, 0);
  355.         return PLUGIN_HANDLED;
  356.     }
  357.     public hSkinChooser(id, menu, item) {
  358.         if(item == MENU_EXIT)
  359.         {
  360.             menu_destroy(menu);
  361.             return PLUGIN_CONTINUE;
  362.         }
  363.         switch(g_Wpn[id]) {
  364.             case 1: {
  365.                 if(g_uPoints[id][M4A1] >= WeaponM4A1[item][Points]) {
  366.                     g_SelectedGun[id][M4A1] = item
  367.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  368.                 }
  369.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  370.             }
  371.             case 2: {
  372.                 if(g_uPoints[id][AK47] >= WeaponAK47[item][Points]) {
  373.                     g_SelectedGun[id][AK47] = item
  374.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  375.                 }
  376.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  377.             }
  378.             case 3: {
  379.                 if(g_uPoints[id][AWP] >= WeaponAWP[item][Points]) {
  380.                     g_SelectedGun[id][AWP] = item
  381.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  382.                 }
  383.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  384.             }
  385.             case 4: {
  386.                 if(g_uPoints[id][SCOUT] >= WeaponSCOUT[item][Points]) {
  387.                     g_SelectedGun[id][SCOUT] = item
  388.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  389.                 }
  390.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  391.             }
  392.             case 5: {
  393.                 if(g_uPoints[id][FAMAS] >= WeaponFAMAS[item][Points]) {
  394.                     g_SelectedGun[id][FAMAS] = item
  395.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  396.                 }
  397.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  398.             }
  399.             case 6: {
  400.                 if(g_uPoints[id][GALIL] >= WeaponGALIL[item][Points]) {
  401.                     g_SelectedGun[id][GALIL] = item
  402.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  403.                 }
  404.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  405.             }
  406.             case 7: {
  407.                 if(g_uPoints[id][AUG] >= WeaponAUG[item][Points]) {
  408.                     g_SelectedGun[id][AUG] = item
  409.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  410.                 }
  411.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  412.             }
  413.             case 8: {
  414.                 if(g_uPoints[id][M3] >= WeaponM3[item][Points]) {
  415.                     g_SelectedGun[id][M3] = item
  416.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  417.                 }
  418.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  419.             }
  420.             case 9: {
  421.                 if(g_uPoints[id][XM1014] >= WeaponXM1014[item][Points]) {
  422.                     g_SelectedGun[id][XM1014] = item
  423.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  424.                 }
  425.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  426.             }
  427.             case 10: {
  428.                 if(g_uPoints[id][KNIFE] >= WeaponKNIFE[item][Points]) {
  429.                     g_SelectedGun[id][KNIFE] = item
  430.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  431.                 }
  432.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  433.             }
  434.             case 11: {
  435.                 if(g_uPoints[id][DEAGLE] >= WeaponDEAGLE[item][Points]) {
  436.                     g_SelectedGun[id][DEAGLE] = item
  437.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  438.                 }
  439.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  440.             }
  441.             case 12: {
  442.                 if(g_uPoints[id][USP] >= WeaponUSP[item][Points]) {
  443.                     g_SelectedGun[id][USP] = item
  444.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  445.                 }
  446.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  447.             }
  448.             case 13: {
  449.                 if(g_uPoints[id][GLOCK] >= WeaponGLOCK[item][Points]) {
  450.                     g_SelectedGun[id][GLOCK] = item
  451.                     client_print_color(id, print_team_blue, "^4%s ^1Sikeresen aktiváltad a skint!", gChatPrefix);
  452.                 }
  453.                 else client_print_color(id, print_team_blue, "^4%s ^1Sajnálom, nincs elegendő ^3pontod^3!", gChatPrefix);
  454.             }
  455.         }
  456.         menu_destroy(menu);
  457.         return PLUGIN_HANDLED;
  458.     }
  459.     public client_putinserver(id)
  460.     {
  461.         if(is_user_bot(id))
  462.             return;
  463.        
  464.         g_uPoints[id][M4A1] = 0;
  465.         g_uPoints[id][AK47] = 0;
  466.         g_uPoints[id][AWP] = 0;
  467.         g_uPoints[id][SCOUT] = 0;
  468.         g_uPoints[id][FAMAS] = 0;
  469.         g_uPoints[id][GALIL] = 0;
  470.         g_uPoints[id][AUG] = 0;
  471.         g_uPoints[id][M3] = 0;
  472.         g_uPoints[id][XM1014] = 0;
  473.         g_uPoints[id][KNIFE] = 0;
  474.         g_uPoints[id][DEAGLE] = 0;
  475.         g_uPoints[id][USP] = 0;
  476.         g_uPoints[id][GLOCK] = 0;
  477.         g_SelectedGun[id][M4A1] = 0;
  478.         g_SelectedGun[id][AK47] = 0;
  479.         g_SelectedGun[id][AWP] = 0;
  480.         g_SelectedGun[id][SCOUT] = 0;
  481.         g_SelectedGun[id][FAMAS] = 0;
  482.         g_SelectedGun[id][GALIL] = 0;
  483.         g_SelectedGun[id][AUG] = 0;
  484.         g_SelectedGun[id][M3] = 0;
  485.         g_SelectedGun[id][XM1014] = 0;
  486.         g_SelectedGun[id][KNIFE] = 0;
  487.         g_SelectedGun[id][DEAGLE] = 0;
  488.         g_SelectedGun[id][USP] = 0;
  489.         g_SelectedGun[id][GLOCK] = 0;
  490.        
  491.         SelectDataTable(id);
  492.     }
  493.     public client_disconnected(id)
  494.     {
  495.         if(is_user_bot(id))
  496.             return;
  497.        
  498.         TableUpdate(id);
  499.     }
  500.     new Handle:g_SqlTuple;
  501.     public plugin_cfg()
  502.     {
  503.         //Kiszolgáló | Felhasználó | Jelszó | Adatbázis
  504.        
  505.         g_SqlTuple = SQL_MakeDbTuple("maria.srkhost.eu", "", "", "s17878_newszerver");
  506.         CreateTable();
  507.     }
  508.     public CreateTable(){
  509.         new iLen;
  510.         static sQuery[10048];
  511.        
  512.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "CREATE TABLE IF NOT EXISTS `%s` ", Tablename);
  513.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "( ");
  514.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
  515.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`SteamId` varchar(64) NOT NULL,");
  516.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM4A1` int(11) NOT NULL,");
  517.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAK47` int(11) NOT NULL,");
  518.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAWP` int(11) NOT NULL,");
  519.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsSCOUT` int(11) NOT NULL,");
  520.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsFAMAS` int(11) NOT NULL,");
  521.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGALIL` int(11) NOT NULL,");
  522.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAUG` int(11) NOT NULL,");
  523.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM3` int(11) NOT NULL,");
  524.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsXM1014` int(11) NOT NULL,");
  525.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsKNIFE` int(11) NOT NULL,");
  526.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  527.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsUSP` int(11) NOT NULL,");
  528.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGLOCK` int(11) NOT NULL,");
  529.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  530.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAK47` int(11) NOT NULL,");
  531.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAWP` int(11) NOT NULL,");
  532.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  533.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  534.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  535.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAUG` int(11) NOT NULL,");
  536.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM3` int(11) NOT NULL,");
  537.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  538.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  539.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  540.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunUSP` int(11) NOT NULL,");
  541.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGLOCK` int(11) NOT NULL)");
  542.        
  543.         SQL_ThreadQuery(g_SqlTuple, "TableCreateThread", sQuery);
  544.     }
  545.     public TableUpdate(id)
  546.     {
  547.         static sQuery[10048];
  548.         new iLen, sSteamID[64];
  549.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  550.        
  551.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "UPDATE `%s` SET ", Tablename);
  552.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM4A1 = ^"%i^",", g_uPoints[id][M4A1]);
  553.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAK47 = ^"%i^",", g_uPoints[id][AK47]);
  554.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAWP = ^"%i^",", g_uPoints[id][AWP]);
  555.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsSCOUT = ^"%i^",", g_uPoints[id][SCOUT]);
  556.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsFAMAS = ^"%i^",", g_uPoints[id][FAMAS]);
  557.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGALIL = ^"%i^",", g_uPoints[id][GALIL]);
  558.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAUG = ^"%i^",", g_uPoints[id][AUG]);
  559.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM3 = ^"%i^",", g_uPoints[id][M3]);
  560.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsXM1014 = ^"%i^",", g_uPoints[id][XM1014]);
  561.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsKNIFE = ^"%i^",", g_uPoints[id][KNIFE]);
  562.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsDEAGLE = ^"%i^",", g_uPoints[id][DEAGLE]);
  563.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsUSP = ^"%i^",", g_uPoints[id][USP]);
  564.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGLOCK = ^"%i^",", g_uPoints[id][GLOCK]);
  565.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAK47 = ^"%i^",", g_SelectedGun[id][AK47]);
  566.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAWP = ^"%i^",", g_SelectedGun[id][AWP]);
  567.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunSCOUT = ^"%i^",", g_SelectedGun[id][SCOUT]);
  568.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunFAMAS = ^"%i^",", g_SelectedGun[id][FAMAS]);
  569.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGALIL = ^"%i^",", g_SelectedGun[id][GALIL]);
  570.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAUG = ^"%i^",", g_SelectedGun[id][AUG]);
  571.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM3 = ^"%i^",", g_SelectedGun[id][M3]);
  572.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunXM1014 = ^"%i^",", g_SelectedGun[id][XM1014]);
  573.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunKNIFE = ^"%i^",", g_SelectedGun[id][KNIFE]);
  574.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunDEAGLE = ^"%i^",", g_SelectedGun[id][DEAGLE]);
  575.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunUSP = ^"%i^",", g_SelectedGun[id][USP]);
  576.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGLOCK = ^"%i^",", g_SelectedGun[id][GLOCK]);
  577.        
  578.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM4A1 = ^"%i^" WHERE `SteamId` = ^"%s^";", g_SelectedGun[id][M4A1], sSteamID);
  579.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  580.     }
  581.     public TableCreateThread(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  582.     {
  583.         if(iFailState == TQUERY_CONNECT_FAILED)
  584.             set_fail_state("[Create] Nem lehet csatlakozni az adatbazishoz!");
  585.         else if(iFailState == TQUERY_QUERY_FAILED)
  586.             set_fail_state("[Create] Lekerdezesi hiba");
  587.         if(iErrcode)
  588.             log_amx("[Create] Hiba:**!! %s !!**", sError);
  589.     }
  590.     public TableInsert(id)
  591.     {
  592.         static sQuery[10048], sSteamID[64];
  593.        
  594.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  595.         formatex(sQuery, charsmax(sQuery), "INSERT INTO `%s` (`SteamId`) VALUES (^"%s^");", Tablename, sSteamID);
  596.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  597.     }
  598.     public SelectDataTable(id)
  599.     {
  600.         static sQuery[10048];
  601.         new sData[1], sSteamID[64];
  602.         sData[0] = id;
  603.        
  604.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  605.        
  606.         formatex(sQuery, charsmax(sQuery), "SELECT * FROM `%s` WHERE SteamId = ^"%s^";", Tablename, sSteamID);
  607.         SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataTable", sQuery, sData, 1);
  608.     }
  609.     public QuerySelectDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  610.     {
  611.         if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  612.         {
  613.             log_amx("[Insert] Hiba:**!! %s !!**", sError);
  614.             return;
  615.         }
  616.         else
  617.         {
  618.             new id = sData[0];
  619.            
  620.             if(SQL_NumRows(sQuery) > 0)
  621.             {
  622.                 g_uPoints[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM4A1"));
  623.                 g_uPoints[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAK47"));
  624.                 g_uPoints[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAWP"));
  625.                 g_uPoints[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsSCOUT"));
  626.                 g_uPoints[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsFAMAS"));
  627.                 g_uPoints[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGALIL"));
  628.                 g_uPoints[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAUG"));
  629.                 g_uPoints[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM3"));
  630.                 g_uPoints[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsXM1014"));
  631.                 g_uPoints[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsKNIFE"));
  632.                 g_uPoints[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsDEAGLE"));
  633.                 g_uPoints[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsUSP"));
  634.                 g_uPoints[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGLOCK"));
  635.                 g_SelectedGun[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM4A1"));
  636.                 g_SelectedGun[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAK47"));
  637.                 g_SelectedGun[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAWP"));
  638.                 g_SelectedGun[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunSCOUT"));
  639.                 g_SelectedGun[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunFAMAS"));
  640.                 g_SelectedGun[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGALIL"));
  641.                 g_SelectedGun[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAUG"));
  642.                 g_SelectedGun[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM3"));
  643.                 g_SelectedGun[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunXM1014"));
  644.                 g_SelectedGun[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunKNIFE"));
  645.                 g_SelectedGun[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunDEAGLE"));
  646.                 g_SelectedGun[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunUSP"));
  647.                 g_SelectedGun[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGLOCK"));
  648.             }
  649.             else
  650.                 TableInsert(id);
  651.         }
  652.     }
  653.     public autoSave()
  654.     {
  655.         new pnum, id ,sSteamID[64];
  656.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  657.        
  658.         for(new i; i<pnum; i++)
  659.         {
  660.             id = sSteamID[i]  
  661.             set_task(random_float(0.2, 5.0), "TableUpdate", id)
  662.         }
  663.         return PLUGIN_HANDLED
  664.     }
  665.     public QuerySetDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  666.     {
  667.         if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  668.         {
  669.             log_amx("[SetData] Hiba:**!! %s !!**", sError);
  670.             return;
  671.         }
  672.     }


Helló!
Nem igaz már hogy nem tudod megoldani ezeket 100x felraktad ugyan ezeket ilyen témákkal.
Legalább 1x próbáld már meg ne más oldja meg helyeted, az ilyen kis dolgokat, ha nem megy akkor ne futass szervert.
Nem leszólás képp.



Helló!
Próbáltam már, nem tudom mi a megoldás erre, e meg lenézed a másikat! Gratulálok! Nem lehet mindeki ügyes mint te! :D Inkább hadjtad volna magadba a leszolást! :D

Szerző:  8mTNNe [ 2022.10.12. 18:12 ]
Hozzászólás témája:  Re: SQL gond! (Következő pálya után nem tölti be az adatokat)

Szia, van hiba kódod?

Szerző:  saxxo [ 2022.10.12. 18:14 ]
Hozzászólás témája:  Re: SQL gond! (Következő pálya után nem tölti be az adatokat)

8mTNNe írta:
Szia, van hiba kódod?



Szia!
Semmi hibakód nincs mert nem dob hibát!

Szerző:  HellEnergY [ 2022.10.14. 21:41 ]
Hozzászólás témája:  Re: SQL gond! (Következő pálya után nem tölti be az adatokat)

saxxo írta:
8mTNNe írta:
Szia, van hiba kódod?



Szia!
Semmi hibakód nincs mert nem dob hibát!


Ellenőrizted a steamid tömböd mielőtt mentene/beszúrna/betöltene, hogy nem e ürül?
Ellenőrizted myadminbanban, hogy beszúrja e a sort amit kell neki, megjelenik, vagy nem?
Ha nem akkor ott keress először hibát, ha igen akkor a betöltésnél lesz a bibi.
Ezenfelül ha addolsz és lelépsz frissül a táblád?
Na ha nem, akkor ott keress hibát, ellenkező esetben ismét a betöltésnél a bibi.
Egyáltalán azon kívül, hogy felraktad a kódot ami már magában nehéz lehet, próbálkoztál debugolni?

Az adatokat fix jól adtad meg, mert akkor eleve nem indulna el a dolog.
Sok sikert!

Szerző:  saxxo [ 2022.10.16. 14:33 ]
Hozzászólás témája:  Re: SQL gond! (Következő pálya után nem tölti be az adatokat)

HellEnergY írta:
saxxo írta:
8mTNNe írta:
Szia, van hiba kódod?



Szia!
Semmi hibakód nincs mert nem dob hibát!


Ellenőrizted a steamid tömböd mielőtt mentene/beszúrna/betöltene, hogy nem e ürül?
Ellenőrizted myadminbanban, hogy beszúrja e a sort amit kell neki, megjelenik, vagy nem?
Ha nem akkor ott keress először hibát, ha igen akkor a betöltésnél lesz a bibi.
Ezenfelül ha addolsz és lelépsz frissül a táblád?
Na ha nem, akkor ott keress hibát, ellenkező esetben ismét a betöltésnél a bibi.
Egyáltalán azon kívül, hogy felraktad a kódot ami már magában nehéz lehet, próbálkoztál debugolni?

Az adatokat fix jól adtad meg, mert akkor eleve nem indulna el a dolog.
Sok sikert!



Megoldva! köszönöm! :)

Oldal: 1 / 1 Minden időpont UTC+02:00 időzóna szerinti
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/