Previous Thread
Next Thread
Print Thread
Rate Thread
#315364 08/22/2007 10:55 PM
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:
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 - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Sponsored Links
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?


- Allen wavey
- What Drives You?
Joined: Nov 2003
Posts: 482
Enthusiast
Enthusiast
Offline
Joined: Nov 2003
Posts: 482
yes

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
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 - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Nov 2003
Posts: 482
Enthusiast
Enthusiast
Offline
Joined: Nov 2003
Posts: 482
just do an alter table on ubbt_USERS and set the autoincrement value to xxxx wink *poof* done

2c

Sponsored Links
Joined: Feb 2007
Posts: 329
Yarp™
Yarp™
Offline
Joined: Feb 2007
Posts: 329
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.

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...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Joined: Feb 2007
Posts: 329
Yarp™
Yarp™
Offline
Joined: Feb 2007
Posts: 329
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.

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 wink at the moment - but expanding all the time....)
Joined: Feb 2007
Posts: 329
Yarp™
Yarp™
Offline
Joined: Feb 2007
Posts: 329
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.

Sponsored Links

Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 449
Joined: February 2008
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)