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);
}