hlmod.hu

}
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 `derbyawpp2`");
   Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,");
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Euro` 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, "`Masodpercek` int(11) NOT NULL,");   
   Len += formatex(Query[Len], charsmax(Query)-Len, "`Coin` int(11) NOT NULL,");
   
   for(new i;i < FEGYO; 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, "`L%d` int(11) NOT NULL,", i);
   for(new i;i < KULCS; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`K%d` int(11) NOT NULL,", i);
   for(new i;i < 2; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "`S%d` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)", i);
   
   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 `derbyawpp2` 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) {
         PP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Coin"));
         Vip[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vip"));
         VipIdo[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipIdo"));
         Euro[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Euro"));
         DropOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DropOles"));
         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"));
         idke[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "id"));
         
         for(new i;i < FEGYO; 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), "L%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), "K%d", i);
            Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }
         for(new i;i < 2; i++)
         {
            new String[64];
            formatex(String, charsmax(String), "S%d", i);
            Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
         }         
      }
      else
      {
         Save(id);
      }
   }
}
public Save(id)
{
static Query[256];
 
formatex(Query, charsmax(Query), "INSERT INTO `derbyawpp2` (`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 `derbyawpp2` 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 `derbyawpp2` Euro = ^"%i^", ",Euro[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "DropOles = ^"%i^", ", DropOles[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "Vip = ^"%i^", ", Vip[id]);
   Len += formatex(Query[Len], charsmax(Query)-Len, "VipIdo = ^"%i^", ", VipIdo[id]-get_user_time(id));
   Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));   
   Len += formatex(Query[Len], charsmax(Query)-Len, "Coin = ^"%i^", ", PP[id]);
   
   for(new i=0;i < FEGYO; 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, "L%d = ^"%i^", ", i, Lada[i][id]);
      
   for(new i;i < KULCS; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "K%d = ^"%i^", ", i, Kulcs[i][id]);
      
   for(new i;i < 2; i++)
      Len += formatex(Query[Len], charsmax(Query)-Len, "S%d = ^"%i^", ", i, Skin[i][id]);
   
   Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE Nev = ^"%s^";", 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;
   }
}