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

codigofonte

Admininistrador
  • Total de itens

    333
  • Registro em

  • Última visita

Posts postados por codigofonte


  1. Verifica se nos seus arquivos .php existe algum espaço ou enter no final do código. Este erro acontece por que o conteúdo da página já foi preenchida e o php não consegue alterar o output, que já foi mudado.


  2. Olá,

    Você deve pensar em trabalhar com window.hash e verificar se mudou. Por exemplo:

    Imaginemos que você criou uma página e ao clicar no link ele vai processar o ajax, a partir daí, você deverá mudar o hash da url:

    http://localhost/teste/#novohash

    Ao acessar outra página, sempre mude o hash

    http://localhost/teste/#novapagina

    Assim, quando você voltar pelo navegador, ele vai voltar ao hash anterior. Para capturar quando o hash muda, use este plugin jquery:

    http://benalman.com/projects/jquery-hashchange-plugin/


  3. Olá Flávio,

    Realmente eu tenho notado um grande número de perguntas sem respostas. Mas você sabe que o fórum é um local público para que todas as pessoas troquem idéias, dúvidas e experiências. Nós apenas mantemos o serviço online e em perfeito funcionamento, além de fazer as devidas manutenções (apagar posts de SPAM, etc).

    Estou desenvolvendo a nova versão do portal CódigoFonte.net, o que está me consumindo um grande tempo, mas estou sempre de olho no que as pessoas postam aqui, não se preocupe ;-)

    De qualquer forma, vamos trabalhar junto para tornar o fórum um canal bastante movimentado. Vou começar com uma campanha no site para dar mais visitas pra ele ;-)

    Abraço.


  4. antes de $acao, faça assim:

    print_r($_POST);
    
    
    exit;
    veja o que imprime. se não imprimir código, o problema tá no seu formulário.
    E awe Kinzinho! eu acabei de perceber que o erro é que a variavel ID não está recebendo codigo, onde será que estou errando ??
    <?php  include ("conexao/conexao_fb.php");
    
    
    $acao 	= $_POST["acao"];
    
    $id		= $_POST["codigo"];
    
    
    
    	$nome  	= $_POST["nome"];
    
    	$endereco = $_POST["endereco"];
    
    	$cidade   = $_POST["cidade"];
    
    	$uf    	= $_POST["uf"]; ?>
    
    
    <?php 
    
    if ($acao=="Inserir")
    
    {
    
    $sql = ("INSERT INTO CADASTRO
    
    
    	(nome, endereco, cidade, uf) 
    
    	VALUES 
    
    	('$nome',
    
         '$endereco',
    
         '$cidade',
    
         '$uf')");
    
    
    $q = ibase_prepare($sql);
    
    
    $r= ibase_execute($query) or die ("Desculpa, n&atilde;o fui capaz de adicionar os dados.");
    
    
    	print "<script type = 'text/javascript'> location.href = 'index.php?pagina=3'</script>";
    
    }
    
    
    if ($acao=="Alterar")
    
    {
    
    $sql =("UPDATE CADASTRO SET
    
    
    	nome ='$nome',
    
    	endereco = '$endereco',
    
    	cidade='$cidade',
    
    	uf='$uf' WHERE CODIGO='$id' ");
    
    echo $sql;
    
    echo "<br>";
    
    $q =ibase_prepare($sql);
    
    $r = ibase_execute($qry) or die ("Desculpa, n&atilde;o fui capaz de modificar os dados.");
    
    
    
    }
    
    
    if ($acao=="Excluir")
    
    {
    
     $sql=("DELETE FROM CADASTRO WHERE CODIGO=$id");
    
    echo $sql;
    
    $q = ibase_prepare($sql);
    
    $r = ibase_execute($qry) or die ("Desculpa, n&atilde;o fui capaz de apagar os dados.");
    
    	print "<script type = 'text/javascript'> location.href = 'index.php?pagina=3'</script>";
    
    }
    
    ?>
    
    
    


  5. já tentou usar "float: left" ao invés de display: inline eu seus ul li?

    Boa tarde.

    Estou desenvolvendo um menu horizontal em CSS, ficou muito bom, mas qdo se tem vários itens ele não permanece na mesma linha.

    O CSS é este:

    #menucontainer
    
    {
    
    	margin:0 auto;
    
    	width: 100%;
    
    	height: 31px;
    
        background-image: url('Images/back_menu_vermelho.jpg');
    
    	background-repeat: repeat-x;
    
        _height: 1px; /* only IE6 applies CSS properties starting with an underscore */
    
    }
    
    /* MENU */
    
    #menu {	
    
    	width:900px;
    
    	margin: 0 auto;
    
    	padding-top:5px;
    
    	text-align: center;
    
    }
    
    
    #menu ul li {
    
    	display: inline;
    
    }
    
    #menu ul li a {
    
    	color: #FFFFFF;
    
    	padding: 5px 15px;
    
    	text-decoration: none;
    
    	background-image: url('Images/separador.png');
    
    	background-repeat: no-repeat;	
    
    	background-position: right;	
    
    }
    
    #menu ul li a:hover {
    
    	color: #000000;
    
    	font-weight: bold;	
    
    }
    
    

    E o HTML é este:

    <div id="menucontainer">
    <div id="menu">
    <ul id="Ul1">

    <%//Cliente
    if (Session["tipoUsuarioSac"].Equals('C') || Session["tipoUsuarioSac"].Equals('S')){ %>
    <li><%= Html.ActionLink("Abrir Chamado", "Index", "ClienteAtendimentos")%></li>

    <% }
    //Gerente
    if (Session["tipoUsuarioSac"].Equals('G') || Session["tipoUsuarioSac"].Equals('S')){%>
    <li><%= Html.ActionLink("Chamados sem Analista", "Index", "AcompanhamentoAtendimentos")%></li>
    <li><%= Html.ActionLink("Fila líderes", "filaDosLideres", "AcompanhamentoAtendimentos")%></li>
    <% }
    //Líder
    if (Session["tipoUsuarioSac"].Equals('L') || Session["tipoUsuarioSac"].Equals('S')){%>
    <li><%= Html.ActionLink("Fila Atendentes", "FilaDosAtendentes", "LiderAtendimentos")%></li>
    <li><%= Html.ActionLink("Atender Chamados", "Index", "Atendentes")%></li>
    <% }
    //Líder / Gerente
    if (Session["tipoUsuarioSac"].Equals('L') || Session["tipoUsuarioSac"].Equals('S') || Session["tipoUsuarioSac"].Equals('G')){%>
    <li><%= Html.ActionLink("Encaminhar Chamados", "Index", "LiderAtendimentos")%></li>
    <%}

    //Atendente
    if (Session["tipoUsuarioSac"].Equals('A')){%>
    <li><%= Html.ActionLink("Atender Chamados", "Index", "Atendentes")%></li>
    <% }
    if (Session["tipoUsuarioSac"].Equals('C')){%>
    <li><%= Html.ActionLink("Consultar Chamados", "Index", "PesquisarAtendimentos")%></li>
    <% }
    else{%>
    <li><%= Html.ActionLink("Consultar Chamados", "IndexEmpresa", "PesquisarAtendimentos")%></li>
    <%}%>

    </ul>
    </div>
    </div>[/html]

    Se alguém tiver uma ideia, de como faço isso, será de grande ajuda. Obrigado.


  6. você está chamando a função utilizando a variável de instância?

    ex.

    $database = new MYSQL_DB();

    $database->updateActiveUser("tal", "y");

    ?

    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/spe...ll_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.images.../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


  7. Olá,

    Eu nunca vi num for se fazer uma multiplicação, creio que ele sirva apenas para incremento. Veja:

    for ($a=0; $a<=100; $a++){
    
    
    if(($a % 3) == 0) {
    
    
    echo "<i> Os m&uacute;tiplos de 3 s&atilde;o :</i> <b>$a</b> <br>";
    
    
    }
    
    
    }

    E segui o raciocínio de seu professor, utilizando o "mod" (%) para saber se o resultado é igual a "0", ou seja, a variável $i é múltipla de 3.

    Teste ;-)

    Pessoal estou em curso de php, e durante a aula o professor pasou o seguinte exercicio.

    crie um programa que mostre em tela os números múltiplos de três, dentro do intervalo de 4 a 100;

    Criei o formulario em html e este arquivo PHP, porém ele entra em loop, dizendo que a linha 23 ( onde esta comando for está indefinido )

    --> arquivo php <--

    <html>

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

    <title> Exerc&iacute;cio 1 </title>

    </head>

    <body>

    <?php

    $recA = $_POST["edtPri"];

    for ($recA=12; $a<=100; $a*3){

    echo "<i> Os m&uacute;tiplos de 3 s&atilde;o :</i> <b>$recA</b> <br>";

    }

    ?>

    </body>

    </html>

    o professor me passou oura forma de fazer pelo usando o "%" calculando pelo resto, que não me satisfez, gostaria de saber prque do loop e se seria desta a melhor forma de criar o programa.


  8. Olá Peterson,

    na verdade faltou mais uma linha de código:

    $dados = mysql_fetch_array($data1);

    print_r($dados);

    veja agora ;-)

    Pessoal sou novo aqui, bom estou com um problema eu tenho uma variavel e nessa variável eu quero jogar o resultado de um select

    $data1 = mysql_query("SELECT ENT_DATAENTRADA FROM RECEPCAO WHERE ENT_CODAPARTAMENTO = '$apto'"); 
    dei um
    echo "$data1";
    pra ver o resultado por que nao estava dando certo ele me retorno
    Resource id #5 ou outro numero

    alguem poderia me ajudar ?

    desde já agradeço


  9. tipo, no segundo while (dentro do primeiro) vc tem que fazer um select e filtrar as fotos daquele album atual, por exemplo:

    $sqlphoto = "SELECT * FROM gal_images where album_id ='". $linhaalbum['codigo_galeria'] ."' LIMIT 5";

    sacou?


  10. fiz uns testes aqui e acho que os teus campos estão no formato inteiro, por isto que a concatenação padrão não funciona.

    Mas que tal forçar? ehehehe

    veja o código a seguir:

    SELECT str_to_date(concat(d,"/",m,"/",a), "%d/%m/%Y") as data FROM `teste`
    where str_to_date(concat(d,"/",m,"/",a), "%d/%m/%Y") < curdate()

    pelos meus testes aqui deu certo.

    a única diferença é utilizar a função "concat" que recebe as strings que desejamos juntar. depois é só converter a string pra data e pronto. campo de data agora funcionando.

×
×
  • Criar Novo...