function __construct()
{
parent::__construct();
switch ($this->integrationMode) {
case 'groups':
// The primary key for categories
switch (getCmsVersion()) {
case CMS_JOOMLA10:
case CMS_MAMBO46:
$this->categoryPrimaryKey = 'group_id';
break;
case CMS_JOOMLA15:
$this->categoryPrimaryKey = 'id';
break;
}
$this->joins = array('Total' => "LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_comprofiler'", "LEFT JOIN #__core_acl_aro_groups AS Category ON Listing.gid = Category.{$this->categoryPrimaryKey}", "INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.gid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_comprofiler'", 'LEFT JOIN #__jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id', 'LEFT JOIN #__comprofiler AS CommunityBuilder ON Listing.id = CommunityBuilder.id', "LEFT JOIN #__users AS User ON User.id = Listing.id");
$this->joinsReviews = array("LEFT JOIN #__users AS Listing ON Review.pid = Listing.id", "LEFT JOIN #__core_acl_aro_groups AS Category ON Listing.gid = Category.{$this->categoryPrimaryKey}", "INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.gid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_comprofiler'", 'LEFT JOIN #__jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id');
break;
case 'fields':
$this->fields = array('Listing.id AS `Listing.listing_id`', 'Listing.username AS `Listing.title`', 'CommunityBuilder.avatar AS `Listing.images`', 'CommunityBuilder.avatarapproved AS `Listing.images_approved`', "'com_comprofiler' AS `Listing.extension`", 'JreviewsCategory.id AS `Listing.cat_id`', 'Category.fieldtitle AS `Category.title`', 'JreviewsCategory.id AS `Category.cat_id`', 'Criteria.id AS `Criteria.criteria_id`', 'Criteria.criteria AS `Criteria.criteria`', 'Criteria.tooltips AS `Criteria.tooltips`', 'Criteria.weights AS `Criteria.weights`', 'Criteria.required AS `Criteria.required`', 'Criteria.state AS `Criteria.state`');
$this->joins = array('INNER JOIN #__comprofiler AS CommunityBuilder ON Listing.id = CommunityBuilder.id', "LEFT JOIN #__comprofiler_field_values AS Category ON CommunityBuilder.{$this->cbCustomField} = Category.fieldtitle", "INNER JOIN #__jreviews_categories AS JreviewsCategory ON Category.fieldvalueid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_comprofiler'", 'LEFT JOIN #__jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id');
$this->joinsReviews = array('INNER JOIN #__comprofiler AS CommunityBuilder ON Review.pid = CommunityBuilder.id', "LEFT JOIN #__comprofiler_field_values AS Category ON CommunityBuilder.{$this->cbCustomField} = Category.fieldtitle", "INNER JOIN #__jreviews_categories AS JreviewsCategory ON Category.fieldvalueid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_comprofiler'", 'LEFT JOIN #__jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id');
break;
}
$this->tag = __t("COMMUNITY_BUILDER_TAG", true);
// Used in MyReviews page to differentiate from other component reviews
$this->fields[] = "'{$this->tag}' AS `Listing.tag`";
}
function getAccessGroupList($groups = null)
{
/* Groupids reference */
// 18 - Registered
// 19 - Author
// 20 - Editor
// 21 - Published
// 23 - Manager
// 24 - Administrator
// 25 - Super Administrator
$whereGroups = $groups ? "\n AND id IN ({$groups})" : "";
switch (getCmsVersion()) {
case CMS_JOOMLA16:
$query = "\n SELECT \n id AS value, title AS text\n FROM \n #__usergroups" . $whereGroups;
break;
case CMS_JOOMLA15:
$excludedGroups = array("'ROOT'", "'USERS'", "'Public Frontend'", "'Public Backend'");
$excludedGroups = implode(",", $excludedGroups);
$query = "\n SELECT \n id AS value, name AS text\n FROM \n #__core_acl_aro_groups\n WHERE \n name NOT IN ({$excludedGroups})" . $whereGroups;
break;
}
$this->_db->setQuery($query);
$results = $this->_db->loadAssocList();
return $results;
}
function create()
{
if (getCmsVersion() != CMS_JOOMLA15) {
return $this->create_j16();
}
$this->name = 'categories';
$this->autoRender = true;
$sectionid = Sanitize::getInt($this->params, 'sectionid', '');
$limit = Sanitize::getInt($this->params, 'limit', cmsFramework::getConfig('list_limit'));
$limitstart = Sanitize::getInt($this->params, 'limitstart', '');
$this->set(array('sectionid' => $sectionid, 'limit' => $limit, 'limitstart' => $limitstart, 'criterias' => $this->Criteria->getSelectList(), 'directories' => $this->Directory->getSelectList(), 'categories' => $this->Category->getSelectList()));
}
function __construct()
{
parent::__construct();
// The primary key for categories
switch (getCmsVersion()) {
case CMS_JOOMLA10:
case CMS_MAMBO46:
$this->categoryPrimaryKey = 'group_id';
break;
case CMS_JOOMLA15:
$this->categoryPrimaryKey = 'id';
break;
}
$this->joins = array('Total' => "LEFT JOIN #__jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = '{$this->extension_alias}'", "LEFT JOIN #__core_acl_aro_groups AS Category ON Listing.gid = Category.{$this->categoryPrimaryKey}", "INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.gid = JreviewsCategory.id AND JreviewsCategory.`option` = '{$this->extension_alias}'", 'LEFT JOIN #__jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id', 'LEFT JOIN #__community_users AS Community ON Listing.id = Community.userid', "LEFT JOIN #__users AS User ON User.id = Listing.id");
$this->joinsReviews = array("LEFT JOIN #__users AS Listing ON Review.pid = Listing.id", "LEFT JOIN #__core_acl_aro_groups AS Category ON Listing.gid = Category.{$this->categoryPrimaryKey}", "INNER JOIN #__jreviews_categories AS JreviewsCategory ON Listing.gid = JreviewsCategory.id AND JreviewsCategory.`option` = '{$this->extension_alias}'", 'LEFT JOIN #__jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id');
$this->tag = __t("JOMSOCIAL_TAG", true);
// Used in MyReviews page to differentiate from other component reviews
$this->fields[] = "'{$this->tag}' AS `Listing.tag`";
}
function user($title, $user_id, $attributes)
{
if ($user_id == 0) {
return '"' . $title . '"';
}
switch (getCmsVersion()) {
case CMS_JOOMLA10:
case CMS_MAMBO46:
$route = $this->routes['user10'];
$url = sprintf($route, $user_id);
break;
case CMS_JOOMLA15:
$route = $this->routes['user15'];
$url = sprintf($route, $user_id);
break;
}
$attributes['sef'] = false;
return $this->Html->link($title, $url, $attributes);
}
function __construct()
{
parent::__construct();
$this->tag = __t("Listing", true);
// Used in MyReviews page to differentiate from other component reviews
// Uncomment line below to show tag in My Reviews page
// $this->fields[] = "'{$this->tag }' AS `Listing.tag`";
if (getCmsVersion() == CMS_JOOMLA15) {
// Add listing, category aliases to fields
$this->fields[] = 'Listing.alias AS `Listing.slug`';
$this->fields[] = 'Category.alias AS `Category.slug`';
$this->fields[] = 'Section.alias AS `Section.slug`';
} else {
$this->fields[] = 'Listing.title_alias AS `Listing.slug`';
$this->fields[] = 'Category.name AS `Category.slug`';
$this->fields[] = 'Section.name AS `Section.slug`';
}
// PaidListings integration - when completing review info needs to be triggered here
if (class_exists('PaidListingsComponent')) {
PaidListingsComponent::applyBeforeFindListingChanges($this);
}
$this->Routes = RegisterClass::getInstance('RoutesHelper');
}
function getCategory($id, $section_id, $dir_id, $listing = false)
{
if ($listing) {
$core = $this->get('core_content_menu_id_' . $listing, '');
if ($core != '') {
return $core;
}
$core = $this->get('core_category_menu_id_' . $id, $this->getSection($section_id, $dir_id, $listing));
if ($core != '') {
return $core;
} elseif (getCmsVersion() == CMS_JOOMLA15 && cmsFramework::getConfig('sef') == 1) {
// There's a problem with J1.5 core sef urls with Itemids from non-core menus, so we make sure the jReviews menu ids are not used
return false;
}
}
return $this->get('jr_category_menu_id_' . $id, $this->getSection($section_id, $dir_id));
}
function __construct()
{
$this->cmsVersion = getCmsVersion();
}
} else {
$_GET['url'] = Sanitize::getString($_GET, 'url', 'about');
}
/*******************************************************************
* FRONT-END ROUTING
******************************************************************/
} elseif ($menu_id && !isset($_POST['data']['controller']) && (!$url || !isset($route['data']['controller']) || preg_match('/^menu\\//', $route['url']['url']))) {
// If no task is passed in the url, then this is a menu item and we read the menu parameters
$segments = array();
$url_param = $url;
$url = str_replace('menu', '', $url);
$db = cmsFramework::getDB();
$query = "SELECT * FROM #__menu WHERE id = " . $menu_id;
$db->setQuery($query);
$menu = end($db->loadObjectList());
$mparams = getCmsVersion() == CMS_JOOMLA16 ? json_decode($menu->params, true) : stringToArray($menu->params);
if (isset($mparams['action'])) {
$action = paramsRoute((int) $mparams['action']);
$_REQUEST['Itemid'] = $_GET['Itemid'] = $menu->id;
// For default - home page menu
unset($mparams['action']);
$menu_params['data'] = $mparams;
$filters = array('dir' => 'dirid', 'section' => 'sectionid', 'cat' => 'catid', 'criteria' => 'criteriaid');
foreach ($filters as $key => $key2) {
$menu_params[$key] = Sanitize::getVar($mparams, $key2);
is_array($menu_params[$key]) and $menu_params[$key] = implode(',', $menu_params[$key]);
}
// $menu_params['url'] = 'menu';
$menu_params['data']['component_menu'] = true;
$menu_params['data']['controller'] = $action[0];
$menu_params['data']['action'] = $action[1];
S2Paths::set($s2_app, 'S2_VIEWS_URL', S2Paths::get($s2_app, 'S2_APP_URL') . 'views' . _DS);
S2Paths::set($s2_app, 'S2_THEMES_URL', S2Paths::get($s2_app, 'S2_VIEWS_URL') . 'themes' . _DS);
S2Paths::set($s2_app, 'S2_IMAGES_URL', S2Paths::get($s2_app, 'S2_VIEWS_URL') . 'images' . _DS);
S2Paths::set($s2_app, 'S2_CSS_URL', S2Paths::get($s2_app, 'S2_VIEWS_URL') . 'css' . _DS);
S2Paths::set($s2_app, 'S2_CMS_ADMIN', PATH_ROOT . 'administrator' . DS . 'components' . DS . S2Paths::get($s2_app, 'S2_CMSCOMP') . DS);
S2Paths::set($s2_app, 'S2_ADMIN_CONTROLLERS', S2Paths::get($s2_app, 'S2_APP') . 'admin_controllers' . DS);
S2Paths::set($s2_app, 'S2_ADMIN_COMPONENTS', S2Paths::get($s2_app, 'S2_ADMIN_CONTROLLERS') . 'components' . DS);
S2Paths::set($s2_app, 'S2_ADMIN_VIEWS', S2Paths::get($s2_app, 'S2_APP') . 'views' . DS . 'admin' . DS);
S2Paths::set($s2_app, 'S2_ADMIN_HELPERS', S2Paths::get($s2_app, 'S2_ADMIN_VIEWS') . 'helpers' . DS);
S2Paths::set($s2_app, 'S2_ADMIN_VIEWS_URL', S2Paths::get($s2_app, 'S2_VIEWS_URL') . 'admin' . _DS);
S2Paths::set($s2_app, 'S2_ADMIN_THEMES_URL', S2Paths::get($s2_app, 'S2_ADMIN_VIEWS_URL') . 'themes' . _DS);
S2Paths::set($s2_app, 'S2_CSS_ADMIN_URL', S2Paths::get($s2_app, 'S2_ADMIN_VIEWS_URL') . 'css' . _DS);
S2Paths::set($s2_app, 'S2_JS_ADMIN_URL', S2Paths::get($s2_app, 'S2_ADMIN_VIEWS_URL') . 'js' . _DS);
// Whatever path you enter here, JReviews will add an additional folder called jreviews so it becomes your/path/jreviews/
// Thumbnails will be stored in your/path/jreviews/tn/ so make sure you create that folder as well
if (getCmsVersion() == CMS_JOOMLA16) {
if (!defined('_JR_WWW_IMAGES')) {
define('_JR_WWW_IMAGES', 'images' . _DS);
}
if (!defined('_JR_PATH_IMAGES')) {
define('_JR_PATH_IMAGES', 'images' . DS);
}
} else {
if (!defined('_JR_WWW_IMAGES')) {
define('_JR_WWW_IMAGES', 'images' . _DS . 'stories' . _DS);
}
if (!defined('_JR_PATH_IMAGES')) {
define('_JR_PATH_IMAGES', 'images' . DS . 'stories' . DS);
}
}
/**
function ModuleReviews()
{
$assets = array();
$inline = in_array(getCmsVersion(), array(CMS_JOOMLA10, CMS_MAMBO46));
if (Sanitize::getInt($this->params['module'], 'ajax_nav', 1)) {
$assets['js'] = array('jreviews', 'jquery' => 'jquery', 'jq.scrollable');
}
$assets['css'] = array('theme', 'modules', 'paginator');
$this->send($assets, $inline);
}
} else {
define('_PLUGIN_DIR_NAME', 'mambots');
}
}
$query = "SELECT published,params FROM #__" . _PLUGIN_DIR_NAME . " WHERE element = 'jreviews' AND folder = 'content' LIMIT 1";
$CMS->_db->setQuery($query);
$jrbot = current($CMS->_db->loadObjectList());
$params = stringToArray($jrbot->params);
$published = $jrbot->published;
if ((int) (!$published)) {
return;
}
$frontpageOff = Sanitize::getVar($params, 'frontpage');
$blogLayoutOff = Sanitize::getVar($params, 'blog');
# Get theme, suffix and load CSS so it's not killed by the built-in cache
if (getCmsVersion() == CMS_JOOMLA10 || getCmsVersion() == CMS_MAMBO46) {
if ($option == 'com_content' && ($task == 'category' || $task == 'section' || $blogLayoutOff && $task == 'blogsection' || $blogLayoutOff && $task == 'blogcategory') || $frontpageOff && $option == 'com_frontpage') {
return;
}
} elseif ($blogLayoutOff && $option == 'com_content' && ($view == 'category' || $view == 'section') && ($layout == 'blog' || $layout == 'blogfull')) {
return;
} elseif ($frontpageOff && $view == 'frontpage') {
return;
}
jimport('joomla.plugin.plugin');
class plgContentJreviews extends JPlugin
{
function plgContentJreviews(&$subject, $params)
{
parent::__construct($subject, $params);
}
/**
* Converts string to array and removes empty elements
*/
function stringToArray($string, $separator = "\n")
{
if (getCmsVersion() == CMS_JOOMLA16 && !strstr($string, $separator)) {
$result = json_decode($string, true);
if (is_array($result)) {
return $result;
}
}
$out = array();
$array = explode($separator, $string);
foreach ($array as $key => $value) {
if ($value != '') {
$pos = strpos($value, '=');
$property = trim(substr($value, 0, $pos));
$pvalue = trim(substr($value, $pos + 1));
$out[$property] = $pvalue;
}
}
return $out;
}
function getUsedCategoriesgroups()
{
$table = '#__usergroups';
$key = 'title';
if (getCmsVersion() == CMS_JOOMLA15) {
$table = '#__core_acl_aro_groups';
$key = 'name';
}
$query = "\n SELECT \n Component.{$this->categoryPrimaryKey} AS `Component.cat_id`,Component.{$key} as `Component.cat_title`, Criteria.title AS `Component.criteria_title`\n FROM \n {$table} AS Component\n INNER JOIN \n #__jreviews_categories AS JreviewCategory ON Component.{$this->categoryPrimaryKey} = JreviewCategory.id AND JreviewCategory.`option` = '{$this->extension}'\n LEFT JOIN \n #__jreviews_criteria AS Criteria ON JreviewCategory.criteriaid = Criteria.id\n LIMIT \n {$this->offset},{$this->limit}\n ";
$this->_db->setQuery($query);
appLogMessage("getUsedCategories\n" . $this->_db->getQuery(), 'everywhere');
$results = $this->_db->loadObjectList();
appLogMessage($this->_db->getErrorMsg(), 'everywhere');
$results = $this->__reformatArray($results);
$results = $this->changeKeys($results, 'Component', 'cat_id');
$query = "SELECT count(JreviewCategory.id)" . "\n FROM #__jreviews_categories AS JreviewCategory" . "\n WHERE JreviewCategory.`option` = '{$this->extension}'";
$this->_db->setQuery($query);
$count = $this->_db->loadResult();
return array('rows' => $results, 'count' => $count);
}
function startup(&$controller = null)
{
# Use different default values for J15 access settings
if (getCmsVersion() == CMS_JOOMLA15) {
$this->security_image = "0,18";
$this->moderation_item = "0,18";
$this->moderation_reviews = "0,18";
$this->editaccess = "24,25";
$this->listing_publish_access = "24,25";
$this->listing_delete_access = "24,25";
$this->editaccess_reviews = "24,25";
$this->addnewaccess = "24,25";
$this->addnewaccess_reviews = "18,19,20,21,23,24,25";
$this->addnewwysiwyg = "24,25";
$this->addnewmeta = "24,25";
$this->user_vote_public = "0,18,19,20,21,23,24,25";
$this->addnewaccess_posts = "18,19,20,21,23,24,25";
$this->moderation_posts = "0,18";
$this->post_edit_access = "18,19,20,21,23,24,25";
$this->post_delete_access = "18,19,20,21,23,24,25";
$this->moderation_owner_replies = "18";
$this->claims_enable_userids = "62";
$this->authorids = "62";
}
if ($Config = Configure::read('JreviewsSystem.Config')) {
$this->merge($Config);
} else {
$cache_file = 'jreviews_config_' . md5(cmsFramework::getConfig('secret'));
$Config = S2Cache::read($cache_file);
if (false == $Config || empty($Config)) {
$Config = $this->load();
S2Cache::write($cache_file, $Config);
}
$this->merge($Config);
Configure::write('JreviewsSystem.Config', $Config);
}
Configure::write('System.version', strip_tags($this->version));
Configure::write('Theme.name', $this->template);
Configure::write('Community.extension', $this->community);
Configure::write('Cache.enable', true);
Configure::write('Cache.disable', false);
Configure::write('Cache.expires', $this->cache_expires);
Configure::write('Cache.query', (bool) $this->cache_query);
Configure::write('Cache.view', (bool) $this->cache_view);
Configure::write('Jreviews.editor_rank_exclude', (bool) $this->editor_rank_exclude);
}
/**
* Gets the most basic listing info to construct the urls for them
*
* @param mixed $id
*/
function getListingById($id)
{
# Add Menu ID info for each row (Itemid)
$Menu = ClassRegistry::getClass('MenuModel');
$fields = array('Listing.id AS `Listing.listing_id`', 'Listing.alias AS `Listing.slug`', 'Listing.title AS `Listing.title`', 'Listing.catid AS `Listing.cat_id`', 'Category.alias AS `Category.slug`', 'Category.id AS `Category.cat_id`', 'Category.title AS `Category.title`');
if (getCmsVersion() == CMS_JOOMLA15) {
$fields[] = 'Listing.sectionid AS `Listing.section_id`';
}
$query = "\n SELECT \n " . implode(",", $fields) . "\n FROM \n #__content AS Listing\n LEFT JOIN \n #__categories AS Category ON Category.id = Listing.catid\n WHERE \n Listing.id IN (" . $this->Quote($id) . ") \n ";
$this->_db->setQuery($query);
$listings = $this->__reformatArray($this->_db->loadObjectList());
$listings = $this->changeKeys($listings, 'Listing', 'listing_id');
$listings = $Menu->addMenuListing($listings);
foreach ($listings as $key => $listing) {
$listings[$key]['Listing']['url'] = $this->listingUrl($listing);
}
return $listings;
}
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);
}
