vb.org Archive - Referral question

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Referral question (https://vborg.vbsupport.ru/showthread.php?t=117297)

Ohiosweetheart

06-01-2006 07:59 PM

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 https://vborg.vbsupport.ru/

MickDoneDee

06-01-2006 08:56 PM

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

06-01-2006 09:00 PM

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

06-23-2006 10:29 PM

Quote:

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

06-24-2006 08:21 AM

Could you explain the steps to do this, please?

ResaleBroker

06-24-2006 11:40 AM

Quote:

Originally Posted by MickDoneDee

Could you explain the steps to do this, please?

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

MickDoneDee

06-24-2006 11:51 AM

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

ResaleBroker

06-24-2006 12:38 PM

Happy to be of help. :)

Ohiosweetheart

11-05-2006 11:22 AM

Well that info is good news! :D

newforum

06-11-2007 04:49 PM

Quote:

Originally Posted by MickDoneDee (Post 994986)

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.

All times are GMT. The time now is 01:56 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01021 seconds Memory Usage 1,729KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: