Articles in phpwcms auto expired by December 31, 2010? Then use this script to fix the article kill date (and the historical bug).
<?php | |
/************************************************************************************* | |
Copyright notice | |
(c) 2002-2011 Oliver Georgi (oliver@phpwcms.de) // All rights reserved. | |
This script is part of PHPWCMS. The PHPWCMS web content management system is | |
free software; you can redistribute it and/or modify it under the terms of | |
the GNU General Public License as published by the Free Software Foundation; | |
either version 2 of the License, or (at your option) any later version. | |
The GNU General Public License can be found at http://www.gnu.org/copyleft/gpl.html | |
A copy is found in the textfile GPL.txt and important notices to the license | |
from the author is found in LICENSE.txt distributed with these scripts. | |
This script is distributed in the hope that it will be useful, but WITHOUT ANY | |
WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A | |
PARTICULAR PURPOSE. See the GNU General Public License for more details. | |
This copyright notice MUST APPEAR in all copies of the script! | |
*************************************************************************************/ | |
// Patch to fix the fixed article end date problem | |
/* CP based | |
[PHP] | |
@mysql_query("UPDATE ".DB_PREPEND."phpwcms_article SET article_tstamp=article_tstamp, article_end='2030-12-31 23:59:59' WHERE article_end='2010-12-31 23:59:59' AND article_deleted=0", $GLOBALS['db']); | |
[/PHP] | |
*/ | |
$phpwcms = array(); | |
define( 'ROOT', rtrim( str_replace("\\", '/', dirname(__FILE__) ), '/' ) . '/' ); | |
// newer phpwcms | |
if(is_file(ROOT.'config/phpwcms/conf.inc.php')) { | |
require_once (ROOT.'config/phpwcms/conf.inc.php'); | |
} elseif(is_file(ROOT.'include/inc_conf/conf.inc.php')) { | |
require_once (ROOT.'include/inc_conf/conf.inc.php'); | |
} else { | |
die('SORRY: cannot run the script'); | |
} | |
require_once (ROOT.'include/inc_lib/default.inc.php'); | |
if(!isset($db)) { | |
require_once (PHPWCMS_ROOT.'/include/inc_lib/dbcon.inc.php'); | |
} | |
$sql = "SELECT article_id FROM ".DB_PREPEND."phpwcms_article WHERE article_end='2010-12-31 23:59:59' AND article_deleted=0"; | |
$result = mysql_query($sql, $db); | |
$total = mysql_num_rows($result); | |
echo '<html><head><title>Fix phpwcms fixed article end date</head><body>'; | |
echo '<h1>Update '.$total.' articles with new fixed date</h1>'; | |
$sql = "UPDATE ".DB_PREPEND."phpwcms_article SET "; | |
$sql .= "article_tstamp=article_tstamp, "; // keep article timestamp | |
$sql .= "article_end='2030-12-31 23:59:59' "; | |
$sql .= "WHERE article_end='2010-12-31 23:59:59' AND article_deleted=0"; | |
echo '<p>The following command is used to correct your articles having false fixed article end dates.</p>'; | |
echo '<code>'.$sql.';</code>'; | |
if($total) { | |
@mysql_query($sql, $db); | |
echo '<p><b>Done!</b> Visit your <a href="'.$phpwcms["site"].$phpwcms["root"].'" target="_blank">website</a> and check if all is fine again</p>'; | |
} else { | |
echo '<p><b>Fine!</b> It seems your <a href="'.$phpwcms["site"].$phpwcms["root"].'" target="_blank">website</a> is not touched by the problem (or got fixed).</p>'; | |
} | |
echo '<p><a href="http://forum.phpwcms.org/viewtopic.php?f=3&t=20949">Visit phpwcms forum for more information</a></p>'; | |
echo '<hr /><p>Copyright © 2011 Oliver Georgi, <a href="http://www.phpwcms.de">www.phpwcms.de</a></p></body></html>'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment