function assign_translation_job($job_id, $translator_id, $service = 'local')
 {
     global $wpdb, $iclTranslationManagement;
     // make sure TM is running
     if (empty($this->settings)) {
         $iclTranslationManagement->init();
     }
     list($prev_translator_id, $rid) = $wpdb->get_row($wpdb->prepare("SELECT translator_id, rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id), ARRAY_N);
     require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
     $tn_notification = new TM_Notification();
     if ($this->settings['notification']['resigned'] == ICL_TM_NOTIFICATION_IMMEDIATELY) {
         if (!empty($prev_translator_id) && $prev_translator_id != $translator_id) {
             if ($job_id) {
                 $tn_notification->translator_removed($prev_translator_id, $job_id);
             }
         }
     }
     if ($this->settings['notification']['new-job'] == ICL_TM_NOTIFICATION_IMMEDIATELY) {
         if (empty($translator_id)) {
             $tn_notification->new_job_any($job_id);
         } else {
             $tn_notification->new_job_translator($job_id, $translator_id);
         }
     }
     $wpdb->update($wpdb->prefix . 'icl_translation_status', array('translator_id' => $translator_id, 'status' => ICL_TM_WAITING_FOR_TRANSLATOR, 'translation_service' => $service), array('rid' => $rid));
     $wpdb->update($wpdb->prefix . 'icl_translate_job', array('translator_id' => $translator_id), array('job_id' => $job_id));
     return true;
 }
 function assign_translation_job($job_id, $translator_id, $service = 'local')
 {
     global $wpdb;
     list($prev_translator_id, $rid) = $wpdb->get_row($wpdb->prepare("SELECT translator_id, rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id), ARRAY_N);
     require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
     $tn_notification = new TM_Notification();
     if (!empty($prev_translator_id) && $prev_translator_id != $translator_id) {
         if ($job_id) {
             $tn_notification->translator_removed($prev_translator_id, $job_id);
         }
     }
     if (empty($translator_id)) {
         $tn_notification->new_job_any($job_id);
     } else {
         $tn_notification->new_job_translator($job_id, $translator_id);
     }
     $wpdb->update($wpdb->prefix . 'icl_translation_status', array('translator_id' => $translator_id, 'status' => ICL_TM_WAITING_FOR_TRANSLATOR, 'translation_service' => $service), array('rid' => $rid));
     $wpdb->update($wpdb->prefix . 'icl_translate_job', array('translator_id' => $translator_id), array('job_id' => $job_id));
     return true;
 }