Announcement

Collapse
No announcement yet.

Resetting Users Referrer Count

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Resetting Users Referrer Count

    Is there any way to reset individual users’ referrer count? It doesn’t seem to appear in the User Manager, although other variables do, e.g. Reputation, Infractions etc.

    Thanks!

  • #2
    Try this query...
    Code:
    UPDATE
        user
    SET
        referrerid = 0
    WHERE
        referrerid = X
    Change X to the userid of the individual.

    To reset everyone, don't use the where clause.
    Lats...

    Comment


    • #3
      Thanks very much for this.

      It's going to be hard doing this manually, though, on a regular basis. is there any way to embed it into an html page, so the user can simply enter the data on a form and the query is run?

      Thanks for the help.

      Peter

      Comment


      • #4
        Yes, that is possible - there's a tutorial @ vbulletin.org which shows how to make a non-vbpage.
        Lats...

        Comment


        • #5
          I'm sorry, but I simply can't find this anywhere - can you be more specific?

          P.

          Comment


          • #6
            How to create your own vBulletin-powered page! (uses vB templates)
            Lats...

            Comment

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