import com.ecyrd.jspwiki.*;
import com.ecyrd.jspwiki.plugin.*;
import java.util.*;
import java.sql.*;

public class Forum implements WikiPlugin 
{
    public String execute (WikiContext Context, Map ParameterMap) throws PluginException {
        WikiEngine engine = Context.getEngine();       
        String return_html = "";
        String title;
        String page = Context.getPage().getName();

        if (ParameterMap != null || ParameterMap.size() > 0) {
            Iterator parmIter = ParameterMap.keySet().iterator();
            
            if( ((String)parmIter.next()).equalsIgnoreCase("title")){
                title = handleApostrophe((String)ParameterMap.get("title"));
            }else{
                return errorMsg();
            };
        }else{
            return errorMsg();
        };
        
        return_html += getHTML(Context, engine, title);
        
        return return_html;
    };
   
    private String getHTML(WikiContext Context, WikiEngine engine, String title){
        String html = "";
        Connection conn = null;
        
        try{
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/forum", "root", "");
            
            html += "<div>\n";
            html += "<style>\n";
            html += "<!--\n";
            html += ".topic_table        { background-color: #c2cfdf; }\n";
            html += ".topic_header       { background-color: #c2cfdf; font-size: 10pt; font-family: verdana, helvetica, sans-serif; }\n";
            html += ".topic_center_light { background-color: #e4eaf2; font-size: 10pt; font-family: verdana, helvetica, sans-serif; }\n";
            html += ".topic_center_dark  { background-color: #dfe6ef; font-size: 10pt; font-family: verdana, helvetica, sans-serif; }\n";
            html += ".textinput          { font-size: 10pt; font-family: verdana, helvetica, sans-serif;vertical-align:middle }\n";
            html += ".add_topic          { border-style: solid; border-color: #c2cfdf; background-color: #e4eaf2; border-width: 1pt; margin-bottom: 3pt; cursor: hand; };\n";
            html += "-->\n";
            html += "</style>\n";
            html += "<table cellSpacing=\"0\" cellPadding=\"0\" width=\"95%\" align=\"left\" class=\"topic_table\" border=\"0\">\n";
            html += "  <tr>\n";
            html += "    <td width=\"10\" BGCOLOR=\"#ffffff\">&nbsp;</td>\n";
            html += "    <td>\n";
            html += "      <table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">\n";
            html += "        <tr>\n";
            html += "          <td BGCOLOR=\"#ffffff\" width=\"100%\" align=\"center\">" + title + "</td>\n";
            html += "          <td BGCOLOR=\"#ffffff\" align=\"right\"><input type=\"button\" value=\"Add New Topic\" class=\"add_topic\"\n"; 
            html += "    OnClick='window.open(\"templates/"+Context.getTemplate()+"/addTopic.jsp?forum_title="+title+"&"+engine.getUserManager().getUserProfile(Context.getHttpRequest()).getStringRepresentation()+"\",\"\",\"width=300,height=150,\");'></td>\n";
            html += "        </tr>\n";
            html += "      </table>\n";
            html += "    </td>\n";    
            html += "  </tr>\n";
            html += "  <tr>\n";
            html += "    <td width=\"10\" BGCOLOR=\"#ffffff\">\n";
            html += "      <div></div>\n";
            html += "    </td>\n";
            html += "    <td>\n";
            html += "    <table cellSpacing=\"1\" cellPadding=\"2\" width=\"100%\" border=\"0\">\n";
            html += "      <tr>\n";
            html += "        <td class=\"topic_header\">\n";
            html += "          <div></div>\n";
            html += "        </td>\n";
            html += "        <td vAlign=\"center\" align=\"left\" width=\"45%\" class=\"topic_header\">Topic Title</td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" width=\"14%\" class=\"topic_header\">Topic Starter</td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" width=\"5%\" class=\"topic_header\"><center><p>Replies</p></center></td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" width=\"5%\" class=\"topic_header\"><center><p>Views</p></center></td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" width=\"25%\" class=\"topic_header\">Last Action</td>\n";
            html += "      </tr>\n";

            Statement stmt_topic = conn.createStatement();
            ResultSet rs_topic = stmt_topic.executeQuery("SELECT topic.index, topic.title, topic.starter FROM topic WHERE topic.forum_title = '" + title + "'");
     
        while(rs_topic.next()){
            String topic_index = rs_topic.getString("topic.index");
            String topic_title = rs_topic.getString("topic.title");
            String topic_starter = rs_topic.getString("topic.starter");
            
            Statement stmt_post = conn.createStatement();
            ResultSet rs_post = stmt_post.executeQuery("SELECT COUNT(*), DATE_FORMAT(MAX(timestamp), '%m/%d/%y') AS timestamp FROM post WHERE post.topic_index = " + topic_index);
            rs_post.next();
            String replies = rs_post.getString("COUNT(*)");
            String last_action = rs_post.getString("timestamp");
            
            if(last_action == null) last_action = "";
            
            html += "      <tr>\n";
            html += "        <td align=\"middle\" width=\"4%\" class=\"topic_center_light\" border=\"0\"><img alt src=\"images/f_norm.gif\" border=\"0\" width=\"17\" height=\"10\"></td>\n";
            html += "        <td onmouseover=\"style.cursor='hand';style.backgroundColor='#EEEEEE'; window.status='Click to enter topic';return true\" onclick=\"location.href='" + engine.getBaseURL() + "Forum.jsp?topic_index=" + topic_index + "'\" onmouseout=\"style.cursor='';style.backgroundColor=''; window.status='';return true\" width=\"40%\" class=\"topic_center_light\">\n";
            html += "        <span id=\"linkthru\">\n";
            html += "        <a href=\"" + engine.getBaseURL() + "Forum.jsp?topic_index=" + topic_index + "\">\n";
            html += "        " + topic_title + "\n";
            html += "        </a></span></td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" class=\"topic_center_light\">\n";
            html += "        <a href=\"" + engine.getViewURL(topic_starter.replaceAll(" ", "")) + "\">\n";
            html += "        " + topic_starter + "\n";
            html += "        </a></td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" class=\"topic_center_dark\">\n";
            html += "        " + replies + "\n";
            html += "        </td>\n";
            html += "        <td vAlign=\"center\" align=\"middle\" class=\"topic_center_dark\"><div></div></td>\n";
            html += "        <td vAlign=\"center\" align=\"left\" class=\"topic_center_dark\"><span id=\"highlight\">\n";
            html += "        &nbsp;&nbsp;<img alt src=\"images/lpost_off.gif\" align=\"middle\" border=\"0\" width=\"14\" height=\"14\">\n";
            html += "        Last Post: " + last_action + "</span>\n";
            html += "        </td>\n";
            html += "      </tr>\n";
        };
        html += "    </table>\n";
        html += "    </td>\n";
        html += "  </tr>\n";
        html += "</table>\n";
        html += "</div>\n";
        }catch (Exception e){
            html += "Error: " + e;
            return html;
        };
        
        return html;
    };
    
    private String errorMsg(){
        return "<p>Useage: [{Discuss title=&lt;your_title&gt;}]</p>";
    };
    
    private String handleApostrophe(String commentString) {
        for(int i_marker = 0; i_marker < commentString.length(); i_marker++){
            if(commentString.substring(i_marker, i_marker + 1).equals("'")){
                commentString = commentString.substring(0, i_marker) + "''" + commentString.substring(i_marker + 1, commentString.length());
                i_marker++;
            }
        }
    
        if(commentString.length() > 255){
            commentString = commentString.substring(0,255);
        }

        return commentString;
    };  
};