ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / sparklp6 / public_html / sparklerfilters-org / administrator / components / com_k2 / models

<?php
/**
 * @version 2.10.x
 * @package K2
 * @author JoomlaWorks https://www.joomlaworks.net
 * @copyright Copyright (c) 2006 - 2020 JoomlaWorks Ltd. All rights reserved.
 * @license GNU/GPL license: https://www.gnu.org/copyleft/gpl.html
 */

// no direct access
defined('_JEXEC') or die;

jimport('joomla.application.component.model');

JTable::addIncludePath(JPATH_COMPONENT.'/tables');

class K2ModelComments extends K2Model {

function getData() {
		$app = JFactory::getApplication();
		$params = JComponentHelper::getParams('com_k2');
		$option = JRequest::getCmd('option');
		$view = JRequest::getCmd('view');
		$db = JFactory::getDbo();
		$limit = $app->getUserStateFromRequest('global.list.limit', 'limit', $app->getCfg('list_limit'), 'int');
		$limitstart = $app->getUserStateFromRequest($option.$view.'.limitstart', 'limitstart', 0, 'int');
		$filter_order = $app->getUserStateFromRequest($option.$view.'filter_order', 'filter_order', 'c.id', 'cmd');
		$filter_order_Dir = $app->getUserStateFromRequest($option.$view.'filter_order_Dir', 'filter_order_Dir', 'DESC', 'word');
		$filter_state = $app->getUserStateFromRequest($option.$view.'filter_state', 'filter_state', -1, 'int');
		$filter_category = $app->getUserStateFromRequest($option.$view.'filter_category', 'filter_category', 0, 'int');
		$filter_author = $app->getUserStateFromRequest($option.$view.'filter_author', 'filter_author', 0, 'int');
		$search = $app->getUserStateFromRequest($option.$view.'search', 'search', '', 'string');
		$search = JString::strtolower($search);
		$search = trim(preg_replace('/[^\p{L}\p{N}\s\"\.\@\-_]/u', '', $search));

$query = "SELECT c.*, i.title , i.catid,  i.alias AS itemAlias, i.created_by,  cat.alias AS catAlias, cat.name as catName FROM #__k2_comments AS c LEFT JOIN #__k2_items AS i ON c.itemID=i.id LEFT JOIN #__k2_categories AS cat ON cat.id=i.catid LEFT JOIN #__k2_users AS u ON c.userID=u.userID WHERE c.id>0";

if ($filter_state > - 1) {
			$query .= " AND c.published={$filter_state}";
		}

if ($filter_category) {
			$query .= " AND i.catid={$filter_category}";
		}

if ($filter_author) {
			$query .= " AND i.created_by={$filter_author}";
		}

if ($search)
		{

// Detect exact search phrase using double quotes in search string
			if(substr($search, 0, 1)=='"' && substr($search, -1)=='"')
			{
				$exact = true;
			}
			else
			{
				$exact = false;
			}

// Now completely strip double quotes
			$search = trim(str_replace('"', '', $search));

// Escape remaining string
			$escaped = K2_JVERSION == '15' ? $db->getEscaped($search, true) : $db->escape($search, true);

// Full phrase or set of words
			if(strpos($escaped, ' ')!==false && !$exact)
			{
				$escaped=explode(' ', $escaped);
				$quoted = array();
				foreach($escaped as $key=>$escapedWord)
				{
					$quoted[] = $db->Quote('%'.$escapedWord.'%', false);
				}
				if ($params->get('adminSearch') == 'full')
				{
					foreach($quoted as $quotedWord)
					{
						$query .= " AND ( ".
							"LOWER(c.commentText) LIKE ".$quotedWord." ".
							"OR LOWER(c.userName) LIKE ".$quotedWord." ".
							"OR LOWER(c.commentEmail) LIKE ".$quotedWord." ".
							"OR LOWER(c.commentURL) LIKE ".$quotedWord." ".
							"OR LOWER(i.title) LIKE ".$quotedWord." ".
							"OR LOWER(u.userName) LIKE ".$quotedWord." ".
							"OR LOWER(u.ip) LIKE ".$quotedWord." ".
							" )";
					}
				}
				else
				{
					foreach($quoted as $quotedWord)
					{
						$query .= " AND LOWER(c.commentText) LIKE ".$quotedWord;
					}
				}
			}
			// Single word or exact phrase to search for (wrapped in double quotes in the search block)
			else
			{
				$quoted = $db->Quote('%'.$escaped.'%', false);

if ($params->get('adminSearch') == 'full')
				{
					$query .= " AND ( ".
						"LOWER(c.commentText) LIKE ".$quoted." ".
						"OR LOWER(c.userName) LIKE ".$quoted." ".
						"OR LOWER(c.commentEmail) LIKE ".$quoted." ".
						"OR LOWER(c.commentURL) LIKE ".$quoted." ".
						"OR LOWER(i.title) LIKE ".$quoted." ".
						"OR LOWER(u.userName) LIKE ".$quoted." ".
						"OR LOWER(u.ip) LIKE ".$quoted." ".
						" )";
				}
				else
				{
					$query .= " AND LOWER(c.commentText) LIKE ".$quoted;
				}
			}
		}

if (!$filter_order) {
			$filter_order = "c.commentDate";
		}

$query .= " ORDER BY {$filter_order} {$filter_order_Dir}";
		$db->setQuery($query, $limitstart, $limit);
		$rows = $db->loadObjectList();
		return $rows;
	}

function getTotal() {
		$app = JFactory::getApplication();
		$params = JComponentHelper::getParams('com_k2');
		$option = JRequest::getCmd('option');
		$view = JRequest::getCmd('view');
		$db = JFactory::getDbo();
		$limit = $app->getUserStateFromRequest('global.list.limit', 'limit', $app->getCfg('list_limit'), 'int');
		$limitstart = $app->getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');
		$filter_state = $app->getUserStateFromRequest($option.$view.'filter_state', 'filter_state', 1, 'int');
		$filter_category = $app->getUserStateFromRequest($option.$view.'filter_category', 'filter_category', 0, 'int');
		$filter_author = $app->getUserStateFromRequest($option.$view.'filter_author', 'filter_author', 0, 'int');
		$search = $app->getUserStateFromRequest($option.$view.'search', 'search', '', 'string');
		$search = JString::strtolower($search);
		$search = trim(preg_replace('/[^\p{L}\p{N}\s\"\.\@\-_]/u', '', $search));

$query = "SELECT COUNT(*) FROM #__k2_comments AS c LEFT JOIN #__k2_items AS i ON c.itemID=i.id LEFT JOIN #__k2_users AS u ON c.userID=u.userID WHERE c.id>0";

if ($filter_state > - 1) {
			$query .= " AND c.published={$filter_state}";
		}

if ($filter_category) {
			$query .= " AND i.catid={$filter_category}";
		}

if ($filter_author) {
			$query .= " AND i.created_by={$filter_author}";
		}

if ($search)
		{

// Detect exact search phrase using double quotes in search string
			if(substr($search, 0, 1)=='"' && substr($search, -1)=='"')
			{
				$exact = true;
			}
			else
			{
				$exact = false;
			}

// Now completely strip double quotes
			$search = trim(str_replace('"', '', $search));

// Escape remaining string
			$escaped = K2_JVERSION == '15' ? $db->getEscaped($search, true) : $db->escape($search, true);

function publish() {
		$app = JFactory::getApplication();
		$user = JFactory::getUser();
		$cid = JRequest::getVar('cid');
	    if(!count($cid)){
            $cid[]=JRequest::getInt('commentID');
        }

foreach ($cid as $id) {
			$row = JTable::getInstance('K2Comment', 'Table');
			$row->load($id);
			if($app->isSite()){
				$item = JTable::getInstance('K2Item', 'Table');
				$item->load($row->itemID);
				if ($item->created_by != $user->id) {
					JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
					$app->close();
				}
			}
			$row->published = 1;
			$row->store();
		}
		$cache = JFactory::getCache('com_k2');
		$cache->clean();
		if(JRequest::getCmd('format')=='raw'){
			echo 'true';
			$app->close();
		}
		if(JRequest::getCmd('context') == "modalselector"){
			$app->redirect('index.php?option=com_k2&view=comments&tmpl=component&context=modalselector');
		} else {
			$app->redirect('index.php?option=com_k2&view=comments');
		}
	}

$cache = JFactory::getCache('com_k2');
		$cache->clean();
		$app->enqueueMessage(JText::_('K2_DELETE_COMPLETED'));
		if(JRequest::getCmd('context') == "modalselector"){
			$app->redirect('index.php?option=com_k2&view=comments&tmpl=component&context=modalselector');
		} else {
			$app->redirect('index.php?option=com_k2&view=comments');
		}
	}

if($params->get('recaptchaV2'))
				{
					require_once JPATH_SITE.'/components/com_k2/helpers/utilities.php';
					if (!K2HelperUtilities::verifyRecaptcha())
					{
						$this->setError(JText::_('K2_COULD_NOT_VERIFY_THAT_YOU_ARE_NOT_A_ROBOT'));
						return false;
					}
				}
				else
				{
					if(!function_exists('_recaptcha_qsencode'))
					{
						require_once(JPATH_SITE.'/media/k2/assets/vendors/google/recaptcha_legacy/recaptcha.php');
					}
					$privatekey = $params->get('recaptcha_private_key');
					$resp = recaptcha_check_answer($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);
					if (!$resp->is_valid) {
						$this->setError(JText::_('K2_THE_WORDS_YOU_TYPED_DID_NOT_MATCH_THE_ONES_DISPLAYED_PLEASE_TRY_AGAIN'));
						return false;
					}
				}
		}

$app = JFactory::getApplication();
        $mail = JFactory::getMailer();
        $senderEmail = $app->getCfg('mailfrom');
        $senderName = $app->getCfg('fromname');

$mail->setSender(array($senderEmail, $senderName));
        $mail->setSubject(JText::_('K2_COMMENT_REPORT'));
        $mail->IsHTML(true);

switch(substr(strtoupper(PHP_OS), 0, 3)) {
            case 'WIN':
                $mail->LE = "\r\n";
                break;
            case 'MAC':
            case 'DAR':
                $mail->LE = "\r";
            default:
                break;
        }

// K2 embedded email template (to do: move to separate HTML template/override)
 $body = "
 ".JText::_('K2_NAME').": ".$name." 
 ".JText::_('K2_REPORT_REASON').": ".$reportReason." 
 ".JText::_('K2_COMMENT').": ".nl2br($row->commentText)." 
 ";

$mail->setBody($body);
        $mail->ClearAddresses();
        $mail->AddAddress($params->get('commentsReportRecipient', $app->getCfg('mailfrom')));
        $mail->Send();

return true;
    }
}

[-] item.php [edit]
[-] categories.php [edit]
[-] category.php [edit]
[-] tags.php [edit]
[-] usergroups.php [edit]
[-] item.xml [edit]
[-] users.php [edit]
[-] items.php [edit]
[-] comments.php [edit]
[-] tag.php [edit]
[-] usergroup.xml [edit]
[-] usergroup.php [edit]
[-] extrafield.php [edit]
[+] ..
[-] model.php [edit]
[-] extrafields.php [edit]
[-] user.php [edit]
[-] settings.php [edit]
[-] category.xml [edit]