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
I would attempt to do all files at once - wit a search and replace in EditPlus... ------------- Sorry for my bad 3nglish..!! |
-boRg- wrote: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
|
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- I a´m going nuts about this, everything seems to work after renaming, only I can´t login anymore. 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 |