function generateSQL($t, $formid, $cntr) { global $_TABLES; if ($t == 'formDefinitions') { $table = $_TABLES['nxform_definitions']; $query = DB_query("SELECT * from {$table} WHERE id='{$formid}'"); } else { $table = $_TABLES['nxform_fields']; $query = DB_query("SELECT * from {$table} WHERE formid='{$formid}'"); } while ($A = DB_fetchArray($query)) { $numfields = DB_numFields($query); $myvars = array(); $sqlstmt .= '$_SQL[' . $cntr . '][] = "INSERT INTO ' . $table; $sqlstmtVars = ''; $sqlstmtValues = ''; // Need to skip the first field - which is an auto-increment primary key for ($i = 1; $i < $numfields; $i++) { $fieldname = DB_fieldName($query, $i); //echo "<br>$i:$fieldname and value:{$A[$fieldname]}"; $myvars[$fieldname] = $A[$fieldname]; if ($t == 'formFields' and $fieldname == 'formid') { $value = $cntr; } else { $value = addslashes($A[$fieldname]); //$value = str_replace('"','\"',$A[$fieldname]); //$value = str_replace('\'','\\\'',$A[$fieldname]); } if ($i > 1) { $sqlstmtVars .= ",{$fieldname}"; if (is_null($A[$fieldname])) { $sqlstmtValues .= ",NULL"; } else { $sqlstmtValues .= ",'{$value}'"; } } else { $sqlstmtVars .= "{$fieldname}"; $sqlstmtValues .= "'{$value}'"; } } $sqlstmt = $sqlstmt . ' (' . $sqlstmtVars . ') VALUES (' . $sqlstmtValues . ')";' . LB; } return $sqlstmt; }
function menuConfig() { global $_CONF, $_TABLES, $_USER, $LANG_NEXMENU01, $id, $inactive, $showdisabled; global $menulocation, $CONF_NEXMENU, $LANG_NEXMENU04, $LANG_NEXMENU05; $statusmsg = $_GET['statusmsg']; include $_CONF['path_system'] . 'classes/navbar.class.php'; $tpl = new Template($_CONF['path_layout'] . 'nexmenu/admin'); if ($CONF_NEXMENU['debug']) { $tpl->set_file('page', 'menuconfig-debug.thtml'); } else { $tpl->set_file('page', 'menuconfig.thtml'); } $tpl->set_var('site_url', $_CONF['site_url']); $tpl->set_var('layout_url', $_CONF['layout_url']); $tpl->set_var('imgset', $_CONF['layout_url'] . '/nexmenu/images/admin'); $tpl->set_var('LANG_usecolorpicker', $LANG_NEXMENU05[32]); $theme = COM_applyFilter($_POST['theme']); if (empty($theme)) { $theme = COM_applyFilter($_GET['theme']); } if (empty($theme)) { $theme = $_USER['theme']; } if (!empty($theme)) { // Check if a record already exists for theme - if not create one from the default record if (DB_count($_TABLES['nexmenu_config'], 'theme', $theme) == 1) { $query = DB_query("SELECT * FROM {$_TABLES['nexmenu_config']} WHERE theme='{$theme}'"); $A = DB_fetchArray($query); } else { $query = DB_query("SELECT * FROM {$_TABLES['nexmenu_config']} WHERE theme='default'"); if (DB_numRows($query) == 1) { DB_query("INSERT INTO {$_TABLES['nexmenu_config']} (theme,header_style,block_style) VALUES ('{$theme}','CSS','CSS')"); $D = DB_fetchArray($query); $numfields = DB_numFields($query); // Need to skip the first field - which is an auto-increment primary key for ($i = 1; $i < $numfields; $i++) { $fieldname = DB_fieldName($query, $i); DB_query("UPDATE {$_TABLES['nexmenu_config']} SET {$fieldname}='{$D[$fieldname]}' WHERE theme='{$theme}'"); } $query = DB_query("SELECT * FROM {$_TABLES['nexmenu_config']} WHERE theme='{$theme}'"); $A = DB_fetchArray($query); } else { COM_errorLog("glMenu - tried to create new config record for theme: {$theme}, and default config record not found"); echo "<p>Unexpected plugin Error - check error.log</p>"; die; } } } else { $theme = 'default'; $query = DB_query("SELECT * FROM {$_TABLES['nexmenu_config']} WHERE theme='{$theme}'"); $A = DB_fetchArray($query); } $scripturl = $_CONF['site_admin_url'] . '/plugins/nexmenu/index.php'; $navbar = new navbar(); $navbar->add_menuitem($LANG_NEXMENU04['1'], $scripturl . "?menulocation=header&showdisabled={$showdisabled}"); $navbar->add_menuitem($LANG_NEXMENU04['2'], $scripturl . "?menulocation=block&showdisabled={$showdisabled}"); $navbar->add_menuitem($LANG_NEXMENU04['3'], $scripturl . "?op=addaction&id={$idCurrent}&menulocation={$menulocation}&showdisabled={$showdisabled}"); $navbar->add_menuitem($LANG_NEXMENU04['6'], $scripturl . "?op=config&menulocation=block&showdisabled={$showdisabled}"); $navbar->set_selected($LANG_NEXMENU04['6']); $tpl->set_var('navbar', $navbar->generate()); if ($statusmsg != '') { $tpl->set_var('showalert', ''); } else { $tpl->set_var('showalert', 'none'); } $tpl->set_var('statusmsg', $statusmsg); $tpl->set_var('LANG_title', $LANG_NEXMENU05[6]); $menustyles = array_keys($CONF_NEXMENU['menutypes']); $headerMenuType_options = ''; $blockMenuType_options = ''; foreach ($menustyles as $option) { if ($A['header_style'] == $option) { $headerMenuType_options .= '<option value="' . $option . '" SELECTED=selected>' . $option . '</option>'; } else { $headerMenuType_options .= '<option value="' . $option . '">' . $option . '</option>'; } } foreach ($menustyles as $option) { if ($A['block_style'] == $option) { $blockMenuType_options .= '<option value="' . $option . '" SELECTED=selected>' . $option . '</option>'; } else { $blockMenuType_options .= '<option value="' . $option . '">' . $option . '</option>'; } } if ($A['header_style'] == 'Milonic') { $tpl->set_var('show_headerCssMenuSettings', 'none'); $tpl->set_var('show_headerMilonicMenuSettings', ''); } else { $tpl->set_var('show_headerCssMenuSettings', ''); $tpl->set_var('show_headerMilonicMenuSettings', 'none'); } if ($A['block_style'] == 'Milonic') { $tpl->set_var('show_blockCssMenuSettings', 'none'); $tpl->set_var('show_blockMilonicMenuSettings', ''); } else { $tpl->set_var('show_blockCssMenuSettings', ''); $tpl->set_var('show_blockMilonicMenuSettings', 'none'); } $themes = COM_getThemes(); $themes[0] = 'default'; ksort($themes); foreach ($themes as $option) { if ($A['theme'] == $option) { $theme_options .= '<option value="' . $option . '" SELECTED=selected>' . $option . '</option>'; } else { $theme_options .= '<option value="' . $option . '">' . $option . '</option>'; } } $tpl->set_var('headerMenuType_options', $headerMenuType_options); $tpl->set_var('blockMenuType_options', $blockMenuType_options); $tpl->set_var('theme_options', $theme_options); $tpl->set_var('headerbg', $A['headerbg']); $tpl->set_var('headerfg', $A['headerfg']); $tpl->set_var('blockbg', $A['blockbg']); $tpl->set_var('blockfg', $A['blockfg']); $tpl->set_var('headersubmenubg', $A['headersubmenubg']); $tpl->set_var('headersubmenufg', $A['headersubmenufg']); $tpl->set_var('blocksubmenubg', $A['blocksubmenubg']); $tpl->set_var('blocksubmenufg', $A['blocksubmenufg']); $tpl->set_var('onhover_headerbg', $A['onhover_headerbg']); $tpl->set_var('onhover_headerfg', $A['onhover_headerfg']); $tpl->set_var('onhover_blockbg', $A['onhover_blockbg']); $tpl->set_var('onhover_blockfg', $A['onhover_blockfg']); $tpl->set_var('onhover_headersubmenubg', $A['onhover_headersubmenubg']); $tpl->set_var('onhover_headersubmenufg', $A['onhover_headersubmenufg']); $tpl->set_var('onhover_blocksubmenubg', $A['onhover_blocksubmenubg']); $tpl->set_var('onhover_blocksubmenufg', $A['onhover_blocksubmenufg']); $tpl->set_var('header_properties', $A['headermenu_properties']); $tpl->set_var('block_properties', $A['blockmenu_properties']); $tpl->set_var('LANG_menumode', $LANG_NEXMENU05[0]); $tpl->set_var('LANG_langlabels', $LANG_NEXMENU05[1]); $tpl->set_var('LANG_newwindow', $LANG_NEXMENU05[2]); $tpl->set_var('LANG_reference', $LANG_NEXMENU05[3]); $tpl->set_var('LANG_enabled', $LANG_NEXMENU05[4]); $tpl->set_var('LANG_disabled', $LANG_NEXMENU05[5]); $tpl->set_var('LANG_miloniclabel1', $LANG_NEXMENU05[7]); $tpl->set_var('LANG_miloniclabel2', $LANG_NEXMENU05[8]); $tpl->set_var('LANG_miloniclabel3', $LANG_NEXMENU05[9]); $tpl->set_var('LANG_miloniclabel4', $LANG_NEXMENU05[10]); $tpl->set_var('LANG_miloniclabel5', $LANG_NEXMENU05[12]); $tpl->set_var('LANG_miloniclabel6', $LANG_NEXMENU05[13]); $tpl->set_var('LANG_miloniclabel7', $LANG_NEXMENU05[14]); $tpl->set_var('LANG_milonichelp1', $LANG_NEXMENU05[11]); $tpl->set_var('LANG_csslabel1', $LANG_NEXMENU05[15]); $tpl->set_var('LANG_csslabel2', $LANG_NEXMENU05[16]); $tpl->set_var('LANG_csslabel3', $LANG_NEXMENU05[17]); $tpl->set_var('LANG_csslabel4', $LANG_NEXMENU05[18]); $tpl->set_var('LANG_csslabel5', $LANG_NEXMENU05[19]); $tpl->set_var('LANG_csslabel6', $LANG_NEXMENU05[20]); $tpl->set_var('LANG_csslabel7', $LANG_NEXMENU05[21]); $tpl->set_var('LANG_csslabel8', $LANG_NEXMENU05[22]); $tpl->set_var('LANG_csslabel9', $LANG_NEXMENU05[23]); $tpl->set_var('LANG_csslabel26', $LANG_NEXMENU05[26]); $tpl->set_var('LANG_csslabel27', $LANG_NEXMENU05[27]); $tpl->set_var('LANG_csslabel28', $LANG_NEXMENU05[28]); $tpl->set_var('LANG_csslabel29', $LANG_NEXMENU05[29]); $tpl->set_var('LANG_csslabel30', $LANG_NEXMENU05[30]); $tpl->set_var('LANG_csslabel31', $LANG_NEXMENU05[31]); $tpl->set_var('LANG_yes', $LANG_NEXMENU05[24]); $tpl->set_var('LANG_no', $LANG_NEXMENU05[25]); if ($A['multilanguage'] == 1) { $tpl->set_var('chk_langon', "CHECKED=checked"); } else { $tpl->set_var('chk_langoff', "CHECKED=checked"); } if ($A['targetfeatures'] == '') { $tpl->set_var('targetfeatures', 'width=800,height=600,left=50,top=50,scrollbars=yes;'); } else { $A['targetfeatures'] = str_replace('targetfeatures=', '', $A['targetfeatures']); $tpl->set_var('targetfeatures', $A['targetfeatures']); } if ($_GET['writecss'] == 1) { $tpl->set_var('chk_writecss_yes', 'CHECKED=checked'); } else { $tpl->set_var('chk_writecss_no', 'CHECKED=checked'); } $menustyles = ''; foreach ($CONF_NEXMENU['milonicstyles'] as $menustyle) { if ($A['blockmenu_style'] == $menustyle) { $menustyles .= '<option value="' . $menustyle . '" SELECTED=selected>' . $menustyle . '</option>'; } else { $menustyles .= '<option value="' . $menustyle . '">' . $menustyle . '</option>'; } } $tpl->set_var('style1_options', $menustyles); if ($A['header_style'] == 'Milonic') { $tpl->set_var('show_milonicstyles', ''); $tpl->set_var('show_cssmenucolors', 'none'); } else { $tpl->set_var('show_milonicstyles', 'none'); $tpl->set_var('show_cssmenucolors', ''); } $menustyles = ''; foreach ($CONF_NEXMENU['milonicstyles'] as $menustyle) { if ($A['blocksubmenu_style'] == $menustyle) { $menustyles .= '<option value="' . $menustyle . '" SELECTED=selected>' . $menustyle . '</option>'; } else { $menustyles .= '<option value="' . $menustyle . '">' . $menustyle . '</option>'; } } $tpl->set_var('style2_options', $menustyles); $menustyles = ''; foreach ($CONF_NEXMENU['milonicstyles'] as $menustyle) { if ($A['headermenu_style'] == $menustyle) { $menustyles .= '<option value="' . $menustyle . '" SELECTED=selected>' . $menustyle . '</option>'; } else { $menustyles .= '<option value="' . $menustyle . '">' . $menustyle . '</option>'; } } $tpl->set_var('style3_options', $menustyles); $menustyles = ''; foreach ($CONF_NEXMENU['milonicstyles'] as $menustyle) { if ($A['headersubmenu_style'] == $menustyle) { $menustyles .= '<option value="' . $menustyle . '" SELECTED=selected>' . $menustyle . '</option>'; } else { $menustyles .= '<option value="' . $menustyle . '">' . $menustyle . '</option>'; } } $tpl->set_var('style4_options', $menustyles); $tpl->set_var('LANG_CANCEL', $LANG_NEXMENU01['LANG_CANCEL']); $tpl->set_var('cancel_url', $_CONF['site_admin_url'] . '/plugins/nexmenu/index.php?op=display&id=' . $id . '&showdisabled=' . $inactive . '&menulocation=' . $menulocation); $tpl->set_var('LANG_SUBMIT', $LANG_NEXMENU01['LANG_UPDATE']); $tpl->parse('output', 'page'); return $tpl->finish($tpl->get_var('output')); }