Well, a hidden edit is a hidden edit...so, nothing except the T_MESSAGE (and/or T_SUBJECT) or R_MESSAGE gets updated when you perform a hidden edit.
There's no registration of the last edit time nor who performed the last edit.
This last value gets stored in R_LAST_EDITBY (for replies) or T_LAST_EDITBY (for topics).
The way it works in TOPIC.ASP, is that when the value for R_LAST_EDITBY (for replies) or T_LAST_EDITBY (for topics) is not empty, it shows up as 'edited by "user"'.
So, in other words, if you do not want to update R_LAST_EDITBY or T_LAST_EDITBY, nor R_LAST_EDIT nor T_LAST_EDIT, the only way to show the (not so hidden) edit, is by adding a piece of info to the message.
This can be done in this line (line 349 in base install, in the 'if MethodType = "Edit" then' part) for replies:
Code:
txtMessage = ChkString(Request.Form("Message"),"message")
If you add these lines below, you'll add a short message to the end of the reply, stating that the reply was edited by a moderator/admin:
Code:
if Request.Form("modedit") = "true") then
txtMessage = txtMessage & "<br>This post was edited by a moderator at " & DateToStr(strForumTimeAdjust)
end if
You can also add the name of the editor, with this code:
Code:
if Request.Form("modedit") = "true") then
txtMessage = txtMessage & "<br>This post was edited by " & getMemberName(MemberID) & " at " & DateToStr(strForumTimeAdjust)
end if
In the part for the EditTopic method is the same line, (451 in base install).
If you add the same code as shown above to it, it will also work for edited topics.
But, _only_ if the mod has decided to make a hidden edit.
By the way ; the option to do a hidden edit is only available for moderators/admins. (in my case only for admins).
That's why I decided to make it this way. Normally they make hidden edits, but now and then they should be able to make 'non-hidden' edits.
The problem with your SQL statement is that you are trying to fill in T_LAST_EDITBY with a text-string, but it should be filled in with a memberid (so a number).<