SELECT m.TopicID, m.UserID, t.Title AS TopicName, u.Email, u.Firstname, u.Username FROM Message m LEFT JOIN Topic t ON m.TopicID = t.TopicID LEFT JOIN Users u ON m.UserID = u.UserID WHERE m.MessageID = #messageid# AND t.Enabled = 1




Be an active participant in the Watchnet community. Share your knowledge and enthusiasm with your fellow Watchnet members. Simply enter your information in the required fields below and your message will be posted for all to see. We look forward to hearing from you!


Below is a preview of the message as it will appear in the message boards. Please make sure that the message is correct and click the Post Message button if everything is correct.

SubjectUser IDDate Posted
#subject##session_Username##DateFormat(Now(), "m/d/yyyy")#
#Replace(body, chr(13) & chr(10), "
", "ALL")#
Photos:
  1. (uploaded)
  2. (uploaded)
  3. #image3#
  4. #image4#

Make Corrections to Message

INSERT INTO Message ( ParentMessageID, TopicID, Title, Description, UserID, Pic1, Pic2, Pic3, Pic4 ) VALUES ( #messageid#, #getmessage.TopicID#, '#subject#', '#body#', #session_userid#, '#image1#', '#image2#', '#image3#', '#image4#') UPDATE Message SET Responses=Responses + 1 WHERE MessageID = #messageid# UPDATE Topic SET Messages=Messages + 1 WHERE TopicID = #getmessage.TopicID# SELECT email FROM Users WHERE UserID = #session_UserID#

Reply Was Posted Successfully

#errormsg#

     Pictures
There are two ways to add photos to the Watchnet Forums. On the left, you may upload 2 photos from your computer to Watchnet. On the right, you may specify a web address for 2 photos that are on another server.
Upload Picture 1

- Must be JPG or GIF file
Remote Picture 1

- Must be JPG or GIF file
Upload Picture 2

- Must be JPG or GIF file
Remote Picture 2

- Must be JPG or GIF file
 
Original Post:

Return to #getmessage.TopicName#