Emaze Auction: User Feedback User Feedback SELECT userID, username, email, firstName, lastName FROM Member WHERE userID = #userID#

Username: #getUser.username#
Name: #getUser.firstName# #getUser.lastName#
Email: #getUser.email#
UPDATE Feedback SET feedbackRating = #Form.feedbackRating#, feedbackComment = NULL'#Form.feedbackComment#' WHERE feedbackID = #Form.feedbackID# UPDATE Member SET feedbackRating = feedbackRating + 1, feedbackCountPositive = feedbackCountPositive + 1, feedbackCountNeutral = feedbackCountNeutral - 1 SET feedbackRating = feedbackRating + 2, feedbackCountPositive = feedbackCountPositive + 1, feedbackCountNegative = feedbackCountNegative - 1 SET feedbackRating = feedbackRating - 1, feedbackCountNegative = feedbackCountNegative + 1, feedbackCountNeutral = feedbackCountNeutral - 1 SET feedbackRating = feedbackRating - 2, feedbackCountNegative = feedbackCountNegative + 1, feedbackCountPositive = feedbackCountPositive - 1 SET feedbackRating = feedbackRating - 1, feedbackCountNeutral = feedbackCountNeutral + 1, feedbackCountPositive = feedbackCountPositive - 1 SET feedbackRating = feedbackRating + 1, feedbackCountNeutral = feedbackCountNeutral + 1, feedbackCountNegative = feedbackCountNegative - 1 WHERE userID = #Form.feedbackUserID##userID# Feedback message updated.

SELECT Feedback.userID, Feedback.feedbackRating, Feedback.feedbackDateTime, Feedback.feedbackComment, Member.username, Member.email, Member.firstName, Member.lastName FROM Feedback INNER JOIN Member ON Feedback.userID = Member.userID FROM Feedback INNER JOIN Member ON Feedback.feedbackUserID = Member.userID WHERE Feedback.feedbackID = #feedbackID#

Edit Feedback

Posted: #DateFormat(getFeedbackToEdit.feedbackDateTime,"mm-dd-yyyy")# / #TimeFormat(getFeedbackToEdit.feedbackDateTime,"hh:mm tt")#
Rating: CHECKED> Positive   CHECKED> Neutral   CHECKED> Negative
About Username: #getFeedbackToEdit.username#
About Name: #getFeedbackToEdit.firstName# #getFeedbackToEdit.lastName#
About Email: #getFeedbackToEdit.email#
Comment:

DELETE FROM Feedback WHERE feedbackID = #feedbackID# UPDATE Member SET feedbackCountTotal = feedbackCountTotal - 1, feedbackRating = feedbackRating - 1, feedbackCountPositive = feedbackCountPositive - 1 feedbackCountNeutral = feedbackCountNeutral - 1 feedbackRating = feedbackRating + 1, feedbackCountNegative = feedbackCountNegative - 1 WHERE userID = #feedbackUserID##userID# Feedback message deleted.

SELECT Feedback.feedbackID, Feedback.feedbackRating, Feedback.feedbackUserID, Feedback.feedbackComment, Feedback.feedbackDateTime, Member.username, Member.userID, Member.firstName, Member.lastName, Member.email FROM Feedback INNER JOIN Member ON Feedback.feedbackUserID = Member.userID WHERE Feedback.userID = #userID# SELECT Feedback.feedbackID, Feedback.feedbackRating, Feedback.userID, Feedback.feedbackComment, Feedback.feedbackDateTime, Feedback.feedbackUserID, Member.username, Member.userID, Member.firstName, Member.lastName, Member.email FROM Feedback INNER JOIN Member ON Feedback.userID = Member.userID WHERE Feedback.feedbackUserID = #userID#

Feedback Posted BY This User About Other Users

Edit | Delete
Posted: #DateFormat(feedbackDateTime,"mm-dd-yyyy")# / #TimeFormat(feedbackDateTime,"hh:mm tt")#
Rating: PositiveNeutralNegative
About Username: #username#
About Name: #firstName# #lastName#
About Email: #email#
Comment: #feedbackComment#

Feedback Posted ABOUT This User By Other Users

Edit | Delete
Posted: #DateFormat(feedbackDateTime,"mm-dd-yyyy")# / #TimeFormat(feedbackDateTime,"hh:mm tt")#
Rating: PositiveNeutralPositive
By Username: #username#
By Name: #firstName# #lastName#
By Email: #email#
Comment: #feedbackComment#