, нужно
Код PHP:
{$comtable}
Вы имеете в виду FROM {$comtable} ?
Нет, проблема не в этом. Оно $comment_id на входе в функцию не подхватывает.
, нужно
Код PHP:
{$comtable}
В вашем случае в каждую ф-цию где есть cms_comments
public function getComments($only_published=true, $is_tree=false, $from_module = false) { if ($comment_id > 15) {$comtable = 'cms_comments';} else {$comtable = 'cms_comments_old';} $inUser = cmsUser::getInstance(); global $_LANG; $published = $only_published ? 'c.published = 1' : '1=1'; $sql = "SELECT c.*, IFNULL(u.nickname, 0) as nickname, IFNULL(u.login, 0) as login, IFNULL(u.is_deleted, 0) as is_deleted, IFNULL(p.imageurl, 0) as imageurl, IFNULL(p.gender, 0) as gender FROM $comtable c LEFT JOIN cms_users u ON u.id = c.user_id LEFT JOIN cms_user_profiles p ON p.user_id = u.id WHERE {$published} {$this->inDB->where} {$this->inDB->group_by} {$this->inDB->order_by}\n"; if ($this->inDB->limit){ $sql .= "LIMIT {$this->inDB->limit}"; } $result = $this->inDB->query($sql); $this->inDB->resetConditions(); while($comment = $this->inDB->fetch_assoc($result)){ $comment['level'] = 0; $comment['is_editable'] = $this->isEditable($comment['pubdate']); $comment['fpubdate'] = cmsCore::dateFormat($comment['pubdate'], true, true); if ($comment['guestname']){ $comment['author'] = $comment['guestname']; $comment['is_profile'] = false; } else { $comment['author']['nickname'] = $comment['nickname']; $comment['author']['login'] = $comment['login']; $comment['is_profile'] = true; $comment['user_image'] = cmsUser::getUserAvatarUrl($comment['user_id'], 'small', $comment['imageurl'], $comment['is_deleted']); $comment['ip'] = ($this->config['cmm_ip'] == 2 && $comment['ip']) ? $comment['ip'] : ''; } switch ($comment['gender']){ case 'm': $comment['gender'] = $_LANG['COMMENTS_MALE']; break; case 'f': $comment['gender'] = $_LANG['COMMENTS_FEMALE']; break; default: $comment['gender'] = $_LANG['COMMENTS_GENDER']; } $comment['show'] = (!$this->config['min_karma'] || $comment['rating'] >= $this->config['min_karma_show']) || cmsUser::userIsAdmin($comment['user_id']); $comment['is_my'] = ($inUser->id == $comment['user_id']); if ($inUser->id){ $comment['is_voted'] = $comment['is_my'] ? true : cmsUser::isRateUser('comment', $inUser->id, $comment['id']); } else { $comment['is_voted'] = true; } if ($inUser->id){ $quest['is_voted'] = $quest['is_my'] ? true : cmsUser::isRateUser('quest', $inUser->id, $quest['id']); } else { $quest['is_voted'] = true; } $comments[] = $comment; } if($is_tree){ $comments = $this->buildTree(0, 0, $comments); } return $from_module ? cmsCore::callEvent('GET_COMMENTS_MODULE', $comments) : cmsCore::callEvent('GET_COMMENTS', $comments); }
if (comment_id > (какое-то значение)) { $comtable = 'cms_comments';} else { $comtable = 'cms_comments_old';}
$nickname = cmsCore::request('nickname', 'str', '');
<span class="cmm_author"><a href="javascript:void(0)" onclick="addComment('{$target|escape:'html'}', '{$target_id}', {$comment.id}, '[b]{$comment.author.nickname}[/b],')" title="{$LANG.ADD_NICKNAME}" class="ajaxlink">{$comment.author.nickname}</a> {if $is_admin && $comment.ip}({$comment.ip}){/if}</span>
function addComment(target, target_id, parent_id, nickname){ $('.cm_addentry').remove(); $('.cm_add_link').show(); $link_span = $('#cm_add_link'+parent_id); old_html = $link_span.html(); loading_img = '<img src="/images/ajax-loader.gif"/>'; $link_span.html(loading_img); $.post('/components/comments/addform.php', {target: target, target_id: target_id, parent_id: parent_id, nickname: nickname}, function(data) { if(data){ $("#cm_addentry"+parent_id).html(data).fadeIn(); $('#content').focusToEnd(); $().br; $link_span.html(old_html).hide(); $('#submit_cmm').click(function() { $('#submit_cmm').prop('disabled', true); $('#cancel_cmm').hide(); $('.submit_cmm').append(loading_img); var options = { success: showResponseAdd, dataType: 'json' }; $('#msgform').ajaxSubmit(options); }); } }); } $.fn.focusToEnd = function() { var v = $(this).val(); $(this).focus().val("").val(v); }); };
cmsPage::initTemplate('components', 'com_comments_add')-> assign('user_can_add', $model->is_can_add)-> assign('is_can_bbcode', $model->is_can_bbcode)-> assign('do', $do)-> assign('is_user', $inUser->id)-> assign('nickname', $nickname." ")-> assign('cfg', $model->config)-> assign('target', $target)-> assign('target_id', $target_id)-> assign('parent_id', $parent_id)-> assign('user_subscribed', cmsUser::isSubscribed($inUser->id, $target, $target_id))-> assign('can_by_karma', $can_by_karma)-> assign('karma_need', $karma_need)-> assign('karma_has', $inUser->karma)-> assign('need_captcha', $need_captcha)-> display('com_comments_add.tpl');
Что интересно 2 значные домены не хочет регистрировать, например nn.online
Тоталкомандер может скачивать файлы по http?
Достаточно конвертировать базу штатным мигратором 1.10.1 в utf8сначало лучше перенести до 1.10.6 а уже потом на 2.2.1 теми конвертерами.
instantcms.ru/blogs/poleznosti-ot-sjen/migrator-dlja-instantcms-1-2-2-1-polzovateli-i-vse-svjazanye-tablicy.htmlГде то еще был мигратор пользователей.