Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
user import problem Details »»
user import problem
Version: , by sledgeboy sledgeboy is offline
Developer Last Online: Sep 2002 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-27-2002 Last Update: Never Installs: 0
 
No support by the author.

Hi i´ve just imported 9000 users from our old database (using version 2.0.3 ) to our new one (2.2.6). Everthing worked perfect but no user can log on anymore because there is a new table called "useractivation" but this table isn´t n the old database. so i think the boarb thinks that all those users haven´t activated their account yet, so how can i make the board accept those users and see them as activated ? Please answer quickly it´s very important for us to hold the board online and working !

And please forgive my bad english, i´m not from the US and it isn´t as good as well !

Greetings

Sledge

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-28-2002, 06:24 AM
scsa20's Avatar
scsa20 scsa20 is offline
 
Join Date: Mar 2002
Location: Mars
Posts: 458
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

actuly, if I remember reading around the board, 2.0.3 never encripted user passwords, but in 2.2.x it did...so what you might have to do is change all the users password and e-mail it to them asking them to change it right away (one way is just change there password to there userid number and do a mulit-email to all your users using that one code that shows there userid number as there password).
Reply With Quote
  #3  
Old 06-28-2002, 10:45 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

write a small script to encrypt ther pws automatically:

[php]
<?php
require('./global.php');
for($i=2;$i<=9000;$i++) {
$info=$DB_site->query_first("SELECT userid,password FROM user WHERE userid='".$i."');
if($info[userid]==$i) $DB_site->query("UPDATE user SET password='".md5($info[password])."' WHERE userid='".$i."');

}
?>

replace the 9000 with the highest userid you have
Reply With Quote
  #4  
Old 06-28-2002, 11:00 AM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Xenon
write a small script to encrypt ther pws automatically:

PHP Code:
<?php
require('./global.php');
for(
$i=2;$i<=9000;$i++) {
$info=$DB_site->query_first("SELECT userid,password FROM user WHERE userid='".$i."');
if(
$info[userid]==$i$DB_site->query("UPDATE user SET password='".md5($info[password])."' WHERE userid='".$i."');

}
?>
replace the 9000 with the highest userid you have
Ouch man, that'll cause 18,000 queries a large headache to your host!

PHP Code:
<?php
require('./global.php');
$DB_site->query('UPDATE user SET password=MD5(password)');
echo 
'Yes, we did it!';
?>
Unless you have a terribly old version of MySQL which doesn't support the MD5() function.
Reply With Quote
  #5  
Old 06-28-2002, 11:21 AM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hehe, hosts just want to have fun

i didn't know that MD5 is also an MySQL-included function.
thank, learning never ends
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 12:35 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.04151 seconds
  • Memory Usage 2,240KB
  • Queries Executed 18 (?)
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
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (4)postbit
  • (5)postbit_onlinestatus
  • (5)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