1) { $sql = 'SELECT address_id FROM '.DB_PREPEND.'phpwcms_address '; $sql .= "WHERE address_email='".aporeplace($value['address_email'])."' "; $sql .= 'ORDER BY address_verified DESC, address_name DESC LIMIT 1'; $dataID = _dbQuery($sql); if(!empty($dataID[0]['address_id'])) { $sql = 'DELETE FROM '.DB_PREPEND.'phpwcms_address '; $sql .= "WHERE address_email='".aporeplace($value['address_email'])."' "; $sql .= "AND address_id != ".intval($dataID[0]['address_id']); @_dbQuery($sql, 'DELETE'); } } } } headerRedirect(PHPWCMS_URL.'phpwcms.php?do=messages&p=4'); } // delete susbcriber if(isset($_GET["del"]) && isset($_GET["s"]) && $_GET["del"] == $_GET["s"]) { _dbQuery("DELETE FROM ".DB_PREPEND."phpwcms_address WHERE address_id=".intval($_GET["del"])." LIMIT 1", 'DELETE'); } // change verification if(isset($_GET["verify"]) && isset($_GET["s"])) { $sql = "UPDATE ".DB_PREPEND."phpwcms_address SET address_verified="; $sql .= intval($_GET["verify"]) ? 1 : 0; $sql .= " WHERE address_id=".intval($_GET["s"])." LIMIT 1"; _dbQuery($sql, 'UPDATE'); } echo '
"; echo ' | '."\n"; echo ''.$row["address_email"]." | \n"; echo ''.html_specialchars($row["address_name"])." | \n"; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo " | \n\n"; $row_count++; } if($row_count) { echo '