<%=body%>
<% conn.close set conn=nothing end if sub savemsg() dim sendtime,sender sendtime=Now() sender=Forum_info(0) set rs = server.CreateObject ("adodb.recordset") select case request("stype") case 1 sql="select username from online where userid>0" rs.open sql,conn,1,1 do while not rs.eof sql="insert into message(incept,sender,title,content,sendtime,flag,issend) values('"&rs(0)&"','"&sender&"','"&TRim(Request("title"))&"','"&Trim(Request("message"))&"',Now(),0,1)" conn.Execute(sql) rs.movenext loop rs.close case 2 sql = "select username from [user] where usergroupid=8 order by userid desc" rs.Open sql,conn,1,1 do while not rs.EOF sql="insert into message(incept,sender,title,content,sendtime,flag,issend) values('"&rs(0)&"','"&sender&"','"&TRim(Request("title"))&"','"&Trim(Request("message"))&"',Now(),0,1)" conn.Execute(sql) rs.MoveNext Loop rs.Close case 3 sql = "select username from [user] where usergroupid=3 order by userid desc" rs.Open sql,conn,1,1 do while not rs.EOF sql="insert into message(incept,sender,title,content,sendtime,flag,issend) values('"&rs(0)&"','"&sender&"','"&TRim(Request("title"))&"','"&Trim(Request("message"))&"',Now(),0,1)" conn.Execute(sql) rs.MoveNext Loop rs.Close case 4 sql = "select username from [user] where usergroupid=1 order by userid desc" rs.Open sql,conn,1,1 do while not rs.EOF sql="insert into message(incept,sender,title,content,sendtime,flag,issend) values('"&rs(0)&"','"&sender&"','"&TRim(Request("title"))&"','"&Trim(Request("message"))&"',Now(),0,1)" conn.Execute(sql) rs.MoveNext Loop rs.Close case 5 sql = "select username from [user] where usergroupid<4 order by userid desc" rs.Open sql,conn,1,1 do while not rs.EOF sql="insert into message(incept,sender,title,content,sendtime,flag,issend) values('"&rs(0)&"','"&sender&"','"&TRim(Request("title"))&"','"&Trim(Request("message"))&"',Now(),0,1)" conn.Execute(sql) rs.MoveNext Loop rs.Close case 6 sql = "select username from [user] order by userid desc" rs.Open sql,conn,1,1 do while not rs.EOF sql="insert into message(incept,sender,title,content,sendtime,flag,issend) values('"&rs(0)&"','"&sender&"','"&TRim(Request("title"))&"','"&Trim(Request("message"))&"',Now(),0,1)" conn.Execute(sql) rs.MoveNext Loop rs.Close end select set rs=nothing body=body+"| 论坛短信管理 | |
|---|---|
| 批量删除 |