function lgsl_query_cached($type, $ip, $c_port, $q_port, $s_port, $request)

  {

    global $lgsl_config;



    lgsl_database();



    // PROTECT THE DATABASE QUERY



    $type    = mysql_real_escape_string($type);

    $ip      = mysql_real_escape_string($ip);

    $c_port  = mysql_real_escape_string(intval($c_port));

    $q_port  = mysql_real_escape_string(intval($q_port));

    $s_port  = mysql_real_escape_string(intval($s_port));



    // GET CACHE



    $mysql_query  = "SELECT * FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE `type`='{$type}' AND `ip`='{$ip}' AND `q_port`='{$q_port}' LIMIT 1";

    $mysql_result = mysql_query($mysql_query) or die(mysql_error());

    $mysql_row    = mysql_fetch_array($mysql_result, MYSQL_ASSOC);



    // CHECK IF SERVER IS NOT IN THE DATABASE AND ADD IF REQUESTED



    if (!$mysql_row)

    {

      if (strpos($request, "a") !== FALSE)

      {

        $mysql_query     = "INSERT INTO `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` (`type`,`ip`,`c_port`,`q_port`,`s_port`,`cache`,`cache_time`) VALUES ('{$type}','{$ip}','{$c_port}','{$q_port}','{$s_port}','','')";

        $mysql_result    = mysql_query($mysql_query) or die(mysql_error());

        $mysql_row['id'] = mysql_insert_id();

      }

      else

      {

        exit("LGSL PROBLEM: REQUESTED SERVER NOT IN DATABASE: '{$type} : {$ip} : {$c_port} : {$q_port} : {$s_port} : {$request}'");

      }

    }



    // UNPACK CACHE AND CACHE TIMES



    $cache         = unserialize(base64_decode($mysql_row['cache']));

    $cache_time    = explode("_", $mysql_row['cache_time']);

    $cache_time[0] = intval($cache_time[0]);

    $cache_time[1] = intval($cache_time[1]);

    $cache_time[2] = intval($cache_time[2]);



    // SET THE SERVER AS OFFLINE AND PENDING WHEN THERE IS NO CACHE



    if (!isset($cache['b']))

    {

      $cache      = array();

      $cache['b'] = array();

      $cache['b']['status']  = 0;

      $cache['b']['pending'] = 1;

    }



    // IF NEEDED CONVERT HOSTNAME TO IP



    if ($lgsl_config['host_to_ip'])

    {

      $ip = gethostbyname($ip);

    }



    // ALWAYS UPDATE THESE WITH THE LATEST VALUES



    $cache['b']['type']    = $type;

    $cache['b']['ip']      = $ip;

    $cache['b']['c_port']  = $c_port;

    $cache['b']['q_port']  = $q_port;

    $cache['b']['s_port']  = $s_port;

    $cache['o']['request'] = $request;

    $cache['o']['id']      = $mysql_row['id'];

    $cache['o']['zone']    = $mysql_row['zone'];

    $cache['o']['comment'] = $mysql_row['comment'];



    if (!isset($cache['s']))

    {

      $cache['s']               = array();

      $cache['s']['game']       = $type;

      $cache['s']['name']       = $lgsl_config['text']['nnm'];

      $cache['s']['map']        = $lgsl_config['text']['nmp'];

      $cache['s']['players']    = 0;

      $cache['s']['playersmax'] = 0;

      $cache['s']['password']   = 0;

    }



    if (!isset($cache['e'])) { $cache['e'] = array(); }

    if (!isset($cache['p'])) { $cache['p'] = array(); }



    // CHECK WHAT IS NEEDED



    $needed = "";



    if (strpos($request, "c") === FALSE) // CACHE ONLY REQUEST

    {

      if (strpos($request, "s") !== FALSE && time() > ($cache_time[0]+$lgsl_config['cache_time'])) { $needed .= "s"; }

      if (strpos($request, "e") !== FALSE && time() > ($cache_time[1]+$lgsl_config['cache_time'])) { $needed .= "e"; }

      if (strpos($request, "p") !== FALSE && time() > ($cache_time[2]+$lgsl_config['cache_time'])) { $needed .= "p"; }

    }



    if ($needed)

    {

      // UPDATE CACHE TIMES BEFORE QUERY - PREVENTS OTHER INSTANCES FROM QUERY FLOODING THE SAME SERVER



      $packed_times = time() + $lgsl_config['cache_time'] + 10;

      $packed_times = "{$packed_times}_{$packed_times}_{$packed_times}";

      $mysql_query  = "UPDATE `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` SET `cache_time`='{$packed_times}' WHERE `id`='{$mysql_row['id']}' LIMIT 1";

      $mysql_result = mysql_query($mysql_query) or die(mysql_error());



      // GET WHAT IS NEEDED



      $live = lgsl_query_live($type, $ip, $c_port, $q_port, $s_port, $needed);



      if (!$live['b']['status'] && $lgsl_config['retry_offline'] && !$lgsl_config['feed']['method'])

      {

        $live = lgsl_query_live($type, $ip, $c_port, $q_port, $s_port, $needed);

      }



      // CHECK AND CONVERT TO UTF-8 WHERE NEEDED



      $live = lgsl_charset_convert($live, lgsl_charset_detect($live));



      // IF SERVER IS OFFLINE PRESERVE SOME OF THE CACHE AND CLEAR THE REST



      if (!$live['b']['status'])

      {

        $live['s']['game']       = $cache['s']['game'];

        $live['s']['name']       = $cache['s']['name'];

        $live['s']['map']        = $cache['s']['map'];

        $live['s']['password']   = $cache['s']['password'];

        $live['s']['players']    = 0;

        $live['s']['playersmax'] = $cache['s']['playersmax'];

        $live['e']               = array();

        $live['p']               = array();

      }



      // MERGE LIVE INTO CACHE



      if (isset($live['b'])) { $cache['b'] = $live['b']; }

      if (isset($live['s'])) { $cache['s'] = $live['s']; $cache_time[0] = time(); }

      if (isset($live['e'])) { $cache['e'] = $live['e']; $cache_time[1] = time(); }

      if (isset($live['p'])) { $cache['p'] = $live['p']; $cache_time[2] = time(); }



      // UPDATE CACHE



      $packed_cache = mysql_real_escape_string(base64_encode(serialize($cache)));

      $packed_times = mysql_real_escape_string(implode("_", $cache_time));

      $mysql_query  = "UPDATE `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` SET `status`='{$cache['b']['status']}',`cache`='{$packed_cache}',`cache_time`='{$packed_times}' WHERE `id`='{$mysql_row['id']}' LIMIT 1";

      $mysql_result = mysql_query($mysql_query) or die(mysql_error());

    }



    // RETURN ONLY THE REQUESTED



    if (strpos($request, "s") === FALSE) { unset($cache['s']); }

    if (strpos($request, "e") === FALSE) { unset($cache['e']); }

    if (strpos($request, "p") === FALSE) { unset($cache['p']); }



    return $cache;

  }