Table of most "popular" threads.

Originally posted by wluke
DATELINE is when the thread was created.

perfect, that means we can easily do the hack based on the first post date,, this can be good for news ordering.

Could you post the source you used for that original hack ? I really like it

I will post it later today. Sorry, I've been really busy at work.

<?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>MOST VIEWED MESSAGES FROM THE PAST 7 DAYS</strong></small></td>
<td align="center"><small><strong>REPLIES</strong></small></td>
<td align="center"><small><strong>VIEWS</strong></small></td>
</tr>
<?php
$mostviewed = most_viewed();
while( $row = mysql_fetch_row($mostviewed) )
{
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 ($mostviewed);
?>
</table>

<?php

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

?>

Here you go. I took out most of the formatting tags so that you can put in your own to make it look the way you want. Put this file into same folder as global.php and let me know how it goes. :P

Ir rulez man !

Just a question , I try to adjust the fonts to size=1 that works with everything except for this part

print('<tr>');
print('<td>');
print('<font size=1><a href="showthread.php?s=&threadid=</font>');
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>');

Where sould I add <font size=1> etc ... ? I know it's easy , but I'm not really a php wizard

Thanks for the GREAt script

ps:Is it possible to make the script rank them by most REPLIES instead of VIEWS or is that too hard ?
anywayz ,it rox allready !

GOOD JOB IRC

Thanks

To have it order by replies, you can change the line:

'ORDER BY views DESC LIMIT 10';
to
'ORDER BY replycount DESC LIMIT 10';

Put the font tags here:

print('<tr>');
print('<td><font size="1">');
print('<a href="showthread.php?s=&threadid=');
print($row[0]);
print('" target="_top">');
print($row[1]);
print('</a></font></td>');
print('<td align="center"><font size="1">');
print($row[2]);
print('</font></td>');
print('<td align="center"><font size="1">');
print($row[3]);
print('</font></td>');
print('</tr>');

Something else first , do I add the able border/color options at the same spots you add the font tags ?

Now the serious question , I posted earlier that I need this kind of hack , but for the TOP POSTER (so not a link to a certain post) So just a list that shows us who are the top 3 posters on the forum

Something like this

TOP POSTERS

UserA 188 POSTS
USERB 150 POSTS
UserC 100 POSTS

It shouldn't be too hard to get something that does what you want. I will work take a look at doing that for you.

As for where to put various formatting tags for the table. For tags that affect the whole table like cellpadding and border size, put them in the <table> tag. For the bgcolor or alignment of individual cells, put them in the <td> tags.

I would consult a source on HTML. Once you know where to put a tag if the file was purely HTML, it is usually easy to find out where to put in a PHP file.

Here you go. Again I have stripped out most of the formatting stuff so you can add your own specificiations.

<?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>TOP POSTERS</strong></small></td>
<td align="center"><small><strong>POSTS</strong></small></td>
</tr>
<?php
$top_post = top_posters();
while( $row = mysql_fetch_row($top_post) )
{
print('<tr>');
print('<td>');
print('<a href="member.php?s=&action=getinfo&userid=');
print($row[0]);
print('" target="_top">');
print($row[1]);
print('</a></td>');
print('<td align="center">');
print($row[2]);
print('</td>');
print('</tr>');
}
mysql_free_result ($top_post);
?>
</table>

<?php

function top_posters()
{
$cur_time = mktime(date(G), date(i), date(s), date(m), date(d), date(Y));
$query = 'SELECT userid, username, posts ' .
'FROM user ' .
'ORDER BY posts DESC LIMIT 3';
$result = mysql_query($query)
or die('top_posters query failed');
return($result);
}

?>

Remember, the file must be residing in the same folder as global.php to work correctly. Also, take off the .txt at the end when you put in on the server.

Of course as soon as I post it I realize that there is an unnecessary line of code in it. Delete this line:

$cur_time = mktime(date(G), date(i), date(s), date(m), date(d), date(Y));