Web Wiz Support and Community Forums : Adding A Topic Automatically Via SQL

Web Wiz Support and Community Forums : Adding A Topic Automatically Via SQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 20:25:30 +0000 Tue, 25 Mar 2008 13:40:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25464 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Adding A Topic Automatically Via SQL : The version of the forums is 9.0x I'll...]]> https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132153.html#132153 Author: Testin123
Subject: 25464
Posted: 25 March 2008 at 1:40pm

The version of the forums is 9.0x

I'll take a look at new_post.asp

I guess that's the file containing the functionality I need to mirror.

]]> Tue, 25 Mar 2008 13:40:14 +0000 https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132153.html#132153 <![CDATA[Adding A Topic Automatically Via SQL : Is this SP from V7/8?If so then...]]> https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132121.html#132121 Author: Scotty32
Subject: 25464
Posted: 22 March 2008 at 2:09pm

Is this SP from V7/8?

If so then it will need updating as V9 updates more information, as V9 doesnt use SP's.

If it is your own custom work, then you are missing certen parts.

I think it maybe easier to look at the file that processes posts and work from that. Or you could just run the Post Count Sync every time you use the SP.
]]> Sat, 22 Mar 2008 14:09:53 +0000 https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132121.html#132121 <![CDATA[Adding A Topic Automatically Via SQL : Just a guess, but I'd imagine...]]> https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132119.html#132119 Author: stevek_mcc
Subject: 25464
Posted: 22 March 2008 at 2:04pm

Just a guess, but I'd imagine that the ASP code does some extra actions as well as the basic topic addition. You might be better trying to automate adding the topic by calling the actual login and post pages with a programmatic HTML client. ]]> Sat, 22 Mar 2008 14:04:12 +0000 https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132119.html#132119 <![CDATA[Adding A Topic Automatically Via SQL : I have a stored procedure to add...]]> https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132084.html#132084 Author: Testin123
Subject: 25464
Posted: 19 March 2008 at 3:37pm

I have a stored procedure to add a topic from an SQL Server stored procedure:

CREATE PROCEDURE DS_NewTopic
@Forum_ID int, @Subject varchar(64), @Message varchar(4096)
AS
DECLARE @NewTopicID int
DECLARE @NewThreadID int
DECLARE @Author_ID int

-- Set new topic author ID to match for 'testuser':
SET @Author_ID = 15

-- Add new topic and retrieve Topic ID:
INSERT tblTopic (Forum_ID, Subject, Priority) VALUES (@Forum_ID, @Subject, 0)
SET @NewTopicID = (SELECT MAX(Topic_ID) FROM tblTopic)

-- Add thread and retrieve Thread ID:
INSERT tblThread (Topic_ID, Author_ID, Message) VALUES (@NewTopicID, @Author_ID, @Message)
SET @NewThreadID = (SELECT MAX(Thread_ID) FROM tblThread)

-- Update Thread ID's in tblTopic
UPDATE tblTopic SET Start_Thread_ID = @NewThreadID, Last_Thread_ID = @NewThreadID WHERE Topic_ID = @NewTopicID
GO

This works reasonably well apart from:

1) The post is never shown as the 'Last Post'

2) If the post is the only one in a forum the post count stays at zero.

How can I modify the above SP to have the topic added 'correctly'?

Thanks

]]> Wed, 19 Mar 2008 15:37:38 +0000 https://forums.webwiz.net/adding-a-topic-automatically-via-sql_topic25464_post132084.html#132084