Edit or delete approved Review

[webwerx]

I've just got a phonecall from the owner of one of the Links listed in my Directory. There has been a Review about his Website, that is 2 Years old and if you type in the Name of his Company my Directory is #1 in Google But the Review is really bad and he has redesigned his Website very good.
So I wanted to delete the Review. But how? In the Features of Indexu Deluxe is stated that I can edit, delete aso. Reviews. But where?

Thanks in advance
-Dirk

[esm]

I can tell you that you will not like the answer from brucepr. I'll bet the word SQL will be used or somehow involved in the answer.


.

[webwerx]

@esm

Somehow I think I can read through your lines that you are no longer into Indexu so much, prove me that I am wrong

I have read 2 - 3 Threads about the Review Problem here and in any topic the word SQL really has been mentioned. Do I have to wonder now? Dont think so.

So this should require a new plugin? Or is this a feature Request?

Thanks

[esm]

Content visible to License Owner only.

But I am submitting a new MOD this month.

Content visible to License Owner only.

Feature request.


.

[Bruceper]

You can edit and delete reviews before they are approved. Once they are approved they cannot be changed because you have already approved it, it is assumed that the review is "safe".

The following are a few ways to remove it

1) Go into phpmyadmin in the table idx_review and delete the line
2) Find out what review number it is and run the following in the admin panel under Database - Query

DELETE FROM `idx_review` WHERE `review_id` = X

Where X is the review number. The review number is not visable so if you don't know it there are other ways!

3) The username DOES appear beside each review, so you could go to Database - Query and run the following

DELETE FROM `idx_review` WHERE `username` = X

Where X is the username of the review you want to delete. To be honest this method is probably the easiest and quickest

4) There's more! If you want to delete a review, or multiple reviews you could do the following

DELETE FROM `idx_review` WHERE `rating` = X

Where X equals the rating number that you want to remove. You could remove reviews that were all set to 1 by doing DELETE FROM `idx_review` WHERE `rating` = 1

A full panel to edit existing and already approved reviews is in the wishlist for the next release of IndexU (1.2). This is something I've wanted for a while.

[esm]

Content visible to License Owner only.

Yep, not sure what dody was thinking when he didn't create the edit/delete function for reviews back in 3.x. cause you can certainly delete the link even if the link has a review.

Content visible to License Owner only.

always include a LIMIT 1 when using the above SQL statement. Other wise you might just accidentially delete ALL the reviews

Content visible to License Owner only.

just remember that if you use the above SQL statements, you will delete ALL of the reviews where the username = X or the rating = X. And how many is ALL...???


Also, you need to put quote marks around X if you use username.



.