function GetSelectBoxRecords()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteFacilitiesRecordsDesired, $DiveSiteFacilitiesId, $DiveSiteFacilitiesRank, $DiveSiteFacilitiesDescription;
global $DesiredRecord;
global $DiveSiteFacilitiesIdArray, $DiveSiteFacilitiesRankArray, $DiveSiteFacilitiesDescriptionArray;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
# $sql="select * from DiveSiteFacilities where(DiveSiteFacilitiesId = '".strip_tags(addslashes($DesiredRecord))."') order by DiveSiteFacilitiesId";
$sql = "select DiveSiteFacilitiesId,DiveSiteFacilitiesRank,DiveSiteFacilitiesDescription from DiveSiteFacilities order by DiveSiteFacilitiesRank";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteFacilities Select * failure");
$NumDiveSiteFacilitiesRecordsDesired = mysql_num_rows($result);
mysql_close($connection);
for ($i = 0; $i < $NumDiveSiteFacilitiesRecordsDesired; $i++) {
$rowdata = mysql_fetch_row($result);
$DiveSiteFacilitiesIdArray[] = $rowdata[0];
$DiveSiteFacilitiesRankArray[] = $rowdata[1];
$DiveSiteFacilitiesDescriptionArray[] = $rowdata[2];
}
PutVariablesIntoSession();
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteMedicalRecords, $DiveSiteMedicalId, $DiveSiteMedicalRank, $DiveSiteMedicalDescription;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "select * from DiveSiteMedical order by DiveSiteMedicalRank";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteMedical InitializeProgram failure");
$NumDiveSiteMedicalRecords = mysql_num_rows($result);
if ($NumDiveSiteMedicalRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function Db_Add()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSitePOIRecords, $DiveSitePOIId, $DiveSiteId, $DiveSitePOIEnteredBy, $DiveSitePOIDateEntered;
global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName;
global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSitePOITitle, $DiveSitePOIType;
global $DiveSitePOILat, $DiveSitePOILong, $DiveSitePOINoteKeywords, $DiveSitePOINotes, $DiveSitePOIPictureURLFileInfo;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to divesites database');
$sql = "insert into DiveSitePOI(DiveSiteId,DiveSitePOIEnteredBy,DiveSitePOIDateEntered,DiveSiteCity,DiveSiteProvince,DiveSiteCountry,DiveSiteName,DiveSiteMajorName,DiveSiteMinorName,DiveSiteExactLat,DiveSiteExactLong,DiveSitePOITitle,DiveSitePOIType,DiveSitePOILat,DiveSitePOILong,DiveSitePOINoteKeywords,DiveSitePOINotes,DiveSitePOIPictureURLFileInfo) values (";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteId)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIEnteredBy)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIDateEntered)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteCity)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteProvince)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteCountry)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteName)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteMajorName)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteMinorName)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLat)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLong)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOITitle)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIType)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOILat)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOILong)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOINoteKeywords)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOINotes)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIPictureURLFileInfo)) . "')";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSitePOI ADD failure");
$DiveSitePOIId = mysql_insert_id($connection);
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password;
global $NumDiveSiteRecords, $DiveSiteId, $DiveSiteStatus, $DiveSiteEnteredBy, $DiveSiteDateEntered;
global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName;
global $DiveSiteMinorName, $DiveSiteRating, $DiveSiteType, $DiveSiteLevel, $DiveSiteElevation;
global $DiveSiteElevationUnits, $DiveSiteWater, $DiveSiteDifficulty, $DiveSiteTideTable, $DiveSiteTideTableNotes;
global $DiveSiteBestDiveMonths, $DiveSiteTimeRestrictions, $DiveSitePermitRequired, $DiveSiteWinterTemp;
global $DiveSiteSummerTemp, $DiveSiteFallTemp, $DiveSiteSpringTemp, $DiveSiteDepthMin, $DiveSiteDepthMax;
global $DiveSiteDepthUnits, $DiveSiteVisibilityMinimum, $DiveSiteVisibilityMaximum, $DiveSiteVisibilityUnits;
global $DiveSiteHazards, $DiveSiteHazardNotes, $DiveSiteBottomComposition, $DiveSiteCompositionNotes;
global $DiveSiteTelephoneNotes, $DiveSiteFacilities, $DiveSiteFacilitiesNotes, $DiveSiteMedical;
global $DiveSiteMedicalNotes, $DiveSiteRecommendationNotes, $DiveSiteEAPNotes, $DiveSiteNotes;
global $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteShoreLat, $DiveSiteShoreLong, $DiveSiteShoreNotes;
global $DiveSiteWebPage, $DiveSiteBackground;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "select * from DiveSite order by DiveSiteStatus";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSite InitializeProgram failure");
$NumDiveSiteRecords = mysql_num_rows($result);
if ($NumDiveSiteRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteVideoRecords, $DiveSiteVideoId, $DiveSiteId, $DiveSiteVideoDateEntered, $DiveSiteCity;
global $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName, $DiveSiteMinorName;
global $DiveSiteDifficulty, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteVideoTitle, $DiveSiteVideoType;
global $DiveSiteVideoNoteKeywords, $DiveSiteVideoURLFileInfo, $DiveSiteVideoNotes;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "select * from DiveSiteVideo order by DiveSiteId";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteVideo InitializeProgram failure");
$NumDiveSiteVideoRecords = mysql_num_rows($result);
if ($NumDiveSiteVideoRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteMarineLifeRecords, $DiveSiteMarineLifeId, $DiveSiteId, $DiveSiteMarineLifeEnteredBy;
global $DiveSiteMarineLifeDateEntered, $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName;
global $DiveSiteMajorName, $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteMarineLifeDomain;
global $DiveSiteMarineLifeKingdom, $DiveSiteMarineLifePhylum, $DiveSiteMarineLifeClass, $DiveSiteMarineLifeSubClass;
global $DiveSiteMarineLifeInfraClass, $DiveSiteMarineLifeOrder, $DiveSiteMarineLifeFamily;
global $DiveSiteMarineLifeGenus, $DiveSiteMarineLifeSpecies, $DiveSiteMarineLifeCommonName;
global $DiveSiteMarineLifeScientificName, $DiveSiteMarineLifePictureURLFileInfo1, $DiveSiteMarineLifePictureURLFileInfo2;
global $DiveSiteMarineLifePictureURLFileInfo3, $DiveSiteMarineLifePictureURLFileInfo4, $DiveSiteMarineLifePictureURLFileInfo5;
global $DiveSiteMarineLifeNotes;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "select * from DiveSiteMarineLife order by DiveSiteId";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteMarineLife InitializeProgram failure");
$NumDiveSiteMarineLifeRecords = mysql_num_rows($result);
if ($NumDiveSiteMarineLifeRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function Db_Add()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSitePixRecords, $DiveSitePixId, $DiveSiteId, $DiveSitePixEnteredBy, $DiveSitePixDateEntered;
global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName;
global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSitePixTitle, $DIveSitePixType;
global $DiveSitePixNoteKeywords, $DiveSitePixPictureURLFileInfo, $DiveSitePixNotes;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "insert into DiveSitePix(DiveSiteId,DiveSitePixEnteredBy,DiveSitePixDateEntered,DiveSiteCity,DiveSiteProvince,DiveSiteCountry,DiveSiteName,DiveSiteMajorName,DiveSiteMinorName,DiveSiteExactLat,DiveSiteExactLong,DiveSitePixTitle,DIveSitePixType,DiveSitePixNoteKeywords,DiveSitePixPictureURLFileInfo,DiveSitePixNotes) values (";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteId)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePixEnteredBy)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePixDateEntered)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteCity)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteProvince)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteCountry)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteName)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteMajorName)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteMinorName)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLat)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLong)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePixTitle)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DIveSitePixType)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePixNoteKeywords)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePixPictureURLFileInfo)) . "',";
$sql = $sql . "'" . strip_tags(addslashes($DiveSitePixNotes)) . "')";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSitePix ADD failure");
#-------------------- record has been added
$DiveSitePixId = mysql_insert_id($connection);
mysql_close($connection);
#$DiveSitePixId='9999'; # fake id to test
#------------ now to move the file with the name properly set ---------------------------------
#echo('Pix ID is: '.$DiveSitePixId.'<br>');
#echo('Pix File name: '.$DiveSitePixURLFileInfo.'<br>');
$target_dir = "DiveSiteImages/";
$target_name = $DiveSiteName . '_' . str_pad($DiveSitePixId, 8, '0', STR_PAD_LEFT);
#echo('target name is: '.$target_name.'<br>');
$target_file = $target_dir . basename($_FILES["DiveSitePixPictureURLFileInfo"]["name"]);
#echo('target file is: '.$target_file.'<br>');
$uploadOk = 1;
$imageFileType = pathinfo($target_file, PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if (isset($_POST["submit"])) {
$check = getimagesize($_FILES["DiveSitePixPictureURLFileInfo"]["tmp_name"]);
if ($check !== false) {
# echo "File is an image - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
# echo "File is not an image.";
$uploadOk = 0;
}
}
// Check if file already exists
if (file_exists($target_file)) {
# echo "Sorry, file already exists.";
$uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 10000000) {
# echo "Sorry, your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif" && $imageFileType != "JPG" && $imageFileType != "PNG" && $imageFileType != "JPEG" && $imageFileType != "GIF") {
# echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
echo "Sorry, your file was not uploaded.";
exit;
// if everything is ok, try to upload file
} else {
$target_file = $target_dir . $target_name . '.' . $imageFileType;
$target_file = preg_replace('/\\s+/', '_', $target_file);
if (move_uploaded_file($_FILES["DiveSitePixPictureURLFileInfo"]["tmp_name"], $target_file)) {
# echo "The file ". basename( $_FILES["DiveSitePixPictureURLFileInfo"]["name"]). " has been uploaded as ".$target_file;
} else {
echo "Sorry, there was an error uploading your file.";
exit;
}
}
$DiveSitePixPictureURLFileInfo = $target_file;
PutVariablesIntoSession();
Db_Update();
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteReviewRecords, $DiveSiteReviewId, $DiveSiteId, $DiveSiteReviewReviewerLevel;
global $DiveSiteReviewDateEntered, $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName;
global $DiveSiteMajorName, $DiveSiteMinorName, $DiveSiteReviewRating, $DiveSiteReviewTemp, $DiveSiteReviewVisibility;
global $DiveSiteReviewNotes, $DiveSiteReviewPix1URLFileInfo, $DiveSiteReviewPix1Note, $DiveSiteReviewPix2URLFileInfo;
global $DiveSiteReviewPix2Note, $DiveSiteReviewPix3URLFileInfo, $DiveSiteReviewPix3Note, $DiveSiteReviewPix4URLFileInfo;
global $DiveSiteReviewPix4Note, $DiveSiteExactLat, $DiveSiteExactLong;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "select * from DiveSiteReview order by DiveSiteId";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteReview InitializeProgram failure");
$NumDiveSiteReviewRecords = mysql_num_rows($result);
if ($NumDiveSiteReviewRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function Db_Update()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteCoursesRecords, $DiveSiteCourse, $DiveSiteId, $DiveSiteCourseEnteredBy, $DiveSiteCourseDateEntered;
global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName;
global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteCourseTitle, $DiveSiteCourseNoteKeywords;
global $DiveSiteCourseWhyNotes, $DiveSiteCourseURLFileInfo;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to divesites database');
$DiveSiteCourse = $_SESSION['DiveSiteCourse'];
$sql = "update DiveSiteCourses SET ";
$sql = $sql . "DiveSiteId='" . strip_tags(addslashes($DiveSiteId)) . "',";
$sql = $sql . "DiveSiteCourseEnteredBy='" . strip_tags(addslashes($DiveSiteCourseEnteredBy)) . "',";
$sql = $sql . "DiveSiteCourseDateEntered='" . strip_tags(addslashes($DiveSiteCourseDateEntered)) . "',";
$sql = $sql . "DiveSiteCity='" . strip_tags(addslashes($DiveSiteCity)) . "',";
$sql = $sql . "DiveSiteProvince='" . strip_tags(addslashes($DiveSiteProvince)) . "',";
$sql = $sql . "DiveSiteCountry='" . strip_tags(addslashes($DiveSiteCountry)) . "',";
$sql = $sql . "DiveSiteName='" . strip_tags(addslashes($DiveSiteName)) . "',";
$sql = $sql . "DiveSiteMajorName='" . strip_tags(addslashes($DiveSiteMajorName)) . "',";
$sql = $sql . "DiveSiteMinorName='" . strip_tags(addslashes($DiveSiteMinorName)) . "',";
$sql = $sql . "DiveSiteExactLat='" . strip_tags(addslashes($DiveSiteExactLat)) . "',";
$sql = $sql . "DiveSiteExactLong='" . strip_tags(addslashes($DiveSiteExactLong)) . "',";
$sql = $sql . "DiveSiteCourseTitle='" . strip_tags(addslashes($DiveSiteCourseTitle)) . "',";
$sql = $sql . "DiveSiteCourseNoteKeywords='" . strip_tags(addslashes($DiveSiteCourseNoteKeywords)) . "',";
$sql = $sql . "DiveSiteCourseWhyNotes='" . strip_tags(addslashes($DiveSiteCourseWhyNotes)) . "',";
$sql = $sql . "DiveSiteCourseURLFileInfo='" . strip_tags(addslashes($DiveSiteCourseURLFileInfo)) . "' where DiveSiteCourse='" . $DiveSiteCourse . "'";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteCourses DATA failure");
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSupportRecords, $DiveSupportId, $DiveSupportStatus, $DiveSupportType, $DiveSupportName;
global $DiveSupportAddress1, $DiveSupportAddress2, $DiveSupportCity, $DiveSupportProvince, $DiveSupportCountry;
global $DiveSupportPhone1, $DiveSupportPhone1Type, $DiveSupportPhone2, $DiveSupportPhone2Type;
global $DiveSupportPhone3, $DiveSupportPhone3Type, $DiveSupportWebsite, $DiveSupportEmail, $DiveSupportExactLat;
global $DiveSupportExactLong, $DiveSupportHoursMon, $DiveSupportHoursTues, $DiveSupportHoursWed;
global $DiveSupportHoursThu, $DiveSupportHoursFri, $DiveSupportHoursSat, $DiveSupportHoursSun;
global $DiveSupportServices, $DiveSupportSuppliersNote, $DiveSupportNotes, $DiveSupportPaidDate, $DiveSupportPCZip;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to divesites database');
$sql = "select * from DiveSupport order by DiveSupportStatus";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSupport InitializeProgram failure");
$NumDiveSupportRecords = mysql_num_rows($result);
if ($NumDiveSupportRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
function InitializeProgram()
{
global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry;
global $NumDiveSiteEAPRecords, $DiveSiteEAPId, $DiveSiteId, $DiveSiteEAPEnteredBy, $DiveSiteEAPDateEntered;
global $DiveSiteEAPCity, $DiveSiteEAPProvince, $DiveSiteEAPCountry, $DiveSiteName, $DiveSiteMajorName;
global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteEAPMedical, $DiveSiteEAPRecompression;
global $DiveSiteEAPContact1, $DiveSiteEAPContact2, $DiveSiteEAPTravelNotes;
$connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql');
$rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database');
$sql = "select * from DiveSiteEAP order by DiveSiteId";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteEAP InitializeProgram failure");
$NumDiveSiteEAPRecords = mysql_num_rows($result);
if ($NumDiveSiteEAPRecords == 0) {
InitializeVariables();
} else {
GetLastRecord($connection, $result);
}
PutVariablesIntoSession();
mysql_close($connection);
return;
}
