public static function yesnoSelectList($tag_name, $tag_attribs, $selected, $yes = 'yes', $no = 'no')
{
if (JCOMMENTS_JVERSION == '1.0') {
$arr = array(JCommentsHTML::makeOption(0, $no), JCommentsHTML::makeOption(1, $yes));
} else {
$arr = array(JCommentsHTML::makeOption(0, $no), JCommentsHTML::makeOption(1, $yes));
}
return JCommentsHTML::selectList($arr, $tag_name, $tag_attribs, 'value', 'text', (int) $selected);
}
public static function showImport($CommentSystems = array())
{
$app = JCommentsFactory::getApplication('administrator');
$db = JCommentsFactory::getDBO();
$db->setQuery("SHOW TABLES");
$tables = $db->loadResultArray();
foreach ($tables as $tableName) {
for ($i = 0, $n = count($CommentSystems); $i < $n; $i++) {
$tableMask = str_replace('#__', $app->getCfg('dbprefix'), $CommentSystems[$i]->table);
if (preg_match('/' . $tableMask . '$/i', $tableName)) {
$CommentSystems[$i]->found = true;
$CommentSystems[$i]->UpdateCount();
}
}
}
$languages = JCommentsMultilingual::getLanguages();
if (JCOMMENTS_JVERSION == '1.0') {
$lang = JCommentsMultilingual::getLanguage();
} else {
$params = JComponentHelper::getParams('com_languages');
$lang = $params->get("site", 'en-GB');
}
$ajaxUrl = JCommentsFactory::getLink('ajax-backend');
?>
<link rel="stylesheet" href="<?php
echo $app->getCfg('live_site');
?>
/administrator/components/com_jcomments/assets/style.css" type="text/css" />
<script type="text/javascript" src="<?php
echo $app->getCfg('live_site');
?>
/components/com_jcomments/libraries/joomlatune/ajax.js?v=2"></script>
<script type="text/javascript" src="<?php
echo $app->getCfg('live_site');
?>
/administrator/components/com_jcomments/assets/jcomments-backend-v2.1.js"></script>
<script type="text/javascript">
<!--
function JCommentsImportCommentsAJAX(source, language, start)
{
try {
jtajax.setup({url:'<?php
echo $ajaxUrl;
?>
'});
return jtajax.call('JCommentsImportCommentsAjax', arguments, 'post');
} catch (e) {
return false;
}
}
function startCommentsImport(source)
{
var language = '';
var e=document.getElementById(source.toLowerCase() + '_lang');
if (e){for (var i=0;i<e.length;i++) {if (e.options[i].selected){language=e.options[i].value;break;}}}
var b = document.getElementById('btnImport' + source);
if (b) {b.disabled = true;}
JCommentsImportCommentsAJAX(source, language, 0);
}
function finishCommentsImport(source) {
var b=document.getElementById('btnImport'+source);if(b){b.disabled=false;}
}
<?php
if (JCOMMENTS_JVERSION == '1.7') {
?>
Joomla.submitbutton = function (task) {
Joomla.submitform(task, document.getElementById('adminForm'));
};
<?php
} else {
?>
function submitbutton(task)
{
submitform(task);
}
<?php
}
?>
//-->
</script>
<script type="text/javascript">
<!--
var jc_comments = new Array(
<?php
$jsArray = array();
foreach ($CommentSystems as $CommentSystem) {
if ($CommentSystem->found) {
$jsArray[] = $CommentSystem->code;
}
}
echo "'" . implode("', '", $jsArray) . "'";
?>
);
function importMode( mode ) {
if(document.getElementById) {
for(var i=0;i<jc_comments.length;i++) {
if (mode == jc_comments[i]) {
document.getElementById('import' + jc_comments[i]).checked = true;
document.getElementById('import' + jc_comments[i]+'Info').style.display = '';
} else {
document.getElementById('import' + jc_comments[i]).checked = false;
document.getElementById('import' + jc_comments[i]+'Info').style.display = 'none';
}
}
}
}
//-->
</script>
<style type="text/css">
#jcomments-message {padding: 0 0 0 25px;margin: 0; width: auto; float: right; font-size: 14px; font-weight: bold;}
.jcomments-message-error {background: transparent url(components/com_jcomments/assets/error.gif) no-repeat 4px 50%; color: red;}
.jcomments-message-info {background: transparent url(components/com_jcomments/assets/info.gif) no-repeat 4px 50%; color: green;}
.jcomments-message-wait {background: transparent url(components/com_jcomments/assets/wait.gif) no-repeat 4px 50%; color: green;}
.adminform fieldset { border: 1px #999 solid; }
.adminform fieldset input, fieldset select { float: none; }
.adminform span.note { color: #777; }
table.componentinfo td { color: #777; padding: 0; }
</style>
<div>
<form action="<?php
echo JCOMMENTS_INDEX;
?>
" method="post" name="adminForm" id="adminForm">
<input type="hidden" name="option" value="com_jcomments" />
<input type="hidden" name="task" value="" />
<?php
if (JCOMMENTS_JVERSION == '1.0') {
?>
<table class="adminheading">
<tr>
<th style="background-image: none; padding: 0;"><img src="components/com_jcomments/assets/icon-48-import.png" width="48" height="48" align="middle" alt="<?php
echo JText::_('A_IMPORT');
?>
"> <?php
echo JText::_('A_IMPORT');
?>
</th>
</tr>
</table>
<?php
}
?>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr valign="top">
<td align="right"> </td>
<td width="50%" align="right"><div id="jcomments-message-holder"></div></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="4" cellspacing="2" class="adminform">
<tr>
<td>
<fieldset>
<legend><?php
echo JText::_('A_IMPORT_SELECT_SOURCE');
?>
</legend>
<table cellpadding="1" cellspacing="1" border="0">
<?php
$foundSources = 0;
foreach ($CommentSystems as $CommentSystem) {
if ($CommentSystem->found) {
$foundSources++;
?>
<tr valign="top" align="left">
<td><input type="radio" id="import<?php
echo $CommentSystem->code;
?>
" name="vars[import]" value="<?php
echo $CommentSystem->code;
?>
" onclick="importMode('<?php
echo $CommentSystem->code;
?>
')" <?php
echo $CommentSystem->found ? '' : 'disabled';
?>
/></td>
<td><label for="import<?php
echo $CommentSystem->code;
?>
"><?php
echo $CommentSystem->name;
?>
</label></td>
<td><div id="jcomments-message-<?php
echo strtolower($CommentSystem->code);
?>
"></div></td>
</tr>
<tr id="import<?php
echo $CommentSystem->code;
?>
Info" style="display: none;">
<td> </td>
<td>
<table cellpadding="0" cellspacing="0" border="0" class="componentinfo">
<tr>
<td width="150px"><?php
echo JText::_('A_IMPORT_COMPONENT_AUTHOR');
?>
</td>
<td><?php
echo $CommentSystem->author;
?>
</td>
</tr>
<tr>
<td><?php
echo JText::_('A_IMPORT_COMPONENT_HOMEPAGE');
?>
</td>
<td><a href="<?php
echo $CommentSystem->homepage;
?>
" target="_blank"><?php
echo str_replace('http://', '', $CommentSystem->homepage);
?>
</a></td>
</tr>
<tr>
<td><?php
echo JText::_('A_IMPORT_COMPONENT_LICENSE');
?>
</td>
<td>
<?php
if ($CommentSystem->license_url != '') {
?>
<a href="<?php
echo $CommentSystem->license_url;
?>
" target="_blank"><?php
echo $CommentSystem->license;
?>
</a>
<?php
} else {
?>
<?php
echo $CommentSystem->license;
}
?>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr valign="top" align="left">
<td>
<?php
echo JText::_('A_IMPORT_COMPONENT_COMMENTS_COUNT');
?>
</td>
<td>
<label for="import<?php
echo $CommentSystem->code;
?>
"><?php
echo $CommentSystem->count;
?>
</label>
</td>
</tr>
<tr valign="top" align="left">
<td>
</td>
<td>
<?php
if (count($languages)) {
echo JCommentsHTML::selectList($languages, strtolower($CommentSystem->code) . '_lang', 'class="inputbox" size="1"', 'value', 'name', $lang) . ' ';
}
?>
<input type="button" id="btnImport<?php
echo $CommentSystem->code;
?>
" name="btnImport<?php
echo $CommentSystem->code;
?>
" value="<?php
echo JText::_('A_IMPORT_BUTTON_IMPORT');
?>
" onclick="startCommentsImport('<?php
echo $CommentSystem->code;
?>
')" <?php
echo $CommentSystem->count ? '' : 'disabled';
?>
/>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</td>
</tr>
<?php
}
}
if ($foundSources == 0) {
?>
<tr>
<td><?php
echo JText::_('A_IMPORT_NO_SOURCES');
?>
</td>
</tr>
<?php
}
?>
</table>
</fieldset>
</td>
</tr>
</table>
<?php
echo JCommentsSecurity::formToken();
?>
</form>
</div>
<?php
}
public static function show()
{
$app = JCommentsFactory::getApplication('administrator');
$context = 'com_jcomments.subscriptions.';
$object_group = trim($app->getUserStateFromRequest($context . 'fog', 'fog', ''));
$object_id = intval($app->getUserStateFromRequest($context . 'foid', 'foid', 0));
$flang = trim($app->getUserStateFromRequest($context . 'flang', 'flang', '-1'));
$fauthor = trim($app->getUserStateFromRequest($context . 'fauthor', 'fauthor', ''));
$fstate = trim($app->getUserStateFromRequest($context . 'fstate', 'fstate', '-1'));
$limit = intval($app->getUserStateFromRequest($context . 'limit', 'limit', $app->getCfg('list_limit')));
$limitstart = intval($app->getUserStateFromRequest($context . 'limitstart', 'limitstart', 0));
$filter_order = $app->getUserStateFromRequest($context . 'filter_order', 'filter_order', 'js.name');
$filter_order_Dir = $app->getUserStateFromRequest($context . 'filter_order_Dir', 'filter_order_Dir', 'asc');
$search = trim($app->getUserStateFromRequest($context . 'search', 'search', ''));
if (JCOMMENTS_JVERSION == '1.0') {
$search = strtolower($search);
} else {
$search = JString::strtolower($search);
}
if ($filter_order == '') {
$filter_order = 'js.name';
}
if ($filter_order_Dir == '') {
$filter_order_Dir = 'asc';
}
$lists['order'] = $filter_order;
$lists['order_Dir'] = $filter_order_Dir;
$lists['search'] = $search;
$db = JCommentsFactory::getDBO();
$where = array();
if ($object_group != '') {
$where[] = 'js.object_group = "' . $db->getEscaped($object_group, true) . '"';
}
if ($object_id != 0) {
$where[] = 'js.object_id = ' . intval($object_id);
}
if ($flang != '-1') {
$where[] = 'js.lang = "' . $db->getEscaped($flang, true) . '"';
}
if ($fauthor != '') {
$where[] = 'js.name = "' . $db->getEscaped($fauthor, true) . '"';
}
if ($fstate != '' && $fstate != '-1') {
$where[] = 'js.published = ' . intval($fstate);
}
if ($search != '') {
$where[] = '(js.name like "%' . $db->getEscaped($search, true) . '%" OR js.email like "%' . $db->getEscaped($search, true) . '%")';
}
$query = "SELECT COUNT(*)" . " FROM #__jcomments_subscriptions AS js" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "");
$db->setQuery($query);
$total = $db->loadResult();
$lists['pageNav'] = JCommentsAdmin::getPagination($total, $limitstart, $limit);
$query = "SELECT js.*, u.name AS editor" . " FROM #__jcomments_subscriptions AS js" . " LEFT JOIN #__users AS u ON u.id = js.userid" . (count($where) ? " WHERE " . implode(' AND ', $where) : "") . " ORDER BY " . $filter_order . ' ' . $filter_order_Dir;
$db->setQuery($query, $lists['pageNav']->limitstart, $lists['pageNav']->limit);
$lists['rows'] = $db->loadObjectList();
// Filter by object_group (component)
$query = "SELECT DISTINCT(object_group) AS name, object_group AS value " . " FROM #__jcomments_subscriptions" . " ORDER BY name";
$db->setQuery($query);
$rows = $db->loadObjectList();
$cnt = count($rows);
if ($cnt > 1 || $cnt == 1 && $total == 0) {
array_unshift($rows, JCommentsHTML::makeOption('', JText::_('A_FILTER_COMPONENT'), 'name', 'value'));
$lists['fog'] = JCommentsHTML::selectList($rows, 'fog', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'name', 'value', $object_group);
} else {
if ($cnt == 1) {
if ($object_group == '') {
$object_group = $rows[0]->name;
}
}
}
unset($rows);
if ($object_group != '') {
$query = "SELECT DISTINCT object_id AS value, lang " . " FROM #__jcomments_subscriptions " . " WHERE object_group = " . $db->Quote($object_group) . ($flang != '-1' ? " AND lang = " . $db->Quote($flang) : "");
$db->setQuery($query);
$rows = $db->loadObjectList();
for ($i = 0, $n = count($rows); $i < $n; $i++) {
$rows[$i]->name = JCommentsObjectHelper::getTitle($rows[$i]->value, $object_group, $rows[$i]->lang);
if ($rows[$i]->name == '') {
$rows[$i]->name = 'Untitled' . $rows[$i]->value;
}
}
// Don't show filter if we have more than 100 objects
if (count($rows) > 1 && count($rows) < 100) {
usort($rows, create_function('$a, $b', 'return strcasecmp( $a->name, $b->name);'));
array_unshift($rows, JCommentsHTML::makeOption('', JText::_('A_FILTER_OBJECT'), 'value', 'name'));
$lists['foid'] = JCommentsHTML::selectList($rows, 'foid', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'name', $object_id);
unset($rows);
}
}
// Filter by language
$query = "SELECT DISTINCT(lang) AS text, lang AS value " . " FROM #__jcomments_subscriptions" . " ORDER BY lang";
$db->setQuery($query);
$rows = $db->loadObjectList();
if (count($rows) > 1) {
array_unshift($rows, JCommentsHTML::makeOption('-1', JText::_('A_FILTER_LANGUAGE'), 'text', 'value'));
$lists['flang'] = JCommentsHTML::selectList($rows, 'flang', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'text', 'value', $flang);
}
unset($rows);
// Filter by published state
$stateOptions = array();
$stateOptions[] = JCommentsHTML::makeOption('-1', JText::_('A_FILTER_STATE'), 'text', 'value');
$stateOptions[] = JCommentsHTML::makeOption('', JText::_('A_FILTER_STATE_ALL'), 'text', 'value');
$stateOptions[] = JCommentsHTML::makeOption('1', JText::_('A_FILTER_STATE_PUBLISHED'), 'text', 'value');
$stateOptions[] = JCommentsHTML::makeOption('0', JText::_('A_FILTER_STATE_UNPUBLISHED'), 'text', 'value');
$lists['fstate'] = JCommentsHTML::selectList($stateOptions, 'fstate', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'text', 'value', $fstate);
unset($stateOptions);
// Filter by author
$lists['fauthor'] = '';
$db->setQuery("SELECT COUNT(DISTINCT(name)) FROM #__jcomments_subscriptions;");
$usersCount = $db->loadResult();
// Don't show filter if we have more than 100 comments' authors
if ($usersCount > 0 && $usersCount < 100) {
$query = "SELECT DISTINCT(name) AS author, name AS value " . " FROM #__jcomments_subscriptions" . " ORDER BY name";
$db->setQuery($query);
$rows = $db->loadObjectList();
if (count($rows) > 1) {
array_unshift($rows, JCommentsHTML::makeOption('', JText::_('A_FILTER_AUTHOR'), 'author', 'value'));
$lists['fauthor'] = JCommentsHTML::selectList($rows, 'fauthor', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'author', 'value', $fauthor);
}
unset($rows);
}
HTML_JCommentsAdminSubscriptionManager::show($lists);
}
public static function showSettings()
{
$db = JCommentsFactory::getDBO();
$config = JCommentsFactory::getConfig();
// check current site template for afterDisplayContent event
if (JCOMMENTS_JVERSION == '1.5') {
$db->setQuery('SELECT template FROM #__templates_menu WHERE client_id = 0 AND menuid = 0', 0, 1);
$template = $db->loadResult();
$articleTemplate = JPATH_SITE . '/templates/' . $template . '/html/com_content/article/default.php';
if (is_file($articleTemplate)) {
$tmpl = implode('', file($articleTemplate));
if (strpos($tmpl, 'afterDisplayContent') === false && !(strpos($tmpl, 'include') !== false || strpos($tmpl, 'require') !== false)) {
JError::raiseWarning(500, JText::_('A_WARNINGS_TEMPLATE_EVENT'));
}
}
}
$joomfish = JOOMLATUNE_JPATH_SITE . '/components/com_joomfish/joomfish.php';
if (is_file($joomfish) || JCommentsMultilingual::isEnabled()) {
$languages = JCommentsMultilingual::getLanguages();
if (count($languages)) {
$lang = trim(JCommentsInput::getVar('lang', ''));
if ($lang == '') {
if (JCOMMENTS_JVERSION != '1.0') {
$params = JComponentHelper::getParams('com_languages');
$lang = $params->get("site", 'en-GB');
}
if ($lang == '') {
$lang = JCommentsMultilingual::getLanguage();
}
}
// reload configuration
$config = JCommentsFactory::getConfig($lang);
$lists['languages'] = JCommentsHTML::selectList($languages, 'lang', 'class="inputbox" size="1" onchange="submitform(\'settings\');"', 'value', 'name', $lang);
}
}
$forbiddenNames = $config->get('forbidden_names');
$forbiddenNames = preg_replace('#,+#', "\n", $forbiddenNames);
$config->set('forbidden_names', $forbiddenNames);
$badWords = $config->get('badwords');
if ($badWords != '') {
$config->set('badwords', implode("\n", $badWords));
}
require_once JCOMMENTS_LIBRARIES . '/joomlatune/filesystem.php';
// path to images directory
$path = JCOMMENTS_BASE . DS . 'tpl' . DS;
$items = JoomlaTuneFS::readDirectory($path);
$templates = array();
foreach ($items as $item) {
if (is_dir($path . $item)) {
$tpl = new StdClass();
$tpl->text = $item;
$tpl->value = $item;
$templates[] = $tpl;
}
}
$currentTemplate = $config->get('template');
$lists['templates'] = JCommentsHTML::selectList($templates, 'cfg_template', 'class="inputbox"', 'value', 'text', $currentTemplate);
require_once JCOMMENTS_HELPERS . '/user.php';
$groups = JCommentsUserHelper::getUserGroups();
$captchaError = '';
$captchaExclude = array();
if (!extension_loaded('gd') || !function_exists('imagecreatefrompng')) {
if ($config->get('captcha_engine', 'kcaptcha') != 'recaptcha') {
foreach ($groups as $group) {
$captchaExclude[] = $group->id;
}
$captchaError = JText::_('A_WARNINGS_PHP_GD');
}
}
$reportError = '';
$reportExclude = array();
if ($config->getInt('enable_notification') == 0 || $config->check('notification_type', 2) == false) {
foreach ($groups as $group) {
$reportExclude[] = $group->id;
}
$reportError = JText::_('A_REPORTS_WARNING_NOTIFICATIONS_DISABLED');
}
$lists['group_names'] = $groups;
$permissions = array();
// Post
JCommentsAdmin::loadParam($permissions, 'can_comment', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_CAN_COMMENT'), JText::_('AP_CAN_COMMENT_DESC'));
JCommentsAdmin::loadParam($permissions, 'can_reply', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_CAN_REPLY'), JText::_('AP_CAN_REPLY_DESC'));
JCommentsAdmin::loadParam($permissions, 'autopublish', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_AUTOPUBLISH'), JText::_('AP_AUTOPUBLISH_DESC'));
JCommentsAdmin::loadParam($permissions, 'show_policy', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_SHOW_POLICY'), JText::_('AP_SHOW_POLICY_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_captcha', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_CAPTCHA'), JText::_('AP_ENABLE_CAPTCHA_DESC'), $captchaExclude, $captchaError);
JCommentsAdmin::loadParam($permissions, 'floodprotection', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_FLOODPROTECTION'), JText::_('AP_ENABLE_FLOODPROTECTION_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_comment_length_check', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_COMMENT_LENGTH_CHECK'), JText::_('AP_ENABLE_COMMENT_LENGTH_CHECK_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_autocensor', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_AUTOCENSOR'), JText::_('AP_ENABLE_AUTOCENSOR_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_subscribe', $groups, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_SUBSCRIBE'), JText::_('AP_ENABLE_SUBSCRIBE_DESC'));
// BBCodes
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_b', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_B'), JText::_('AP_ENABLE_BBCODE_B_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_i', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_I'), JText::_('AP_ENABLE_BBCODE_I_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_u', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_U'), JText::_('AP_ENABLE_BBCODE_U_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_s', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_S'), JText::_('AP_ENABLE_BBCODE_S_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_url', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_URL'), JText::_('AP_ENABLE_BBCODE_URL_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_img', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_IMG'), JText::_('AP_ENABLE_BBCODE_IMG_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_list', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_LIST'), JText::_('AP_ENABLE_BBCODE_LIST_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_hide', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_HIDE'), JText::_('AP_ENABLE_BBCODE_HIDE_DESC'), array('Public'));
JCommentsAdmin::loadParam($permissions, 'enable_bbcode_quote', $groups, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_QUOTE'), JText::_('AP_ENABLE_BBCODE_QUOTE_DESC'));
// View
JCommentsAdmin::loadParam($permissions, 'autolinkurls', $groups, JText::_('A_RIGHTS_VIEW'), JText::_('AP_ENABLE_AUTOLINKURLS'), JText::_('AP_ENABLE_AUTOLINKURLS_DESC'));
JCommentsAdmin::loadParam($permissions, 'emailprotection', $groups, JText::_('A_RIGHTS_VIEW'), JText::_('AP_ENABLE_EMAILPROTECTION'), JText::_('AP_ENABLE_EMAILPROTECTION_DESC'));
JCommentsAdmin::loadParam($permissions, 'enable_gravatar', $groups, JText::_('A_RIGHTS_VIEW'), JText::_('AP_ENABLE_GRAVATAR'), JText::_('AP_ENABLE_GRAVATAR_DESC'));
JCommentsAdmin::loadParam($permissions, 'can_view_email', $groups, JText::_('A_RIGHTS_VIEW'), JText::_('AP_CAN_VIEW_AUTHOR_EMAIL'), JText::_('AP_CAN_VIEW_AUTHOR_EMAIL_DESC'));
JCommentsAdmin::loadParam($permissions, 'can_view_homepage', $groups, JText::_('A_RIGHTS_VIEW'), JText::_('AP_CAN_VIEW_AUTHOR_HOMEPAGE'), JText::_('AP_CAN_VIEW_AUTHOR_HOMEPAGE_DESC'));
JCommentsAdmin::loadParam($permissions, 'can_view_ip', $groups, JText::_('A_RIGHTS_VIEW'), JText::_('AP_CAN_VIEW_AUTHOR_IP'), JText::_('AP_CAN_VIEW_AUTHOR_IP_DESC'), array('Public', 'Registered'));
// Edit
JCommentsAdmin::loadParam($permissions, 'can_edit_own', $groups, JText::_('A_RIGHTS_EDIT'), JText::_('AP_CAN_EDIT_OWN'), JText::_('AP_CAN_EDIT_OWN_DESC'), array('Public'));
JCommentsAdmin::loadParam($permissions, 'can_delete_own', $groups, JText::_('A_RIGHTS_EDIT'), JText::_('AP_CAN_DELETE_OWN'), JText::_('AP_CAN_DELETE_OWN_DESC'), array('Public'));
// Administration
JCommentsAdmin::loadParam($permissions, 'can_edit', $groups, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_EDIT'), JText::_('AP_CAN_EDIT_DESC'), array('Public', 'Registered'));
JCommentsAdmin::loadParam($permissions, 'can_edit_for_my_object', $groups, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_EDIT_FOR_MY_OBJECT'), JText::_('AP_CAN_EDIT_FOR_MY_OBJECT_DESC'), array('Public'));
JCommentsAdmin::loadParam($permissions, 'can_publish', $groups, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_PUBLISH'), JText::_('AP_CAN_PUBLISH_DESC'), array('Public', 'Registered'));
JCommentsAdmin::loadParam($permissions, 'can_publish_for_my_object', $groups, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_PUBLISH_FOR_MY_OBJECT'), JText::_('AP_CAN_PUBLISH_FOR_MY_OBJECT_DESC'), array('Public'));
JCommentsAdmin::loadParam($permissions, 'can_delete', $groups, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_DELETE'), JText::_('AP_CAN_DELETE_DESC'), array('Public', 'Registered'));
JCommentsAdmin::loadParam($permissions, 'can_delete_for_my_object', $groups, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_DELETE_FOR_MY_OBJECT'), JText::_('AP_CAN_DELETE_FOR_MY_OBJECT_DESC'), array('Public'));
// Votes
JCommentsAdmin::loadParam($permissions, 'can_vote', $groups, JText::_('A_RIGHTS_MISC'), JText::_('AP_CAN_VOTE'), JText::_('AP_CAN_VOTE_DESC'));
JCommentsAdmin::loadParam($permissions, 'can_report', $groups, JText::_('A_RIGHTS_MISC'), JText::_('AP_CAN_REPORT'), JText::_('AP_CAN_REPORT_DESC'), $reportExclude, $reportError);
JCommentsAdmin::loadParam($permissions, 'can_ban', $groups, JText::_('A_RIGHTS_MISC'), JText::_('AP_CAN_BAN'), JText::_('AP_CAN_BAN_DESC'), array('Public', 'Registered'));
$lists['groups'] =& $permissions;
if (JCOMMENTS_JVERSION == '1.0') {
$lookupQuery = "SELECT c.id AS `value`, CONCAT_WS( ' / ', s.title, c.title) AS `text`" . "\n FROM #__sections AS s" . "\n INNER JOIN #__categories AS c ON c.section = s.id" . "\n WHERE c.id IN ( " . $config->get('enable_categories') . " )" . "\n ORDER BY s.title,c.title";
$categoriesQuery = "SELECT c.id AS `value`, CONCAT_WS( ' / ', s.title, c.title) AS `text`" . "\n FROM #__sections AS s" . "\n INNER JOIN #__categories AS c ON c.section = s.id" . "\n ORDER BY s.title,c.title";
} elseif (JCOMMENTS_JVERSION == '1.5') {
$lookupQuery = "SELECT c.id AS `value`, CONCAT_WS( ' / ', s.title, c.title) AS `text`" . "\n FROM #__sections AS s" . "\n INNER JOIN #__categories AS c ON c.section = s.id" . "\n WHERE c.id IN ( " . $config->get('enable_categories') . " )" . "\n ORDER BY s.title,c.title";
$categoriesQuery = "SELECT c.id AS `value`, CONCAT_WS( ' / ', s.title, c.title) AS `text`" . "\n FROM #__sections AS s" . "\n INNER JOIN #__categories AS c ON c.section = s.id" . "\n ORDER BY s.title,c.title";
} else {
$lookupQuery = "SELECT c.id AS `value`, c.title AS `text`" . "\n FROM #__categories AS c" . "\n WHERE c.extension = 'com_content'" . "\n AND c.id IN ( " . $config->get('enable_categories') . " )" . "\n ORDER BY c.title";
$categoriesQuery = "SELECT c.id AS `value`, c.title AS `text`, c.level" . "\n FROM #__categories AS c" . "\n WHERE c.extension = 'com_content'" . "\n ORDER BY c.lft, c.title";
}
$db->setQuery($categoriesQuery);
$categories = $db->loadObjectList();
if (!is_array($categories)) {
$categories = array();
} else {
if (JCOMMENTS_JVERSION == '1.7') {
for ($i = 0, $n = count($categories); $i < $n; $i++) {
$repeat = $categories[$i]->level - 1 >= 0 ? $categories[$i]->level - 1 : 0;
$categories[$i]->text = str_repeat('- ', $repeat) . $categories[$i]->text;
}
}
}
if ($config->get('enable_categories') != '') {
$db->setQuery($lookupQuery);
$lookup = $db->loadObjectList();
} else {
$lookup = '';
}
$lists['categories'] = JCommentsHTML::selectList($categories, 'cfg_enable_categories[]', 'class="inputbox categories" size="10" multiple="multiple"', 'value', 'text', $lookup);
$captcha = array();
$captcha[] = JCommentsHTML::makeOption('kcaptcha', 'KCAPTCHA');
$config->set('enable_mambots', 1);
$enginesList = JCommentsEvent::trigger('onJCommentsCaptchaEngines');
foreach ($enginesList as $engines) {
foreach ($engines as $code => $text) {
$captcha[] = JCommentsHTML::makeOption($code, $text);
}
}
$disabledCAPTCHA = count($captcha) == 1 ? ' disabled="disabled"' : '';
$lists["captcha"] = JCommentsHTML::selectList($captcha, 'cfg_captcha_engine', 'class="inputbox"' . $disabledCAPTCHA, 'value', 'text', $config->get('captcha_engine', 'kcaptcha'));
HTML_JComments::showSettings($lists);
}
function show()
{
global $mainframe;
$option = JCommentsInput::getVar('option');
$object_group = trim($mainframe->getUserStateFromRequest("fog{$option}", 'fog', ''));
$object_id = intval($mainframe->getUserStateFromRequest("foid{$option}", 'foid', 0));
$flang = trim($mainframe->getUserStateFromRequest("flang{$option}", 'flang', ''));
$fauthor = trim($mainframe->getUserStateFromRequest("fauthor{$option}", 'fauthor', ''));
$fstate = trim($mainframe->getUserStateFromRequest("fstate{$option}", 'fstate', ''));
$limit = intval($mainframe->getUserStateFromRequest("view{$option}limit", 'limit', $mainframe->getCfg('list_limit')));
$limitstart = intval($mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0));
$filter_order = $mainframe->getUserStateFromRequest($option . 'filter_order', 'filter_order', 'js.name');
$filter_order_Dir = $mainframe->getUserStateFromRequest($option . 'filter_order_Dir', 'filter_order_Dir', 'asc');
$search = trim($mainframe->getUserStateFromRequest($option . 'subscriptions.search', 'search', ''));
if (JCOMMENTS_JVERSION == '1.5') {
$search = JString::strtolower($search);
} else {
$search = strtolower($search);
}
if ($filter_order == "") {
$filter_order = 'js.name';
}
if ($filter_order_Dir == "") {
$filter_order_Dir = 'asc';
}
$lists['order'] = $filter_order;
$lists['order_Dir'] = $filter_order_Dir;
$lists['search'] = $search;
$db =& JCommentsFactory::getDBO();
$where = array();
if ($object_group != '') {
$where[] = 'js.object_group = "' . $object_group . '"';
}
if ($object_id != 0) {
$where[] = 'js.object_id = ' . $object_id;
}
if ($flang != '') {
$where[] = 'js.lang = "' . $flang . '"';
}
if (trim($fauthor) != '') {
$where[] = 'js.name = "' . $fauthor . '"';
}
if (trim($fstate) != '' && trim($fstate) != '-1') {
$where[] = 'js.published = "' . intval($fstate) . '"';
}
if ($search != '') {
$where[] = '(js.name like "%' . $search . '%" OR js.email like "%' . $search . '%")';
}
$query = "SELECT COUNT(*)" . "\nFROM #__jcomments_subscriptions AS js" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "");
$db->setQuery($query);
$total = $db->loadResult();
if (JCOMMENTS_JVERSION == '1.0') {
require_once $mainframe->getCfg('absolute_path') . DS . 'administrator' . DS . 'includes' . DS . 'pageNavigation.php';
$lists['pageNav'] = new mosPageNav($total, $limitstart, $limit);
} else {
jimport('joomla.html.pagination');
$lists['pageNav'] = new JPagination($total, $limitstart, $limit);
}
$query = "SELECT js.*, u.name AS editor" . "\nFROM #__jcomments_subscriptions AS js" . "\n LEFT JOIN #__users AS u ON u.id = js.userid" . (count($where) ? "\nWHERE " . implode(' AND ', $where) : "") . "\nORDER BY " . $filter_order . ' ' . $filter_order_Dir;
$db->setQuery($query, $lists['pageNav']->limitstart, $lists['pageNav']->limit);
$lists['rows'] = $db->loadObjectList();
// Filter by object_group (component)
$query = "SELECT DISTINCT(object_group) AS name, object_group AS value " . "\nFROM #__jcomments_subscriptions" . "\nORDER BY name";
$db->setQuery($query);
$rows = $db->loadObjectList();
$cnt = count($rows);
if ($cnt > 1 || $cnt == 1 && ($total = 0)) {
array_unshift($rows, JCommentsHTML::makeOption('', JText::_('A_FILTER_ALL_COMPONENTS'), 'name', 'value'));
$lists['fog'] = JCommentsHTML::selectList($rows, 'fog', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'name', 'value', $object_group);
} else {
if ($cnt == 1) {
if ($object_group == '') {
$object_group = $rows[0]->name;
}
}
}
unset($rows);
if ($object_group != '') {
$query = "SELECT DISTINCT(object_id) AS value " . "\nFROM #__jcomments_subscriptions " . "\nWHERE object_group = '" . $object_group . "'" . ($flang != '' ? "AND lang = '" . $flang . "'" : "");
$db->setQuery($query);
$rows = $db->loadObjectList();
for ($i = 0, $n = count($rows); $i < $n; $i++) {
$rows[$i]->name = JCommentsObjectHelper::getTitle($rows[$i]->value, $object_group, $flang);
if ($rows[$i]->name == '') {
$rows[$i]->name = 'Untitled' . $rows[$i]->value;
}
}
// Don't show filter if we have more than 100 objects
if (count($rows) < 100) {
usort($rows, create_function('$a, $b', 'return strcasecmp( $a->name, $b->name);'));
array_unshift($rows, JCommentsHTML::makeOption('', '', 'name', 'value'));
$lists['foid'] = JCommentsHTML::selectList($rows, 'foid', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'name', $object_id);
unset($rows);
}
}
// Filter by language
$query = "SELECT DISTINCT(lang) AS text, lang AS value " . "\nFROM #__jcomments_subscriptions" . "\nORDER BY lang";
$db->setQuery($query);
$rows = $db->loadObjectList();
if (count($rows) > 1) {
array_unshift($rows, JCommentsHTML::makeOption('', '', 'text', 'value'));
$lists['flang'] = JCommentsHTML::selectList($rows, 'flang', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'text', 'value', $flang);
}
unset($rows);
// Filter by published state
$stateOptions = array();
$stateOptions[] = JCommentsHTML::makeOption('', JText::_('Select state'), 'text', 'value');
$stateOptions[] = JCommentsHTML::makeOption('-1', JText::_('All'), 'text', 'value');
$stateOptions[] = JCommentsHTML::makeOption('1', JText::_('Published'), 'text', 'value');
$stateOptions[] = JCommentsHTML::makeOption('0', JText::_('Unpublished'), 'text', 'value');
$lists['fstate'] = JCommentsHTML::selectList($stateOptions, 'fstate', 'class="inputbox" size="1" onchange="document.adminForm.submit();"', 'text', 'value', $fstate);
unset($stateOptions);
// Filter by author
$lists['fauthor'] = '';
$db->setQuery("SELECT COUNT(DISTINCT(name)) FROM #__jcomments_subscriptions;");
$usersCount = $db->loadResult();
// Don't show filter if we have more than 100 comments' authors
if ($usersCount > 0 && $usersCount < 100) {
$query = "SELECT DISTINCT(name) AS author, name AS value " . "\nFROM #__jcomments_subscriptions" . "\nORDER BY name";
$db->setQuery($query);
$rows = $db->loadObjectList();
if (count($rows) > 1) {
array_unshift($rows, JCommentsHTML::makeOption('', JText::_('A_FILTER_ALL_AUTHORS'), 'author', 'value'));
$lists['fauthor'] = JCommentsHTML::selectList($rows, 'fauthor', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'author', 'value', $fauthor);
}
unset($rows);
}
HTML_JCommentsAdminSubscriptionManager::show($lists);
}
function showImport()
{
global $mainframe;
$CommentSystems = array();
$CommentSystems[] = new JOtherCommentSystem('AkoComment', 'AkoComment', 'Arthur Konze', 'http://www.konze.de/content/view/8/26/', 'http://www.konze.de/content/view/8/26/', 'http://mamboportal.com', '#__akocomment');
$CommentSystems[] = new JOtherCommentSystem('MosCom', 'MosCom', 'Chanh Ong', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://ongetc.com', '#__content_comments');
$CommentSystems[] = new JOtherCommentSystem('ComboMax', 'ComboMax', 'Phil Taylor', 'Commercial (22.50 GPB)', '', 'http://www.phil-taylor.com/Joomla/Components/ComboMAX/', '#__combomax');
$CommentSystems[] = new JOtherCommentSystem('JoomlaComment', 'JoomlaComment', 'Frantisek Hliva', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://cavo.co.nr', '#__comment');
$CommentSystems[] = new JOtherCommentSystem('mXcomment', 'mXcomment', 'Bernard Gilly', 'Creative Commons', '', 'http://www.visualclinic.fr', '#__mxc_comments');
$CommentSystems[] = new JOtherCommentSystem('JomComment', 'JomComment', 'Azrul Rahim', 'Commercial/Free', '', 'http://www.azrul.com', '#__jomcomment');
$CommentSystems[] = new JOtherCommentSystem('jxtendedcomments', 'JXtended Comments', 'JXtended LLC', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://jxtended.com/products/comments.html', '#__jxcomments_comments');
$CommentSystems[] = new JOtherCommentSystem('chronocomments', 'Chrono Comments', 'Chronoman', 'CC', '', 'http://www.chronoengine.com/', '#__chrono_comments');
$CommentSystems[] = new JOtherCommentSystem('jacomment', 'JA Comment', 'JoomlArt', 'Copyrighted Commercial Software', '', 'www.joomlart.com', '#__jacomment_items');
$CommentSystems[] = new JOtherCommentSystem('DatsoGallery', 'DatsoGallery comments', 'Andrey Datso', 'Free', '', 'http://www.datso.fr', '#__datsogallery_comments');
$CommentSystems[] = new JOtherCommentSystem('JoomGallery', 'JoomGallery comments', 'M. Andreas Boettcher', 'Free', '', 'http://www.joomgallery.net', '#__joomgallery_comments');
$CommentSystems[] = new JOtherCommentSystem('IceGallery', 'IceGallery comments', 'Markus Donhauser', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://joomlacode.org/gf/project/ice/', '#__ice_comments');
$CommentSystems[] = new JOtherCommentSystem('Remository', 'Remository file reviews', 'Martin Brampton', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.remository.com', '#__downloads_reviews');
$CommentSystems[] = new JOtherCommentSystem('PAXXGallery', 'PAXXGallery comments', 'Tobias Floery', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.paxxgallery.com', '#__paxxcomments');
$CommentSystems[] = new JOtherCommentSystem('PhocaGallery', 'PhocaGallery comments', 'Jan Pavelka', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.phoca.cz', '#__phocagallery_comments');
$CommentSystems[] = new JOtherCommentSystem('JMovies', 'JMovies comments', 'Luscarpa & Vamba', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.jmovies.eu/', '#__jmovies_comments');
$CommentSystems[] = new JOtherCommentSystem('Cinema', 'Cinema comments', 'Vamba', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.joomlaitalia.com', '#__cinema_comments');
$CommentSystems[] = new JOtherCommentSystem('MosetsTree', 'Mosets Tree reviews', 'Mosets Consulting', 'Commercial', '', 'http://www.mosets.com', '#__mt_reviews');
$CommentSystems[] = new JOtherCommentSystem('LinkDirectory', 'LinkDirectory link comments', 'Soner Ekici', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.sonerekici.com/', '#__ldcomment');
$CommentSystems[] = new JOtherCommentSystem('zOOmMediaGallery', 'zOOm Media Gallery comments', 'Mike de Boer', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.zoomfactory.org/', '#__zoom_comments');
$CommentSystems[] = new JOtherCommentSystem('rsgallery2', 'RSGallery2 comments', 'rsgallery2.net', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://rsgallery2.net/', '#__rsgallery2_comments');
$CommentSystems[] = new JOtherCommentSystem('hotornot2', 'Hotornot2 comments', 'Aron Watson', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://joomlacode.org/gf/project/com_hotornot2/frs/', '#__hotornot_comments');
$CommentSystems[] = new JOtherCommentSystem('easycomments', 'EasyComments (www.easy-joomla.org)', 'EasyJoomla', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.easy-joomla.org/', '#__easycomments');
$CommentSystems[] = new JOtherCommentSystem('musicbox', 'MusicBox', 'Vamba', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.joomlaitalia.com', '#__musicboxrewiev');
$CommentSystems[] = new JOtherCommentSystem('jreviews', 'JReviews', 'Alejandro Schmeichler', 'Commercial', '', 'http://www.reviewsforjoomla.com', '#__jreviews_comments');
$CommentSystems[] = new JOtherCommentSystem('tutorials', 'Tutorials (comments for items)', 'NSOrg Project', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.nsorg.com', '#__tutorials_comments');
$CommentSystems[] = new JOtherCommentSystem('idoblog', 'IDoBlog', 'Sunshine studio', 'GNU/GPL', '', 'http://idojoomla.com', '#__idoblog_comments');
$CommentSystems[] = new JOtherCommentSystem('sobi2reviews', 'SOBI2 Reviews', 'SOBI2 Developer Team', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.sigsiu.net', '#__sobi2_plugin_reviews');
$CommentSystems[] = new JOtherCommentSystem('jreactions', 'J! Reactions', 'SDeCNet Software', '', '', 'http://jreactions.sdecnet.com', '#__jreactions');
$CommentSystems[] = new JOtherCommentSystem('virtuemart', 'VirtueMart product reviews', 'The VirtueMart Development Team', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.virtuemart.net', '#__vm_product_reviews');
$CommentSystems[] = new JOtherCommentSystem('akobook', 'AkoBook', 'Arthur Konze', '', '', 'http://mamboportal.com', '#__akobook');
$CommentSystems[] = new JOtherCommentSystem('jambook', 'JamBook', 'Olle Johansson', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.jxdevelopment.com/', '#__jx_jambook');
$CommentSystems[] = new JOtherCommentSystem('k2', 'K2 Comments', 'JoomlaWorks', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://k2.joomlaworks.gr/', '#__k2_comments');
$CommentSystems[] = new JOtherCommentSystem('smartblog', 'SmartBlog Comments', 'Aneesh S', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.aarthikaindia.com', '#__blog_comment');
$CommentSystems[] = new JOtherCommentSystem('urcomment', 'UrComment', 'Comdev Software Sdn Bhd', 'GPL, Commercial Software', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://joomla.comdevweb.com', '#__urcomment');
$CommentSystems[] = new yvCommentSystem('yvcomment', 'yvComment', 'Yuri Volkov', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://yurivolkov.com/Joomla/yvComment/index_en.html', '#__yvcomment');
$CommentSystems[] = new JOtherCommentSystem('zimb', 'ZiMB Comment', 'ZiMB LLC', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.zimbllc.com/Software/zimbcomment', '#__zimbcomment_comment');
$CommentSystems[] = new JOtherCommentSystem('rdbscomment', 'RDBS Commment', 'Robert Deutz', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.rdbs.de', '#__rdbs_comment_comments');
$CommentSystems[] = new JOtherCommentSystem('lyftenbloggie', 'LyftenBloggie', 'Lyften Designs', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.lyften.com', '#__bloggies_comments');
$CommentSystems[] = new JOtherCommentSystem('webee', 'Webee Comment', 'Onno Groen', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.onnogroen.nl/webee/', '#__webeecomment_comment');
$CommentSystems[] = new JOtherCommentSystem('resource', 'MightyExtensions Resource comments', 'MightyExtensions', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://mightyextensions.com/', '#__js_res_comments');
$CommentSystems[] = new JOtherCommentSystem('tpdugg', 'TPDugg', 'TemplatePlazza', '', '', 'http://templateplazza.com/', '#__tpdugg_comments');
$CommentSystems[] = new JOtherCommentSystem('zoo', 'ZOO Comments', 'YOOtheme', 'GNU/GPLv2', 'http://www.gnu.org/licenses/gpl-2.0.html GNU/GPLv2 only', 'http://zoo.yootheme.com', '#__zoo_comment');
$CommentSystems[] = new JOtherCommentSystem('beeheard', 'BeeHeard Comments', 'Kaysten Mazerino', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://www.cmstactics.com', '#__beeheard_comments');
$CommentSystems[] = new JOtherCommentSystem('jmylife', 'JMyLife Comments', 'Jeff Channell', 'GNU/GPL', 'http://www.gnu.org/copyleft/gpl.html', 'http://jeffchannell.com', '#__jmylife_comments');
$CommentSystems[] = new JOtherCommentSystem('muscol', 'Music Colllection Comments', 'Germinal Camps', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.joomlamusicsolutions.com', '#__muscol_comments');
$CommentSystems[] = new JOtherCommentSystem('rscomments', 'RSComments', 'RSJoomla', 'GNU/GPL', 'http://www.gnu.org/licenses/gpl-2.0.html', 'http://www.rsjoomla.com/joomla-components/joomla-comments.html', '#__rscomments_comments');
$db =& JCommentsFactory::getDBO();
$db->setQuery("SHOW tables");
$tables = $db->loadResultArray();
foreach ($tables as $tblval) {
for ($i = 0, $n = count($CommentSystems); $i < $n; $i++) {
$table_mask = str_replace('#_', '', $CommentSystems[$i]->table);
if (preg_match('/' . $table_mask . '$/i', $tblval)) {
$CommentSystems[$i]->found = true;
$CommentSystems[$i]->UpdateCount();
}
}
}
$languages = array();
$joomfish = JOOMLATUNE_JPATH_SITE . DS . 'components' . DS . 'com_joomfish' . DS . 'joomfish.php';
if (is_file($joomfish)) {
$db =& JCommentsFactory::getDBO();
$db->setQuery("SELECT name, `code` as value FROM #__languages WHERE active = 1");
$languages = $db->loadObjectList();
}
if (JCOMMENTS_JVERSION == '1.5') {
$params = JComponentHelper::getParams('com_languages');
$lang = $params->get("site", 'en-GB');
} else {
$lang = JCommentsMultilingual::getLanguage();
}
$ajaxUrl = JCommentsFactory::getLink('ajax-backend');
?>
<script type="text/javascript" src="<?php
echo $mainframe->getCfg('live_site');
?>
/components/com_jcomments/libraries/joomlatune/ajax.js?v=2"></script>
<script type="text/javascript" src="<?php
echo $mainframe->getCfg('live_site');
?>
/administrator/components/com_jcomments/assets/jcomments-backend-v2.1.js"></script>
<script type="text/javascript">
<!--
function JCommentsImportCommentsAJAX() {
try{
jtajax.setup({url:'<?php
echo $ajaxUrl;
?>
'});
return jtajax.call('JCommentsImportCommentsAjax',null,'post','adminForm');
}catch(e){
return false;
}
}
function submitbutton(pressbutton) {
var form = document.adminForm;
if (pressbutton == 'cancel') {
submitform( pressbutton );
return;
}
JCommentsImportCommentsAJAX();
}
//-->
</script>
<script type="text/javascript">
<!--
var jc_comments = new Array(
<?php
$jsArray = array();
foreach ($CommentSystems as $CommentSystem) {
if ($CommentSystem->found) {
$jsArray[] = $CommentSystem->code;
}
}
echo "'" . implode("', '", $jsArray) . "'";
?>
);
function importMode( mode ) {
if(document.getElementById) {
for(var i=0;i<jc_comments.length;i++) {
if (mode == jc_comments[i]) {
document.getElementById('import' + jc_comments[i]).checked = true;
document.getElementById('import' + jc_comments[i]+'Info').style.display = '';
} else {
document.getElementById('import' + jc_comments[i]).checked = false;
document.getElementById('import' + jc_comments[i]+'Info').style.display = 'none';
}
}
}
}
//-->
</script>
<style type="text/css">
#jcomments-message {padding: 0 0 0 25px;margin: 0; width: auto; float: right; font-size: 14px; font-weight: bold;}
.jcomments-message-error {background: transparent url(components/com_jcomments/assets/error.gif) no-repeat 4px 50%; color: red;}
.jcomments-message-info {background: transparent url(components/com_jcomments/assets/info.gif) no-repeat 4px 50%; color: green;}
fieldset { border: 1px #999 solid; }
span.note { color: #777; }
table.componentinfo td { color: #777; padding: 0; }
</style>
<div id="jc">
<form action="<?php
echo JCOMMENTS_INDEX;
?>
" method="post" name="adminForm" id="adminForm">
<input type="hidden" name="option" value="com_jcomments" />
<input type="hidden" name="task" value="" />
<?php
if (JCOMMENTS_JVERSION == '1.0') {
?>
<table class="adminheading">
<tr>
<th style="background-image: none; padding: 0;"><img src="./components/com_jcomments/assets/import48x48.png" width="48" height="48" align="middle"> <?php
echo JText::_('A_IMPORT');
?>
</th>
</tr>
</table>
<?php
}
?>
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr valign="top">
<td align="right"> </td>
<td width="50%" align="right"><div id="jcomments-message-holder"></div></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="4" cellspacing="2" class="adminform">
<tr>
<td>
<fieldset>
<legend><?php
echo JText::_('A_IMPORT_SELECT_SOURCE');
?>
</legend>
<table cellpadding="1" cellspacing="1" border="0">
<?php
$foundSources = 0;
foreach ($CommentSystems as $CommentSystem) {
if ($CommentSystem->found) {
$foundSources++;
?>
<tr valign="top" align="left">
<td><input type="radio" id="import<?php
echo $CommentSystem->code;
?>
" name="vars[import]" value="<?php
echo $CommentSystem->code;
?>
" onclick="importMode('<?php
echo $CommentSystem->code;
?>
')" <?php
echo $CommentSystem->found ? '' : 'disabled';
?>
/></td>
<td><label for="import<?php
echo $CommentSystem->code;
?>
"><?php
echo $CommentSystem->name;
?>
<?php
echo $CommentSystem->found ? '' : '<span class="note">[' . JText::_('A_IMPORT_COMPONENT_NOT_INSTALLED') . ']</span>';
?>
</label></td>
<td><div id="jcomments-message-<?php
echo strtolower($CommentSystem->code);
?>
"></div></td>
</tr>
<tr id="import<?php
echo $CommentSystem->code;
?>
Info" style="display: none;">
<td> </td>
<td>
<table cellpadding="0" cellspacing="0" border="0" class="componentinfo">
<tr>
<td width="150px"><?php
echo JText::_('A_IMPORT_COMPONENT_AUTHOR');
?>
</td>
<td><?php
echo $CommentSystem->author;
?>
</td>
</tr>
<tr>
<td><?php
echo JText::_('A_IMPORT_COMPONENT_HOMEPAGE');
?>
</td>
<td><a href="<?php
echo $CommentSystem->homepage;
?>
" target="_blank"><?php
echo str_replace('http://', '', $CommentSystem->homepage);
?>
</a></td>
</tr>
<tr>
<td><?php
echo JText::_('A_IMPORT_COMPONENT_LICENSE');
?>
</td>
<td>
<?php
if ($CommentSystem->license_url != '') {
?>
<a href="<?php
echo $CommentSystem->license_url;
?>
" target="_blank"><?php
echo $CommentSystem->license;
?>
</a>
<?php
} else {
?>
<?php
echo $CommentSystem->license;
}
?>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr valign="top" align="left">
<td>
<?php
echo JText::_('A_IMPORT_COMPONENT_COMMENTS_COUNT');
?>
</td>
<td>
<label for="import<?php
echo $CommentSystem->code;
?>
"><?php
echo $CommentSystem->count;
?>
</label>
<br />
<?php
if (count($languages)) {
echo JCommentsHTML::selectList($languages, strtolower($CommentSystem->code) . '_lang', 'class="inputbox" size="1"', 'value', 'name', $lang) . ' ';
}
?>
<input type="button" id="import<?php
echo $CommentSystem->code;
?>
" name="import<?php
echo $CommentSystem->code;
?>
" value="<?php
echo JText::_('A_IMPORT_DO_IMPORT');
?>
" onclick="submitbutton('doimport')" <?php
echo $CommentSystem->count ? '' : 'disabled';
?>
/>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</td>
</tr>
<?php
}
}
if ($foundSources == 0) {
?>
<tr>
<td><?php
echo JText::_('A_IMPORT_NO_SOURCES');
?>
</td>
</tr>
<?php
}
?>
</table>
</fieldset>
</td>
</tr>
</table>
</form>
</div>
<?php
}
function showSettings()
{
$db =& JCommentsFactory::getDBO();
$config =& JCommentsFactory::getConfig();
// check current site template for afterDisplayContent event
if (JCOMMENTS_JVERSION == '1.5') {
$db->setQuery('SELECT template FROM #__templates_menu WHERE client_id = 0 AND menuid = 0', 0, 1);
$template = $db->loadResult();
$articleTemplate = JPATH_SITE . DS . 'templates' . DS . $template . DS . 'html' . DS . 'com_content' . DS . 'article' . DS . 'default.php';
if (is_file($articleTemplate)) {
$tmpl = implode('', file($articleTemplate));
if (strpos($tmpl, 'afterDisplayContent') === false) {
JError::raiseWarning(500, JText::_('Your current site template doesn\'t have afterDisplayContent event!'));
}
}
}
$languages = array();
$joomfish = JOOMLATUNE_JPATH_SITE . DS . 'components' . DS . 'com_joomfish' . DS . 'joomfish.php';
if (is_file($joomfish)) {
$db =& JCommentsFactory::getDBO();
$db->setQuery("SELECT `name`, `code` as value FROM `#__languages` WHERE `active` = 1");
$languages = $db->loadObjectList();
if (is_array($languages)) {
$lang = trim(JCommentsInput::getVar('lang', ''));
if ($lang == '') {
if (JCOMMENTS_JVERSION == '1.5') {
$params = JComponentHelper::getParams('com_languages');
$lang = $params->get("site", 'en-GB');
}
if ($lang == '') {
$lang = JCommentsMultilingual::getLanguage();
}
}
// reload configuration
$config =& JCommentsFactory::getConfig($lang);
$lists['languages'] = JCommentsHTML::selectList($languages, 'lang', 'class="inputbox" size="1" onchange="submitform(\'settings\');"', 'value', 'name', $lang);
}
}
$forbiddenNames = $config->get('forbidden_names');
$forbiddenNames = preg_replace('#,+#', "\n", $forbiddenNames);
$config->set('forbidden_names', $forbiddenNames);
$badWords = $config->get('badwords');
if ($badWords != '') {
$config->set('badwords', implode("\n", $badWords));
}
require_once JCOMMENTS_LIBRARIES . DS . 'joomlatune' . DS . 'filesystem.php';
// path to images directory
$path = JCOMMENTS_BASE . DS . 'tpl' . DS;
$items = JoomlaTuneFS::readDirectory($path);
$templates = array();
foreach ($items as $item) {
if (is_dir($path . $item)) {
$tpl = new StdClass();
$tpl->text = $item;
$tpl->value = $item;
$templates[] = $tpl;
}
}
$currentTemplate = $config->get('template');
$lists['templates'] = JCommentsHTML::selectList($templates, 'cfg_template', 'class="inputbox"', 'value', 'text', $currentTemplate);
$rows = JCommentsAdmin::getAllGroups();
$exclude = JCommentsAdmin::getHigherGroups();
if (count($exclude)) {
// remove users 'above' me
$i = 0;
while ($i < count($rows)) {
if (in_array($rows[$i]->group_id, $exclude)) {
array_splice($rows, $i, 1);
} else {
$i++;
}
}
}
$captchaError = '';
$captchaExclude = array();
if (!extension_loaded('gd') || !function_exists('imagecreatefrompng')) {
if ($config->get('captcha_engine', 'kcaptcha') != 'recaptcha') {
foreach ($rows as $row) {
$captchaExclude[] = $row->value;
}
$captchaError = JText::_('GD library is not installed!');
}
}
$lists['group_names'] = $rows;
$groups = array();
// Post
JCommentsAdmin::loadParam($groups, 'can_comment', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_CAN_COMMENT'), JText::_('AP_CAN_COMMENT_DESC'));
JCommentsAdmin::loadParam($groups, 'can_reply', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_CAN_REPLY'), JText::_('AP_CAN_REPLY_DESC'));
JCommentsAdmin::loadParam($groups, 'autopublish', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_AUTOPUBLISH'), JText::_('AP_AUTOPUBLISH_DESC'));
JCommentsAdmin::loadParam($groups, 'show_policy', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_SHOW_POLICY'), JText::_('AP_SHOW_POLICY_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_captcha', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_CAPTCHA'), JText::_('AP_ENABLE_CAPTCHA_DESC'), $captchaExclude, $captchaError);
JCommentsAdmin::loadParam($groups, 'floodprotection', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_FLOODPROTECTION'), JText::_('AP_ENABLE_FLOODPROTECTION_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_comment_length_check', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_COMMENT_LENGTH_CHECK'), JText::_('AP_ENABLE_COMMENT_LENGTH_CHECK_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_autocensor', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_AUTOCENSOR'), JText::_('AP_ENABLE_AUTOCENSOR_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_subscribe', $rows, JText::_('A_RIGHTS_POST'), JText::_('AP_ENABLE_SUBSCRIBE'), JText::_('AP_ENABLE_SUBSCRIBE_DESC'));
// BBCodes
JCommentsAdmin::loadParam($groups, 'enable_bbcode_b', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_B'), JText::_('AP_ENABLE_BBCODE_B_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_i', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_I'), JText::_('AP_ENABLE_BBCODE_I_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_u', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_U'), JText::_('AP_ENABLE_BBCODE_U_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_s', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_S'), JText::_('AP_ENABLE_BBCODE_S_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_url', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_URL'), JText::_('AP_ENABLE_BBCODE_URL_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_img', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_IMG'), JText::_('AP_ENABLE_BBCODE_IMG_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_list', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_LIST'), JText::_('AP_ENABLE_BBCODE_LIST_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_hide', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_HIDE'), JText::_('AP_ENABLE_BBCODE_HIDE_DESC'), array('Unregistered'));
JCommentsAdmin::loadParam($groups, 'enable_bbcode_quote', $rows, JText::_('A_RIGHTS_BBCODE'), JText::_('AP_ENABLE_BBCODE_QUOTE'), JText::_('AP_ENABLE_BBCODE_QUOTE_DESC'));
// View
JCommentsAdmin::loadParam($groups, 'autolinkurls', $rows, JText::_('A_RIGHTS_VIEW'), JText::_('AP_ENABLE_AUTOLINKURLS'), JText::_('AP_ENABLE_AUTOLINKURLS_DESC'));
JCommentsAdmin::loadParam($groups, 'emailprotection', $rows, JText::_('A_RIGHTS_VIEW'), JText::_('AP_ENABLE_EMAILPROTECTION'), JText::_('AP_ENABLE_EMAILPROTECTION_DESC'));
JCommentsAdmin::loadParam($groups, 'enable_gravatar', $rows, JText::_('A_RIGHTS_VIEW'), JText::_('AP_ENABLE_GRAVATAR'), JText::_('AP_ENABLE_GRAVATAR_DESC'));
JCommentsAdmin::loadParam($groups, 'can_view_email', $rows, JText::_('A_RIGHTS_VIEW'), JText::_('AP_CAN_VIEW_AUTHOR_EMAIL'), JText::_('AP_CAN_VIEW_AUTHOR_EMAIL_DESC'));
JCommentsAdmin::loadParam($groups, 'can_view_homepage', $rows, JText::_('A_RIGHTS_VIEW'), JText::_('AP_CAN_VIEW_AUTHOR_HOMEPAGE'), JText::_('AP_CAN_VIEW_AUTHOR_HOMEPAGE_DESC'));
JCommentsAdmin::loadParam($groups, 'can_view_ip', $rows, JText::_('A_RIGHTS_VIEW'), JText::_('AP_CAN_VIEW_AUTHOR_IP'), JText::_('AP_CAN_VIEW_AUTHOR_IP_DESC'), array('Unregistered', 'Registered'));
// Edit
JCommentsAdmin::loadParam($groups, 'can_edit_own', $rows, JText::_('A_RIGHTS_EDIT'), JText::_('AP_CAN_EDIT_OWN'), JText::_('AP_CAN_EDIT_OWN_DESC'), array('Unregistered'));
JCommentsAdmin::loadParam($groups, 'can_delete_own', $rows, JText::_('A_RIGHTS_EDIT'), JText::_('AP_CAN_DELETE_OWN'), JText::_('AP_CAN_DELETE_OWN_DESC'), array('Unregistered'));
// Administration
JCommentsAdmin::loadParam($groups, 'can_edit', $rows, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_EDIT'), JText::_('AP_CAN_EDIT_DESC'), array('Unregistered', 'Registered'));
JCommentsAdmin::loadParam($groups, 'can_publish', $rows, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_PUBLISH'), JText::_('AP_CAN_PUBLISH_DESC'), array('Unregistered', 'Registered'));
JCommentsAdmin::loadParam($groups, 'can_delete', $rows, JText::_('A_RIGHTS_ADMINISTRATION'), JText::_('AP_CAN_DELETE'), JText::_('AP_CAN_DELETE_DESC'), array('Unregistered', 'Registered'));
// Votes
JCommentsAdmin::loadParam($groups, 'can_vote', $rows, JText::_('A_RIGHTS_MISC'), JText::_('AP_CAN_VOTE'), JText::_('AP_CAN_VOTE_DESC'));
$reportError = '';
$reportExclude = array();
if ($config->getInt('enable_notification') == 0 || $config->check('notification_type', 2) == false) {
foreach ($rows as $row) {
$reportExclude[] = $row->value;
}
$reportError = JText::_('Notifications are disabled! Please, enable notifications first.');
}
JCommentsAdmin::loadParam($groups, 'can_report', $rows, JText::_('A_RIGHTS_MISC'), JText::_('AP_CAN_REPORT'), JText::_('AP_CAN_REPORT_DESC'), $reportExclude, $reportError);
$lists['groups'] =& $groups;
if ($config->get('enable_categories') != '') {
$query = "SELECT c.id AS `value`, CONCAT_WS( ' / ', s.title, c.title) AS `text`" . "\n FROM #__sections AS s" . "\n INNER JOIN #__categories AS c ON c.section = s.id" . "\n WHERE c.id IN ( " . $config->get('enable_categories') . " )" . "\n ORDER BY s.name,c.name";
$db->setQuery($query);
$lookup = $db->loadObjectList();
} else {
$lookup = '';
}
$query = "SELECT c.id AS `value`, CONCAT_WS( ' / ', s.title, c.title) AS `text`" . "\n FROM #__sections AS s" . "\n INNER JOIN #__categories AS c ON c.section = s.id" . "\n ORDER BY s.name,c.name";
$db->setQuery($query);
$categories = $db->loadObjectList();
if (!is_array($categories)) {
$categories = array();
}
$lists['categories'] = JCommentsHTML::selectList($categories, 'cfg_enable_categories[]', 'class="inputbox" size="10" multiple="multiple"', 'value', 'text', $lookup);
$captcha = array();
$captcha[] = JCommentsHTML::makeOption('kcaptcha', 'KCAPTCHA');
require_once JCOMMENTS_HELPERS . DS . 'plugin.php';
JCommentsPluginHelper::importPlugin('jcomments');
$enginesList = JCommentsPluginHelper::trigger('onJCommentsCaptchaEngines');
foreach ($enginesList as $engines) {
foreach ($engines as $code => $text) {
$captcha[] = JCommentsHTML::makeOption($code, $text);
}
}
$disabledCAPTCHA = count($captcha) == 1 ? ' disabled="disabled"' : '';
$lists["captcha"] = JCommentsHTML::selectList($captcha, 'cfg_captcha_engine', 'class="inputbox"' . $disabledCAPTCHA, 'value', 'text', $config->get('captcha_engine'));
HTML_JComments::showSettings($lists);
}