Combining tables

[Norco]

Hello, I have a user system website which has 4000 members (A little over now). I want to add these to my vB. So I put the site db into the vb db, (with all the vb tables having a prefix of vb_) I copied the table all my site users are in, added it to the table called vb_user. But, in my vb statistics, it still says only 1 member is joined, when really it would be 4081. Where do I change this in the database?

[Dismounted]

The table structures are most likely different.

[Norco]

Well, it is. I added them all, and then searched for one random user that I added in the acp, and it would show the page to edit all their details.. but the fields were all empty.

Would it be POSSIBLE to integrate these?

If so, Ill post in the thread to pay someone to help me with it.

[Dismounted]

Yes, it should be possible.

[Norco]

Originally Posted by Dismounted

Yes, it should be possible.

Do you think you could get in contact with me (MSN messenger probably) and you can take a look at the database and such, and give me a quote of how much you would charge to help me, or assist me do it?

[Dismounted]

PM me your MSN handle.

[Antivirus]

I would just use the vbulletin impex system to import the users.

[Norco]

Originally Posted by Antivirus

I would just use the vbulletin impex system to import the users.

The database system is completely different.

For example, most of the feilds are different, and dates I have set as like 'June 19 2007' instead of the time in the time function time(); (eg. 198474589)

Ill post how my user table is setup:

  `id` int(11) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `password` varchar(95) NOT NULL default '',
  `salt` char(3) NOT NULL default '',
  `email` varchar(85) NOT NULL default '',
  `group_id` int(11) NOT NULL default '2',
  `banned_message` text NOT NULL,
  `banned_time` text NOT NULL,
  `avatar` varchar(255) NOT NULL default 'nopic.gif',
  `sig` text NOT NULL,
  `joindate` text NOT NULL,
  `ip` text NOT NULL,
  `points` int(11) NOT NULL default '20',
  `rare` text NOT NULL,
  `norm` text NOT NULL,
  `staff` text NOT NULL,
  `x` text NOT NULL,
  `website` text NOT NULL,
  `bio` varchar(250) NOT NULL default '',
  `online` varchar(12) NOT NULL default '',
  `invisible` text NOT NULL,
  `alert` varchar(255) NOT NULL default 'Empty',
  `CA` text NOT NULL,
  `US` text NOT NULL,
  `AU` text NOT NULL,
  `UK` text NOT NULL,
  `SG` text NOT NULL,
  `referral` text NOT NULL,
  `ubadges` text NOT NULL,
  `skin` varchar(50) NOT NULL default 'skin',
  `gender` text NOT NULL,
  `Activation_Code` bigint(20) NOT NULL default '0',
  `Activated` varchar(10) NOT NULL default '',
  `colour` text NOT NULL,
  `colour2` text NOT NULL,
  `advert` text NOT NULL,
  `bannedhours` varchar(255) NOT NULL default '',
  `pin` text NOT NULL,
  PRIMARY KEY  (`id`)

Now.. tables which can change would be like id to userid but I need the other things for my website system, then add the vb stuff. I already did that although, all 4000 members where in the db, but when I would search them in the acp user search, it would show the page to display all the info, but it was ALL blank (eg username, email...) and it didn't update the member count..

I was looking through the acp, the only thing I could think to do it 'rebuild' the forum statistics? I don't know if I should try that or not..