Erro ao criar conta

[Gaant 230]

Ao criar conta está dando este erro

 

Meu config.php

/*These configs are neccessary in order to make Modern AAC work.*/

/*URL of website including http:// and without slash at the end! */
$config['website'] = $config['website'] = 'http://'.$_SERVER['HTTP_HOST'] . '/'.trim(dirname($_SERVER['SCRIPT_NAME']), '/.\\');


/*Database information*/
$config['database']['host'] = "127.0.0.1";
$config['database']['login'] = "root";
$config['database']['password'] = "";
$config['database']['database'] = "pokijap";

/*Name of server*/
$config['server_name'] = "Nome do server";

/*End of most important configs*/

/*List of cities, declare by using city ID and name eg. 2=>"Eternia City" etc.*/
$config['cities'] = array(1=>'Saffron');


/*List of vocation available to choose when creating new character*/
$config['vocations'] = array(1=>"Treinador de Pokémon");


/*List of vocation that exists on server*/
$config['server_vocations'] = array(1=>"Pokemon Trainer");

/*List of promotions, the key is vocation without promotion*/
$config['promotions'] = array(1=>"Treinador de Pokémon");

/*Resitricted names*/
$config['restricted_names'] = array("god", "gamemaster", "admin", "Pokemon Trainer Sample");

/*Names with any of this value cannot be created*/
$config['invalidNameTags'] = array("god", "gm", "cm", "gamemaster", "hoster", "admin");


/*ID and names of worlds*/
$config['worlds'][0] = "PokeJap";

// Enable multiworld by uncommenting this
//$config['worlds'][1] = "Second World";

/* Addresses of each server */
$config['servers'][0] = array('address'=>'25.13.134.75', 'port'=>7171, 'vapusid'=>'

Notice: Undefined variable: vapusID in C:\xampp\htdocs\install\index.php on line 143

');

// Enable multiworld by uncommenting this
//$config['servers'][1] = array('address'=>'25.13.134.75', 'port'=>7173, 'vapusid' => 'XXX');

/*Groups that exists on server*/
$config['groups'] = array(0=>"Player", 1=>"Player", 2=>"Tutor", 3=>"Senior Tutor", 4=>"Gamemaster", 5=>"Community Manager", 6=>"God");


/*Names of vocations as in database as samples. First key is world id and second vocation id.*/
$config['newchar_vocations'][0][1] = "Pokemon Trainer Sample";

/*Don't show chaarcters with group id higher than*/
$config['players_group_id_block'] = 3;

// Sistema automatico Pagseguro by tatu_hunter
// Seu email cadastrado no pagseguro
$config['pagseguro']['email'] = '[email protected]';
// Nome do Produto
$config['pagseguro']['produtoNome'] = 'Pontos VIP';
// Valor unitario do produto ou seja valor de cada ponto
// Exemplo de valores
// 100 = R$ 1,00
// 235 = R$ 2,35
// 4254 = R$ 42,54
$config['pagseguro']['produtoValor'] = '100';
// Token gerado no painel do pagseguro --token você pega após confirmar que tem mais de 18 anos para receber as donations--
$config['pagseguro']['token'] = 'EFEB3B4CA8914CB3963C3695A6947965';

/*Min. level to create guild*/
$config['levelToCreateGuild'] = 50;


/*Limit of latest deaths*/
$config['latestdeathlimit'] = 20;

/*Limit news per page*/
$config['newsLimit'] = 10;

/*Limit comments per page*/
$config['commentLimit'] = 10;

/*Template that should be used on website*/
$config['layout'] = "pokemon";

/*Title of a website*/
$config['title'] = "PokeJap";


/*Premdays given when creating new account.*/
$config['premDays'] = 1;


/*Positions to start when creating character*/
$startPos['x'] = 1032;
$startPos['y'] = 1026;
$startPos['z'] = 5;


/*Trigger password for scaffolding system.*/
$config['scaffolding_trigger'] = "password";

/*Minimum page access for admin priviliges*/
$config['adminAccess'] = 5;

/*Max threads per page*/
$config['threadsLimit'] = 10;

/*Max posts per page in a thread*/
$config['postsLimit'] = 10;

/*Time between posts*/
$config['timeBetweenPosts'] = 30;

/*Limit of submissions per page in bug tracker*/
$config['bugtrackerPageLimit'] = 10;

/*Limit of houses on listing page*/
$config['housesLimit'] = 10;

/*Level to buy house*/
$config['houseLevel'] = 50;

/*Lenght of housing auction in seconds*/
$config['houseAuctionTime'] = 604800;

/*Default timezone*/
$config['timezone'] = "Europe/London";

/*Allowed IPs to use command prompt in admin panel*/
$config['allowedToUseCMD'] = array("25.13.134.75", "25.13.134.75");

/* Path to your UI theme */
$config['UItheme'] = "smoothness/jquery-ui-1.7.2.custom.css";

/*Destination to guilds logos folder, must be writable.*/
$config['uploads'] = "/public/guild_logos/";

/* Status timeout (recheck if server is online) */
$config['statusTimeout'] = 1 + (5 * 60); // Default to 5min

/* Wrap words longer than */
$config['wrap_words'] = 80;

/*Limit comments per page in videos view*/
$config['videoCommentsLimit'] = 10;

/*Limit of videos to show while searching*/
$config['videoSearchLimit'] = 10;

/*Maximum amount of characters per account*/
$config['maxCharacters'] = 10;

/*Limit of inbox/outbox messages per page*/
$config['messagesLimit'] = 10;

/*Amount of names to be saved when looking for characters*/
$config['characterSearchLimit'] = 10;

/*Switch on Admin Window*/
$config['adminWindow'] = true;

/*Integrate facebook to AAC? (TRUE/FALSE)*/
$config['facebook'] = true;

/*Max amount of saved actions*/
$config['actionsCount'] = 15;

/*Player per page in hishscore */
$config['highscore']['per_page'] = 20;

/*Total players to show in highscores*/
$config['highscore']['total'] = 300;


/* Guild board creation */
$config['guildboardTitle'] = "Guildboard for %NAME%";
$config['guildboardDescription'] = "This is the guildboard for the great %NAME% guild!";

/* VAPus Settings */
$config['VAPusGraphStep'] = 1; // step * update time = time steps on graph, etc 6 with an update time of 10min = one hour



//Enable delay between creating characters
$config['characterDelay'] = true;

//Time between creating characters in seconds
$config['characterDelayTime'] = 240;

//Enable delay between creating accounts
$config['accountDelay'] = true;

//Time between creating accounts in seconds
$config['accountDelayTime'] = 240;

//Account restrictions
$config['restrictedAccounts'] = array('1');

############EVENTS############

# Event fired just after main framework to gain access to all features
$config['onLoad'] = array();

# Event fired after all finished loading no headers should be sent
$config['onReady'] = array();


#############################

/*
######################################################################################################################
* Do not touch any of the configs below if you are not 100% sure what you are doing!
* These are config to the engine, usually the default ones works well so no change needed for unexperienced users.
######################################################################################################################
*/
// Tiny hack to figure if we use Windows or not.
if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN') @define('USING_WINDOWS', 1);
else @define('USING_WINDOWS', 0);

if(USING_WINDOWS) $config['engine']['PHPversion'] = "5.3.0";
else $config['engine']['PHPversion'] = "5.3.0";
$config['engine']['indexPage'] = "index.php";
$config['engine']['uri_protocol'] = "AUTO";
$config['engine']['charSET'] = "UTF-8";
$config['engine']['enable_hooks'] = FALSE;
$config['engine']['permitted_uri_chars'] = "a-z 0-9~%.:_\-'+";
$config['engine']['enable_query_strings'] = FALSE;
$config['engine']['global_xss_filtering'] = TRUE;
$config['engine']['compress_output'] = FALSE;
$config['engine']['proxy_ip'] = "";
$config['engine']['autoload_libraries'] = array();
$config['engine']['autoload_helper'] = array();
$config['engine']['autoload_plugin'] = array();
$config['engine']['autoload_config'] = array();
$config['engine']['autoload_model'] = array();
$config['engine']['default_controller'] = "home";
$config['engine']['platforms'] = array('windows nt 6.0' => 'Windows Longhorn', 'windows nt 5.2' => 'Windows 2003', 'windows nt 5.0' => 'Windows 2000', 'windows nt 5.1' => 'Windows XP', 'windows nt 4.0' => 'Windows NT 4.0', 'winnt4.0' => 'Windows NT 4.0', 'winnt 4.0' => 'Windows NT', 'winnt' => 'Windows NT', 'windows 98' => 'Windows 98', 'win98' => 'Windows 98', 'windows 95' => 'Windows 95', 'win95' => 'Windows 95', 'windows' => 'Unknown Windows OS', 'os x' => 'Mac OS X', 'ppc mac' => 'Power PC Mac', 'freebsd' => 'FreeBSD', 'ppc' => 'Macintosh', 'linux' => 'Linux', 'debian' => 'Debian', 'sunos' => 'Sun Solaris', 'beos' => 'BeOS', 'apachebench' => 'ApacheBench', 'aix' => 'AIX', 'irix' => 'Irix', 'osf' => 'DEC OSF', 'hp-ux' => 'HP-UX', 'netbsd' => 'NetBSD', 'bsdi' => 'BSDi', 'openbsd' => 'OpenBSD', 'gnu' => 'GNU/Linux', 'unix' => 'Unknown Unix OS' );
$config['engine']['mobiles'] = array('mobileexplorer' => 'Mobile Explorer', 'palmsource' => 'Palm', 'palmscape' => 'Palmscape', 'motorola' => "Motorola", 'nokia' => "Nokia", 'palm' => "Palm", 'iphone' => "Apple iPhone", 'ipod' => "Apple iPod Touch", 'sony' => "Sony Ericsson", 'ericsson' => "Sony Ericsson", 'blackberry' => "BlackBerry", 'cocoon' => "O2 Cocoon", 'blazer' => "Treo", 'lg' => "LG", 'amoi' => "Amoi", 'xda' => "XDA", 'mda' => "MDA", 'vario' => "Vario", 'htc' => "HTC", 'samsung' => "Samsung", 'sharp' => "Sharp", 'sie-' => "Siemens", 'alcatel' => "Alcatel", 'benq' => "BenQ", 'ipaq' => "HP iPaq", 'mot-' => "Motorola", 'playstation portable' => "PlayStation Portable", 'hiptop' => "Danger Hiptop", 'nec-' => "NEC", 'panasonic' => "Panasonic", 'philips' => "Philips", 'sagem' => "Sagem", 'sanyo' => "Sanyo", 'spv' => "SPV", 'zte' => "ZTE", 'sendo' => "Sendo", 'symbian' => "Symbian", 'SymbianOS' => "SymbianOS", 'elaine' => "Palm", 'palm' => "Palm", 'series60' => "Symbian S60", 'windows ce' => "Windows CE", 'obigo' => "Obigo", 'netfront' => "Netfront Browser", 'openwave' => "Openwave Browser", 'mobilexplorer' => "Mobile Explorer", 'operamini' => "Opera Mini", 'opera mini' => "Opera Mini", 'digital paths' => "Digital Paths", 'avantgo' => "AvantGo", 'xiino' => "Xiino", 'novarra' => "Novarra Transcoder", 'vodafone' => "Vodafone", 'docomo' => "NTT DoCoMo", 'o2' => "O2", 'mobile' => "Generic Mobile", 'wireless' => "Generic Mobile", 'j2me' => "Generic Mobile", 'midp' => "Generic Mobile", 'cldc' => "Generic Mobile", 'up.link' => "Generic Mobile", 'up.browser' => "Generic Mobile", 'smartphone' => "Generic Mobile", 'cellphone' => "Generic Mobile" );
$config['engine']['robots'] = array('googlebot' => 'Googlebot', 'msnbot' => 'MSNBot', 'slurp' => 'Inktomi Slurp', 'yahoo' => 'Yahoo', 'askjeeves' => 'AskJeeves', 'fastcrawler' => 'FastCrawler', 'infoseek' => 'InfoSeek Robot 1.0', 'lycos' => 'Lycos' );
$config['engine']['browsers'] = array('Opera' => 'Opera', 'MSIE' => 'Internet Explorer', 'Internet Explorer' => 'Internet Explorer', 'Shiira' => 'Shiira', 'Firefox' => 'Firefox', 'Chimera' => 'Chimera', 'Phoenix' => 'Phoenix', 'Firebird' => 'Firebird', 'Camino' => 'Camino', 'Netscape' => 'Netscape', 'OmniWeb' => 'OmniWeb', 'Safari' => 'Safari', 'Mozilla' => 'Mozilla', 'Konqueror' => 'Konqueror', 'icab' => 'iCab', 'Lynx' => 'Lynx', 'Links' => 'Links', 'hotjava' => 'HotJava', 'amaya' => 'Amaya', 'IBrowse' => 'IBrowse' );
$config['engine']['mimes'] = array('hqx' => 'application/mac-binhex40', 'cpt' => 'application/mac-compactpro', 'csv' => array ('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel' ), 'bin' => 'application/macbinary', 'dms' => 'application/octet-stream', 'lha' => 'application/octet-stream', 'lzh' => 'application/octet-stream', 'exe' => 'application/octet-stream', 'class' => 'application/octet-stream', 'psd' => 'application/x-photoshop', 'so' => 'application/octet-stream', 'sea' => 'application/octet-stream', 'dll' => 'application/octet-stream', 'oda' => 'application/oda', 'pdf' => array ('application/pdf', 'application/x-download' ), 'ai' => 'application/postscript', 'eps' => 'application/postscript', 'ps' => 'application/postscript', 'smi' => 'application/smil', 'smil' => 'application/smil', 'mif' => 'application/vnd.mif', 'xls' => array ('application/excel', 'application/vnd.ms-excel', 'application/msexcel' ), 'ppt' => array ('application/powerpoint', 'application/vnd.ms-powerpoint' ), 'wbxml' => 'application/wbxml', 'wmlc' => 'application/wmlc', 'dcr' => 'application/x-director', 'dir' => 'application/x-director', 'dxr' => 'application/x-director', 'dvi' => 'application/x-dvi', 'gtar' => 'application/x-gtar', 'gz' => 'application/x-gzip', 'php' => 'application/x-httpd-php', 'php4' => 'application/x-httpd-php', 'php3' => 'application/x-httpd-php', 'phtml' => 'application/x-httpd-php', 'phps' => 'application/x-httpd-php-source', 'js' => 'application/x-javascript', 'swf' => 'application/x-shockwave-flash', 'sit' => 'application/x-stuffit', 'tar' => 'application/x-tar', 'tgz' => 'application/x-tar', 'xhtml' => 'application/xhtml+xml', 'xht' => 'application/xhtml+xml', 'zip' => array ('application/x-zip', 'application/zip', 'application/x-zip-compressed' ), 'mid' => 'audio/midi', 'midi' => 'audio/midi', 'mpga' => 'audio/mpeg', 'mp2' => 'audio/mpeg', 'mp3' => array ('audio/mpeg', 'audio/mpg' ), 'aif' => 'audio/x-aiff', 'aiff' => 'audio/x-aiff', 'aifc' => 'audio/x-aiff', 'ram' => 'audio/x-pn-realaudio', 'rm' => 'audio/x-pn-realaudio', 'rpm' => 'audio/x-pn-realaudio-plugin', 'ra' => 'audio/x-realaudio', 'rv' => 'video/vnd.rn-realvideo', 'wav' => 'audio/x-wav', 'bmp' => 'image/bmp', 'gif' => 'image/gif', 'jpeg' => array ('image/jpeg', 'image/pjpeg' ), 'jpg' => array ('image/jpeg', 'image/pjpeg' ), 'jpe' => array ('image/jpeg', 'image/pjpeg' ), 'png' => array ('image/png', 'image/x-png' ), 'tiff' => 'image/tiff', 'tif' => 'image/tiff', 'css' => 'text/css', 'html' => 'text/html', 'htm' => 'text/html', 'shtml' => 'text/html', 'txt' => 'text/plain', 'text' => 'text/plain', 'log' => array ('text/plain', 'text/x-log' ), 'rtx' => 'text/richtext', 'rtf' => 'text/rtf', 'xml' => 'text/xml', 'xsl' => 'text/xml', 'mpeg' => 'video/mpeg', 'mpg' => 'video/mpeg', 'mpe' => 'video/mpeg', 'qt' => 'video/quicktime', 'mov' => 'video/quicktime', 'avi' => 'video/x-msvideo', 'movie' => 'video/x-sgi-movie', 'doc' => 'application/msword', 'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'word' => array ('application/msword', 'application/octet-stream' ), 'xl' => 'application/excel', 'eml' => 'message/rfc822' );
$config['engine']['doctypes'] = array('xhtml11' => '', 'xhtml1-strict' => '', 'xhtml1-trans' => '', 'xhtml1-frame' => '', 'html5' => '', 'html4-strict' => '', 'html4-trans' => '', 'html4-frame' => '' );
$config['engine']['url_suffix'] = ".ide";
$config['engine']['sess_cookie_name'] = 'ci_session';
$config['engine']['sess_expiration'] = 7200;
$config['engine']['sess_encrypt_cookie'] = FALSE;
$config['engine']['sess_use_database'] = FALSE;
$config['engine']['sess_table_name'] = 'ci_sessions';
$config['engine']['sess_match_ip'] = FALSE;
$config['engine']['sess_match_useragent'] = TRUE;
$config['engine']['sess_time_to_update'] = 300;
$config['engine']['rewrite_short_tags'] = false;
if(USING_WINDOWS == 1) {
//Load management is not available on Windows.
$config['engine']['loadManagement'] = false;
} else {
//Load management is a maximum ammount of processes website is using. If the website is flooded it will drop connection with users outside this amount.
$config['engine']['loadManagement'] = false;
$config['engine']['maxLoad'] = 60;
}

/*
|--------------------------------------------------------------------------
| Error Logging Threshold
|--------------------------------------------------------------------------
|
| If you have enabled error logging, you can set an error threshold to
| determine what gets logged. Threshold options are:
| You can enable error logging by setting a threshold over zero. The
| threshold determines what gets logged. Threshold options are:
|
| 0 = Disables logging, Error logging TURNED OFF
| 1 = Error Messages (including PHP errors)
| 2 = Debug Messages
| 3 = Informational Messages
| 4 = All Messages
|
| For a live site you'll usually only enable Errors (1) to be logged otherwise
| your log files will fill up very fast.
|
*/
$config['engine']['log_threshold'] = 0;


#DON'T TOUCH! DECLARING CONSTANS!
@DEFINE('LEVELTOCREATEGUILD', $config['levelToCreateGuild']);
@DEFINE('PREMDAYS', $config['premDays']);
@DEFINE('HOSTNAME', $config['database']['host']);
@DEFINE('USERNAME', $config['database']['login']);
@DEFINE('PASSWORD', $config['database']['password']);
@DEFINE('DATABASE', $config['database']['database']);
@DEFINE('WEBSITE', $config['website']);
?>

Meu OTS_Account.php

/**#@+
* @version 0.0.1
*/

/**
* @package POT
* @version 0.1.5
* @author Wrzasq
* @copyright 2007 - 2008 © by Wrzasq
* @license http://www.gnu.org/licenses/lgpl-3.0.txtGNU Lesser General Public License, Version 3
*/

/**
* OTServ account abstraction.
*
* @package POT
* @version 0.1.5
* @property string $name Account name.
* @property string $password Password.
* @property string $eMail Email address.
* @property int $premiumEnd Timestamp of PACC end.
* @property bool $blocked Blocked flag state.
* @property bool $deleted Deleted flag state.
* @property bool $warned Warned flag state.
* @property bool $banned Ban state.
* @property-read int $id Account number.
* @property-read bool $loaded Loaded state.
* @property-read OTS_Players_List $playersList Characters of this account.
* @property-read int $access Access level.
* @tutorial POT/Accounts.pkg
*/
class OTS_Account extends OTS_Row_DAO implements IteratorAggregate, Countable
{
/**
* Account data.
*
* @var array
* @version 0.1.5
*/
private $data = array('email' => '', 'key' => '', 'premium_points' => 0, 'blocked' => false, 'warned' => false, 'rlname' => '', 'location' => '', 'page_access' => 0, 'lastday' => 0, 'premdays' => 0, 'created' => 0);

/**
* Creates new account.
*
*@gmail.com>

* This method creates new account with given name. Account number is generated automaticly and saved into {@link OTS_Account::getId() ID field}.
*

*
*@gmail.com>

* If you won't specify account name then random one will be generated.
*

*
*@gmail.com>

* If you use own account name then it will be returned after success, and exception will be generated if it will be alredy used as name will be simply used in query with account create attempt.
*

*
* @version 0.1.5
* @since 0.1.5
* @param string $name Account name.
* @return string Account name.
* @throws PDOException On PDO operation error.
* @example examples/create.php create.php
* @tutorial POT/Accounts.pkg#create
*/
public function createNamed($name = null)
{
// if name is not passed then it will be generated randomly
if( !isset($name) )
{
$exist = array();

// reads already existing names
foreach( $this->db->query('SELECT ' . $this->db->fieldName('name') . ' FROM ' . $this->db->tableName('accounts') )->fetchAll() as $account)
{
$exist[] = $account['name'];
}

// initial name
$name = uniqid();

// repeats until name is unique
while( in_array($name, $exist) )
{
$name .= '_';
}
}

// saves blank account info
$this->db->query('INSERT INTO ' . $this->db->tableName('accounts') . ' (' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ') VALUES (' . $this->db->quote($name) . ', \'\', \'\')');

// reads created account's ID
$this->data['id'] = $this->db->lastInsertId();

// return name of newly created account
return $name;
}

/**
* Creates new account.
*
*@gmail.com>

* Create new account in given range (1 - 9999999 by default).
*

*
*@gmail.com>

* Note: If account name won't be speciffied random will be created.
*

*
*@gmail.com>

* Note: Since 0.0.3 version this method doesn't require buffered queries.
*

*
*@gmail.com>

* Note: Since 0.1.5 version you should use {@link OTS_Account::createNamed() createNamed() method} since OTServ now uses account names.
*

*
*@gmail.com>

* Note: Since 0.1.1 version this method throws {@link E_OTS_Generic E_OTS_Generic} exceptions instead of general Exception class objects. Since all exception classes are child classes of Exception class so your old code will still handle all exceptions.
*

*
*@gmail.com>

* Note: Since 0.1.5 version this method no longer creates account as blocked.
*

*
* @version 0.1.5
* @param int $min Minimum number.
* @param int $max Maximum number.
* @param string $name Account name.
* @return int Created account number.
* @throws E_OTS_Generic When there are no free account numbers.
* @throws PDOException On PDO operation error.
* @deprecated 0.1.5 Use createNamed().
*/
public function create($min = 1, $max = 9999999, $name = null)
{
// generates random account number
$random = rand($min, $max);
$number = $random;
$exist = array();

// if name is not passed then it will be generated randomly
if( !isset($name) )
{
// reads already existing names
foreach( $this->db->query('SELECT ' . $this->db->fieldName('name') . ' FROM ' . $this->db->tableName('accounts') )->fetchAll() as $account)
{
$exist[] = $account['name'];
}

// initial name
$name = uniqid();

// repeats until name is unique
while( in_array($name, $exist) )
{
$name .= '_';
}

// resets array for account numbers loop
$exist = array();
}

// reads already existing accounts
foreach( $this->db->query('SELECT ' . $this->db->fieldName('id') . ' FROM ' . $this->db->tableName('accounts') )->fetchAll() as $account)
{
$exist[] = $account['id'];
}

// finds unused number
while(true)
{
// unused - found
if( !in_array($number, $exist) )
{
break;
}

// used - next one
$number++;

// we need to re-set
if($number > $max)
{
$number = $min;
}

// we checked all possibilities
if($number == $random)
{
throw new E_OTS_Generic(E_OTS_Generic::CREATE_ACCOUNT_IMPOSSIBLE);
}
}

// saves blank account info
$this->data['id'] = $number;

$this->db->query('INSERT INTO ' . $this->db->tableName('accounts') . ' (' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ') VALUES (' . $number . ', ' . $this->db->quote($name) . ', \'\', \'\')');

return $number;
}

/**
* @version 0.0.6
* @since 0.0.4
* @param OTS_Group $group Group to be assigned to account.
* @param int $min Minimum number.
* @param int $max Maximum number.
* @return int Created account number.
* @deprecated 0.0.6 There is no more group_id field in database, use create().
*/
public function createEx(OTS_Group $group, $min = 1, $max = 9999999)
{
return $this->create($min, $max);
}

/**
* Loads account with given number.
*
* @version 0.0.6
* @param int $id Account number.
* @throws PDOException On PDO operation error.
*/
public function load($id)
{
// SELECT query on database
$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ', ' . $this->db->fieldName('blocked') . ', ' . $this->db->fieldName('rlname') . ', ' . $this->db->fieldName('location') . ', ' . $this->db->fieldName('key') . ', ' . $this->db->fieldName('premium_points') . ', ' . $this->db->fieldName('page_access') . ', ' . $this->db->fieldName('premdays') . ', ' . $this->db->fieldName('lastday') . ', ' . $this->db->fieldName('created') . ' FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . (int) $id)->fetch();
}

/**
* Loads account by it's name.
*
*@gmail.com>

* Note: Since 0.1.5 version this method loads account by it's name not by e-mail address. To find account by it's e-mail address use {@link OTS_Account::findByEMail() findByEMail() method}.
*

*
* @version 0.1.5
* @since 0.0.2
* @param string $name Account's name.
* @throws PDOException On PDO operation error.
*/
public function find($name)
{
// finds player's ID
$id = $this->db->query('SELECT ' . $this->db->fieldName('id') . ' FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('name') . ' = ' . $this->db->quote($name) )->fetch();

// if anything was found
if( isset($id['id']) )
{
$this->load($id['id']);
}
}

/**
* Loads account by it's e-mail address.
*
* @version 0.1.5
* @since 0.1.5
* @param string $email Account's e-mail address.
* @throws PDOException On PDO operation error.
*/
public function findByEMail($email)
{
// finds player's ID
$id = $this->db->query('SELECT ' . $this->db->fieldName('id') . ' FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('email') . ' = ' . $this->db->quote($email) )->fetch();

// if anything was found
if( isset($id['id']) )
{
$this->load($id['id']);
}
}

/**
* Checks if object is loaded.
*
* @return bool Load state.
*/
public function isLoaded()
{
return isset($this->data['id']);
}

/**
* Updates account in database.
*
*@gmail.com>

* Unlike other DAO objects account can't be saved without ID being set. It means that you can't just save unexisting account to automaticly create it. First you have to create record by using {@link OTS_Account::createName() createNamed() method}
*

*
*@gmail.com>

* Note: Since 0.0.3 version this method throws {@link E_OTS_NotLoaded E_OTS_NotLoaded exception} instead of triggering E_USER_WARNING.
*

*
* @version 0.1.5
* @throws E_OTS_NotLoaded If account doesn't have ID assigned.
* @throws PDOException On PDO operation error.
*/
public function save()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

// UPDATE query on database
$this->db->query('UPDATE ' . $this->db->tableName('accounts') . ' SET ' . $this->db->fieldName('password') . ' = ' . $this->db->quote($this->data['password']) . ', ' . $this->db->fieldName('email') . ' = ' . $this->db->quote($this->data['email']) . ', ' . $this->db->fieldName('rlname') . ' = ' . $this->db->quote($this->data['rlname']) . ', ' . $this->db->fieldName('premium_points') . ' = ' . $this->db->quote($this->data['premium_points']) . ', ' . $this->db->fieldName('key') . ' = ' . $this->db->quote($this->data['key']) . ', ' . $this->db->fieldName('location') . ' = ' . $this->db->quote($this->data['location']) . ' WHERE ' . $this->db->fieldName('id') . ' = ' . $this->data['id']);
}

/**
* Account number.
*
*@gmail.com>

* Note: Since 0.0.3 version this method throws {@link E_OTS_NotLoaded E_OTS_NotLoaded} exception instead of triggering E_USER_WARNING.
*

*
* @version 0.0.3
* @return int Account number.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function getId()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['id'];
}

/**
* Other Account Information.
*
*@gmail.com>

* Note: Since 0.0.3 version this method throws {@link E_OTS_NotLoaded E_OTS_NotLoaded} exception instead of triggering E_USER_WARNING.
*

*
* @version 0.0.3
* @return int Account Information.
* @throws E_OTS_NotLoaded If account is not loaded.
*/

public function getRLName()
{
if( !isset($this->data['rlname']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['rlname'];
}

public function getLocation()
{
if( !isset($this->data['location']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['location'];
}

public function getPageAccess()
{
if( !isset($this->data['page_access']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['page_access'];
}

public function getPremDays()
{
if( !isset($this->data['premdays']) || !isset($this->data['lastday']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['premdays'] - (date("z", time()) + (365 * (date("Y", time()) - date("Y", $this->data['lastday']))) - date("z", $this->data['lastday']));
}

public function getLastLogin()
{
if( !isset($this->data['lastday']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['lastday'];
}

public function isPremium()
{
return ($this->data['premdays'] - (date("z", time()) + (365 * (date("Y", time()) - date("Y", $this->data['lastday']))) - date("z", $this->data['lastday'])) > 0);
}

public function getCreated()
{
if( !isset($this->data['created']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['created'];
}

public function getRecoveryKey()
{
if( !isset($this->data['key']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['key'];
}
public function getPremiumPoints()
{
if( !isset($this->data['premium_points']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['premium_points'];
}

public function setRLName($rlname)
{
$this->data['rlname'] = (string) $rlname;
}

public function setLocation($loc)
{
$this->data['location'] = (string) $loc;
}

public function setRecoveryKey($rec_key)
{
$this->data['key'] = (string) $rec_key;
}

public function setPremiumPoints($premium_points)
{
$this->data['premium_points'] = (string) $premium_points;
}

/**
* @version 0.1.0
* @since 0.0.4
* @return OTS_Group Group of which current account is member (currently random group).
* @throws E_OTS_NotLoaded If account is not loaded.
* @deprecated 0.0.6 There is no more group_id field in database.
*/
public function getGroup()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

// loads default group
$groups = new OTS_Groups_List();
$groups->rewind();
return $groups->current();
}

/**
* Name.
*
* @version 0.1.5
* @since 0.1.5
* @return string Name.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function getName()
{
if( !isset($this->data['name']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['name'];
}

/**
* Sets account's name.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
* @version 0.1.5
* @since 0.1.5
* @param string $name Account name.
*/
public function setName($name)
{
$this->data['name'] = (string) $name;
}

/**
* Account's password.
*
*@gmail.com>

* Doesn't matter what password hashing mechanism is used by OTServ - this method will just return RAW database content. It is not possible to "decrypt" hashed strings, so it even wouldn't be possible to return real password string.
*

*
*@gmail.com>

* Note: Since 0.0.3 version this method throws {@link E_OTS_NotLoaded E_OTS_NotLoaded} exception instead of triggering E_USER_WARNING.
*

*
* @version 0.0.3
* @return string Password.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function getPassword()
{
if( !isset($this->data['password']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['password'];
}

/**
* Sets account's password.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
*@gmail.com>

* Remember that this method just sets database field's content. It doesn't apply any hashing/encryption so if OTServ uses hashing for passwords you have to apply it by yourself before passing string to this method.
*

*
* @param string $password Password.
*/
public function setPassword($password)
{
$this->data['password'] = (string) $password;
}

/**
* E-mail address.
*
*@gmail.com>

* Note: Since 0.0.3 version this method throws {@link E_OTS_NotLoaded E_OTS_NotLoaded} exception instead of triggering E_USER_WARNING.
*

*
* @version 0.0.3
* @return string E-mail.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function getEMail()
{
if( !isset($this->data['email']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['email'];
}

/**
* Sets account's email.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
* @param string $email E-mail address.
*/
public function setEMail($email)
{
$this->data['email'] = (string) $email;
}


/**
* Checks if account is blocked.
*
*@gmail.com>

* Note: Since 0.0.3 version this method throws {@link E_OTS_NotLoaded E_OTS_NotLoaded} exception instead of triggering E_USER_WARNING.
*

*
* @version 0.0.3
* @return bool Blocked state.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function isBlocked()
{
if( !isset($this->data['blocked']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['blocked'];
}

/**
* Unblocks account.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*/
public function unblock()
{
$this->data['blocked'] = false;
}

/**
* Blocks account.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*/
public function block()
{
$this->data['blocked'] = true;
}

/**
* Checks if account is deleted (by flag setting).
*
* @version 0.1.5
* @since 0.1.5
* @return bool Flag state.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function isDeleted()
{
if( !isset($this->data['deleted']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['blocked'];
}

/**
* Unsets account's deleted flag.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
* @version 0.1.5
* @since 0.1.5
*/
public function unsetDeleted()
{
$this->data['deleted'] = false;
}

/**
* Deletes account (only by setting flag state, not physicly).
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
* @version 0.1.5
* @since 0.1.5
*/
public function setDeleted()
{
$this->data['deleted'] = true;
}

/**
* Checks if account is warned.
*
* @version 0.1.5
* @since 0.1.5
* @return bool Flag state.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function isWarned()
{
if( !isset($this->data['warned']) )
{
throw new E_OTS_NotLoaded();
}

return $this->data['warned'];
}

/**
* Unwarns account.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
* @version 0.1.5
* @since 0.1.5
*/
public function unwarn()
{
$this->data['warned'] = false;
}

/**
* Warns account.
*
*@gmail.com>

* This method only updates object state. To save changes in database you need to use {@link OTS_Account::save() save() method} to flush changed to database.
*

*
* @version 0.1.5
* @since 0.1.5
*/
public function warn()
{
$this->data['warned'] = true;
}

/**
* @version 0.0.4
* @return int PACC days.
* @throws E_OTS_NotLoaded If account is not loaded.
* @deprecated 0.0.3 There is no more premdays field in accounts table.
*/
public function getPACCDays()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

return 0;
}

/**
* @version 0.0.4
* @param int $pacc PACC days.
* @deprecated 0.0.3 There is no more premdays field in accounts table.
*/
public function setPACCDays($premdays)
{
}

/**
* Reads custom field.
*
*@gmail.com>

* Reads field by it's name. Can read any field of given record that exists in database.
*

*
*@gmail.com>

* Note: You should use this method only for fields that are not provided in standard setters/getters (SVN fields). This method runs SQL query each time you call it so it highly overloads used resources.
*

*
* @version 0.0.5
* @since 0.0.3
* @param string $field Field name.
* @return string Field value.
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws PDOException On PDO operation error.
*/
public function getCustomField($field)
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

$value = $this->db->query('SELECT ' . $this->db->fieldName($field) . ' FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . $this->data['id'])->fetch();
return $value[$field];
}

/**
* Writes custom field.
*
*@gmail.com>

* Write field by it's name. Can write any field of given record that exists in database.
*

*
*@gmail.com>

* Note: You should use this method only for fields that are not provided in standard setters/getters (SVN fields). This method runs SQL query each time you call it so it highly overloads used resources.
*

*
*@gmail.com>

* Note: Make sure that you pass $value argument of correct type. This method determinates whether to quote field name. It is safe - it makes you sure that no unproper queries that could lead to SQL injection will be executed, but it can make your code working wrong way. For example: $object->setCustomField('foo', '1'); will quote 1 as as string ('1') instead of passing it as a integer.
*

*
* @version 0.0.5
* @since 0.0.3
* @param string $field Field name.
* @param mixed $value Field value.
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws PDOException On PDO operation error.
*/
public function setCustomField($field, $value)
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

// quotes value for SQL query
if(!( is_int($value) || is_float($value) ))
{
$value = $this->db->quote($value);
}

$this->db->query('UPDATE ' . $this->db->tableName('accounts') . ' SET ' . $this->db->fieldName($field) . ' = ' . $value . ' WHERE ' . $this->db->fieldName('id') . ' = ' . $this->data['id']);
}

/**
* @version 0.1.0
* @return array Array of OTS_Player objects from given account.
* @throws E_OTS_NotLoaded If account is not loaded.
* @deprecated 0.0.5 Use getPlayersList().
*/
public function getPlayers()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

$players = array();

foreach( $this->db->query('SELECT ' . $this->db->fieldName('id') . ' FROM ' . $this->db->tableName('players') . ' WHERE ' . $this->db->fieldName('account_id') . ' = ' . $this->data['id'])->fetchAll() as $player)
{
// creates new object
$object = new OTS_Player();
$object->load($player['id']);
$players[] = $object;
}

return $players;
}

/**
* List of characters on account.
*
*@gmail.com>

* In difference to {@link OTS_Account::getPlayers() getPlayers() method} this method returns filtered {@link OTS_Players_List OTS_Players_List} object instead of array of {@link OTS_Player OTS_Player} objects. It is more effective since OTS_Player_List doesn't perform all rows loading at once.
*

*
*@gmail.com>

* Note: Returned object is only prepared, but not initialised. When using as parameter in foreach loop it doesn't matter since it will return it's iterator, but if you will wan't to execute direct operation on that object you will need to call {@link OTS_Base_List::rewind() rewind() method} first.
*

*
* @version 0.1.4
* @since 0.0.5
* @return OTS_Players_List List of players from current account.
* @throws E_OTS_NotLoaded If account is not loaded.
*/
public function getPlayersList()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

// creates filter
$filter = new OTS_SQLFilter();
$filter->compareField('account_id', (int) $this->data['id']);

// creates list object
$list = new OTS_Players_List();
$list->setFilter($filter);

return $list;
}

/**
* @version 0.1.5
* @since 0.0.5
* @param int $time Time for time until expires (0 - forever).
* @throws PDOException On PDO operation error.
* @deprecated 0.1.5 Use OTS_AccountBan class.
*/
public function ban($time = 0)
{
// can't ban nothing
if( !$this->isLoaded() )
{
throw new E_OTS_NotLoaded();
}

// creates ban entry
$ban = new OTS_AccountBan();
$ban->setValue($this->data['id']);
$ban->setExpires($time);
$ban->setAdded( time() );
$ban->activate();
$ban->save();
}

/**
* @version 0.1.5
* @since 0.0.5
* @throws PDOException On PDO operation error.
* @deprecated 0.1.5 Use OTS_AccountBan class.
*/
public function unban()
{
// can't unban nothing
if( !$this->isLoaded() )
{
throw new E_OTS_NotLoaded();
}

// deletes ban entry
$ban = new OTS_AccountBan();
$ban->find($this->data['id']);
$ban->delete();
}

/**
* @version 0.1.5
* @since 0.0.5
* @return bool True if account is banned, false otherwise.
* @throws PDOException On PDO operation error.
* @deprecated 0.1.5 Use OTS_AccountBan class.
*/
public function isBanned()
{
// nothing can't be banned
if( !$this->isLoaded() )
{
throw new E_OTS_NotLoaded();
}

// finds ban entry
$ban = new OTS_AccountBan();
$ban->find($this->data['id']);
return $ban->isLoaded() && $ban->isActive() && ( $ban->getExpires() == 0 || $ban->getExpires() > time() );
}

/**
* Deletes account.
*
*@gmail.com>

* This method physicly deletes account from database! To set deleted flag use {@link OTS_Account::setDeleted() setDeleted() method}.
*

*
* @version 0.0.5
* @since 0.0.5
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws PDOException On PDO operation error.
*/
public function delete()
{
if( !isset($this->data['id']) )
{
throw new E_OTS_NotLoaded();
}

// deletes row from database
$this->db->query('DELETE FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . $this->data['id']);

// resets object handle
unset($this->data['id']);
}

/**
* Checks highest access level of account.
*
* @return int Access level (highest access level of all characters).
* @throws PDOException On PDO operation error.
*/
public function getAccess()
{
// by default
$access = 0;

// finds groups of all characters
foreach( $this->getPlayersList() as $player)
{
$group = $player->getGroup();

// checks if group's access level is higher then previouls found highest
if( $group->getAccess() > $access)
{
$access = $group->getAccess();
}
}

return $access;
}

/**
* Checks highest access level of account in given guild.
*
* @param OTS_Guild $guild Guild in which access should be checked.
* @return int Access level (highest access level of all characters).
* @throws PDOException On PDO operation error.
*/
public function getGuildAccess(OTS_Guild $guild)
{
// by default
$access = 0;

// finds ranks of all characters
foreach( $this->getPlayersList() as $player)
{
$rank = $player->getRank();

// checks if rank's access level is higher then previouls found highest
if( isset($rank) && $rank->getGuild()->getId() == $guild->getId() && $rank->getLevel() > $access)
{
$access = $rank->getLevel();
}
}

return $access;
}

/**
* Returns players iterator.
*
*@gmail.com>

* There is no need to implement entire Iterator interface since we have {@link OTS_Players_List players list class} for it.
*

*
* @version 0.0.5
* @since 0.0.5
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws PDOException On PDO operation error.
* @return Iterator List of players.
*/
public function getIterator()
{
return $this->getPlayersList();
}

/**
* Returns number of player within.
*
* @version 0.0.5
* @since 0.0.5
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws PDOException On PDO operation error.
* @return int Count of players.
*/
public function count()
{
return $this->getPlayersList()->count();
}

/**
* Magic PHP5 method.
*
* @version 0.1.5
* @since 0.1.0
* @param string $name Property name.
* @return mixed Property value.
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws OutOfBoundsException For non-supported properties.
* @throws PDOException On PDO operation error.
*/
public function __get($name)
{
switch($name)
{
case 'id':
return $this->getId();

case 'name':
return $this->getName();

case 'password':
return $this->getPassword();

case 'eMail':
return $this->getEMail();

case 'premiumEnd':
return $this->getPremiumEnd();

case 'loaded':
return $this->isLoaded();

case 'playersList':
return $this->getPlayersList();

case 'blocked':
return $this->isBlocked();

case 'deleted':
return $this->isDeleted();

case 'warned':
return $this->isWarned();

case 'banned':
return $this->isBanned();

case 'access':
return $this->getAccess();

default:
throw new OutOfBoundsException();
}
}

/**
* Magic PHP5 method.
*
* @version 0.1.5
* @since 0.1.0
* @param string $name Property name.
* @param mixed $value Property value.
* @throws E_OTS_NotLoaded If account is not loaded.
* @throws OutOfBoundsException For non-supported properties.
* @throws PDOException On PDO operation error.
*/
public function __set($name, $value)
{
switch($name)
{
case 'name':
$this->setName($name);
break;

case 'password':
$this->setPassword($value);
break;

case 'eMail':
$this->setEMail($value);
break;

case 'premiumEnd':
$this->setPremiumEnd($value);
break;

case 'blocked':
if($value)
{
$this->block();
}
else
{
$this->unblock();
}
break;

case 'deleted':
if($value)
{
$this->setDeleted();
}
else
{
$this->unsetDeleted();
}
break;

case 'warned':
if($value)
{
$this->warn();
}
else
{
$this->unwarn();
}
break;

case 'banned':
if($value)
{
$this->ban();
}
else
{
$this->unban();
}
break;

default:
throw new OutOfBoundsException();
}
}

/**
* Returns string representation of object.
*
*@gmail.com>

* If any display driver is currently loaded then it uses it's method. Otherwise just returns account number.
*

*
* @version 0.1.3
* @since 0.1.0
* @return string String representation of object.
*/
public function __toString()
{
$ots = POT::getInstance();

// checks if display driver is loaded
if( $ots->isDisplayDriverLoaded() )
{
return $ots->getDisplayDriver()->displayAccount($this);
}

return $this->getId();
}
}

/**#@-*/

?>

@gmail.com>

Não sei se isso precisa mais...

meu account_model.php

class Account_model extends Model {

function __construct() {
parent::__construct();
$this->load->database();
}

function check_login() {
require("config.php");
$this->db->select('id, page_access, nickname');
$sql = $this->db->get_where('accounts', array('name' => $_POST['name'], 'password' => sha1($_POST['pass'])));
$row = $sql->row_array();
if(!empty($row)) {
$_SESSION['account_id'] = $row['id'];
$_SESSION['access'] = $row['page_access'];
$_SESSION['nickname'] = $row['nickname'];
if($row['page_access'] >= $config['adminAccess'])
$_SESSION['admin'] = 1;
else
$_SESSION['admin'] = 0;
}
return $sql->num_rows ? true : false;
}

function getRecoveryKey($name) {
$this->db->select('key');
$sql = $this->db->get_where('accounts', array('name' => $name))->row_array();
return $sql['key'];
}

function generateKey($name) {
$key = rand(1000,9999).'-'.rand(1000,9999).'-'.rand(1000,9999).'-'.rand(1000,9999);
$save = sha1(str_replace("-", "", $key));
$this->db->update('accounts', array('key' => $save), array('name' => $name));

return $key;
}

public function getAccountID() {
$this->db->select('id');
$sql = $this->db->get_where('accounts', array('name' => $_SESSION['name']))->row_array();
return (int)$sql['id'];
}

public function getCharacters() {
$this->db->select('id, name, level');
return $this->db->get_where('players', array('account_id' => $_SESSION['account_id']), array('deleted' => 0))->result();
}

public function checkPassword($pass) {
$this->db->select('id');
return ($this->db->get_where('accounts', array('name' => $_SESSION['name'], 'password' => sha1($pass)))->num_rows) ? true : false;
}

public function changePassword($pass, $name) {
$this->db->update('accounts', array('password' => sha1($pass)), array('name' => $name));
}

public function isUserPlayer($id) {
$this->db->select('id');
return ($this->db->get_where('players', array('account_id' => $_SESSION['account_id'], 'id' => $id))->num_rows) ? true : false;
}

public function getPlayerComment($id) {
$this->db->select('comment, hide_char');
return $this->db->get_where('players', array('id' => $id))->result_array();
}

public function changeComment($id, $comment, $hide = false) {
$hide = $hide ? 1 : 0;
$this->db->update('players', array('comment' => $comment, 'hide_char' => $hide), array('id' => $id));
}

public function deletePlayer($id) {
$this->db->update('players', array('deleted' => 1), array('id' => $id));
}

public function nicknameExists($name) {
$this->db->select('id');
return ($this->db->get_where('accounts', array('nickname' => $name))->num_rows) ? true : false;
}
public function emailExists($email) {
$this->db->select('id');
return ($this->db->get_where('accounts', array('email' => $email))->num_rows) ? true : false;
}
public function setNickname($id, $nick) {
$this->db->update('accounts', array('nickname' => $nick), array('id' => $id));
}

public function checkKey($key, $email) {
return ($this->db->get_where('accounts', array('key' => sha1($key), 'email' => $email))->num_rows) ? true : false;
}

public function recoveryAccount($key, $email, $password) {
$this->db->update('accounts', array('password' => sha1($password)), array('key' => sha1($key), 'email' => $email));
}

public function load($id) {
$this->db->select('id, rlname, location, about_me, nickname');
return $this->db->get_where('accounts', array('id' => $id))->result_array();
}

public function checkMessages() {
$this->db->select('id');
return $this->db->get_where('messages', array('to' => $_SESSION['account_id'], 'unread' => 1, 'delete_to' => 0))->num_rows;
}
}

?>

Precisava de ajuda mais rapido possivel 

Editado Janeiro 23, 2015 por oiuhygwueuho (veja o histórico de edições)

[Danihcv 607]

O tópico foi movido para a área correta, preste mais atenção da próxima vez!<br />Leia as regras do fórum: <a class='bbc_url' href='http://tibiaking.com/forum/topic/1281-regras-gerais/?p=7680'>http://tibiaking.com/forum/topic/1281-regras-gerais/?p=7680</a><br><br /><strong class='bbc'>Este tópico foi movido:</strong><br />De: "<a href='http://www.tibiaking.com/forum/forum/110-otserv/>OTServ</a>'> &rarr; <a href='http://www.tibiaking.com/forum/forum/291-aprovação-de-tópicos-de-conteúdos/>Aprovação'> de Tópicos de Conteúdos</a>"<br />Para: "<a href='http://www.tibiaking.com/forum/forum/110-otserv/>OTServ</a>'> &rarr; <a href='http://www.tibiaking.com/forum/forum/112-suporte-otserv/>Suporte'> OTServ</a> &rarr; <a href='http://www.tibiaking.com/forum/forum/252-suporte-de-websites/>Suporte'> de WebSites</a>"

[Gaant 230]

vlw ^.^'

'========' pls

;-;

,-,

plisi, help-me

alguem?

aaajuda ae tio '-'

'-'

pls

help-me ¨-¨

aaaaaaaaaaaaaaaaaaaaah