/**
* 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';
