<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="net.lybbs.util.*"%>
<%@ page import="net.lybbs.session.util.*"%>
<%@ page import="net.lybbs.db.*"%>
<%@ page import="net.lybbs.post.bean.*"%>
<%@ page import="net.lybbs.post.proxy.*"%>
<%@ page import="net.lybbs.post.dao.jdbc.*"%>
<%@ page import="net.lybbs.post.dao.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%
int step=ParameterUtils.getInt(request,"step");
int offset=ParameterUtils.getInt(request,"offset");
int limit=ParameterUtils.getInt(request,"limit");
int to=offset+limit;


out.println("<br>");
out.println("Next upgrade from 6.3 to 6.4, if connection failed, please check test.jsp first:<br>");
DBConnect dbConnect=null;
PreparedStatement prestmt1=null;
PreparedStatement prestmt2=null;
ResultSet rs=null;
try {
  dbConnect=DBConnectManager.getInstance().getDBConnect();
  dbConnect.createConnection();
  if(step==1) {
    int parentID=0;
    prestmt1=dbConnect.createPreparedStatement("update lybbs_posts set replynum=?,votenum=?,lastauthorid=?,lastauthor=?,lastpostat=?,lastpostclue=? where id=?");
    
    prestmt2=dbConnect.createPreparedStatement("select id from lybbs_posts where parentid=0 and lastauthorid=0 and id>"+offset+" and id<="+to);
    rs=dbConnect.executeQuery(prestmt2);
    ILastTopic lastTopic;
    ITopicDAO topicDAO=TopicDAO.getInstance();
    while(rs.next()) {
      parentID=rs.getInt(1);
      lastTopic=topicDAO.getLastReply(dbConnect,parentID);
      prestmt1.setInt(1,lastTopic.getReplyNumber());
      prestmt1.setInt(2,lastTopic.getVoteNumber());
      prestmt1.setInt(3,lastTopic.getLastPostAuthorID());
      prestmt1.setString(4,lastTopic.getLastPostAuthor());
      prestmt1.setLong(5,lastTopic.getLastPostAtByLong());
      prestmt1.setString(6,lastTopic.getLastPostClue());
      prestmt1.setInt(7,parentID);
      dbConnect.executeUpdate(prestmt1);
    }
    out.println("<br>postID:"+parentID);
  }
  else if(step==2) {
  	int uploadID=0;
  	int postID=0;
    prestmt1=dbConnect.createPreparedStatement("update lybbs_posts set accessaryname=? where id=?");
    prestmt2=dbConnect.createPreparedStatement("select id,postsid,filepath from lybbs_uploadinfo where id>"+offset+" and id<="+to+" group by postsid");
    rs=dbConnect.executeQuery(prestmt2);
    while(rs.next()) {
      uploadID=rs.getInt(1);
      postID=rs.getInt(2);
      prestmt1.setString(1,rs.getString(3));
      prestmt1.setInt(2,postID);
      dbConnect.executeUpdate(prestmt1);
    }
    out.println("<br>uploadID:"+uploadID);
  }
  out.println("<br><b>Upgrade success!</b>");
}
catch(Exception ex) {
  out.println("&nbsp;&nbsp;&nbsp;&nbsp;Upgrade error:"+ex.toString());
}
finally {
  if(dbConnect!=null) {
    dbConnect.closeResultSet(rs);
    dbConnect.closePreStmt(prestmt1);
    dbConnect.closePreStmt(prestmt2);
    dbConnect.close();
  }
}
%>
<br><br>
<form action="lybbs_upgrade_6.3to6.4.jsp" name="myform" method="post">
step:<select name=step>
	    <option value="1" <%if(step==1)out.print("selected");%>>step1</option>
	    <option value="2" <%if(step==2)out.print("selected");%>>step2</option>
	   </select>
Offset:<input type=text name="offset" value="<%=to%>" size=10>&nbsp;
Limit:<input type=text name="limit" value="<%=(limit==0)?500:limit%>" size=10>&nbsp;&nbsp;
<input type=button name=mysubmit value="Submit" onclick="disabledButton()">
</form>
<script language="JavaScript">
  function disabledButton() {
    document.myform.mysubmit.disabled=true;
    document.myform.submit();
  }
</script>