Unable to connect to the " . "database server at this time.

" ); exit(); } // Select the database if (! @mysql_select_db("$DBname") ) { echo( "

Unable to locate the DataBase at this time.

" ); exit(); } //Get Default Display $query1 = "SELECT * FROM SUGGEST_PLACE_VISIT ORDER BY RAND(NOW()) LIMIT 1"; $result1 = MYSQL_QUERY($query1); $row1 = mysql_fetch_array($result1); $ARTNR1 = $row1['ARTNR']; if (empty($article_number)) { $article_number = "$ARTNR1"; $random_display = "You arrived at this page without selecting a destination.
The Below is only a random selection for you. If you would like to select a specific destination to view go here: "; } else { $article_number = "$article_number"; $random_display = ""; } //Get Slected Display $result = mysql_query ("SELECT * FROM SUGGEST_PLACE_VISIT where ARTNR ='$article_number' "); if ($myrow = mysql_fetch_array($result)) { do { $ARTNR = $myrow['ARTNR']; $DisplayPLACE = $myrow['PLACE']; $KEYWORDS = $myrow['KEYWORDS']; $URL = $myrow['URL']; $TOP_CATEGORY_NAME = $myrow['TOP_CATEGORY_NAME']; $CATEGORY_NAME = $myrow['CATEGORY_NAME']; $CITY = $myrow['CITY']; $STATE = $myrow['STATE']; $WHEN_YEAR = $myrow['WHEN_YEAR']; $WHEN_MONTH = $myrow['WHEN_MONTH']; $WHEN_DAY = $myrow['WHEN_DAY']; $REASON = $myrow['REASON']; $BY_NAME = $myrow['BY_NAME']; $EMAIL = $myrow['EMAIL']; $SHOW_NAME = $myrow['SHOW_NAME']; $ADMIN_COMMENTS = $myrow['ADMIN_COMMENTS']; $DONE = $myrow['DONE']; $DONE_WHEN = $myrow['DONE_WHEN']; $DONE_RATING = $myrow['DONE_RATING']; $DONE_COMMENTS = $myrow['DONE_COMMENTS']; $DONE_PICTURES = $myrow['DONE_PICTURES']; $BEEN_BEFORE = $myrow['BEEN_BEFORE']; $BEEN_WHEN = $myrow['BEEN_WHEN']; $BEEN_COMMENTS = $myrow['BEEN_COMMENTS']; $PAGE_VIEWS = $myrow['PAGE_VIEWS']; } while($myrow = mysql_fetch_array($result)); } else {print "Sorry, their name is not in the database!";} $ARTNR = stripslashes($ARTNR); $DisplayPLACE = stripslashes($DisplayPLACE); $KEYWORDS = stripslashes($KEYWORDS); $URL = stripslashes($URL); $TOP_CATEGORY_NAME = stripslashes($TOP_CATEGORY_NAME); $CATEGORY_NAME = stripslashes($CATEGORY_NAME); $CITY = stripslashes($CITY); $STATE = stripslashes($STATE); $WHEN_YEAR = stripslashes($WHEN_YEAR); $WHEN_MONTH = stripslashes($WHEN_MONTH); $WHEN_DAY = stripslashes($WHEN_DAY); $REASON = stripslashes($REASON); $BY_NAME = stripslashes($BY_NAME); $EMAIL = stripslashes($EMAIL); $SHOW_NAME = stripslashes($SHOW_NAME); $ADMIN_COMMENTS = stripslashes($ADMIN_COMMENTS); $DONE = stripslashes($DONE); $DONE_WHEN = stripslashes($DONE_WHEN); $DONE_RATING = stripslashes($DONE_RATING); $DONE_COMMENTS = stripslashes($DONE_COMMENTS); $DONE_PICTURES = stripslashes($DONE_PICTURES); $BEEN_BEFORE = stripslashes($BEEN_BEFORE); $BEEN_WHEN = stripslashes($BEEN_WHEN ); $BEEN_COMMENTS = stripslashes($BEEN_COMMENTS); $REASON = nl2br($REASON); $ADMIN_COMMENTS = nl2br($ADMIN_COMMENTS); $DONE = nl2br($DONE); $DONE_WHEN = nl2br($DONE_WHEN); $DONE_RATING = nl2br($DONE_RATING); $DONE_COMMENTS = nl2br($DONE_COMMENTS); $DONE_PICTURES = nl2br($DONE_PICTURES); $BEEN_BEFORE = nl2br($BEEN_BEFORE); $BEEN_WHEN = nl2br($BEEN_WHEN ); $BEEN_COMMENTS = nl2br($BEEN_COMMENTS); // // /* Test Code echo"
refer = $refer
"; */ // // $WhatReplaceThisField_in = "$DisplayPLACE";//Replace SESearch_Replace with the array element to look through for highlight //This is so data is inserted into DB only 1 time $SEInsertDB = "No"; //include("$DOCUMENT_ROOT/inc/SESearchInfo.php"); //$DisplayPLACE = "$WhatReplaceThisField_out"; $WhatReplaceThisField_out =""; // // $REASON = stripslashes("$REASON"); // /* Comment Block $WhatReplaceThisField_in = "$REASON";//Replace SESearch_Replace with the array element to look through for highlight //This is so data is inserted into DB only 1 time $SEInsertDB = "No"; include("$DOCUMENT_ROOT/inc/SESearchInfo.php"); $REASON = "$WhatReplaceThisField_out"; $WhatReplaceThisField_out =""; // */ // /* Comment Block //Show SE Search explanation in web page $ReplaceThisField = "$ShowReplaceThisField";//Replace SESearch_Replace with the array element to look through for highlight ob_start(); include("$DOCUMENT_ROOT/$Blog_Location/inc/ShowSESearchInfo.php"); $SEShowDisplay = ob_get_contents(); ob_end_clean(); */ // // //Next SESearch highlight field // $KeyWordIncrement = "No";//Set this for second and subsequent field being checked $DONE_COMMENTS = stripslashes("$DONE_COMMENTS"); // /* Comment Block $WhatReplaceThisField_in = "$DONE_COMMENTS";//Replace SESearch_Replace with the array element to look through for highlight //This is so data is inserted into DB only 1 time $SEInsertDB = "No"; include("$DOCUMENT_ROOT/inc/SESearchInfo.php"); $DONE_COMMENTS = "$WhatReplaceThisField_out"; $WhatReplaceThisField_out =""; */ // // // // // // //Next SESearch highlight field // $KeyWordIncrement = "No";//Set this for second and subsequent field being checked $BEEN_COMMENTS = stripslashes("$BEEN_COMMENTS"); // /* Comment Block $WhatReplaceThisField_in = "$BEEN_COMMENTS";//Replace SESearch_Replace with the array element to look through for highlight //This is so data is inserted into DB only 1 time $SEInsertDB = "Yes"; include("$DOCUMENT_ROOT/inc/SESearchInfo.php"); $BEEN_COMMENTS = "$WhatReplaceThisField_out"; $WhatReplaceThisField_out =""; */ // // // // // if ($SHOW_NAME == "No") { $DISPLAY_NAME = "Anonymous"; } if ($BY_NAME == "Ray Plumlee" AND $DONE != "yes") { $DISPLAY_NAME = "The Traveling Webmaster added $DisplayPLACE as I already intend to visit."; } elseif ($BY_NAME == "Ray Plumlee" AND $DONE == "yes") { $DISPLAY_NAME = "The Traveling Webmaster added $DisplayPLACE as I had intended to visit all along."; } else { $DISPLAY_NAME = "$BY_NAME"; } if ($WHEN_YEAR != "0" and $WHEN_MONTH != "0" and $WHEN_DAY != "0") { $WHEN_DISPLAY = "$WHEN_DAY $WHEN_MONTH $WHEN_YEAR"; } elseif ($WHEN_YEAR == "0" and $WHEN_MONTH != "0" and $WHEN_DAY != "0") { $WHEN_DISPLAY = "Any year: $WHEN_DAY $WHEN_MONTH"; } elseif ($WHEN_YEAR == "0" and $WHEN_MONTH != "0" and $WHEN_DAY == "0") { $WHEN_DISPLAY = "Any Year: $WHEN_MONTH"; } elseif ($WHEN_YEAR != "0" and $WHEN_MONTH != "0" and $WHEN_DAY == "0") { $WHEN_DISPLAY = "$WHEN_YEAR: $WHEN_MONTH"; } elseif ($WHEN_YEAR == "0" and $WHEN_MONTH = "0" and $WHEN_DAY == "0") { $WHEN_DISPLAY = "Any Time"; } else { $WHEN_DISPLAY = "Any Time"; } if ($DONE == "yes") { $DISPLAY_DONE = "yes"; } elseif ($DONE == "") { $DISPLAY_DONE = "No"; } else { $DISPLAY_DONE = "$DONE_WHEN"; } // This page configuration // if ($DONE == "yes") { $ptitle = "$DisplayPLACE which is Located in or near $CITY, $STATE was visted by the Traveling Webmaster on $DONE_WHEN. Pictures of the visit are available."; $ptitle_short = "$DisplayPLACE
Was Visited by the Traveling Webmaster on $DONE_WHEN.
Pictures Were Taken And Are Included Below."; $page_description = "$DisplayPLACE which is Located in or near $CITY, $STATE was visted $DONE_WHEN where pictures were taken by"; } else { $ptitle = "$DisplayPLACE is Located in or near $CITY, $STATE and was a suggested place to visit"; $ptitle_short = "$DisplayPLACE is a Suggested Place for the Traveling Webmaster to Visit."; $page_description = "$DisplayPLACE is located in or near $CITY, $STATE and has been recommended as a place to visit to"; } $filename = "community/view_where/index.html"; $topic = "where"; $page_keywords="photo,picture,visit,travel,place,where,locate"; // //Does a Comments exist for this destination? $PLACE_querry = str_replace("'", "", "$DisplayPLACE"); $querysearch = "select * from destination_reviews where destination_name = '$PLACE_querry' AND show_review = 'Yes'"; $resultsearch = MYSQL_QUERY($querysearch); $numbersearchComments = mysql_Numrows($resultsearch); $number_display = "50"; $title_font_size ="-1"; $base_font = "-2"; include("$DOCUMENT_ROOT/$SiteStyle/inc/header.inc.php"); ?>

Number of visitor comments for :
0) { ?> Click Here to view Visitor Comments.

Would you like to make comments for ? If so &article_number=">click here:

">Contact Ray about

$SEShowDisplay
"; } ?>

Back to Where to go list: $DisplayShowWhatReplaceThisField_out "; ?> ">Destination :
Web Address :      Yes : Click Here to Visit "; } else { } ?>

">Category :       /

">Location :      ">City :      ">State :

">When :

">Reason to Visit :

">Submitted By :

">Visted Yet During This Adventure? :
Ray Plumlee's Rating :      $DONE_RATING Stars out of 5.

When Visited :      $DONE_WHEN

Ray Plumlee's Comments :
$DONE_COMMENTS
$DONE_PICTURES "; } else { echo"      No.   The Traveling Webmaster has not yet visited, $DisplayPLACE during this current adventure, but once I do, I will be sure and tell you all about it. I will provide a rating and my recommendation whether you should schedule $DisplayPLACE in your next vacation plan. "; } if ($BEEN_BEFORE == "yes" AND $DONE == "yes") { echo "

And I have been to $DisplayPLACE before in $BEEN_WHEN. "; } else { } if ($BEEN_BEFORE == "yes" AND $DONE != "yes") { echo "

But I have been to $DisplayPLACE before in $BEEN_WHEN. "; } else { } if (!empty($ADMIN_COMMENTS)) { echo"

Traveling Webmasters Comments :      $ADMIN_COMMENTS"; } else { } if ($BEEN_BEFORE == "yes") { echo "

Traveling Webmasters Comments about his previous visit in $BEEN_WHEN. :
$BEEN_COMMENTS "; } else { echo""; } //Include List Comments file if ($numbersearchComments>0) { //Include List Comments file include("$DOCUMENT_ROOT/community/view_where/comments/comments.html"); }//End if comments exist //Else there is no Comments file else { ?>

There are no visitor comments for . Would you like to provide comments for ? If so &article_number=">click here:

Back to Where to go list:

">Contact Ray about

Unable to connect to the " . "database server at this time.
" ); exit(); } // Select the database if (! @mysql_select_db("$DBname") ) { echo( "
Unable to locate the DataBase at this time.
" ); exit(); } $NEW_PAGE_VIEWS = ++$PAGE_VIEWS; if ($NEW_PAGE_VIEWS != "$PAGE_VIEWS + 1") { $NEW_PAGE_VIEWS = "$PAGE_VIEWS"; $mailheaders = "From: Have Web Sites Will Travel \n"; $mailheaders .= "Reply-To: notifyme@plumlee.net\n"; $msg = "The following Place had a counter error\n\n"; $msg .= "Place: $DisplayPLACE\n"; $msg .= "Last Count: $PAGE_VIEWS\n"; $msg .= "New Count: $NEW_PAGE_VIEWS\n"; $msg .= "\n"; mail("notify@plumlee.net", "Failed Counter Update 1", $msg, $mailheaders); } else { $NEW_PAGE_VIEWS = "$NEW_PAGE_VIEWS"; } $query = "UPDATE `SUGGEST_PLACE_VISIT` SET `PAGE_VIEWS` = '$NEW_PAGE_VIEWS' WHERE `ARTNR` = '$article_number'"; $NEW_PAGE_VIEWS = number_format($NEW_PAGE_VIEWS); $PAGE_VIEWS = number_format($PAGE_VIEWS); if(!mysql_query($query)) { $mailheaders = "From: Have Web Sites Will Travel \n"; $mailheaders .= "Reply-To: notifyme@plumlee.net\n"; $msg = "The following Place had a counter MySQL Insert error\n\n"; $msg .= "Place: $DisplayPLACE\n"; $msg .= "Last Count: $PAGE_VIEWS\n"; $msg .= "New Count: $NEW_PAGE_VIEWS\n"; $msg .= "\n"; mail("notifyme@plumlee.net", "Failed Counter Update 2", "$msg", "$mailheaders"); } else { echo "$DisplayPLACE has been viewed: ( $NEW_PAGE_VIEWS ) times."; } ?>