| What was the primary factor you considered in determining your score? |
|
|
$line
\n";
}
// Error
if ($found_record != "1") {
$err = "
Sorry, the reservation code entered was not valid or the survey has already been completed.
";
include "error.php";
include "footer.inc.php";
die;
}
}
// submit survey
if ($_POST['start'] == "2") {
foreach ($_POST as $k=>$value) {
$_POST[$k] = @mysql_real_escape_string($value);
}
// Insert survey results
switch ($_POST['fleet']) {
case "AF":
$db = "reserve";
$sql = "
SELECT
`WWM_survey_codes`.*,
`boats`.`name`
FROM $db.`WWM_survey_codes`,$db.`boats`
WHERE
`WWM_survey_codes`.`inventoryID` = '$_POST[code]'
AND `WWM_survey_codes`.`submitted` IS NULL
AND `WWM_survey_codes`.`boatID` = `boats`.`boatID`
";
$result = mysql_query("$sql", $af);
for ($x=0; $x < mysql_num_rows($result); $x++) {
$row = mysql_fetch_assoc($result);
$contactID = $row['passengerID'];
}
// check for duplicate
$sql2 = "SELECT `inventoryID` FROM $db.`WWM_survey_results` WHERE `inventoryID` = '$_POST[code]'";
$result2 = mysql_query($sql2,$af);
for ($x2=0; $x2 < mysql_num_rows($result2); $x2++) {
$row2 = mysql_fetch_assoc($result2);
$found = "1";
}
if ($found == "1") {
print "
You have already completed the survey.
";
die;
}
// My Aggressor Points - 10/30/2016 - RBS
$today = date("Ymd");
$sql7 = "INSERT INTO `$db`.`points_earned_log` (`contactID`,`points_earned`,`date`,`event_details`) VALUES
('$contactID','100','$today','Completed Survey')";
$result7 = mysql_query("$sql7", $af);
$sql8 = "SELECT `points` FROM `$db`.`contacts` WHERE `contactID` = '$contactID'";
$result8 = mysql_query("$sql8",$af);
for ($x8=0; $x8 < mysql_num_rows($result8); $x8++) {
$row8 = mysql_fetch_assoc($result8);
$points = $row8['points'] + 100;
$sql9 = "UPDATE `$db`.`contacts` SET `points` = '$points' WHERE `contactID` = '$contactID'";
$result9 = mysql_query("$sql9",$af);
}
// end points
print_r($row);
// Insert
$sql = "
INSERT INTO $db.`WWM_survey_results` (
`inventoryID`,`boatID`,`start_date`,`end_date`,
`ans_1`,`ans_3`,`ans_4a`,`ans_4b`,`ans_5`,`ans_6`,`ans_7`,`ans_8`,`ans_9`,`ans_10`,`ans_11`,`ans_12`,`ans_gift`,`ans_15`,
`ans_16`,`ans_17`,`ans_18`,`ans_19`,`ans_20`,`ans_21`,`ans_22`,`ans_23`,`ans_24`
)
VALUES (
'$_POST[code]','$row[boatID]','$row[start_date]','$row[end_date]',
'$_POST[q2]','$_POST[q9]','$_POST[q11a]','$_POST[q11b]','$_POST[q7a]','$_POST[q7b]','$_POST[q7c]','$_POST[q7d]','$_POST[q8]','$_POST[company]','$_POST[q4]','$_POST[q5]','$_POST[donate]','$_POST[q14]',
'$_POST[q15]','$_POST[q10a]','$_POST[q10b]','$_POST[q6]','$_POST[q1]','$_POST[q4b]','$_POST[q22]','$_POST[q16]','$_POST[q17]'
)
";
// die($sql);
$result2 = mysql_query("$sql", $af);
if ($result2 == "TRUE") {
for ($r=0; $r < 30; $r++) {
$i = "q12a_";
$i .= $r;
$mag[$r] = $_POST[$i];
}
for ($r=0; $r < 30; $r++) {
$i = "q13a_";
$i .= $r;
$site[$r] = $_POST[$i];
}
$sql3 = "
INSERT INTO $db.`WWM_survey_publications` (
`inventoryID`,`boatID`,`start_date`,`end_date`,
`mag_1`,`mag_2`,`mag_3`,`mag_4`,`mag_5`,`mag_6`,`mag_8`,`mag_9`,`mag_10`,`mag_11`,`mag_13`,`mag_14`,`mag_15`,`mag_16`,`mag_17`,`mag_18`,`mag_19`,`mag_20`,`mag_21`,`mag_22`,`mag_23`,
`mag_other`,
`site_1`,`site_2`,`site_3`,`site_4`,`site_5`,`site_6`,`site_7`,`site_8`,`site_9`,`site_10`,`site_11`,`site_12`,`site_13`,`site_14`,`site_15`,`site_16`,`site_17`,
`site_other`
)
VALUES (
'$_POST[code]','$row[boatID]','$row[start_date]','$row[end_date]',
'$mag[0]','$mag[1]','$mag[2]','$mag[3]','$mag[4]','$mag[5]','$mag[6]','$mag[7]','$mag[8]','$mag[9]','$mag[10]','$mag[11]','$mag[12]','$mag[13]','$mag[14]','$mag[15]','$mag[16]','$mag[17]','$mag[18]',
'$mag[19]','$mag[20]',
'$_POST[q12b]',
'$site[0]','$site[1]','$site[2]','$site[3]','$site[4]','$site[5]','$site[6]','$site[7]','$site[8]','$site[9]','$site[10]','$site[11]','$site[12]','$site[13]','$site[14]','$site[15]','$site[16]',
'$_POST[q13b]'
)
";
$result3 = mysql_query("$sql3", $af);
$submitted = date("Ymd");
$result4 = mysql_query("UPDATE $db.`WWM_survey_codes` SET `submitted` = '$submitted' WHERE `inventoryID` = '$_POST[code]'", $af);
print "";
//include "thankyou.php";
} else {
$err = "
There was an error saving your survey results. Please email info@aggressor.com.
\n";
include "error.php";
}
break;
case "DF":
$db = "peterhughes";
$sql = "
SELECT
`survey_codes`.*,
`vessels`.`vessel` AS 'name'
FROM $db.`survey_codes`, $db.`vessels`
WHERE
`survey_codes`.`inventoryID` = '$_POST[code]'
AND `survey_codes`.`submitted` IS NULL
AND `survey_codes`.`boatID` = `vessels`.`vessel_id`
";
$result = mysql_query("$sql", $df);
for ($x=0; $x < mysql_num_rows($result); $x++) {
$row = mysql_fetch_assoc($result);
}
$sql2 = "
INSERT INTO $db.`survey_results` (
`inventoryID`,`boatID`,`start_date`,`end_date`,
`ans_1`,`ans_3`,`ans_4a`,`ans_4b`,`ans_5`,`ans_6`,`ans_7`,`ans_8`,`ans_9`,`ans_10`,`ans_11`,`ans_12`,`ans_gift`,`ans_15`,`ans_16`,`ans_17`,`ans_18`,`ans_19`,`ans_20`,`ans_21`)
VALUES (
'$_POST[code]','$row[boatID]','$row[start_date]','$row[end_date]',
'$_POST[q2]','$_POST[q9]','$_POST[q11a]','$_POST[q11b]','$_POST[q7a]','$_POST[q7b]','$_POST[q7c]','$_POST[q7d]','$_POST[q8]','$row[company]','$_POST[q4]','$_POST[q5]','$_POST[donate]','$_POST[q14]',
'$_POST[q15]','$_POST[q10a]','$_POST[q10b]','$_POST[q6]','$_POST[q1]','$_POST[q4b]'
)
";
die($sql2);
$result2 = mysql_query("$sql2", $df);
if ($result2 == "TRUE") {
for ($r=0; $r < 11; $r++) {
$i = "q12a_";
$i .= $r;
$mag[$r] = $_POST[$i];
}
for ($r=0; $r < 7; $r++) {
$i = "q13a_";
$i .= $r;
$site[$r] = $_POST[$i];
}
$sql3 = "
INSERT INTO $db.`survey_publications` (
`inventoryID`,`boatID`,`start_date`,`end_date`,
`mag_1`,`mag_2`,`mag_3`,`mag_4`,`mag_5`,`mag_6`,`mag_8`,`mag_9`,`mag_10`,`mag_11`,`mag_12`,`mag_other`,
`site_1`,`site_2`,`site_3`,`site_4`,`site_5`,`site_6`,`site_7`,`site_other`
)
VALUES (
'$_POST[code]','$row[boatID]','$row[start_date]','$row[end_date]',
'$mag[0]','$mag[1]','$mag[2]','$mag[3]','$mag[4]','$mag[5]','$mag[6]','$mag[7]','$mag[8]','$mag[9]','$mag[10]','$_POST[q12b]',
'$site[0]','$site[1]','$site[2]','$site[3]','$site[4]','$site[5]','$site[6]','$_POST[q13b]'
)
";
$result3 = mysql_query("$sql3", $df);
$submitted = date("Ymd");
$result4 = mysql_query("UPDATE $db.`survey_codes` SET `submitted` = '$submitted' WHERE `inventoryID` = '$_POST[code]'", $df);
include "thankyou.php";
} else {
$err = "
There was an error saving your survey results. Please email robert@wayneworks.com.
\n";
include "error.php";
}
break;
default:
$err = "
Sorry, I was unable to determin what cruize line you traveled with. Please email robert@wayneworks.com
";
include "error.php";
include "footer.inc.php";
die;
}
die;
}
include "footer.inc.php";
die;
?>
| |