//zu 1.0.8
$mysql = "\n\t\t\t\tALTER TABLE `apx_news` CHANGE `sticky` `sticky` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' ;\n\t\t\t\tUPDATE `apx_news` SET sticky='3000000000' WHERE sticky=1;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 108:
//zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_news');
clearIndices(PRE . '_news_cat');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_news_cat');
//config Update
updateConfig('news', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('news', 'epp', 'int', '', '5', 'VIEW', 1249584889, 1000),\n\t\t\t\t('news', 'archiveepp', 'int', '', '5', 'VIEW', 1249584889, 2000),\n\t\t\t\t('news', 'archiveall', 'switch', '', '0', 'VIEW', 1249584889, 3000),\n\t\t\t\t('news', 'searchepp', 'int', '', '10', 'VIEW', 1249584889, 4000),\n\t\t\t\t('news', 'archivesort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '2', 'VIEW', 1249584889, 5000),\n\t\t\t\t('news', 'archiveentrysort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 'VIEW', 1249584889, 6000),\n\t\t\t\t\n\t\t\t\t('news', 'searchable', 'switch', '', '1', 'OPTIONS', 1249584889, 1000),\n\t\t\t\t('news', 'subcats', 'switch', '', '1', 'OPTIONS', 1249584889, 2000),\n\t\t\t\t('news', 'teaser', 'switch', '', '1', 'OPTIONS', 1249584889, 3000),\n\t\t\t\t('news', 'coms', 'switch', '', '1', 'OPTIONS', 1249584889, 4000),\n\t\t\t\t('news', 'ratings', 'switch', '', '1', 'OPTIONS', 1249584889, 5000),\n\t\t\t\t('news', 'archcoms', 'switch', '', '1', 'OPTIONS', 1249584889, 6000),\n\t\t\t\t('news', 'archratings', 'switch', '', '1', 'OPTIONS', 1249584889, 7000),\n\t\t\t\t('news', 'captcha', 'switch', '', '1', 'OPTIONS', 1249584889, 8000),\n\t\t\t\t('news', 'spamprot', 'int', '', '1', 'OPTIONS', 1249584889, 9000),\n\t\t\t\t('news', 'mailonnew', 'string', '', '', 'OPTIONS', 1249584889, 10000),\n\t\t\t\t\n\t\t\t\t('news', 'newspic_width', 'int', '', '120', 'IMAGES', 1249584889, 1000),\n\t\t\t\t('news', 'newspic_height', 'int', '', '120', 'IMAGES', 1249584889, 2000),\n\t\t\t\t('news', 'newspic_popup', 'switch', '', '1', 'IMAGES', 1249584889, 3000),\n\t\t\t\t('news', 'newspic_popup_width', 'int', '', '640', 'IMAGES', 1249584889, 4000),\n\t\t\t\t('news', 'newspic_popup_height', 'int', '', '480', 'IMAGES', 1249584889, 5000),\n\t\t\t\t('news', 'newspic_quality', 'switch', '', '1', 'IMAGES', 1249584889, 6000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_news_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_news` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allowrating` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_news` ADD INDEX ( `catid` ) ;\n\t\t\t\tALTER TABLE `apx_news` ADD INDEX ( `userid` ) ;\n\t\t\t\tALTER TABLE `apx_news` ADD INDEX ( `starttime` , `endtime` ) ;\n\t\t\t\tALTER TABLE `apx_news_cat` ADD INDEX ( `parents` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_news', PRE . '_news_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_news` ADD `meta_description` TEXT NOT NULL AFTER `galid` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
}
//Zu 1.0.2
$mysql = "\n\t\t\t\tALTER TABLE `apx_links` ADD `broken` INT( 11 ) UNSIGNED NOT NULL AFTER `endtime` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 102:
//Zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_links');
clearIndices(PRE . '_links_cat');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_links_cat');
//config Update
updateConfig('links', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('links', 'epp', 'int', '', '20', 'VIEW', 1249981968, 1000),\n\t\t\t\t('links', 'searchepp', 'string', '', '20', 'VIEW', 1249981881, 2000),\n\t\t\t\t('links', 'catonly', 'switch', '', '1', 'VIEW', 1249981968, 3000),\n\t\t\t\t('links', 'sortby', 'select', 'a:2:{i:1;s:7:\"{TITLE}\";i:2;s:6:\"{DATE}\";}', '1', 'VIEW', 1249981968, 4000),\n\t\t\t\t('links', 'new', 'int', '', '3', 'VIEW', 1249981968, 5000),\n\t\t\t\t\n\t\t\t\t('links', 'searchable', 'switch', '', '1', 'OPTIONS', 1249981968, 1000),\n\t\t\t\t('links', 'coms', 'switch', '', '1', 'OPTIONS', 1249981968, 2000),\n\t\t\t\t('links', 'ratings', 'switch', '', '1', 'OPTIONS', 1249981968, 3000),\n\t\t\t\t('links', 'captcha', 'switch', '', '1', 'OPTIONS', 1249981968, 4000),\n\t\t\t\t('links', 'spamprot', 'int', '', '1', 'OPTIONS', 1249981968, 5000),\n\t\t\t\t('links', 'mailonnew', 'string', '', '', 'OPTIONS', 1249981968, 6000),\n\t\t\t\t('links', 'mailonbroken', 'string', '', '', 'OPTIONS', 1249981968, 7000),\n\t\t\t\t\n\t\t\t\t('links', 'linkpic_width', 'int', '', '120', 'IMAGES', 1249981968, 1000),\n\t\t\t\t('links', 'linkpic_height', 'int', '', '120', 'IMAGES', 1249981968, 2000),\n\t\t\t\t('links', 'linkpic_popup', 'switch', '', '1', 'IMAGES', 1249981968, 3000),\n\t\t\t\t('links', 'linkpic_popup_width', 'int', '', '640', 'IMAGES', 1249981968, 4000),\n\t\t\t\t('links', 'linkpic_popup_height', 'int', '', '480', 'IMAGES', 1249981968, 5000),\n\t\t\t\t('links', 'linkpic_quality', 'switch', '', '1', 'IMAGES', 1249981968, 6000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_links_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_links` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allowrating` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_links` ADD INDEX ( `catid` ) ;\n\t\t\t\tALTER TABLE `apx_links` ADD INDEX ( `userid` ) ;\n\t\t\t\tALTER TABLE `apx_links` ADD INDEX ( `starttime` , `endtime` ) ;\n\t\t\t\tALTER TABLE `apx_links_cat` ADD INDEX ( `parents` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_links', PRE . '_links_tags');
case 110:
//Zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_links` ADD `meta_description` TEXT NOT NULL AFTER `text` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
}
$mysql = "\n\t\t\t\tALTER TABLE `apx_articles` CHANGE `sticky` `sticky` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' ;\n\t\t\t\tUPDATE `apx_articles` SET sticky='3000000000' WHERE sticky=1;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 114:
//zu 1.2.0
//Indizes entfernen
clearIndices(PRE . '_articles');
clearIndices(PRE . '_articles_cat');
clearIndices(PRE . '_articles_pages');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_articles_cat');
//config Update
updateConfig('articles', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('articles', 'epp', 'int', '', '10', 'VIEW', 1165596044, 1000),\n\t\t\t\t('articles', 'searchepp', 'int', '', '10', 'VIEW', 1165596044, 2000),\n\t\t\t\t('articles', 'archiveepp', 'int', '', '10', 'VIEW', 1165596044, 3000),\n\t\t\t\t('articles', 'archiveall', 'switch', '', '0', 'VIEW', 1165596044, 4000),\n\t\t\t\t('articles', 'archivesort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 'VIEW', 1165596044, 5000),\n\t\t\t\t('articles', 'archiveentrysort', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 'VIEW', 1165596044, 6000),\n\t\t\t\t\n\t\t\t\t('articles', 'searchable', 'switch', '', '1', 'OPTIONS', 1165596044, 1000),\n\t\t\t\t('articles', 'subcats', 'switch', '', '1', 'OPTIONS', 1165596044, 2000),\n\t\t\t\t('articles', 'teaser', 'switch', '', '1', 'OPTIONS', 1165596044, 3000),\n\t\t\t\t('articles', 'normalonly', 'switch', '', '1', 'OPTIONS', 1165596044, 4000),\n\t\t\t\t('articles', 'coms', 'switch', '', '1', 'OPTIONS', 1165596044, 5000),\n\t\t\t\t('articles', 'ratings', 'switch', '', '1', 'OPTIONS', 1165596044, 6000),\n\t\t\t\t('articles', 'archcoms', 'switch', '', '1', 'OPTIONS', 1165596044, 7000),\n\t\t\t\t('articles', 'archratings', 'switch', '', '1', 'OPTIONS', 1165596044, 8000),\n\t\t\t\t('articles', 'previews_conclusionpage', 'switch', '', '1', 'OPTIONS', 1165596044, 9000),\n\t\t\t\t('articles', 'reviews_conclusionpage', 'switch', '', '1', 'OPTIONS', 1165596044, 10000),\n\t\t\t\t\n\t\t\t\t('articles', 'custom_preview', 'array', '', 'a:0:{}', 'CUSTOM', 1165596044, 1000),\n\t\t\t\t('articles', 'custom_review', 'array', '', 'a:0:{}', 'CUSTOM', 1165596044, 3000),\n\t\t\t\t('articles', 'ratefields', 'array', '', 'a:0:{}', 'CUSTOM', 1165596044, 4000),\n\t\t\t\t('articles', 'awards', 'array', '', 'a:0:{}', 'CUSTOM', 1165596044, 5000),\n\t\t\t\t\n\t\t\t\t('articles', 'artpic_width', 'int', '', '120', 'IMAGES', 1165596044, 1000),\n\t\t\t\t('articles', 'artpic_height', 'int', '', '120', 'IMAGES', 1165596044, 2000),\n\t\t\t\t('articles', 'artpic_popup', 'switch', '', '1', 'IMAGES', 1165596044, 3000),\n\t\t\t\t('articles', 'artpic_popup_width', 'int', '', '640', 'IMAGES', 1165596044, 4000),\n\t\t\t\t('articles', 'artpic_popup_height', 'int', '', '480', 'IMAGES', 1165596044, 5000),\n\t\t\t\t('articles', 'picwidth', 'int', '', '640', 'IMAGES', 1165596044, 6000),\n\t\t\t\t('articles', 'picheight', 'int', '', '480', 'IMAGES', 1165596044, 7000),\n\t\t\t\t('articles', 'watermark', 'string', '', '', 'IMAGES', 1165596044, 8000),\n\t\t\t\t('articles', 'watermark_transp', 'int', '', '50', 'IMAGES', 1165596044, 9000),\n\t\t\t\t('articles', 'watermark_position', 'select', 'a:9:{i:1;s:18:\"{POSTOP} {POSLEFT}\";i:2;s:20:\"{POSTOP} {POSCENTER}\";i:3;s:19:\"{POSTOP} {POSRIGHT}\";i:4;s:21:\"{POSMIDDLE} {POSLEFT}\";i:5;s:23:\"{POSMIDDLE} {POSCENTER}\";i:6;s:22:\"{POSMIDDLE} {POSRIGHT}\";i:7;s:21:\"{POSBOTTOM} {POSLEFT}\";i:8;s:23:\"{POSBOTTOM} {POSCENTER}\";i:9;s:22:\"{POSBOTTOM} {POSRIGHT}\";}', '9', 'IMAGES', 1165596044, 10000),\n\t\t\t\t('articles', 'thumbwidth', 'int', '', '120', 'IMAGES', 1165596044, 11000),\n\t\t\t\t('articles', 'thumbheight', 'int', '', '90', 'IMAGES', 1165596044, 12000),\n\t\t\t\t('articles', 'popup_addwidth', 'int', '', '60', 'IMAGES', 1165596044, 13000),\n\t\t\t\t('articles', 'popup_addheight', 'int', '', '150', 'IMAGES', 1165596044, 14000),\n\t\t\t\t('articles', 'popup_resizeable', 'switch', '', '1', 'IMAGES', 1165596044, 15000),\n\t\t\t\t('articles', 'artpic_quality', 'switch', '', '1', 'IMAGES', 1165596044, 16000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_articles_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_articles` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allowrating` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_articles` ADD INDEX (`userid`) ;\n\t\t\t\tALTER TABLE `apx_articles` ADD INDEX (`catid`) ;\n\t\t\t\tALTER TABLE `apx_articles` ADD INDEX (`starttime`,`endtime`) ;\n\t\t\t\tALTER TABLE `apx_articles_cat` ADD INDEX ( `parents` ) ;\n\t\t\t\tALTER TABLE `apx_articles_pages` ADD INDEX ( `artid` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_articles', PRE . '_articles_tags');
case 120:
//zu 1.2.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_articles` ADD `meta_description` TEXT NOT NULL AFTER `teaser` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
}
case 104:
//zu 1.0.4
//Indizes entfernen
clearIndices(PRE . '_gallery');
clearIndices(PRE . '_gallery_pics');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_gallery');
//config Update
updateConfig('gallery', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('gallery', 'potw_time', 'int', 'BLOCK', '1249981414', '', 0, 0),\n\t\t\t\t\n\t\t\t\t('gallery', 'listepp', 'int', '', '5', 'VIEW', 1249816805, 1000),\n\t\t\t\t('gallery', 'galepp', 'int', '', '16', 'VIEW', 1249816805, 2000),\n\t\t\t\t('gallery', 'ordergal', 'select', 'a:3:{i:1;s:11:\"{ORDERTIME}\";i:2;s:12:\"{ORDERTITLE}\";i:3;s:12:\"{ORDERADMIN}\";}', '1', 'VIEW', 1249816805, 3000),\n\t\t\t\t('gallery', 'orderpics', 'select', 'a:2:{i:1;s:10:\"{NEWFIRST}\";i:2;s:10:\"{OLDFIRST}\";}', '1', 'VIEW', 1249816805, 4000),\n\t\t\t\t('gallery', 'new', 'int', '', '3', 'VIEW', 1249816805, 5000),\n\t\t\t\t\n\t\t\t\t('gallery', 'searchable', 'switch', '', '1', 'OPTIONS', 1249816805, 1000),\n\t\t\t\t('gallery', 'subgals', 'switch', '', '1', 'OPTIONS', 1249816805, 2000),\n\t\t\t\t('gallery', 'coms', 'switch', '', '1', 'OPTIONS', 1249816805, 3000),\n\t\t\t\t('gallery', 'galcoms', 'switch', '', '1', 'OPTIONS', 1249816805, 3000),\n\t\t\t\t('gallery', 'ratings', 'switch', '', '1', 'OPTIONS', 1249816805, 4000),\n\t\t\t\t('gallery', 'potw_auto', 'switch', '', '0', 'OPTIONS', 1249816805, 5000),\n\t\t\t\t\n\t\t\t\t('gallery', 'addpics', 'int', '', '10', 'IMAGES', 1249816805, 1000),\n\t\t\t\t('gallery', 'picwidth', 'int', '', '640', 'IMAGES', 1249816805, 2000),\n\t\t\t\t('gallery', 'picheight', 'int', '', '480', 'IMAGES', 1249816805, 3000),\n\t\t\t\t('gallery', 'watermark', 'string', '', '', 'IMAGES', 1249816805, 4000),\n\t\t\t\t('gallery', 'watermark_transp', 'int', '', '50', 'IMAGES', 1249816805, 5000),\n\t\t\t\t('gallery', 'watermark_position', 'select', 'a:9:{i:1;s:18:\"{POSTOP} {POSLEFT}\";i:2;s:20:\"{POSTOP} {POSCENTER}\";i:3;s:19:\"{POSTOP} {POSRIGHT}\";i:4;s:21:\"{POSMIDDLE} {POSLEFT}\";i:5;s:23:\"{POSMIDDLE} {POSCENTER}\";i:6;s:22:\"{POSMIDDLE} {POSRIGHT}\";i:7;s:21:\"{POSBOTTOM} {POSLEFT}\";i:8;s:23:\"{POSBOTTOM} {POSCENTER}\";i:9;s:22:\"{POSBOTTOM} {POSRIGHT}\";}', '9', 'IMAGES', 1249816805, 6000),\n\t\t\t\t('gallery', 'thumbwidth', 'int', '', '120', 'IMAGES', 1249816805, 7000),\n\t\t\t\t('gallery', 'thumbheight', 'int', '', '90', 'IMAGES', 1249816805, 8000),\n\t\t\t\t('gallery', 'quality_resize', 'switch', '', '1', 'IMAGES', 1249816805, 9000),\n\t\t\t\t('gallery', 'popup', 'switch', '', '1', 'IMAGES', 1249816805, 10000),\n\t\t\t\t('gallery', 'popup_addwidth', 'int', '', '60', 'IMAGES', 1249816805, 12000),\n\t\t\t\t('gallery', 'popup_addheight', 'int', '', '150', 'IMAGES', 1249816805, 13000),\n\t\t\t\t('gallery', 'popup_resizeable', 'switch', '', '1', 'IMAGES', 1249816805, 14000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_gallery_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_gallery` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allowcoms` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_gallery` ADD INDEX ( `parents` ) ;\n\t\t\t\tALTER TABLE `apx_gallery` ADD INDEX ( `starttime` , `endtime` , `parents` ) ;\n\t\t\t\tALTER TABLE `apx_gallery_pics` ADD INDEX ( `galid`, `active` ) ;\n\t\t\t\tALTER TABLE `apx_gallery_pics` ADD INDEX ( `active` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_gallery', PRE . '_gallery_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_gallery` ADD `meta_description` TEXT NOT NULL AFTER `description` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tALTER TABLE `apx_gallery` ADD `lastupdate` INT( 10 ) UNSIGNED NOT NULL AFTER `endtime` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_glossar` ADD `spelling` TINYTEXT NOT NULL AFTER `title` ;\n\t\t\t\tINSERT INTO `apx_config` VALUES ('glossar', 'highlight', 'switch', '', '', '0', '300');\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 101:
//zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_glossar');
//config Update
updateConfig('glossar', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('glossar', 'searchable', 'switch', '', '1', '', 1181326815, 1000),\n\t\t\t\t('glossar', 'epp', 'int', '', '0', '', 1181326815, 2000),\n\t\t\t\t('glossar', 'highlight', 'switch', '', '0', '', 1181326815, 3000),\n\t\t\t\t('glossar', 'coms', 'switch', '', '1', '', 1181326815, 4000),\n\t\t\t\t('glossar', 'ratings', 'switch', '', '1', '', 1181326815, 5000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_glossar_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_glossar` ADD INDEX ( `catid` , `starttime` ) ;\n\t\t\t\tALTER TABLE `apx_glossar` ADD INDEX ( `starttime` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_glossar', PRE . '_glossar_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_glossar` ADD `meta_description` TEXT NOT NULL AFTER `text` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
}
$db->query($query);
}
case 103:
//zu 1.0.4
$mysql = "\n\t\t\t\tALTER TABLE `apx_poll_iplog` ADD `userid` INT( 11 ) UNSIGNED NOT NULL AFTER `id` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 104:
//zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_poll');
//config Update
updateConfig('poll', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('poll', 'maxfirst', 'switch', '', '1', 'VIEW', 1164754067, 1000),\n\t\t\t\t('poll', 'archall', 'switch', '', '1', 'VIEW', 1164754067, 2000),\n\t\t\t\t('poll', 'barmaxwidth', 'int', '', '0', 'VIEW', 1164754067, 3000),\n\t\t\t\t('poll', 'percentdigits', 'int', '', '1', 'VIEW', 1164754067, 4000),\n\t\t\t\t\n\t\t\t\t('poll', 'searchable', 'switch', '', '1', 'OPTIONS', 1164754067, 5000),\n\t\t\t\t('poll', 'coms', 'switch', '', '1', 'OPTIONS', 1164754067, 6000),\n\t\t\t\t('poll', 'archcoms', 'switch', '', '1', 'OPTIONS', 1164754067, 7000),\n\t\t\t\t('poll', 'archvote', 'switch', '', '0', 'OPTIONS', 1164754067, 8000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_poll_tags` (\n\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_poll_iplog` CHANGE `ip` `ip` INT( 11 ) UNSIGNED NOT NULL ;\n\t\t\t\tTRUNCATE TABLE `apx_poll_iplog` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_poll` ADD INDEX ( `starttime` , `endtime` ) ;\n\t\t\t\tALTER TABLE `apx_poll_iplog` ADD INDEX ( `id` , `time` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_poll', PRE . '_poll_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_poll` ADD `meta_description` TEXT NOT NULL AFTER `question` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
}
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Media anpassen
$data = $db->fetch("SELECT id, type, media, systems FROM " . PRE . "_products");
if (count($data)) {
foreach ($data as $res) {
$db->query("UPDATE " . PRE . "_products SET media='|" . $res['media'] . "|', systems='" . dash_serialize(unserialize($res['media'])) . "' WHERE id='" . $res['id'] . "' LIMIT 1");
if (in_array($res['type'], array('software', 'book', 'music'))) {
$db->query("UPDATE " . PRE . "_products_releases SET system='" . $res['media'] . "' WHERE prodid='" . $res['id'] . "'");
}
}
}
//Tags erzeugen
transformKeywords(PRE . '_products', PRE . '_products_tags');
case 110:
//zu 1.1.1
//Indizes entfernen
clearIndices(PRE . '_products');
clearIndices(PRE . '_products_groups');
clearIndices(PRE . '_products_releases');
clearIndices(PRE . '_products_units');
$mysql = "\n\t\t\t\tALTER TABLE `apx_products` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allowrating` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_products` ADD INDEX ( `type` ) ;\n\t\t\t\tALTER TABLE `apx_products` ADD INDEX ( `active` ) ;\n\t\t\t\tALTER TABLE `apx_products_groups` ADD INDEX ( `grouptype` ) ;\n\t\t\t\tALTER TABLE `apx_products_groups` ADD INDEX ( `type` ) ;\n\t\t\t\tALTER TABLE `apx_products_releases` ADD INDEX ( `prodid` ) ;\n\t\t\t\tALTER TABLE `apx_products_releases` ADD INDEX ( `stamp` ) ;\n\t\t\t\tALTER TABLE `apx_products_units` ADD INDEX ( `type` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'manu_searchepp', 'int', '', '20', 'VIEW', '0', '2500');\n\t\t\t\tINSERT INTO `apx_config` VALUES ('products', 'searchepp', 'int', '', '20', 'VIEW', '0', '3500');\n\t\t\t";
case 108:
//zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_downloads');
clearIndices(PRE . '_downloads_cat');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_downloads_cat');
//config Update
updateConfig('downloads', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('downloads', 'epp', 'int', '', '20', 'VIEW', 1249981881, 1000),\n\t\t\t\t('downloads', 'searchepp', 'string', '', '20', 'VIEW', 1249981881, 2000),\n\t\t\t\t('downloads', 'catonly', 'switch', '', '1', 'VIEW', 1249981881, 3000),\n\t\t\t\t('downloads', 'sortby', 'select', 'a:2:{i:1;s:7:\"{TITLE}\";i:2;s:6:\"{DATE}\";}', '1', 'VIEW', 1249981881, 4000),\n\t\t\t\t('downloads', 'new', 'int', '', '3', 'VIEW', 1249981881, 5000),\n\t\t\t\t\n\t\t\t\t('downloads', 'searchable', 'switch', '', '1', 'OPTIONS', 1249981881, 1000),\n\t\t\t\t('downloads', 'regonly', 'switch', '', '0', 'OPTIONS', 1249981881, 2000),\n\t\t\t\t('downloads', 'maxtraffic', 'float', '', '0', 'OPTIONS', 1249981881, 3000),\n\t\t\t\t('downloads', 'exttraffic', 'switch', '', '0', 'OPTIONS', 1249981881, 4000),\n\t\t\t\t('downloads', 'mirrorstats', 'switch', '', '1', 'OPTIONS', 1301669229, 4500),\n\t\t\t\t('downloads', 'coms', 'switch', '', '1', 'OPTIONS', 1249981881, 5000),\n\t\t\t\t('downloads', 'ratings', 'switch', '', '1', 'OPTIONS', 1249981881, 6000),\n\t\t\t\t('downloads', 'captcha', 'switch', '', '1', 'OPTIONS', 1249981881, 7000),\n\t\t\t\t('downloads', 'spamprot', 'int', '', '0', 'OPTIONS', 1249981881, 8000),\n\t\t\t\t('downloads', 'mailonnew', 'string', '', '', 'OPTIONS', 1249981881, 9000),\n\t\t\t\t('downloads', 'mailonbroken', 'string', '', '', 'OPTIONS', 1249981881, 10000),\n\t\t\t\t\n\t\t\t\t('downloads', 'addpics', 'int', '', '5', 'IMAGES', 1249981881, 1000),\n\t\t\t\t('downloads', 'picwidth', 'int', '', '640', 'IMAGES', 1249981881, 2000),\n\t\t\t\t('downloads', 'picheight', 'int', '', '480', 'IMAGES', 1249981881, 3000),\n\t\t\t\t('downloads', 'watermark', 'string', '', '', 'IMAGES', 1249981881, 4000),\n\t\t\t\t('downloads', 'watermark_transp', 'int', '', '50', 'IMAGES', 1249981881, 5000),\n\t\t\t\t('downloads', 'watermark_position', 'select', 'a:9:{i:1;s:18:\"{POSTOP} {POSLEFT}\";i:2;s:20:\"{POSTOP} {POSCENTER}\";i:3;s:19:\"{POSTOP} {POSRIGHT}\";i:4;s:21:\"{POSMIDDLE} {POSLEFT}\";i:5;s:23:\"{POSMIDDLE} {POSCENTER}\";i:6;s:22:\"{POSMIDDLE} {POSRIGHT}\";i:7;s:21:\"{POSBOTTOM} {POSLEFT}\";i:8;s:23:\"{POSBOTTOM} {POSCENTER}\";i:9;s:22:\"{POSBOTTOM} {POSRIGHT}\";}', '9', 'IMAGES', 1249981881, 6000),\n\t\t\t\t('downloads', 'thumbwidth', 'int', '', '120', 'IMAGES', 1249981881, 7000),\n\t\t\t\t('downloads', 'thumbheight', 'int', '', '90', 'IMAGES', 1249981881, 8000),\n\t\t\t\t('downloads', 'quality_resize', 'switch', '', '1', 'IMAGES', 1249981881, 9000);\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_downloads` ADD INDEX ( `catid` ) ;\n\t\t\t\tALTER TABLE `apx_downloads` ADD INDEX ( `userid` ) ;\n\t\t\t\tALTER TABLE `apx_downloads` ADD INDEX ( `starttime` , `endtime` ) ;\n\t\t\t\tALTER TABLE `apx_downloads_cat` ADD INDEX ( `parents` ) ;\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_downloads_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_downloads` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allowrating` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_downloads', PRE . '_downloads_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_downloads` ADD `meta_description` TEXT NOT NULL AFTER `text` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('downloads', 'mirrorstats', 'switch', '', '1', 'OPTIONS', 1301669229, 4500);\n\t\t\t\tALTER TABLE `apx_downloads` ADD `format` TINYTEXT NOT NULL AFTER `filesize` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
case 102:
//zu 1.1.0
//Indizes entfernen
clearIndices(PRE . '_calendar_cat');
clearIndices(PRE . '_calendar_events');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_calendar_cat');
//config Update
updateConfig('calendar', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('calendar', 'eventdays', 'int', '', '7', 'VIEW', 1219685244, 1000),\n\t\t\t\t('calendar', 'searchepp', 'int', '', '20', 'VIEW', 1219685244, 2000),\n\t\t\t\t('calendar', 'sortby', 'select', 'a:2:{i:1;s:13:\"{SORTBY_TIME}\";i:2;s:14:\"{SORTBY_TITLE}\";}', '1', 'VIEW', 1219685244, 3000),\n\t\t\t\t\n\t\t\t\t('calendar', 'searchable', 'switch', '', '1', 'OPTIONS', 1219685244, 1000),\n\t\t\t\t('calendar', 'subcats', 'switch', '', '1', 'OPTIONS', 1219685244, 2000),\n\t\t\t\t('calendar', 'userevents', 'switch', '', '1', 'OPTIONS', 1219685244, 3000),\n\t\t\t\t('calendar', 'captcha', 'switch', '', '1', 'OPTIONS', 1219685244, 4000),\n\t\t\t\t('calendar', 'mailonnew', 'string', '', '', 'OPTIONS', 1219685244, 5000),\n\t\t\t\t('calendar', 'coms', 'switch', '', '1', 'OPTIONS', 1219685244, 6000),\n\t\t\t\t('calendar', 'note', 'switch', '', '1', 'OPTIONS', 1219685244, 7000),\n\t\t\t\t\n\t\t\t\t('calendar', 'pic_width', 'int', '', '120', 'IMAGES', 1219685244, 1000),\n\t\t\t\t('calendar', 'pic_height', 'int', '', '120', 'IMAGES', 1219685244, 2000),\n\t\t\t\t('calendar', 'pic_popup', 'switch', '', '1', 'IMAGES', 1219685244, 3000),\n\t\t\t\t('calendar', 'pic_popup_width', 'int', '', '640', 'IMAGES', 1219685244, 4000),\n\t\t\t\t('calendar', 'pic_popup_height', 'int', '', '480', 'IMAGES', 1219685244, 5000),\n\t\t\t\t('calendar', 'pic_quality', 'switch', '', '1', 'IMAGES', 1219685244, 6000);\n\t\t\t");
$mysql = "\n\t\t\t\tCREATE TABLE `apx_calendar_tags` (\n\t\t\t\t\t`id` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`tagid` INT( 11 ) UNSIGNED NOT NULL ,\n\t\t\t\t\tPRIMARY KEY ( `id` , `tagid` )\n\t\t\t\t) ENGINE=MyISAM;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `restricted` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `allownote` ;\n\t\t\t\t\n\t\t\t\tALTER TABLE `apx_calendar_cat` ADD INDEX ( `parents` ) ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD INDEX ( `catid` ) ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD INDEX ( `userid` ) ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD INDEX ( `active` ) ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD INDEX ( `startday` , `endday`, `starttime`,`endtime` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
//Tags erzeugen
transformKeywords(PRE . '_calendar_events', PRE . '_calendar_tags');
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_calendar_events` CHANGE `active` `active` INT( 11 ) UNSIGNED NOT NULL ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 111:
//zu 1.1.2
$mysql = "\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `meta_description` TEXT NOT NULL AFTER `text` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 112:
