Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

how to convert user tables..
 View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x
Author Message
Plasma
Regular
Regular



Joined: May 17, 2005
Posts: 66
PostPosted: Sat Aug 13, 2016 6:43 am Reply with quote
Is there an easy way to convert nuke_user tables, which is from my older site, to match what i'm using with Raven.

When i try and replace the current with the older version the site won't load..

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,


  `ublockon` tinyint(1) NOT NULL DEFAULT '0',


  `ublock` tinytext,


  `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 '0',


  `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` tinyint(4) NOT NULL DEFAULT '10',


  `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,


  `points` int(10) DEFAULT '0',


  `last_ip` varchar(15) NOT NULL DEFAULT '0',


  `user_login_tries` smallint(5) unsigned NOT NULL DEFAULT '0',


  `user_last_login_try` int(11) NOT NULL DEFAULT '0',


  `agreedtos` tinyint(1) NOT NULL DEFAULT '0',


  `lastsitevisit` int(11) NOT NULL DEFAULT '0',


  PRIMARY KEY (`user_id`),


  KEY `uname` (`username`),


  KEY `user_session_time` (`user_session_time`)


) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;





--


-- Table structure for table `nuke_users`


--





DROP TABLE IF EXISTS `nuke_users`;


/*!40101 SET @saved_cs_client     = @@character_set_client */;


/*!40101 SET character_set_client = utf8 */;


CREATE TABLE `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 '0',


  `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` tinyint(4) NOT NULL DEFAULT '10',


  `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,


  `points` int(10) DEFAULT '0',


  `user_group_cp` int(11) NOT NULL DEFAULT '2',


  `user_group_list_cp` varchar(100) NOT NULL DEFAULT '2',


  `user_active_cp` enum('YES','NO') NOT NULL DEFAULT 'YES',


  `user_lastvisit_cp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',


  `user_regdate_cp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',


  `last_seen_blocker` int(11) NOT NULL DEFAULT '0',


  `last_ip` varchar(15) NOT NULL DEFAULT '0',


  `custom1` varchar(255) NOT NULL DEFAULT '',


  `custom2` varchar(255) NOT NULL DEFAULT '',


  `custom3` varchar(255) NOT NULL DEFAULT '',


  `custom4` varchar(255) NOT NULL DEFAULT '',


  `custom5` varchar(255) NOT NULL DEFAULT '',


  `user_show_custom1` tinyint(2) NOT NULL DEFAULT '1',


  `user_show_custom2` tinyint(2) NOT NULL DEFAULT '1',


  `user_show_custom3` tinyint(2) NOT NULL DEFAULT '1',


  `user_show_custom4` tinyint(2) NOT NULL DEFAULT '1',


  `user_show_custom5` tinyint(2) NOT NULL DEFAULT '1',


  `user_chatting` int(11) NOT NULL DEFAULT '0',


  `karma` tinyint(1) DEFAULT '0',


  `user_allow_arcadepm` tinyint(4) NOT NULL DEFAULT '1',


  PRIMARY KEY (`user_id`),


  KEY `uid` (`user_id`),


  KEY `uname` (`username`),


  KEY `user_session_time` (`user_session_time`),


  KEY `karma` (`karma`)


) ENGINE=MyISAM AUTO_INCREMENT=2219 DEFAULT CHARSET=latin1;


/*!40101 SET character_set_client = @saved_cs_client */;




and I need to match


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,


  `ublockon` tinyint(1) NOT NULL DEFAULT '0',


  `ublock` tinytext,


  `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 '0',


  `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` tinyint(4) NOT NULL DEFAULT '10',


  `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,


  `points` int(10) DEFAULT '0',


  `last_ip` varchar(15) NOT NULL DEFAULT '0',


  `user_login_tries` smallint(5) unsigned NOT NULL DEFAULT '0',


  `user_last_login_try` int(11) NOT NULL DEFAULT '0',


  `agreedtos` tinyint(1) NOT NULL DEFAULT '0',


  `lastsitevisit` int(11) NOT NULL DEFAULT '0',


  PRIMARY KEY (`user_id`),


  KEY `uname` (`username`),


  KEY `user_session_time` (`user_session_time`)


) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;





--


-- Dumping data for table `nuke_users`


--





INSERT INTO `nuke_users` (`user_id`, `name`, `username`, `user_email`, `femail`, `user_website`, `user_avatar`, `user_regdate`, `user_icq`, `user_occ`, `user_from`, `user_interests`, `user_sig`, `user_viewemail`, `user_theme`, `user_aim`, `user_yim`, `user_msnm`, `user_password`, `storynum`, `umode`, `uorder`, `thold`, `noscore`, `bio`, `ublockon`, `ublock`, `theme`, `commentmax`, `counter`, `newsletter`, `user_posts`, `user_attachsig`, `user_rank`, `user_level`, `broadcast`, `popmeson`, `user_active`, `user_session_time`, `user_session_page`, `user_lastvisit`, `user_timezone`, `user_style`, `user_lang`, `user_dateformat`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_emailtime`, `user_allowhtml`, `user_allowbbcode`, `user_allowsmile`, `user_allowavatar`, `user_allow_pm`, `user_allow_viewonline`, `user_notify`, `user_notify_pm`, `user_popup_pm`, `user_avatar_type`, `user_sig_bbcode_uid`, `user_actkey`, `user_newpasswd`, `points`, `last_ip`, `user_login_tries`, `user_last_login_try`, `agreedtos`, `lastsitevisit`) VALUES


(1, '', 'Anonymous', '', '', '', 'blank.gif', 'Oct 10, 2008', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, 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', 0, 0, 0, 0),


(2, 'plasma', 'plasma', 'plasmafused@hotmail.com', '', '', 'blank.gif', 'Jul 01, 2016', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'af52eca2e70ae22b5b6636f68765c451', 10, '', 0, 0, 0, NULL, 0, NULL, 'lightmulti', 4096, 0, 0, 1, 0, 0, 2, 1, 0, 1, 1470677348, 0, 1470422645, 10, NULL, 'english', 'D M d, Y g:i a', 0, 0, 1469850574, NULL, 1, 1, 1, 1, 1, 1, 0, 0, 0, 3, NULL, NULL, NULL, 0, '73.54.169.100', 0, 0, 0, 1471057095);





/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;


/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 
View user's profile Send private message
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6432
PostPosted: Sat Aug 13, 2016 7:36 am Reply with quote
Not sure there is an easy way. But if you look at the upgrade scripts, you can see the changes that are applied to the user tables when upgrading from previous versions. That could help you make the same changes to your user tables.

Of course, test this on a local installation before doing it on a live site. Smile

_________________
I search, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG 
View user's profile Send private message
kguske
PostPosted: Sat Aug 13, 2016 7:38 am Reply with quote
Also, you can use the table compare utility to identify differences between your user tables and what's expected by RN.
 
Plasma
PostPosted: Sun Aug 14, 2016 5:09 pm Reply with quote
Thank you, I will see what I can do..
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RavenNuke(tm) v2.5x


 Jump to:   




View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©