Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/56791?pagenum=1
04 November 2025, 21:28
Topic
cripto9t
Edit/Delete Post Time Limits
26 January 2005, 13:16
This mod allows Administrators and Forum Moderators to set Edit and/or Delete time limits for normal users posts.
Features:
On/Off for Edit and Delete in "Admin Options".
Individual forum time limits, set in forum properties (edit/create forum).
Time limits can be set in either minutes, hours or days.
Time limits do not apply to Administrators or Forum Moderators.
Note: This mod depends on forum time which can be adjusted in "Admin Options".
If the forum time is adjusted, it will screw-up the time limits for all prior posts.
Download: Right Click and Save
Demo: Here - Use the test forum, it's set for 2 minutes. The other forums are no limit.<
Replies ...
PeeWee.Inc
26 January 2005, 14:15
I thought/think someone has done this MOD before.
If it has been done or not dont really matter. Nice MOD and well done.<
cripto9t
26 January 2005, 15:15
Originally posted by PeeWee.Inc I thought/think someone has done this MOD before.
If it has been done or not dont really matter. Nice MOD and well done.
Thanks PeeWee.
This is the only one I've been able to find http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=39699 . I'm not sure how it works but the link to the Time Limit part is broken. I think it's an across the board time limit though.
I posted some code earlier that I can't seem to find with search, that had an across the board time limit also. That code is what I built this mod around. <
nsukz
13 February 2005, 17:32
According to cripto9t, we have to edit 7 asp files, i did exactly he said but still couldnt work out. Can anybdy help me by sending all the edited 7 asp files in my email nsukz@hotmail.co.uk. I will be very grateful.<
cripto9t
14 February 2005, 09:36
Originally posted by nsukz According to cripto9t, we have to edit 7 asp files, i did exactly he said but still couldnt work out. Can anybdy help me by sending all the edited 7 asp files in my email nsukz@hotmail.co.uk. I will be very grateful.
nsukz, the edits are marked in the sample files. Just search for "edit time" in each file to find the changes. Also I have the line numbers listed in the head notes of each file.
What sort of problem are you having?<
sorry for the off topic cripto9t....any way to get the very good weblog you've there??<
nsukz
14 February 2005, 16:55
Now im getting this error.
Your strDBType is not set, please edit your config.asp to reflect your database type.
but i referred to my config.sys 'strDBType = "sqlserver" strDBType = "access" 'strDBType = "mysql" <
rasure
14 February 2005, 17:02
Sounds as if you may have uploaded the config file from the zip file, rather than your own?<
nsukz
15 February 2005, 03:48
I edited by my self using the refrence of the config.sys inside the zip file.<
nsukz
15 February 2005, 06:50
This is my config.sys
...<
cripto9t
15 February 2005, 08:26
nsukz, those changes look alright and shouldn't have caused that error.
It sounds like the connection to your database got off somehow. You can probably get more help for that error in this forum http://forum.snitz.com/forum/forum.asp?FORUM_ID=111 .
If you made a backup copy of config.asp , you could go back to it.
I'm sorry I couldn't be of more help.
<
cripto9t
15 February 2005, 09:26
Originally posted by rabufo
sorry for the off topic cripto9t....any way to get the very good weblog you've there??
As you can probably tell by looking at the head, they arn't quite finished . I got burned out and quit on them.
I used CSS for the display and back when I made them I was only useing Internet Explorer, so they look like crap in Netscape.
But if you ignore the display, everything else works , but I'm sure there are still some minor bugs.
They are basically another forum, useing the "topics" and "reply" tables. If I remember right the only database upgrade is for the "links" (I used OneWayMules' "links manager" as a model). The calender is one I found on the net and modified a little and the archives I did from scratch.
I think I noted all the changes needed for the basic Snitz files. So if you would like the code, I can probably get them together and e-mail to you.
<
nsukz
15 February 2005, 10:32
its done. it works now. Thanks cripto9t.
Now to give edit/delete limit i went to forum properties and theres a option of mins,hrs, days or no limit. So if i put 10 minute, does this mean that users can edit or delete the topic withing 10 minutes time and after that users cannot.
<
cripto9t
15 February 2005, 12:22
Originally posted by nsukz So if i put 10 minute, does this mean that users can edit or delete the topic withing 10 minutes time and after that users cannot.
That's right. The time is based on your database server time which can be adjusted in "Admin Options".
You will have to edit each forum to set a time limit. e.g. each forum has a separate time limit. Default is no limit.
If you have any problems/questions let me know, o.k. <
rabufo
16 February 2005, 04:12
I think I noted all the changes needed for the basic Snitz files. So if you would like the code, I can probably get them together and e-mail to you.
thank you cripto, you're very kind
I'd like to install the weblogs section only (I really like the way you organize it and how it looks) without calendar, links and other mods', so I think it'll be easier to implement it.
If you want, you can send files to rabufo@libero.it
Thank you very much in advance....<
nsukz
27 March 2005, 15:26
I managed to implement edit time limit by the guides of cripto9t, but now administrator cannot delete the users, im getting this error message
"Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_PM'. Make sure it exists and that its name is spelled correctly.
/snitz/pop_delete.asp, line 654" <
withanhdammit
27 March 2005, 16:12
nsukz...no need to double post...
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=56718
h<
cripto9t
28 March 2005, 08:23
Originally posted by nsukz I managed to implement edit time limit by the guides of cripto9t, but now administrator cannot delete the users, im getting this error message
"Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_PM'. Make sure it exists and that its name is spelled correctly.
/snitz/pop_delete.asp, line 654"
nsukz, that's the private messages mod causing the error. It looks like you haven't added it to the database yet.
Do you have private messages working?
You might want to post a new topic in the Help Forum<
Doughnut
01 April 2005, 09:00
Ello, I got these erros when updating the db.... any ideas?
-2147217900 | ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column 'F_EDIT_TIME' cannot be added to table 'FORUM_FORUM' because it does not allow nulls and does not specify a DEFAULT definition. Thanks.<
cripto9t
02 April 2005, 07:50
Doughnut, I've never seen that . Anyway There should be an uninstall folder in the download. Copy the dbs file in that folder and put it in you main forum folder. Then update with that file "Uninstall Edit Time". It will remove any thing that was added in the first update. When your through delete that file in your main folder.
Now replace this line in dbs_edit_time.asp
Code:
ADD#F_EDIT_TIME#varChar(7)##
Replace it with this
Code:
ADD#F_EDIT_TIME#varChar(7)#NULL#
Then update again with "Edit Time Mod"
I think that will do it.<
Doughnut
02 April 2005, 13:04
Thanks, I'll give it a go later and let you know <
nsukz
03 April 2005, 11:06
What is Private Message?
I have added anything like PM? All i have added is "the timelimit for the message edit/delete"<
nsukz
04 April 2005, 04:48
Sorry typing mistake in above post.
What is Private Message?
I havent added anything like PM? All i have added is "the timelimit for the message edit/delete"<
cripto9t
04 April 2005, 10:19
nsukz, find this code and remove it.
Code:
'## Forum_SQL - Delete Private Messages that the user has sent or received strSql = "DELETE FROM " & strTablePrefix & "PM " strSql = strSql & " WHERE " & strTablePrefix & "PM.M_TO = " & Member_ID strSql = strSql & " OR " & strTablePrefix & "PM.M_FROM = " & Member_ID
my_Conn.Execute(strSql)
The reference files in the download contain the private messages mod and probably a few others. That's why you should always back-up your original files and make the code changes instead of overwriting your files with the reference files.
If you are using the other files in the download you may run into other problems.<
Doughnut
04 April 2005, 13:37
Originally posted by cripto9t
Now replace this line in dbs_edit_time.asp
Code:
ADD#F_EDIT_TIME#varChar(7)##
Replace it with this
Code:
ADD#F_EDIT_TIME#varChar(7)#NULL#
Then update again with "Edit Time Mod"
I think that will do it.
I think that did the trick mate...
I did get an error but I think it's just because something is being duplicated is that right?
-2147217873 | Cannot insert duplicate key row in object 'FORUM_CONFIG_NEW' with unique index 'C_VARIABLE'. Thanks..<
cripto9t
04 April 2005, 14:50
Originally posted by Doughnut
I did get an error but I think it's just because something is being duplicated is that right?
-2147217873 | Cannot insert duplicate key row in object 'FORUM_CONFIG_NEW' with unique index 'C_VARIABLE'. Thanks..
That's what it sounds like. The uninstall was supposed to delete those variables in config_new, but maybe it didn't work.
Anyway the mod won't work without them . If you want to make sure they are there, you can look in "admin options > forum variables" for "STREDITTIME" and "STRDELETETIME". They will be listed there along with thier settings.<
Doughnut
04 April 2005, 14:54
Yea they are there, thanks!
It's a good addition as it goes, something I'd been looking for <
Doughnut
06 April 2005, 05:05
Ello again, Getting a bit of an error from a few people..
Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'split'
/forum/post.asp, line 304 When I try to reproduce this with an ordinary acount I can't so I'm not sure why they're getting it, it doesn;t seem to be in all sections.
Any ideas?
Thanks..........<
Doughnut
06 April 2005, 05:07
This is line 304 by the way; arrEditTime = split(rs("F_EDIT_TIME"),"|") Thanks...<
cripto9t
06 April 2005, 07:45
Try this Doughnut change this line, its just above line 304
Code:
if (rs.EOF or rs.BOF) or trim(rs("F_EDIT_TIME")) = "" or then
to this
Code:
if (rs.EOF or rs.BOF) or (trim(rs("F_EDIT_TIME")) = "") or (isNull(rs("F_EDIT_TIME"))) then
Probably have to do the same for delete.
<
cripto9t
06 April 2005, 08:21
Yea, if that works, you'll need to make the same code change in pop_delete.asp.
My line number is 732.
I think that will do it for the null setting.
Sorry about the errors, I'm going to do some testing this morning with these changes. Let me know what happens, I want to update the download. If your members still get errors, you can turn this off in "admin options".<
Doughnut
06 April 2005, 08:43
That works
Not too sure about the delete bit though, just testing it!<
cripto9t
06 April 2005, 10:29
Originally posted by Doughnut That works
Not too sure about the delete bit though, just testing it!
That's good .
To test you need to be signed in as an ordinary member (no admin or mod) and edit or delete a topic in a forum that has not had a time limit set yet (time limit is still "Null").<
Doughnut
06 April 2005, 11:13
Originally posted by cripto9t
To test you need to be signed in as an ordinary member (no admin or mod) and edit or delete a topic in a forum that has not had a time limit set yet (time limit is still "Null").
It's a weird thing but that is how I was testing it but I couldn't reproduce the error, I got the people complaining about the problems to test it for me after the changes were made (your adjusted code) and it's fine now.... just waiting for em to get back to me on the delete side of things.
Looks good so far <
Doughnut
06 April 2005, 12:24
Ayyyeee all works perfectly now!
Thanks cripto <
cripto9t
06 April 2005, 14:17
Your welcome
If have any more problems with it let me know.
I'm going to try to update the download with these changes today.<
cripto9t
06 April 2005, 14:32
Originally posted by Doughnut It's a weird thing but that is how I was testing it but I couldn't reproduce the error
I thought things like that only happened to me .<
Doughnut
06 April 2005, 19:27
Seems to happen to me all the time <
tribaliztic
19 April 2005, 12:42
worked like a charm. Thanks alot!
<
cripto9t
20 April 2005, 07:03
Originally posted by tribaliztic worked like a charm. Thanks alot!
I tried this mod exactely but when i go to edit a topic to set the time limit it gives me this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Unknown column 'F_EDIT_TIME' in 'field list'
/forum/post.asp, line 461
this is the post.asp page strSql = "SELECT F_SUBJECT, F_URL, F_PRIVATEFORUMS, F_PASSWORD_NEW, F_EDIT_TIME," & _ "F_DEFAULTDAYS, F_COUNT_M_POSTS, F_SUBSCRIPTION, F_MODERATION, F_DESCRIPTION " & _ " FROM " & strTablePrefix & "FORUM " & _ " WHERE FORUM_ID = " & strRqForumId
(line 461) set rs = my_Conn.Execute (strSql)
i dont use access but mysql
why?
<
Shaggy
30 August 2005, 09:57
Did you run the dbs file for this mod as per the readme?
<
Glisborg
19 February 2006, 16:39
I get this error when I try to edit a post now: Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'split'
/Forum/post.asp, line 278
What is wrong????<
Glisborg
19 February 2006, 16:43
It seems like this error only comes in forums that has no limit set.<
cripto9t
20 February 2006, 08:15
Originally posted by cripto9t Try this Doughnut change this line, its just above line 304
Code:
if (rs.EOF or rs.BOF) or trim(rs("F_EDIT_TIME")) = "" then
to this
Code:
if (rs.EOF or rs.BOF) or (trim(rs("F_EDIT_TIME")) = "") or (isNull(rs("F_EDIT_TIME"))) then
Probably have to do the same for delete.
This should fix it. There are two places in post.asp with this line that need to be changed.
oops, 1 place in post.asp and 1 place in pop_delete.asp. I'm sorry I thought I fixed the zip.<
cripto9t
20 February 2006, 09:19
Glisborg, I just updated the download. It seems code changes were made in my personal files but not the download. I see my test forum is down also. If it's not one thing it's another .<
cripto9t
20 February 2006, 09:56
The test site is back up if anyone is interested. I think edit time is set for 2 minutes.<
jiffy
06 March 2006, 12:01
Can you create a web link with this mod? I added a time edit mod and now I can't create a web link since there is no time value associated with it.<
jiffy
06 March 2006, 12:08
This is the error I get: Microsoft JET Database Engine error '80004005'
The field 'FORUM_FORUM.F_EDIT_TIME' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/forums/post_info.asp, line 1347
And this is my post_info.asp file
http://www.jiffypark.com/pics/post_info.txt<
Mr Pink
07 March 2006, 08:14
I've just installed this mod and it works fine except for when I create a new web link just like Jiffy. I've tried turning it off but still get the same error.<
laser
07 March 2006, 15:44
Simple ...
in Post_info there are a few changes, but the important ones are :
Code:
'## Edit Time Mod ### ADD Code below ###################### if Time_Limits then strSql = strSql & ", F_EDIT_TIME " end if '## End Add on #######
at line 1196, and
Code:
'## Edit Time ### Add code below ########################### if Time_Limits then strSql = strSql & ", '" & strTimeArr & "'" end if '## End code add on #######
at line 1233
These same changes have to be echoed in the Link code area at line 1308 and 1586.
NB!! I've just pointed you to the vague area, if you don't know how to later the SQL to suit, let me know and I'll provide more detailed instructions.<
Mr Pink
07 March 2006, 17:51
I've added another mod before this one so my lines are out, can you point me to the right places to put the new code please.<
jiffy
09 March 2006, 15:52
I'm thick on this. Can you tell me where to edit my code? I'm used to the mod readme files that tell you exactly where to place the code. Here is my post_info file. I really appreciate this.
http://www.jiffypark.com/pics/post_info.txt<
cripto9t
10 March 2006, 20:23
jiffy, mr pink see my fix Here. Let me know what happens so I can update the mod. Also what db are you using?<
jiffy
10 March 2006, 20:53
You are the man! Works great now. Using Access db.<
cripto9t
11 March 2006, 10:06
Thanks for the reply jiffy, sorry it took so long for a fix. It seems mySql over looks some things that access takes very seriously . I'll see about updating the download.<
cripto9t
11 March 2006, 10:45
I updated the zip file. There is/was an uninstall file in the original download. To anyone using this mod, I'd suggest running it and reinstalling using the new dbs file. You will have to reset your time limits after you do this.<
Mr Pink
13 March 2006, 16:53
I ran uninstall and re-installed the DBS file as there is no Alternate MOD setup on my forum. It appears to work! Thanks for the help.<
garyrobar
09 February 2007, 20:44
I hate to reopen this, but I just did a clean install with the files from the zip.
I am getting an error in post.asp...
Code:
Microsoft VBScript runtime error '800a000d' Type mismatch: 'rs' /forum/post.asp, line 727
This isn't a line that involves the mod, but this worked fine before install.
This is 727:
[code]
if MoveTopicAllowed = "1" then else strSql = strSql & " AND F.FORUM_ID = " & rs("FORUM_ID") end if [code]
727 is the SQL line...
I'll also add that after the time lim has passed, there is no more error, since the code never gets executed at that deep a level/<
garyrobar
10 February 2007, 11:33
I should have searched first, answer is here, and has nothing to do wtih this mod. Its a prob with the new version of forums
I noticed the open recordset and tried to figure out how the mod was causing the error. I guess I should have looked at a updated version because that did have an old snitz look to it .<
Hermes
21 March 2007, 07:31
Ok. Snitz Version 3.4.06, MySql 5.0
Following error: Microsoft VBScript compilation error '800a0400'
" <tr valign=""middle"">" & vbNewLine & _ " <td bgColor=""" & strPopUpTableColor......
What am I missing?
<
Shaggy
21 March 2007, 07:34
Originally posted by Hermes
What am I missing?
Code:
'## End code add on and ADD "Response.Write" to line below.
" <tr valign=""middle"">" & vbNewLine & _ " <td bgColor=""" & strPopUpTableColor......
<
Hermes
21 March 2007, 11:13
Originally posted by Hermes
What am I missing?
Code:
'## End code add on and ADD "Response.Write" to line below.
" <tr valign=""middle"">" & vbNewLine & _ " <td bgColor=""" & strPopUpTableColor......
Ouuuuuuups... Sorry guys. Everything works now. Thanks for help.
That's the way that we newbies are <
Shaggy
21 March 2007, 11:24
You're welcome.
<
rkp
02 July 2007, 13:33
Anyone gotten this error??
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/boc/forum/post.asp, line 437 <
rkp
02 July 2007, 13:58
Originally posted by rkp Anyone gotten this error??
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/boc/forum/post.asp, line 437
Line 437set rs = my_Conn.Execute (strSql)
(is there suppose to be a space between execute| |(strsql)<
rkp
02 July 2007, 14:02
[stupid] Disregard.. it helps to upload the dbs_edit_time.asp file... [/stupid]<
cripto9t
02 July 2007, 16:35
Had me worried there for a second . Let me know if you have any more problems.<
balexandre
05 January 2008, 17:24
just to leave you a happy year and a big thank you for the MOD TODO List: Add a Global Edit/Delete time, specified Forum Edit/Time will overwrite the Global value, if Default, Global value will be used.
and again... Thank you.<
texanman
11 January 2008, 11:01
Just installed the mod. Everything seems to be working fine except when I set the limit in the forum property. It says changes made but when I go back to the number ir reset. Meaning if I entered 20 minutes it is not there when I get back to the forum properties.
Any kind of help will be appreciated.
thanks<
texanman
11 January 2008, 11:25
Nevermind, I figured it out[^]<
cripto9t
11 January 2008, 12:08
Originally posted by balexandre TODO List: Add a Global Edit/Delete time, specified Forum Edit/Time will overwrite the Global value, if Default, Global value will be used.
Thats a good idea. I may add that if I get some time.
texanman, I'm glad you got it working. If you guys have any problems let me know. Hopefully all the bugs are worked out .
<
texanman
11 January 2008, 12:30
Thanks Cripto9t! It is a wonderful mod and I am thankful. I am using MS SQL and it works fine. The README instructions are extremely clear! You did a good job!<
Talismanic
30 May 2008, 00:20
I added all the files and checked the datebase to make sure the correct fields are there and it all apears to be so. I have even checked the Edit and Delete Radio buttons but the one thing I seem to be missing is where to set the time. The instructions say
Now edit your forum properties to set time limits you want. (Default is "No Limit")
Where are the forum properties located?<
cripto9t
30 May 2008, 08:01
The edit icon (pencil) in the forum row on the main page (default).
Where you edit forum title, description, add moderators etc...
There should be a place to set the time. You'll have to set each forum seperatly.<
Etymon
07 October 2008, 19:59
Hey Cripto9t,
Just getting around to installing this MOD and trying it out.
It looks really good so far!
Hey, I'm curious why you went off of forum time instead of last post time for the post by the respective author like Flood Control has. I'll do some fiddling with it though and see what other curiosities come about.
Thanks for the MOD!
Cheers,
Etymon <
pierretopping
24 December 2009, 05:17
Hi,
Does anybody have a working link to this mod, the one listed does not work.
Thanks,
ruirib
24 December 2009, 05:59
Did you check at snitzbitz.com?
pierretopping
24 December 2009, 16:16
Hi,
Yes, cannot see it listed
Classicmotorcycling
24 December 2009, 17:09
I have a copy that I have put up here: Edit/Delete Post Time Limits I take no responsibility for it as it came from the download when it was available.