"; } else { $wid=$oa*8; $scolorbar = ""; } return $scolorbar; } // ************************************************************************** function Color3($oa,$scolorbar) { if ($oa <= 5){ $wid=$oa*16; $scolorbar = ""; $boxbor = "Red"; } elseif ($oa <= 7 AND $oa > 5){ $wid=$oa*16; $scolorbar = ""; $boxbor = "Blue"; } else { $wid=$oa*16; $scolorbar = ""; $boxbor = "Green"; } $colorbar = array("colorbar"=>$scolorbar, "boxbor"=>$boxbor); return $colorbar; } // ************************************************************************** function Color4($oa,$scolorbar) { if ($oa <= 5){ $wid=$oa*8; $scolorbar = ""; $boxbor = "Red"; } elseif ($oa <= 7 AND $oa > 5){ $wid=$oa*8; $scolorbar = ""; $boxbor = "Blue"; } else { $wid=$oa*8; $scolorbar = ""; $boxbor = "Green"; } $colorbar = array("colorbar"=>$scolorbar, "boxbor"=>$boxbor); return $colorbar; } // *************************************************************************** $h_r1 = '0'; $h_r2 = '0'; $h_r3 = '0'; $h_r4 = '0'; $h_r5 = '0'; mysql_pconnect("qs99.pair.com", "a2zlv_18_r", "ufyYQ69Z") or die("Unable to connect to Datebase - Please try again in a few minutes"); mysql_select_db("a2zlv_a2z") or die("Unable to select database"); // $result = mysql_query("SELECT * FROM all_restaurants WHERE r_id = '627'"); $result = mysql_query("SELECT * FROM all_restaurants WHERE r_id = '$r_id'"); /* echo mysql_errno().": ".mysql_error()."
"; */ $r_id = mysql_result($result,0,"r_id"); $id = mysql_result($result,0,"r_id"); $r_name = mysql_result($result,0,"r_name"); $r_address = mysql_result($result,0,"r_address"); $r_city = mysql_result($result,0,"r_city"); $r_zip = mysql_result($result,0,"r_zip"); $r_type = mysql_result($result,0,"r_type"); $r_type2 = mysql_result($result,0,"r_type2"); $r_about = mysql_result($result,0,"r_about"); $r_hours = mysql_result($result,0,"r_hours"); $r_phone = mysql_result($result,0,"r_phone"); $r_lon = mysql_result($result,0,"r_lon"); $r_lat = mysql_result($result,0,"r_lat"); $r_notes = mysql_result($result,0,"r_notes"); $r_location = mysql_result($result,0,"r_location"); $r_hotel = mysql_result($result,0,"r_hotel"); $r_fax = mysql_result($result,0,"r_fax"); $r_web = mysql_result($result,$counter,"r_web"); echo "\n"; echo ""; echo "\n"; echo "$r_name $r_hotel - $r_city - earlier reviews and ratings"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo "
\n"; /* echo mysql_errno().": ".mysql_error()."
"; */ $result = mysql_query("SELECT * FROM r_comments WHERE id = '$id' ORDER BY added DESC "); /* echo mysql_errno().": ".mysql_error()."<------
"; */ $total_rows = mysql_numrows($result); echo "
"; include "/usr/www/users/a2zlv/ieatvegas/ads/iev120x60tl.txt"; echo ""; include "/usr/www/users/a2zlv/ieatvegas/ads/iev728x90ros.txt"; echo ""; include "/usr/www/users/a2zlv/ieatvegas/ads/iev120x60tr.txt"; echo "
"; echo "
\"space\"
\n"; echo ""; echo "\n"; echo "\r"; echo "\r"; echo "\r"; echo "\n"; echo ""; echo "
 "; include "/usr/www/users/a2zlv/ieatvegas/2linehead.inc"; echo "
\"space\"
"; echo ""; echo ""; echo ""; echo ""; echo "
 
"; echo "
"; include "/usr/www/users/a2zlv/ieatvegas/search_box.html"; include "/usr/www/users/a2zlv/ieatvegas/left_menu.html"; echo "

"; include "/usr/www/users/a2zlv/ieatvegas/ads/ievtextlink.txt"; echo "

"; include "/usr/www/users/a2zlv/ieatvegas/ads/iev160x600ros.txt"; if ($total_rows > 3) { echo "


"; include "/usr/www/users/a2zlv/ieatvegas/ads/iev160x600b.txt"; echo "

"; }; include "/usr/www/users/a2zlv/ieatvegas/ads/iev120x60lt.txt"; echo "

 "; echo "
\n"; echo ""; echo "
"; /* =========================================================== */ echo "
Earlier comments about\n"; echo "
$r_name\n"; echo "
(Sorted by month of visit, latest month first.)\n"; echo "
If you have eaten at $r_name, please\n"; echo "ADD "; echo "your own comment.
"; echo "
\n"; $result9 = mysql_query("SELECT * FROM icons WHERE category = 'restaurants'"); $h_icon1 = mysql_result($result9,0,"icon1"); $h_icon2 = mysql_result($result9,0,"icon2"); $h_icon3 = mysql_result($result9,0,"icon3"); $h_icon4 = mysql_result($result9,0,"icon4"); $h_icon5 = mysql_result($result9,0,"icon5"); $h_icon6 = mysql_result($result9,0,"icon6"); $h_icon7 = mysql_result($result9,0,"icon7"); $h_icon8 = mysql_result($result9,0,"icon8"); $result = mysql_query("SELECT * FROM r_comments WHERE id = '$id' ORDER By vdate DESC LIMIT 10,50"); $total_rows = mysql_numrows($result); $counter = 0; if ($total_rows == 0): echo "

No Earlier Comments at this time




\n"; else: while($counter < $total_rows): $rc_added = mysql_result($result,$counter,"added"); $rc_extra = mysql_result($result,$counter,"extra"); $rc_rating = mysql_result($result,$counter,"rating"); $rc_vdate = mysql_result($result,$counter,"vdate"); $rc_comment = mysql_result($result,$counter,"comment"); $rc_name = mysql_result($result,$counter,"name"); $rc_from = mysql_result($result,$counter,"city"); $rc_email = mysql_result($result,$counter,"email"); $rc_ip = mysql_result($result,$counter,"ip"); $r1 = mysql_result($result,$counter,"r1"); $r2 = mysql_result($result,$counter,"r2"); $r3 = mysql_result($result,$counter,"r3"); $r4 = mysql_result($result,$counter,"r4"); $r5 = mysql_result($result,$counter,"r5"); $rc_location = mysql_result($result,$counter,"location"); $r_again = mysql_result($result,$counter,"again"); $r_kids = mysql_result($result,$counter,"kids"); $r = mysql_result($result,$counter,"R"); $c = mysql_result($result,$counter,"C"); $icon1 = mysql_result($result,$counter,"icon1"); $icon2 = mysql_result($result,$counter,"icon2"); $icon3 = mysql_result($result,$counter,"icon3"); $icon4 = mysql_result($result,$counter,"icon4"); $icon5 = mysql_result($result,$counter,"icon5"); $icon6 = mysql_result($result,$counter,"icon6"); $icon7 = mysql_result($result,$counter,"icon7"); $icon8 = mysql_result($result,$counter,"icon8"); $c_index = mysql_result($result,$counter,"c_index"); $or=($r1 + $r2 + $r3 + $r4 + $r5)/5; $ay=substr($rc_added,2,2); $am=substr($rc_added,5,2); $ad=substr($rc_added,8,2); $added=$am."/".$ad."/".$ay; $vy=substr($rc_vdate,2,2); $vm=substr($rc_vdate,5,2); $visit= $vm."/".$vy; $rc_ip = substr("$rc_ip", 0, -3); $rc_ip = "$rc_ip"."***"; $uname = ereg_replace ("@", " ", $rc_email); $pieces = explode(" ", $uname); $rc_email = ereg_replace ("@", " -at- ", $rc_email); echo "
$rc_location             
\n"; echo "
"; if ($icon1 == 'on'){echo "      ";} if ($icon2 == 'on'){echo "      ";} if ($icon3 == 'on'){echo "      ";} if ($icon4 == 'on'){echo "      ";} if ($icon5 == 'on'){echo "      ";} if ($icon6 == 'on'){echo "      ";} if ($icon7 == 'on'){echo "      ";} if ($icon8 == 'on'){echo "";} $or=substr($or,0,5); if($r_again == "yes"){ $raagain = ""; } elseif($r_again == 'no'){ $raagain = ""; } else { $raagain = ""; }; if($r_kids == "yes"){ $rakids = ""; } elseif($r_kids == 'no'){ $rakids = ""; } else { $rakids = ""; }; echo "
Month Visited: $visit\n"; switch($rc_rating) { case "Good Meal"; echo " - Good Meal\n"; break; case "Bad Meal"; echo " - Bad Meal\n"; break; case "Undecided"; echo " - Undecided\n"; break; } echo " - $rc_extra"; if ($c != "Y"): echo "
This person rated this restaurant but left no comment.\n"; else: $rc_comment = nl2br($rc_comment); echo "

$rc_comment\n"; endif; $oacl = "#009933"; //green if ($or <= 5){$oacl = "#CC0033";}; //red echo "   $c_index
\n"; echo "

    "; echo ""; echo "
"; // echo "
This User's Overall Rating $or
"; echo "
"; $user=substr($pieces[0],0,10); echo "
$user's
    Overall Rating
"; echo "
$or
"; echo "
"; $colorbar = Color4($r1,$ncolorbar); $r1 = substr($r1,0,4); $cb1 = $colorbar['colorbar']; $boxbor1 = $colorbar['boxbor']; echo "
Ambiance: $r1 
"; echo "
"; echo "$cb1"; echo "

"; $r2 = substr($r2,0,4); $colorbar = Color4($r2,$scolorbar); $cb2 = $colorbar['colorbar']; $boxbor2 = $colorbar['boxbor']; echo "
Service: $r2 
"; echo "
"; echo "$cb2"; echo "

"; $r3 = substr($r3,0,4); $colorbar = Color4($r3,$scolorbar); $cb3 = $colorbar['colorbar']; $boxbor3 = $colorbar['boxbor']; echo "
Food: $r3 
"; echo "
"; echo "$cb3"; echo "

"; $r4 = substr($r4,0,4); $colorbar = Color4($r4,$scolorbar); $cb4 = $colorbar['colorbar']; $boxbor4 = $colorbar['boxbor']; echo "
Value: $r4 
"; echo "
"; echo "$cb4"; echo "

"; $r5 = substr($r5,0,4); $colorbar = Color4($r5,$scolorbar); $cb5 = $colorbar['colorbar']; $boxbor5 = $colorbar['boxbor']; echo "
Access: $r5 
"; echo "
"; echo "$cb5"; echo "

"; echo "
Would Eat Here Again: 
"; echo "
"; echo "$raagain"; echo "

\n"; echo "
Is Family Friendly: 
"; echo "
"; echo "$rakids"; echo "

\n"; echo "
"; echo "$rc_name <$rc_email>
"; echo "From: $rc_from
"; echo "Added: $added \n"; echo "[$rc_ip]
\n"; echo "
"; echo "
"; echo "
"; $counter = $counter + 1; endwhile; endif; /* =========================================================== */ echo "
\n"; echo "Comment Disclaimer: No attempt has been made to verify or assure the accuracy of the above comments.
"; echo "You must judge the truthfulness of any comment and accept responsibility for your use of this information."; echo "

\n"; echo "Last Updated: ".date( "F d Y H:i:s."); echo "

"; echo "$r_name

\n"; echo "If you have eaten at $r_name,
please "; echo "ADD "; echo "a rating and/or comment!
"; echo "

"; echo "
"; echo "
"; include "/usr/www/users/a2zlv/ieatvegas/ads/table_foot1020.inc"; echo "

"; echo ""; ?>