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
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

phoenixtaz13
Junior Member

129 Posts

Posted - 27 March 2009 :  15:02:09  Show Profile
hello.... good day to all.... :)

is there a mod that would hide a category?.... if not, i've been trying to tweak the default.asp using this "and not CAT_ID = 5" i want to hide CAT_ID = 5,
been doing trial and error, and i cant make it work.... :)

anyone knows how to do it?....

thanks in advance..... :)

AnonJr
Moderator

United States
5768 Posts

Posted - 27 March 2009 :  15:12:48  Show Profile  Visit AnonJr's Homepage
If all forums under that category are marked as hidden, the category won't be displayed.
Go to Top of Page

bobby131313
Senior Member

USA
1163 Posts

Posted - 27 March 2009 :  15:15:47  Show Profile  Visit bobby131313's Homepage
Just click the minus sign.....


Switch the order of your title tags
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 27 March 2009 :  15:30:47  Show Profile
hi anonjr and bobby.... good day to you... :)

heres the situation.... i have two forum folder, forumRC(remotecars) and forumphoto(photography), and my database is outside those two folders, and i plan for my two forum folder to just use 1 database instead of having each database....

since both forumfolders will be using the same database, i want to restrict some category photo stuff showing in forumRC and also restrict some category remotecars stuff showing in forumPhoto, and i found out in google search that its possible by adding "SELECT T_SUBJECT, TOPIC_ID, T_AUTHOR from FORUM_TOPICS where FORUM_ID = 34 and not T_AUTHOR = 1 order by T_LAST_POST desc;" and i've been doing some trial and error in the default.asp, and i cant seem to make it work.... :(

do u know where i can put this "AND NOT CAT_ID = 5" ?

thanks for ur time.... :)


Edited by - phoenixtaz13 on 27 March 2009 15:32:32
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 27 March 2009 :  16:16:18  Show Profile  Visit HuwR's Homepage
Snitz already allows you to share a single database between multiple forums, you just have to change a few settings in the config.asp file for each forum and you can then share the members but have totally different cataegories etc for each forum, or have different members too, all in the same database.
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 27 March 2009 :  16:41:10  Show Profile
hi huwr.... good day to you.... :)


quote:
Snitz already allows you to share a single database between multiple forums

wow!... :)

what should i be looking in the config.asp file?... and what are the changes i should put to make it work?...

thanks for ur time huwr.... :)

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 27 March 2009 :  16:59:14  Show Profile  Visit HuwR's Homepage
if you want to share the same users across the two forums, then all you need to change is

strTablePrefix

if you want different members then change strmembertableprefix as well

MVC .net dev/test site | MVC .net running on Raspberry Pi
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 27 March 2009 :  17:12:30  Show Profile
hi huwr.... :)

i found this in config.asp file, LINE 64 and 65:
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

just checking if i got it right... i can change it from "FORUM_" to "PHOTO_", am i right?....

btw, im using MS Access for my database, the changes above wont be a prob, right?....

thank u, thank u again for ur time.... :)

Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 27 March 2009 :  17:26:36  Show Profile  Visit HuwR's Homepage
that is correct, and no it won't be a problem, when you have set the strTableprefix, just run setup.asp and it should create the new tables with the PHOTO_ prefix (it may throw some errors saying it can't create FORUM_MEMBERS etc, but you can ignore that
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 27 March 2009 :  17:36:53  Show Profile
hi huwr..... :)

thank you very much.... u just made my day great.... :) i'll work on it now.... :)

god bless...
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 28 March 2009 :  04:03:43  Show Profile
help pls....

i changed the strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_" to strTablePrefix = "PHOTO_" strMemberTablePrefix = "PHOTO_"

and i get this error:
Error: -2147217865	Could not find output table 'PHOTO_CATEGORY'.
strSql: 	INSERT INTO PHOTO_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
Error: -2147217865	Could not find output table 'PHOTO_MEMBERS'.
strSql: 	INSERT INTO PHOTO_MEMBERS (M_STATUS, M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_LINK1, M_LINK2, M_PHOTO_URL, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_DEFAULT_VIEW, M_LEVEL, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_DATE, M_LASTHEREDATE, M_LASTPOSTDATE, M_TITLE, M_SUBSCRIPTION, M_HIDE_EMAIL, M_RECEIVE_EMAIL, M_LAST_IP, M_IP) VALUES(1, 'admin2', 'admin2', '864c90ccb7177f26742fce2bc70cb0259d5dee15d9dc68e141136baae758825c', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20090328161836', '20090328161336', '20090328161836', 'Forum Admin', 0, 0, 1, '000.000.000.000', '000.000.000.000')
Error: -2147217865	Could not find output table 'PHOTO_FORUM'.
strSql: 	INSERT INTO PHOTO_FORUM(CAT_ID, F_STATUS, F_MAIL, F_SUBJECT, F_URL, F_DESCRIPTION, F_TOPICS, F_COUNT, F_LAST_POST, F_PASSWORD_NEW, F_PRIVATEFORUMS, F_TYPE, F_IP, F_LAST_POST_AUTHOR, F_LAST_POST_TOPIC_ID, F_LAST_POST_REPLY_ID) VALUES(1, 1, 0, 'Testing Forums', '', 'This forum gives you a chance to become more familiar with how this product responds to different features and keeps testing in one place instead of posting tests all over. Happy Posting! ', 1, 1, '20090328161836', '', 0, 0, '000.000.000.000', 1, 1, 0)
Error: -2147217865	Could not find output table 'PHOTO_TOPICS'.
strSql: 	INSERT INTO PHOTO_TOPICS (CAT_ID, FORUM_ID, T_STATUS, T_MAIL, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_ARCHIVE_FLAG) VALUES(1, 1, 1, 0, 'Welcome to Snitz Forums 2000', 'Thank you for downloading Snitz Forums 2000. We hope you enjoy this great tool to support your organization! Many thanks go out to John Penfold <asp@asp-dev.com> and Tim Teal <tteal@tealnet.com> for the original source code and to all the people of Snitz Forums 2000 at http://forum.snitz.com for continued support of this product.', 1, 0, 0, 0, '20090328161836', '20090328161836', 0, '000.000.000.000', 1, 0, 1)
Error: -2147217865	Could not find output table 'PHOTO_TOTALS'.
strSql: 	INSERT INTO PHOTO_TOTALS (COUNT_ID, P_COUNT, T_COUNT, U_COUNT) VALUES(1,1,1,1)
Error: -2147217865	Could not find output table 'PHOTO_GROUP_NAMES'.
strSql: 	INSERT INTO PHOTO_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('All Categories you have access to','All Categories you have access to')
Error: -2147217865	Could not find output table 'PHOTO_GROUP_NAMES'.
strSql: 	INSERT INTO PHOTO_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('Default Categories','Default Categories')
Error: -2147217865	Could not find output table 'PHOTO_GROUPS'.
strSql: 	INSERT INTO PHOTO_GROUPS (GROUP_ID, GROUP_CATID) VALUES (2,1)


i ignored the error above and went to the forum...
and then i encountered another error:
Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'PHOTO_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
/cast/inc_header.asp, line 229


what i did is, i made a copy of the FORUM_ACTIVE_USERS and renamed it PHOTO_ACTIVE_USERS and erased or deleted its content, and the error above goes on and on, and i just did the same process as i did with PHOTO_ACTIVE_USERS...

after i got done with the tables,
another error occured:
Error Type:
(0x80020009)
Exception occurred.
/cast/inc_func_common.asp, line 218

my inc_func_common.asp file:
function chkAURecord(intTotalActiveUsers)
  if cInt(intTotalActiveUsers) > cInt(intAURecord) then 'We have a new record!!! :)
    'Check to see if it *Really* is a record, or if Application varaibles just got reset
	strSql = "SELECT C_VALUE FROM " & strTablePrefix & "CONFIG_NEW WHERE C_VARIABLE = 'intAURecord'"
	set rs = my_conn.execute (strSql)
	intOldRecord = cint(rs("C_VALUE")) '## this is LINE 218
	rs.close
	set rs = nothing


how can i fix this?... am i missing or forgetting something?.... :(





Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 28 March 2009 :  04:18:52  Show Profile  Visit HuwR's Homepage
when do you get the first set of errors?
ie these ones
Error: -2147217865 Could not find output table 'PHOTO_CATEGORY'.
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 28 March 2009 :  04:27:16  Show Profile
hi huwr... :)

in setup.asp.... i clicked "click here to create table in the database"

then i entered admin and password.... after i created the admin account, next, in
the "Please Wait until the installation has been completed !" below it displayes the error u are asking, so i ignored it... and went straight to the forum....

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

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 28 March 2009 :  04:46:54  Show Profile  Visit HuwR's Homepage
mmm, looks like the create_forum script doesn't actually create any tables for access databases
Go to Top of Page

phoenixtaz13
Junior Member

129 Posts

Posted - 28 March 2009 :  05:05:47  Show Profile
hi huwr, good day to you.... :)

any suggestions to what i can do or any files should i look into?....

would it be simplier if i just add this code "AND NOT CAT_ID = 5" in the default.asp file?....

thanks for ur time..... :)


Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 28 March 2009 :  05:12:03  Show Profile  Visit HuwR's Homepage
quote:
would it be simplier if i just add this code "AND NOT CAT_ID = 5" in the default.asp file?....



yes probably.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next 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.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07