hlmod.hu

L 04/15/2018 - 15:21:46: [AMXX] Plugin ("rtd.amxx") is setting itself as failed.
L 04/15/2018 - 15:21:46: [AMXX] Plugin says: Query Error
L 04/15/2018 - 15:21:46: [AMXX] Run time error 1 (plugin "rtd.amxx") - forced exit

public client_disconnect(id)
{
if(!is_user_bot(id))
{
   Update(id);
}
Belepve[id] = false;
Beirtjelszot[id] = false;
Beirtjelszot1[id] = false;
Beirtfelhasznalot[id] = false;
Beirtfelhasznalot1[id] = false;

regFh[id][0] = EOS;
regJelszo[id][0] = EOS;
Felhasznalonev[id][0] = EOS;
Jelszo[id][0] = EOS;

Dollar[id] = 0;
Forint[id] = 0;
Rang[id] = 0;
Oles[id] = 0;
SMS[id] = 0;
g_MVP[id] = 0;
Masodpercek[id] = 0;
Regisztralt[id] = 0;
AutoB[id] = 0;
g_VipTime[id] = 0;
g_Quest[id] = 0;
g_QuestWeapon[id] = 0;
g_QuestMVP[id] = 0;
g_QuestHead[id] = 0;
g_Erem[id] = 0;
g_MatchesWon[id] = 0;

for(new i;i < STAWP; i++) 
g_sTAWP[i][id] = 0;

for(new i;i < STKALA; i++) 
g_sTAK[i][id] = 0;

for(new i;i < STCOLT; i++) 
g_sTM4[i][id] = 0;

for(new i;i < STDEAGLE; i++) 
g_sTDG[i][id] = 0;

for(new i;i < STUSP; i++) 
g_sTUSP[i][id] = 0;

for(new i;i < STKNIFE; i++) 
g_sTKNIFE[i][id] = 0;

for(new i;i < MAX; i++)
OsszesSkin[i][id] = 0;

for(new i;i < LADA; i++)
Lada[i][id] = 0;

for(new i;i < KULCS; i++)
Kulcs[i][id] = 0;

copy(name[id], charsmax(name[]), "");
}
public client_putinserver(id)
{
if(!is_user_bot(id))
{
   get_user_name(id, name[id], charsmax(name));
   Load(id);
}
Gun[id] = true;
Hud[id] = true;
Belepve[id] = false;
Felhasznalonev[id] = "";
Jelszo[id] = "";
}
public plugin_cfg()
{
   g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
   
   static Query[10048];
   new Len;
   
   Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `rtd_go_uj5`");
   Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`SMS` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`MVP` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`AutoB` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Ermek` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Forint` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`DropOles` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Vip` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`VipIdo` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestH` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestMVP` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestNeed` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestHave` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestWeap` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestHead` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`JutLada` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`JutKulcs` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`JutPont` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`JutDoll` int(11) NOT NULL,"); 
   Len += formatex(Query[Len], charsmax(Query)-Len, "`NyertM` int(11) NOT NULL,"); 

   for(new i;i < STAWP; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`STA%d` int(11) NOT NULL,", i);
   for(new i;i < STKALA; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`STK%d` int(11) NOT NULL,", i);
   for(new i;i < STCOLT; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`STM%d` int(11) NOT NULL,", i);
   for(new i;i < STDEAGLE; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`STG%d` int(11) NOT NULL,", i);
   for(new i;i < STUSP; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`STU%d` int(11) NOT NULL,", i);
   for(new i;i < STKNIFE; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`STKN%d` int(11) NOT NULL,", i);
   for(new i;i < MAX; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`F%d` int(11) NOT NULL,", i);
   for(new i;i < LADA; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`LA%d` int(11) NOT NULL,", i);
   for(new i;i < KULCS; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`KU%d` int(11) NOT NULL,", i);
   for(new i;i < 11; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`S%d` int(11) NOT NULL,", i);
   
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");
   
   SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
}
public Load(id) {
   static Query[10048];
   new Data[1], Name[32];
   get_user_name(id, Name, 31);
   Data[0] = id;

   formatex(Query, charsmax(Query), "SELECT * FROM `rtd_go_uj5` WHERE Nev = ^"%s^";", name[id]);
   SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
}
public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
   if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
      log_amx("%s", Error);
      return;
   }
   else {
      new id = Data[0];
 
      if(SQL_NumRows(Query) > 0) {
         Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));
         Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars"));
         Forint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Forint"));
         SMS[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SMS"));
         g_MVP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "MVP"));
         AutoB[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AutoB"));
         g_Erem[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Ermek"));
         Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));
         D_Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DropOles"));
         Vip[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vip"));
         g_VipTime[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipIdo"));
         Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));
         SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Felhasznalonev"), regFh[id], charsmax(regFh[]));
         SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[]));
         Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt"));
         g_Quest[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestH"));
         g_QuestMVP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestMVP"));
         g_QuestKills[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestNeed"));
         g_QuestKills[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHave"));
         g_QuestWeapon[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestWeap"));
         g_QuestHead[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHead"));
         g_Jutalom[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutLada"));
         g_Jutalom[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutKulcs"));
         g_Jutalom[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutPont"));
         g_Jutalom[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutDoll"));
         g_MatchesWon[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "NyertM"));
         
         for(new i;i < MAX; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "F%d", i);
            OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         for(new i;i < LADA; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "LA%d", i);
            Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         for(new i;i < KULCS; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "KU%d", i);
            Kulcs[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         for(new i;i < 11; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "S%d", i);
            Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         
         for(new i;i < STAWP; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "STA%d", i);
            g_sTAWP[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         
         for(new i;i < STKALA; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "STK%d", i);
            g_sTAK[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         
         for(new i;i < STCOLT; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "STM%d", i);
            g_sTM4[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         
         for(new i;i < STDEAGLE; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "STG%d", i);
            g_sTDG[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         
         for(new i;i < STUSP; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "STU%d", i);
            g_sTUSP[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         for(new i;i < STKNIFE; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "STKN%d", i);
            g_sTKNIFE[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
      }
      else
      {
         Save(id);
      }
   }
}
public Save(id)
{
static Query[256];
 
formatex(Query, charsmax(Query), "INSERT INTO `rtd_go_uj5` (`Nev`) VALUES (^"%s^");", name[id]);
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public SQL_Update_Reg(id)
{
static Query[10048];
new Len;

Len += formatex(Query[Len], charsmax(Query), "UPDATE `rtd_go_uj5` SET Felhasznalonev = ^"%s^", ", regFh[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Jelszo = ^"%s^", ", regJelszo[id]);
Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralt = ^"%i^" WHERE Nev = ^"%s^";", Regisztralt[id], name[id]);

SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update(id)
{
   static Query[10048];
   new Len;
   
   Len += formatex(Query[Len], charsmax(Query), "UPDATE `rtd_go_uj5` SET Dollars = ^"%i^", ",Dollar[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Forint = ^"%i^", ", Forint[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "DropOles = ^"%i^", ", D_Oles[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Ermek = ^"%i^", ", g_Erem[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "AutoB = ^"%i^", ", AutoB[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));
   Len += formatex(Query[Len], charsmax(Query)-Len, "SMS = ^"%i^", ", SMS[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "MVP = ^"%i^", ", g_MVP[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Vip = ^"%i^", ", Vip[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "VipIdo = ^"%i^", ", g_VipTime[id]-get_user_time(id));
   Len += formatex(Query[Len], charsmax(Query)-Len, "QuestH = '%i', ", g_Quest[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "QuestMVP = '%i', ", g_QuestMVP[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "QuestNeed = '%i', ", g_QuestKills[0][id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "QuestHave = '%i', ", g_QuestKills[1][id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "QuestWeap = '%i', ", g_QuestWeapon[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "QuestHead = '%i', ", g_QuestHead[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "JutLada = '%i', ", g_Jutalom[0][id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "JutKulcs = '%i', ", g_Jutalom[1][id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "JutPont = '%i', ", g_Jutalom[2][id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "JutDoll = '%i', ", g_Jutalom[3][id]); 
   Len += formatex(Query[Len], charsmax(Query)-Len, "NyertM = '%i', ", g_MatchesWon[id]); 
   
   for(new i=0;i < STAWP; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "STA%d = ^"%i^", ", i, g_sTAWP[i][id]);
      
   for(new i;i < STKALA; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "STK%d = ^"%i^", ", i, g_sTAK[i][id]);
      
   for(new i;i < STCOLT; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "STM%d = ^"%i^", ", i, g_sTM4[i][id]);
      
   for(new i;i < STDEAGLE; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "STG%d = ^"%i^", ", i, g_sTDG[i][id]);
      
   for(new i;i < STUSP; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "STU%d = ^"%i^", ", i, g_sTUSP[i][id]);
      
   for(new i;i < STKNIFE; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "STKN%d = ^"%i^", ", i, g_sTKNIFE[i][id]);
      
   for(new i=0;i < MAX; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "F%d = ^"%i^", ", i, OsszesSkin[i][id]);
      
   for(new i;i < LADA; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "LA%d = ^"%i^", ", i, Lada[i][id]);
      
   for(new i;i < KULCS; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "KU%d = ^"%i^", ", i, Kulcs[i][id]);
      
   for(new i;i < 11; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "S%d = ^"%i^", ", i, Skin[i][id]);
   
   Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^" WHERE Nev = ^"%s^";", Kulcs[id], name[id]);
   
   SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
   if(FailState == TQUERY_CONNECT_FAILED)
      set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!");
   else if(FailState == TQUERY_QUERY_FAILED)
      set_fail_state("Query Error");
   if(Errcode)
      log_amx("[HIBA*] HIBAT DOBTAM: %s",Error);
}
public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
   if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
      log_amx("%s", Error);
      return;
   }
}
public plugin_end() {
   SQL_FreeHandle(g_SqlTuple);
}