XoopsModules25x / xnewsletter

            $sql        = 'SELECT Count(`catsubscr_id`) AS `nb_ids`';

            $sql        .= " FROM `{$xoopsDB->prefix('xnewsletter_catsubscr')}` LEFT JOIN `{$xoopsDB->prefix('xnewsletter_subscr')}` ON `catsubscr_subscrid` = `subscr_id`";

            $sql        .= ' WHERE (`subscr_id` Is Null)';

            if ($result = $xoopsDB->query($sql)) {

                $row_result = $xoopsDB->fetchRow($result);

                $number_ids = $row_result[0];

            }

            if ($number_ids > 0) {

                $sql    = "DELETE `{$xoopsDB->prefix('xnewsletter_catsubscr')}`";

                $sql    .= " FROM `{$xoopsDB->prefix('xnewsletter_catsubscr')}` LEFT JOIN `{$xoopsDB->prefix('xnewsletter_subscr')}` ON `catsubscr_subscrid` = `subscr_id`";

                $sql = 'SELECT Count(`cat_id`) AS `nb_ids`';

                $sql .= " FROM `{$xoopsDB->prefix('xnewsletter_cat')}`";

                $sql .= ' WHERE (`cat_mailinglist` > 0)';

                if ($result = $xoopsDB->query($sql)) {

                    $row_result = $xoopsDB->fetchRow($result);

                    $number_ids = $row_result[0];

                }

                if ($number_ids > 0) {

                    $sql = "UPDATE `{$xoopsDB->prefix('xnewsletter_cat')}` SET `cat_mailinglist` = 0";

                    if ($result = $xoopsDB->query($sql)) {

                $sql = 'SELECT Count(`cat_mailinglist`) AS `nb_ids`';

                $sql .= " FROM `{$xoopsDB->prefix('xnewsletter_cat')}` LEFT JOIN `{$xoopsDB->prefix('xnewsletter_mailinglist')}` ON `cat_mailinglist` = `mailinglist_id`";

                $sql .= ' WHERE (((`mailinglist_id`) Is Null) AND ((`cat_mailinglist`)>0)) HAVING (((Count(`cat_mailinglist`))>0));';

                if ($result = $xoopsDB->query($sql)) {

                    $row_result = $xoopsDB->fetchRow($result);

                    $number_ids = $row_result[0];

                }

                if ($number_ids > 0) {

                    $sql = "UPDATE `{$xoopsDB->prefix('xnewsletter_cat')}` LEFT JOIN `{$xoopsDB->prefix('xnewsletter_mailinglist')}` ON `cat_mailinglist` = `mailinglist_id` SET `cat_mailinglist` = 0";

                    $sql .= ' WHERE (((`cat_mailinglist`)>0) AND ((`mailinglist_id`) Is Null));';