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