diff options
| author | Simon Rettberg | 2019-05-28 17:57:29 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2019-06-25 10:17:22 +0200 |
| commit | f31b474e1f720e94b37cfedfe0febe453284f158 (patch) | |
| tree | 7aa8b6c329e3d4dfa474e9c6ff403c3db970652c /modules-available/news/install.inc.php | |
| parent | [dnbd3] Put proxies from other locations into SLX_DNBD3_FALLBACK (diff) | |
| download | slx-admin-f31b474e1f720e94b37cfedfe0febe453284f158.tar.gz slx-admin-f31b474e1f720e94b37cfedfe0febe453284f158.tar.xz slx-admin-f31b474e1f720e94b37cfedfe0febe453284f158.zip | |
[news] Modularize; add 'login-news' category
TODO: Use date/time picker for expire time
Diffstat (limited to 'modules-available/news/install.inc.php')
| -rw-r--r-- | modules-available/news/install.inc.php | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/modules-available/news/install.inc.php b/modules-available/news/install.inc.php index e5e52256..43336290 100644 --- a/modules-available/news/install.inc.php +++ b/modules-available/news/install.inc.php @@ -23,14 +23,26 @@ if (tableExists('news')) { $res[] = tableCreate('vmchooser_pages', " `newsid` int(10) unsigned NOT NULL AUTO_INCREMENT, `dateline` int(10) unsigned NOT NULL, + `expires` int(10) unsigned NOT NULL, `title` varchar(200) DEFAULT NULL, `content` text, `type` varchar(10), PRIMARY KEY (`newsid`), - KEY `type` (`type`, `dateline`) + KEY `type` (`type`, `dateline`), + KEY `all3` (`type`, `expires`, `dateline`) "); -Database::exec('ALTER TABLE vmchooser_pages DROP KEY `dateline`, ADD KEY `type` (`type`, `dateline`)'); +if (tableHasIndex('vmchooser_pages', ['dateline'])) { + Database::exec('ALTER TABLE vmchooser_pages DROP KEY `dateline`'); + Database::exec('ALTER TABLE vmchooser_pages ADD KEY `type` (`type`, `dateline`)'); +} +if (!tableHasIndex('vmchooser_pages', ['type', 'expires', 'dateline'])) { + Database::exec('ALTER TABLE vmchooser_pages ADD KEY `all3` (`type`, `expires`, `dateline`)'); +} +if (!tableHasColumn('vmchooser_pages', 'expires')) { + Database::exec('ALTER TABLE vmchooser_pages ADD COLUMN `expires` int(10) unsigned NOT NULL AFTER `dateline`'); + Database::exec('UPDATE vmchooser_pages SET expires = dateline + 86400 * 3650 WHERE expires = 0'); // ~10 Years +} // Create response for browser |