The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 01-12-2001

Anyone done this yet ?

a simple page listing most viewed thread in the past X days , sorted by forum which the thread hyperlinked showing the number of replies and views

- mostviewedthread [views: xx] [replies: xx]

#12 01-14-2001, 10:09 AM

Thanks but No idea where to put it kept getting errors..
plz give example
thnx
cya trinity

#13 01-14-2001, 10:32 AM

Quote:

Originally posted by trinity679
Thanks but No idea where to put it kept getting errors..
plz give example
thnx
cya trinity

okay something like this for the private forums

Code:

<?
require("global.php");

$foruminfo=$DB_site->query("SELECT forumid, title FROM forum WHERE forumid<>33 AND forumid<>34 ORDER BY categoryid,displayorder");
while ($forum=$DB_site->fetch_array($foruminfo)) {
  echo ("<b><br><a href=\"forumdisplay.php?forumid=".$forum[forumid]."\">".$forum[title]."</a></b><br>");
  $threadinfo=$DB_site->query("SELECT threadid,title,replycount,views FROM thread WHERE forumid=$forum[forumid] AND dateline > UNIX_TIMESTAMP(curdate()-30) ORDER BY views DESC LIMIT 4");
  while ($thread=$DB_site->fetch_array($threadinfo)) {
    echo ("???<a href=\"showthread.php?threadid=".$thread[threadid]."\">".htmlspecialchars($thread[title])."</a><font color=\"#0000ff\">?[views: ".$thread[views]."]?[replies: ".$thread[replycount]."]</font><br>");
  }
}

?>

#14 01-15-2001, 07:08 AM

Thanks i'll give it ago

cya trinity

#15 01-15-2001, 07:19 PM

This is what i've done with this hack well just started mesing about with it

Code:

<html>
<head>
<STYLE type=text/css>BODY {
	SCROLLBAR-FACE-COLOR: #336699; SCROLLBAR-HIGHLIGHT-COLOR: #cccccc; SCROLLBAR-SHADOW-COLOR: #cccccc; SCROLLBAR-3DLIGHT-COLOR: #c0c0c0; SCROLLBAR-ARROW-COLOR: #666666; SCROLLBAR-TRACK-COLOR: #808080; SCROLLBAR-DARKSHADOW-COLOR: #391918
}
</STYLE>
<STYLE type="text/css">
	{font-family: helvetica,arial}
		A:visited {text-decoration: none;COLOR: #ffffff}
		A:link {text-decoration: none;COLOR: #ffffff}
	</STYLE>
   
<title>Whats going  on the board</title>
</head>
<body bgcolor="#336699">


<div align="left">
  <table border="1" width="736" height="521">
    <tr>
      <td width="730" height="74">
      
      <?php
require("global.php3");
$foruminfo=$DB_site->query("SELECT forumid, title FROM forum WHERE forumid<>2 AND forumid<>3 AND forumid<>4 AND forumid<>5 AND forumid<>6 AND forumid<>7 AND forumid<>8 AND forumid<>9 AND forumid<>10 AND forumid<>11 AND forumid<>12 AND forumid<>13 AND forumid<>14 AND forumid<>15 AND forumid<>16 AND forumid<>16 AND forumid<>17 AND forumid<>18 AND forumid<>19 ORDER BY displayorder");
while ($forum=$DB_site->fetch_array($foruminfo)) {
  echo ("<b><br><a href=\"forumdisplay.php3?forumid=".$forum[forumid]."\">".$forum[title]."</a></b><br>");
  $threadinfo=$DB_site->query("SELECT threadid,title,replycount,views FROM thread WHERE forumid=$forum[forumid] AND dateline > UNIX_TIMESTAMP(curdate()-30) ORDER BY views DESC LIMIT 4");
  while ($thread=$DB_site->fetch_array($threadinfo)) {
    echo (" ? <a href=\"showthread.php3?threadid=".$thread[threadid]."\">".htmlspecialchars($thread[title])."</a><font color=\"#000000\"> [views: ".$thread[views]."] [replies: ".$thread[replycount]."]</font><br>");
  }
}
?>
      </td>
    </tr>
    <tr>
      <td width="748" height="74">
      <?php

$foruminfo=$DB_site->query("SELECT forumid, title FROM forum WHERE forumid<>1 AND forumid<>3 AND forumid<>4 AND forumid<>5 AND forumid<>6 AND forumid<>7 AND forumid<>8 AND forumid<>9 AND forumid<>10 AND forumid<>11 AND forumid<>12 AND forumid<>13 AND forumid<>14 AND forumid<>15 AND forumid<>16 AND forumid<>16 AND forumid<>17 AND forumid<>18 AND forumid<>19 ORDER BY displayorder");
while ($forum=$DB_site->fetch_array($foruminfo)) {
  echo ("<b><br><a href=\"forumdisplay.php3?forumid=".$forum[forumid]."\">".$forum[title]."</a></b><br>");
  $threadinfo=$DB_site->query("SELECT threadid,title,replycount,views FROM thread WHERE forumid=$forum[forumid] AND dateline > UNIX_TIMESTAMP(curdate()-30) ORDER BY views DESC LIMIT 4");
  while ($thread=$DB_site->fetch_array($threadinfo)) {
    echo (" ? <a href=\"showthread.php3?threadid=".$thread[threadid]."\">".htmlspecialchars($thread[title])."</a><font color=\"#000000\"> [views: ".$thread[views]."] [replies: ".$thread[replycount]."]</font><br>");
  }
}
?>
</td>
   </tr>
  </table>
</div>

i had to add - all forums but the one i wanted in the frame this way i could cose what forum was displayed first

hope this helps anyone thought i would share it as it looks alot better than starnard

cya trinity

#16 01-15-2001, 07:23 PM

Actually if it was something that I was going to use, I would have used vBulletin's template system for display.

It was something that was just whipped up to answer the request...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03940 seconds Memory Usage 2,252KB Queries Executed 20 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (6)post_thanks_postbit_info (5)postbit (6)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!