Project

General

Profile

« Previous | Next » 

Revision 1866

Added by Dietmar almost 12 years ago

  1. typofix in class TranslateTable
    ! 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

View differences:

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