#!/usr/bin/php

<?php

# Working with Online-Bookmarks versions >= 0.8.x

require_once ("./config/config.php");
require_once ("./lib/mysql.php");
$mysql = & new mysql;
require_once ("./favicon.php");

$settings['show_bookmark_icon'] = true;

$query = "SELECT url, id FROM bookmark WHERE favicon IS NULL OR favicon=''";

if ($mysql->query ($query)) {
    while ($row = mysql_fetch_row ($mysql->result)) {
        echo "Attempt to get favicon for " . $row[0] . "\n";
        $favicon = & new favicon ($row[0]);
        if (isset ($favicon->favicon)) {
            mysql_query ("UPDATE bookmark set favicon = '$favicon->favicon' WHERE id = '$row[1]'");
            echo "favicon found and updated\n";
        }
        else {
            mysql_query ("UPDATE bookmark set favicon = './images/bookmark_image.gif' WHERE id = '$row[1]'");
            echo "no favicon found\n";
        }
    }
}
else {
    message ($mysql->error);
}

?>