<!--#include file="../conn/conn.asp"-->
<!--#include file="../conn/nosql.asp"-->
<!--#include file="../conn/config.asp"-->
<!--#include file="../conn/page.asp"-->
<%if Not ChkPosturl then response.redirect ("login.asp")
if session("adminname")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='login.asp';</script>"
response.End
end if
if isChkInteger(request("id")) then
id=request("id")
else
Response.Redirect ("../index.asp")
end if
if id="" then 
response.write "<script language='javascript'>"
response.write "alert('您没还有登录，请登录后再访问本页！');"
response.write"this.location.href='/index.asp';</SCRIPT>"
response.end
end if
sql="select * from snsn_user where id="&id
Set rs= Server.CreateObject("ADODB.Recordset") 
rs.open sql,conn,1,1
if rs.eof or rs.bof then
response.write "<script language='javascript'>"
response.write "alert('没有此用户，请确认后或联系管理员再访问本页！');"
response.write"this.location.href='/index.asp';</SCRIPT>"
response.end
else
conn.execute "delete from snsn_getprice where sendcid in ("&id&")"
conn.execute "delete from snsn_getprice1 where sendcid in ("&id&")"
conn.execute "delete from snsn_count where userid in ("&id&")"
conn.execute "delete from snsn_guestbook where userid in ("&id&")"
conn.execute "delete from snsn_bbs where userid in ("&id&")"
conn.execute "delete from snsn_Diary where userid in ("&id&")"
conn.execute "delete from snsn_bbs_class where userid in ("&id&")"
conn.execute "delete from snsn_Diary_class where userid in ("&id&")"
conn.execute "delete from snsn_xd_class where userid in ("&id&")"
conn.execute "delete from snsn_xd where userid in ("&id&")"
conn.execute "delete from snsn_user1 where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_myfriend where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_yhfy where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_yhbm where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_yh where fquser in ('"&rs("username")&"')"
conn.execute "delete from snsn_xy where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_mini_msn where fren in ('"&rs("username")&"')"
conn.execute "delete from snsn_uppic where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_uppic_class where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_Shoucang where u_id in ("&id&")"
conn.execute "delete from mini_give where from1 in ("&id&")"
conn.execute "delete from mini_goods where userid in ("&id&")"
conn.execute "delete from mini_shc where userid in ("&id&")"
conn.execute "delete from mini_body where userid in ("&id&")"
conn.execute "delete from mini_qiqiu where userid in ("&id&")"
conn.execute "delete from snsn_qqshow where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_gwz where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_music where uid in ("&id&")"
conn.execute "delete from snsn_uppic_msn where fren in ('"&rs("username")&"')"
conn.execute "delete from mini_layer where userid in ("&id&")"
conn.execute "delete from snsn_guestip where username in ('"&rs("username")&"')"
conn.execute "delete from snsn_Diary_msn where userid in ("&id&")"
conn.execute "delete from snsn_xd_msn where userid in ("&id&")"
conn.execute "delete from mini_piclayer where friendid in ("&id&")"
conn.execute "delete from mini_piclayer where userid in ("&id&")"
conn.execute "delete from snsn_countfw where userid in ("&id&")"
conn.execute "delete from mini_yw where userid in ("&id&")"
conn.execute "delete from mini_gwz where userid in ("&id&")"
conn.execute "delete from snsn_minipic_msn where userid in ("&id&")"
conn.execute "delete from mini_homelayer where userid in ("&id&")"
conn.execute "delete from online where [name] in ('"&rs("username")&"')"
conn.execute "delete from snsn_hua where userid in ("&id&")"
conn.execute "delete from mini_flogood where userid in ("&id&")"
conn.execute "delete from mini_zjhome where userid in ("&id&")"
conn.execute "delete from mini_zjhome where userid in ("&id&")"
conn.execute "delete from snsn_msn where [user] in ('"&rs("username")&"')"
conn.execute "delete from snsn_msn where [yquser] in ('"&rs("username")&"')"
conn.execute "delete from mini_pr where userid in ("&id&")"
conn.execute "delete from snsn_shenri where [username] in ('"&rs("username")&"')"
conn.execute "delete from snsn_shenri where [fromname] in ('"&rs("username")&"')"
'conn.execute "delete from snsn_msnmsn where [toname] in ('"&rs("username")&"')"
'conn.execute "delete from snsn_msnmsn where [formname] in ('"&rs("username")&"')"
conn.execute "delete from snsn_friendlist where [username] in ('"&rs("username")&"')"
conn.execute "delete from snsn_friendlist where [friend_name] in ('"&rs("username")&"')"
conn.execute "delete from snsn_pay where [c_username] in ('"&rs("username")&"')"
conn.execute "delete from snsn_m_photo where poto_user_id in ("&id&")"
conn.execute "delete from snsn_m_msn where [username] in ('"&rs("username")&"')"
end if
rs.close
conn.execute "delete from snsn_user where id="&id
response.write "<script language='javascript'>"
response.write "alert('删除成功请返回！');"
response.write"this.location.href='user.asp';</SCRIPT>"
response.end
%>


						