The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
how can i make this display the latest 5 threads or whatever?
I had an hack on my old site which displayed username, PM status (or guest message for unregistered members), total posts, threads, members and the last 5 posts of the forum. The first part is very simple, however the last 5 posts required quite a bit of code, utilizing templates from the old topXstats hack that I had. So I've gotten the first part working:
http://www.pkmndex.com/testvb - it's the right box. Now I'd like to have it display last 5 posts as well (thread titles only) and I have Cyb's Advanced Forum Stats installed so maybe we can use the code from that? I have no idea where to start though. Here is the old code: Code:
global $vbulletin; $displayrecords = $vbulletin->input->clean_gpc('r', 'displayrecords', TYPE_UINT); if ($displayrecords <= 0) { $displayrecords = $vbulletin->options['topXstats_displayrecords']; } else if ($displayrecords >= $vbulletin->options['topXstats_maxdisplayrecords']) { $displayrecords = $vbulletin->options['topXstats_maxdisplayrecords']; } else { $displayrecords = $displayrecords; } if ($vbulletin->options['topXstats_excludedforums'] !== '') { $excludedforums = ',' . $vbulletin->options['topXstats_excludedforums']; } $forumpermissions = array(); foreach($vbulletin->forumcache AS $forum) { $forumpermissions[$forum["forumid"]] = fetch_permissions($forum['forumid']); // ## HIDE FORUMS WITHOUT THE CANVIEW, CANVIEWOTHERS OR CANSEEDELNOTICE PERMISSION ## if (!($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canview']) AND !$vbulletin->options['showprivateforums']) { $excludedforums = $excludedforums . ',' . $forum['forumid']; } // filter out deletion notices if can't be seen if ($forumpermissions[$forum["forumid"]] & $vbulletin->bf_ugp_forumpermissions['canseedelnotice'] OR can_moderate($forum['forumid'])){ $deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')"; } else { $deljoin = ''; } } unset($forum); // get rid of initial comma $excludedforums = substr($excludedforums, 1); if ($excludedforums != "") { $excludedforums = "AND thread.forumid NOT IN ($excludedforums)"; } $threadchars = $vbulletin->options['topXstats_threadchars']; if ($threadchars <= 0) { $threadchars = $vbulletin->options['lastthreadchars']; } $userchars = $vbulletin->options['topXstats_userchars']; $newpostprefix = $vbulletin->options['topXstats_newpostprefix']; $oldpostprefix = $vbulletin->options['topXstats_oldpostprefix']; if ($threadchars <= 0) { $threadchars = $vbulletin->options['lastthreadchars']; } $getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords"); while ($getstats_poster = $db->fetch_array($getstats_posters)) { if ($userchars > 0) { if (strlen($getstats_poster[username]) > $userchars) { $getstats_poster[username] = substr($getstats_poster[username], 0, $userchars) . '...'; } else { $getstats_poster[username] = $getstats_poster[username]; } } $getstats_poster[musername] = fetch_musername($getstats_poster); eval('$topXstats_posters_bits .= "' . fetch_template('topXstats_poster_bit') . '";'); } $getstats_members = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts, joindate FROM " . TABLE_PREFIX . "user ORDER BY joindate DESC LIMIT 0, $displayrecords"); while ($getstats_member = $db->fetch_array($getstats_members)) { if ($userchars > 0) { if (strlen($getstats_member[username]) > $userchars) { $getstats_member[username] = substr($getstats_member[username], 0, $userchars) . '...'; } else { $getstats_member[username] = $getstats_member[username]; } } $getstats_member[musername] = fetch_musername($getstats_member); eval('$topXstats_members_bits .= "' . fetch_template('topXstats_member_bit') . '";'); } $getstats_threads = $db->query_read(" SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid " . iif($deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason") . " FROM " . TABLE_PREFIX . "thread AS thread LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter) $deljoin WHERE NOT ISNULL(thread.threadid) $excludedforums " . iif(!$deljoin, "AND thread.visible <> 2") . " ORDER BY lastpost DESC LIMIT 0, 5"); while ($getstats_thread = $db->fetch_array($getstats_threads)) { $getstats_thread[title] = unhtmlspecialchars($getstats_thread[title]); if ($threadchars > 0) { if (strlen($getstats_thread[title]) > $threadchars) { $getstats_thread[titletrimmed] = substr($getstats_thread[title], 0, strrpos(substr($getstats_thread[title], 0, $threadchars), ' ')) . '...'; } else { $getstats_thread[titletrimmed] = $getstats_thread[title]; } } $getstats_thread[titletrimmed]=htmlspecialchars($getstats_thread[titletrimmed]); $getstats_thread[titlelong]=htmlspecialchars($getstats_thread[title]); if ($getstats_thread[lastpost] > $vbulletin->userinfo['lastvisit']) { $getstats_thread[newpost] = true; } if ($getstats_thread[isdeleted]) { $getstats_thread[isdeleted] = true; } if ($userchars > 0) { if (strlen($getstats_thread[username]) > $userchars) { $getstats_thread[username] = substr($getstats_thread[username], 0, $userchars) . '...'; } else { $getstats_thread[username] = $getstats_thread[username]; } } $getstats_member[musername] = fetch_musername($getstats_thread); eval('$foruminteg .= "' . fetch_template('foruminteg') . '";'); } eval('$memberstats .= "' . fetch_template('memberstats') . '";'); echo "<p><strong>Latest Posts</strong><br>$foruminteg</p>"; |
#2
|
|||
|
|||
Bump.
OK, I've been messing with it. Here's what I have so far... I don't see why this isn't working. http://www.pkmndex.com/zero/login_inc.txt Code was too big to post here. The posts, threads, members work fine but it isn't displaying the $cyb_topstats_poster stuff. I put in the code and have it call that template so I don't really understand why it isn't working. The test page is at: http://www.pkmndex.com/testvb Edit2: I made another page without all the code and it calls a template called foruminteg and it works fine: http://www.pkmndex.com/vbs So all I need now is a way to make the latest posts show up via the template. I tried adding the code from Cyb's Advanced Forum latest posts template but that returns a "N/A" value. |
#3
|
|||
|
|||
Anybody?
|
#4
|
|||
|
|||
Hi Zero,
If you're just looking for the 5 most recent posts you can do a simple query such as this... PHP Code:
|
#5
|
|||
|
|||
http://www.pkmndex.com/posts
Code: Code:
$lpost = $db->query_first('SELECT b.title,a.threadid,a.username,a.userid,a.dateline FROM ' . TABLE_PREFIX . 'post a,thread b WHERE a.threadid = b.threadid AND b.forumid NOT IN (31) ORDER BY a.dateline DESC LIMIT 0 , 5'); |
#6
|
|||
|
|||
Bump, see above post.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|