Navigacija

Vartotojų tinkle

Prisijungusių svečių: 167
Prisijungusių narių: 0
Prisijungusių narių nėra

Registruoti nariai: 25,953
Naujausias narys: Quwqkibor

Naujausi straipsniai

Paskutiniai nariai

Memento Mori 4 dienos
ozzWANTED 1 savaitė
Quwqkibor 2 savaitės
asirija 6 savaitės
tomeem 8 savaitės
Reikalas 9 savaitės
weberiz12 savaitės
mRokass14 savaitės
kartoonas15 savaitės
iaescortsmap15 savaitės
grunskiz18 savaitės
Bruksnys18 savaitės
illusion18 savaitės
ordo19 savaitės
Jurgaila20 savaitės
originalcs1620 savaitės
Rytis21 savaitės
halis22 savaitės
junkus25 savaitės
morlis25 savaitės

Informacija:


OS: Unknown
Naršyklė: Nežinoma
IP: 3.138.60.232
Naujienų: 529
Straipsnių: 235
Temų: 52,585
Postų: 522,523
Postų pask. parą: 0
Shout'ų pask. parą: 0
P.S.C. pask. parą: 0
Nuorodų kataloge: 13

Lankomumo Statistika

Peržiūrų šiandien: 22

Iš viso peržiūrų: 22948724

Prisijungti

REGISTRUOTIS
Nario vardas

Slaptažodis



Pamiršai slaptažodį?
Paprašyk naujo

Aktyvuoti save

Šaukykla

Jei norite rašyti žinutes, turite prisijungti.

ozzWANTED
2024 Sau. 17 01:01:00
Desperatiškus komentarus šaukykloje su accountu po mėnesio prasibuvimo, ištryniau. Pasaulis ir taip juodas. Įjungiam šviesą, prašviesės. šypsosi

Majakas
2023 Gru. 10 19:12:39
Negaliu patikėti jog žinutės/pranešimai visi yra nuo 2008 m akinanti šypsen

Žmogus
2023 Rugs. 7 21:09:14
O gal BloodKiller pasijungs?

Apocal
2023 Rugs. 2 18:09:23
Nu davai nuveikiam kažką akinanti šypsen. Prisijungti kada visi čia akinanti šypsen.

Apocal
2023 Rugs. 2 00:09:18
Šiaip atėjau pažiūrėti ar dar lopas nesby yra ar koks ten buvo.

Šaukyklos archyvas

Apklausa

Ar esate patenkinti lietuviško vertimo kokybe?

Taip!

Taip, bet yra ką taisyti (parašysiu komentaruose)

Ne

Norėdamas balsuoti turite prisijungti.
Archyvas
Reklama 400x60
Reikia pagalbos ištaisyti error'ui
Forumas | Kita | Off-Topic diskusijos

Autorius: Skirmantas. Peržiūrų: 1935      Spausdinti temą
2011 Kov. 13 16:03:28          1 žinutė iš 8
Spausdinti pranešimą
Sveiki, taigi susidūriau su tokių error:






Va jei dar prireiks constant.php (čia failo vidus);

<?php
include("news_setting.php");
//Server Constants
define("NETWORK_NAME", "Travian Clone");
define("SHOW_FLAG", false);
define("MULTI_SERVER", false);
?>


Jei kas žino kame bėdos padėkit.

2011 Kov. 13 16:03:54          2 žinutė iš 8
Spausdinti pranešimą
Nebus pagalbos daugiau?
2011 Kov. 13 16:03:52          3 žinutė iš 8
Spausdinti pranešimą
Pz proto turek mes ne Travian zaidimo specai zinot visas bedas.
Turiu omeny travian clono failu specai

2011 Kov. 13 19:03:05          4 žinutė iš 8
Spausdinti pranešimą
Ne žaidime esmė, esi žalias tai geriau patylėtum, čia gi php viskas sudaryta mastai?
2011 Kov. 15 17:03:39          5 žinutė iš 8
Spausdinti pranešimą
Rimtai yra specų kurie žino ar čia supportas, kuriame susirenka vaikai nieko neyšmanantys? Pagalbos nei biškučio nesulaukiau.
2011 Kov. 15 17:03:30          6 žinutė iš 8
Spausdinti pranešimą
database.php faile.. 10 eilutėje kažkas blogai.. Read errors....

nolife.lt / c-s.lt
2011 Kov. 15 17:03:50          7 žinutė iš 8
Spausdinti pranešimą
Dar vienas... Nori tuo datebase.php? va imk:
<?php
/******Database.php*******
-- Class MYSQL_DB and MYSQLi_DB consists of the database releated functions of Travian Clone.
-- Revision: Beta 3
-- Author: akakori
-- Homepage: -
-- Beta Server: http://www.game-chaos.com/travian
-- Please do not remove this section
************************/
include("constant.php");

class MYSQL_DB {
   
   var $connection;
   
   function MYSQL_DB() {
      $this->connection = mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS) or die(mysql_error());
      mysql_select_db(SQL_DB, $this->connection) or die(mysql_error());
   }
   
   /***************************
   Function to check existance of email or the username.
   Mode 0: username;
   Mode 1: Email;
   References: Reference, Mode
   ***************************/
   function checkExist($ref,$mode) {
      if(!$mode) {
         $q = "SELECT username FROM ".TB_PREFIX."users where username = '$ref' LIMIT 1";
      }
      else {
         $q = "SELECT email FROM ".TB_PREFIX."users where email = '$ref' LIMIT 1";
      }
      $result = mysql_query($q, $this->connection);
      if(mysql_num_rows($result)) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to check the existing session if its correct.
   References: Username, Session ID
   ***************************/
   function checkactiveSession($username,$sessid) {
      $q = "SELECT username FROM ".TB_PREFIX."users where username = '$username' and sessid = '$sessid' LIMIT 1";
      $result = mysql_query($q, $this->connection);
      if(mysql_num_rows($result) != 0) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to update any field in users.
   References: Username, Field Name, Value
   ***************************/
   function updateUserField($username,$field,$value) {
      $q = "UPDATE ".TB_PREFIX."users set $field = '$value' where username = '$username'";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to login users
   References: Username, Password
   ***************************/
   function login($username,$password) {
      $q = "SELECT password,sessid FROM ".TB_PREFIX."users where username = '$username' and access != ".BANNED;
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      if($dbarray['password'] == md5($password)) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to register users
   References: Username, Password, Email, Tribe, Activation
   ***************************/
   function register($username,$password,$email,$tribe,$act) {
      $time = time();
      $q = "INSERT INTO ".TB_PREFIX."users (username,password,access,email,timestamp,tribe,act) VALUES ('$username', '$password', ".USER.", '$email', $time, $tribe, '$act')";
      if(mysql_query($q,$this->connection)) {
         return mysql_insert_id($this->connection);
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to delete users
   References: User ID
   ***************************/
   function deleteAccount($id) {
      $time = time();
      $allvillage = $this->getAVillage($id);
      for($i=0;$i<=count($allvillage)-1;$i++) {
         $q = "DELETE FROM ".TB_PREFIX."constdata where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."fdata where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "UPDATE ".TB_PREFIX."wdata set occupied = 1 where id = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."baselog where vid = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."market where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."movement where send = ".$allvillage[$i]['wref']." or recieve = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."units where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."enforcement where vref = ".$allvillage[$i]['wref']." or from = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connnection);
         $q = "DELETE FROM ".TB_PREFIX."training where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."heroes where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
         $q = "DELETE FROM ".TB_PREFIX."research where vref = ".$allvillage[$i]['wref'];
         mysql_query($q,$this->connection);
      }
      $q = "DELETE FROM ".TB_PREFIX."mdata where sender = $id or recieve = $id";
      mysql_query($q,$this->connection);
      $q = "DELETE FROM ".TB_PREFIX."userlink where uref = $id";
      mysql_query($q,$this->connection);
      $q = "DELETE FROM ".TB_PREFIX."mardata where sender = $id or recieve = $id";
      mysql_query($q,$this->connection);
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $id and town = 0";
      $result = mysql_query($q,$this->connection);
      if(mysql_num_rows($result) > 0) {
         $array = $this->mysql_fetch_all($result);
         for($i=0;$i<=count($array)-1;$i++) {
            $q = "UPDATE ".TB_PREFIX."wdata set occupied = 0 where id = ".$array[$i]['wref'];
            mysql_query($q,$this->connection);
         }
      }
      $q = "DELETE FROM ".TB_PREFIX."vdata where owner = $id";
      mysql_query($q,$this->connection);
      $q = "DELETE FROM ".TB_PREFIX."users where id = $id";
      mysql_query($q,$this->connection);
   }
   
   /**************************
   Function to calculate registered users
   References: -
   **************************/
   function countUsers() {
      $q = "SELECT * FROM ".TB_PREFIX."users";
      $result = mysql_query($q,$this->connection);
      $num_rows = mysql_num_rows($result);
      return $result;
   }
   
   /**************************
   Function to give or remove gold
   Mode 0: Remove
   Mode 1: Give
   References: User ID, Amount, Mode
   **************************/
   function modifyGold($id,$amt,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."USERS set gold = gold - $amt where id = $id";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."USERS set gold = gold + $amt where id = $id";
      }
      return mysql_query($q,$this->connection);
   }
   
   /**************************
   Function to check plus
   References: Userid
   **************************/
   function checkPlus($id) {
      $q = "SELECT plus from ".TB_PREFIX."users where id = $id";
      $result = mysql_query($q,$this->connection);
      if(mysql_result($result,0) > time()) {
         return true;
      }
      else {
         $this->modifyPlus($id,0);
      }
   }
   
   /**************************
   Function to give or remove plus
   Mode 0: Remove
   Mode 1: Give
   References: Userid, Mode
   **************************/
   function modifyPlus($id,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."users set access = ".USER." where id = $id and access < ".MODERATOR."";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."users set access = ".PLUS." where id = $id and access < ".MODERATOR."";
      }
      return mysql_query($q,$this->connection);
   }
   
   /**************************
   Function to generate base for new registration
   Sector 0: Random all
   Sector 1: -x, +y
   Sector 2: +x, +y
   Sector 3: -x, -y
   Sector 4: +x, -y
   References: Sector
   **************************/
   function generateBase($sector) {
      $count = $this->countUsers();
      $starter = -3;
      if($count > 20) {
         $starter = -3 * round($count/20);
      }
      switch($sector) {
         case 0:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and occupied = 0 and x > $starter and y > $starter LIMIT 200";
         break;
         case 1:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x < 0 and y > 0 and occupied = 0 LIMIT 200";
         break;
         case 2:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x > 0 and y > 0 and occupied = 0 LIMIT 200";
         break;
         case 3:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x < 0 and y < 0 and occupied = 0 LIMIT 200";
         break;
         case 4:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x > 0 and y < 0 and occupied = 0 LIMIT 200";
         break;
      }
         $result = mysql_query($q);
         $num_rows = mysql_num_rows($result);
         $result = $this->mysql_fetch_all($result);
         $base = rand(0, ($num_rows-1));
         return $result[$base]['id'];
   }
   
   /***************************
   Function to retrieve data from specific field in users
   Mode 0: Search by ID
   Mode 1: Search by Username
   References: Reference, Field, Mode
   ***************************/
   function getUserField($ref,$field,$mode) {
      if(!$mode) {
         $q = "SELECT $field FROM ".TB_PREFIX."users where id = $ref";
      }
      else {
         $q = "SELECT $field FROM ".TB_PREFIX."users where username = '$ref'";
      }
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray[$field];
   }
   
   /***************************
   Function to retrieve data from specific field in vdata
   References: Reference, Field
   ***************************/
   function getVillageField($ref,$field) {
      $q = "SELECT $field FROM ".TB_PREFIX."vdata where id = $ref";
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray[$field];
   }
   
   /***************************
   Function to retrieve alliance name via ID
   References: Alliance ID
   ***************************/
   function getUserAlliance($id) {
      $q = "SELECT ".TB_PREFIX."alidata.name from ".TB_PREFIX."users join ".TB_PREFIX."alidata where ".TB_PREFIX."users.alliance = ".TB_PREFIX."alidata.id";
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray['name'];
   }
   
   /***************************
   Function to retrieve user array via Username or ID
   Mode 0: Search by Username
   Mode 1: Search by ID
   References: Alliance ID
   ***************************/
   function getUserArray($ref,$mode) {
      if(!$mode) {
         $q = "SELECT * FROM ".TB_PREFIX."users where username = '$ref'";
      }
      else {
         $q = "SELECT * FROM ".TB_PREFIX."users where id = $ref";
      }
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result);
   }
   
   /***************************
   Function to update active user in database
   References: Username, Time
   ***************************/
   function updateActiveUser($username,$time) {
      $q = "UPDATE ".TB_PREFIX."users set timestamp = $time where username = '$username'";
      $exec1 = mysql_query($q,$this->connection);
      $q = "REPLACE into ".TB_PREFIX."active values ('$username',$time)";
      $exec2 = mysql_query($q, $this->connection);
      if($exec1 && $exec2) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to add or remove active user
   Mode 0: Add active
   Mode 1: Remove active
   References: Username, Mode
   ***************************/
   function activeModify($username,$mode) {
      $time = time();
      if(!$mode) {
         $q = "INSERT into ".TB_PREFIX."active VALUES ('$username',$time)";
      }
      else {
         $q = "DELETE FROM ".TB_PREFIX."active where username = '$username'";
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to automatically clear inactive user
   References: Nil
   ***************************/
   function removeInactiveUsers(){
      $timeout = time()-USER_TIMEOUT*60;
      $q = "DELETE FROM ".TB_PREFIX."active WHERE timestamp < $timeout";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add cultral points to village or users
   Mode 0: Add to village
   Mode 1: Add to user
   References: Reference, Points, Mode
   ***************************/
   function addCP($ref,$cp,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."vdata set cp = cp + $cp where wref = $ref and town = 1";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."users set cp = cp + $cp where id = $ref and town = 1";
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to get world field details
   References: Field ID
   ***************************/
   function getFieldDetails($id) {
      $q = "SELECT * FROM ".TB_PREFIX."wdata where id = $id";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result);
   }
   
   /***************************
   Function to set occupied on world data
   References: Field ID
   ***************************/
   function setFieldTaken($id) {
      $q = "UPDATE ".TB_PREFIX."wdata set occupied = 1 where id = $id";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add village or oasis to user
   Mode 0: Add Village
   Mode 1: Add Oasis
   References: Field ID, User ID, Username, Capital, Mode
   ***************************/
   function addVillage($wid,$uid,$username,$capital,$oasis) {
      $total = $this->getAVillageCount($uid);
      if ($total >= 1) {
      $vname = $username."\'s village ".($total+1);
      }
      else {
         $vname = $username."\'s village";
      }
      $time = time();
      if($oasis) {
         $q = "INSERT into ".TB_PREFIX."vdata values ($wid, $uid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, $time)";
      }
      else {
         $q = "INSERT into ".TB_PREFIX."vdata values ($wid, $uid, '$vname', $capital, 1, 2, 0, 750, 750, 750, 800, 750, 800, $time)";
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to retrieve capital of user
   References: User ID
   ***************************/
   function getCapital($uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $uid and capital = 1 and town = 1";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result);
   }
   
   /***************************
   Function to retrieve specific village of user
   References: Village ID, User ID
   ***************************/
   function getVillage($vid,$uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where wref = $vid and owner = $uid and town = 1";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result);
   }
   
   /***************************
   Function to retrieve owner of village
   References: Village ID
   ***************************/
   function getVillageOwner($vid) {
      $q = "SELECT owner FROM ".TB_PREFIX."vdata where wref = $vid";
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray['owner'];
   }
   
   /***************************
   Function to count number of village owned by user
   References: User ID
   ***************************/
   function getAVillageCount($uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $uid and town = 1";
      $result = mysql_query($q, $this->connection);
      return mysql_num_rows($result);
   }
   
   /***************************
   Function to count number of pop in village owned by user
   References: User ID
   ***************************/
   function getAVillagePop($uid) {
      $q = "SELECT sum(pop) FROM ".TB_PREFIX."vdata where owner = $uid and town = 1";
      $result = mysql_query($q, $this->connection);
      $row = mysql_fetch_row($result);
      return $row[0];
   }
   
   /***************************
   Function to retrieve all village of user
   References: User ID
   ***************************/
   function getAVillage($uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $uid and town = 1";
      $result = mysql_query($q, $this->connection);
      return $this->mysql_fetch_all($result);;
   }
   
   /***************************
   Function to retrieve coordinate of village
   References: Village ID
   ***************************/
   function getCoor($wref) {
      $q = "SELECT x,y FROM ".TB_PREFIX."wdata where id = $wref";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result);
   }
   
   /***************************
   Function to retrieve type of oasis via user id
   References: User ID
   ***************************/
   function getOasisType($uid) {
      $q = "select ".TB_PREFIX."_wdata.oasistype from ".TB_PREFIX."_wdata,".TB_PREFIX."_vdata where ".TB_PREFIX."_wdata.id = ".TB_PREFIX."_vdata.wref and ".TB_PREFIX."_vdata.town = 0 and ".TB_PREFIX."_vdata.owner = $uid";
      $result = mysql_query($q, $this->connection);
      if($result) {
      return mysql_fetch_array($result,MYSQL_NUM);
      }
      else {
         return array(0);
      }
   }
   
   /***************************
   Function to retrieve type of village via ID
   References: Village ID
   ***************************/
   function getVillageType($wref) {
      $q = "SELECT fieldtype FROM ".TB_PREFIX."wdata where id = $wref";
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray['fieldtype'];
   }
   
   /***************************
   Function to retrieve wref from village by name
   References: Village Name
   ***************************/
   function getVillageByName($name) {
      $name = mysql_real_escape_string($name,$this->connection);
      $q = "SELECT wref FROM ".TB_PREFIX."vdata where name = '$name'";
      $result = mysql_query($q,$this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray['wref'];
   }
   
   /***************************
   Function to update specific field of village
   References: Field, Value, Village ID
   ***************************/
   function putVillageStats($field, $value, $vid) {
      $q = "UPDATE ".TB_PREFIX."vdata set $field = $value where wref = $vid";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to set updated time
   References: Village ID
   ***************************/
   function updateVillage($vid) {
      $time = time();
      $q = "UPDATE ".TB_PREFIX."vdata set lastupdate = $time where wref = $vid";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add resource fields for village
   References: Village ID, Village Type
   ***************************/
   function addResourceFields($vid,$type) {
      switch($type) {
         case 1:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,4,4,1,4,4,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 2:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,1,3,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 3:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,3,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 4:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,2,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 5:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,3,1,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 6:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,4,4,1,3,4,4,4,4,4,4,4,4,4,4,4,2,4,4,1,15)";
         break;
         case 7:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,4,1,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 8:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,4,1,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 9:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,4,1,1,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 10:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,4,1,2,2,2,3,4,4,3,3,4,4,1,4,2,1,2,1,15)";
         break;
         case 11:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,3,1,1,3,1,4,4,3,3,4,4,3,1,4,4,2,4,4,1,15)";
         break;
         case 12:
         $q = "INSERT into ".TB_PREFIX."fdata (vref,f1t,f2t,f3t,f4t,f5t,f6t,f7t,f8t,f9t,f10t,f11t,f12t,f13t,f14t,f15t,f16t,f17t,f18t,f26,f26t) values($vid,1,4,1,1,2,2,3,4,4,3,3,4,4,1,4,1,2,1,1,15)";
         break;
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add construction fields
   References: Village ID
   ***************************/
   function addConst($vid) {
      $q = "INSERT into ".TB_PREFIX."constdata (vref) values ($vid)";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add units default data
   References: Village ID
   ***************************/
   function addUnits($vid) {
      $q = "INSERT into ".TB_PREFIX."units (vref) values ($vid)";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to get running construction
   References: Village ID
   ***************************/
   function getResourceCount($vid) {
      $q = "SELECT count from ".TB_PREFIX."constdata where vref = $vid";
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray['count'];
   }
   
   /***************************
   Function to start resource upgrade
   Mode 1: Construction 1
   Mode 2: Construction 2
   Mode 3: Construction 3
   Mode 4: Construction 4
   References: Village ID, Field, Endtime, BID, Log ID, Construction Number
   ***************************/
   function startResourceUpgrade($vid,$field,$endtime,$type,$logid,$mode) {
      switch($mode) {
         case 1:
         $q = "UPDATE ".TB_PREFIX."constdata set upgrading1 = $field, endtime1 = $endtime, utype1 = $type, logid1 = $logid, count = count + 1 where vref = $vid";
         break;
         case 2:
         $q = "UPDATE ".TB_PREFIX."constdata set upgrading2 = $field, endtime2 = $endtime, utype2 = $type,logid2 = $logid, count = count + 1 where vref = $vid";
         break;
         case 3:
         $q = "UPDATE ".TB_PREFIX."constdata set upgrading3 = $field, endtime3 = $endtime, utype3 = $type,logid3 = $logid, count = count + 1 where vref = $vid";
         break;
         case 4:
         $q = "UPDATE ".TB_PREFIX."constdata set upgrading4 = $field, endtime4 = $endtime, utype4 = $type,logid4 = $logid, count = count + 1 where vref = $vid";
         break;
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to cancel resource upgrade
   References: Village ID
   ***************************/
   function cancelResourceUpgrade($vid) {
      $count = $this->getResourceCount($vid);
      if($count > 0) {
         $count -= 1;
      }
      $q = "UPDATE ".TB_PREFIX."constdata set upgrading1 = 0 , endtime1 = 0 , utype1 = 0, logid1 = 0, count = $count where vref = $vid";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to get running upgrades and auto assign
   References: Village ID
   ***************************/
   function getRunningResource($vid) {
      $now = time();
      $q = "SELECT * from ".TB_PREFIX."constdata where vref = $vid";
      $result = mysql_query($q, $this->connection);
      $array = mysql_fetch_array($result);
      if($array['count'] != 0) {
            for($i=1;$i<=$array['count'];$i++) {
               if($array['upgrading'.$i] != 0) {
                  $_SESSION['runres'.$i] = $array['upgrading'.$i];
                  $_SESSION['runtype'.$i] = $array['utype'.$i];
                  $_SESSION['logid'.$i] = $array['logid'.$i];
               }
            }
         $timearray = array(($array['endtime1'] - $now),($array['endtime2'] - $now),($array['endtime3'] - $now),($array['endtime4'] - $now));
         return $timearray;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to get running data only
   References: Village ID
   ***************************/
   function getRunningData($vid) {
      $now = time();
      $q = "SELECT * from ".TB_PREFIX."constdata where vref = $vid";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result,MYSQL_ASSOC);
   }
   
   /***************************
   Function to shift upgrades infront
   Mode 1: Shift 1-4
   Mode 2: Shift 2-4
   Mode 3: Shift 3-4
   Mode 4: Shift 4/ Clear 4
   Mode 5: Force finish All
   References: Village ID, Mode
   ***************************/
   function shiftUpgrading($vid,$mode) {
      $count = $this->getResourceCount($vid);
      if($count > 0) {
         $count -= 1;
      }
         switch($mode) {
            case 1:
            $q = "UPDATE ".TB_PREFIX."constdata set upgrading1 = upgrading2, endtime1 = endtime2,utype1 = utype2,logid1 = logid2, endtime2 = endtime3, upgrading2 = upgrading3, utype2 = utype3,logid2 = logid3, endtime3 = endtime4, upgrading3 = upgrading4, utype3 = utype4,logid3 = logid4, endtime4 = 0, upgrading4 = 0, utype4 = 0,logid4 = 0, count = $count where vref = $vid";
            break;
            case 2:
            $q = "UPDATE ".TB_PREFIX."constdata set endtime2 = endtime3, upgrading2 = upgrading3, utype2 = utype3,logid2 = logid3, endtime3 = endtime4, upgrading3 = upgrading4, utype3 = utype4,logid3 = logid4, endtime4 = 0, upgrading4 = 0, utype4 = 0,logid4 = 0, count = $count where vref = $vid";
            break;
            case 3:
            $q = "UPDATE ".TB_PREFIX."constdata set endtime3 = endtime4, upgrading3 = upgrading4, utype3 = utype4,logid3 = logid4, endtime4 = 0, upgrading4 = 0, utype4 = 0,logid4 = 0, count = count - 1 where vref = $vid";
            break;
            case 4:
            $q = "UPDATE ".TB_PREFIX."constdata set endtime4 = 0, upgrading4 = 0, utype4 = 0,logid4 = 0, count = $count where vref = $vid";
            break;
            case 5:
            $q = "REPLACE INTO ".TB_PREFIX."constdata (vref) values ($vid)";
            break;
         }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to retrieve field levels and type
   References: Village ID
   ***************************/
   function getResourceLevel($vid) {
      $q = "SELECT * from ".TB_PREFIX."fdata where vref = $vid";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_assoc($result);
   }
   
   /***************************
   Function to up level resource field
   References: Field, Village ID
   ***************************/
   function updateResourceFields($field,$vid) {
      $q = "UPDATE ".TB_PREFIX."fdata set f".$field." = f".$field." + 1 where vref = $vid";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to set resource field type
   References: Village ID, Field, Type
   ***************************/
   function updateType($vid,$field,$type) {
      $q = "UPDATE ".TB_PREFIX."fdata set f".$field."t = $type where vref = $vid";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to modify resource
   Mode 0: Add resource
   Mode 1: Remove resource
   References: Village ID, Wood, Clay, Iron, Crop, Mode
   ***************************/
   function modifyResource($vid,$wood,$clay,$iron,$crop,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."vdata set wood = wood - $wood, clay = clay - $clay, iron = iron - $iron, crop = crop - $crop where wref = $vid and town = 1";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."vdata set wood = wood + $wood, clay = clay + $clay, iron = iron + $iron, crop = crop + $crop where wref = $vid and town = 1";
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to consume crop
   References: Village ID, Crop
   ***************************/
   function villageUpkeep($vid,$upkeep) {
      $q = "UPDATE ".TB_PREFIX."vdata set crop = crop - $upkeep where wref = $vid and town = 1";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to prune resource except crop
   References: Village ID, Type
   ***************************/
   function pruneResource($vid,$resource) {
      $q = "UPDATE ".TB_PREFIX."vdata set $resource = maxstore where wref = $vid and town = 1";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to prune crop
   References: Village ID, crop
   ***************************/
   function pruneCrop($vid) {
      $q = "UPDATE ".TB_PREFIX."vdata set crop = maxcrop where wref = $vid and town = 1";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to modify population
   Mode 0: Add population
   Mode 1: Remove population
   References: Village ID, Population, Mode
   ***************************/
   function modifyPop($vid,$pop,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."vdata set pop = pop + $pop where wref = $vid and town = 1";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."vdata set pop = pop - $pop where wref = $vid and town = 1";
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add building log
   Type 1: Start Building - Field, Type, Pop
   Type 2: Start Research
   Type 3: Send Resource - Recieve Village, Time, Send ID
   Type 4: Train Unit - Type, Amt, Time
   References: Village ID, Type, References
   ***************************/
   function addRlog($vid,$type,$ref1,$ref2,$ref3) {
      $q = "INSERT into ".TB_PREFIX."baselog values (0, $vid, $type, $ref1, $ref2, $ref3, CURRENT_TIMESTAMP)";
      mysql_query($q, $this->connection);
      return mysql_insert_id($this->connection);
   }
   
   /***************************
   Function to search building log
   References: Village ID, Comment
   ***************************/
   function getRlog($vid,$like) {
      $q = "SELECT id FROM ".TB_PREFIX."baselog where comment like '$like' and vid = $vid";
      $result = mysql_query($q, $this->connection);
      $dbarray = mysql_fetch_array($result);
      return $dbarray['id'];
   }
   
   /***************************
   Function to remove building log
   References: Log ID
   ***************************/
   function removeRlog($id) {
      $q = "DELETE FROM ".TB_PREFIX."baselog where id = $id";
      return mysql_query($q, $this->connection);
   }

   /***************************
   Function to get Map info array (Obsolete)
   References: X, Y
   ***************************/
   function getMInfoArray($x,$y) {
      $q = "SELECT * FROM ".TB_PREFIX."wdata left JOIN ".TB_PREFIX."vdata ON ".TB_PREFIX."vdata.wref = ".TB_PREFIX."wdata.id where (x=".$x[0]." || x=".$x[1]." || x=".$x[2]." || x=".$x[3]."|| x=".$x[4]." || x=".$x[5]." || x=".$x[6].") and (y=".$y[0]." || y=".$y[1]." ||y=".$y[2]."||y=".$y[3]."||y=".$y[4]."||y=".$y[5]."||y=".$y[6].") order by ".TB_PREFIX."wdata.x asc, ".TB_PREFIX."wdata.y asc LIMIT 49";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result,MYSQL_BOTH);
   }
   
   /***************************
   Function to get Map info by World ID
   References: World ID
   ***************************/
   function getMInfo($id) {
      $q = "SELECT * FROM ".TB_PREFIX."wdata left JOIN ".TB_PREFIX."vdata ON ".TB_PREFIX."vdata.wref = ".TB_PREFIX."wdata.id where ".TB_PREFIX."wdata.id = $id";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_array($result);
   }
   
   /***************************
   Function to get messages
   Mode 1: Get inbox
   Mode 2: Get sent
   Mode 3: Get message
   Mode 4: Set viewed
   Mode 5: Remove message
   Mode 6: Retrieve archive
   References: User ID/Message ID, Mode
   ***************************/
   function getMessage($id,$mode) {
      switch($mode) {
         case 1:
         $q = "SELECT * FROM ".TB_PREFIX."mdata WHERE recieve = $id";
         break;
         case 2:
         $q = "SELECT * FROM ".TB_PREFIX."mdata WHERE sender = $id";
         break;
         case 3:
         $q = "SELECT * FROM ".TB_PREFIX."mdata where id = $id";
         break;
         case 4:
         $q = "UPDATE ".TB_PREFIX."mdata set viewed = 1 where id = $id";
         break;
         case 5:
         $q = "DELETE FROM ".TB_PREFIX."mdata where id = $id";
         break;
         case 6:
         $q = "SELECT * FROM ".TB_PREFIX."mardata where recieve = $id";
         break;
      }
      if($mode <= 3 || $mode == 6) {
         $result = mysql_query($q, $this->connection);
         return $this->mysql_fetch_all($result);
      }
      else {
         return mysql_query($q, $this->connection);
      }
   }
   
   /***************************
   Function to see if there is unread message or notice
   Mode 0: Message
   Mode 1: Notice
   References: User, Mode
   ***************************/
   function gotUnread($id,$mode) {
      if(!$mode) {
         $q = "SELECT * FROM ".TB_PREFIX."mdata where recieve = $id & viewed = 0";
      }
      else {
         $q = "SELECT * FROM ".TB_PREFIX."notice where recieve = $id & viewed = 0";
      }
      $result = mysql_query($q, $this->connection);
      if(mysql_affected_rows($this->connection) != 0) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to process MYSQLi->fetch_all (Only exist in MYSQL)
   References: Result
   ***************************/
   function mysql_fetch_all($result) {
      $all = array();
      while ($row = mysql_fetch_assoc($result)){ $all[] = $row; }
      return $all;
      }
   
   /***************************
   Function to send message
   Mode 0: Normal Send
   Mode 1: Add to archive
   References: Reciever, Sender, Topic, Message, Mode
   ***************************/
   function sendMessage($client,$from,$topic,$message,$mode) {
      $time = time();
      $to = $this->getUserField($client,'id',1);
      if(!$mode) {
      $q = "INSERT INTO ".TB_PREFIX."mdata values (0,$to, $from,'$topic','$message',0,$time)";
      }
      else {
         $q = "INSERT INTO ".TB_PREFIX."mardata values (0,$to, $from,'$topic','$message',0,$time)";
      }
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to add movement to other village
   Type 0: Send Resource
   Type 1: Send Merchant
   Type 2: Return Resource
   Type 3: Attack
   Type 4: Return
   Type 5: Settler
   References: Type, From, To, Reference, Endtime
   ***************************/
   function addMovement($type,$from,$to,$ref,$endtime) {
      $q = "INSERT INTO ".TB_PREFIX."movement values (0,$type,$from,$to,$ref,$endtime,0)";
      return mysql_query($q, $this->connection);
   }
   
   /***************************
   Function to retrieve movement of village
   Type 0: Send Resource
   Type 1: Send Merchant
   Type 2: Return Resource
   Type 3: Attack
   Type 4: Return
   Type 5: Settler
   Mode 0: Send/Out
   Mode 1: Recieve/In
   References: Type, Village, Mode
   ***************************/
   function getMovement($type,$village,$mode) {
      $time = time();
      if(!$mode) {
         $where = "from";
      }
      else {
         $where = "to";
      }
      switch($type) {
         case 0: $q = "SELECT * FROM ".TB_PREFIX."movement, ".TB_PREFIX."send where ".TB_PREFIX."movement.".$where." = $village and ".TB_PREFIX."movement.ref = ".TB_PREFIX."send.id and ".TB_PREFIX."movement.proc = 0"; break;
         case 2: $q = "SELECT * FROM ".TB_PREFIX."movement where ".TB_PREFIX."movement.".$where." = $village and proc = 0 and type = 2"; break;
      }
      $result = mysql_query($q, $this->connection);
      $array = $this->mysql_fetch_all($result);
      return $array;
   }
   
   /***************************
   Function to set process flag on movement
   References: Moveid
   ***************************/
   function setMovementProc($moveid) {
      $q = "UPDATE ".TB_PREFIX."movement set proc = 1 where moveid = $moveid";
      return mysql_query($q,$this->connection);
   }
   
   /***************************
   Function to set accept flag on market
   References: id
   ***************************/
   function setMarketAcc($id) {
      $q = "UPDATE ".TB_PREFIX."movement set accept = 1 where id = $id";
      return mysql_query($q,$this->connection);
   }
   
   /***************************
   Function to send resource to other village
   Mode 0: Send
   Mode 1: Cancel
   References: Wood/ID, Clay, Iron, Crop, Mode
   ***************************/
   function sendResource($ref,$clay,$iron,$crop,$merchant,$mode) {
      if(!$mode) {
         $q = "INSERT INTO ".TB_PREFIX."send values (0,$ref,$clay,$iron,$crop,$merchant)";
         mysql_query($q, $this->connection);
         return mysql_insert_id($this->connection);
      }
      else {
         $q = "DELETE FROM ".TB_PREFIX."send where id = $ref";
         return mysql_query($q, $this->connection);
      }
   }
   
   /***************************
   Function to add market offer
   Mode 0: Add
   Mode 1: Cancel
   References: Village, Give, Amt, Want, Amt, Time, Alliance, Mode
   ***************************/
   function addMarket($vid,$gtype,$gamt,$wtype,$wamt,$time,$alliance,$merchant,$mode) {
      if(!$mode) {
         $q = "INSERT INTO ".TB_PREFIX."market values (0,$vid,$gtype,$gamt,$wtype,$wamt,0,$time,$alliance,$merchant)";
         mysql_query($q, $this->connection);
         return mysql_insert_id($this->connection);
      }
      else {
         $q = "DELETE FROM ".TB_PREFIX."market where id = $gtype and vref = $vid";
         return mysql_query($q, $this->connection);
      }
   }
   
   /***************************
   Function to get market offer
   References: Village, Mode
   ***************************/
   function getMarket($vid,$mode) {
      $alliance = $this->getUserField($this->getVillageOwner($vid),"alliance",0);
      if(!$mode) {
         $q = "SELECT * FROM ".TB_PREFIX."market where vref = $vid";
      }
      else {
         $q = "SELECT * FROM ".TB_PREFIX."market where vref != $vid and alliance = $alliance or vref != $vid and alliance = 0";
      }
      $result = mysql_query($q, $this->connection);
      return $this->mysql_fetch_all($result);
   }
   
   /***************************
   Function to get market offer
   References: ID
   ***************************/
   function getMarketInfo($id) {
      $q = "SELECT * FROM ".TB_PREFIX."market where id = $id";
      $result = mysql_query($q, $this->connection);
      return mysql_fetch_assoc($result);
   }
   
   /***************************
   Function to retrieve used merchant
   References: Village
   ***************************/
   function totalMerchantUsed($vid) {
      $time = time();
      $q = "SELECT sum(".TB_PREFIX."send.merchant) from ".TB_PREFIX."send, ".TB_PREFIX."movement where ".TB_PREFIX."movement.from = $vid and ".TB_PREFIX."send.id = ".TB_PREFIX."movement.ref and ".TB_PREFIX."movement.proc = 0 and type = 0";
       $result = mysql_query($q, $this->connection);
       $row = mysql_fetch_row($result);
       $q2 = "SELECT sum(ref) from ".TB_PREFIX."movement where type = 2 and ".TB_PREFIX."movement.to = $vid and proc = 0";
       $result2 = mysql_query($q2, $this->connection);
       $row2 = mysql_fetch_row($result2);
       $q3 = "SELECT sum(merchant) from ".TB_PREFIX."market where vref = $vid";
       $result3 = mysql_query($q3, $this->connection);
       $row3 = mysql_fetch_row($result3);
       return $row[0]+$row2[0]+$row3[0];
   }
   
   /***************************
   Function to get unit array
   Mode 0: From
   Mode 1: Vref
   References: Village, Mode
   ***************************/
   function getEnforce($vid,$mode) {
      if($mode) {
         $q = "SELECT * from ".TB_PREFIX."enforcement where vref = $vid";
      }
      else {
         $q = "SELECT * from ".TB_PREFIX."enforcement where from = $vid";
      }
      $result = mysql_query($q,$this->connection);
      return $this->mysql_fetch_all($result);
   }
   
   /***************************
   Function to get unit array
   References: Village
   ***************************/
   function getUnit($vid) {
      $q = "SELECT * from ".TB_PREFIX."units where vref = $vid";
      $result = mysql_query($q,$this->connection);
      return mysql_fetch_assoc($result);
   }
   
   /***************************
   Function to get unit array
   Mode 0: Train
   Mode 1: Cancel
   References: Village, Unit, Amount, Each, Time, Mode
   ***************************/
   function trainUnit($vid,$unit,$amt,$each,$time,$mode) {
      if(!$mode) {
         $q = "INSERT INTO ".TB_PREFIX."training values (0,$vid,$unit,$amt,$time,$each)";
      }
      else {
         $q = "DELETe FROM ".TB_PREFIX."training where id = $vid";
      }
      return mysql_query($q,$this->connection);
   }
   
   /***************************
   Function to get unit array
   References: ID
   ***************************/
   function updateTraining($id) {
      $q = "UPDATE INTO ".TB_PREFIX."training set amt = amt - 1 where id = $id";
      return mysql_query($q,$this->connection);
   }
   
   /***************************
   Function to get oncurrent training
   References: Village
   ***************************/
   function getTraining($vid) {
      $q = "SELECT * FROM ".TB_PREFIX."training where vref = $vid";
      $result = mysql_query($q,$this->connection);
      return $this->mysql_fetch_all($result);
   }
   
   /***************************
   Function to get modify unit
   Mode 0: Remove
   Mode 1: Add
   References: Village, Unit, Amount, Mode
   ***************************/
   function modifyUnit($vref,$unit,$amt,$mode) {
      $unit = 'u'.$unit;
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."units set $unit = $unit - $amt where vref = $vref";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."units set $unit = $unit + $amt where vref = $vref";
      }
      return mysql_query($q,$this->connection);
   }
   
   /***************************
   Function to get tech array
   References: Village
   ***************************/
   function getTech($vid) {
      $q = "SELECT tech from ".TB_PREFIX."research where vref = $vid and timestamp <= time()";
      $result = mysql_query($q, $this->connection);
      $holder = array();
      if(mysql_affected_rows($this->connection) != 0) {
         foreach($this->mysql_fetch_all($result) as $value) {
            array_push($holder,$value['tech']);
         }
         return $holder;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to get ranking array
   References: -
   ***************************/
   function getRanking() {
      if(INCLUDE_ADMIN) {
         $q = "SELECT id,username,cp,ap,dp FROM ".TB_PREFIX."users where access != ".BANNED;
      }
      else {
         $q = "SELECT id,username,cp,ap,dp FROM ".TB_PREFIX."users where access = 1";
      }
      $result = mysql_query($q, $this->connection);
      return $this->msqyl_fetch_all($result);
   }
   
   /***************************
   Function to do free query
   References: Query
   ***************************/
   function query($query) {
      return mysql_query($query, $this->connection);
   }
};

class MYSQLi_DB {
   
   var $connection;
   
   function MYSQLi_DB() {
      $this->connection = mysqli_connect(SQL_SERVER, SQL_USER, SQL_PASS, SQL_kietas or die(mysqli_error());
   }
   
   /***************************
   Function to check existance of email or the username.
   Mode 0: username;
   Mode 1: Email;
   References: Reference, Mode
   ***************************/
   function checkExist($ref,$mode) {
      if(!$mode) {
         $q = "SELECT username FROM ".TB_PREFIX."users where username = '$ref' LIMIT 1";
      }
      else {
         $q = "SELECT email FROM ".TB_PREFIX."users where email = '$ref' LIMIT 1";
      }
      $result = $this->connection->query($q);
      if(mysqli_num_rows($result)) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to check the existing session if its correct.
   References: Username, Session ID
   ***************************/
   function checkactiveSession($username,$sessid) {
      $q = "SELECT username FROM ".TB_PREFIX."users where username = '$username' and sessid = '$sessid' LIMIT 1";
      $result = $this->connection->query($q);
      if(mysqli_num_rows($result) != 0) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to update any field in users.
   References: Username, Field Name, Value
   ***************************/
   function updateUserField($username,$field,$value) {
      $q = "UPDATE ".TB_PREFIX."users set $field = '$value' where username = '$username'";
      return $this->connection->query($q);
   }
   
   /***************************
   Function to login users
   References: Username, Password
   ***************************/
   function login($username,$password) {
      $q = "SELECT password FROM ".TB_PREFIX."users where username = '$username' and access != ".BANNED;
      $result = $this->connection->query($q);
      $row = $result->fetch_assoc();
      if($row['password'] == md5($password)) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to register users
   References: Username, Password, Email, Tribe, Activation
   ***************************/
   function register($username,$password,$email,$tribe,$act) {
      $time = time();
      $q = "INSERT INTO ".TB_PREFIX."users (username,password,access,email,timestamp,tribe,act) VALUES ('$username', '$password', ".USER.", '$email', $time, $tribe, '$act')";
      if($this->connection->query($q)) {
         return $this->connection->insert_id;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to delete users
   References: User ID
   ***************************/
   function deleteAccount($id) {
      $time = time();
      $allvillage = $this->getAVillage($id);
      for($i=0;$i<=count($allvillage)-1;$i++) {
         $q = "DELETE FROM ".TB_PREFIX."constdata where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."fdata where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "UPDATE ".TB_PREFIX."wdata set occupied = 1 where id = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."baselog where vid = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."market where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."movement where send = ".$allvillage[$i]['wref']." or recieve = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."units where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."enforcement where vref = ".$allvillage[$i]['wref']." or from = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."training where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."heroes where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
         $q = "DELETE FROM ".TB_PREFIX."research where vref = ".$allvillage[$i]['wref'];
         $this->connection->query($q);
      }
      $q = "DELETE FROM ".TB_PREFIX."mdata where sender = $id or recieve = $id";
      $this->connection->query($q);
      $q = "DELETE FROM ".TB_PREFIX."userlink where uref = $id";
      $this->connection->query($q);
      $q = "DELETE FROM ".TB_PREFIX."mardata where sender = $id or recieve = $id";
      $this->connection->query($q);
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $id and town = 0";
      $result = $this->connection->query($q);
      if($this->connection->affected_rows > 0) {
         $array = $this->mysql_fetch_all($result);
         for($i=0;$i<=count($array)-1;$i++) {
            $q = "UPDATE ".TB_PREFIX."wdata set occupied = 0 where id = ".$array[$i]['wref'];
            $this->connection->query($q);
         }
      }
      $q = "DELETE FROM ".TB_PREFIX."vdata where owner = $id";
      $this->connection->query($q);
      $q = "DELETE FROM ".TB_PREFIX."users where id = $id";
      $this->connection->query($q);
   }
   
   /**************************
   Function to calculate registered users
   References: -
   **************************/
   function countUsers() {
      $q = "SELECT * FROM ".TB_PREFIX."users";
      $result = $this->connection->query($q);
      return $result->num_rows;
   }
   
   
   /**************************
   Function to give or remove gold
   Mode 0: Remove
   Mode 1: Give
   References: User ID, Amount, Mode
   **************************/
   function modifyGold($id,$amt,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."USERS set gold = gold - $amt where id = $id";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."USERS set gold = gold + $amt where id = $id";
      }
      return $this->connection->query($q);
   }
   
   /**************************
   Function to check plus
   References: Userid
   **************************/
   function checkPlus($id) {
      $q = "SELECT plus from ".TB_PREFIX."users where id = $id";
      $result = $this->connection->query($q);
      $row = $result->fetch_assoc();
      if($row['plus'] > time()) {
         return true;
      }
      else {
         $this->modifyPlus($id,0);
      }
   }
   
   /**************************
   Function to give or remove plus
   Mode 0: Remove
   Mode 1: Give
   References: Userid, Mode
   **************************/
   function modifyPlus($id,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."users set access = ".USER." where id = $id and access < ".MODERATOR."";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."users set access = ".PLUS." where id = $id and access < ".MODERATOR."";
      }
      return $this->connection->query($q);
   }
   
   /**************************
   Function to generate base for new registration
   Sector 0: Random all
   Sector 1: -x, +y
   Sector 2: +x, +y
   Sector 3: -x, -y
   Sector 4: +x, -y
   References: Sector
   **************************/
   function generateBase($sector) {
      $count = $this->countUsers();
      $starter = -3;
      if($count > 20) {
         $starter = -3 * round($count/20);
      }
      switch($sector) {
         case 0:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and occupied = 0 and x > $starter and y > $starter LIMIT 200";
         break;
         case 1:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x < 0 and y > 0 and occupied = 0 LIMIT 200";
         break;
         case 2:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x > 0 and y > 0 and occupied = 0 LIMIT 200";
         break;
         case 3:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x < 0 and y < 0 and occupied = 0 LIMIT 200";
         break;
         case 4:
         $q = "Select * from ".TB_PREFIX."wdata where fieldtype = 3 and x > 0 and y < 0 and occupied = 0 LIMIT 200";
         break;
      }
         $result = $this->connection->query($q);
         $num_rows = $result->num_rows;
         $row = $result->fetch_all(MYSQLI_ASSOC);
         $base = rand(0, ($num_rows-1));
         return $row[$base]['id'];
   }
   
   /***************************
   Function to retrieve data from specific field in users
   Mode 0: Search by ID
   Mode 1: Search by Username
   References: Reference, Field, Mode
   ***************************/
   function getUserField($ref,$field,$mode) {
      if(!$mode) {
         $q = "SELECT $field FROM ".TB_PREFIX."users where id = $ref";
      }
      else {
         $q = "SELECT $field FROM ".TB_PREFIX."users where username = '$ref'";
      }
      $result = $this->connection->query($q);
      $obj = $result->fetch_object();
      return $obj->$field;
   }
   
   /***************************
   Function to retrieve data from specific field in vdata
   References: Reference, Field
   ***************************/
   function getVillageField($ref,$field) {
      $q = "SELECT $field FROM ".TB_PREFIX."vdata where wref = $ref";
      $result = $this->connection->query($q);
      $obj = $result->fetch_object();
      return $obj->$field;
   }
   
   /***************************
   Function to retrieve alliance name via ID
   References: Alliance ID
   ***************************/
   function getUserAlliance($id) {
      $q = "SELECT ".TB_PREFIX."alidata.name from ".TB_PREFIX."users join ".TB_PREFIX."alidata where ".TB_PREFIX."users.alliance = ".TB_PREFIX."alidata.id";
      $result = $this->connection->query($q);
      $obj = $result->fetch_object();
      if($this->connection->affected_rows != 0) {
      return $obj->name;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to retrieve user array via Username or ID
   Mode 0: Search by Username
   Mode 1: Search by ID
   References: Alliance ID
   ***************************/
   function getUserArray($ref,$mode) {
      if(!$mode) {
         $q = "SELECT * FROM ".TB_PREFIX."users where username = '$ref'";
      }
      else {
         $q = "SELECT * FROM ".TB_PREFIX."users where id = $ref";
      }
      $result = $this->connection->query($q);
      return $result->fetch_assoc();
   }
   
   /***************************
   Function to update active user in database
   References: Username, Time
   ***************************/
   function updateActiveUser($username,$time) {
      $q = "UPDATE ".TB_PREFIX."users set timestamp = $time where username = '$username'";
      $exec1 = $this->connection->query($q);
      $q = "REPLACE into ".TB_PREFIX."active values ('$username',$time)";
      $exec2 = $this->connection->query($q);
      if($exec1 && $exec2) {
         return true;
      }
      else {
         return false;
      }
   }
   
   /***************************
   Function to add or remove active user
   Mode 0: Add active
   Mode 1: Remove active
   References: Username, Mode
   ***************************/
   function activeModify($username,$mode) {
      $time = time();
      if(!$mode) {
         $q = "INSERT into ".TB_PREFIX."active VALUES ('$username',$time)";
      }
      else {
         $q = "DELETE FROM ".TB_PREFIX."active where username = '$username'";
      }
      return $this->connection->query($q);
   }
   
   /***************************
   Function to automatically clear inactive user
   References: Nil
   ***************************/
   function removeInactiveUsers(){
      $timeout = time()-USER_TIMEOUT*60;
      $q = "DELETE FROM ".TB_PREFIX."active WHERE timestamp < $timeout";
      return $this->connection->query($q);
   }
   
   /***************************
   Function to add cultral points to village or users
   Mode 0: Add to village
   Mode 1: Add to user
   References: Reference, Points, Mode
   ***************************/
   function addCP($ref,$cp,$mode) {
      if(!$mode) {
         $q = "UPDATE ".TB_PREFIX."vdata set cp = cp + $cp where wref = $ref and town = 1";
      }
      else {
         $q = "UPDATE ".TB_PREFIX."users set cp = cp + $cp where id = $ref and town = 1";
      }
      return $this->connection->query($q);
   }
   
   /***************************
   Function to get world field details
   References: Field ID
   ***************************/
   function getFieldDetails($id) {
      $q = "SELECT * FROM ".TB_PREFIX."wdata where id = $id";
      $result = $this->connection->query($q);
      return $result->fetch_assoc();
   }
   
   /***************************
   Function to set occupied on world data
   References: Field ID
   ***************************/
   function setFieldTaken($id) {
      $q = "UPDATE ".TB_PREFIX."wdata set occupied = 1 where id = $id";
      return $this->connection->query($q);
   }
   
   /***************************
   Function to add village or oasis to user
   Mode 0: Add Village
   Mode 1: Add Oasis
   References: Field ID, User ID, Username, Capital, Mode
   ***************************/
   function addVillage($wid,$uid,$username,$capital,$oasis) {
      $total = $this->getAVillageCount($uid);
      if ($total >= 1) {
      $vname = $username."\'s village ".($total+1);
      }
      else {
         $vname = $username."\'s village";
      }
      $time = time();
      if($oasis) {
         $q = "INSERT into ".TB_PREFIX."vdata values ($wid, $uid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, $time)";
      }
      else {
         $q = "INSERT into ".TB_PREFIX."vdata values ($wid, $uid, '$vname', $capital, 1, 2, 0, 750, 750, 750, 800, 750, 800, $time)";
      }
      return $this->connection->query($q);
   }
   
   /***************************
   Function to retrieve capital of user
   References: User ID
   ***************************/
   function getCapital($uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $uid and capital = 1 and town = 1";
      $result = $this->connection->query($q);
      return $result->fetch_assoc();
   }
   
   /***************************
   Function to retrieve any village of user
   References: Village ID, User ID
   ***************************/
   function getVillage($vid,$uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where wref = $vid and owner = $uid and town = 1";
      $result = $this->connection->query($q);
      return $result->fetch_assoc();
   }
   
   /***************************
   Function to retrieve owner of village
   References: Village ID
   ***************************/
   function getVillageOwner($vid) {
      $q = "SELECT owner FROM ".TB_PREFIX."vdata where wref = $vid";
      $result = $this->connection->query($q);
      $row = $result->fetch_assoc();
      return $row['owner'];
   }
   
   /***************************
   Function to count number of village owned by user
   References: User ID
   ***************************/
   function getAVillageCount($uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $uid and town = 1";
      $result = $this->connection->query($q);
      return $result->num_rows;
   }
   
   /***************************
   Function to count number of pop in village owned by user
   References: User ID
   ***************************/
   function getAVillagePop($uid) {
      $q = "SELECT sum(pop) FROM ".TB_PREFIX."vdata where owner = $uid and town = 1";
      $result = $this->connection->query($q);
      $row = $result->fetch_row();
      return $row[0];
   }
   
   /***************************
   Function to retrieve all village of user
   References: User ID
   ***************************/
   function getAVillage($uid) {
      $q = "SELECT * FROM ".TB_PREFIX."vdata where owner = $uid and town = 1";
      $result = $this->connection->query($q);
      return $result->fetch_all(MYSQLI_ASSOC);
   }
   
   /***************************
   Function to retrieve coordinate of village
   References: Village ID
   ***************************/
   function getCoor($wref) {
      $q = "SELECT x,y FROM ".TB_PREFIX."wdata where id = $wref";
      $result = $this->connection->query($q);
      return $result->fetch_assoc();
   }
   
   /***************************
   Function to retrieve type of oasis via user id
   References: User ID
   ***************************/
   function getOasisType($uid) {
      $q = "select ".TB_PREFIX."_wdata.oasistype from ".TB_PREFIX."_wdata,".TB_PREFIX."_vdata where ".TB_PREFIX."_wdata.id = ".TB_PREFIX."_vdata.wref and ".TB_PREFIX."_vdata.town = 0 and ".TB_PREFIX."_vdata.owner = $uid";
      $result = $this->connection->query($q);
      if($result) {
      return $result->fetch_all(MYSQL_NUM);
      }
      else {
         return array(0);
      }
   }
   
   /***************************
   Function to retrieve type of village via ID
   References: Village ID
   ***************************/
   function getVillageType($wref) {
      $q = "SELECT fieldtype FROM ".TB_PREFIX."wdata where id = $wref";
      $result = $this->connection->query($q);
      $row = $result->fetch_assoc();
      return $row['fieldtype'];
   }




(čia baigiasi simboliai leistini simboliai)

2011 Kov. 15 17:03:39          8 žinutė iš 8
Spausdinti pranešimą
Nei, aš prašiau to database.php... Pagal error sako kad negali inludinti constant.php nes jo neranda... Pakeisk 10 elutę į


include("../constant.php");


gal padės, negarantuoju.

nolife.lt / c-s.lt
Peršokti į forumą: