it's party time LOL

it's working now, what did you say? it's working ;)

Thanks boofo :glasses: for me and beer for you :speechless:

Apparently when you are using a table prefix you HAVE to declare the tables with a "table AS table" in it for each table (if you are calling more than 1 table in the query) or the table prefix gets confused, I guess. I hadn't been doing that because that is new in vB3 and I don't use a table prefix. Now that I know that (many, many thanks to NTLDR for enlightening me on this), I will start doing that in any future coding I do just so we can avoid all that you have had to go through for me not knowing that. ;)

It wasn't your fault, there were 3 queries doing that in this hack and as soon as we fixed one of them, it stopped at the next one. I should have looked at all of them the first time but, alas, I didn't. Sorry you had to go through all of this for such a small hack. ;)

I'm glad it's finally working for you, my friend. Enjoy! And thanks for the beer. I can sure use it now. ;)

You remembered the install button, right? ;)

okay well it proved to be a task for both of us then and thanks for the explanation.

Thanks to NTLDR for all the help also :)

I have hit install on both now.

I am really pleased and can't stress enough how grateful i am for your brilliant support

And we both learned something along the way. I guess we're never too old to learn, huh? ;)

Thank you for the kind words, sir. I really appreciate it. It feels kindof nice when someone appreciates the work that goes into a hack, no matter how small. If more users felt like you do, this would be a much happier place. I enjoyed our little adventure. ;)

Boofo,

there are some problems with this hack. I didn't check all my forums because I have - sub-forums included - well over 200 but

1. one of them lists a user with user ID = 0 as top thread starter. If I search for him in the Admin CP, it tells me, he doesn't exist.

2. some forums list no top poster.

3. I know that your hack is not phrased, what is not a problem, as I can phrase it myself apart from one thing: the date that is not displayed in the German language system. Also affects your Forum Home Stats modification; and also the Arcade modification ... so maybe there is a general solution I can apply to all of them?

Screen shots are attached.

Your modification seems to work fine in most forums and sub-forums into which I surfed. Great work. :)

The aracde modification doesn't have anything to do with this hack. As far as the date thing goes, I don't know what the german language uses so I couldn't change that. Just use whatever you use elsewhere on your site for the date and time part of it. ;)

As far as the other problems go, you are the first that has reported that so I'm not sure exactly what is going on. Have you updated your counters recently? You might want to try that and see if that fixes the problem, especially if you have deleted any users that were top posters in a forum at one time. Let me know. ;)

Yes, I did. Still persists. There definitely was never a user Strapu having created 117 threads. Since his user ID is 0, I think the problem could be caused by members that were deleted (pruned)? Once about 800 members were pruned ...

So maybe a conditional of the sort "if user ID = 0 then skip" could solve the "top thread starter" problem? as far as the "top poster" (top poster doesn't appear in some forums) problem is concerned -- it might be related?

But after you deleted the users and updated the counters, it should have straightened itself out. Did you update the theread and forum counters as well as the postcount? You need to do that, too.

Boofo, It would be nice if you changed the attachment instructions to reflect these changes for other who might experience this problem. Might save you the hastle of explaining this to other who don't want to wade through the threads to find a fix. ;)

Quick question... (not sure if it was addressed in this thread)

My Administrator usergroup has HTML markups to BOLD and change the font color of the username to RED. My Super Moderators are supposed to show up just BOLD... etc. etc.

Under "Currently Active Users", only the Administrator usernames reflect HTML markups. If an Admin is online, it shows their name BOLDED and RED, but other usergroups look like standard links(like regular, registered users).

Under "Number of Active Users Today", all usergroups' "HTML Markups" show up correctly, not just the Administrators.

Does anybody know how I would go about fixing this??? Thanks