Media » Community Downloads » Code Snippets » Changing Username Script (SQL)

Changing Username Script (SQL)

Previous | Next | View all files | View Slideshow
posted by David Voss
Mon, Oct 3 2005
Downloads: 776
File size: 974 B
Views: 4,676
Changing Username Script (SQL)
The purpose of this script is for changing a username in CS 1.1. A quick check of the aspnet_Users table is performed before executing the update statements. The update statements are wrapped in a transaction. Known Issues / Limitations
  • This query does not validate the new username against Disallowed Names.
  • This query will not update the post body, including reports found within the Reporting Forum where the Post author is displayed in the report details.
  • The cs_EmailQueue is not included.
  • This will not update any tables outside of the original CS tables.
References (previous discussions) Changing Username Script (SQL) Why is it not possible to change a user name? Is there a way to change a user's login name?

Comments

kids games wrote re: Changing Username Script (SQL)
on Mon, Apr 9 2007 4:05 AM
thanks ,
stuff.wslaat.com wrote re: Changing Username Script (SQL)
on Thu, Apr 12 2007 10:35 AM
Well done
ghazwan wrote re: Changing Username Script (SQL)
on Sun, May 27 2007 6:08 PM
Thanks for the SQL , can i found a php script that includs this sql script with Search Form , and Edit page to change username ?? regards .
games for all wrote re: Changing Username Script (SQL)
on Mon, Aug 27 2007 2:46 PM
Thanks
game wrote re: Changing Username Script (SQL)
on Wed, Aug 29 2007 7:41 AM
gooooood
forum. wrote re: Changing Username Script (SQL)
on Thu, Aug 30 2007 12:52 AM
Thank you
swish wrote re: Changing Username Script (SQL)
on Fri, Aug 31 2007 3:01 AM
Thanks for you
ar dir wrote re: Changing Username Script (SQL)
on Fri, Aug 31 2007 8:32 AM
nice share thanks
mhmdkhamis wrote re: Changing Username Script (SQL)
on Tue, Sep 11 2007 8:20 AM
thanks
mhmdkhamis wrote re: Changing Username Script (SQL)
on Tue, Sep 11 2007 8:22 AM
great
mhmdkhamis wrote re: Changing Username Script (SQL)
on Tue, Sep 11 2007 8:31 AM
nice pices
mhmdkhamis wrote re: Changing Username Script (SQL)
on Tue, Sep 11 2007 8:34 AM
great photo
upload photos wrote re: Changing Username Script (SQL)
on Fri, Oct 5 2007 4:01 AM
thankk u
over wrote re: Changing Username Script (SQL)
on Mon, Jun 2 2008 9:24 PM
wrote re: Changing Username Script (SQL)
on Wed, Jul 23 2008 8:50 AM
wrote re: Changing Username Script (SQL)
on Wed, Jul 23 2008 8:51 AM
wrote re: Changing Username Script (SQL)
on Wed, Jul 23 2008 8:52 AM
afif wrote re: Changing Username Script (SQL)
on Mon, Jul 28 2008 9:52 AM
greaaaaaaaaaat ,, thanx alot
Dr.Adams wrote re: Changing Username Script (SQL)
on Sun, Oct 19 2008 6:35 PM

Very Good!

Dr.Adams wrote re: Changing Username Script (SQL)
on Tue, Oct 21 2008 10:52 AM

Sjeso

Dr.Adams wrote re: Changing Username Script (SQL)
on Wed, Oct 29 2008 2:53 PM
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com