@@ 490-498 (lines=9) @@ | ||
487 | if (0 == $status) { |
|
488 | $sql = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('smallworld_friends') . " (me,you,status,date) VALUES ('" . $userid . "', '" . $friendid . "', '1', UNIX_TIMESTAMP())"; |
|
489 | $result = $GLOBALS['xoopsDB']->queryF($sql); |
|
490 | } elseif ($status > 0) { |
|
491 | $sql = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_friends') . " WHERE me = '" . (int)$friendid . "' AND you = '" . (int)$userid . "'"; |
|
492 | $sql2 = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_friends') . " WHERE me = '" . (int)$userid . "' AND you = '" . (int)$friendid . "'"; |
|
493 | $result = $GLOBALS['xoopsDB']->queryF($sql); |
|
494 | $result = $result && $GLOBALS['xoopsDB']->queryF($sql2); |
|
495 | ||
496 | // Since friendship is canceled also following is deleted |
|
497 | $this->toogleFollow(1, $userid, $friendid); |
|
498 | } |
|
499 | ||
500 | return $result ? true : false; |
|
501 | } |
|
@@ 545-550 (lines=6) @@ | ||
542 | $query2 = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('smallworld_friends') . " (me,you,status,date) VALUES ('" . $myUid . "', '" . $friend . "', '2', UNIX_TIMESTAMP())"; |
|
543 | $result = $GLOBALS['xoopsDB']->queryF($query); |
|
544 | $result = $result && $GLOBALS['xoopsDB']->queryF($query2); |
|
545 | } elseif (0 > $stat) { |
|
546 | $query = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_friends') . " WHERE me = '" . (int)$friend . "' AND you = '" . (int)$myUid . "'"; |
|
547 | $query2 = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_friends') . " WHERE you = '" . (int)$friend . "' AND me = '" . (int)$myUid . "'"; |
|
548 | $result = $GLOBALS['xoopsDB']->queryF($query); |
|
549 | $result = $result && $GLOBALS['xoopsDB']->queryF($query2); |
|
550 | } |
|
551 | return $result ? true : false; |
|
552 | } |
|
553 |