function update_pr_tools()
{
global $prtools_debug;
global $prtools_version;
$prtools_settings = get_option('pagerank_tools_settings');
// unset($prtools_settings['running_number']);
if ($prtools_debug) {
print_r_html($prtools_settings);
}
// Reorganizing tables // 08. December 2010 // Version 0.2 to 0.2.1
// Adding entries for requests urls without pr from google,
// adding first creation log,
// get difference between last PR and new PR in table
// and getting num of entries in table
if ($prtools_settings['running_number'] == "") {
cleanup_db_from_02();
}
if ($prtools_settings['running_number'] < 3) {
alter_table_from_02();
update_url_table(true, true);
$prtools_settings['fetch_titles_num'] = 2;
}
// Saving which updates have been made
$prtools_settings['version'] = $prtools_version;
$prtools_settings['running_number'] = 3;
// if($prtools_debug)unset($prtools_settings['running_number']);
update_option('pagerank_tools_settings', $prtools_settings);
}
function prtools_overview()
{
global $prtools_extended;
update_url_table(false, false);
update_pr_tools();
if (isset($_GET['url']) && $prtools_extended) {
prtools_url();
} else {
global $wpdb;
global $prtools_url_table;
global $prtools_pr_table;
global $prtools_sum_urls;
global $prtools_sum_urls_query;
global $prtools_absolute_path;
$table_name = $wpdb->prefix . "prtools_url";
$sql = "SELECT count(*) AS count FROM " . $table_name;
$prtools_stat = $wpdb->get_row($sql);
$prtools_sum_urls = $prtools_stat->count;
$sql = "SELECT * FROM " . $table_name . " ORDER by pr DESC";
$sql = apply_filters('prtools_main_sql', $sql);
$prtools_rows = $wpdb->get_results($sql);
$prtools_sum_urls_query = count($prtools_rows);
?>
<!-- Head of entry //-->
<div class="tab-head">
<h2>
<?php
_e('Pageranks', 'prtools');
?>
<?php
if (isset($_GET['url']) && $prtools_extended) {
echo ' ' . $_GET['url'];
}
?>
</h2>
</div>
<?php
do_action('prtools_main_head');
?>
<!-- Listing pageranks of all sites //-->
<table class="widefat">
<?php
$tablehead = '<thead><tr>';
$tablehead .= '<th scope="col">' . __('PR', 'prtools') . '</th>';
$tablehead .= '<th scope="col">' . __('URL', 'prtools') . '</th>';
$tablehead .= '<th scope="col"> </th><th scope="col">' . __('Type', 'prtools') . '</th>';
$tablehead .= '<th scope="col">' . __('Update', 'prtools') . '</th>';
$tablehead .= '</tr></thead>';
$tablehead = apply_filters('prtools_main_tablehead', $tablehead);
echo $tablehead;
?>
<tbody>
<?php
foreach ($prtools_rows as $row) {
if ($row->lastupdate != 0) {
$row->date = date("d.m.Y", $row->lastupdate);
} else {
$row->date = "n/a";
}
if ($row->pr == -1) {
$pr = "n/a";
} elseif ($row->pr == -2) {
$pr = "-";
} else {
$pr = $row->pr;
}
$prtools_row = '<tr>';
$prtools_row .= '<td scope="row">' . $pr . '</td>';
$prtools_row .= '<td scope="row"><a href="' . $row->url . '" target="_blank">' . $row->url . '</a></td>';
$prtools_row .= '<td scope="row">
<a href="' . $row->url . '" target="_blank">[visit]</a>
<a href="#" border="0" title="Delete" onclick="question_redirect(\'' . __('Do you really want to delete', 'prtools') . ' ' . $row->url . ' and all data from Pagerank tools?\', \'' . str_replace('%7E', '~', $_SERVER['REQUEST_URI']) . '&delete_url=' . $row->url . '\' );">[delete]</a>
</td>';
$prtools_row .= '<td scope="row">' . $row->url_type . '</td>';
$prtools_row .= '<td scope="row">' . $row->date . '</td>';
$prtools_row .= '</tr>';
$prtools_row = apply_filters('prtools_main_tablerow', $prtools_row, $row);
echo $prtools_row;
}
?>
</tbody>
</table>
<div style="height:20px"></div>
<?php
}
do_action('prtools_main_bottom');
}
