source: extensions/Psli_BingMaps/include/admin.php @ 14891

<?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,
        'JSPATH'           => PSLI_BINGMAPS_JS
  )
);

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

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

?>