Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackHow to delete unwanted comments?How to delete unwanted comments?
Previous
 
Next
New Post
5/9/2008 10:32 PM
 

I have since discovered that the other moderation buttons for the feedback module (v4.4.3) are also defunct.  Each of them refreshes the page but does not actually perform the specified action on the comment.

 
New Post
5/10/2008 1:43 AM
 

did your site by any chance have a prior version of feedback installed on another page? If yes, then in 4.4.3 (of feedback) the ability to moderate posts that were made on a different instance of the module (ie on a different page or if you added and then deleted the prior instance) was removed since it was considered a security hole.

You can get around this by modifying the stored proc (and I'd be happy to show you how) but that would explain why the page is refreshing without any changes...
Sanjay


AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post
5/10/2008 5:19 AM
 

I have several feedback forms scattered about on various pages.  While I'm reasonably sure all of them were installed after upgrading Feedback to 4.4.3, I can't be absolutely certain.  Since I'm not a programmer, I'm not particularly keen on the idea of tinkering with anything that isn't easy enough for a monkey to accomplish, lest I break something.

That is, if I change the stored proc (whatever that is, mind you), is it going to break something else, or am I going to have to change it again if I drop another feedback form on another page, etc.?

 
New Post
5/14/2008 4:50 PM
 

Sanjay Mehrotra wrote

did your site by any chance have a prior version of feedback installed on another page? If yes, then in 4.4.3 (of feedback) the ability to moderate posts that were made on a different instance of the module (ie on a different page or if you added and then deleted the prior instance) was removed since it was considered a security hole.

You can get around this by modifying the stored proc (and I'd be happy to show you how) but that would explain why the page is refreshing without any changes...
Sanjay

Yes please! Can you explain this?

 
New Post
5/14/2008 5:43 PM
 

Alan wrote

 Sanjay Mehrotra wrote

 

did your site by any chance have a prior version of feedback installed on another page? If yes, then in 4.4.3 (of feedback) the ability to moderate posts that were made on a different instance of the module (ie on a different page or if you added and then deleted the prior instance) was removed since it was considered a security hole.

You can get around this by modifying the stored proc (and I'd be happy to show you how) but that would explain why the page is refreshing without any changes...
Sanjay

 

Yes please! Can you explain this?

Alan,

So here is the original stored procedure that I'm talking about. (UpdateFeedbackStatus)


CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateFeedbackStatus
 @ModuleID int,
 @FeedbackID int,
 @Status int
AS
IF @Status = 4
 DELETE {databaseOwner}[{objectQualifier}Feedback] WHERE FeedbackID = @FeedbackID and ModuleID = @ModuleID
ELSE
 UPDATE {databaseOwner}[{objectQualifier}Feedback]
 SET    Status = @Status
 WHERE FeedbackID = @FeedbackID and ModuleID = @ModuleID
GO

If you modify this stored procedure as follows, it would allow you to update the status of any feedback submitted (ie similar to what was the case prior to 4.4.3).

CREATE PROCEDURE {databaseOwner}{objectQualifier}UpdateFeedbackStatus
 @ModuleID int,
 @FeedbackID int,
 @Status int
AS
IF @Status = 4
 DELETE {databaseOwner}[{objectQualifier}Feedback] WHERE FeedbackID = @FeedbackID

ELSE
 UPDATE {databaseOwner}[{objectQualifier}Feedback]
 SET    Status = @Status
 WHERE FeedbackID = @FeedbackID

GO


AcuitiDP - Oracle Data Provider for DotNetNuke
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackHow to delete unwanted comments?How to delete unwanted comments?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out