Вниманию участников! Данный форум теперь является архивом и вскором времени здесь нельзя будет создавать новых тем! Просьба всем для общения и создания новых тем перейти на наш новый форум: http://amxmodx.su/

"STEAM_0:0:19399933" "H3043M" "Forwards" "241.761825" "298.686553" "340.424804" 6 76

"authid" "name" "type" "distance" "prestrafe" "maxspeed" "strafes" "sync"

public sbj_handler(failstate, Handle:query, error[], errnum, data[], size, Float:queuetime)  
{  
  if(file_exists(demos_sbj))     
  {     
   new line, stxtsize   
   new name[33], authid[33]
   new distance[16], maxspeed[16], prestrafe[16], strafes[16], sync[16]
   new pretype[33]
    
   while((line=read_file(demos_sbj,line,name,32,stxtsize))!=0)  
   {     
    line=read_file(demos_sbj,line,authid,32,stxtsize)
    line=read_file(demos_sbj,line,distance,15,stxtsize)
    line=read_file(demos_sbj, line,maxspeed,15,stxtsize)
    line=read_file(demos_sbj,line,prestrafe,15,stxtsize)
    line=read_file(demos_sbj,line,strafes,15,stxtsize)
    l ine=read_file(demos_sbj,line,sync,15,stxtsize)
    line=read_file(demos_sbj,line,pretype,32,stxtsize)
     
    if(!SQL_MoreResults(query))  
    {
     new query[1024]  
     formatex( query, 1023, "INSERT INTO `js_sbj` VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", authid, name, type, distance, prestrafe, maxspeed, strafes, sync )
     SQL_ThreadQuery(DB_TUPLE,"db_save_handler",query)  
    }
    else
    {
     new g_name[33], g_pretype[33], g_authid[33]
      
     SQL_ReadResult(query, 0, g_name, 32)
     SQL_ReadResult(query, 1, g_authid, 32)
     new g_distance = SQL_ReadResult(query, 2)
     new g_maxspeed = SQL_ReadResult(query, 3)
     new g_prestrafe = SQL_ReadResult(query, 4)
     new g_strafes = SQL_ReadResult(query, 5)
     new g_sync = SQL_ReadResult(query, 6)
     SQL_ReadResult(query, 7, g_pretype, 32)
      
     if(!equal(name[32], g_name[32]) && !equal(authid[32], g_authid[32]) && distance[15] != g_distance && maxspeed[15] != g_maxspeed && prestrafe[15] != g_prestrafe && sync[15] != g_sync && !equal(pretype[32], g_pretype[32]) && strafes[15] != g_strafes)
     {
      new query[1024]  
      formatex( query, 1023, "INSERT INTO `js_sbj` VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", authid, name, type, distance, prestrafe, maxspeed, strafes, sync )  
      SQL_ThreadQuery(DB_TUPLE,"db_save_handler",query)  
     }
     else  
      return PLUGIN_CONTINUE
    }
     
   }  
  }  
  else
   log_amx("Failed To Load standupbhopjumps.txt !")  
   
  return PLUGIN_CONTINUE
}

while((line=read_file(demos_sbj,line,data,255,stxtsize))!=0)

  while((line=read_file(demos_bj,line,data,255,stxtsize))!=0)  
   {     
    parse(data, authid, 32, name, 32, type, 32, distance, 15, prestrafe, 15, maxspeed, 15, strafes, 15)

public bj_handler(failstate, Handle:query, error[], errnum, data[], size, Float:queuetime)    
{    
    if(file_exists(demos_bj))       
    {       
     new line, stxtsize
     new data[256]     
     new authid[33], name[33]
     new type[33], distance[16], prestrafe[16], maxspeed[16], strafes[16]
     new sync[16]
        
     while((line=read_file(demos_bj,line,data,255,stxtsize))!=0)    
     {       
      parse(data, authid, 32, name, 32, type, 32, distance, 15, prestrafe, 15, maxspeed, 15, strafes, 15, sync, 15)    
         
      if(!SQL_MoreResults(query))    
      {
       new query[1024]    
       formatex( query, 1023, "INSERT INTO `js_bj` VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", authid, name, type, distance, prestrafe, maxspeed, strafes, sync )
       SQL_ThreadQuery(DB_TUPLE,"db_save_handler",query)    
      }
      else
      {
       new g_name[33], g_type[33], g_authid[33]
          
       SQL_ReadResult(query, 0, g_name, 32)
       SQL_ReadResult(query, 1, g_authid, 32)
       new g_distance = SQL_ReadResult(query, 2)
       new g_maxspeed = SQL_ReadResult(query, 3)
       new g_prestrafe = SQL_ReadResult(query, 4)
       new g_strafes = SQL_ReadResult(query, 5)
       new g_sync = SQL_ReadResult(query, 6)
       SQL_ReadResult(query, 7, g_pretype, 32)
          
       if(!equal(authid[32], g_authid[32]) && !equal(name[32], g_name[32]) && !equal(type[32], g_type[32]) && distance[15] != g_distance && prestrafe[15] != g_prestrafe && maxspeed[15] != g_maxspeed && strafes[15] != g_strafes && sync[15] != g_sync)
       {
        new query[1024]    
        formatex( query, 1023, "INSERT INTO `js_bj` VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", authid, name, type, distance, prestrafe, maxspeed, strafes, sync )    
        SQL_ThreadQuery(DB_TUPLE,"db_save_handler",query)    
       }
       else    
        return PLUGIN_CONTINUE
      }
         
     }    
    }    
    else
     log_amx("[Web_JumpStats] Failed To Load bhopjumps.txt !")    
       
    return PLUGIN_CONTINUE
}    

public make_xj_table()    
{    
    if(file_exists(demos_xj))       
    {       
     new line, stxtsize       
     new data[256]       
     new map_name[32], name[32]    
     new fin_time[8]    
     new query[1024]    
        
     while((line=read_file(demos_xj,line,data,255,stxtsize))!=0)    
     {       
      parse(data, map_name, 31, fin_time, 7, name, 31)    
         
      formatex( query, 1023, "INSERT INTO `rec_xj` VALUES ('%s', '%s', '%s')", map_name, fin_time, name  )    
      SQL_ThreadQuery(DB_TUPLE,"db_save_handler",query)    
     }    
    }    
    else    
    {    
     log_amx("Failed To Load demos_xj.txt !")    
    }    
}