Blogs

<%break; /*********** loginaction **************/ case "login": YongHu=Request.Form("YongHu")+""; YongHu=YongHu.replace(/'/g,"''"); MiMa=Request.Form("MiMa")+""; MiMa=MiMa.replace(/'/g,"''"); if(YongHu+""=="undefined"){Session("d7fabb5d7")="Guest"; Response.Write("
you have logout state .
");} else{ sql="select * from User where YongHu='"+YongHu+"' and MiMa='"+MiMa+"' and ShanChu=0"; rs.Open(sql,conn); if(rs.eof){Response.Write("
sorry ,Your input user name or passwd not right.
");} else{QuanXian=""+rs(3); if(QuanXian=="true"){QuanXian=true;} else{QuanXian=false;} Session("d7fabb5d7")=QuanXian?"Admin":"User"; Response.Write("
loginsuccess.
");} rs.Close();} break; /*********** articlemanage **************/ case "manage": if(Request.QueryString("do")+""=="delete"&&Session("d7fabb5d7")=="Admin"){ sql="update Article set ShanChu=1 where BH="+Request.QueryString("BH"); conn.Execute(sql);} if(Request.QueryString("do")+""=="huifu"&&Session("d7fabb5d7")=="Admin"){ sql="update Article set ShanChu=0 where BH="+Request.QueryString("BH"); conn.Execute(sql);} if(Request.QueryString("do")+""=="add"){ sql="select count(*) from Article"; rs.open(sql,conn); BH=rs(0)+""; rs.Close(); Title=Request.Form("Title")+""; Category=Request.Form("Category")+""; Content=Request.Form("Content")+""; str_match = Content.match(']+href="(.*)"[^>]*>(.*)'); URL = str_match[1]; Keywords = str_match[2]; //Response.write(url); //Keywords=Request.Form("Keywords")+""; //URL=Request.Form("URL")+""; Title=Title.replace(/'/g,"''"); Category=Category.replace(/'/g,"''"); Content=Content.replace(/'/g,"''"); Content=Content.replace(/\r/g,"
"); Keywords=Keywords.replace(/'/g,"''"); URL=URL.replace(/'/g,"''"); RiQi=new Date(); Nian=RiQi.getYear(); Yue=RiQi.getMonth()+1; /*********** Content=Content.replace(/ /g," ");*************/ if(Yue<10) Yue="0"+Yue; Ri=RiQi.getDate(); if(Ri<10) Ri="0"+Ri; RiQi=Nian+"-"+Yue+"-"+Ri+""; sql="select top 1 BH from Article where ShanChu=1 order by RiQi asc"; rs.open(sql,conn); if(!rs.eof){ sql="Update Article set Title='"+Title+"',Content='"+Content+"',Keywords='"+Keywords+"',URL='"+URL+"',RiQi='"+RiQi+"',DianJi=0,Category='"+Category+"',ShanChu=0 where BH="+rs(0);} else{sql="insert into Article values("+BH+",'"+Title+"','"+Content+"','"+Keywords+"','"+URL+"','"+RiQi+"',0,'"+Category+"',0)";} rs.Close(); if(Session("d7fabb5d7")=="User"||Session("d7fabb5d7")=="Admin") conn.Execute(sql);} if(Request.QueryString("do")+""=="modify"&&Session("d7fabb5d7")=="Admin"){ if(Request.Form("BH")+""!="undefined"){ Title=Request.Form("Title")+""; Category=Request.Form("Category")+""; Content=Request.Form("Content")+""; Keywords=Request.Form("Keywords")+""; URL=Request.Form("URL")+""; Title=Title.replace(/'/g,"''"); Category=Category.replace(/'/g,"''"); Content=Content.replace(/'/g,"''"); Content=Content.replace(/\r/g,"
"); Keywords=Keywords.replace(/'/g,"''"); URL=URL.replace(/'/g,"''"); RiQi=new Date(); Nian=RiQi.getYear(); Yue=RiQi.getMonth()+1; /*************Content=Content.replace(/ /g," ");*************/ if(Yue<10) Yue="0"+Yue; Ri=RiQi.getDate(); if(Ri<10) Ri="0"+Ri; RiQi=Nian+"-"+Yue+"-"+Ri+"-"; sql="Update Article set Title='"+Title+"',Content='"+Content+"',Keywords='"+Keywords+"',URL='"+URL+"',RiQi='"+RiQi+"',Category='"+Category+"' where BH="+Request.Form("BH"); conn.Execute(sql);} else{%>

modify article

<%sql="select * from Article where BH="+Request.QueryString("BH"); rs.Open(sql,conn); BH=rs(0)+""; Title=rs(1)+""; Content=rs(2)+""; Keywords=rs(3)+""; URL=rs(4)+""; Category=rs(7)+""; rs.Close(); Title=Title.replace("/g,"); Content=Content.replace(/ \n/g,"\r\n");%> ?action=manage&do=modify method=post>> articletitle suoshucategory selectcategory <%sql="Select distinct Category from Article where ShanChu=0"; rs.Open(sql,conn); while(!rs.eof){%><%=rs(0)%> <%rs.MoveNext();} rs.Close();%> detail/content <%=Content%> Keywords url >

<%} }%>

>back home articlemanage <%if(Session("d7fabb5d7")=="Admin"){%> ?action=user>usermanage ?action=setting>copyrightsetting <%}%> ?action=login>logout

(clicktitlemodify article) addarticle <%sql="select BH,Title,ShanChu from Article order by RiQi DESC"; rs.open(sql,conn,1); rs.pagesize=17; page=parseInt(Request.QueryString("yema")); if(isNaN(page)||page<1) page=1; if(page>rs.pagecount) page=rs.pagecount; if(rs.eof){Response.Write("curr , no any article.");} else{ rs.absolutepage=page; for(C=0;C <%rs.MoveNext(); if(rs.eof) break;}} pagecount=rs.pagecount; recordcount=rs.recordcount; rs.Close();%> @ ?action=manage&do=modify&BH=<%=rs(0)%>><%=rs(1)%> <%if(rs(2)==0){%>?action=manage&do=delete&BH=<%=rs(0)%>>delete<%} else{%>?action=manage&do=huifu&BH=<%=rs(0)%>>huifu<%}%> <%if(page>1){%>[?action=manage>index] [?action=manage&yema=<%=page-1%>>Previous Page] <%}%><%if(page!=pagecount){%>[?action=manage&yema=<%=page+1%>>Next Page] [?action=manage&yema=<%=pagecount%>>last] <%}%>jump to <%if(pagecount==0) pagecount=1; for(C=1;C<=pagecount;C++){%>><%=C%> <%}%> page.(total <%=recordcount%> recodes)

addarticle
?action=manage&do=add method=post> articletitle suoshucategory selectcategory <%sql="Select distinct Category from Article where ShanChu=0"; rs.Open(sql,conn); while(!rs.eof){%><%=rs(0)%> <%rs.MoveNext();} rs.Close();%> detail/content auther url >

<%break; /*********** useraction **************/ case "user": FangFa=Request.Form("TiJiao")+""; if(FangFa=="add"&&Session("d7fabb5d7")=="Admin"){ sql="Select count(*) from User"; rs.open(sql,conn); BH=rs(0)+""; rs.Close(); YongHu=Request.Form("YongHu"); MiMa=Request.Form("MiMa"); QuanXian=Request.Form("QuanXian"); ShanChu=Request.Form("ShanChu"); sql="insert into User values("+BH+",'"+YongHu+"','"+MiMa+"',"+QuanXian+","+ShanChu+")"; conn.Execute(sql);} if(FangFa=="save"&&Session("d7fabb5d7")=="Admin"){ BH=Request.Form("BH"); YongHu=Request.Form("YongHu"); MiMa=Request.Form("MiMa"); QuanXian=Request.Form("QuanXian"); ShanChu=Request.Form("ShanChu"); sql="update User set YongHu='"+YongHu+"',MiMa='"+MiMa+"',QuanXian="+QuanXian+",ShanChu="+ShanChu+" where BH="+BH; conn.Execute(sql);}%>

>back home ?action=manage>articlemanage <%if(Session("d7fabb5d7")=="Admin"){%> usermanage ?action=setting>copyrightsetting <%}%> ?action=login>logout

?action=user method=post onsubmit="return confirm('Are You sure to adduser '+YongHu.value+' £¿\n\n(added ,and no delete.)')"> <%sql="Select * from User order by BH desc"; if(Session("d7fabb5d7")=="Admin"){ rs.open(sql,conn); while(!rs.eof){%> ?action=user method=post>> <%rs.MoveNext();} rs.Close();}%> usermanage user: passwd: commonuser manager active deactive user:> passwd:> commonuser style="background:abcdef">manager active style="background:fedcba">deactive

<%break; /*********** copyrightsetting **************/ case "setting": TiJiao=Request.Form("TiJiao")+""; if(Session("d7fabb5d7")=="Admin"&&TiJiao=="save"){ BlogName=Request.Form("ZhanMing")+""; BlogURL=Request.Form("BlogURL"); YeTou=Request.Form("YeTou"); YeWei=Request.Form("YeWei"); sql="update Copyright set ZhanMing='"+BlogName+"',BlogURL='"+BlogURL+"',YeTou='"+YeTou+"',YeWei='"+YeWei+"'"; conn.Execute(sql); Response.Write("");}%>

>back home ?action=manage>articlemanage <%if(Session("d7fabb5d7")=="Admin"){%> ?action=user>usermanage copyrightsetting <%}%> ?action=login>logout

?action=setting method=post> copyrightsetting site name:> address: size=30> YeTou:<%=YeTou%> YeWei:<%=YeWei%>

<%break; /*********** default **************/ default: ID=parseInt(Request.QueryString("ID")); if(!isNaN(ID)){%>
<%sql="select * from Article where ShanChu=0 and BH="+ID; rs.Open(sql,conn); if(!rs.eof){sql="update Article set DianJi=DianJi+1 where BH="+ID; conn.Execute(sql);%>

<%=rs(1)%>

date:<%=rs(5)%>
><%=rs(3)%>

<%=rs(2)%>

<%} else{Response.Write("error: can't find this ID, or This file was deleted.");} Category=""+rs(7); rs.Close();%>