[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: sitemgr/setup tables_update.inc.php,1.14,1.15
From: |
Michael Totschnig <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: sitemgr/setup tables_update.inc.php,1.14,1.15 |
Date: |
Mon, 23 Jun 2003 16:33:25 -0400 |
Update of /cvsroot/phpgroupware/sitemgr/setup
In directory subversions:/tmp/cvs-serv15263/setup
Modified Files:
tables_update.inc.php
Log Message:
tables_update: maybe it is better to use the oproc object for the update?
sitemgr-site/templates: Ralf's commits to the 16 branch
Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/setup/tables_update.inc.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -r1.14 -r1.15
*** tables_update.inc.php 31 May 2003 16:36:45 -0000 1.14
--- tables_update.inc.php 23 Jun 2003 20:33:22 -0000 1.15
***************
*** 430,442 ****
'uc' => array()
));
- $db2 = $phpgw_setup->db;
//Create default site and hang all existing categories into it
! $db2->query("INSERT INTO phpgw_categories
(cat_parent,cat_owner,cat_access,cat_appname,cat_name,cat_description,last_mod)
VALUES (0,-1,'public','sitemgr','Default Website','This website has been added
by setup',0)");
! $site_id =
$db2->get_last_insert_id('phpgw_categories','cat_id');
! $db2->query("UPDATE phpgw_categories SET cat_main = $site_id
WHERE cat_appname = 'sitemgr'",__LINE__,__FILE__);
! $db2->query("UPDATE phpgw_categories SET cat_parent = $site_id
WHERE cat_appname = 'sitemgr' AND cat_parent = 0 AND cat_id !=
$site_id",__LINE__,__FILE__);
! $db2->query("UPDATE phpgw_categories SET cat_level = cat_level
+1 WHERE cat_appname = 'sitemgr' AND cat_id != $site_id",__LINE__,__FILE__);
! $db2->query("INSERT INTO phpgw_sitemgr_sites
(site_id,site_name) VALUES ($site_id,'Default Website')");
//insert values from old preferences table into new sites table
--- 430,444 ----
'uc' => array()
));
//Create default site and hang all existing categories into it
! $phpgw_setup->oProc->query("INSERT INTO phpgw_categories
(cat_parent,cat_owner,cat_access,cat_appname,cat_name,cat_description,last_mod)
VALUES (0,-1,'public','sitemgr','Default Website','This website has been added
by setup',0)");
! $site_id =
$phpgw_setup->oProc->get_last_insert_id('phpgw_categories','cat_id');
! $phpgw_setup->oProc->query("UPDATE phpgw_categories SET
cat_main = $site_id WHERE cat_appname = 'sitemgr'",__LINE__,__FILE__);
! $phpgw_setup->oProc->query("UPDATE phpgw_categories SET
cat_parent = $site_id WHERE cat_appname = 'sitemgr' AND cat_parent = 0 AND
cat_id != $site_id",__LINE__,__FILE__);
! $phpgw_setup->oProc->query("UPDATE phpgw_categories SET
cat_level = cat_level +1 WHERE cat_appname = 'sitemgr' AND cat_id !=
$site_id",__LINE__,__FILE__);
! $phpgw_setup->oProc->query("INSERT INTO phpgw_sitemgr_sites
(site_id,site_name) VALUES ($site_id,'Default Website')");
!
! $db2 = $phpgw_setup->db;
!
//insert values from old preferences table into new sites table
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: sitemgr/setup tables_update.inc.php,1.14,1.15,
Michael Totschnig <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: sitemgr/sitemgr-site/templates/3D-Fantasy main.tpl,1.4,1.5
- Next by Date:
[Phpgroupware-cvs] CVS: news_admin/inc class.bo.inc.php,1.1.2.1,1.1.2.2 class.boacl.inc.php,1.1.2.1,1.1.2.2 class.so.inc.php,1.1.2.1,1.1.2.2 class.ui.inc.php,1.1.2.1,1.1.2.2
- Previous by thread:
[Phpgroupware-cvs] CVS: sitemgr/sitemgr-site/templates/3D-Fantasy main.tpl,1.4,1.5
- Next by thread:
[Phpgroupware-cvs] CVS: news_admin/inc class.bo.inc.php,1.1.2.1,1.1.2.2 class.boacl.inc.php,1.1.2.1,1.1.2.2 class.so.inc.php,1.1.2.1,1.1.2.2 class.ui.inc.php,1.1.2.1,1.1.2.2
- Index(es):