2011-04-16, 03:21 AM
2011-04-16, 03:37 AM
I'm not sure if it is, but the referrals count might be cached my MyBB.
2011-04-16, 10:35 AM
(2011-04-15, 11:14 PM)KEY Wrote: [ -> ]so there is no missing symbols or any character here?
UPDATEmybb_users
SETreferrer
= '0' WHEREuid
= '3';
No, there is nothing missing, you would get an error if there was.
(2011-04-15, 11:14 PM)KEY Wrote: [ -> ]i will install again mybb from the start i hate to see this bug.
What?? First, you don't need to reinstall. Second, this is not a bug. As I said above, if this isn't working, either you're running this query incorrectly, or we've misunderstood what it is you're actually trying to achieve.
(2011-04-16, 03:37 AM)Malcolm. Wrote: [ -> ]I'm not sure if it is, but the referrals count might be cached my MyBB.
MyBB doesn't cache information on an individual user.
2011-04-23, 03:55 PM
yaldaram is keep on saying that UID, obviously I know the UID of the certain user that I will going to remove referrals.
@malcolm I think you have a point, but how can I update that?
@matt I know how to run query, obviously in a certain table that needed to be run. base on your tutorial thread.
run successfully without an error but still the referral count of a certain user remain.
bugs
isn't
@malcolm I think you have a point, but how can I update that?
@matt I know how to run query, obviously in a certain table that needed to be run. base on your tutorial thread.
run successfully without an error but still the referral count of a certain user remain.
bugs
isn't
referrals
or referrer
?? 2011-04-23, 04:34 PM
This isn't a bug, you running a query and it not working is not a bug in MyBB.
If that query isn't working then try changing the column to referrals instead of referrer. I've said all along we might not be understanding what you're trying to do because you've not explained it.
If that query isn't working then try changing the column to referrals instead of referrer. I've said all along we might not be understanding what you're trying to do because you've not explained it.
2011-04-23, 04:44 PM
very simple, for example matt you are my member in my forum and you have 10 referred members. obviously in your profile indicate:
now I would like to remove that 10. thats it! well explained
Referrals: 10
now I would like to remove that 10. thats it! well explained
2011-04-23, 04:53 PM
Run this;
UPDATE mybb_users SET `referrals` = '0' WHERE `uid` = 'X';
Replace X from where you want to remove referrals.2011-04-23, 04:55 PM
(2011-04-23, 04:53 PM)Yaldaram Wrote: [ -> ]Run this;
Replace X from where you want to remove referrals.UPDATE mybb_users SET `referrals` = '0' WHERE `uid` = 'X';
could you please stop insisting UID!!!!
I know that!!!!
Quote:yaldaram is keep on saying that UID, obviously I know the UID of the certain user that I will going to remove referrals.
2011-04-23, 05:03 PM
(2011-04-23, 04:55 PM)KEY Wrote: [ -> ](2011-04-23, 04:53 PM)Yaldaram Wrote: [ -> ]Run this;
Replace X from where you want to remove referrals.UPDATE mybb_users SET `referrals` = '0' WHERE `uid` = 'X';
could you please stop insisting UID!!!!
I know that!!!!
Quote:yaldaram is keep on saying that UID, obviously I know the UID of the certain user that I will going to remove referrals.
Then how you specify from where you are removing that ?
2011-04-23, 05:07 PM
(2011-04-23, 05:03 PM)Yaldaram Wrote: [ -> ](2011-04-23, 04:55 PM)KEY Wrote: [ -> ](2011-04-23, 04:53 PM)Yaldaram Wrote: [ -> ]Run this;
Replace X from where you want to remove referrals.UPDATE mybb_users SET `referrals` = '0' WHERE `uid` = 'X';
could you please stop insisting UID!!!!
I know that!!!!
Quote:yaldaram is keep on saying that UID, obviously I know the UID of the certain user that I will going to remove referrals.
Then how you specify from where you are removing that ?
thanks anyway
but still the referral count remains.
have you try to your board to query a test user that has referral? maybe I'm the only 1 experiencing this.
bugs