php forum
php mysql forum
php mysql smarty
 
Topic Options
#315364 - 08/22/07 10:55 PM [7.x] Fake Member Total
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
Fake Member Total - Some people do a lot of active pruning of their member database, so by keeping things tidy we suffer from low member counts... In Classic we had the ability to have a "fake" member total which just took the last uid from the forums and that was your total...

Well it's not that easy to track in threads, but you can tell it to increase your member count by X ammount of users...

Open your cache_builders/forum_stats.php, replace this:
Code:
$smarty->assign("users",$users);


With this:
Code:
$smarty->assign("users",$users+XXXX);


Where XXXX is the number you want to increase the total by (no comma's), then clear your cache.

Now the forum stats will show your actual total PLUS the offset you typed in
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#315365 - 08/22/07 11:01 PM Re: [7.x] Fake Member Total [Re: Gizmo]
AllenAyres Administrator Offline
I type Like navaho

Registered: 03/10/00
Posts: 25452
Loc: Texas
hmmm.. would it be more accurate to do like we did with .classic and just use the id number of the last registered member?
_________________________
- Allen wavey
- What Drives You?

Top
#315369 - 08/23/07 12:21 AM Re: [7.x] Fake Member Total [Re: AllenAyres]
sirdude Offline
Enthusiast

Registered: 11/08/03
Posts: 442
Loc: SoCal
yes
_________________________

Top
#315373 - 08/23/07 12:57 AM Re: [7.x] Fake Member Total [Re: AllenAyres]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
Originally Posted By: AllenAyres
hmmm.. would it be more accurate to do like we did with .classic and just use the id number of the last registered member?
yup lol, however, if you imported from another product (or upgraded), the member id's where renumerated, so it won't be accurate based off of what it WAS...
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#315374 - 08/23/07 01:07 AM Re: [7.x] Fake Member Total [Re: Gizmo]
sirdude Offline
Enthusiast

Registered: 11/08/03
Posts: 442
Loc: SoCal
just do an alter table on ubbt_USERS and set the autoincrement value to xxxx wink *poof* done

2c
_________________________

Top
#315375 - 08/23/07 01:40 AM Re: [7.x] Fake Member Total [Re: sirdude]
blaaskaak Offline
Enthusiast

Registered: 02/25/07
Posts: 304
Loc: The Netherlands
Another quicky solution would be:

Don't clean up the userdatabase smile

I find that faking numbers that can be checked to be false will cause some forumfreak to notice it, and open a topic about it screaming why you are faking a number of members.
_________________________

Top
#315376 - 08/23/07 02:22 AM Re: [7.x] Fake Member Total [Re: blaaskaak]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
Pruning is a nessessity, I like things tidy, call it OC... I just can't stand to see several thousand registered accounts with 0-4 posts that havne't so much as visited my site in 3 years...
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#315377 - 08/23/07 03:44 AM Re: [7.x] Fake Member Total [Re: Gizmo]
blaaskaak Offline
Enthusiast

Registered: 02/25/07
Posts: 304
Loc: The Netherlands
Originally Posted By: Gizmo
Pruning is a nessessity, I like things tidy, call it OC... I just can't stand to see several thousand registered accounts with 0-4 posts that havne't so much as visited my site in 3 years...


ok, I can go with that why you would want that. We decided against cleaning up.

But I can't see why you would want to fake a usercount that can easely be checked to see it's false.
_________________________

Top
#315379 - 08/23/07 03:50 AM Re: [7.x] Fake Member Total [Re: blaaskaak]
Ian_W Global Moderator Offline
Veteran

Registered: 02/22/02
Posts: 2575
Loc: England
I would also like to see the number of threads / posts on the forum to accurately reflect the total number of threads/posts that have been made, rather than the number that are currently on the site, which can easily be 10% lower.

_________________________
Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)

Top
#315380 - 08/23/07 05:42 AM Re: [7.x] Fake Member Total [Re: Ian_W]
blaaskaak Offline
Enthusiast

Registered: 02/25/07
Posts: 304
Loc: The Netherlands
Originally Posted By: Ian_W
I would also like to see the number of threads / posts on the forum to accurately reflect the total number of threads/posts that have been made, rather than the number that are currently on the site, which can easily be 10% lower.


SELECT sum(USER_TOTAL_POSTS) FROM ubbt_USER_PROFILE gives you a rough number about the total posts ever been made (if you don't prune users that have posts).

You normally would get the number from the autoincrement values, but all this importing between products kinda killed the original increment value.
_________________________

Top


Who's Online
0 registered (), 23 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Wisdom needed
by Gizmo
Today at 10:54 AM
How to hide sub forums from summary page
by blaaskaak
Yesterday at 09:54 AM
Spell Check [beta]
by Bill B
12/01/08 09:16 PM
PhotoPost BB Code Popup
by AllenAyres
12/01/08 09:41 AM
Problems reading a lot of old posts here
by AllenAyres
12/01/08 09:35 AM
Forum 'Trader Ratings'.
by AllenAyres
12/01/08 09:33 AM
Customization needed
by Gizmo
11/12/08 12:28 PM
New Mods
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Spell Check [beta]
by
10/17/06 09:24 PM
Newest Members
Truth, David DelMonte, nick1, Begbie, cenk
13364 Registered Users
Top Posters
AllenAyres 25452
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks