XoopsModules25x / xoopstube

                // get all links in each subcategory

                $result = $GLOBALS['xoopsDB']->query('SELECT lid FROM ' . $GLOBALS['xoopsDB']->prefix('xoopstube_videos') . ' WHERE cid=' . (int)$arr[$i]);

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

                while (false !== (list($lid) = $GLOBALS['xoopsDB']->fetchRow($result))) {

                    $sql = sprintf('DELETE FROM %s WHERE lid = %u', $GLOBALS['xoopsDB']->prefix('xoopstube_votedata'), (int)$lid);

                    $GLOBALS['xoopsDB']->query($sql);

                    $sql = sprintf('DELETE FROM %s WHERE lid = %u', $GLOBALS['xoopsDB']->prefix('xoopstube_videos'), (int)$lid);

                    $GLOBALS['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', $GLOBALS['xoopsDB']->prefix('xoopstube_cat'), (int)$arr[$i]);

                $GLOBALS['xoopsDB']->query($sql);

            }

            // all subcategory and associated data are deleted, now delete category data and its associated data

            $result = $GLOBALS['xoopsDB']->query('SELECT lid FROM ' . $GLOBALS['xoopsDB']->prefix('xoopstube_videos') . ' WHERE cid=' . (int)$cid);

            while (false !== (list($lid) = $GLOBALS['xoopsDB']->fetchRow($result))) {

                $sql = sprintf('DELETE FROM %s WHERE lid = %u', $GLOBALS['xoopsDB']->prefix('xoopstube_videos'), (int)$lid);

                $GLOBALS['xoopsDB']->query($sql);

                // delete comments

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

                $sql = sprintf('DELETE FROM %s WHERE lid = %u', $GLOBALS['xoopsDB']->prefix('xoopstube_votedata'), (int)$lid);

                $GLOBALS['xoopsDB']->query($sql);

            }

            // delete altcat entries

            $sql = sprintf('DELETE FROM %s WHERE cid = %u', $GLOBALS['xoopsDB']->prefix('xoopstube_altcat'), (int)$cid);