| Server IP : 14.207.165.8 / Your IP : 216.73.216.14 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/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();
}
}