public function purge()
{
$db = Komento::getDBO();
$query = 'DELETE FROM ' . $db->nameQuote('#__komento_mailq');
$db->setQuery($query);
$db->Query();
}
public function getEditorList($selected)
{
$db = Komento::getDBO();
// compile list of the editors
if (Komento::joomlaVersion() >= '1.6') {
$query = 'SELECT `element` AS value, `name` AS text' . ' FROM `#__extensions`' . ' WHERE `folder` = "editors"' . ' AND `type` = "plugin"' . ' AND `enabled` = 1' . ' ORDER BY ordering, name';
} else {
$query = 'SELECT element AS value, name AS text' . ' FROM #__plugins' . ' WHERE folder = "editors"' . ' AND published = 1' . ' ORDER BY ordering, name';
}
//echo $query;
$db->setQuery($query);
$editors = $db->loadObjectList();
if (count($editors) > 0) {
if (Komento::joomlaVersion() >= '1.6') {
$lang = JFactory::getLanguage();
for ($i = 0; $i < count($editors); $i++) {
$editor = $editors[$i];
$lang->load($editor->text . '.sys', JPATH_ADMINISTRATOR, null, false, false);
$editor->text = JText::_($editor->text);
}
}
}
// temporary. remove when wysiwyg editors are ready
$editors = array();
$bbcode = new stdClass();
$bbcode->value = 'bbcode';
$bbcode->text = JText::_('COM_KOMENTO_EDITOR_BBCODE');
$none = new stdClass();
$none->value = 'none';
$none->text = JText::_('COM_KOMENTO_EDITOR_NONE');
$editors[] = $bbcode;
$editors[] = $none;
return JHTML::_('select.genericlist', $editors, 'form_editor', 'class="inputbox" size="1"', 'value', 'text', $selected);
}
public function send( $max = 5 )
{
$konfig = Komento::getKonfig();
if( $konfig->get( 'disable_mailq' ) )
{
return false;
}
$db = Komento::getDBO();
$config = Komento::getConfig();
$sql = Komento::getSql();
$sql->select( '#__komento_mailq' )
->column( 'id' )
->where( 'status', 0 )
->order( 'created' )
->limit( $max );
$result = $sql->loadObjectList();
if(! empty($result))
{
foreach($result as $mail)
{
$mailq = Komento::getTable('mailq');
$mailq->load($mail->id);
$sendHTML = $mailq->type == 'html' ? 1 : 0;
$state = 0;
if( empty( $mailq->recipient ) )
{
$state = 1;
}
//send emails.
if( Komento::isJoomla15() )
{
$state = JUtility::sendMail($mailq->mailfrom, $mailq->fromname, $mailq->recipient, $mailq->subject, $mailq->body, $sendHTML);
}
else
{
$mail = JFactory::getMailer();
$state = $mail->sendMail($mailq->mailfrom, $mailq->fromname, $mailq->recipient, $mailq->subject, $mailq->body, $sendHTML);
}
if( $state )
{
// update the status to 1 == proccessed
$mailq->status = 1;
$mailq->store();
}
}
}
}
/**
* Delete the outdated entries.
*/
public function clear()
{
$db = Komento::getDBO();
$date = Komento::getDate();
$query = 'DELETE FROM ' . $db->nameQuote('#__komento_captcha') . ' WHERE ' . $db->nameQuote('created') . ' <= DATE_SUB( ' . $db->Quote($date->toMySQL()) . ', INTERVAL 12 HOUR )';
$db->setQuery($query);
$db->query();
return true;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT c.id, c.title, c.parent_id, c.title AS name, c.parent_id AS parent' . ' FROM #__categories AS c' . ' WHERE c.extension = ' . $db->quote(FLEXI_CAT_EXTENSION) . ' AND (c.lft > ' . $db->quote(FLEXI_LFT_CATEGORY) . ' AND c.rgt < ' . $db->quote(FLEXI_RGT_CATEGORY) . ') GROUP BY c.id ORDER BY c.lft ';
$db->setQuery($query);
$categories = $db->loadObjectList();
foreach ($categories as &$row) {
$repeat = $row->level - 1 >= 0 ? $row->level - 1 : 0;
$row->treename = str_repeat('.   ', $repeat) . ($row->level - 1 > 0 ? '|_ ' : '') . $row->title;
}
return $categories;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT `id`, `title`, `level`, `parent_id` FROM `CATEGORY_TABLE`';
$db->setQuery($query);
$categories = $db->loadObjectList();
// optional. populate tree listing
foreach ($categories as &$row) {
$repeat = $row->level - 1 >= 0 ? $row->level - 1 : 0;
$row->treename = str_repeat('.   ', $repeat) . ($row->level - 1 > 0 ? '|_ ' : '') . $row->title;
}
return $categories;
}
public function store($updateNulls = false)
{
$sql = Komento::getSql();
$sql->select('#__komento_configs')->column('1', '', 'count', true)->where('component', $this->component);
$exists = $sql->loadResult() > 0 ? true : false;
$data = new stdClass();
$data->component = $this->component;
$data->params = trim($this->params);
$database = Komento::getDBO();
if ($exists) {
return $database->updateObject('#__komento_configs', $data, 'component');
}
return $database->insertObject('#__komento_configs', $data);
}
function __construct()
{
$mainframe = JFactory::getApplication();
$db = Komento::getDBO();
$this->limit = $mainframe->getUserStateFromRequest('com_komento.reports.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
$this->limitstart = $mainframe->getUserStateFromRequest('com_komento.reports.limitstart', 'limitstart', 0, 'int');
$this->filter_publish = $mainframe->getUserStateFromRequest('com_komento.reports.filter_publish', 'filter_publish', '*', 'string');
$this->filter_component = $mainframe->getUserStateFromRequest('com_komento.reports.filter_component', 'filter_component', '*', 'string');
$this->order = $mainframe->getUserStateFromRequest('com_komento.reports.filter_order', 'filter_order', 'created', 'cmd');
$this->order_dir = $mainframe->getUserStateFromRequest('com_komento.reports.filter_order_Dir', 'filter_order_Dir', 'DESC', 'word');
$this->search = $mainframe->getUserStateFromRequest('com_komento.reports.search', 'search', '', 'string');
Komento::import('helper', 'string');
$this->search = KomentoStringHelper::escape(trim(JString::strtolower($this->search)));
parent::__construct();
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT c.category_id, cx.category_child_id, cx.category_child_id AS id, cx.category_parent_id,' . ' cx.category_parent_id AS parent_id, c.category_name, c.category_name AS title,' . ' c.category_description, c.published,ordering,' . ' c.category_name AS name, cx.category_parent_id AS parent' . ' FROM `#__redshop_category` AS c,' . ' `#__redshop_category_xref` AS cx' . ' WHERE c.category_id = cx.category_child_id' . ' ORDER BY c.ordering';
$db->setQuery($query);
$categories = $db->loadObjectList();
$children = array();
foreach ($categories as $row) {
$pt = $row->parent_id;
$list = @$children[$pt] ? $children[$pt] : array();
$list[] = $row;
$children[$pt] = $list;
}
$categories = JHTML::_('menu.treerecurse', 0, '', array(), $children, 9999, 0, 0);
return $categories;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT c.id, c.name AS title, c.parent AS parent_id, c.name, c.parent' . ' FROM `#__zoo_category` as c USE INDEX (APPLICATIONID_ID_INDEX)' . ' ORDER BY c.ordering';
$db->setQuery($query);
$categories = $db->loadObjectList();
$children = array();
foreach ($categories as $row) {
$pt = $row->parent_id;
$list = @$children[$pt] ? $children[$pt] : array();
$list[] = $row;
$children[$pt] = $list;
}
$categories = JHTML::_('menu.treerecurse', 0, '', array(), $children, 9999, 0, 0);
return $categories;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT a.id, a.name AS title, a.parent AS parent_id, a.name, a.parent' . ' FROM `#__k2_categories` AS a' . ' WHERE a.trash = 0' . ' ORDER BY a.ordering';
$db->setQuery($query);
$categories = $db->loadObjectList();
$children = array();
foreach ($categories as $row) {
$pt = $row->parent_id;
$list = @$children[$pt] ? $children[$pt] : array();
$list[] = $row;
$children[$pt] = $list;
}
$categories = JHTML::_('menu.treerecurse', 0, '', array(), $children, 9999, 0, 0);
return $categories;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT a.id, a.title, a.level, a.parent_id' . ' FROM `#__categories` AS a' . ' WHERE a.extension = ' . $db->quote('com_content') . ' AND a.parent_id > 0' . ' ORDER BY a.lft';
if (Komento::joomlaVersion() == '1.5') {
$query = 'SELECT a.id, a.title' . ' FROM `#__categories` AS a' . ' ORDER BY a.ordering';
}
$db->setQuery($query);
$categories = $db->loadObjectList();
if (Komento::joomlaVersion() >= '1.6') {
foreach ($categories as &$row) {
$repeat = $row->level - 1 >= 0 ? $row->level - 1 : 0;
$row->treename = str_repeat('.   ', $repeat) . ($row->level - 1 > 0 ? '|_ ' : '') . $row->title;
}
}
return $categories;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT a.`cat_id` AS `id`, a.`cat_name` AS `title` , a.`cat_parent` AS `parent_id`' . ' FROM `#__mt_cats` AS a' . ' ORDER BY a.`lft`';
$db->setQuery($query);
$categories = $db->loadObjectList();
$children = array();
foreach ($categories as $row) {
if ($row->parent_id != -1) {
$pt = $row->parent_id;
$list = @$children[$pt] ? $children[$pt] : array();
$list[] = $row;
$children[$pt] = $list;
}
}
$res = JHTML::_('menu.treerecurse', 0, '', array(), $children, 9999, 0, 0);
return $res;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT c.category_id AS id, cd.name, cd.name AS title, c.parent_id, c.parent_id AS parent' . ' FROM `#__aceshop_category` AS c,' . ' `#__aceshop_category_description` AS cd' . ' WHERE c.category_id = cd.category_id' . ' ORDER BY c.sort_order';
$db->setQuery($query);
$rows = $db->loadObjectList();
$categories = array();
if (count($rows)) {
$children = array();
foreach ($rows as $v) {
$pt = $v->parent_id;
$list = @$children[$pt] ? $children[$pt] : array();
array_push($list, $v);
$children[$pt] = $list;
}
$treelist = JHTML::_('menu.treerecurse', 0, '', array(), $children, 9999, 0, 0);
foreach ($treelist as &$row) {
$category->title = $row->treename;
$categories[] = $row;
}
}
return $categories;
}
public function onBeforeLoad($eventTrigger, $context, &$article, &$params, &$page, &$options)
{
// We got to go through 3 checks:
// 1. Check if POST parameter have id (this is when user go to an event page through event listings)
// 2. Check if page parameter have id (this is when user assign an event on a menu item)
// 3. Find back the id based on text parameter passed in (this was the old trigger before changing from onPrepareContent to onAfterDisplayContent for Joomla 1.5)
$cid = JRequest::getInt('id');
if (empty($cid)) {
$pageParameters = JFactory::getApplication()->getPageParameters();
$cid = $pageParameters->get('id');
}
if (empty($cid)) {
// Bad fallback due to limited data that is being passed in
// Use the description text to backtrace and search for the article id
$text = $article->text;
$text = str_ireplace('<!--{emailcloak=off}-->', '', $text);
$db = Komento::getDBO();
$query = 'SELECT ohanah_event_id FROM `#__ohanah_events` WHERE description = ' . $db->quote($text);
$db->setQuery($query);
$cid = $db->loadResult();
}
// If cid is still empty then we don't continue
if (empty($cid)) {
return false;
}
$article->id = $cid;
return true;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT a.id, a.title, a.parent_id, count(b.id) - 1 AS level'
. ' FROM `#__easyblog_category` AS a'
. ' INNER JOIN `#__easyblog_category` AS b ON a.lft BETWEEN b.lft and b.rgt'
. ' GROUP BY a.id'
. ' ORDER BY a.lft ASC';
$db->setQuery( $query );
$categories = $db->loadObjectList();
if( Komento::joomlaVersion() >= '1.6' )
{
foreach( $categories as &$row )
{
$repeat = ( $row->level - 1 >= 0 ) ? $row->level - 1 : 0;
$row->treename = str_repeat( '.   ', $repeat ) . ( $row->level - 1 > 0 ? '|_ ' : '' ) . $row->title;
}
}
return $categories;
}
public function getCategories()
{
$db = Komento::getDBO();
$query = 'SELECT id, name as title, parent as parent_id, parent, name' . ' FROM `#__sobipro_object`' . ' WHERE oType IN (' . $db->quote('category') . ',' . $db->quote('section') . ')';
$db->setQuery($query);
$categories = $db->loadObjectList();
$children = array();
foreach ($categories as $row) {
$pt = $row->parent_id;
$list = @$children[$pt] ? $children[$pt] : array();
$list[] = $row;
$children[$pt] = $list;
}
$categories = JHTML::_('menu.treerecurse', 0, '', array(), $children, 9999, 0, 0);
return $categories;
}
public static function clearCaptcha($days = '7')
{
$db = Komento::getDBO();
$query = 'DELETE FROM ' . $db->nameQuote('#__komento_captcha') . ' WHERE ' . $db->nameQuote('created') . ' <= DATE_SUB(NOW(), INTERVAL ' . $days . ' DAY)';
$db->setQuery($query);
$db->query();
return $query;
}
private function updateDepth($ids, $depth)
{
$db = Komento::getDBO();
$query = 'UPDATE ' . $db->nameQuote('#__komento_comments') . ' SET ' . $db->nameQuote('depth') . ' = ' . $db->quote($depth);
$query .= ' WHERE ' . $db->nameQuote('id') . ' IN(' . $db->quote($ids) . ')';
$db->setQuery($query);
$db->query();
}
function clearComments()
{
$db = Komento::getDBO();
$db->setQuery('DELETE FROM `#__komento_comments` WHERE `component` = ' . $db->quote('com_easyblog'));
$db->query();
$this->ajax->success();
$this->ajax->send();
}
public function getCategoryId()
{
$db = Komento::getDBO();
$query = 'SELECT `virtuemart_category_id` FROM `#__virtuemart_product_categories` WHERE `virtuemart_product_id` = ' . $db->quote($this->getContentId());
$db->setQuery($query);
$productCategory = $db->loadResult();
return $productCategory;
}
public function clear()
{
$db = Komento::getDBO();
$query = 'SELECT * FROM ' . $db->nameQuote( '#__komento_captcha' ) . ' WHERE ' . $db->nameQuote( 'created' ) . ' <= DATE_SUB(NOW(), INTERVAL 7 DAY)';
$db->setQuery( $query );
$db->query();
}
function isIndexKeyExists( $tableName, $indexName )
{
$db = Komento::getDBO();
$query = 'SHOW INDEX FROM ' . $db->nameQuote( $tableName );
$db->setQuery( $query );
$indexes = $db->loadObjectList();
$result = array();
foreach( $indexes as $index )
{
$result[ $index->Key_name ] = preg_replace( '/[(0-9)]/' , '' , $index->Column_name );
}
if( array_key_exists($indexName, $result) )
{
return true;
}
return false;
}
public function debug()
{
$table = JRequest::getString('table');
$tablename = '#__' . $table;
$db = Komento::getDBO();
$db->setQuery('show columns from ' . $db->nameQuote($tablename));
$result = $db->loadObjectList();
$html = '<table><tr>';
foreach ($result as $row) {
$html .= '<td>' . $row->Field . '</td>';
}
$html .= '</tr>';
$db->setQuery('select * from ' . $db->nameQuote($tablename) . ' order by id');
$result = $db->loadObjectList();
foreach ($result as $row) {
$html .= '<tr>';
foreach ($row as $key => $value) {
$html .= '<td>' . $value . '</td>';
}
$html .= '</tr>';
}
$html .= '</table>';
echo $html;
exit;
}
function __construct()
{
$this->_db = Komento::getDBO();
}
function removeActions( $userId )
{
$db = Komento::getDBO();
$query = 'DELETE FROM ' . $db->nameQuote( '#__komento_actions' );
$query .= ' WHERE ' . $db->nameQuote( 'action_by' ) . ' = ' . $db->quote( $userId );
$db->setQuery( $query );
$db->query();
if($db->getErrorNum())
{
JError::raiseError( 500, $db->stderr());
}
}
public function getCategoryId()
{
$db = Komento::getDBO();
$query = 'SELECT ' . $db->nameQuote('category_id') . ' FROM ' . $db->nameQuote('#__hwdms_category_map') . ' WHERE ' . $db->nameQuote('element_id') . ' = ' . $db->quote($this->_item->id);
$db->setQuery($query);
$result = $db->loadResult();
if (count($result) > 0) {
return $result;
}
return true;
}
