View GitHub Repository xnewsletter

Schedule Inspection
Subscribe

Code Duplication    Length = 4-4 lines in 2 locations

admin/bmh.php 1 location

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

subscription.php 1 location

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