Thsi is the solution, i finally figured it out after working on this for a while. I simply change the value of yes to YES in the query where it requests to know if the comment was published or not.
workign fine now.
<?php
/*
Requires Pixelpost version 1.3
Recent Comments Addon version 0.1
Written by: Mark Lewin
Contact: info@markmyshots.com
To see it in action go to: http://www.markmyshots.com
Pixelpost www: http://www.pixelpunk.se/software/
License: http://www.gnu.org/copyleft/gpl.html
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
*/
$addon_name = "Most Recent Comments";
$addon_description = "Adds one new tag to display the most recent set of comments. <br /><br />
<LAST_COMMENTS><br /><br />
This addon will show the most recent set of comments that were left. The value is decided by you.<br /><br />
";
$addon_version = "0.1";
$limit_comments = 5; // Change this to show however many you want
$recent_comments = ""; // comments stored in this string
if($_GET['showimage'] == "") { $imageid = $image_id; } else { $imageid = $_GET['showimage']; }
$recentquery = mysql_query("select t1.parent_id, t1.message, t1.name, t1.url, t1.publish, t2.headline, t2.id from ".$pixelpost_db_prefix."comments as t1 inner join pixelpost_pixelpost t2 on t1.parent_id = t2.id where t1.publish = 'YES' ORDER BY t1.id DESC limit $limit_comments");
while(list($parent_id, $comment_message, $comment_name, $comment_url, $comment_publish, $comment_headline, $comment_image_id) = mysql_fetch_row($recentquery)) {
$comment_message = pullout($comment_message);
$comment_name = pullout($comment_name);
$comment_headline = pullout($comment_headline);
$comment_headline = htmlspecialchars($comment_headline,ENT_QUOTES);
$comment_image = pullout($comment_image);
if($comment_url != "") {
$comment_url = "http://$comment_url"; // i'm running for president...
$comment_url = str_replace("http://http://","http://",$comment_url); // you see?
$comment_name = "<a href='$comment_url' title='$lang_visit_homepage' target='_blank'>$comment_name</a>";
}
$comment_headline = "<a href='/index.php?showimage=$comment_image_id' title='$comment_headline' target='_blank'>$comment_headline</a>";
$recent_comments .= "<b>$comment_name</b> on <b>$comment_headline</b><br />$comment_message <br /><br />";
}
$recent_comments .= "";
$tpl = ereg_replace("<LAST_COMMENTS>",$recent_comments,$tpl);
?>