function print_structure($pcid, $ident, $mi_mother = '0')
{
global $TOOLBAR_LANG;
$sql_p_c = "SELECT * FROM `menu_items` \n\t\t\t\t\tINNER JOIN `menu_items-languages` ON `menu_items`.MI_ID=`menu_items-languages`.MI_ID\n\t\t\t\t\tWHERE `menu_items`.MI_DELETED=0 AND `menu_items`.MI_MOTHER='{$pcid}' \n\t\t\t\t\tAND `menu_items-languages`.L_ID = '{$TOOLBAR_LANG}' \n\t\t\t\t\tORDER BY `menu_items`.MI_RANK, `menu_items-languages`.MIL_ALIAS";
$query_p_c = mysql_query($sql_p_c);
$rows_p_c = mysql_num_rows($query_p_c);
if ($rows_p_c) {
while ($result_p_c = mysql_fetch_array($query_p_c)) {
$link = '<a href="?action=menu_items_edit&id=' . $result_p_c['MI_ID'] . '&tl=' . $TOOLBAR_LANG . '">' . stripslashes($result_p_c['MIL_ALIAS']) . '</a>';
echo '<li>' . $ident . $link . '</li>';
print_structure($result_p_c['MI_ID'], $ident . ' ', $mi_mother);
}
}
}
function dbstructure_run(&$argv, &$argc)
{
global $a, $db;
if (is_null($a)) {
$a = new App();
}
if (is_null($db)) {
@(include ".htconfig.php");
require_once "include/dba.php";
$db = new dba($db_host, $db_user, $db_pass, $db_data);
unset($db_host, $db_user, $db_pass, $db_data);
}
if ($argc == 2) {
switch ($argv[1]) {
case "update":
update_structure(true, true);
return;
case "dumpsql":
print_structure(db_definition());
return;
}
}
// print help
echo $argv[0] . " <command>\n";
echo "\n";
echo "commands:\n";
echo "update\t\tupdate database schema\n";
echo "dumpsql\t\tdump database schema\n";
return;
}
?>
<div class="breadcrumb">Δημιουργία Μενού » Δομή Μενού</div>
<?php
require_once "menu_structure_toolbox.php";
//Structure listing
require "db_connect.php";
include "functions.php";
$sql_mg = "SELECT * FROM `menu_groups` \n\t\t\t INNER JOIN `menu_groups-languages` ON `menu_groups`.MG_ID=`menu_groups-languages`.MG_ID \n\t\t\t WHERE `menu_groups-languages`.L_ID = '{$TOOLBAR_LANG}' \n\t\t\t AND `menu_groups`.MG_DELETED = 0 \n\t\t\t ORDER BY `menu_groups`.MG_RANK, `menu_groups-languages`.MGL_ALIAS";
$query_mg = mysql_query($sql_mg) or die(mysql_error());
$rows_mg = mysql_num_rows($query_mg);
if ($rows_mg) {
while ($result_mg = mysql_fetch_array($query_mg)) {
echo '<ul class = "list_mg">';
echo '<li>' . stripslashes($result_mg['MGL_ALIAS']) . '</li>';
//START: MENU ITEMS
$sql_mi_mother = "SELECT * FROM `menu_items` \n\t\t\t\t\t\t\tINNER JOIN `menu_items-languages` ON `menu_items`.MI_ID=`menu_items-languages`.MI_ID\n\t\t\t\t\t\t\tINNER JOIN `menu_groups-menu_items` ON `menu_items`.MI_ID=`menu_groups-menu_items`.MI_ID\n\t\t\t\t\t\t\tWHERE `menu_groups-menu_items`.MG_ID='" . $result_mg['MG_ID'] . "' \n\t\t\t\t\t\t\tAND `menu_items`.MI_DELETED=0 \n\t\t\t\t\t\t\tAND `menu_items-languages`.L_ID = '{$TOOLBAR_LANG}' \n\t\t\t\t\t\t\tAND (`menu_items`.MI_MOTHER IS NULL OR `menu_items`.MI_MOTHER='0') \n\t\t\t\t\t\t\tORDER BY `menu_items`.MI_RANK, `menu_items-languages`.MIL_ALIAS";
$query_mi_mother = mysql_query($sql_mi_mother) or die(mysql_error());
$ident = '';
//dashes
while ($result_mi_mother = mysql_fetch_array($query_mi_mother)) {
$link = '<a href="?action=menu_items_edit&id=' . $result_mi_mother['MI_ID'] . '&tl=' . $TOOLBAR_LANG . '">' . stripslashes($result_mi_mother['MIL_ALIAS']) . '</a>';
echo '<li>' . $ident . $link . '</li>';
print_structure($result_mi_mother['MI_ID'], $ident . ' ');
}
//END: MENU ITEMS
echo '</ul>';
}
} else {
echo '<div class="validation_message_false">Δεν έχει δημιουργηθεί μενού για αυτή την γλώσσα.</div>';
}
require "db_disconnect.php";
