Web Wiz Forums - Database - ASP

Print Page | Close Window

Database - ASP - Languages

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=2856
Printed Date: 01 April 2026 at 4:23am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Database - ASP - Languages

Posted By: Bluefrog
Subject: Database - ASP - Languages
Date Posted: 19 May 2003 at 9:50pm

I want to use several instances of the forum in the same database. Each instance will store a seperate language.

Can I do a global search and replace in every file in the forum code to change table and stored proceedure names like this:

tblAuthors becomes:

LCtblAuthors

Where LC is the ISO639 2 character language code - the one you get from HTTP headers. e.g English = en, Spanish = es, Japanese = ja, etc.

Is this possible? I don't know the internal code well enough to know whether this is possible.

The reason is that I want to use more than one language for the forums, but I also want to be able to integrate the forum into an already multilingual database driven website.

Thanks for any help

Replies:

Posted By: Bluefrog
Date Posted: 19 May 2003 at 9:57pm

OK - Silly me...

From the msSQL_server_setup.asp file

'Set up the database table name prefix and stored procedure prefix
'(This is useful if you are running multiple forums from one database)
' - make sure you also change this in the common.asp files
Const strDbTable = "tbl"
Const strDbProc = "wwfSp"

And from the common.asp file

'Set up the database table name prefix and stored procedure prefix
'(This is useful if you are running multiple forums from one database)
' - make sure you also change this in the msSQL_server_setup.asp file if setting up an ms SQL server database)
Const strDbTable = "tbl"
Const strDbProc = "wwfSp"

Does this answer my question? It looks like it does.

Has anyone done this? Are there any other issues that I might need to take care of? Is it that simple? It looks too darn easy...

Posted By: Bluefrog
Date Posted: 19 May 2003 at 10:54pm

Didn't work...

Changed the two instances in the common.asp and the DB setup file.

Used different directories for each instance of the forum, same database, but... I ended up with everything going into the default installation...

So I dropped the testing database, recreated it, redid it all, noticed that there are 2 common.asp files - kicked myself for not reading that final s... (think I'm going blind) - fixed that, monkeyed around and got stuff working.

So... no - it's not that easy if you are blind, but over-all - yes - it is that easy...

Cheers