rapforums-developer Mailing List for RAP Forums (Page 4)
Status: Beta
Brought to you by:
brippe
You can subscribe to this list here.
2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(12) |
Oct
(4) |
Nov
|
Dec
(7) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(34) |
Feb
(3) |
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
(6) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2005 |
Jan
|
Feb
(32) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: <br...@pr...> - 2004-01-26 17:51:29
|
Update of /cvsroot/rapforums/build In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3528 Modified Files: build.properties Log Message: Update version to 0.8.3 Index: build.properties =================================================================== RCS file: /cvsroot/rapforums/build/build.properties,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** build.properties 9 Dec 2003 19:05:41 -0000 1.2 --- build.properties 26 Jan 2004 17:50:32 -0000 1.3 *************** *** 1,5 **** # Ant build properties for RAP Forums #Deployment Server - Change to your root production portal directory ! deploy.home=j:/Tomcat_4-1-18/webapps/myFC src=./src/source media=./src/media --- 1,5 ---- # Ant build properties for RAP Forums #Deployment Server - Change to your root production portal directory ! deploy.home=d:/uPortal/Tomcat_4-1-18/webapps/myFC src=./src/source media=./src/media *************** *** 11,16 **** xercesImpl.jar=lib/xercesImpl.jar xml-apis.jar=lib/xml-apis.jar ! jdbcDriver.jar=lib/mssqlserver.jar ! #jdbcDriver.jar=lib/mysql.jar jdbcDriverBase.jar=lib/msbase.jar jdbcDriverUtil.jar=lib/msutil.jar --- 11,16 ---- xercesImpl.jar=lib/xercesImpl.jar xml-apis.jar=lib/xml-apis.jar ! #jdbcDriver.jar=lib/mssqlserver.jar ! jdbcDriver.jar=lib/mysql.jar jdbcDriverBase.jar=lib/msbase.jar jdbcDriverUtil.jar=lib/msutil.jar |
From: <br...@pr...> - 2004-01-26 17:51:12
|
Update of /cvsroot/rapforums/build In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3386 Modified Files: build.xml Log Message: Update version to 0.8.3 Index: build.xml =================================================================== RCS file: /cvsroot/rapforums/build/build.xml,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** build.xml 9 Dec 2003 19:05:42 -0000 1.2 --- build.xml 26 Jan 2004 17:50:02 -0000 1.3 *************** *** 4,8 **** <property file="build.properties"/> <property name="app.name" value="RAP Forums"/> ! <property name="app.version" value="0.8.2"/> <property name="deploy.home" value="(set this in build.properties!)"/> <property name="test.home" value="(set this in build.properties!)"/> --- 4,8 ---- <property file="build.properties"/> <property name="app.name" value="RAP Forums"/> ! <property name="app.version" value="0.8.3"/> <property name="deploy.home" value="(set this in build.properties!)"/> <property name="test.home" value="(set this in build.properties!)"/> *************** *** 18,21 **** --- 18,22 ---- <property name="xml-apis.jar" value="(set this in build.properties!)"/> <property name="jdbc2_0-stdext.jar.jar" value="(set this in build.properties!)"/> + <!-- Modify jdbcDriver to the appropriate database driver --> <!-- MS SQL Server 2000: use mssqlserver.jar --> *************** *** 25,31 **** <property name="jdbcDriverBase.jar" value="(set this in build.properties!)"/> <property name="jdbcDriverUtil.jar" value="(set this in build.properties!)"/> <!-- SQLTask is used to load MS SQL stored procedures for forums paging --> ! <!-- Uncomment if you are using MS SQL <taskdef name="SQLTask" classname="edu.fullcoll.uportal.channels.rap.forum.tools.SQLTask"/>--> <!-- ==================== Compile Target ================================= --> <target name="compile"> --- 26,39 ---- <property name="jdbcDriverBase.jar" value="(set this in build.properties!)"/> <property name="jdbcDriverUtil.jar" value="(set this in build.properties!)"/> + <!-- SQLTask is used to load MS SQL stored procedures for forums paging --> ! <!-- Uncomment if you are using MS SQL and MAKE SURE THAT THE SQLTask class file is in your ! classpath path. I have commented it out in case you want to create the stored procedures manually ! or if you are using another database that doesn't support stored procedures. ! ! ****SQLTask creates the stored procedures for Microsoft SQL Server***** ! <taskdef name="SQLTask" classname="edu.fullcoll.uportal.channels.rap.forum.tools.SQLTask"/>--> + <!-- ==================== Compile Target ================================= --> <target name="compile"> *************** *** 41,44 **** --- 49,53 ---- </javac> </target> + <!-- ==================== JavaDoc Target ================================= --> <target name="javadoc" description="Javadoc for RAP Forums channel."> *************** *** 57,60 **** --- 66,70 ---- </javadoc> </target> + <!-- ==================== Jar Forums Target ================================= --> <target name="jarForums" depends="compile"> *************** *** 64,67 **** --- 74,78 ---- </jar> </target> + <!-- ==================== Clean Target ================================= --> <target name="clean" description="Clean all build products."> *************** *** 69,76 **** <delete dir="docs/api"/> </target> <!-- ==================== Package Forums For Release Target ================================= --> <target name="packageRelease" depends="jarForums"> ! <delete file="release/rapForumsV0_8_2.zip"/> ! <zip zipfile="${release.home}/rapForumsV0_8_2.zip"> <fileset dir="." excludes="release/*.zip"/> </zip> --- 80,88 ---- <delete dir="docs/api"/> </target> + <!-- ==================== Package Forums For Release Target ================================= --> <target name="packageRelease" depends="jarForums"> ! <delete file="release/rapForumsV0_8_3.zip"/> ! <zip zipfile="${release.home}/rapForumsV0_8_3.zip"> <fileset dir="." excludes="release/*.zip"/> </zip> *************** *** 102,105 **** --- 114,118 ---- </copy> </target> + <!-- ==================== Load the Database Target ================================= --> <target name="db"> *************** *** 123,126 **** --- 136,140 ---- <!-- Uncomment to use MS SQL stored procedures for forums paging The class edu.fullcoll.uportal.channels.rap.forum.tools.SQLTask MUST be in the classpath + <echo>Creating default values for tables and paging stored procedures</echo> <SQLTask scriptXML="properties/sqlScript.xml"/> |
From: <br...@us...> - 2003-12-09 19:05:46
|
Update of /cvsroot/rapforums/build In directory sc8-pr-cvs1:/tmp/cvs-serv28588 Modified Files: build.properties build.xml Log Message: no message Index: build.properties =================================================================== RCS file: /cvsroot/rapforums/build/build.properties,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** build.properties 25 Sep 2003 23:17:15 -0000 1.1.1.1 --- build.properties 9 Dec 2003 19:05:41 -0000 1.2 *************** *** 1,3 **** --- 1,4 ---- # Ant build properties for RAP Forums + #Deployment Server - Change to your root production portal directory deploy.home=j:/Tomcat_4-1-18/webapps/myFC src=./src/source *************** *** 11,16 **** xml-apis.jar=lib/xml-apis.jar jdbcDriver.jar=lib/mssqlserver.jar jdbcDriverBase.jar=lib/msbase.jar jdbcDriverUtil.jar=lib/msutil.jar ! #Test server test.home=c:/eDrive/Tomcat_4-1-18/webapps/myFC --- 12,19 ---- xml-apis.jar=lib/xml-apis.jar jdbcDriver.jar=lib/mssqlserver.jar + #jdbcDriver.jar=lib/mysql.jar jdbcDriverBase.jar=lib/msbase.jar jdbcDriverUtil.jar=lib/msutil.jar ! jdbc2_0-stdext.jar=lib/jdbc2_0-stdext.jar ! #Test server - Change to your root test portal directory test.home=c:/eDrive/Tomcat_4-1-18/webapps/myFC Index: build.xml =================================================================== RCS file: /cvsroot/rapforums/build/build.xml,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** build.xml 25 Sep 2003 23:17:15 -0000 1.1.1.1 --- build.xml 9 Dec 2003 19:05:42 -0000 1.2 *************** *** 17,25 **** <property name="xercesImpl.jar" value="(set this in build.properties!)"/> <property name="xml-apis.jar" value="(set this in build.properties!)"/> <property name="jdbcDriver.jar" value="(set this in build.properties!)"/> <!-- For SQL Server 2000 ONLY --> <property name="jdbcDriverBase.jar" value="(set this in build.properties!)"/> <property name="jdbcDriverUtil.jar" value="(set this in build.properties!)"/> ! <taskdef name="SQLTask" classname="edu.fullcoll.uportal.channels.rap.forum.tools.SQLTask"/> <!-- ==================== Compile Target ================================= --> <target name="compile"> --- 17,31 ---- <property name="xercesImpl.jar" value="(set this in build.properties!)"/> <property name="xml-apis.jar" value="(set this in build.properties!)"/> + <property name="jdbc2_0-stdext.jar.jar" value="(set this in build.properties!)"/> + <!-- Modify jdbcDriver to the appropriate database driver --> + <!-- MS SQL Server 2000: use mssqlserver.jar --> + <!-- MySQL: use mysql.jar --> <property name="jdbcDriver.jar" value="(set this in build.properties!)"/> <!-- For SQL Server 2000 ONLY --> <property name="jdbcDriverBase.jar" value="(set this in build.properties!)"/> <property name="jdbcDriverUtil.jar" value="(set this in build.properties!)"/> ! <!-- SQLTask is used to load MS SQL stored procedures for forums paging --> ! <!-- Uncomment if you are using MS SQL ! <taskdef name="SQLTask" classname="edu.fullcoll.uportal.channels.rap.forum.tools.SQLTask"/>--> <!-- ==================== Compile Target ================================= --> <target name="compile"> *************** *** 27,30 **** --- 33,37 ---- <classpath> <pathelement location="${gnu-regexp.jar}"/> + <pathelement location="${jdbc2_0-stdext.jar}"/> <pathelement location="${jdom-contrib.jar}"/> <pathelement location="${jdom.jar}"/> *************** *** 70,74 **** </target> <!-- deploys the application to the tomcat lib directory --> ! <target name="deploy"> <echo message="Deploying Rap Forums to ${deploy.home}"/> <echo message="Rap Forums copying server jar to ${deploy.home}/WEB-INF/lib"/> --- 77,81 ---- </target> <!-- deploys the application to the tomcat lib directory --> ! <target name="deploy" depends="jarForums"> <echo message="Deploying Rap Forums to ${deploy.home}"/> <echo message="Rap Forums copying server jar to ${deploy.home}/WEB-INF/lib"/> *************** *** 114,119 **** --- 121,129 ---- <arg value="/properties/data.xml"/> </java> + <!-- Uncomment to use MS SQL stored procedures for forums paging + The class edu.fullcoll.uportal.channels.rap.forum.tools.SQLTask MUST be in the classpath <echo>Creating default values for tables and paging stored procedures</echo> <SQLTask scriptXML="properties/sqlScript.xml"/> + --> </target> </project> |
From: <br...@us...> - 2003-12-09 19:04:29
|
Update of /cvsroot/rapforums/sql/storedProcedures In directory sc8-pr-cvs1:/tmp/cvs-serv28263 Modified Files: sp_getSelectViewForums.sql sp_getSelectViewThread.sql sp_getSelectViewThreads.sql Log Message: no message Index: sp_getSelectViewForums.sql =================================================================== RCS file: /cvsroot/rapforums/sql/storedProcedures/sp_getSelectViewForums.sql,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** sp_getSelectViewForums.sql 19 Sep 2003 16:58:21 -0000 1.1.1.1 --- sp_getSelectViewForums.sql 9 Dec 2003 19:04:22 -0000 1.2 *************** *** 1,2 **** --- 1,4 ---- + --USED WITH MS SQL 2000 + -- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_getSelectViewForums]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sp_getSelectViewForums] Index: sp_getSelectViewThread.sql =================================================================== RCS file: /cvsroot/rapforums/sql/storedProcedures/sp_getSelectViewThread.sql,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** sp_getSelectViewThread.sql 19 Sep 2003 16:58:21 -0000 1.1.1.1 --- sp_getSelectViewThread.sql 9 Dec 2003 19:04:22 -0000 1.2 *************** *** 1,2 **** --- 1,4 ---- + --USED WITH MS SQL 2000 + -- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_getSelectViewThread]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sp_getSelectViewThread] Index: sp_getSelectViewThreads.sql =================================================================== RCS file: /cvsroot/rapforums/sql/storedProcedures/sp_getSelectViewThreads.sql,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** sp_getSelectViewThreads.sql 19 Sep 2003 16:58:21 -0000 1.1.1.1 --- sp_getSelectViewThreads.sql 9 Dec 2003 19:04:22 -0000 1.2 *************** *** 1,2 **** --- 1,4 ---- + --USED WITH MS SQL 2000 + -- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_getSelectViewThreads]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sp_getSelectViewThreads] |
From: <br...@us...> - 2003-12-09 19:03:54
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv28077 Added Files: sqlREADME.txt Log Message: no message --- NEW FILE: sqlREADME.txt --- This directory contains sql dumps from different RDBMS. |
From: <br...@us...> - 2003-12-09 19:03:13
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv27881 Removed Files: rapForumsSQL.sql Log Message: Remove rapForumsSQL.sql - Renamed to rapForumsMSSQL.sql --- rapForumsSQL.sql DELETED --- |
From: <br...@us...> - 2003-12-09 19:01:58
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv27417 Modified Files: rapforumsOracleTables.sql Log Message: no message Index: rapforumsOracleTables.sql =================================================================== RCS file: /cvsroot/rapforums/sql/rapforumsOracleTables.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** rapforumsOracleTables.sql 3 Oct 2003 17:19:45 -0000 1.1 --- rapforumsOracleTables.sql 9 Dec 2003 19:01:53 -0000 1.2 *************** *** 1,3 **** ! -- By Steve Barrett sm...@co... DROP TABLE RAPCATEGORY CASCADE CONSTRAINTS ; --- 1,3 ---- ! DROP TABLE RAPCATEGORY CASCADE CONSTRAINTS ; |
From: <br...@us...> - 2003-12-09 19:00:55
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv27060 Added Files: rapforumsMYSQLTables.sql Log Message: no message --- NEW FILE: rapforumsMYSQLTables.sql --- --The default table type in MySQL is MyISAM. If you are trying to use a table type that is not incompiled or activated, MySQL will instead create a table of type MyISAM. --Advantages of not transaction-safe tables (NTST): --Much faster as there is no transcation overhead. --Will use less disk space as there is no overhead of transactions. --Will use less memory to do updates. CREATE DATABASE IF NOT EXISTS portaldb; USE portaldb DROP TABLE RAPCATEGORY CASCADE CONSTRAINTS ; CREATE TABLE RAPCATEGORY ( CATEGORYID INTEGER NOT NULL, NAME VARCHAR (85) NOT NULL, DESCRIPTION VARCHAR (255), CREATIONDATE TIMESTAMP(6), --DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6), -- DEFAULT sysdate, LFT INTEGER , RGT INTEGER , CONSTRAINT RAPCATEGORY_IDX PRIMARY KEY ( CATEGORYID ) ) ; DROP TABLE RAPCOMMENT CASCADE CONSTRAINTS ; CREATE TABLE RAPCOMMENT ( COMMENTID INTEGER NOT NULL, PARENTCOMMENTID INTEGER, THREADID INTEGER, FORUMID INTEGER, USERID VARCHAR (255), SUBJECT VARCHAR (255), BODY VARCHAR (255), MODVALUE DECIMAL , BONUSPOINTS INTEGER, CREATIONDATE TIMESTAMP(6), -- DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6), -- DEFAULT sysdate, CONSTRAINT RAPCOMMENT_IDX PRIMARY KEY ( COMMENTID ) ) ; DROP TABLE RAPFORUM CASCADE CONSTRAINTS ; CREATE TABLE RAPFORUM ( FORUMID INTEGER NOT NULL, NAME VARCHAR (255), DESCRIPTION VARCHAR (255), CREATIONDATE TIMESTAMP(6), -- DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6), -- DEFAULT sysdate, CATEGORYID INTEGER NOT NULL, CONSTRAINT RAPFORUM_IDX PRIMARY KEY ( FORUMID ) ) ; DROP TABLE RAPID CASCADE CONSTRAINTS ; CREATE TABLE RAPID ( IDTYPE INTEGER, ID INTEGER ) ; DROP TABLE RAPTHREAD CASCADE CONSTRAINTS ; CREATE TABLE RAPTHREAD ( THREADID INTEGER NOT NULL, FORUMID INTEGER NOT NULL, ROOTCOMMENTID INTEGER, MODVALUE INTEGER, BONUSPOINTS INTEGER, -- default 0 CREATIONDATE TIMESTAMP(6), -- DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6), -- DEFAULT sysdate, CONSTRAINT RAPTHREAD_IDX PRIMARY KEY ( THREADID, FORUMID ) ) ; insert into rapCategory(CATEGORYID,name,description, creationDate, modifiedDate, lft, rgt) values (1,'General', 'This is a tempory category for Rap Forums','2003-09-24 08:00:00','2003-09-24 08:00:00', 1, 2); insert into rapForum(forumID,name,description,creationDate, modifiedDate, categoryID) values(1,'New Forums Channel', 'This is a tempory Forum for information about Rap Forums', '2003-09-24 08:00:00', '2003-09-24 08:00:00', 1); insert into rapID(idType, id) values (1, 1); insert into rapID(idType, id) values (4, 1); |
From: <br...@us...> - 2003-12-09 19:00:32
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv26824 Added Files: rapForumsMSSQL.sql Log Message: no message --- NEW FILE: rapForumsMSSQL.sql --- -- RAP FORUMS SQL SCRIPTS -- This script creates a database called "uPortal_Channels" and creates all tables needed by RAP Forums -- -- Fullerton College -- Brad Rippe (br...@fu...) IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'uPortal_Channels') DROP DATABASE [uPortal_Channels] GO CREATE DATABASE [uPortal_Channels] COLLATE SQL_Latin1_General_CP1_CI_AS GO exec sp_dboption N'uPortal_Channels', N'autoclose', N'false' GO exec sp_dboption N'uPortal_Channels', N'bulkcopy', N'true' GO exec sp_dboption N'uPortal_Channels', N'trunc. log', N'true' GO exec sp_dboption N'uPortal_Channels', N'torn page detection', N'true' GO exec sp_dboption N'uPortal_Channels', N'read only', N'false' GO exec sp_dboption N'uPortal_Channels', N'dbo use', N'false' GO exec sp_dboption N'uPortal_Channels', N'single', N'false' GO exec sp_dboption N'uPortal_Channels', N'autoshrink', N'false' GO exec sp_dboption N'uPortal_Channels', N'ANSI null default', N'false' GO exec sp_dboption N'uPortal_Channels', N'recursive triggers', N'false' GO exec sp_dboption N'uPortal_Channels', N'ANSI nulls', N'false' GO exec sp_dboption N'uPortal_Channels', N'concat null yields null', N'false' GO exec sp_dboption N'uPortal_Channels', N'cursor close on commit', N'false' GO exec sp_dboption N'uPortal_Channels', N'default to local cursor', N'false' GO exec sp_dboption N'uPortal_Channels', N'quoted identifier', N'false' GO exec sp_dboption N'uPortal_Channels', N'ANSI warnings', N'false' GO exec sp_dboption N'uPortal_Channels', N'auto create statistics', N'true' GO exec sp_dboption N'uPortal_Channels', N'auto update statistics', N'true' GO use [uPortal_Channels] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapBonus]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapBonus] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapCategory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapCategory] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapCategoryProperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapCategoryProperties] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapComment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapComment] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapCommentProperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapCommentProperties] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapForum]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapForum] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapForumProperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapForumProperties] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapID] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapModerate]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapModerate] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapThread]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapThread] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapThreadProperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapThreadProperties] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapUserPermissions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapUserPermissions] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapUserProperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapUserProperties] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rapWatch]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rapWatch] GO if not exists (select * from dbo.sysusers where name = N'DBA' and uid < 16382) EXEC sp_grantdbaccess N'DBA', N'DBA' GO if not exists (select * from dbo.sysusers where name = N'uPortal_CH' and uid < 16382) EXEC sp_grantdbaccess N'uPortal_CH', N'uPortal_CH' GO exec sp_addrolemember N'db_datareader', N'uPortal_CH' GO exec sp_addrolemember N'db_datawriter', N'uPortal_CH' GO exec sp_addrolemember N'db_owner', N'uPortal_CH' GO CREATE TABLE [dbo].[rapBonus] ( [userID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [creationDate] [smalldatetime] NULL , [bonusPoints] [int] NULL , [commentID] [int] NULL , [threadID] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rapCategory] ( [categoryID] [int] NOT NULL , [name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [creationDate] [smalldatetime] NULL , [modifiedDate] [smalldatetime] NULL , [lft] [int] NULL , [rgt] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapCategoryProperties] ( [categoryID] [int] NULL , [name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [propValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapComment] ( [commentID] [int] NOT NULL , [parentCommentID] [int] NULL , [threadID] [int] NULL , [forumID] [int] NULL , [userID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [subject] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [body] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [modValue] [int] NULL , [bonusPoints] [int] NULL , [creationDate] [smalldatetime] NULL , [modifiedDate] [smalldatetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapCommentProperties] ( [commentID] [int] NULL , [name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [propValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapForum] ( [forumID] [int] NOT NULL , [name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [creationDate] [smalldatetime] NULL , [modifiedDate] [smalldatetime] NULL , [categoryID] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapForumProperties] ( [forumID] [int] NULL , [name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [propValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapID] ( [idType] [int] NULL , [id] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rapModerate] ( [objectID] [int] NULL , [objectType] [int] NULL , [userID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [modDate] [smalldatetime] NULL , [modValue] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rapThread] ( [threadID] [int] NOT NULL , [forumID] [int] NOT NULL , [rootCommentID] [int] NULL , [modValue] [int] NULL , [bonusPoints] [int] NULL , [creationDate] [smalldatetime] NULL , [modifiedDate] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rapThreadProperties] ( [threadID] [int] NULL , [name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [propValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapUserPermissions] ( [categoryID] [int] NULL , [forumID] [int] NULL , [userID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [userType] [int] NULL , [permission] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[rapUserProperties] ( [userID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [propValue] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rapWatch] ( [userID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [categoryID] [int] NULL , [forumID] [int] NULL , [threadID] [int] NULL , [watchType] [int] NULL , [expirable] [int] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[rapCategory] WITH NOCHECK ADD CONSTRAINT [PK_rapCategory] PRIMARY KEY CLUSTERED ( [categoryID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[rapComment] WITH NOCHECK ADD CONSTRAINT [PK_rapComment] PRIMARY KEY CLUSTERED ( [commentID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[rapForum] WITH NOCHECK ADD CONSTRAINT [PK_rapForum] PRIMARY KEY CLUSTERED ( [forumID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[rapThread] WITH NOCHECK ADD CONSTRAINT [PK_rapThread] PRIMARY KEY CLUSTERED ( [threadID], [forumID] ) ON [PRIMARY] GO ALTER TABLE [dbo].[rapBonus] WITH NOCHECK ADD CONSTRAINT [DF_rapBonus_creationDate] DEFAULT (getdate()) FOR [creationDate] GO ALTER TABLE [dbo].[rapCategory] WITH NOCHECK ADD CONSTRAINT [DF_rapCategory_creationDate] DEFAULT (getdate()) FOR [creationDate], CONSTRAINT [DF_rapCategory_modifiedDate] DEFAULT (getdate()) FOR [modifiedDate] GO ALTER TABLE [dbo].[rapComment] WITH NOCHECK ADD CONSTRAINT [DF_rapComment_creationDate] DEFAULT (getdate()) FOR [creationDate], CONSTRAINT [DF_rapComment_modifiedDate] DEFAULT (getdate()) FOR [modifiedDate] GO ALTER TABLE [dbo].[rapForum] WITH NOCHECK ADD CONSTRAINT [DF_rapForum_creationDate] DEFAULT (getdate()) FOR [creationDate], CONSTRAINT [DF_rapForum_modifiedDate] DEFAULT (getdate()) FOR [modifiedDate] GO ALTER TABLE [dbo].[rapThread] WITH NOCHECK ADD CONSTRAINT [DF_rapThread_bonusPoints] DEFAULT (0) FOR [bonusPoints], CONSTRAINT [DF_rapThread_creationDate] DEFAULT (getdate()) FOR [creationDate], CONSTRAINT [DF_rapThread_modifiedDate] DEFAULT (getdate()) FOR [modifiedDate] GO |
From: <br...@us...> - 2003-10-03 17:21:24
|
Update of /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum In directory sc8-pr-cvs1:/tmp/cvs-serv32336/edu/fullcoll/uportal/channels/rap/forum Modified Files: forum.xsl post.xsl thread.xml Log Message: no message Index: forum.xsl =================================================================== RCS file: /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum/forum.xsl,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** forum.xsl 17 Sep 2003 19:54:03 -0000 1.1.1.1 --- forum.xsl 3 Oct 2003 17:21:21 -0000 1.2 *************** *** 12,16 **** <xsl:variable name="mediaPath" select="'media/edu/fullcoll/uportal/channels/rap'"/> - <!-- helper functions --> <xsl:template name="incr"> --- 12,15 ---- *************** *** 57,67 **** </xsl:template> ! ! ! ! ! ! <xsl:template match="/"> ! <!-- todo remove --- 56,60 ---- </xsl:template> ! <xsl:template match="/"> <!-- todo remove *************** *** 82,89 **** } </style> - - - - <!-- show our logo --> --- 75,78 ---- Index: post.xsl =================================================================== RCS file: /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum/post.xsl,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** post.xsl 17 Sep 2003 19:54:03 -0000 1.1.1.1 --- post.xsl 3 Oct 2003 17:21:21 -0000 1.2 *************** *** 25,29 **** </style> - <!-- todo remove <base href="G:/uportal/FCForums/FCForums/webpages/"/> --- 25,28 ---- *************** *** 31,35 **** --> - <!-- Show our logo --> <table class="uportal-background-light" --- 30,33 ---- *************** *** 112,119 **** </table> <p/> - - - - --- 110,113 ---- Index: thread.xml =================================================================== RCS file: /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum/thread.xml,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** thread.xml 25 Sep 2003 22:57:08 -0000 1.2 --- thread.xml 3 Oct 2003 17:21:21 -0000 1.3 *************** *** 1,87 **** ! <?xml version="1.0" encoding="UTF-8"?> ! <rap> ! <username>dick head</username> ! <currentPage>1</currentPage> ! <rapForum> ! <forumID>1</forumID> ! <!-- needed for link back to forum --> ! <forumName>This is test forum 1</forumName> ! <!--needed--> ! <forumCategoryID>1</forumCategoryID> ! <!-- need --> ! <forumCategoryName>General</forumCategoryName> ! <!-- needed --> ! <threadID>1</threadID> ! <!--needed--> ! <numComments>25</numComments> ! <rapComments> ! <rapComment> ! <commentID>1</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body ! testing carriage returns... ! </body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>2</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body2</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>3</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body3</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>4</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body4</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>5</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body5</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! </rapComments> ! </rapForum> ! </rap> --- 1,54 ---- ! <?xml version="1.0" encoding="utf-8"?><rap> ! <rapForum> ! <forumID>12</forumID> ! <forumName>New Web Site</forumName> ! <forumCategoryID>1</forumCategoryID> ! <forumCategoryName>General</forumCategoryName> ! <threadID>13</threadID> ! <numComments>2</numComments> ! <rapComments> ! <rapComment> ! <rownum>1</rownum> ! <commentID>20</commentID> ! <parentCommentID>0</parentCommentID> ! <threadID>13</threadID> ! <forumID>12</forumID> ! <userID>smoore</userID> ! <subject>Unscaled Web Page(s)</subject> ! <body>Anyone besides me frustrated with the way the site does not fit in ! to a standard window (even fully maximized), and how you can't get to the left t ! o right scroll bar without using the up to down scrollbar to go all the way to t ! he bottom of the page? How come all the links are hard to find because the page ! does not display properly in the browser window?</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, August 15, 2003 12:11:00 AM PDT</creationDate> ! <modifiedDate>Friday, August 15, 2003 12:11:00 AM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <rownum>2</rownum> ! <commentID>21</commentID> ! <parentCommentID>20</parentCommentID> ! <threadID>13</threadID> ! <forumID>12</forumID> ! <userID>brippe</userID> ! <subject>RE: Unscaled Web Page(s)</subject> ! <body>Are you referring to the Portal or the Main Campus Pages? ! ! ! ----Original Message---- ! Anyone besides me frustrated with the way the site does not fit into a standard ! window (even fully maximized), and how you can't get to the left to right scroll ! bar without using the up to down scrollbar to go all the way to the bottom of t ! he page? How come all the links are hard to find because the page does not disp ! lay properly in the browser window?</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, August 15, 2003 4:12:00 PM PDT</creationDate> ! <modifiedDate>Friday, August 15, 2003 4:12:00 PM PDT</modifiedDate> ! </rapComment> ! </rapComments> ! </rapForum> ! <username>Brad Rippe</username> ! <currentPage>1.0</currentPage> ! </rap> \ No newline at end of file |
From: <br...@us...> - 2003-10-03 17:20:57
|
Update of /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum In directory sc8-pr-cvs1:/tmp/cvs-serv32223 Modified Files: thread.xsl Log Message: Update message bug - template would not display first line of a reply - FIXED Index: thread.xsl =================================================================== RCS file: /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum/thread.xsl,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** thread.xsl 25 Sep 2003 22:57:08 -0000 1.2 --- thread.xsl 3 Oct 2003 17:20:52 -0000 1.3 *************** *** 154,160 **** </td> </tr> ! </table> ! ! <!-- show the available forums --> --- 154,158 ---- </td> </tr> ! </table> <!-- show the available forums --> *************** *** 195,199 **** <td> <div class="PRE"> ! <xsl:call-template name="break"> <xsl:with-param name="text" select="body"/> </xsl:call-template> --- 193,198 ---- <td> <div class="PRE"> ! <!--<xsl:value-of select="body"/>--> ! <xsl:call-template name="break"> <xsl:with-param name="text" select="body"/> </xsl:call-template> *************** *** 283,287 **** <xsl:choose> <xsl:when test="contains($text, '
')"> ! <br/> <xsl:call-template name="break"> <xsl:with-param name="text" select="substring-after($text, '
')"/> --- 282,287 ---- <xsl:choose> <xsl:when test="contains($text, '
')"> ! <xsl:variable name="before-end-of-line" select="substring-before($text, '
')"/> ! <xsl:value-of select="$before-end-of-line"/><br/> <xsl:call-template name="break"> <xsl:with-param name="text" select="substring-after($text, '
')"/> |
From: <br...@us...> - 2003-10-03 17:19:49
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv31926 Added Files: rapforumsOracleTables.sql Log Message: Add Oracle DB Dump - Creation script for forums tables --- NEW FILE: rapforumsOracleTables.sql --- -- By Steve Barrett sm...@co... DROP TABLE RAPCATEGORY CASCADE CONSTRAINTS ; CREATE TABLE RAPCATEGORY ( CATEGORYID NUMBER NOT NULL, NAME VARCHAR2 (85) NOT NULL, DESCRIPTION VARCHAR2 (255), CREATIONDATE TIMESTAMP(6) DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6) DEFAULT sysdate, LFT NUMBER, RGT NUMBER, CONSTRAINT RAPCATEGORY_IDX PRIMARY KEY ( CATEGORYID ) ) ; DROP TABLE RAPCOMMENT CASCADE CONSTRAINTS ; CREATE TABLE RAPCOMMENT ( COMMENTID NUMBER NOT NULL, PARENTCOMMENTID NUMBER, THREADID NUMBER, FORUMID NUMBER, USERID VARCHAR2 (255), SUBJECT VARCHAR2 (255), BODY VARCHAR2 (255), MODVALUE NUMBER, BONUSPOINTS NUMBER, CREATIONDATE TIMESTAMP(6) DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6) DEFAULT sysdate, CONSTRAINT RAPCOMMENT_IDX PRIMARY KEY ( COMMENTID ) ) ; DROP TABLE RAPFORUM CASCADE CONSTRAINTS ; CREATE TABLE RAPFORUM ( FORUMID NUMBER NOT NULL, NAME VARCHAR2 (255), DESCRIPTION VARCHAR2 (255), CREATIONDATE TIMESTAMP(6) DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6) DEFAULT sysdate, CATEGORYID NUMBER NOT NULL, CONSTRAINT RAPFORUM_IDX PRIMARY KEY ( FORUMID ) ) ; DROP TABLE RAPID CASCADE CONSTRAINTS ; CREATE TABLE RAPID ( IDTYPE NUMBER, ID NUMBER ) ; DROP TABLE RAPTHREAD CASCADE CONSTRAINTS ; CREATE TABLE RAPTHREAD ( THREADID NUMBER NOT NULL, FORUMID NUMBER NOT NULL, ROOTCOMMENTID NUMBER, MODVALUE NUMBER, BONUSPOINTS NUMBER, CREATIONDATE TIMESTAMP(6) DEFAULT sysdate, MODIFIEDDATE TIMESTAMP(6) DEFAULT sysdate, CONSTRAINT RAPTHREAD_IDX PRIMARY KEY ( THREADID, FORUMID ) ) ; |
From: <br...@us...> - 2003-10-03 17:19:04
|
Update of /cvsroot/rapforums/build In directory sc8-pr-cvs1:/tmp/cvs-serv31736 Added Files: setclasspath.bat Log Message: Add classpath setup batch --- NEW FILE: setclasspath.bat --- echo on set deploy.home=j:/Tomcat_4-1-18/webapps/myFC set test.home=c:/eDrive/Tomcat_4-1-18/webapps/myFC set classpath=%classpath%./lib/log4j.jar;./lib/jdom.jar;./classes;%test.home%/WEB-INF/classes;./lib/msbase.jar;./lib/mssqlserver.jar;./lib/msutil.jar |
From: <br...@us...> - 2003-09-25 23:17:53
|
Update of /cvsroot/rapforums/sql In directory sc8-pr-cvs1:/tmp/cvs-serv22017 Removed Files: build.properties build.xml ReadMe0.8.2.txt Log Message: remove files from sql --- build.properties DELETED --- --- build.xml DELETED --- --- ReadMe0.8.2.txt DELETED --- |
From: <br...@us...> - 2003-09-25 23:04:27
|
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/tools In directory sc8-pr-cvs1:/tmp/cvs-serv19426 Added Files: SQLTask.java Log Message: no message --- NEW FILE: SQLTask.java --- /** * Copyright (C) 2003, Fullerton College. All Rights Reserved. * (http://www.fullcoll.edu) * * This software is distributed under the IBM Public Licence. Please see * the license infomation for more details at http://www.opensource.org/licenses/ibmpl.php. * EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, THE PROGRAM IS PROVIDED * ON AN "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, EITHER * EXPRESS OR IMPLIED INCLUDING, WITHOUT LIMITATION, ANY WARRANTIES OR CONDITIONS * OF TITLE, NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. * Each Recipient is solely responsible for determining the appropriateness of using * and distributing the Program and assumes all risks associated with its exercise * of rights under this Agreement, including but not limited to the risks and costs * of program errors, compliance with applicable laws, damage to or loss of data, * programs or equipment, and unavailability or interruption of operations. * * This software is OSI Certified Open Source Software. * OSI Certified is a certification mark of the Open Source Initiative */ package edu.fullcoll.uportal.channels.rap.forum.tools; import java.sql.Connection; import java.sql.Statement; import java.sql.DatabaseMetaData; import java.io.File; import java.util.List; import java.util.Iterator; import org.apache.tools.ant.BuildException; import org.apache.tools.ant.Task; import org.jasig.portal.RDBMServices; import org.jdom.input.SAXBuilder; import org.jdom.Document; import org.jdom.Element; /** * This class is a custom Ant Task that reads an xml file and sets the * default values for the forum tables and creates the paging stored procedures. * * @author Brad Rippe (br...@fu...) * @version 0.8.2 $Revision %G% */ public class SQLTask extends Task { // The method executing the task public void execute() throws BuildException { Connection con = null; Statement stmt = null; try { System.out.println("Reading "+scriptXML+"..."); SAXBuilder builder = new SAXBuilder(); Document doc = builder.build(new File(scriptXML)); rdbmService = new RDBMServices(); con = rdbmService.getConnection(); if(con != null) { DatabaseMetaData dbMD = con.getMetaData(); System.out.println("Connecting to "+dbMD.getDatabaseProductName()+" "+dbMD.getDatabaseProductVersion()); System.out.println(dbMD.getURL()); stmt = con.createStatement(); Element root = doc.getRootElement(); Element alterTables = root.getChild("alterTables"); List alters = alterTables.getChildren("alter"); Iterator i = alters.iterator(); System.out.println("Executing table default values..."); while(i.hasNext()) { Element element = (Element) i.next(); stmt.executeUpdate(element.getText()); } Element storedProcedureElement = root.getChild("storedProcedures"); List sProcedures = storedProcedureElement.getChildren("storedProcedure"); Iterator j = sProcedures.iterator(); System.out.println("Creating forums paging stored procedures..."); while(j.hasNext()) { Element element = (Element) j.next(); stmt.executeUpdate(element.getText()); } rdbmService.releaseConnection(con); } else { System.out.println("Connection is null"); } } catch (Exception e) { e.printStackTrace(); } finally { try { stmt.close(); } catch (Exception e) {} } } public void setScriptXML(String scriptXML) { this.scriptXML = scriptXML; } private RDBMServices rdbmService; private String scriptXML = null; } |
From: <br...@us...> - 2003-09-25 23:02:48
|
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/tools In directory sc8-pr-cvs1:/tmp/cvs-serv18860/tools Log Message: Directory /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/tools added to the repository |
From: <br...@us...> - 2003-09-25 23:00:43
|
Update of /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum In directory sc8-pr-cvs1:/tmp/cvs-serv18314/stylesheets/edu/fullcoll/uportal/channels/rap/forum Removed Files: .nbattrs Log Message: no message --- .nbattrs DELETED --- |
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source/edu/fullcoll/uportal/channels/rap/forum Modified Files: CForum.java ForumSearch.java IDManager.java IForum.java IForumCategory.java IForumComment.java IForumThread.java IForumsManager.java ISearchManager.java IUser.java IUserManager.java NestedException.java RAPException.java RAPForum.java RAPForumCategory.java RAPForumComment.java RAPForumThread.java RAPForumsManager.java RAPIDManagerException.java RAPUser.java forum.dfPackage Log Message: no message Index: CForum.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/CForum.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** CForum.java 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- CForum.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 36,39 **** --- 36,40 ---- import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBException; + import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBConfig; import edu.fullcoll.uportal.channels.rap.forum.commands.AboutModeCommand; import edu.fullcoll.uportal.channels.rap.forum.commands.MainModeCommand; *************** *** 45,56 **** /** ! * CForum ! * ! * This is the main class for the MY FC Forums channel. * This proxy takes requests and directs responses to the correct * xsl stylesheet based on the incoming request. * * @author Brad Rippe (br...@fu...) and Chris Pereda (cp...@fu...), Tung Lai Thanh (lt...@ya...) ! * @version 0.3 $Revision 05/05/2003 */ public class CForum implements IChannel { --- 46,56 ---- /** ! * This is the main class for the RAP Forums channel. * This proxy takes requests and directs responses to the correct * xsl stylesheet based on the incoming request. * * @author Brad Rippe (br...@fu...) and Chris Pereda (cp...@fu...), Tung Lai Thanh (lt...@ya...) ! * @version 0.8.2 $Revision %G% ! * 09/19/2003 */ public class CForum implements IChannel { *************** *** 95,98 **** --- 95,105 ---- public void setStaticData(ChannelStaticData sd) { this.staticData = sd; + // Configuration for multiple DBs + // defaults to a single database called "uPortal" + // MultiDB supports DS for "uPortal" and another DS for "uPortal_Channels" + String multiDB = staticData.getParameter("multiDB"); + if(multiDB != null && multiDB.equals("true")) + RAPDBConfig.getInstance().setMultiDS(true); + } *************** *** 103,111 **** public void setRuntimeData(ChannelRuntimeData rd) { this.runtimeData = rd; - - //todo, fix this? - /*if (runtimeData.getParameter("back") != null) { - this.mode = mode; - }*/ if (runtimeData.getParameter("mode") != null) { --- 110,113 ---- Index: ForumSearch.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/ForumSearch.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ForumSearch.java 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- ForumSearch.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 29,34 **** /** - * ForumSearch - * * This class is the search interface for rap forums. * (Current search uses a bare bones search. ForumSearch --- 29,32 ---- *************** *** 38,42 **** * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision: */ public class ForumSearch implements ISearchManager { --- 36,40 ---- * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% */ public class ForumSearch implements ISearchManager { Index: IDManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IDManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IDManager.java 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- IDManager.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 26,31 **** /** - * IDManager - * * This class manages identification numbers for forums, threads, comments, and categories. * The advantages is that the user will know what the id of a forum entitiy is --- 26,29 ---- *************** *** 33,37 **** * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision 01/31/2003 * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestIDManager */ --- 31,36 ---- * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% ! * 01/31/2003 * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestIDManager */ Index: IForum.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IForum.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IForum.java 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- IForum.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 31,40 **** /** - * IForums - * * The forums interface for the rap forums * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public interface IForum --- 31,38 ---- /** * The forums interface for the rap forums * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IForum Index: IForumCategory.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IForumCategory.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IForumCategory.java 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- IForumCategory.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 27,36 **** /** - * IForumCategory - * * This is the forum category interface. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision 02/03/2003 */ public interface IForumCategory { --- 27,35 ---- /** * This is the forum category interface. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% ! * 02/03/2003 */ public interface IForumCategory { Index: IForumComment.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IForumComment.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IForumComment.java 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- IForumComment.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 29,33 **** * Interface for a forum comment. * @author Brad Rippe (br...@fu...), Christopher Pereda (cp...@fu...) ! * @version 0.3 */ public interface IForumComment --- 29,33 ---- * Interface for a forum comment. * @author Brad Rippe (br...@fu...), Christopher Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IForumComment Index: IForumThread.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IForumThread.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IForumThread.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- IForumThread.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 29,38 **** /** - * IForumThread - * * The forum thread interface. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: */ public interface IForumThread --- 29,36 ---- /** * The forum thread interface. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IForumThread Index: IForumsManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IForumsManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IForumsManager.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- IForumsManager.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 27,36 **** /** - * IForumsManager - * * Manager interface for the rap forums * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public interface IForumsManager --- 27,34 ---- /** * Manager interface for the rap forums * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IForumsManager Index: ISearchManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/ISearchManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ISearchManager.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- ISearchManager.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 24,29 **** /** - * SearchManager - * * The search interface for rap forums. * (There are no classes that implement this interface) --- 24,27 ---- *************** *** 32,36 **** * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision: */ public interface ISearchManager { --- 30,34 ---- * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface ISearchManager { Index: IUser.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IUser.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IUser.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- IUser.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 26,29 **** --- 26,35 ---- import java.util.Properties; + /** + * Forums user interface + * + * @author Brad Rippe (br...@fu...), Christopher Pereda (cp...@fu...) + * @version 0.8.2 $Revision %G% + */ public interface IUser { Index: IUserManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/IUserManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IUserManager.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- IUserManager.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 26,35 **** /** ! * IUser ! * ! * This is the interface for forum users. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public interface IUserManager --- 26,33 ---- /** ! * This is the interface for managing forum users. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IUserManager Index: NestedException.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/NestedException.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** NestedException.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- NestedException.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 24,29 **** /** - * NestedException - * * This class represents a nested expection. * A nested exception is generated by another exception and --- 24,27 ---- *************** *** 32,36 **** * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision %G% */ public class NestedException extends Exception --- 30,34 ---- * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class NestedException extends Exception Index: RAPException.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPException.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPException.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPException.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 26,35 **** /** - * RAPException - * * RAPException occur if an error occurs from rap forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision * @see edu.fullcoll.uportal.channels.rap.forum.NestedException */ --- 26,33 ---- /** * RAPException occur if an error occurs from rap forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% * @see edu.fullcoll.uportal.channels.rap.forum.NestedException */ Index: RAPForum.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPForum.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPForum.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPForum.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 31,41 **** /** - * RAPForum - * * This class represents a RAP Forum. Forums consist of threads and comments * (messages). RAP forums are based on a name, description and category. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 1.0 $Revision * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestRAPForum */ --- 31,39 ---- /** * This class represents a RAP Forum. Forums consist of threads and comments * (messages). RAP forums are based on a name, description and category. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestRAPForum */ Index: RAPForumCategory.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPForumCategory.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPForumCategory.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPForumCategory.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 25,34 **** /** - * RAPForumCategory - * * This class represents a forum category. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision 02/03/2003 */ public class RAPForumCategory implements IForumCategory { --- 25,33 ---- /** * This class represents a forum category. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% ! * 02/03/2003 */ public class RAPForumCategory implements IForumCategory { Index: RAPForumComment.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPForumComment.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPForumComment.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPForumComment.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 27,36 **** /** - * RAPForumComment - * * This class represents the comments (message) in a forum. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestRAPForumComment */ --- 27,34 ---- /** * This class represents the comments (message) in a forum. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestRAPForumComment */ Index: RAPForumThread.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPForumThread.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPForumThread.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPForumThread.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 30,35 **** /** - * RAPForumThread - * * This class represents the forums threads. Threads are associated with * a forum. RAP threads contains a collection of comments (messages) that --- 30,33 ---- *************** *** 37,41 **** * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 1.0 $Revision * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestRAPForumThread */ --- 35,39 ---- * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% * @testcase test.edu.fullcoll.uportal.channels.rap.forum.TestRAPForumThread */ Index: RAPForumsManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPForumsManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPForumsManager.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPForumsManager.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 34,43 **** /** - * RapForumsManager - * * This class provides the search funcitionality for the forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public class RAPForumsManager implements IForumsManager --- 34,41 ---- /** * This class provides the search funcitionality for the forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class RAPForumsManager implements IForumsManager Index: RAPIDManagerException.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPIDManagerException.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPIDManagerException.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPIDManagerException.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 24,33 **** /** - * RapForumsManager - * * This exception is thrown by RAPForumsManager. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision * @see edu.fullcoll.uportal.channels.rap.forum.RAPForumsManager */ --- 24,31 ---- /** * This exception is thrown by RAPForumsManager. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% * @see edu.fullcoll.uportal.channels.rap.forum.RAPForumsManager */ Index: RAPUser.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/RAPUser.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPUser.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- RAPUser.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 27,36 **** /** - * RAPUser - * * This class represents a forum user * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public class RAPUser implements IUser { --- 27,34 ---- /** * This class represents a forum user * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class RAPUser implements IUser { Index: forum.dfPackage =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/forum.dfPackage,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** forum.dfPackage 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- forum.dfPackage 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 7,11 **** */ class diagram { ! }/** @__tags @shapeType ClassDiagram --- 7,17 ---- */ class diagram { ! /** ! @__ref <oiref:design#Class#id1pf4edky6tdqcdkznhyls.diagram:oiref><oihard> ! @__modelType reference ! @__fqn <oiref:#Package#edu.fullcoll.uportal.channels.rap.forum.tools:oiref> ! */ ! class reference { ! }}/** @__tags @shapeType ClassDiagram |
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/filter In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source/edu/fullcoll/uportal/channels/rap/forum/filter Modified Files: DefaultFilter.java ICommentFilter.java IFilterManager.java ProfanityFilter.java RAPFilterManager.java Log Message: no message Index: DefaultFilter.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/filter/DefaultFilter.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** DefaultFilter.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- DefaultFilter.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 24,33 **** /** - * DefaultFilter - * * Default comment filter. This just returns the comment unchanged. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: */ public class DefaultFilter implements ICommentFilter { --- 24,31 ---- /** * Default comment filter. This just returns the comment unchanged. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class DefaultFilter implements ICommentFilter { Index: ICommentFilter.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/filter/ICommentFilter.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ICommentFilter.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- ICommentFilter.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 24,33 **** /** - * ICommentFilter - * * Interface for comment filters * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: */ public interface ICommentFilter --- 24,31 ---- /** * Interface for comment filters * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface ICommentFilter Index: IFilterManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/filter/IFilterManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IFilterManager.java 17 Sep 2003 19:54:02 -0000 1.1.1.1 --- IFilterManager.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 26,35 **** /** - * IFilterManager - * * Interface for filter managers * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: */ public interface IFilterManager { --- 26,33 ---- /** * Interface for filter managers * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IFilterManager { Index: ProfanityFilter.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/filter/ProfanityFilter.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ProfanityFilter.java 17 Sep 2003 19:54:02 -0000 1.1.1.1 --- ProfanityFilter.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 30,39 **** /** - * ProfanityFilter - * * Class that filters profanity out of a comment. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: */ public class ProfanityFilter implements ICommentFilter { --- 30,37 ---- /** * Class that filters profanity out of a comment. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class ProfanityFilter implements ICommentFilter { Index: RAPFilterManager.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/filter/RAPFilterManager.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPFilterManager.java 17 Sep 2003 19:54:02 -0000 1.1.1.1 --- RAPFilterManager.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 28,37 **** /** - * RAPFilterManager - * * The filter manager for RAP forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: */ public class RAPFilterManager implements IFilterManager { --- 28,35 ---- /** * The filter manager for RAP forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class RAPFilterManager implements IFilterManager { |
From: <br...@us...> - 2003-09-25 22:57:13
|
Update of /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum In directory sc8-pr-cvs1:/tmp/cvs-serv17361/stylesheets/edu/fullcoll/uportal/channels/rap/forum Modified Files: thread.xml thread.xsl Log Message: no message Index: thread.xml =================================================================== RCS file: /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum/thread.xml,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** thread.xml 17 Sep 2003 19:54:03 -0000 1.1.1.1 --- thread.xml 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 1,81 **** <?xml version="1.0" encoding="UTF-8"?> <rap> ! <username>dick head</username> ! <currentPage>1</currentPage> <rapForum> ! <forumID>1</forumID><!-- needed for link back to forum --> ! <forumName>This is test forum 1</forumName><!--needed--> ! <forumCategoryID>1</forumCategoryID><!-- need --> ! <forumCategoryName>General</forumCategoryName><!-- needed --> ! <threadID>1</threadID><!--needed--> ! <numComments>25</numComments> ! ! <rapComments> ! <rapComment> ! <commentID>1</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>2</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>3</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>4</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>5</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! </rapComments> </rapForum> </rap> --- 1,87 ---- <?xml version="1.0" encoding="UTF-8"?> <rap> ! <username>dick head</username> ! <currentPage>1</currentPage> <rapForum> ! <forumID>1</forumID> ! <!-- needed for link back to forum --> ! <forumName>This is test forum 1</forumName> ! <!--needed--> ! <forumCategoryID>1</forumCategoryID> ! <!-- need --> ! <forumCategoryName>General</forumCategoryName> ! <!-- needed --> ! <threadID>1</threadID> ! <!--needed--> ! <numComments>25</numComments> ! <rapComments> ! <rapComment> ! <commentID>1</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body ! testing carriage returns... ! </body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>2</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body2</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>3</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body3</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>4</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body4</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! <rapComment> ! <commentID>5</commentID> ! <parentCommentID>1</parentCommentID> ! <threadID>1</threadID> ! <forumID>1</forumID> ! <userID>00001149</userID> ! <subject>Test Comment Insert</subject> ! <body>Test comment body5</body> ! <modValue>0</modValue> ! <bonusPoints>0</bonusPoints> ! <creationDate>Friday, October 18, 2002 3:15:00 PM PDT</creationDate> ! <modifiedDate>Friday, October 18, 2002 3:15:00 PM PDT</modifiedDate> ! </rapComment> ! </rapComments> </rapForum> </rap> Index: thread.xsl =================================================================== RCS file: /cvsroot/rapforums/src/stylesheets/edu/fullcoll/uportal/channels/rap/forum/thread.xsl,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** thread.xsl 17 Sep 2003 19:54:03 -0000 1.1.1.1 --- thread.xsl 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 12,16 **** <xsl:variable name="mediaPath" select="'media/edu/fullcoll/uportal/channels/rap'"/> - <!-- helper functions --> <xsl:template name="incr"> --- 12,15 ---- *************** *** 57,75 **** </xsl:template> ! ! ! ! ! ! <xsl:template match="/"> ! ! ! <!-- todo remove ! <base href="G:/uportal/FCForums/FCForums/webpages/"/> ! <link rel="stylesheet" href="file://G:/uportal/FCForums/FCForums/webpages/stylesheets/edu/fullcoll/uportal/channels/rap/forum/sun001.css"></link> ! --> <style type="text/css"> ! PRE { font-size : 9pt; } --- 56,64 ---- </xsl:template> ! <xsl:template match="/"> <style type="text/css"> ! .PRE { ! font-family: Courier; font-size : 9pt; } *************** *** 83,90 **** </style> - - - - <!-- show our logo --> <table class="uportal-background-light" cellpadding="1" cellspacing="0" border="0" width="100%"> --- 72,75 ---- *************** *** 156,160 **** <xsl:variable name="pages"> <xsl:value-of select="/rap/rapForum/numComments div 5"/> ! </xsl:variable> <xsl:value-of select="ceiling($pages)"/>  Pages   <b> [  --- 141,145 ---- <xsl:variable name="pages"> <xsl:value-of select="/rap/rapForum/numComments div 5"/> ! </xsl:variable> <xsl:value-of select="ceiling($pages)"/>  Pages   <b> [  *************** *** 209,215 **** <tr> <td> ! <pre> ! <xsl:value-of select="body"/> ! </pre> </td> </tr> --- 194,202 ---- <tr> <td> ! <div class="PRE"> ! <xsl:call-template name="break"> ! <xsl:with-param name="text" select="body"/> ! </xsl:call-template> ! </div> </td> </tr> *************** *** 289,293 **** --- 276,295 ---- </tr> </table> + + </xsl:template> + <xsl:template name="break"> + <xsl:param name="text" select="."/> + <xsl:choose> + <xsl:when test="contains($text, '
')"> + <br/> + <xsl:call-template name="break"> + <xsl:with-param name="text" select="substring-after($text, '
')"/> + </xsl:call-template> + </xsl:when> + <xsl:otherwise> + <xsl:value-of select="$text"/> + </xsl:otherwise> + </xsl:choose> </xsl:template> </xsl:stylesheet> |
From: <br...@us...> - 2003-09-25 22:57:13
|
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source/edu/fullcoll/uportal/channels/rap/forum/commands Modified Files: AboutModeCommand.java AdminModeCommand.java ForumModeCommand.java IForumCommand.java MainModeCommand.java PostModeCommand.java SearchModeCommand.java ThreadModeCommand.java Log Message: no message Index: AboutModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/AboutModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** AboutModeCommand.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- AboutModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 30,35 **** /** - * AboutModeCommand - * * This class provides the display for the about screen. * --- 30,33 ---- *************** *** 37,41 **** * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public class AboutModeCommand implements IForumCommand { --- 35,39 ---- * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision */ public class AboutModeCommand implements IForumCommand { Index: AdminModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/AdminModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** AdminModeCommand.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- AdminModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 46,53 **** /** - * AdminModeCommand * This class provides the administration functionality. * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision 02/05/2003 - Brad Rippe */ public class AdminModeCommand implements IForumCommand { --- 46,54 ---- /** * This class provides the administration functionality. + * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% ! * 02/05/2003 - Brad Rippe */ public class AdminModeCommand implements IForumCommand { Index: ForumModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/ForumModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ForumModeCommand.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- ForumModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 38,47 **** /** - * ForumModeCommand - * * This class provides the forum display for rap forums. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public class ForumModeCommand implements IForumCommand { --- 38,45 ---- /** * This class provides the forum display for rap forums. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class ForumModeCommand implements IForumCommand { Index: IForumCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/IForumCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** IForumCommand.java 17 Sep 2003 19:54:00 -0000 1.1.1.1 --- IForumCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 31,41 **** /** - * IForumModeCommand - * * This is the interface used rendering different displays for RAP Forums. * Different displays are About, Creating Forums, Viewing Forums, Viewing Threads, etc. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision %G% */ public interface IForumCommand { --- 31,39 ---- /** * This is the interface used rendering different displays for RAP Forums. * Different displays are About, Creating Forums, Viewing Forums, Viewing Threads, etc. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface IForumCommand { Index: MainModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/MainModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** MainModeCommand.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- MainModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 38,48 **** /** - * MainModeCommand - * * This class provides the rendering method for the main rap forum page. * This simply renders a display of all the forums available. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...), Tung Lai Thanh (lt...@ya...) ! * @version 0.8 $Revision 5/5/2003 */ public class MainModeCommand implements IForumCommand { --- 38,47 ---- /** * This class provides the rendering method for the main rap forum page. * This simply renders a display of all the forums available. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...), Tung Lai Thanh (lt...@ya...) ! * @version 0.8.2 $Revision %G% ! * 5/5/2003 */ public class MainModeCommand implements IForumCommand { Index: PostModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/PostModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** PostModeCommand.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- PostModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 43,53 **** /** - * PostModeCommand - * * This class provides the post functionality for rap forums. * This is the process that allows users to post messages to rap forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision */ public class PostModeCommand implements IForumCommand { --- 43,51 ---- /** * This class provides the post functionality for rap forums. * This is the process that allows users to post messages to rap forums. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class PostModeCommand implements IForumCommand { Index: SearchModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/SearchModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** SearchModeCommand.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- SearchModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 38,47 **** /** - * SearchModeCommand - * * This class provides the search funcitionality for the forums. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision %G% */ public class SearchModeCommand implements IForumCommand { --- 38,45 ---- /** * This class provides the search funcitionality for the forums. * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% */ public class SearchModeCommand implements IForumCommand { Index: ThreadModeCommand.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/commands/ThreadModeCommand.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ThreadModeCommand.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- ThreadModeCommand.java 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 41,51 **** /** - * ThreadModeCommand - * * This class provides the rendering method for threads in rap forum. * This simply renders a display of threads. * * @author Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision 02/03/2003 */ public class ThreadModeCommand implements IForumCommand { --- 41,50 ---- /** * This class provides the rendering method for threads in rap forum. * This simply renders a display of threads. * * @author Chris Pereda (cp...@fu...) ! * @version 0.8.2 $Revision %G% ! * 02/03/2003 */ public class ThreadModeCommand implements IForumCommand { |
From: <br...@us...> - 2003-09-25 22:57:13
|
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/xml In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source/edu/fullcoll/uportal/channels/rap/forum/xml Modified Files: RAPViewXML.java RAPXML.java Log Message: no message Index: RAPViewXML.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/xml/RAPViewXML.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPViewXML.java 17 Sep 2003 19:54:02 -0000 1.1.1.1 --- RAPViewXML.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 35,45 **** import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBService; - import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBUtil; import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBException; import edu.fullcoll.uportal.channels.rap.forum.database.DatabaseNames; /** - * RAPViewXML - * * This class provides methods for generating xml documents based on * the view that is to be rendered to the user. Methods build jdom documents --- 35,42 ---- *************** *** 50,54 **** * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * @version 0.3 $Revision: * @see org.jdom.Document */ --- 47,51 ---- * * @author Brad Rippe (br...@fu...), Chris Pereda (cp...@fu...) ! * * @version 0.8.2 $Revision %G% * @see org.jdom.Document */ Index: RAPXML.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/xml/RAPXML.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPXML.java 17 Sep 2003 19:54:02 -0000 1.1.1.1 --- RAPXML.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 32,36 **** import org.jdom.contrib.input.ResultSetBuilder; - import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBUtil; import edu.fullcoll.uportal.channels.rap.forum.database.RAPDBException; import edu.fullcoll.uportal.channels.rap.forum.database.DatabaseNames; --- 32,35 ---- *************** *** 39,44 **** /** - * RAPXML - * * This class is used to connect to the channel database and return * results in XML documents. This xml is in a general form and --- 38,41 ---- *************** *** 47,51 **** * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revison: 02/03/2003 */ public class RAPXML extends RAPDBService { --- 44,49 ---- * * @author Brad Rippe (br...@fu...) ! ** @version 0.8.2 $Revision %G% ! * 02/03/2003 */ public class RAPXML extends RAPDBService { *************** *** 453,465 **** } - } - - /** - * TODO THIS -- MIGHT HAVE TO ADD A RAP USER - * Returns the specified user as an xml document. - * @param userID the id of the user to return as xml. - */ - public Document getUserXML(String userID) throws RAPDBException { - return new RAPUserXMLDB().getUserXML(userID); } --- 451,454 ---- |
Update of /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/database In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source/edu/fullcoll/uportal/channels/rap/forum/database Modified Files: DatabaseNames.java RAPDB.java RAPDBException.java RAPDBService.java database.dfPackage Log Message: no message Index: DatabaseNames.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/database/DatabaseNames.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** DatabaseNames.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- DatabaseNames.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 24,39 **** /** - * DatabaseNames - * * This interface provides access to database names used by * RAP Forums. * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision: */ public interface DatabaseNames { public final static String PORTAL_CHANNELS = "uPortalChannels"; public final static String PORTAL = "uPortal"; - public final static String USERS = "Vegas"; } --- 24,36 ---- /** * This interface provides access to database names used by * RAP Forums. * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% */ public interface DatabaseNames { public final static String PORTAL_CHANNELS = "uPortalChannels"; public final static String PORTAL = "uPortal"; } Index: RAPDB.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/database/RAPDB.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPDB.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- RAPDB.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 46,55 **** /** - * RAPDB - * * This class handles general database interaction for Rap forums. * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision: */ public class RAPDB extends RAPDBService { --- 46,53 ---- /** * This class handles general database interaction for Rap forums. * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% */ public class RAPDB extends RAPDBService { Index: RAPDBException.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/database/RAPDBException.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPDBException.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- RAPDBException.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 25,40 **** import edu.fullcoll.uportal.channels.rap.forum.RAPException; /** ! * RAPDBException ! * * This exception is thrown when there is an error with the database. * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision: */ public class RAPDBException extends RAPException { public RAPDBException(String msg) { super(msg); } public RAPDBException(String msg, Exception nested) { super(msg, nested); --- 25,50 ---- import edu.fullcoll.uportal.channels.rap.forum.RAPException; /** ! * This exception is thrown when there is an error with the database. * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% */ public class RAPDBException extends RAPException { + + /** + * Constructs a Database exception with the specified message + * @param msg - the exception's message + */ public RAPDBException(String msg) { super(msg); } + /** + * Constructs a database exception with the exception message + * and a nested exception. + * @param msg - the exception message + * @param nested - the initial exception + */ public RAPDBException(String msg, Exception nested) { super(msg, nested); Index: RAPDBService.java =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/database/RAPDBService.java,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** RAPDBService.java 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- RAPDBService.java 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 30,44 **** /** - * RAPDBService - * * This class provides basic functionality for RAP database classes. ! * RAPDBService uses Pool Man connection pooling. * * @author Brad Rippe (br...@fu...) ! * @version 0.3 $Revision: */ public abstract class RAPDBService { protected Connection dbConnection = null; /** --- 30,50 ---- /** * This class provides basic functionality for RAP database classes. ! * RAPDBService uses jndi lookup to obtain the data sources. * * @author Brad Rippe (br...@fu...) ! * @version 0.8.2 $Revision %G% */ public abstract class RAPDBService { protected Connection dbConnection = null; + private String defaultDSName = DatabaseNames.PORTAL; + + /** + * Constructs a RAPDBService object + */ + public RAPDBService() { + getChannelDSConfig(); + } /** *************** *** 50,54 **** Context envCtx = (Context) initCtx.lookup("java:comp/env/"); ! DataSource ds = (DataSource)envCtx.lookup("jdbc/"+DatabaseNames.PORTAL_CHANNELS); if (ds != null) --- 56,60 ---- Context envCtx = (Context) initCtx.lookup("java:comp/env/"); ! DataSource ds = (DataSource)envCtx.lookup("jdbc/"+defaultDSName); if (ds != null) *************** *** 57,61 **** if(dbConnection == null) { LogService.instance().log(LogService.ERROR, "Database connection error datasource null"); ! throw new RAPDBException("Database connection error: "+DatabaseNames.PORTAL_CHANNELS); } --- 63,67 ---- if(dbConnection == null) { LogService.instance().log(LogService.ERROR, "Database connection error datasource null"); ! throw new RAPDBException("Database connection error: "+defaultDSName); } *************** *** 80,84 **** DataSource ds = (DataSource)envCtx.lookup("jdbc/"+dbName); - //DataSource ds = PoolMan.findDataSource(dbName); if (ds != null) --- 86,89 ---- *************** *** 99,102 **** --- 104,111 ---- } + /** + * This method releases a Connection object's database and JDBC resources immediately. + * @throws RAPDBException - if a database error occurs + */ protected void closeConnection() throws RAPDBException { try { *************** *** 114,117 **** --- 123,130 ---- } + /** + * Releases the specified ResultSet object's database and JDBC resources. + * @throws RAPDBException - if a database error occurs + */ protected void closeResultSet(ResultSet result) throws RAPDBException { try { *************** *** 127,130 **** --- 140,147 ---- } + /** + * Releases the specified Statement object's database and JDBC resources. + * @throws RAPDBException - if a database error occurs + */ protected void closeStatement(Statement stmt) throws RAPDBException { try { *************** *** 137,140 **** --- 154,172 ---- throw new RAPDBException("SQL Exception while closing " + "Statement : \n" + se); + } + } + + /** + * This method determines if the forums have been configured two use multiple + * databases. One scenario is to have one database for the portal data and one + * for the portal channels. If set to true, the forums expect to a data source + * called "uPortalChannels", otherwise the forums use a data source called "uPortal". + * @param separateDB - true if the forums are configured to use two databases, otherwise false + */ + private void getChannelDSConfig() { + if(RAPDBConfig.getInstance().isMultiDS()) { + defaultDSName = DatabaseNames.PORTAL_CHANNELS; + } else { + defaultDSName = DatabaseNames.PORTAL; } } Index: database.dfPackage =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/fullcoll/uportal/channels/rap/forum/database/database.dfPackage,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** database.dfPackage 17 Sep 2003 19:54:01 -0000 1.1.1.1 --- database.dfPackage 25 Sep 2003 22:57:08 -0000 1.2 *************** *** 7,11 **** */ class diagram { ! }/** @__tags @shapeType ClassDiagram --- 7,16 ---- */ class diagram { ! /** ! @__ref <oiref:java#Class#edu.fullcoll.uportal.channels.rap.forum.database.RAPDBConfig:oiref><oihard> ! @__modelType reference ! */ ! class reference { ! }}/** @__tags @shapeType ClassDiagram |
From: <br...@us...> - 2003-09-25 22:57:11
|
Update of /cvsroot/rapforums/src/source In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source Modified Files: default.dfPackage Log Message: no message Index: default.dfPackage =================================================================== RCS file: /cvsroot/rapforums/src/source/default.dfPackage,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** default.dfPackage 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- default.dfPackage 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 7,11 **** */ class diagram { ! }/** @__tags @shapeType ClassDiagram --- 7,17 ---- */ class diagram { ! /** ! @__ref <oiref:design#Class#idpffbdkn0hcbodkn3e2or.diagram:oiref><oihard> ! @__modelType reference ! @__fqn <oiref:#Package#edu:oiref> ! */ ! class reference { ! }}/** @__tags @shapeType ClassDiagram *************** *** 17,21 **** class __options { }/** ! @__positions */ class __positions { --- 23,27 ---- class __options { }/** ! @__positions <oigroup:<oiref:design#Class#idpffbdkn0hcbodkn3e2or.diagram:oiref>=10,10,53,78,1:oigroup> */ class __positions { |
From: <br...@us...> - 2003-09-25 22:57:11
|
Update of /cvsroot/rapforums/src/source/edu In directory sc8-pr-cvs1:/tmp/cvs-serv17361/source/edu Modified Files: edu.dfPackage Log Message: no message Index: edu.dfPackage =================================================================== RCS file: /cvsroot/rapforums/src/source/edu/edu.dfPackage,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** edu.dfPackage 17 Sep 2003 19:53:59 -0000 1.1.1.1 --- edu.dfPackage 25 Sep 2003 22:57:07 -0000 1.2 *************** *** 7,11 **** */ class diagram { ! }/** @__tags @shapeType ClassDiagram --- 7,17 ---- */ class diagram { ! /** ! @__ref <oiref:design#Class#id2gg0vdkn0hcbodkn3e2qh.diagram:oiref><oihard> ! @__modelType reference ! @__fqn <oiref:#Package#edu.fullcoll:oiref> ! */ ! class reference { ! }}/** @__tags @shapeType ClassDiagram |