<?php
/*
 * Copyright (C) 2010 Thomas Cort <linuxgeek@gmail.com>
 *
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted (subject to the limitations in the
 * disclaimer below) provided that the following conditions are met:
 *
 *  * Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 *
 *  * Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in the
 *    documentation and/or other materials provided with the
 *    distribution.
 *
 *  * Neither the name of Thomas Cort nor the names of its
 *    contributors may be used to endorse or promote products derived
 *    from this software without specific prior written permission.
 *
 * NO EXPRESS OR IMPLIED LICENSES TO ANY PARTY'S PATENT RIGHTS ARE
 * GRANTED BY THIS LICENSE.  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT
 * HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED
 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
 * MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
 * BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
 * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE
 * OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN
 * IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

// UTF-8 enable this script
mb_language('uni');
mb_internal_encoding('UTF-8');

require_once('../www/config.php');

// Connect to the Database
@mysql_connect($hostname, $username, $password) or die("Unable to connect to database");
@mysql_select_db($database) or die("Unable to select database");

// UTF-8 enable the database connection
@mysql_set_charset('utf8');

@mysql_query("SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'");
@mysql_query("SET CHARACTER SET 'utf8'");
@mysql_query("SET collation_connection = 'utf8_general_ci'");

// go through the lowest level to see if there are any candidates to bring up
$result = mysql_query("SELECT DISTINCT sym FROM poi ORDER BY sym ASC;");
while ($row = mysql_fetch_row($result)) {
	if (!file_exists("../www/sym/" . $row[0] . ".png")) {
		print "../www/sym/" . $row[0] . ".png" . "\n";
		mysql_query("DELETE FROM poi WHERE sym = '" . mysql_real_escape_string($row[0]) . "';");
	}
}
mysql_free_result($result);



mysql_close();
?>

Add a tool to remove POI that don't have associated symbols in www/sym
Add a tool to remove POI that don't have associated symbols in www/sym
