YAFLogo

metta123
  • metta123
  • 50.2% (Neutral)
  • YAF Camper Topic Starter
11 years ago
Hi all,

I want to be able to add new posts programmatically at a certain time each week. Can I just write an sql insert statement into yaf_message table providing I get the fields accurate. Then I could just run an SP (stored procedure) every week at a certain time. Or can you let me know of the SP to use. I need to create about 40 new topics at say 3pm every wednesday.

I just need some basic advice on this. I would rather do this through MSSQL using Transact if I can. Please advise...

Thank you.
Sponsor

metta123
  • metta123
  • 50.2% (Neutral)
  • YAF Camper Topic Starter
11 years ago
Hi,

After alot of fiddling about I might well have found a way in. So that I can add multiple posts as an automated service. I was just wondering if anyone could advise me on whether this will cause any issues with anything else.

Basically I just execute the stored procedure [dbo].[yaf_topic_save], and pass in the required parameters. My worry is somewhere along the line Im going to come seriously unstuck with this. As I am not executing anything else other than [dbo].[yaf_topic_save], and of course what that in turn executes.

Goes like this....

exec [dbo].[yaf_topic_save] 1, 'subject', 2, 'body', 0, 'myTestUser', '::1', null, 999999, 0;

Any advise would be greatly appreciated.
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button