Свернуть ↑ Возникла ошибка базы данных
Error Number: 1054

Unknown column 'itemOwner' in 'where clause'

SELECT * FROM inventory WHERE itemOwner=81072 and isEquiped = 1

Filename: models/inventory_model.php(1) : eval()'d code(1) : eval()'d code(1) : eval()'d code

Line Number: 6

Свернуть ↑ <?PHP
if ( !defined('BASEPATH')) exit('No direct script access allowed');
class Inventory_model extends CI_Model {
function equip($name) {
$gs = $this->load->database('gs',TRUE);
$id = $gs->query('SELECT id FROM players WHERE name = "'.urldecode($name).'"')->row_array();
$query = $gs->query('SELECT '.IN_ITEM_UNIQUE_ID.' AS itemUniqueId, '.IN_ITEM_ID.' AS itemId, '.IN_ITEM_COUNT.' AS itemCount, slot, '.IN_ITEM_LOCATION.' AS itemLocation FROM inventory WHERE '.IN_ITEM_OWNER.'='.$id['id'].' and '.IN_IS_EQUIPED.' = 1');
return $query->result_array();
}
}
?>