// ----------------------------------------------------------------------
// Original Author of file:
// Purpose of file: Upgrade from PostNuke .72 to PostNuke .722 [Neo]
// ----------------------------------------------------------------------
//
// Temp fixes for validation and correct update of 0.7.2.2
// Note that this is upgrade script uses ADODB instead
// of raw mysql
global $dbconn, $pntable, $prefix;
include_once 'install/pntables72.php';
include_once 'install/update_functions.php';
// Table structure changes first
// Change most pn_url to 254 instead of 255 to later support vfp
// add-statements right at the end
// Fixes for 0.7.2.2 installation prevents duplication and errors [Neo]
if (!CheckForField('pn_type', 'banner')) {
$dbconn->Execute("ALTER TABLE {$pntable['banner']} ADD `pn_type` VARCHAR( 2 ) DEFAULT '0' NOT NULL AFTER `pn_cid`");
}
// || die ("<b>"._NOTUPDATED."$pntable[banner]</b>");
// Verfy existance prior to alter Neo
$pnValConfigVar = $dbconn->Execute("SELECT pn_format_type FROM " . $prefix . "_stories\n WHERE pn_sid >0 LIMIT 1");
if (!$pnValConfigVar) {
$dbconn->Execute("ALTER TABLE {$pntable['stories']} ADD pn_format_type tinyint(1) unsigned NOT NULL DEFAULT '0'") || die("<b>" . _NOTUPDATED . "{$pntable['stories']}</b>");
}
// Now lets get the module_vars up to date.
$pnValConfigVar = $dbconn->Execute("SELECT pn_value FROM " . $prefix . "_module_vars\n WHERE pn_name='pnAntiCracker' AND pn_modname='/PNConfig'");
if (!$pnValConfigVar) {
$dbconn->Execute("INSERT INTO " . $prefix . "_module_vars\n (pn_modname,\n pn_name,\n pn_value)\n VALUES\n ('/PNConfig',\n 'pnAntiCracker',\n '" . serialize(0) . "')") || die("<b>" . _NOTUPDATED . $prefix . "_modules</b>");
}
$pnValConfigVar = $dbconn->Execute("SELECT pn_value FROM " . $prefix . "_module_vars\n WHERE pn_name='WYSIWYGEditor' AND pn_modname='/PNConfig'");
if (!$pnValConfigVar) {
}
$image .= $v2;
$flag = true;
}
} else {
$image = $v[img];
}
$v[title] = addslashes($v[title]);
mysql_query("INSERT INTO {$GLOBALS['prefix']}_blocks_buttons (id, bid, title, url, images) VALUES (NULL, {$row['bid']}, '{$v['title']}', '{$v['url']}', '{$image}')");
}
print "Done</li>\n";
}
print '</ul>Done converting old-style button blocks!';
}
// Add a column to the queue of news for the bodytext
if (CheckForField('bodytext', 'queue')) {
echo "<font class=\"pn-normal\">It appears your {$GLOBALS['prefix']}_queue table already contains a bodytext field ... skipping</font><br>\r\n";
} else {
echo "<font class=\"pn-normal\">Attempting to add 'bodytext' field to {$GLOBALS['prefix']}_queue... ";
if (!@mysql_query("ALTER TABLE {$GLOBALS['prefix']}_queue add bodytext text")) {
echo "failed</font><br>\r\n";
} else {
echo "done!</font><br>\r\n";
}
}
// Alter length of url field in links_links table
if (CheckTableExists('links_links')) {
// alter table
print '<br><br>';
print "<font class=\"pn-normal\">Updating Links Table ({$GLOBALS['prefix']}_links_links).</font><br>";
if (!@mysql_query("ALTER TABLE {$GLOBALS['prefix']}_links_links CHANGE pn_url VARCHAR(255) NOT NULL DEFAULT ''")) {
