对LBS的一个改进

[ 2009-07-07 17:47:16 | Author: wujimmy ]

Font Size: Large | Medium | Small

对LBS 记事本一个改进,增加了一个功能,测试一下一个评论是否含有汉字,如果没有,则删之.

Quote

// Delete Comment By ID /////////////////////////////////////////////////////////////////////////////
function commentDeleteByID(id){
if(theUser.rights["delete"]<1){
// Check User Right - without DB Query
pageHeader(lang["error"]);
redirectMessage(lang["error"], lang["no_rights"], lang["goback"], "javascript:window.history.back();", false, "errorbox");
}else{
var strError="";

commentID=func.checkInt(commentID);
if(!commentID){
strError=lang["invalid_parameter"];
}else{
// Check user right again
var arrData=connGBook.query("SELECT TOP 1 gb_userid FROM [Guestbook] WHERE gb_id="+commentID);
if(arrData){
arrData=arrData[0];
if(theUser.id!=arrData["gb_userid"]&&theUser.groupID!=1&&theUser.rights["delete"]<2){
strError=lang["no_rights"];
}
}else{
strError=lang["comment_not_found"];
}
}

if(strError!=""){
pageHeader(lang["error"]);
redirectMessage(lang["error"], strError, lang["goback"], "javascript:window.history.back();", false, "errorbox");
}else{
connGBook.doDelete("[Guestbook]","gb_id="+commentID);
}
}
}

//by wujimmy . for delete only english content.
function isHZ(s)
{
var patrn=/[u4e00-u9fa5]/;
if (patrn.exec(s)) return false
return true
}

// Delete Comment By ID /////////////////////////////////////////////////////////////////////////////
function commentDeleteByID(commentID){
if(theUser.rights["delete"]<1){
// Check User Right - without DB Query
pageHeader(lang["error"]);
redirectMessage(lang["error"], lang["no_rights"], lang["goback"], "javascript:window.history.back();", false, "errorbox");
}else{
var strError="";
if(!commentID){
strError=lang["invalid_parameter"];
}else{
// Check user right again
var arrData=connGBook.query("SELECT TOP 1 gb_userid FROM [Guestbook] WHERE gb_id="+commentID);
if(arrData){
arrData=arrData[0];
if(theUser.id!=arrData["gb_userid"]&&theUser.groupID!=1&&theUser.rights["delete"]<2){
strError=lang["no_rights"];
}
}else{
strError=lang["comment_not_found"];
}
}

if(strError!=""){
pageHeader(lang["error"]);
redirectMessage(lang["error"], strError, lang["goback"], "javascript:window.history.back();", false, "errorbox");
}else{
connGBook.doDelete("[Guestbook]","gb_id="+commentID);
}
}
}

// Check GuestBook ////////////////////////////////////////////////////////////////////////////
function checkGuestBook(){
var sqlWHERE="";
var strURLPrefix="?";
var arrKeywords="";

var entries = connGBook.query("SELECT * FROM [Guestbook] ORDER BY gb_postTime DESC");

if(entries){
for(var i=0;i<entries.length;i++){
         var commentID=entries[i]["gb_id"];
         var content=entries[i]["gb_content"];
         // check is contain HZ, if not then delete isHZ
    if (! isHZ(content))
    {
      commentDeleteByID(commentID);
    }

}
}else{
entries="";
entryCount = 0;
}
}