My 2pence is to keep with the ## of posts, not the % of posts. I was thinking... That is alot of programming 'on the fly' to do. I was wondering if storing the 'rank' in the database would be better? You could have the number of posts calculated at the beginning of each forum insert and then update the database value at that time. You could even cut down on that processing by reading the forum post count on session start and then incrementing that value for each new post during that session. If the number of posts increases beyond the 'rank' threshold then you could instigate the database update.
Just some thoughts. William >I have a forum set up that I have various rank names based on the >number of posts a user enters.. The more posts, the better the rank.. > >At first, I used a cfswitch and counted that way. Unfortunately, I >realized that I would have to keep it up as more and more posts came >in (if it went over the maximum) and if I separated it out to include >a high maximum, I would still have issues as the spread between the >ranks would grow and grow (there are 9 ranks total) making progress to >the next rank harder and harder. > >I then came up with an idea that I would get what percentage of posts >the user was responsible for and based on that precentage, it would >set the rank. > >Someone just pointed out however that the same issue remains.. New >people would face harder and harder times getting rank as the posts >increased.. > >I was wondering if anyone had any ideas how to combat this.. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306423 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
