systemtoolaction.java

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

			if (threads_forums != null && !threads_forums.get(0).equals("")&& !threads_forums.get(0).equals("all")) {
				sql.append(and);
				String fids = "";
				for (String fid : threads_forums) {
					fids += fid + ",";
				}
				fids = fids.substring(0, fids.length() - 1);
				sql.append(" t.fid in (" + fids + ") ");
			}
			if (tids != null && !tids.equals("")) {
				sql.append(and);
				sql.append(" t.tid in (" + tids + ") ");
			}
			if (keyword != null && !keyword.equals("")) {
				sql.append(and);
				String key = "";
				key = keyword.replace("*", "%");
				sql.append(" t.subject like '" + key + "' ");
			}
			if (typeids != null && !typeids.get(0).equals("all")) {
				sql.append(and);
				String typeidss = "";
				for (String typeid : typeids) {
					typeidss += typeid + ",";
				}
				typeidss = typeidss.substring(0, typeidss.length() - 1);
				sql.append(" t.typeid in (" + typeidss + ") ");
			}
			if (blog != null && !blog.equals("")) {
				sql.append(and);
				sql.append(" t.blog = " + blog);
			}
			if (special != null && !special.equals("")) {
				sql.append(and);
				String specialids = "";
				for (String specialid : special) {
					specialids += specialid + ",";
				}
				specialids = specialids.substring(0, specialids.length() - 1);
				sql.append(" t.special in (" + specialids + ") ");
			}
			if(rewardstatus!=null && !rewardstatus.equals("")){
				if(rewardstatus.equals("2")){
					sql.append(and);
					sql.append(" t.price>0 ");
				}else if(rewardstatus.equals("1")){
					sql.append(and);
					sql.append(" t.price<0 ");
				}
			}
			if (digest != null && !digest.equals("")) {
				sql.append(and);
				String digests = "";
				for (String digestid : digest) {
					digests += digestid + ",";
				}
				digests = digests.substring(0, digests.length() - 1);
				sql.append(" t.digest in (" + digests + ") ");
			}
			if (stick != null && !stick.equals("")) {
				sql.append(and);
				String sticks = "";
				for (String stickid : stick) {
					sticks += stickid + ",";
				}
				sticks = sticks.substring(0, sticks.length() - 1);
				sql.append(" t.displayorder in (" + sticks + ") ");
			}
			if (orderby != null && !orderby.equals("")) {
				sql.append(" order by " + orderby);
			}
			int startrowcount = Common.toDigit(startrow);
			int itemscount =  Common.toDigit(items);
			List<Map<String,String>> threadlist = dataBaseService.executeQuery(sql.toString()+" limit "+startrowcount+","+itemscount);
			StringBuffer preebuffer = new StringBuffer();
			if (threadlist != null && threadlist.size()>0) {
				for (Map<String,String> thread:threadlist) {
					String subject = thread.get("subject");
					if (convertInt(maxlength) < subject.length()) {
						subject = subject.substring(0, Common.toDigit(maxlength))+ "...";
					}
					if (threadtypes != null && threadtypes.equals("1")) {
						subject = "[" + thread.get("typename") + "]" + subject;
					}
					String message = thread.get("message");
					String forumss = thread.get("name");
					String author = thread.get("author");
					String datetime = Common.gmdate(dateformat+" "+timeformat, (int)(Common.toDigit(thread.get("dateline"))+timeoffset));
					String lastpost = Common.gmdate(dateformat+" "+timeformat, (int)(Common.toDigit(thread.get("lastpost"))+timeoffset));
					String lastposter = thread.get("lastposter");
					String replices = thread.get("replies");
					String views = thread.get("views");
					String link = "viewthread.jsp?tid="+thread.get("tid");
					String resultpreview = "";
					if (highlight != null && highlight.equals("1")) {
						if (Common.toDigit(thread.get("highlight")) > 0) {
							resultpreview = jstemplate.replaceAll("\\(subject\\)","<a href='"+request.getContextPath()+"/viewthread.jsp?tid="+thread.get("tid")+"' target=_blanck><font color='red'>" + subject + "</font></a>");
							resultpreview = resultpreview.replaceAll("\\(subject_nolink\\)", "<font color='red'>" + subject + "</font>");
							resultpreview = resultpreview.replaceAll("\\(subject_full\\)", "<font color='red'>" + subject + "</font>");
						} else {
							resultpreview = jstemplate.replaceAll("\\(subject\\)", "<a href='"+request.getContextPath()+"/viewthread.jsp?tid="+thread.get("tid")+"' target=_blanck>" + subject+ "</a>");
							resultpreview = resultpreview.replaceAll("\\(subject_nolink\\)", subject);
							resultpreview = resultpreview.replaceAll("\\(subject_full\\)", subject);
						}
					} else {
						resultpreview = jstemplate.replaceAll("\\(subject\\)","<a href='"+request.getContextPath()+"/viewthread.jsp?tid="+thread.get("tid")+"' target=_blanck>" + subject + "</a>");
						resultpreview = resultpreview.replaceAll("\\(subject_nolink\\)", subject);
						resultpreview = resultpreview.replaceAll("\\(subject_full\\)", subject);
					}
					if (picpre != null && !picpre.equals("")) {
						resultpreview = resultpreview.replaceAll("\\(prefix\\)", "<img src='" + picpre + "'>");
					} else {
						resultpreview = resultpreview.replaceAll("\\(prefix\\)", "");
					}
					resultpreview = resultpreview.replaceAll("\\(message\\)",message);
					resultpreview = resultpreview.replaceAll("\\(forum\\)","<a href='"+request.getContextPath()+"/forumdisplay?fid="+thread.get("fid")+"' target=_blanck>" + forumss + "</a>");
					resultpreview = resultpreview.replaceAll("\\(author\\)","<a href='"+request.getContextPath()+"/space.jsp?uid="+thread.get("authorid")+"' target=_blanck>" + author + "</a>");
					resultpreview = resultpreview.replaceAll("\\(dateline\\)",datetime);
					resultpreview = resultpreview.replaceAll("\\(lastposter\\)", "<a href='"+request.getContextPath()+"/space.jsp?action=viewpro&username="+Common.encode(lastposter)+"' target=_blanck>" + lastposter+ "</a>");
					resultpreview = resultpreview.replaceAll("\\(lastpost\\)",lastpost);
					resultpreview = resultpreview.replaceAll("\\(replies\\)",replices);
					resultpreview = resultpreview.replaceAll("\\(views\\)",views);
					resultpreview = resultpreview.replaceAll("\\(link\\)", link);
					preebuffer.append(resultpreview);
				}
			}
			threadlist = null;
			String preview = parsenode(jstemplatebody,preebuffer.toString(),jscharset);
			request.setAttribute("resultpreview", preview);
			request.setAttribute("diaplay", "yes");
		} else {
			List<Map<String,String>> groups = dataBaseService.executeQuery("select fid,name,status from jrun_forums where type='group'");
			List<Map<String,String>> forums = dataBaseService.executeQuery("select fid,name,fup,status from jrun_forums where type='forum'");
			List<Map<String,String>> subs = dataBaseService.executeQuery("select fid,name,fup,status from jrun_forums where type='sub'");
			List<Threadtypes> threadtype = threadTypeServer.getAllThreadtypes();
			Map threadTypeMap = new HashMap();
			for (Threadtypes types : threadtype) {
				threadTypeMap.put(types, "");
			}
			request.setAttribute("groups", groups);
			request.setAttribute("forums", forums);
			request.setAttribute("subs", subs);
			request.setAttribute("threadtype", threadTypeMap);
			String inentname = "threads_" + randomName();
			request.setAttribute("inentifier", inentname);
			request.setAttribute("diaplay", null);
		}
		return mapping.findForward("jsthreadsetting");
	}

	private String randomName() {
		Random random = new Random();
		String str = "abcdefghigklmnopqrstuvtxyzABCDEFGHIGKLMNOPQRSTUVWXYZ0123456789";
		String sRand = "";
		for (int i = 0; i < 3; i++) {
			String rand = String.valueOf(str.charAt(random.nextInt(62)));
			sRand += rand;
		}
		return sRand;
	}

	@SuppressWarnings("unchecked")
	public ActionForward editjsthreads(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		String jssubmit = request.getParameter("jssubmit");
		if(jssubmit==null){
			Common.requestforward(response, "admincp.jsp?action=jswizard");
			return null;
		}
		Map<String,String> settings = (Map<String,String>)request.getSession().getServletContext().getAttribute("fsmap");
		String jstemplate = request.getParameter("parameter[jstemplate]");  
		String jskey = request.getParameter("jskey");  
		String cachelife = request.getParameter("parameter[cachelife]");  
		String threads_forums[] = request.getParameterValues("parameter[threads_forums]");  
		String startrow = request.getParameter("parameter[startrow]");  
		String items = request.getParameter("parameter[items]"); 
		String maxlength = request.getParameter("parameter[maxlength]");  
		String fnamelength = request.getParameter("parameter[fnamelength]");  
		String picpre = request.getParameter("parameter[picpre]");  
		String tids = request.getParameter("parameter[tids]");  
		String keyword = request.getParameter("parameter[keyword]"); 
		String tag = request.getParameter("parameter[tag]");  
		String typeids[] = request.getParameterValues("parameter[typeids]");  
		String threadtype = request.getParameter("parameter[threadtype]");  
		String highlight = request.getParameter("parameter[highlight]");  
		String blog = request.getParameter("parameter[blog]");  
		String[] special = request.getParameterValues("parameter[special]");  
		String rewardstatus = request.getParameter("parameter[rewardstatus]");  
		String digest[] = request.getParameterValues("parameter[digest]"); 
		String stick[] = request.getParameterValues("parameter[stick]"); 
		String newwindow = request.getParameter("parameter[newwindow]");  
		String orderby = request.getParameter("parameter[orderby]");  
		String jscharset = request.getParameter("parameter[jscharset]");  
		String uri = "function=threads&";
		if (threads_forums != null) {
			String fid = "";
			for (String s : threads_forums) {
				fid = fid + s + "_";
			}
			fid = fid.substring(0, fid.length() - 1);
			uri = uri + "fids=" + fid + "&maxlength=" + maxlength + "&fnamelength=" + fnamelength + "&blog=" + blog + "&startrow=" + startrow + "&picpre=" + picpre + "&items=" + items + "&tag=" + tag + "&tids=" + tids + "&keyword=" + keyword;
		} else {
			uri = uri + "&maxlength=" + maxlength + "&fnamelength=" + fnamelength + "&blog=" + blog + "&startrow=" + startrow + "&picpre=" + picpre + "&items=" + items + "&tag=" + tag + "&tids=" + tids + "&keyword=" + keyword;
		}
		if (typeids != null) {
			String typeid = "";
			for (String s : typeids) {
				typeid = typeid + s + "_";
			}
			typeid = typeid.substring(0, typeid.length() - 1);
			uri = uri + "&typeids=" + typeid;
		}
		if (special != null) {
			String specials = "";
			for (String s : special) {
				specials = specials + s;
			}
			uri = uri + "&special=" + specials + "&rewardstatus=" + rewardstatus;
		} else {
			uri = uri + "&rewardstatus=" + rewardstatus;
		}
		if (digest != null) {
			String digests = "";
			for (String s : digest) {
				digests += s;
			}
			uri = uri + "&digest=" + digests;
		}
		if (stick != null) {
			String sticks = "";
			for (String s : stick) {
				sticks += s;
			}
			uri = uri + "&stick=" + sticks + "&newwindow=" + newwindow + "&threadtype=" + threadtype + "&highlight=" + highlight + "&orderby=" + orderby + "&jscharset=" + jscharset + "&cachelife=" + cachelife + "&jstemplate=" + jstemplate;
		} else {
			uri = uri + "&newwindow=" + newwindow + "&threadtype=" + threadtype + "&highlight=" + highlight + "&orderby=" + orderby + "&jscharset=" + jscharset + "&cachelife=" + cachelife + "&jstemplate=" + jstemplate;
		}
		HashMap resultMap = new HashMap();
		HashMap parameterMap = new HashMap();
		parameterMap.put("blog", blog);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("cachelife", cachelife);
		resultMap.put("parameter", parameterMap);
		if (digest != null) {
			Map digestsubMap = new HashMap();
			for (String s : digest) {
				digestsubMap.put(new Integer(s), "1");
			}
			parameterMap.put("digest", digestsubMap);
			resultMap.put("parameter", parameterMap);
		}
		parameterMap.put("fnamelength", fnamelength);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("highlight", highlight);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("items", items);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("jscharset", jscharset);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("jstemplate", jstemplate);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("keyword", keyword);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("maxlength", maxlength);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("newwindow", newwindow);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("orderby", orderby);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("picpre", picpre);
		resultMap.put("parameter", parameterMap);
		parameterMap.put("rewardstatus", rewardstatus);
		resultMap.put("parameter", parameterMap);
		if (special != null) {