Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 category mod		  New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

phoenixtaz13
Junior Member

129 Posts
Posted - 28 March 2009 :  05:17:26  Show Profile
hi huwr.... :)

can u pls tell me where to put this "AND NOT CAT_ID = 5".... i've been doing some trial and errors and still not working..... :(

thanks for ur time.... :)
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 28 March 2009 :  05:49:46  Show Profile  Visit HuwR's Homepage
from a quick look, try this.

look for the sections of code labeled
###### Group Cat Mod ##### example below

'############################## Group Cat MoD #####################################
if Cat_ID <> "" then
	strSql = strSql & " WHERE CAT_ID = " & Cat_ID & "AND CAT_ID <> 5"
else
	if Group > 1 and strGroupCategories = "1" then
		strSql = strSql & " WHERE (CAT_ID = 0"
		if recGroupCatCount <> "" then
			for iGroupCat = 0 to recGroupCatCount
				strSql = strSql & " or CAT_ID = " & allGroupCatData(1, iGroupCat)
			next
		end if
                strSql = strSql & ") AND CAT_ID <> 5" 
	end if
end if
'############################## Group Cat MoD #####################################


there are a couple of places in default.asp that you will need to make the changes, and possibly in active.asp as well
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts
Posted - 28 March 2009 :  06:18:33  Show Profile
hi huwr..... :)

i'll work on it now..... thanks.... :)
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts
Posted - 28 March 2009 :  16:17:19  Show Profile
hi huwr....

sad to say, the code you gave above is not working.... :(

heres what i did:
'############################## Group Cat MoD #####################################
if Cat_ID <> "" then
	strSql = strSql & " WHERE CAT_ID = " & Cat_ID & "AND CAT_ID <> 5"
else
	if Group > 1 and strGroupCategories = "1" then
		strSql = strSql & " WHERE (CAT_ID = 0"
		if recGroupCatCount <> "" then
			for iGroupCat = 0 to recGroupCatCount
				strSql = strSql & " or CAT_ID = " & allGroupCatData(1, iGroupCat)
			next
		end if
		strSql = strSql & ") AND CAT_ID <> 5"
	end if
end if
'############################## Group Cat MoD #####################################


and 

'############################## Group Cat MoD #####################################
if Cat_ID <> "" then
	strSql = strSql & " WHERE F.CAT_ID = " & Cat_ID & "AND CAT_ID <> 5"
else
	if Group > 1 and strGroupCategories = "1" then
		strSql = strSql & " WHERE (F.CAT_ID = 0"
		if recGroupCatCount <> "" then
			for iGroupCat = 0 to recGroupCatCount
				strSql = strSql & " OR F.CAT_ID = " & allGroupCatData(1, iGroupCat)
			next
		end if
		strSql = strSql & ") AND CAT_ID <> 5"
	end if
end if
'############################## Group Cat MoD #####################################



any more ideas?.... :)

thanks for ur time..... :)
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts
Posted - 31 March 2009 :  11:53:41  Show Profile
hi huwr.... :) after so many trial and error...

i manage to make this thing work:
strTablePrefix = "PHOTO_"
strMemberTablePrefix = "PHOTO_"

though i have a question, what if in the future i decided to combine both forum, is it possible
to do it?... if yes, how would i do it?....
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts
Posted - 01 April 2009 :  03:37:38  Show Profile
hello guyz.... :) good day to all...

anyone out there?...

Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07