Converting phpnuke 8.0 Forums DB

silicastorm · Posted: Wed Feb 03, 2010 11:16 pm

Currently in a production environment utilizing the phpnuke 8.0 with phpBB 2.0.20.

Now in test environment have a clean install of RN 2.4.0 and need to convert the production database for the forums to Raven.

Please any guidance or assistance would be greatly appreciated.

Best regards,

spasticdonkey · Posted: Thu Feb 04, 2010 12:14 am

try this for starters

Only registered users can see links on this board!
Get registered or login to the forums!

silicastorm · Posted: Thu Feb 04, 2010 7:48 am

Went to the link provided,,, very helpful however the link for downgrade tool is not active:

Quote:

http://www.nukescripts.net/modules.php?name=Downloads&op=getit&lid=100270

Anyone have the link?

Cheers,

spasticdonkey · Posted: Fri Feb 05, 2010 12:01 pm

<BUMP>

there are a lot files here

Only registered users can see links on this board!
Get registered or login to the forums!

I took a quick look around but couldn't find it.

anyone know where to get their hands on the downgrade tool (broken link in RN wiki)?

Palbin · Posted: Fri Feb 05, 2010 12:24 pm

You could try this. It is for 7.9 to 7.6. Before you do ANYTHING please make sure you have a backup of the database.

Code:

<?php

########################################################
# File to Downgrade from PHP-Nuke 7.8 to PHP-Nuke 7.6 #
# 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. #
########################################################
# Made By Platinum @

Only registered users can see links on this board!
Get registered or login to the forums!

#
# for Php Nuke Evolution #
#

Only registered users can see links on this board!
Get registered or login to the forums!

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

require_once(dirname(__FILE__) . '/mainfile.php');

$module_name = basename(dirname(__FILE__));

include(dirname(__FILE__) . "/header.php");

global $admin;

if (!is_admin($admin)) {
OpenTable();
echo "<center>Access Denied</center>";
CloseTable();
} else {
$index = 0;

// Table Removal and alteration for Moderated Comments to drop the karma system
$db->sql_query("ALTER TABLE ".$user_prefix."_users Drop karma ");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_comments_moderated");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_pollcomments_moderated");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_reviews_comments_moderated");

// News Comments table alteration for moderation system
$db->sql_query("ALTER TABLE ".$prefix."_comments DROP last_moderation_ip ");

// Surveys Comments table alteration for moderation system
$db->sql_query("ALTER TABLE ".$prefix."_pollcomments DROP last_moderation_ip ");
$db->sql_query("ALTER TABLE ".$prefix."_poll_desc DROP comments ");

// Articles rating system Backdate
$db->sql_query("ALTER TABLE ".$prefix."_stories DROP rating_ip ");

// Topic image field length Decreased
$db->sql_query("ALTER TABLE ".$prefix."_topics CHANGE topicimage topicimage varchar(20) default NULL");

// Forums Table Backdate *
$db->sql_query("UPDATE ".$prefix."_bbconfig SET config_value='.0.10' WHERE config_name='version'");
$db->sql_query("DROP TABLE IF EXISTS".$prefix."_bbsessions session_admin tinyint(2) DEFAULT '0' NOT NULL");
$db->sql_query("CREATE TABLE ".$prefix."_bbsessions (session_id char(32) NOT NULL default '', session_user_id mediumint(8) NOT NULL default '0', session_start int(11) NOT NULL default '0', session_time int(11) NOT NULL default '0', session_ip char(8) NOT NULL default '0', session_page int(11) NOT NULL default '0', session_logged_in tinyint(1) NOT NULL default '0', PRIMARY KEY (session_id), KEY session_user_id (session_user_id), KEY session_id_ip_user_id (session_id,session_ip,session_user_id))");

// Banners Table Alteration
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_banner_positions");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_banner_terms");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_banner_plans");
$db->sql_query("ALTER TABLE ".$prefix."_banner_clients RENAME nuke_bannerclient");
$db->sql_query("ALTER TABLE ".$prefix."_banner DROP ad_class , DROP ad_code , DROP ad_width , DROP ad_height ");
$db->sql_query("ALTER TABLE ".$prefix."_banner CHANGE type position INT( 10 ) DEFAULT '0' NOT NULL");
$db->sql_query("ALTER TABLE ".$prefix."_banner DROP name");
$db->sql_query("ALTER TABLE ".$prefix."_banner CHANGE type tinyint(1) NOT NULL default '0'");

// Tables user field length defixes
$db->sql_query("alter table ".$prefix."_stories change informant informant varchar(20) NOT NULL default ''");
$db->sql_query("alter table ".$prefix."_stories change aid aid varchar(30) NOT NULL default ''");
$db->sql_query("alter table ".$prefix."_autonews change informant informant varchar(20) NOT NULL default ''");
$db->sql_query("alter table ".$prefix."_autonews change aid aid varchar(30) NOT NULL default ''");
$db->sql_query("alter table ".$prefix."_reviews change reviewer reviewer varchar(20) default NULL");
$db->sql_query("alter table ".$prefix."_reviews_add change reviewer reviewer varchar(20) not null default ''");

// Countries and Cities Table Drop
// It's used in the banners system and will be used in the future. Very useful for some modules developers

$db->sql_query("DROP TABLE IF EXISTS nuke_cities");

// PHP-Nuke copyright notice modification. (c) year changed.
$db->sql_query("UPDATE ".$prefix."_config SET copyright='<a href=\"http://phpnuke.org\">PHP-Nuke</a> Copyright © 2006 by Francisco Burzi. This is free software, and you may redistribute it under the <a href=\"http://phpnuke.org/files/gpl.txt\">GPL</a>. PHP-Nuke comes with absolutely no warranty, for details, see the <a href=\"http://phpnuke.org/files/gpl.txt\">license</a>.'");

// PHP-Nuke Version Number Update
$db->sql_query("UPDATE ".$prefix."_config SET Version_Num='7.6'");

OpenTable();

echo " PHP-Nuke Update finished! "
."Your Php Nuke Version is now 7.6 "
."You should now delete this Downgrade file from your server. ";

CloseTable();
}

include(dirname(__FILE__) . "/footer.php");

?>