<%@ page language="java" import="java.sql.*,java.lang.*,java.util.Date,java.util.TimeZone,java.text.SimpleDateFormat" session="true" %> EDUAGE - EDUCATION MADE EASY 

Home Home 
Suggestions Suggestions 
Sitemap Sitemap 
Contact Us Contact Us 










 



<%!public String ecode(String dt) {
int len=dt.length();
String org="";
String org1="";
String org2="";
String org3="";

String alpha[]=new String[66];

alpha[0]="a";alpha[1]="b";alpha[2]="c";alpha[3]="d";alpha[4]="e";alpha[5]="f";
alpha[6]="g";alpha[7]="h";alpha[8]="i";alpha[9]="j";alpha[10]="k";alpha[11]="l";
alpha[12]="m";alpha[13]="n";alpha[14]="o";alpha[15]="p";alpha[16]="q";alpha[17]="r";
alpha[18]="s";alpha[19]="t";alpha[20]="u";alpha[21]="v";alpha[22]="w";alpha[23]="x";
alpha[24]="y";alpha[25]="z";alpha[26]="A";alpha[27]="B";alpha[28]="C";alpha[29]="D";
alpha[30]="E";alpha[31]="F";alpha[32]="G";alpha[33]="H";alpha[34]="I";alpha[35]="J";
alpha[36]="K";alpha[37]="L";alpha[38]="M";alpha[39]="N";alpha[40]="O";alpha[41]="P";
alpha[42]="Q";alpha[43]="R";alpha[44]="S";alpha[45]="T";alpha[46]="U";alpha[47]="V";
alpha[48]="W";alpha[49]="X";alpha[50]="Y";alpha[51]="Z";alpha[52]=" ";alpha[53]=".";
alpha[54]="-";alpha[55]="0";alpha[56]="1";alpha[57]="2";alpha[58]="3";alpha[59]="4";
alpha[60]="5";alpha[61]="6";alpha[62]="7";alpha[63]="8";alpha[64]="9";alpha[65]="_";

for(int g=0; g

<%!Connection con;
Statement st,st1,st2,st3,st4,stmt,stmt1;
ResultSet rs,rst,rss,rsg,rsx,res,res1;
String forum_type="";
String uid="";
int total_post;
int post;
int ftcount=0;
int ftc;
%>

<%
	HttpSession rsm=request.getSession(true);
	session.setMaxInactiveInterval(900);

	try {

	String dns = "jdbc:mysql://eduage.db.6936442.hostedresource.com/eduage?user=eduage&password=macs@123SAN";
	Class.forName("org.gjt.mm.mysql.Driver");
	con= DriverManager.getConnection(dns);

	st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

	st1=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

	st2=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

	st3=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

	st4=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

	int visitors=100;

	Date dt=new java.util.Date();
        SimpleDateFormat sdf=new SimpleDateFormat("hh:mm a");
        String zone="IST";
        TimeZone tz=TimeZone.getTimeZone(zone);
        sdf.setTimeZone(tz);
        String time1=sdf.format(dt);

	String uid1=(String)rsm.getValue("userid");
	String conid=(String)rsm.getValue("connectid");

	if (uid1!=null) {
	rsm.putValue("userid",uid);
	rsm.putValue("connectid",conid);
	stmt=con.createStatement();

	stmt1=con.createStatement();

	res=stmt.executeQuery("Select flag from edu_UserSession where User_id='"+uid1+"'");
	if (res.next()==true) {
	String flagr=res.getString("flag");
	if (flagr.equals("Yes")) {
	res1=stmt.executeQuery("Select fname,lname from edu_User2 where email='"+uid1+"'");
	res1.next();
%>













EDUAGE Forum is a value added platform to share opinions, views and queries.
      








Welcome <%=res1.getString("fname") %> <%=res1.getString("lname") %>,









<%
	rs=st.executeQuery("Select Forum_name,Status,Comments from edu_Forum where Status='Active'");
%>



<%
	while(rs.next()==true) {
	forum_type=rs.getString("Forum_name");
	ftcount++;
	
	rst=st1.executeQuery("Select Forum,Thread_date,Thread_time,User_id from edu_Thread where Forum='"+forum_type+"'");
	rst.last();

	uid=rst.getString("User_id");

	rss=st2.executeQuery("Select fname,lname from edu_User2 where email='"+uid+"'");
	rss.next();
%>

<%
	total_post+=rst.getRow();
	}
%>



Forum
Total Posts
Last Post






<%=forum_type %>









Introduction
<%=rs.getString("Comments") %>
<%=rst.getRow() %>
<%=rst.getString("Thread_date") %> at <%=rst.getString("Thread_time") %>
By <%=rss.getString("fname") %> <%=rss.getString("lname") %>



<%
	rsg=st3.executeQuery("Select * from edu_Password");
	rsg.last();
	rs.last();

	rsx=st4.executeQuery("Select Reply_id from edu_Reply");
	rsx.last();
%>





Forum Statistics


The date and time now is <%=(dt.getDate()+1) %>/<%=(dt.getMonth()+1) %>/<%=(dt.getYear()+1900) %> <%=time1 %>
Online Members: <%=rsg.getRow() %>, Online Visitors: <%=visitors %>
Members: <%=(rsg.getRow()+visitors) %>, Forum: <%=rs.getRow() %>, Total Post: <%=total_post %>, Total Reply: <%=rsx.getRow() %>





<%
	}
	else {
%>











Welcome Visitor











You currently have browse capabilities. To participate in the discussions and post your own comments, please log in.
Get a free EDUAGE Forum Account.





	
Existing Users!

	

	
User Id
Password
















<%
	rs=st.executeQuery("Select Forum_name,Status,Comments from edu_Forum where Status='Active'");
%>



<%
	while(rs.next()==true) {
	forum_type=rs.getString("Forum_name");
	ftcount++;
	
	rst=st1.executeQuery("Select Forum,Thread_date,Thread_time,User_id from edu_Thread where Forum='"+forum_type+"'");
	if (rst.next()==true) {
	rst.last();

	uid=rst.getString("User_id");

	rss=st2.executeQuery("Select fname,lname from edu_User2 where email='"+uid+"'");
	rss.next();
%>

<%
	total_post+=rst.getRow();
	}
	else {
%>

<%
	}
	}

%>



Forum
Total Posts
Last Post






<%=forum_type %>









Introduction
<%=rs.getString("Comments") %>
<%=rst.getRow() %>
<%=rst.getString("Thread_date") %> at <%=rst.getString("Thread_time") %>
By <%=rss.getString("fname") %> <%=rss.getString("lname") %>
<%=forum_type %> 


Introduction
<%=rs.getString("Comments") %>
0
-



<%
	rsg=st3.executeQuery("Select * from edu_Password");
	rsg.last();
	rs.last();

	rsx=st4.executeQuery("Select Reply_id from edu_Reply");
	rsx.last();
%>





Forum Statistics


The date and time now is <%=(dt.getDate()+1) %>/<%=(dt.getMonth()+1) %>/<%=(dt.getYear()+1900) %> <%=time1 %>
Online Members: <%=rsg.getRow() %>, Online Visitors: <%=visitors %>
Members: <%=(rsg.getRow()+visitors) %>, Forum: <%=rs.getRow() %>, Total Post: <%=total_post %>, Total Reply: <%=rsx.getRow() %>





<%
	}
	}
	}
	else {
%>











Welcome Visitor











You currently have browse capabilities. To participate in the discussions and post your own comments, please log in.
Get a free EDUAGE Forum Account.





	
Existing Users!

	

	
User Id
Password
















<%
	rs=st.executeQuery("Select Forum_name,Status,Comments from edu_Forum where Status='Active'");
%>



<%
	while(rs.next()==true) {
	forum_type=rs.getString("Forum_name");
	ftcount++;
	
	rst=st1.executeQuery("Select Forum,Thread_date,Thread_time,User_id from edu_Thread where Forum='"+forum_type+"'");
	if (rst.next()==true) {

	rst.last();

	uid=rst.getString("User_id");

	rss=st2.executeQuery("Select fname,lname from edu_User2 where email='"+uid+"'");
	rss.next();
%>

<%
	total_post+=rst.getRow();
	}
	else {
%>

<%
	}
	}
%>



Forum
Total Posts
Last Post






<%=forum_type %>









Introduction
<%=rs.getString("Comments") %>
<%=rst.getRow() %>
<%=rst.getString("Thread_date") %> at <%=rst.getString("Thread_time") %>
By <%=rss.getString("fname") %> <%=rss.getString("lname") %>
<%=forum_type %> 


Introduction
<%=rs.getString("Comments") %>
0
-



<%
	rsg=st3.executeQuery("Select * from edu_Password");
	rsg.last();
	rs.last();

	rsx=st4.executeQuery("Select Reply_id from edu_Reply");
	rsx.last();
%>





Forum Statistics


The date and time now is <%=(dt.getDate()+1) %>/<%=(dt.getMonth()+1) %>/<%=(dt.getYear()+1900) %> <%=time1 %>
Online Members : <%=rsg.getRow() %>, Online Visitors : <%=visitors %>
Members: <%=(rsg.getRow()+visitors) %>, Forum: <%=rs.getRow() %>, Total Post: <%=total_post %>, Total Reply: <%=rsx.getRow() %>





<%
	}

ftc=ftcount;
ftcount=0;

	con.close();
	} catch(SQLException se) {
	  out.println("SQL Exception :"+se);
	} catch(ClassNotFoundException ce) {
	  out.println("Class Not Found Exception :"+ce);
	} catch(Exception e) {
	  out.println("General Exception :"+e);
	}
%>








 bgcolor=#933900>












Home
Delhi University
J N U
I G N O U
Global Education
Disccussion Form
Contact Us










All rights reserved. Copyright © N F I L    Legal Disclaimer