Code Duplication    Length = 6-9 lines in 2 locations

class/SwDatabase.php 2 locations

@@ 394-402 (lines=9) @@
391
            $sql    = 'INSERT INTO ' . $xoopsDB->prefix('smallworld_friends') . " (id,me,you,status,date) VALUES ('', '" . $userid . "', '" . $friendid . "', '1', UNIX_TIMESTAMP())";
392
            $result = $xoopsDB->queryF($sql);
393
        }
394
        if ($status > 0) {
395
            $sql     = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_friends') . " WHERE me = '" . (int)$friendid . "' AND you = '" . (int)$userid . "'";
396
            $sql2    = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_friends') . " WHERE me = '" . (int)$userid . "' AND you = '" . (int)$friendid . "'";
397
            $result  = $xoopsDB->queryF($sql);
398
            $result2 = $xoopsDB->queryF($sql2);
399
400
            // Since friendship is canceled also following is deleted
401
            $this->toogleFollow(1, $userid, $friendid);
402
        }
403
    }
404
405
    /**
@@ 443-448 (lines=6) @@
440
            $query  = 'INSERT INTO ' . $xoopsDB->prefix('smallworld_friends') . " (id,me,you,status,date) VALUES ('', '" . $myUid . "', '" . $friend . "', '2', UNIX_TIMESTAMP())";
441
            $result = $xoopsDB->queryF($query);
442
        }
443
        if ($stat < 0) {
444
            $sql     = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_friends') . " WHERE me = '" . (int)$friend . "' AND you = '" . (int)$myUid . "'";
445
            $sql2    = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_friends') . " WHERE you = '" . (int)$friend . "' AND me = '" . (int)$myUid . "'";
446
            $result  = $xoopsDB->queryF($sql);
447
            $result2 = $xoopsDB->queryF($sql2);
448
        }
449
    }
450
451
    /**