Quick Login   
 
Register AdminFusion Tutorials
 
Featured Sponsors


One.com Domain and Hosting


Register
Forum of the Month
Australian Webmaster
fotm

A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.

Tag Cloud
Latest Threads
Forum Stats
7,900 Members
165,094 Posts
31 Users Online

Please welcome our newest member, Jors308932!

Affiliates
Welcome to the AdminFusion. AdminFusion is the ultimate resource for forum administrators and moderators. With exclusive articles, interviews with the experts, free downloadable skins, and the revolutionary post exchange system - PostFusion, AdminFusion is the place to go for all of your forum needs.  By joining AdminFusion, you will become part of a thriving admin community and immediately gain access to all of these resources. Registration is fast, simple and absolutely free so please join us today!
Want more than our forums? Try these: Post Fusion Forum Matrix
Old 01-15-2006, 05:23 AM   #1

Title: Apprentice

Points: 3,151, Level: 16Points: 3,151, Level: 16Points: 3,151, Level: 16
Level up: 17%, 299 Points neededLevel up: 17%, 299 Points neededLevel up: 17%, 299 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jan 2006

Posts: 450

Domainer Zone has a spectacular aura aboutDomainer Zone has a spectacular aura about
 
 
Replies/Topics

I'm getting plenty of replies, but not very many new topics. This one guy talks to me on MSN Messenger and wanted me to sign up to a forum that pays 12 cents a thread and 8 cents a reply.

How about something like a 2:3 ratio for PostFusion? One replies gives you +1 balance, but a new topic gives you +1.5. This could be annoying for people who do not care if they get replies or new topics. You could have some settings that would let us choose between 1:1, 1:2, or 2:3. Replies would always be one, but if you wanted to post a new topic, you'd get a little more. The settings would also let you take off the higher reward for topics when you no longer need them.

...I don't know. I just need more topics and less replies.
Reply With Quote
Old 01-15-2006, 05:30 AM   #2

LarryB's Avatar

Title: AF Lead Developer

Points: 6,450, Level: 23Points: 6,450, Level: 23Points: 6,450, Level: 23
Level up: 24%, 100 Points neededLevel up: 24%, 100 Points neededLevel up: 24%, 100 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2005

Posts: 1,186

Location: OHIO, US

LarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud of
Send a message via MSN to LarryB  
 
Here's the thing with this type of request. Theoretically this could be done. The problem is that most forum packages store a post count only. So it increments the post count as the user makes posts so that it can save on performance. What this would mean is that in order for us to get the numbers in the pickup script we would have to do some number crunching. Basically doing a select to query all the threads started by this user and counting them and doing the same thing for posts. While this is not a big deal on a small forum say couple thousand threads or so, for a very large forum this presents a very large performance bottleneck. Especially with us hitting the script at any regular interval. The other problem that this creates is that the pickup script now becomes infinitely more complex and difficult to update for future forums. So in short I don't know that this would be a very good feature for us to add, but if there is interest we awibble and I can sit down and discuss the logistics of it and if it is feasible to do.
__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.
Reply With Quote
Old 01-15-2006, 05:55 AM   #3

Title: Apprentice

Points: 3,151, Level: 16Points: 3,151, Level: 16Points: 3,151, Level: 16
Level up: 17%, 299 Points neededLevel up: 17%, 299 Points neededLevel up: 17%, 299 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jan 2006

Posts: 450

Domainer Zone has a spectacular aura aboutDomainer Zone has a spectacular aura about
 
 
That is a good point. If you did the select on threads for thread starters, and then did a mysql_num_rows to get the number, you could just get the replie count based total posts - new threads.

Also, there probably won't be a lot of forums with several thousand threads joining a post exchange program. Hitting the forum at any interval might be an issue, but it only needs to do the queries for members of the forum that are subscribed members here at PostFusion. Even if 500 forums sign up, not everyone will join that one forum.

As for the pickup script, I have no idea.
Reply With Quote
Old 01-15-2006, 06:00 AM   #4

LarryB's Avatar

Title: AF Lead Developer

Points: 6,450, Level: 23Points: 6,450, Level: 23Points: 6,450, Level: 23
Level up: 24%, 100 Points neededLevel up: 24%, 100 Points neededLevel up: 24%, 100 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2005

Posts: 1,186

Location: OHIO, US

LarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud ofLarryB has much to be proud of
Send a message via MSN to LarryB  
 
while that works the count aggregate function would be better performance wise than mysql_num_rows. The problem with mysql_num_rows is that it pulls the entire dataset to count the results. This is added overhead that is not experienced with the aggregate function COUNT(). It is something that we can talk about if there is more interest, but at the current time I'm not sure if this is a direction we would want to go.
__________________
Do not post your PF private key in public.

Did I help you with this post? If so, pls click the rep button or send money.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

 
Posting Rules

AdminFusion

All times are GMT +1. The time now is 04:03 AM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0 © 2005-2008 AdminFusion - All Rights Reserved



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72