vb.org Archive - Top 'X' Stats

Page 5 of 13

« First

Last »

Show 40 post(s) from this thread on one page

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

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

Snoop-It

11-06-2005 02:09 PM

How do i change the colour of [NEW] and [Old] - before in the 3.0.x version it was simple...

now that it has plugins etc.. its a lot harder... don't know where to look at...

Could some one please direct me to what part i should look at?

outlaw621

11-06-2005 03:50 PM

Quote:

Originally Posted by caliman

Thank you outlaw I will try that.
Do you know anything about the 'moved thread' bug? It shows the redirect and the thread.

No but I guess I can see if I can figure it out. I am in no way a coder for VB. I just figure stuff out pretty fast when I have to (but only if I have to becasue although I am not a coder, I am lazy:nervous: )

aberg

11-06-2005 05:19 PM

Question about languages translation.
Where can i translate the words [new] and [old] to a new language?
I can't find this two words.
These words display for the last treads

LockeAG

11-07-2005 02:31 AM

vbulletin Options> Top 'X' Stats by InfiniteWebby > :

Prefix Shown For New Posts:

(change)

[new]

(to)

nieuw

and do the same with :

Prefix Shown For Old Posts,

[old] to [oud]

See'a

plateau

11-07-2005 07:59 AM

how can I exclude some forums so that they will not be counted for the TOP Poster list?

outlaw621

11-07-2005 12:04 PM

Quote:

Originally Posted by plateau

how can I exclude some forums so that they will not be counted for the TOP Poster list?

To exclude certain user groups from showing in Top Posters, try the solution from post #159. As for excluding certain forums, I believe this is built in to the ACP interface part of the modification. Will be installing later today to test.

bspiller82

11-07-2005 06:25 PM

How do you hide hidden forum posts from showing in the top5 list? I have a few locked forums and the post names seem to sho in the list. On the older version I remember you edit the php file to exclude the forum but can't do that in this version.

Telegon80

11-07-2005 06:32 PM

they show for you because youre site admin but not for members with no access. i signed on with my troll account and they dont show.

jluerken

11-07-2005 06:55 PM

Small bug:

If you move a thread from one location to another and leave a pointer in the old forum then the post appears two times in the TopX list but one link is broken.

bspiller82

11-07-2005 08:42 PM

Quote:

Originally Posted by Telegon80

they show for you because youre site admin but not for members with no access. i signed on with my troll account and they dont show.

What I mean is when I log out and I'm a guest, I see the post title in the top5 list. You can't read the post. Is there a way to hide it from even showing the post?

outlaw621

11-07-2005 11:37 PM

Quote:

Originally Posted by bspiller82

What I mean is when I log out and I'm a guest, I see the post title in the top5 list. You can't read the post. Is there a way to hide it from even showing the post?

Look in the ACP interface. There is a spot where you can put the number(s) of the forum(s) that you do not want to display or even show on the top 5 list.

InfiniteWebby

11-07-2005 11:47 PM

To fix the showing of moved thread change:

PHP Code:


		
			
$getstats_threads = $db->query_read("

    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, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

        " . iif($deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "

    FROM " . TABLE_PREFIX . "thread AS thread

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

        $deljoin

        WHERE NOT ISNULL(thread.threadid)

        $excludedforums

        " . iif(!$deljoin, "AND thread.visible <> 2") . "

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

to:

PHP Code:


		
			
$getstats_threads = $db->query_read("

    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, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

        " . iif($deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "

    FROM " . TABLE_PREFIX . "thread AS thread

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

        $deljoin

        WHERE NOT ISNULL(thread.threadid)

        $excludedforums

        " . iif(!$deljoin, "AND thread.visible <> 2") . "

        AND thread.open <> 10

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

I'll see about releasing a quick version update for excluding user ids and usergroup ids but at the moment ay major changes planned have been put on hold.

The Chief

11-08-2005 02:32 AM

Looking good, thanks for this awesome product ;)

plateau

11-08-2005 06:54 AM

Quote:

Originally Posted by outlaw621

thanks

wating for the next version.

thank for the efforts.

Rickie3

11-08-2005 07:02 AM

thanx i love it *clicks instal*

athoob

11-08-2005 10:33 AM

that was a piece of cake .. thanx :D

zzzxxzzz

11-16-2005 01:17 PM

work with 3.5.1?

caliman

11-16-2005 01:19 PM

Quote:

Originally Posted by zzzxxzzz

work with 3.5.1?

yes it well, works on mine.

zzzxxzzz

11-17-2005 12:33 AM

how can we change from top 5 stat to top 10?

peterska2

11-17-2005 12:37 AM

in the settings for it you can set the top x. change the 5 to 10.

Club3G

11-18-2005 02:20 PM

Any chance of getting code to show reputation? Latest users is kinda blah.

teedizz

11-24-2005 03:19 AM

hello, i just installed this & it works great but one problem is that it shows up in the parent style but not in the child styles...how can i get this to show in the child styles?

poolking

11-24-2005 06:04 AM

Quote:

Originally Posted by teedizz

hello, i just installed this & it works great but one problem is that it shows up in the parent style but not in the child styles...how can i get this to show in the child styles?

Have you edited the FORUMHOME template in all of the styles?

mainframe

11-25-2005 12:54 PM

Hi Infinityweb,

Did you ever thought about the serverload?
a query suchs as your would defenitly slow down your page with your plugin installed. Als the forumcache table your using to get forum permissions is too big to access all the time.
Actually I think if someone would install your plugin it will use more than the whole vbulletin itself :ermm:

I think you should find a workarround for the forum permissions and try to get them in a different way, because now it's loading the whole forumcache. but only the last 5 posts are needed.

Regards,
MainFrame

InfiniteWebby

11-25-2005 11:40 PM

Quote:

Originally Posted by mainframe

I would welcome any suggestions you might have but experience has shown me that people who install this hack do not want their users to see what they shouldn't and therefore the newest posts must be grabbed on a per user basis.

As for server load I haven't really looked into it with and without this hack and don't really plan to as load isn't solely based on the one page load however the query you talk about takes a fraction of time to load, even if it is on my relatively small board.

Time Before: 0.37994 seconds
Time After: 0.38122 seconds
Time Taken: 0.00128 seconds

So at the moment load isn't a concern to me. If you find your forum slows up when this hack is installed then you are welcome to uninstall it.

shama

11-26-2005 02:37 PM

Thanks it works with me......

caliman

11-26-2005 02:37 PM

Quote:

Originally Posted by InfiniteWebby

Perhaps a couple options via admin CP:

Queries:
1)Per User
2)Last 5 with private board screening
3)Raw last 5

Display:
() Latest Posts
() Newest Members
() Highest Posters
() Highest Rep
() Most Active Members

- This would be radio buttons with multi-select options

Like you said, your board is small. Just a guess, but I'd think the difference would magnify with big boards. I love your mod, but these pulls have bothered me a little. I'd love to see some of the above available for speed freaks like me.

mainframe

11-27-2005 03:00 AM

Hi Infinityweb,

thanks for your fast reply.
I have turned on debug mode and found the problem.
I have arround 90.000 registerred users on my forum(www.funfiles.ws) and arround 1500 online practicly every day arround 19:00. Because your plugin is sorting them on posts it's taking 0.34 seconds to get the top users from the database.
I've added an index in the mysql table users for posts and now it's only taking 0.0008 seconds so thats defenitly a change..

If anyone uses your plugin and have many registerred users and lots of them online I would suggest the same. add an index for posts in the user table by executing the below query in your admincp

Code:

ALTER TABLE `user` ADD INDEX ( `posts` )

Kindest Regards,
MainFrame

tormodg

11-27-2005 11:51 AM

This is a really nice hack...but I would *love* to see a "Top thread starters" stats in it! :)

Qwest

11-27-2005 02:05 PM

It doesn't work for me...

I installed it and get no errors but it's not showing up on the forumhome.

Is there a settign I need to adjust to get it to display?

I notice the code for forumhome says:

Code:

<if condition="$show['topXstats']">

        $topXstats

        </if>

So where do I set that condition to true??

Qwest

11-27-2005 02:08 PM

CRAP nevermind I found it. It's on the bottm.

I want it on the top like on http://www.dholaholic.com/forum/ :)

tormodg

11-27-2005 02:53 PM

Read through the thread. You can place the code wherever you want in the FORUMHOME template.

Snoop-It

11-27-2005 03:43 PM

I think i asked this before.. but what vbphrase do i have to edit to change the colour for NEW and OLD.. i done this in the old version via template.. but since were using products its harder to find it.

I want to make [NEW] in red and [OLD] in blue - so its different and stands out. no one will take notice whats new and whats not if its not clearly highlighted on my board... which is why im looking into changingcolours etc....

any ideas on what vbphrase i have to edit?

cheers.

InfiniteWebby

11-28-2005 10:12 PM

Quote:

Originally Posted by dholaholic

It's in the settings.

caliman

11-28-2005 11:03 PM

Quote:

Originally Posted by mainframe

Code:

ALTER TABLE `user` ADD INDEX ( `posts` )

Kindest Regards,
MainFrame

I hope to have this problem some day! Thanks for sharing.

lsgworldl

11-30-2005 07:55 PM

I have a problem with my skin it dosnt fit right in it lol as you can see here

http://pspgameforums.com/forum/index.php?

InfiniteWebby

11-30-2005 10:25 PM

Quote:

Originally Posted by lsgworldl

I have a problem with my skin it dosnt fit right in it lol as you can see here

http://pspgameforums.com/forum/index.php?

That's really a problem that your skin designer needs to fix.

cbr929rrerion

12-02-2005 08:02 PM

how can I adjust the width of the part that shows on forum home? I dont want 100% I want 95% but cant seem to find the part that determines the width that shows on the home page

ShadowOne

12-05-2005 06:34 PM

i put this and it doesnt stretch my tables on 3.5.1 plus i like the interface better without newest members showing up...

PHP Code:


		
			
<!-- top statistics box -->  <br />    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">  <thead>      <tr>          <td class="tcat" colspan="3">              <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_statistics')"><img id="collapseimg_forumhome_statistics" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_statistics].gif" alt="" border="0" /></a>              <a href="topXstats.php$session[sessionurl_q]">$vbphrase[statistics] - <phrase 1="$displayrecords">$vbphrase[top_x]</phrase></a></td>      </tr>  </thead>  <tbody id="collapseobj_forumhome_statistics" style="$vbcollapse[collapseobj_forumhome_statistics]">      <tr>          <td class="thead" width="23%" align="$stylevar[left]" nowrap="nowrap">$vbphrase[top_posters]</td>          <td class="thead" width="77%" nowrap="nowrap">$vbphrase[latest_replies]</td>      </tr>      <tr>          <td class="alt2" width="23%" valign="top">          <table>              <tr>                  <td width="100%" nowrap="nowrap">$vbphrase[member]:</td>                  <td align="right" nowrap="nowrap">$vbphrase[posts]:</td>              </tr>              $topXstats_posters_bits          </table>          </td>          <td class="alt2" width="77%" valign="top">          <table>              <tr>                  <td width="70%" nowrap="nowrap">$vbphrase[thread]:</td>                  <td width="30%" nowrap="nowrap">$vbphrase[last_poster]:</td>                  <td align="right" nowrap="nowrap">$vbphrase[views]:</td>                  <td align="right" nowrap="nowrap">$vbphrase[replies]:</td>                  </tr>              $topXstats_threads_bits          </table>          </td>      </tr>  </tbody>  </table>    <br />  <br />  <!-- end top statistics box -->

cbr929rrerion

12-05-2005 09:37 PM

I like it and it works but I wish it had the newest member in it, can you add that, I tried, no luck.. I have it on there now working the way you posted but I would like newest members and their post count as in original..

Thats for this tho.. if ya can add the other it will be great..

Quote:

Originally Posted by ShadowOne

i put this and it doesnt stretch my tables on 3.5.1 plus i like the interface better without newest members showing up...

PHP Code:


		
			
<!-- top statistics box -->  <br />    <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">  <thead>      <tr>          <td class="tcat" colspan="3">              <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_statistics')"><img id="collapseimg_forumhome_statistics" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_statistics].gif" alt="" border="0" /></a>              <a href="topXstats.php$session[sessionurl_q]">$vbphrase[statistics] - <phrase 1="$displayrecords">$vbphrase[top_x]</phrase></a></td>      </tr>  </thead>  <tbody id="collapseobj_forumhome_statistics" style="$vbcollapse[collapseobj_forumhome_statistics]">      <tr>          <td class="thead" width="23%" align="$stylevar[left]" nowrap="nowrap">$vbphrase[top_posters]</td>          <td class="thead" width="77%" nowrap="nowrap">$vbphrase[latest_replies]</td>      </tr>      <tr>          <td class="alt2" width="23%" valign="top">          <table>              <tr>                  <td width="100%" nowrap="nowrap">$vbphrase[member]:</td>                  <td align="right" nowrap="nowrap">$vbphrase[posts]:</td>              </tr>              $topXstats_posters_bits          </table>          </td>          <td class="alt2" width="77%" valign="top">          <table>              <tr>                  <td width="70%" nowrap="nowrap">$vbphrase[thread]:</td>                  <td width="30%" nowrap="nowrap">$vbphrase[last_poster]:</td>                  <td align="right" nowrap="nowrap">$vbphrase[views]:</td>                  <td align="right" nowrap="nowrap">$vbphrase[replies]:</td>                  </tr>              $topXstats_threads_bits          </table>          </td>      </tr>  </tbody>  </table>    <br />  <br />  <!-- end top statistics box -->

All times are GMT. The time now is 10:50 PM.

Page 5 of 13

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01933 seconds Memory Usage 1,932KB 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 (3)bbcode_code_printable (4)bbcode_php_printable (13)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: