/**
* Lists the page variables (not displayed in the CMS)
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'location', $order = 'desc', $just_count = FALSE)
{
$this->db->select($this->_tables['fuel_pagevars'] . '.*, ' . $this->_tables['fuel_pages'] . '.layout, ' . $this->_tables['fuel_pages'] . '.location, ' . $this->_tables['fuel_pages'] . '.published AS page_published');
$this->db->join($this->_tables['fuel_pages'], $this->_tables['fuel_pages'] . '.id = ' . $this->_tables['fuel_pagevars'] . '.page_id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc')
{
$this->db->join('authors', 'authors.id = articles.author_id', 'left');
$this->db->select('articles.id, authors.name AS author, title, SUBSTRING(content, 50) AS content, DATE_FORMAT(date_added,"%m/%d/%Y") as date_added, articles.published', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'date_added', $order = 'desc')
{
$this->db->select($this->_tables['blog_comments'] . '.id, title AS post_title, ' . $this->_tables['blog_comments'] . '.content AS comment, author_name AS comment_author_name, DATE_FORMAT(' . $this->_tables['blog_comments'] . '.date_added,"%m/%d/%Y %h:%i %p") as date_added, ' . $this->_tables['blog_comments'] . '.published', FALSE);
$this->db->join($this->_tables['blog_posts'], $this->_tables['blog_comments'] . '.post_id = ' . $this->_tables['blog_posts'] . '.id', 'inner');
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'id', $order = 'asc')
{
$this->db->join('wa_items', 'wa_items.id = wa_enchantments.item_id', 'left');
$this->db->select('wa_enchantments.id, wa_enchantments.name, wa_enchantments.level, wa_enchantments.item_id', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
/**
* Lists the log items
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'entry_date', $order = 'desc', $just_count = FALSE)
{
$this->db->select($this->_logs_table . '.id, entry_date, CONCAT(' . $this->_tables['fuel_users'] . '.first_name, " ", ' . $this->_tables['fuel_users'] . '.last_name) as name, message, type', FALSE);
$this->db->join($this->_tables['fuel_users'], $this->_logs_table . '.user_id = ' . $this->_tables['fuel_users'] . '.id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'id', $order = 'asc')
{
$this->db->join('wa_items', 'wa_items.id = wa_market_prices.item_id', 'left');
$this->db->select('wa_market_prices.id, wa_market_prices.item_id, wa_market_prices.quantity, wa_market_prices.price, wa_items.name AS name, wa_items.damage AS damage', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'id', $order = 'asc')
{
$this->db->join('wa_items', 'wa_items.id = wa_static_shops.item_id', 'left');
$this->db->select('wa_static_shops.id, wa_static_shops.item_id, wa_items.name AS name, wa_items.damage AS damage, wa_static_shops.buy, wa_static_shops.sell', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc', $just_count = FALSE)
{
$this->db->select('fuel_blog_users.id, CONCAT(first_name, " ", last_name) as name, display_name, fuel_blog_users.active', FALSE);
$this->db->join('fuel_users', 'fuel_users.id = fuel_blog_users.fuel_user_id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'date_added', $order = 'desc')
{
$this->db->select($this->_tables['blog_posts'] . '.id, title, CONCAT(' . $this->_tables['users'] . '.first_name, " ", ' . $this->_tables['users'] . '.last_name) AS author, DATE_FORMAT(' . $this->_tables['blog_posts'] . '.date_added,"%m/%d/%Y") as date_added, ' . $this->_tables['blog_posts'] . '.published', FALSE);
$this->db->join($this->_tables['users'], $this->_tables['users'] . '.id = ' . $this->_tables['blog_posts'] . '.author_id', 'left');
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'id', $order = 'asc')
{
$this->db->join('wa_items', 'wa_items.id = wa_auctions.item_id', 'left');
$this->db->join('wa_users', 'wa_users.id = wa_auctions.seller', 'left');
$this->db->select('wa_auctions.id, wa_auctions.item_id, wa_users.username AS seller, wa_auctions.price, wa_items.name AS name, wa_items.damage AS damage, wa_auctions.quantity, wa_auctions.started', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'id', $order = 'asc')
{
$this->db->join('wa_items', 'wa_items.id = wa_mail.item_id', 'left');
$this->db->join('wa_users', 'wa_users.id = wa_mail.player', 'left');
$this->db->select('wa_mail.id, wa_mail.item_id, wa_users.username AS owner, wa_items.name AS name, wa_items.damage AS damage, wa_mail.quantity', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
/**
* Lists the module's items
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'nav_key', $order = 'desc', $just_count = FALSE)
{
$table = $this->table_name();
$this->db->select($table . '.id, ' . $table . '.name, ' . $table . '.slug, ' . $table . '.context, p.name as parent_id, ' . $table . '.precedence, ' . $table . '.published', FALSE);
$this->db->join($table . ' AS p', $this->tables('fuel_categories') . '.parent_id = p.id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc')
{
$this->db->where(array('id !=' => 1));
// Uncategorized category
$this->db->select('id, name, published');
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
public function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'desc')
{
$this->db->select('id, name, SUBSTRING(description, 1, 50) as description, SUBSTRING(view, 1, 150) as view, published', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
foreach ($data as $key => $val) {
$data[$key]['view'] = htmlentities($val['view'], ENT_QUOTES, 'UTF-8');
}
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'post_date', $order = 'desc', $just_count = FALSE)
{
// set the filter again here just in case the table names are different
$this->filters = array('title', 'content_filtered', $this->_tables['fuel_users'] . '.first_name', $this->_tables['fuel_users'] . '.last_name');
$this->db->select($this->_tables['blog_posts'] . '.id, title, CONCAT(' . $this->_tables['fuel_users'] . '.first_name, " ", ' . $this->_tables['fuel_users'] . '.last_name) AS author, ' . $this->_tables['blog_posts'] . '.post_date, ' . $this->_tables['blog_posts'] . '.published', FALSE);
$this->db->join($this->_tables['fuel_users'], $this->_tables['fuel_users'] . '.id = ' . $this->_tables['blog_posts'] . '.author_id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
/**
* Lists the site variable items
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'desc', $just_count = FALSE)
{
$this->db->select('id, name, SUBSTRING(value, 1, 50) as value, scope, active', FALSE);
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
if (empty($just_count)) {
foreach ($data as $key => $val) {
$data[$key]['value'] = htmlentities($val['value'], ENT_QUOTES, 'UTF-8');
}
}
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'email', $order = 'desc')
{
$CI =& get_instance();
$user = $CI->fuel_auth->user_data();
if (!$CI->fuel_auth->is_super_admin()) {
$this->db->where(array('super_admin' => 'no'));
}
$this->db->select('id, email, user_name, first_name, last_name, super_admin, active');
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
/**
* Lists the module's items
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'nav_key', $order = 'desc', $just_count = FALSE)
{
$CI =& get_instance();
if ($CI->fuel->language->has_multiple()) {
$this->db->select('id, label, if (nav_key != "", nav_key, location) AS location, precedence, language, hidden, published', FALSE);
} else {
$this->db->select('id, label, if (nav_key != "", nav_key, location) AS location, precedence, hidden, published', FALSE);
}
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'date_added', $order = 'desc')
{
// set the filter again here just in case the table names are different
$this->filters = array('title', 'content_filtered', $this->_tables['users'] . '.first_name', $this->_tables['users'] . '.last_name');
$this->db->select($this->_tables['blog_posts'] . '.id, title, CONCAT(' . $this->_tables['users'] . '.first_name, " ", ' . $this->_tables['users'] . '.last_name) AS author, ' . $this->_tables['blog_posts'] . '.date_added, ' . $this->_tables['blog_posts'] . '.published', FALSE);
$this->db->join($this->_tables['users'], $this->_tables['users'] . '.id = ' . $this->_tables['blog_posts'] . '.author_id', 'left');
$data = parent::list_items($limit, $offset, $col, $order);
foreach ($data as $key => $val) {
$data[$key]['date_added'] = english_date($data[$key]['date_added'], TRUE);
}
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc', $just_count = FALSE)
{
$this->db->join('authors', 'authors.id = articles.author_id', 'left');
$this->db->select('articles.id, title, SUBSTRING(content, 1, 50) AS content, authors.name AS author, date_added, articles.published', FALSE);
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
if (empty($just_count)) {
foreach ($data as $key => $val) {
$data[$key]['content'] = htmlentities($val['content'], ENT_QUOTES, 'UTF-8');
}
}
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'date_added', $order = 'desc')
{
if ($col == 'date_added') {
$col = $this->_tables['blog_comments'] . '.date_added';
}
$this->db->select($this->_tables['blog_comments'] . '.id, title AS post_title, ' . $this->_tables['blog_comments'] . '.content AS comment, author_name AS comment_author_name, ' . $this->_tables['blog_comments'] . '.is_spam, ' . $this->_tables['blog_comments'] . '.date_added as date_submitted, ' . $this->_tables['blog_comments'] . '.published', FALSE);
$this->db->join($this->_tables['blog_posts'], $this->_tables['blog_comments'] . '.post_id = ' . $this->_tables['blog_posts'] . '.id', 'inner');
$data = parent::list_items($limit, $offset, $col, $order);
foreach ($data as $key => $val) {
$data[$key]['date_submitted'] = english_date($data[$key]['date_submitted'], TRUE);
}
return $data;
}
public function list_items($limit = NULL, $offset = NULL, $col = 'date_added', $order = 'desc', $just_count = FALSE)
{
$this->db->select($this->_tables['form_entries'] . '.id, ' . $this->_tables['form_entries'] . '.form_name, ' . $this->_tables['form_entries'] . '.post, ' . $this->_tables['form_entries'] . '.is_spam, ' . $this->_tables['form_entries'] . '.remote_ip, ' . $this->_tables['form_entries'] . '.date_added');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
if (!$just_count && !$this->is_export) {
foreach ($data as $key => $val) {
$data[$key] = str_replace(array('[', ']', '"', '{', '}'), '', $data[$key]);
$data[$key] = str_replace(array(','), ', ', $data[$key]);
// put deserializing json_decode code here if needed
}
}
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'post_date', $order = 'desc', $just_count = FALSE)
{
// set the filter again here just in case the table names are different
$this->filters = array('title', 'content_filtered', $this->_tables['fuel_users'] . '.first_name', $this->_tables['fuel_users'] . '.last_name');
$CI =& get_instance();
if ($CI->fuel->blog->config('multiple_authors')) {
$this->db->select($this->_tables['blog_posts'] . '.id, title, ' . $this->_tables['blog_posts'] . '.post_date, ' . $this->_tables['blog_posts'] . '.published', FALSE);
} else {
$this->db->select($this->_tables['blog_posts'] . '.id, ' . $this->_tables['blog_posts'] . '.title, IF(' . $this->_tables['fuel_users'] . '.first_name IS NULL, display_name, CONCAT(' . $this->_tables['fuel_users'] . '.first_name, " ", ' . $this->_tables['fuel_users'] . '.last_name)) AS author, ' . $this->_tables['blog_posts'] . '.post_date, ' . $this->_tables['blog_posts'] . '.published', FALSE);
}
$this->db->join($this->_tables['fuel_users'], $this->_tables['fuel_users'] . '.id = ' . $this->_tables['blog_posts'] . '.author_id', 'left');
$this->db->join($this->_tables['blog_users'], $this->_tables['blog_users'] . '.id = ' . $this->_tables['blog_posts'] . '.author_id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
/**
* Lists the module items
*
* @access public
* @param int The limit value for the list data
* @param int The offset value for the list data
* @param string The field name to order by
* @param string The sorting order
* @param boolean Determines whether the result is just an integer of the number of records or an array of data
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'desc', $just_count = FALSE)
{
$CI =& get_instance();
if ($CI->fuel->language->has_multiple()) {
$this->db->select('id, name, SUBSTRING(description, 1, 50) as description, SUBSTRING(view, 1, 150) as view, language, published', FALSE);
} else {
$this->db->select('id, name, SUBSTRING(description, 1, 50) as description, SUBSTRING(view, 1, 150) as view, published', FALSE);
}
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
if (empty($just_count)) {
foreach ($data as $key => $val) {
$data[$key]['view'] = htmlentities($val['view'], ENT_QUOTES, 'UTF-8');
}
}
return $data;
}
public function list_items($limit = NULL, $offset = NULL, $col = NULL, $order = NULL, $just_count = FALSE)
{
if (empty($col)) {
$col = $this->order_by_field;
}
if (empty($order)) {
$order = $this->order_by_direction;
}
$this->db->join('fuel_categories', 'fuel_categories.id = ' . $this->table_name . '.category_id', 'LEFT');
//$this->db->select($this->table_name.'.id, title, fuel_categories.name as category, SUBSTRING(content, 1, 50) as content, '.$this->table_name.'.published', FALSE);
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
// foreach($data as $key => $val)
// {
// $data[$key]['content'] = htmlentities($val['content']);
// }
return $data;
}
/**
* Lists the module's items
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc', $just_count = FALSE)
{
$table = $this->table_name();
$CI =& get_instance();
if ($CI->fuel->language->has_multiple()) {
$this->db->select($table . '.id, ' . $table . '.name, ' . $table . '.slug, SUBSTRING(' . $table . '.description, 1, 50) as description, ' . $table . '.context, p.name as parent_id, ' . $table . '.language, ' . $table . '.precedence, ' . $table . '.published', FALSE);
} else {
$this->db->select($table . '.id, ' . $table . '.name, ' . $table . '.slug, SUBSTRING(' . $table . '.description, 1, 50) as description, ' . $table . '.context, p.name as parent_id, ' . $table . '.precedence, ' . $table . '.published', FALSE);
}
$this->db->join($table . ' AS p', $this->tables('fuel_categories') . '.parent_id = p.id', 'left');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
if (empty($just_count)) {
foreach ($data as $key => $val) {
$data[$key]['description'] = htmlentities($val['description'], ENT_QUOTES, 'UTF-8');
}
}
return $data;
}
function list_items($limit = null, $offset = null, $col = 'title', $order = 'asc')
{
$data = parent::list_items('id, title, type, published', $limit, $offset, $col, $order);
return $data;
}
/**
* Lists the permission items
*
* @access public
* @param int The limit value for the list data (optional)
* @param int The offset value for the list data (optional)
* @param string The field name to order by (optional)
* @param string The sorting order (optional)
* @param boolean Determines whether the result is just an integer of the number of records or an array of data (optional)
* @return mixed If $just_count is true it will return an integer value. Otherwise it will return an array of data (optional)
*/
public function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc', $just_count = FALSE)
{
$this->db->select('id, name, description, active');
$data = parent::list_items($limit, $offset, $col, $order, $just_count);
return $data;
}
public function list_items($limit = NULL, $offset = NULL, $col = 'publish_date', $order = 'desc')
{
$this->db->select('id, job_title, publish_date, published', FALSE);
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'asc')
{
$this->db->select('id, name, url, published');
$data = parent::list_items($limit, $offset, $col, $order);
return $data;
}
