Ah, got it.... nice one. So that means, there will be a version 3.0? :D

BTW, while I am browsing your forums. Which "Who was online today"-Hack do you use? I like it with keeping the most ever users online today.
Next one I would be very interested in is the XXX's Private Forum. Is that just done by using the [you] hack, or is there anything else to it?

Just the [you] hack is all. It works very well in the forums as you can see. Although, I changed [you] to my own special word so the hack does not get abused and used wrongly on my crappy site. ;)

a quick note on the install...

everything went fine except the "Top Referrer" query.

i have a table prefix set, so i had to alter your query. :)
(added "TABLE_PREFIX" on the select list AND the where clause for the "user" table).

otherwise...installed fine. :) thanks.

You should have only had to add the TABLE_PREFIX on the tables themselves, not the SELECT parts. ;)

But as long as it is installed and working for you, then great! Make sure you make the changes noted above until I get the update for this hack out, though. ;)

well no...as that obviouslly didn't work for me. ;)

"TABLE_PREFIX . user" is seen as a different table than just "user".

it's like saying:
"SELECT A.fieldname FROM tablename B"

A.fieldname does NOT exist in tablename B

in your current sql statement, you're specifying a table that *may not* exist for some members...the "user" table. :)

regardless, i have it installed and i'm good to go!
i only posted that because i saw that another person had this same error. :)

thanks again!

If anyone running vBulletin doesn't have a user table, that would definately be a first and impossible, also, I'm afraid. ;)

sorry...my post came out wrong.

of course they'd have a user table.

i was trying to point out that they may not have it named [user]; as i run my tables with a prefix. :)

Right, and the TABLE_PREFIX in front of the user table should take care of that. ;)

do me a favor...take two minutes and create a new user table with a prefix, then run your query below (replacing TABLE_PREFIX below with the prefix on the newly created table).

it will error out.
#1109 - Unknown table 'user' in field list

merely putting the table prefix in the "from" clause only is not enough.

your query:
// <!-- TOP REFERRER -->
$ref = $DB_site->query_first("
SELECT COUNT(*) AS referrals, user.username, user.userid
FROM " . TABLE_PREFIX . "user AS users
LEFT JOIN " . TABLE_PREFIX . "user ON (users.referrerid = user.userid)
WHERE users.referrerid <> 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 1
");


i don't get me wrong here, i'm not trying to give you a hard time. just want to point out that the above string is incorrect when using a table prefix. :)

I'll take your word for it since I don't use a table prefix in my db. It's just that that isn't supposed to be how it works from all I've encountered with vB3. If it is doing what you say, then it sounds to me like the vb team needs to do some more work on the TABLE_PREFIX code, don't you think? ;)

na, actually that's SQL thing...nothing to do with vB. ;)

when joining tables, you should specify the TABLE_PREFIX on the table AND field names.
if pulling only ONE table, you do not need the TABLE_PREFIX on the select list, just the table name.

thanks for listening! :D




and GREAT hack btw!

I'll have to remember that in the future. Thank you, sir, for informing me of this. It's good to know. ;)

Don't forget to vote for the Hack of the Month for March. This hack is in there. ;)

Seems like I am the only one who is having style problems? I have a default vB3 template, but the style is messed up!

Check it out at http://www.invoid.net

[high]* Mijae clicks install after posting.[/high]

Try changing this:

to this:

and let me know if it fixes it.

Also, %'s arent showing up! Hrm!

This is what I see:

ivForums Statistics

Didn't fix it.

Here is a SS of what I see:

Ok, try this then:

Change:

to:

Hang in there, we'll get it. ;)

Ok, that fixed the table but it made the image go away :P That doesnt matter tho...

I still see no % and there are some numbers with no text next to them, I am not sure what it should say there? Its in the screenshot.

Ok, I intentionally did this so there was no image on the left as the box is long and an image at the top obn the left didn't look right to me. I have all my boxes down there with no images on my site. ;)

Set the update time to 0 and run it a few times and see if that fills those percent areas. Let me know, ok?

Also, change that last code I gave you to this and let me know if it still looks ok.

And don't forget to change back the first code I gave you that didn't work. ;)

Did that, still nothing.

There is no text for Thread Views:, etc. There wasn't anything in the instructions to add phrases, not sure if thats the problem.

I don't have the phrase system set up for this yet. All of that is hardcoded. I'll look at it now and get it going for you until I can get the phrase system in place. Ok?

I re-edited index.php and re-added the template changes and still nothing, no % and no text.

My index.php is unhacked :P

$vbphrase[bf2_thread_views]:

Stuff like that isnt showing up :P

Very cool hack, Boofo. :)

Also, the welcome latest member won't show up!

Damn, your hack messed all my stats :P My forum didnt seem to like the hack altho I did :P

Ok, relax. I just uploaded a fixed version to the first post. Clear your cache and re-download it and it should fix ALL of your problems. Let me know. I will stay with you until it is working 100%. That's all I can do except apologize for not looking closer at the file I uploaded the first time. I'm sorry for all the troubles. ;)

Thank you, my friend. Coming from you, that means alot to me. After all, I learned alot of coding from you and your hacks. ;)

I just had to re-upload the file because I uploaded the wrong one earlier. It was missing some stuff. Oops! ;)

Anyway to exclude members from stats?

Also, it's not working on my site. It's vb3 Gold...no modification to the forumhome template other than yours. Why is it screwy like dat? ;)

I'm not sure what you mean.

Ha! I knew I had to add some phrases! Wow, I actually saw something wrong :P I have no php knowlegde, so its a big thing for me :P

Everything seems right now, except that the % shows up as 0% for everything.

Also,
Do I have to add that to my phpinclude_start if I only use these stats on forumhome?

Edit: also, not sure if its just me or not, but I can't logout now, everytime I click logout and get back to forum index, I am logged in.

Clear your cache and re-download the file from the first post. I uploaded the wrong one earlier. Sorry about that. ;)

No, you do not add that for the foumhome. That is only if you want the stats to show up on another page and not have to run any queries. An added bonus, I guess you could say.

The logging out has nothing to do with this hack. Try clearing your cookies and see if that fixes your logging out problem.

Is everything running right or do we need to fix something else?

Everything is working fine, except percentages show up as 0%.

My top poster has ~1600 posts and it says 1600 = 0%.

Did you set the updatetime to 0 and run it a few times? Try that and let me know. We WILL get it working for you. ;)

Ok, I found the problem. I'm a dolt! ;)

Last time, I swear. ;) Re-download the file from the first post (clear your cache first) and re-do the code for the index.php. The percents should show now. ;)

Yep, I set it to 0 and tried a few times to see if it fixed, but nope :P

I also updated counters and stuff like that, didn't help.