User: user57 Date: 01/12/10 17:01:10 Modified: src/web/forums footer.jsp header.jsp Added: src/web/forums fix.jsp Log: o adding production jive 2.1.2 jar o added sf.net logo to footer o including fix.jsp until the jive folks fix the date problem Revision Changes Path 1.8 +12 -6 website-forums/src/web/forums/footer.jsp Index: footer.jsp =================================================================== RCS file: /cvsroot/jboss/website-forums/src/web/forums/footer.jsp,v retrieving revision 1.7 retrieving revision 1.8 diff -u -r1.7 -r1.8 --- footer.jsp 2001/12/04 03:31:01 1.7 +++ footer.jsp 2001/12/11 01:01:10 1.8 @@ -1,24 +1,30 @@ +<!-- FOOTER --> <table cellspacing="0" cellpadding="0" border="0" width="100%"> <tr> - <td bgcolor="#ffffff" align=center> - <jsp:include page="picabanner.jsp" flush="true" /> + <td> + + </td> + <td bgcolor="#ffffff" align="center"> + <jsp:include page="picabanner.jsp"/> + </td> + <td> + <a href="http://sourceforge.net"> + <img src="http://sourceforge.net/sflogo.php?group_id=22866&type=1" width="88" height="31" border="0" alt="SourceForge Logo"></a> + </td> </tr> </table> <table cellpadding="6" cellspacing="0" border="0" width="100%"> <tr> <td align="center"> - <hr size="1" width="75%" color="#666666"> + <hr size="1" width="100%" color="#666666"> <font size="-2" face="<%= JiveGlobals.getJiveProperty("skin.default.buttonFontFace") %>" color="#666666"> <a href="<%= JiveGlobals.getJiveProperty("skin.default.homeURL") %>">Forum Home</a> | <a href="account.jsp">Register</a> | <a href="login.jsp">Log-In</a> - | - <%-- - <a href="faq.jsp">FAQ/Help</a> | --%> <a href="search.jsp">Search</a> 1.14 +0 -8 website-forums/src/web/forums/header.jsp Index: header.jsp =================================================================== RCS file: /cvsroot/jboss/website-forums/src/web/forums/header.jsp,v retrieving revision 1.13 retrieving revision 1.14 diff -u -r1.13 -r1.14 --- header.jsp 2001/12/04 20:52:24 1.13 +++ header.jsp 2001/12/11 01:01:10 1.14 @@ -1,11 +1,3 @@ -<% -/** - * $RCSfile: header.jsp,v $ - * $Revision: 1.13 $ - * $Date: 2001/12/04 20:52:24 $ - */ -%> - <%@ page import="com.jivesoftware.forum.*" %> <% // This page is the header page included on all the pages. It defines 1.1 website-forums/src/web/forums/fix.jsp Index: fix.jsp =================================================================== <%@ page import="java.util.*, java.sql.*, com.jivesoftware.forum.database.*" %> <% String SELECT_CREATION_QUERY="SELECT jm.messageId, jm2.creationDate FROM jiveMessage jm, jiveMessage jm2 WHERE jm.creationDate <= jm2.creationDate AND jm2.messageID=jm.parentmessageID"; String UPDATE_CREATION_QUERY="UPDATE jiveMessage SET creationDate=? WHERE messageID=?"; String SELECT_MODIFIED_QUERY="SELECT messageId, modifiedDate FROM jiveMessage WHERE modifiedDate < creationDate"; String UPDATE_MODIFIED_QUERY="UPDATE jiveMessage SET modifiedDate=? WHERE messageID=?"; Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; Hashtable list = new Hashtable(); boolean abortTransaction = false; try { con = ConnectionManager.getTransactionConnection(); try { pstmt = con.prepareStatement(SELECT_CREATION_QUERY); rs = pstmt.executeQuery(); while (rs.next()) { list.put(new Long(rs.getLong(1)), new Long(rs.getLong(2))); out.println("Found bad date, c=" + rs.getLong(1) + ",p=" + rs.getLong(2)); } rs.close(); pstmt.close(); for (Enumeration keys = list.keys(); keys.hasMoreElements();) { Long key = (Long) keys.nextElement(); Long val = (Long) list.get(key); pstmt = con.prepareStatement(UPDATE_CREATION_QUERY); pstmt.setLong(1, val.longValue() + 1); pstmt.setLong(2, key.longValue()); pstmt.executeUpdate(); pstmt.close(); } // modified pstmt.close(); pstmt = con.prepareStatement(SELECT_MODIFIED_QUERY); rs = pstmt.executeQuery(); while (rs.next()) { list.put(new Long(rs.getLong(1)), new Long(rs.getLong(2))); } rs.close(); pstmt.close(); for (Enumeration keys = list.keys(); keys.hasMoreElements();) { Long key = (Long) keys.nextElement(); Long val = (Long) list.get(key); pstmt = con.prepareStatement(UPDATE_MODIFIED_QUERY); pstmt.setLong(1, val.longValue() + 1); pstmt.setLong(2, key.longValue()); pstmt.executeUpdate(); pstmt.close(); } } finally { try { rs.close(); pstmt.close(); } catch (Exception e) { e.printStackTrace(); } } } catch(Exception e) { e.printStackTrace(); abortTransaction = true; } finally { ConnectionManager.closeTransactionConnection(con, abortTransaction); } %> Done.
_______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development