{"id":9,"date":"2006-01-12T19:08:38","date_gmt":"2006-01-12T18:08:38","guid":{"rendered":"http:\/\/s143831080.websitehome.co.uk\/mc\/support-the-campaign\/"},"modified":"2006-01-15T19:26:25","modified_gmt":"2006-01-15T19:26:25","slug":"support-the-campaign","status":"publish","type":"page","link":"http:\/\/www.mingcampbell.org.uk\/ccarchive\/support-the-campaign\/","title":{"rendered":"Join the campaign"},"content":{"rendered":"\n $pqr_description)
\n\t{
\n\t\t$answer = $pqr_answers[$pqr_variable];
\n\t\techo “<\/p>\n\\n<\/p>\n$pqr_description<\/td>\n

\\n<\/p>\n<\/td>\n

\\n<\/tr>\n

“;
\n\t}
\n}
\n# First of all the default is to show the form
\n$ccdb_ShowForm = “Yes”;
\n# Now get all the data – and, if appropriate, push it into the database
\n$ccdb_addlist = $_REQUEST[‘addlist’];
\n$ccdb_submitsupporter = $_REQUEST[‘submitsupporter’];
\nif(!empty($ccdb_addlist) or !empty($ccdb_submitsupporter)) {
\n\tif (!empty($ccdb_addlist)) {
\n\t\t$answers[’email’] = trim(strip_tags(stripslashes($_REQUEST[‘listemail’])));
\n\t\t$answers[‘mobile’] = trim(strip_tags(stripslashes($_REQUEST[‘listmobile’])));
\n\t\t$answers[‘getmail’] = $_REQUEST[‘listsendnews’];
\n\t\tif ($answers[’email’] == “Your email address”) {$answers[’email’]=””;}
\n\t\tif ($answers[‘mobile’] == “Your mobile number”) {$answers[‘mobile’]=””;}
\n\t\t$tempanswers = $answers;
\n\t\tif (!empty($answers[’email’]) or !empty($answers[‘mobile’])) {
\n\t\t\tunset($ccdb_joiner);
\n\t\t\t$ccdb_query = “INSERT INTO ccdb_supporters SET timestamp = now(),”;
\n\t\t\tforeach ($tempanswers as $ccdb_variable => $ccdb_result)
\n\t\t\t{
\n\t\t\t\t$ccdb_query .= $ccdb_joiner.”$ccdb_variable='”.addslashes($ccdb_result).”‘”;
\n\t\t\t\t$ccdb_joiner=”,”;
\n\t\t\t}
\n\t\t\t# echo $ccdb_query;
\n\t\t\t$ccdb_topmessage = “<\/p>\n

Thank you for signing up to news. If you would like to pledge your support to Ming, please fill in the form below.<\/p>\n

“;
\n\t\t\t$ccdb_result = mysql_query($ccdb_query);
\n\t\t}
\n\t} else {
\n\t\t$ccdb_helpofferresponse = $_REQUEST[‘helpoffer’];
\n\t\tunset($ccdb_helpofferstring);
\n\t\tif(!empty($ccdb_helpofferresponse)) {
\n\t\t\tforeach ($ccdb_helpofferresponse as $ccdb_helpnum => $ccdb_helpresponse) {
\n\t\t\t\t$ccdb_helpofferstring .= $ccdb_helpnum.”-“;
\n\t\t\t}
\n\t\t}
\n\t\t$ccdb_WantedVariables=array(“firstname”,”surname”,”email”,”mobile”,”homephone”,”address1″,”address2″,”address3″,”postcode”,”stateorregion”,”localparty”,”membership”,”getmail”);
\n\t\tempty($ccdb_joiner);
\n\t\t$ccdb_query = “INSERT INTO ccdb_supporters SET timestamp = now(), helpnumrecords=’$ccdb_helpofferstring’, “;
\n\t\tforeach ($ccdb_WantedVariables as $ccdb_variable)
\n\t\t{
\n\t\t\t$answers[$ccdb_variable] = trim(strip_tags(stripslashes($_REQUEST[$ccdb_variable])));
\n\t\t\t$ccdb_query .= $ccdb_joiner.”$ccdb_variable='”.addslashes($answers[$ccdb_variable]).”‘”;
\n\t\t\t$ccdb_joiner=”,”;
\n\t\t}
\n\t\t# echo $ccdb_query;
\n\t\t$ccdb_checkstring = $answers[’email’].$answers[‘mobile’].$answers[‘address1’].$answers[‘homephone’];
\n\t\tif (empty($ccdb_checkstring)) {
\n\t\t\t$ccdb_topmessage = “<\/p>\n

Please can you provide some more information.<\/p>\n

“;
\n\t\t} else {
\n\t\t\t$ccdb_topmessage = “<\/p>\n

Thank you for registering your support.<\/p>\n

“;
\n\t\t\t$ccdb_result = mysql_query($ccdb_query);
\n\t\t}<\/p>\n

\t}
\n}
\n# if ($ccbd_ShowForm == “Yes”) {
\n\/* Now display the form *\/
\necho $ccdb_topmessage;
\necho “<\/p>\n

I support Ming Campbell’s campaign<\/h3>\n

“;
\necho ‘<\/p>\n

\n‘;
\n$questions = array(
\n\t“firstname” => “First name”,
\n\t“surname” => “Surname”,
\n\t“email” => “Email address”,
\n\t“mobile” => “Mobile phone*”,
\n\t“homephone” => “Home phone*”,
\n\t“membership” => “Lib Dem membership number*”,
\n\t“address1” => “Address*”,
\n\t“address2” => “”,
\n\t“address3” => “”,
\n\t“postcode” => “Postcode*”
\n);
\nputquestionsinrows($questions,$answers);
\n# State or region…
\necho “<\/p>\n\\n<\/p>\n\\n<\/p>\n\\n<\/p>\n
State or region<\/td>\n
Local party<\/td>\n
Would you like to receive news from the campaign via text or email?<\/td>\n

\\n<\/p>\n

<\/td>\n<\/tr>\n

“;<\/p>\n

# Reminder:
\necho “<\/table>\n

\\n* Optional<\/small>\\n<\/p>\n

I want to help Ming’s campaign<\/h3>\n

\\n<\/p>\n“;
\n# And now the help questions
\n$ccdb_query = “SELECT * FROM ccdb_help ORDER BY helpsort,helpdesc”;
\n$ccdb_result = mysql_query($ccdb_query) or die(“Can’t run queries”);
\nwhile ($ccdb_row = mysql_fetch_array($ccdb_result)) {
\n\t\t\textract($ccdb_row,EXTR_PREFIX_ALL,”ccdb”);
\n\t\t\techo “<\/p>\n\\n<\/p>\n
$ccdb_helpdesc<\/td>\n

\\n<\/p>\n

<\/td>\n<\/tr>\n

“;
\n}
\necho ‘<\/table>\n