| Author |
 Topic  |
|
gregko
Starting Member
6 Posts |
 Posted - 31 January 2002 : 19:12:17
|
Hi,
is is possible to set something in ver. 3.3.03 to be notified by email, when messages needing moderation are posted? If not, I suggest such enhancement to a future version.
Greg
Edited by - Nathan on 01 February 2002 01:41:48
Edited by - Davio on 01 March 2002 13:41:39 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 February 2002 : 01:39:07
|
You are correct. It should function that way.
Nathan, could you move this to the bug forum please?
The moderation function needs to be modified quite a bit to accomadate that.
- David |
 |
|
|
sumo
Junior Member
USA
121 Posts |
Posted - 06 February 2002 : 09:07:10
|
If you use SQL Server, I have some triggers that do just that. I can send them over if you like.
quote:
Hi,
is is possible to set something in ver. 3.3.03 to be notified by email, when messages needing moderation are posted? If not, I suggest such enhancement to a future version.
Greg
Mike
http://www.ekeystone.com/
http://www.sumovw.com/
http://www.driverfx.com/ |
|
|
|
gregko
Starting Member
6 Posts |
Posted - 11 February 2002 : 11:55:06
|
quote:
If you use SQL Server, I have some triggers that do just that. I can send them over if you like.
Mike,
I do use SQL Server 2000. Please post the switches here or email to me. Thank you!
Greg
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 March 2002 : 13:38:54
|
Here is a fix supplied by Nathan. I have checked it and it works. If there are any problems, let me know.
There are too many modifications to make to post here, so I have zipped up the files that need editing.
Download: http://www.dsilvera.com/download.asp?file_id=80
If you do a search for Modification in each file you will see what needs to be edited.
«-------------------------------------------------»
Read the Do's and Don'ts before you post for help
«-------------------------------------------------»
Edited by - Davio on 20 June 2002 16:07:13 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 09 March 2002 : 01:30:33
|
| fixed in v3.4 |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 14 March 2002 : 00:25:24
|
quote:
fixed in v3.4
Not so fast. I missed one little detail. 
About line 293:
'################## Modification #######################
if Moderation <> "No" then
StrSql = StrSql & " AND ((M.M_LEVEL = 3"
if strUniqueModID = "none" then
StrSql = StrSql & "))"
else
StrSql = StrSql & "AND Mo.Mod_ID = " & strUniqueModID & ") OR (M.M_LEVEL = 2 AND S.Member_ID = Mo.Member_id AND Mo.Forum_ID = " & ForumId & "))"
end if
end if
'#######################################################
That little red thingie is important. 
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 14 March 2002 : 00:29:49
|
| updated... |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 14 March 2002 : 01:14:04
|
This was missing from my origional fix. Were these not in the file I sent to you Davio?
The if structure is there to prevent an unessisary extra trip to the database. And the notes are important so that people will know what I was the heck I was doing when they go back to read the file, otherwise they will ask "what the heck?!"
The 'Ls3k is just a flag for me to know that I wrote the notes, it can be changed to '## if you want.
'################## Modification #######################
'Ls3K- This sql finds if mods have been asigned, anywhere. This infomation is needed so that we know
'Ls3K- whether or not we need to join to the mods table, and if so we need a unique mod_id to sort out
'Ls3K- one example of each individual administrator
if Moderation <> "No" then
strSql = "SELECT Mod_ID from " & strTablePrefix & "MODERATOR"
Set modCheck = Server.CreateObject("ADODB.Recordset")
modCheck.open strSql, my_Conn
if modCheck.EOF or modCheck.BOF then
strUniqueModID = "none"
else
strUniqueModID = modCheck("Mod_ID")
end if
modCheck.Close
set modCheck = nothing
else
'Ls3k Just in case. . .
strUniqueModID = "none"
end if
'#######################################################
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's
Edited by - Nathan on 14 March 2002 01:43:37 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 March 2002 : 11:21:04
|
Yes it was. But I didn't update the files here that I provided for download. I only fixed it in the 3.4 version.
«------------------------------------------------------»
Read the Do's and Don'ts before you post for help |
|
|
|
the_zone
Starting Member
12 Posts |
Posted - 03 April 2002 : 11:50:05
|
what about those of us using an access database? Don't know sql server. Should I suggest this as being a bug? It seems like you have many types of people here posting. Ones that want to control.. and ones that don't care and ones that just want to be considerate.
I am going to be running a message board for my church website. It has to do with control and for those not to abuse. I need to be able to moderate everything. There are plenty of people that I can setup as moderators.. I was thinking about setting up a query that would catch everything that was not clicked "ok" and they can look at it and decide. Does that make sense?
thanks.
Edited by - the_zone on 09 April 2002 16:20:18 |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 03 April 2002 : 12:43:39
|
the_zone.....
3.3 already has full moderation, 3.4 just adds the capability to notify the mods of a post needing approval....
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 03 April 2002 : 13:04:24
|
quote:
what about those of us using an access database? Don't know sql server.
zone, this fix is fully tested for use on Microsoft Acess databases.
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
|
|
|
the_zone
Starting Member
12 Posts |
Posted - 09 April 2002 : 16:14:44
|
I have posted in another section about once something is moderated one can go in and chage it to anything. Therefore it is a hole in the "security" of the moderation. That needs to be fixed please. If I can help, and I am pretty sure I can't , but if I can please email me at jeremy@sanz.net and I will try to help. Thanks for this forum and the one that I placed on the church website.
Jeremy
|
|
|
|
the_zone
Starting Member
12 Posts |
Posted - 09 April 2002 : 16:19:24
|
quote:
3.3 already has full moderation, 3.4 just adds the capability to notify the mods of a post needing approval....
Once it is approved the user can go and change/edit the post to whatever he/she wants. That isn't moderated. It needs to change the R_STATUS back to [2] so that it is in the "not moderated" section. IF I am wrong please let me know. jeremy@sanz.net
|
|
|
|
ibos
Starting Member
6 Posts |
Posted - 07 May 2002 : 11:43:39
|
Hello ,
I have recently downloaded and installed 3.3.033. Am I safe dropping these new files on top of the current ones, or should I apply the mods individually ?
thanks
ibos
quote:
Here is a fix supplied by Nathan. I have checked it and it works. If there are any problems, let me know.
There are too many modifications to make to post here, so I have zipped up the files that need editing.
Download: link removed
If you do a search for Modification in each file you will see what needs to be edited.
«-------------------------------------------------»
Read the Do's and Don'ts before you post for help
«-------------------------------------------------»
Edited by - Davio on 20 June 2002 16:10:04 |
|
|
|
Topic |
|
Topic Locked
