function get_unsent_mail($email) { if (!check_admin_user($email)) { return false; } $list = array(); $query = "select mailid, subject, listid from mail \r\n where status = 'STORED' or status = 'TESTED' order by modified"; if (db_connect()) { $result = mysql_query($query); if (!$result) { echo '<p>Unable to get list from database.'; return false; } $num = mysql_numrows($result); for ($i = 0; $i < $num; $i++) { array_push($list, array(mysql_result($result, $i, 0), mysql_result($result, $i, 1), get_list_name(mysql_result($result, $i, 2)), mysql_result($result, $i, 2))); } } return $list; }
$subj_gender = $data[2]; $subj_bdate = $data[3]; $subj_email = $data[4]; $subj_status = $data[5]; if (!subject_exists($subj_email)) { $query = "INSERT INTO subjects (`first_name`, `last_name`, `gender`, `birth_date`, `email`, `status`)\n\t\t\t\t\t\t\t\t\t\t\tVALUES ('" . $subj_first_name . "', '" . $subj_last_name . "', '" . $subj_gender . "', '" . $subj_bdate . "', '" . $subj_email . "', '" . $subj_status . "') "; $result = mysql_query($query, $dbconnect); confirm_query($result); $subj_id = mysql_insert_id(); $subject_count++; if (isset($list_id)) { // add the imported subject to the edited list $query_rel = "INSERT INTO rel_subj_list (`list_id`, `subj_id`) VALUES ('" . $list_id . "', '" . $subj_id . "')"; $result_rel = mysql_query($query_rel, $dbconnect); if (mysql_affected_rows() == 1) { $list_name = get_list_name($list_id, $lang); echo "Subject has been added to list {$list_name}."; } } } else { continue; } } fclose($handle); unlink($storage_path); if (isset($list_id)) { $mesaj[] = $subject_count . " subjects were added to this list"; $_SESSION["mesaj"] = $mesaj; redirect("view_list.php?list_id=" . $list_id); } else { $mesaj[] = $subject_count . " subjects were added";
function get_unsent_mail($user) { if (!check_admin_user($user)) { return false; } $list = array(); $query = "select mailid, subject, listid from mail \n where status = 'STORED' or status = 'TESTED' order by modified"; if ($conn = db_connect()) { $result = $conn->query($query); if (!$result) { echo '<p>Unable to get list from database.</p>'; return false; } $num = $result->num_rows; for ($i = 0; $i < $num; $i++) { $row = $result->fetch_array(); array_push($list, array($row[0], $row[1], get_list_name($row[2]), $row[2])); } } return $list; }
} if (!check_logged_in()) { display_login_form($action); } break; case 'log-in': case '': if (!check_logged_in()) { display_login_form($action); } break; case 'show-all-lists': display_items('All Lists', get_all_lists(), 'information', 'show-archive', ''); break; case 'show-archive': display_items('Archive For ' . get_list_name($_GET['id']), get_archive($_GET['id']), 'view-html', 'view-text', ''); break; case 'information': display_information($_GET['id']); break; default: if (!check_logged_in()) { display_login_form($action); } break; } //all other actions require user to be logged in if (check_logged_in()) { switch ($action) { case 'account-settings': display_account_form(get_email(), get_real_name(get_email()), get_mimetype(get_email()));
} if ($complaint == 1) { $unsubscribed = '<span class="label label-inverse">' . _('Marked as spam') . '</span>'; } if ($confirmed == 0) { $unsubscribed = '<span class="label">' . _('Unconfirmed') . '</span>'; } if ($name == '') { $name = '[' . _('No name') . ']'; } echo ' <tr id="' . $id . '"> <td><a href="#subscriber-info" data-id="' . $id . '" data-toggle="modal" class="subscriber-info">' . $name . '</a></td> <td><a href="#subscriber-info" data-id="' . $id . '" data-toggle="modal" class="subscriber-info">' . $email . '</a></td> <td><a href="' . get_app_info('path') . '/subscribers?i=' . get_app_info('app') . '&l=' . $list . '">' . get_list_name($list) . '</a></td> <td>' . $timestamp . '</td> <td id="unsubscribe-label-' . $id . '">' . $unsubscribed . '</td> <td> '; if ($row['unsubscribed'] == 0) { $action_icon = ' <a href="javascript:void(0)" title="' . _('Unsubscribe') . ' ' . $email . '" data-action' . $id . '="unsubscribe" id="unsubscribe-btn-' . $id . '"> <i class="icon icon-ban-circle"></i> </a> '; } else { if ($row['unsubscribed'] == 1) { $action_icon = ' <a href="javascript:void(0)" title="' . _('Resubscribe') . ' ' . $email . '" data-action' . $id . '="resubscribe" id="unsubscribe-btn-' . $id . '"> <i class="icon icon-ok"></i>