Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Integrate WebWiz Forum with Current SQL DB
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Integrate WebWiz Forum with Current SQL DB

 Post Reply Post Reply Page  <1234>
Author
skbohler View Drop Down
Newbie
Newbie


Joined: 08 February 2006
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote skbohler Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2006 at 5:27pm
No web farm or anything liked that. All on the same machine.
 
Could it be that my application has a global.asa file or something?
I don't know much about the scope of session variables.
 
Steve
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2006 at 5:41pm
Global.asa should make a difference unless you are using session.abandon within it.

Also make sure when your set the session variable that you are actually populating it with a value.

If it is the server that is having problems holding the session then this is something that your host needs to look into.
Back to Top
skbohler View Drop Down
Newbie
Newbie


Joined: 08 February 2006
Status: Offline
Points: 33
Post Options Post Options   Thanks (0) Thanks(0)   Quote skbohler Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2006 at 9:54pm

The global.asa was calling session.abandon. I commented it out, but still no luck.

The session variable is definitely being set, but it's definitely not set when I move to the forum/default.asp.
 
I can't see why not. It's a shame because I really need that functionality.
 
 
Back to Top
calmoim3 View Drop Down
Newbie
Newbie


Joined: 16 May 2006
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote calmoim3 Quote  Post ReplyReply Direct Link To This Post Posted: 17 May 2006 at 5:46pm

boRg,

I wish I had found this thread sooner.  We tried to do this on our own and wound up locking everyone out!  Ouch.
 
Is there a way to make membership and forum access time limited?  We are setting up a support forum that will be subscription based and we were planning to require authorization for new members, then track subscription status manually.  Upon expiration, we plan to send a tickler email, and if the user declines remove them from the forum.
 
This adds a couple of layers I would just as soon not administer.
 
Is there a better way?
 
thanks
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2006 at 9:51am
There isn't a time limited feature built into the present version of web wiz forums.
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2006 at 12:34pm
Originally posted by calmoim3 calmoim3 wrote:

boRg,

I wish I had found this thread sooner.  We tried to do this on our own and wound up locking everyone out!  Ouch.
 
Is there a way to make membership and forum access time limited?  We are setting up a support forum that will be subscription based and we were planning to require authorization for new members, then track subscription status manually.  Upon expiration, we plan to send a tickler email, and if the user declines remove them from the forum.
 
This adds a couple of layers I would just as soon not administer.
 
Is there a better way?
 
thanks
If I am understanding what you want correctly, there are a couple ways to do it:
 
If you are using your own login system and using Borg's method of integration you can do this:
  • In a table in the database you will need to store their subscription expiration date.  (It doesn't matter where.)
  • When they login, do a quick query to see if their subscription has expired.
    • If it has expired, then check if they have access to the support forums and if so do an update query on the database that changes their status in the forum so they can't access it anymore.  You would probably do this by changing the permissions of that particular user.
    • If it has not expired, then do nothing.
  • Continue the login process like normal.

This way users with expired subscriptions will automatically be restricted from accessing the forums.

An alternate way would be to:
  • In a table in the database you will need to store their subscription expiration date.  (It doesn't matter where.)
  • Create a script that checks a user's subscription expiration date.
    • If their subscription is expired and they still have access, change their permissions in the forum.
    • Else do nothing.
  • Create a scheduled task that runs this script once a day.

Some Notes:

You may want to create some additional error checking and optimization into this.  What I described is simple and uses more resources than necessary, but would work.
 
Additional Ideas:
 
You could also make it so that it sends out the tickler as well.  You would just need to make sure that it records that it was sent out to prevent it from being sent multiple times.
 
Hope that helps.
Back to Top
calmoim3 View Drop Down
Newbie
Newbie


Joined: 16 May 2006
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote calmoim3 Quote  Post ReplyReply Direct Link To This Post Posted: 18 May 2006 at 1:58pm
Thanks, gives us something to work with.
Back to Top
Geekman View Drop Down
Newbie
Newbie


Joined: 25 May 2006
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote Geekman Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2006 at 6:34pm
I'm having trouble implementing the new Member API.  I'm sure I'm overlooking something simple.  I set the Session variables (USER & PASSWORD).  But when I run default.asp it does not autologin.  I've even written code to read back all session variables and sure enough they are both correct. I just can't see the forest for the trees. Thanks 
Back to Top
 Post Reply Post Reply Page  <1234>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.