Where are members accounts located in MySQL database?

lies · New Member Joined: Oct 11, 2006 Posts: 12

I have the newest version of raven, but I want to use Platinum 7.6.b.4v2 Full Version instead. (mainly because of the arcade).

Is it possible to locate in MySql with phpmyadmin where the members accounts are located in my raven database and then import them into a new database that has nuke platinum? I currently have ravenNuke in my root folder and Platinum in a sub.

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2758

Platinum may run other addons that change the users table. You will have to compare the table structures to see which fields are added or removed. Once the tables match, you should be able to move all the data over

Loki · Regular Joined: Oct 05, 2003 Posts: 62

The nuke_users table is what you would need to convert. I am not familiar with ravens version so I would have to look at the table for the conversion. Here is the table structure for 7.6.b.4.v2.

Code:

CREATE TABLE IF NOT EXISTS `nuke_users` (
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '1',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'english',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '0',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`last_ip` varchar(15) NOT NULL default '0',
`user_color_gc` varchar(6) default NULL,
`user_color_gi` text,
`user_quickreply` tinyint(1) NOT NULL default '0',
`user_allow_arcadepm` tinyint(4) NOT NULL default '0',
`kick_ban` int(2) NOT NULL default '0',
`user_wordwrap` smallint(2) NOT NULL default '70',
`agreedtos` tinyint(1) NOT NULL default '0',
`user_view_log` tinyint(4) NOT NULL default '0',
`user_effects` varchar(255) default NULL,
`user_privs` varchar(255) default NULL,
`user_custitle` text,
`user_specmsg` text,
`user_items` text,
`user_trade` text,
`points` decimal(11,2) NOT NULL default '0.00',
`user_cash` decimal(11,2) NOT NULL default '0.00',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`)
) ;

#
# Dumping data for table `nuke_users`
#

INSERT INTO `nuke_users` VALUES (1, '', 'Anonymous', '', '', '', 'blank.gif', 'Sep 9, 2005', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 10.00, NULL, 'english', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL, NULL, NULL, '0', '', '0', 1, 0, 0, 70, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00);

Here is a list of upgrade changes from Nuke 7.6 up to Platinum 7.6.b.4v2 compare them to ravens sql.

Code:

ALTER TABLE nuke_users ADD user_color_gc VARCHAR(6) DEFAULT '';
ALTER TABLE nuke_users ADD user_color_gi INT(10) DEFAULT '0';
ALTER TABLE nuke_users ADD user_allow_arcadepm TINYINT( 0 ) DEFAULT '1' NOT NULL;
ALTER TABLE nuke_users ADD user_quickreply TINYINT(1) DEFAULT '1' NOT NULL ;
UPDATE nuke_users SET user_quickreply=0 WHERE user_id=-1;
ALTER TABLE nuke_users ADD `kick_ban` INT( 2 ) DEFAULT '0' NOT NULL;
ALTER TABLE nuke_users ADD user_wordwrap SMALLINT(2) DEFAULT '99' NOT NULL;
ALTER TABLE nuke_users ADD agreedtos TINYINT(1) DEFAULT 0 NOT NULL;
ALTER TABLE nuke_users_temp ADD realname VARCHAR(255) NOT NULL AFTER username;
ALTER TABLE `nuke_users` CHANGE `user_allow_arcadepm` `user_allow_arcadepm` TINYINT( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `nuke_users` CHANGE `user_timezone` `user_timezone` DECIMAL( 5, 2 ) DEFAULT '0.00' NOT NULL;
ALTER TABLE `nuke_users` CHANGE `user_color_gi` `user_color_gi` TEXT DEFAULT NULL;
ALTER TABLE `nuke_users` ADD user_view_log TINYINT NOT NULL DEFAULT '0';
UPDATE `nuke_users` SET user_allow_arcadepm="0";
ALTER TABLE nuke_users ADD user_effects varchar(255);
ALTER TABLE nuke_users ADD user_privs varchar(255);
ALTER TABLE nuke_users ADD user_custitle text;
ALTER TABLE nuke_users ADD user_specmsg text;
ALTER TABLE nuke_users ADD user_items text;
ALTER TABLE nuke_users ADD user_trade text;
UPDATE nuke_users SET user_active = 0 WHERE user_id = '1';
ALTER TABLE nuke_users ADD user_cash decimal(11,2) NOT NULL DEFAULT '0.00';

Captain_Computer · Hangin' Around Joined: May 30, 2004 Posts: 46

No need to jump ship and turn to Platinum. I've got V3 Arcade working on RavenNuke76 v2.00.00 - v2.02.00 Distro.

Download

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

There will be a couple of fields that need to be added to raven nuke_users table. It has been quite some time since I installed the Arcade. You can check the Platinum nuke_users table against raven nuke_users table. This download does add one field to nuke_users table "user_allow_arcadepm". You'll only need to add fields if you get errors running the Arcade.

ctec · New Member Joined: Aug 18, 2005 Posts: 4 Location: Texas

phpMyAdmin would help you in this matter. Simple install and you can run queries in a GUI.

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