function edit_css()
{
$base = "msql/design/";
$basy = "msql/system/";
clrpckr_js();
$qb = ses('qb');
$lh = sesmk('csslang');
$defsb["_menus_"] = array("div", "class", "element", "color", "bkg", "border", "free");
$edit = $_GET["edit_css"] ? $_GET["edit_css"] : $_POST["edit_css"];
if (!$_SESSION['desgn']) {
$_SESSION['desgn'] = $_SESSION['prmd'];
}
$numb = $_GET["desgn"];
//desgn
if ($numb && $numb != "=") {
$_SESSION['desgn'] = $numb;
$_SESSION['clrset'] = $numb;
$_SESSION['prmd'] = $numb;
$_SESSION['clrs'][$numb] = msql_read('design', $qb . '_clrset_' . $_SESSION['clrset'], '');
$defs = read_vars($base, $qb . '_design_' . $_SESSION['desgn'], $defsb);
}
$desgn = $_SESSION['desgn'];
$prmd = $_SESSION['prmd'];
$clrset = $_SESSION['clrset'] = $_SESSION['clrset'] ? $_SESSION['clrset'] : $prmd;
$f_dsn = $qb . '_design_' . $desgn;
$f_clr = $qb . '_clrset_' . $clrset;
$basecss = 'css/' . $f_dsn . '.css';
$basecss_temp = 'css/' . $qb . '_design_dev_' . $prmd . '.css';
#load
if (!$defs) {
$defs = read_vars($base, $f_dsn, $defsb);
}
unset($defs['_menus_']);
//good_nb
unset($defs[0]);
$defs = reorder_keys($defs);
if (!is_file($basecss_temp)) {
build_css($basecss_temp, $defs);
}
#sav
if ($nd = $_GET["newdiv"]) {
$defs = defs_addnew($defs, $_GET["from"], array($nd, '', '', '', '', '', ''));
//p($defs);
save_vars($base, $f_dsn, $defs);
$edit = find_value($defs, array($nd));
}
if ($_GET["new_from"]) {
$tbn = msq_find_last('design', $qb, 'design');
save_vars($base, $qb . '_design_' . $tbn, $defs);
msq_copy('design', $f_clr, 'design', $qb . '_clrset_' . $tbn);
//msq_copy('design',$qb.'_blocks_'.$desgn,'design',$qb.'_blocks_'.$tbn);
$_SESSION['clrs'][$tbn] = $_SESSION['clrs'][$_SESSION['desgn']];
$_SESSION['desgn'] = $_SESSION['clrset'] = $tbn;
$f_dsn = $qb . '_design_' . $tbn;
$f_clr = $qb . '_clrset_' . $tbn;
msql_modif('users', 'public_design', dsnam_arr(desname($qb, $desgn)), '', 'one', $tbn);
build_css('css/' . $qb . '_design_dev_' . $tbn . '.css', $defs);
}
if ($_GET["make_public"]) {
if ($_GET["inform"]) {
$tbn = $desgn;
} else {
$tbn = msq_find_last('design', 'public', 'design');
}
save_vars($base, 'public_design_' . $tbn, $defs);
msq_copy('design', $f_clr, 'design', 'public_clrset_' . $tbn);
msql_modif('users', 'public_design', dsnam_arr(desname($qb, $desgn)), '', 'one', $desgn);
build_css('css/public_design_' . $tbn . '.css', $defs);
alert('created: public_design_' . $tbn);
}
if ($_GET["make_admin"]) {
build_css('css/_admin.css', $defs);
save_vars($basy, 'default_css_3', $defs);
alert('modified: system/default_css_3, _admin.css');
}
if ($_GET["make_global"]) {
build_css('css/_global.css', $defs);
save_vars($basy, 'default_css_1', $defs);
msq_copy('design', $f_clr, 'system', 'default_clr_1');
alert('modified: system/default_css_1, _global.css');
}
if ($_GET["make_default"]) {
build_css('css/_classic.css', $defs);
save_vars($basy, 'default_css_2', $defs);
msq_copy('design', $f_clr, 'system', 'default_clr_2');
$defse = empty_design($defs, 'clr');
build_css('css/_default.css', $defse);
alert('modified: table system/default_css_2, _classic.css, _default.css (no colors)');
}
//clrset
if ($_GET["clrset"]) {
$_SESSION['clrset'] = $clrset = $_GET["clrset"];
$f_clr = $qb . '_clrset_' . $clrset;
$_SESSION['clrs'][$prmd] = msql_read('design', $f_clr, '');
build_css($basecss_temp, $defs);
}
//import_clrset
if ($_GET["import_clrset"]) {
$_SESSION['clrs'][$prmd] = explode("_", $_GET["import_clrset"]);
if ($_SESSION["auth"] >= 6) {
save_clr($qb . '_' . $clrset);
}
}
if ($_GET["add_clrset"]) {
save_clr($qb . '_' . $_GET["clrset"]);
}
//reset
if ($_GET["reset_clr"] or $_GET["add_design"]) {
$_SESSION['clrs'][$prmd] = msql_read('system', "default_clr_2", '');
save_clr($f_clr);
}
if ($_GET["reset_default"] or $_GET["add_design"]) {
$defs = css_default();
unset($defs['_menus_']);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
if ($_GET["reset_global"] or $_GET["add_design"]) {
$defs = css_default(1);
unset($defs['_menus_']);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
//public
if ($pub = $_GET["public_clr"]) {
$_SESSION['clrs'][$prmd] = msql_read('design', 'public_clrset_' . $pub, '');
save_clr($f_clr);
}
if ($pub = $_GET["public_design"]) {
$defs = msql_read('design', 'public_design_' . $pub, '');
unset($defs['_menus_']);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
//null
if ($_GET["empty_design"]) {
$defs = empty_design($defs, 'css');
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
if ($pub = $_GET["null_clr"]) {
$_SESSION['clrs'][$prmd] = array('', '', '', '', '', '', '', '');
save_clr($f_clr);
}
if ($pub = $_GET["null_design"]) {
$defs = css_default();
$defs = empty_design($defs, 'css');
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
//append
if ($_GET["append"]) {
$defsc = css_default();
unset($defsc['_menus_']);
$defs = array_append($defs, $defsc);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
if ($_GET["append_global"]) {
$defsc = css_default();
unset($defsc['_menus_']);
$defs = array_append($defs, $defsc);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
if ($_GET["inject_global"]) {
$defsc = css_default();
unset($defsc['_menus_']);
$defs = append_design($defs, $defsc);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
if ($_GET["reset_this"]) {
$ec = $_GET["edit_css"];
$defsc = css_default();
$ecb = find_value($defsc, $defs[$ec]);
if ($ecb) {
$defs[$ec] = $defsc[$ecb];
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
}
//restore_design
if ($_GET["restore"] == "design") {
$defs = read_vars($base, $f_dsn . '_sav', $defsb);
unset($defs['_menus_']);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
//restore_clrset
if ($_GET["restore"] == "clrset") {
$r = read_vars($base, $f_clr . '_sav', '');
foreach ($r as $k => $v) {
$clrst[] = $v[0];
}
$_SESSION['clrs'][$prmd] = $clrst;
save_clr($f_clr);
build_css($basecss_temp, $defs);
}
//herits
if ($_GET["herit_desgn"]) {
list($qbb, $nbd) = explode('_', $_GET["herit_desgn"]);
$defs = read_vars($base, $qbb . '_design_' . $nbd, $defsb);
//$_SESSION['clrs'][$desgn]=msql_read("design",$qbb.'_clrset_'.$nbd,'');
//save_clr($f_clr);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
if ($_GET["herit_clrset"]) {
list($qbb, $nbd) = explode('_', $_GET["herit_clrset"]);
$_SESSION['clrs'][$desgn] = msql_read("design", $qbb . '_clrset_' . $nbd, '');
save_clr($f_clr);
build_css($basecss_temp, $defs);
}
//ff
if ($_GET['addff']) {
$defs = defs_adder_ff($defs);
save_vars($base, $f_dsn, $defs);
build_css($basecss_temp, $defs);
}
//save//add
if ($_POST["save"] or $_GET["save_img"] or $_GET["save"]) {
$defs = save_defs($base, $f_dsn, $defs, $defsb["_menus_"]);
build_css($basecss_temp, $defs);
if ($_POST["saveblocks"] or $_GET["save"]) {
build_css($basecss, $defs);
}
}
if ($_GET["invert_clr"]) {
$_SESSION['clrs'][$prmd] = invert_defsclr();
save_clr($f_clr);
build_css($basecss_temp, $defs);
}
//sav
if ($_GET["erase"]) {
$defs = save_css_j_del($defs, $_GET["erase"]);
save_vars($base, $f_dsn, $defs);
}
if ($_GET["newfrom"]) {
$defs = save_css_newfrom($defs, $_GET["newfrom"]);
//if($newdiv=$_GET["newdiv"])$defs[$edit]=array($newdiv);
save_vars($base, $f_dsn, $defs);
}
if ($_GET["atpos"]) {
$n = count($defs);
$defs = save_css_displace($defs, $_GET["atpos"], $_POST["pos"]);
if (count($defs) == $n) {
save_vars($base, $f_dsn, $defs);
}
}
if ($_GET['sav']) {
save_vars($base, $f_dsn . '_sav', $defs, 1);
save_clr($f_clr);
}
//_sav
if ($_GET["apply"]) {
save_vars($base, $f_dsn, $defs);
save_clr($f_clr);
build_css($basecss, $defs);
informe_config_design();
}
//informe_config_width($defs);
//build_css
if ($_GET["build_css"]) {
build_css($basecss_temp, $defs);
}
#body
$go = '/?admin=css';
$ret .= lkc("txtcadr", $go, $f_dsn) . ' ';
$ret .= msql_desnam($qb, $desgn, '') . "\n";
$ret .= hlpbt('design') . ' ';
$ret .= msqlink('design', $qb . '_design_' . $desgn) . ' ';
$ret .= lkc('popsav', "/?admin=console&exit_design==", pictxt('logout', nms(112)));
//$ret.=lj('popbt','page_deskbkg','desk').lj('popbt','popup_site___desktop_ok__autosize','site');
//icon('exit')
$ret .= br() . br();
if (prmb(5)) {
$ret .= picto(alert) . helps('prmb5') . br() . br();
}
//$ret.=btn_switch('desgn',$prmd,'/?admin=css','live_edit');
$ret .= see_conds_b() . ' ';
//$ret.=lkc('txtx','/?admin=css&apply==cr_mod==','create conditionnal design').' ';
$ret .= hlpbt('designcond') . br() . br();
$ret .= btn("txtsmall", "save:") . ' ';
$ret .= lkc('txtx', $go . '&sav==', "backup") . ' ';
if ($_SESSION['prmd'] != $_SESSION['desgn']) {
$ret .= lkc('txtx', $go . '&apply==', 'test design ' . $desgn) . ' ';
}
$ret .= lkc('txtx', $go . '&apply=save', nms(66) . ' (mods:' . prmb(1) . ')') . ' ';
$ret .= lkc("popsav", $go . '&save==', nms(57)) . ' ';
//$ret.=lkc("txtx",$go.'&save_inverted==','black').' ';
$ret .= br();
$ret .= btn("txtsmall", nms(111)) . ' ';
//select
$ret .= lj("txtbox", 'popup_styls___select', 'design:' . $desgn . '/clrset:' . $clrset) . ' ';
$ret .= lj('txtx', 'popup_styls___herit', $lh[3]) . ' | ';
//herit
$ret .= lkc('txtx', $go . '&build_css==', nms(93)) . ' | ';
//rebuild
//$ret.=lkc('txtx',$go.'&build_css==&cmpq==',"cmpq").' ';
$ret .= lj('txtx', 'popup_stylsff___1', '@font-face') . br();
$ret .= btn("txtsmall", nms(113)) . ' ';
//make
$ret .= lkc('txtx', $go . '&new_from==', nms(44)) . ' ';
$ret .= lkc('txtx', $go . '&empty_design==', nms(46)) . ' ';
$ret .= lkc('txtx', $go . '&invert_clr==', nms(115)) . ' ';
$ret .= lkc('txtx', $go . '&make_public==', $lh[4]) . ' ';
//make_public
$ret .= lkc('txtx', $go . '&make_public==&inform==', $lh[5]) . ' ';
//inform_public
if ($_SESSION['auth'] > 5) {
$r = msql_read('users', $qb . '_design', $desgn);
$desgname = $r[0] ? $r[0] : $r['name'];
if ($desgname == 'admin') {
$make = 'make_admin';
} elseif ($desgname == 'global') {
$make = 'make_global';
} else {
$make = 'make_default';
}
$ret .= lkc('txtbox', $go . '&' . $make . '==', $make);
}
$ret .= br();
$ret .= btn("txtsmall", nms(95)) . ' ';
//restore
if (is_file($base . $f_dsn . '_sav.php')) {
$ret .= lkc('txtx', $go . '&restore=design', 'design') . ' ';
}
//restore
$ret .= lkc('txtx', $go . '&restore=clrset', 'clr') . ' | ';
$ret .= lkc('txtx', $go . '&reset_default==', nms(96)) . ' ';
//defaults
$ret .= lkc('txtx', $go . '&reset_clr==', "clr") . ' | ';
$ret .= lkc('txtx', $go . '&reset_global=1', "global") . ' ';
$ret .= lkc('txtx', $go . '&public_clr=1', "clr") . ' | ';
$ret .= lkc('txtx', $go . '&public_design=2', "public") . ' ';
//public
$ret .= lkc('txtx', $go . '&public_clr=2', "clr") . ' | ';
$ret .= lkc('txtx', $go . '&null_design==', "null") . ' ';
$ret .= lkc('txtx', $go . '&null_clr==', "clr") . br();
$ret .= btn("txtsmall", nms(92)) . ' ';
//append
$ret .= lkc('txtx', $go . '&append==', nms(96)) . ' ';
//default
$ret .= lkc('txtx', $go . '&append_global==', "global") . ' ';
$ret .= lkc('txtx', $go . '&inject_global==', $lh[9]) . br();
//inject_globals
$ret .= btn("txtsmall", nms(45)) . ' ';
//see
$ret .= lkt('txtx', $basecss, $lh[10]) . ' ';
$ret .= lkt('txtx', $basecss_temp, $lh[11]) . ' ';
//$ret.=lkt('txtx',$f_clr,"clr").' ';
$ret .= lj('txtx', 'popup_styls___clr', "clrset") . ' ';
$ret .= btn('txtx', count($defs) . ' ' . nms(117)) . ' ';
$ret .= btn('txtx', mkday(filemtime($base . $f_dsn . '.php'))) . ' ';
$ret .= br() . br();
$ret .= f_inp_clr_manage_j() . br();
//colors
//plugin('csswidth'); $ret.=f_inp_widths($defs);//widths
if ($defs) {
$ret .= f_inp_plugs($defs, $defsb["_menus_"], $edit, 1) . br() . br();
}
//edit_css
return $ret;
}
function msql_adm($msql = '')
{
//echo br();
$root = sesm('root', 'msql/');
$auth = $_SESSION['auth'];
$ath = 6;
//auth_level_mini
$wsz = define_s('wsz', 700);
$msql = $msql ? $msql : $_GET['msql'];
$_SESSION['page'] = $_GET['page'] ? $_GET['page'] : 1;
#boot
if ($msql && $msql != '=') {
$url = sesm('url', '/msql/');
$ra = msql_boot($msql);
$_SESSION['msql_boot'] = $ra;
list($bases, $base, $dirs, $dir, $prefixes, $prefix, $files, $table, $version, $folder, $node) = $ra;
//build url
$murl = sesm('murl', murl($base, $dir, $prefix, $table, $version));
//b/d/p_t_v
$basename = $root . $folder . $node;
$is_file = is_file($basename . '.php');
$lk = sesm('lk', $url . $folder . $node . gpage());
$folder = $root . $folder;
//conformity
msql_adm_head($lk, $base, $prefix, $table, $version);
}
$def = ajx($_POST['def'] ? $_POST['def'] : $_GET['def'], 1);
if ($_GET['see']) {
$ret[] = verbose($ra, 'dirs');
}
//auth
if ($base == 'users' && $prefix == $_SESSION['USE']) {
$_SESSION['ex_atz'] = 1;
}
if ($auth >= $ath && $_SESSION['ex_atz'] or $auth >= 6) {
$authorized = true;
}
$lkb = $lk . '&';
#load
//reqp('msql'); $msq=new msql($base,$node); if($is_file)$defs=$msq->load();
if (get('repair')) {
msql_repair($folder, $node);
}
//old
if ($is_file) {
$defs = read_vars($folder, $node, $defsb);
}
//if(!$defs)$ret[]=verbose($ra,'');
if ($defs['_menus_']) {
$defsb['_menus_'] = $defs['_menus_'];
}
//save
if ($def && !$defs[$def]) {
$_POST['add'] = $def;
}
if (($_POST['def'] or $_POST['add']) && $authorized) {
list($defs, $def) = save_defs($folder, $node, $defs, $def, $base);
}
//savb
if ($_GET['sav']) {
save_vars($folder, $node . '_sav', $defs, 1);
}
//create
if ($_GET['create'] && $authorized) {
$prefix = normaliz_c($_POST['prfx']);
$table = normaliz_c($_POST['hbname']);
if ($_POST['hbnb'] && $_POST['hbnb'] != 'version') {
$version = $_POST['hbnb'];
}
if (!$_POST['hbnb']) {
$version = '';
}
if (is_numeric($_POST['nbc'])) {
$defsb['_menus_'] = '';
$nbc = $_POST['nbc'];
$nbc = $nbc > 1 ? $nbc : 1;
for ($i = 1; $i <= $nbc; $i++) {
$defsb['_menus_'][] = 'col_' . $i;
}
} elseif ($defs['_menus_']) {
$defsb['_menus_'] = $defs['_menus_'];
} else {
$defsb['_menus_'] = array('');
}
$node = mnod($prefix, $table, $version);
if ($folder && $prefix) {
read_vars($folder, $node, $defsb);
}
relod(sesm('url') . murl_build('', '', $prefix, $table, $version));
}
#modifs
//save_modif
$do = find_command();
if ($do && $auth >= $ath) {
$defs = msql_modifs($defs, $defsb, $folder, $prefix . '_' . $table, $node, $basename, $do);
}
#render
$lh = sesmk('msqlang');
#-menus
if (!$_GET['def']) {
$ret['menus'] = msql_menus($ra);
}
//auth(3) &&
if (!$_GET['def']) {
//called
#-files
//add
if (auth(4)) {
$ret['fls'] = lkc('txtblc', $lkb . 'new==', pictxt('add', $lh[9][0])) . ' ';
}
if ($table && $authorized && $prefix && $is_file) {
//$defs &&
$ret['fls'] .= lkc('txtx', $lkb . 'sav==', $lh[2][0]) . ' ';
if (is_file($basename . '_sav.php')) {
$ret['fls'] .= lkc('txtx', $lkb . 'restore==', $lh[3][0]) . ' ';
}
$ret['fls'] .= lj_goto('import_defs', 5);
//$ret['fls'].=lj_goto('import_old','');
$ret['fls'] .= lj_goto('import_keys', 17);
$ret['fls'] .= lj_goto('merge_defs', 6);
$ret['fls'] .= lj_goto('append_update', 7);
$ret['fls'] .= lj_goto('append_values', 8);
} else {
$ret['fls'] .= $bckp;
}
if ($files[$prefix] && ($auth > $ath or $prefix == $_SESSION['USE'])) {
if ($auth >= $ath && $table && $prefix && $is_file) {
$ret['fls'] .= lkc('txtx', $lkb . 'del_table==', $lh[10][0]) . ' ';
$ret['fls'] .= ljb('txtblc', 'delfile', $lkb . 'del_file==', $lh[11][0]) . ' ';
//$ret['fls'].=lkc('txtyl',$lkb.'del_file==',$lh[11][0]).' ';
if (!$defs or isset($defs[0])) {
$ret['fls'] .= lkc('txtyl', $lkb . 'repair==', $lh[12][0]) . ' ';
}
}
}
if ($ret['fls']) {
$ret['fls'] .= br();
}
//$ret['fls']=divc('menu',$ret['fls']);
//new
if ($_GET['new']) {
$ret['fls'] .= newbase($base, $prefix, $table, $version);
}
#-util
if ($table && $authorized && $prefix && $is_file) {
$ret['utl'] .= lkc('txtblc', $lkb . 'def=_menus_', $lh[1][0]) . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'reset_menus==', $lh[22][0]) . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'del_menus==', $lh[23][0]) . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'add_keys==', $lh[24][0]) . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'del_keys==', $lh[25][0]) . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'def=_menus_&add_col==', $lh[14][0]) . ' ';
$ret['utl'] .= lj_goto('del_col', 15);
if ($is_file) {
$ret['utl'] .= lkc('txtx" title="' . $lh[13][1], $lkb . 'repair_cols==', $lh[13][0]) . br();
}
if ($base != 'system' && is_file(sesm('root') . 'system/' . $node . '.php')) {
$ret['utl'] .= lkc('txtblc', $lkb . 'update==', $lh[26][0]) . ' ';
}
$ret['utl'] .= lj_goto('sort_table', 19);
if ($table != 'restrictions' && $table != 'params') {
$ret['utl'] .= lkc('txtx', $lkb . 'reorder==', $lh[20][0]) . ' ';
}
$ret['utl'] .= lj_goto('permut', 21);
$ret['utl'] .= lkc('txtx', $lkb . 'edit_conn==', $lh[16][0]) . ' ';
$ret['utl'] .= lkc('txtx" title="' . $lh[6][1], $lkb . 'inject_defs==', $lh[18][0]) . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'edit_csv==', 'csv') . ' ';
$ret['utl'] .= lkc('txtx', $lkb . 'json==', 'json') . ' ';
if (auth(6)) {
$ret['utl'] .= lkc('txtx', $lkb . 'export_mysql==', 'sql') . ' ';
}
if (auth(6)) {
$ret['utl'] .= lkc('txtx', $lkb . 'create_mysql==', 'create mysql') . ' ';
}
$ret['utl'] .= lj('txtx', 'popup_msql___lang_helps_msql', '?');
}
#-fieldset
if ($ret['fls'] . $ret['utl']) {
$ret['utils'] = divc('menu', $ret['fls'] . $ret['utl']);
}
$ret['fls'] = $ret['utl'] = '';
//if($ret['nfo'])$ret['nfo'].=br();
}
//called
#-infos
if ($table && $is_file) {
$ret['nfo'] = lkc('popsav', $lk, $murl) . ' ';
$wurl = $_SERVER['HTTP_HOST'] . '/msql/' . $murl;
$ret['nfo'] .= lj('popbt', 'popup_text___' . ajx($wurl) . '_weburl_console', pictit('link', 'web url'));
$wcon = '[' . $murl . $kdef . ($def ? ':' . $def : '') . ':microsql]';
$ret['nfo'] .= lj('popbt', 'popup_text___' . ajx($wcon) . '_connector_console', pictit('conn', 'connector'));
$ret['nfo'] .= lkt('popbt', '/plug/microxml.php?table=' . $murl, pictit('rss', 'xml')) . ' - ';
$ret['nfo'] .= btn('txtsmall2', count($defs) . ' ' . plurial(count($defs), 116)) . ' - ';
if ($is_file) {
$ret['nfo'] .= btn('txtsmall2', fsize($basename . '.php')) . ' - ';
}
$ret['nfo'] .= btn('txtsmall2', ftime($basename . '.php')) . ' ';
$ret['nfo'] .= msq_search($murl);
}
if ($ret['nfo']) {
$ret['nfo'] = divc('menu', $ret['nfo']);
}
//entries
//if($defs)$ret['edt'].=slctmenuder($defs,$def?$def:'_menus_');
//add
if ($is_file && $authorized && !$_GET['called'] && $defs && !$_GET['def']) {
$ret['edt'] .= divc('menu', f_inp_add($defs, $defsb, $def)) . br();
}
//edit
//echo verbose($ra,'');
if ($def && $defs[$def]) {
$ret['edt'] .= f_inp_m($defs, $defsb['_menus_'], $def);
}
//edit_conn
if ($_GET['edit_conn'] == '=') {
if ($defs) {
foreach ($defs as $k => $v) {
$v = str_replace(array('|', '¬'), array(':BAR:', ':LINE:'), $v);
$edittable .= implode('|', $v) . '¬' . "\n";
}
}
//(!is_numeric($k)?$k.'|':'')
$ret[] = divc('', 'paste a table as created by transductor from html table :: use "|" for cells and "¬" for lines of cells') . form($lkb . 'def=' . $def, txarea('import_conn', $edittable, 60, 14) . br() . checkbox('aid', 'ok', 'auto_increment', '1') . input2('submit', 'save', 'import', 'txtbox')) . hr() . br();
}
//array
if ($_GET['inject_defs'] == '=') {
$datas = str_replace(array('<' . '?php', '?' . '>'), '', read_file($basename . '.php'));
$ret[] = divc('', 'paste $r[1]=array(1,2,3)') . form($lkb, txarea('inject_defs', $datas, 60, 14) . br() . input2('submit', 'replace', 'replace', 'txtbox') . input2('submit', 'inject', 'inject', 'txtbox') . checkbox('mono', '1', 'key=>value', '') . checkbox('sql', '1', 'mysql', '')) . hr() . br();
}
//export_mysql
if ($_GET['create_mysql'] == '=' && auth(6)) {
$ok = plugin_func('mysql', 'import_msql', $defs, $node);
$ret[] = divc('txtalert', 'create table ' . $node . ': ' . $ok);
}
if ($_GET['export_mysql'] == '=' && auth(6)) {
$ret[] = txarea('', mysqlrb($defs), 60, 40);
}
//csv
if ($_GET['edit_csv'] == '=') {
foreach ($defs as $k => $v) {
if ($v) {
$edittable .= $k . ':' . (is_array($v) ? implode(',', $v) : htmlentities($v)) . "\n";
}
}
$ret[] = divc('', 'paste csv using "," for cells and lines for rows') . form($lkb . 'def=' . $def, txarea('edit_csv', $edittable, 60, 14) . br() . checkbox('aid', 'ok', 'auto_increment', '1') . input2('submit', 'save', 'import', 'txtbox')) . hr() . br();
}
//csv
if ($_GET['json'] == '=') {
foreach ($defs as $k => $v) {
if ($v) {
$edittable .= '"' . $k . '":' . (is_array($v) ? '["' . implode('","', $v) . '"]' : '"' . htmlentities($v[0])) . '",';
}
}
$ret[] = txarea('edit_csv', '{' . $edittable, 60, 14) . '}' . br();
}
//see_table
if ($defs && !$_GET['def']) {
// && (!$def or $_POST['save'])//called
$out = divd('editmsql', draw_table($defs, $murl, ''));
$ret[] = $out . br();
} else {
$ret[] = divd('editmsql', '');
}
if ($auth > 6) {
$ret[] = lkc('txtx', $lkb . 'backup_msql==', 'backup') . ' ';
}
if ($_GET['backup_msql']) {
$ret[] = backup_msql();
}
return divd('content', implode('', $ret));
}
