admin_news.asp

joekoe cms2.0 sql破解版

<!-- #include file="include/admin_onlogin.asp" -->
<%
'****************************************************
' Joekoe CMS 2.0      Power by Joekoe.com
' Email: [e-mail] , [e-mail]
' Web: http://www.joekoe.com , http://www.topv.com
' Copyright (C) 2004 Joekoe.com All Rights Reserved.
'****************************************************

del_user_true=true
del_upload_true=true
index_url="{$clone_index_url}"
put_uppath=index_url
call admin_master(1,0)
call admin_cid_sid()
call admin_header(0,0)
select case jk_mod
case "istop"
  ntit="推荐"&tit_fir
  sql_add="hidden=1 and istop=1"
case "sh"
  ntit="待审核"&tit_fir
  sql_add="hidden=0"
case else
  jk_mod=""
  ntit=tit_fir&"列表"
  sql_add="hidden=1"
end select
%>
<tr><td align=center colspan=2 height=30>
  <table border=0>
  <tr>
  <td><a href='?'><%response.write tit_fir%>列表</a></td>
  <td width=10></td>
  <td><a href='?jk_mod=istop'<%if jk_mod="istop" then response.write " class=red"%>>推荐<%response.write tit_fir%></a></td>
  <td width=10></td>
  <td><a href='?jk_mod=sh'<%if jk_mod="sh" then response.write " class=red"%>>待审核<%response.write tit_fir%></a></td>
  <td width=10></td>
  <td><a href='?action=add&c_id=<%response.write cid%>&s_id=<%response.write sid%>'<%if action="add" then response.write " class=red"%>>添加<%response.write tit_fir%></a></td>
<%call joekoe_is_nsort_review()%>
  </tr>
  </table>
</td></tr>
<tr><td colspan=2 align=center>
  <table border=0 cellspacing=0 cellpadding=2>
  <form action='?' method=get>
  <input type=hidden name=jk_mod value='<%response.write jk_mod%>'>
  <input type=hidden name=c_id value='<%response.write cid%>'>
  <input type=hidden name=s_id value='<%response.write sid%>'>
  <tr>
  <td>搜索（<%response.write ntit%>） 关键字：</td>
  <td><input type=text name=keyword value='<%response.write joekoe_cms.code_query("keyword")%>' size=15 maxlength=20></td>
  <td><select name=sea_type size=1>
<option value='topic'>按标题</option>
<option value='username'>按发布人</option>
</select></td>
  <td><select name=sea_term sizs=1><option value='all'>满足所有条件</option><option value='only'>满足一个条件</option></seelct></td>
  <td><input type=submit value='搜索'></td>
  </tr>
  </form>
  </table>
</td></tr>
</table>
<%
call admin_table(1)

if action="handle" then call joekoe_go_handle()

select case action
case "add"
  call joekoe_chk_add()
case "edit"
  call joekoe_chk_edit()
case else
  call joekoe_chk_main()
end select

call admin_ender(1)

sub joekoe_chk_edit()
  dim topic,keyes,comto,username,tim,counter,istop,hidden,pic,ispic,word
  call admin_td("编辑"&tit_fir)
  sql="select top 1 * from "&data_name&" where id="&id
  call joekoe_cms.exe_conn(rs,sql,3)
  if rs.eof then
    rs.close
    call admin_msg(tit_fir&"ID（"&id&"）不存在！","?",1)
    exit sub
  end if
  if chk() then
    topic=joekoe_cms.code_admin("topic",1,40)
    word=joekoe_cms.code_remark("word")
    csid=joekoe_cms.code_form("c_id")
    if cs_nd(csid)=false then
      rs.close
      call admin_error("请选择 "&tit_fir&"类型 ！")
      exit sub
    end if
    if topic="" or word="" then
      rs.close
      call admin_error(tit_fir&"标题 和 "&tit_fir&"内容 不能为空！")
      exit sub
    end if
    keyes=joekoe_cms.code_admin("keyes",1,20)
    comto=joekoe_cms.code_admin("comto",1,10)
    username=get_form_username()
    tim=get_form_tim()
    pic=joekoe_cms.code_admin("pic",1,200)
    ispic=true
    if pic="" then ispic=false
    counter=joekoe_cms.code_int("counter",1)
    istop=0
    if joekoe_cms.code_form("istop")="yes" then istop=1
    hidden=true
    if joekoe_cms.code_form("hidden")="yes" then hidden=false
    call chk_cid_sid()
    rs("c_id")=cid
    rs("s_id")=sid
    rs("cod")=cod_type()
    rs("topic")=topic
    rs("comto")=comto
    rs("username")=username
    rs("tim")=tim
    rs("counter")=counter
    rs("istop")=istop
    rs("hidden")=hidden
    rs("keyes")=keyes
    rs("pic")=pic
    rs("ispic")=ispic
    rs("word")=word
    rs.update
    rs.close
    call joekoe_cms.upload_note(index_url,id)
    call admin_msg("已成功编辑了一条"&tit_fir&"！","?jk_mod="&jk_mod&"&c_id="&cid&"&s_id="&sid,0)
    exit sub
  end if
  call form_first()
  cid=rs("c_id")
  sid=rs("s_id")
  pic=rs("pic")
  ispic=joekoe_cms.apart_filename(pic,1,"/")
  if ispic="" then ispic=joekoe_cms.rand_file(index_url)
%>
<form name=add_frm action='?jk_mod=<%response.write jk_mod%>&c_id=<%response.write cid%>&s_id=<%response.write sid%>&action=edit&id=<%response.write id%>' method=post>
<input type=hidden name=chk value='yes'>
<input type=hidden name=upid value=''>
<tr>
<td<%response.write dd1%>><%response.write tit_fir%>标题：</td>
<td<%response.write dd2%>><input type=text name=topic value='<%response.write rs("topic")%>' size=60 maxlength=40><%response.write redx%></td>
</tr>
<tr>
<td><%response.write tit_fir%>分类：</td>
<td><%call chk_csid(nsort,cid,sid)%></td>
</tr>
<tr>
<td><%response.write tit_fir%>关键字：</td>
<td><%call frm_keyes(rs("keyes"))%></td>
</tr>
<tr>
<td><%response.write tit_fir%>出处：</td>
<td><input type=text name=comto value='<%response.write rs("comto")%>' size=20 maxlength=10>&nbsp;&nbsp;<%response.write tit_fir%>发布人：<input type=text name=username value='<%response.write rs("username")%>' size=20 maxlength=20></td>
</tr>
<tr>
<td>发布时间：</td>
<td><input type=text name=tim value='<%response.write rs("tim")%>' size=20 maxlength=20>&nbsp;&nbsp;浏览&nbsp;<input type=text name=counter value='<%response.write rs("counter")%>' size=6 maxlength=10>&nbsp;人次&nbsp;&nbsp;推荐：<input type=checkbox name=istop value='yes'<%if rs("istop")=true then response.write " checked"%>>&nbsp;&nbsp;&nbsp;&nbsp;隐藏/审核：<input type=checkbox name=hidden value='yes'<%if rs("hidden")=false then response.write " checked"%>></td>
</tr>
<%call html_edit(rs("cod"),"add_frm","word","")%>
<tr>
<td valign=top><%response.write tit_fir%>内容：<%call put_pagecute()%></td>
<td><textarea name=word rows=15 cols=65><%response.write joekoe_cms.code_word(rs("word"))%></textarea></td>
</tr>
<tr>
<td><%response.write tit_fir%>图片：</td>
<td><input type=text name=pic value='<%response.write pic%>' size=40 maxlength=100>&nbsp;&nbsp;&nbsp;<a href='upload.asp?uptype=pic&uppath=<%response.write index_url%>&upname=<%response.write ispic%>&uptext=pic' target=upload_frame>上传图片</a>&nbsp;&nbsp;<a href='upload.asp?uppath=<%response.write index_url%>&upname=<%response.write left(index_url,1)%>&uptext=word' target=upload_frame>上传至内容</a></td>
</tr>
<tr>
<td>上传图片：</td>
<td><iframe frameborder=0 name=upload_frame width='100%' height=30 scrolling=no src='upload.asp?uptype=pic&uppath=<%response.write index_url%>&upname=<%response.write ispic%>&uptext=pic'></iframe></td>
</tr>
<%
  call submit_edit()
  rs.close
end sub

sub joekoe_chk_add()
  dim topic,keyes,comto,username,tim,counter,istop,hidden,pic,ispic,word
  call admin_td("添加"&tit_fir)
  if chk() then
    topic=joekoe_cms.code_admin("topic",1,40)
    word=joekoe_cms.code_remark("word")
    csid=joekoe_cms.code_form("c_id")
    if cs_nd(csid)=false then
      call admin_error("请选择 "&tit_fir&"类型 ！")
      exit sub
    end if
    if topic="" or word="" then
      call admin_error(tit_fir&"标题 和 "&tit_fir&"内容 不能为空！")
      exit sub
    end if
    keyes=joekoe_cms.code_admin("keyes",1,20)
    comto=joekoe_cms.code_admin("comto",1,10)
    username=get_form_username()
    tim=get_form_tim()
    pic=joekoe_cms.code_admin("pic",1,200)
    ispic=true
    if pic="" then ispic=false
    counter=joekoe_cms.code_int("counter",1)
    istop=0
    if joekoe_cms.code_form("istop")="yes" then istop=1
    hidden=true
    if joekoe_cms.code_form("hidden")="yes" then hidden=false
    call chk_cid_sid()
    sql="select * from "&data_name
    call joekoe_cms.exe_conn(rs,sql,3)
    rs.addnew
    rs("c_id")=cid
    rs("s_id")=sid
    rs("cod")=cod_type()
    rs("topic")=topic
    rs("comto")=comto
    rs("username")=username
    rs("tim")=tim
    rs("counter")=counter
    rs("istop")=istop
    rs("hidden")=hidden
    rs("keyes")=keyes
    rs("pic")=pic
    rs("ispic")=ispic
    rs("word")=word
    rs.update
    rs.close
    call joekoe_cms.upload_note(index_url,joekoe_cms.first_id(data_name,"id"))
    call admin_msg("已成功添加了一条"&tit_fir&"！","?jk_mod="&jk_mod&"&c_id="&cid&"&s_id="&sid,0)
    exit sub
  end if
  call form_first()
  ispic=joekoe_cms.rand_file(index_url)
%>
<form name=add_frm action='?jk_mod=<%response.write jk_mod%>&action=add' method=post>
<input type=hidden name=chk value='yes'>
<input type=hidden name=upid value=''>
<tr>
<td<%response.write dd1%>><%response.write tit_fir%>标题：</td>
<td<%response.write dd2%>><input type=text name=topic size=60 maxlength=40><%response.write redx%></td>
</tr>
<tr>
<td><%response.write tit_fir%>分类：</td>
<td><%call chk_csid(nsort,cid,sid)%></td>
</tr>
<tr>
<td><%response.write tit_fir%>关键字：</td>
<td><%call frm_keyes("")%></td>
</tr>
<tr>
<td><%response.write tit_fir%>出处：</td>
<td><input type=text name=comto size=20 maxlength=10>&nbsp;&nbsp;<%response.write tit_fir%>发布人：<input type=text name=username value='<%response.write login_username%>' size=20 maxlength=20></td>
</tr>
<tr>
<td>发布时间：</td>
<td><input type=text name=tim value='<%response.write joekoe_cms.now_time%>' size=20 maxlength=20>&nbsp;&nbsp;浏览&nbsp;<input type=text name=counter value='0' size=6 maxlength=10>&nbsp;人次&nbsp;&nbsp;推荐：<input type=checkbox name=istop value='yes'>&nbsp;&nbsp;&nbsp;&nbsp;隐藏/审核：<input type=checkbox name=hidden value='yes'></td>
</tr>
<%call html_edit(2,"add_frm","word","")%>
<tr>
<td valign=top><%response.write tit_fir%>内容：<%call put_pagecute()%></td>
<td><textarea name=word rows=15 cols=65></textarea></td>
</tr>
<tr>
<td><%response.write tit_fir%>图片：</td>
<td><input type=text name=pic value='<%response.write pic%>' size=40 maxlength=100>&nbsp;&nbsp;&nbsp;<a href='upload.asp?uptype=pic&uppath=<%response.write index_url%>&upname=<%response.write ispic%>&uptext=pic' target=upload_frame>上传图片</a>&nbsp;&nbsp;<a href='upload.asp?uppath=<%response.write index_url%>&upname=<%response.write left(index_url,1)%>&uptext=word' target=upload_frame>上传至内容</a></td>
</tr>
<tr>
<td>上传图片：</td>
<td><iframe frameborder=0 name=upload_frame width='100%' height=30 scrolling=no src='upload.asp?uptype=pic&uppath=<%response.write index_url%>&upname=<%response.write ispic%>&uptext=pic'></iframe></td>
</tr>
<%
  call submit_add()
end sub

sub joekoe_chk_main()
  dim topic,pageurl2
  pageurl2=pageurl
  call sql_cid_sid(sql_add)
  call admin_search("topic","topic,username")
%>
<tr valign=top align=center>
<td<%response.write dd1%>>
  <table class=table2>
  <tr><td><%response.write img_admin("s_left_sort","")%> <a href='?jk_mod=<%response.write jk_mod%>'><%response.write ntit%></a></td></tr>
  <tr><td height=5></td></tr>
  <tr><td class=htd><%call left_sort(pageurl2,"")%></td></tr>
  </table>
</td>
<td<%response.write dd2%>>
  <table cellspacing=1 cellpadding=3 class=table0>
<form name=sel_form action='?jk_mod=<%response.write jk_mod%>&action=handle&c_id=<%response.write cid%>&s_id=<%response.write sid%>' method=post>
<tr align=center>
<td class=td width='7%'>序号</td>
<td class=td width='66%'><%response.write tit_fir%>标题及整理时间<%if keyword<>"" then response.write "（搜索结果："&keyword&"）"%></td>
<td class=td width='22%'>相关属性</td>
<td class=td width='5%'><input type=checkbox name=sel_all value='yes' onclick="javascript:select_all(this.form);"></td>
</tr>
<%
  set obj=server.createobject("Joekoe_CMS_2.CMS_PageCute")
  obj.pageurl=pageurl
  obj.nummer=nummer
  obj.page_t=1
  obj.page_p=8
  obj.page_unit="条"
  obj.page_tit=tit_fir
  obj.v_id="id"
  call obj.p_init("id,topic,ispic,tim,istop,hidden,cod",data_name,sql_add,"id desc")
  sql=obj.sql_count
  set rs=joekoe_cms.exec(sql,1)
  obj.rssum=rs(0)
  rs.close
  call obj.p_main()
  sql=obj.sql_master
  call joekoe_cms.exe_conn(rs,sql,1)
  for i=1 to obj.page_num
    id=rs("id")
    topic=rs("topic")
%>
<tr align=center>
<td class=tims><a href='<%response.write index_url%>_view.asp?id=<%response.write id%>' target=_blank><%response.write obj.page_now+i%></a></td>
<td>
  <table border=0 cellspacing=0 cellpadding=0 width='100%'>
  <tr>
  <td><a href='?jk_mod=<%response.write jk_mod%>&action=edit&id=<%response.write id%>'><%response.write joekoe_cms.code_html(topic,1,(18+tnum))%></a></td>
  <td align=right><font class=tims><%response.write joekoe_cms.time_type(rs("tim"),4)%></font></td>
  </tr>
  </table>
</td>
<td align=left><%response.write pro_edit("?jk_mod="&jk_mod&"&action=edit&id="&id,"编辑该"&tit_fir) &"&nbsp;"& pro_hidden(rs("hidden"),1) &"&nbsp;"& pro_cod(rs("cod")) &"&nbsp;"& pro_istop(rs("istop")) &"&nbsp;"& pro_ispic(rs("ispic"))%></td>
<td><input type=checkbox name=sel_id value='<%response.write id%>'></td>
</tr>
<%
    rs.movenext
  next
  rs.close
%>
<tr class=tr1>
<td colspan=2>
  <table border=0>
  <tr class=tr1>
  <td></td>
  <td><%response.write obj.page_var%></td>
  <td width=3></td>
  <td>分页：</td>
  <td><%response.write obj.page_cute%></td>
  </tr>
  </table>
</td>
<td colspan=2 align=center>
执行
<select name=sel_type size=1>
<option value='推荐'>推荐</option>
<option value='取消推荐'>取消推荐</option>
<option value='审核'>审核</option>
<option value='待审核'>待审核</option>
<option value='删除'>删除</option>
</select>
<input type=submit value='操作' onclick="return sel_click(this.form);">
</td>
</tr>
</form>
  </table>
</td>
</tr>
<%
end sub

'****************************************************
' Joekoe CMS 2.0      Power by Joekoe.com
' Email: [e-mail] , [e-mail]
' Web: http://www.joekoe.com , http://www.topv.com
' Copyright (C) 2004 Joekoe.com All Rights Reserved.
'****************************************************
%>