$db->query($query);
}
case 101:
//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);
$db->query($query);
}
case 103:
//zu 1.0.4
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('gallery', 'galcoms', 'switch', '', '0', '1152120685', '2050');\n\t\t\t\tALTER TABLE `apx_gallery` ADD `allowcoms` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `searchable` ;\n\t\t\t\tUPDATE `apx_gallery` SET allowcoms=1;\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);
$db->query("INSERT INTO " . PRE . "_config VALUES ('news', 'searchepp', 'int', '', '10', '0', '1630');");
}
case 107:
//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);
}
} elseif (SETUPMODE == 'update') {
switch ($installed_version) {
case 100:
//zu 1.0.1
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` ( `module` , `varname` , `type` , `addnl` , `value` , `lastchange` , `ord` ) VALUES ('faq', 'searchable', 'switch', '', '1', '0', '50');\n\t\t\t\tALTER TABLE `apx_faq` ADD `searchable` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `starttime` ;\n\t\t\t\tUPDATE `apx_faq` SET starttime=addtime;\n\t\t\t\tUPDATE `apx_faq` SET searchable='1';\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 . '_faq');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_faq');
//config Update
updateConfig('faq', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('faq', 'searchable', 'switch', '', '1', '', 0, 1000);\n\t\t\t");
$mysql = "\n\t\t\t\tALTER TABLE `apx_faq` ADD INDEX ( `parents` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 110:
//zu 1.1.1
$mysql = "\n\t\t\t\tALTER TABLE `apx_faq` ADD `meta_description` TEXT NOT NULL AFTER `answer` ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
}
}
case 113:
//zu 1.1.4
$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 100:
//zu 1.0.1
//zu 1.0.1
case 101:
//zu 1.0.2
$mysql = "\n\t\t\t\tALTER TABLE `apx_navi` ADD `link_popup` TINYINT( 1 ) UNSIGNED NOT NULL AFTER `link` ;\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 . '_navi');
//Tabellenformat ändern
convertRecursiveTable(PRE . '_navi');
//config Update
updateConfig('navi', "\n\t\t\t\tINSERT INTO `apx_config` (`module`, `varname`, `type`, `addnl`, `value`, `tab`, `lastchange`, `ord`) VALUES\n\t\t\t\t('navi', 'groups', 'array', 'BLOCK', 'a:5:{i:1;s:12:\"Navigation 1\";i:2;s:12:\"Navigation 2\";i:3;s:12:\"Navigation 3\";i:4;s:12:\"Navigation 4\";i:5;s:12:\"Navigation 5\";}', '', 0, 0);\n\t\t\t");
$mysql = "\n\t\t\t\tALTER TABLE `apx_navi` ADD INDEX ( `parents` ) ;\n\t\t\t";
$queries = split_sql($mysql);
foreach ($queries as $query) {
$db->query($query);
}
case 110:
//zu 1.1.1
//Navigation 2 erzeugen
list($check) = $db->first("SELECT id FROM " . PRE . "_navi WHERE nid='2' LIMIT 1");
if ($check && !isset($set['navi']['groups'][2])) {
$set['navi']['groups'][2] = 'Navigation 2';
$db->query("UPDATE " . PRE . "_config SET value='" . addslashes(serialize($set['navi']['groups'])) . "' WHERE module='navi' AND varname='groups' LIMIT 1");
}
$db->query($query);
}
case 107:
//zu 1.0.8
$mysql = "\n\t\t\t\tUPDATE `apx_config` SET type='switch' WHERE module='downloads' AND varname='exttraffic';\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 . '_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 101:
//zu 1.0.2
$mysql = "\n\t\t\t\tINSERT INTO `apx_config` VALUES ('calendar', 'searchepp', 'int', '', '20', '0', '150');\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `location_link` TINYTEXT NOT NULL AFTER `location` ;\n\t\t\t\tALTER TABLE `apx_calendar_events` ADD `links` TEXT NOT NULL AFTER `galid` ;\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 . '_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);
