vb.org Archive - Top 'X' Stats

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Top 'X' Stats (https://vborg.vbsupport.ru/showthread.php?t=59609)

Is there a way to display Date for Threads?

Does this work for 3.0.7?

yes it does, works fine on my forums
http://www.diteam.org/

Can i show newest replies of a box which i want , ex : I want to show the newest replies of forum's ID 3 only , who can help me ?
Sorry because my English is so bad !

Quote:

// ### TOP 5 STATS BY ANIMEWEBBY ###########################################
$displayrecords = "5"; // how many records should we show?
$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7"
$threadchars = "30"; // number of characters in thread title before '...' is added

All you have to do is exclude all other forum id's except for 3. I believe this is what your looking for.

where would we find that code mate :)

index?

Yes, located in the root index.php. It is also in the txt attached to this hack. You need to locate those lines in the file and adjust accordingly. Good Luck. Hope that helps :-)

thanks ill try now :)

Quote:

Originally Posted by DaPro

All you have to do is exclude all other forum id's except for 3. I believe this is what your looking for.

thanks 4 sharing . good job !

I installed this 100% to directions but all stats show up 0, I even tried posting and stuff after, nothing!

Please help, saw this Q asked a few times.. No one responded...

Okay it works! but some please help with this problem, for real!

if you go to my site www.mustangmafia.com you will see the stat block just fine

But if you are browsing forums and then click the home link the url is www.mustangmafia.com/forum.php? even though its the homepage still!

Thus what can i do to make it always show on the home page no matter what the url
is!

click the links and see what i mean!

Pleeeeeeeeeeeeaaaaaaaassssssssseeeeeeee

Quote:

Originally Posted by BOSS 302

Pleeeeeeeeeeeeaaaaaaaassssssssseeeeeeee

Im with him...lol :ermm:

Boss 302,

Please wait 24 hours before bumping a thread.

Ogie Dogie, sorry wasn't sure of any rules on it or anything just seeking help and thought some one would have replied by now, I really wanna fix this.

p.s. don't count this as a bump, lol. Just telling you i saw the post and i will wait the 24 if that's the rule.

Next post i make in 24 is gonna have the problem posted in it again cuz it's getting barried.

Thanks,Sean..

Quote:

Originally Posted by BOSS 302

Ogie Dogie, sorry wasn't sure of any rules on it or anything just seeking help and thought some one would have replied by now, I really wanna fix this.

A quote from the Board rules, you can find a link in hte NavBar.

Quote:

1.4 No senseless "Bumping": Please do not bump your request/help searching or other threads several times a day. Remember there are people who don't browse this board every hour. So do not bump a thread within 24h or too much even after 24 hours.

I gotcha, It's all good now anyway i fixed the problem my self. 3 cheers for me! -_-

Will this work with 3.0.7?

*EDIT* nm

Will this work on vb 3.5.0 ?

http://www.biohazardentertainment.com/forums/index.php?

i might sound like a n00b :D but can anyone tell me how to get my members names smaller in stats block?

got it but some of the stats arnt right
check out http://thebattledome.com

bottom of front page and sorry uhh wont show less u a member so ude name

name passy = name

thank you for the hack, installed no problems :)

great hack... thanks alot man!

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
, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE thread.forumid NOT IN (13)

ORDER BY thread.lastpost DESC LIMIT 0, 5
mysql error: Column 'views' in field list is ambiguous

mysql error number: 1052

what happened? at vb 3.0.7

AnimeWebby, Can you help me?

I'm using Version 3.0.7 and installed your hack " Top 'X' Stats " careful.
But i have this error:

https://vborg.vbsupport.ru/external/2005/06/2.jpg

Can you fix this error for me, thanks so much!

OK I would like this to show JUST New threads and latest replied to threads. and exclued the hidden forums exept to the people that are ment to see it. Can I do this? and how?

OK maybe I should clarify what Im looking for ^_^

OK

The image below shows what I want to do with it. you see it shows latest new posts with replies but if you notice in the replyes none of them show up. So Thats what Im wanting to do ^_^

i've installed this hack but i dotn see any info in the topx stats box on the index

i've made the custom templates

'forumhome_stats_member'
'forumhome_stats_poster'
'forumhome_stats_thread'

updated the index.php with the correct info
uploaded it but dont see any stats in teh box :(

Can somone help please.

Thanks in avance

almost sounds like your index.php file wasn't uploaded or edited....i know you said you did, but try once more and let's see what happens

here is a pic of the templates can you see if there in the rite place plz

i've checked everything 10 times to be sure it wasnt me :(

uploaded and redone the index.php loads of times to be sure also

thanks for your reply mate

well if you can see the top x stats on your forum home, then the templates should be right...the dispalying of the actual stats has to do with the index.php...maybe copy and paste your index.php so we can take alook at it may help us help you more..

<a href="http://thebattledome.com" target="_blank">http://thebattledome.com</a>

i havin lil prob with % on top poster thread person, etc

Is there a way to exclude HIDDEN Forums to the groups that can't see it.

yes sir..ask and ye shall receive bud!

look for:

PHP Code:


		
			
$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7"

and just add the forum id's you want excluded!

Quote:

Originally Posted by Sleepyk

http://thebattledome.com

i havin lil prob with % on top poster thread person, etc

shoot us a screen shot...dont know if we need a login to view it at your site bud

ok i have pasted some of the code here

all the code that has been alered.

Code:

// ### BOARD STATISTICS #################################################



// get total threads & posts from the forumcache

$totalthreads = 0;

$totalposts = 0;

if (is_array($forumcache))

{

        foreach ($forumcache AS $forum)

        {

                $totalthreads += $forum['threadcount'];

                $totalposts += $forum['replycount'];

        }

}

$totalthreads = vb_number_format($totalthreads);

$totalposts = vb_number_format($totalposts);



// get total members and newest member from template

$userstats = unserialize($datastore['userstats']);

$numbermembers = vb_number_format($userstats['numbermembers']);

$newusername = $userstats['newusername'];

$newuserid = $userstats['newuserid'];



// ### TOP 5 STATS BY ANIMEWEBBY ###########################################

$displayrecords = "5"; // how many records should we show?

$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7"

$threadchars = "30"; // number of characters in thread title before '...' is added



$getstats_posters = $DB_site->query("SELECT userid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");

while ($getstats_poster = $DB_site->fetch_array($getstats_posters))

{

                eval('$stats_posters .= "' . fetch_template('forumhome_stats_poster') . '";');

}



$getstats_members = $DB_site->query("SELECT userid, username, posts, joindate FROM " . TABLE_PREFIX . "user ORDER BY joindate DESC LIMIT 0, $displayrecords");

while ($getstats_member = $DB_site->fetch_array($getstats_members))

{

                eval('$stats_members .= "' . fetch_template('forumhome_stats_member') . '";');

}



// filter out deletion notices if can't be seen

$forumperms = fetch_permissions($forumid);

if (!($permissions['forumpermissions'] & CANSEEDELNOTICE))

{

        $delquery = ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason";

        $delthreadlimit = "AND deletionlog.primaryid IS NULL";

        $deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')";

}

else

{

        $delquery = ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason";

        $delthreadlimit = "";

        $deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')";

}



$getstats_threads = $DB_site->query("

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 

$delquery

                FROM " . TABLE_PREFIX . "thread AS thread

                LEFT JOIN  " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)

$deljoin

WHERE thread.forumid NOT IN ($excludedforums)

$delthreadlimit

ORDER BY thread.lastpost DESC LIMIT 0, $displayrecords");



while ($getstats_thread = $DB_site->fetch_array($getstats_threads))

{

        $getstats_thread[title] = unhtmlspecialchars($getstats_thread[title]);

        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];

        }

        if ($getstats_thread[lastpost] > $bbuserinfo[lastvisit])

        {

                $getstats_thread[newpost] = true;

        }

        if ($getstats_thread[isdeleted])

        {

                $getstats_thread[isdeleted] = true;

        }

        eval('$stats_threads .= "' . fetch_template('forumhome_stats_thread') . '";');

}



// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###



eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('FORUMHOME') . '");');

oh and templates but as you said this works.

Code:

// pre-cache templates used by all actions

$globaltemplates = array(

        'FORUMHOME',

        'forumhome_event',

        'forumhome_forumbit_level1_nopost',

        'forumhome_forumbit_level1_post',

        'forumhome_forumbit_level2_nopost',

        'forumhome_forumbit_level2_post',

        'forumhome_lastpostby',

        'forumhome_loggedinuser',

        'forumhome_moderator',

        'forumhome_pmloggedin',

        'forumhome_subforumbit_nopost',

        'forumhome_subforumbit_post',

        'forumhome_subforumseparator_nopost',

        'forumhome_subforumseparator_post',

        'forumhome_stats_poster',

        'forumhome_stats_member',

        'forumhome_stats_thread',

yes, but did you add the templates in your admincp?...the index.php calls to the templates to give you your stats therefore you need to ad templates in your admincp witht the content stated in the instructions

forumhome_stats_member
forumhome_stats_poster
forumhome_stats_thread

OK .. lookin like a few have asked this question but can`t seem to see a reply ... I have the RSS feed hack installed, and although I can exclude the feeds forum, I dunno how to excude the user that I`m using as the bot from my top 5 posters

Anyone?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01669 seconds Memory Usage 1,831KB 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 (2)bbcode_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: