/** * * 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); } }