2011年7月26日星期二

Joomla的Myblog组件与Jcomments集成

原方法来自俄罗斯的Joomla的爱好者的论坛:http://joomlaforum.ru/index.php/topic,41316.0.html
我在Joomla 1.5.21 +Myblog 3.0.332+Jcomments 2.2.0.2 上测试通过!
1、 打开 /administrator/components/com_myblog/config.myblog.php;
2、查找:$db->setQuery("SELECT id FROM #__components WHERE `option`='com_jomcomment'");
    替换成:$db->setQuery("SELECT id FROM #__components WHERE `option`='com_jcomments'");
3、查找:$db->setQuery("SELECT count(*) FROM #__components WHERE `option`='com_jomcomment'");
    替换成:$db->setQuery("SELECT count(*) FROM #__components WHERE `option`='com_jcomments'");
4、打开 /components/com_myblog/task/show.php;
5、查找:
jimport( 'joomla.filesystem.file');

$file    = JPATH_PLUGINS . DS . 'content' . DS . 'jom_comment_bot.php';
if (JFile::exists( $file ) )
{
require_once( $file );

// Check if admin allows user to enable or disable the comment on the blog
if($_MY_CONFIG->get('enableJCDashboard'))
{
if(eregi('\{!jomcomment\}',$row->text))
{
$row->text    = str_replace('{!jomcomment}','',$row->text);
}
else if(eregi('\{jomcomment\}',$row->text))
{
$row->text    = str_replace('{jomcomment}','',$row->text);
$row->comments    = "";
$row->comments     = jomcomment($row->id, "com_myblog");
}
else if(eregi('\{jomcomment lock\}', $row->text) )
{
$row->text    = str_replace('{jomcomment lock}','',$row->text);
$row->comments    = "";
$row->comments     = jomcomment($row->id, "com_myblog" , '' , '' , true );
}
else
{
// Default
// User is not allowed to enable or disable comments
// so we use the default value to display
$row->comments    = "";
$row->comments     = jomcomment($row->id, "com_myblog");
}
}
else
{
// User is not allowed to enable or disable comments
// so we use the default value to display
$row->comments    = "";
$row->comments     = jomcomment($row->id, "com_myblog");
}
}



替换成:
jimport( 'joomla.filesystem.file');
$file = JPATH_SITE . DS . 'components' . DS . 'com_jcomments' . DS . 'jcomments.php';
if (JFile::exists($file)) {
require_once($file);
$row->comments = JComments::showComments($row->id, 'com_myblog', $row->title);
}

6、打开 /components/com_myblog/functions.myblog.php;

7、查找:$db->setQuery("SELECT COUNT(*) FROM #__jomcomment WHERE contentid='$article_Id' AND (`option`='$com' OR `option`='com_content') AND published='1'");
替换成:$db->setQuery("SELECT COUNT(*) FROM #__jcomments WHERE object_id='$article_Id' AND (`object_group`='$com' OR `object_group`='com_content') AND published='1'");
8、查找:
$strSQL = "SELECT COUNT(*) FROM #__jomcomment AS a "
. "INNER JOIN #__content AS b "
. "WHERE b.id=a.contentid "
. "AND a.option='com_myblog' "
. "AND b.created_by='{$uid}'";
替换成:
$strSQL = "SELECT COUNT(*) FROM #__jcomments AS a "
. "INNER JOIN #__content AS b "
. "WHERE b.id=a.object_id "
. "AND a.object_group='com_myblog' "
. "AND b.created_by='{$uid}'";
9、在后台清空缓存之后,就可以在myblog的文章下面看到Jcomments的评论输入框了。
10、说明,这些修改,不确定是不是支持{jcomments on}这些参数。

2011年7月5日星期二

Livezilla升级指南

1、备份Livezilla数据库和文件夹;

2、安装新版本(full);

3、启动Livezilla Server Admin

4、

Image

5、

Image(1)

6、之后新建管理员,然后输入 正确的FTP账号密码、上传的路径、SQL的账号密码、数据库名、前缀,完成升级;

7、重要,恢复Group和User

将备份的Livezilla文件夹中的_groups和_internal文件夹,还原。

PS:还原之后,新建的管理员账号将失效,还原成以前的了。