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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2004, 11:43 AM
*****Sniper *****Sniper is offline
 
Join Date: Apr 2004
Location: Firenze
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default insert into user table problem

I am importing the moderators data from an old forum to vb3.

this is my insert statement
"INSERT INTO
user (userid, usergroupid, membergroupids, displaygroupid, username, email, usertitle, reputation, reputationlevelid, timezoneoffset, options, startofweek, passworddate, joindate )
VALUES ('".$row2['id_comm']."', '$userGroupid', '$memberGroupid', '$displayGroupid', '".$row1['username']."', '$email', '$userTitle', '$reputation', '$reputationid', '$timeZone', '$options', '$startWeek', '$passwordDate', '$joinDate' )";

[do you need to see what i values i put in for all the constants?]

i did this for a couple of results just to check if it worked.
it did the insert correctly, and the usernames and their respective emails showup when I look at all the users present in the admincp.
but (you knew this was coming) when i click on the username (to modify the profile or something) it does nothing. when i look at the bottom of the screen it says

/admincp/user.php?do=edit&userid=

there is no userid (whereas for test subjects the userid shows up)
what do i do? is the userid number a problem. (i inserted thru admincp about 6 users, so have userids 2-7 filled when i insert thru the script to the database the userid are 5697988 & 3479651 this shouldnt be a problem tho in the database it says int(10)
Reply With Quote
  #2  
Old 05-12-2004, 11:56 AM
NTLDR's Avatar
NTLDR NTLDR is offline
Coder
 
Join Date: Apr 2002
Location: Bristol, UK
Posts: 3,644
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Entries also need to be inserted into the userfield and usertextfield for each user added. Try the Fix Broken Profile option under Update Counters which should repair them.
Reply With Quote
  #3  
Old 05-12-2004, 12:06 PM
*****Sniper *****Sniper is offline
 
Join Date: Apr 2004
Location: Firenze
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yes that did work, thanx a bunch! you think it will work when i import all 500 users??? it'll do it for all of them?

-update-
actually i just checked out the tables and i can do it myself! thanx again!
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 02:59 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.03524 seconds
  • Memory Usage 2,173KB
  • Queries Executed 13 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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