Table of most "popular" threads.

Dude , in 2 days you have solved all my problems YOU RULE !

Thanks a 100000000 times

I think I'm going to create a whole page for my users with all kinds of stats. It will use some of the default settings for the board formatting to make it look like part of the board. I'll post it here when I'm done. It might take a week or two to do it.

I saw your script IRC and I changed it a litle bit to a headline script, for me is this more interesting. Good work IRC, simple but efficient your script

The change:

<?php 

require("global.php"); 

$db_link = @mysql_pconnect("$dbservername", "$dbusername", "$dbpassword"); 
mysql_select_db("$dbname"); 

?> 

<table cellpadding="4" cellspacing="1" width="100%"> 
<tr> 
<td><small><strong>Show the last 10 postings</strong></small></td> 
<td align="center"><small><strong>REPLIES</strong></small></td> 
<td align="center"><small><strong>VIEWS</strong></small></td> 
</tr> 
<?php 
$lastten = lastten(); 
while( $row = mysql_fetch_row($lastten) ) 
{ 
print('<tr>'); 
print('<td>'); 
print('<a href="showthread.php?s=&threadid='); 
print($row[0]); 
print('" target="_top">'); 
print($row[1]); 
print('</a></td>'); 
print('<td align="center">'); 
print($row[2]); 
print('</td>'); 
print('<td align="center">'); 
print($row[3]); 
print('</td>'); 
print('</tr>'); 
} 
mysql_free_result ($lastten); 
?> 
</table> 

<?php 

function lastten() 
{ 
$query = 'SELECT threadid, title, replycount, views ' . 
'FROM thread ' . 
'WHERE (' . $cur_time . '-lastpost) < 604800 ' . 
'ORDER BY threadid DESC LIMIT 10'; 
$result = mysql_query($query) 
or die('most_viewed query failed'); 
return($result); 
} 

?>

Hi,
I really like this script. I would LOVE to put it in my front page.

But.. I'm new to hacking vB. If someone has time to explain to me how I can incorp this into my homepage (Where to put the code, how to modify it so it works) that'd be GREAT.. Once again, great job on the script. Thanks for your time

-esoin

http://3dwin.gamesmania.de/main/index.php

Now you can see the headlinescript in action


Very fine!

IRC, I'm liking the script....Your most recent upload, does that include the "Most Popular In The Past Week" feature?

The first attachment ranks threads by most views. They have to have had a reply in the last week to qualify.

I haven't had a chance to create my crazy page of message board stats yet. Any requests for features? Here are a few ideas of mine:

• Top 5 threads of all time (replies)
• Top 5 threads of all time (views)
• Top 5 most popular polls (votes)
• Top 5 posters of all time
• Five newest threads
• Top 10 threads of the week (new threads only, in terms of views)
• Top 10 threads of the week (new threads only, in terms of replies)

How are you displaying it on your main page? I tried include("./forums/popular.php"); but I get the error "Fatal error: Failed opening required './admin/config.php' (include_path='') in /home/users/x/xtremetuning.net-71707/public_html/forums/global.php on line 48"

I can get it to work if I use xtremetuning.net/forums/popular.php but I want to include it in my main page.

Thanks,

-JRW

Two solutions. One is to put the popular script in frames. Then you can put each individual frame whereever you want. However a better solution is described in another thread.

*searching for thread*

Here it is:
http://www.vbulletin.com/forum/showt...&threadid=9452

I haven't had the chance to try out that solution. Let me know how it works.

Thanks, it worked perfectly. I still have a problem though. I already called a header which is used through out my main site, but this then calls the header function for vbulletin. I suppose I simply need to intigrate the two headers into one file to take care of this.

Thanks for your help,

-JRW