Richard Perry - GreyCube.com: Forums / Live Game Server List / DATABASE

Richard Perry - GreyCube.com :: Forums :: Live Game Server List

DATABASE

lexta

Thu Nov 03 2011, 06:01PM

Posts: 14
Joined: Sun Jan 16 2011, 05:02PM
Registered Member #6517

Hello!

I added another structure database column named "user"

but when I add a server from administrator panel and give save the data in column "users" are deleted

where should I change to no longer delete?

xMin

Fri Nov 04 2011, 07:20AM

Posts: 54
Joined: Fri Mar 04 2011, 08:41AM
Registered Member #6619

That is BUG in Admin panel! If you do ANYTHING in Admin panel and click Save *(Keep Cache or Reset Cache)* that will reset your database to default settings and clear any of your added fields to empty value.. just don't use Admin.php from your lgsl and all will be ok! I did recreated Admin panel but in another structure for my gt and I don't have this problem for long time

lexta

Fri Nov 04 2011, 01:42PM

Posts: 14
Joined: Sun Jan 16 2011, 05:02PM
Registered Member #6517

Rich you can help me ?

Dodgeitorelse

Sun Nov 06 2011, 12:33AM

Posts: 175
Joined: Sun Dec 12 2010, 09:16AM
Registered Member #6457

thats true gt unless you also edit lgsl_add.php

for example when I added website column and added by column I had to edit a few areas to get it to keep all

so when a user adds a server he is asked in lgsl form for his name and website address. this is added to lgsl database and also shows in admin panel. gets tricky the more you want to modify.

so you must modify lgsl_add.php

below is my lgsl_add.php file


<?php



 /*----------------------------------------------------------------------------------------------------------\

 |                                                                                                            |

 |                      [ LIVE GAME SERVER LIST ] [ © RICHARD PERRY FROM GREYCUBE.COM ]                       |

 |                                                                                                            |

 |    Released under the terms and conditions of the GNU General Public License Version 3 (http://gnu.org)    |

 |                                                                                                            |

 \-----------------------------------------------------------------------------------------------------------*/



//------------------------------------------------------------------------------------------------------------+



  require "lgsl_class.php";

  include "logged_username2.php";

//-----------------------------------------------------------------------------------------------------------+





// will warn if public adding is disabled

  if (!$lgsl_config['public_add'])

  {

    $output .= "

    <div style='text-align:center;".lgsl_bg()."'>

      <br />

      {$lgsl_config['text']['asd']}

      <br />

      <br />

    </div>";



    return;

  }



//-----------------------------------------------------------------------------------------------------------+



  $lgsl_type_list = lgsl_type_list();

  unset($lgsl_type_list['test']);

  asort($lgsl_type_list);



  $type    = empty($_POST['form_type'])         ? "source"  : trim($_POST['form_type']);

  $comment = empty($_POST['form_comment'])      ? ""        : trim($_POST['form_comment']);

  $ip      = empty($_POST['form_ip'])           ? ""        : trim($_POST['form_ip']);

  $c_port  = empty($_POST['form_c_port'])       ? 0         : intval(trim($_POST['form_c_port']));

  $q_port  = empty($_POST['form_q_port'])       ? 0         : intval(trim($_POST['form_q_port']));

  $s_port  = 0;

  $yourname = empty($_POST['form_yourname'])    ? "{$logged_name[0]}"        : trim($_POST['form_yourname']);

  $yoursite = empty($_POST['form_yoursite'])    ? ""        : trim($_POST['form_yoursite']);



  if     (preg_match("/(\[[0-9a-z\:]+\])/iU", $ip, $match)) { $ip = $match[1]; }

  elseif (preg_match("/([0-9a-z\.\-]+)/i", $ip, $match))    { $ip = $match[1]; }

  else                                                      { $ip = ""; }



  if ($c_port > 99999 || $q_port < 1024) { $c_port = 0; }

  if ($q_port > 99999 || $q_port < 1024) { $q_port = 0; }



  list($c_port, $q_port, $s_port) = lgsl_port_conversion($type, $c_port, $q_port, $s_port);



//-----------------------------------------------------------------------------------------------------------+





//explains reason for this area and displays type:



  $output .= "

  <form method='post' action=''>

    <div style='text-align:center'>

      <table cellpadding='4' cellspacing='2' style='margin:auto; text-align:left'>



        <tr style='".lgsl_bg()."'>

          <td colspan='2' style='text-align:center'>

            <br />

            <font color='white' size =3>

            {$lgsl_config['text']['awm1']}

            <br />

            {$lgsl_config['text']['awm2']}

            </font>

            <br />

            <br />

          </td>

        </tr>



        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['typ']} </td>

          <td>

            <select name='form_type'>";

  //---------------------------------------------------------+

            foreach ($lgsl_type_list as $key => $value)

            {

              $output .= "

              <option ".($key == $type ? "selected='selected'" : "")." value='{$key}'> {$value} </option>";

            }

  //---------------------------------------------------------+

            $output .= "

            </select>

          </td>

        </tr>

        

        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['svrname']} </td>

          <td> <input type='text' name='form_comment' value='".lgsl_string_html($comment)."' size='40' maxlength='128' /> DO NOT use symbols for colored names</td>

        </tr>



        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['adr']} </td>

          <td> <input type='text' name='form_ip' value='".lgsl_string_html($ip)."' size='15' maxlength='128' /> game server ip (format = xxx.xxx.xxx.xxx)</td>

        </tr>



        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['cpt']} </td>

          <td> <input type='text' name='form_c_port' value='".lgsl_string_html($c_port)."' size='5' maxlength='5' /> Suggested for AA2: 1716 or 1916</td>

        </tr>



        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['qpt']} </td>

          <td> <input type='text' name='form_q_port' value='".lgsl_string_html($q_port)."' size='5' maxlength='5' /> Suggested for AA2: 1717 or 7778</td>

        </tr>

        

        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['ynm']} </td>

          <td> <input type='text' name='form_yourname' value='".lgsl_string_html($yourname)."' size='15' maxlength='50' /> Enter your name (your IP is {$_SERVER['REMOTE_ADDR']}) </td>

        </tr>

        

        <tr style='".lgsl_bg()."'>

          <td> {$lgsl_config['text']['ysite']} </td>

          <td> <input type='text' name='form_yoursite' value='".lgsl_string_html($yoursite)."' size='15' maxlength='50' /> Enter your web site (will link to your site from tracker, format = your-site.com/) </td>

        </tr>



        <tr style='".lgsl_bg()."'>

          <td colspan='2' style='text-align:center'>

            <br />ALL FIELDS MUST BE FILLED IN WITH VALID DATA OR SERVER WILL BE REJECTED BY ADMIN<br /><br />

            <input type='submit' name='lgsl_submit_test' value='{$lgsl_config['text']['ats']}'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='javascript:history.go(-1)'><img src='../../../images/back_button_color.gif'>

            <br />

            <br />

          </td>

        </tr>



      </table>



      

      <br />



    </div>

  </form>";



//-----------------------------------------------------------------------------------------------------------+



  if (empty($_POST['lgsl_submit_test']) && empty($_POST['lgsl_submit_add'])) { return; }

  if (!isset($lgsl_type_list[$type]) || !$comment || !$ip || !$c_port || !$q_port  || !$yourname || !$yoursite){ return; }



//-----------------------------------------------------------------------------------------------------------+



  lgsl_database();



  $ip     = mysql_real_escape_string($ip);

  $q_port = mysql_real_escape_string($q_port);

  $c_port = mysql_real_escape_string($c_port);

  $s_port = mysql_real_escape_string($s_port);

  $type   = mysql_real_escape_string($type);

  $comment   = mysql_real_escape_string($comment);

  //$yourname  = mysql_real_escape_string($yourname);

  //$yoursite  = mysql_real_escape_string($yoursite);

   

//-----------------------------------------------------------------------------------------------------------+



  $ip_check     = gethostbyname($ip);

  $mysql_result = mysql_query("SELECT `ip`,`disabled` FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` WHERE `type`='{$type}' AND `q_port`='{$q_port}'");



  while ($mysql_row = mysql_fetch_array($mysql_result, MYSQL_ASSOC))

  {

    if ($ip_check == gethostbyname($mysql_row['ip']))

    {

      $output .= "

      <div style='text-align:center;".lgsl_bg()."'>

        <br />";



        if ($mysql_row['disabled'])

        {

          $output .= $lgsl_config['text']['aaa'];

        }

        else

        {

          $output .= $lgsl_config['text']['aan'];

        }



        $output .="

        <br />

        <br />

      </div>



      <div>

      <br />

      </div>";



      return;

    }

  }



//-----------------------------------------------------------------------------------------------------------+



  $server = lgsl_query_live($type, $ip, $c_port, $q_port, $s_port, "s");

  $server = lgsl_server_html($server);



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

  {

    $output .= "

    <div style='text-align:center;".lgsl_bg()."'>

      <br />

      {$lgsl_config['text']['anr']}

      <br />

      <br />

    </div>



    <div>

    <br />

    </div>";



    return;

  }



//-----------------------------------------------------------------------------------------------------------+



  if (!empty($_POST['lgsl_submit_add']))

  {

    $disabled = ($lgsl_config['public_add'] == "2") ? "0" : "1";



    $mysql_query  = "INSERT INTO `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` (`type`,`ip`,`c_port`,`q_port`,`s_port`,`disabled`,`comment`,`cache`,`cache_time`,`site`) VALUES ('{$type}','{$ip}','{$c_port}','{$q_port}','{$s_port}','{$disabled}','{$comment}','','','<a href=\"$yoursite\" target=\"blank\">$comment</a>')";

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



    $output .= "

    <div style='text-align:center;".lgsl_bg()."'>

      <br />";



      if ($disabled)

      {

        $output .= $lgsl_config['text']['ada'];

      }

      else

      {

        $output .= $lgsl_config['text']['adn'];

      }



      $output .="

      <br />

      <br />

    </div>



    <div>

    <br />

    </div>";



    return;

  }

  

//-----------------------------------------------------------------------------------------------------------+



    $output .= "

  <form method='post' action=''>

    <div style='text-align:center;".lgsl_bg()."'>

      <br />

      {$lgsl_config['text']['asc']}

      <br />

      <br />

    </div>



    <div>

    <br />

    </div>



    <table cellpadding='4' cellspacing='2' style='margin:auto; text-align:left'>

      <tr style='".lgsl_bg()."'> <td> <b> Name:                         </b> </td> <td style='white-space:nowrap'> {$server['s']['name']}                                   </td> </tr>

      <tr style='".lgsl_bg()."'> <td> <b> {$lgsl_config['text']['gme']} </b> </td> <td style='white-space:nowrap'> {$server['s']['game']}                                   </td> </tr>

      <tr style='".lgsl_bg()."'> <td> <b> {$lgsl_config['text']['map']} </b> </td> <td style='white-space:nowrap'> {$server['s']['map']}                                    </td> </tr>

      <tr style='".lgsl_bg()."'> <td> <b> {$lgsl_config['text']['plr']} </b> </td> <td style='white-space:nowrap'> {$server['s']['players']} / {$server['s']['playersmax']} </td> </tr>

        

      <tr style='".lgsl_bg()."'> <td> <b> {$lgsl_config['text']['ysite2']} </b> </td> <td style='white-space:nowrap'> $yoursite </td> </tr>

    </table>



    <div>

    <br />

    </div>



    <div style='text-align:center;".lgsl_bg()."'>

      <br />

      <input type='hidden' name='form_type'       value='".lgsl_string_html($type)."'   />

      <input type='hidden' name='form_comment'    value='".lgsl_string_html($comment)."'/>

      <input type='hidden' name='form_ip'         value='".lgsl_string_html($ip)."'     />

      <input type='hidden' name='form_c_port'     value='".lgsl_string_html($c_port)."' />

      <input type='hidden' name='form_q_port'     value='".lgsl_string_html($q_port)."' />

      <input type='hidden' name='form_yoursite'   value='".$yoursite."' />

      <input type='submit' name='lgsl_submit_add' value='{$lgsl_config['text']['aas']}' />

      <br />

      <br />

    </div>



    <div>

    <br />

    </div>



  </form>";

  

  //Create a text file to write filename that was uploaded and IP of user that uploaded file

date_default_timezone_set('est');

$on = "on " . "";

$added = "was added for admin approval" . "";

$by = "by" . "";

$with = "with" . "";

$sip = " server ip" . "";

$from = "from" . "";

$cws = "claiming the website" . "";

$qm = "\"";

$blank = "" . " ";

$date = date("l, dFY @ h:i:s A");

$filename = "added_servers.txt";

$handle = fopen($filename, "a");

fwrite($handle,  $comment . $blank . $with . $sip . $blank . $ip . $blank . $cws . $blank .  $qm . $yoursite . $qm . $blank . $by . $blank . $yourname . $blank . $from . $blank . $_SERVER['REMOTE_ADDR'] . $blank . $added . $blank . $on . $date . "\n");

fclose($handle);



//------------------------------------------------------------------------------------------------------------+

Dodgeitorelse

Sun Nov 06 2011, 12:40AM

Posts: 175
Joined: Sun Dec 12 2010, 09:16AM
Registered Member #6457

I correct myself

the user name is added to a text file that is written to when a user adds a server. It also gives me their ip and date and time, name of server, server ip and all that so I know who added what. but the website addy is in admin panel

The purpose of the website is so that user click the server name in the tracker and go to that clans website.

xMin

Sun Nov 06 2011, 05:42AM

Posts: 54
Joined: Fri Mar 04 2011, 08:41AM
Registered Member #6619

My gt is a real gametracker

with server rank, players statistic, player banner, community's (with stats), server ownership confirm sistem (Gametracker(userid) for server name), so that simple lgsl Admin panel isn't the solution for me, it has 10 pages for now

Dodgeitorelse

Sun Nov 06 2011, 08:32AM

Posts: 175
Joined: Sun Dec 12 2010, 09:16AM
Registered Member #6457

This was to help lexta with his issue, not telling you that you needed it

Dodgeitorelse

Sun Nov 06 2011, 09:50AM

Posts: 175
Joined: Sun Dec 12 2010, 09:16AM
Registered Member #6457

and this is my file for lgsl/lgsl_files/admin.php


<?php



 /*----------------------------------------------------------------------------------------------------------\

 |                                                                                                            |

 |                      [ LIVE GAME SERVER LIST ] [ © RICHARD PERRY FROM GREYCUBE.COM ]                       |

 |                                                                                                            |

 |    Released under the terms and conditions of the GNU General Public License Version 3 (http://gnu.org)    |

 |                                                                                                            |

 \-----------------------------------------------------------------------------------------------------------*/



//------------------------------------------------------------------------------------------------------------+



  if (!defined("LGSL_ADMIN")) { exit("DIRECT ACCESS ADMIN FILE NOT ALLOWED"); }



  require "lgsl_class.php";



  lgsl_database();

  $lgsl_type_list     = lgsl_type_list(); asort($lgsl_type_list);

  $lgsl_protocol_list = lgsl_protocol_list();



  $id        = 0;

  $last_type = "source";

  $zone_list = array(0,1,2,3,4,5,6,7,8);



//------------------------------------------------------------------------------------------------------------+



  if (!function_exists("fsockopen") && !$lgsl_config['feed']['method'])

  {

    if ((function_exists("curl_init") && function_exists("curl_setopt") && function_exists("curl_exec")))

    {

      $output = "<div style='text-align:center'><br /><br /><b>FSOCKOPEN IS DISABLED - YOU MUST ENABLE THE FEED OPTION</b><br /><br /></div>".lgsl_help_info(); return;

    }

    else

    {

      $output = "<div style='text-align:center'><br /><br /><b>FSOCKOPEN AND CURL ARE DISABLED - LGSL WILL NOT WORK ON THIS HOST</b><br /><br /></div>".lgsl_help_info(); return;

    }

  }



//------------------------------------------------------------------------------------------------------------+



  if ($_POST && get_magic_quotes_gpc()) { $_POST = lgsl_stripslashes_deep($_POST); }



  if (function_exists("mysql_set_charset"))

  {

    @mysql_set_charset("utf8");

  }

  else

  {

    @mysql_query("SET NAMES 'utf8'");

  }



//------------------------------------------------------------------------------------------------------------+



  if (!empty($_POST['lgsl_save_1']) || !empty($_POST['lgsl_save_2']))

  {

    if (!empty($_POST['lgsl_save_1']))

    {

      // LOAD SERVER CACHE INTO MEMORY

      $db = array();

      $mysql_result = mysql_query("SELECT * FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}`");

      while($mysql_row = mysql_fetch_array($mysql_result, MYSQL_ASSOC))

      {

        $db["{$mysql_row['type']}:{$mysql_row['ip']}:{$mysql_row['q_port']}"] = array($mysql_row['status'], $mysql_row['cache'], $mysql_row['cache_time']);

      }

    }



    // EMPTY SQL TABLE

    $mysql_result = mysql_query("TRUNCATE `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}`") or die(mysql_error());



    // CONVERT ADVANCED TO NORMAL DATA FORMAT

    if (!empty($_POST['lgsl_management']))

    {

      $form_lines = explode("\r\n", trim($_POST['form_list']));



      foreach ($form_lines as $form_key => $form_line)

      {

        list($_POST['form_type']    [$form_key],

             $_POST['form_ip']      [$form_key],

             $_POST['form_c_port']  [$form_key],

             $_POST['form_q_port']  [$form_key],

             $_POST['form_s_port']  [$form_key],

             $_POST['form_zone']    [$form_key],

             $_POST['form_disabled'][$form_key],

             $_POST['form_comment'] [$form_key],

             $_POST['form_site'] [$form_key]) = explode(":", "{$form_line}:::::::");

      }

    }



    foreach ($_POST['form_type'] as $form_key => $not_used)

    {

      // COMMENTS LEFT IN THEIR NATIVE ENCODING WITH JUST HTML SPECIAL CHARACTERS CONVERTED

      $_POST['form_comment'][$form_key] = lgsl_htmlspecialchars($_POST['form_comment'][$form_key]);



      $type       = mysql_real_escape_string(               strtolower(trim($_POST['form_type']    [$form_key])));

      $ip         = mysql_real_escape_string(                          trim($_POST['form_ip']      [$form_key]));

      $c_port     = mysql_real_escape_string(                   intval(trim($_POST['form_c_port']  [$form_key])));

      $q_port     = mysql_real_escape_string(                   intval(trim($_POST['form_q_port']  [$form_key])));

      $s_port     = mysql_real_escape_string(                   intval(trim($_POST['form_s_port']  [$form_key])));

      $zone       = mysql_real_escape_string(                          trim($_POST['form_zone']    [$form_key]));

      $disabled   = isset($_POST['form_disabled'][$form_key]) ? intval(trim($_POST['form_disabled'][$form_key])) : "0";

      $comment    = mysql_real_escape_string(                          trim($_POST['form_comment'] [$form_key]));

      $site    = mysql_real_escape_string(                          trim($_POST['form_site'] [$form_key]));



      // CACHE INDEXED BY TYPE:IP:Q_PORT SO IF THEY CHANGE THE CACHE IS IGNORED

      list($status, $cache, $cache_time) = isset($db["{$type}:{$ip}:{$q_port}"]) ? $db["{$type}:{$ip}:{$q_port}"] : array("0", "", "");



      $status     = mysql_real_escape_string($status);

      $cache      = mysql_real_escape_string($cache);

      $cache_time = mysql_real_escape_string($cache_time);



      // THIS PREVENTS PORTS OR WHITESPACE BEING PUT IN THE IP WHILE ALLOWING IPv6

      if     (preg_match("/(\[[0-9a-z\:]+\])/iU", $ip, $match)) { $ip = $match[1]; }

      elseif (preg_match("/([0-9a-z\.\-]+)/i", $ip, $match))    { $ip = $match[1]; }



      list($c_port, $q_port, $s_port) = lgsl_port_conversion($type, $c_port, $q_port, $s_port);



      // DISCARD SERVERS WITH AN EMPTY IP AND AUTO DISABLE SERVERS WITH SOMETHING WRONG

      if     (!$ip)                               { continue; }

      elseif ($c_port < 1 || $c_port > 99999)     { $disabled = 1; $c_port = 0; }

      elseif ($q_port < 1 || $q_port > 99999)     { $disabled = 1; $q_port = 0; }

      elseif (!isset($lgsl_protocol_list[$type])) { $disabled = 1; }



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

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

    }

  }



//------------------------------------------------------------------------------------------------------------+



  if (!empty($_POST['lgsl_map_image_paths']))

  {

    $server_list = lgsl_query_cached_all("s");



    foreach ($server_list as $server)

    {

      if (!$server['b']['status']) { continue; }



      $image_map = lgsl_image_map($server['b']['status'], $server['b']['type'], $server['s']['game'], $server['s']['map'], FALSE);



      $output .= "

      <div>

        <a href='{$image_map}'> {$image_map} </a>

      </div>";

    }



    $output .= "

    <form method='post' action=''>

      <div>

        <br />

        <br />

        <input type='hidden' name='lgsl_management' value='{$_POST['lgsl_management']}' />

        <input type='submit' name='lgsl_return' value='RETURN TO ADMIN' />

        <br />

        <br />

      </div>

    </form>";



    return;

  }



//------------------------------------------------------------------------------------------------------------+



  if ((!empty($_POST['lgsl_management']) && empty($_POST['lgsl_switch'])) || (empty($_POST['lgsl_management']) && !empty($_POST['lgsl_switch'])) || (!isset($_POST['lgsl_management']) && $lgsl_config['management']))

  {

    $output .= "

    <form method='post' action=''>

      <div style='text-align:center'>

        <b>TYPE : IP : C PORT : Q PORT : S PORT : ZONES : DISABLED : COMMENT</b>

        <br />

        <br />

      </div>

      <div style='text-align:center'>

        <textarea name='form_list' cols='90' rows='30' wrap='off' spellcheck='false' style='width:95%; height:500px; font-size:1.2em; font-family:courier new, monospace'>\r\n";



//---------------------------------------------------------+

        $mysql_result = mysql_query("SELECT * FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` ORDER BY `id` ASC");



        while($mysql_row = mysql_fetch_array($mysql_result, MYSQL_ASSOC))

        {

          $output .=

          lgsl_string_html(str_pad($mysql_row['type'],     15, " ")).":".

          lgsl_string_html(str_pad($mysql_row['ip'],       30, " ")).":".

          lgsl_string_html(str_pad($mysql_row['c_port'],   6,  " ")).":".

          lgsl_string_html(str_pad($mysql_row['q_port'],   6,  " ")).":".

          lgsl_string_html(str_pad($mysql_row['s_port'],   7,  " ")).":".

          lgsl_string_html(str_pad($mysql_row['zone'],     7,  " ")).":".

          lgsl_string_html(str_pad($mysql_row['disabled'], 2,  " ")).":".

                                   $mysql_row['comment']            ."\r\n";

                                   $mysql_row['site']            ."\r\n";

        }

//---------------------------------------------------------+

        $output .= "

        </textarea>

      </div>

      <div style='text-align:center'>

        <input type='hidden' name='lgsl_management' value='1' />

        <table cellspacing='20' cellpadding='0' style='text-align:center;margin:auto'>

          <tr>

            <td><input type='submit' name='lgsl_save_1'          value='Save - Keep Cache' />  </td>

            <td><input type='submit' name='lgsl_save_2'          value='Save - Reset Cache' /> </td>

            <td><input type='submit' name='lgsl_map_image_paths' value='Map Image Paths' />    </td>

            <td><input type='submit' name='lgsl_switch'          value='Normal Management' />  </td>

          </tr>

        </table>

      </div>

    </form>";



    $output .= lgsl_help_info();



    return $output;

  }



//------------------------------------------------------------------------------------------------------------+



  $output .= "

  <form method='post' action=''>

    <div style='text-align:center; overflow:auto'>

      <table cellspacing='5' cellpadding='0' style='margin:auto'>

        <tr>

          <td style='text-align:center; white-space:nowrap'>[ ID ]             </td>

          <td style='text-align:center; white-space:nowrap'>[ Game Type ]      </td>

          <td style='text-align:center; white-space:nowrap'>[ IP ]             </td>

          <td style='text-align:center; white-space:nowrap'>[ Connection Port ]</td>

          <td style='text-align:center; white-space:nowrap'>[ Query Port ]     </td>

          <td style='text-align:center; white-space:nowrap'>[ Software Port ]  </td>

          <td style='text-align:center; white-space:nowrap'>[ Zones ]          </td>

          <td style='text-align:center; white-space:nowrap'>[ Disabled ]       </td>

          <td style='text-align:center; white-space:nowrap'>[ Comment ]        </td>

          <td style='text-align:center; white-space:nowrap'>[ Site ]           </td>

        </tr>";



//---------------------------------------------------------+



      $mysql_result = mysql_query("SELECT * FROM `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` ORDER BY `id` ASC");



      while($mysql_row = mysql_fetch_array($mysql_result, MYSQL_ASSOC))

      {

        $id = $mysql_row['id']; // ID USED AS [] ONLY RETURNS TICKED CHECKBOXES



        $output .= "

        <tr>

          <td>

            <a href='".lgsl_link($id)."' style='text-decoration:none'>{$id}</a>

          </td>

          <td>

            <select name='form_type[{$id}]'>";

//---------------------------------------------------------+

            foreach ($lgsl_type_list as $type => $description)

            {

              $output .= "

              <option ".($type == $mysql_row['type'] ? "selected='selected'" : "")." value='{$type}'>{$description}</option>";

            }



            if (!isset($lgsl_type_list[$mysql_row['type']]))

            {

              $output .= "

              <option selected='selected' value='".lgsl_string_html($mysql_row['type'])."'>".lgsl_string_html($mysql_row['type'])."</option>";

            }

//---------------------------------------------------------+

            $output .= "

            </select>

          </td>

          <td style='text-align:center'><input type='text' name='form_ip[{$id}]'     value='".lgsl_string_html($mysql_row['ip'])."'     size='15' maxlength='255' /></td>

          <td style='text-align:center'><input type='text' name='form_c_port[{$id}]' value='".lgsl_string_html($mysql_row['c_port'])."' size='5'  maxlength='5'   /></td>

          <td style='text-align:center'><input type='text' name='form_q_port[{$id}]' value='".lgsl_string_html($mysql_row['q_port'])."' size='5'  maxlength='5'   /></td>

          <td style='text-align:center'><input type='text' name='form_s_port[{$id}]' value='".lgsl_string_html($mysql_row['s_port'])."' size='5'  maxlength='5'   /></td>

          <td>

            <select name='form_zone[$id]'>";

//---------------------------------------------------------+

            foreach ($zone_list as $zone)

            {

              $output .= "

              <option ".($zone == $mysql_row['zone'] ? "selected='selected'" : "")." value='{$zone}'>{$zone}</option>";

            }



            if (!isset($zone_list[$mysql_row['zone']]))

            {

              $output .= "

              <option selected='selected' value='".lgsl_string_html($mysql_row['zone'])."'>".lgsl_string_html($mysql_row['zone'])."</option>";

            }

//---------------------------------------------------------+

//---------------------------------------------------------+

            $output .= "

            </select>

          </td>

          <td style='text-align:center'><input type='checkbox' name='form_disabled[{$id}]' value='1' ".(empty($mysql_row['disabled']) ? "" : "checked='checked'")." /></td>

          <td style='text-align:center'><input type='text'     name='form_comment[{$id}]'  value='{$mysql_row['comment']}' size='20' maxlength='255' /></td>

          <td style='text-align:center'><input type='text'     name='form_site[{$id}]'  value='{$mysql_row['site']}' size='80' maxlength='255' /></td>

        </tr>";



        $last_type = $mysql_row['type']; // SET LAST TYPE ( $mysql_row EXISTS ONLY WITHIN THE LOOP )

      }

//---------------------------------------------------------+

        $id ++; // NEW SERVER ID CONTINUES ON FROM LAST



        $output .= "

        <tr>

          <td>NEW</td>

          <td>

            <select name='form_type[{$id}]'>";

//---------------------------------------------------------+

            foreach ($lgsl_type_list as $type => $description)

            {

              $output .= "

              <option ".($type == $last_type ? "selected='selected'" : "")." value='{$type}'>{$description}</option>";

            }

//---------------------------------------------------------+

            $output .= "

            </select>

          </td>

          <td style='text-align:center'><input type='text' name='form_ip[{$id}]'     value=''  size='15' maxlength='255' /></td>

          <td style='text-align:center'><input type='text' name='form_c_port[{$id}]' value=''  size='5'  maxlength='5'   /></td>

          <td style='text-align:center'><input type='text' name='form_q_port[{$id}]' value=''  size='5'  maxlength='5'   /></td>

          <td style='text-align:center'><input type='text' name='form_s_port[{$id}]' value='0' size='5'  maxlength='5'   /></td>

          <td>

            <select name='form_zone[{$id}]'>";

//---------------------------------------------------------+

            foreach ($zone_list as $zone)

            {

              $output .= "

              <option value='{$zone}'>{$zone}</option>";

            }

//---------------------------------------------------------+

            $output .= "

            </select>

          </td>

          <td style='text-align:center'><input type='checkbox' name='form_disabled[{$id}]' value='' /></td>

          <td style='text-align:center'><input type='text'     name='form_comment[{$id}]'  value='' size='20' maxlength='255' /></td>

          <td style='text-align:center'><input type='text'     name='form_site[{$id}]'  value='' size='80' maxlength='255' /></td>

        </tr>

      </table>



      <input type='hidden' name='lgsl_management' value='0' />

      <table cellspacing='20' cellpadding='0' style='text-align:center;margin:auto'>

        <tr>

          <td><input type='submit' name='lgsl_save_1'          value='Save - Keep Cache' />  </td>

          <td><input type='submit' name='lgsl_save_2'          value='Save - Reset Cache' /> </td>

          <td><input type='submit' name='lgsl_map_image_paths' value='Map Image Paths' />    </td>

          <td><input type='submit' name='lgsl_switch'          value='Advanced Management' /></td>

        </tr>

      </table>

    </div>

  </form>";



  $output .= lgsl_help_info();



//------------------------------------------------------------------------------------------------------------+



  function lgsl_help_info()

  {

    return "

    <div style='text-align:center; line-height:1em; font-size:1em;'>

      <br /><br />

      <a href='http://www.greycube.com/help/readme/lgsl/'>[ LGSL ONLINE README ]</a>  <br /><br />

      - To remove a server, delete the IP, then click Save.                           <br /><br />

      - Leave the query port blank to have LGSL try to fill it in for you.            <br /><br />

      - Software port is only needed for a few games so it being set 0 is normal.     <br /><br />

      - Edit the lgsl_config.php to set the background colors and other options.      <br /><br />

      <table cellspacing='10' cellpadding='0' style='border:1px solid; margin:auto; text-align:left'>

        <tr>

          <td> <a href='http://php.net/fsockopen'>FSOCKOPEN</a>           </td>

          <td> Enabled: ".(function_exists("fsockopen") ? "YES" : "NO")." </td>

          <td> ( Required for direct querying of servers )                </td>

        </tr>

        <tr>

          <td> <a href='http://php.net/curl'>CURL</a>                                                                                         </td>

          <td> Enabled: ".((function_exists("curl_init") && function_exists("curl_setopt") && function_exists("curl_exec")) ? "YES" : "NO")." </td>

          <td> ( Used for the feed when fsockopen is disabled )                                                                               </td>

        </tr>

        <tr>

          <td> <a href='http://php.net/mbstring'>MBSTRING</a>                       </td>

          <td> Enabled: ".(function_exists("mb_convert_encoding") ? "YES" : "NO")." </td>

          <td> ( Used to show UTF-8 server and player names correctly )             </td>

        </tr>

        <tr>

          <td> <a href='http://php.net/bzip2'>BZIP2</a>                      </td>

          <td> Enabled: ".(function_exists("bzdecompress") ? "YES" : "NO")." </td>

          <td> ( Used to show Source server settings over a certain size )   </td>

        </tr>

        <tr>

          <td> <a href='http://php.net/zlib'>ZLIB</a>                        </td>

          <td> Enabled: ".(function_exists("gzuncompress") ? "YES" : "NO")." </td>

          <td> ( Required for America's Army 3 )                             </td>

        </tr>

      </table>

      <br /><br />

      <br /><br />

    </div>";

  }



//------------------------------------------------------------------------------------------------------------+



  function lgsl_stripslashes_deep($value)

  {

    $value = is_array($value) ? array_map('lgsl_stripslashes_deep', $value) : stripslashes($value);

    return $value;

  }



//------------------------------------------------------------------------------------------------------------+



  function lgsl_htmlspecialchars($string)

  {

    // PHP4 COMPATIBLE WAY OF CONVERTING SPECIAL CHARACTERS WITHOUT DOUBLE ENCODING EXISTING ENTITIES

    $string = str_replace("\x05\x06", "", $string);

    $string = preg_replace("/&([a-z\d]{2,7}|#\d{2,5});/i", "\x05\x06$1", $string);

    $string = htmlspecialchars($string, ENT_QUOTES);

    $string = str_replace("\x05\x06", "&", $string);



    return $string;

  }



//------------------------------------------------------------------------------------------------------------+