echo '<option value="0" SELECTED>Κανένα</option>'; while ($result_mg = mysql_fetch_array($query_mg)) { echo "ENTERED"; echo '<optgroup label="' . stripslashes($result_mg['MGL_ALIAS']) . '">'; //START: MENU ITEMS $sql_mi_mother = "SELECT * FROM `menu_items` \n\t\t\t\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\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\t\t\t\tWHERE `menu_groups-menu_items`.MG_ID = '" . $result_mg['MG_ID'] . "' \t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\tAND `menu_items`.MI_DELETED = 0 \n\t\t\t\t\t\t\t\t\t\tAND `menu_items-languages`.L_ID = '{$DLTL}' \n\t\t\t\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\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()); $pcs = ''; //dashes while ($result_mi_mother = mysql_fetch_array($query_mi_mother)) { $is_disabled = ""; if ($result_mi_mother['MT_ID'] != 'ZS4z2y9E5F') { $is_disabled = "DISABLED"; } echo '<option value="' . $result_mi_mother['MI_ID'] . '" ' . $is_disabled . '>' . $pcs . stripslashes($result_mi_mother['MIL_ALIAS']) . '</option>'; print_structure_gallery($result_mi_mother['MI_ID'], $pcs . ' - - - '); } //END: MENU ITEMS echo '</optgroup>'; } echo '</select>'; } else { echo '<div class="form_left"></div><div class="form_right">Δεν υπάρχουν διαθέσιμα Στοιχεία Μενού προς αντιστοίχιση.'; } require "db_disconnect.php"; ?> </div> <div class="clear"></div> </div> <!-- END: MENU --> <div class="form_left"> </div><div class="form_right"><input type="submit" class="form_button" value="Ανέβασμα" /></div>
function print_structure_gallery($pcid, $pcs, $mi_mother = '0') { global $tab_lang; global $DLTL; $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 = '{$DLTL}' \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)) { $is_disabled = ""; if ($result_p_c['MT_ID'] != 'EKatjWfxOt') { $is_disabled = "DISABLED"; } $mi_selected = ""; if ($result_p_c['MI_ID'] == $mi_mother) { $mi_selected = "SELECTED"; } echo '<option value="' . $result_p_c['MI_ID'] . '" ' . $mi_selected . ' ' . $is_disabled . '>' . $pcs . stripslashes($result_p_c['MIL_ALIAS']) . '</option>'; print_structure_gallery($result_p_c['MI_ID'], $pcs . ' - - - ', $mi_mother); } } }