Welcome, Guest. Please Login or Register.
April 26, 2025, 05:47:02 PM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  Development  |  Converters  |  vBulletin to YaBBSE conversion? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: vBulletin to YaBBSE conversion?  (Read 682 times)
Lauren
Noobie
*
Posts: 1


I'm a llama!

vBulletin to YaBBSE conversion?
« on: November 23, 2002, 03:07:03 AM »
Reply with quote

I am helping with a site that is converting from vB to YaBBSE.  Is there any way to use the mySQL user table from vB and somehow convert it (typing in 230+ profiles isn't my idea of a wonderful time)?  Here's the table structure.  Thank you very much for any help that you can provide! Just email me if you have any questions.
 
# Table structure for table `user`
#
 
CREATE TABLE user (
  userid int(10) unsigned NOT NULL auto_increment,
  usergroupid smallint(5) unsigned NOT NULL default '0',
  username varchar(50) NOT NULL default '',
  password varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  styleid smallint(5) unsigned NOT NULL default '0',
  parentemail varchar(50) NOT NULL default '',
  coppauser smallint(6) NOT NULL default '0',
  homepage varchar(100) NOT NULL default '',
  icq varchar(20) NOT NULL default '',
  aim varchar(20) NOT NULL default '',
  yahoo varchar(20) NOT NULL default '',
  signature mediumtext NOT NULL,
  adminemail smallint(6) NOT NULL default '0',
  showemail smallint(6) NOT NULL default '0',
  invisible smallint(6) NOT NULL default '0',
  usertitle varchar(250) NOT NULL default '',
  customtitle smallint(6) NOT NULL default '0',
  joindate int(10) unsigned NOT NULL default '0',
  cookieuser smallint(6) NOT NULL default '0',
  daysprune smallint(6) NOT NULL default '0',
  lastvisit int(10) unsigned NOT NULL default '0',
  lastactivity int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  posts smallint(5) unsigned NOT NULL default '0',
  timezoneoffset varchar(4) NOT NULL default '',
  emailnotification smallint(6) NOT NULL default '0',
  buddylist mediumtext NOT NULL,
  ignorelist mediumtext NOT NULL,
  pmfolders mediumtext NOT NULL,
  receivepm smallint(6) NOT NULL default '0',
  emailonpm smallint(6) NOT NULL default '0',
  pmpopup smallint(6) NOT NULL default '0',
  avatarid smallint(6) NOT NULL default '0',
  options smallint(6) NOT NULL default '15',
  birthday date NOT NULL default '0000-00-00',
  maxposts smallint(6) NOT NULL default '-1',
  startofweek smallint(6) NOT NULL default '1',
  ipaddress varchar(20) NOT NULL default '',
  referrerid int(10) unsigned NOT NULL default '0',
  nosessionhash smallint(6) NOT NULL default '0',
  inforum smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (userid),
  KEY usergroupid (usergroupid),
  KEY username (username),
  KEY inforum (inforum)
) TYPE=MyISAM;
« Last Edit: November 23, 2002, 03:07:47 AM by Lauren » Logged
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  Development  |  Converters  |  vBulletin to YaBBSE conversion? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.009 seconds with 16 queries.