inc_trackback.asp

ZD-BS是一个基于asp+access的个人blog系统 程序特点: 1.数据结构合理

<script language="JScript" runat="server">

//============================================================
//     Copyright 2006-2007 VAL/ZYI. All Rights Reserved.
//============================================================

function doit(){
	var arrPara=new Array();
	var arrQS=func.getInput(0);
	var arrF=func.getInput(1);
	arrPara["logID"]=func.checkInt(arrQS["logID"]);
	arrPara["url"]=arrF["url"];
	arrPara["title"]=arrF["title"];
	arrPara["excerpt"]=arrF["excerpt"];
	arrPara["blog_name"]=arrF["blog_name"];
	saveTrackback(arrPara);
}

function saveTrackback(arrPara){
	
	var intLogID=arrPara["logID"];
	var strURL=func.checkUrl(theHTML.trim(arrPara["url"]));
	var strTitle=theHTML.trim(theHTML.encodeHTML(theHTML.trimHTML(arrPara["title"])));
	var strExcerpt=theHTML.trim(theHTML.encodeHTML(theHTML.trimHTML(arrPara["excerpt"])));
	var strBlog=theHTML.trim(theHTML.encodeHTML(theHTML.trimHTML(arrPara["blog_name"])));
	
	var arrArticle=dbConn.query("select top 1 post_enablePingIn from zd_post where post_ID="+intLogID+" and post_type='article' and post_state='publish'");
	if(arrArticle==null){
		theXML.output(theAPI.sendITBResponse(1,"Invalid Article ID"));
	}else if(!arrArticle[0]["post_enablePingIn"]){
		theXML.output(theAPI.sendITBResponse(1,"disable Trackback or Article is locked"));
	}else if(strURL==""){
		theXML.output(theAPI.sendITBResponse(1,"Source URL is Blank"));
	}else{
		arrTrackback=dbConn.query("select top 1 comm_ID from zd_comment where comm_postID="+intLogID+" and comm_homepage='"+strURL+"' and comm_type='trackback'");
		if(arrTrackback!=null){
			theXML.output(theAPI.sendITBResponse(1,"Trackback is already saved"));
		}else{
			var arrDB={
				"comm_postID":intLogID,
				"comm_homepage":theHTML.sliceStr(strURL,252,"..."),
				"comm_email":theHTML.sliceStr((strTitle==""?strURL:strTitle),100,"..."),
				"comm_from":theHTML.sliceStr((strBlog==""?"Unknow":strBlog),100,"..."),
				"comm_content":theHTML.sliceStr((strExcerpt==""?strURL:strExcerpt),100,"..."),
				"comm_textMode":"text",
				"comm_ip":func.getIp(),
				"comm_state":"publish",
				"comm_type":"trackback"
			};
			dbConn.insert(arrDB,"zd_comment");
			if(zd_set["cacheCounter"]) theCache.loadCounter();
			theXML.output(theAPI.sendITBResponse(0));
		}
	}
}

</script>