| $desc | |
| "; $lists=mysql_query("SELECT * FROM " . $TABLEPREFIX . "lists ORDER BY ListName ASC"); while($l=mysql_fetch_assoc($lists)){ $l = stripslashes_array($l); if(AllowList($l['ListID'])) { $e++; if(mysql_num_rows(mysql_query("SELECT * FROM " . $TABLEPREFIX . "form_lists WHERE ListID='".addslashes($l['ListID'])."' AND FormID='".addslashes($FormID)."'"))) { $s="CHECKED"; } else { $s=""; } $FORM_ITEMS[" " . $l["ListName"]]="checkbox|Lists[".$l["ListID"]."]:1:Yes:$s"; } } $all_fields = array(); $skip = array(); $ordered_fields_query = "SELECT lf.*, ff.FieldOrder, 'CHECKED' AS selected FROM " . $TABLEPREFIX . "form_fields ff, " . $TABLEPREFIX . "list_fields lf WHERE ff.FieldID=lf.FieldID AND ff.FormID='" . addslashes($FormID) . "'"; if (!isset($CURRENTADMIN['Manager']) || $CURRENTADMIN['Manager'] == 0) $ordered_fields_query .= " AND lf.AdminID='" . addslashes($CURRENTADMIN['AdminID']) . "'"; $ordered_fields_query .= " ORDER BY ff.FieldOrder, lf.FieldName"; $ordered_fields_result = mysql_query($ordered_fields_query); if (mysql_num_rows($ordered_fields_result) > 0) { while($row = mysql_fetch_assoc($ordered_fields_result)) { $row = stripslashes_array($row); $all_fields[$row['FieldID']] = $row; $skip[] = $row['FieldID']; } } if (empty($skip)) $skip[] = '0'; $unordered_fields_query = "SELECT *, 0 AS FieldOrder, 0 AS selected FROM " . $TABLEPREFIX . "list_fields WHERE FieldID NOT IN (" . implode(',', $skip) . ")"; if (!isset($CURRENTADMIN['Manager']) || $CURRENTADMIN['Manager'] == 0) $unordered_fields_query .= " AND AdminID='".addslashes($CURRENTADMIN['AdminID'])."'"; $unordered_fields_query .= " ORDER BY FieldName ASC"; $unordered_results = mysql_query($unordered_fields_query); if (mysql_num_rows($unordered_results) > 0) { while($row = mysql_fetch_assoc($unordered_results)) { $row = stripslashes_array($row); $all_fields[$row['FieldID']] = $row; } } if (!empty($all_fields)) { $FORM_ITEMS["-102"]="spacer| | |
| Custom Fields to Show | |
| ";
$first = true;
foreach($all_fields as $fieldid => $details) {
$FORM_ITEMS[" " . $details['FieldName'].' ']="checkbox|Fields[".$fieldid."]:1:Yes:" . $details['selected'] . '$$$BAR$$$';
$FORM_ITEMS[" " . $details['FieldName'] . " Order"]="textfield|FieldOrder[".$fieldid."]:2:2:" . $details['FieldOrder'].":0::field20";
if ($first) {
$HELP_ITEMS['FieldOrder[' . $fieldid . ']']['Title'] = 'Include this field';
$HELP_ITEMS['FieldOrder[' . $fieldid . ']']['Content'] = 'If ticked, this field will be included in the form. Sort Order You can also set the order the fields appear in - put in a number (eg 1) for that fields position in the form'; } $first = false; } } break; case 'unsub': $FORM_ITEMS["-101"]="spacer| | |
| Lists to unsubscribe from | |
| ";
$lists=mysql_query("SELECT * FROM " . $TABLEPREFIX . "lists ORDER BY ListName ASC");
while($l=mysql_fetch_assoc($lists)) {
$l = stripslashes_array($l);
if(AllowList($l['ListID'])) {
$e++;
if(mysql_num_rows(mysql_query("SELECT * FROM " . $TABLEPREFIX . "form_lists WHERE ListID='".addslashes($l['ListID'])."' AND FormID='".addslashes($FormID)."'"))) {
$s="CHECKED";
} else {
$s="";
}
$FORM_ITEMS[" " . $l["ListName"]]="checkbox|Lists[".$l["ListID"]."]:1:Yes:$s";
}
}
break;
}
$FORM_ITEMS["-2"]="spacer| "; if($SubAction == "") $FORM_ITEMS[-1]="submit|Next »:1-forms"; else $FORM_ITEMS[-1]="submit|Next »:1-forms"; //make the form $FORM=new AdminForm; $FORM->title="View Banned"; $FORM->items=$FORM_ITEMS; if($SubAction == "") $action = "forms?Action=EditForm&Save=Yes&FormID=$FormID"; else $action = "forms?Action=EditForm&SubAction=Edit&Save=Yes&FormID=$FormID"; $FORM->action=MakeAdminLink($action); $FORM->MakeForm("New Form Details"); $FO=$FORM->output; switch($form['FormType']) { case 'sub': $formType = 'Subscription'; break; case 'unsub': $formType = 'Unsubscription'; break; case 'modify': $formType = 'Modify Subscriber Details'; break; } if($SubAction == "") { $FO = "Complete the form below to create a new $formType form. Click on the \"Continue to Step 3\" button to continue." . $FO; $OUTPUT.=MakeBox("Create Form (Step 2 of 3)", $FO); } else { $FO = "Complete the form below to update the selected form. Click on the \"Continue to Step 2\" button to continue." . $FO; $OUTPUT.=MakeBox("Edit Form (Step 1 of 2)", $FO); } $OUTPUT .= ' '; $DontDo=1; } } if($Action=='ResponseOptions'){ $form=mysql_fetch_assoc(mysql_query("SELECT * FROM " . $TABLEPREFIX . "forms WHERE FormID='".addslashes($FormID)."'")); $form = stripslashes_array($form); if($SubSave){ mysql_query("DELETE FROM " . $TABLEPREFIX . "form_responses WHERE FormID='".addslashes($FormID)."'"); foreach($Responses as $Name => $Val ) { mysql_query("INSERT INTO " . $TABLEPREFIX . "form_responses SET ResponseName='".addslashes($Name)."', FormID='".addslashes($FormID)."', ResponseData='".addslashes($Val)."'"); } $query = "UPDATE " . $TABLEPREFIX . "forms SET SendName='" . addslashes($_POST['SendName']) . "', SendEmail='" . addslashes($_POST['SendEmail']) . "' WHERE FormID='" . addslashes($FormID) . "'"; mysql_query($query); $OUTPUT .= MakeSuccessBox("Form Saved Successfully", "Your form has been saved successfully.", MakeAdminLink("forms")); }else{ $extraChecks = ""; // lets set all the defaults. These are the only things that are different. switch($form['FormType']) { case 'sub': $confirm_subject = "Confirm Subscribe Request"; $confirm_email = "Hi,\r\nPlease click on the link below to confirm your subscription of %EMAIL% to the following mailing lists:\r\n\r\n%LISTS%\r\n\r\n%CONFIRMLINK%"; $confirm_html = ' | |