View GitHub Repository xnewsletter

Schedule Inspection
Subscribe

Code Duplication    Length = 4-4 lines in 2 locations

admin/bmh.php 1 location

@@ 51-54 (lines=4) @@
48 
            $sql = "SELECT subscr_id FROM {$xoopsDB->prefix('xnewsletter_subscr')}";
49 
            $sql .= " WHERE (subscr_email='{$bmh_email}')";
50 
            $sql .= ' LIMIT 1;';
51 
            if ($user = $xoopsDB->query($sql)) {
52 
                $row_user  = $xoopsDB->fetchRow($user);
53 
                $subscr_id = (int)$row_user[0];
54 
            }
55 
            if (0 == $subscr_id) {
56 
                //set bmh_measure for all entries in bmh with this email
57 
                $sql_upd_measure = "UPDATE {$xoopsDB->prefix('xnewsletter_bmh')} SET `bmh_measure` = '" . _XNEWSLETTER_BMH_MEASURE_VAL_NOTHING . "'";

subscription.php 1 location

@@ 460-463 (lines=4) @@
457 
                    $sql        = "SELECT `uid` FROM {$xoopsDB->prefix('users')}";
458 
                    $sql        .= " WHERE (`email`='{$subscr_email}')";
459 
                    $sql        .= ' LIMIT 1';
460 
                    if ($user = $xoopsDB->query($sql)) {
461 
                        $row_user   = $xoopsDB->fetchRow($user);
462 
                        $subscr_uid = $row_user[0];
463 
                    }
464 
                    $subscrObj->setVar('subscr_uid', $subscr_uid);
465 
                    // form subscr_submitter
466 
                    $subscrObj->setVar('subscr_submitter', $uid);