Revision 600
Added by thorn almost 18 years ago
| upgrade-script.php | ||
|---|---|---|
| 473 | 473 |
//Start of upgrade script for the news modul |
| 474 | 474 |
//****************************************************************************** |
| 475 | 475 |
|
| 476 |
echo "<BR><B>Adding new field to database table mod_news_posts</B><BR>"; |
|
| 476 |
echo "<BR><B>Adding new fields to database table mod_news_posts</B><BR>";
|
|
| 477 | 477 |
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_news_posts` ADD `published_when` INT NOT NULL AFTER `commenting`")) {
|
| 478 | 478 |
echo 'Database Field published_when added successfully<br />'; |
| 479 | 479 |
} |
| 480 | 480 |
echo mysql_error().'<br />'; |
| 481 |
if($database->query("ALTER TABLE `".TABLE_PREFIX."mod_news_posts` ADD `published_until` INT NOT NULL AFTER `published_when`")) {
|
|
| 482 |
echo 'Database Field published_until added successfully<br />'; |
|
| 483 |
} |
|
| 484 |
echo mysql_error().'<br />'; |
|
| 481 | 485 |
|
| 482 | 486 |
// UPDATING DATA INTO FIELDS |
| 483 | 487 |
echo "<BR>"; |
Also available in: Unified diff
module news: added publish_until field to control the visibility of a news-posting by date and time