Hello!
Here are some ponits I need you to address/clarify on:
1) You need this working 'from within wordpress' or outside the wordperss installation(assuming it's a wp installation readily accessible at the place where the script is to work from)?
2) Define 'unpublished' teh way you mean it here, what do you mean -
a) a post previously being published that changed its status to anything different than published, or scheduled for the future(draft, trashed, etc)?, or
b) a post, which at the time of its creation has a non-publish/schedule status?
3) Depending on teh answer of (2) above, should it do anything subsecuently, should the post gains a non-publish/schedule staus again or if there's the video id meta present skip straight away?
4) The 'other' database the video url should be adde to - that's residing on the same server(inside wp, outside wp) or remote server?
5) The '3) Clear text from text box and use a predefined format ' part is kinda stepping on its ownn toes. YOu say 'clear' but 'use a predefined format', so I am assuming you mean that the post content should be cleared from all previous input and a new one to be created using a peredefined format, but please clarify.
Kind Regards,
Dobri