Print Page | Close Window

Rename Username & password Table

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8988
Printed Date: 07 April 2026 at 1:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Rename Username & password Table
Posted By: cheops@collecto
Subject: Rename Username & password Table
Date Posted: 16 January 2004 at 5:55pm
I need to remane my  Username & password Tables..!!

Anyone know how it can be done and what part of ASP code I need to change in order to rename Username and Password Tables??

I have tried without luck, seems to mess op the codes..



-------------
Sorry for my bad 3nglish..!!



Replies:
Posted By: Semikolon
Date Posted: 16 January 2004 at 5:57pm

why do you want to rename the tables?

this will cause alot of un nessesary modification to the code..



Posted By: cheops@collecto
Date Posted: 16 January 2004 at 5:59pm
Yes I know - I need it to incorporate my CMS system into the WWF database in order to let my members use the same username and pass for both, and my CMS is WAY to complex to edit...

-------------
Sorry for my bad 3nglish..!!


Posted By: WebWiz-Bruce
Date Posted: 16 January 2004 at 6:10pm
So is the forum I'm afraid, doing waht you ask would probally mean editing all 200+ files in the forum.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: cheops@collecto
Date Posted: 16 January 2004 at 6:21pm
Originally posted by -boRg- -boRg- wrote:

So is the forum I'm afraid, doing waht you ask would probally mean editing all 200+ files in the forum.


I would attempt to do all files at once - wit a search and replace in EditPlus...



-------------
Sorry for my bad 3nglish..!!


Posted By: WebWiz-Bruce
Date Posted: 16 January 2004 at 6:36pm
The problem is that the database is a relational database and all fields in the tblAuthors table are required.

If they are not available and the member is not stored in this table the forum will fail to run.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: cheops@collecto
Date Posted: 16 January 2004 at 7:00pm

Originally posted by -boRg- -boRg- wrote:

The problem is that the database is a relational database and all fields in the tblAuthors table are required.

If they are not available and the member is not stored in this table the forum will fail to run.


Well If I rename the tables, changes the -

Const strDbTable = "tbl" to the one I need to use and change the password and username tabe - I only need to change (alot) code in the asp files - am I right....

boRg could you tell me what this does:

Const strDbProc = "wwfSp"



-------------
Sorry for my bad 3nglish..!!


Posted By: WebWiz-Bruce
Date Posted: 16 January 2004 at 7:21pm
Const strDbProc = "wwfSp" is for the stored procedures on the sql server version.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: ljamal
Date Posted: 16 January 2004 at 7:46pm
You can use a view to recreate the forum members table.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming


Posted By: cheops@collecto
Date Posted: 16 January 2004 at 7:48pm

Hallo -boRg-

If I change the username Table to FLPUsername do I need to change "strUsername" to "strFLPUsername"

I a´m going nuts about this, everything seems to work after renaming, only I can´t login anymore.

I have removed encrytion and checked the password, in database...
and everything look okay in there - nothin changed eccept the name of the tables and the Username and password in asp

Damn if only there was some body out there that would help me out, and have a look at my database and could see what I need to make it work - I´m almost about to give up...Damn



-------------
Sorry for my bad 3nglish..!!


Posted By: ljamal
Date Posted: 16 January 2004 at 7:52pm
cheops send me a PM, I have succesfully merged the WWF database with another members table severla time.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net