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);