Ir para conteúdo
Fórum CódigoFonte.net

Pedro6i

Membros
  • Total de itens

    1
  • Registro em

  • Última visita

  1. Salve amigos!! Primeiramente boa tarde e que deus abençoe a todos!!!! Me desculpem atrapalhar vocês mas estou com um probleminha (meu conhecimento é limitado em Php) e não consigo resolver.... Vou explicar a situação... estou montando um servidor de Travian (so para brincarmos na empresa mesmo, sem intenções $$$) A realidade hoje é a seguinte... * Core2Quad Q8300 4gb memoria.. * Windows 2008 Enterprise * Travian clone Project PHP (http://forum.horeca-spel.nl/) * Xamp instalado e rodando perfeito (testei todos [easyphp, wamp appserv mas o xamp foi o que rodou melhor e não deu erros]) So para vocês entenderem o procedimento que fiz.. * instalei o xamp * Criei uma DB chamada hyborian (nome do meu servidor [Conan Era hyboriana OWNA xD ] * Instalei na pasta Htdocs o Projeto (em outros é a pasta www) * A instalação do Travian é via navegador mesmo... (no caso ficou assim... http://localhost/speed/install_v2/index.php esse é o local para começar a instalação..) * Instalei de boa... tudo rodou bem... eu entro no jogo, crio o cadastro mas na hora de logar esse dá o seguinte erro: Fatal error: Call to a member function updateActiveUser () on a non-object in C: \ xampp \ htdocs \ speed \ GameEngine \ Session.php on line 39 O arquivo de configuração é db_MYSQL.php em GameEngine\Database\ o meu está da seguinte maneira: <?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 register($username,$password,$email,$tribe,$locate ,$act) { $time = time(); $q = "INSERT INTO ".TB_PREFIX."users (username,password,access,email,timestamp,tribe,lo cation,act,protect) VALUES ('$username', '$password', ".USER.", '$email',$time, $tribe, $locate, '$act', $time)"; if(mysql_query($q,$this->connection)) { return mysql_insert_id($this->connection); } else { return false; } } function unreg($username) { $q = "DELETE from ".TB_PREFIX."users where username = '$username'"; return mysql_query($q,$this->connection); } 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 updateUserField($ref,$field,$value,$switch) { if(!$switch) { $q = "UPDATE ".TB_PREFIX."users set $field = '$value' where username = '$ref'"; } else { $q = "UPDATE ".TB_PREFIX."users set $field = '$value' where id = '$ref'"; } return mysql_query($q, $this->connection); } function getSitee($uid) { $q = "SELECT id from ".TB_PREFIX."users where sit1 = $uid or sit2 = $uid"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function removeMeSit($uid,$uid2) { $q = "UPDATE ".TB_PREFIX."users set sit1 = 0 where id = $uid and sit1 = $uid2"; mysql_query($q,$this->connection); $q2 = "UPDATE ".TB_PREFIX."users set sit2 = 0 where id = $uid and sit2 = $uid2"; mysql_query($q2,$this->connection); } 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) or die(mysql_error()); $dbarray = mysql_fetch_array($result); return $dbarray[$field]; } 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 sitterLogin($username,$password) { $q = "SELECT sit1,sit2 FROM ".TB_PREFIX."users where username = '$username' and access != ".BANNED; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); if($dbarray['sit1'] != 0) { $q2 = "SELECT password FROM ".TB_PREFIX."users where id = ".$dbarray['sit1']." and access != ".BANNED; $result2 = mysql_query($q2, $this->connection); $dbarray2 = mysql_fetch_array($result2); } else if($dbarray['sit2'] != 0) { $q3 = "SELECT password FROM ".TB_PREFIX."users where id = ".$dbarray['sit2']." and access != ".BANNED; $result3 = mysql_query($q3, $this->connection); $dbarray3 = mysql_fetch_array($result3); } if($dbarray2['password'] == md5($password) || $dbarray3['password'] == md5($password)) { return true; } else { return false; } } function setDeleting($uid,$mode) { $time = time() + 72*3600; if(!$mode) { $q = "INSERT into ".TB_PREFIX."deleting values ($uid,$time)"; } else { $q = "DELETE FROM ".TB_PREFIX."deleting where uid = $uid"; } mysql_query($q, $this->connection); } function isDeleting($uid) { $q = "SELECT timestamp from ".TB_PREFIX."deleting where uid = $uid"; $result = mysql_query($q,$this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['timestamp']; } function modifyGold($username,$amt,$mode) { if(!$mode) { $q = "UPDATE ".TB_PREFIX."users set gold = gold - $amt where username = $username"; } else { $q = "UPDATE ".TB_PREFIX."users set gold = gold + $amt where username = $username"; } return mysql_query($q,$this->connection); } /***************************************** 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 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 addActiveUser($username,$time) { $q = "REPLACE into ".TB_PREFIX."active values ('$username',$time)"; if(mysql_query($q, $this->connection)) { return true; } else { return false; } } function updateActiveUser($username,$time) { $q = "REPLACE into ".TB_PREFIX."active values ('$username',$time)"; $q2 = "UPDATE ".TB_PREFIX."users set timestamp = $time where username = '$username'"; $exec1 = mysql_query($q, $this->connection); $exec2 = mysql_query($q2, $this->connection); if($exec1 && $exec2) { return true; } else { return false; } } 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 submitProfile($uid,$gender,$location,$birthday,$de s1,$des2) { $q = "UPDATE ".TB_PREFIX."users set gender = $gender, location = '$location', birthday = '$birthday', desc1 = '$des1', desc2 = '$des2' where id = $uid"; return mysql_query($q,$this->connection); } function gpack($uid,$gpack) { $q = "UPDATE ".TB_PREFIX."users set gpack = '$gpack' where id = $uid"; return mysql_query($q,$this->connection); } function UpdateOnline($mode, $name="", $time="") { global $session; if ($mode == "login") { $q = "INSERT IGNORE INTO ".TB_PREFIX."online (name, time) VALUES ('$name', ".time().")"; return mysql_query ($q,$this->connection); } else { $q = "DELETE FROM ".TB_PREFIX."online WHERE name ='".$session->username."'"; return mysql_query ($q,$this->connection); } } function generateBase($sector) { switch($sector) { 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, $this->connection); $num_rows = mysql_num_rows($result); $result = $this->mysql_fetch_all($result); $base = rand(0, ($num_rows-1)); return $result[$base]['id']; } function setFieldTaken($id) { $q = "UPDATE ".TB_PREFIX."wdata set occupied = 1 where id = $id"; return mysql_query($q, $this->connection); } function addVillage($wid,$uid,$username,$capital) { $total = count($this->getVillagesID($uid)); if ($total >= 1) { $vname = $username."\'s village ".($total+1); } else { $vname = $username."\'s village"; } $time = time(); $q = "INSERT into ".TB_PREFIX."vdata (wref, owner, name, capital, pop, cp, wood, clay, iron, maxstore, crop, maxcrop, lastupdate, created) values ($wid, $uid, '$vname', $capital, 2, 1, 750, 750, 750, 800, 750, 800, $time, $time)"; return mysql_query($q, $this->connection) or die(mysql_error()); } 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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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,f11 t,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 retrieve type of village via ID References: Village ID ***************************/ function getVillageType($wref) { $q = "SELECT id, 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 if is ocuped via ID References: Village ID *****************************************/ function getVillageState($wref) { $q = "SELECT occupied FROM ".TB_PREFIX."wdata where id = $wref"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['occupied']; } function getProfileVillages($uid) { $q = "SELECT capital,wref,name,pop,created from ".TB_PREFIX."vdata where owner = $uid order by pop desc"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function getVillagesID($uid) { $q = "SELECT wref from ".TB_PREFIX."vdata where owner = $uid order by capital DESC"; $result = mysql_query($q, $this->connection); $array = $this->mysql_fetch_all($result); $newarray = array(); for($i=0;$i<count($array);$i++) { array_push($newarray,$array[$i]['wref']); } return $newarray; } function getVillage($vid) { $q = "SELECT * FROM ".TB_PREFIX."vdata where wref = $vid"; $result = mysql_query($q, $this->connection); return mysql_fetch_array($result); } 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 getOasis($vid) { $q = "SELECT * FROM ".TB_PREFIX."odata where conqured = $vid"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function getOasisInfo($wid) { $q = "SELECT * FROM ".TB_PREFIX."odata where wref = $wid"; $result = mysql_query($q, $this->connection); return mysql_fetch_assoc($result); } function getVillageField($ref,$field) { $q = "SELECT $field FROM ".TB_PREFIX."vdata where wref = $ref"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); return $dbarray[$field]; } function setVillageField($ref,$field,$value) { $q = "UPDATE ".TB_PREFIX."vdata set $field = '$value' where wref = $ref"; return mysql_query($q,$this->connection); } function getResourceLevel($vid) { $q = "SELECT * from ".TB_PREFIX."fdata where vref = $vid"; $result = mysql_query($q, $this->connection); return mysql_fetch_assoc($result); } function getCoor($wref) { $q = "SELECT x,y FROM ".TB_PREFIX."wdata where id = $wref"; if (DBUG){ $this->DataQuery[]=$q; } $result = mysql_query($q, $this->connection); return mysql_fetch_array($result); } function CheckForum($id) { $q = "SELECT * from ".TB_PREFIX."forum_cat where alliance = '$id'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } function CountCat($id) { $q = "SELECT count(id) FROM ".TB_PREFIX."forum_topic where cat = '$id'"; $result = mysql_query($q,$this->connection); $row = mysql_fetch_row($result); return $row[0]; } function LastTopic($id) { $q = "SELECT * from ".TB_PREFIX."forum_topic where cat = '$id' order by post_date"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function CheckLastTopic($id) { $q = "SELECT * from ".TB_PREFIX."forum_topic where cat = '$id'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } function CheckLastPost($id) { $q = "SELECT * from ".TB_PREFIX."forum_post where topic = '$id'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } function LastPost($id) { $q = "SELECT * from ".TB_PREFIX."forum_post where topic = '$id'"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function CountTopic($id) { $q = "SELECT count(id) FROM ".TB_PREFIX."forum_post where owner = '$id'"; $result = mysql_query($q,$this->connection); $row = mysql_fetch_row($result); $qs = "SELECT count(id) FROM ".TB_PREFIX."forum_topic where owner = '$id'"; $results = mysql_query($qs,$this->connection); $rows = mysql_fetch_row($results); return $row[0]+$rows[0]; } function CountPost($id) { $q = "SELECT count(id) FROM ".TB_PREFIX."forum_post where topic = '$id'"; $result = mysql_query($q,$this->connection); $row = mysql_fetch_row($result); return $row[0]; } function ForumCat($id) { $q = "SELECT * from ".TB_PREFIX."forum_cat where alliance = '$id' ORDER BY id"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function ForumCatEdit($id) { $q = "SELECT * from ".TB_PREFIX."forum_cat where id = '$id'"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function ForumCatName($id) { $q = "SELECT forum_name from ".TB_PREFIX."forum_cat where id = $id"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['forum_name']; } function CheckCatTopic($id) { $q = "SELECT * from ".TB_PREFIX."forum_topic where cat = '$id'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } function CheckResultEdit($alli) { $q = "SELECT * from ".TB_PREFIX."forum_edit where alliance = '$alli'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } function CheckCloseTopic($id) { $q = "SELECT close from ".TB_PREFIX."forum_topic where id = '$id'"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['close']; } function CheckEditRes($alli) { $q = "SELECT result from ".TB_PREFIX."forum_edit where alliance = '$alli'"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['result']; } function CreatResultEdit($alli,$result) { $q = "INSERT into ".TB_PREFIX."forum_edit values (0,'$alli','$result')"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } function UpdateResultEdit($alli,$result) { $date = time(); $q = "UPDATE ".TB_PREFIX."forum_edit set result = '$result' where alliance = '$alli'"; return mysql_query($q, $this->connection); } function UpdateEditTopic($id,$title,$cat) { $q = "UPDATE ".TB_PREFIX."forum_topic set title = '$title', cat = '$cat' where id = $id"; return mysql_query($q, $this->connection); } function UpdateEditForum($id,$name,$des) { $q = "UPDATE ".TB_PREFIX."forum_cat set forum_name = '$name', forum_des = '$des' where id = $id"; return mysql_query($q, $this->connection); } function StickTopic($id,$mode) { $q = "UPDATE ".TB_PREFIX."forum_topic set stick = '$mode' where id = '$id'"; return mysql_query($q, $this->connection); } function ForumCatTopic($id) { $q = "SELECT * from ".TB_PREFIX."forum_topic where cat = '$id' AND stick = '' ORDER BY post_date desc"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function ForumCatTopicStick($id) { $q = "SELECT * from ".TB_PREFIX."forum_topic where cat = '$id' AND stick = '1' ORDER BY post_date desc"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function ShowTopic($id) { $q = "SELECT * from ".TB_PREFIX."forum_topic where id = '$id'"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function ShowPost($id) { $q = "SELECT * from ".TB_PREFIX."forum_post where topic = '$id'"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function ShowPostEdit($id) { $q = "SELECT * from ".TB_PREFIX."forum_post where id = '$id'"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function CreatForum($owner,$alli,$name,$des,$area) { $q = "INSERT into ".TB_PREFIX."forum_cat values (0,'$owner','$alli','$name','$des','$area')"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } function CreatTopic($title,$post,$cat,$owner,$alli,$ends) { $date = time(); $q = "INSERT into ".TB_PREFIX."forum_topic values (0,'$title','$post','$date','$date','$cat','$owner ','$alli','$ends','','')"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } function CreatPost($post,$tids,$owner) { $date = time(); $q = "INSERT into ".TB_PREFIX."forum_post values (0,'$post','$tids','$owner','$date')"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } function UpdatePostDate($id) { $date = time(); $q = "UPDATE ".TB_PREFIX."forum_topic set post_date = '$date' where id = $id"; return mysql_query($q, $this->connection); } function EditUpdateTopic($id,$post) { $q = "UPDATE ".TB_PREFIX."forum_topic set post = '$post' where id = $id"; return mysql_query($q, $this->connection); } function EditUpdatePost($id,$post) { $q = "UPDATE ".TB_PREFIX."forum_post set post = '$post' where id = $id"; return mysql_query($q, $this->connection); } function LockTopic($id,$mode) { $q = "UPDATE ".TB_PREFIX."forum_topic set close = '$mode' where id = '$id'"; return mysql_query($q, $this->connection); } function DeleteCat($id) { $qs = "DELETE from ".TB_PREFIX."forum_cat where id = '$id'"; $q = "DELETE from ".TB_PREFIX."forum_topic where cat = '$id'"; mysql_query($qs,$this->connection); return mysql_query($q,$this->connection); } function DeleteTopic($id) { $qs = "DELETE from ".TB_PREFIX."forum_topic where id = '$id'"; $q = "DELETE from ".TB_PREFIX."forum_post where topic = '$id'"; mysql_query($qs,$this->connection); return mysql_query($q,$this->connection); } function DeletePost($id) { $q = "DELETE from ".TB_PREFIX."forum_post where id = '$id'"; return mysql_query($q,$this->connection); } function getAllianceName($id) { $q = "SELECT tag from ".TB_PREFIX."alidata where id = $id"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['tag']; } function getAlliance($id) { $q = "SELECT * from ".TB_PREFIX."alidata where id = $id"; $result = mysql_query($q, $this->connection); return mysql_fetch_assoc($result); } function setAlliName($aid,$name,$tag) { $q = "UPDATE ".TB_PREFIX."alidata set name = '$name', tag = '$tag' where id = $aid"; return mysql_query($q, $this->connection); } function isAllianceOwner($id) { $q = "SELECT * from ".TB_PREFIX."alidata where leader = '$id'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } function aExist($ref,$type) { $q = "SELECT $type FROM ".TB_PREFIX."alidata where $type = '$ref'"; $result = mysql_query($q, $this->connection); if(mysql_num_rows($result)) { return true; } else { return false; } } /***************************************** Function to create an alliance References: *****************************************/ function createAlliance($tag,$name,$uid,$max) { $q = "INSERT into ".TB_PREFIX."alidata values (0,'$name','$tag',$uid,0,0,0,'','',$max)"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } /***************************************** Function to insert an alliance new References: *****************************************/ function insertAlliNotice($aid,$notice) { $time = time(); $q = "INSERT into ".TB_PREFIX."ali_log values (0,'$aid','$notice',$time)"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } /***************************************** Function to read all alliance news References: *****************************************/ function readAlliNotice($aid) { $q = "SELECT * from ".TB_PREFIX."ali_log where aid = $aid ORDER BY date DESC"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } /***************************************** Function to create alliance permissions References: ID, notice, description *****************************************/ function createAlliPermissions($uid,$aid,$rank,$opt1,$opt2, $opt3,$opt4,$opt5,$opt6,$opt7,$opt8) { $q = "INSERT into ".TB_PREFIX."ali_permission values(0,'$uid','$aid','$rank','$opt1','$opt2','$o pt3','$opt4','$opt5','$opt6','$opt7','$opt8')"; mysql_query($q,$this->connection); return mysql_insert_id($this->connection); } /***************************************** Function to update alliance permissions References: *****************************************/ function deleteAlliPermissions($uid) { $q = "DELETE from ".TB_PREFIX."ali_permission where uid = '$uid'"; return mysql_query($q,$this->connection); } /***************************************** Function to update alliance permissions References: *****************************************/ function updateAlliPermissions($uid,$aid,$rank,$opt1,$opt2, $opt3,$opt4,$opt5,$opt6,$opt7) { $q = "UPDATE ".TB_PREFIX."ali_permission SET rank = '$rank', opt1 = '$opt1', opt2 = '$opt2', opt3 = '$opt3', opt4 = '$opt4', opt5 = '$opt5', opt6 = '$opt6', opt7 = '$opt7' where uid = $uid && alliance =$aid"; return mysql_query($q,$this->connection); } /***************************************** Function to read alliance permissions References: ID, notice, description *****************************************/ function getAlliPermissions($uid, $aid) { $q = "SELECT * FROM ".TB_PREFIX."ali_permission where uid = $uid && alliance = $aid"; $result = mysql_query($q,$this->connection); return mysql_fetch_assoc($result); } /***************************************** Function to update an alliance description and notice References: ID, notice, description *****************************************/ function submitAlliProfile($aid,$notice,$desc) { $q = "UPDATE ".TB_PREFIX."alidata SET `notice` = '$notice', `desc` = '$desc' where id = $aid"; return mysql_query($q,$this->connection); } function getUserAlliance($id) { $q = "SELECT ".TB_PREFIX."alidata.tag from ".TB_PREFIX."users join ".TB_PREFIX."alidata where ".TB_PREFIX."users.alliance = ".TB_PREFIX."alidata.id and ".TB_PREFIX."users.id = $id"; $result = mysql_query($q, $this->connection); $dbarray = mysql_fetch_array($result); if($dbarray['tag'] == "") { return "-"; } else { return $dbarray['tag']; } } 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"; } else { $q = "UPDATE ".TB_PREFIX."vdata set wood = wood + $wood, clay = clay + $clay, iron = iron + $iron, crop = crop + $crop where wref = $vid"; } return mysql_query($q, $this->connection); } function getFieldLevel($vid,$field) { $q = "SELECT f".$field." from ".TB_PREFIX."fdata where vref = $vid"; $result = mysql_query($q,$this->connection); return mysql_result($result,0); } function getVSumField($uid,$field) { $q = "SELECT sum(".$field.") FROM ".TB_PREFIX."vdata where owner = $uid"; $result = mysql_query($q, $this->connection); $row = mysql_fetch_row($result); return $row[0]; } function updateVillage($vid) { $time = time(); $q = "UPDATE ".TB_PREFIX."vdata set lastupdate = $time where wref = $vid"; return mysql_query($q, $this->connection); } function setVillageName($vid,$name) { $q = "UPDATE ".TB_PREFIX."vdata set name = '$name' where wref = $vid"; return mysql_query($q, $this->connection); } function modifyPop($vid,$pop,$mode) { if(!$mode) { $q = "UPDATE ".TB_PREFIX."vdata set pop = pop + $pop where wref = $vid"; } else { $q = "UPDATE ".TB_PREFIX."vdata set pop = pop - $pop where wref = $vid"; } return mysql_query($q, $this->connection); } function addCP($ref,$cp) { $q = "UPDATE ".TB_PREFIX."vdata set cp = cp + $cp where wref = $ref"; return mysql_query($q, $this->connection); } function getInvitation($uid) { $q = "SELECT * FROM ".TB_PREFIX."ali_invite where uid = $uid"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function getAliInvitations($aid) { $q = "SELECT * FROM ".TB_PREFIX."ali_invite where alliance = $aid && accept = 0"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function sendInvitation($uid, $alli, $sender) { $time = time(); $q = "INSERT INTO ".TB_PREFIX."ali_invite values (0,$uid,$alli,$sender,$time,0)"; return mysql_query($q,$this->connection) or die(mysql_error()); } function removeInvitation($id) { $q = "DELETE FROM ".TB_PREFIX."ali_invite where id = $id"; return mysql_query($q,$this->connection); } function sendMessage($client,$owner,$topic,$message,$send) { $time = time(); $q = "INSERT INTO ".TB_PREFIX."mdata values (0,$client,$owner,'$topic',\"$message\",0,0,$send, $time)"; return mysql_query($q, $this->connection); } function setArchived($id) { $q = "UPDATE ".TB_PREFIX."mdata set archived = 1 where id = $id"; return mysql_query($q, $this->connection); } function setNorm($id) { $q = "UPDATE ".TB_PREFIX."mdata set archived = 0 where id = $id"; return mysql_query($q, $this->connection); } /*************************** 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 target = $id and send = 0 and archived = 0 ORDER BY time DESC"; break; case 2: $q = "SELECT * FROM ".TB_PREFIX."mdata WHERE owner = $id and send = 1 and archived = 0 ORDER BY time DESC"; 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."mdata where target = $id and send = 0 and archived = 1"; 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 unarchiveNotice($id) { $q = "UPDATE ".TB_PREFIX."ndata set ntype = archive, archive = 0 where id = $id"; return mysql_query($q,$this->connection); } function archiveNotice($id) { $q = "update ".TB_PREFIX."ndata set archive = ntype, ntype = 9 where id = $id"; return mysql_query($q,$this->connection); } function removeNotice($id) { $q = "DELETE FROM ".TB_PREFIX."ndata where id = $id"; return mysql_query($q,$this->connection); } function noticeViewed($id) { $q = "UPDATE ".TB_PREFIX."ndata set viewed = 1 where id = $id"; return mysql_query($q,$this->connection); } function addNotice($uid,$type,$topic,$data) { $time = time(); $q = "INSERT INTO ".TB_PREFIX."ndata (id, uid, topic, ntype, data, time, viewed) values (0,'$uid','$topic',$type,'$data',$time,0)"; return mysql_query($q,$this->connection) or die(mysql_error()); } function getNotice($uid) { $q = "SELECT * FROM ".TB_PREFIX."ndata where uid = $uid ORDER BY time DESC"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function addBuilding($wid,$field,$type,$loop,$time) { $q = "INSERT into ".TB_PREFIX."bdata values (0,$wid,$field,$type,$loop,$time)"; return mysql_query($q,$this->connection); } function removeBuilding($d) { $q = "DELETE FROM ".TB_PREFIX."bdata where id = $d"; return mysql_query($q,$this->connection); } function getJobs($wid) { $q = "SELECT * FROM ".TB_PREFIX."bdata where wid = $wid order by ID ASC"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function getVillageByName($name) { $name = mysql_real_escape_string($name,$this->connection); $q = "SELECT wref FROM ".TB_PREFIX."vdata where name = '$name' limit 1"; $result = mysql_query($q,$this->connection); $dbarray = mysql_fetch_array($result); return $dbarray['wref']; } /*************************** Function to set accept flag on market References: id ***************************/ function setMarketAcc($id) { $q = "UPDATE ".TB_PREFIX."market 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,$mod e) { 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,$al liance,$merchant,$mode) { if(!$mode) { $q = "INSERT INTO ".TB_PREFIX."market values (0,$vid,$gtype,$gamt,$wtype,$wamt,0,$time,$allianc e,$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->getVillageField($vid,"owner"),"alliance",0); if(!$mode) { $q = "SELECT * FROM ".TB_PREFIX."market where vref = $vid and accept = 0"; } else { $q = "SELECT * FROM ".TB_PREFIX."market where vref != $vid and alliance = $alliance or vref != $vid and alliance = 0 and accept = 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 setMovementProc($moveid) { $q = "UPDATE ".TB_PREFIX."movement set proc = 1 where moveid = $moveid"; return mysql_query($q,$this->connection); } /*************************** 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 sort_type = 0"; $result = mysql_query($q, $this->connection); $row = mysql_fetch_row($result); $q2 = "SELECT sum(ref) from ".TB_PREFIX."movement where sort_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 and accept = 0"; $result3 = mysql_query($q3, $this->connection); $row3 = mysql_fetch_row($result3); return $row[0]+$row2[0]+$row3[0]; } /*************************** 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 and ".TB_PREFIX."movement.sort_type = 0"; break; case 2: $q = "SELECT * FROM ".TB_PREFIX."movement where ".TB_PREFIX."movement.".$where." = $village and proc = 0 and sort_type = 2"; break; case 3: $q = "SELECT * FROM ".TB_PREFIX."movement, ".TB_PREFIX."attacks where ".TB_PREFIX."movement.".$where." = $village and ".TB_PREFIX."movement.ref = ".TB_PREFIX."attacks.id and ".TB_PREFIX."movement.proc = 0 and ".TB_PREFIX."movement.sort_type = 3 ORDER BY endtime DESC"; break; case 4: $q = "SELECT * FROM ".TB_PREFIX."movement where ".TB_PREFIX."movement.".$where." = $village and sort_type = 4 and proc = 0"; break; case 5: $q = "SELECT * FROM ".TB_PREFIX."movement where ".TB_PREFIX."movement.".$where." = $village and sort_type = 5 and proc = 0"; break; } $result = mysql_query($q, $this->connection); $array = $this->mysql_fetch_all($result); return $array; } 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 addAttack($vid,$t1,$t2,$t3,$t4,$t5,$t6,$t7,$t8,$t9 ,$t10,$t11,$type) { $q = "INSERT INTO ".TB_PREFIX."attacks values (0,$vid,$t1,$t2,$t3,$t4,$t5,$t6,$t7,$t8,$t9,$t10,$ t11,$type)"; mysql_query($q, $this->connection); return mysql_insert_id($this->connection); } function modifyAttack($aid,$unit,$amt) { $unit = 't'.$unit; $q = "UPDATE ".TB_PREFIX."attacks set $unit = $unit - $amt where id = $aid"; return mysql_query($q,$this->connection); } function getRanking() { if(INCLUDE_ADMIN) { $q = "SELECT id,username,alliance,ap,dp FROM ".TB_PREFIX."users where access != ".BANNED; } else { $q = "SELECT id,username,alliance,ap,dp FROM ".TB_PREFIX."users where access = ".USER; } $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function getVRanking() { $q = "SELECT wref,name,owner,pop FROM ".TB_PREFIX."vdata where wref != ''"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function getARanking() { $q = "SELECT id,name,tag FROM ".TB_PREFIX."alidata where id != ''"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function getAllMember($aid) { $q = "SELECT * FROM ".TB_PREFIX."users left JOIN ".TB_PREFIX."vdata ON ".TB_PREFIX."vdata.owner = ".TB_PREFIX."users.id where ".TB_PREFIX."users.alliance = '$aid' order by ".TB_PREFIX."vdata.pop desc"; $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } function addUnits($vid) { $q = "INSERT into ".TB_PREFIX."units (vref) values ($vid)"; return mysql_query($q, $this->connection); } function getUnit($vid) { $q = "SELECT * from ".TB_PREFIX."units where vref = $vid"; $result = mysql_query($q,$this->connection); return mysql_fetch_assoc($result); } function addTech($vid) { $q = "INSERT into ".TB_PREFIX."tdata (vref) values ($vid)"; return mysql_query($q, $this->connection); } function addABTech($vid) { $q = "INSERT into ".TB_PREFIX."abdata (vref) values ($vid)"; return mysql_query($q, $this->connection); } function getABTech($vid) { $q = "SELECT * FROM ".TB_PREFIX."abdata where vref = $vid"; $result = mysql_query($q,$this->connection); return mysql_fetch_assoc($result); } function addResearch($vid,$tech,$time) { $q = "INSERT into ".TB_PREFIX."research values (0,$vid,'$tech',$time)"; return mysql_query($q,$this->connection); } function getResearching($vid) { $q = "SELECT * FRom ".TB_PREFIX."research where vref = $vid"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function getTech($vid) { $q = "SELECT * from ".TB_PREFIX."tdata where vref = $vid"; $result = mysql_query($q, $this->connection); return mysql_fetch_assoc($result); } 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 trainUnit($vid,$unit,$amt,$pop,$each,$time,$mode) { if(!$mode) { $q = "INSERT INTO ".TB_PREFIX."training values (0,$vid,$unit,$amt,$pop,$time,1,$time)"; } else { $q = "DELETe FROM ".TB_PREFIX."training where id = $vid"; } return mysql_query($q,$this->connection); } function updateTraining($id,$trained) { $time = time(); $q = "UPDATE ".TB_PREFIX."training set amt = amt - $trained, timestamp = $time where id = $id"; return mysql_query($q,$this->connection); } 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 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 addEnforce($t1,$t2,$t3,$t4,$t5,$t6,$t7,$t8,$t9,$t1 0,$from,$to) { $q = "INSERT INTO ".TB_PREFIX."enforcement values (0,$t1,$t2,$t3,$t4,$t5,$t6,$t7,$t8,$t9,$t10,$from, $to)"; mysql_query($q, $this->connection); return mysql_insert_id($this->connection); } function getEnforceArray($id) { $q = "SELECT * from ".TB_PREFIX."enforcement where id = $id"; $result = mysql_query($q, $this->connection); return mysql_fetch_assoc($result); } function modifyCommence($id) { $time = time(); $q = "UPDATE ".TB_PREFIX."training set commence = $time"; return mysql_query($q,$this->connection); } function getTrainingList() { $q = "SELECT * FROM ".TB_PREFIX."training where vref != ''"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function getNeedDelete() { $time = time(); $q = "SELETE uid FROM ".TB_PREFIX."deleting where timestampe < $time"; $result = mysql_query($q,$this->connection); return $this->mysql_fetch_all($result); } function countUser() { $q = "SELECT count(id) FROM ".TB_PREFIX."users where id != 0"; $result = mysql_query($q,$this->connection); $row = mysql_fetch_row($result); return $row[0]; } function countAlli() { $q = "SELECT count(id) FROM ".TB_PREFIX."alidata where id != 0"; $result = mysql_query($q,$this->connection); $row = mysql_fetch_row($result); return $row[0]; } /*************************** Function to process MYSQLi->fetch_all (Only exist in MYSQL) References: Result ***************************/ function mysql_fetch_all($result) { $all = array(); if($result) { while ($row = mysql_fetch_assoc($result)){ $all[] = $row; } return $all; } } function query_return($q) { $result = mysql_query($q, $this->connection); return $this->mysql_fetch_all($result); } /*************************** Function to do free query References: Query ***************************/ function query($query) { return mysql_query($query, $this->connection); } function RemoveXSS($val) { // remove all non-printable characters. CR(0a) and LF(0b) and TAB(9) are allowed // this prevents some character re-spacing such as <java\0script> // note that you have to handle splits with \n, \r, and \t later since they *are* allowed in some inputs $val = preg_replace('/([\x00-\x08,\x0b-\x0c,\x0e-\x19])/', '', $val); $val = htmlspecialchars($val); // straight replacements, the user should never need these since they're normal characters // this prevents like <IMG SRC=&#X40&#X61&#X76&#X61&#X73&#X63&#X72&#X69&#X70& #X74&#X3A &#X61&#X6C&#X65&#X72&#X74&#X28&#X27&#X58&#X53&#X53 &#X27&#X29> $search = '[a-zA-Z0-9]'; $search .= '[email protected]#$%^&*()'; $search .= '~`";:?+/={}[]-\\_|\''; for ($i = 0; $i < strlen($search); $i++) { // ;? matches the ;, which is optional // 0{0,7} matches any padded zeros, which are optional and go up to 8 chars // &#x0040 @ search for the hex values $val = preg_replace('/(&#[xX]0{0,8}'.dechex(ord($search[$i])).';?)/i', $search[$i], $val); // with a ; // &#00064 @ 0{0,7} matches '0' zero to seven times $val = preg_replace('/(&#0{0,8}'.ord($search[$i]).';?)/', $search[$i], $val); // with a ; } // now the only remaining whitespace attacks are \t, \n, and \r $ra1 = Array('javascript', 'vbscript', 'expression', 'applet', 'meta', 'xml', 'blink', 'link', 'style', 'script', 'embed', 'object', 'iframe', 'frame', 'frameset', 'ilayer', 'layer', 'bgsound', 'title', 'base'); $ra2 = Array('onabort', 'onactivate', 'onafterprint', 'onafterupdate', 'onbeforeactivate', 'onbeforecopy', 'onbeforecut', 'onbeforedeactivate', 'onbeforeeditfocus', 'onbeforepaste', 'onbeforeprint', 'onbeforeunload', 'onbeforeupdate', 'onblur', 'onbounce', 'oncellchange', 'onchange', 'onclick', 'oncontextmenu', 'oncontrolselect', 'oncopy', 'oncut', 'ondataavailable', 'ondatasetchanged', 'ondatasetcomplete', 'ondblclick', 'ondeactivate', 'ondrag', 'ondragend', 'ondragenter', 'ondragleave', 'ondragover', 'ondragstart', 'ondrop', 'onerror', 'onerrorupdate', 'onfilterchange', 'onfinish', 'onfocus', 'onfocusin', 'onfocusout', 'onhelp', 'onkeydown', 'onkeypress', 'onkeyup', 'onlayoutcomplete', 'onload', 'onlosecapture', 'onmousedown', 'onmouseenter', 'onmouseleave', 'onmousemove', 'onmouseout', 'onmouseover', 'onmouseup', 'onmousewheel', 'onmove', 'onmoveend', 'onmovestart', 'onpaste', 'onpropertychange', 'onreadystatechange', 'onreset', 'onresize', 'onresizeend', 'onresizestart', 'onrowenter', 'onrowexit', 'onrowsdelete', 'onrowsinserted', 'onscroll', 'onselect', 'onselectionchange', 'onselectstart', 'onstart', 'onstop', 'onsubmit', 'onunload'); $ra = array_merge($ra1, $ra2); $found = true; // keep replacing as long as the previous round replaced something while ($found) { $val_before = $val; for ($i = 0; $i < sizeof($ra); $i++) { $pattern = '/'; for ($j = 0; $j < strlen($ra[$i]); $j++) { if ($j > 0) { $pattern .= '('; $pattern .= '(&#[xX]0{0,8}([9ab])'; $pattern .= '|'; $pattern .= '|(&#0{0,8}([9|10|13])'; $pattern .= ')*'; } $pattern .= $ra[$i][$j]; } $pattern .= '/i'; $replacement = substr($ra[$i], 0, 2).'<x>'.substr($ra[$i], 2); // add in <> to nerf the tag $val = preg_replace($pattern, $replacement, $val); // filter out the hex tags if ($val_before == $val) { // no replacements were made, so exit the loop $found = false; } } } return $val; } }; $database = new MYSQL_DB; ?> e meu banco de dados tem os seguintes itens: http://img253.imageshack.us/f/helpsss.png/ (SS para facilitar, lembrando que na hora de instalar o próprio instalador informou que o sufixo das tabelas seria essa S1_ ) E esse é meu problema.... o que faço para corrigir?? Apanhei em uns foruns gringos até perder o caminho de casa srsrsrs o máximo que consegui assimilar foi as seguintes respostas de uns usuarios: USUARIO GRINGO QUE ME RESPONDEU: Look for db_MYSQL.php in GameEngine\Database\ folder line: 181 u got this? : Code: Select all function updateActiveUser($username,$time) { $q = "REPLACE into ".TB_PREFIX."active values ('$username',$time)"; $q2 = "UPDATE ".TB_PREFIX."users set timestamp = $time where username = '$username'"; $exec1 = mysql_query($q, $this->connection); $exec2 = mysql_query($q2, $this->connection); if($exec1 && $exec2) { return true; } else { return false; } } Got table active in your database? OU do you see $database = new db..... ? at the end of file ? Estou perdido amigos me ajudem!! E me desculpem o incoviniente
×
×
  • Criar Novo...