Change User ID

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
4
67%
Very Good
0
No votes
Good
1
17%
Fair
0
No votes
Poor
1
17%
 
Total votes: 6

Extensions Robot
Extensions Robot
Extensions Robot
Posts: 28602
Joined: Sat Aug 16, 2003 7:36 am

Change User ID

Post by Extensions Robot »

Modification name: Change User ID
Author: kp3011
Modification description: This MOD allows the admin to change the user ID of any particular user in the admin panel. Simply click into Users Admin and change the number.
Modification version: 1.0.2
Tested on phpBB version: 2.0.22

Download file: Change_User_ID_1
File size: 7865 Bytes

Modification overview page: View


Selected tags:
  1. category
    1. Add-Ons
    2. Admin Tools
  2. phpbb
    1. 2.0.21
    2. 2.0.22
Support for this modification needs to be asked within this topic. The phpBB Team is not responsible or required to give anyone support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB MODifications Team may not be able to provide support.

This MOD has only been tested by the phpBB MOD Team with the phpBB version listed in the topic. It may not work in any other versions of phpBB.
Last edited by Extensions Robot on Tue Jul 17, 2007 7:31 pm, edited 2 times in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)
User avatar
webmacster87
Former Team Member
Posts: 3758
Joined: Fri Jun 11, 2004 2:30 am
Location: San Mateo, CA
Name: Douglas Bell
Contact:

Post by webmacster87 »

MOD Validated/Released

Notes:
Allows a user to change his/her user ID on the board to a different one, provided that it is not already in use by another member.
PanTzeR
Registered User
Posts: 32
Joined: Mon Sep 05, 2005 9:42 am
Contact:

Post by PanTzeR »

What it could be useful for?
kp3011
Registered User
Posts: 480
Joined: Fri Aug 27, 2004 4:58 am

Post by kp3011 »

Thanks for validating this MOD for me :)
PanTzeR wrote: What it could be useful for?
Everyone has a user ID in phpBB forums (eg your number is 204924 and mine is 137646) In certain boards, some members might would like to change this (eg for his preference) and this MOD can help with that.
kp3011
Registered User
Posts: 480
Joined: Fri Aug 27, 2004 4:58 am

Post by kp3011 »

Sorry for pushing this topic, but seems the MOD doesn't exist on the server :wink:
User avatar
stickerboy
Former Team Member
Posts: 7349
Joined: Mon Mar 29, 2004 2:27 pm
Location: Airdrie, UK (127.0.0.1)
Name: Kenny Cameron
Contact:

Post by stickerboy »

kp3011 wrote: Sorry for pushing this topic, but seems the MOD doesn't exist on the server :wink:

http://www.phpbb.com/files/mods/Change User ID_a.mod
works fine for me :?
give it another try :wink:
I'm a web-designing code-decrypting tech-support musician
|| Twitter || Flickr || phpBB Snippets ||
Formerly known as cherokee red
User avatar
igorw
Former Team Member
Posts: 8024
Joined: Fri Dec 16, 2005 12:23 pm
Location: {postrow.POSTER_FROM}
Name: Igor Wiedler

Post by igorw »

This MOD is cool, installing now! Thanks! :D
Igor Wiedler | area51 | GitHub | trashbin | Formerly known as evil less than three
binarysins
Registered User
Posts: 7
Joined: Sat May 27, 2006 1:00 am

Post by binarysins »

kp3011 wrote: Thanks for validating this MOD for me :)
PanTzeR wrote:What it could be useful for?
Everyone has a user ID in phpBB forums (eg your number is 204924 and mine is 137646) In certain boards, some members might would like to change this (eg for his preference) and this MOD can help with that.


I really don't want to seem dense, but being a data analyst/DBA I just checked the users table and it appears user_id is not set to autoincrement (which is the only way that this mod would work). I still fail to see why it would be useful to change a user's id to whatever you want, but at least there won't be any ID collisions.

However, what about updating tables that are the results of other mods that have a user_id column? Is there the equivalent in mySQL to information_schema.columns where you can look for a column like '%user_id%' and update that?
kp3011
Registered User
Posts: 480
Joined: Fri Aug 27, 2004 4:58 am

Post by kp3011 »

binarysins wrote: I really don't want to seem dense, but being a data analyst/DBA I just checked the users table and it appears user_id is not set to autoincrement (which is the only way that this mod would work). I still fail to see why it would be useful to change a user's id to whatever you want, but at least there won't be any ID collisions.

However, what about updating tables that are the results of other mods that have a user_id column? Is there the equivalent in mySQL to information_schema.columns where you can look for a column like '%user_id%' and update that?
Thanks for your comments.

In fact this MOD is not used for auto-increment. It simply changes the userid of any existing member to another one if and only if there is no collision.

This MOD updates the relevant tables' user_id columns.
Wyvers
Registered User
Posts: 14
Joined: Sat Mar 11, 2006 10:39 pm

Post by Wyvers »

After installing this mod I can't make any changes to user profiles. For some reason I get the message "Sorry, but this username has already been taken." across the top of the page and none of the settings have changed. Anyone know why? Reinstalling from clean backups doesn't.

Edit: It just seems to happen when changing a users rank only. Uninstalling breaks the acp =/
User avatar
WileCoyote
Registered User
Posts: 432
Joined: Sun Jan 15, 2006 7:37 am
Location: Austria
Name: Wolfgang
Contact:

Post by WileCoyote »

Same Problem here. After installing another MOD which requires to edit the admin_users.php i can't change any user settings without getting the message "Sorry, but this username has already been taken." Only deleting the user is possible
kp3011
Registered User
Posts: 480
Joined: Fri Aug 27, 2004 4:58 am

Post by kp3011 »

Sorry for the trouble.

I've just submitted a corrected version which corrected the bug that caused the problem.

I think it'll be avilable in a few days.

Sorry again for the inconvenience.
User avatar
Kellanved
Former Team Member
Posts: 2635
Joined: Wed Jan 26, 2005 2:48 pm
Location: Meta-level

Post by Kellanved »

MOD Updated to version 1.0.1
See first post for Download Link
Nocando is in Idontwanna county. No support via PM
User avatar
igorw
Former Team Member
Posts: 8024
Joined: Fri Dec 16, 2005 12:23 pm
Location: {postrow.POSTER_FROM}
Name: Igor Wiedler

Post by igorw »

Wow, that was quick 8O
Igor Wiedler | area51 | GitHub | trashbin | Formerly known as evil less than three
User avatar
Roks
Registered User
Posts: 119
Joined: Thu Sep 14, 2006 1:15 am

Post by Roks »

Thanks kp3011 for the MOD, I will soon install.

Thanks evil for directing me to this page.
Post Reply

Return to “[2.0.x] MOD Database Releases”