| Author |
 Topic  |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
 Posted - 13 October 2007 : 17:46:54
|
I am trying to have members that have not made any forum posts to at least come out the shadows and say hi. So I did the following:
strSql = "SELECT M_POSTS"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
set rs = my_Conn.Execute (strSql)
if M_POSTS>1 then
Response.Write "<font size=""2"">You need at least one forum post to access this page. We know you didn't need any before but we would like to get to know you a little better. We suggest you at least say hi to us in the official <a href=""/forum/topic.asp?TOPIC_ID=15772"">Say Hi!</a> forum topic! One forum post is all we ask from you, it's not much to ask for right? Thank you.</font><br><br><br>" & vbNewLine
WriteFooter
Response.End
End if
and it doesn't work
I tried the following variations:
if M_POSTS>1 then
if M_POSTS<1 then (yields everyone the message)
if M_POSTS>2 then
if M_POSTS=0 then
the last one makes everyone get the message displayed which doesn't work since I have over 8,000 posts I do not fit the m_posts=0 case so what am I doing wrong? I want anyone that has not made a forum post to get that message and everyone else I want the page to display which is a bunch of code below that  Thanks! |
coaster crazy |
Edited by - weeweeslap on 13 October 2007 18:18:17 |
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 13 October 2007 : 18:09:56
|
| where is the WHERE clause in your SQL? |
 |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 13 October 2007 : 18:27:35
|
maybe that's what I'm missing. I'm a noob 
I just tried with
strSql = strSql & " WHERE M_POSTS=0"
and changed it to:
strSql = "SELECT M_POSTS"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE M_POSTS=0"
set rs = my_Conn.Execute (strSql)
if M_POSTS=0 then
Response.Write "<font size=""2"">You need at least one forum post to access this page. We know you didn't need any before but we would like to get to know you a little better. We suggest you at least say hi to us in the official <a href=""/forum/topic.asp?TOPIC_ID=15772"">Say Hi!</a> forum topic! One forum post is all we ask from you, it's not much to ask for right? Thank you.</font><br><br><br>" & vbNewLine
WriteFooter
Response.End
End if
and it still doesn't work, it blocks everyone out that has or doesn't have posts and only want the people with 0 forum posts to get that message. |
coaster crazy |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 13 October 2007 : 18:43:23
|
no the where clause need to select only the member trying to access the forum so I think
strSql = strSql & " WHERE MEMBER_ID = " & MemberID |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 13 October 2007 : 18:59:30
|
strSql = "SELECT M_POSTS"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE MEMBER_ID = " & MemberID
set rs = my_Conn.Execute (strSql)
if M_POSTS<1 then
Response.Write "blah blah blah><br><br><br>" & vbNewLine
WriteFooter
Response.End
End if
I tried that just not after your post and everyone gets the message displayed so it's ignoring the fact that it should only display to people if their post count is lessthan 1 I even switched to =0 and same result. |
coaster crazy |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 13 October 2007 : 19:15:27
|
| try if rs("M_POSTS")<1 then |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 13 October 2007 : 19:32:23
|
awesome! thank you so much, that worked out perfectly  |
coaster crazy |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 13 October 2007 : 19:33:39
|
| finally no problem but could you post where this is in the code? I might want to do this. |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 13 October 2007 : 19:38:44
|
oh, I used this for a page outside the forum:
http://www.weeweeslap.com/track_exchange/detail.asp?tid=10317
you can use the test account:
username: snitztest
password: test
and see, I'll reset it to 0 post count so you can see it in action and you can make a forum post to see that it works.
the code used is:
<!--#INCLUDE VIRTUAL="forum/config.asp"-->
<!--#INCLUDE VIRTUAL="forum/inc_sha256.asp"-->
<!--#INCLUDE VIRTUAL="forum/inc_header.asp" -->
<!--#INCLUDE VIRTUAL="forum/inc_func_member.asp" -->
<%
strSql = "SELECT M_POSTS"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS"
strSql = strSql & " WHERE MEMBER_ID = " & MemberID
set rs = my_Conn.Execute (strSql)
if rs("M_POSTS")<1 then
Response.Write "<font size=""2"">You need at least one forum post to access this page. We know you didn't need any before but we would like to get to know you a little better. We suggest you at least say hi to us in the official <a href=""/forum/topic.asp?TOPIC_ID=15772"">Say Hi!</a> forum topic! One forum post is all we ask from you, it's not much to ask for right? Thank you.</font><br><br><br>" & vbNewLine
WriteFooter
Response.End
End if
There's lots of code after that to show the actual page but that's private  But yeah it worked out! Thank you!
|
coaster crazy |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 14 October 2007 : 11:22:44
|
| I was looking at this and it dawned on me that over here someone else was trying to do the same thing. So thanks your way is much better than mine. |
|
|
|
HuwR
Forum Admin
United Kingdom
20590 Posts |
Posted - 14 October 2007 : 13:22:58
|
| by the way weeweeslap, you are actually only blocking out members with 0 posts, what about non-members ? or does your forum only allow registered users ? |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 15 October 2007 : 09:36:10
|
| yes, that page only allows logged in registered members |
coaster crazy |
|
|
|
HuwR
Forum Admin
United Kingdom
20590 Posts |
Posted - 15 October 2007 : 09:45:19
|
| cool, thought I better mention it just in case |
|
|
| |
Topic |
|
Topic Locked
