"; } $placement++; } $start = $start + 10; } if ($found == 0) { $query = "INSERT INTO 06_google_monitor_results (`query`, `placement`, `timestamp`) VALUES ('$searchQuery', '" . $placement * 10 . "', null)"; } $message .= checkResults($searchQuery, $allowance); } function checkResults($searchQuery, $allowance) { $query = "SELECT placement FROM 06_google_monitor_results WHERE `query` = '$searchQuery' ORDER BY timestamp DESC LIMIT 2"; echo $query . "
"; $recentResults = getAssoc($query, 2); $thisRun = $recentResults[0]['placement']; $lastRun = $recentResults[1]['placement']; if ($thisRun == $lastRun) { return ""; }else if (($thisRun - $lastRun) > $allowance) { echo "WARNING ranking for $searchQuery has dropped from $lastRun to $thisRun
\n"; return "WARNING ranking for $searchQuery has dropped from $lastRun to $thisRun\n"; }else if (($lastRun - $thisRun) > $allowance) { echo "Good News! Ranking for $searchQuery has increased from $lastRun to $thisRun
\n"; return "Good News! Ranking for $searchQuery has increased from $lastRun to $thisRun\n"; }else { return ""; } } function runGoogleSearch($client, $searchQuery, $start) { echo "called"; $query = array( 'key'=>'u6U/r39QFHK18Qcjz/XdWSbptVaj9k1t', 'q'=>$searchQuery, 'start'=>$start, 'maxResults'=>10, 'filter'=>true, 'restrict'=>'', 'safeSearch'=>true, 'lr'=>'', 'ie'=>'', 'oe'=>'' ); $result = $client->call("doGoogleSearch", $query, "urn:GoogleSearch", "urn:GoogleSearch"); return $result; } ?>