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 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 $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 = "select * from DiveSitePOI order by DiveSiteId";
$result = mysql_query($sql, $connection) or die("ERROR!! DiveSitePOI InitializeProgram failure");
$NumDiveSitePOIRecords = mysql_num_rows($result);
if ($NumDiveSitePOIRecords == 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 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 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;
}
