forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 modpack by Stramm => Topic started by: Mannie on July 04, 2007, 07:38:38 am
-
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 ;)