|
Joined: Jan 2000
Posts: 5,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 Likes: 20 |
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: $smarty->assign("users",$users); With this: $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
|
|
|
|
Joined: Mar 2000
Posts: 21,079 Likes: 3
I type Like navaho
|
I type Like navaho
Joined: Mar 2000
Posts: 21,079 Likes: 3 |
hmmm.. would it be more accurate to do like we did with .classic and just use the id number of the last registered member?
|
|
|
|
Joined: Nov 2003
Posts: 482
Enthusiast
|
Enthusiast
Joined: Nov 2003
Posts: 482 |
|
|
|
|
Joined: Jan 2000
Posts: 5,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 Likes: 20 |
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...
|
|
|
|
Joined: Nov 2003
Posts: 482
Enthusiast
|
Enthusiast
Joined: Nov 2003
Posts: 482 |
just do an alter table on ubbt_USERS and set the autoincrement value to xxxx *poof* done 2c
|
|
|
|
Joined: Feb 2007
Posts: 329
Yarp™
|
Yarp™
Joined: Feb 2007
Posts: 329 |
Another quicky solution would be: Don't clean up the userdatabase 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.
|
|
|
|
Joined: Jan 2000
Posts: 5,833 Likes: 20
UBBDev / UBBWiki Owner Time Lord
|
UBBDev / UBBWiki Owner Time Lord
Joined: Jan 2000
Posts: 5,833 Likes: 20 |
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...
|
|
|
|
Joined: Feb 2007
Posts: 329
Yarp™
|
Yarp™
Joined: Feb 2007
Posts: 329 |
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.
|
|
|
|
Joined: Feb 2002
Posts: 2,286
Veteran
|
Veteran
Joined: Feb 2002
Posts: 2,286 |
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 at the moment - but expanding all the time....)
|
|
|
|
Joined: Feb 2007
Posts: 329
Yarp™
|
Yarp™
Joined: Feb 2007
Posts: 329 |
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.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 449
Joined: February 2008
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|