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; }