SELECT 	FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_PASSWORD  
FROM 	FORUM_MEMBERS  
WHERE 	FORUM_MEMBERS.M_NAME = 'graz'  AND   FORUM_MEMBERS.M_PASSWORD = 'password' AND   FORUM_MEMBERS.M_STATUS = 1

SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'

SELECT COUNT(*) AS SubCount FROM FORUM_SUBSCRIPTIONS

SELECT FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_PASSWORD  
FROM FORUM_MEMBERS  
WHERE FORUM_MEMBERS.M_NAME = 'graz'  AND   FORUM_MEMBERS.M_PASSWORD = 'password' AND   FORUM_MEMBERS.M_STATUS = 1

-- main query for topics
SELECT F.F_SUBJECT, F.F_SUBSCRIPTION,  F.F_STATUS, F.F_ORDER, C.CAT_SUBSCRIPTION, C.CAT_STATUS, C.CAT_ORDER, 
	T.T_STATUS, T.T_VIEW_COUNT, T.FORUM_ID, T.TOPIC_ID, T.CAT_ID, T.T_SUBJECT, T.T_AUTHOR, T.T_REPLIES, 
	M.M_NAME, T.T_LAST_POST_AUTHOR, T.T_LAST_POST, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME 
FROM 	FORUM_MEMBERS M, FORUM_FORUM F, FORUM_TOPICS T, FORUM_CATEGORY C, FORUM_MEMBERS MEMBERS_1 
WHERE 	T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID  AND F.FORUM_ID = T.FORUM_ID AND F.CAT_ID = T.CAT_ID 
AND 	F.CAT_ID = C.CAT_ID AND M.MEMBER_ID = T.T_AUTHOR AND (T.T_LAST_POST > '20020316160614')  
ORDER BY C.CAT_ORDER, F.F_ORDER, T.T_LAST_POST DESC;
-- end main query for topics

SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'

SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100

SELECT 	mo.FORUM_ID  
FROM 	FORUM_MODERATOR mo, FORUM_MEMBERS me  
WHERE 	mo.FORUM_ID = 6  AND   mo.MEMBER_ID = me.MEMBER_ID  AND me.M_NAME = ''

SELECT 	mo.FORUM_ID  
FROM 	FORUM_MODERATOR mo, FORUM_MEMBERS me  
WHERE 	mo.FORUM_ID = 6  AND   mo.MEMBER_ID = me.MEMBER_ID  AND me.M_NAME = 'graz'

Select Count(*) as PostCount FROM FORUM_TOPICS T WHERE   T.FORUM_ID = 6 AND T.T_STATUS > 1 
Select Count(*) as PostCount FROM FORUM_REPLY    R WHERE   R.FORUM_ID = 6 AND R.R_STATUS > 1 
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'

SELECT Count(*) as SubCount from FORUM_SUBSCRIPTIONS S 
WHERE S.MEMBER_ID = 100 AND ((S.CAT_ID = 0 and S.FORUM_ID = 0 and S.TOPIC_ID = 0) 
OR (S.CAT_ID = 3 and S.FORUM_ID = 0 and S.TOPIC_ID = 0))

Select Count(*) as PostCount FROM FORUM_TOPICS T WHERE   T.TOPIC_ID = 13951 AND T.T_STATUS > 1 
Select Count(*) as PostCount FROM FORUM_REPLY    R WHERE   R.TOPIC_ID = 13951 AND R.R_STATUS > 1 

SELECT Count(*) as SubCount from FORUM_SUBSCRIPTIONS S 
WHERE S.MEMBER_ID = 100 AND ((S.CAT_ID = 0 and S.FORUM_ID = 0 and S.TOPIC_ID = 0) 
OR (S.CAT_ID = 3 and S.FORUM_ID = 0 and S.TOPIC_ID = 0) OR (S.CAT_ID = 3 and S.FORUM_ID = 6 and S.TOPIC_ID = 0))

SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT mo.FORUM_ID  FROM FORUM_MODERATOR mo, FORUM_MEMBERS me  
WHERE mo.FORUM_ID = 6  AND   mo.MEMBER_ID = me.MEMBER_ID  AND me.M_NAME = ''

SELECT mo.FORUM_ID  
FROM FORUM_MODERATOR mo, FORUM_MEMBERS me  
WHERE mo.FORUM_ID = 6  AND   mo.MEMBER_ID = me.MEMBER_ID  AND me.M_NAME = 'graz'

Select Count(*) as PostCount FROM FORUM_TOPICS T WHERE   T.TOPIC_ID = 13934 AND T.T_STATUS > 1 
Select Count(*) as PostCount FROM FORUM_REPLY    R WHERE   R.TOPIC_ID = 13934 AND R.R_STATUS > 1 

SELECT Count(*) as SubCount 
from 	FORUM_SUBSCRIPTIONS S 
WHERE 	S.MEMBER_ID = 100 
AND 	((S.CAT_ID = 0 and S.FORUM_ID = 0 and S.TOPIC_ID = 0) OR (S.CAT_ID = 3 and S.FORUM_ID = 0 and S.TOPIC_ID = 0) 
OR (S.CAT_ID = 3 and S.FORUM_ID = 6 and S.TOPIC_ID = 0))


SELECT CAT_ID, CAT_NAME, CAT_ORDER  FROM FORUM_CATEGORY ORDER BY CAT_ORDER ASC, CAT_NAME ASC

SELECT FORUM_ID, F_TYPE, F_SUBJECT, F_URL, CAT_ID, F_ORDER  
FROM FORUM_FORUM  WHERE CAT_ID = 2 ORDER BY F_ORDER ASC, F_SUBJECT ASC;

SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100

SELECT FORUM_ID, F_TYPE, F_SUBJECT, F_URL, CAT_ID, F_ORDER  
FROM FORUM_FORUM  WHERE CAT_ID = 3 ORDER BY F_ORDER ASC, F_SUBJECT ASC;

SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100

SELECT FORUM_ID, F_TYPE, F_SUBJECT, F_URL, CAT_ID, F_ORDER  
FROM FORUM_FORUM  WHERE CAT_ID = 4 ORDER BY F_ORDER ASC, F_SUBJECT ASC;

SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100
SELECT FORUM_MEMBERS.MEMBER_ID  FROM FORUM_MEMBERS  WHERE M_NAME = 'graz'
SELECT FORUM_MEMBERS.M_LEVEL  FROM FORUM_MEMBERS  WHERE FORUM_MEMBERS.MEMBER_ID=100

quote:

---

If I knew how to do an SQL query with a whole bunch of inner joins and one left outter join I would fix that, but I have never studied SQL or the theory behind it.

  Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's

---

Surely someone on the dev team knows. I can help with that if you want.
There will be a problem with MySQL though. Last time I looked it didn't even support inner joins, much less outer joins. If the situation remains you'll need different code to handle MySQL (I hope that support for MySQL wasn't the reason for these inefficiencies in the SQL used here - I guess that could only add to my ever growing contempt for MySQL ).

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs

    if MemberID <> 0 then
      getNewMemberNumber = MemberID
      exit function
    end if

quote:

---

For people who only use active.asp like me, its the only place we are going to see a button to subscribe at all. Except in the topic iteself.

It would be foolish to remove that option unless you want to remove it form forum.asp as well.

  Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's

---

function isAllowedMember2(fMemberID)
	isAllowedMember2 = ""
	on error resume next
	strSql = "SELECT FORUM_ID FROM " & strTablePrefix & "ALLOWED_MEMBERS "
	strSql = strSql & " WHERE " & strTablePrefix & "ALLOWED_MEMBERS.MEMBER_ID = " & ChkString(fMemberID, "SQLString")

	Set rsAllowedMember = Server.CreateObject("ADODB.Recordset")
	rsAllowedMember.open strSql, my_Conn
    if not rsAllowedMember.EOF then
      AllowedForums = rsAllowedMember.GetRows()
      rsAllowedMember.Close()
      set rsAllowedMember = nothing
      For AllowCount = 0 to ubound(AllowedForums,2) ' Total Numer of Rows
        isAllowedMember2 = isAllowedMember2 & "|" & AllowedForums(0,AllowCount)
      next
        isAllowedMember2 = isAllowedMember2 & "|" ' Add last pipe
    end if

end function

AllowForumList = isAllowedMember2(MemberID)

if instr(AllowForumList,("|" & fForum_ID & "|",) > 0 then 
  MatchFound = 1 
else 
  MatchFound = 0
end if