The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
Help needed with an SQL query to remove referrers
Hi,
I want to delete all the refers from a certain user. I've been using the referrer system on one account to track signups through my google advert. But this account now has so many referrals it looks wrong in the stats hack I've got installed. Can anyone help me with simple query that can purge the refers for a particular user? |
#2
|
||||
|
||||
Quote:
PHP Code:
[sql]UPDATE user set referrerid=0 where referrerid=particular_user[/sql] |
#3
|
||||
|
||||
That worked, thanks
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|