Web Wiz Support and Community Forums : setting up new db (SQL) https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:23:35 +0000 Thu, 06 Jul 2006 15:58:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20570 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[setting up new db (SQL) : If you use the member API your...]]> https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110258.html#110258 Author: WebWiz-Bruce
Subject: 20570
Posted: 06 July 2006 at 3:58pm

If you use the member API your database runs independently from that used in the forum.

The common.asp file is used on every page, but remember when adding your own code to this to declare all new variables as strict coding is enabled within the forum code.
]]> Thu, 06 Jul 2006 15:58:52 +0000 https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110258.html#110258 <![CDATA[setting up new db (SQL) : oh one other thing... the forum...]]> https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110256.html#110256 Author: mtm81
Subject: 20570
Posted: 06 July 2006 at 3:53pm

oh one other thing...
the forum is in a logged in only progrected area.. if a user tries to access any other area of this protected area, a piece of code in the top of each page written in ASP, checks the session and if it doesn't exist, boots them to the login page...
 
How does this work in conjunction with the forum...
 
Is there a particular include (like the common.asp) one for example which is on every forum page and therefore if I posted my piece of code in there would force this to work?
 
 
]]> Thu, 06 Jul 2006 15:53:20 +0000 https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110256.html#110256 <![CDATA[setting up new db (SQL) : ok smashing - one last thing.....]]> https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110252.html#110252 Author: mtm81
Subject: 20570
Posted: 06 July 2006 at 3:12pm

ok smashing - one last thing.. if I'm planning on using the existing member api system and these members are a part of this existing db - would I NEED to use the same DB or is it independant.
 
 
]]> Thu, 06 Jul 2006 15:12:36 +0000 https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110252.html#110252 <![CDATA[setting up new db (SQL) : A new database is best and would...]]> https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110249.html#110249 Author: WebWiz-Bruce
Subject: 20570
Posted: 06 July 2006 at 2:50pm

A new database is best and would give better performance, but you can use an existing one if you prefer.

All tables in web wiz forums begin with the table prefix 'tbl' if you feel this will course problems with your own tables in the database you can change the table prefix in the file 'includes/setup_options.asp' just edit the file with notepad.
]]> Thu, 06 Jul 2006 14:50:51 +0000 https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110249.html#110249 <![CDATA[setting up new db (SQL) : Hi, When setting up a new forum...]]> https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110243.html#110243 Author: mtm81
Subject: 20570
Posted: 06 July 2006 at 12:50pm

Hi,
When setting up a new forum using SQL.. instead of creating a new db, I was going to us a db with existing tbls for other purposes that do other things around the site.
 
1) - Would this affect the performance of the forum (i.e does it prefer to be running in it's own db)
2) - When I create the db I don't want it overwriting any existing data... The only way I can think this would happen would be if there were any existing tbls called the same as the new ones created for the forum..
 
How can I check this.. is there a list ofthe tbls created for the forum I can check against?
 
 
]]> Thu, 06 Jul 2006 12:50:02 +0000 https://forums.webwiz.net/setting-up-new-db-sql_topic20570_post110243.html#110243