The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Exclude Users Posts in Some Forums from Stats?
Hello,
1st even if I mentioning a mod here, I don't think this issue belongs to mod support because there's nothing wrong with the mod. I wanted the Top Posters stats in "Cyb's Advanced Stats" to show total posts excluding those made in the "Forums excluded from stats". So with my very limited knowledge in PHP/mySQL, I opened the XML file & tried some things. 1st I found lines like these: PHP Code:
PHP Code:
I tried to add a variable like $cybexclforums_topforums called $cybexclforums_toppost & added it here: PHP Code:
I tried also to edit my $cybexclforums_toppost value, replacing thread.forumid with post.forumid then forumid , but it doesn't seem to work. Any enlightenment? |
#2
|
||||
|
||||
You said you tried to add a variable "like $cybexclforums_topforums called $cybexclforums_toppost" but then you never posted what that variable looked like. And when you said it doesn't seem to work, what is the result? What makes you think it isn't working?
And, if you are doing this on your test site (which you should be), then turn on debug mode and take a look at the query and see if it's correct. |
#3
|
|||
|
|||
Hi Lynne
Like $cybexclforums_topforums means it has the same value, then I tried replacing thread.forumid with post.forumid then forumid, I tried these 3 versions: PHP Code:
PHP Code:
PHP Code:
How I know it doesn't work? Because in the Top Posters stats I see that users still have all their posts counted. The trick worked though with the "Top Thread Starters" stats. |
#4
|
||||
|
||||
There is no such thing as post.forumid and forumid is ambiguous cuz there is a thread.forumid and a forum.forumid. It seems to me that thread.forumid is the correct variable. What are you trying to grab that is different than what he is doing?
|
#5
|
|||
|
|||
Thanks for your time
The query I posted above seems to grab posts counts from users to rank them in the "Top Posters" stats, I wanted to exclude posts in some forums from the count so I added that $cybexclforums_toppost to the query in this line: Code:
WHERE user.userid > 0 AND posts > 0 AND post.visible= 1 AND (forum.options & 4096) $cybexclforums_toppost $cybexclgroups $cybtopstats_timecut_toppost I added similar variable to the query that works with the "Top Thread Starters" stats, now I see that threads made by users in the excluded forums are deducted from the count. But posts are still all counted BtW I did try debug mode, I couldn't see the query for some reason, but I know it works as "Top Posters" are displayed, it just doesn't work as I want it to.. |
#6
|
||||
|
||||
Queries are not my strong point, but I think what you may need to do is change the JOIN and exclude threads in that forum there. I really don't know exactly, sorry. (It's what I would try anyway.)
|
#7
|
|||
|
|||
Thanks again
I think I did it, I just hope my hack doesn't have some nasty side effects There's a place where it was saying $cybstats_posters_tcenabled = false; I changed false to true & it seems to work |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|