Hi,
At my site http://art.spliffcanvas.net i still got some problems with the buddylist. When i add buddies it shows myself as active friends. And i can't seem to delete them. Hope that can be fixed to
Thanks in advance
can post 2-3 testuser accounts?
ok
sent the info in pm to you
I see that there's something weird with your buddylist. And I'd say it's something with the mysql table.
I've checked with a CPG bridged to SMF and on my testbed it worked without a problem. And without beeing able to replicate that issue I can give you advice but not a real solution. For a start I'd delete the buddy table and run update.php again. Cause as it looks like the buddy id and the user id somehow get mixed
ok, that seems to have done the trick.
Now i only need to figure out how to get this theme working with the modpack. Allready looked at those instructions, but i cannot figure it out yet.
ok, think i got that to ;)
thanks
hmm guess i was to soon.
When accepting it showed the right user. after it shows me again ?
got it.. however I need to setup a test environment (where no joins are possible). Then I can fix this. Guess somewhen this weekend.
Hmm, maybe you want to test the fix before the weekend. But it's utterly untested. Just what I think needs to be changed.
in udb_base.inc.php find
if($view=="1") $sql = "SELECT id, buddy_block, buddy_id, since FROM {$CONFIG['TABLE_BUDDY']} buddy_id=".(USER_ID)." AND buddy_block='YES' ";
if($view=="2") $sql = "SELECT id, since, buddy_from as buddy_id FROM {$CONFIG['TABLE_BUDDY_REQ']} WHERE buddy_to=".(USER_ID)." ";
if($view=="3") $sql = "SELECT id, since, buddy_to as buddy_id FROM {$CONFIG['TABLE_BUDDY_REQ']} WHERE buddy_from=".(USER_ID)." ";
if($view=="0") $sql = "SELECT id, buddy_ok, buddy_block, buddy_id, since FROM {$CONFIG['TABLE_BUDDY']} WHERE buddy_ok='YES' AND buddy_id = ".(USER_ID)." ";
and replace with
if($view=="1") $sql = "SELECT id, buddy_block, buddy_id, since FROM {$CONFIG['TABLE_BUDDY']} WHERE user_id=".(USER_ID)." AND buddy_block='YES' ";
if($view=="2") $sql = "SELECT id, since, buddy_from as buddy_id FROM {$CONFIG['TABLE_BUDDY_REQ']} WHERE buddy_to=".(USER_ID)." ";
if($view=="3") $sql = "SELECT id, since, buddy_to as buddy_id FROM {$CONFIG['TABLE_BUDDY_REQ']} WHERE buddy_from=".(USER_ID)." ";
if($view=="0") $sql = "SELECT id, buddy_ok, buddy_block, buddy_id, since FROM {$CONFIG['TABLE_BUDDY']} WHERE buddy_ok='YES' AND user_id = ".(USER_ID)." ";
i think that works. Changed and refresh the page changed it to the right buddy.
Thank you
Note: This fix isn't included into the modpack up to 1.4.12 v1. Later versions will contain it.
i noticed, so i just copied that file back ;)
The other fix was fine in the new version ;)