case "Cancel": $sql->query("DROP TABLE `%tree_tmp`"); print "window.location.reload(true);"; exit; case "Save": $ddc = new ddc_key(); $ddc->attach('%tree', $sql); $ddc2 = new ddc_key(); $ddc2->attach('%tree_tmp', $sql); $ddc->gen_changes($ddc2); foreach ($ddc->actions as $i => $r) { print "chse.safe_alert(111,'" . js_escape($r->q) . "');"; } $ddc->apply_changes($sql); $sql->query("DROP TABLE `%tree`"); ddc_gentable_n('%tree', $ddc_tree_structure, $ddc_tree_structure_keys, $sql); $sql->query("INSERT INTO `%tree` SELECT * FROM `%tree_tmp`"); //print "window.location.reload(true);"; exit; case 'del': $q = "DELETE FROM `" . $workingtable . "` WHERE (SELECT `%tree_selections`.selected FROM `%tree_selections` WHERE `" . $workingtable . "`.id=`%tree_selections`.id )=1"; $sql->query($q); //clean up orphans $q = "DELETE FROM `" . $workingtable . "` WHERE (SELECT a.id FROM `" . $workingtable . "` as a WHERE `" . $workingtable . "`.parentid=a.id ) IS NULL"; $sql->query($q); $q = "DELETE FROM `%tree_selections` WHERE (SELECT a.id FROM `" . $workingtable . "` as a WHERE a.id=`%tree_selections`.id ) IS NULL"; $sql->query($q); print 'chse.safe_alert(111,\'' . js_escape($q) . "');"; print "window.location.reload(true);"; exit; break;
<?php set_include_path($_SERVER['DOCUMENT_ROOT']); //$_SESSION['uid']='1000'; //if(preg_match('/^127\.0\..*/',$_SERVER['REMOTE_ADDR']))$_SESSION['uid']='0'; //phpinfo(); //$_SESSION['sql_design']=false; //if($_SESSION['uid']==0)$_SESSION['sql_design']=true; require_once 'lib/auth.php'; require_once 'lib/ddc_meta.php'; require_once 'lib/commctrls.php'; $sql->logquerys = true; if ($_SESSION['sql_design'] == true) { ddc_gentable_n('%dev_list', array(array('id', 'bigint(20)', 0, NULL, 1, NULL), array('name', 'text', 0, NULL, NULL, NULL), array('description', 'text', 0, NULL, NULL, NULL), array('isdone', 'tinyint(1)', 0, 0, NULL, NULL), array('wip', 'tinyint(1)', 0, 0, NULL, NULL), array('mtime', 'timestamp', 1, NULL, NULL, NULL)), array(array('PRIMARY', 'id', NULL)), $sql); ddc_gentable_n('%dev_list_deps', array(array('id', 'bigint(20)', 0, NULL, NULL, NULL), array('depid', 'bigint(20)', 0, NULL, NULL, NULL)), array(array('PRIMARY', 'id', NULL), array('PRIMARY', 'depid', NULL)), $sql); } function gen_text($str) { $r = new dom_statictext(); $r->text = $str; return $r; } class progress_viewer extends dom_div { function __construct() { dom_div::__construct(); $this->etype = 'progress_viewer'; $this->top = new dom_div(); $this->append_child($this->top); if ($_SESSION['uid'] == 0) {
<?php set_include_path($_SERVER['DOCUMENT_ROOT']); session_start(); $_SESSION['focus-state']->keys = $_POST['keys']; $_SESSION['focus-state']->name = $_POST['name']; $_SESSION['focus-state']->oid = $_POST['oid']; exit; require_once 'lib/ddc_meta.php'; require_once 'lib/commctrls.php'; ddc_gentable_n('%backlog', array(array('id', 'bigint(20)', 0, NULL, 1, NULL), array('time', 'timestamp', 0, NULL, NULL, NULL), array('name', 'text(4096)', 0, '', NULL, NULL), array('keys', 'text(40096)', 0, '', NULL, NULL), array('oid', 'text(4096)', 0, '', NULL, NULL)), array(array('PRIMARY', 'id', NULL), array('time', 'time', NULL)), $sql); $q = "insert into `%backlog` set `name`='" . $sql->esc($_POST['name']) . "' , `keys`='" . $sql->esc($_POST['keys']) . "' , `oid`='" . $sql->esc($_POST['oid']) . "'"; $sql->query($q); //$sql->query('delete from `%backlog`'); print "/*" . $q . "*/";
<?php $profiler = microtime(true); require "../etc/dbsettings.php"; require "../sql/my.php"; require "../lib/base_connect.php"; require "../lib/ddc_raw.php"; $testtbl = 'mm'; $sql->query("DROP TABLE `{$testtbl}`"); $sql->query("CREATE TABLE `{$testtbl}` (`id_prod` int(11) NOT NULL auto_increment, `doorname` varchar(255) default NULL, `fillmodel` int(11) default NULL, `filltype` decimal(11,5) unsigned zerofill default NULL comment 'tyutfytuy', `boxtype` varchar(255) default NULL, `sheight` int(11) default NULL, `swidth` int(11) default NULL, `sthickness` int(11) default NULL, `isglass` varchar(5) default NULL, `glassincluded` varchar(5) default NULL, `decoration` varchar(255) default NULL, `glassing` int(11) default NULL, `fillet` int(11) default NULL, `store_rests` double default NULL, `rests_date` datetime NOT NULL default '2007-09-26 00:00:00', `price` double default NULL, `price_currency` char(3) default 'RUR', PRIMARY KEY (`id_prod`,`fillmodel`,`sheight`), key (`doorname`(10)) )"); //$sql->query("CREATE TABLE `$testtbl` (`id_prod` int(11) NOT NULL auto_increment, `doorname` varchar(255) default NULL, `fillmodel` int(11) default NULL, PRIMARY KEY (`id_prod`), key (doorname(10)) )"); // function addcol($name,$type,$null,$default,$extra,$comment) ddc_gentable_n('t1', array(array('id', 'int', 0, NULL, 'auto_increment', NULL), array('t1', 'varchar(100)', 1, NULL, NULL, NULL), array('t2', 'varchar(100)', 1, NULL, NULL, NULL), array('in', 'bigint', 1, NULL, NULL, NULL), array('mf', 'int', 1, NULL, NULL, NULL), array('in2', 'bigint', 1, NULL, NULL, NULL)), array(array('PRIMARY', 'id', NULL), array('1', 't1', 12), array('1', 't2', 12), array('1', 'in', NULL)), $sql); $v1 = new ddc_raw(); $v1->load_table($testtbl, $sql); print "<HTML>"; //$r=$sql->query("SHOW COLUMNS FROM `$testtbl`"); //var_dump($v1->cols); $v1->print_cols(); $v1->print_keys(); //var_dump($v1->keys); //$v1->delcol('doorname');$v1->delcol('fillmodel');$v1->delcol('filltype'); print $v1->create_query('test'); $v2 = new ddc_raw(); $v2->addcol('test', 'varchar(10)', 1, NULL, NULL, NULL); $v2->addcol('test1', 'varchar(10)', 1, NULL, NULL, NULL); $v2->addcol('test2', 'varchar(10)', 1, NULL, NULL, NULL); $v2->addcol('test3', 'varchar(10)', 1, NULL, NULL, NULL); $v2->addcol('id', 'int(10) unsigned auto_increment', 1, NULL, NULL, NULL); $v2->addcol('doorname', 'varchar(10)', 1, NULL, NULL, NULL); $v2->addcol_to_key('PRIMARY', 'id', NULL);