I am in need of a pretty simply add-on which basically updates a table when a user makes a post or posts a reply.
My table structure is:
table name: xf_credits
cid (INT 11 AI)
user_id (INT 11)
points (INT 11)
reason (varchar 150)
Now what I need is this: I need a add-on which basically does two things:
If a user creates a topic, two points are added to the points field - in mysql terms:
update xf_credits set points=points+2 where user_id = '$uid'
If a user replies to a topic, we add one credit as in:
update xf_credits set points=points+1 where user_id = '$uid'
I am sure it's not really called $uid in XF, but I am sure you know the values anyways.
I do NOT need a admin interface or anything. Just a simply hack. The user_id field will have the same valus as the xf_users user_id to keep things simple
Let me know how fast you could do something like this (I really needed this one since yesterday) and how much you would charge.
Thank you very much