YAFLogo

metta123
  • metta123
  • 50.2% (Neutral)
  • YAF Camper Topic Starter
12 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
12 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.