<SCRIPT LANGUAGE='JavaScript' SRC='js/game.js?2'></SCRIPT>

<img src="/images/1.jpg" alt="" title="" />

<img src="http://localhost/StG.ru/images/1.jpg" alt="" title="" />

if (isset($_SESSION["user"][0])) {$faction=faction($_SESSION["user"][10]); $imgs=$_SESSION["user"][13]; $fimgs=$faction[2];}
else {$imgs="default/"; $fimgs="1/";}

function faction($id)

{
    global $db_id;

    $query="select * from factions where id=".$id;
    $result=mysql_query($query, $db_id);
       
    $row=mysql_fetch_row($result);
    return $row;
}

function factions()
{
    global $db_id;

    $factions=array();
    $query="select * from factions";
    $result=mysql_query($query, $db_id);
       
    for ($i=0; $row=mysql_fetch_row($result); $i++) $factions[$i]=$row;
    return $factions;
}

function buildings($faction)
{
    global $db_id, $lang;

    $query="select * from buildings where faction=".$faction;
    $result=mysql_query($query, $db_id); $buildings=array();
       
    for ($i=0; $row=mysql_fetch_row($result); $i++)
    {
     $buildings[$i]=$row;
     if (isset($lang['buildings']))
     {
      $buildings[$i][2]=$lang['buildings'][$faction-1][$i][0];
      $buildings[$i][8]=$lang['buildings'][$faction-1][$i][1];
     }
    }
    return $buildings;
}

function weapons($faction)
{
    global $db_id, $lang;

    $query="select * from weapons where faction=".$faction;
    $result=mysql_query($query, $db_id); $weapons=array();
       
    for ($i=0; $row=mysql_fetch_row($result); $i++)
    {
     $weapons[$i]=$row;
     if (isset($lang['weapons']))
     {
      $weapons[$i][2]=$lang['weapons'][$faction-1][$i][0];
      $weapons[$i][5]=$lang['weapons'][$faction-1][$i][1];
     }
    }
    return $weapons;
}

function units($faction)
{
    global $db_id, $lang;

    $query="select * from units where faction=".$faction;
    $result=mysql_query($query, $db_id); $units=array();
       
    for ($i=0; $row=mysql_fetch_row($result); $i++)
    {
     $units[$i]=$row;
     if (isset($lang['units']))
     {
      $units[$i][2]=$lang['units'][$faction-1][$i][0];
      $units[$i][10]=$lang['units'][$faction-1][$i][1];
     }
    }
    return $units;
}

function check_c($id, $faction)
{
    global $db_id, $tdif;
$town=town($id);
$buildings=buildings($faction);
$data=explode("-", $town[8]); $res=explode("-", $town[10]); $lim=explode("-", $town[11]); $prod=explode("-", $town[9]); $land=explode("/", $town[13]);
$land[0]=explode("-", $land[0]); $land[1]=explode("-", $land[1]); $land[2]=explode("-", $land[2]); $land[3]=explode("-", $land[3]);

    $query="select timediff(dueTime".$tdif.", now()), b, subB from c_queue where town=".$id." order by dueTime asc";
    $result=mysql_query($query, $db_id);
    for (; $row=mysql_fetch_row($result); )
    if ($row[0][0]=="-")
    {
     if ($row[2]>-1)
     {
      $land[$row[1]][$row[2]]++; $ldata="";
      for ($i=0; $i<count($land); $i++) $ldata[$i]=implode("-", $land[$i]);
      $ldata=implode("/", $ldata);
      $out=explode("-", $buildings[$row[1]][5]); $prod[$row[1]]=0;
      for ($i=0; $i<count($land[$row[1]]); $i++)
      if ($land[$row[1]][$i]) $prod[$row[1]]+=$out[$land[$row[1]][$i]-1];
      $pdata=implode("-", $prod);
      $query="update towns set land='".$ldata."', production='".$pdata."' where id=".$id;
      mysql_query($query, $db_id);
     }
     else switch($row[1])
     {
      case 0:
      {
       $data[$row[1]]=1; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 1:
      {
       $data[$row[1]]=1; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 2:
      {
       $data[$row[1]]=1; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 3:
      {
       $data[$row[1]]=1; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 4:
      {
       $data[4]++; $lim[0]=explode("-", $buildings[4][5]); $lim[0]=$lim[0][$data[4]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 5:
      {
       $data[5]++; $lim[1]=explode("-", $buildings[5][5]); $lim[1]=$lim[1][$data[5]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 6:
      {
       $data[6]++; $lim[5]=explode("-", $buildings[6][5]); $lim[5]=$lim[5][$data[6]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 7:
      {
       $data[7]++; $lim[4]=explode("-", $buildings[7][5]); $lim[4]=$lim[4][$data[7]-1]; $lim[2]+=800; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 8:
      {
       $data[8]++; $lim[3]=explode("-", $buildings[8][5]); $lim[3]=$lim[3][$data[8]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 9:
      {
       $data[9]++; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 10:
      {
       $data[10]++; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 11:
      {
       $mdata=explode("-", $buildings[11][5]);
       $data[11]++; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."', morale=".(100-$prod[4]+$mdata[$data[11]-1])." where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 12:
      {
       $data[12]++; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 13:
      {
       $data[13]++; $lim[6]=explode("-", $buildings[13][5]); $lim[6]=$lim[6][$data[13]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 14:
      {
       $data[14]++; $lim[7]=explode("-", $buildings[14][5]); $lim[7]=$lim[7][$data[14]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 15:
      {
       $data[15]++; $lim[8]=explode("-", $buildings[15][5]); $lim[8]=$lim[8][$data[15]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 16:
      {
       $data[16]=1; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 17:
      {
       $data[17]++; $bdata=implode("-", $data);
       $query="update towns set buildings='".$bdata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 18:
      {
       $data[18]++; $lim[9]=explode("-", $buildings[18][5]); $lim[9]=$lim[9][$data[18]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 19:
      {
       $data[19]++; $lim[10]=explode("-", $buildings[19][5]); $lim[10]=$lim[10][$data[19]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 20:
      {
       $data[20]++; $lim[11]=explode("-", $buildings[20][5]); $lim[11]=$lim[11][$data[20]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      case 21:
      {
       $data[21]++; $lim[12]=explode("-", $buildings[21][5]); $lim[12]=$lim[12][$data[21]-1]; $bdata=implode("-", $data); $ldata=implode("-", $lim);
       $query="update towns set buildings='".$bdata."', limits='".$ldata."' where id=".$id;
    mysql_query($query, $db_id);
      } break;
      default: ;
     }
     $query="delete from c_queue where c_queue.town=".$id." and c_queue.b=".$row[1]." and c_queue.subB=".$row[2];
     mysql_query($query, $db_id);
    }
}

function cancel_c($id, $b, $subB, $res, $faction)
{
    global $db_id;
$town=town($id);
$buildings=buildings($faction);
$data=explode("-", $town[8]); $land=explode("/", $town[13]); $upk=explode("-", $buildings[$b][7]);
$land[0]=explode("-", $land[0]); $land[1]=explode("-", $land[1]); $land[2]=explode("-", $land[2]); $land[3]=explode("-", $land[3]);

     if ($subB==-1) $pop=$town[3]-$upk[$data[$b]];
     else $pop=$town[3]-$upk[$land[$b][$subB]];
    $query="update towns set resources='".$res."', population=".$pop." where id=".$id;
    $result=mysql_query($query, $db_id);
    $query="delete from c_queue where town=".$id." and b=".$b;
    $result=mysql_query($query, $db_id);
    if ($result) echo "<script type='text/javascript'>history.go(-1)</script>";
    else msg("Failed.".mysql_error());
}

function build($id, $b, $subB, $time, $res, $faction)
{
    global $db_id;
    $town=town($id); $buildings=buildings($faction); $data=explode("-", $town[8]); $land=explode("/", $town[13]); $upk=explode("-", $buildings[$b][7]);
    $land[0]=explode("-", $land[0]); $land[1]=explode("-", $land[1]); $land[2]=explode("-", $land[2]); $land[3]=explode("-", $land[3]);

    $time=explode(":", $time);
       
    $query="select max(dueTime) from c_queue where town=".$id;
    $result=mysql_query($query, $db_id);
    $row=mysql_fetch_row($result);
    if ($row[0]!="") $date=strtotime("+".$time[0]." hours ".$time[1]." minutes ".($time[2]+rand(0, 9))." seconds", strtotime($row[0])); else $date=strtotime("+".$time[0]." hours ".$time[1]." minutes ".($time[2]+rand(0, 9))." seconds");
    $date=strftime("%Y-%m-%d %H:%M:%S", $date);
    $query="insert into c_queue(town, dueTime, b, subB) values('".$id."', '".$date."', '".$b."', '".$subB."')";
    $result=mysql_query($query, $db_id);
    $query="update towns set resources='".$res."' where id=".$id;
    $result=mysql_query($query, $db_id);
    if ($subB==-1) $pop=$town[3]+$upk[$data[$b]];
    else $pop=$town[3]+$upk[$land[$b][$subB]];
    $query="update towns set population=".$pop." where id=".$id;
    $result=mysql_query($query, $db_id);
        
    if ($result) echo "<script type='text/javascript'>history.go(-1)</script>";
    else msg("Failed.".mysql_error());
}

function reg($name, $pass, $email, $faction)
{
    global $db_id;

    $query="insert into users(name, pass, email, level, joined, lastVisit, points, ip, grPath, faction) values('".$name."', '".$pass."', '".$email."', 1, now(), now(), 0, '".$_SERVER["REMOTE_ADDR"]."', 'default/', ".$faction.")";
    $result=mysql_query($query, $db_id);
    if ($result) msg("Succes. You are now registered as '".$name."'. You can now login and create your town.");
    else msg("Failed.".mysql_error());
}

function install($name, $pass, $email, $faction)
{
    global $db_id;

    $query="insert into users(name, pass, email, level, joined, lastVisit, points, ip, grPath, faction) values('".$name."', '".$pass."', '".$email."', 5, now(), now(), 0, '".$_SERVER["REMOTE_ADDR"]."', 'default/', ".$faction.")";
    $result=mysql_query($query, $db_id);
       
    $handle = fopen ("map.dat","r") or
    die("Error opening map data file."); $ok=1;
    for ($i=0; $info[$i] = fscanf ($handle, "%i %i %i %i"); $i++)
    {
     if (!$info[$i][3])
      switch($info[$i][2])
      {
       case 1: $info[$i][3]=rand(1, 6); break;
       case 2: $info[$i][3]=rand(1, 4); break;
       default: ;
      }
     $query="insert into map(x, y, type, subtype) values (".$info[$i][0] .", ".$info[$i][1].", ".$info[$i][2].", ".$info[$i][3].")";
     $result=mysql_query($query, $db_id);    if (!$result) $ok=0;
    }
    fclose($handle);
    if ($ok) msg(" Succes. Map data added.");
    else msg("Failed.".mysql_error());
}
//chat functions
function send_chat($se, $sid, $msg, $re)
{
    global $db_id;

    $query="insert into chat (sId, timeStamp, message, recipient, sender) values (".$sid.", now(), '".$msg."', ".$re.", ".$se.")";
    mysql_query($query, $db_id);
}

require("{$ugamela_root_path}config.{$phpEx}");