<?php
/*
Plugin Name: Psli-BingMaps
Author: psli 
Description: Admin function for plugin "Psli-BingMaps"
*/

// Chech whether we are indeed included by Piwigo.
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

// Fetch the template.
global $template, $conf, $page;

// Save configuration
if (isset($_POST['submit']))
{
	$query = '
		UPDATE '.CONFIG_TABLE.'
			SET value="' . addslashes($_POST['key']) . '"
			WHERE param="'.PSLI_CONF_KEY.'"
			LIMIT 1';
    pwg_query($query);
    $query = '
		UPDATE '.CONFIG_TABLE.'
			SET value="' . addslashes($_POST['lat']) . '"
			WHERE param="'.PSLI_CONF_LAT.'"
			LIMIT 1';
    pwg_query($query);
	$query = '
		UPDATE '.CONFIG_TABLE.'
			SET value="' . addslashes($_POST['lon']) . '"
			WHERE param="'.PSLI_CONF_LON.'"
			LIMIT 1';
    pwg_query($query);
	$query = '
		UPDATE '.CONFIG_TABLE.'
			SET value="' . addslashes($_POST['zoom']) . '"
			WHERE param="'.PSLI_CONF_ZOOM.'"
			LIMIT 1';
    pwg_query($query);
	
	if ($_POST['catSelected'] != 0)
	{
		$query = '
			UPDATE '.CONFIG_TABLE.'
				SET value="' . addslashes($_POST['catSelected']) . '"
				WHERE param="'.PSLI_CONF_CATEGORY.'"
				LIMIT 1';
		pwg_query($query);
	}
    array_push($page['infos'], l10n('Information data registered in database'));
}

// Get configuration
$query = '
	SELECT value
		FROM '.CONFIG_TABLE.'
		WHERE param = "'.PSLI_CONF_KEY.'";';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$key = $row['value'];

$query = '
	SELECT value
		FROM '.CONFIG_TABLE.'
		WHERE param = "'.PSLI_CONF_LAT.'";';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$lat = $row['value'];

$query = '
	SELECT value
		FROM '.CONFIG_TABLE.'
		WHERE param = "'.PSLI_CONF_LON.'";';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$lon = $row['value'];

$query = '
	SELECT value
		FROM '.CONFIG_TABLE.'
		WHERE param = "'.PSLI_CONF_ZOOM.'";';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$zoom = $row['value'];

$query = '
	SELECT value
		FROM '.CONFIG_TABLE.'
		WHERE param = "'.PSLI_CONF_CATEGORY.'";';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$category = $row['value'];

$query = '
SELECT id,name,uppercats,global_rank
  FROM '.CATEGORIES_TABLE.'
;';
$result = pwg_query($query);
$categories = array();
$selecteds = array();
array_push($selecteds, "To define");
if (!empty($result))
{
	while ($row = pwg_db_fetch_assoc($result))
	{
		if ($row['id'] == $category)
		{
			$option = strip_tags(
				get_cat_display_name_cache(
					$row['uppercats'],
					null,
					false
					)
				);
			$selecteds = array();
			array_push($selecteds, $option);
			array_push($categories, $row);
		}
		else
		{
			array_push($categories, $row);
		}
	}
}
usort($categories, 'global_rank_compare');
display_select_categories($categories, $selecteds, 'category_select', true);

display_select_categories($categories, null, 'zone', true);

// Send configuration data to template
$template->assign(
  array(
	'KEY'          => $key,
	'LAT'          => $lat,
	'LON'          => $lon,
	'ZOOM'         => $zoom
  )
);

// Language data
load_language('plugin.lang', PSLI_BINGMAPS_DIRECTORY);

// Assign the template contents to ADMIN_CONTENT
$template->set_filenames(array('plugin_admin_content' => PSLI_BINGMAPS_DIRECTORY.'template/admin.tpl'));
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');

?>