Automation (Delete and Add posts)

[picusart]

Hi all,

I have two automation questions.

1- I want to remove posts that have a specific pattern like 'abcdefgh' for example. Does admincp has such a utility? Or should I use phpmyadmin and sql to complete such a task by deleting db records?

2- I want to add a post everyday to pre-defined threads...
- I implemented a web service, deployed it to tomcat.
- Added a stored procedure to mysql db, web service calls the SP with thread name and message params.
The SP :
adds a record to post table
adds a record to postlog table
update thread table
update forum table
- And coded a windows application to consume my web service.

Is this a correct solution? Can you suggest a better and robust alternative?


Thanks in advance...