| 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 : /proc/11585/cwd/html/old/administrator/components/com_sppolls/tables/ |
Upload File : |
<?php
/**
* @package Sppolls
*
* @copyright Copyright (C) 2010 - 2018 JoomShaper. All rights reserved.
* @license GNU General Public License version 2 or later; see LICENSE.txt
*/
defined('_JEXEC') or die;
class SppollsTablePoll extends JTable
{
public function __construct(&$db)
{
parent::__construct('#__sppolls_polls', 'id', $db);
}
public function bind($src, $ignore = array())
{
return parent::bind($src, $ignore);
}
public function store($updateNulls = false)
{
$user = JFactory::getUser();
$app = JFactory::getApplication();
$date = new JDate('now', $app->getCfg('offset'));
if ($this->id)
{
$this->modified = (string)$date;
$this->modified_by = $user->get('id');
}
if (empty($this->created))
{
$this->created = (string)$date;
}
if (empty($this->created_by))
{
$this->created_by = $user->get('id');
}
$table = JTable::getInstance('Poll','SppollsTable');
if ($table->load(['alias' => $this->alias]) && ($table->id != $this->id || $this->id == 0) )
{
$this->setError(JText::_('COM_SPPOLLS_ERROR_UNIQUE_ALIAS'));
return false;
}
return parent::store($updateNulls);
}
public function check()
{
if (trim($this->title) == '')
{
throw new UnexpectedValueException(sprintf('The title is empty'));
}
$this->handleAlias();
return true;
}
private function handleAlias()
{
if (empty($this->alias))
{
$this->alias = $this->title;
}
$this->alias = JApplicationHelper::stringURLSafe($this->alias, $this->language);
if (trim(str_replace('-','',$this->alias)) == '')
{
$this->alias = JFactory::getDate()->format('Y-m-d-H-i-s');
}
}
public function publish($pks = null, $published = 1, $userId = 0)
{
$k = $this->_tbl_key;
JArrayHelper::toInteger($pks);
$publilshed = (int) $published;
if (empty($pks)) {
if ($this->$k) {
$pks = array($this->$k);
} else {
$this->setError(JText::_('JLIB_DATABASE_ERROR_NO_ROWS_SELECTED'));
return false;
}
}
$where = $k . '=' . implode(' OR '. $k . ' = ', $pks);
$query = $this->_db->getQuery(true)
->update($this->_db->quoteName($this->_tbl))
->set($this->_db->quoteName('published') . ' = '. $published)
->where($where);
$this->_db->setQuery($query);
try {
$this->_db->execute();
}catch(RuntimeException $e){
$this->setError($e->getMessage());
return false;
}
if (in_array($this->$k, $pks)) {
$this->published = $published;
}
$this->setError('');
return true;
}
}