public function init()
 {
     if (isset($_GET[_SUPPORT_HUB_LINK_REWRITE_PREFIX]) && strlen($_GET[_SUPPORT_HUB_LINK_REWRITE_PREFIX]) > 0) {
         // check hash
         $bits = explode(':', $_GET[_SUPPORT_HUB_LINK_REWRITE_PREFIX]);
         if (defined('AUTH_KEY') && isset($bits[1])) {
             $shub_message_link_id = (int) $bits[0];
             if ($shub_message_link_id > 0) {
                 $correct_hash = substr(md5(AUTH_KEY . ' shub extension link ' . $shub_message_link_id), 1, 5);
                 if ($correct_hash == $bits[1]) {
                     // link worked! log a visit and redirect.
                     $link = shub_get_single('shub_message_link', 'shub_message_link_id', $shub_message_link_id);
                     if ($link) {
                         if (!preg_match('#^http#', $link['link'])) {
                             $link['link'] = 'http://' . trim($link['link']);
                         }
                         shub_update_insert('shub_message_link_click_id', false, 'shub_message_link_click', array('shub_message_link_id' => $shub_message_link_id, 'click_time' => time(), 'ip_address' => $_SERVER['REMOTE_ADDR'], 'user_agent' => $_SERVER['HTTP_USER_AGENT'], 'url_referrer' => $_SERVER['HTTP_REFERER']));
                         header("Location: " . $link['link']);
                         exit;
                     }
                 }
             }
         }
     }
 }
 public function update($field, $value)
 {
     // what fields to we allow? or not allow?
     if (in_array($field, array('shub_item_id'))) {
         return;
     }
     if ($this->shub_item_id) {
         $this->{$field} = $value;
         if (in_array($field, $this->json_fields)) {
             $value = json_encode($value);
         }
         shub_update_insert('shub_item_id', $this->shub_item_id, 'shub_item', array($field => $value));
     }
 }
 public function update($field, $value = false)
 {
     if (is_array($field)) {
         foreach ($field as $key => $val) {
             if (isset($this->details[$key])) {
                 $this->update($key, $val);
             }
         }
         return;
     }
     // what fields to we allow? or not allow?
     if (in_array($field, array('shub_product_id'))) {
         return;
     }
     if ($this->shub_product_id) {
         $this->{$field} = $value;
         if (in_array($field, $this->json_fields)) {
             $value = json_encode($value);
         }
         shub_update_insert('shub_product_id', $this->shub_product_id, 'shub_product', array($field => $value));
     }
 }
 public function add_meta($key, $val)
 {
     if ((int) $this->shub_user_id > 0) {
         shub_update_insert(false, false, $this->db_table_meta, array('shub_user_id' => $this->shub_user_id, 'meta_key' => $key, 'meta_val' => $val));
     }
 }
 public function update_author_sale_history($debug = false, $do_all = false)
 {
     return;
     // todo: save sale history in db with no username/api key just for stats
     $api = $this->get_api();
     // how many days do we want to go back? maybe 60 days to start with?
     $last_sale = get_option('supporthub_envato_author_sales_last', false);
     if (!$last_sale) {
         $last_sale = strtotime('-360 days');
     }
     $last_sale_in_this_batch = 0;
     $page = 1;
     while (true) {
         $recent_sales = $api->api('v2/market/author/sales?page=' . $page, array(), true);
         //            echo "Recent sales are: ";print_r($recent_sales);exit;
         if ($debug) {
             echo "Page {$page} of sales data contained " . count($recent_sales) . " results.<br>\n";
         }
         $page++;
         if (!$recent_sales || !is_array($recent_sales)) {
             break;
         }
         foreach ($recent_sales as $recent_sale) {
             if ($recent_sale && !empty($recent_sale['sold_at']) && !empty($recent_sale['code']) && !empty($recent_sale['item']['id'])) {
                 //                    echo $recent_sale['sold_at']."<br>";
                 // add this to the database, or break if we already have this one in the db.
                 $sale_time = strtotime($recent_sale['sold_at']);
                 // we might already have this one in our database
                 // unless we are doing the intial seed
                 $existing_purchase = shub_get_single('shub_envato_purchase', array('purchase_code'), array($recent_sale['code']));
                 if ($existing_purchase) {
                     if (!$do_all) {
                         break 2;
                         // stop processing once we reach one we've already saved
                     }
                     continue;
                     // exists already in the db, skip to next one.
                 }
                 $last_sale_in_this_batch = max($last_sale_in_this_batch, $sale_time);
                 // todo: check if they add username to the system, for now we use a 0 shub_user_id because we're unsure which user this purchase is related to (without doing another separate purchase call)
                 if ($debug) {
                     echo " - adding new sale to database ( " . shub_print_date($sale_time, true) . " - " . $recent_sale['item']['name'] . " )...<br>\n";
                 }
                 // for now we do all processing based on this purchase code. SLOW. but until we get usernames in the buyer result there is no other way.
                 //                    echo "Query this code: ".$recent_sale['code'];exit;
                 SupportHub::getInstance()->message_managers['envato']->pull_purchase_code($api, $recent_sale['code'], $recent_sale);
                 update_option('supporthub_envato_author_sales_last', $last_sale_in_this_batch);
                 continue;
                 // save this purchase code into the db
                 // find the product this purchase is related to
                 $existing_products = SupportHub::getInstance()->get_products();
                 // check if this item exists already
                 $exists = false;
                 foreach ($existing_products as $existing_product) {
                     if (isset($existing_product['product_data']['envato_item_id']) && $existing_product['product_data']['envato_item_id'] == $recent_sale['item']['id']) {
                         $exists = $existing_product['shub_product_id'];
                     }
                 }
                 $newproduct = new SupportHubProduct();
                 if (!$exists) {
                     $newproduct->create_new();
                     if (!$newproduct->get('product_name')) {
                         $newproduct->update('product_name', $recent_sale['item']['name']);
                     }
                     $existing_product_data = $newproduct->get('product_data');
                     if (!is_array($existing_product_data)) {
                         $existing_product_data = array();
                     }
                     if (empty($existing_product_data['envato_item_id'])) {
                         $existing_product_data['envato_item_id'] = $recent_sale['item']['id'];
                     }
                     if (empty($existing_product_data['envato_item_data'])) {
                         $existing_product_data['envato_item_data'] = $recent_sale['item'];
                     }
                     if (empty($existing_product_data['image'])) {
                         $existing_product_data['image'] = $recent_sale['item']['thumbnail_url'];
                     }
                     if (empty($existing_product_data['url'])) {
                         $existing_product_data['url'] = $recent_sale['item']['url'];
                     }
                     $newproduct->update('product_data', $existing_product_data);
                 } else {
                     $newproduct->load($exists);
                 }
                 if ($newproduct->get('shub_product_id')) {
                     // product has been added
                     // time to add it to the purchase db
                     // check if this already exists in the db
                     $existing_purchase = shub_get_single('shub_envato_purchase', array('purchase_code'), array($recent_sale['code']));
                     if (!$existing_purchase) {
                         $shub_envato_purchase_id = shub_update_insert('shub_envato_purchase_id', false, 'shub_envato_purchase', array('shub_user_id' => 0, 'shub_product_id' => $newproduct->get('shub_product_id'), 'purchase_time' => $sale_time, 'envato_user_id' => 0, 'purchase_code' => $recent_sale['code'], 'api_type' => 'author/sales', 'purchase_data' => json_encode($recent_sale)));
                     } else {
                         $shub_envato_purchase_id = $existing_purchase['shub_envato_purchase_id'];
                     }
                     if ($shub_envato_purchase_id) {
                         // we have a purchase in the db
                         // add or update the support expiry based on this purchase history.
                         // work out when this purchase support expires
                         // this is the expiry date returned in the api or just 6 months from the original purchase date.
                         $support_expiry_time = strtotime("+6 months", $sale_time);
                         // todo - check for this expiry time in the new api results.
                         $existing_support = shub_get_single('shub_envato_support', array('shub_envato_purchase_id'), array($shub_envato_purchase_id));
                         if ($existing_support && $existing_support['shub_envato_support_id'] && $existing_support['start_time'] == $sale_time) {
                             // check the existing support expiry matches the one we have in the database.
                             if ($existing_support['end_time'] < $support_expiry_time) {
                                 // we have a support extension!
                                 $shub_envato_support_id = shub_update_insert('shub_envato_support_id', $existing_support['shub_envato_support_id'], 'shub_envato_support', array('end_time' => $support_expiry_time, 'api_type' => 'buyer/purchases', 'support_data' => json_encode($recent_sale)));
                             }
                         } else {
                             // we are adding a new support entry
                             $shub_envato_support_id = shub_update_insert('shub_envato_support_id', false, 'shub_envato_support', array('shub_user_id' => 0, 'shub_product_id' => $newproduct->get('shub_product_id'), 'shub_envato_purchase_id' => $shub_envato_purchase_id, 'start_time' => $sale_time, 'end_time' => $support_expiry_time, 'api_type' => 'author/sales', 'support_data' => json_encode($recent_sale)));
                         }
                     }
                 }
             }
         }
     }
 }
 public function extra_send_message($message, $network, $account_id, $message_id)
 {
     // save this message in the database as a new comment.
     // set the 'private' flag so we know this comment has been added externally to the API scrape.
     $shub_message = new shub_message(false, false, $message_id);
     $existing_comments = $shub_message->get_comments();
     shub_update_insert('shub_message_comment_id', false, 'shub_message_comment', array('shub_message_id' => $shub_message->get('shub_message_id'), 'private' => 1, 'message_text' => $message, 'time' => time(), 'shub_user_id' => !empty($_SESSION['shub_oauth_envato']['shub_user_id']) ? $_SESSION['shub_oauth_envato']['shub_user_id'] : $shub_message->get('shub_user_id')));
     // mark the main message as unread so it appears at the top.
     $shub_message->update('shub_status', _shub_MESSAGE_STATUS_UNANSWERED);
     $shub_message->update('last_active', time());
     // todo: update the 'summary' to reflect this latest message?
     $shub_message->update('summary', $message);
     // todo: post a "Thanks for providing information, we will reply soon" message on Envato comment page
 }
 public function queue_reply($network_key, $message, $debug = false, $extra_data = array(), $shub_outbox_id = false)
 {
     if ($this->account && $this->shub_message_id) {
         if ($debug) {
             echo "Type: " . $this->get('shub_type') . " <br>\n";
         }
         if (!$network_key) {
             $network_key = $this->get('network_key');
         }
         if ($debug) {
             echo "Sending a reply to Network Message ID: {$network_key} <br>\n";
         }
         $reply_user = $this->get_reply_user();
         // add a placeholder in the comments table, next time the cron runs it should pick this up and fill in all the details correctly from the API
         $shub_message_comment_id = shub_update_insert('shub_message_comment_id', false, 'shub_message_comment', array('shub_message_id' => $this->shub_message_id, 'shub_user_id' => $reply_user ? $reply_user->get('shub_user_id') : 0, 'shub_outbox_id' => $shub_outbox_id, 'network_key' => '', 'time' => time(), 'message_text' => $message, 'user_id' => get_current_user_id()));
         if ($debug) {
             echo "Successfully added comment with id {$shub_message_comment_id} <br>\n";
         }
         return $shub_message_comment_id;
     }
     return false;
 }
 public function send_queued_comment_reply($envato_message_comment_id, $shub_outbox, $debug = false)
 {
     $comments = $this->get_comments();
     if (isset($comments[$envato_message_comment_id]) && !empty($comments[$envato_message_comment_id]['message_text'])) {
         $api = $this->account->get_api();
         $outbox_data = $shub_outbox->get('message_data');
         if ($outbox_data && isset($outbox_data['extra']) && is_array($outbox_data['extra'])) {
             $extra_data = $outbox_data['extra'];
         } else {
             $extra_data = array();
         }
         $api_result = $api->api('ticket', 'reply', array('ticket_id' => $this->get('network_key'), 'message' => $comments[$envato_message_comment_id]['message_text'], 'extra_data' => $extra_data));
         if ($api_result && !empty($api_result['ticket_message_id'])) {
             if ($debug) {
                 echo 'UCM API Result:';
                 print_r($api_result);
             }
             // add a placeholder in the comments table, next time the cron runs it should pick this up and fill in all the details correctly from the API
             shub_update_insert('shub_message_comment_id', $envato_message_comment_id, 'shub_message_comment', array('network_key' => $api_result['ticket_message_id'], 'time' => time()));
             return true;
         } else {
             echo "Failed to send comment, check debug log. " . var_export($api_result, true);
             return false;
         }
     }
     echo 'No comment found to send.';
     return false;
 }
Ejemplo n.º 9
0
 public function update($field, $value = false)
 {
     if (is_array($field)) {
         foreach ($field as $key => $val) {
             $this->update($key, $val);
         }
         return;
     }
     // what fields to we allow? or not allow?
     if (in_array($field, array($this->db_primary_key))) {
         return;
     }
     if ($this->{$this->db_primary_key} && isset($this->details[$field])) {
         $this->{$field} = $value;
         $this->details[$field] = $value;
         if (in_array($field, $this->json_fields)) {
             $value = json_encode($value);
         }
         shub_update_insert($this->db_primary_key, $this->{$this->db_primary_key}, $this->db_table, array($field => $value));
     }
 }
 public function log_data($error_level, $extension, $subject, $data = array())
 {
     if (get_option('shub_logging_enabled', 0) > time() || $error_level > 0) {
         shub_update_insert('shub_log_id', false, 'shub_log', array('log_time' => time(), 'log_error_level' => $error_level, 'log_extension' => $extension, 'log_subject' => $subject, 'log_data' => $data ? serialize($data) : ''));
     }
 }
 public function update_purchase_history()
 {
     $tokens = shub_get_multiple('shub_envato_oauth', array('shub_user_id' => $this->shub_user_id));
     // find the latest token for this user, per account.
     $account_tokens = array();
     // if any of them have expired, refresh the token from the api
     foreach ($tokens as $token) {
         if (!$token['shub_account_id']) {
             continue;
         }
         if (!isset($account_tokens[$token['shub_account_id']]) || $token['expire_time'] > $account_tokens[$token['shub_account_id']]['expire_time']) {
             $account_tokens[$token['shub_account_id']] = $token;
         }
     }
     foreach ($account_tokens as $account_token) {
         $shub_envato_account = new shub_envato_account($account_token['shub_account_id']);
         // found the account, pull in the API and build the url
         $api = $shub_envato_account->get_api();
         $api->set_manual_token($account_token);
         if ($account_token['expire_time'] <= time()) {
             // renew this token!
             $new_access_token = $api->refresh_token();
             if ($new_access_token) {
                 shub_update_insert('shub_envato_oauth_id', $account_token['shub_envato_oauth_id'], 'shub_envato_oauth', array('access_token' => $new_access_token, 'expire_time' => time() + 3600));
             } else {
                 echo 'Token refresh failed';
                 return false;
             }
         }
         $api_result = $api->api('v1/market/private/user/username.json', array(), false);
         $api_result_email = $api->api('v1/market/private/user/email.json', array(), false);
         if ($api_result && !empty($api_result['username'])) {
             $this->add_unique_meta('envato_username', $api_result['username']);
         }
         if ($api_result_email && !empty($api_result_email['email'])) {
             $email = trim(strtolower($api_result_email['email']));
             // todo: not sure if best to update users eamail , if they change email accounts and stuff
             $this->update('user_email', $email);
         }
         $api_result_purchase_history = $api->api('v2/market/buyer/purchases', array(), false);
         // store this purchase history in our db for later use.
         if ($api_result_purchase_history && !empty($api_result_purchase_history['buyer']['id']) && !empty($api_result_purchase_history['buyer']['username']) && $api_result_purchase_history['buyer']['username'] == $api_result['username']) {
             // we have the buyer ID! yay! this is better than a username.
             $this->add_unique_meta('envato_user_id', $api_result_purchase_history['buyer']['id']);
             if (!empty($api_result_purchase_history['purchases']) && is_array($api_result_purchase_history['purchases'])) {
                 foreach ($api_result_purchase_history['purchases'] as $purchase) {
                     if (!empty($purchase['item']['id'])) {
                         // todo: beg envato to add the purchase code to this output so we can link it together correctly.
                         // find out which shub product this is for
                         // if we cannot find one then we create one. this helps when new items are made.
                         $existing_products = SupportHub::getInstance()->get_products();
                         // check if this item exists already
                         $exists = false;
                         foreach ($existing_products as $existing_product) {
                             if (isset($existing_product['product_data']['envato_item_id']) && $existing_product['product_data']['envato_item_id'] == $purchase['item']['id']) {
                                 $exists = $existing_product['shub_product_id'];
                             }
                         }
                         $newproduct = new SupportHubProduct();
                         if (!$exists) {
                             $newproduct->create_new();
                         } else {
                             $newproduct->load($exists);
                         }
                         if (!$newproduct->get('product_name')) {
                             $newproduct->update('product_name', $purchase['item']['name']);
                         }
                         $existing_product_data = $newproduct->get('product_data');
                         if (!is_array($existing_product_data)) {
                             $existing_product_data = array();
                         }
                         if (empty($existing_product_data['envato_item_id'])) {
                             $existing_product_data['envato_item_id'] = $purchase['item']['id'];
                         }
                         if (empty($existing_product_data['envato_item_data'])) {
                             $existing_product_data['envato_item_data'] = $purchase['item'];
                         }
                         if (empty($existing_product_data['image'])) {
                             $existing_product_data['image'] = $purchase['item']['thumbnail_url'];
                         }
                         if (empty($existing_product_data['url'])) {
                             $existing_product_data['url'] = $purchase['item']['url'];
                         }
                         $newproduct->update('product_data', $existing_product_data);
                         if ($newproduct->get('shub_product_id')) {
                             // product has been added
                             // time to add it to the purchase db
                             // check if this already exists in the db
                             $existing_purchase = shub_get_single('shub_envato_purchase', array('purchase_code'), array($purchase['code']));
                             if (!$existing_purchase) {
                                 $shub_envato_purchase_id = shub_update_insert('shub_envato_purchase_id', false, 'shub_envato_purchase', array('shub_user_id' => $this->get('shub_user_id'), 'shub_product_id' => $newproduct->get('shub_product_id'), 'purchase_time' => strtotime($purchase['sold_at']), 'envato_user_id' => $api_result_purchase_history['buyer']['id'], 'purchase_code' => $purchase['code'], 'api_type' => 'buyer/purchases', 'purchase_data' => json_encode($purchase)));
                             } else {
                                 if (!$existing_purchase['shub_user_id']) {
                                     shub_update_insert('shub_envato_purchase_id', $existing_purchase['shub_envato_purchase_id'], 'shub_envato_purchase', array('shub_user_id' => $this->get('shub_user_id')));
                                 }
                                 $shub_envato_purchase_id = $existing_purchase['shub_envato_purchase_id'];
                             }
                             if ($shub_envato_purchase_id) {
                                 // we have a purchase in the db
                                 // add or update the support expiry based on this purchase history.
                                 // work out when this purchase support expires
                                 // this is the expiry date returned in the api or just 6 months from the original purchase date.
                                 $support_expiry_time = strtotime("+6 months", strtotime($purchase['sold_at']));
                                 // todo - check for this expiry time in the new api results.
                                 $existing_support = shub_get_single('shub_envato_support', array('shub_envato_purchase_id'), array($shub_envato_purchase_id));
                                 if ($existing_support && empty($existing_support['shub_user_id'])) {
                                     shub_update_insert('shub_envato_support_id', $existing_support['shub_envato_support_id'], 'shub_envato_support', array('shub_user_id' => $this->get('shub_user_id')));
                                 }
                                 if ($existing_support && $existing_support['shub_envato_support_id'] && $existing_support['start_time'] == strtotime($purchase['sold_at'])) {
                                     // check the existing support expiry matches the one we have in the database.
                                     if ($existing_support['end_time'] < $support_expiry_time) {
                                         // we have a support extension!
                                         $shub_envato_support_id = shub_update_insert('shub_envato_support_id', $existing_support['shub_envato_support_id'], 'shub_envato_support', array('end_time' => $support_expiry_time, 'api_type' => 'buyer/purchases', 'support_data' => json_encode($purchase)));
                                     }
                                 } else {
                                     // we are adding a new support entry
                                     $shub_envato_support_id = shub_update_insert('shub_envato_support_id', false, 'shub_envato_support', array('shub_user_id' => $this->get('shub_user_id'), 'shub_product_id' => $newproduct->get('shub_product_id'), 'shub_envato_purchase_id' => $shub_envato_purchase_id, 'start_time' => strtotime($purchase['sold_at']), 'end_time' => $support_expiry_time, 'api_type' => 'buyer/purchases', 'support_data' => json_encode($purchase)));
                                 }
                             }
                         }
                     }
                 }
             }
         }
     }
     return true;
 }
 public function send_queued_comment_reply($bbpress_message_comment_id, $shub_outbox, $debug = false)
 {
     $comments = $this->get_comments();
     if (isset($comments[$bbpress_message_comment_id]) && !empty($comments[$bbpress_message_comment_id]['message_text'])) {
         $api = $this->account->get_api();
         //$item_data = $this->get('item')->get('item_data');
         $bbpress_post_data = $this->get('shub_data');
         $bbpress_id = $this->get('network_key');
         if ($debug) {
             echo "Sending a reply to bbPress Topic ID: {$bbpress_id} <br>\n";
         }
         $outbox_data = $shub_outbox->get('message_data');
         if ($outbox_data && isset($outbox_data['extra']) && is_array($outbox_data['extra'])) {
             $extra_data = $outbox_data['extra'];
         } else {
             $extra_data = array();
         }
         $api_result = false;
         try {
             $extra_data['api'] = 1;
             $api_result = $api->newPost('Reply to: ' . (isset($bbpress_post_data['post_title']) ? $bbpress_post_data['post_title'] : 'Post'), $comments[$bbpress_message_comment_id]['message_text'], array('post_type' => 'reply', 'post_parent' => $bbpress_id, 'custom_fields' => array(array('key' => 'support_hub', 'value' => json_encode($extra_data)))));
             SupportHub::getInstance()->log_data(_SUPPORT_HUB_LOG_INFO, 'bbpress', 'API Result: ', $api_result);
         } catch (Exception $e) {
             SupportHub::getInstance()->log_data(_SUPPORT_HUB_LOG_ERROR, 'bbpress', 'API Error: ', $e);
             if ($debug) {
                 echo "API Error: " . $e;
             }
         }
         if ((int) $api_result > 0) {
             shub_update_insert('shub_message_comment_id', $bbpress_message_comment_id, 'shub_message_comment', array('network_key' => $api_result, 'time' => time()));
             return true;
         } else {
             echo "Failed to send comment, check debug log.";
             print_r($api_result);
             return false;
         }
         /*if((int) $api_result > 0){
                         // we have a post id for our reply!
                         // add this reply to the 'comments' array of our existing 'message' object.
         
                         // grab the updated post details for both the parent topic and the newly created reply:
                         $parent_topic = $api->getPost($this->get('network_key'));
                         SupportHub::getInstance()->log_data(_SUPPORT_HUB_LOG_INFO, 'bbpress', 'API Result: ', $api_result);
                         $reply_post = $api->getPost($api_result);
                         SupportHub::getInstance()->log_data(_SUPPORT_HUB_LOG_INFO, 'bbpress', 'API Result: ', $api_result);
         
                         if($parent_topic && $parent_topic['post_id'] == $this->get('network_key') && $reply_post && $reply_post['post_id'] == $api_result && $reply_post['post_parent'] == $this->get('network_key')){
                             // all looks hunky dory
                             $comments = $this->get('comments');
                             if(!is_array($comments))$comments = array();
                             array_unshift($comments, $reply_post);
                             $parent_topic['replies'] = $comments;
                             // save this updated data to the db
                             $this->load_by_bbpress_id($this->get('network_key'),$parent_topic,$this->get('shub_type'),$debug);
                             $existing_messages = $this->get_comments();
                             foreach($existing_messages as $existing_message){
                                 if(!$existing_message['user_id'] && $existing_message['message_text'] == $comments[$bbpress_message_comment_id]['message_text']){
                                     shub_update_insert('shub_message_comment_id',$existing_message['shub_message_comment_id'],'shub_message_comment',array(
                                         'user_id' => get_current_user_id(),
                                     ));
                                 }
                             }
                             $this->update('shub_status', _shub_MESSAGE_STATUS_ANSWERED);
                         }
         
                     }*/
     }
     return false;
 }
 public function update($field, $value)
 {
     // what fields to we allow? or not allow?
     if (in_array($field, array('shub_account_id'))) {
         return;
     }
     if ($this->shub_account_id) {
         if ($field == 'account_data') {
             if (is_array($value)) {
                 // merge data with existing.
                 $existing_data = $this->get('account_data');
                 if (!is_array($existing_data)) {
                     $existing_data = array();
                 }
                 $value = array_merge($existing_data, $value);
             }
         }
         $this->{$field} = $value;
         if (in_array($field, $this->json_fields)) {
             $value = json_encode($value);
         }
         shub_update_insert('shub_account_id', $this->shub_account_id, 'shub_account', array($field => $value));
     }
 }
 public function send_queued_comment_reply($envato_message_comment_id, $shub_outbox, $debug = false)
 {
     $comments = $this->get_comments();
     if (isset($comments[$envato_message_comment_id]) && !empty($comments[$envato_message_comment_id]['message_text'])) {
         $api = $this->account->get_api();
         $item_data = $this->get('item')->get('item_data');
         if ($item_data && $item_data['url']) {
             $api_result = $api->post_comment($item_data['url'] . '/comments', $this->get('network_key'), $comments[$envato_message_comment_id]['message_text']);
             if ($api_result) {
                 // add a placeholder in the comments table, next time the cron runs it should pick this up and fill in all the details correctly from the API
                 shub_update_insert('shub_message_comment_id', $envato_message_comment_id, 'shub_message_comment', array('network_key' => $api_result, 'time' => time()));
                 return true;
             } else {
                 echo "Failed to send comment, check debug log.";
                 return false;
             }
         }
     }
     return false;
 }