Preview the below needed script in a Custom Page. DO NOT SAVE IT !!!

// Script below upgrades Nickpages ver 2.0 to ver 3.0

<?php
global $settings;
require_once INFUSIONS."nickpage_panel/infusion_db.php";
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nicktwo_title VARCHAR(50) NOT NULL AFTER nickpage_title");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nickthree_title VARCHAR(50) NOT NULL AFTER nicktwo_title");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nicktwo_content TEXT NOT NULL AFTER nickpage_content");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nickthree_content TEXT NOT NULL AFTER nicktwo_content");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickpage_title nickmain_title VARCHAR(50) NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickpage_content nickmain_content TEXT NOT NULL");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nickmain_title='Home', nicktwo_title='Biography', nickthree_title='Photo Gallery'");
$result = dbquery("UPDATE ".DB_INFUSIONS." SET inf_version='3.0' WHERE inf_title='Personal NickPages'");
$result = dbquery("UPDATE ".DB_COMMENTS." SET comment_type='XP' WHERE comment_type='NP'");
$result = dbquery("UPDATE ".DB_RATINGS." SET rating_type='X' WHERE rating_type='Z'");
?>

// End upgrade ver 2.0

// Script below upgrades Nickpages ver 3.0 to ver 3.1

<?php
global $settings;
require_once INFUSIONS."nickpage_panel/infusion_db.php";
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickmain_title nick1_title VARCHAR(50) NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nicktwo_title nick2_title VARCHAR(50) NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickthree_title nick3_title VARCHAR(50) NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickpage_theme nick1_theme VARCHAR(100) NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_theme VARCHAR(100) NOT NULL AFTER nick1_theme");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick2_theme='Blue_Fire' WHERE nick2_theme=''");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_theme VARCHAR(100) NOT NULL AFTER nick2_theme");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick3_theme='Blue_Fire' WHERE nick3_theme=''");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick1_hdr INT(1) UNSIGNED NOT NULL AFTER nick3_theme");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_hdr INT(1) UNSIGNED NOT NULL AFTER nick1_hdr");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_hdr INT(1) UNSIGNED NOT NULL AFTER nick2_hdr");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick1_hdr='1'");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick2_hdr='1'");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick3_hdr='1'");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick1_hdr_pic VARCHAR(10) NOT NULL AFTER nick3_hdr");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_hdr_pic VARCHAR(10) NOT NULL AFTER nick1_hdr_pic");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_hdr_pic VARCHAR(10) NOT NULL AFTER nick2_hdr_pic");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickmain_content nick1_content TEXT NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nicktwo_content nick2_content TEXT NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickthree_content nick3_content TEXT NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick1_ratings INT(1) UNSIGNED NOT NULL AFTER nick3_content");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_ratings INT(1) UNSIGNED NOT NULL AFTER nick1_ratings");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_ratings INT(1) UNSIGNED NOT NULL AFTER nick2_ratings");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick1_ratings='1'");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick2_ratings='1'");
$result = dbquery("UPDATE ".DB_NICKPAGE." SET nick3_ratings='1'");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickpage_comments nick1_comments INT(1) UNSIGNED NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_comments INT(1) UNSIGNED NOT NULL AFTER nick1_comments");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_comments INT(1) UNSIGNED NOT NULL AFTER nick2_comments");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickpage_update nick1_update INT(10) UNSIGNED NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_update INT(10) UNSIGNED NOT NULL AFTER nick1_update");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_update INT(10) UNSIGNED NOT NULL AFTER nick2_update");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." CHANGE nickpage_count nick1_count INT(10) UNSIGNED NOT NULL");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick2_count INT(10) UNSIGNED NOT NULL AFTER nick1_count");
$result = dbquery("ALTER TABLE ".DB_NICKPAGE." ADD nick3_count INT(10) UNSIGNED NOT NULL AFTER nick2_count");
 
$result = dbquery("UPDATE ".DB_INFUSIONS." SET inf_version='3.1' WHERE inf_title='Personal NickPages'");
$result = dbquery("UPDATE ".DB_COMMENTS." SET comment_type='XP' WHERE comment_type='NP'");
$result = dbquery("UPDATE ".DB_RATINGS." SET rating_type='X' WHERE rating_type='Z'");
?>

// End upgrade ver 3.0