Referral question

[Ohiosweetheart]

OK! I'm off to try this right now.


EDIT: That did it! Mick, thank you for being so patient with me, and so willing to help.
You're wonderful

[MickDoneDee]

I'm glad it worked. If you have any further mysql related questions or need a query then vBulletin.com has a MySql section.

[Ohiosweetheart]

I noticed that a little while ago. Since I rarely go there, I didn't even think about posting it there. plus I wasn't sure that it was going to be a mysql question, to start with.

thanks again!

[ResaleBroker]

Originally Posted by Ohiosweetheart

Is there a way to reset members' referral counts back to 0?

I ask because we're planning a referral contest, and need an accurate count of how many referrals each member gets.

You don't have to reset the member's referral counts. Simply run a report from the UserCP.

[MickDoneDee]

Could you explain the steps to do this, please?

[ResaleBroker]

Originally Posted by MickDoneDee

Could you explain the steps to do this, please?

AdminCP >> Users >> Referrals >> Enter the start data and end date.

[MickDoneDee]

Excellent! I never noticed that menu before. Thanks for telling us about it.

[ResaleBroker]

Happy to be of help.

[Ohiosweetheart]

Well that info is good news!

[newforum]

Originally Posted by MickDoneDee

Admin CP - Import & Maintenance - Execute SQL Query - Paste query in Manual Query edit box - click Continue

Copy and Paste exactly as below:

SELECT `referrerid`
FROM `user`
WHERE referrerid >0

If you're happy that the correct data has been called then do another query. This time, copy and paste the DELETE version which should call the same data and, hopefully, give you the option of deleting it.

DELETE `referrerid`
FROM `user`
WHERE referrerid >0

Later, you can do another query to determine who received the most referrals.

If i click execute sql query it gives an error message as "you are not authorized to execute sql queries". I am admin of this site, so what should i do to remove this error message.