Help With Log-In Form...

Well Stephen....

If subscriptions to all forums were at forum level, then you can see a problem here, I sure.

As admins and mods are the only people allowed in *this* particular one, I have allowed forum subscriptions for this.

Consider even just 500 users.... with forum (and whole board) subscriptions, then you are potentially looking at 500 emails being sent per post.... but what the hell dude... it's your bandwidth.

Additionally besides the bandwidth thing, there is the performance issue to think of.... seriously, it could be a real issue as the site grows if we allow forum, level subscriptions.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

Well, programmer guru. Lets change the subscriber code to allow only Mods or Admins to subscribe to a forum. Then we can monitor traffic from the comfort of our couches.

good mod.... but right now dude, I am still learning about this major product..... as myself and Sam (Smokey) have already learnt to our mispent lunch hours, it is a spaghetti work off code written in multiple languages and certainly not something you can mod that easily.

I will however make it a priority, and maybe we need a moderator / admin forum for 'to do' or 'tasklist'. What do others think?

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

I would say lets make that list. If nothing else, some of use can research if a MOD exsists already for that. There are MANY MODS for this program.

Its functionality could be improved upon. I am game.

Ok, well I got the Registration form up and running.. (well haven't learned how to check forms just yet but got the basics...) Ok, now what I need to do is to check the Database to see if the Username and Password is already there. Then if so take them to a Members.htm, and if not take them to Form2.htm.

Feel Free to try out my Form by the way... here it is: www.haeglodesigns.com/ASPTests/Form2.htm

Ok, so what I am asking is how do I (without yall doing it for me of course...) go about checking the database and figuring out where to send the person that filled out the form?


EDITED...

Code: Select all

<%
Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=Mydatabase"

Set recordSet =Server.CreateObject("ADODB.Recordset")
recordSet.Open "SELECT USER FROM List Where USER='" & session("username") & "'",connectionToDatabase, 3,3

connectionToDatabase.Close
Set connectionToDatabase=Nothing
%>

ok, I can log onto the User's username in the database, that works great... problem is I don't know how to verify the password they typed in and then redirect them. I have been trying and trying but no luck so far.

SELECT the user on both the username and password, then check to see if you get any records back (if rs.bof and rs.eof then...).

Response.redirect "url" is the normal way to redirect. But check out my original post to your question about this and the use of cookies, etc http://www.webforumz.com/topic.asp?TOPIC_ID=871