SELECT forumAccess FROM tblUsers WHERE userID = select ForumName,SecurityLevel,Locked, swearFilter from tblForums where forumid = AND locked = if ( trim(form.ThreadTitle) eq "" ) { foo = arrayappend(error,"You must enter a Topic Title."); } if ( trim(form.MessageText) eq "" ) { foo = arrayappend(error,"You must at least put some text in the message field."); } SELECT userName FROM tblUsers WHERE userID = declare @fID int, @tID int, @mID int, @uID int, @uName varchar(50) select @fID = select @uID = select @uName = insert into tblThreads (ThreadTitle,ThreadStarter,ThreadStartDateTime,ForumID,announcement,locked,lastPostDT,lastPosterName,lastMessageID,lastPosterID,HotTopic) values ( , @uID, getdate(), @fID, , , getdate(), @uName, , @uID, ) select @tID = @@IDENTITY insert into tblMessages (UserID,ForumID,ThreadID,MessageDateTime,MessageText,IP) values ( @uID, @fID, @tID, getdate(), , ) select @mID = @@IDENTITY update tblThreads SET lastMessageID = @mID where forumID = @fID and threadID = @tID update tblForums set NumberOfPosts = NumberOfPosts + 1, lastpostDT = getdate(), lastPosterID = @uID, lastPosterName = @uName, lastMessageID = @mID, lastThreadID = @tID where ForumID = @fID update tblUsers set totalPosts = totalPosts + 1 where UserId = @uID SELECT @tID as tID

Add Topic in Forum: #GetForum.ForumName#
Title
Message
Sticky Topic?	checked value="1">
Hot Topic?	checked value="1">