Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Buddy List issues  (Read 7121 times)

0 Members and 1 Guest are viewing this topic.

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Buddy List issues
« 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
« Last Edit: July 05, 2007, 06:36:54 pm by Stramm »
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy List issues
« Reply #1 on: July 04, 2007, 07:58:32 am »

can post 2-3 testuser accounts?

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Re: Buddy List issues
« Reply #2 on: July 04, 2007, 02:09:22 pm »

ok
sent the info in pm to you
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy List issues
« Reply #3 on: July 04, 2007, 04:29:03 pm »

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

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Re: Buddy List issues
« Reply #4 on: July 04, 2007, 04:47:52 pm »

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.
Logged

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Re: Buddy List issues
« Reply #5 on: July 04, 2007, 04:57:31 pm »

ok, think i got that to ;)
thanks
Logged

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Re: Buddy List issues
« Reply #6 on: July 04, 2007, 05:01:17 pm »

hmm guess i was to soon.
When accepting it showed the right user. after it shows me again ?
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy List issues
« Reply #7 on: July 04, 2007, 05:08:31 pm »

got it.. however I need to setup a test environment (where no joins are possible). Then I can fix this. Guess somewhen this weekend.

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy List issues
« Reply #8 on: July 04, 2007, 05:14:16 pm »

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
Code: [Select]
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
Code: [Select]
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)." ";

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Re: Buddy List issues
« Reply #9 on: July 04, 2007, 05:31:50 pm »

i think that works. Changed and refresh the page changed it to the right buddy.
Thank you
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Buddy List issues
« Reply #10 on: July 05, 2007, 06:39:16 pm »

Note: This fix isn't included into the modpack up to 1.4.12 v1. Later versions will contain it.

Mannie

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 21
    • Spliffcanvas
Re: Buddy List issues
« Reply #11 on: July 05, 2007, 06:50:05 pm »

i noticed, so i just copied that file back ;)

The other fix was fine in the new version ;)
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 21 queries.