function getReviews($d, $sku) { //echo "getReviews: " . $sku . "\n"; global $r, $revs; $reviews = $d->find('#product-reviews-list > li.review'); if (count($reviews) > 0) { $revs[$sku] += count($reviews); foreach ($reviews as $rev) { $data = array($sku, trim($rev->find('span[property=name]', 0)->innertext), round($rev->find('meta[property=ratingValue]', 0)->content / 20, 1), trim($rev->find('span[property=author]', 0)->innertext), "", trim($rev->find('meta[property=datePublished]', 0)->content, "on "), trim($rev->find('div.review-text', 0)->innertext)); fputcsv($r, $data); } } if (!is_null($d->find('a.i-next', 0))) { $newurl = $d->find('a.i-next', 0)->href; //echo "Another page of reviews found: " . $newurl . "\n"; $d->load(scraperwiki::scrape($newurl)); getReviews($d, $sku); } else { echo "Saved " . $revs[$sku] . " reviews for sku: " . $sku . ".\n"; } }
function assignCommonListlinksVar(&$savant, &$links, &$pathWay, &$pageNav) { global $task, $Itemid, $my, $cat_id, $mtconf; $database =& JFactory::getDBO(); require_once $mtconf->getjconf('absolute_path') . '/administrator/components/com_mtree/mfields.class.php'; # Load custom fields' caption if ($task == 'advsearch') { $database->setQuery("SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS value, field_type FROM #__mt_customfields WHERE published = 1 AND advanced_search = 1"); $custom_fields = $database->loadObjectList("name"); } else { $database->setQuery("SELECT CONCAT( 'cust_', cf_id ) AS name, caption AS value, field_type FROM #__mt_customfields"); $custom_fields = $database->loadObjectList("name"); } $fields = array(); $arrayLinkId = array(); if (count($links) > 0) { foreach ($links as $link) { $arrayLinkId[] = intval($link->link_id); } } $tmp_fields = array(); $tmp_core_fields = array(); if (count($arrayLinkId) > 0) { $sql = "SELECT cf.*, cfv.link_id, cfv.value, cfv.attachment, cfv.counter, ft.ft_class FROM #__mt_customfields AS cf " . "\nLEFT JOIN #__mt_cfvalues AS cfv ON cf.cf_id=cfv.cf_id " . "\nLEFT JOIN #__mt_fieldtypes AS ft ON ft.field_type=cf.field_type" . "\nWHERE cf.published = '1' AND cf.summary_view = '1' " . "\nAND cfv.link_id IN (" . implode(',', $arrayLinkId) . ") " . "\nORDER BY cf.ordering ASC, link_id DESC"; $database->setQuery($sql); $tmp_fields = $database->loadObjectList(); $sql_core = "SELECT cf. * , NULL AS link_id, '' AS value, NULL AS attachment, ft.ft_class " . "\nFROM #__mt_customfields AS cf " . "\nLEFT JOIN #__mt_fieldtypes AS ft ON ft.field_type=cf.field_type " . "\nWHERE cf.published = '1' " . "\nAND cf.summary_view = '1' " . "\nAND cf.iscore = '1' " . "\nORDER BY cf.ordering ASC"; $database->setQuery($sql_core); $tmp_core_fields = $database->loadObjectList(); } if (count($arrayLinkId) > 0 && (count($tmp_core_fields) > 0 || count($tmp_fields) > 0)) { $tmp_fields = array_merge($tmp_fields, $tmp_core_fields); } // Custom fields that do not require value, appear only once with a NULL value to link_id. // This loop clone the custom fields for each link foreach ($tmp_fields as $key => $value) { if (is_null($value->link_id)) { foreach ($arrayLinkId as $linkId) { $tmp_value = $value; $tmp_value = PHP_VERSION < 5 ? $value : clone $value; $tmp_value->link_id = $linkId; $tmp_fields[] = $tmp_value; unset($tmp_value); } } } usort($tmp_fields, "customFieldsSort"); if (count($links) > 0) { foreach ($links as $link) { $tmp_link_id = $link->link_id; $fields[$link->link_id] = new mFields(); $data = null; $i = 0; foreach ($tmp_fields as $key => $value) { if ($value->link_id == $tmp_link_id) { $data[$key * 28] = $value; unset($tmp_fields[$key]); } $i++; } $fields[$link->link_id]->setCoresValue($link->link_name, $link->link_desc, $link->address, $link->city, $link->state, $link->country, $link->postcode, $link->telephone, $link->fax, $link->email, $link->website, $link->price, $link->link_hits, $link->link_votes, $link->link_rating, $link->link_featured, $link->link_created, $link->link_modified, $link->link_visited, $link->publish_up, $link->publish_down, $link->metakey, $link->metadesc, $link->user_id, $link->username); $fields[$link->link_id]->loadFields($data); } } # Mambots if ($mtconf->get('cat_parse_plugin')) { applyMambots($links); } assignCommonVar($savant); $savant->assignRef('pathway', $pathWay); $savant->assign('pageNav', $pageNav); $savant->assignRef('links', $links); $savant->assignRef('fields', $fields); $savant->assign('reviews', getReviews($links)); $savant->assign('min_votes_to_show_rating', $mtconf->get('min_votes_to_show_rating')); $savant->assign('custom_fields', $custom_fields); $savant->assign('listing_image_dir', $mtconf->getjconf('live_site') . $mtconf->get('listing_image_dir')); $savant->assign('cat_id', $cat_id); return true; }
purchaseOrder(); } if ($function == "add_coupon") { addCoupon(); } if ($function == "get_order") { getOrder(); } if ($function == "get_orders") { getOrders(); } if ($function == "add_review") { addReview(); } if ($function == "get_reviews") { getReviews(); } if ($function == "check_employee") { checkEmployee(); } if ($function == "register_employee") { registerEmployee(); } if ($function == "get_managed_employees") { getManagedEmployees(); } if ($function == "get_employee_username") { getEmployeeUsername(); } if ($function == "get_warehouses") { getWarehouses();
if ($i == $gutachtennr) { print " selected"; } print ">{$i}</option>\n"; } print "</select>" . "<p><input type=\"submit\" name=\"submitButtonName\" value=\"Gutachten zeigen\"></p>\n" . "</form>"; } else { echo "<p>Es liegen noch keine Gutachten vor!</p>"; } if (!ereg("^[0-9]*\$", $autor)) { print "<p>Bitte die Matrikelnr. des Autors angeben!</p>"; } if ($gutachtennr > 0) { if (0 < $nr && $nr <= $gutachtennr) { $query = "SELECT dokument, anmerkung, punkte, validiert, zusatzpunkte FROM dokumente WHERE autor = '{$autor}' AND aufgabenr='{$nr}'"; getReviews($query); } else { echo "<p>Finger weg vom Formular!</p>"; } } function getReviews($query) { global $con; global $nr; global $autor; $rs = mysql_query($query); if (!$rs) { print "<p>Datenbank-Fehler. Bitte erneut versuchen</p>"; } elseif (mysql_num_rows($rs) > 0) { $rs_array = mysql_fetch_row($rs); $dokument = $rs_array[0];
include "connection.php"; ini_set('display_errors', 'On'); error_reporting(E_ALL | E_STRICT); //determine the which query to form $query_func = $_REQUEST['q']; switch ($query_func) { case 'post_review': $reviewer = $_COOKIE['userID']; $driver = $_REQUEST['driver']; $content = $_REQUEST['content']; $rating = $_REQUEST['rating']; echo postReview($driver, $reviewer, $content, $rating); break; case 'get_reviews': $driver = $_REQUEST['driver']; echo getReviews($driver); break; case 'get_user_recent_trips': $userID = $_COOKIE['userID']; $trips = getUserRecentTrips($userID); echo $trips; break; case 'search': $words = $_REQUEST['words']; echo searchALL($words); break; case 'start_following': $sessionUser = $_COOKIE['userID']; $profileUser = $_REQUEST['profileUser']; startFollowing($profileUser, $sessionUser); break;