PHP WYSIJA::log方法代码示例

 function send_test_editor($dataPost = false)
 {
     $modelQ =& WYSIJA::get("queue", "model");
     $config =& WYSIJA::get("config", "model");
     $premium = $config->getValue('premium_key');
     $subscribers = (int) $config->getValue('total_subscribers');
     if ($subscribers < 2000 || $premium && $subscribers >= 2000) {
         if ($modelQ->count() > 0) {
             $helperQ =& WYSIJA::get("queue", "helper");
             $emailid = false;
             if ($_REQUEST['emailid']) {
                 $emailid = $_REQUEST['emailid'];
             }
             WYSIJA::log('Don\'t wait and send now queue process', array('email_id' => $emailid));
             $helperQ->process($emailid);
         } else {
             echo "<strong>" . __("Queue is empty!", WYSIJA) . "</strong>";
         }
     } else {
         echo "<strong>" . __("Go premium, you cannot send anymore!", WYSIJA) . "</strong>";
     }
     exit;
 }

 /**
  * erase an array of queue elements from the database
  * @param array $queue_delete
  * @return boolean
  */
 function _deleteQueue($queue_delete)
 {
     if (empty($queue_delete)) {
         return true;
     }
     $status = true;
     $modelQ = WYSIJA::get('queue', 'model');
     foreach ($queue_delete as $email_id => $subscribers) {
         $nbsub = count($subscribers);
         //$res=$modelQ->delete(array("email_id"=>intval($email_id),"user_id"=>$subscribers));
         //$realquery='DELETE a.* FROM `[wysija]queue` as a LEFT JOIN `[wysija]email` as b on a.email_id = b.email_id WHERE b.email_id IS NULL';
         $real_query = 'DELETE FROM `[wysija]queue` WHERE email_id = ' . intval($email_id) . ' AND user_id IN (' . implode(',', $subscribers) . ') LIMIT ' . $nbsub;
         WYSIJA::log('helpers -> Queue ->process ->deleteQueue', $real_query, 'queue_process');
         $res = $modelQ->query($real_query);
         if (!$res) {
             $status = false;
             WYSIJA::log('helpers -> Queue ->process ->deleteQueue failed', true, 'queue_process');
             //$this->_display($this->db->getErrorNum.' : '.$this->db->getErrorMsg());
         } else {
             WYSIJA::log('deleting queue ok', array('email_id' => $email_id, 'subscribers' => $subscribers), 'queue_process');
             $nbdeleted = $modelQ->getAffectedRows();
             if ($nbdeleted != $nbsub) {
                 $status = false;
                 $this->_display(__('Newsletters are already being sent. Your latest newsletter will be sent afterwards.', WYSIJA));
             }
         }
     }
     return $status;
 }

 function insertAutoQueue($user_id, $email_id, $email_params_autonl)
 {
     $model_queue =& WYSIJA::get('queue', 'model');
     $queueData = array('priority' => '-1', 'email_id' => $email_id, 'user_id' => $user_id);
     $delay = $model_queue->calculate_delay($email_params_autonl);
     $queueData['send_at'] = time() + $delay;
     if (!$model_queue->exists(array('email_id' => $email_id, 'user_id' => $user_id))) {
         if (isset($email_params_autonl['unique_send']) && $email_params_autonl['unique_send']) {
             $modelEUS =& WYSIJA::get('email_user_stat', 'model');
             if (!$modelEUS->exists(array('email_id' => $email_id, 'user_id' => $user_id))) {
                 $model_queue->insert($queueData, true);
             }
         } else {
             $model_queue->insert($queueData, true);
         }
     }
     if ($delay == 0) {
         $queueH =& WYSIJA::get('queue', 'helper');
         $queueH->report = false;
         WYSIJA::log('insertAutoQueue queue process', array('email_id' => $email_id, 'user_id' => $user_id), 'queue_process');
         $queueH->process($email_id, $user_id);
     }
 }

//.........这里部分代码省略.........
         }
     } else {
         $params = array('from_name' => $emailObject->from_name, 'from_email' => $emailObject->from_email, 'replyto_name' => $emailObject->replyto_name, 'replyto_email' => $emailObject->replyto_email);
     }
     if (strpos($_REQUEST['receiver'], ',')) {
         $receivers = explode(',', $_REQUEST['receiver']);
     } else {
         if (strpos($_REQUEST['receiver'], ';')) {
             $receivers = explode(';', $_REQUEST['receiver']);
         } else {
             $receivers = array($_REQUEST['receiver']);
         }
     }
     foreach ($receivers as $key => $receiver) {
         $receivers[$key] = trim($receiver);
         $dummyReceiver = new stdClass();
         $dummyReceiver->user_id = 0;
         $dummyReceiver->email = $receiver;
         $dummyReceiver->status = 1;
         $dummyReceiver->lastname = $dummyReceiver->firstname = $langextra = '';
         if ($spamtest) {
             $dummyReceiver->firstname = 'Mail Tester';
             if (defined('WPLANG') && WPLANG) {
                 $langextra = '&lang=' . WPLANG;
             }
             $resultarray['urlredirect'] = 'http://www.mail-tester.com/check.php?id=' . urlencode($dummyReceiver->email) . $langextra;
         }
         $receivers[$key] = $dummyReceiver;
     }
     $emailClone = array();
     foreach ($emailObject as $kk => $vv) {
         $emailClone[$kk] = $vv;
     }
     $wjEngine =& WYSIJA::get('wj_engine', 'helper');
     // set data & styles
     if (isset($emailClone['wj_data'])) {
         $wjEngine->setData($emailClone['wj_data'], true);
     } else {
         $wjEngine->setData();
     }
     if (isset($emailClone['wj_styles'])) {
         $wjEngine->setStyles($emailClone['wj_styles'], true);
     } else {
         $wjEngine->setStyles();
     }
     // generate email html body
     $body = $wjEngine->renderEmail($emailClone);
     // get back email data as it will be updated during the rendering (articles ids + articles count)
     $emailChild = $wjEngine->getEmailData();
     if ((int) $emailChild['type'] === 2 && isset($emailChild['params']['autonl']['articles'])) {
         $itemCount = 0;
         $totalCount = 1;
         $firstSubject = '';
         if (isset($emailChild['params']['autonl']['articles']['count'])) {
             $itemCount = (int) $emailChild['params']['autonl']['articles']['count'];
         }
         if (isset($emailChild['params']['autonl']['articles']['first_subject'])) {
             $firstSubject = $emailChild['params']['autonl']['articles']['first_subject'];
         }
         if (isset($emailClone['params']['autonl']['total_child'])) {
             $totalCount = (int) $emailClone['params']['autonl']['total_child'] + 1;
         }
         if (empty($firstSubject)) {
             $this->error(__('There are no articles to be sent in this email.', WYSIJA), 1);
             return array('result' => false);
         }
         $emailObject->subject = str_replace(array('[total]', '[number]', '[post_title]'), array($itemCount, $totalCount, $firstSubject), $emailChild['subject']);
     }
     $successmsg = __('Your email preview has been sent to %1$s', WYSIJA);
     if (isset($emailObject->params)) {
         $params['params'] = $emailObject->params;
         if (isset($configVal['params[googletrackingcode'])) {
             $paramsemail = array();
             if (!is_array($emailObject->params)) {
                 $paramsemail = unserialize(base64_decode($emailObject->params));
             }
             if (trim($configVal['params[googletrackingcode'])) {
                 $paramsemail['googletrackingcode'] = $configVal['params[googletrackingcode'];
             } else {
                 unset($paramsemail['googletrackingcode']);
             }
             $params['params'] = base64_encode(serialize($paramsemail));
         }
     }
     $params['email_id'] = $emailObject->email_id;
     $receiversList = array();
     $res = false;
     foreach ($receivers as $receiver) {
         if ($mailer->sendSimple($receiver, stripslashes($emailObject->subject), $emailObject->body, $params)) {
             $res = true;
             $receiversList[] = $receiver->email;
         }
         WYSIJA::log('preview_sent', $mailer, 'manual');
     }
     if ($res === true) {
         $this->notice(sprintf($successmsg, implode(', ', $receiversList)));
     }
     $resultarray['result'] = $res;
     return $resultarray;
 }

 function insertAutoQueue($user_id, $email_id, $emailparams)
 {
     $modelQueue =& WYSIJA::get('queue', 'model');
     $queueData = array('priority' => '-1', 'email_id' => $email_id, 'user_id' => $user_id);
     $delay = 0;
     if (isset($emailparams['numberafter']) && (int) $emailparams['numberafter'] > 0) {
         switch ($emailparams['numberofwhat']) {
             case 'immediate':
                 $delay = 0;
                 break;
             case 'hours':
                 $delay = (int) $emailparams['numberafter'] * 3600;
                 break;
             case 'days':
                 $delay = (int) $emailparams['numberafter'] * 3600 * 24;
                 break;
             case 'weeks':
                 $delay = (int) $emailparams['numberafter'] * 3600 * 24 * 7;
                 break;
         }
         $queueData['send_at'] = time() + $delay;
     }
     if (isset($emailparams['unique_send']) && $emailparams['unique_send']) {
         $modelEUS =& WYSIJA::get('email_user_stat', 'model');
         if (!$modelEUS->exists(array('email_id' => $email_id, 'user_id' => $user_id))) {
             $modelQueue->insert($queueData);
         }
     } else {
         $modelQueue->insert($queueData);
     }
     if ($delay == 0) {
         $queueH =& WYSIJA::get('queue', 'helper');
         $queueH->report = false;
         WYSIJA::log('insertAutoQueue queue process', array('email_id' => $email_id, 'user_id' => $user_id));
         $queueH->process($email_id, $user_id);
     }
     return true;
 }

 /**
  * used in post notification scheme, it uses the model email to create a child to send when ready
  * @param array $email
  * @param boolean $immediatePostNotif
  * @return int next send value
  */
 function give_birth($email, $immediatePostNotif = false)
 {
     WYSIJA::log('give_birth_starts', $email['params']['autonl']['nextSend'], 'post_notif');
     //duplicate email with the right body and title set it as type 1
     if (isset($email['params']) && !is_array($email['params'])) {
         $this->getParams($email);
     }
     $emailChild = $email;
     $paramsVal = $email['params'];
     if (!isset($paramsVal['autonl']['total_child'])) {
         $paramsVal['autonl']['total_child'] = 0;
     }
     $paramsVal['autonl']['total_child']++;
     unset($emailChild['email_id']);
     unset($emailChild['created_at']);
     $emailChild['type'] = 1;
     $emailChild['status'] = 99;
     $emailChild['sent_at'] = time();
     $this->reset();
     unset($emailChild['params']['autonl']);
     // get articles ids used in previously sent childs
     $ids = !empty($paramsVal['autonl']['articles']['ids']) ? $paramsVal['autonl']['articles']['ids'] : array();
     // build autonl articles params for child
     $emailChild['params']['autonl']['articles'] = array('ids' => $ids, 'count' => 0, 'first_subject' => '');
     if (isset($email['params']['autonl']['firstSend'])) {
         $emailChild['params']['autonl']['firstSend'] = $email['params']['autonl']['firstSend'];
     }
     if (isset($email['params']['autonl']['lastSend'])) {
         $emailChild['params']['autonl']['lastSend'] = $email['params']['autonl']['lastSend'];
     }
     //if it's an immediate post notif let know the render email
     if ($immediatePostNotif) {
         $emailChild['params']['autonl']['articles']['immediatepostid'] = (int) $immediatePostNotif;
         //if this article is already set there is no reason to give birth to a child email
         if (isset($email['params']['autonl']['articles']['ids']) && in_array($immediatePostNotif, $email['params']['autonl']['articles']['ids'])) {
             return false;
         }
     }
     $wjEngine = WYSIJA::get('wj_engine', 'helper');
     // set data & styles
     if (isset($emailChild['wj_data'])) {
         $wjEngine->setData($emailChild['wj_data'], true);
     } else {
         $wjEngine->setData();
     }
     if (isset($emailChild['wj_styles'])) {
         $wjEngine->setStyles($emailChild['wj_styles'], true);
     } else {
         $wjEngine->setStyles();
     }
     // generate email html body
     $body = $wjEngine->renderEmail($emailChild);
     // get back email data as it will be updated during the rendering (articles ids + articles count)
     $emailChild = $wjEngine->getEmailData();
     $emailChild['body'] = $body;
     // update parent email articles' ids to reflect the ones added in the child email
     $paramsVal['autonl']['articles']['ids'] = $emailChild['params']['autonl']['articles']['ids'];
     // added new_ids parameter in order to know which articles are being used in that newsletter for instance with shortcodes
     if (!empty($email['params']['autonl']['articles']['ids'])) {
         $emailChild['params']['autonl']['articles']['new_ids'] = array_diff($emailChild['params']['autonl']['articles']['ids'], $email['params']['autonl']['articles']['ids']);
     } else {
         $emailChild['params']['autonl']['articles']['new_ids'] = $emailChild['params']['autonl']['articles']['ids'];
     }
     $donotsend = false;
     // if there's no article, do not send
     if ((int) $emailChild['params']['autonl']['articles']['count'] === 0) {
         $donotsend = true;
     }
     // we send if not told to not do it
     if (!$donotsend) {
         // Parse old subject shortcodes.
         $emailChild['subject'] = str_replace(array('[total]', '[number]', '[post_title]'), array((int) $emailChild['params']['autonl']['articles']['count'], (int) $paramsVal['autonl']['total_child'], $emailChild['params']['autonl']['articles']['first_subject']), $emailChild['subject']);
         $emailChild['params']['autonl']['total_child'] = (int) $paramsVal['autonl']['total_child'];
         // Get the email object, needed for the shortcode class.
         $current_email_object = (object) $emailChild;
         // Parse subject shortcodes.
         $helper_mailer = WYSIJA::get('mailer', 'helper');
         $helper_mailer->parseSubjectUserTags($current_email_object);
         // Replace subject shortcodes.
         $helper_shortcodes = WYSIJA::get('shortcodes', 'helper');
         $emailChild['subject'] = $helper_shortcodes->replace_subject($current_email_object);
         // save the child email
         $emailChild['params']['autonl']['parent'] = $email['email_id'];
         $this->dbg = false;
         //this line is to correct the crazy color so that it doesn't use the keepQry function.
         $emailChild['email_id'] = $this->insert($emailChild);
         $this->reset();
         WYSIJA::log('check_post_notif_give_birth_before_send', $emailChild, 'post_notif');
         $this->send_activate($emailChild);
     }
     WYSIJA::log('prev_send_value_give_birth', $email['params']['autonl']['nextSend'], 'post_notif');
     // update the parent with the new nextSend date
     $auton = WYSIJA::get('autonews', 'helper');
     $nextSendValue = $auton->getNextSend($email);
//.........这里部分代码省略.........

 /**
  * email has a late post notification which needs to be cancelled and postponed
  * @param array $email
  * @param int $how_late
  * @return boolean
  */
 function cancel_late_post_notification($email, $how_late)
 {
     $cancel_it = false;
     switch ($email['params']['autonl']['when-article']) {
         case 'daily':
             //cancel a daily notification with more than two hours delay
             if ($how_late > 2 * 3600) {
                 $cancel_it = true;
             }
             break;
         case 'weekly':
             //cancel a weekly notification with more than half a day delay
             if ($how_late > 12 * 3600) {
                 $cancel_it = true;
             }
             break;
         case 'monthly':
             //cancel a monthly notification with more than a day delay
             if ($how_late > 24 * 3600) {
                 $cancel_it = true;
             }
             break;
         case 'monthlyevery':
             //cancel a monthly notification with more than a day delay
             if ($how_late > 24 * 3600) {
                 $cancel_it = true;
             }
             break;
     }
     //if the notification is being cancelled then we store the value of that late notification and update the nextSend
     if ($cancel_it) {
         $late_send = $email['params']['autonl']['nextSend'];
         WYSIJA::log('cancel_late_post_notification_late_send', $late_send, 'post_notif');
         $next_send = $this->getNextSend($email);
         $email['params']['autonl']['nextSend'] = $next_send;
         $email['params']['autonl']['late_send'] = $late_send;
         $model_email = WYSIJA::get('email', 'model');
         $model_email->reset();
         $model_email->update(array('params' => $email['params']), array('email_id' => $email['email_id']));
         return true;
     }
     return false;
 }

    /**
     * this is used when we want to send the email immediately after inserting it into the queue
     * @param int $user_id
     * @param int $email_id
     * @param array $email_params_autonl
     * @return void
     */
    function insertAutoQueue($user_id,$email_id,$email_params_autonl){
        $model_queue=WYSIJA::get('queue','model');
        $queueData=array('priority'=>'-1','email_id'=>$email_id,'user_id'=>$user_id);

        $delay=$model_queue->calculate_delay($email_params_autonl);

        $queueData['send_at']=time()+$delay;

        if(!$model_queue->exists(array('email_id'=>$email_id,'user_id'=>$user_id))){
            //check if the email can be sent more than once
            if(isset($email_params_autonl['unique_send']) && $email_params_autonl['unique_send']){
                //check if the email has been sent to the user email_user_stat
                $modelEUS=WYSIJA::get('email_user_stat','model');
                if(!$modelEUS->exists(array('email_id'=>$email_id,'user_id'=>$user_id)))
                        $model_queue->insert($queueData,true);
            }else{
                $model_queue->insert($queueData,true);
            }
        }

        //if delay is = to 0 then we need to try to send the email straight away
        if($delay==0){
            $queueH=WYSIJA::get('queue','helper');
            $queueH->report=false;
            WYSIJA::log('insertAutoQueue queue process',array('email_id'=>$email_id,'user_id'=>$user_id),'queue_process');
            $queueH->process($email_id,$user_id);

        }
    }

 function _deleteQueue($queueDelete)
 {
     if (empty($queueDelete)) {
         return true;
     }
     $status = true;
     $modelQ =& WYSIJA::get("queue", "model");
     foreach ($queueDelete as $email_id => $subscribers) {
         $nbsub = count($subscribers);
         $realquery = 'DELETE FROM `[wysija]queue` WHERE email_id = ' . intval($email_id) . ' AND user_id IN (' . implode(',', $subscribers) . ') LIMIT ' . $nbsub;
         WYSIJA::log('helpers -> Queue ->process ->deleteQueue', $realquery);
         $res = $modelQ->query($realquery);
         if (!$res) {
             $status = false;
             WYSIJA::log('helpers -> Queue ->process ->deleteQueue failed', true);
         } else {
             WYSIJA::log('deleting queue ok', array('email_id' => $email_id, 'subscribers' => $subscribers));
             $nbdeleted = $modelQ->getAffectedRows();
             if ($nbdeleted != $nbsub) {
                 $status = false;
                 $this->_display(__("Newsletters are already being sent. Your latest newsletter will be sent afterwards.", WYSIJA));
             }
         }
     }
     return $status;
 }

    function logError(){
        if(defined('WYSIJA_DBG') && WYSIJA_DBG>1){
            global $wysija_queries_errors, $wpdb;
            if(!$wysija_queries_errors) $wysija_queries_errors=array();

            $this->sql_error=mysql_error($wpdb->dbh);

            if($this->sql_error) {
                $wysija_queries_errors[]=$this->sql_error;
                WYSIJA::log('queries_errors',$this->sql_error,'query_errors');
            }

        }

    }

 /**
  * post notification transition hook, know when a post really gets published
  * @param type $new_status
  * @param type $old_status
  * @param type $post
  * @return type
  */
 public static function hook_postNotification_transition($new_status, $old_status, $post)
 {
     //we run some process only if the status of the post changes from something to publish
     if ($new_status === 'publish' && $old_status !== $new_status) {
         $model_email = WYSIJA::get('email', 'model');
         $emails = $model_email->get(false, array('type' => 2, 'status' => array(1, 3, 99)));
         if (!empty($emails)) {
             //we loop through all of the automatic emails
             foreach ($emails as $key => $email) {
                 //we will try to give birth to a child email only if the automatic newsletter is a post notification email and in immediate mode
                 if (is_array($email) && $email['params']['autonl']['event'] === 'new-articles' && $email['params']['autonl']['when-article'] === 'immediate') {
                     // set default include/exclude categories
                     $include_category_ids = array();
                     $exclude_category_ids = array();
                     // ALC need to check for post_type on each block of the autoposts
                     $wj_data = maybe_unserialize(base64_decode($email['wj_data']));
                     $post_types = array();
                     $has_alc_blocks = false;
                     foreach ($wj_data['body'] as $block_key => $block) {
                         if ($block['type'] !== 'auto-post') {
                             continue;
                         }
                         $has_alc_blocks = true;
                         // get post type and post categories from block parameters
                         foreach ($block['params'] as $param_data) {
                             if (in_array($param_data['key'], array('post_type', 'cpt')) && strlen(trim($param_data['value'])) > 0) {
                                 // store post type
                                 $post_types[] = trim($param_data['value']);
                             } else {
                                 if ($param_data['key'] === 'category_ids' && strlen(trim($param_data['value'])) > 0) {
                                     // store post category ids
                                     $include_category_ids = array_map('intval', explode(',', trim($param_data['value'])));
                                 }
                             }
                         }
                     }
                     if ($has_alc_blocks === true && !in_array($post->post_type, $post_types)) {
                         continue;
                     }
                     // get post categories
                     $helper_wp_tools = WYSIJA::get('wp_tools', 'helper');
                     $taxonomies = $helper_wp_tools->get_post_category_ids($post);
                     // assume the post has to be sent
                     $do_send_post = true;
                     // post categories have to match at least one of the email's included categories
                     $include_intersection = array_intersect($taxonomies, $include_category_ids);
                     if (!empty($include_category_ids) && empty($include_intersection)) {
                         $do_send_post = false;
                     }
                     $exclude_intersection = array_intersect($taxonomies, $exclude_category_ids);
                     // post categories should not match any one of the email's excluded categories
                     if (!empty($exclude_category_ids) && !empty($exclude_intersection)) {
                         $do_send_post = false;
                     }
                     if ($do_send_post) {
                         WYSIJA::log('post_transition_hook_give_birth', array('post_id' => $post->ID, 'post_title' => $post->post_title, 'newsletter' => $email, 'old_status' => $old_status, 'new_status' => $new_status), 'post_notif');
                         $model_email->reset();
                         $model_email->give_birth($email, $post->ID);
                     }
                 }
             }
         }
         // we check for automatic latest content widget in automatic newsletter
         $helper_autonews = WYSIJA::get('autonews', 'helper');
         $helper_autonews->refresh_automatic_content();
     }
     return true;
 }

 function logError()
 {
     if (defined('WYSIJA_DBG') && WYSIJA_DBG > 1) {
         global $wysija_queries_errors, $wpdb;
         if (!$wysija_queries_errors) {
             $wysija_queries_errors = array();
         }
         $this->sql_error = $wpdb->last_error;
         if ($this->sql_error && (empty($this->last_error) || $this->last_error != $this->sql_error)) {
             $this->last_error = $wysija_queries_errors[] = $this->sql_error;
             $this->sql_error = false;
             WYSIJA::log('queries_errors', $this->sql_error, 'query_errors');
         }
     }
 }

 function get_posts($args = array())
 {
     if (!$args) {
         return false;
     }
     $customQuery = '';
     /**
      * SELECT A.ID, A.post_title, A.post_content, A.post_date FROM `wp_posts` A
      * LEFT JOIN `wp_term_relationships` B ON (A.ID = B.object_id)
      * LEFT JOIN `wp_term_taxonomy` C ON (C.term_taxonomy_id = B.term_taxonomy_id)
      * WHERE C.term_id IN (326) AND A.post_type IN ('post') AND A.post_status IN ('publish') ORDER BY post_date DESC LIMIT 0,10;
      *
      */
     $customQuery = 'SELECT DISTINCT A.ID, A.post_title, A.post_content, A.post_excerpt FROM `[wp]' . $this->table_name . '` A ';
     if (isset($args['category']) && $args['category']) {
         $customQuery .= 'JOIN `[wp]term_relationships` as B ON (A.ID = B.object_id) ';
         $customQuery .= 'JOIN `[wp]term_taxonomy` C ON (C.term_taxonomy_id = B.term_taxonomy_id) ';
     }
     $conditionsOut = $conditionsIn = array();
     foreach ($args as $col => $val) {
         if (!$val) {
             continue;
         }
         switch ($col) {
             case 'category':
                 //$conditionsIn['B.term_taxonomy_id']=array('sign'=>'IN','val' =>$val, 'cast' => 'int');
                 $conditionsIn['C.term_id'] = array('sign' => 'IN', 'val' => $val, 'cast' => 'int');
                 break;
             case 'include':
                 $conditionsIn['A.ID'] = array('sign' => 'IN', 'val' => $val, 'cast' => 'int');
                 break;
             case 'exclude':
                 $conditionsIn['A.ID'] = array('sign' => 'NOT IN', 'val' => $val, 'cast' => 'int');
                 break;
             case 'post_type':
                 $conditionsIn['A.post_type'] = array('sign' => 'IN', 'val' => $val);
                 break;
             case 'post_status':
                 $conditionsIn['A.post_status'] = array('sign' => 'IN', 'val' => $val);
                 break;
             case 'post_date':
                 //convert the date
                 $toob =& WYSIJA::get('toolbox', 'helper');
                 $val = $toob->time_tzed($val);
                 if ($val !== '') {
                     $conditionsIn['A.post_date'] = array('sign' => '>', 'val' => $val);
                 }
                 break;
             default:
         }
     }
     $customQuery .= 'WHERE ';
     $customQuery .= $this->setWhereCond($conditionsIn);
     if (isset($args['orderby'])) {
         $customQuery .= ' ORDER BY ' . $args['orderby'];
         if (isset($args['order'])) {
             $customQuery .= ' ' . $args['order'];
         }
     }
     if (isset($args['numberposts'])) {
         $customQuery .= ' LIMIT 0,' . $args['numberposts'];
     }
     WYSIJA::log('post notif qry', $customQuery, 'post_notif');
     return $this->query('get_res', $customQuery);
 }

 function hook_postNotification_transition($new_status, $old_status, $post)
 {
     WYSIJA::log('pn_transition_post', array('postID' => $post->ID, 'postID' => $post->post_title, 'old_status' => $old_status, 'new_status' => $new_status));
     if ($post->post_type == 'post' && $new_status == 'publish' && $old_status != $new_status) {
         $modelEmail =& WYSIJA::get('email', 'model');
         $emails = $modelEmail->get(false, array('type' => 2, 'status' => array(1, 3, 99)));
         foreach ($emails as $key => $email) {
             if ($email['params']['autonl']['event'] === 'new-articles' && $email['params']['autonl']['when-article'] === 'immediate') {
                 $modelEmail->reset();
                 $modelEmail->giveBirth($email, $post->ID);
             }
         }
     }
     return true;
 }

 function logError()
 {
     if (defined('WYSIJA_DBG') && WYSIJA_DBG > 1) {
         global $wysija_queries_errors, $wpdb;
         if (!$wysija_queries_errors) {
             $wysija_queries_errors = array();
         }
         $mysqlerror = mysql_error($wpdb->dbh);
         /* dbg($wpdb->last_query,0);
            dbg($wpdb,0);*/
         if ($mysqlerror) {
             $wysija_queries_errors[] = $mysqlerror;
             WYSIJA::log('queries_errors', $mysqlerror, 'query_errors');
         }
     }
 }