View GitHub Repository xnewsletter

Schedule Inspection
Subscribe

Code Duplication    Length = 4-4 lines in 2 locations

admin/bmh.php 1 location

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

subscription.php 1 location

@@ 201-204 (lines=4) @@
198 
                $sql = "SELECT `uid` FROM {$xoopsDB->prefix('users')}";
199 
                $sql .= " WHERE (`email`='{$subscr_email}')";
200 
                $sql .= ' LIMIT 1';
201 
                if ($user = $xoopsDB->query($sql)) {
202 
                    $row_user = $xoopsDB->fetchRow($user);
203 
                    $subscr_uid = $row_user[0];
204 
                }
205 
                $subscrObj->setVar('subscr_uid', (int) $subscr_uid);
206 
                // form subscr_submitter
207 
                $subscrObj->setVar('subscr_submitter', $submitterUid);