<?php
/**
* @package linea21\plugins\l21_dynamicMenu
* @author $Author$ - Simon Georget <simon@linea21.com>
* @version $Id$
* @access public
* @license http://opensource.org/licenses/gpl-3.0.html
*/

//////////// Check Inclusion de pages ////////////
if (!class_exists('auth')) {
	include_once ("../lib/lib_common.php");
	ReloadIndex('admin');
}
//////////// Check Droits utilisateur ////////////
if (!$GLOBALS['l21auth']->isSuperAdmin()) ReloadIndex('admin');
////////////

// we create table if it does not exists yet
$sql = "CREATE TABLE IF NOT EXISTS l21_menu (
  menu_id int(11) NOT NULL AUTO_INCREMENT,
  menu_item varchar(255) NOT NULL,
  menu_description varchar(255) NOT NULL,
  menu_url varchar(255) NOT NULL,
  menu_accesskey varchar(1) NOT NULL,
  menu_parent int(11) NOT NULL,
  menu_sublevel int(11) NOT NULL,
  menu_order int(11) NOT NULL,
  menu_active VARCHAR(1) NOT NULL DEFAULT 'Y',
  menu_reference int(11) NOT NULL,
  PRIMARY KEY (menu_id)
) DEFAULT CHARSET=utf8;";
$GLOBALS['sql_object']->DBQuery($sql);

// we check if there is some data already
$r = $GLOBALS['sql_object']->DBSelect("SELECT menu_id FROM l21_menu;");


// if the database is not populated yet, we do so
// based on current $GLOBALS['menuitems'] settings

if(!isset($r[0]['menu_id'])) {

	$i = 1;
	foreach($GLOBALS['menuitems'] as $key => $value) {
		$a =$GLOBALS['sql_object']->DBescape($GLOBALS['links'][U_L][$value]);
		
		// @todo handle URL rewriting
		// $current_link = HrefMaker(array('rub' => $a['linkvalue']));
		// $current_link = get_permalink(array('rub' => $a['linkvalue']));
		$current_link = 'index.php?rub=' .$a['linkvalue'];
		
		$q = "INSERT INTO l21_menu (menu_item, menu_description, menu_url, menu_accesskey, menu_parent, menu_sublevel, menu_order, menu_reference)  VALUES('".mb_ucfirst($a['title'])."', '".mb_ucfirst($a['desc'])."', '".$current_link."' , '', 0, 0, ".$i.", 0);";
		
		$r = $GLOBALS['sql_object']->DBInsert($q);
		$i++;
		
	}
}

?>