No announcement yet.

Anyway to delete people's referalls?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Anyway to delete people's referalls?

    If there is a person who has like 50 referrals (all being himself), is there a way to mass delete them?

  • #2
    No, vBulletin does not have an option build in to do this.

    This would require a custom MySQL query.


    • #3
      Assuming your table names haven't changed (you haven't added a prefix during installation), and you know what a query is and what it does:

      UPDATE user SET referrerid='0' WHERE username='[Insert Username]';

      Run that query for each of the users you want to delete the referrer id #. Only thing that should change each time is [Insert Username]. Be careful when using sequence query language, cuz if you don't know what you're doing, you can mess things up easily. For example forgetting the WHILE - you can easily strip an entire column of values fromthe DB that you didn't want to. The above query will not do any harm as long as you enter in the username correctly.

      PS. I believe you can run queries if you login to the admincp. Tried didn't work for me, but it's at the bottom of the left frame, open the maintenance group. ( (Administrator)
      Fansite for RagnarokOnline since 2002. Since I started I've learned a lot. I'm so vastly experienced at PHP I can pretty much code anything.


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.