| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,mail,shell_exec,system,proc_open,popen,ini_alter,dl,proc_close,curl_exec,curl_multi_exec,readfile,parse_ini_file,escapeshellarg,escapeshellcmd,show_source,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,mail,php_uname,phpinfo MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/old/components/com_sppolls/models/ |
Upload File : |
<?php
defined('_JEXEC') or die;
class SppollsModelPoll extends JModelItem
{
// Get Poll
public function getPoll($id = null) {
$app = JFactory::getApplication();
$authorised = JAccess::getAuthorisedViewLevels(JFactory::getUser()->get('id'));
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('id', 'title', 'alias', 'polls')));
$query->from($db->quoteName('#__sppolls_polls'));
if ($app->getLanguageFilter()) {
$query->where('language IN (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')');
}
$query->where($db->quoteName('access')." IN (" . implode( ',', $authorised ) . ")");
$query->where($db->quoteName('published'). ' = ' . $db->quote(1));
if($id) {
$query->where($db->quoteName('id') . " = " . $db->quote($id));
}
$query->order('created DESC');
$db->setQuery($query);
return $db->loadObject();
}
// Update Poll
public function updatePoll($poll_data, $id) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$fields = array($db->quoteName('polls') . ' = ' . $db->quote(json_encode($poll_data)));
$conditions = array($db->quoteName('id') . ' = ' . $db->quote($id));
$query->update($db->quoteName('#__sppolls_polls'))->set($fields)->where($conditions);
$db->setQuery($query);
$db->execute();
}
// Get Module
public function getModule($id) {
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName(array('title', 'module', 'params')));
$query->from($db->quoteName('#__modules'));
$query->where($db->quoteName('id') . ' = '. $db->quote($id));
$query->where($db->quoteName('published') . ' = '. $db->quote(1));
$db->setQuery($query);
return $db->loadObject();
}
}