(Resolvido)[Website] Erro ao logar na conta

[Hadggar 130]

OPa galera blz? abri um server a poco tempo, preucurei ,preucure nem um site funcionava, ai fui é achei esse http://www.tibiaking.com/forum/topic/7642-nicaw-acc-0707/ so que quando o player cria conta normal aparece, esse erro:

Fatal error: Uncaught exception 'DatabaseQueryException'
Message: Error #1054:Unknown column 'guilds.owner_id' in 'where clause'
SQL query: SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = 2
File: sql.php on line: 94
Script was terminated because something unexpected happened. You can report this, if you think it's a bug.

Debug Backtrace:
Array
(
    [0] => Array
        (
            [function] => ExceptionHandler
            [class] => AAC
            [type] => ::
            [args] => Array
                (
                    [0] => DatabaseQueryException Object
                        (
                            [query_str:DatabaseQueryException:private] => SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = 2
                            [help_id:aacException:private] => 
                            [message:protected] => Error #1054:Unknown column 'guilds.owner_id' in 'where clause'
                            [string:Exception:private] => 
                            [code:protected] => 0
                            [file:protected] => C:\xammp\xampp\htdocs\class\sql.php
                            [line:protected] => 94
                            [trace:Exception:private] => Array
                                (
                                    [0] => Array
                                        (
                                            [file] => C:\xammp\xampp\htdocs\class\account.php
                                            [line] => 36
                                            [function] => myQuery
                                            [class] => SQL
                                            [type] => ->
                                            [args] => Array
                                                (
                                                    [0] => SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = 2
                                                )

                                        )

                                    [1] => Array
                                        (
                                            [file] => C:\xammp\xampp\htdocs\class\account.php
                                            [line] => 133
                                            [function] => load_guilds
                                            [class] => Account
                                            [type] => ->
                                            [args] => Array
                                                (
                                                )

                                        )

                                    [2] => Array
                                        (
                                            [file] => C:\xammp\xampp\htdocs\account.php
                                            [line] => 61
                                            [function] => __get
                                            [class] => Account
                                            [type] => ->
                                            [args] => Array
                                                (
                                                    [0] => guilds
                                                )

                                        )

                                )

                            [previous:Exception:private] => 
                        )

                )

        )

)

Ajuda pf? rep+

@UP

@UP

@UP

[roriscrave 61]

tenta usar outro site, so esse que pegou?

[Hadggar 130]

infelizmente so esse que funfo, testei todos, sempre dava um erro diferente, se você achar um que e compativel com o NARUTO ROBINHOOD 8.54 PODE DESPONIBILIZAR

@UP

@UP

@UP

[luanluciano93 1994]

O próprio erro diz ... 

 

Unknown column 'guilds.owner_id

 

[Hadggar 130]

é pra mim remover?

conifgura pra mim? é que n itendo mt pf?

aki a script :

<?php
/*
     Copyright (C) 2007 - 2009  Nicaw

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License along
    with this program; if not, write to the Free Software Foundation, Inc.,
    51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
class Account {
    private $attrs, $sql, $guilds, $players;

    public function __construct() {
        $this->sql = AAC::$SQL;
    }

    public function find($name) {
        if (empty($name)) throw new AccountNotFoundException();
        $acc = $this->sql->myRetrieve('accounts', array('name' => $name));
        if ($acc === false) throw new AccountNotFoundException();
        $this->load($acc['id']);
        return true;
    }

    public function load_guilds() {
        if(empty($this->attrs['accno'])) throw new AccountNotLoadedException();
        $this->sql->myQuery('SELECT guilds.id, guilds.name FROM guilds, accounts, players WHERE players.id = guilds.owner_id AND players.account_id = accounts.id AND accounts.id = '.$this->sql->quote($this->attrs['accno']));
        while ($a = $this->sql->fetch_array()) {
            $this->guilds[] = array('id' => $a['id'], 'name' => $a['name']);
        }
        return true;
    }

    public function load_players() {
        if(empty($this->attrs['accno'])) throw new AccountNotLoadedException();
        $this->sql->myQuery('SELECT players.id, players.name FROM players WHERE (`account_id`='.$this->sql->quote($this->attrs['accno']).')');
        while ($a = $this->sql->fetch_array()) {
            $this->players[] = array('name' => $a['name'], 'id' => $a['id']);
        }
        return true;
    }

    public function load($id) {
        if (!is_numeric($id)) throw new AccountNotFoundException();
        //load attributes from database
        $acc = $this->sql->myRetrieve('accounts', array('id' => $id));
        $nicaw_acc = $this->sql->myRetrieve('nicaw_accounts', array('account_id' => $id));
        if ($acc === false) throw new AccountNotFoundException();

        //arranging attributes, ones on the left will be used all over the aac
        $this->attrs['accno'] = (int) $acc['id'];
        $this->attrs['blocked'] = (bool) $acc['blocked'];
        $this->attrs['name'] = (string) $acc['name'];
        $this->attrs['password'] = (string) $acc['password'];
        $this->attrs['email'] = (string) $acc['email'];
        $this->attrs['rlname'] = $nicaw_acc['rlname'];
        $this->attrs['location'] = $nicaw_acc['location'];
        $this->attrs['comment'] = $nicaw_acc['comment'];
        $this->attrs['recovery_key'] = $nicaw_acc['recovery_key'];
        $this->attrs['reveal_characters'] = (bool) $nicaw_acc['reveal_characters'];
        if (isset($acc['premdays']) && $acc['premdays'] > 0) $this->attrs['premend'] = $acc['premdays']*24*3600 + time();
        elseif (isset($acc['premend']) && $acc['premend'] > 0) $this->attrs['premend'] = $acc['premend'];
        
        return true;
    }

    public function save() {
        $acc['id'] = $this->attrs['accno'];
        $acc['name'] = $this->attrs['name'];
        $acc['password'] = $this->attrs['password'];
        $acc['email'] = $this->attrs['email'];

        $this->sql->myUpdate('accounts',$acc, array('id' => $this->attrs['accno']));

        $nicaw_acc['account_id'] = $this->attrs['accno'];
        $nicaw_acc['rlname'] = $this->attrs['rlname'];
        $nicaw_acc['location'] = $this->attrs['location'];
        $nicaw_acc['comment'] = $this->attrs['comment'];
        $nicaw_acc['recovery_key'] = $this->attrs['recovery_key'];
        $nicaw_acc['reveal_characters'] = $this->attrs['reveal_characters'];

        $this->sql->myReplace('nicaw_accounts',$nicaw_acc);

        return true;
    }

    public function hasPlayer($pid) {
        $players = $this->__get('players');
        foreach($players as $p) {
            if ($p['id'] == $pid) {
                return true;
            }
        }
        return false;
    }

    static public function Create($name, $password, $email, $rlname = '', $location = '') {
        $SQL = AAC::$SQL;

        unset($d);
        $d['name'] = $name;
        $d['password'] = Account::encodePassword($password);
        $d['email'] = $email;
        $SQL->myInsert('accounts',$d);
        $aid = $SQL->insert_id();

        unset($d);
        $d['account_id'] = $aid;
        $d['rlname'] = $rlname;
        $d['location'] = $location;
        $SQL->myInsert('nicaw_accounts',$d);

        $account = new Account();
        $account->load($aid);
        return $account;
    }

    public function __get($attr) {
        if(empty($this->attrs['accno']))
            throw new ClassException('Attempt to get attribute of account that is not loaded.');
        if($attr == 'attrs') {
            return $this->attrs;
        }elseif($attr == 'guilds') {
            if(empty($this->guilds)) $this->load_guilds();
            return $this->guilds;
        }elseif($attr == 'players') {
            if(empty($this->players)) $this->load_players();
            return $this->players;
        }else {
            throw new ClassException('Undefined property: '.$attr);
        }
    }

    public function setAttr($attr,$value) {
        $this->attrs[$attr] = $value;
    }

    public function setPassword($pass) {
        if(empty($pass)) return false;
        $this->attrs['password'] = Account::encodePassword($pass);
        return true;
    }

    static private function encodePassword($pass) {global $cfg;
        $pass = $pass.$cfg['password_salt'];
        if ($cfg['password_type'] == 'md5')
            $pass = md5($pass);
        elseif ($cfg['password_type'] == 'sha1')
            $pass = sha1($pass);
        return $pass;
    }

    public function checkPassword($pass) {global $cfg;
        $pass = $pass.$cfg['password_salt'];
        if ($cfg['password_type'] == 'md5') {
            $pass = md5($pass);
        }elseif ($cfg['password_type'] == 'sha1') {
            $pass = sha1($pass);
        }elseif ($cfg['password_type'] == 'plain') {
        }else throw new ClassException('Unknow password encoding $cfg[\'password_type\'].');
        return $this->attrs['password'] == (string)$pass && !empty($pass);
    }

    static public function existsName($name) {
        try {
            AAC::$SQL->myQuery('SELECT * FROM `accounts` WHERE `name` = '.AAC::$SQL->quote($name));
        } catch(DatabaseQueryException $e) {
            throw new DatabaseException('Account::existsName() failed. If your server doesn\'t support account names pelase use AAC release v3.20');
        }
        if (AAC::$SQL->num_rows() > 0) return true;
        return false;
    }

    public function logAction($action) {
        $this->sql->myQuery('INSERT INTO `nicaw_account_logs` (id, ip, account_id, date, action) VALUES(NULL, INET_ATON('.$this->sql->quote($_SERVER['REMOTE_ADDR']).'), '.$this->sql->quote($this->attrs['accno']).', UNIX_TIMESTAMP(NOW()), '.$this->sql->quote($action).')');
    }

    public function removeRecoveryKey() {
        $this->attrs['recovery_key'] = NULL;
    }

    public function addRecoveryKey() {
        $this->attrs['recovery_key'] = substr(str_shuffle(md5(mt_rand()).md5(time())), 0, 32);
        $this->logAction('Recovery key added');
        return $this->attrs['recovery_key'];
    }

    public function checkRecoveryKey($key) {
        return $this->attrs['recovery_key'] === $key && !empty($key);
    }

    public function vote($option) {
        $this->sql->myQuery('INSERT INTO `nicaw_poll_votes` (option_id, ip, account_id) VALUES('.$this->sql->quote($option).', INET_ATON('.$this->sql->quote($_SERVER['REMOTE_ADDR']).'), '.$this->sql->quote($this->attrs['accno']).')');
    }

    public function getMaxLevel() {
        $this->sql->myQuery('SELECT MAX(level) AS maxlevel FROM `players` WHERE `account_id` = '.$this->sql->quote($this->attrs['accno']));
        $row = $this->sql->fetch_array();
        return (int) $row['maxlevel'];
    }

    public function canVote($option) {
        $query = 'SELECT nicaw_polls.id FROM nicaw_polls, nicaw_poll_options
WHERE nicaw_polls.id = nicaw_poll_options.poll_id
AND nicaw_poll_options.id = '.$this->sql->quote($option).'
AND '.$this->sql->quote($this->getMaxLevel()).' > minlevel
AND nicaw_polls.startdate < UNIX_TIMESTAMP(NOW())
AND nicaw_polls.enddate > UNIX_TIMESTAMP(NOW())';
        $this->sql->myQuery($query);
        if ($this->sql->num_rows() == 0) return false;
        if ($this->sql->num_rows() > 1) throw new DatabaseException('Unexpected SQL answer.');
        $a = $this->sql->fetch_array();
        $poll_id = $a['id'];
        $query = 'SELECT * FROM nicaw_poll_votes, nicaw_poll_options
WHERE nicaw_poll_options.poll_id = '.$this->sql->quote($poll_id).'
AND nicaw_poll_options.id = nicaw_poll_votes.option_id
AND (account_id = '.$this->sql->quote($this->attrs['accno']).' OR ip = INET_ATON('.$this->sql->quote($_SERVER['REMOTE_ADDR']).')
)';
        $this->sql->myQuery($query);
        if ($this->sql->num_rows() == 0) return true;
        elseif ($this->sql->num_rows() == 1) return false;
        else throw new DatabaseException('Unexpected SQL answer.');
    }
}
?>

[luanluciano93 1994]

Quando for colocar algum script grande coloque-o em spoiler por favor .. 

ALTER TABLE `guilds` CHANGE COLUMN `ownerid` `owner_id` INT UNSIGNED NOT NULL;

[Hadggar 130]

VLW FUNFO ! RETIREI A LINHA E FOI