Latest Post Like WJ

kamrul · Dec 22, 2009

Plugin install---

Code:

http://hotfile.com/dl/21849478/862f62f/vbulletin-plugins.xml.html

add this code --FORUMHOME-->navbar--> below

Code:

<table cellpadding="0" cellspacing="0" width="100%">
<tr><td valign="top">
<!--{%SHOUTBOX%}-->
</td>
<if condition="$bbuserinfo['field6'] == 'Yes'"><else />
<td width="10">&nbsp;</td><td valign="top" width="300">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
    <td class="tcat" align="center">
        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_latestposts')"><img id="collapseimg_forumhome_latestposts" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_latestposts].gif" alt="" border="0" /></a>
        Latest Posts
    </td>
</tr>
</thead>
<tbody id="collapseobj_forumhome_latestposts" style="$vbcollapse[collapseobj_forumhome_latestposts]">
    <tr>
        <td class="alt1" align="left" width="100%">
<div style="padding: 2px; margin-top: 3px; margin-left: 2px; width: 100%;">
<div style="border: 0pt none; height: 218px; width: 98%; overflow: auto;">
<div id="tabContent"></div>$latest_posts

</div>
</div>
</if>
<script type="text/javascript">
var tabVar=new ajaxtabs("tabs", "tabContent")
tabVar.setpersist(true)
tabVar.setselectedClassTarget("link") //"link" or "linkparent"
tabVar.init()
</script>





        
        </td>

    </tr>
</tbody>
</table></td></tr></table>

This is for infernoshot not others.

Exel · Aug 20, 2010

The working demo is on WJUNCTION... >_>

Royal King · Aug 20, 2010

^ LOL yeah >.<

bxflow · Aug 20, 2010

Pr0nZtrA said:
any working demo?

Yupp...

is very hard to get to the demo.

open any browser (firefox recommended)
type www.wjunction.com on the homepage u will see a chatbox and a latest post box next to it,

THATS UR DEMO!

Exel · Aug 20, 2010

bxflow said:
Yupp...

is very hard to get to the demo.

open any browser (firefox recommended)
type www.wjunction.com on the homepage u will see a chatbox and a latest post box next to it,

THATS UR DEMO!

Don't listen to him, he's a liar.

What you really need to do is send me $20 via paypal gift.
Then I can give you a secret demo link as well as install instructions.

bxflow · Sep 6, 2010

What if we wanted to have our own custom box there instead of LATEST POST what wold be the steps

CammyD · Sep 6, 2010

Can you re-upload the product please.

CammyD · Sep 18, 2010

Re-upload the plugin pl0x.

MaXiCoM · Oct 26, 2010

upload this plugin here

realy i need it

MaXiCoM · Nov 6, 2010

bump, please upload Here !

bxflow · Nov 8, 2010

Latest Post Plugin:
http://www.fileserve.com/file/JMjBD9c
http://www.megaupload.com/?d=1JJ4NRV7

By the way does anyone know why do i get this error when trying to install the plugin ?

Code:

Database error in vBulletin 3.8.5:

Invalid SQL:

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) ORDER BY lastpost DESC LIMIT 0, 5;

MySQL Error   : Table 'XXXXXXXXXX_XXXXXXXX.thread' doesn't exist
Error Number  : 1146
Request Date  : Thursday, October 21st 2010 @ 10:38:49 AM
Error Date    : Thursday, October 21st 2010 @ 10:38:49 AM
Script        : http://your360stop.com/index.php
Referrer      : http://your360stop.com/index.php
IP Address    : XXXXXXXXXXXX
Username      : XX
Classname     : vB_Database
MySQL Version : 5.1.48

crampz · Nov 8, 2010

please update the latests posts..i have error like bxflow..thank you!

Last Word · Nov 8, 2010

bxflow Yes bcoz your table prefix is vb_
And crampz your also vb_

If you want to solve this problem Use This Plugin Code

PHP:

$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 " . TABLE_PREFIX . "thread as thread
LEFT JOIN " . TABLE_PREFIX . "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("&amp;" => "&");
$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);

crampz · Nov 8, 2010

Thank you LAST WORD..it works

Last Word · Nov 8, 2010

crampz You are welcome.....

bxflow · Nov 8, 2010

ok, i got it but now shows blank

[SLIDE] http://screensnapr.com/u/yqxgm3.png[/SLIDE]

Last Word · Nov 9, 2010

Go to Admin CP > Plugins & Products > Download / Upload Plugins > Import Plugin Definitions XML File

& Import This Plugin

http://www.mediafire.com/file/ylw0d5rq31xi492/Lastest-Posts.xml

bxflow · Nov 9, 2010

Already did that but it shows a blank Latest post box

SuicidalMedia · Nov 9, 2010

Did you turned on External JavaScript? It can be turned on in "External Data Provider" options.

bxflow · Nov 9, 2010

Yes jason.

crampz · Nov 9, 2010

@bxflow just edit Forum id that u dont want to include(7, 22, 23, 8, 24, 9, 14, 15, 16, 17, 25)

PHP:

$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 " . TABLE_PREFIX . "thread as thread
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter) WHERE forumid NOT IN (7, 22, 23, 8, 24, 9, 14, 15, 16, 17, 25) ORDER BY lastpost DESC LIMIT 0, 19");
while($latest = $db->fetch_array($siteposts))
{

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

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

$latest['title'] = htmlspecialchars($latest['title']);
$trans = array("&amp;" => "&");
$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']);

$latest_posts .= "
<div style='padding: 4px; border-bottom: 1px dashed blue;' >
<div style='font-size: 14px;'>&bull; <a href='showthread.php?t=$latest[threadid]' title='$latest[title]' style='font-size: 14px;'><b>$latest[title]</b></a></div>
<div style='padding-top: 1px; padding-bottom: 1px;'><a href='member.php?u=$latest[userid]' style='font-size: 12px;'>Posted by $latest[musername]</a></div>
<div style='padding-top: 1px; padding-bottom: 2px; font-size: 7pt;'>
<span style='float: right;'>at $date</span>
<span> <font color='#8A478F'><b>$latest[replycount] replies</b></font></span>
</div>

</div>";
}
$db->free_result($siteposts);

Latest Post Like WJ

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member