vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Easy way to edit 3600 users? (https://vborg.vbsupport.ru/showthread.php?t=81182)

Watson 05-09-2005 09:53 AM

Easy way to edit 3600 users?
 
I am wondering if there is an easy way to change 3600 odd users from there user ID's

The list in the user table is running out of sequence, and I would like the userid's to run from 1-3600 in sequence, but instead the run like 1,2,4,6,8 from inactive members that have been deleted.

Is there any easy way to do this other than editing them all manually which I worked out will take hours :)


This is so I can merge them with another table

Cheers

Watson

Brad 05-09-2005 09:56 AM

Quote:

Originally Posted by Watson
I am wondering if there is an easy way to change 3600 odd users from there user ID's

The list in the user table is running out of sequence, and I would like the userid's to run from 1-3600 in sequence, but instead the run like 1,2,4,6,8 from inactive members that have been deleted.

Is there any easy way to do this other than editing them all manually which I worked out will take hours :)


This is so I can merge them with another table

Cheers

Watson

Its really pointless and not worth it, changing them in the user table is going to throw all the other places that store userid's out of wack.

Userid's act like this so there is never a conflict. :)

Marco van Herwaarden 05-09-2005 12:15 PM

It would be like asking if we can give everybody in my class a new birthday, so we would have birthday on consecutive days.

This will cause you so much problems, it is never worth it.

Paul M 05-09-2005 12:22 PM

This would be a very quick way to completely break your board - the userids are embedded in all the major vb tables.

Marco van Herwaarden 05-09-2005 12:32 PM

Not even to mention links to userids posted as URL's.

Or if attachments are stored in teh filesystem, the directory names where the attachments are stored.

Just 1 advice: Forget it!

Watson 05-09-2005 01:14 PM

k cheers guy, need to find another way of doing it then :)

Zachery 05-09-2005 01:24 PM

Quote:

Originally Posted by Watson
k cheers guy, need to find another way of doing it then :)

What good reason do you have for renumbering your users...

Watson 05-09-2005 01:26 PM

running a torrent tracker, and trying to get the users to line up with each other so that they dont have to re-register on another tracker, and we can get stats to work, but it didnt work too well heh

Reeve of shinra 05-09-2005 01:31 PM

Maybe you could reimport your board using the vb importer? I am not sure how that works but vb to vb imports must renumber the user id's to avoid conflicts.

Marco van Herwaarden 05-09-2005 01:39 PM

I still don't see why members must have consecutive id's for a tracker?

But why don't you just add a new field to the user table. If you add it, you can do with it whatever you want.


All times are GMT. The time now is 03:21 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.01144 seconds
  • Memory Usage 1,729KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete