The job scheduling features of MTOS are powerful, and I’m working on ways to leverage them externally.
Here’s what I’ve been working on creating so far. Its currently in my mail machine in /usr/local/sbin/ because I was thinking of connecting it with Postfix:
INSERT INTO mt_entry
(entry_allow_comments, entry_author_id, entry_authored_on, entry_basename, entry_blog_id, entry_class, entry_convert_breaks, entry_created_by, entry_created_on, entry_modified_on, entry_status, entry_text, entry_title, entry_week_number)
VALUES
(1, 1, '2009-08-22 19:08:40', 'testing_12_3', 256, 'entry', 'richtext', 1, '2009-08-22 19:08:40', '2009-08-22 19:08:40', 2, '$comment', 'Testing 12 3', 200934);
INSERT INTO `mt_fileinfo` (`fileinfo_archive_type`, `fileinfo_author_id`, `fileinfo_blog_id`, `fileinfo_category_id`, `fileinfo_entry_id`, `fileinfo_file_path`, `fileinfo_startdate`, `fileinfo_template_id`, `fileinfo_templatemap_id`, `fileinfo_url`) VALUES ('Individual', NULL, 256, NULL, (SELECT entry_id FROM mt_entry WHERE entry_created_on='2009-08-22 19:08:40' LIMIT 1), CONCAT('/var/www/virtual/www.kernelmadness.com/public','/blog/2009/08/testing_12_3.html'), NULL, (SELECT template_id FROM mt_template WHERE template_blog_id=256 AND template_name='Entry'), 1091, '/blog/2009/08/testing_12_3.html' );
INSERT INTO `mt_ts_job` (`ts_job_arg`, `ts_job_coalesce`, `ts_job_funcid`, `ts_job_grabbed_until`, `ts_job_insert_time`, `ts_job_priority`, `ts_job_run_after`, `ts_job_uniqkey`) VALUES
(NULL, '256:7307:1:1250984560', 1, 0, 1250984560, 1, 1250984560, (SELECT fileinfo_id FROM mt_fileinfo WHERE fileinfo_blog_id=256 AND fileinfo_entry_id=(SELECT entry_id FROM mt_entry WHERE entry_created_on='2009-08-22 19:08:40' LIMIT 1) LIMIT 1) );
INSERT INTO `mt_ts_job` (`ts_job_arg`, `ts_job_coalesce`, `ts_job_funcid`, `ts_job_grabbed_until`, `ts_job_insert_time`, `ts_job_priority`, `ts_job_run_after`, `ts_job_uniqkey`) VALUES
(NULL, '256:7307:1:1250984560', 1, 0, 1250984560, 1, 1250984560, (SELECT fileinfo_id FROM mt_fileinfo WHERE fileinfo_blog_id=256 AND fileinfo_url LIKE '%index.html' AND fileinfo_archive_type='index' LIMIT 1) LIMIT 1) );
This gets generated by an eruby template (ERB). The reason what there are two mttsjob inserts is so that a page is rendered and the index is rebuilt.
Looks like publish jobs can be reinserted with jobfuncid to to sync them. Speaking of which, the rsync capability of movable type open source is absolutely awesome as well. There should also be an FTP synchronization function, maybe a module could somehow link up with sitecopy.
