skinutil.java

阿菜论坛beta-1版java代码

package net.acai.forum;
/**
 * Title:        阿菜网络
 * Description:
 * Copyright:    Copyright (c) 2002
 * Company:      www.justhis.com
 * @author:       acai
 * @version 1.0
 */
import net.acai.database.*;
import net.acai.forum.*;
import net.acai.forum.util.*;
import net.acai.util.*;
import net.acai.ip.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
public class SkinUtil
{
	public static void login(HttpServletRequest request,
				 HttpServletResponse response,
				 String username,
				 String password) throws UserNotFoundException,Exception
	{
			/*User sessionUser=new User(username,password);
			HttpSession session=request.getSession(true);
			session.setAttribute("UJBBUser",sessionUser);
			GCookie.setCookie(response,"UJBBUName",username,60*60*60);
			GCookie.setCookie(response,"UJBBUPSW",password,60*60*60);*/
	}
	public static User checkUser(HttpServletRequest request,HttpServletResponse response,int loginSign) throws UserNotFoundException,Exception{
		String userName=GCookie.getCookieValue(request,"UJBBUName","");
		String userPassword=GCookie.getCookieValue(request,"UJBBUPSW","");
		User tempUser=new User(userName,userPassword,loginSign);
		return tempUser;
	}
		
	public static void userLogin(HttpServletRequest request,HttpServletResponse response,int loginSign) throws UserNotFoundException,Exception{
		String userName=ParamUtil.getString(request,"userName","");
		String userPassword=ParamUtil.getString(request,"userPassword","");
		User tempUser=new User(userName,userPassword,loginSign);
		int cookieDate=ParamUtil.getInt(request,"cookieDate",1);
		switch(cookieDate){
			case 1:
				cookieDate=3600*24;
				break;
			case 2:
				cookieDate=30*3600*24;
				break;
			case 3:
				cookieDate=365*30*3600*24;
				break;
			
			default:
				cookieDate=3600*24;
				break;
		}
		
		GCookie.setCookie(response,"UJBBUName",userName,cookieDate);
		GCookie.setCookie(response,"UJBBUPSW",userPassword,cookieDate);	
	}
	public static void userLogout(HttpServletResponse response,HttpServletRequest request) throws Exception
	{
		
			String userName=GCookie.getCookieValue(request,"UJBBUName","");
			String userPassword=GCookie.getCookieValue(request,"UJBBUPSW","");
			GCookie.setCookie(response,"UJBBUName",userName,0);
			GCookie.setCookie(response,"UJBBUPSW",userPassword,0);	
	
			long 	statUserID=Long.parseLong(StringUtils.replace(request.getRemoteAddr(),".",""));
 			String sql="delete from online where ID="+statUserID;
			
			DBConnect dbc=new DBConnect(sql);
			dbc.executeUpdate();
	}
		
		
	public static User userLogin(String userName,String userPassword,int loginSign) throws UserNotFoundException,Exception{
		User tempUser=new User(userName,userPassword,loginSign);
		return tempUser;
	}
	
	
	public static void checkUserStats(HttpServletRequest request,HttpServletResponse response){
		String stats;
		if((stats=ParamUtil.getString(request,"stats"))==null)
			stats="论坛首页 response";
		
		checkUserStats(request,response,stats);
		
	}
	
	public static void checkUserStats(HttpServletRequest request,HttpServletResponse response,String stats){
		
		String userName=GCookie.getCookieValue(request,"UJBBUName","");
		String userPassword=GCookie.getCookieValue(request,"UJBBUPSW","");
		String ip=request.getRemoteAddr();
		String[] addr=IPLocalizer.search(request);
		String comeFrom="";
		for(int i=0;i<addr.length;i++)
			comeFrom+=addr[i];
		String actCome=request.getHeader("X_FORWARDED_FOR");
		long 	statUserID=Long.parseLong(StringUtils.replace(ip,".",""));
 		boolean onlineSign=false;
 		String browser=request.getHeader("User-Agent");
		ResultSet rs;
 		try{
			String sql="";
			DBConnect dbc=new DBConnect();
			try{
 			sql="select * from online where id=?";
			dbc.prepareStatement(sql);
			dbc.setLong(1,statUserID);
			//dbc.setBytes(2,userName.getBytes("GBK"));
			rs=dbc.executeQuery();
			if(rs.next())
				onlineSign=true;
			else
				onlineSign=false;
			rs.close();
			}
			catch(Exception e){
				onlineSign=false;
			}
 		
		

			
		
			if("".equals(userName)){
				if(!onlineSign){
					sql="insert into online (id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
					dbc.prepareStatement(sql);
					dbc.setLong(1,statUserID);
					dbc.setString(2,"guest");
					dbc.setBytes(3,"客人".getBytes("GBK"));
					dbc.setBytes(4,ip.getBytes("GBK"));
					dbc.setString(5,Format.getDateTime());
					dbc.setString(6,Format.getDateTime());
					dbc.setString(7,browser);
					dbc.setBytes(8,stats.getBytes("GBK"));
					dbc.setString(9,actCome);
					dbc.setBytes(10,comeFrom.getBytes("GBK"));
					dbc.setString(11,actCome);
					dbc.executeUpdate();
					dbc.clearParameters();
					
				}
				else{
						sql="update online set lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=?";
						dbc.prepareStatement(sql);
						dbc.setString(1,Format.getDateTime());
						dbc.setString(2,Format.getStrDateTime());
						dbc.setBytes(3,comeFrom.getBytes("GBK"));
						dbc.setString(4,actCome);
						dbc.setBytes(5,stats.getBytes("GBK"));
						dbc.setLong(6,statUserID);
						dbc.executeUpdate();
						dbc.clearParameters();
					
				}
			}
			else{
				sql="select * from online where  ID=? or username=?";
				dbc.prepareStatement(sql);
				dbc.setLong(1,statUserID);
				dbc.setBytes(2,userName.getBytes("GBK"));
				rs=dbc.executeQuery();
				if(rs.next())
					onlineSign=true;
				else
					onlineSign=false;
				dbc.clearParameters();
				try{
					User theUser=new User(userName,userPassword,4);
					if(onlineSign){
						
						sql="update online set id=?,userName=?,userClass=?,lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=? or username=?";
						dbc.prepareStatement(sql);
						dbc.setLong(1,statUserID);
						dbc.setBytes(2,userName.getBytes("GBK"));
						dbc.setBytes(3,getUserClass(theUser.getUserClass()).getBytes("GBK"));
						dbc.setString(4,Format.getDateTime());
						dbc.setString(5,Format.getStrDateTime());
						dbc.setBytes(6,comeFrom.getBytes("GBK"));
						dbc.setString(7,actCome);
						dbc.setBytes(8,stats.getBytes("GBK"));
						dbc.setLong(9,statUserID);
						dbc.setBytes(10,userName.getBytes("GBK"));
						dbc.executeUpdate();
						dbc.clearParameters();
					}
					else{
					
						sql="insert into online(id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
						dbc.prepareStatement(sql);
						dbc.setLong(1,statUserID);//statUserID);
						dbc.setBytes(2,userName.getBytes("GBK"));
						dbc.setBytes(3,getUserClass(theUser.getUserClass()).getBytes("GBK"));
						dbc.setString(4,ip);
						dbc.setString(5,Format.getDateTime());
						dbc.setString(6,Format.getStrDateTime());
						dbc.setString(7,browser);
						dbc.setBytes(8,stats.getBytes("GBK"));
						if(actCome==null){
							dbc.setString(9,"null");
							dbc.setString(11,"null");
						}
						else{
							dbc.setString(9,actCome);
							dbc.setString(11,actCome);
						}
						
						dbc.setBytes(10,comeFrom.getBytes("GBK"));
						
						dbc.executeUpdate();
						dbc.clearParameters();
					}
				}
				catch(Exception e){
					
					if(!onlineSign){
					sql="insert into online (id,username,userclass,ip,startime,lastimebk,browser,stats,actforip,ComeFrom,actCome) values(?,?,?,?,?,?,?,?,?,?,?)";
					dbc.prepareStatement(sql);
					dbc.setLong(1,statUserID);
					dbc.setString(2,"guest");
					dbc.setBytes(3,"客人".getBytes("GBK"));
					dbc.setBytes(4,ip.getBytes("GBK"));
					dbc.setString(5,Format.getDateTime());
					dbc.setString(6,Format.getDateTime());
					dbc.setString(7,browser);
					dbc.setBytes(8,stats.getBytes("GBK"));
					dbc.setString(9,actCome);
					dbc.setBytes(10,comeFrom.getBytes("GBK"));
					dbc.setString(11,actCome);
					dbc.executeUpdate();
					dbc.clearParameters();
					
					}
					else{
							sql="update online set lastimebk=?,lastime=?,ComeFrom=?,actCome=?,stats=? where id=?";
							dbc.prepareStatement(sql);
							dbc.setString(1,Format.getDateTime());
							dbc.setString(2,Format.getStrDateTime());
							dbc.setBytes(3,comeFrom.getBytes("GBK"));
							dbc.setString(4,actCome);
							dbc.setBytes(5,stats.getBytes("GBK"));
							dbc.setLong(6,statUserID);
							dbc.executeUpdate();
							dbc.clearParameters();
						
					}

				}
					
			}
			
			
			
			sql="delete from online where now()>date_add(lastimebk,interval 20 minute)";
			
			dbc.executeUpdate(sql);
			sql="select Maxonline from config";
			rs=dbc.executeQuery(sql);
			rs.next();
			int oldMaxOnLine=rs.getInt(1);
			sql="select count(*) from online";
			ResultSet tmprs=dbc.executeQuery(sql);
			tmprs.next();
			int newMaxOnLine=tmprs.getInt(1);
			if(newMaxOnLine>oldMaxOnLine){
				sql="update config set Maxonline="+newMaxOnLine+",MaxonlineDate=now()";
				dbc.executeUpdate(sql);
				ForumPropertiesManager.resetManager();
			}
			
			dbc.close();
			
		}
		catch(Exception e){
			
			e.printStackTrace();
		}
		
	}
	public static String getUserClass(int userClass){
		String user_level="";
		switch(userClass){
				
			case 1:
				user_level="新手上路";
				break;
			case 2:
				user_level="论坛游民";
				break;
			case 3:
				user_level="论坛游侠";
				break;
			case 4:
				user_level="业余侠客";
				break;
			case 5:
				user_level="职业侠客";
				break;
			case 6:
				user_level="侠之大者";
				break;
			case 7:
				user_level="黑侠";
				break;
			case 8:
				user_level="蝙蝠侠";
				break;
			case 9:
				user_level="蜘蛛侠";
				break;
			case 10:
				user_level="青蜂侠";
				break;
			case 11:
				user_level="小飞侠";
				break;
			case 12:
				user_level="火箭侠";
				break;
			case 13:
				user_level="蒙面侠";
				break;
			case 14:
				user_level="城市猎人";
				break;
			case 15:
				user_level="罗宾汉";
				break;
			case 16:
				user_level="阿诺";
				break;
			case 17:
				user_level="侠圣";
				break;
			case 18:
				user_level="贵宾";
				break;
			case 19:
				user_level="版主";
				break;
			case 20:
				user_level="总版主";
				break;
			default:
				user_level="新手上路";
				break;
		}
		return user_level;
	}
	
		
	public static int getPoint(int p){
		int level_point=0;
		switch(p){
			case 1:
				level_point=0;
				break;
			case 2:
				level_point=100;
				break;
			case 3:
				level_point=200;
				break;
			case 4:
				level_point=300;
				break;
			case 5:
				level_point=400;
				break;
			case 6:
				level_point=500;
				break;
			case 7:
				level_point=600;
				break;
			case 8:
				level_point=800;
				break;
			case 9:
				level_point=1000;
				break;
			case 10:
				level_point=1200;
				break;
			case 11:
				level_point=1500;
				break;
			case 12:
				level_point=1800;
				break;
			case 13:
				level_point=2100;
				break;
			case 14:
				level_point=2500;
				break;
			case 15:
				level_point=3000;
				break;
			case 16:
				level_point=3500;
				break;
			case 17:
				level_point=4000;
				break;
			default:
				level_point=0;
				break;
		}
		return level_point;
	}
		
	public static Vector getTopList(HttpServletRequest request) throws Exception{
		int orders=ParamUtil.getInt(request,"orders",7);
		String sql="";
		switch(orders){
		case 1:
			sql="select username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from user order by article desc limit 0,10";
			break;
		case 2:
			sql="select  username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from user order by AddDate desc limit 0,10";
			break;
		case 7:
			sql="select username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from user order by AddDate desc ";
			break;
		default:
			sql="select  username,useremail,userclass,oicq,homePage,article,addDate,userwealth as wealth ,userID from user order by article desc limit 0,10";
			break;
		}
		
		DBConnect dbc=new DBConnect();
		ResultSet rs=dbc.executeQuery(sql);
		Vector userVector=new Vector();
		while(rs.next()){
			User tempUser=new User();
			tempUser.setUserName(rs.getString(1));
			tempUser.setUserEmail(rs.getString(2));
			tempUser.setUserClass(rs.getInt(3));
			tempUser.setOicq(rs.getString(4));
			tempUser.setHomePage(rs.getString(5));
			tempUser.setArticle(rs.getInt(6));
			tempUser.setAddDate(rs.getString(7));
			tempUser.setUserWealth(rs.getInt(8));
			tempUser.setUserID(rs.getInt(9));
			userVector.add(tempUser);
		}
		return userVector;
	}
	
				
}