XoopsModules25x / xnewsletter

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

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

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

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

                    ++$deleted;

                } else {

                    $errors[] = 'Error delete catsubscr: ' . $result->getHtmlErrors();

                }

            }

            if (count($errors) > 0) {

                }

                if ($number_ids > 0) {

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

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

                        ++$update;

                    } else {

                        $errors[] = 'Error update cat_mailinglist: ' . $result->getHtmlErrors();

                    }

                }

            } else {

                //set cat_mailinglist = 0, if mailinglist_id is no more existing in table mailinglist

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

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

                        ++$update;

                    } else {

                        $errors[] = 'Error update cat_mailinglist: ' . $result->getHtmlErrors();

                    }

                }

            }