Downgraging from 7.5 to 7.4

Useless Joined: Aug 23, 2002 Posts: 213 Location: Chicago

Someone I know made an upgrade without a backup to 7.5 and now want to rollback to 7.4.
Is there for him to do that without major problems?

Posted: Tue Dec 28, 2004 10:32 am

Save the following to a file, name it something like downgrade.php and upload it to where mainfile.php is located, last point your browser to it, delete once done. Of course this will only restore the db, you still need to reupload the old files from 7.4

Code:

<?php





######################################################


# File to rollback from PHP-Nuke 7.5 to PHP-Nuke 7.4


# After you used this file, you can safely delete it.


######################################################


#            -= WARNING: PLEASE READ =-


#


# NOTE: This file uses config.php to retrieve needed


# variables values. So, to do the upgrade PLEASE copy


# this file in your server root directory and execute


# it from your browser.


######################################################





include("mainfile.php");





// Modules Table Update


$db->sql_query("ALTER TABLE ".$prefix."_modules DROP admins");





// Administrators Table modification


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminarticle tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radmintopic tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminuser tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminsurvey tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminlink tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminfaq tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radmindownload tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminreviews tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminnewsletter tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminforum tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radmincontent tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors ADD radminency tinyint(2) NOT NULL default '0'");


$db->sql_query("ALTER TABLE ".$prefix."_authors CHANGE radminsuper radminsuper tinyint(2) NOT NULL default '1'");





// PHP-Nuke Version Number Update


$db->sql_query("UPDATE ".$prefix."_config SET Version_Num='7.4'");





echo "PHP-Nuke Update finished!<br><br>";


?>

Posted: Tue Dec 28, 2004 11:58 am

Thanks so much chatserv!