| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/old/administrator/components/com_kunena/models/ |
Upload File : |
<?php
/**
* Kunena Component
* @package Kunena.Administrator
* @subpackage Models
*
* @copyright (C) 2008 - 2014 Kunena Team. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* @link http://www.kunena.org
**/
defined ( '_JEXEC' ) or die ();
jimport ( 'joomla.application.component.modellist' );
/**
* Smileys Model for Kunena
*
* @since 3.0
*/
class KunenaAdminModelSmilies extends JModelList {
public function __construct($config = array()) {
if (empty($config['filter_fields'])) {
$config['filter_fields'] = array(
'id',
'code',
'location',
'greylocation',
'emoticonbar',
);
}
parent::__construct($config);
}
/**
* Method to auto-populate the model state.
*
* @param string $ordering
* @param string $direction
* @return void
*/
protected function populateState($ordering = null, $direction = null) {
$this->context = 'com_kunena.admin.smilies';
$app = JFactory::getApplication();
// Adjust the context to support modal layouts.
$layout = $app->input->get('layout');
if ($layout) {
$this->context .= '.'.$layout;
}
$filter_active = '';
$filter_active .= $value = $this->getUserStateFromRequest ( $this->context.'.filter.search', 'filter_search', '', 'string' );
$this->setState ( 'filter.search', $value );
$filter_active .= $value = $this->getUserStateFromRequest ( $this->context .'.filter.code', 'filter_code', '', 'string' );
$this->setState ( 'filter.code', $value !== '' ? $value : null );
$filter_active .= $value = $this->getUserStateFromRequest ( $this->context .'.filter.location', 'filter_location', '', 'string' );
$this->setState ( 'filter.location', $value !== '' ? $value : null );
$this->setState ( 'filter.active',!empty($filter_active));
// List state information.
parent::populateState('id', 'asc');
}
protected function getStoreId($id = '') {
// Compile the store id.
$id .= ':'.$this->getState('filter.code');
$id .= ':'.$this->getState('filter.url');
return parent::getStoreId($id);
}
protected function getListQuery() {
$db = $this->getDbo();
$query = $db->getQuery(true);
$query->select(
$this->getState(
'list.select',
'a.id, a.code, a.location, a.greylocation, a.emoticonbar'
)
);
$query->from('#__kunena_smileys AS a');
$filter = $this->getState ('filter.code');
if (!empty($filter)) {
$code = $db->Quote('%'.$db->escape($filter, true).'%');
$query->where('(a.code LIKE '.$code.')');
}
$filter = $this->getState ('filter.location');
if (!empty($filter)) {
$location = $db->Quote('%'.$db->escape($filter, true).'%');
$query->where('(a.location LIKE '.$location.')');
}
// Add the list ordering clause.
$direction = strtoupper($this->state->get('list.direction'));
switch ($this->state->get('list.ordering')) {
case 'code':
$query->order('a.code ' . $direction);
break;
case 'location':
$query->order('a.location ' . $direction);
break;
case 'greylocation':
$query->order('a.greylocation ' . $direction);
break;
case 'emoticonbar':
$query->order('a.emoticonbar ' . $direction);
break;
default:
$query->order('a.id ' . $direction);
}
//echo nl2br(str_replace('#__','jos_',$query));
return $query;
}
}