/** * Updates PageRank and inlink count for the Page. * * @return null */ public function update_statistics() { $db = DB::connect(); $pagerank = Google::get_pagerank($this->url); $db->exec("INSERT INTO page_data VALUES({$this->id}, '0', NOW(), {$pagerank})"); $inlink_count = Yahoo::get_inlink_count(array('query' => $this->url)); $db->exec("INSERT INTO page_data VALUES({$this->id}, '1', NOW(), {$inlink_count})"); }
/** * Updates statistics for the site domain. * * @return null */ public function update_statistics() { $pagerank = Google::get_pagerank($this->domain); DB::connect()->exec("UPDATE site SET pagerank = '{$pagerank}' WHERE id = '{$this->id}' LIMIT 1"); $this->update_keyword_rankings(); }
private function site_create_from_sitemap() { $db = DB::connect(); $domain = parse_url($_POST['url'], PHP_URL_HOST); if (!Site::exists($domain)) { $pagerank = Google::get_pagerank($domain); $db->exec("INSERT INTO site VALUES('', '{$domain}', '{$pagerank}')"); } if (!($xml = simplexml_load_file($_POST['url']))) { trigger_error('Unable to load sitemap at ' . $_POST['url'], E_USER_ERROR); header('HTTP/1.1 302 Found'); header("Location: " . Options::get('base_url')); exit; } foreach ($xml->url as $url) { if (!Page::exists($url->loc)) { $db->exec("INSERT INTO page VALUES('', '{$url->loc}', '')"); // @todo update page metrics } } }
<label>Web page URL</label> <input name="url" size="45" id="url" type="text" class="text" /> <input value="Submit" type="submit" /> </form> </div></div> </div> <?php } else { ?> <?php $db = DB::connect(); $url = mysql_escape_string($_GET["url"]); $url = str_replace('http://', '', $url); $url = "http://{$url}"; $page_exists = $db->query("SELECT COUNT(1) FROM page WHERE url= '{$url}'")->fetchColumn(); if (!$page_exists) { // create the page $db->exec("INSERT INTO page VALUES('','{$url}','{$title}')"); // @todo update page metrics } $domain = parse_url($url, PHP_URL_HOST); $site_exists = $db->query("SELECT COUNT(1) FROM site WHERE domain = '{$domain}'")->fetchColumn(); if (!$site_exists) { $pagerank = Google::get_pagerank($domain); $db->exec("INSERT INTO site VALUES('', '{$domain}', '{$pagerank}')"); } } ?> <?php include 'footer.php';