Thread: [pLog-CVS] plog_plugins/plugins plugintopkarmaposts.class.php,NONE,1.1 pluginkarma.class.php,1.4,1.5
Brought to you by:
jondaley
From: Oscar R. <phu...@us...> - 2004-05-27 16:17:46
|
Update of /cvsroot/plog/plog_plugins/plugins In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31723/plugins Modified Files: pluginkarma.class.php pluginrecentcomments.class.php pluginrecenttrackbacks.class.php pluginsmileys.class.php plugintopcommentposts.class.php plugintopreadposts.class.php Added Files: plugintopkarmaposts.class.php Log Message: updated some of mark's plugins, fixed a little mistake in the smileys plugin and made the first public release of the karma plugin Index: pluginrecentcomments.class.php =================================================================== RCS file: /cvsroot/plog/plog_plugins/plugins/pluginrecentcomments.class.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** pluginrecentcomments.class.php 26 May 2004 20:34:56 -0000 1.2 --- pluginrecentcomments.class.php 27 May 2004 16:17:33 -0000 1.3 *************** *** 33,41 **** if ($based == 'BLOG') { $query = "SELECT ".$prefix."articles_comments.* FROM ".$prefix."articles_comments, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."articles_comments.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId; $query .= " ORDER BY ".$prefix."articles_comments.date DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT * FROM ".$prefix."articles_comments"; ! $query .= " ORDER BY date DESC"; } else { return false; --- 33,42 ---- if ($based == 'BLOG') { $query = "SELECT ".$prefix."articles_comments.* FROM ".$prefix."articles_comments, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."articles_comments.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId." AND ".$prefix."articles.status = 'published'"; $query .= " ORDER BY ".$prefix."articles_comments.date DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT ".$prefix."articles_comments.* FROM ".$prefix."articles_comments, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."articles_comments.article_id = ".$prefix."articles.id AND ".$prefix."articles.status = 'published'"; ! $query .= " ORDER BY ".$prefix."articles_comments.date DESC"; } else { return false; Index: pluginrecenttrackbacks.class.php =================================================================== RCS file: /cvsroot/plog/plog_plugins/plugins/pluginrecenttrackbacks.class.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** pluginrecenttrackbacks.class.php 26 May 2004 20:34:56 -0000 1.2 --- pluginrecenttrackbacks.class.php 27 May 2004 16:17:33 -0000 1.3 *************** *** 31,39 **** if ($based == 'BLOG') { $query = "SELECT ".$prefix."trackbacks.* FROM ".$prefix."trackbacks, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."trackbacks.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId; $query .= " ORDER BY ".$prefix."trackbacks.date DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT * FROM ".$prefix."trackbacks"; ! $query .= " ORDER BY date DESC"; } else { return false; --- 31,40 ---- if ($based == 'BLOG') { $query = "SELECT ".$prefix."trackbacks.* FROM ".$prefix."trackbacks, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."trackbacks.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId." AND ".$prefix."articles.status = 'published'"; $query .= " ORDER BY ".$prefix."trackbacks.date DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT ".$prefix."trackbacks.* FROM ".$prefix."trackbacks, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."trackbacks.article_id = ".$prefix."articles.id AND ".$prefix."articles.status = 'published'"; ! $query .= " ORDER BY ".$prefix."trackbacks.date DESC"; } else { return false; Index: plugintopcommentposts.class.php =================================================================== RCS file: /cvsroot/plog/plog_plugins/plugins/plugintopcommentposts.class.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** plugintopcommentposts.class.php 26 May 2004 20:34:56 -0000 1.1 --- plugintopcommentposts.class.php 27 May 2004 16:17:33 -0000 1.2 *************** *** 35,43 **** $query = "SELECT ".$prefix."articles_comments.article_id,count(".$prefix."articles_comments.article_id) as comment_count"; $query .= " FROM ".$prefix."articles_comments, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."articles_comments.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId; $query .= " GROUP BY ".$prefix."articles_comments.article_id ORDER BY comment_count DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT article_id,count(article_id) as comment_count FROM ".$prefix."articles_comments"; ! $query .= " GROUP BY article_id ORDER BY comment_count DESC"; } else { return false; --- 35,45 ---- $query = "SELECT ".$prefix."articles_comments.article_id,count(".$prefix."articles_comments.article_id) as comment_count"; $query .= " FROM ".$prefix."articles_comments, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."articles_comments.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId." AND ".$prefix."articles.status = 'published'"; $query .= " GROUP BY ".$prefix."articles_comments.article_id ORDER BY comment_count DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT ".$prefix."articles_comments.article_id,count(".$prefix."articles_comments.article_id) as comment_count"; ! $query .= " FROM ".$prefix."articles_comments, ".$prefix."articles"; ! $query .= " WHERE ".$prefix."articles_comments.article_id = ".$prefix."articles.id AND ".$prefix."articles.status = 'published'"; ! $query .= " GROUP BY ".$prefix."articles_comments.article_id ORDER BY comment_count DESC"; } else { return false; --- NEW FILE: plugintopkarmaposts.class.php --- <?php include_once( PLOG_CLASS_PATH."class/plugin/pluginbase.class.php" ); include_once( PLOG_CLASS_PATH."class/plugin/pluginmanager.class.php" ); include_once( PLOG_CLASS_PATH."class/karma/karmalib.class.php" ); include_once( PLOG_CLASS_PATH."class/dao/articles.class.php" ); include_once( PLOG_CLASS_PATH."class/dao/article.class.php" ); /** * Plugin that offers features to returns the top karma posts object of current blog */ class PluginTopKarmaPosts extends PluginBase { function PluginTopKarmaPosts() { $this->author = "Mark Wu"; $this->desc = "This plugin offers the rank list of articles by scores of karma. Usage as follow:<br /><br />Add the following code to footer.template<br /><br /><strong><p><br /><strong>Top Karma Post</strong><br /><br />{assign var=posts value=\$topkarmaposts->getTopKarmaPosts()}<br />{foreach from=\$posts item=post}<br />{assign var=postid value=\$post->getId()}<br />{assign var=karmascore value=\$topkarmaposts->getArticleKarma(\$postid)}<br /><li><a title="{\$post->getText()|truncate:150:"..."|escape}" href="{\$url->postLink(\$post)}">{\$post->getTopic()}</a> (+{\$karmascore.positive_karma}/-{\$karmascore.negative_karma})</li><br />{/foreach}<br /></p><br /></p></strong> <br /><br />You can use <br /><br /><strong>getTopKarmaPosts(5)</strong> to get top 5 karma posts. The default view is BLOG. <br /><strong>getTopKarmaPosts(10, 'SITE')</strong> to get top 10 karm posts from SITE view. It is very convenient for pLog Host Provider.<br /><br />"; $this->PluginBase(); } /** * Returns the top karma posts object of current blog */ function getTopKarmaPosts($maxPosts = 3, $based = 'BLOG') { $karmascores = new KarmaScores(); $config = new Config(); $prefix = $config->getValue('db_prefix'); $blogId = $this->blogInfo->getId(); if ($based == 'BLOG') { $query = "SELECT ".$prefix."karma_scores.article_id, ".$prefix."karma_scores.positive_karma-".$prefix."karma_scores.negative_karma as article_karma_score"; $query .= " FROM ".$prefix."karma_scores, ".$prefix."articles"; $query .= " WHERE ".$prefix."karma_scores.article_id = ".$prefix."articles.id AND ".$prefix."articles.blog_id = ".$blogId." AND ".$prefix."articles.status = 'published'"; $query .= " ORDER BY article_karma_score DESC"; } elseif ($based == 'SITE') { $query = "SELECT ".$prefix."karma_scores.article_id, ".$prefix."karma_scores.positive_karma-".$prefix."karma_scores.negative_karma as article_karma_score"; $query .= " FROM ".$prefix."karma_scores, ".$prefix."articles"; $query .= " WHERE ".$prefix."karma_scores.article_id = ".$prefix."articles.id AND ".$prefix."articles.status = 'published'"; $query .= " ORDER BY article_karma_score DESC"; } else { return false; } if( $maxPosts > 0 ) $query .= " LIMIT 0,".$maxPosts; $result = $karmascores->_db->Execute( $query ); if( !$result ) return false; $topkarmaposts = Array(); while( $row = $result->FetchRow()) { $article = $this->getArticle($row["article_id"]); array_push( $topkarmaposts, $article); } return $topkarmaposts; } function getArticleKarma($artId) { $karmascores = new KarmaScores(); $config = new Config(); $prefix = $config->getValue('db_prefix'); $blogId = $this->blogInfo->getId(); $query = "SELECT * FROM ".$prefix."karma_scores"; $query .= " WHERE article_id = ".$artId; $result = $karmascores->_db->Execute( $query ); if( !$result ) return false; $row = $result->FetchRow( $result ); if( $row["positive_karma"] == "" ) $row["positive_karma"] = 0; if( $row["negative_karma"] == "" ) $row["negative_karma"] = 0; return $row; } function getArticle( $artId ) { $articles = new Articles(); $config = new Config(); $prefix = $config->getValue('db_prefix'); $blogId = $this->blogInfo->getId(); $query = "SELECT * FROM ".$prefix."articles WHERE id = ".$artId; $query .= " AND blog_id = ".$blogId; $query .= ";"; // we send the query and then fetch the first array with the result $result = $articles->_db->Execute( $query ); if( $result == false ) return false; if ( $result->RecordCount() == 0) return false; $row = $result->FetchRow( $result ); $article = $articles->_fillArticleInformation( $row ); return $article; } } PluginManager::registerPlugin( "topkarmaposts", "PluginTopKarmaPosts" ); ?> Index: pluginsmileys.class.php =================================================================== RCS file: /cvsroot/plog/plog_plugins/plugins/pluginsmileys.class.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** pluginsmileys.class.php 14 Mar 2004 15:32:37 -0000 1.1 --- pluginsmileys.class.php 27 May 2004 16:17:33 -0000 1.2 *************** *** 41,45 **** If you want to translate the smileys in your posts, edit edit the file <b>post.template</b> from your current template set and modify the call to <b>\{\$post->getText()}</b> to:<br/><br/> ! <b> \{assign name=postText value=\$post->getText()}<br/> \{\$smileys->smileys(\$postText)}</b> <br/><br/> --- 41,45 ---- If you want to translate the smileys in your posts, edit edit the file <b>post.template</b> from your current template set and modify the call to <b>\{\$post->getText()}</b> to:<br/><br/> ! <b> \{assign var=postText value=\$post->getText()}<br/> \{\$smileys->smileys(\$postText)}</b> <br/><br/> Index: plugintopreadposts.class.php =================================================================== RCS file: /cvsroot/plog/plog_plugins/plugins/plugintopreadposts.class.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** plugintopreadposts.class.php 26 May 2004 20:34:56 -0000 1.1 --- plugintopreadposts.class.php 27 May 2004 16:17:33 -0000 1.2 *************** *** 32,39 **** if ($based == 'BLOG') { $query = "SELECT * FROM ".$prefix."articles"; ! $query .= " WHERE blog_id = ".$blogId; $query .= " ORDER BY num_reads DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT * FROM ".$prefix."articles"; $query .= " ORDER BY num_reads DESC"; } else { --- 32,40 ---- if ($based == 'BLOG') { $query = "SELECT * FROM ".$prefix."articles"; ! $query .= " WHERE blog_id = ".$blogId." AND status = 'published'"; $query .= " ORDER BY num_reads DESC"; } elseif ($based == 'SITE') { ! $query = "SELECT * FROM ".$prefix."articles"; ! $query .= " WHERE status = 'published'"; $query .= " ORDER BY num_reads DESC"; } else { Index: pluginkarma.class.php =================================================================== RCS file: /cvsroot/plog/plog_plugins/plugins/pluginkarma.class.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** pluginkarma.class.php 19 May 2004 16:57:02 -0000 1.4 --- pluginkarma.class.php 27 May 2004 16:17:33 -0000 1.5 *************** *** 141,145 **** $this->_pluginOp = $params->getValue( "pluginOp" ); $this->_pluginOpMode = $params->getValue( "mode" ); - _debug("plugin op = ".$this->_pluginOp." - mode = ".$this->_pluginOpMode ); if( $this->_pluginOp == PLUGIN_KARMA_SAVE_SETTINGS ) { --- 141,144 ---- |