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
 user accounts		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

baxterthaman
Starting Member

2 Posts
Posted - 21 April 2006 :  10:36:35  Show Profile
Is there anyway to integrate an existing user account (just username and password) from another table in the database with Snitz Forum? I have users creating a profile from another sign up but want them to have the same access to the forum without going through the sign up on the forum. Any help would be greatly appreciated.

Thanks!

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 21 April 2006 :  11:13:30  Show Profile  Send ruirib a Yahoo! Message
SQL Server allows you probably the best way to do that, by creating a view using the existing password fields from your members table and all the other fields from the Snitz members table (which would have to be renamed). Then you would need to write 3 instead of triggers, so that changes to the view would be reflected in the two original tables.

It's the cleanest possible process, and requires no code changes at all, but would require you to create a view and 3 instead of triggers for it.

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

baxterthaman
Starting Member

2 Posts
Posted - 21 April 2006 :  14:42:38  Show Profile
Great thank you for the advice!
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.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07