quote:
Originally posted by weeweeslap
add
strRequireReg="1"
in post.asp after the set of includes that has:
<!--#INCLUDE FILE="config.asp"-->
click and you'll see it'll throw the login boxes at you if you're not logged in. So I assume it'll give you the same result if you add that code snippet to post.asp.
Does anybody use this ? It doesnt work properly on my site, it causes an invalid SQL statement to be created because it loses the forum id after logging in.
if you open a category then click 'new topic' , you will correctly be shown a login screen with this in the path bar:
http://localhost/forum/login.asp?target=post.asp?method=Topic&FORUM_ID=4
after logging in successfully, you get redirected back to post.asp with this in the title bar:
http://localhost/forum/post.asp?method=Topic
this raises the error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
the output of the relevant SQL at that point is:
SELECT C.CAT_ID, C.CAT_NAME, C.CAT_STATUS, C.CAT_SUBSCRIPTION, F.FORUM_ID, F.F_STATUS, F.F_TYPE, F.F_SUBJECT, F.F_SUBSCRIPTION FROM FORUM_CATEGORY C, FORUM_FORUM F WHERE C.CAT_ID = F.CAT_ID AND F.FORUM_ID =
the forum ID is lost, hence the error.
Does anyone have a work around ? For various reasons I dont want the user to be able to enter his username & pwd on post.asp