(Resolvido)Modern Acc (Erro Account)

[ZoR 93]

<?php
class Character_model extends Model {
	
	function __construct() {
		parent::__construct();
		$this->load->database();
	}
	
	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 getPlayersOnline() {
		@$world = (int)$_REQUEST['world'];
		@$order = $_REQUEST['sort'];
		
		$where = array('online' => 1);
		if(!empty($world))
			$where['world_id'] = $world;
		
		$o = "level DESC";
		
		$allowed = array('level', 'vocation', 'name');
		if(!empty($order))
			if(in_array($order, $allowed))
				$o = "$order DESC";

		$this->db->select('name, level, world_id, vocation, promotion');
		$this->db->order_by($o);
		return $this->db->get_where('players', $where)->result_array();
	}
	
	public function getCount() {
		$this->db->where(array('account_id' => $_SESSION['account_id'], 'deleted' => 0));
		$this->db->from('players');
		return $this->db->count_all_results();
	}
	
	public function characterExists($name) {
		$this->db->select('id');
		return ($this->db->get_where('players', array('name' => $name))->num_rows ? true : false);
	}
	
}

?>

Print

Da Errro ao criar account

[dragonfight 3]

Você excluiu algum arquivo? Atualizou a versão do php? Infelizmente o modern aac está ficando defasado em relação ao php. Versões mais atuais do php têm incompatibilidades com algumas funções que devem ser alteradas.

[DarkWore 35]

Altere por:

 

<?php
class Character_model extends Model {
	
	function __construct() {
		parent::__construct();
		$this->load->database();
	}
	
	public function getAccountID() {
		$this->db->select('id');
		$sql = $this->db->get_where('accounts', array('name' => $_SESSION['name']))->row_array();
		return $this->db->get_where('id', $where)->result_array();
	}
	
	public function getPlayersOnline() {
		@$world = (int)$_REQUEST['world'];
		@$order = $_REQUEST['sort'];
		
		$where = array('online' => 1);
		if(!empty($world))
			$where['world_id'] = $world;
		
		$o = "level DESC";
		
		$allowed = array('level', 'vocation', 'name');
		if(!empty($order))
			if(in_array($order, $allowed))
				$o = "$order DESC";

		$this->db->select('name, level, world_id, vocation, promotion');
		$this->db->order_by($o);
		return $this->db->get_where('players', $where)->result_array();
	}
	
	public function getCount() {
		$this->db->where(array('account_id' => $_SESSION['account_id'], 'deleted' => 0));
		$this->db->from('players');
		return $this->db->count_all_results();
	}
	
	public function characterExists($name) {
		$this->db->select('id');
		return ($this->db->get_where('players', array('name' => $name))->num_rows ? true : false);
	}
	
}

?>

Testa assim.

[ZoR 93]

16 horas atrás, RathBR disse:

Altere por:

 

<?php
class Character_model extends Model {
	
	function __construct() {
		parent::__construct();
		$this->load->database();
	}
	
	public function getAccountID() {
		$this->db->select('id');
		$sql = $this->db->get_where('accounts', array('name' => $_SESSION['name']))->row_array();
		return $this->db->get_where('id', $where)->result_array();
	}
	
	public function getPlayersOnline() {
		@$world = (int)$_REQUEST['world'];
		@$order = $_REQUEST['sort'];
		
		$where = array('online' => 1);
		if(!empty($world))
			$where['world_id'] = $world;
		
		$o = "level DESC";
		
		$allowed = array('level', 'vocation', 'name');
		if(!empty($order))
			if(in_array($order, $allowed))
				$o = "$order DESC";

		$this->db->select('name, level, world_id, vocation, promotion');
		$this->db->order_by($o);
		return $this->db->get_where('players', $where)->result_array();
	}
	
	public function getCount() {
		$this->db->where(array('account_id' => $_SESSION['account_id'], 'deleted' => 0));
		$this->db->from('players');
		return $this->db->count_all_results();
	}
	
	public function characterExists($name) {
		$this->db->select('id');
		return ($this->db->get_where('players', array('name' => $name))->num_rows ? true : false);
	}
	
}

?>

Testa assim.

Dando esse Erro

Spoiler

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: where

Filename: models/character_model.php

Line Number: 12

A Database Error Occurred
Error Number: 1146

Table 'naruto.id' doesn't exist

SELECT * FROM (`id`)

 

 

[DarkWore 35]

32 minutos atrás, ZikaLord disse:

Dando esse Erro

  Ocultar conteúdo

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: where

Filename: models/character_model.php

Line Number: 12

A Database Error Occurred
Error Number: 1146

Table 'naruto.id' doesn't exist

SELECT * FROM (`id`)

 

 

Esse erro:

 

A Database Error Occurred
Error Number: 1146

Table 'naruto.id' doesn't exist

SELECT * FROM (`id`)

é á falta da tabela:

 

naruto.id

Já o outro erro, não posso ajudar pois meu conhecimento em PHP é quase Nulo, não sou programador web e sim programador de plataformas.