hlmod.hu

Magyar Half-Life Mód közösség!
Pontos idő: 2025.11.04. 03:39

Megválaszolatlan témák | Aktív témák



» » » »


Navigáció
Jelenlévő felhasználók

Jelenleg 285 felhasználó van jelen :: 2 regisztrált, 0 rejtett és 283 vendég

A legtöbb felhasználó (2883 fő) 2025.07.30. 16:00-kor tartózkodott itt.

Regisztrált felhasználók: Bing [Bot], Google [Bot]az elmúlt 5 percben aktív felhasználók alapján

Utoljára aktív
Ahhoz hogy lásd ki volt utoljára aktív, be kell jelentkezned.



Az oldal teljeskörű
használatához regisztrálj.

Regisztráció

Kereső


Új téma nyitása Hozzászólás a témához  Oldal: 1 / 1
  [4 hozzászólás ] 
 Nyomtatóbarát verzió |Barát értesítése e-mailben Előző téma | Következő téma 
Szerző Üzenet
John Wick
HozzászólásElküldve:2023.04.04. 09:13 
Offline
Tag
Avatar

Csatlakozott:2023.03.12. 22:01
Hozzászólások:42
Megköszönt másnak: 16 alkalommal
Sziasztok, tudom van sok ehhez hasonló téma, de az enyém elég furcsa, ugyan is mindent elment amit kell tehát

Név: blabla (id#1)
Öléseid: 10
Rangod: Silver I
Játszott idő: 5 Óra 10 perc

De miután felcsatlakozik egy new player, akkor egyből mindenkinek lenullázódik az összes mentett adata, és ezt nem tudom miért csinálja, itt is van a kódrészlet:

MySQL
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public plugin_cfg()
  2. {
  3.     g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  4.     static Query[10048];
  5.     new Len
  6.     Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  12.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  13.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  14.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  15.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  16.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  17.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  18.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  19.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  20.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  21.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  22.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  23.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  24.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  25.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  26.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  27.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  28.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  29.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  30.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  31.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  32.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  33.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  34.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  35.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  36.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  37.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  38.     Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  39.     SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  40. }
  41.  
  42.  
  43. public Load(id) {
  44.     static Query[10048];
  45.     new Data[1]
  46.     Data[0] = id;
  47.     formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  48.     SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  49. }
  50.  
  51.  
  52. public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  53.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  54.         log_amx("%s", Error)
  55.         return
  56.     }
  57.     else {
  58.         new id = Data[0];
  59.         if(SQL_NumRows(Query) > 0)
  60.         {
  61.             Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  62.             Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  63.             hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  64.             Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  65.             g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  66.             g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  67.             g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  68.             g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  69.             g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  70.             g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  71.             g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  72.             g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  73.             g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  74.             g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  75.             g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  76.             g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  77.             g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  78.             g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  79.             g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  80.             g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  81.             g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  82.             g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  83.             g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  84.             g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  85.             g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  86.             g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  87.             g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  88.             g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  89.             g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  90.             g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  91.             g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  92.         }
  93.         else
  94.         {
  95.             Save(id)
  96.         }
  97.     }
  98. }
  99. public Save(id)
  100. {
  101.     new text[512];
  102.     formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  103.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  104. }
  105.  
  106. public Update(id)
  107. {
  108.     static Query[10048]
  109.     new Len
  110.     new Steam[32]; get_user_authid(id, Steam, 31)
  111.     Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  112.     Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  113.     Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  114.     Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  115.     Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  116.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  117.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  118.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  119.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  120.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  121.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  122.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  123.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  124.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  125.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  126.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  127.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  128.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  129.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  130.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  131.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  132.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  133.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  134.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  135.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  136.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  137.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  138.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  139.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  140.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  141.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  142.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  143. }
  144. public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  145.     if(FailState == TQUERY_CONNECT_FAILED)
  146.         set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  147.     else if(FailState == TQUERY_QUERY_FAILED)
  148.         set_fail_state("Query Error")
  149.     if(Errcode)
  150.         log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  151. }
  152. public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  153.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  154.         log_amx("%s", Error);
  155.         return;
  156.     }
  157. }
  158. public client_putinserver(id)
  159.     if(!is_user_bot(id))
  160. {
  161.     get_user_authid(id,steamid[id], 32);
  162.     set_task(1.0, "hudrendszer", id, _, _, "b");
  163.     Load(id);
  164. }
  165. public client_disconnected(id)
  166. {
  167.     if(!is_user_bot(id))
  168.     {
  169.         Update(id);
  170.     }
  171.     Rang[id] = 0;
  172.     Oles[id] = 0;
  173.     hudkibe[id] = 1;
  174.     Masodpercek[id] = 0;
  175.     g_uPoints[M4A1][id] = 0
  176.     g_uPoints[AK47][id] = 0
  177.     g_uPoints[AWP][id] = 0
  178.     g_uPoints[DEAGLE][id] = 0
  179.     g_uPoints[KNIFE][id] = 0
  180.     g_uPoints[SCOUT][id] = 0
  181.     g_uPoints[FAMAS][id] = 0
  182.     g_uPoints[GALIL][id] = 0
  183.     g_uPoints[AUG][id] = 0
  184.     g_uPoints[M3][id] = 0
  185.     g_uPoints[XM1014][id] = 0
  186.     g_uPoints[USP][id] = 0
  187.     g_uPoints[GLOCK][id] = 0
  188.    
  189.     g_SelectedGun[M4A1][id] = 0
  190.     g_SelectedGun[AK47][id] = 0
  191.     g_SelectedGun[AWP][id] = 0
  192.     g_SelectedGun[DEAGLE][id] = 0
  193.     g_SelectedGun[KNIFE][id] = 0
  194.     g_SelectedGun[SCOUT][id] = 0
  195.     g_SelectedGun[FAMAS][id] = 0
  196.     g_SelectedGun[GALIL][id] = 0
  197.     g_SelectedGun[AUG][id] = 0
  198.     g_SelectedGun[M3][id] = 0
  199.     g_SelectedGun[XM1014][id] = 0
  200.     g_SelectedGun[USP][id] = 0
  201.     g_SelectedGun[GLOCK][id] = 0
  202. }
  203. public plugin_end()
  204. {
  205.     SQL_FreeHandle(g_SqlTuple)
  206. }
GeSHi © Codebox Plus

Köszönöm

_________________
Mindenki a tettei következményeit szenvedi.


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
saxxo
HozzászólásElküldve:2023.04.04. 19:21 
Offline
Jómunkásember

Csatlakozott:2020.06.14. 17:59
Hozzászólások:424
Megköszönt másnak: 78 alkalommal
Megköszönték neki: 10 alkalommal
John Wick írta:
Sziasztok, tudom van sok ehhez hasonló téma, de az enyém elég furcsa, ugyan is mindent elment amit kell tehát

Név: blabla (id#1)
Öléseid: 10
Rangod: Silver I
Játszott idő: 5 Óra 10 perc

De miután felcsatlakozik egy new player, akkor egyből mindenkinek lenullázódik az összes mentett adata, és ezt nem tudom miért csinálja, itt is van a kódrészlet:

MySQL
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public plugin_cfg()
  2. {
  3.     g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  4.     static Query[10048];
  5.     new Len
  6.     Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  12.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  13.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  14.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  15.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  16.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  17.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  18.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  19.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  20.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  21.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  22.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  23.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  24.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  25.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  26.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  27.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  28.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  29.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  30.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  31.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  32.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  33.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  34.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  35.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  36.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  37.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  38.     Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  39.     SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  40. }
  41.  
  42.  
  43. public Load(id) {
  44.     static Query[10048];
  45.     new Data[1]
  46.     Data[0] = id;
  47.     formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  48.     SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  49. }
  50.  
  51.  
  52. public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  53.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  54.         log_amx("%s", Error)
  55.         return
  56.     }
  57.     else {
  58.         new id = Data[0];
  59.         if(SQL_NumRows(Query) > 0)
  60.         {
  61.             Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  62.             Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  63.             hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  64.             Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  65.             g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  66.             g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  67.             g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  68.             g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  69.             g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  70.             g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  71.             g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  72.             g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  73.             g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  74.             g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  75.             g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  76.             g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  77.             g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  78.             g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  79.             g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  80.             g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  81.             g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  82.             g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  83.             g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  84.             g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  85.             g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  86.             g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  87.             g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  88.             g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  89.             g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  90.             g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  91.             g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  92.         }
  93.         else
  94.         {
  95.             Save(id)
  96.         }
  97.     }
  98. }
  99. public Save(id)
  100. {
  101.     new text[512];
  102.     formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  103.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  104. }
  105.  
  106. public Update(id)
  107. {
  108.     static Query[10048]
  109.     new Len
  110.     new Steam[32]; get_user_authid(id, Steam, 31)
  111.     Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  112.     Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  113.     Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  114.     Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  115.     Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  116.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  117.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  118.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  119.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  120.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  121.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  122.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  123.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  124.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  125.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  126.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  127.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  128.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  129.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  130.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  131.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  132.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  133.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  134.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  135.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  136.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  137.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  138.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  139.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  140.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  141.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  142.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  143. }
  144. public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  145.     if(FailState == TQUERY_CONNECT_FAILED)
  146.         set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  147.     else if(FailState == TQUERY_QUERY_FAILED)
  148.         set_fail_state("Query Error")
  149.     if(Errcode)
  150.         log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  151. }
  152. public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  153.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  154.         log_amx("%s", Error);
  155.         return;
  156.     }
  157. }
  158. public client_putinserver(id)
  159.     if(!is_user_bot(id))
  160. {
  161.     get_user_authid(id,steamid[id], 32);
  162.     set_task(1.0, "hudrendszer", id, _, _, "b");
  163. betoltve[id] = false;
  164.     Load(id);
  165. }
  166. public client_disconnected(id)
  167. {
  168.     if(!is_user_bot(id))
  169.     {
  170.         Update(id);
  171.     }
  172.     Rang[id] = 0;
  173.     Oles[id] = 0;
  174.     hudkibe[id] = 1;
  175.     Masodpercek[id] = 0;
  176.     g_uPoints[M4A1][id] = 0
  177.     g_uPoints[AK47][id] = 0
  178.     g_uPoints[AWP][id] = 0
  179.     g_uPoints[DEAGLE][id] = 0
  180.     g_uPoints[KNIFE][id] = 0
  181.     g_uPoints[SCOUT][id] = 0
  182.     g_uPoints[FAMAS][id] = 0
  183.     g_uPoints[GALIL][id] = 0
  184.     g_uPoints[AUG][id] = 0
  185.     g_uPoints[M3][id] = 0
  186.     g_uPoints[XM1014][id] = 0
  187.     g_uPoints[USP][id] = 0
  188.     g_uPoints[GLOCK][id] = 0
  189.    
  190.     g_SelectedGun[M4A1][id] = 0
  191.     g_SelectedGun[AK47][id] = 0
  192.     g_SelectedGun[AWP][id] = 0
  193.     g_SelectedGun[DEAGLE][id] = 0
  194.     g_SelectedGun[KNIFE][id] = 0
  195.     g_SelectedGun[SCOUT][id] = 0
  196.     g_SelectedGun[FAMAS][id] = 0
  197.     g_SelectedGun[GALIL][id] = 0
  198.     g_SelectedGun[AUG][id] = 0
  199.     g_SelectedGun[M3][id] = 0
  200.     g_SelectedGun[XM1014][id] = 0
  201.     g_SelectedGun[USP][id] = 0
  202.     g_SelectedGun[GLOCK][id] = 0
  203. }
  204. public plugin_end()
  205. {
  206.     SQL_FreeHandle(g_SqlTuple)
  207. }
GeSHi © Codebox Plus

Köszönöm



Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. new betoltve[33];// írd a sor elejére
  2.    
  3.    
  4.     public plugin_cfg()
  5.     {
  6.         g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  7.         static Query[10048];
  8.         new Len
  9.         Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  10.         Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  11.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  12.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  13.         Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  14.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  15.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  16.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  17.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  18.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  19.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  20.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  21.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  22.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  23.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  24.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  25.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  26.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  27.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  28.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  29.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  30.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  31.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  32.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  33.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  34.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  35.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  36.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  37.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  38.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  39.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  40.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  41.         Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  42.         SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  43.     }
  44.      
  45.      
  46.     public Load(id) {
  47.         static Query[10048];
  48.         new Data[1]
  49.         Data[0] = id;
  50.         formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  51.         SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  52.         betoltve[id] = true;
  53.     }
  54.      
  55.      
  56.     public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  57.         if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  58.             log_amx("%s", Error)
  59.             return
  60.         }
  61.         else {
  62.             new id = Data[0];
  63.             if(SQL_NumRows(Query) > 0)
  64.             {
  65.                 Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  66.                 Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  67.                 hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  68.                 Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  69.                 g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  70.                 g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  71.                 g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  72.                 g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  73.                 g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  74.                 g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  75.                 g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  76.                 g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  77.                 g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  78.                 g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  79.                 g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  80.                 g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  81.                 g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  82.                 g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  83.                 g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  84.                 g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  85.                 g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  86.                 g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  87.                 g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  88.                 g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  89.                 g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  90.                 g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  91.                 g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  92.                 g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  93.                 g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  94.                 g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  95.                 g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  96.                 betoltve[id] = true;
  97.             }
  98.             else
  99.             {
  100.                 Save(id)
  101.             }
  102.         }
  103.     }
  104.     public Save(id)
  105.     {
  106.         new text[512];
  107.         formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  108.         SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  109.     }
  110.      
  111.     public Update(id)
  112.     {
  113.         if(betoltve[id]) {
  114.         static Query[10048]
  115.         new Len
  116.         new Steam[32]; get_user_authid(id, Steam, 31)
  117.         Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  118.         Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  119.         Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  120.         Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  121.         Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  122.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  123.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  124.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  125.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  126.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  127.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  128.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  129.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  130.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  131.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  132.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  133.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  134.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  135.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  136.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  137.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  138.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  139.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  140.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  141.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  142.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  143.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  144.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  145.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  146.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  147.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  148.         SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  149.     }
  150.     public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  151.         if(FailState == TQUERY_CONNECT_FAILED)
  152.             set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  153.         else if(FailState == TQUERY_QUERY_FAILED)
  154.             set_fail_state("Query Error")
  155.         if(Errcode)
  156.             log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  157.     }
  158.     public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  159.         if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  160.             log_amx("%s", Error);
  161.             return;
  162.         }
  163.     }
  164.     public client_putinserver(id)
  165.         if(!is_user_bot(id))
  166.     {
  167.         get_user_authid(id,steamid[id], 32);
  168.         set_task(1.0, "hudrendszer", id, _, _, "b");
  169.         Load(id);
  170.     }
  171.     public client_disconnected(id)
  172.     {
  173.         if(!is_user_bot(id))
  174.         {
  175.             Update(id);
  176.         }
  177.         betoltve[id] = false;
  178.         Rang[id] = 0;
  179.         Oles[id] = 0;
  180.         hudkibe[id] = 1;
  181.         Masodpercek[id] = 0;
  182.         g_uPoints[M4A1][id] = 0
  183.         g_uPoints[AK47][id] = 0
  184.         g_uPoints[AWP][id] = 0
  185.         g_uPoints[DEAGLE][id] = 0
  186.         g_uPoints[KNIFE][id] = 0
  187.         g_uPoints[SCOUT][id] = 0
  188.         g_uPoints[FAMAS][id] = 0
  189.         g_uPoints[GALIL][id] = 0
  190.         g_uPoints[AUG][id] = 0
  191.         g_uPoints[M3][id] = 0
  192.         g_uPoints[XM1014][id] = 0
  193.         g_uPoints[USP][id] = 0
  194.         g_uPoints[GLOCK][id] = 0
  195.        
  196.         g_SelectedGun[M4A1][id] = 0
  197.         g_SelectedGun[AK47][id] = 0
  198.         g_SelectedGun[AWP][id] = 0
  199.         g_SelectedGun[DEAGLE][id] = 0
  200.         g_SelectedGun[KNIFE][id] = 0
  201.         g_SelectedGun[SCOUT][id] = 0
  202.         g_SelectedGun[FAMAS][id] = 0
  203.         g_SelectedGun[GALIL][id] = 0
  204.         g_SelectedGun[AUG][id] = 0
  205.         g_SelectedGun[M3][id] = 0
  206.         g_SelectedGun[XM1014][id] = 0
  207.         g_SelectedGun[USP][id] = 0
  208.         g_SelectedGun[GLOCK][id] = 0
  209.     }
  210.     public plugin_end()
  211.     {
  212.         SQL_FreeHandle(g_SqlTuple)
  213.     }
GeSHi © Codebox Plus


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
John Wick
HozzászólásElküldve:2023.04.05. 14:39 
Offline
Tag
Avatar

Csatlakozott:2023.03.12. 22:01
Hozzászólások:42
Megköszönt másnak: 16 alkalommal
saxxo írta:
John Wick írta:
Sziasztok, tudom van sok ehhez hasonló téma, de az enyém elég furcsa, ugyan is mindent elment amit kell tehát

Név: blabla (id#1)
Öléseid: 10
Rangod: Silver I
Játszott idő: 5 Óra 10 perc

De miután felcsatlakozik egy new player, akkor egyből mindenkinek lenullázódik az összes mentett adata, és ezt nem tudom miért csinálja, itt is van a kódrészlet:

MySQL
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public plugin_cfg()
  2. {
  3.     g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  4.     static Query[10048];
  5.     new Len
  6.     Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  12.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  13.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  14.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  15.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  16.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  17.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  18.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  19.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  20.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  21.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  22.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  23.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  24.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  25.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  26.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  27.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  28.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  29.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  30.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  31.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  32.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  33.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  34.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  35.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  36.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  37.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  38.     Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  39.     SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  40. }
  41.  
  42.  
  43. public Load(id) {
  44.     static Query[10048];
  45.     new Data[1]
  46.     Data[0] = id;
  47.     formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  48.     SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  49. }
  50.  
  51.  
  52. public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  53.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  54.         log_amx("%s", Error)
  55.         return
  56.     }
  57.     else {
  58.         new id = Data[0];
  59.         if(SQL_NumRows(Query) > 0)
  60.         {
  61.             Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  62.             Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  63.             hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  64.             Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  65.             g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  66.             g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  67.             g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  68.             g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  69.             g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  70.             g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  71.             g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  72.             g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  73.             g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  74.             g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  75.             g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  76.             g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  77.             g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  78.             g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  79.             g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  80.             g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  81.             g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  82.             g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  83.             g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  84.             g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  85.             g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  86.             g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  87.             g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  88.             g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  89.             g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  90.             g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  91.             g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  92.         }
  93.         else
  94.         {
  95.             Save(id)
  96.         }
  97.     }
  98. }
  99. public Save(id)
  100. {
  101.     new text[512];
  102.     formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  103.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  104. }
  105.  
  106. public Update(id)
  107. {
  108.     static Query[10048]
  109.     new Len
  110.     new Steam[32]; get_user_authid(id, Steam, 31)
  111.     Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  112.     Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  113.     Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  114.     Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  115.     Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  116.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  117.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  118.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  119.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  120.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  121.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  122.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  123.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  124.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  125.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  126.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  127.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  128.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  129.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  130.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  131.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  132.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  133.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  134.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  135.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  136.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  137.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  138.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  139.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  140.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  141.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  142.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  143. }
  144. public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  145.     if(FailState == TQUERY_CONNECT_FAILED)
  146.         set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  147.     else if(FailState == TQUERY_QUERY_FAILED)
  148.         set_fail_state("Query Error")
  149.     if(Errcode)
  150.         log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  151. }
  152. public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  153.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  154.         log_amx("%s", Error);
  155.         return;
  156.     }
  157. }
  158. public client_putinserver(id)
  159.     if(!is_user_bot(id))
  160. {
  161.     get_user_authid(id,steamid[id], 32);
  162.     set_task(1.0, "hudrendszer", id, _, _, "b");
  163. betoltve[id] = false;
  164.     Load(id);
  165. }
  166. public client_disconnected(id)
  167. {
  168.     if(!is_user_bot(id))
  169.     {
  170.         Update(id);
  171.     }
  172.     Rang[id] = 0;
  173.     Oles[id] = 0;
  174.     hudkibe[id] = 1;
  175.     Masodpercek[id] = 0;
  176.     g_uPoints[M4A1][id] = 0
  177.     g_uPoints[AK47][id] = 0
  178.     g_uPoints[AWP][id] = 0
  179.     g_uPoints[DEAGLE][id] = 0
  180.     g_uPoints[KNIFE][id] = 0
  181.     g_uPoints[SCOUT][id] = 0
  182.     g_uPoints[FAMAS][id] = 0
  183.     g_uPoints[GALIL][id] = 0
  184.     g_uPoints[AUG][id] = 0
  185.     g_uPoints[M3][id] = 0
  186.     g_uPoints[XM1014][id] = 0
  187.     g_uPoints[USP][id] = 0
  188.     g_uPoints[GLOCK][id] = 0
  189.    
  190.     g_SelectedGun[M4A1][id] = 0
  191.     g_SelectedGun[AK47][id] = 0
  192.     g_SelectedGun[AWP][id] = 0
  193.     g_SelectedGun[DEAGLE][id] = 0
  194.     g_SelectedGun[KNIFE][id] = 0
  195.     g_SelectedGun[SCOUT][id] = 0
  196.     g_SelectedGun[FAMAS][id] = 0
  197.     g_SelectedGun[GALIL][id] = 0
  198.     g_SelectedGun[AUG][id] = 0
  199.     g_SelectedGun[M3][id] = 0
  200.     g_SelectedGun[XM1014][id] = 0
  201.     g_SelectedGun[USP][id] = 0
  202.     g_SelectedGun[GLOCK][id] = 0
  203. }
  204. public plugin_end()
  205. {
  206.     SQL_FreeHandle(g_SqlTuple)
  207. }
GeSHi © Codebox Plus

Köszönöm



Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. new betoltve[33];// írd a sor elejére
  2.    
  3.    
  4.     public plugin_cfg()
  5.     {
  6.         g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  7.         static Query[10048];
  8.         new Len
  9.         Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  10.         Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  11.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  12.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  13.         Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  14.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  15.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  16.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  17.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  18.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  19.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  20.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  21.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  22.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  23.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  24.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  25.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  26.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  27.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  28.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  29.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  30.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  31.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  32.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  33.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  34.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  35.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  36.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  37.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  38.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  39.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  40.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  41.         Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  42.         SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  43.     }
  44.      
  45.      
  46.     public Load(id) {
  47.         static Query[10048];
  48.         new Data[1]
  49.         Data[0] = id;
  50.         formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  51.         SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  52.         betoltve[id] = true;
  53.     }
  54.      
  55.      
  56.     public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  57.         if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  58.             log_amx("%s", Error)
  59.             return
  60.         }
  61.         else {
  62.             new id = Data[0];
  63.             if(SQL_NumRows(Query) > 0)
  64.             {
  65.                 Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  66.                 Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  67.                 hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  68.                 Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  69.                 g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  70.                 g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  71.                 g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  72.                 g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  73.                 g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  74.                 g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  75.                 g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  76.                 g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  77.                 g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  78.                 g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  79.                 g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  80.                 g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  81.                 g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  82.                 g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  83.                 g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  84.                 g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  85.                 g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  86.                 g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  87.                 g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  88.                 g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  89.                 g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  90.                 g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  91.                 g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  92.                 g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  93.                 g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  94.                 g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  95.                 g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  96.                 betoltve[id] = true;
  97.             }
  98.             else
  99.             {
  100.                 Save(id)
  101.             }
  102.         }
  103.     }
  104.     public Save(id)
  105.     {
  106.         new text[512];
  107.         formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  108.         SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  109.     }
  110.      
  111.     public Update(id)
  112.     {
  113.         if(betoltve[id]) {
  114.         static Query[10048]
  115.         new Len
  116.         new Steam[32]; get_user_authid(id, Steam, 31)
  117.         Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  118.         Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  119.         Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  120.         Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  121.         Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  122.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  123.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  124.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  125.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  126.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  127.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  128.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  129.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  130.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  131.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  132.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  133.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  134.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  135.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  136.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  137.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  138.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  139.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  140.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  141.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  142.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  143.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  144.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  145.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  146.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  147.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  148.         SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  149.     }
  150.     public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  151.         if(FailState == TQUERY_CONNECT_FAILED)
  152.             set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  153.         else if(FailState == TQUERY_QUERY_FAILED)
  154.             set_fail_state("Query Error")
  155.         if(Errcode)
  156.             log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  157.     }
  158.     public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  159.         if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  160.             log_amx("%s", Error);
  161.             return;
  162.         }
  163.     }
  164.     public client_putinserver(id)
  165.         if(!is_user_bot(id))
  166.     {
  167.         get_user_authid(id,steamid[id], 32);
  168.         set_task(1.0, "hudrendszer", id, _, _, "b");
  169.         Load(id);
  170.     }
  171.     public client_disconnected(id)
  172.     {
  173.         if(!is_user_bot(id))
  174.         {
  175.             Update(id);
  176.         }
  177.         betoltve[id] = false;
  178.         Rang[id] = 0;
  179.         Oles[id] = 0;
  180.         hudkibe[id] = 1;
  181.         Masodpercek[id] = 0;
  182.         g_uPoints[M4A1][id] = 0
  183.         g_uPoints[AK47][id] = 0
  184.         g_uPoints[AWP][id] = 0
  185.         g_uPoints[DEAGLE][id] = 0
  186.         g_uPoints[KNIFE][id] = 0
  187.         g_uPoints[SCOUT][id] = 0
  188.         g_uPoints[FAMAS][id] = 0
  189.         g_uPoints[GALIL][id] = 0
  190.         g_uPoints[AUG][id] = 0
  191.         g_uPoints[M3][id] = 0
  192.         g_uPoints[XM1014][id] = 0
  193.         g_uPoints[USP][id] = 0
  194.         g_uPoints[GLOCK][id] = 0
  195.        
  196.         g_SelectedGun[M4A1][id] = 0
  197.         g_SelectedGun[AK47][id] = 0
  198.         g_SelectedGun[AWP][id] = 0
  199.         g_SelectedGun[DEAGLE][id] = 0
  200.         g_SelectedGun[KNIFE][id] = 0
  201.         g_SelectedGun[SCOUT][id] = 0
  202.         g_SelectedGun[FAMAS][id] = 0
  203.         g_SelectedGun[GALIL][id] = 0
  204.         g_SelectedGun[AUG][id] = 0
  205.         g_SelectedGun[M3][id] = 0
  206.         g_SelectedGun[XM1014][id] = 0
  207.         g_SelectedGun[USP][id] = 0
  208.         g_SelectedGun[GLOCK][id] = 0
  209.     }
  210.     public plugin_end()
  211.     {
  212.         SQL_FreeHandle(g_SqlTuple)
  213.     }
GeSHi © Codebox Plus

Hm, érdekes, nem változott semmi. Bár rá jöttem arra hogy elcsúsznak az authid-k, tehát én első játékos fent vagyok a szerveren és öltem párat megmarad egy kis ideig a mentésben, de miután feljön egy másik játékos azután már lenullázodott nekem. tehát ezt így tudnám szemléltetni:

1. játékos
Név: Egy SCP(#1)
Ölés: 10
Rangod: Pokembej
Játszott időd: 1000 Óra 1000 Perc :D
Elmenti minden kafa ezután --->

Felcsatlakozott a 2. játékos:
Név: Kawasaki(#0) -> (tehát itt sem vág össze 2-id val kellene rendelkeznie, de még is az eggyel alatta lévőt használja addig ameddig lenem csatlakozik majd vissza)
Ölés: 0
Rangod Silver I
Játszott időd 0 Óra 0 Perc
tehát nem frissit időben vagy nem tudom
és ezután mindig törli az alatta levőt, tehát ha feljönnek sokan a szerverre, akkor mindenki lenulláza a másikat :D
egyébként erről a modról van szó: SaNeSS_ @ Skinrendszer V2
és mivel az id-t jelzi amit hozzá raktam így legalább hamarabb észrevettem a problémát

_________________
Mindenki a tettei következményeit szenvedi.


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
saxxo
HozzászólásElküldve:2023.04.05. 18:38 
Offline
Jómunkásember

Csatlakozott:2020.06.14. 17:59
Hozzászólások:424
Megköszönt másnak: 78 alkalommal
Megköszönték neki: 10 alkalommal
John Wick írta:
saxxo írta:
John Wick írta:
Sziasztok, tudom van sok ehhez hasonló téma, de az enyém elég furcsa, ugyan is mindent elment amit kell tehát

Név: blabla (id#1)
Öléseid: 10
Rangod: Silver I
Játszott idő: 5 Óra 10 perc

De miután felcsatlakozik egy new player, akkor egyből mindenkinek lenullázódik az összes mentett adata, és ezt nem tudom miért csinálja, itt is van a kódrészlet:

MySQL
Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. public plugin_cfg()
  2. {
  3.     g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  4.     static Query[10048];
  5.     new Len
  6.     Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  7.     Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  8.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  9.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  10.     Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  11.     Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  12.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  13.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  14.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  15.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  16.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  17.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  18.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  19.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  20.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  21.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  22.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  23.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  24.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  25.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  26.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  27.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  28.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  29.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  30.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  31.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  32.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  33.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  34.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  35.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  36.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  37.     Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  38.     Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  39.     SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  40. }
  41.  
  42.  
  43. public Load(id) {
  44.     static Query[10048];
  45.     new Data[1]
  46.     Data[0] = id;
  47.     formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  48.     SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  49. }
  50.  
  51.  
  52. public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  53.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  54.         log_amx("%s", Error)
  55.         return
  56.     }
  57.     else {
  58.         new id = Data[0];
  59.         if(SQL_NumRows(Query) > 0)
  60.         {
  61.             Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  62.             Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  63.             hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  64.             Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  65.             g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  66.             g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  67.             g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  68.             g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  69.             g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  70.             g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  71.             g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  72.             g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  73.             g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  74.             g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  75.             g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  76.             g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  77.             g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  78.             g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  79.             g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  80.             g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  81.             g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  82.             g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  83.             g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  84.             g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  85.             g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  86.             g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  87.             g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  88.             g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  89.             g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  90.             g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  91.             g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  92.         }
  93.         else
  94.         {
  95.             Save(id)
  96.         }
  97.     }
  98. }
  99. public Save(id)
  100. {
  101.     new text[512];
  102.     formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  103.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  104. }
  105.  
  106. public Update(id)
  107. {
  108.     static Query[10048]
  109.     new Len
  110.     new Steam[32]; get_user_authid(id, Steam, 31)
  111.     Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  112.     Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  113.     Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  114.     Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  115.     Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  116.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  117.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  118.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  119.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  120.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  121.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  122.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  123.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  124.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  125.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  126.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  127.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  128.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  129.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  130.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  131.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  132.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  133.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  134.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  135.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  136.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  137.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  138.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  139.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  140.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  141.     Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  142.     SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  143. }
  144. public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  145.     if(FailState == TQUERY_CONNECT_FAILED)
  146.         set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  147.     else if(FailState == TQUERY_QUERY_FAILED)
  148.         set_fail_state("Query Error")
  149.     if(Errcode)
  150.         log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  151. }
  152. public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  153.     if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  154.         log_amx("%s", Error);
  155.         return;
  156.     }
  157. }
  158. public client_putinserver(id)
  159.     if(!is_user_bot(id))
  160. {
  161.     get_user_authid(id,steamid[id], 32);
  162.     set_task(1.0, "hudrendszer", id, _, _, "b");
  163. betoltve[id] = false;
  164.     Load(id);
  165. }
  166. public client_disconnected(id)
  167. {
  168.     if(!is_user_bot(id))
  169.     {
  170.         Update(id);
  171.     }
  172.     Rang[id] = 0;
  173.     Oles[id] = 0;
  174.     hudkibe[id] = 1;
  175.     Masodpercek[id] = 0;
  176.     g_uPoints[M4A1][id] = 0
  177.     g_uPoints[AK47][id] = 0
  178.     g_uPoints[AWP][id] = 0
  179.     g_uPoints[DEAGLE][id] = 0
  180.     g_uPoints[KNIFE][id] = 0
  181.     g_uPoints[SCOUT][id] = 0
  182.     g_uPoints[FAMAS][id] = 0
  183.     g_uPoints[GALIL][id] = 0
  184.     g_uPoints[AUG][id] = 0
  185.     g_uPoints[M3][id] = 0
  186.     g_uPoints[XM1014][id] = 0
  187.     g_uPoints[USP][id] = 0
  188.     g_uPoints[GLOCK][id] = 0
  189.    
  190.     g_SelectedGun[M4A1][id] = 0
  191.     g_SelectedGun[AK47][id] = 0
  192.     g_SelectedGun[AWP][id] = 0
  193.     g_SelectedGun[DEAGLE][id] = 0
  194.     g_SelectedGun[KNIFE][id] = 0
  195.     g_SelectedGun[SCOUT][id] = 0
  196.     g_SelectedGun[FAMAS][id] = 0
  197.     g_SelectedGun[GALIL][id] = 0
  198.     g_SelectedGun[AUG][id] = 0
  199.     g_SelectedGun[M3][id] = 0
  200.     g_SelectedGun[XM1014][id] = 0
  201.     g_SelectedGun[USP][id] = 0
  202.     g_SelectedGun[GLOCK][id] = 0
  203. }
  204. public plugin_end()
  205. {
  206.     SQL_FreeHandle(g_SqlTuple)
  207. }
GeSHi © Codebox Plus

Köszönöm



Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. new betoltve[33];// írd a sor elejére
  2.    
  3.    
  4.     public plugin_cfg()
  5.     {
  6.         g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
  7.         static Query[10048];
  8.         new Len
  9.         Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `Hyper_Mysql`");
  10.         Len += formatex(Query[Len], charsmax(Query)-Len, "(`steamid` varchar(32) NOT NULL, ");
  11.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
  12.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
  13.         Len += formatex(Query[Len], charsmax(Query)-Len, "`hudkibe` int(11) NOT NULL,");
  14.         Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
  15.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM4A1` int(11) NOT NULL,");
  16.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAK47` int(11) NOT NULL,");
  17.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAWP` int(11) NOT NULL,");
  18.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsSCOUT` int(11) NOT NULL,");
  19.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsFAMAS` int(11) NOT NULL,");
  20.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGALIL` int(11) NOT NULL,");
  21.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsAUG` int(11) NOT NULL,");
  22.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsM3` int(11) NOT NULL,");
  23.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsXM1014` int(11) NOT NULL,");
  24.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsKNIFE` int(11) NOT NULL,");
  25.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  26.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsUSP` int(11) NOT NULL,");
  27.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_uPointsGLOCK` int(11) NOT NULL,");
  28.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  29.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAK47` int(11) NOT NULL,");
  30.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAWP` int(11) NOT NULL,");
  31.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  32.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  33.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  34.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunAUG` int(11) NOT NULL,");
  35.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunM3` int(11) NOT NULL,");
  36.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  37.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  38.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  39.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunUSP` int(11) NOT NULL,");
  40.         Len += formatex(Query[Len], charsmax(Query)-Len, "`g_SelectedGunGLOCK` int(11) NOT NULL,");
  41.         Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
  42.         SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
  43.     }
  44.      
  45.      
  46.     public Load(id) {
  47.         static Query[10048];
  48.         new Data[1]
  49.         Data[0] = id;
  50.         formatex(Query, charsmax(Query), "SELECT * FROM `Hyper_Mysql` WHERE steamid = ^"%s^";", steamid[id]);
  51.         SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
  52.         betoltve[id] = true;
  53.     }
  54.      
  55.      
  56.     public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  57.         if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  58.             log_amx("%s", Error)
  59.             return
  60.         }
  61.         else {
  62.             new id = Data[0];
  63.             if(SQL_NumRows(Query) > 0)
  64.             {
  65.                 Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
  66.                 Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
  67.                 hudkibe[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "hudkibe"));
  68.                 Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
  69.                 g_uPoints[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM4A1"));
  70.                 g_uPoints[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAK47"));
  71.                 g_uPoints[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAWP"));
  72.                 g_uPoints[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsDEAGLE"));
  73.                 g_uPoints[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsKNIFE"));
  74.                 g_uPoints[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsSCOUT"));
  75.                 g_uPoints[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsFAMAS"));
  76.                 g_uPoints[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGALIL"));
  77.                 g_uPoints[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsAUG"));
  78.                 g_uPoints[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsM3"));
  79.                 g_uPoints[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsXM1014"));
  80.                 g_uPoints[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsUSP"));
  81.                 g_uPoints[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_uPointsGLOCK"));
  82.                 g_SelectedGun[M4A1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM4A1"));
  83.                 g_SelectedGun[AK47][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAK47"));
  84.                 g_SelectedGun[AWP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAWP"));
  85.                 g_SelectedGun[DEAGLE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunDEAGLE"));
  86.                 g_SelectedGun[KNIFE][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunKNIFE"));
  87.                 g_SelectedGun[SCOUT][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunSCOUT"));
  88.                 g_SelectedGun[FAMAS][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunFAMAS"));
  89.                 g_SelectedGun[GALIL][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGALIL"));
  90.                 g_SelectedGun[AUG][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunAUG"));
  91.                 g_SelectedGun[M3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunM3"));
  92.                 g_SelectedGun[XM1014][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunXM1014"));
  93.                 g_SelectedGun[USP][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunUSP"));
  94.                 g_SelectedGun[GLOCK][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "g_SelectedGunGLOCK"));
  95.                 g_id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
  96.                 betoltve[id] = true;
  97.             }
  98.             else
  99.             {
  100.                 Save(id)
  101.             }
  102.         }
  103.     }
  104.     public Save(id)
  105.     {
  106.         new text[512];
  107.         formatex(text, charsmax(text), "INSERT INTO `Hyper_Mysql` (`steamid`) VALUES (^"%s^");", steamid[id]);
  108.         SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text);
  109.     }
  110.      
  111.     public Update(id)
  112.     {
  113.         if(betoltve[id]) {
  114.         static Query[10048]
  115.         new Len
  116.         new Steam[32]; get_user_authid(id, Steam, 31)
  117.         Len += formatex(Query[Len], charsmax(Query), "UPDATE `Hyper_Mysql` SET g_uPointsAWP = ^"%i^", ", g_uPoints[AWP][id]);
  118.         Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
  119.         Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
  120.         Len += formatex(Query[Len], charsmax(Query)-Len, "hudkibe = ^"%i^", ", hudkibe[id]);
  121.         Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
  122.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM4A1 = ^"%i^", ", g_uPoints[M4A1][id]);
  123.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAK47 = ^"%i^", ", g_uPoints[AK47][id]);
  124.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsDEAGLE = ^"%i^", ", g_uPoints[DEAGLE][id]);
  125.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsKNIFE = ^"%i^", ", g_uPoints[KNIFE][id]);
  126.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsSCOUT = ^"%i^", ", g_uPoints[SCOUT][id]);
  127.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsFAMAS = ^"%i^", ", g_uPoints[FAMAS][id]);
  128.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGALIL = ^"%i^", ", g_uPoints[GALIL][id]);
  129.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsAUG= ^"%i^", ", g_uPoints[AUG][id]);
  130.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsM3 = ^"%i^", ", g_uPoints[M3][id]);
  131.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsXM1014 = ^"%i^", ", g_uPoints[XM1014][id]);
  132.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsUSP = ^"%i^", ", g_uPoints[USP][id]);
  133.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_uPointsGLOCK = ^"%i^", ", g_uPoints[GLOCK][id]);
  134.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^", ", g_SelectedGun[M4A1][id]);
  135.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAK47 = ^"%i^", ", g_SelectedGun[AK47][id]);
  136.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAWP = ^"%i^", ", g_SelectedGun[AWP][id]);
  137.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunDEAGLE = ^"%i^", ", g_SelectedGun[DEAGLE][id]);
  138.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunKNIFE = ^"%i^", ", g_SelectedGun[KNIFE][id]);
  139.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunSCOUT = ^"%i^", ", g_SelectedGun[SCOUT][id]);
  140.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunFAMAS = ^"%i^", ", g_SelectedGun[FAMAS][id]);
  141.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGALIL = ^"%i^", ", g_SelectedGun[GALIL][id]);
  142.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunAUG = ^"%i^", ", g_SelectedGun[AUG][id]);
  143.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM3 = ^"%i^", ", g_SelectedGun[M3][id]);
  144.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunXM1014 = ^"%i^", ", g_SelectedGun[XM1014][id]);
  145.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunUSP = ^"%i^", ", g_SelectedGun[USP][id]);
  146.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunGLOCK = ^"%i^", ", g_SelectedGun[GLOCK][id]);
  147.         Len += formatex(Query[Len], charsmax(Query)-Len, "g_SelectedGunM4A1 = ^"%i^" WHERE steamid = ^"%s^";", g_SelectedGun[M4A1][id], steamid[id]);
  148.         SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query)
  149.     }
  150.     public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  151.         if(FailState == TQUERY_CONNECT_FAILED)
  152.             set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!")
  153.         else if(FailState == TQUERY_QUERY_FAILED)
  154.             set_fail_state("Query Error")
  155.         if(Errcode)
  156.             log_amx("[HIBA*] HIBAT DOBTAM: %s",Error)
  157.     }
  158.     public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
  159.         if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
  160.             log_amx("%s", Error);
  161.             return;
  162.         }
  163.     }
  164.     public client_putinserver(id)
  165.         if(!is_user_bot(id))
  166.     {
  167.         get_user_authid(id,steamid[id], 32);
  168.         set_task(1.0, "hudrendszer", id, _, _, "b");
  169.         Load(id);
  170.     }
  171.     public client_disconnected(id)
  172.     {
  173.         if(!is_user_bot(id))
  174.         {
  175.             Update(id);
  176.         }
  177.         betoltve[id] = false;
  178.         Rang[id] = 0;
  179.         Oles[id] = 0;
  180.         hudkibe[id] = 1;
  181.         Masodpercek[id] = 0;
  182.         g_uPoints[M4A1][id] = 0
  183.         g_uPoints[AK47][id] = 0
  184.         g_uPoints[AWP][id] = 0
  185.         g_uPoints[DEAGLE][id] = 0
  186.         g_uPoints[KNIFE][id] = 0
  187.         g_uPoints[SCOUT][id] = 0
  188.         g_uPoints[FAMAS][id] = 0
  189.         g_uPoints[GALIL][id] = 0
  190.         g_uPoints[AUG][id] = 0
  191.         g_uPoints[M3][id] = 0
  192.         g_uPoints[XM1014][id] = 0
  193.         g_uPoints[USP][id] = 0
  194.         g_uPoints[GLOCK][id] = 0
  195.        
  196.         g_SelectedGun[M4A1][id] = 0
  197.         g_SelectedGun[AK47][id] = 0
  198.         g_SelectedGun[AWP][id] = 0
  199.         g_SelectedGun[DEAGLE][id] = 0
  200.         g_SelectedGun[KNIFE][id] = 0
  201.         g_SelectedGun[SCOUT][id] = 0
  202.         g_SelectedGun[FAMAS][id] = 0
  203.         g_SelectedGun[GALIL][id] = 0
  204.         g_SelectedGun[AUG][id] = 0
  205.         g_SelectedGun[M3][id] = 0
  206.         g_SelectedGun[XM1014][id] = 0
  207.         g_SelectedGun[USP][id] = 0
  208.         g_SelectedGun[GLOCK][id] = 0
  209.     }
  210.     public plugin_end()
  211.     {
  212.         SQL_FreeHandle(g_SqlTuple)
  213.     }
GeSHi © Codebox Plus

Hm, érdekes, nem változott semmi. Bár rá jöttem arra hogy elcsúsznak az authid-k, tehát én első játékos fent vagyok a szerveren és öltem párat megmarad egy kis ideig a mentésben, de miután feljön egy másik játékos azután már lenullázodott nekem. tehát ezt így tudnám szemléltetni:

1. játékos
Név: Egy SCP(#1)
Ölés: 10
Rangod: Pokembej
Játszott időd: 1000 Óra 1000 Perc :D
Elmenti minden kafa ezután --->

Felcsatlakozott a 2. játékos:
Név: Kawasaki(#0) -> (tehát itt sem vág össze 2-id val kellene rendelkeznie, de még is az eggyel alatta lévőt használja addig ameddig lenem csatlakozik majd vissza)
Ölés: 0
Rangod Silver I
Játszott időd 0 Óra 0 Perc
tehát nem frissit időben vagy nem tudom
és ezután mindig törli az alatta levőt, tehát ha feljönnek sokan a szerverre, akkor mindenki lenulláza a másikat :D



Szia!
Nálam ez a megoldás műkődik! :)

Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. new betoltve[33];
GeSHi © Codebox Plus


Kód: [Egész kijelölése] [Mutatás/Eltüntetés]
  1. }
  2. public client_putinserver(id)
  3. {
  4.     if(is_user_bot(id))
  5.         return;
  6.    
  7.     set_task(5.0, "hudshow_p", id);
  8.    
  9.     betoltve[id] = false;
  10.     g_ePlayer[id][eLvl] = 0;
  11.     g_ePlayer[id][eXp] = 0;
  12.     g_ePlayer[id][eRank] = 0;
  13.     g_ePlayer[id][eRankCounter] = 0;
  14.     g_uPoints[id][M4A1] = 0;
  15.     g_uPoints[id][AK47] = 0;
  16.     g_uPoints[id][AWP] = 0;
  17.     g_uPoints[id][SCOUT] = 0;
  18.     g_uPoints[id][FAMAS] = 0;
  19.     g_uPoints[id][GALIL] = 0;
  20.     g_uPoints[id][AUG] = 0;
  21.     g_uPoints[id][M3] = 0;
  22.     g_uPoints[id][XM1014] = 0;
  23.     g_uPoints[id][KNIFE] = 0;
  24.     g_uPoints[id][DEAGLE] = 0;
  25.     g_uPoints[id][USP] = 0;
  26.     g_uPoints[id][GLOCK] = 0;
  27.     g_SelectedGun[id][M4A1] = 0;
  28.     g_SelectedGun[id][AK47] = 0;
  29.     g_SelectedGun[id][AWP] = 0;
  30.     g_SelectedGun[id][SCOUT] = 0;
  31.     g_SelectedGun[id][FAMAS] = 0;
  32.     g_SelectedGun[id][GALIL] = 0;
  33.     g_SelectedGun[id][AUG] = 0;
  34.     g_SelectedGun[id][M3] = 0;
  35.     g_SelectedGun[id][XM1014] = 0;
  36.     g_SelectedGun[id][KNIFE] = 0;
  37.     g_SelectedGun[id][DEAGLE] = 0;
  38.     g_SelectedGun[id][USP] = 0;
  39.     g_SelectedGun[id][GLOCK] = 0;
  40.    
  41.     SelectDataTable(id);
  42. }
  43. public client_disconnected(id)
  44. {
  45.     if(is_user_bot(id))
  46.         return;
  47.    
  48.     TableUpdate(id);
  49.    
  50.     if(task_exists(id))
  51.         remove_task(id);
  52. }
  53. new Handle:g_SqlTuple;
  54. public plugin_cfg()
  55. {
  56.     //Kiszolgáló | Felhasználó | Jelszó | Adatbázis
  57.    
  58.     g_SqlTuple = SQL_MakeDbTuple("", "", "", "");
  59.     CreateTable();
  60. }
  61. public CreateTable(){
  62.     new iLen;
  63.     static sQuery[10048];
  64.    
  65.     iLen += formatex(sQuery[iLen], charsmax(sQuery), "CREATE TABLE IF NOT EXISTS `%s` ", Tablename);
  66.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "( ");
  67.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`Id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,");
  68.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`SteamId` varchar(64) NOT NULL,");
  69.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`qSzint` int(11) NOT NULL,");
  70.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`qXp` int(11) NOT NULL,");
  71.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`qRank` int(11) NOT NULL,");
  72.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`qRankCounter` int(11) NOT NULL,");
  73.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM4A1` int(11) NOT NULL,");
  74.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAK47` int(11) NOT NULL,");
  75.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAWP` int(11) NOT NULL,");
  76.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsSCOUT` int(11) NOT NULL,");
  77.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsFAMAS` int(11) NOT NULL,");
  78.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGALIL` int(11) NOT NULL,");
  79.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsAUG` int(11) NOT NULL,");
  80.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsM3` int(11) NOT NULL,");
  81.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsXM1014` int(11) NOT NULL,");
  82.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsKNIFE` int(11) NOT NULL,");
  83.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsDEAGLE` int(11) NOT NULL,");
  84.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsUSP` int(11) NOT NULL,");
  85.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_uPointsGLOCK` int(11) NOT NULL,");
  86.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM4A1` int(11) NOT NULL,");
  87.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAK47` int(11) NOT NULL,");
  88.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAWP` int(11) NOT NULL,");
  89.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunSCOUT` int(11) NOT NULL,");
  90.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunFAMAS` int(11) NOT NULL,");
  91.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGALIL` int(11) NOT NULL,");
  92.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunAUG` int(11) NOT NULL,");
  93.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunM3` int(11) NOT NULL,");
  94.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunXM1014` int(11) NOT NULL,");
  95.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunKNIFE` int(11) NOT NULL,");
  96.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunDEAGLE` int(11) NOT NULL,");
  97.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunUSP` int(11) NOT NULL,");
  98.     iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "`g_SelectedGunGLOCK` int(11) NOT NULL)");
  99.    
  100.     SQL_ThreadQuery(g_SqlTuple, "TableCreateThread", sQuery);
  101. }
  102. public TableUpdate(id)
  103. {
  104.     if(betoltve[id]) {
  105.         static sQuery[10048];
  106.         new iLen, sSteamID[64];
  107.         get_user_authid(id, sSteamID, charsmax(sSteamID));
  108.        
  109.         iLen += formatex(sQuery[iLen], charsmax(sQuery), "UPDATE `%s` SET ", Tablename);
  110.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "qSzint = ^"%i^",", g_ePlayer[id][eLvl]);
  111.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "qXp = ^"%i^",", g_ePlayer[id][eXp]);
  112.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "qRank = ^"%i^",", g_ePlayer[id][eRank]);
  113.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "qRankCounter = ^"%i^",", g_ePlayer[id][eRankCounter]);
  114.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM4A1 = ^"%i^",", g_uPoints[id][M4A1]);
  115.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAK47 = ^"%i^",", g_uPoints[id][AK47]);
  116.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAWP = ^"%i^",", g_uPoints[id][AWP]);
  117.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsSCOUT = ^"%i^",", g_uPoints[id][SCOUT]);
  118.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsFAMAS = ^"%i^",", g_uPoints[id][FAMAS]);
  119.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGALIL = ^"%i^",", g_uPoints[id][GALIL]);
  120.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsAUG = ^"%i^",", g_uPoints[id][AUG]);
  121.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsM3 = ^"%i^",", g_uPoints[id][M3]);
  122.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsXM1014 = ^"%i^",", g_uPoints[id][XM1014]);
  123.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsKNIFE = ^"%i^",", g_uPoints[id][KNIFE]);
  124.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsDEAGLE = ^"%i^",", g_uPoints[id][DEAGLE]);
  125.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsUSP = ^"%i^",", g_uPoints[id][USP]);
  126.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_uPointsGLOCK = ^"%i^",", g_uPoints[id][GLOCK]);
  127.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAK47 = ^"%i^",", g_SelectedGun[id][AK47]);
  128.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAWP = ^"%i^",", g_SelectedGun[id][AWP]);
  129.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunSCOUT = ^"%i^",", g_SelectedGun[id][SCOUT]);
  130.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunFAMAS = ^"%i^",", g_SelectedGun[id][FAMAS]);
  131.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGALIL = ^"%i^",", g_SelectedGun[id][GALIL]);
  132.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunAUG = ^"%i^",", g_SelectedGun[id][AUG]);
  133.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM3 = ^"%i^",", g_SelectedGun[id][M3]);
  134.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunXM1014 = ^"%i^",", g_SelectedGun[id][XM1014]);
  135.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunKNIFE = ^"%i^",", g_SelectedGun[id][KNIFE]);
  136.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunDEAGLE = ^"%i^",", g_SelectedGun[id][DEAGLE]);
  137.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunUSP = ^"%i^",", g_SelectedGun[id][USP]);
  138.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunGLOCK = ^"%i^",", g_SelectedGun[id][GLOCK]);
  139.        
  140.         iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen, "g_SelectedGunM4A1 = ^"%i^" WHERE `SteamId` = ^"%s^";", g_SelectedGun[id][M4A1], sSteamID);
  141.         SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  142.     }
  143. }
  144. public TableCreateThread(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  145. {
  146.     if(iFailState == TQUERY_CONNECT_FAILED)
  147.         set_fail_state("[Create] Nem lehet csatlakozni az adatbazishoz!");
  148.     else if(iFailState == TQUERY_QUERY_FAILED)
  149.         set_fail_state("[Create] Lekerdezesi hiba");
  150.     if(iErrcode)
  151.         log_amx("[Create] Hiba:**!! %s !!**", sError);
  152. }
  153. public TableInsert(id)
  154. {
  155.     static sQuery[10048], sSteamID[64];
  156.    
  157.     get_user_authid(id, sSteamID, charsmax(sSteamID));
  158.     formatex(sQuery, charsmax(sQuery), "INSERT INTO `%s` (`SteamId`) VALUES (^"%s^");", Tablename, sSteamID);
  159.     SQL_ThreadQuery(g_SqlTuple, "QuerySetDataTable", sQuery);
  160.     betoltve[id] = true;
  161. }
  162. public SelectDataTable(id)
  163. {
  164.     static sQuery[10048];
  165.     new sData[1], sSteamID[64];
  166.     sData[0] = id;
  167.    
  168.     get_user_authid(id, sSteamID, charsmax(sSteamID));
  169.    
  170.     formatex(sQuery, charsmax(sQuery), "SELECT * FROM `%s` WHERE SteamId = ^"%s^";", Tablename, sSteamID);
  171.     SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataTable", sQuery, sData, 1);
  172. }
  173. public QuerySelectDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  174. {
  175.     if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  176.     {
  177.         log_amx("[Insert] Hiba:**!! %s !!**", sError);
  178.         return;
  179.     }
  180.     else
  181.     {
  182.         new id = sData[0];
  183.        
  184.         if(SQL_NumRows(sQuery) > 0)
  185.         {
  186.             g_ePlayer[id][eLvl] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "qSzint"));
  187.             g_ePlayer[id][eXp] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "qXp"));
  188.             g_ePlayer[id][eRank] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "qRank"));
  189.             g_ePlayer[id][eRankCounter] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "qRankCounter"));
  190.             g_uPoints[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM4A1"));
  191.             g_uPoints[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAK47"));
  192.             g_uPoints[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAWP"));
  193.             g_uPoints[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsSCOUT"));
  194.             g_uPoints[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsFAMAS"));
  195.             g_uPoints[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGALIL"));
  196.             g_uPoints[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsAUG"));
  197.             g_uPoints[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsM3"));
  198.             g_uPoints[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsXM1014"));
  199.             g_uPoints[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsKNIFE"));
  200.             g_uPoints[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsDEAGLE"));
  201.             g_uPoints[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsUSP"));
  202.             g_uPoints[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_uPointsGLOCK"));
  203.             g_SelectedGun[id][M4A1] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM4A1"));
  204.             g_SelectedGun[id][AK47] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAK47"));
  205.             g_SelectedGun[id][AWP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAWP"));
  206.             g_SelectedGun[id][SCOUT] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunSCOUT"));
  207.             g_SelectedGun[id][FAMAS] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunFAMAS"));
  208.             g_SelectedGun[id][GALIL] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGALIL"));
  209.             g_SelectedGun[id][AUG] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunAUG"));
  210.             g_SelectedGun[id][M3] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunM3"));
  211.             g_SelectedGun[id][XM1014] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunXM1014"));
  212.             g_SelectedGun[id][KNIFE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunKNIFE"));
  213.             g_SelectedGun[id][DEAGLE] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunDEAGLE"));
  214.             g_SelectedGun[id][USP] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunUSP"));
  215.             g_SelectedGun[id][GLOCK] = SQL_ReadResult(sQuery, SQL_FieldNameToNum(sQuery, "g_SelectedGunGLOCK"));
  216.             betoltve[id] = true;
  217.         }
  218.         else
  219.             TableInsert(id);
  220.     }
  221. }
  222. public QuerySetDataTable(iFailState, Handle:sQuery, sError[], iErrcode, sData[], iDataSize, Float:fQueuetime)
  223. {
  224.     if(iFailState == TQUERY_CONNECT_FAILED || iFailState == TQUERY_QUERY_FAILED)
  225.     {
  226.         log_amx("[SetData] Hiba:**!! %s !!**", sError);
  227.         return;
  228. }
GeSHi © Codebox Plus


Hozzászólás jelentése
Vissza a tetejére
   
Hozzászólás az előzmény idézésével  
Hozzászólások megjelenítése: Rendezés 
Új téma nyitása Hozzászólás a témához  Oldal: 1 / 1
  [4 hozzászólás ] 

» » » »


Ki van itt

Jelenlévő fórumozók: nincs regisztrált felhasználó valamint 3 vendég

Nyithatsz új témákat ebben a fórumban.
Válaszolhatsz egy témára ebben a fórumban.
Nem szerkesztheted a hozzászólásaidat ebben a fórumban.
Nem törölheted a hozzászólásaidat ebben a fórumban.
Nem küldhetsz csatolmányokat ebben a fórumban.

Keresés:
Ugrás:  
Powered by phpBB® Forum Software © phpBB Limited
Magyar fordítás © Magyar phpBB Közösség
Portal: Kiss Portal Extension © Michael O'Toole