vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Combining tables (https://vborg.vbsupport.ru/showthread.php?t=151155)

Norco 07-02-2007 04:33 AM
Combining tables
 
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 07-02-2007 05:07 AM
The table structures are most likely different.

Norco 07-02-2007 05:11 AM
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 07-02-2007 05:19 AM
Yes, it should be possible.

Norco 07-02-2007 09:35 PM
Quote:
Originally Posted by Dismounted (Post 1281045)
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 07-03-2007 05:52 AM
PM me your MSN handle.

Antivirus 07-03-2007 07:36 PM
I would just use the vbulletin impex system to import the users.

Norco 07-03-2007 08:50 PM
Quote:
Originally Posted by Antivirus (Post 1282154)
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:
Code:
  `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..


All times are GMT. The time now is 08:55 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01139 seconds
  • Memory Usage 1,728KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete