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...

[kh99]

Sorry for the late reply, are you still looking for these answers? I don't see anything in the admincp for deleting threads by keyword, but I sometimes forget about features. You could do it by going to the database directly but there are counters and cached forum info to be updated, so it's complicated to make sure everything's done. The 'right' way would be to find the post ids you want to remove, then use the vbulletin thead/post data manager class to remove the post. But to do that you need to include the vbulletin back end, which might be too much overhead for your application.

Same for adding a post. It would be good to use the datamanager if you can. Otherwise, I can't tell you offhand everythign that needs to be done, but you could probably figure it out by looking at the threadpost data manager class.