getName() == 'table') { $info = TableInfo::fromXML($tabledef); $basename = $info->getName(); $infos[$basename] = $info; } if ($tabledef->getName() == 'view') { $info = ViewInfo::fromXML($tabledef); $basename = $info->getName(); $infos[$basename] = $info; } } unset($info); switch ($STEP) { case 1: echo '

'; if (!$db->tableExists('dirurls')) { // ### CREATE TABLE/VIEW dirurls ### $info = $infos['dirurls']; echo '
• '.$LANG->tr('will_create_table', [$info->getName()])."
\n"; } // ### ALTER TABLE/VIEW menus ### $info = $infos['menus']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • column styles will be added
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW menuitems ### $info = $infos['menuitems']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • column styles will be added
  \n"; echo "
  • column type will be added
  \n"; echo "
  • column instance will be added
  \n"; echo "
  • column viewname will be added
  \n"; echo "
  • column addparm1name will be added
  \n"; echo "
  • column addparm1val will be added
  \n"; echo "
  • column addparm2name will be added
  \n"; echo "
  • column addparm2val will be added
  \n"; echo "
  • column addparm3name will be added
  \n"; echo "
  • column addparm3val will be added
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW menublocks ### $info = $infos['menublocks']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • column class will be renamed to styles
  \n"; echo "
  • column styles will be altered
  \n"; echo "
\n"; } if (!$db->tableExists('accgrpaddons')) { // ### CREATE TABLE/VIEW accgrpaddons ### $info = $infos['accgrpaddons']; echo '
• '.$LANG->tr('will_create_table', [$info->getName()])."
\n"; } if (!$db->tableExists('aclroles')) { // ### CREATE TABLE/VIEW aclroles ### $info = $infos['aclroles']; echo '
• '.$LANG->tr('will_create_table', [$info->getName()])."
\n"; } if (!$db->tableExists('aclrolemembers')) { // ### CREATE TABLE/VIEW aclrolemembers ### $info = $infos['aclrolemembers']; echo '
• '.$LANG->tr('will_create_table', [$info->getName()])."
\n"; } if (!$db->tableExists('sysacls')) { // ### CREATE TABLE/VIEW sysacls ### $info = $infos['sysacls']; echo '
• '.$LANG->tr('will_create_table', [$info->getName()])."
\n"; } // ### ALTER TABLE/VIEW acls ### $info = $infos['acls']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • column role_id will be added
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW acls ### $info = $infos['acls']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • index ids will be removed
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW acls ### $info = $infos['acls']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • index ids will be (re-)created
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW accounts ### $info = $infos['accounts']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('will_mod_table',[$info->getName()])."
  \n"; echo "
  • column cname will be added
  \n"; echo "
  • column title will be added
  \n"; echo "
  • column f_name will be added
  \n"; echo "
  • column m_name will be added
  \n"; echo "
  • column l_name will be added
  \n"; echo "
  • column backendaccess will be added
  \n"; echo "
\n"; } echo '

'; break; case 2: echo '

'; if (!$db->tableExists('dirurls')) { // ### CREATE TABLE/VIEW dirurls ### $info = $infos['dirurls']; echo '
• '.$LANG->tr('create_table', [$info->getName()])." "; try { $db->createTable($info); echo " OK "; } catch (SQLException $e) { echo " Error!
   ".$e->getMessage()."
   ".$e->getQuery(); } echo '
'; } // ### ALTER TABLE/VIEW menus ### $info = $infos['menus']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $col = $info->getColumnInfo('styles'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW menuitems ### $info = $infos['menuitems']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $col = $info->getColumnInfo('styles'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('type'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('instance'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('viewname'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('addparm1name'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('addparm1val'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('addparm2name'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('addparm2val'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('addparm3name'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('addparm3val'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW menublocks ### $info = $infos['menublocks']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $db->table($info)->renameColumn('class','styles'); echo "
  • table ".$info->getName()." renamed column class to styles
  \n"; for ($i = 0; $i < $info->getColumnCount(); $i++) { $col = $info->getColumnInfo($i); if ($col->getName() == 'styles') { $db->table($info->getName())->alterColumn($col->getName(),$col); echo "
  • table ".$info->getName()." altered column ".$col->getName()."
  \n"; } } echo "
\n"; } if (!$db->tableExists('accgrpaddons')) { // ### CREATE TABLE/VIEW accgrpaddons ### $info = $infos['accgrpaddons']; echo '
• '.$LANG->tr('create_table', [$info->getName()])." "; try { $db->createTable($info); echo " OK "; } catch (SQLException $e) { echo " Error!
   ".$e->getMessage()."
   ".$e->getQuery(); } echo '
'; } if (!$db->tableExists('aclroles')) { // ### CREATE TABLE/VIEW aclroles ### $info = $infos['aclroles']; echo '
• '.$LANG->tr('create_table', [$info->getName()])." "; try { $db->createTable($info); echo " OK "; } catch (SQLException $e) { echo " Error!
   ".$e->getMessage()."
   ".$e->getQuery(); } echo '
'; } if (!$db->tableExists('aclrolemembers')) { // ### CREATE TABLE/VIEW aclrolemembers ### $info = $infos['aclrolemembers']; echo '
• '.$LANG->tr('create_table', [$info->getName()])." "; try { $db->createTable($info); echo " OK "; } catch (SQLException $e) { echo " Error!
   ".$e->getMessage()."
   ".$e->getQuery(); } echo '
'; } if (!$db->tableExists('sysacls')) { // ### CREATE TABLE/VIEW sysacls ### $info = $infos['sysacls']; echo '
• '.$LANG->tr('create_table', [$info->getName()])." "; try { $db->createTable($info); echo " OK "; } catch (SQLException $e) { echo " Error!
   ".$e->getMessage()."
   ".$e->getQuery(); } echo '
'; } // ### ALTER TABLE/VIEW acls ### $info = $infos['acls']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $col = $info->getColumnInfo('role_id'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW acls ### $info = $infos['acls']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $db->table($info)->removeIndex('ids'); echo "
  • table ".$info->getName()." index removed ids
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW acls ### $info = $infos['acls']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $db->table($info)->setIndex('ids',['account_id','group_id','role_id']); echo "
  • table ".$info->getName()." index defined ids
  \n"; echo "
\n"; } // ### ALTER TABLE/VIEW accounts ### $info = $infos['accounts']; if ($info instanceof TableInfo) { echo '
• '.$LANG->tr('mod_table',[$info->getName()])."
  \n"; $col = $info->getColumnInfo('cname'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('title'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('f_name'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('m_name'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('l_name'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; $col = $info->getColumnInfo('backendaccess'); if (is_null($col)) throw new \Exception('Missing column definition'); $db->table($info->getName())->addColumn($col); echo "
  • table ".$info->getName()." added column ".$col->getName()."
  \n"; echo "
\n"; } echo '

'; break; }