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
