Revision 1866
Added by Dietmar almost 12 years ago
upgrade.php | ||
---|---|---|
1 | 1 |
<?php |
2 | 2 |
/** |
3 |
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER. |
|
3 | 4 |
* |
4 |
* @category modules |
|
5 |
* @package news |
|
6 |
* @subpackage upgrade |
|
7 |
* @copyright 2009-2012, WebsiteBaker Org. e.V. |
|
8 |
* @link http://www.websitebaker2.org/ |
|
9 |
* @license http://www.gnu.org/licenses/gpl.html |
|
10 |
* @platform WebsiteBaker 2.8.x |
|
11 |
* @requirements PHP 5.2.2 and higher |
|
12 |
* @version $Id$ |
|
13 |
* @filesource $HeadURL$ |
|
14 |
* @lastmodified $Date$ |
|
5 |
* This program is free software: you can redistribute it and/or modify |
|
6 |
* it under the terms of the GNU General Public License as published by |
|
7 |
* the Free Software Foundation, either version 3 of the License, or |
|
8 |
* (at your option) any later version. |
|
15 | 9 |
* |
10 |
* This program is distributed in the hope that it will be useful, |
|
11 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of |
|
12 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|
13 |
* GNU General Public License for more details. |
|
14 |
* |
|
15 |
* You should have received a copy of the GNU General Public License |
|
16 |
* along with this program. If not, see <http://www.gnu.org/licenses/>. |
|
16 | 17 |
*/ |
17 | 18 |
|
19 |
/** |
|
20 |
* upgrade.php |
|
21 |
* |
|
22 |
* @category Module |
|
23 |
* @package Module_news |
|
24 |
* @subpackage upgrade |
|
25 |
* @author Dietmar Wöllbrink <dietmar.woellbrink@websitebaker.org> |
|
26 |
* @author Werner v.d.Decken <wkl@isteam.de> |
|
27 |
* @copyright Werner v.d.Decken <wkl@isteam.de> |
|
28 |
* @license http://www.gnu.org/licenses/gpl.html GPL License |
|
29 |
* @version 0.0.1 |
|
30 |
* @revision $Revision$ |
|
31 |
* @link $HeadURL$ |
|
32 |
* @lastmodified $Date$ |
|
33 |
* @since File available since 17.01.2013 |
|
34 |
* @description xyz |
|
35 |
* |
|
36 |
*/ |
|
37 |
|
|
18 | 38 |
/* -------------------------------------------------------- */ |
19 | 39 |
// Must include code to stop this file being accessed directly |
20 | 40 |
require_once( dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php'); |
... | ... | |
26 | 46 |
function mod_news_Upgrade() |
27 | 47 |
{ |
28 | 48 |
global $database, $admin, $MESSAGE,$bDebugModus; |
29 |
$msg = array();
|
|
49 |
$msg = array();
|
|
30 | 50 |
$callingScript = $_SERVER["SCRIPT_NAME"]; |
31 | 51 |
// check if upgrade startet by upgrade-script to echo a message |
32 | 52 |
$tmp = 'upgrade-script.php'; |
33 | 53 |
$globalStarted = substr_compare($callingScript, $tmp,(0-strlen($tmp)),strlen($tmp)) === 0; |
34 |
/**
|
|
35 |
* check database engine
|
|
36 |
*/
|
|
37 |
$aTable = array('mod_news_posts','mod_news_groups','mod_news_comments','mod_news_settings');
|
|
38 |
for($x=0; $x<sizeof($aTable);$x++) {
|
|
39 |
if(($sOldType = $database->getTableEngine(TABLE_PREFIX.$aTable[$x]))) {
|
|
40 |
if(('myisam' != strtolower($sOldType))) {
|
|
41 |
if(!$database->query('ALTER TABLE `'.TABLE_PREFIX.$aTable[$x].'` Engine = \'MyISAM\' ')) {
|
|
42 |
$msg[] = $database->get_error();
|
|
43 |
} else{
|
|
44 |
$msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` changed to Engine = \'MyISAM\'';
|
|
45 |
}
|
|
46 |
} else {
|
|
47 |
$msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` has Engine = \'MyISAM\'';
|
|
48 |
}
|
|
49 |
} else {
|
|
50 |
$msg[] = $database->get_error();
|
|
51 |
}
|
|
52 |
}
|
|
54 |
/**
|
|
55 |
* check database engine
|
|
56 |
*/
|
|
57 |
$aTable = array('mod_news_posts','mod_news_groups','mod_news_comments','mod_news_settings');
|
|
58 |
for($x=0; $x<sizeof($aTable);$x++) {
|
|
59 |
if(($sOldType = $database->getTableEngine(TABLE_PREFIX.$aTable[$x]))) {
|
|
60 |
if(('myisam' != strtolower($sOldType))) {
|
|
61 |
if(!$database->query('ALTER TABLE `'.TABLE_PREFIX.$aTable[$x].'` Engine = \'MyISAM\' ')) {
|
|
62 |
$msg[] = $database->get_error();
|
|
63 |
} else{
|
|
64 |
$msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` changed to Engine = \'MyISAM\'';
|
|
65 |
}
|
|
66 |
} else {
|
|
67 |
$msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` has Engine = \'MyISAM\'';
|
|
68 |
}
|
|
69 |
} else {
|
|
70 |
$msg[] = $database->get_error();
|
|
71 |
}
|
|
72 |
}
|
|
53 | 73 |
|
54 |
|
|
55 | 74 |
$sPagesPath = WB_PATH.PAGES_DIRECTORY; |
56 | 75 |
$sPostsPath = $sPagesPath.'/posts'; |
57 | 76 |
// create /posts/ - directory if not exists |
58 |
if(!file_exists($sPostsPath)) { |
|
59 |
if(is_writable($sPagesPath)) { |
|
60 |
make_dir(WB_PATH.PAGES_DIRECTORY.'/posts/'); |
|
61 |
} else { |
|
62 |
if(!$globalStarted){ |
|
63 |
$msg[] = ($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']); |
|
64 |
// $admin->print_error($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']); |
|
65 |
return $msg; |
|
66 |
} else { |
|
67 |
echo ''.$MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE'].''; |
|
68 |
return $msg; |
|
69 |
} |
|
77 |
if(is_writable($sPagesPath)) { |
|
78 |
if(!($bRetval = is_dir($sPostsPath))) { |
|
79 |
$iOldUmask = umask(0) ; |
|
80 |
// sanitize directory mode to 'o+rwx/g+x/u+x' and create path |
|
81 |
$bRetval = mkdir($sPostsPath, (OCTAL_DIR_MODE |0711), true); |
|
82 |
umask($iOldUmask); |
|
70 | 83 |
} |
71 |
$msg[] = '<strong>Directory "'.PAGES_DIRECTORY.'/posts/" created</strong>'; |
|
72 |
} else { |
|
73 |
$msg[] = '<strong>Directory "'.PAGES_DIRECTORY.'/posts/" already exists.</strong>'; |
|
84 |
if($bRetval) { |
|
85 |
$msg[] = 'Directory "'.PAGES_DIRECTORY.'/posts/" already exists or created.'; |
|
86 |
}else { |
|
87 |
$msg[] = ($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']); |
|
88 |
} |
|
89 |
}else { |
|
90 |
$msg[] = ($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']); |
|
74 | 91 |
} |
75 | 92 |
// check if new fields must be added |
76 | 93 |
$doImportDate = true; |
77 | 94 |
if(!$database->field_exists(TABLE_PREFIX.'mod_news_posts', 'created_when')) { |
78 | 95 |
if(!$database->field_add(TABLE_PREFIX.'mod_news_posts', 'created_when', |
79 | 96 |
'INT NOT NULL DEFAULT \'0\' AFTER `commenting`')) { |
80 |
if($globalStarted){ |
|
81 |
echo ''.$MESSAGE['RECORD_MODIFIED_FAILED'].''; |
|
82 |
return $msg; |
|
83 |
} else { |
|
84 |
// $admin->print_error($MESSAGE['RECORD_MODIFIED_FAILED']); |
|
85 | 97 |
$msg[] = $MESSAGE['RECORD_MODIFIED_FAILED']; |
86 |
return $msg;
|
|
87 |
}
|
|
98 |
} else {
|
|
99 |
$msg[] = 'TABLE `'.TABLE_PREFIX.'mod_news_posts` Datafield `created_when` added.';
|
|
88 | 100 |
} |
101 |
} else { |
|
102 |
$msg[] = 'TABLE `'.TABLE_PREFIX.'mod_news_posts` Datafield `created_when` already exists.'; |
|
103 |
$doImportDate = false; |
|
104 |
} |
|
89 | 105 |
|
90 |
if($globalStarted) { |
|
91 |
echo 'Datafield `'.TABLE_PREFIX.'mod_news_posts`.`created_when` added.<br />'; |
|
92 |
} |
|
93 |
} else { $doImportDate = false; } |
|
94 |
|
|
95 | 106 |
if(!$database->field_exists(TABLE_PREFIX.'mod_news_posts', 'created_by')) { |
96 | 107 |
if(!$database->field_add(TABLE_PREFIX.'mod_news_posts', 'created_by', |
97 | 108 |
'INT NOT NULL DEFAULT \'0\' AFTER `created_when`')) { |
98 |
if($globalStarted){ |
|
99 |
echo ''.$MESSAGE['RECORD_MODIFIED_FAILED'].''; |
|
100 |
return $msg; |
|
101 |
}else { |
|
102 |
// $admin->print_error($MESSAGE['RECORD_MODIFIED_FAILED']); |
|
103 |
$msg[] = $MESSAGE['RECORD_MODIFIED_FAILED']; |
|
104 |
return $msg; |
|
105 |
} |
|
109 |
$msg[] = $MESSAGE['RECORD_MODIFIED_FAILED']; |
|
106 | 110 |
} |
107 |
if($globalStarted) {
|
|
108 |
echo 'datafield `'.TABLE_PREFIX.'mod_news_posts`.`created_by` added.<br />';
|
|
109 |
}
|
|
111 |
} else {
|
|
112 |
$msg[] = 'TABLE `'.TABLE_PREFIX.'mod_news_posts` Datafield `created_by` already exists.';
|
|
113 |
$doImportDate = false;
|
|
110 | 114 |
} |
111 |
// preset new fields `created_by` and `created_when` from existing values
|
|
115 |
// preset new fields `created_by` and `created_by` from existing values
|
|
112 | 116 |
if($doImportDate) { |
113 | 117 |
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_news_posts` '; |
114 | 118 |
$sql .= 'SET `created_by`=`posted_by`, `created_when`=`posted_when`'; |
115 | 119 |
$database->query($sql); |
116 | 120 |
} |
117 | 121 |
|
118 |
/**
|
|
119 |
* rebuild news post folder
|
|
120 |
*/
|
|
121 |
$array = rebuildFolderProtectFile($sPostsPath); |
|
122 |
/**
|
|
123 |
* rebuild news post folder
|
|
124 |
*/
|
|
125 |
// $array = rebuildFolderProtectFile($sPostsPath);
|
|
122 | 126 |
// now iterate through all existing accessfiles, |
123 | 127 |
// write its creation date into database |
124 | 128 |
$oDir = new DirectoryIterator($sPostsPath); |
... | ... | |
137 | 141 |
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_news_posts` '; |
138 | 142 |
$sql .= 'SET `created_when`='.$fileinfo->getMTime().' '; |
139 | 143 |
$sql .= 'WHERE `link`=\''.$link.'\''; |
140 |
$database->query($sql); |
|
144 |
if($database->query($sql)) { |
|
145 |
// delete old access file |
|
146 |
unlink($fileinfo->getPathname()); |
|
147 |
$count++; |
|
148 |
} |
|
141 | 149 |
} |
142 |
// delete old access file |
|
143 |
unlink($fileinfo->getPathname()); |
|
144 |
$count++; |
|
145 | 150 |
} |
146 | 151 |
} |
147 | 152 |
unset($oDir); |
148 | 153 |
|
149 | 154 |
if($count > 0) { |
150 |
$msg[] = 'save date of creation from '.$count.' old accessfiles and delete these files.';
|
|
155 |
$msg[] = 'Save date of creation from '.$count.' old accessfiles and delete these files.';
|
|
151 | 156 |
} |
152 | 157 |
// ************************************************ |
153 | 158 |
// Check the validity of 'create-file-timestamp' and balance against 'posted-timestamp' |
... | ... | |
161 | 166 |
$database->query($sql); |
162 | 167 |
// ************************************************ |
163 | 168 |
|
164 |
// rebuild all access-files |
|
165 |
$count = 0; |
|
166 |
$backSteps = preg_replace('@^'.preg_quote(WB_PATH).'@', '', $sPostsPath); |
|
167 |
$backSteps = str_repeat( '../', substr_count($backSteps, '/')); |
|
168 |
$sql = 'SELECT `page_id`,`post_id`,`section_id`,`link` '; |
|
169 |
$sql .= 'FROM `'.TABLE_PREFIX.'mod_news_posts`'; |
|
170 |
$sql .= 'WHERE `link` != \'\''; |
|
171 |
if( ($resPosts = $database->query($sql)) ) |
|
172 |
{ |
|
173 |
while( $recPost = $resPosts->fetchRow() ) |
|
174 |
{ |
|
175 |
$file = $sPagesPath.$recPost['link'].PAGE_EXTENSION; |
|
176 |
$content = |
|
177 |
'<?php'."\n". |
|
178 |
'// *** This file is generated by WebsiteBaker Ver.'.VERSION."\n". |
|
179 |
'// *** Creation date: '.date('c')."\n". |
|
180 |
'// *** Do not modify this file manually'."\n". |
|
181 |
'// *** WB will rebuild this file from time to time!!'."\n". |
|
182 |
'// *************************************************'."\n". |
|
183 |
"\t".'$page_id = '.$recPost['page_id'].';'."\n". |
|
184 |
"\t".'$section_id = '.$recPost['section_id'].';'."\n". |
|
185 |
"\t".'$post_id = '.$recPost['post_id'].';'."\n". |
|
186 |
"\t".'$post_section = '.$recPost['section_id'].';'."\n". |
|
187 |
"\t".'require(\''.$backSteps.'index.php\');'."\n". |
|
188 |
'// *************************************************'."\n"; |
|
189 |
if( file_put_contents($file, $content) !== false ) { |
|
190 |
// Chmod the file |
|
191 |
change_mode($file); |
|
192 |
}else { |
|
193 |
$msg[] = ($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']); |
|
194 |
} |
|
195 |
$count++; |
|
196 |
} |
|
197 |
$msg[] = '<strong>Number of new created access files: '.$count.'</strong>'; |
|
198 |
} |
|
199 | 169 |
// only for upgrade-script |
200 | 170 |
if($globalStarted) { |
201 | 171 |
if($bDebugModus) { |
... | ... | |
203 | 173 |
echo '<strong>'.$title.'</strong><br />'; |
204 | 174 |
} |
205 | 175 |
} |
206 |
} |
|
207 |
return $msg;
|
|
176 |
}
|
|
177 |
return ( ($globalStarted==true ) ? $globalStarted : $msg);
|
|
208 | 178 |
} |
209 | 179 |
} |
210 | 180 |
// end mod_news_Upgrade |
211 | 181 |
|
212 | 182 |
// ------------------------------------ |
213 |
|
|
214 |
$msg = mod_news_Upgrade(); |
|
215 |
|
|
216 |
|
|
217 |
/* **** END UPGRADE ********************************************************* */ |
|
183 |
// only show if manuell upgrade |
|
184 |
if( is_array($msg = mod_news_Upgrade()) ) { |
|
185 |
$sModulReorg = 'm_news_Reorg'; |
|
186 |
if(class_exists($sModulReorg)) { |
|
187 |
$oReorg = new $sModulReorg(); |
|
188 |
$msg = array_merge($msg, $oReorg->execute() ); // show details |
|
189 |
// $msg = array_merge($msg,(new $sModulReorg())->execute()); // show details |
|
190 |
} |
|
191 |
foreach($msg as $title) { |
|
192 |
echo '<strong>'.$title.'</strong><br />'; |
|
193 |
} |
|
194 |
echo '<strong>News upgrade finished </strong><br /><br>'; |
|
195 |
} |
|
196 |
/* **** END UPGRADE ********************************************************* */ |
Also available in: Unified diff
! framework/functions.php set function create_access_file to deprecated
! set ModLanguage.php to deprecated
! add methode escapeString to class WbDatabase
! update upgrade-script.php
! add getter property LastInsertId to class WbDatabase