public function getItems() { $mainframe = JFactory::getApplication(); $db = EasyBlogHelper::db(); $filter_groups = $mainframe->getUserStateFromRequest('com_easyblog.fields.filter_groups', 'filter_groups', '', 'string'); $search = $mainframe->getUserStateFromRequest('com_easyblog.fields.search', 'search', '', 'string'); $search = $db->getEscaped(trim(JString::strtolower($search))); $query = array(); $pagination = $this->getPagination(); $query[] = 'SELECT * FROM ' . $db->quoteName('#__easyblog_fields'); $where = array(); if ($filter_groups) { $where[] = $db->quoteName('id') . '=' . $db->Quote($filter_groups); } if ($search) { $where[] = 'LOWER(' . $db->quoteName('title') . ') LIKE \'%' . $search . '%\' '; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $query[] = $where; $query[] = 'LIMIT ' . $pagination->limitstart . ',' . $pagination->limit; $query = implode(' ', $query); $db->setQuery($query); $data = $db->loadObjectList(); return $data; }
function getPostCount($id) { $db = EasyBlogHelper::db(); $query = 'SELECT COUNT(1) FROM #__easyblog_post ' . 'WHERE `created_by`=' . $db->Quote($id); $db->setQuery($query); return $db->loadResult(); }
function exists() { $db = EasyBlogHelper::db(); $query = 'SELECT COUNT(1) FROM #__easyblog_team_request ' . 'WHERE `team_id`=' . $db->Quote($this->team_id) . ' ' . 'AND `user_id`=' . $db->Quote($this->user_id) . ' ' . 'AND `ispending` = ' . $db->Quote('1'); $db->setQuery($query); return $db->loadResult() > 0 ? true : false; }
function getAllRuleItems() { $db = EasyBlogHelper::db(); $query = 'select * from `#__easyblog_category_acl_item` order by id'; $db->setQuery($query); return $db->loadObjectList(); }
function sendOnPageLoad($max = 5) { $db = EasyBlogHelper::db(); $config = EasyBlogHelper::getConfig(); $sendHTML = $config->get('main_mailqueuehtmlformat', 0); // Delete existing mails that has already been sent. $query = 'DELETE FROM ' . $db->nameQuote('#__easyblog_mailq') . ' WHERE ' . $db->nameQuote('status') . '=' . $db->Quote(1) . ' AND DATEDIFF(NOW(), `created`) >= 7'; $db->setQuery($query); $db->Query(); $query = 'SELECT `id` FROM `#__easyblog_mailq` WHERE `status` = 0'; $query .= ' ORDER BY `created` ASC'; $query .= ' LIMIT ' . $max; $db->setQuery($query); $result = $db->loadObjectList(); if (!empty($result)) { foreach ($result as $mail) { $mailq = EasyBlogHelper::getTable('MailQueue', 'Table'); $mailq->load($mail->id); // update the status to 1 == proccessed $mailq->status = 1; if ($mailq->store()) { // Send emails out. if (EasyBlogHelper::getJoomlaVersion() >= '3.0') { $mail = JFactory::getMailer(); $mail->sendMail($mailq->mailfrom, $mailq->fromname, $mailq->recipient, $mailq->subject, $mailq->body, $sendHTML); } else { JUtility::sendMail($mailq->mailfrom, $mailq->fromname, $mailq->recipient, $mailq->subject, $mailq->body, $sendHTML); } } } } }
function exists() { $db = EasyBlogHelper::db(); $query = 'SELECT COUNT(1) FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl) . ' ' . 'WHERE `team_id`=' . $db->Quote($this->team_id) . ' ' . 'AND `group_id`=' . $db->Quote($this->group_id); $db->setQuery($query); return $db->loadResult() > 0 ? true : false; }
/** * Detects where the system has been setup before */ public function isAssociated($type) { $db = EasyBlogHelper::db(); $query = 'SELECT COUNT(1) FROM ' . $db->nameQuote('#__easyblog_oauth') . ' ' . 'WHERE ' . $db->nameQuote('system') . '=' . $db->Quote(1) . ' ' . 'AND ' . $db->nameQuote('type') . '=' . $db->Quote($type) . ' ' . 'AND ' . $db->nameQuote('access_token') . ' !=""'; $db->setQuery($query); return $db->loadResult() > 0; }
protected function getInput() { if (!JFile::exists(JPATH_ROOT . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_easyblog' . DIRECTORY_SEPARATOR . 'constants.php')) { return JText::_('PLG_DJMEDIATOOLS_EASYBLOG_COMPONENT_DISABLED'); } require_once JPATH_ROOT . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_easyblog' . DIRECTORY_SEPARATOR . 'constants.php'; require_once EBLOG_HELPERS . DIRECTORY_SEPARATOR . 'helper.php'; $mainframe = JFactory::getApplication(); $db = EasyBlogHelper::db(); $doc = JFactory::getDocument(); JFactory::getLanguage()->load('com_easyblog', JPATH_ROOT); require_once JPATH_ROOT . DIRECTORY_SEPARATOR . 'administrator' . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_easyblog' . DIRECTORY_SEPARATOR . 'models' . DIRECTORY_SEPARATOR . 'categories.php'; $model = new EasyBlogModelCategories(); $categories = $model->getAllCategories(); if (!is_array($this->value)) { $this->value = array($this->value); } ob_start(); ?> <select name="<?php echo $this->name; ?> []" multiple="multiple" style="width:220px;height:200px;" class="<?php echo $this->element['class']; ?> "> <?php $selected = in_array('all', $this->value) ? ' selected="selected"' : ''; ?> <option value="all"<?php echo $selected; ?> ><?php echo JText::_('COM_EASYBLOG_ALL_CATEGORIES'); ?> </option> <?php foreach ($categories as $category) { $selected = in_array($category->id, $this->value) ? ' selected="selected"' : ''; ?> <option value="<?php echo $category->id; ?> "<?php echo $selected; ?> ><?php echo $category->title; ?> </option> <?php } ?> </select> <?php $html = ob_get_contents(); ob_end_clean(); return $html; }
function getCategoriesByBlogger($bloggerId) { $db = EasyBlogHelper::db(); $query = $this->_buildQueryByBlogger($bloggerId); $db->setQuery($query); $result = $this->_getList($query, $this->getState('limitstart'), $this->getState('limit')); return $result; }
public function getLanguageTitle($code) { $db = EasyBlogHelper::db(); $query = 'SELECT ' . EasyBlogHelper::getHelper('SQL')->nameQuote('title') . ' FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__languages') . ' WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('lang_code') . '=' . $db->Quote($code); $db->setQuery($query); $title = $db->loadResult(); return $title; }
public function loadByKey($key) { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . $db->nameQuote($this->_tbl) . ' WHERE ' . $db->nameQuote('key') . '=' . $db->Quote($key); $db->setQuery($query); $data = $db->loadObject(); return parent::bind($data); }
function _buildQueryWhere($userId) { $mainframe = JFactory::getApplication(); $db = EasyBlogHelper::db(); $where[] = 'a.' . EasyBlogHelper::getHelper('SQL')->nameQuote('user_id') . '=' . $db->Quote($userId); $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; return $where; }
public function getDescription($rule) { $db = EasyBlogHelper::db(); $query = 'SELECT ' . EasyBlogHelper::getHelper('SQL')->nameQuote('description') . ' ' . 'FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_acl') . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('action') . '=' . $db->Quote($rule); $db->setQuery($query); $description = $db->loadResult(); return $description; }
function loadBySource($postId, $key, $source) { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl) . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('uid') . '=' . $db->Quote($key) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('post_id') . '=' . $db->Quote($postId) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('source') . '=' . $db->Quote($source); $db->setQuery($query); $obj = $db->loadObject(); return parent::bind($obj); }
public function getRatingUsers($uid, $type, $limit = 5) { $db = EasyBlogHelper::db(); $query = 'SELECT COUNT(' . EasyBlogHelper::getHelper('SQL')->nameQuote('created_by') . ') AS times, ' . EasyBlogHelper::getHelper('SQL')->nameQuote('created_by') . ' , ' . EasyBlogHelper::getHelper('SQL')->nameQuote('created') . ' ' . 'FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_ratings') . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('uid') . ' = ' . $db->Quote($uid) . ' ' . 'AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('type') . ' = ' . $db->Quote($type) . ' ' . 'GROUP BY ' . EasyBlogHelper::getHelper('SQL')->nameQuote('created_by') . ' ' . 'LIMIT 0,' . $limit; $db->setQuery($query); $result = $db->loadObjectList(); return $result; }
public function nameQuote($str) { $db = EasyBlogHelper::db(); $version = EasyBlogHelper::getJoomlaVersion(); if ($version >= '2.5') { return $db->quoteName($str); } return $db->nameQuote($str); }
/** * Delete the outdated entries. */ function clear() { $db = EasyBlogHelper::db(); $date = EB::date(); $query = 'DELETE FROM `#__easyblog_captcha` WHERE `created` <= DATE_SUB( ' . $db->Quote($date->toMySQL()) . ', INTERVAL 12 HOUR )'; $db->setQuery($query); $db->query(); return true; }
/** * Method to build the query for the tags * * @access private * @return string */ function _buildQuery() { $db = EasyBlogHelper::db(); $query = 'select a.*, c.`title` from `#__easyblog_team_request` as a'; $query .= ' inner join `#__easyblog_team` as c on a.`team_id` = c.`id`'; $query .= ' where a.`ispending` = ' . $db->Quote('1'); $query .= ' ORDER BY `created`'; return $query; }
public function clear($draft_id) { // Delete any existing rejected messages $db = EasyBlogHelper::db(); $query = 'DELETE FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_post_rejected') . ' WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('draft_id') . '=' . $db->Quote($draft_id); $db->setQuery($query); $db->Query(); return true; }
function listBloggers() { $db = EasyBlogHelper::db(); $query = 'SELECT a.*, b.`name` FROM #__easyblog_users AS a, #__users AS b'; $query .= ' WHERE a.`id` = b.`id`'; $db->setQuery($query); $result = $db->loadObjectList(); return $result; }
function fetchElement($name, $value, &$node, $control_name) { require_once JPATH_ROOT . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_easyblog' . DIRECTORY_SEPARATOR . 'constants.php'; require_once EBLOG_HELPERS . DIRECTORY_SEPARATOR . 'helper.php'; $mainframe = JFactory::getApplication(); $db = EasyBlogHelper::db(); $doc = JFactory::getDocument(); require_once JPATH_ROOT . DIRECTORY_SEPARATOR . 'components' . DIRECTORY_SEPARATOR . 'com_easyblog' . DIRECTORY_SEPARATOR . 'constants.php'; // get only bloggers $query = 'SELECT a.`id`, a.`title` FROM ' . $db->nameQuote('#__easyblog_team') . ' AS a'; $query .= ' LEFT JOIN `#__easyblog_team_users` AS b ON a.`id` = b.`team_id` '; $query .= ' WHERE a.`published` = ' . $db->Quote('1'); $query .= ' ORDER BY a.`id` DESC'; $db->setQuery($query); $data = $db->loadObjectList(); ob_start(); ?> <select name="<?php echo $control_name; ?> [<?php echo $name; ?> ]"> <option value="0"<?php echo $value == 0 ? ' selected="selected"' : ''; ?> ><?php echo JText::_('Select a team'); ?> </option> <?php if (count($data) > 0) { foreach ($data as $team) { $selected = $team->id == $value ? ' selected="selected"' : ''; ?> <option value="<?php echo $team->id; ?> "<?php echo $selected; ?> ><?php echo '(' . $team->id . ') ' . $team->title; ?> </option> <?php } } ?> </select> <?php $html = ob_get_contents(); ob_end_clean(); return $html; }
public function load($path = null, $type = true) { $db = EasyBlogHelper::db(); $query = 'SELECT * FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote($this->_tbl); $query .= ' WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('path') . '=' . $db->Quote($path); $query .= ' AND ' . EasyBlogHelper::getHelper('SQL')->nameQuote('type') . '=' . $db->Quote($type); $db->setQuery($query); $obj = $db->loadObject(); return parent::bind($obj); }
function getCategoryName() { $db = EasyBlogHelper::db(); if (!empty($this->item_category)) { $query = 'SELECT `title` FROM `#__easyblog_category` WHERE `id` = ' . $db->Quote($this->item_category); $db->setQuery($query); return $db->loadResult(); } return ''; }
function isExists($feedid, $uid) { $db = EasyBlogHelper::db(); $query = 'select count(1) from `#__easyblog_feeds_history`'; $query .= ' where `feed_id` = ' . $db->Quote($feedid); $query .= ' and `uid` = ' . $db->Quote($uid); $db->setQuery($query); $result = $db->loadResult(); return empty($result) ? false : true; }
function addMember() { $db = EasyBlogHelper::db(); $query = 'INSERT INTO `#__easyblog_team_users` (`team_id`,`user_id`)'; $query .= ' VALUES ('; $query .= $db->Quote($this->team_id) . ', ' . $db->Quote($this->user_id); $query .= ')'; $db->setQuery($query); $db->query(); return true; }
function getArticleAuthors16() { $db = EasyBlogHelper::db(); $query = 'SELECT u.id AS created_by, u.name'; $query .= ' FROM `#__users` AS u'; $query .= ' INNER JOIN `#__content` AS c ON c.created_by = u.id'; $query .= ' GROUP BY u.id'; $query .= ' ORDER BY u.name'; $db->setQuery($query); return $db->loadObjectList(); }
function load($id = null, $loadPostId = false) { if (!$loadPostId) { return parent::load($id); } $db = EasyBlogHelper::db(); $query = 'select `id` from `#__easyblog_autoarticle_map` where `post_id` = ' . $db->Quote($id); $db->setQuery($query); $result = $db->loadResult(); return parent::load($result); }
function deletePostTag($blogId) { $db = EasyBlogHelper::db(); $query = ' DELETE FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_post_tag') . ' WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('post_id') . ' = ' . $db->quote($blogId); $db->setQuery($query); $result = $db->Query(); if ($db->getErrorNum()) { JError::raiseError(500, $db->stderr()); } return $result; }
function &_getParams($key = 'config') { static $params = null; if (is_null($params)) { $db = EasyBlogHelper::db(); $query = 'SELECT ' . EasyBlogHelper::getHelper('SQL')->nameQuote('params') . ' ' . 'FROM ' . EasyBlogHelper::getHelper('SQL')->nameQuote('#__easyblog_configs') . ' ' . 'WHERE ' . EasyBlogHelper::getHelper('SQL')->nameQuote('name') . '=' . $db->Quote($key); $db->setQuery($query); $params = $db->loadResult(); } return $params; }
public function purge() { JRequest::checkToken() or jexit('Invalid Token'); // @task: Check for acl rules. $this->checkAccess('mail'); $db = EasyBlogHelper::db(); $query = 'DELETE FROM ' . $db->nameQuote('#__easyblog_mailq'); $db->setQuery($query); $db->Query(); $this->setRedirect('index.php?option=com_easyblog&view=spools', JText::_('COM_EASYBLOG_MAILS_PURGED')); }