common.java

论坛软件系统亦称电子公告板(BBS)系统

					String viewperm=forum.get("viewperm");
					if("group".equals(type)){
						forumlist.append(groupselectable ? "<option value='"+forum.get("fid")+"'>"+name+"</option>" : "</optgroup><optgroup label='"+name+"'>");
						visible.put(forum.get("fid"), true);
					}else if("forum".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<option value='"+forum.get("fid")+"' "+(forum.get("fid").equals(fid) ? " selected" : "")+">&nbsp; &gt; "+name+"</option>");
						visible.put(forum.get("fid"), true);
					}else if("sub".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<option value='"+forum.get("fid")+"' "+(forum.get("fid").equals(fid) ? " selected" : "")+">&nbsp; &nbsp; &nbsp; &gt; "+name+"</option>");
					}
				}
				forumlist.append("</optgroup>");
			}
			visible=null;
		}
		forumList=null;
		return forumlist.toString().replace(tableformat?"<dl><dd><ul></ul></dd></dl>":"<optgroup label='&nbsp;'></optgroup>", "");
	}
	public static String forumselect(List<Map<String,String>> forumList,boolean groupselectable,boolean tableformat,short groupid,String extgroupid,String fid,boolean urlstatic)
	{
		StringBuffer forumlist=new StringBuffer();
		if(forumList!=null)
		{
			Map<String,Boolean> visible=new HashMap<String,Boolean>();
			if(tableformat){
				forumlist.append("<dl><dd><ul>");
				for(Map<String,String> forum:forumList)
				{
					String type=forum.get("type");
					String name=Common.strip_tags(forum.get("name"));
					String viewperm=forum.get("viewperm");
					if("group".equals(type)){
						forumlist.append("</ul></dd></dl><dl><dt><a href='index.jsp?gid="+forum.get("fid")+"'>"+name+"</a></dt><dd><ul>");
						visible.put(forum.get("fid"), true);
					}else if("forum".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						if(urlstatic){
							forumlist.append("<li"+(forum.get("fid").equals(fid) ? " class='current'" : "")+"><a href='forum-"+forum.get("fid")+"-1.html'>"+name+"</a></li>");
						}else{
							forumlist.append("<li"+(forum.get("fid").equals(fid) ? " class='current'" : "")+"><a href='forumdisplay.jsp?fid="+forum.get("fid")+"'>"+name+"</a></li>");
						}
						visible.put(forum.get("fid"), true);
					}else if("sub".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						if(urlstatic){
							forumlist.append("<li class='sub"+(forum.get("fid").equals(fid) ? "  current'" : "'")+"><a href='forum-"+forum.get("fid")+"-1.html'>"+name+"</a></li>");
						}else{
							forumlist.append("<li class='sub"+(forum.get("fid").equals(fid) ? "  current'" : "'")+"><a href='forumdisplay.jsp?fid="+forum.get("fid")+"'>"+name+"</a></li>");
						}
					}
				}
				forumlist.append("</ul></dd></dl>");
			}
			else{
				forumlist.append("<optgroup label='&nbsp;'>");
				for(Map<String,String> forum:forumList){
					String type=forum.get("type");
					String name=Common.strip_tags(forum.get("name"));
					String viewperm=forum.get("viewperm");
					if("group".equals(type)){
						forumlist.append(groupselectable ? "<option value='"+forum.get("fid")+"'>"+name+"</option>" : "</optgroup><optgroup label='"+name+"'>");
						visible.put(forum.get("fid"), true);
					}else if("forum".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<option value='"+forum.get("fid")+"' "+(forum.get("fid").equals(fid) ? " selected" : "")+">&nbsp; &gt; "+name+"</option>");
						visible.put(forum.get("fid"), true);
					}else if("sub".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<option value='"+forum.get("fid")+"' "+(forum.get("fid").equals(fid) ? " selected" : "")+">&nbsp; &nbsp; &nbsp; &gt; "+name+"</option>");
					}
				}
				forumlist.append("</optgroup>");
			}
			visible=null;
		}
		forumList=null;
		return forumlist.toString().replace(tableformat?"<dl><dd><ul></ul></dd></dl>":"<optgroup label='&nbsp;'></optgroup>", "");
	}
	public static String forumselect(List<Map<String,String>> forumList,short groupid,String extgroupid,String fid,boolean urlstatic)
	{
		StringBuffer forumlist=new StringBuffer();
		if(forumList!=null)
		{
			Map<String,Boolean> visible=new HashMap<String,Boolean>();
			forumlist.append("<dl><dd><ul>");
			for(Map<String,String> forum:forumList)
			{
				String type=forum.get("type");
				String viewperm=forum.get("viewperm");
				if("group".equals(type)){
					forumlist.append("</ul></dd></dl><dl><dt><a href='index.jsp?gid="+forum.get("fid")+"'>"+forum.get("name")+"</a></dt><dd><ul>");
					visible.put(forum.get("fid"), true);
				}else if("forum".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
					if(urlstatic){
						forumlist.append("<li"+(forum.get("fid").equals(fid) ? " class='current'" : "")+"><a href='forum-"+forum.get("fid")+"-1.html'>"+forum.get("name")+"</a></li>");
					}else{
						forumlist.append("<li"+(forum.get("fid").equals(fid) ? " class='current'" : "")+"><a href='forumdisplay.jsp?fid="+forum.get("fid")+"'>"+forum.get("name")+"</a></li>");
					}
					visible.put(forum.get("fid"), true);
				}else if("sub".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
					if(urlstatic){
						forumlist.append("<li class='sub"+(forum.get("fid").equals(fid) ? "  current'" : "'")+"><a href='forum-"+forum.get("fid")+"-1.html'>"+forum.get("name")+"</a></li>");
					}else{
						forumlist.append("<li class='sub"+(forum.get("fid").equals(fid) ? "  current'" : "'")+"><a href='forumdisplay.jsp?fid="+forum.get("fid")+"'>"+forum.get("name")+"</a></li>");
					}
				}
			}
			forumlist.append("</ul></dd></dl>");
			visible=null;
		}
		forumList=null;
		return forumlist.toString().replace("<dl><dd><ul></ul></dd></dl>", "");
	}
	public static String showForumWithSelected(boolean groupselectable,boolean tableformat,Short groupid,String extgroupid,List<String> selectFidList){
		List<Map<String,String>> forumList=dataBaseService.executeQuery("SELECT f.fid, f.type, f.name, f.fup, ff.viewperm, ff.formulaperm, a.uid FROM jrun_forums f LEFT JOIN jrun_forumfields ff ON ff.fid=f.fid LEFT JOIN jrun_access a ON a.fid=f.fid AND a.allowview='1' WHERE f.status>0 ORDER BY f.type, f.displayorder");
		setForums(forumList);
		StringBuffer forumlist=new StringBuffer();
		if(forumList!=null)
		{
			Map<String,Boolean> visible=new HashMap<String,Boolean>();
			if(tableformat){
				forumlist.append("<dl><dd><ul>");
				for(Map<String,String> forum:forumList)
				{
					String type=forum.get("type");
					String name=Common.strip_tags(forum.get("name"));
					String viewperm=forum.get("viewperm");
					if("group".equals(type)){
						forumlist.append("</ul></dd></dl><dl><dt><a href='index.jsp?gid="+forum.get("fid")+"'>"+name+"</a></dt><dd><ul>");
						visible.put(forum.get("fid"), true);
					}else if("forum".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<li"+(selectFidList.contains(forum.get("fid")) ? " class='current'" : "")+"><a href='forumdisplay.jsp?fid="+forum.get("fid")+"'>"+name+"</a></li>");
						visible.put(forum.get("fid"), true);
					}else if("sub".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<li class='sub"+(selectFidList.contains(forum.get("fid"))  ? "  current'" : "'")+"><a href='forumdisplay.jsp?fid="+forum.get("fid")+"'>"+name+"</a></li>");
					}
				}
				forumlist.append("</ul></dd></dl>");
			}
			else{
				forumlist.append("<optgroup label='&nbsp;'>");
				for(Map<String,String> forum:forumList){
					String type=forum.get("type");
					String name=Common.strip_tags(forum.get("name"));
					String viewperm=forum.get("viewperm");
					if("group".equals(type)){
						forumlist.append(groupselectable ? "<option value='"+forum.get("fid")+"'>"+name+"</option>" : "</optgroup><optgroup label='"+name+"'>");
						visible.put(forum.get("fid"), true);
					}else if("forum".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<option value='"+forum.get("fid")+"' "+(selectFidList.contains(forum.get("fid"))  ? " selected" : "")+">&nbsp; &gt; "+name+"</option>");
						visible.put(forum.get("fid"), true);
					}else if("sub".equals(type)&&visible.get(forum.get("fup"))!=null && ("".equals(viewperm) || (!"".equals(viewperm) && forumperm(viewperm,groupid,extgroupid)))){
						forumlist.append("<option value='"+forum.get("fid")+"' "+(selectFidList.contains(forum.get("fid"))  ? " selected" : "")+">&nbsp; &nbsp; &nbsp; &gt; "+name+"</option>");
					}
				}
				forumlist.append("</optgroup>");
			}
			visible=null;
		}
		forumList=null;
		return forumlist.toString().replace(tableformat?"<dl><dd><ul></ul></dd></dl>":"<optgroup label='&nbsp;'></optgroup>", "");
	}
	public static void visitedforums(HttpServletRequest request,HttpServletResponse response,int visitedforumcount,String visited,Map<String,String> settings){
		int count=0;
		String visitedfid = CookieUtil.getCookie(request, "visitedfid", true, settings);
		String[] visitedfids=null;
		if(visitedfid!=null){
			visitedfid=Base64Decoder.decode(visitedfid,JspRunConfig.charset);
			visitedfids=visitedfid.split("D"); 
		}
		List<String> fidarray=new ArrayList<String>();
		fidarray.add(visited);
		StringBuffer visitedforums=new StringBuffer();
		if(visitedfids!=null){
			for(String fid:visitedfids){
				fidarray.add(fid);
				if(!visited.equals(fid)){
					String[] fids=fid.split("=>");
					visitedforums.append("<option value="+fids[0]+">"+fids[1]+"</option>");
					if(++count>=visitedforumcount){
						break;
					}
				}
			}
		}
		String value = Base64Encoder.encode(implode("D",fidarray),JspRunConfig.charset);
		if(!value.equals(visitedfid)){
			CookieUtil.setCookie(request, response, "visitedfid", value, 2592000, true, settings);
		}
		if(visitedforums.length()>0){
			request.setAttribute("visitedforums",visitedforums.toString());
		}
	}
	public static String implode(String separator,List<String> obj){
		if(separator==null){
			separator="";
		}
		if(obj==null){
			return "";
		}
		StringBuffer values=new StringBuffer();
		for(String fid:obj){
			values.append(fid);
		}
		return values.toString();
	}
	public static String number_format(double number,String format) {
		return  new DecimalFormat(format).format(number);
	}
	public static String ajax_decode(String s) {
		try {
			return URLDecoder.decode(s,"utf-8");
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		}
		return s;
	}
	public static String encode(String s) {
		try {
			return URLEncoder.encode(s,JspRunConfig.charset);
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		}
		return s;
	}
	public static String decode(String s) {
		try {
			return URLDecoder.decode(s,JspRunConfig.charset);
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		}
		return s;
	}
	public static String[] getgroupid(Members member,String creditsformula,Map<String,String> usermap,Usergroups usergroup){
		if(creditsformula!=null && !creditsformula.equals("")){
			String[] result = new String[6];
			if(member!=null){				
				postOperating.setCredits(creditsformula,member,null);
				if(usergroup.getType().equals("member") && !(member.getCredits()>=usergroup.getCreditshigher() && member.getCredits()<=usergroup.getCreditslower())){
					List<Map<String,String>> grouplist = dataBaseService.executeQuery("SELECT groupid,grouptitle,color,stars,groupavatar FROM jrun_usergroups WHERE type='member' AND "+member.getCredits()+">=creditshigher AND "+member.getCredits()+"<creditslower LIMIT 1");
					if(grouplist!=null && grouplist.size()>0){
						member.setGroupid(Short.valueOf(grouplist.get(0).get("groupid")));
						result[0] = grouplist.get(0).get("groupid");
						result[1] = grouplist.get(0).get("grouptitle");
						result[2] = member.getCredits()+"";
						result[3] = grouplist.get(0).get("color");
						result[4] = grouplist.get(0).get("stars");
						result[5] = grouplist.get(0).get("groupavatar");
					}
				}
				memberService.modifyMember(member);
				if(result[0]==null){
					result[0] = usergroup.getGroupid()+"";
					result[1] = usergroup.getGrouptitle()+"";
					result[2] = member.getCredits()+"";
					result[3] = usergroup.getColor();
					result[4] = usergroup.getStars()+"";
					result[5] = usergroup.getGroupavatar();
				}
			}else{
				String credits = postOperating.setCreditsbyMap(creditsformula, usermap, null);
				if(credits!=null){
					if("member".equals(usermap.get("type")) && !(Integer.valueOf(credits)>=Integer.valueOf(usermap.get("creditshigher")) && Integer.valueOf(credits)<=Integer.valueOf(usermap.get("creditslower")))){
						List<Map<String,String>> grouplist = dataBaseService.executeQuery("SELECT groupid,grouptitle,color,stars,groupavatar FROM jrun_usergroups WHERE type='member' AND "+credits+">=creditshigher AND "+credits+"<creditslower LIMIT 1");
						if(grouplist!=null && grouplist.size()>0){
							result[0] = grouplist.get(0).get("groupid");
							result[1] = grouplist.get(0).get("grouptitle");
							result[3] = grouplist.get(0).get("color");
							result[4] = grouplist.get(0).get("stars");
							result[5] = grouplist.get(0).get("groupavatar");
						}
						grouplist = null;
					}
					if(!usermap.get("credits").equals(credits)){
						result[2] = credits;
						String sql = "";
						if(result[0]!=null){
							sql = ",groupid="+result[0];
						}
						dataBaseService.runQuery("update jrun_members set credits = "+credits+sql+" where uid="+usermap.get("uid"),true);
					}
				}
				if(result[0]==null){
					result[0] = usermap.get("groupid");
					result[1] = usermap.get("grouptitle");
					result[3] = usermap.get("color");
					result[4] = usermap.get("stars");
					result[5] = usermap.get("groupavatar");
				}
				if(result[2]==null){
					result[2] = usermap.get("credits");
				}
			}
			return result;
		}
		return null;
	}
	public static void updatepostcredits(String operator, int uid,Map<Integer, Integer> creditsarray, int timestamp) {
		StringBuffer creditsadd = new StringBuffer();
		Set<Integer> keys = creditsarray.keySet();
		for (Integer key : keys) {