Project

General

Profile

1 1538 Luisehahne
<?php
2
/**
3
 *
4
 * @category        modules
5
 * @package         wysiwyg
6
 * @author          WebsiteBaker Project
7 1576 darkviper
 * @copyright       2009-2012, Website Baker Org. e.V.
8 1538 Luisehahne
 * @link			http://www.websitebaker2.org/
9
 * @license         http://www.gnu.org/licenses/gpl.html
10 1652 Luisehahne
 * @platform        WebsiteBaker 2.8.3
11 1538 Luisehahne
 * @requirements    PHP 5.2.2 and higher
12
 * @version      	$Id$
13
 * @filesource		$HeadURL$
14
 * @lastmodified    $Date$
15
 *
16
 */
17
/* -------------------------------------------------------- */
18 1576 darkviper
// Must include code to stop this file being accessed directly
19
if(!defined('WB_PATH')) {
20 1652 Luisehahne
	require_once(dirname(dirname(dirname(__FILE__))).'/framework/globalExceptionHandler.php');
21 1576 darkviper
	throw new IllegalFileException();
22 1538 Luisehahne
}
23
/* -------------------------------------------------------- */
24
$msg = '';
25
$sTable = TABLE_PREFIX.'mod_wysiwyg';
26
if(($sOldType = $database->getTableEngine($sTable))) {
27
	if(('myisam' != strtolower($sOldType))) {
28
		if(!$database->query('ALTER TABLE `'.$sTable.'` Engine = \'MyISAM\' ')) {
29
			$msg = $database->get_error();
30
		}
31
	}
32
} else {
33 1576 darkviper
	$msg .= $database->get_error().'<br />';
34 1538 Luisehahne
}
35 1754 Luisehahne
36
$sql = 'ALTER TABLE `'.DB_NAME.'`.`'.$sTable.'` DROP PRIMARY KEY';
37
if(!$database->query($sql)) {
38
	$msg .= $database->get_error().'<br />';
39
}
40
41
$sql = 'ALTER TABLE `'.$sTable.'`  ADD `wysiwyg_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST';
42
if(!$database->query($sql)) {
43
	$msg .= $database->get_error().'<br />';
44
}
45
46 1576 darkviper
// change internal absolute links into relative links
47
$sTable = TABLE_PREFIX.'mod_wysiwyg';
48
$sql  = 'UPDATE `'.$sTable.'` ';
49
$sql .= 'SET `content` = REPLACE(`content`, \'"'.WB_URL.MEDIA_DIRECTORY.'\', \'"{SYSVAR:MEDIA_REL}\')';
50
if (!$database->query($sql)) {
51
	$msg .= $database->get_error().'<br />';
52
}
53
54 1538 Luisehahne
// ------------------------------------