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";