Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2007, 04:33 AM
Norco Norco is offline
 
Join Date: Jun 2007
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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?
Reply With Quote
  #2  
Old 07-02-2007, 05:07 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The table structures are most likely different.
Reply With Quote
  #3  
Old 07-02-2007, 05:11 AM
Norco Norco is offline
 
Join Date: Jun 2007
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #4  
Old 07-02-2007, 05:19 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, it should be possible.
Reply With Quote
  #5  
Old 07-02-2007, 09:35 PM
Norco Norco is offline
 
Join Date: Jun 2007
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Dismounted View Post
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?
Reply With Quote
  #6  
Old 07-03-2007, 05:52 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PM me your MSN handle.
Reply With Quote
  #7  
Old 07-03-2007, 07:36 PM
Antivirus's Avatar
Antivirus Antivirus is offline
 
Join Date: Sep 2004
Location: Black Lagoon
Posts: 1,090
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would just use the vbulletin impex system to import the users.
Reply With Quote
  #8  
Old 07-03-2007, 08:50 PM
Norco Norco is offline
 
Join Date: Jun 2007
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Antivirus View Post
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..
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:38 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03913 seconds
  • Memory Usage 2,228KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete