XoopsModules25x / xoopstube

                    'SELECT lid FROM ' . $xoopsDB->prefix('xoopstube_videos') . ' WHERE cid=' . intval($arr[$i])

                );

                // now for each linkload, delete the text data and vote ata associated with the linkload

                while (list($lid) = $xoopsDB->fetchRow($result)) {

                    $sql = sprintf(

                        "DELETE FROM %s WHERE lid = %u",

                        $xoopsDB->prefix('xoopstube_votedata'),

                        intval($lid)

                    );

                    $xoopsDB->query($sql);

                    $sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix('xoopstube_videos'), intval($lid));

                    $xoopsDB->query($sql);

                    // delete comments

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

                }

                // all links for each subcategory is deleted, now delete the subcategory data

                $sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix('xoopstube_cat'), intval($arr[$i]));

                $xoopsDB->query($sql);

            $result = $xoopsDB->query(

                'SELECT lid FROM ' . $xoopsDB->prefix('xoopstube_videos') . ' WHERE cid=' . intval($cid)

            );

            while (list($lid) = $xoopsDB->fetchRow($result)) {

                $sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix('xoopstube_videos'), intval($lid));

                $xoopsDB->query($sql);

                // delete comments

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

                $sql = sprintf("DELETE FROM %s WHERE lid = %u", $xoopsDB->prefix('xoopstube_votedata'), intval($lid));

                $xoopsDB->query($sql);

            }

            // delete altcat entries

            $sql = sprintf("DELETE FROM %s WHERE cid = %u", $xoopsDB->prefix('xoopstube_altcat'), intval($cid));