Top xx Posters List

[Paul M]

This modification is no longer available or supported.

The 3.5 version of my Top (10) Posters hack.

This has now been re-vamped for the release of version 3.xx - the hack no longer uses a seperate topposters.php file.

This hack displays a page with the Top Forum Posters for a given set of periods. Two periods are fixed ('This Month' & 'Overall') but can be turned off in the options. The other three periods are user definable (in days) - the default values are 1 day (24 hours), 7 days & 28 days. These three columns cannot be turned off.

The number of posters to be shown can also be set, the default is the top 10 posters. You can also select which usergroups are included in the count, so members in banned groups etc are not shown.

To upgrade (if you want to) uninstall version 2.xx and re-install this version. Note the url to display the page has changed.


History:

v3.01 - First public version 3
v3.02 - Fixed display error reported in post 59
v3.03 - Fixed display error reported in post 84
v3.11 - Series of additions, upgrades and settings added.
v3.12 - Updated install code to check for existing index.
v3.13 - Fixed uncached templates added in v3.11
v3.14 : Changes to display layout.
v3.15 : Minor changes, no update necessary.
v3.16 : Fixed bug in monthly totals caculation.

[Reimer]

Cool, that is nice :)

[flup]

Gonna install

[Paul M]

Hmm, so who rated this one star, and why :(

[Chris M]

Installed :)

Satan

[EH-Jay]

Fatal error: Call to a member function on a non-object in /home/deathleg/public_html/forums/topposters.php on line 44

[Paul M]

Fatal error: Call to a member function on a non-object in /home/deathleg/public_html/forums/topposters.php on line 44
Real name: Jay

Location: Canada

vB Version: 3.0.7
This is for vB Version: 3.5.0 Beta 4. :)

Click on the "my hacks" link in my sig and seek out the 3.0.7 version.

[jesus likes pie]

hell yes.

/me downloads and clicks install

[Paul M]

v2.10 uploaded - added ability to filter the usergroups that are included (so you can exclude banned users etc).

[mbader71]

Thanks. This is really great.

I just want to display this statistics table at the bottom of my forum home. How can I do that?

[Brinnie]

woot!

I'll take 2! :D

[Kusadasi-Guy]

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
WHERE dateline > $startp AND user.usergroupid IN ($groupsp)
GROUP BY userid ORDER BY postcount DESC LIMIT 10

i wasted 2 days for this query. Thank You so much!

[plateau]

Paul M,

I just installed ur Flashchat hacks, and when I read this thread, I think I have to install this top poster hack again. I mean, what a nice idea, what a work :)

I think this hack could be an extension (extended thinking) to the TopXStats hack:
https://vborg.vbsupport.ru/showthread.php?t=93065

I ve kept my eyes on all these Ranking hacks for a very long time, several coders have released diff. types of ranking hacks for 3.5. however, I think if there is a hack that comprehensively works like a BillBoard or a Ranking Board for the vBulletin. That would be nice for an online society.

Top Posters, Most Viewed Topics, Most Replied Topics and so on, they can be displayed in one table and shown on the forumhome, and also can be detailed in a special page as what u do for the top poster...

could u be the one to think about this?

cheers mate.

[iceytdot]

hopefully this thread still gives support.. cuz i just got this error trying to install it!

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select count(*) as newposts from post where dateline >= 03:42 AM, 09-24-2005 and visible = 1;

anyway to fix this? or if not how do i unistall so i can get my forums back! i've re-traced you steps in the instructions & altered the SQL table with what you had ... but umm yea thats what im left with!

anyone

[Paul M]

Invalid SQL:
select count(*) as newposts from post where dateline >= 03:42 AM, 09-24-2005 and visible = 1;
Erm, that sql code is nowhere in this hack, are you sure you posted in the right topic .......

[iceytdot]

i think so because i only got this error, immediately after i added the links in my navbar

but now i might have a bigger problem, i just dropped the whole dateline table in pHp my admin.. do you know how i can get that back lol

[iceytdot]

i want this code... just im pretty dumb wit certain things lol....... i can't believe i dropped that table .. i'm in for a long night

[iceytdot]

Paul M heres everything.... but i'm certain it had to be this code as it was the last before the site got the DB error

ok i had just installed my 3.5 again today! & i was installing a few minor hacks nuthing big but than i got to this hack:



https://vborg.vbsupport.ru/showthread.php?t=92177&page=2



i followed the steps, did the SQL execution
so i wanted to see what it looked like on my site soon as i refreshed i had

this error:



There seems to have been a problem with the Unsigned Hype database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



went to my technical support email & had this:



Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select count(*) as newposts from post where dateline >= 03:42 AM, 09-24-2005 and visible = 1;



so i thought i was all mister SMarTGuy went into pHp My admin, had no clue what i was doing & dropped the Dateline Table completely..



no the email is saying this:



Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
select count(*) as newposts from post where dateline >= 1127528755 and visible = 1;

MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054






so yeaaa i really screwed up & had no back up, as i didn't think i'd do something as dumb as this!!!! is there anyway to get my forums back

or am i going to have to start all over again... please tell me theres something i can do.... ANYTHING lol im Beggin

[Paul M]

Sorry but that sql [for newposts] is simply not this hack - I would guess it's a hack to show a member the number of new posts since they last visited. It might help if you posted the whole message - since it should show has the script that called it.

As for dateline - that's a column in a table, not a table. You could probably recreate it with

ALTER TABLE post ADD dateline INT UNSIGNED NOT NULL DEFAULT '0'

But that won't recover the data it - all you posts would have a date of Jan1st 1970, and I doubt threads would show correctly. Don't you have a BACKUP ?

Oh, I have to go to bed now so I won't see any reply for a few hours.

[Trevor Hannant]

Has anyone been able to write code to show the top average posters (ie. posters with highest 'posts per day')?

Realise this may be a 'messy' one to try but before I do, want to check if anyone else has been able to........

[theArchitect]

Any chance of this being re-made as a plug-in so I can drop it onto my home page in the whats going on area?

Love the mod, just don't like that it is on a page all by itself.

[Paul M]

I wouldn't recommend having it on the homepage of a large board - the queries can be quite intensive if you have a large number of posts per month.

I don't intend to make it as a plugin, but you could do what you want pretty easily I think - just copy lines 18 to 80 of the code from the file to a plugin using the forumhome_start hook - and copy the table template code (i.e. the stuff between the <table> and </table> tags ) from the top_posters template into the forumhome template, above or below the "What' going on" table, depending on your preference. You might want to make it the Top 5 as well - for space reasons.

[theArchitect]

I wouldn't recommend having it on the homepage of a large board - the queries can be quite intensive if you have a large number of posts per month.

I don't intend to make it as a plugin, but you could do what you want pretty easily I think - just copy lines 18 to 80 of the code from the file to a plugin using the forumhome_start hook - and copy the table template code (i.e. the stuff between the <table> and </table> tags ) from the top_posters template into the forumhome template, above or below the "What' going on" table, depending on your preference. You might want to make it the Top 5 as well - for space reasons.

Interesting. I don't have a massive board, but hope to in the future, so I will follow your advise and keep it as a seperate page.

[Trevor Hannant]

Has anyone been able to write code to show the top average posters (ie. posters with highest 'posts per day')?

Realise this may be a 'messy' one to try but before I do, want to check if anyone else has been able to........

Paul, any thoughts on this or how to have this seperately somewhere?

[Paul M]

Paul, any thoughts on this or how to have this seperately somewhere?Not at the moment, but I'll keep it in mind.

[Aeolian]

this ia a great addon.. :)

is it compatible with vb 3.5 gold..

thanx~

[Paul M]

It'll work with any 3.5 version.

[Vizionz]

installed worked fine for me on gold

[csidlernet]

sweet. very nice i like!

[chanzero]

sweet. very nice i like!

installed it -- cool :)

can anyone tell me how i could make this link appear in the Quick Links instead though?

[theArchitect]

installed it -- cool :)

can anyone tell me how i could make this link appear in the Quick Links instead though?Go to your navbar template and scroll down until you see

<!-- user cp tools menu -->

Everything under this are links in your Quick Links menu.

Decide where you want the option to go and then drop this code in

<tr><td class="vbmenu_option"><a href="topposters.php?$session[sessionurl]">Display Top Posters</a></td></tr>

[Brandon Sheley]

* Brandon Sheley installs ty for that last post, i put my link in the quick links too :)

[chanzero]

Go to your navbar template and scroll down until you see

<!-- user cp tools menu -->

Everything under this are links in your Quick Links menu.

Decide where you want the option to go and then drop this code in

<tr><td class="vbmenu_option"><a href="topposters.php?$session[sessionurl]">Display Top Posters</a></td></tr>

thanks!

[Ncturnal]

Nice. Paul M is The Man!

[DamasGate]

Thanks
very nice hack. but did there any way to make it display on the forumhome ? without extra page?

i mean like Top 'X' Stats
https://vborg.vbsupport.ru/showthread.php?t=93065&highlight=Top+Posters

Thanks again

[Paul M]

Thanks
very nice hack. but did there any way to make it display on the forumhome ? without extra page?See post #22 (prevous page).

[DamasGate]

Thanks for help

Understand now

I have a large board, so i can't put it in forumhome

Thanks again

[wolfyman]

worked perfect, I threw it in the quicklinks - thanks :D

[klinsek]

Very nice! I like that you wen't that extra step and didn't just make it an "all time top poster" thing.

I am curious, it shouldn't be all that difficult to *EXCLUDE* a certain forum ID, right?

I don't think I would want my Off Topic forum being counted in this tally. Would rather shine some light on my on-topic posters for a change. ;)

Cheers!

[Paul M]

Easy enough if you modify the code.

[havefun]

/me cklicked install

nice nice THX

[Extreme John]

first of all nice hack paul m, you're the best! :D

ive installed it and it was awesome :) i was just wodering if anybody tried making this mod display at vb cmps page? ive seen somebody did it on the forumhome, so i think its quite possible

[Keyser S?ze]

is it possible t set this to like, top 50?

[Paul M]

If you edit the code, yes. I think 50 is a bit extreme.

[JagFan]

Installed - Thanks!

[chabbs]

Hi,

I'm curious to know where the results of the top posters are displayed?

[Paul M]

On your screen when you go to the top posters page ......

[chabbs]

On your screen when you go to the top posters page ......

The link to the top poster page is added to the navbar?

[Paul M]

Yes.

[chabbs]

Thanks for the replies. I installed it, works great!

[Telegon80]

bah i installed it per the instructions and i get a blank page........ :mad:

[Paul M]

Then you didn't do it right :)

The template name is case sensitive, I would guess you haven't called it "Top_Posters".

[Telegon80]

okey i took everything off completely and then tried it again and it works. sweet as hell. thanks!

[romow]

Hi, thanks for the mod.
btw, can this hack be extended to include top-10 posters in terms of "post counts of the current month"?

that would be awesome..

[Snake]

Thanks, installed! :)

[Paul M]

A new version [3.01] of this has now been released. Please read the main post for details.

[theArchitect]

A couple of silly questions, but...

How do I delete the old top posters template?

I have specified that I want 20 posters in my list (through the Admin CP), but only 10 are being displayed.

[Paul M]

A couple of silly questions, but...

How do I delete the old top posters template?

I have specified that I want 20 posters in my list (through the Admin CP), but only 10 are being displayed.You don't actually need to delete the old template, as it's also used by the new version.

I've just set mine to 20 and it's fine, are you sure the setting has been changed ?

Edit: Nevermind I see what you mean, i'll fix that now. :)

[theArchitect]

You don't actually need to delete the old template, as it's also used by the new version.

I've just set mine to 20 and it's fine, are you sure the setting has been changed ?

Edit: Nevermind I see what you mean, i'll fix that now. :)

Thanks. Though, for general reference, how do I delete a template anyway?

I know how to delete a whole style, but can't seem to find an option to remove a specific template.

[Paul M]

Okay, fixed that little oversight (uploaded).

I don't know how you would delete a single template from the master set, there doesn't seem to be a way to do it.

[theArchitect]

Okay, fixed that little oversight (uploaded).

I don't know how you would delete a single template from the master set, there doesn't seem to be a way to do it.I guess that the boys and girls at Jelsoft figured that people (non-coders) might get into trouble if they started deleting templates, thought one can mess up a board just as easily by playing with the PHP files.

But given the number of people that mod boards they should add it.

And thanks for the updated file.

Uploaded and working.

[theArchitect]

I have just done a little digging.

You can't delete a core template, only revert it to its original state.

However, if you use the revert function on a custom template then it gets deleted. Unless the template is added by a product then it just gets reverted to the original template layout defined in the product.

[Paul M]

Actually, uninstalling the product will remove any templates associated with it. :)

[theArchitect]

Actually, uninstalling the product will remove any templates associated with it. :)

Yep, I was thinking for templates added manually, rather than those which come with a product.

[Paul M]

Yep, I was thinking for templates added manually, rather than those which come with a product.
Well you could fudge it by creating a dummy product, assigning the template to it, and then uninstall the product ....

Anyway, this probably isn't the best place to discuss this ;)

[SnowBot]

Thanks for the update atey

[Snake]

Yeah thanks for the update bro.

[Snake]

Uh by the way Paul, have you ever thought of making this hack, please?

https://vborg.vbsupport.ru/showthread.php?t=99517

I am really looking forward to it. Thanks in advance!

[Paul M]

Uh by the way Paul, have you ever thought of making this hack, please?

https://vborg.vbsupport.ru/showthread.php?t=99517

I am really looking forward to it. Thanks in advance!Why would I want to make another top posters hack ?

Sorry, but I'm happy with this one, I don't have time to re-invent the wheel. :)

[Snake]

Gah that's sad... :(

[lazytown]

This is a great mod! Why are you complaining?

-vissa

[lazytown]

I was thinking I would write a little cronjob that would run this every hour and save it as html. That way it won't hammer the server every time a user requests it. Do you think that would be a good way to reduce the load this puts on a server?

-vissa

[lazytown]

One thing that would be cool is if it had another table that showed top reputations per period of time (is that even possible?)... For example, top user reputation overall, top reputation points earned in last 30 days, etc... Perhaps even a ratio between posts and reputation earned over that period of time. Is that a wacko idea? :) I think that would make this the ultimate top user mod.

-vissa

[lazytown]

Last question from me (promise). How would I remove certain forums from the postcount? I'm assuming I could change the SQL querry - but I might need a little help.

Thanks
-vissa

[mojahudba]

i instal but dunno where its gone ? ? anyway love all your hacks

[Paul M]

Gah that's sad... :(That's life I'm afraid. vB is a hobby, not a career.

I just about have time to do, and support, the stuff I do for free, and a few small paid jobs every now and then.

[Paul M]

This is a great mod! Why are you complaining? Thank you.


I was thinking I would write a little cronjob that would run this every hour and save it as html. That way it won't hammer the server every time a user requests it. Do you think that would be a good way to reduce the load this puts on a server?I think that sounds like overkill. Unless you have a huge forum (> 1000 posts a day) and people are viewing this all the time, then the load is not going to worry you.

One thing that would be cool is if it had another table that showed top reputations per period of time (is that even possible?)... For example, top user reputation overall, top reputation points earned in last 30 days, etc... Perhaps even a ratio between posts and reputation earned over that period of time. Is that a wacko idea? :) I think that would make this the ultimate top user mod.That would be a whole different hack.

Last question from me (promise). How would I remove certain forums from the postcount? I'm assuming I could change the SQL querry - but I might need a little help.Yes, you would need to add some code to the SQL WHERE lines.

[Paul M]

i instal but dunno where its gone ? ? anyway love all your hacksErm, where has what gone ?

[lazytown]

I think that sounds like overkill. Unless you have a huge forum (> 1000 posts a day) and people are viewing this all the time, then the load is not going to worry you.Well I guess we have a huge forum since we get over 1500 posts per day (sometimes 2000 or more). I guess it does depend how often it is clicked though. Mine takes about 2.5 secs when I run the top 10 posters, according to ministats.

Yes, you would need to add some code to the SQL WHERE lines.Any specifics?

Thanks
-vissa

[Paul M]

Well I guess we have a huge forum since we get over 1500 posts per day (sometimes 2000 or more). I guess it does depend how often it is clicked though. Mine takes about 2.5 secs when I run the top 10 posters, according to ministats.Yeah, that's quite slow, but my guess it that's only a small number os times pre hour, it's not a page people keep viewing minute after minute.


Any specifics?
No at the moment, but thinking about it, it will add extra joins to the queries, as well as the extra 'where' logic. Not recommended - esp on a forum your size - it would drive that 2.5 seconds up significantly.

[plateau]

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

thanks

[Paul M]

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

thanksRead the previous two/three posts - you can't, there is no such functionality in it.

[poolking]

* poolking installed . :D

[Blacky1971]

A small bug:

Find:

<if "condition=$vboptions[tpmonth]">
<td class='thead' width='$cwidth%' align='center'>$vbphrase[top_posters_col4]</td>
</if>
<if "condition=$vboptions[tpall]">
<td class='thead' width='$cwidth%' align='center'>$vbphrase[top_posters_col5]</td>
</if>


Replace:

<if condition="$vboptions[tpmonth]">
<td class='thead' width='$cwidth%' align='center'>$vbphrase[top_posters_col4]</td>
</if>
<if condition="$vboptions[tpall]">
<td class='thead' width='$cwidth%' align='center'>$vbphrase[top_posters_col5]</td>
</if>

[Paul M]

A small bug:Gah. I fixed that locally before release, but didn't update the master template that gets exported by the Product Manager. Thanks for spotting it. Fixed template uploaded as v3.03

[havefun]

thx 4 the update :)

[RGSMDNR]

can this work on a page with cmps?

[Snake]

If you ask the author, yeah sure why not?

[funinthesun]

This looks good, might install tomorrow :)

[Rabbitoh Warren]

Every time I try to import this hack it just hangs and the import does not seem to get completed. After this my server's performance seems to be impacted greatly. Page generation times go from under 1 second to above 10. Any idea what's going on? I had the previous version with the topposters.php file installed and that worked great. I'll have to click uninstall for the time being. :(

[Paul M]

Sounds like a corrupted xml file, re-download and extract it again.

[ShadowOne]

Is it possible to have this a part of the nav bar? where it will say Stats, when you click it, it takes you to a page that shows top x stats and top 10 posters and maybe a couple others?

This would be greatly appreciated

[cyberhypnotic]

All I've got to say is... I've finally found it!

I've been searching for awhile, looking for a top posters of the month hack. Finally, I find it in the Extensions, not Modifications.

Excellent, worked like a charm!

I noticed PaulM, that you said you guys don't get paid. Who gets the $160 we put out for this? :laugh: You guys should get paid for the coding and the support provided.

I had an InvisionFree forum and they tried to stick me when it came to a conversion file. Then took DAYS to get back to me. Here, I knew if I searched long enough, I would find what I needed and the answers I was looking for.

viva la vBulletin! :banana:

[Ncturnal]

I'm having a strange issue with this one now. It was working yesterday after I upgraded to 3.11 but today it's out of commission.

()


That's all I get now.

http://www.mr2board.com/forums/misc.php?do=topposters

[Paul M]

Well that's bizarre, esp if it worked okay after you upgraded. Looks like the templates have been corrupted. Try removing it, and then re-importing it.

[Coldhands]

I installed this plugin and my members pounded mySQL till it slowed down the whole site. Anyone else with this prob?

My real question: Is there a way to create a static page of the stats that updates each night, and outputs the info to a html page????

[Ncturnal]

Well that's bizarre, esp if it worked okay after you upgraded. Looks like the templates have been corrupted. Try removing it, and then re-importing it.

I removed it and actually reverted back to the previous working version that had the seperate file and it is not working either. :(

[Paul M]

I removed it and actually reverted back to the previous working version that had the seperate file and it is not working either. :(well then you broke something. I really haven't a clue what without access.

[Snake]

Paul ever thought of making a hack for top threads, too? That would be GREAT! :D

[Ncturnal]

I removed it and actually reverted back to the previous working version that had the seperate file and it is not working either. :(

Reapplied after the 3.5.2 update and got it working. :D

[Paul M]

Glad to hear it. :)

[Snake]

Paul ever thought of making a hack for top threads, too? That would be GREAT! :D

Well?

[Paul M]

No, I haven't thought about it.

[Derekclarke]

Cool, Just what i Needed.

Is their a way i can put the link @ the Bottom of the Main Page In the Stats Box too?

Derek

[MThornback]

Paul,

Great hack...little problem tho...If I turn the Monthly display option on, the top of the table where it says Last xx Days doesn't display the month column, the post counts show, but it doesn't shift the overall posters down to the right.

[Paul M]

Not sure I follow, I have the monthly option turned on and it's fine here. Screenshot ?

[plateau]

hi Paul, still cannot exclude some forums?

i mean, if i got forum 1,2,3...

and i dont want the posts in forum 2 to be counted... is that available in this version? thanks!!!

[Paul M]

No, there is no ability to exclude forums.

[firstrebel]

Nice one.

firstrebel *clicks install*.

Bob

[weitalia]

Very Very great hack man ;) Simple and perfect!

;)

[Trevor Hannant]

Has anyone been able to write code to show the top average posters (ie. posters with highest 'posts per day')?

Realise this may be a 'messy' one to try but before I do, want to check if anyone else has been able to........

Had a go at this but got nowhere very very fast.

Anyone had a bash or want to give it a try?

[Mathiau]

trying on vb 3.5.3 - not showing up :( will try a reinstall and let you know as i amsure it is myself or another hack :)

[wolfyman]

working fine on 3.5.3 here

[Startinfresh]

LOVE IT..

THank you

[Gizmo5h1t3]

weird, this one shows a user on mine that hasnt been on or posted in bout 6 months, on the last 28 days column...
methinks it doesnt work....

[Paul M]

methinks it works fine.

[Darat]

Works fine on 3.53 for me - Thanks.

[stinger2]

i think this hack has a conflict with another hack.......which i dont know which?

i have currently active users, who is using flashchat...total members visited the forum...

for some reason it does not show up for me on the main page...the part in vbulletin option is there...all options set......

i have vbulletin 3.5.1 and i tried some time ago your version 3.01 which was actually for vbulletin 3.5.1
and i thought i give this new version a try ..but it was the same.....

my guess is its conflicting with one of the above three hacks.......any way
great hack in my openion.......just wished if it worked for me....
rgds

[Paul M]

It does not clash with any of those hacks (which I think are all mine ?) so you must have another problem. What is your site url ?

[stinger2]

i found the problem........its ME.......loool
i thought it will display the table also on the main page .......and not only from quick links.....i wonder where did i get that idea........maybe from top x state hack??

thanks for the quick response
installed and thanks

[Lance Carbuncle]

Hey Paul.... Your hacks all rock!... I have them all installed on my forum....

One thing I would like in the top posters display list is to have the usernames be active links to their member homepage... is there a line I can throw somewhere to get this to work....?

Thanks again for the great hacks........ Lance

http://www.forums.repashy.com/cmps_index.php

[Paul M]

It would (I think) require a template edit and changes to the sql queries.

[Lance Carbuncle]

Thanks Paul.....

I am not a coder, so wouldn't know where to start...I can only follow directions, and am lucky if I can pull that off most of the time LOL Maybe you will consider this for a future release....... :)

Cheers, Lance

[Guest210212002]

Yikes, for some reason my forums didn't agree with this at all. Importing the product gave me a blank screen (well, blue, but no text) each time, and I got this:

Page generated in 29.82860 seconds with 16 queries [Server Loads: 3.79 1.50 : 1.01]

On each of my pages. I'm sure it's probably something to do with my particular setup, since Paul's a hell of a coder, but yikes, it was the hack of doom for me.

/me tries to determine what the sod happened

[Guest210212002]

And upon checking my email, I get this SQL error trying to add the plug in:





I don't have this installed, didn't have it previously installed, and the only thing that I can think of is that perhaps this is using the same product ID as one of your other hacks?

[zylstra]

Paul, I hope I'm not hijacking this thread, but do you know of a hack that shows the 3 or 5 (or however many) top posters per board?

[AshokForums.com]

Can you create a Column to display their respective ranks?? Like 1, 2 , 3 etc

And also a cup (Like the arcade leaderboard) for the 1st, 2nd and 3rd member would be great :)

[Paul M]

Yikes, for some reason my forums didn't agree with this at all. Importing the product gave me a blank screen (well, blue, but no text) each time, and I got this:

Page generated in 29.82860 seconds with 16 queries [Server Loads: 3.79 1.50 : 1.01]

On each of my pages. I'm sure it's probably something to do with my particular setup, since Paul's a hell of a coder, but yikes, it was the hack of doom for me.

* Chris-777 tries to determine what the sod happenedUnfortunately you have fallen victim to impatience and a lack of feedback from the product install system. The installation includes creating two indexes, which on larger forums can take a bit of time (and as you noticed, drive the server load up while they are created). vB just shows a blank screen while this creation takes place.

Because you stopped the install mid process, the product id exists, which is why you get the duplicate problem. On the import, try setting the "allow overwrite" to yes. Install it at a quiet period and just leave it to proceed, blank sccreen and all. :)

[Paul M]

Thanks Paul.....

I am not a coder, so wouldn't know where to start...I can only follow directions, and am lucky if I can pull that off most of the time LOL Maybe you will consider this for a future release....... :)

Cheers, LanceIf you want to drop me a PM with admin access to your forum, I can probably do it for you sometime in the next week or two. It should be less than 30 mins of work.

[Guest210212002]

Unfortunately you have fallen victim to impatience and a lack of feedback from the product install system. The installation includes creating two indexes, which on larger forums can take a bit of time (and as you noticed, drive the server load up while they are created). vB just shows a blank screen while this creation takes place.

Because you stopped the install mid process, the product id exists, which is why you get the duplicate problem. On the import, try setting the "allow overwrite" to yes. Install it at a quiet period and just leave it to proceed, blank sccreen and all. :)

That is the nicest way I've ever been told to stop being an impatient sod, ever. :D

You're absolutely right, thanks very much sir.

* Guest210212002 humbly crawls up to the install button and clicks it

[Joey805]

Is there a way to remove the Last 28 days column from displaying? It's almost identical to the Last Month column.

Thanks,

Joey

[Paul M]

No, but you could change it to 14 days or whatever if you really want.

BTW, it's not the same, it's always the last 28 days - the "This Month" is always the 1st of the current month to the current date (so today its Jan 1st - Jan 31st, tomorrow it will be Feb 1st only, then Feb 1st - Feb 2nd etc).

[Joey805]

Ok thanks. Whats the easiest way to change it to 14 days? I can change it within admin but wont the code need to be updated as well to show the column heading correctly?

Also, I am running 4.53 and in the instruction text file, it says:

In the navbar template ;

Find ;

<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a></td></tr></if>

This does not exist in my navbar template.

The closest I have to this code in the standard unmodified navbar template is this:

<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>

What should I do? If I add your code below it, it puts a Top Posters link in the Quick Links sub Menu.

[Paul M]

That's the correct place - the navbar has been updated slightly since the instructions were written.

The column heading is a phrase - search for it in the phrase manager and edit it.

[Joey805]

How could I add the top posters link to the main bar instead of in the Quick Links menu?

[Joey805]

Hey Paul,

I just had Jelsoft import my data over from another forum into VB and everything seems to be working fine with forum functionality. I then installed your hack for top posters but its not picking anyone up. It shows only the two new test posts that I did after the import. The other 1500 users with posts are not getting read and displayed. Can you help me out?

I asked Jelsoft and they said I need to contact you directly. They assured me that the data is there like it should be.

Thanks,

Joey

[Paul M]

As a guess I would say those 1500 users are in a non standard usergroup - In the 'Top Posters' settings (in vbulletin Options), make sure the "Included User Groups" includes all your active usergroups.

[majorxp]

Ok thanks. Whats the easiest way to change it to 14 days? I can change it within admin but wont the code need to be updated as well to show the column heading correctly?


Also, I am running 4.53 and in the instruction text file, it says:

In the navbar template ;

Find ;

<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a></td></tr></if>

This does not exist in my navbar template.

The closest I have to this code in the standard unmodified navbar template is this:

<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>


What should I do? If I add your code below it, it puts a Top Posters link in the Quick Links sub Menu.




phrases to change are:

top_posters_col1
top_posters_col2
top_posters_col3
top_posters_col4
top_posters_col5

[majorxp]

Installed. Thanks!

I wonder how much effort it would take to get a vba module created to show the top posters over a variable amount of days using the same usergroup settings......

[Bellinis]

Is it possible to add a WOL location for the top posters page? :)

[Joey805]

How do I fix these:

Uncached templates: Top_Posters_bit (23)
Uncached templates: Top_Posters_blank (17)
Uncached templates: Top_Posters_row (10)

[Paul M]

How do I fix these:

Uncached templates: Top_Posters_bit (23)
Uncached templates: Top_Posters_blank (17)
Uncached templates: Top_Posters_row (10)Upgrade to v3.13 - they were missed in a previous change.

[Snake]

Thank you! :)

[stinger2]

thank you.....just upgraded it......it seem i nearly installed ALL your hacks.....great job

[CupraSi]

Paul

Thank you this is my third ever hack

A couple of things

When you now drop down the quick links I get this

class="vbmenu_option">Private Messages

It has also moved the Top Posters box to the right

If you go to www.seatenthusiasts.co.uk/forum you will see it

Also can you put this at the bottom of the forum do you know?

Cheers

[Joey805]

Thanks paul, the upgrade fixed the problem.

[Paul M]

CupraSi - Quicklinks is not visible to guests. Your Top Posters display looks fine.

http://www.seatenthusiasts.co.uk/forum/misc.php?do=topposters

[CupraSi]

Paul

Damn ... the quick links box has gone weird thats all

I will enable quick links for Guests

[CupraSi]

Paul how would I move it so it is below my users online please?

[Paul M]

Move what exactly ?

[CupraSi]

I would like the box with the stats to move so it us below my online users

[Paul M]

You can't really do that, it's designed to be it's own page, you would have to redo large parts of it. I would also seriously dicourage it anyway, some of the queries are quite 'heavy' - esp on busy boards. It's not something you want to run many times a minute on your homepage.

[CupraSi]

Cheers Paul thats answered my question ... I hope it can be done in the future

[Freezerator]

Nice hack!

[TPOCJames]

Love it.

[Paul M]

If you've downloaded this in the last 4 weeks you may want to download it again and re-install. There was a line of debug code left in it (that has now been removed). It won't affect anything other than an a line of text may appear at the top of the screen on the WOL page.

[xlegends]

YES this ne update also fixed the conflict with whose online. previously whose online would not work while this hack was running.

[hiiped]

< installed >

< and rated a 5 >

[Joey805]

OK Paul, I installed the plugin and it works great except for one thing. I have v3arcade installed and when ever this plugin is active and I goto my active users page, i get some code showing up in my header and it's making the size of my table up there distort. I turn off top posters and the page looks fine.

Can we debug this problem? If you want I can provide you with a URL and username/password to see for yourself.

Thanks for all your contributions.

~ Joey

[Paul M]

OK Paul, I installed the plugin and it works great except for one thing. I have v3arcade installed and when ever this plugin is active and I goto my active users page, i get some code showing up in my header and it's making the size of my table up there distort. I turn off top posters and the page looks fine.

Can we debug this problem? If you want I can provide you with a URL and username/password to see for yourself.

See post #156 (about two above yours). :)

[Joey805]

See post #156 (about two above yours). :)

You sir are brilliant! Thank you so much!

:banana:

[Bounce]

Sorry not looked at the whole thread but having an issue that its not working too great in firefox.. shows a black box at one side :(

Great hack thou paul, the stats are good, can I just link in as a link in the navbar instead how it is. Screenie attached. I'll take a look throu the thread i think as your screenshot hasn't it showin like I have it EEK :o

Scrap that paul,got it,BRILLIANT mate,got it as a link in the navbar :)

Thanks..

Off to rate and click install :)

[Paul M]

The "Display Top Posters" should not appear there. You seem to have inserted the template code in the wrong place.

Basically the code to search for in the instructions appears to have changed slightly since I wrote them (yet no one has ever mentioned this ....) so I think you have guessed where to insert the link and got the wrong place.

I've updated the instructions.

[Bounce]

The "Display Top Posters" should not appear there. You seem to have inserted the template code in the wrong place.

Basically the code to search for in the instructions appears to have changed slightly since I wrote them (yet no one has ever mentioned this ....) so I think you have guessed where to insert the link and got the wrong place.

I've updated the instructions.

Yes guessed lol , had to add it below my mood hack,must read better next time,its after 2am thou lol,anyways got it where I want it ,just edited my above post, thanks again :cool:

[dilbert]

Paul,

Very nice, thank you.
I haven't posted a link to it yet. My site is almost entirely unbranded.
May I remove the Version 3.13 : © Paul Marsden 2006 at the bottom?

Thanks,
Cliff

[Paul M]

Paul,

Very nice, thank you.
I haven't posted a link to it yet. My site is almost entirely unbranded.
May I remove the Version 3.13 : ? Paul Marsden 2006 at the bottom?

Thanks,
CliffDon't people usually charge for unbranded :banana:

PM sent.

[Doc.Blade]

nice mod, *clicks install*

[blitzburgh]

Love the hack, I need to see if there is anyway to save the data on a cron job at the end of each month. I used it in a specific forum for contests, and need to save the data at the end of each month to find out the winner, and it would be great if the system could save all the data for me somehow, instead of looking each month. Anyone know if this is possible and how you could do it?

[tony76]

Hi I inserted the required into the navbar template but surprisingly, don't see any link to click.

[Paul M]

As I recall, the link is in the quicklinks dropdown. Please click install. :)

[Derekclarke]

Love the hack, I need to see if there is anyway to save the data on a cron job at the end of each month. I used it in a specific forum for contests, and need to save the data at the end of each month to find out the winner, and it would be great if the system could save all the data for me somehow, instead of looking each month. Anyone know if this is possible and how you could do it?


I agree this would be good, i want to run a Comp for the highest poster in a 28 day period.

[Paul M]

You would need a seperate hack to do that.

[fabbry]

Work with Vb 3.5.4 ?

Me not can you help me please?
My forum (http://www.vm18forum.org/forum/index.php)
Top poster (http://www.vm18forum.org/forum/misc.php?do=topposters)

[Paul M]

Um, looks fine to me :)

[Derekclarke]

Is anyone up for writing one?

[dsotmoon]

added, thanks PaulM

[ThorstenA]

Nice one.

Suggestions:
1. style: < div style = "float:left" > for users, < ... "float:right" >for postcount. That makes the table more professional.
2. sortorder: second sortorder for names. Otherwise users with same postcount will be shown different each time you refresh the page.

[Lineman28645]

ok here is my question. how can i change this so it shows on my forumhome, but has a button to like close it off and bring it back up?

[TalkMilitary]

Added to one of my forums. Great hack, Thanks.

[baerwurz]

How can I exclude an User ID?

Because there is an RSS Mod Poster in my vB.

[blitzburgh]

How can I exclude an User ID?

Because there is an RSS Mod Poster in my vB.

I included only one usergroup in my website in the admin panel, if you put the poster in its own usergroup, you believe you could exclude it in the admin panel by removing the usergroup number.

[ThorstenA]

Suggestion:

- only show number of postings where bbuser has access for

[Paul M]

Sorry, I can't really see the point of that, and it would be very complicated to do. :)

[geezmo]

awesome hack!

one question though. the instrcutions above said the number of days being counted (1, 7, 28) are user-definable, so does that mean if I place "15 days" instead of "7 days" in the setting, it would count the top poster for the past 15 days?

if that is so, why does the column still say "Last 7 Days" and not "Last 15 Days" ?

[rareclownfish]

It doesn't show up like this
https://vborg.vbsupport.ru/external/2006/04/19.jpg

It shows up like this.
http://www.rareclownfish.com/modules.php?newtop=10&op=posters&name=Top&file=index&s=

Am I doing somthing wrong?

[Paul M]

awesome hack!

one question though. the instrcutions above said the number of days being counted (1, 7, 28) are user-definable, so does that mean if I place "15 days" instead of "7 days" in the setting, it would count the top poster for the past 15 days?

if that is so, why does the column still say "Last 7 Days" and not "Last 15 Days" ?
Because the column heading is a phrase, so you need to change it.

[Paul M]

It doesn't show up like this
https://vborg.vbsupport.ru/attachment.php?attachmentid=32003&d=1121363959

It shows up like this.
http://www.rareclownfish.com/modules.php?newtop=10&op=posters&name=Top&file=index&s=

Am I doing somthing wrong?Whatever that is, it is not this hack.

[Nikke]

I've removed the quick links thing from my navbar. Is there anyway you can provide me with a direct link so that I get the link straight in the navbar?

[Paul M]

misc.php?do=topposters

[Rahuldhanpat]

its not wrking even i got the Admincp for this hack...but nothing on the forum,,,,, help Plz ,,,,PM me the solution

[klaush]

Hmm, so who rated this one star, and why :(

Not me, it?s awesome!

Any idea how to put it in vbadvanced?

[Paul M]

its not wrking even i got the Admincp for this hack...but nothing on the forum,,,,, help Plz ,,,,PM me the solutionSorry but it's impossible to PM you a solution since without access to your site, there is no way i could find the problem.

[Paul M]

Any idea how to put it in vbadvanced?Not really sure what you mean, but I don't use vba so I would suggest you try the vba forums. :)

[hdraye]

Great, but :)
is there a way to show posts/threads instead of posts only?

[SHalliday]

Thanks Paul,

Beautiful hack. Installed and worked right out of the box without a problem.

[Serial Killer]

If only all hacks were made this way.

Great hack from a great coder.

[Rican]

easy install... very nice!

[Snake]

Nice!

[csidlernet]

really cool thanks

[FLMom]

Love it!! I installed :D Great job!!!

[Invalid ID]

Can't find the following text in my navbar:

<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a></td></tr></if>

[Paul M]

Well you should have something very similar, the exact text may have changed slightly since that was written. Just look for $show['pmstats'] and you should find the appropiate section.

[FLMom]

Mine has been working since install, now all of a sudden it's not, what would cause this? I am getting the error: 404 Not found page :(


edited to say never mind, it seems to be back and working fine....very strange indeed :p

[Coldhands]

I like this hack but the page generates in 9.11221 seconds with 10 queries (most pages are under 0.1 seconds).

When I have this one installed it slows down the server. What is another good hack for this, or is there a way to make it serve as a static page?

[Paul M]

I like this hack but the page generates in 9.11221 seconds with 10 queries (most pages are under 0.1 seconds).There is something seriously wrong with your server if it takes 9 seconds to run that page. It takes less than a second on our live server (13 queries, and 20,000 posts to scan).

[davelacey]

First-class hack.
Thankyou.

[haytham]

tried the code in many places ( navbar or after the CP to show in the quick links) but nothing showed...no links......any ideas? I have 3.5.4 VB

[Invalid ID]

Well you should have something very similar, the exact text may have changed slightly since that was written. Just look for $show['pmstats'] and you should find the appropiate section.
I did find these words $show['pmstats'] but not the complete sentance given above.

So can you (or anyone else) please tell me where should I put that line.

Here is my navbar:


<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1); return false;"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

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

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
<if condition="$pcount != ''">$pcount<br /></if>
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>
<br /><if condition="$rcount != ''">$rcount<br /></if>
</div>
</td>
<td class="alt1"><a href="$vboptions[bburl]/profile.php?do=editavatar">$navbaravatar</a></td>
<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont"><label for="navbar_username">$vbphrase[username]</label></td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont"><label for="navbar_password">$vbphrase[password]</label></td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" id="navbar_password" size="10" accesskey="p" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->

<!-- nav buttons bar -->
<div align="center">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
<tr align="center">
<if condition="$show['member']">
<td class="vbmenu_control"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_cp]</a></td>
</if>
<if condition="$show['registerbutton']">
<td class="vbmenu_control"><a href="register.php$session[sessionurl_q]" rel="nofollow">$vbphrase[register]</a></td>
</if>
<td class="vbmenu_control"><a href="faq.php$session[sessionurl_q]" accesskey="5">$vbphrase[faq]</a></td>
<td class="vbmenu_control"><a href="memberlist.php$session[sessionurl_q]">$vbphrase[members_list]</a></td>
<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>
<if condition="$show['popups']">
<if condition="$show['searchbuttons']">
<if condition="$show['member']">
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]</a></td>
<else />
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getdaily" accesskey="2">$vbphrase[todays_posts]</a></td>
</if>
<td id="navbar_search" class="vbmenu_control"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[search]</a> <script type="text/javascript"> vbmenu_register("navbar_search"); </script></td>
</if>
<if condition="$show['member']">
<td id="usercptools" class="vbmenu_control"><a href="$show[nojs_link]#usercptools">$vbphrase[quick_links]</a> <script type="text/javascript"> vbmenu_register("usercptools"); </script></td>
</if>
<else />
<if condition="$show['searchbuttons']">
<td class="vbmenu_control"><a href="search.php$session[sessionurl_q]" accesskey="4">$vbphrase[search]</a></td>
<if condition="$show['member']">
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]</a></td>
<else />
<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getdaily" accesskey="2">$vbphrase[todays_posts]</a></td>
</if>
</if>
<td class="vbmenu_control"><a href="forumdisplay.php?$session[sessionurl]do=markread" rel="nofollow">$vbphrase[mark_forums_read]</a></td>
<if condition="$show['member']">
<td class="vbmenu_control"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td>
</if>
</if>
<if condition="$show['member']">
<td class="vbmenu_control"><a href="login.php?$session[sessionurl]do=logout&amp;logouthash=$bbuserinfo[logouthash]" onclick="return log_out()">$vbphrase[log_out]</a></td>
</if>
</tr>
</table>
</div>
<!-- / nav buttons bar -->

<br />
<if condition="$show['forumdesc']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%"><strong>$foruminfo[title]</strong> <span class="smallfont">$foruminfo[description]</span></td>
</tr>
</table>
<br />
</if>

<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="hidden" name="quicksearch" value="1" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="text" class="bginput" name="query" size="20" />&nbsp;$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[advanced_search]</a></td>
</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]" rel="nofollow">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
$my_threads
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->

<!-- PAGENAV POPUP -->

<div class="vbmenu_popup" id="pagenav_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead" nowrap="nowrap">$vbphrase[go_to_page]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="$vboptions[forumhome].php" method="get" onsubmit="return this.gotopage()" id="pagenav_form">
<input type="text" class="bginput" id="pagenav_itxt" style="font-size:11px" size="4" />
<input type="button" class="button" id="pagenav_ibtn" value="$vbphrase[go]" />
</form>
</td>
</tr>
</table>
</div>

<!-- / PAGENAV POPUP -->
</if>

[Paul M]

The line in bold below is the one you are looking for ;


<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]" rel="nofollow">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
$my_threads
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->

[Invalid ID]

So nice of you, it's working now :)

Love it... it would be better if the total of all lines would also be included at the end of list.

[Paul M]

Feel free to click on install :)

[chriszep]

hello
just an idea
is it possible to show near the name his avatar (small) ?

[Paul M]

If you edited the plugin, and the template, then probably - but I'm afraid it's not something I intend to do. :)

[chriszep]

If you edited the plugin, and the template, then probably - but I'm afraid it's not something I intend to do. :)

yes I was thinking it's possible but I'm not a coder :cross-eyed:

[ar2]

This is my navbar, I've pasted code but i can't see top users on my forum :cross-eyed: forum.hdtv.com.pl

<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />







<!-- top category table setup -->
<table width="100%" style="background-image:url($stylevar[imgdir_misc]/cat_back.gif)" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="140" height="27" align="left" valign="top"><img src="$stylevar[imgdir_misc]/cat_top_ls.gif" width="140" height="27" alt=" " border="0" /></td>
<td width="100%" style="background-image:url($stylevar[imgdir_misc]/cat_back.gif)" valign="middle">&nbsp;</td>
<td width="140" height="27" align="right" valign="top"><img src="$stylevar[imgdir_misc]/cat_top_rs.gif" width="140" height="27" alt=" " border="0" /></td>
</tr>
</table>
<!-- End top category table setup -->

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1)"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php?$session[sessionurl]">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php?$session[sessionurl]"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

<if condition="$bbuserinfo['userid']">

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<!--<span style="float:$stylevar[right]">[<a href="login.php?$session[sessionurl]do=logout" onclick="return log_out()">$vbphrase[log_out]</a>]</span>-->
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl]">$vbphrase[private_messages_nav]</phrase></if>
</div>
</td>

<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password,vb_login_md5password)">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont">$vbphrase[username]</td>
<td><input type="text" class="button" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="1" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="3" id="cb_cookieuser_navbar" accesskey="c" checked="checked" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont">$vbphrase[password]</td>
<td><input type="password" class="button" name="vb_login_password" size="10" accesskey="p" tabindex="2" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="4" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="forceredirect" value="1" />
<input type="hidden" name="vb_login_md5password" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->








<!-- bottom table setup -->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="70" align="left" valign="top"><img src="$stylevar[imgdir_misc]/ls_main_table_bottom.gif" width="70" height="14" alt=" " border="0" /></td>
<td width="100%" style="background-image:url($stylevar[imgdir_misc]/extended_main_table_bottom.gif)"><img src="$stylevar[imgdir_misc]/clear.gif" width="100%" height="14" alt=" " border="0" /></td>
<td width="70" align="right" valign="top"><img src="$stylevar[imgdir_misc]/rs_main_table_bottom.gif" width="70" height="14" alt=" " border="0" /></td>
</tr>
</table>
<!-- End bottom table setup -->




<if condition="$show['guest']">
<br />
<!-- guest welcome message -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tr>
<td class="tcat" colspan="6"><phrase 1="$vboptions[bbtitle]">$vbphrase[welcome_to_the_x]</phrase></td>
</tr>
<tr>
<td class="alt1" colspan="6">
<phrase 1="faq.php?$session[sessionurl]" 2="register.php?$session[sessionurl]">$vbphrase[first_visit_message]</phrase>
</td>
</tr></table>
<!-- / guest welcome message -->
</if>


<br />
<br />








<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="text" class="bginput" name="query" size="20" />$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php?$session[sessionurl]">$vbphrase[advanced_search]</a></td>
</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getnew">$vbphrase[new_posts_nav]</a></td></tr>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php?$session[sessionurl]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a></td></tr></if>

<tr><td class="vbmenu_option"><a href="misc.php?$session[sessionurl]do=topposters">Display Top Posters</a></td></tr>


<tr><td class="vbmenu_option"><a href="subscription.php?$session[sessionurl]">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php?$session[sessionurl]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->
</if>

[Dr.Viggy]

*installed

[thelittleguy]

I keep gettin this error message Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE dateline > 1148052957 AND user.usergroupid IN (2,3,4,)
GROUP BY userid ORDER BY postcount DESC LIMIT 10;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY userid ORDER BY postcount DESC LIMIT 10' at lin
Error Number : 1064
Date : Saturday, May 20th 2006 @ 08:35:57 AM
Script : http://mywebsiteaddress/forums/misc.php?do=topposters

[Paul M]

Check your usergroups allowed setting, you may have a stray space or comma at the end of the list.

[Snake]

Paul, could you make this hack as a seperate file and URL just like the other top threads/topics hack?

[Paul M]

Paul, could you make this hack as a seperate file and URL just like the other top threads/topics hack?Sorry, but no, that would be a backwards step IMO.

[ar2]

Can anyone help me? I've installed new ver. and it's not working neither :(, I get no error messages.

[Paul M]

Can you be a bit more specific than just "not working" ?

[ar2]

Hmmm it's strange because it seems to be everything (in admin panel in options everything also looks fine) ok but I cant find top posters on my forum, maybe I'm looking in wrong place. The shortcut should be in navbar? I don't know what's wrong :confused:

forum adress is forum.hdtv.com.pl

greets

[Paul M]

You have to add the link yourself, step 1 in the instructions - (adds it to quicklinks as I recall).

[ar2]

edit: ok I think I know what is wrong. Thnx for hlp.

greets

[kittykattjess]

humm ok...

my navbar templet do not have..
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a></td></tr></if>



So how do I add this one then when I dont seem to have it to add the next code after???

[Paul M]

Search the template for $show['pmstats'] and you should find a line similar (check post #209, about two pages back). :)

[bangpc]

I haved install throught 3 steps, but nothing new to appears on my forum. Who can help me. sorry for my bad english

[Zachariah]

There is something seriously wrong with your server if it takes 9 seconds to run that page. It takes less than a second on our live server (13 queries, and 20,000 posts to scan).

Hello,

I have another person with the same type of load problem.

Threads: 14,881, Posts: 645,393, Members: 16,854

Display Setting: 10 users
Page generated in 42.99153 seconds with 8 queries [Server Loads: 0.74 0.60 : 0.75]

Avj: 15k-30K posts a person - 6K new posts a day.

[Paul M]

6,000 posts day ? are you sure, that's nearly 200,000 posts per month, the board only has 645,000 posts .....

I suggest they make sure that dateline has been correctly indexed in the post table, and run an explain.

At the end of they day its very poor performance by mysql slowing it down - even if I remove the index on my server, it only takes 1.5 seconds, and that is scanning 720,000 posts, not 645,000.

[skooby]

Couldn't get it to work for me either. I do have the quickregister mod installed though so that could be making things a lil wacky.

here is my navbar...

<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1); return false;"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

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

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />

<if condition="$bbuserinfo['pmunread']">
<a href="http://www.nokturnalist.com/private.php?"><img border="0" src="http://www.nokturnalist.com/images/newpm.gif" width="22" height="10"></a>
</if>



<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>
</div>
</td>

<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont"><label for="navbar_username">$vbphrase[username]</label></td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont"><label for="navbar_password">$vbphrase[password]</label></td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" id="navbar_password" size="10" accesskey="p" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->

<br />
<if condition="$show['forumdesc']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%"><strong>$foruminfo[title]</strong> <span class="smallfont">$foruminfo[description]</span></td>
</tr>
</table>
<br />
</if>

<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="hidden" name="quicksearch" value="1" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="text" class="bginput" name="query" size="20" />&nbsp;$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[advanced_search]</a></td>

<!-- Start Post Thank You Hack -->
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=findallthanks">$vbphrase[post_thanks_search]</a></td>
<!-- End Post Thank You Hack -->



</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>

<tr><td class="vbmenu_option"><a href="misc.php?$session[sessionurl]do=topposters">Display Top Posters</a></td></tr>


<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]" rel="nofollow">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->

<!-- PAGENAV POPUP -->

<div class="vbmenu_popup" id="pagenav_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead" nowrap="nowrap">$vbphrase[go_to_page]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="$vboptions[forumhome].php" method="get" onsubmit="return this.gotopage()" id="pagenav_form">
<input type="text" class="bginput" id="pagenav_itxt" style="font-size:11px" size="4" />
<input type="button" class="button" id="pagenav_ibtn" value="$vbphrase[go]" />
</form>
</td>
</tr>
</table>
</div>

<!-- / PAGENAV POPUP -->
</if>

$welcomeheaders
$quickregister

The plugin shows up in my vbulletin options so I know it is installed correctly.

Thanks for any help

[zeropaid]

Some of my users are not showing up in the list, i am assuming since some of them are mods they are not being listed. Is there a criteria in which only reg'd users show up? How can i change this so everyone appears?

[skooby]

Some of my users are not showing up in the list, i am assuming since some of them are mods they are not being listed. Is there a criteria in which only reg'd users show up? How can i change this so everyone appears?

If you look in the options, it lets you choose which usergroups to allow
IE: registered users, mods, admins, etc. Just enter of the numbers of the groups you wish to appear.

[Paul M]

Couldn't get it to work for me either. I do have the quickregister mod installed though so that could be making things a lil wacky.

here is my navbar...

<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1); return false;"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

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

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />

<if condition="$bbuserinfo['pmunread']">
<a href="http://www.nokturnalist.com/private.php?"><img border="0" src="http://www.nokturnalist.com/images/newpm.gif" width="22" height="10"></a>
</if>



<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>
</div>
</td>

<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont"><label for="navbar_username">$vbphrase[username]</label></td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont"><label for="navbar_password">$vbphrase[password]</label></td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" id="navbar_password" size="10" accesskey="p" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->

<br />
<if condition="$show['forumdesc']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%"><strong>$foruminfo[title]</strong> <span class="smallfont">$foruminfo[description]</span></td>
</tr>
</table>
<br />
</if>

<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="hidden" name="quicksearch" value="1" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="text" class="bginput" name="query" size="20" />&nbsp;$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[advanced_search]</a></td>

<!-- Start Post Thank You Hack -->
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=findallthanks">$vbphrase[post_thanks_search]</a></td>
<!-- End Post Thank You Hack -->



</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>

<tr><td class="vbmenu_option"><a href="misc.php?$session[sessionurl]do=topposters">Display Top Posters</a></td></tr>


<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]" rel="nofollow">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->

<!-- PAGENAV POPUP -->

<div class="vbmenu_popup" id="pagenav_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead" nowrap="nowrap">$vbphrase[go_to_page]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="$vboptions[forumhome].php" method="get" onsubmit="return this.gotopage()" id="pagenav_form">
<input type="text" class="bginput" id="pagenav_itxt" style="font-size:11px" size="4" />
<input type="button" class="button" id="pagenav_ibtn" value="$vbphrase[go]" />
</form>
</td>
</tr>
</table>
</div>

<!-- / PAGENAV POPUP -->
</if>

$welcomeheaders
$quickregister

The plugin shows up in my vbulletin options so I know it is installed correctly.

Thanks for any help
The text to look for has changed to this ;

<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]" rel="nofollow">$vbphrase[private_messages]</a></td></tr></if>

[skooby]

Thanks for the help Paul. If you look at my template that I posted, I indeed addded the new text (after seeing someone else having the same problem) under the correct text (the same one you said to look for) but still no dice.

Thanks for the help though :)

[aky]

does this have to be in the QUICK LINKS section, how do we just put it in the NAVBAR, i dont need the CALANDER, if someone can show me how to replace the CALANDER with TOP POSTER???

[peterska2]

Replace

<td class="vbmenu_control"><a href="calendar.php?$session[sessionurl]do=topposters">$vbphrase[calendar]</a></td>

with

<td class="vbmenu_control"><a href="misc.php?$session[sessionurl]do=topposters">Display Top Posters</a></td>

[Paul M]

Thanks for the help Paul. If you look at my template that I posted, I indeed addded the new text (after seeing someone else having the same problem) under the correct text (the same one you said to look for) but still no dice.

Thanks for the help though :)You *are* looking in the quick links menu ? it's not a Navbar item. You template looks correct to me.

[skooby]

Thanks for the help Paul.

The problem was a conflict with the "turn sigs on/off" feature in the quick links. Works great :)

[Zachariah]

6,000 posts day ? are you sure, that's nearly 200,000 posts per month, the board only has 645,000 posts .....

I suggest they make sure that dateline has been correctly indexed in the post table, and run an explain.

At the end of they day its very poor performance by mysql slowing it down - even if I remove the index on my server, it only takes 1.5 seconds, and that is scanning 720,000 posts, not 645,000.

There are a lot of products on this VB install. Ill have to surf through the soup.
- I'll let you know what I find :tired:

Current Output:
They all show the same data list. (ex: userid's )

Last 24 Hours | Last 7 Days | Last 28 Days | Overall

user 1 | user 1 | user 1 | user 1
user 10 | user 10 | user 10 | user 10
user 100 | user 100 | user 100 | user 100
user 1000 | user 1000 | user 1000 | user 1000

Page generated in 46.68237 seconds with 9 queries

[Paul M]

That is a seriously poorly server, what is the url of the site ?

[Amaranth]

Liquid sugar, this mod is! :) Installed in two minutes and working perfectly on 3.5.4. This is one of the better (unintended?) Moderator tools I have seen in a Long time, it makes it so easy to pin-point and handle spammers on a small board. The execution is just spot on - you belong in Apple somewhere hehe

Thanks a million for another job well done! :)

[aky]

i just upgraded from the prev version to the newest, and my users are reporting loss in posts, what gives? do i have to update counters or something?

[Kihon Kata]

I've got the same "slow loading issue"...sometimes 7-10 secs

Total Threads: 46,033
Total Posts: 498,906
Total Members: 41,318

Dedicated webserver running Debian Fedora, plenty of HDD space and 2 gigs of ram

Server loads around 1-3 depending on how many online sometimes a few hundred. The site flies, except when I click this link.

Ideas?

[SCORPION1]

nice hack m8 thanks for that was looking for something like this to put in place of an other one instead:D

[Derek]

I installed this the way I was supposed to, but the link takes me to a smilie page.. any ideas why?

http://www.forumfatale.com/misc.php?do=topposters

[kofoid]

derek looks good now - how did you get it working? I have the smilies issue too

[Derek]

I had the template cache hack installed, so you have to choose the "Clean Template Cache" option otherwise all the templates will stay the same because they are cached on your server.

[Al-Fateh]

installed :)

great

[Paul M]

Version 3.16 has been uploaded today - this fixes a bug in the monthly posts calculation - it was counting the last day of the previous month in the totals.