XoopsModules25x /
smallworld
| @@ 416-430 (lines=15) @@ | ||
| 413 | * @param int $friend |
|
| 414 | * @return void |
|
| 415 | */ |
|
| 416 | public function toogleFollow($following, $myUid, $friend) |
|
| 417 | { |
|
| 418 | global $xoopsDB; |
|
| 419 | if (0 == $following) { |
|
| 420 | $sql = 'INSERT INTO ' . $xoopsDB->prefix('smallworld_followers') . " (id,me,you,status,date) VALUES ('', '" . $myUid . "', '" . $friend . "', '1', UNIX_TIMESTAMP())"; |
|
| 421 | $result = $xoopsDB->queryF($sql); |
|
| 422 | } |
|
| 423 | if ($following > 0) { |
|
| 424 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_followers') . " WHERE you = '" . (int)$friend . "'"; |
|
| 425 | $sql .= " AND me = '" . (int)$myUid . "'"; |
|
| 426 | $sql2 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_followers') . " WHERE me = '" . (int)$friend . "'"; |
|
| 427 | $sql2 .= " AND you = '" . (int)$myUid . "'"; |
|
| 428 | $result2 = $xoopsDB->queryF($sql2); |
|
| 429 | } |
|
| 430 | } |
|
| 431 | ||
| 432 | /** |
|
| 433 | * SetFriendshitStat function |
|
| @@ 419-433 (lines=15) @@ | ||
| 416 | * @param int $friend |
|
| 417 | * @return void |
|
| 418 | */ |
|
| 419 | public function toogleFollow($following, $myUid, $friend) |
|
| 420 | { |
|
| 421 | global $xoopsDB; |
|
| 422 | if (0 == $following) { |
|
| 423 | $sql = 'INSERT INTO ' . $xoopsDB->prefix('smallworld_followers') . " (me,you,status,date) VALUES ('" . $myUid . "', '" . $friend . "', '1', UNIX_TIMESTAMP())"; |
|
| 424 | $result = $xoopsDB->queryF($sql); |
|
| 425 | } |
|
| 426 | if ($following > 0) { |
|
| 427 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_followers') . " WHERE you = '" . (int)$friend . "'"; |
|
| 428 | $sql .= " AND me = '" . (int)$myUid . "'"; |
|
| 429 | $sql2 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_followers') . " WHERE me = '" . (int)$friend . "'"; |
|
| 430 | $sql2 .= " AND you = '" . (int)$myUid . "'"; |
|
| 431 | $result2 = $xoopsDB->queryF($sql2); |
|
| 432 | } |
|
| 433 | } |
|
| 434 | ||
| 435 | /** |
|
| 436 | * SetFriendshitStat function |
|
