Is there a simple Alternate MOD setup routine that will clear all the records in the FORUM_ACTIVE_USERS TABLE? I would prefer to do this instead of downloading the DB, deleting the records manually and the waiting while the db uploads.. Would this work?
[ALTER] ACTIVE_USERS DROP#AU_IP### [END]
or does the DROP remove the field intoto instead of its records?
Alternatively this code can be run from admin_home.asp 1. Save this code as deleteactiveusers.asp
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Server.ScriptTimeout = 600 ' This could take a while as the code is not very efficient!
dim conn
'Set the path to the database
sourceDB = "C:\xxxx\xxxx\xxx\xxx.mdb"
response.write ("Database: " & sourceDB & "<br>")
'Delete Active Users from Table
Set conn=Server.CreateObject("ADODB.connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & sourceDB
Set rs = conn.Execute("DELETE * FROM FORUM_ACTIVE_USERS")
response.write("The <b>Active Users</b> list has been successfully deleted<br><b>Done!</b>")
%>
<br>
<font size="-1" face="Verdana, Arial, Helvetica, sans-serif">Return to Admin Page</font> <a href="admin_home.asp"><font size="-1" face="Verdana, Arial, Helvetica, sans-serif">click here</font></a>
2. Upload file into forum directory
3. admin_home.asp approx line 144 Find: " <p><b>Other Configuration Options and Features:</b>" & vbNewLine & _ " <UL>" & vbNewLine
immediately after that add Response.Write " <LI><span class=""spnMessageText""><a href=""deleteactiveusers.asp"">Delete Active Users</a></LI>" & vbNewLine ' ######## Active Users Delete######## 4. Upload admin_home.asp
Topic Locked
Posted - 06 June 2008 : 03:49:22
