Code Duplication    Length = 6-9 lines in 2 locations

class/SwDatabase.php 2 locations

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