<%@ include file="header.jsp"%>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, user, pass);
statement = connection.createStatement();
statement2 = connection.createStatement();
statement3 = connection.createStatement();
java.util.Date today = new java.util.Date();
String currenttime = String.valueOf(today.getTime());
String action ="";
String lid = "";
double star_number=0;
int star_number_member=0;
DateFormat df = null;
Date datetime = null;
String announcetxt="";
rs = statement.executeQuery("SELECT * FROM announcement WHERE anid=1");
if (rs.next())
{
announcetxt = rs.getString("message");
}
%>
| Announcement |
|
<%
if (announcetxt.length() != 0)
{
out.println(announcetxt);
}
else
{
out.println("No Announcement Yet.");
}
%>
|
|
<%
//Check star
// rs4=statement4.executeQuery("SELECT * FROM loginuser");
// while (rs4.next())
// {
// //out.println(rs4.getString("lid")+"=");
// rs5=statement5.executeQuery("SELECT COUNT(lid) FROM posts WHERE lid="+rs4.getString("lid"));
// rs5.next();
// star_number+=Integer.parseInt(rs5.getString("COUNT(lid)"));
// statement6.executeUpdate("UPDATE loginuser SET stars="+rs5.getString("COUNT(lid)")+" WHERE lid="+rs4.getString("lid") );
// //out.println("UPDATE loginuser SET stars="+rs5.getString("COUNT(lid)")+" WHERE lid="+rs4.getString("lid"));
// //star_number_member++;
//
// }
//===========================
// page no
//===========================
int num=0;
int eu=0,limit=0,current=0,back=0,next=0;
int start=0;
int l,i;
rs = statement.executeQuery("SELECT count(*) FROM topic t WHERE topTopic=0");
if (rs.next() == true)
{
num = rs.getInt("count(*)");
}
if (request.getParameter("start") != null)
{
start = Integer.parseInt(request.getParameter("start"));
}
eu = (start - 0);
limit = 10; // No of records to be shown per page.
current = eu + limit;
back = eu - limit;
next = eu + limit;
if (next > num)
{
next = num;
}
%>
<%@ include file="member.jsp"%>
<%
if (request.getParameter("action") != null)
{
action = request.getParameter("action");
rs = statement.executeQuery("SELECT lid,l_email FROM loginuser WHERE l_username='" + currentUser + "'");
if (rs.next())
{
String lemail = rs.getString("l_email");
lid = rs.getString("lid");
if (action.equals("New Post"))
{
//System.out.println(currenttime);
String subject = request.getParameter("subject");
String message = request.getParameter("message");
df = new SimpleDateFormat("yyyy-MM-dd HH:mm");
String lastposter = df.format(today) + " by " + currentUser;
String insertSQL = "INSERT INTO topic(topic, lid, date, lastposter) VALUES('" + subject + "','" + lid + "','" + currenttime + "','" + lastposter +"')";
statement.execute(insertSQL);
String topicid = "";
rs2 = statement.executeQuery("SELECT t.tid FROM topic t WHERE t.lid ='" + lid + "' AND t.date='" + currenttime + "' ORDER BY t.tid DESC");
if (rs2.next())
{
topicid = rs2.getString("t.tid");
}
insertSQL = "INSERT INTO posts VALUES(null,'" + subject + "','" + message + "','" + topicid + "','" + lid + "','" + currenttime + "')";
statement.execute(insertSQL);
//add stars
statement.executeUpdate("UPDATE loginuser SET stars=stars+1 WHERE lid="+ lid);
statement.executeUpdate("UPDATE topic SET replies=replies+1 WHERE tid="+ topicid);
String mailposter = currentUser;
String mailposteremail = lemail;
String maildate = df.format(today);
String mailstatus = "New topic by ";
String mailtopic = subject;
String mailmsg = message;
%>
<%@ include file="sendmail.jsp"%>
<%
response.sendRedirect("post.jsp?topic=" + topicid );
}
else if (action.equals("delete"))
{
out.println("Deleted!");
String forumid = request.getParameter("forum");
String templid="";
int decreasestar=0;
rs = statement.executeQuery("SELECT DISTINCT lid FROM posts WHERE tid=" + forumid);
//out.println("row"+rs.getRow() +"
");
while (rs.next())
{
//out.println("userid:"+rs.getString("lid"));
templid=rs.getString("lid");
rs2 = statement2.executeQuery("SELECT count(*) FROM posts WHERE tid='"+ forumid +"' AND lid='" + templid + "'");
if (rs2.next())
{
decreasestar = rs2.getInt("count(*)");
//out.println("
no of star:"+rs2.getString("count(*)"));
}
statement3.executeUpdate("UPDATE loginuser SET stars=stars-"+decreasestar+" WHERE lid='"+ templid +"'");
}
String deleteSQL = "DELETE FROM posts WHERE tid=" + forumid;
statement.execute(deleteSQL);
deleteSQL = "DELETE FROM topic WHERE tid=" + forumid;
statement.execute(deleteSQL);
response.sendRedirect("forum.jsp");
}//action
else
{
response.sendRedirect("error_page.jsp");
}
}
else
{
response.sendRedirect("error_loginfirst.jsp");
}//lid true
}//action not null
String noposts = "";
%>
<%@ include file="adminfunc.jsp"%>
|
| |
Topic |
Replies |
Views |
Author |
Last poster |
|
<%
if (start <= 0)
{
//important forum topic
rs = statement.executeQuery("SELECT l.*,t.*,u.* FROM loginuser l, topic t, usergroup u WHERE t.lid=l.lid AND u.aid=l.admin AND t.topTopic=1 ORDER BY t.tid");
while (rs.next()) {
String topicid = rs.getString("t.tid");
out.println("![](\"images/pin.gif\") | ");
out.println(""+rs.getString("t.topic")+" | ");
out.println(""+rs.getString("t.replies")+" | ");
out.println(""+rs.getString("t.views")+" | ");
out.println(""+rs.getString("l.l_username"));
df = new SimpleDateFormat("yyyy-MM-dd");
datetime = new Date(Long.parseLong(rs.getString("t.date")));
out.println("
"+df.format(datetime));
out.println("
| ");
String tempmsg=rs.getString("t.lastposter");
tempmsg=tempmsg.replaceAll("by","
by");
out.println(""+ tempmsg +" | ");
rs3=statement3.executeQuery("SELECT * FROM loginuser l, usergroup u WHERE u.aid=l.admin AND l.l_username='"+currentUser+"'");
if (rs3.next())
{
if(rs3.getString("u.aid").equals("1"))
{
out.println("![](\"images/pindown.gif\") ");
out.println("![](\"images/edit.gif\") ");
out.println("![](\"images/delete.gif\") | "); }
else
{
out.println(" | ");
}
}
else
{
out.println(" | ");
}
}
//out.println(" | ");
out.println("|
");
}
%>
<%
//normal forum topic
rs = statement.executeQuery("SELECT l.*,t.*,u.* FROM loginuser l, topic t, usergroup u WHERE t.lid=l.lid AND u.aid=l.admin AND t.topTopic=0 ORDER BY lastposter DESC LIMIT " + start + "," + next);
while (rs.next()) {
out.println("");
String topicid = rs.getString("t.tid");
long dateCreated = Long.parseLong(rs.getString("t.date"));
long diff = System.currentTimeMillis() - dateCreated;
if (diff <= 2 * 1000 * 60 *60 *24)
{
out.println("![](\"images/new.gif\") | ");
}
else
{
out.println("![](\"images/normal.gif\") | ");
}
out.println(""+rs.getString("t.topic")+" | ");
out.println(""+rs.getString("t.replies")+" | ");
out.println(""+rs.getString("t.views")+" | ");
out.println(""+rs.getString("l.l_username"));
//author and time created the post
df = new SimpleDateFormat("yyyy-MM-dd");
datetime = new Date(Long.parseLong(rs.getString("t.date")));
out.println("
"+df.format(datetime));
out.println("
| ");
String tempmsg=rs.getString("t.lastposter");
tempmsg=tempmsg.replaceAll("by","
by");
out.println(""+ tempmsg +" | ");
rs3=statement3.executeQuery("SELECT * FROM loginuser l, usergroup u WHERE u.aid=l.admin AND l.l_username='"+currentUser+"'");
if (rs3.next())
{
if(rs3.getString("u.aid").equals("1"))
{
out.println("![](\"images/pinup.gif\") ");
out.println("");
out.println(" | ");
}
else
{
out.println(" | ");
}
}
else
{
out.println(" | ");
}
}
connection.close();
statement = null;
statement2 = null;
statement3 = null;
rs = null;
rs2 = null;
rs3 = null;
%>
|
|
|
<% if (currentUser.length() != 0)
{
%>
<% }//user haven't login
}
catch (SQLException ex)
{
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
%>
|
|
<%@ include file="footer.jsp"%> |
|
New Topic
Pin Topic
Normal Topic