Beispiel #1
0
                 $newdata .= $firstexp[$i] . " ";
             }
             $formatted = trim($newdata);
         } else {
             $formatted = $firstexp[0];
         }
     }
     if (!$formatted && stristr($msg, "Just REPLY to this Email")) {
         $thirdexp = explode("Just REPLY to this Email", $msg);
         $formatted = $thirdexp[0];
     }
     if ($formatted) {
         $msg = $formatted;
     }
 } else {
     $msg = getEmailMsg($header, $message);
 }
 $query1 = "SELECT User.id,User.name,ProjectUser.company_id FROM users as User, project_users as ProjectUser WHERE User.email='" . $mail_id . "' AND User.id=ProjectUser.user_id AND ProjectUser.project_id='" . $row_pid['id'] . "'";
 $result1 = mysql_query($query1) or die('Query failed: ' . mysql_error());
 $row1 = mysql_fetch_assoc($result1);
 $user_id = $row1['id'];
 //user id of the sender
 $unq = md5(uniqid());
 //uniq id in md5 format
 $gmt_dttime = gmdate('Y-m-d H:i:s');
 $checkExists = mysql_num_rows(mysql_query("select id from easycases where message='" . addslashes($msg) . "' and user_id='" . $user_id . "' and project_id = '" . $row_pid['id'] . "' and title='' and case_no = '" . $cs_no . "'"));
 if ($checkExists >= 1) {
     echo "Same Post Postign Again...";
     continue;
 }
 if ($msg != "" && $user_id && mysql_num_rows($result)) {
Beispiel #2
0
                 $newdata .= $firstexp[$i] . " ";
             }
             $formatted = trim($newdata);
         } else {
             $formatted = $firstexp[0];
         }
     }
     if (!$formatted && stristr($msg, "Just REPLY to this Email")) {
         $thirdexp = explode("Just REPLY to this Email", $msg);
         $formatted = $thirdexp[0];
     }
     if ($formatted) {
         $msg = $formatted;
     }
 } else {
     $msg = getEmailMsg($header, $message, $row_pusers, $chk_multibyt);
 }
 /*$hj_test = fopen('wotextt_today_o_p.txt','a');
 		fwrite($hj_test,$cs_uniq_id);
 		fwrite($hj_test,$msg);
 		fwrite($hj_test,'----uid:'.$user_id);
 		fclose($hj_test);*/
 if ($msg != "" && $user_id && mysql_num_rows($result)) {
     //checking company is not cancel
     $task_posted = 1;
     $valid_comp = 0;
     if ($row1['company_id']) {
         $sqlCom = "SELECT id,is_free,is_cancel,subscription_id FROM  user_subscriptions as UserSubscription WHERE UserSubscription.company_id='" . $row1['company_id'] . "' ORDER BY created DESC LIMIT 1";
         $qryCom = mysql_query($sqlCom) or die('Query failed: ' . mysql_error());
         if (mysql_num_rows($qryCom)) {
             $resCom = mysql_fetch_assoc($qryCom);