XoopsModules25x / mylinks

    $lid = MylinksUtility::mylinks_cleanVars($_GET, 'lid', 0, 'int', array('min' => 0));

    $dbTables = array('links', 'text', 'votedata', 'broken', 'mod');

    foreach ($dbTables as $thisTable) {

        $sql    = sprintf('DELETE FROM %s WHERE lid = %u', $xoopsDB->prefix("mylinks_{$thisTable}"), $lid);

        $result = $xoopsDB->query($sql);

        if (!$result) {

            MylinksUtility::show_message(_MD_MYLINKS_DBNOTUPDATED);

            exit();

        }

    }

    // delete comments & notifications

    xoops_comment_delete($xoopsModule->getVar('mid'), $lid);

    xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'link', $lid);

        if ($lidArray) {

            $linkIDs  = '(' . implode(',', $lidArray) . ')';

            $dbTables = array('links', 'text', 'votedata', 'broken', 'mod');

            foreach ($dbTables as $thisTable) {

                $sql    = sprintf('DELETE FROM %s WHERE lid IN %s', $xoopsDB->prefix("mylinks_{$thisTable}"), $linkIDs);

                $result = $xoopsDB->query($sql);

                if (!result) {

                    MylinksUtility::show_message(_MD_MYLINKS_NORECORDFOUND);

                    exit();

                }

            }

            // remove any notifications and comments for these listings

            foreach ($lidArray as $this_lid) {

                xoops_comment_delete($xoopsModule->getVar('mid'), $this_lid);