| Author |
 Topic  |
|
|
Dawids
Starting Member
New Zealand
11 Posts |
 Posted - 16 July 2003 : 21:30:50
|
v 3.4.03
Goal: Making Snitz plug-into another existing customer database.
I have recently download the Snitz forum again to implement it into my e-commerce environment.... I would however like to migrate the members table to use our existing customers table, avoiding the need for double registerations to use the forum.
If there are some general guidelines for where the member registration queries need to be changed and any other info that might help in the task I might be able to create a mod for snitz to allow it to integrate into any existing (MSSQL) user database.
(That’s if someone hasn’t done this already)
Thanks |
Today is the day.... |
Edited by - Dawids on 21 July 2003 08:07:48 |
|
|
winterrise
Starting Member
1 Posts |
Posted - 18 July 2003 : 05:35:09
|
Dear Dawids ,
Sorry for my pooring English.
I have a very similar experience sharing with you. Hope it will be useful for you !!
My website use Snitz Forum for the membership database and intergrated with another e-commerce environment .
First I build a local package in SQL Server Data Transformation Service(DTS) . This package will publish the Snitz Forum members data to e-commerce database.
Then I build a storeprocedure excuting the command-line DTS package .
While Snitz system adding a new menber or modifing the profile , add asp code to excute the storeprocedure , then the e-commerce environment would have the same members data except for the password field .Because Snitz membership database's password field have been encoding. I don't know how to decode it.
CREATE PROCEDURE do_publish AS
exec master..xp_cmdshell 'dtsrun /S Kenny /N member_publish /E'
GO
User may login Snitz first for using the e-commerce environment. Throught the cookie I get the Member Identity no, then autologin the e-commerce environment.
My website is here http://www.my-cartoon.com.tw .Its a Chinese Big-5 Code site
Regards, Kenny |
Edited by - winterrise on 18 July 2003 05:36:41 |
 |
|
|
Dawids
Starting Member
New Zealand
11 Posts |
Posted - 20 July 2003 : 21:49:29
|
I have been working on Snitz this weekend and although the coding of the forum is done well the actual model behind is non-existing....
I personally think its time that Snitz moves towards DAO classes and drop this in code mixing if else stuff of data access code and display code. There are well known programming models defined to ease the future enhancements and maintainability of any software program… (Just me thinking out loud.)
I will be starting this change which will only cater for MSSQL but what it means is that there will be one customer data access layer that can be replaced or modified to support any database or system requirement, I will also attempt to make it globally support most environments.
Will keep you posted.
Ps. making this support any version of Snitz is going to be impossible, so I hope Snitz will implement these changes in its new releases.
Dawid 
|
Today is the day.... |
|
|
|
Dawids
Starting Member
New Zealand
11 Posts |
Posted - 21 July 2003 : 08:01:35
|
I have just completed the first instalment of this change; it’s only a test at this time....
I have re-done the Forum.asp file to use a data access class to interact as a layer between the ASP and Database
Its a bit messy at this stage as I am trying to figure out what the page does but at the same time create the classes...and well I haven’t got the answer to all those where clauses yet but I will soon.
I would like to see how this change performs on a large-scale forum, especially with the SQL view.
One of the big advantages with this sort change is that if you need access to any database software you only need to change the classes, instead of digging through the display code trying to find answers.
Install Procedure:
1) Extract the ZIP (Not into the forum main directory)
2) Execute the scripts int he SQL Scripts directory, it creates 3 procedures and 1 view and should be safe on current forum databases (They wont alter exiting data).
3) Copy the forum.asp into the forum directory (BACKUP ORIGINAL 1ST!!!)
4) Extract the Classes subdirectory into the forum directory.
5) DONE!
Well as I said its early days and I am still playing around with the idea, so any comments and feed back would be great, especially regarding speed
My Homepage (http://www.gumboot.co.nz)
Download URL (http://www.gumboot.co.nz/download/Forum-DAO.zip)
Dawid |
Today is the day.... |
|
|
|
Dawids
Starting Member
New Zealand
11 Posts |
Posted - 22 July 2003 : 08:41:55
|
After loads of work I have finally given up on the Data access idea, I have instead renamed the FORUM_MEMBERS table to F_FORUM_MEMBER and created a new SQL VIEW called FORUM_MEMBERS, I then joined our existing CUSTOMERS table to the F_FORUM_MEMBER table and used field aliases to generate a FORUM_MEMBERS SQL VIEW that would look the same as the original table. All I need to do now is fix the queries that update member details as you cannot update both tables in a view at the same time, so I will need to split this off into multiple queries.
Once I have more time I will re-investigate the Data Access Layer option. 
(The previous post download link is still a good source for learning if people want to write good ASP software.)
|
Today is the day.... |
Edited by - Dawids on 22 July 2003 08:44:52 |
|
|
| |
Topic |
|
Topic Locked
