PageRenderTime 62ms CodeModel.GetById 11ms RepoModel.GetById 0ms app.codeStats 0ms

/setup/upgrade.php

http://phpwcms.googlecode.com/
PHP | 343 lines | 318 code | 16 blank | 9 comment | 11 complexity | 8d643155a7dc81045f2a268cdde2b634 MD5 | raw file
Possible License(s): AGPL-1.0, LGPL-2.1, ISC, MIT, LGPL-3.0, GPL-2.0, MPL-2.0-no-copyleft-exception, LGPL-2.0, BSD-3-Clause 
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * phpwcms content management system
    4. 

  4.  *
    5. 

  5.  * @author Oliver Georgi <oliver@phpwcms.de>
    6. 

  6.  * @copyright Copyright (c) 2002-2013, Oliver Georgi
    7. 

  7.  * @license http://opensource.org/licenses/GPL-2.0 GNU GPL-2
    8. 

  8.  * @link http://www.phpwcms.de
    9. 

  9.  *
    10. 

  10.  **/
    11. 

  11. 

  12. $phpwcms = array();
    13. 

  13. 

  14. $_this_path = realpath(dirname(__FILE__).'/../');
    15. 

  15. if(is_file($_this_path.'/config/phpwcms/conf.inc.php')) {
    16. 

  16. 	require_once ($_this_path.'/config/phpwcms/conf.inc.php');
    17. 

  17. } else {
    18. 

  18. 	die('Please proof location of "conf.inc.php".');
    19. 

  19. }
    20. 

  20. 

  21. if (!defined('PHPWCMS_INCLUDE_CHECK')) {
    22. 

  22.    define('PHPWCMS_INCLUDE_CHECK', true);
    23. 

  23. }
    24. 

  24. 

  25. require_once ($_this_path.'/include/inc_lib/default.inc.php');
    26. 

  26. require_once (PHPWCMS_ROOT.'/include/inc_lib/dbcon.inc.php');
    27. 

  27. require_once (PHPWCMS_ROOT.'/include/inc_lib/general.inc.php');
    28. 

  28. require_once (PHPWCMS_ROOT.'/include/inc_lib/backend.functions.inc.php');
    29. 

  29. require_once (PHPWCMS_ROOT.'/setup/inc/upgrade.func.inc.php');
    30. 

  30. 

  31. ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    32. 

  32. <html xmlns="http://www.w3.org/1999/xhtml">
    33. 

  33. <head>
    34. 

  34. <title>Upgrade phpwcms</title>
    35. 

  35. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    36. 

  36. <link href="inc/install.css" rel="stylesheet" type="text/css" />
    37. 

  37. <style type="text/css">
    38. 

  38. <!--
    39. 

  39. body {
    40. 

  40. 	padding:	0 15px 15px 15px;
    41. 

  41. 	margin: 0;
    42. 

  42. }
    43. 

  43. -->
    44. 

  44. </style>
    45. 

  45. </head>
    46. 

  46. 

  47. <body>
    48. 

  48. <table width="770" border="0" align="center" cellpadding="0" cellspacing="0" summary="">
    49. 

  49.   <tr>
    50. 

  50.     <td colspan="3"><img src="../img/leer.gif" alt="[beliebiger Wert]" width="1" height="7" /></td>
    51. 

  51.   </tr>
    52. 

  52.   <tr>
    53. 

  53.     <td colspan="3"><img src="../img/leer.gif" alt="" width="15" height="1" /><a href="http://www.phpwcms.de" target="_blank"><img src="../img/backend/backend_r1_c3.jpg" alt="phpwcms" width="95" height="24" border="0" /></a></td>
    54. 

  54.   </tr>
    55. 

  55.   <tr>
    56. 

  56.     <td colspan="3"><img src="../img/leer.gif" alt="" width="1" height="7" /></td>
    57. 

  57.   </tr>
    58. 

  58.   <tr bgcolor="#FFFFFF">
    59. 

  59.     <td valign="top" style="background-image:url(../img/backend/backend_r3_c4.jpg); background-repeat:repeat-x; "><img src="../img/backend/backend_r3_c1.jpg" alt="" width="15" height="40" /></td>
    60. 

  60.     <td valign="top" style="background-image:url(../img/backend/backend_r3_c4.jpg); background-repeat:repeat-x; "><table width="740" border="0" cellpadding="0" cellspacing="0" summary="">
    61. 

  61.         <tr>
    62. 

  62.           <td colspan="2"><img src="../img/leer.gif" alt="" width="1" height="9" /></td>
    63. 

  63.         </tr>
    64. 

  64.         <tr>
    65. 

  65.           <td valign="top" class="navtext">PHPWCMS UPGRADE VERSION&nbsp;<?php echo $phpwcms['release'].', RELEASE '.$phpwcms['release_date'] ?></td>
    66. 

  66.           <td align="right" valign="top" class="navtext"><a href="../index.php" target="_top">HOME</a> |
    67. 

  67.             <a href="setup.php">SETUP</a> | <a href="index.php" target="_top">LICENCE</a> | <a href="<?php echo PHPWCMS_URL.get_login_file() ?>" target="_top">LOGIN</a></td>
    68. 

  68.         </tr>
    69. 

  69.     </table></td>
    70. 

  70.     <td valign="top" style="background-image:url(../img/backend/backend_r3_c4.jpg); background-repeat:repeat-x; "><img src="../img/backend/backend_r3_c7.jpg" alt="" width="15" height="40" /></td>
    71. 

  71.   </tr>
    72. 

  72.   <tr bgcolor="#FFFFFF">
    73. 

  73.     <td width="15" bgcolor="#FFFFFF" style="background-image:url(../img/backend/preinfo2_r7_c2.gif);background-repeat:repeat-y;"><img src="../img/leer.gif" alt="" width="15" height="1" /></td>
    74. 

  74.     <td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="0" style="border:1px dotted #7599BB;" summary="">
    75. 

  75.         <tr>
    76. 

  76.           <td colspan="4"><img src="../img/leer.gif" alt="" width="1" height="6" /></td>
    77. 

  77.         </tr>
    78. 

  78.         <tr>
    79. 

  79.           <td width="6" rowspan="10"><img src="../img/leer.gif" alt="" width="6" height="1" /></td>
    80. 

  80.           <td align="right" class="chatlist">&nbsp;system:&nbsp;</td>
    81. 

  81.           <td class="chatlist" width="100%"><?php echo php_uname() ?></td>
    82. 

  82.           <td width="6" rowspan="10"><img src="../img/leer.gif" alt="" width="6" height="1" /></td>
    83. 

  83.         </tr>
    84. 

  84.         <tr>
    85. 

  85.           <td align="right" class="chatlist">server:&nbsp;</td>
    86. 

  86.           <td class="chatlist"><?php echo $_SERVER['SERVER_SOFTWARE'] ?></td>
    87. 

  87.         </tr>
    88. 

  88.         <tr>
    89. 

  89.           <td align="right" class="chatlist">php:&nbsp;</td>
    90. 

  90.           <td class="chatlist">v<?php echo PHP_VERSION ?></td>
    91. 

  91.         </tr>
    92. 

  92.         <tr>
    93. 

  93.           <td align="right" class="chatlist">mysql:&nbsp;</td>
    94. 

  94.           <td class="chatlist"><?php echo mysql_get_client_info() ?> (is just client information, server might be different)</td>
    95. 

  95.         </tr>
    96. 

  96.         <tr>
    97. 

  97.           <td align="right" class="chatlist">path:&nbsp;</td>
    98. 

  98.           <td class="chatlist"><?php echo html_specialchars(str_replace("\\", '/', preg_replace('/\/setup$/','', dirname(__FILE__)))); ?></td>
    99. 

  99.         </tr>
    100. 

  100.         <tr>
    101. 

  101.           <td align="right" class="chatlist">php.ini:&nbsp;</td>
    102. 

  102.           <td class="chatlist"><?php
    103. 

  103. 		  
    104. 

  104. 		  if(ini_get('register_globals')) {
    105. 

  105. 		  	echo 'register_globals = On -&gt; should always be set Off because of <a href="http://phpsec.org/projects/guide/1.html#1.3" target="_blank" style="text-decoration:underline">security risks</a>';
    106. 

  106. 		  } else {
    107. 

  107. 		    echo 'register_globals = Off -&gt; that\'s good :)';
    108. 

  108. 		  }
    109. 

  109. 		  
    110. 

  110. 		  
    111. 

  111. 		  
    112. 

  112. 		  ?></td>
    113. 

  113.         </tr>
    114. 

  114.         <tr>
    115. 

  115.           <td align="right" class="chatlist">&nbsp;</td>
    116. 

  116.           <td class="chatlist"><?php
    117. 

  117. 		  
    118. 

  118. 		  if(ini_get('safe_mode')) {
    119. 

  119. 		  	echo 'safe_mode = On -&gt; you have limited permissions, you might not be able to use ImageMagick';
    120. 

  120. 		  } else {
    121. 

  121. 		    echo 'safe_mode = Off -&gt; good when you want to use ImageMagick, may have some <a href="http://phpsec.org/" target="_blank" style="text-decoration:underline">security risks</a>';
    122. 

  122. 		  }
    123. 

  123. 		  
    124. 

  124. 		  ?></td>
    125. 

  125.         </tr>
    126. 

  126.         <tr>
    127. 

  127.           <td align="right" class="chatlist">&nbsp;</td>
    128. 

  128.           <td class="chatlist">GD = <?php 
    129. 

  129. 					
    130. 

  130. 				$_phpinfo = parsePHPModules();
    131. 

  131. 				if(isset($_phpinfo['gd']['GD Support']) && $_phpinfo['gd']['GD Support'] == 'enabled') {
    132. 

  132. 					echo 'On';
    133. 

  133. 					echo isset($_phpinfo['gd']['GD Version']) ? ' -&gt; '.$_phpinfo['gd']['GD Version'] : '';
    134. 

  134. 				} else {
    135. 

  135. 					echo 'Off';
    136. 

  136. 				}
    137. 

  137. 				
    138. 

  138. 				
    139. 

  139. 		
    140. 

  140. 		?></td>
    141. 

  141.         </tr>
    142. 

  142.         <tr>
    143. 

  143.           <td colspan="2" class="chatlist"><img src="../img/leer.gif" alt="" width="1" height="6" /></td>
    144. 

  144.         </tr>
    145. 

  145.         <tr>
    146. 

  146.           <td colspan="2" class="chatlist"><div id="warning">
    147. 

  147. <p><strong>ATTENTION! </strong>Before you start updating &#8212; <strong>backup</strong> all
    148. 

  148.   phpwcms files AND  all databases. Sometimes it might be better you merge SQL
    149. 

  149.    files manually. Don't forget to make copies of  CSS files, templates,
    150. 

  150.   images, settings and custom scripts.</p>
    151. 

  151. </div></td>
    152. 

  152.         </tr>
    153. 

  153. 		
    154. 

  154.         <tr>
    155. 

  155.           <td colspan="4"><img src="../img/leer.gif" alt="" width="1" height="6" /></td>
    156. 

  156.         </tr>
    157. 

  157.     </table>      
    158. 

  158. 

  159. 	
    160. 

  160. 

  161.   <h1>When upgrading from releases older than 1.1.9:</h1>
    162. 

  162.  <p> There are some deeper changes. After upgrading db frame the following<br />
    163. 

  163.   files needs to be processed.<br />
    164. 

  164.   1) <a href="upgrade_filestorage.php" target="_blank"><strong>UPGRADE FILESTORAGE</strong></a> (all
    165. 

  165.   files will be moved and renamed)<br />
    166. 

  166.   2) <a href="upgrade_articleimages.php" target="_blank"><strong>UPGRADE ARTICLE
    167. 

  167.     CONTENT IMAGE</strong></a><br />
    168. 

  168.   3) <a href="upgrade_articleimagelist.php" target="_blank"><strong>UPGRADE ARTICLE
    169. 

  169. CONTENT IMAGELIST</strong></a><br />
    170. 

  170.  4) <a href="upgrade_articleimg.php" target="_blank"><strong>UPGRADE ARTICLE
    171. 

  171.  SUMMARY IMAGE</strong></a></p>
    172. 

  172.  <h1>When upgrading from releases older than 1.2.9:</h1>
    173. 

  173. <p>5) <a href="upgrade_pagelayout.php" target="_blank"><strong>UPGRADE PAGELAYOUT</strong></a></p>
    174. 

  174. <h1>When upgrading from releases older than 1.3.1:</h1>
    175. 

  175. <p>6) <a href="upgrade_multimedia.php" target="_blank"><strong>UPGRADE CONTENT PART MULTIMEDIA</strong></a></p>
    176. 

  176. <p>7) <a href="upgrade_articlealias.php" target="_blank"><strong>UPDATE ARTICLE ALIAS</strong></a></p>
    177. 

  177. 

  178. <h1>Update old default article end date 2010-12-31, 23:59:59:</h1>
    179. 

  179. <p>8) <a href="upgrade_articledate.php" target="_blank"><strong>SET ARTICLE END 2010-12-31, 23:59:59 plus 20 YEARS</strong></a></p>
    180. 

  180. 

  181. <?php
    182. 

  182. $do = 0;
    183. 

  183. if(isset($_POST['sqlfile']) && isset($_GET["do"]) && $_GET["do"] == "upgrade") {
    184. 

  184. 

  185. 	$file = str_replace('inc/showsql.php?f=', '', slweg($_POST['sqlfile']));
    186. 

  186. 	if(file_exists("update_sql/".$file)) {
    187. 

  187. 		$do = 1;
    188. 

  188. 	}
    189. 

  189. }
    190. 

  190. 

  191. if($do) {
    192. 

  192. 

  193. 	@mysql_query('SET storage_engine=MYISAM', $db);
    194. 

  194. 	
    195. 

  195. 	if($phpwcms['db_version'] > 40100) {
    196. 

  196. 		$value = "SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'";
    197. 

  197. 		@mysql_query($value, $db);
    198. 

  198. 		$value = "SET NAMES '".$phpwcms['db_charset']."'".(empty($phpwcms['db_collation']) ? '' : " COLLATE '".$phpwcms['db_collation']."'");
    199. 

  199. 		@mysql_query($value, $db);
    200. 

  200. 	}
    201. 

  201. 

  202. 	$sql_data = read_textfile("update_sql/".$file);
    203. 

  203. 	$sql_data = preg_replace("/#.*.\n/", "", $sql_data );
    204. 

  204. 	$sql_data = preg_replace("/ `phpwcms/", " `".DB_PREPEND."phpwcms", $sql_data );
    205. 

  205. 	$sql = explode(";", $sql_data);
    206. 

  206. 

  207. 	echo '<div id="license" style="width:550px">';
    208. 

  208. 	echo '<p><a href="upgrade.php">Chosse another SQL file...</a></p>';
    209. 

  209. 	echo '<pre>';
    210. 

  210. 

  211. 	foreach($sql as $key => $value) {
    212. 

  212. 		$value = trim($value);
    213. 

  213. 		if(!$value) {
    214. 

  214. 			unset($sql[$key]);
    215. 

  215. 		} else {
    216. 

  216. 		
    217. 

  217. 			if($phpwcms['db_version'] > 40100 && $phpwcms['db_charset']=='utf8') {
    218. 

  218. 				$value = utf8_encode($value);
    219. 

  219. 			}
    220. 

  220. 		
    221. 

  221. 			if(!mysql_query($value)) echo '<span class="error">ERROR: '.html_entities(@mysql_error())." -&gt; </span>";
    222. 

  222. 			echo html_specialchars($value).";\n";
    223. 

  223. 		}
    224. 

  224. 	}
    225. 

  225. 	
    226. 

  226. 	echo '</pre></div>';
    227. 

  227. 

  228. } else {
    229. 

  229. 

  230. ?>
    231. 

  231. <form action="upgrade.php?do=upgrade" method="post" name="form1" id="form1">
    232. 

  232. <p><strong>Please proof!</strong> Upgrade script will use following data:</p>
    233. 

  233. <table border="0" cellpadding="0" cellspacing="0" class="sqlselect" summary="">
    234. 

  234. 

  235. <?php
    236. 

  236. 

  237. if(empty($phpwcms['db_charset']) || empty($phpwcms['db_collation']) || empty($phpwcms['db_version'])) {
    238. 

  238. 

  239. ?>
    240. 

  240.   <tr bgcolor="#FFFFFF">
    241. 

  241.     <td align="right" valign="top">MySQL basics:</td>
    242. 

  242.     <td style="color:#FFFFFF;background-color:	#CC3300;" valign="top">
    243. 

  243. 		<strong>Before you continue proof the following config settings:</strong><br />
    244. 

  244. 		$phpwcms['db_charset']<br />
    245. 

  245. 		$phpwcms['db_collation']<br />
    246. 

  246. 		$phpwcms['db_version']<br />
    247. 

  247. 		If you are not sure how to handle this <br />
    248. 

  248. 		try to start setup process! <br />
    249. 

  249. 		<strong>But STOP SETUP BEFORE SQL IMPORT!!!</strong> </td>
    250. 

  250.   </tr>
    251. 

  251. <?php
    252. 

  252. }
    253. 

  253. ?>
    254. 

  254. 

  255.   <tr bgcolor="#FFFFFF">
    256. 

  256.     <td align="right">MySQL host:</td>
    257. 

  257.     <td style="font-weight:bold; "><?php echo $phpwcms["db_host"] ?></td>
    258. 

  258.   </tr>
    259. 

  259.   <tr bgcolor="#FFFFFF">
    260. 

  260.     <td align="right">Database:</td>
    261. 

  261.     <td style="font-weight:bold; "><?php echo $phpwcms["db_table"] ?></td>
    262. 

  262.   </tr>
    263. 

  263.   <tr bgcolor="#FFFFFF">
    264. 

  264.     <td align="right">DB user:</td>
    265. 

  265.     <td style="font-weight:bold; "><?php echo $phpwcms["db_user"] ?></td>
    266. 

  266.   </tr>
    267. 

  267.   <tr bgcolor="#FFFFFF">
    268. 

  268.     <td align="right">DB table prefix:</td>
    269. 

  269.     <td style="font-weight:bold; "><?php echo $phpwcms["db_prepend"] ?>&nbsp;</td>
    270. 

  270.   </tr>
    271. 

  271.   
    272. 

  272.   
    273. 

  273. 

  274.   
    275. 

  275.   
    276. 

  276.   <tr bgcolor="#FFFFFF">
    277. 

  277.     <td align="right">&nbsp;select&nbsp;SQL&nbsp;file:</td>
    278. 

  278.     <td><select name="sqlfile" id="sqlfile" onchange="window.open(this.options[this.selectedIndex].value,'sqlqueries')">
    279. 

  279.       <option value="inc/showsql.php" style="font-weight:bold; font-style:italic;">Please select&#8230;</option>
    280. 

  280.       <?php
    281. 

  281. 

  282. $dir = 'update_sql';
    283. 

  283. if(is_dir($dir)) {
    284. 

  284. 	$ph			= opendir($dir);
    285. 

  285. 	$dir_sql	= array();
    286. 

  286. 	while($pf = readdir($ph)) {
    287. 

  287.    		if( $pf != '.' && $pf != '..' && !is_dir($dir.'/'.$pf) && preg_match('/(\.sql)$/', strtolower($pf)) ) 
    288. 

  288. 		{
    289. 

  289. 			$dir_sql[] = html_specialchars($pf);
    290. 

  290. 		}
    291. 

  291. 	}
    292. 

  292. 	closedir($ph);
    293. 

  293. 	
    294. 

  294. 	natsort($dir_sql);
    295. 

  295. 	
    296. 

  296. 	foreach($dir_sql as $pf) {
    297. 

  297. 	
    298. 

  298. 		echo '<option value="inc/showsql.php?f='.$pf.'">'.$pf."</option>\n";
    299. 

  299. 	
    300. 

  300. 	}
    301. 

  301. 	
    302. 

  302. }
    303. 

  303. 	
    304. 

  304. 	
    305. 

  305. 	
    306. 

  306. ?>
    307. 

  307.     </select></td>
    308. 

  308.   </tr>
    309. 

  309. </table>
    310. 

  310. <p style="margin-top:5px;"><strong>SQL queries to be processed:</strong></p>
    311. 

  311. <iframe name="sqlqueries" id="sqlqueries" frameborder="0" scrolling="auto" src="inc/showsql.php"></iframe>
    312. 

  312. <p><input name="submit" type="submit" value="Upgrade database" /></p>
    313. 

  313. </form>
    314. 

  314. <?php 
    315. 

  315. 

  316. }
    317. 

  317. 

  318. ?>
    319. 

  319. 

  320. 		
    321. 

  321. 	</td>
    322. 

  322.     <td width="15" bgcolor="#FFFFFF" style="background-image:url(../img/backend/preinfo2_r7_c7.gif);background-repeat:repeat-y;background-position:right;"><img src="../img/leer.gif" alt="" width="15" height="1" /></td>
    323. 

  323.   </tr>
    324. 

  324.   <tr>
    325. 

  325.     <td><img src="../img/backend/backend_a_r1_c1.gif" alt="" width="15" height="15" border="0" /></td>
    326. 

  326.     <td valign="bottom" bgcolor="#FFFFFF" class="navtext"><img src="../img/backend/backend_r6_c2.jpg" alt="" width="740" height="15" border="0" /></td>
    327. 

  327.     <td valign="bottom" class="navtext"><img src="../img/backend/backend_a_r1_c7.gif" alt="" width="15" height="15" border="0" /></td>
    328. 

  328.   </tr>
    329. 

  329.   <tr>
    330. 

  330.     <td width="15"><img src="../img/leer.gif" alt="" width="14" height="20" /></td>
    331. 

  331.     <td colspan="2" valign="bottom" class="navtext">
    332. 

  332. 		<a href="http://www.phpwcms.de" target="_blank">phpwcms</a>
    333. 

  333. 		&copy; 2003&#8212;<?php echo date('Y') ?>
    334. 

  334. 		<a title="oliver at phpwcms dot de" onclick="location.href='mailto:oliver'+'@'+'phpwcms'+'.'+'de';return false;" href="#">Oliver Georgi</a>.
    335. 

  335. 		Licensed under <a href="http://www.gnu.org/licenses/gpl.html" target="_blank">GPL</a>.
    336. 

  336.         Extensions are copyright of their respective owners.</td>
    337. 

  337.   </tr>
    338. 

  338.   <tr>
    339. 

  339.     <td colspan="3"><img src="../img/leer.gif" alt="" width="1" height="8" /></td>
    340. 

  340.   </tr>
    341. 

  341. </table>
    342. 

  342. </body>
    343. 

  343. </html>
    344.