Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 setting up new forum with existing SQL db
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tfingleton
Starting Member

7 Posts

Posted - 09 June 2004 :  22:09:46  Show Profile
hi, I am working on setting up a forum and using our existing SQL database which keeps information on our organisation members, among other things. We are hoping our online forum will attract somenon-members as well as members. For forum participants we will probably only want them to register a name and email address. Although I assume everyone needs to enter a password, is this correct?
I am wondering what is the best way to add this information to the existing db without it affecting the existing member details? In a separate table? And what's the best process for setting up the forum database? Can I set up a database locally first and then add the tables to the existing online db? Hope these questions make sense!
cheers

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 09 June 2004 :  22:24:47  Show Profile
what are the table names of your existing tables? This forum uses it's own tables with a naming convention like: FORUM_MEMBERS, FORUM_TOPICS, etc... As long as you don't have any tables with these names, you shouldn't have any problems. You can even change the prefix in the config.asp file if you need to (from FORUM_ to whatever you want). The best way to setup the forum is to just use the setup.asp file to install the tables/data to your existing database.
Go to Top of Page

jovi
Starting Member

Philippines
3 Posts

Posted - 06 July 2004 :  04:58:53  Show Profile  Send jovi a Yahoo! Message
I have the same situation. We have an existing database for our members. It has also registration, authentication and profile updating for the members. I would to implement your forum as soon as possible. I would like how can I do this. Our site has already a registration, login and profile pages, I would like to eliminate one from yours and use ours. Can this be done? Will it be ok for you? If yes can you email me the details of how shall I do this. If no can you tell me which pages needs to be dealt with and what changes needed to implement your forum?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 06 July 2004 :  08:02:50  Show Profile  Send ruirib a Yahoo! Message
That's a bit complicated, I'm afraid. Here is a post that describes a viable option:

http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=32581&SearchTerms=INSTEAD,OF,TRIGGER


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

jovi
Starting Member

Philippines
3 Posts

Posted - 07 July 2004 :  20:43:49  Show Profile  Send jovi a Yahoo! Message
to ruirib,

i have pages and scripts that handles the login, registration, profile and member search. can i just redirect the links in the header section so as the user can still use the pages that i developed? i think it will be easier that way. can i eliminate the login part but still retain the logout link. by the way, i have visited the link you put up it was helpful but i cannot post a reply. tnx.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 July 2004 :  04:48:33  Show Profile  Send ruirib a Yahoo! Message
The problem is not really with your pages. You must realize that Snitz does use user identification info, obtained from login, to know which user is doing what. So it's not a matter of using your pages, it's a matter of ensuring that the code for user identification used by Snitz also works.

The solution discussed in the thread I posted the link for, describes a way to do that. The advantage of that approach is that Snitz is completely unchanged, code and tables, which means that even with new versions of Snitz, your approach would still work. If you change code, however, you need to change any new Snitz version code to get your forum working with that new version.

The link is to an archived post. Archived posts cannot be replied to. If you have questions about it, post them here.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07