| Author |
 Topic  |
|
|
luca.inno
Starting Member
9 Posts |
 Posted - 01 June 2001 : 09:21:14
|
How can I do it? Will forum still work if I do it?
Luca - Milan |
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 01 June 2001 : 10:35:23
|
why do you not go in as admin and bin them?
|
 |
|
|
luca.inno
Starting Member
9 Posts |
Posted - 01 June 2001 : 12:27:18
|
Sorry, what does "bin" mean?
I'm from Milan, be patient 
Luca - Milan |
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 01 June 2001 : 15:12:55
|
...and I'm from the US. What does bin mean?  I'd like to be able to accomplish the same thing.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 June 2001 : 15:28:53
|
ummm, he meant to click the rubbish 'bin' icon beside each posts you want to delete in the forum, when logged in as admin.
|
|
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 01 June 2001 : 16:04:36
|
|
|
|
|
luca.inno
Starting Member
9 Posts |
Posted - 02 June 2001 : 05:29:19
|
Should I cancel messages using the proper function? Isn't it?
Well, how much time does it take? I'm looking for a faster solution .... if exsists, of course.
Bye
Luca - Milan |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 02 June 2001 : 07:23:53
|
You could just write an SQL statement that looks something like this:
delSQL = DELETE FROM FORUM_TOPICS WHERE((FORUM_TOPICS.T_DATE)<"2001050100000000")
my_conn.Execute delSQL
That would delete all the original posts prior to 1 May 2001, then you'd have to delete all the replies:
delSQL = DELETE FROM FORUM_REPLY WHERE((FORUM_REPLY.R_DATE)<"2001050100000000")
my_conn.Execute delSQL
and something like that would delete all replies prior to 1 May 2001
I haven't tested this, so I'd wait for someone else to "agree" with me before you used it
<-- Eric -->
http://insidewaco.com/forum/home.asp |
|
|
|
luca.inno
Starting Member
9 Posts |
Posted - 05 June 2001 : 05:42:07
|
Does it work?
Other ideas?
Luca - Milan |
|
|
|
KC
Junior Member
USA
152 Posts |
Posted - 13 June 2001 : 17:54:54
|
This looks to be the right topic from my search.
Is there a proven code snipet I can add to have the Forum automaticly delete and topic (including associated posts) that has not been added to (or even viewed) in say 30 days?
Please respond to SnitzHelp@vales.com
Thanks in advance.
KC Vale
|
|
|
|
backspace
Starting Member
1 Posts |
Posted - 15 June 2001 : 08:41:11
|
e3stone: how about if I have an original topic starts from Jan 01, 2001, and I have
an reply on June 6, 2001? you code might
not work.
so I would suggest to get the topic_id first,
then delete its replies based on topic_id,
not date. Anyone can write the code?
|
|
|
| |
Topic |
|
Topic Locked
