I want to remove the referred member of a certain user.
thanks!
Run this;
UPDATE mybb_users SET referrer=0 WHERE uid=3;
Replace 3 to the User ID you want to remove his/her Referred users.
Also Replace mybb_ to your Database Prefix.
@cron do you successfully remove the referred user? the query is not working? any body can help?
What happens when you run the query?
(2011-04-15, 06:38 PM)KEY Wrote: [ -> ]@cron do you successfully remove the referred user? the query is not working? any body can help?
make sure your database prefix is
mybb_
.
@AJS it says okey, but still there in the prostat
@Yaldaram I tried the one you have posted without ``
anyway I will try again the new one. how about the referrer=0 WHERE uid=3; there is no ``
is this the right query?
UPDATE
mybb_users
SET
referrer
= '0' WHERE
uid
='3';
??
nobody knows.
So you're saying a user has registered, the enter name of the suer that referred them, and you want to remove the referrer they put in, right?? Because that query will do that; if it stills shows in Prostats it might be storing it somewhere else, I don't know how prostats works.
is this right?
UPDATE mybb_users
SET referrer
= '0' WHERE uid
= '3';
or what?
Yes, that's fine. If it's not working, either you're not running it right, we've misunderstood what you're trying to do, or Prostats stores this information separately.
so there is no missing symbols or any character here?
UPDATE
mybb_users
SET
referrer
= '0' WHERE
uid
= '3';
i remove prostat then install again but still there.
i will install again mybb from the start i hate to see this bug.