function _installfix()
{
// Load fields model
App::import('Model', 'field', 'jreviews');
$FieldModel = new FieldModel();
$task = Sanitize::getString($this->data, 'task');
$msg = '';
$mambot_error = 0;
switch ($task) {
case 'fix_install_jreviews':
if (!$this->_installPlugin()) {
$msg = "There was a problem updating the database or copying the plugin files. Make sure the Joomla plugins/content folder is writable.";
}
break;
case 'fix_content_fields':
$output = '';
$rows = $this->_db->getTableFields(array('#__jreviews_content'));
$columns = array_keys($rows['#__jreviews_content']);
$sql = "SELECT name,type FROM #__jreviews_fields WHERE location = 'content'";
$this->_db->setQuery($sql);
$fields = $this->_db->loadObjectList('name');
$missing = array();
foreach ($fields as $field) {
if (!in_array($field->name, $columns)) {
$output = $FieldModel->addTableColumn($field->name, $field->type, 'content');
}
}
$query = "DELETE FROM #__jreviews_fields WHERE name = ''";
$this->_db->setQuery($query);
$output = $this->_db->query();
if ($output != '') {
$msg = "There was a problem fixing one or more of the content fields";
}
break;
case 'fix_review_fields':
$output = '';
$rows = $this->_db->getTableFields(array('#__jreviews_review_fields'));
$columns = array_keys($rows['#__jreviews_review_fields']);
$sql = "SELECT name,type FROM #__jreviews_fields WHERE location = 'review'";
$this->_db->setQuery($sql);
$fields = $this->_db->loadObjectList('name');
$missing = array();
foreach ($fields as $field) {
if (!in_array($field->name, $columns)) {
$output = $FieldModel->addTableColumn($field->name, $field->type, 'review');
}
}
$query = "DELETE FROM #__jreviews_fields WHERE name = ''";
$this->_db->setQuery($query);
$output = $this->_db->query();
if ($output != '') {
$msg = "There was a problem fixing one or more of the review fields";
}
break;
default:
break;
}
cmsFramework::redirect("index.php?option=com_jreviews", $msg);
}
$menu_id = $menu_id == 99999999 ? null : $menu_id;
$menu_params = array();
# Check if this is a custom route
$route['url']['url'] = $url;
$route = S2Router::parse($route, false, 'jreviews');
/*******************************************************************
* ADMIN ROUTING
******************************************************************/
if (defined('MVC_FRAMEWORK_ADMIN')) {
// Ensure user has access to this function
switch (getCmsVersion()) {
case 'CMS_JOOMLA15':
$User =& cmsFramework::getUser();
$Acl =& cmsFramework::getACL();
if ($Acl->acl_check('administration', 'manage', 'users', $User->usertype, 'components', S2Paths::get('jreviews', 'S2_CMSCOMP'))) {
cmsFramework::redirect('index.php', JText::_('ALERTNOTAUTH'));
}
break;
case 'CMS_JOOMLA16':
if (!JFactory::getUser()->authorise('core.manage', S2Paths::get('jreviews', 'S2_CMSCOMP'))) {
return JError::raiseWarning(404, JText::_('JERROR_ALERTNOAUTHOR'));
}
break;
default:
die('Not authorized');
break;
}
// Controller routing
$act = Sanitize::getString($_REQUEST, 'act');
if ($act == 'license') {
$_GET['url'] = 'license';
function _process()
{
$urlSeparator = "_";
$simple_search = Sanitize::getInt($this->data, 'simple_search');
$keywords = Sanitize::getVar($this->data, 'keywords');
$criteria = isset($this->data['Search']) ? Sanitize::getInt($this->data['Search'], 'criteria_id') : null;
$dir = str_replace(array(',', ' '), array($urlSeparator, ''), Sanitize::getString($this->data, 'dir'));
$cat = str_replace(array(',', ' '), array($urlSeparator, ''), Sanitize::getString($this->data, 'cat'));
$section = str_replace(array(',', ' '), array($urlSeparator, ''), Sanitize::getString($this->data, 'section'));
/*J15*/
$order = Sanitize::getVar($this->data, 'order');
$query_type = Sanitize::getVar($this->data, 'search_query_type');
$scope = Sanitize::getVar($this->data, 'contentoptions');
$author = Sanitize::getString($this->data, 'author');
$categories = Sanitize::getVar($this->data, 'categories');
$menu_id = Sanitize::getInt($this->data, 'menu_id');
$tmpl_suffix = Sanitize::getString($this->data, 'tmpl_suffix');
$illegal_chars = array('#', '/', '?', ':', urldecode('%E3%80%80'));
// Last one is japanese double space
$sort = '';
# Load Routes helper
App::import('Helper', 'routes', 'jreviews');
$Routes = new RoutesHelper();
// Replace ampersands with temp string to be replaced back as urlencoded ampersand further below
$keywords = str_replace(array_keys($this->KeywordReplacementMask), array_values($this->KeywordReplacementMask), $keywords);
# Get the Itemid
$menu_id_param = $menu_id > 0 ? $menu_id : '';
$url_params = '';
# SIMPLE SEARCH
if ($simple_search) {
# Build the query string
if (trim($keywords) != '') {
$url_params .= (cmsFramework::mosCmsSef() ? '' : '/') . 'keywords' . _PARAM_CHAR . str_replace(' ', '+', urlencode(str_replace($illegal_chars, ' ', $keywords)));
}
!empty($dir) and $url_params .= "/dir" . _PARAM_CHAR . $dir;
!empty($section) and $url_params .= "/cat" . _PARAM_CHAR . 's' . $section;
/*J15*/
!empty($cat) and $url_params .= "/cat" . _PARAM_CHAR . $cat;
!empty($tmpl_suffix) and $url_params .= '/tmpl_suffix' . _PARAM_CHAR . $tmpl_suffix;
!empty($order) and $sort = '/order' . _PARAM_CHAR . $order;
# Checks if need to keep the Itemid on the result page
if ($this->Config->search_itemid && $menu_id) {
$url = $Routes->search_results($menu_id_param, '');
} else {
$url = $Routes->search_results(null, '');
}
$url = cmsFramework::route($url . $url_params . $sort);
$url = str_replace(array_keys($this->KeywordReplacementUrl), array_values($this->KeywordReplacementUrl), $url);
cmsFramework::redirect($url);
exit;
}
# ADVANCED SEARCH
$url_params = array();
$criteria_param = $criteria ? (cmsFramework::mosCmsSef() ? '' : '/') . 'criteria:' . $criteria : '';
// Search query type
!empty($query_type) and $url_params[] = "query" . _PARAM_CHAR . $query_type;
!empty($dir) != '' and $url_params[] = "dir" . _PARAM_CHAR . $dir;
// Listing and reviews
if ($keywords) {
if ($scope) {
$url_params[] = "scope" . _PARAM_CHAR . urlencode(implode($urlSeparator, $scope));
}
$url_params[] = "keywords" . _PARAM_CHAR . urlencode(str_replace($illegal_chars, ' ', $keywords));
}
// Author
!empty($author) and $url_params[] = "author" . _PARAM_CHAR . urlencode($author);
// Categories
if (is_array($categories)) {
// Remove empty values from array
foreach ($categories as $index => $value) {
if (empty($value)) {
unset($categories[$index]);
}
}
if (!empty($categories)) {
$cat = urlencode(implode($urlSeparator, $categories));
!empty($cat) and $url_params[] = "cat" . _PARAM_CHAR . $cat;
}
} elseif ($categories != '') {
// Single select category list
!empty($categories) and $url_params[] = "cat" . _PARAM_CHAR . $categories;
}
// First pass to process numeric values, need to merge operator and operand into one parameter
if (isset($this->data['Field'])) {
foreach ($this->data['Field']['Listing'] as $key => $value) {
if (substr($key, -9, 9) == '_operator') {
$operand = substr($key, 0, -9);
if (is_array($this->data['Field']['Listing'][$operand]) && is_numeric($this->data['Field']['Listing'][$operand][0]) || is_numeric($this->data['Field']['Listing'][$operand])) {
$this->data['Field']['Listing'][$operand] = $value . $urlSeparator . trim(implode('_', $this->data['Field']['Listing'][$operand]));
} elseif (is_array($this->data['Field']['Listing'][$operand]) && trim($this->data['Field']['Listing'][$operand][0]) != '' || !is_array($this->data['Field']['Listing'][$operand]) && trim($this->data['Field']['Listing'][$operand]) != '') {
// Assume it's a date field
$this->data['Field']['Listing'][$operand] = $value . $urlSeparator . "date_" . implode('_', $this->data['Field']['Listing'][$operand]);
} else {
$this->data['Field']['Listing'][$operand] = '';
}
// Remove trailing separator char
$this->data['Field']['Listing'][$operand] = rtrim($this->data['Field']['Listing'][$operand], $urlSeparator);
}
}
// Second pass to process everything
foreach ($this->data['Field']['Listing'] as $key => $value) {
$key_parts = explode("_", $key);
$imploded_value = '';
if (substr($key, 0, 3) == "jr_" && substr($key, -9, 9) != '_operator' && @$key_parts[2] != 'reset') {
// multiple option field
if (is_array($value)) {
if (is_array($value[0]) && !empty($value[0])) {
$imploded_value = implode($urlSeparator, $value[0]);
} elseif (!is_array($value[0]) && implode('', $value) != '') {
$imploded_value = implode($urlSeparator, $value);
}
if ($key != '' && $imploded_value != '') {
$url_params[] = "{$key}" . _PARAM_CHAR . urlencode(trim($imploded_value));
}
// single option field
} elseif (!is_array($value) && trim($value) != '') {
$url_params[] = "{$key}" . _PARAM_CHAR . urlencode(trim($value));
}
}
}
}
// End isset $this->Data['Field']
!empty($tmpl_suffix) and $url_params[] = 'tmpl_suffix' . _PARAM_CHAR . $tmpl_suffix;
$url_params[] = "order" . _PARAM_CHAR . ($order ? $order : $this->Config->list_order_default);
# Remove empty values from array
foreach ($url_params as $index => $value) {
if (empty($value)) {
unset($url_params[$index]);
}
}
$url_params = (cmsFramework::mosCmsSef() ? '' : '/') . implode('/', $url_params);
# Uncomment this line and comment the one below to keep the Itemid on the result page
if ($this->Config->search_itemid && $menu_id) {
$url = $Routes->search_results($menu_id_param, '');
} else {
$url = $Routes->search_results(null, '');
}
// Params outside route function because it messes up the urlencoding
$url = cmsFramework::route($url . $criteria_param . $url_params);
$url = str_replace(array_keys($this->KeywordReplacementUrl), array_values($this->KeywordReplacementUrl), $url);
cmsFramework::redirect($url);
}
function listings()
{
if (Sanitize::getString($this->params, 'action') == 'xml') {
$access = $this->cmsVersion == CMS_JOOMLA15 ? $this->Access->getAccessId() : $this->Access->getAccessLevels();
$feed_filename = PATH_ROOT . 'cache' . DS . 'jreviewsfeed_' . md5($access . $this->here) . '.xml';
$this->Feeds->useCached($feed_filename, 'listings');
}
$this->name = 'categories';
// Required for assets helper
if ($this->_user->id === 0 && ($this->action != 'search' || $this->action == 'search' && Sanitize::getVar($this->params, 'tag') != '')) {
$this->cacheAction = Configure::read('Cache.expires');
}
$this->autoRender = false;
$action = Sanitize::paranoid($this->action);
$dir_id = str_replace(array('_', ' '), array(',', ''), Sanitize::getString($this->params, 'dir'));
$section_id = Sanitize::getString($this->params, 'section');
$cat_id = Sanitize::getString($this->params, 'cat');
$criteria_id = Sanitize::getString($this->params, 'criteria');
$user_id = Sanitize::getInt($this->params, 'user', $this->_user->id);
$index = Sanitize::getString($this->params, 'index');
$sort = Sanitize::getString($this->params, 'order');
if ($sort == '' && in_array($this->action, array('category', 'section', 'alphaindex', 'search', 'custom'))) {
$sort = Sanitize::getString($this->Config, 'list_order_field');
}
$sort == '' and $sort = Sanitize::getString($this->Config, 'list_order_default');
$menu_id = Sanitize::getInt($this->params, 'menu', Sanitize::getString($this->params, 'Itemid'));
// Avoid running the listing query if in section page and listings disabled
$query_listings = $this->action != 'section' || $this->action == 'section' && $this->Config->list_show_sectionlist;
$total_special = Sanitize::getInt($this->data, 'total_special');
if (!in_array($this->action, array('section', 'category')) && $total_special > 0) {
$total_special <= $this->limit and $this->limit = $total_special;
}
$listings = array();
$parent_categories = array();
$count = 0;
$conditions = array();
$joins = array();
if ($action == 'category') {
// Find directory and section id
if ($this->cmsVersion == CMS_JOOMLA15 && ($category = $this->Category->findRow(array('conditions' => array('Category.id = ' . $cat_id))))) {
$dir_id = $this->params['dir'] = $category['Category']['dir_id'];
$section_id = $this->params['section'] = $category['Category']['section_id'];
} elseif ($parent_categories = $this->Category->findParents($cat_id)) {
$category = end($parent_categories);
// This is the current category
if (!$category['Category']['published'] || !$this->Access->isAuthorized($category['Category']['access'])) {
echo $this->render('elements', 'login');
return;
}
$dir_id = $this->params['dir'] = $category['Directory']['dir_id'];
$categories = $this->Category->findTree(array('cat_id' => $cat_id));
}
# Override global configuration
isset($category['ListingType']) and $this->Config->override($category['ListingType']['config']);
$sort = Sanitize::getString($this->params, 'order', Sanitize::getString($this->Config, 'list_order_field'));
$sort == '' and $sort = Sanitize::getString($this->Config, 'list_order_default');
}
# Remove unnecessary fields from model query
$this->Listing->modelUnbind('Listing.fulltext AS `Listing.description`');
# Get section and category database information
if ($this->cmsVersion == CMS_JOOMLA15 && in_array($action, array('section', 'category'))) {
$fields = array();
# Get all categories for page
if ($this->Config->dir_cat_num_entries || $this->Config->dir_category_hide_empty) {
$fields = array('
(SELECT
count(*)
FROM #__content AS Listing
INNER JOIN #__jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = "com_content"
WHERE
Listing.sectionid = ' . $section_id . '
AND Listing.catid = Category.id
AND Listing.state = 1
AND Listing.access <= ' . $this->Access->getAccessId() . '
AND ( Listing.publish_up = "' . NULL_DATE . '" OR Listing.publish_up <= "' . _CURRENT_SERVER_TIME . '" )
AND ( Listing.publish_down = "' . NULL_DATE . '" OR Listing.publish_down >= "' . _CURRENT_SERVER_TIME . '" )
) AS `Category.listing_count`
');
}
$categories = $this->Category->findAll(array('fields' => $fields, 'conditions' => array('Category.section = ' . (int) $section_id, 'Category.published = 1'), 'order' => $this->Config->dir_category_order ? 'Category.title ASC' : 'Category.ordering ASC'));
$category_tmp = current($categories);
$dir_id = $category_tmp['Category']['dir_id'];
$section = $this->Section->findRow(array('fields' => array((int) $dir_id . ' AS `Section.dir_id`'), 'conditions' => array('Section.id = ' . (int) $section_id)));
# Fake the parent_categories array based on section and category
isset($section) and $parent_categories[]['Category'] = $section['Section'];
isset($category) and $parent_categories[]['Category'] = $category['Category'];
}
# Set the theme layout and suffix
$this->Theming->setSuffix(array('categories' => $parent_categories));
$this->Theming->setLayout(array('categories' => $parent_categories));
if (isset($section) && !empty($section) && (!$this->Access->isAuthorized($section['Section']['access']) || !$section['Section']['published']) || $this->action == 'category' && isset($category) && !empty($category) && (!$this->Access->isAuthorized($category['Category']['access']) || !$category['Category']['published'])) {
echo $this->render('elements', 'login');
return;
}
# Get listings
# Modify and perform database query based on lisPage type
if ($action == 'section' && $this->Config->list_show_sectionlist || $action != 'section') {
// Build where statement
switch ($action) {
case 'alphaindex':
// $index = isset($index{0}) ? $index{0} : '';
$conditions[] = $index == '0' ? 'Listing.title REGEXP "^[0-9]"' : 'Listing.title LIKE ' . $this->quote($index . '%');
break;
}
$section_id = cleanIntegerCommaList($section_id);
$cat_id = cleanIntegerCommaList($cat_id);
$dir_id = cleanIntegerCommaList($dir_id);
$criteria_id = cleanIntegerCommaList($criteria_id);
if (!empty($cat_id)) {
if ($this->cmsVersion == CMS_JOOMLA15 || $this->cmsVersion != CMS_JOOMLA15 && !$this->Config->list_show_child_listings) {
if ($this->cmsVersion != CMS_JOOMLA15) {
$conditions[] = 'ParentCategory.id IN (' . $cat_id . ')';
}
$conditions[] = 'Category.id IN (' . $cat_id . ')';
// Exclude listings from child categories
} else {
$conditions[] = 'ParentCategory.id IN (' . $cat_id . ')';
}
} else {
unset($this->Listing->joins['ParentCategory']);
}
empty($cat_id) and !empty($section_id) and $conditions[] = 'Listing.sectionid IN (' . $section_id . ')';
empty($cat_id) and !empty($dir_id) and $conditions[] = 'JreviewsCategory.dirid IN (' . $dir_id . ')';
empty($cat_id) and !empty($criteria_id) and $conditions[] = 'JreviewsCategory.criteriaid IN (' . $criteria_id . ')';
if ($this->action == 'mylistings' && $user_id == $this->_user->id || $this->Access->isPublisher()) {
$conditions[] = 'Listing.state >= 0';
} else {
$conditions[] = 'Listing.state = 1';
$conditions[] = '( Listing.publish_up = "' . NULL_DATE . '" OR Listing.publish_up <= "' . _CURRENT_SERVER_TIME . '" )';
$conditions[] = '( Listing.publish_down = "' . NULL_DATE . '" OR Listing.publish_down >= "' . _CURRENT_SERVER_TIME . '" )';
}
# Shows only links users can access
if ($this->cmsVersion == CMS_JOOMLA15) {
// $conditions[] = 'Section.access <= ' . $this->Access->getAccessId();
$conditions[] = 'Category.access <= ' . $this->Access->getAccessId();
$conditions[] = 'Listing.access <= ' . $this->Access->getAccessId();
} else {
$conditions[] = 'Category.access IN ( ' . $this->Access->getAccessLevels() . ')';
$conditions[] = 'Listing.access IN ( ' . $this->Access->getAccessLevels() . ')';
}
$queryData = array('joins' => $joins, 'conditions' => $conditions, 'limit' => $this->limit, 'offset' => $this->offset);
# Modify query for correct ordering. Change FIELDS, ORDER BY and HAVING BY directly in Listing Model variables
if ($this->action != 'custom' || $this->action == 'custom' && empty($this->Listing->order)) {
$this->Listing->processSorting($action, $sort);
}
// This is used in Listings model to know whether this is a list page to remove the plugin tags
$this->Listing->controller = 'categories';
// Check if review scope checked in advancd search
$scope = explode('_', Sanitize::getString($this->params, 'scope'));
if ($this->action == 'search' && in_array('reviews', $scope)) {
$queryData['joins'][] = "LEFT JOIN #__jreviews_comments AS Review ON Listing.id = Review.pid AND Review.published = 1 AND Review.mode = 'com_content'";
$queryData['group'][] = "Listing.id";
// Group By required due to one to many relationship between listings => reviews table
}
$query_listings and $listings = $this->Listing->findAll($queryData);
# If only one result then redirect to it
if ($this->Config->search_one_result && count($listings) == 1 && $this->action == 'search' && $this->page == 1) {
$listing = array_shift($listings);
$url = cmsFramework::makeAbsUrl($listing['Listing']['url'], array('sef' => true));
cmsFramework::redirect($url);
}
# Get the listing count
if (in_array($action, array('section', 'category'))) {
unset($queryData['joins']);
$this->Listing->joins = array("INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content'", 'Category' => "LEFT JOIN #__categories AS Category ON JreviewsCategory.id = Category.id", 'ParentCategory' => "LEFT JOIN #__categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt", "LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content'", "LEFT JOIN #__jreviews_content AS Field ON Field.contentid = Listing.id", "LEFT JOIN #__jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id");
} elseif ($action != 'favorites') {
unset($queryData['joins']);
$this->Listing->joins = array("INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content'", 'Category' => "LEFT JOIN #__categories AS Category ON JreviewsCategory.id = Category.id", 'ParentCategory' => "LEFT JOIN #__categories AS ParentCategory ON Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt", "LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content'", "LEFT JOIN #__jreviews_content AS Field ON Field.contentid = Listing.id", "LEFT JOIN #__jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id");
if ($this->action == 'search' && in_array('reviews', $scope)) {
$queryData['joins'][] = "LEFT JOIN #__jreviews_comments AS Review ON Listing.id = Review.pid AND Review.published = 1 AND Review.mode = 'com_content'";
}
}
if ($this->cmsVersion == CMS_JOOMLA15 || empty($cat_id)) {
unset($this->Listing->joins['ParentCategory']);
// Exclude listings from child categories
}
// Need to add user table join for author searches
if (isset($this->params['author'])) {
$queryData['joins'][] = "LEFT JOIN #__users AS User ON User.id = Listing.created_by";
}
if ($query_listings && !isset($this->Listing->count)) {
$count = $this->Listing->findCount($queryData, $this->action == 'search' && in_array('reviews', $scope) ? 'DISTINCT Listing.id' : '*');
} else {
$count = $this->Listing->count;
}
if ($total_special > 0 && $total_special < $count) {
$count = Sanitize::getInt($this->data, 'total_special');
}
}
# Get directory info for breadcrumb if dir id is a url parameter
$directory = array();
if (is_numeric($dir_id)) {
$directory = $this->Directory->findRow(array('fields' => array('Directory.id AS `Directory.dir_id`', 'Directory.title AS `Directory.slug`', 'Directory.desc AS `Directory.title`'), 'conditions' => array('Directory.id = ' . $dir_id)));
}
/******************************************************************
* Process page title and description
*******************************************************************/
$name_choice = $this->Config->name_choice == 'alias' ? 'username' : 'name';
$page['show_title'] = 1;
$page['show_description'] = 1;
switch ($action) {
case 'section':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page = $section['Section'];
$page['title'] = trim(Sanitize::getString($menuParams, 'title')) != '' ? Sanitize::getString($menuParams, 'title') : $section['Section']['title'];
$page['show_title'] = Sanitize::getInt($this->data, 'dirtitle', 1);
$page['show_description'] = 1;
break;
case 'category':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page = $category['Category'];
$page['title'] = trim(Sanitize::getString($menuParams, 'title')) != '' ? Sanitize::getString($menuParams, 'title') : $category['Category']['title'];
$page['show_title'] = Sanitize::getInt($this->data, 'dirtitle', 1);
$page['show_description'] = 1;
Sanitize::getString($category['Category'], 'metadesc') == '' and $page['metadesc'] = Sanitize::htmlClean($category['Category']['description']);
# Check if this is a listing submit category or disable listing submissions
if (Sanitize::getInt($category['Category'], 'criteria_id') == 0) {
$this->Config->list_show_addnew = 0;
}
break;
case 'custom':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page['top_description'] = Sanitize::getString($menuParams, 'custom_description');
$page['top_description'] = str_replace('\\n', '', $page['top_description']);
$page['show_description'] = $page['top_description'] != '';
$page['show_title'] = Sanitize::getInt($menuParams, 'dirtitle');
$page['title'] = Sanitize::getString($menuParams, 'title');
if (!$page['title']) {
$page['title'] = $this->Menu->getMenuName($menu_id);
}
break;
case 'alphaindex':
$title = isset($directory['Directory']) ? Sanitize::getString($directory['Directory'], 'title', '') : '';
$page['title'] = $title != '' ? $title . ' - ' . ($index == '0' ? '0-9' : $index) : ($index == '0' ? '0-9' : $index);
break;
case 'mylistings':
if ($user_id > 0) {
$user_name = $this->User->findOne(array('fields' => array('User.' . $name_choice . ' AS `User.name`'), 'conditions' => array('User.id = ' . $user_id)));
} elseif ($this->_user->id > 0) {
$user_name = $this->_user->{$name_choice};
}
$page['title'] = sprintf(__t("Listings by %s", true), $user_name);
break;
case 'favorites':
// Not running from CB Plugin so we change the page title
if (!isset($this->Config->in_cb)) {
if ($user_id > 0) {
$user_name = $this->User->findOne(array('fields' => array('User.' . $name_choice . ' AS `User.name`'), 'conditions' => array('User.id = ' . $user_id)));
} elseif ($this->_user->id > 0) {
$user_name = $this->_user->{$name_choice};
}
$page['title'] = sprintf(__t("Favorites by %s", true), $user_name);
}
break;
case 'list':
case 'search':
$this->__seo_fields($page);
break;
case 'featured':
case 'latest':
case 'mostreviews':
case 'popular':
case 'toprated':
case 'topratededitor':
$menuParams = $this->Menu->getMenuParams($menu_id);
$page['show_title'] = Sanitize::getInt($menuParams, 'dirtitle');
$page['title'] = Sanitize::getString($menuParams, 'title');
if (!$page['title'] && isset($this->Menu->menues[$menu_id])) {
$page['title'] = $this->Menu->menues[$menu_id]->name;
}
break;
default:
$page['title'] = $this->Menu->getMenuName($menu_id);
break;
}
// If empty unset the keys so they don't overwrite the ones set via menu
if (trim(strip_tags(Sanitize::getString($page, 'description'))) == '') {
unset($page['description']);
}
if (trim(strip_tags(Sanitize::getString($page, 'keywords'))) == '') {
unset($page['keywords']);
}
/******************************************************************
* Generate SEO titles for re-ordered pages (most reviews, top user rated, etc.)
*******************************************************************/
# Category ids to be used for ordering list
$cat_ids = array();
if (in_array($action, array('search', 'category'))) {
$cat_ids = $cat_id;
} elseif (!empty($categories)) {
$cat_ids = implode(',', array_keys($categories));
}
$field_order_array = $this->Field->getOrderList($cat_ids, 'listing', $this->action, array('section', 'category', 'search', 'alphaindex'));
isset($page['title']) and $page['title_seo'] = $page['title'];
if (($this->action != 'search' || Sanitize::getVar($this->params, 'tag')) && isset($this->params['order']) && $sort != '') {
App::import('helper', 'jreviews', 'jreviews');
$ordering_options = JreviewsHelper::orderingOptions();
$tmp_order = str_replace('rjr', 'jr', $sort);
if (isset($ordering_options[$sort])) {
$page['title_seo'] .= ' ' . sprintf(__t("ordered by %s", true), mb_strtolower($ordering_options[$sort], 'UTF-8'));
} elseif (isset($field_order_array[$tmp_order])) {
if ($sort[0] == 'r') {
$page['title_seo'] .= ' ' . sprintf(__t("ordered by %s desc", true), mb_strtolower($field_order_array[$tmp_order]['text'], 'UTF-8'));
} else {
$page['title_seo'] .= ' ' . sprintf(__t("ordered by %s", true), mb_strtolower($field_order_array[$sort]['text'], 'UTF-8'));
}
}
}
$this->params['order'] = $sort;
// This is the param read in the views so we need to update it
/******************************************************************
* Set view (theme) vars
*******************************************************************/
$this->set(array('Config' => $this->Config, 'Access' => $this->Access, 'User' => $this->_user, 'subclass' => 'listing', 'page' => $page, 'directory' => $directory, 'section' => isset($section) ? $section : array(), 'category' => isset($category) ? $category : array(), 'categories' => isset($categories) ? $categories : array(), 'parent_categories' => $parent_categories, 'listings' => $listings, 'pagination' => array('total' => $count)));
$query_listings and $this->set('order_list', $field_order_array);
/******************************************************************
* RSS Feed: caches and displays feed when xml action param is present
*******************************************************************/
if (Sanitize::getString($this->params, 'action') == 'xml') {
$this->Feeds->saveFeed($feed_filename, 'listings');
}
echo $this->render('listings', 'listings_' . $this->tmpl_list);
}
/**
* Dynamic Listing Model Loading for jReviewsEverywhere extensions
* Detects which extension is being used to load the correct Listing model
*
* @param object $controller
* @param string $extension
*/
function loadListingModel(&$controller, $extension = null)
{
if (in_array($controller->name, array('admin/reviews', 'reviews')) && $controller->action == '_save') {
$extension = Sanitize::getString($controller->data['Review'], 'mode');
!$extension and isset($controller->data['Listing']) and $extension = Sanitize::getString($controller->data['Listing'], 'extension');
} else {
$extension = $extension ? $extension : Sanitize::getString($controller->params, 'extension', Sanitize::getString($controller->data, 'extension'));
}
if (!$extension && isset($controller->params['module'])) {
// Final check for module parameter
$extension = Sanitize::getString($controller->params['module'], 'extension');
}
$extension == '' and $controller->name != 'facebook' and $controller->name != 'reviews' and $controller->name != 'community_reviews' and $controller->name != 'module_reviews' and $controller->name != 'discussions' and $controller->name != 'admin/reviews' and $controller->name != 'admin/admin_owner_replies' and $controller->name != 'admin/admin_reports' and $controller->name != 'admin/admin_discussions' and $extension = 'com_content';
// Check if in listing detail page and it's a 3rd party component to dynamically load it's Listing model
if ($extension) {
$name = $this->name . '_' . $extension;
App::import('Model', $name, 'jreviews');
$class_name = inflector::camelize($this->name . '_' . $extension) . 'Model';
if ($extension != '' && class_exists($class_name)) {
$controller->Listing = new $class_name($controller->params);
if (isset($controller->Review) && $controller->action != '_save') {
unset($controller->Review->joins['listings'], $controller->Review->joins['jreviews_categories'], $controller->Review->joins['criteria']);
$controller->Review->joins = array_merge($controller->Review->joins, $controller->Listing->joinsReviews);
}
} else {
// Extension used in url doesn't have a plugin so we redirect to 404 error page
$controller->autoLayout = false;
$controller->autoRender = true;
cmsFramework::redirect(cmsFramework::route('index.php?option=com_jreviews&url=404'));
}
}
}
function _installfix()
{
// Load fields model
App::import('Model', 'field', 'jreviews');
$FieldModel = new FieldModel();
$task = Sanitize::getString($this->data, 'task');
$msg = '';
$mambot_error = 0;
switch ($task) {
case 'fix_install_jreviews':
$query = "SELECT id,published FROM #__" . _PLUGIN_DIR_NAME . " WHERE element = 'jreviews' AND folder = 'content'";
$this->_db->setQuery($query);
$jReviewsMambot = $this->_db->loadObjectList();
if (!$jReviewsMambot || empty($jReviewsMambot)) {
// Install in DB
$this->_db->setQuery("INSERT INTO #__" . _PLUGIN_DIR_NAME . " (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES ('jReviews Comment Plugin', 'jreviews', 'content', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');");
$this->_db->query();
} else {
// Publish
$jReviewsMambot = $jReviewsMambot[0];
if (!$jReviewsMambot->published) {
$this->_db->setQuery("UPDATE #__" . _PLUGIN_DIR_NAME . " SET published = '1' WHERE id='{$jReviewsMambot->id}'");
$this->_db->query();
}
}
if (!file_exists(PATH_ROOT . _PLUGIN_DIR_NAME . DS . 'content' . DS . 'jreviews.php')) {
$package = PATH_ROOT . 'administrator' . DS . 'components' . DS . 'com_jreviews' . DS . 'jreviews.plugin.s2';
$target = PATH_ROOT . _PLUGIN_DIR_NAME . DS . 'content';
$target_file = $target . DS . 'jreviews.php';
if (getCmsVersion() == CMS_JOOMLA15) {
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.folder');
jimport('joomla.filesystem.archive');
jimport('joomla.filesystem.path');
$adapter =& JArchive::getAdapter('zip');
$result = $adapter->extract($package, $target);
}
if (!file_exists($target_file)) {
require_once PATH_ROOT . 'administrator' . DS . 'includes' . DS . 'pcl' . DS . 'pclzip.lib.php';
require_once PATH_ROOT . 'administrator' . DS . 'includes' . DS . 'pcl' . DS . 'pclerror.lib.php';
$extract = new PclZip($package);
if (substr(PHP_OS, 0, 3) == 'WIN') {
if (!defined('OS_WINDOWS')) {
define('OS_WINDOWS', 1);
}
} else {
if (!defined('OS_WINDOWS')) {
define('OS_WINDOWS', 0);
}
}
$result = $extract->extract(PCLZIP_OPT_PATH, $target);
}
if (!$result) {
$mambot_error = true;
} else {
$mambot_error = false;
}
}
if ($mambot_error) {
$msg = "It was not possible to copy the mambot/plugin files. Make sure the /" . _PLUGIN_DIR_NAME . "/content folder is writable and try again.";
}
break;
case 'fix_content_fields':
$output = '';
$rows = $this->_db->getTableFields(array('#__jreviews_content'));
$columns = array_keys($rows['#__jreviews_content']);
$sql = "SELECT name,type FROM #__jreviews_fields WHERE location = 'content'";
$this->_db->setQuery($sql);
$fields = $this->_db->loadObjectList('name');
$missing = array();
foreach ($fields as $field) {
if (!in_array($field->name, $columns)) {
$output = $FieldModel->addTableColumn($field->name, $field->type, 'content');
}
}
$query = "DELETE FROM #__jreviews_fields WHERE name = ''";
$this->_db->setQuery($query);
$output = $this->_db->query();
if ($output != '') {
$msg = "There was a problem fixing one or more of the content fields";
}
break;
case 'fix_review_fields':
$output = '';
$rows = $this->_db->getTableFields(array('#__jreviews_review_fields'));
$columns = array_keys($rows['#__jreviews_review_fields']);
$sql = "SELECT name,type FROM #__jreviews_fields WHERE location = 'review'";
$this->_db->setQuery($sql);
$fields = $this->_db->loadObjectList('name');
$missing = array();
foreach ($fields as $field) {
if (!in_array($field->name, $columns)) {
$output = $FieldModel->addTableColumn($field->name, $field->type, 'review');
}
}
$query = "DELETE FROM #__jreviews_fields WHERE name = ''";
$this->_db->setQuery($query);
$output = $this->_db->query();
if ($output != '') {
$msg = "There was a problem fixing one or more of the review fields";
}
break;
default:
break;
}
cmsFramework::redirect("index.php?option=com_jreviews", $msg);
}
