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'));
}
