package com.laoer.bbscs.user;import java.sql.*;import java.io.*;import java.util.*;import com.laoer.bbscs.db.*;import com.laoer.bbscs.txthtml.*;import com.laoer.bbscs.admin.BBSConf;/** * <p>Title: BBS-CS</p> * <p>Description: BBS-CS(BBS式虛擬社區系統)</p> * <p>Copyright: Copyright (c) 2002</p> * <p>Company: loveroom.com.cn</p> * @author 龔天乙（laoer） * @version 3.0 */public class UserIn {  String SQL = "";  DbTrans DBSQL;  ResultSet rs = null;  UserInfo myUserInfo;  DoText myDoText;  BBSConf myBBSConf;  int UserExp = 0;  int power = 0;  int hpower = 0;  String jibie = "";  public UserIn() {      this.DBSQL = new DbTrans();      this.myUserInfo = new UserInfo();      this.myDoText = new DoText();      this.myBBSConf = new BBSConf();  }  //public void setUserInfo(String strUserID) {  //    myUserInfo.setUserInfo(strUserID);  //}  public void setUserIn(String strUserID) {      getUserLevel(strUserID);      SQL = "update userdata set exp="+ this.UserExp +",power="+ this.power +",hpower="+ this.hpower +" where UID="+strUserID;      try {          DBSQL.executeQuery(SQL);      }      catch (SQLException e) {      }  }  public int getUserExp(String strUserID) {      int cishu = 0;      int bx = 0;      int artunm = 0;      int staytime = 0;      myUserInfo.setUserInfo(strUserID);      cishu = myUserInfo.getUserCiShu();      UserData myUserData = new UserData();      myUserData.setUserData(strUserID);      bx = myUserData.getUserBx();      artunm = myUserData.getUserArtNum();      staytime = myUserData.getUserStatyTime();      this.power = myUserData.getUserPower();      this.UserExp = (cishu/4)+artunm+(staytime/3600)+bx;      return this.UserExp;  }  public String getUserLevel(String strUserID) {      int exp = getUserExp(strUserID);      String jibie = "";      if (exp>=0 && exp<=10) {          this.hpower=10;          jibie="新手上路";      }      if (exp>=11 && exp<=50) {          this.hpower=15;          jibie="初出江湖";      }      if (exp>=51 && exp<=130) {          this.hpower=20;          jibie="一般站友";      }      if (exp>=131 && exp<=260) {          this.hpower=30;          jibie = "中級站友";      }      if (exp>=261 && exp<=450) {          this.hpower = 40;          jibie="高級站友";      }      if (exp>=451 && exp<=700) {          this.hpower = 50;          jibie = "老 站 友";      }      if (exp>=701 && exp<=1100) {          this.hpower=60;          jibie="青銅長老";      }      if (exp>=1101 && exp<=1900) {          this.hpower = 80;          jibie = "白銀長老";      }      if (exp>=1901 && exp<=3000) {          this.hpower = 100;          jibie = "黃金長老";      }      if (exp>=3001 && exp<=4500) {          this.hpower = 120;          jibie = "白金長老";      }      if (exp>=4501 && exp<=6500) {          this.hpower = 140;          jibie = "鉆石長老";      }      if (exp>=6501 && exp<=9000) {          this.hpower = 170;          jibie = "本站元老";      }      if (exp>=9001) {          this.hpower=200;          jibie="開國大老";      }      return jibie;  }  public int getUserPower() {      return this.power;  }  public int getUserHPower() {      return this.hpower;  }  public int getSumNote(String strUserID) {      int znote = 0;      SQL = "select count(*) as znote from guestbook where UID="+ strUserID;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              znote = rs.getInt("znote");          }          rs.close();      }      catch (SQLException e){      }      return znote;  }  public int getSumNewNote(String strUserID) {      int wnote = 0;      SQL = "select count(*) as wnote from guestbook where UID="+ strUserID +" and yd=0";      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              wnote = rs.getInt("wnote");          }          rs.close();      }      catch (SQLException e){      }      return wnote;  }  public int getNumMyFriend(String strUserID) {      int myfriend = 0;      SQL = "select count(*) as myfriend from friend where UID="+ strUserID;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              myfriend = rs.getInt("myfriend");          }          rs.close();      }      catch (SQLException e){      }      return myfriend;  }  public int getNumOMyFriend(String strUserID) {      int friendonlie = 0;      SQL = "select count(*) as friendonlie from user,friend where friend.UID="+ strUserID +" and user.ID=friend.FID and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(user.logintime))<=180";      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              friendonlie = rs.getInt("friendonlie");          }          rs.close();      }      catch (SQLException e){      }      return friendonlie;  }  public String getAdv() {      String strAdv = "";      Random r = new Random();      int rnum;      rnum = r.nextInt(2)+1;      if (rnum == 1) {          strAdv = "<a href=http://www.loveroom.com.cn target=_blank><img src=images/shmail.gif width=468 height=60 border=0></a>";      }      else if (rnum == 2) {          strAdv = "<script src=http://mysms.163.com/person?username=laoer&type=1></script>";      }      else {          strAdv = "<a href=http://www.loveroom.com.cn target=_blank><img src=images/shmail.gif width=468 height=60 border=0></a>";      }      return strAdv;  }  public String getHotArt() {      String strHotArt = "";      String tablecolor = "";      int n = 2;      int i = 1;      SQL = "select id2,board,title,time,click from forum  where (UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(time))<=604800 and new=1 and delsign = 0 order by click desc limit 0,10";      try {          rs = DBSQL.executeQuery(SQL);          while (rs.next()) {              if ((i %= n)==1) {                  tablecolor = myBBSConf.gettabletintcolor();              }              else {                  tablecolor = myBBSConf.gettabledarkcolor();              }              strHotArt += "<tr>\n";              strHotArt += "<td bgcolor=";              if ((i %= n)==1) {                  strHotArt += tablecolor;              } else {                  strHotArt += tablecolor;              }              strHotArt += "><a href='showdoc.jsp?bid="+rs.getString("board")+"&recid="+rs.getString("id2")+"&pages=1'>";              strHotArt += "<span class=bt>"+myDoText.iso2gb(rs.getString("title"))+"</span></a>";              strHotArt += "<font color=#FF0000> [點擊"+rs.getInt("click")+"次  發表于"+rs.getString("time")+"]</font></td>\n";              strHotArt += "</tr>\n";              i++;          }          rs.close();      }      catch (SQLException e){      }      return strHotArt;  }  public String getUserPH() {      String strUserPH = "";      String tablecolor = "";      int n = 2;      int i = 1;      SQL = "select user.name,user.nick,userdata.UID,userdata.exp from user,userdata where user.ID=userdata.UID order by userdata.exp desc limit 0,10";      try {          rs = DBSQL.executeQuery(SQL);          while (rs.next()) {          if ((i %= n)==1) {                  tablecolor = myBBSConf.gettabletintcolor();              }              else {                  tablecolor = myBBSConf.gettabledarkcolor();              }              strUserPH += "<tr>\n";              strUserPH += "<td bgcolor=";              if ((i %= n)==1) {              strUserPH += tablecolor;              } else {              strUserPH += tablecolor;              }              strUserPH += "><a href='userinfo.jsp?UID="+rs.getInt("UID")+"'><span class=bt>";              strUserPH += myDoText.iso2gb(rs.getString("name"))+"</span></a>[經驗值："+rs.getInt("exp")+"]</td>\n";              strUserPH += "</tr>\n";              i++;          }          rs.close();      }      catch (SQLException e){      }      return strUserPH;  }  public String getUserPic(String strUserID) {      String strUserPic = "";      int photonum = 0;      String picname = "";      SQL = "select count(*) as photonum from photo where UID="+strUserID;      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              photonum = rs.getInt("photonum");          }          rs.close();      }      catch (SQLException e){      }      if (photonum!=0) {          SQL = "select picname from photo where UID="+strUserID;          try {              rs = DBSQL.executeQuery(SQL);              if (rs.next()) {                  picname = rs.getString("picname");                  strUserPic = "<img src=upload/"+ picname +" width=200 height=150>";              }              rs.close();          }          catch (SQLException e){          }      }      else {          strUserPic = "<img src=images/photo.gif width=200 height=150>";      }      return strUserPic;  }  public boolean isHaveStar() {      int numStar = 0;      SQL = "select count(*) as numStar from photo where isstart = 1";      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              numStar = rs.getInt("numStar");          }          rs.close();      }      catch (SQLException e){      }      if (numStar != 0) {          return true;      }      else {          return false;      }  }  public String getStarPic() {      String strStarPic = "";      SQL = "select picname from photo where isstart = 1";      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              strStarPic = rs.getString("picname");          }          rs.close();      }      catch (SQLException e){      }      return strStarPic;  }  public String getStarBrief() {      String strStarBrief = "";      UserMyData StarUserMyData = new UserMyData();      String StarUID = "";      SQL = "select UID from photo where isstart = 1";      try {          rs = DBSQL.executeQuery(SQL);          if (rs.next()) {              StarUID = rs.getString("UID");          }          rs.close();      }      catch (SQLException e){          return "";      }      StarUserMyData.setUserMyData(StarUID);      strStarBrief = StarUserMyData.getBrief();      StarUserMyData.close();      return strStarBrief;  }  public void close() {      try {          DBSQL.close();      }      catch (SQLException e){      }      myUserInfo.close();      myBBSConf.close();  }}