/**
*
* Retrieves a list of Facebook comments
* from the Comments Plugin
*
* @param string $ids
* @return array
*/
function GetFBComments($ids)
{
$query = "SELECT comments FROM Comments WHERE category_id=1";
$result = mysql_query($query) or die(minor_error(191, $fbme, $uid, $today, $query, mysql_error()));
$row1 = mysql_fetch_array($result, MYSQL_ASSOC);
$content = stripslashes($row1['comments']);
$comments = json_decode($content);
$comments = $comments->{$ids}->data;
return $comments;
}
$url_result = mysql_query($url_sql) or die(minor_error(218, $user, $user, $today, $url_sql, mysql_error()));
$url_row = mysql_fetch_array($url_result, MYSQL_ASSOC);
if ($row[price] == 0) {
$price = "FREE";
} else {
if (!$row[pricing_model]) {
$price = "\$" . $row[price] . " / job";
} else {
if ($row[pricing_model]) {
$price = "\$" . $row[price] . " / hour";
}
}
}
// Extract pictures for the listing
$lnglat_sql = "SELECT * FROM Listing_Location WHERE listing_id=" . $row[listing_id];
$lnglat_result = mysql_query($lnglat_sql) or die(minor_error(217, $user, $user, $today, $picture_sql, mysql_error()));
$lnglat_row = mysql_fetch_array($lnglat_result, MYSQL_ASSOC);
if ($lnglat_row[listing_location] == 0) {
$lnglat_sql = "SELECT * FROM User_Address WHERE fb_uid=" . $row[fb_uid];
$lnglat_result = mysql_query($lnglat_sql) or die(fatal_error(260, $user, $user, $today, $sql, mysql_error()));
$lnglat_row = mysql_fetch_array($lnglat_result, MYSQL_ASSOC);
echo "{\tname: '<div class=\"map_cont\"> <a class=\"map_popup_link\" title=\"" . $row[title] . "\" href=\"" . $working_directory . "service/" . $row[listing_id] . "/\">" . "<img class=\"map_popup_img\" src=\"" . $domain_secondary . "resizer.php?src=" . $domain_secondary . "service_pictures/" . $url_row[URL] . "&h=100&w=120&zc=1\"" . "height=\"100px\"/><p class=\"map_service_title\">" . $row[title] . "</p></a><p>" . $price . "</p></div>', " . "lat: " . $lnglat_row[lat] . "," . "lng: " . $lnglat_row[lng] . "},";
} else {
if ($lnglat_row[listing_location] == 2) {
echo "{\tname: '<div class=\"map_cont\"> <a class=\"map_popup_link\" title=\"" . $row[title] . "\" href=\"" . $working_directory . "service/" . $row[listing_id] . "/\">" . "<img class=\"map_popup_img\" src=\"" . $domain_secondary . "resizer.php?src=" . $domain_secondary . "service_pictures/" . $url_row[URL] . "&h=100&w=120&zc=1\"" . "height=\"100px\"/><p class=\"map_service_title\">" . $row[title] . "</p></a><p>" . $price . "</p></div>', " . "lat: " . $lnglat_row[lat] . "," . "lng: " . $lnglat_row[lng] . "},";
}
}
}
?>
];
function GetFBComments($ids)
{
// Extract category info from Category_Lookup table
$query = "SELECT comments FROM Comments WHERE category_id='" . -$_GET['lid'] . "'";
$result = mysql_query($query) or die(minor_error(191, $fbme, $uid, $today, $query, mysql_error()));
$row1 = mysql_fetch_array($result, MYSQL_ASSOC);
$content = $row1['comments'];
$comments = json_decode($content);
$comments = $comments->{$ids}->data;
return $comments;
}
echo $user_first_name;
?>
's Services </div>
<?php
while ($other_listing_row = mysql_fetch_array($other_listing_result)) {
?>
<?php
extract($other_listing_row);
// Add a thumbnail picture for each service
// Extract pictures for the listing
$picture_sql = "SELECT picture_id_1 FROM Listing_Pictures WHERE listing_id='{$listing_id}'";
$picture_result = mysql_query($picture_sql) or die(minor_error(3, $user, $user, $today, $picture_sql, mysql_error()));
$picture_row = mysql_fetch_array($picture_result, MYSQL_ASSOC);
extract($picture_row);
$url_sql = "SELECT URL FROM Pictures_Lookup WHERE pictures_id='{$picture_id_1}'";
$url_result = mysql_query($url_sql) or die(minor_error(4, $user, $user, $today, $url_sql, mysql_error()));
$url_row = mysql_fetch_array($url_result, MYSQL_ASSOC);
extract($url_row);
?>
<div class='indv_service'>
<a href='<?php
echo $working_directory . "service/" . $listing_id . "/";
?>
'>
<?php
if ($URL == "hoodylogo.jpg") {
?>
<img class='service_pic' src='<?php
echo $domain_secondary;
<url>
<loc>http://gohoody.com/about-us/</loc>
<changefreq>weekly</changefreq>
<priority>1</priority>
</url>
<url>
<loc>http://gohoody.com/search.php</loc>
<changefreq>always</changefreq>
</url>
<url>
<loc>http://gohoody.com/service/</loc>
<changefreq>always</changefreq>
</url>';
//Services
$service_query = "SELECT listing_id FROM Listing_Overview WHERE status=1";
$result = mysql_query($service_query) or die(minor_error(215, $fbme, $uid, $today, $query, mysql_error()));
$num_rows = mysql_num_rows($result);
//loop through the entire resultset
for ($i = 0; $i < $num_rows; $i++) {
$row = mysql_fetch_array($result, MYSQL_ASSOC);
//you can assign whatever changefreq and priority you like
echo '
<url>
<loc>http://gohoody.com/service/' . $row['listing_id'] . '/</loc>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>
';
}
//Profiles
$user_lookup_sql = "SELECT profile_name FROM User_Lookup";
?>
<!--contact seller in general-->
<?php
if ($action == 1 && $lid == 0) {
?>
<div id='regarding'> Regarding: </div>
<select id='topic_selector' name="lid">
<option value="0">General Question</option>
<?php
// Get data for seller's other listings
$query = "SELECT listing_id,title FROM Listing_Overview WHERE fb_uid={$fb_uid}&&status=1 ORDER BY listing_id";
$other_listing_result = mysql_query($query) or die(minor_error(53, $user, $user, $today, $name_lookup_sql, mysql_error()));
$other_listing_num = mysql_num_rows($other_listing_result);
?>
<?php
if ($other_listing_num > 0) {
?>
<?php
while ($other_listing_row = mysql_fetch_array($other_listing_result)) {
?>
<option value="<?php
echo $other_listing_row[listing_id];
?>
" ><?php
echo $other_listing_row[title];
?>
</option>
if ((BrowserDetect.browser != 'Chrome') && (BrowserDetect.browser != 'Firefox') && (BrowserDetect.browser != 'Opera') && (BrowserDetect.browser != 'Safari') && (BrowserDetect.browser != 'Explorer')) {
if (BrowserDetect.version < 11) {
document.write('<div id="broswer_warning">Sorry, your broswer is not supported by Hoody. Please use the latest IE, Firefox, Chrome, Safari, or Opera.</div> <div id="gap"> </div>');
}
}
</script>
<?php
include "html/title_bar_new2.inc";
?>
<div id="content">
<?php
$query = "SELECT * FROM QR_Code_Tracking ORDER BY id";
$result = mysql_query($query) or die(minor_error(102, $user, $user, $today, $query, mysql_error()));
$result_num = mysql_num_rows($result);
if ($result_num > 0) {
?>
<table width="940" border="1">
<tr>
<th width=40% scope="col"><div align="center">Description</div></th>
<th width=30% scope="col"><div align="center">Destination</div></th>
<th width=15% scope="col"><div align="center">Medium</div></th>
<th width=15% scope="col"><div align="center">Visit</div></th>
</tr>
<?php
while ($result_row = mysql_fetch_array($result)) {
extract($result_row);
if ($medium == 1) {
$medium = "Bookmarks";
break;
//Update address - area code
//Update address - area code
case 11:
$value = filter_var($value, FILTER_SANITIZE_STRING);
$address_sql = "SELECT city,state,country,area_code,street FROM User_Address WHERE fb_uid='{$id}'";
$result = mysql_query($address_sql) or die(minor_error(199, $fbme, $uid, $today, $address_sql, mysql_error()));
$row1 = mysql_fetch_array($result, MYSQL_ASSOC);
$database_country = $row1['country'];
$lnglat = geocoding(NULL, NULL, NULL, $database_country, $value);
$lng = $lnglat["lng"];
$lat = $lnglat["lat"];
$address_sql = "UPDATE User_Address SET street='',state='',city='',area_code='{$value}',lng='{$lng}',lat='{$lat}' WHERE fb_uid='{$id}'";
$address_result = mysql_query($address_sql) or die(minor_error(200, $fbme, $uid, $today, $address_sql, mysql_error()));
echo $value;
break;
//cases for flyer.php updates - description
//cases for flyer.php updates - description
case 12:
$query = "UPDATE Listing_Overview SET flyer_description='" . $_POST['value'] . "' WHERE listing_id='{$id}'";
$result = mysql_query($query) or die(minor_error(201, $fbme, $uid, $today, $query, mysql_error()));
echo $_POST['value'];
break;
//cases for flyer.php updates - about me
//cases for flyer.php updates - about me
case 13:
$query = "UPDATE Basic_User_Information SET flyer_about_me='" . $_POST['value'] . "' WHERE fb_uid='{$id}'";
$result = mysql_query($query) or die(minor_error(202, $fbme, $uid, $today, $query, mysql_error()));
echo $_POST['value'];
break;
}
/**
* Retrieves a list of Facebook comments
* from the Comments Plugin
*
* @param string $ids
* @return array
*/
function GetFBComments($ids)
{
// Extract category info from Category_Lookup table
$url_lookup_sql = "SELECT * FROM Category_Lookup WHERE category_url='" . $_GET['url'] . "'";
$result = mysql_query($url_lookup_sql) or die(fatal_error(1, $user, $user, $today, $name_lookup_sql, mysql_error()));
$row4 = mysql_fetch_array($result, MYSQL_ASSOC);
$category_id = $row4['category_id'];
$query = "SELECT comments FROM Comments WHERE category_id='{$category_id}'";
$result = mysql_query($query) or die(minor_error(191, $fbme, $uid, $today, $query, mysql_error()));
$row1 = mysql_fetch_array($result, MYSQL_ASSOC);
$content = $row1['comments'];
$comments = json_decode($content);
$comments = $comments->{$ids}->data;
return $comments;
}
function geocoding($street, $city, $state, $country, $area_code)
{
define("MAPS_HOST", "maps.google.com");
define("KEY", "ABQIAAAArXO6baEuLJHexd0PRnGkCxROoN0XQGx9kWs_TtpEPHPn1-MT3hTUJBft68uSqie8WGV1_AJLqlVFbg");
// Initialize delay in geocode speed
$delay = 0;
$base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&key=" . KEY;
// Iterate through the rows, geocoding each address
$geocode_pending = true;
while ($geocode_pending) {
$address = $street . ", " . $city . ", " . $state . ", " . $area_code . ", " . $country;
$request_url = $base_url . "&q=" . urlencode($address);
$xml = simplexml_load_file($request_url) or die(minor_error(189, $user, $user, $today, $request_url, mysql_error()));
$status = $xml->Response->Status->code;
$output = array();
if (strcmp($status, "200") == 0) {
// Successful geocode
$geocode_pending = false;
$coordinates = $xml->Response->Placemark->Point->coordinates;
$coordinatesSplit = split(",", $coordinates);
// Format: Longitude, Latitude, Altitude
$output["lat"] = mysql_real_escape_string($coordinatesSplit[1]);
$output["lng"] = mysql_real_escape_string($coordinatesSplit[0]);
return $output;
} else {
if (strcmp($status, "620") == 0) {
// sent geocodes too fast
$delay += 100000;
} else {
// failure to geocode
$geocode_pending = false;
//echo "Address " . $address . " failed to geocoded. ";
//echo "Received status " . $status . "\n";
echo "There seems to be something wrong with the address you provided, please try again.";
}
}
usleep($delay);
}
}
