vb.org Archive - top5.thread.stats

PHP Code:


		
			
// #######################################

         TOP5.THREAD.STATS

// #######################################

// #

// # NanoEntity 

// #                                   

// # Top5.Thread.Stats

// # Version: 2.2.0                    

// # Created: 11/05/2001                                               

// #

// #######################################

// #

// # COPYRIGHT NOTICE:

// #

// # ?Copyright 2001, HOLOLITH.COM.

// # All Rights Reserved.

// #

// # Selling the code for this script

// # without prior written consent is

// # expressly forbidden. In all cases

// # copyright and header must remain intact.

// #

// #######################################



           index.php



// #######################################

Look>>

// #######################################



// get total posts

$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');



// #######################################

Before It ADD>>

// #######################################



// Top 5 Statistics BY NanoEntity

// Top 5 Posters

$posts5 = $DB_site->query('SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 5');

while ($posts5top = mysql_fetch_array($posts5)):

    ++$posts5topnbsp;

    $posts5name .= "? <a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$posts5top[userid]>$posts5top[username]</a><br>";

    $posts5post .= "$posts5top[posts] ?<br>";



endwhile;

// Top 5 Posters

// Top 5 New Members

$user = $DB_site->query('SELECT userid,posts,username,joindate FROM user ORDER BY joindate DESC LIMIT 5');

while ($usertop = mysql_fetch_array($user)):

    ++$usertopnbsp;

    $username .= "? <a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$usertop[userid]>$usertop[username]</a><br>";

    $userposts .= "$usertop[posts] ?<br>";



endwhile;

// Top 5 New Members

// Top 5 Thread Replys

$pop = $DB_site->query('SELECT title,threadid,lastpost,lastposter,views FROM thread ORDER BY lastpost DESC LIMIT 5');

while ($poptop = mysql_fetch_array($pop)):

    ++$poptopnbsp;

    $popthread .= "? <a href=showthread.php?s=$session[sessionhash]&threadid=$poptop[threadid]>$poptop[title]</a><br>";

    $poplastposter .= "$poptop[lastposter]<br>";

    $popviews .= "$poptop[views] ?<br>";



endwhile;

// Top 5 Thread Replys

// Top 1 Most Popular Thread

$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');

while ($pop1top = mysql_fetch_array($pop1)):

    ++$pop1topnbsp;

    $pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>";

    $pop1views .= "$pop1top[views]";



endwhile;

// Top 1 Most Popular Thread

// Top 1 Most Rated Thread

$rated = $DB_site->query('SELECT title,threadid,votenum FROM thread ORDER BY votenum DESC LIMIT 1');

while ($ratedtop = mysql_fetch_array($rated)):

    ++$ratedtopnbsp;

    $ratedtitle .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$ratedtop[threadid]>$ratedtop[title]</a>";

    $ratedrating .= "$ratedtop[votenum]";



endwhile;

// Top 1 Most Rated Thread

eval("\$top5threadstats = \"".gettemplate("hl_statistics")."\";");

// Top 5 Statistics BY NanoEntity



// #######################################



# Add template: hl_statistics



// #######################################

Add>>

// #######################################



<!-- key NanoEntity hololith.com -->

<table cellpadding="0" cellspacing="0" border="0" bgcolor="#000000" width="100%" align="center">

    <tr>

        <td>

            <table cellpadding="4" cellspacing="1" border="0" width="100%">

                <tr>

                    <td bgcolor="#006633" colspan="3">

                        <table cellpadding="1" cellspacing="0" border="0" width="100%">

                            <tr>

                                <td bgcolor="#006633">

                <B><normalfont>Statistics</normalfont></B></td>

                            </tr>

                        </table>

                         </td>

                </tr>

                <tr>

                    <TD bgcolor="#DFDFDF" width="25%">

            <smallfont>



<b>Top 5 Posters:</b>

<hr>



<table>

<tr>

<td width=100%><smallfont>User Names:</smallfont></td>

<td align="right"><smallfont>Posts:</smallfont></td>

</tr>

<tr>

<td width=100%><smallfont><b>$posts5name</b></smallfont></td>

<td align="right"><smallfont><b>$posts5post</b></smallfont></td>

</tr>

</table>



            </smallfont></td>



                    <TD bgcolor="#F1F1F1" width="25%">

            <smallfont>



<b>Top 5 Newest Members:</b>

<hr>



<table>

<tr>

<td width=100%><smallfont>User Names:</smallfont></td>

<td align="right"><smallfont>Posts:</smallfont></td>

</tr>

<tr>

<td width=100%><smallfont><b>$username</b></smallfont></td>

<td align="right"><smallfont><b>$userposts</b></smallfont></td>

</tr>

</table>



            </smallfont></td>



                    <TD bgcolor="#DFDFDF" width="50%">

            <smallfont>

<b>Top 5 New Thread Replys:</b>

<hr>



<table>

<tr>

<td width=75%><smallfont>Thread Names:</smallfont></td>

<td width=25%><smallfont>Last Posters:</smallfont></td>

<td align="right"><smallfont>Views:</smallfont></td>

</tr>

<tr>

<td width=75%><smallfont><b>$popthread</b></smallfont></td>

<td width=25%><smallfont><b>$poplastposter</b></smallfont></td>

<td align="right"><smallfont><b>$popviews</b></smallfont></td>

</tr>

</table>

            </smallfont></td>

                </tr>

                <tr>

                    <td bgcolor="#005628" colspan="3">

                        <table cellpadding="1" cellspacing="0" border="0" width="100%">

                            <tr>

                                <td bgcolor="#005628">

                <smallfont>

                                                                Popular thread is <b>$pop1title</b> | <b>$pop1views</b> views.                                    </smallfont></td>





                                <td bgcolor="#005628" align="right">

                <smallfont>

                                                                 Rated thread is <b>$ratedtitle</b> | <b>$ratedrating</b> votes.

                </smallfont></td>

                            </tr>

                        </table>

                         </td>

                </tr>

            </table>

             </td>

    </tr>

</table>

<!-- / key NanoEntity hololith.com -->



// #######################################



# In template: forumhome:



// #######################################

Add where ever you like>>

// #######################################



$top5threadstats



// #######################################

                 N O T E

// #######################################



$pop = $DB_site->query("SELECT title,threadid,lastpost,lastposter,views FROM 

thread WHERE forumid<>'X' AND forumid<>'Y' AND forumid<>'Z' ORDER BY 

lastpost DESC LIMIT 5"); 



Just replace x, y and z with the forums you want to exclude,

this was not implemented becouse I didn't had time.



I am working on a better version, and with mysql CP (options) support for admin,

+ something else, (none public release), but this version is, so enjoy.

 - NanoEntity (hololith.com)

 

// #######################################

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01141 seconds Memory Usage 1,825KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: