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

Registered: 01/10/00
Posts: 5119
Loc: Portland, OR, USA

   [7.x] Fake Member Total to Del.icio.us Add to del.icio.us
  Digg [7.x] Fake Member Total Digg it
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: 25411
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: 439
Loc: SoCal
yes
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

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

Registered: 01/10/00
Posts: 5119
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: 439
Loc: SoCal
just do an alter table on ubbt_USERS and set the autoincrement value to xxxx wink *poof* done

2c
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

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

Registered: 02/25/07
Posts: 286
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 Offline
Wizard

Registered: 01/10/00
Posts: 5119
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
Member

Registered: 02/25/07
Posts: 286
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: 2570
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
Member

Registered: 02/25/07
Posts: 286
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


Top Posters Last 30 Days
AllenAyres 12
Gizmo 10
S7ARBVCK 2
Cambridge 1
Murphdog 1
MattUK 1
Kevin H 1
Who's Online
1 Registered (mikey81), 37 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
BeyondCompare v3.00
by blaaskaak
Yesterday at 02:46 PM
Noob - need help, or a reality check!
by Gizmo
09/04/08 03:21 AM
Here I am! Rock me like a Hurricane!
by AllenAyres
09/02/08 03:05 PM
[7.x] Generic Page Outside of forum directory
by Gizmo
08/30/08 05:43 PM
Team UBBDev Rides Again!
by Gizmo
08/28/08 11:45 PM
Multiple Identity Detector
by MattUK
08/28/08 04:10 PM
[7.3.x] ubb.links
by AllenAyres
08/26/08 09:57 AM
New Mods
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
Newest Members
veedubb8, twentyseven, Claus1, welcomeback1, Paug
13327 Registered Users

 

 

 
fusionbb message board php hacks