Latest Post Like KWWH

[DeLeTeD]

yea would be useful

[Exel]

http://www.besthostingforums.com/sho...6&postcount=21

That's what the plugin has. O.o
Just make a new plugin and paste that code.

DeLeTeD said there was an error with that one, so.. I'll post mine.

Here;

$siteposts = $db->query_read("
SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM thread as thread
LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE forumid NOT IN (30, 3, 13, 15, 34, 16, 31, 81, 82, 17, 18, 19, 20, 22, 80, 79, 21, 69, 70, 71, 72, 73, 24, 25, 32, 85, 84, 86, 87) ORDER BY lastpost DESC LIMIT 0, 19");
while($latest = $db->fetch_array($siteposts))
{

$latest['title'] = str_replace($hidechar, " ", $latest['title']);

if (strlen($latest['title']) > 29)
{
$latest['title'] = substr($latest['title'], 0, 29) . '...';
}
else
{
$latest['title'] = $latest['title'];
}

$latest['title'] = htmlspecialchars($latest['title']);
$trans = array("&" => "&");
$latest['title'] = strtr($latest['title'], $trans);
$latest['replycount'] = number_format($latest['replycount']);
$lastest[musername] = fetch_musername($latest);
$lastest[musername] = $db->escape_string($lastest['musername']);
$date = date("g:i a",$latest['lastpost']);
$div = '<div style="border-bottom: 1px dotted #5080a6; padding: 2px;">';
$enddiv = '</div>';
$ci = '<img src="http://warezsfx.com/images/iwv2/comment.png"; alt="" class="inlineimg">';

$latest_downloads .= "
$div
<div style='font-size: 11px;'><font color='#ce6262'>&bull;</font> <a href='showthread.php?t=$latest[threadid]' title='$latest[title]' style='font-size: 10px;'><b>$latest[title]</b></a></div>
<div style='padding-top: 1px; padding-bottom: 1px;'><a href='member.php?u=$latest[userid]' style='font-size: 9px;'>Posted by $latest[musername]</a></div>
<div style='padding-top: 1px; padding-bottom: 2px; font-size: 7pt;'>
<span>$ci <font color='#8A478F'><b>$latest[replycount] Comments</b></font></span>
$enddiv
</div>";
}
$db->free_result($siteposts);

Of course, edit this: $ci = '<img src="http://warezsfx.com/images/iwv2/comment.png"; alt="" class="inlineimg">'; to your image location.

[BimBoo]

Exel - so what code/addons do we install first for your code to work?

[CJ]

The addon download link in 1st post is dead. Reupload plz. I really want that addon. Its nice.

[Aone]

It would be easier for you to upload the xml file to RS or HF

[Hx]

hmm im looking for this aswell

[DeLeTeD]

^^ use exels code, and add it as a plugin.

[Aone]

I'm a noob at this, why can't someone just upload the file

[GeeZus]

Because if you don't know how to make a plugin or even have a go you won't ever learn nothing.

[-Im.z2ight-]

Whats the: Hook Location This specifies the location within the vBulletin code of the hook that will fire this plugin function.?