Site Integration Package

Hi there, 2 questions:

1) I have downloaded the 3.4 trial version, and got the forum working as a standalone product, but now I need to integrate it into my site (registration, logon and messages).  The SIP is what I want, but I can't find it anywhere!

Is it part of the 3.4 download?  Or is it a separate download?  In either case, where can I find it?

2) We're going to integrate the forum engine into our site, and allow an admin user to create threads which are displayed on the front end of the website only.  As well as having the standard message fields (subject, content etc), we want to be able to add an image upload, which is a separate field and displayed independently of the rest of the content.  Does your system allow us to add custom fields to the message table, or am I going to have to keep it in a separate table, and create a link between our table and the forum's message table?

Cheers

kitster

Hi Kitster,

Let me answer your questions one by one:

1. The SIP is only available when users purchased the license. Trial version does not come with the SIP.
2. Let me answer your questions one at a time:
   1. You can use the SIP's message extractor to display messages on your site
   2. we do not have custom fields for message. However you don't need a table for this, but simply add a field to the existing message table so that you don't need to create any additional joins in the SPs. What you will have to do is modify the following sp's to add the column to the select list
      
      1. spDisplayMsg
      2. spDisplayMsgMod
      3. spDisMsg

ASPPlayground.net Developer

Pity about the lack of SIP in the demo, really makes it more difficult to judge how long its going to take to integrate for our clients.  I presume its for piracy/fraud reasons.

Regarding the addition of the image to a message, thanks for the sp's for retrieving the details.  Could you also tell me the sp's I need to alter to enable the insert/update of the messages?

It is best not to alter the insert/update sps. What you will do is issue your own SQL statement directly from the code -> Always use the Update statement after a message is inserted / updated.

And yes, you are right about the issue with SIP not being part of demo. The SIP does not have a expiration built in as it is a set of ASP.NET Provider based codes intended to be used outside the forum software.

ASPPlayground.net Developer

Yep, that's fine, just had a look at that, and agree, best not alter the existing code!

But, it would be good if you could tell me which stored procs are used to insert/update, so I can base a new one on them.  Essentially I'll copy them, add in the new parameter, and take it from there.  The two sp's I've found which look likely are spEdit and spPost, am I on the right track?

Also, spReply for replying to existing threads.

ASPPlayground.net Developer