Online PHP editor | vld for DDjv0

<?php require(INCLUDE_URL.SEP.'phpmailer/class.phpmailer.php'); include_once("popup.php"); if(!xml2php("workorder")) { $smarty->assign('error_msg',"Error in language file"); } $login_id = $_SESSION['login_id']; $smarty->assign('login_id', $login_id); $wo_id = $VAR['wo_id']; $smarty->assign('wo_id', $wo_id); $company = $VAR['company']; $smarty->assign('company', $company); $customer_id = $VAR['customer_id']; $smarty->assign('customer_id', $customer_id); //pass message type from url $msg_type = $VAR['msg_type']; $smarty->assign('msg_type', $msg_type); $smarty->assign('msg_id', $VAR['msg_id']); $rep_date=date('D, d M Y - h:i A'); //set template for individual messages $eml_template=<<<EOF <table align="center" cellpadding="0" cellspacing="0" style="margin: 0px auto; text-align: left; color: rgb(153, 153, 153); line-height: 15pt; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal; border-collapse: collapse;" width="100%"> <tbody> <tr> <td bgcolor="#ffffff" valign="top"> </td> </tr> <tr> <td bgcolor="#ffffff" style="padding: 15px 20px; color: rgb(102, 102, 102); line-height: 15pt;"> <hr style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border:1px solid #f3f3f3"/> <p style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"><input alt="" src="[[employee_pic]]" style="width: 50px; height: 50px; float: left; margin: 0px 10px; border-width: 1px; border-style: solid;" type="image" /><span style="font-family:lucida sans unicode,lucida grande,sans-serif;"><span style="font-size:14px;">[[fname]] [[lname]] - [[date]] @ [[time]]</span></span></p> <div> <div style="border: 0px solid rgb(255, 255, 255); padding: 5px 10px; margin-left: 70px; margin-top: -10px; background-image: initial; background-attachment: initial; background-color: rgb(255, 255, 255); background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"> <p><span style="font-family: 'lucida sans unicode', 'lucida grande', sans-serif; font-size: 14px; color: rgb(102, 102, 102); line-height: 15px; background-color: rgb(255, 255, 255);"></span><span style="color: rgb(102, 102, 102); line-height: 15px; background-color: rgb(255, 255, 255);"><font face="arial, helvetica, sans-serif">[[msg]]</font></span></p> <p style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"> </p> </div> </div> <hr style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; border:1px solid #f3f3f3"/> <p style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;"> </p> </td> </tr> <tr> <td height="20" style="line-height: 2px; font-size: 2px;"><img alt="" border="0" height="20" src="http://computergeeksrus.com/email/images/shadow620.gif" style="display: block;" width="100%" /></td> </tr> </tbody> </table> EOF; /* Get Ticket info*/ $q = "SELECT ".PRFX."TABLE_WORK_ORDER.*, ".PRFX."TABLE_CUSTOMER.* FROM ".PRFX."TABLE_WORK_ORDER LEFT JOIN ".PRFX."TABLE_CUSTOMER ON ".PRFX."TABLE_WORK_ORDER.CUSTOMER_ID = ".PRFX."TABLE_CUSTOMER.CUSTOMER_ID WHERE WORK_ORDER_ID=".$db->qstr($wo_id); if(!$rs = $db->execute($q)){ force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database'); exit; } else { $email_info = $rs->GetArray(); } $smarty->assign('email_info', $email_info); /* Get Company Email Address*/ $q = "SELECT COMPANY_EMAIL FROM ".PRFX."TABLE_COMPANY"; if(!$rs = $db->execute($q)) { force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database'); exit; } $company_email = $rs->fields['COMPANY_EMAIL']; $smarty->assign('company_email', $company_email); if($VAR['msg_type']!='new' && ($VAR['msg_type']=='reply' || $VAR['msg_type']=='forward')){ if(ctype_digit($VAR['msg_id'])){ $q = "SELECT MSG FROM ".PRFX."TABLE_WORK_ORDER_MESSAGE WHERE MSG_WORK_ORDER_ID='$wo_id' AND MSG_ID='".$VAR['msg_id']."' LIMIT 1"; } else { $q = "SELECT MSG FROM ".PRFX."TABLE_WORK_ORDER_MESSAGE WHERE MSG_WORK_ORDER_ID='$wo_id' ORDER BY MSG_ID DESC"; } if(!$rs = $db->execute($q)){ force_page('core', 'error&error_msg=Could not get Messages'); exit; } else { //$ticket_message= $rs->fields['MSG']; $ticket_message = $rs->GetArray(); } $all_messages=NULL; //loop messages foreach ($ticket_message as $m) { $this_msg=str_replace('[[msg]]', $m['MSG'], $eml_template); $this_msg=str_replace('[[employee_pic]]', get_employee_profile_pic($login_id), $this_msg); $this_msg=str_replace('[[date]]', strtotime($m['MSG_CREATED_ON']), $this_msg); $this_msg=str_replace('@ [[time]]', '', $this_msg); $all_messages.=$this_msg; } } elseif($VAR['msg_type']=='new'){ $all_messages=str_replace('[[msg]]', $VAR['ticket_msg'], $eml_template); $all_messages=str_replace('[[employee_pic]]', get_employee_profile_pic($login_id), $all_messages); $all_messages=str_replace('[[date]]', str_replace(" - ", " @ ", $rep_date), $all_messages); } if($VAR['msg_type']=='forward'){ $smarty->assign('message_content', "<br/><br/><br/><div style='text-align:center;color:#999;'>----FORWARDED EMAIL----</div><br/>".$all_messages); } /*Update Ticket message*/ if(isset($_POST['send_email'])) { //Remove Extra Slashes caused by Magic Quotes $msg = $VAR['ticket_msg']; $clean_msg = preg_replace("/<p[^>]*?>/", "", $msg); $clean_msg = str_replace("</p>", "<br />", $clean_msg); //$description_string2=("<br/><hr><u>Replied On $rep_date by $login </u><br/>$description_string"); $sql = "INSERT INTO ".PRFX."TABLE_WORK_ORDER_MESSAGE SET MSG_WORK_ORDER_ID =".$db->qstr($wo_id).", MSG_CUSTOMER_ID =".$db->qstr($customer_id).", MSG_SOURCE =". $db->qstr('System').", MSG =". $db->qstr($clean_msg).", MSG_EMPLOYEE_ID =". $db->qstr($login_id); if(!$result = $db->Execute($sql)) { force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database'); exit; } /*Get Full Description to send to Email*/ /*$sql = mysql_query("SELECT MSG FROM ".PRFX."TABLE_WORK_ORDER_MESSAGE WHERE MSG_WORK_ORDER_ID='$wo_id' ORDER BY MSG_ID DESC"); $sql=mysql_fetch_array($sql); //$ticket_message=$sql['MSG']; */ /*Send the email*/ $emailto=$VAR["email_to"]; $email_from="$company_email"; $email_subject=$VAR["email_subject"]; $html=$all_messages; $email_priority=$VAR["email_priority"]; $email_cc=$VAR["email_cc"]; $subject = "$email_subject"; $mailer = "$email_from"; $headers = "From: $mailer \r\n"; $headers .= "Reply-To: $mailer\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; $headers .= "Importance: $email_priority\r\n"; $message = '<html><head> tyle type="text/css">body { margin:0; padding:0; background-color:#eeeeee; color:#999999; font-family:Arial, Helvetica, sans-serif; font-size:12px; -webkit-text-size-adjust: none; } h1, h2, h3, h4, h5, h6 { color:#39434d !important; margin-bottom:10px !important; } a, a:link, a:visited { color:#777777; text-decoration:none; border-bottom:1px #777777 dotted; } a:hover, a:active { text-decoration:none; color:#0f79aa !important; border-bottom:1px #0f79aa dotted !important; } p { line-height:15px; } img { border:0; } /*Hotmail and Yahoo specific code*/ .ReadMsgBody { width: 100%;} .ExternalClass {width: 100%;} .yshortcuts { color: #999999 } .yshortcuts a span { color: #777777 } </style> </head> <body style="background:#ffffff"> <table align="center" cellpadding="0" cellspacing="0" id="container" style="margin: 0px; padding: 0px; width: 100%; background-color: rgb(238, 238, 238);"> <tbody> <tr> <td style="padding: 0px 20px;"> '; $message .= $html; $message .= ' <tr> <td bgcolor="#ffffff" style="padding: 15px 20px; color: rgb(51, 51, 51); line-height: 15pt; font-family: Arial, Helvetica, sans-serif; font-size: 13px; border-top-color: rgb(235, 235, 235); border-top-width: 1px; border-top-style: solid;"> <p style="text-align: center;"><span style="color: rgb(169, 169, 169);"><span style="font-family: comic sans ms,cursive;">Thank you for choosing ComputerGeeksrus. Trust, Integrity and your best Interest first!      </span></span></p> </td> </tr>  <table align="center" cellpadding="0" cellspacing="0" style="margin: 0px auto; text-align: left; color: rgb(153, 153, 153); line-height: 15pt; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal; border-collapse: collapse;" width="100%"> <tbody> <tr> </tr> <tr> </tr> </tbody> </table> </td> </tr> </tbody> </table> </body></html>'; $headers .= "Cc: $email_cc \r\n"; /* mail($emailto, $subject, $message, $headers); */ $email = new PHPMailer(); $email->From = $email_from; $email->FromName = $mailer; $email->addReplyTo($email_from); $email->addCC($email_cc); $email->Subject = $subject; $email->Body = $message; $email->AddAddress( $emailto ); $email->isHTML(true); if($email_priority=="Medium") $email->Priority = 3; if($email_priority=="High") $email->Priority = 1; if($email_priority=="Low") $email->Priority = 5; $email->AddCustomHeader("X-MSMail-Priority: $email_priority"); $email->AddCustomHeader("Importance: $email_priority"); if(count($VAR['add_attachments'])>0){ $attachments_select="('".implode("', '", $VAR['add_attachments'])."')"; //select all attachments $q = "SELECT * FROM ".PRFX."TABLE_WORK_ORDER_ATTACHMENTS WHERE `WO_ID`=".$db->qstr($wo_id)." AND `ATTACHMENT_ID` IN $attachments_select ORDER BY `ATTACHMENT_ID` DESC"; if(!$rs = $db->execute($q)) { force_page('core', 'error&error_msg=MySQL Error: '.$db->ErrorMsg().'&menu=1&type=database'); exit; } $attachments = $rs->GetArray(); foreach($attachments as $a){ $file=$a['WO_ID']."_".$a['ATTACHMENT_NUMBER']."_".$a['ATTACHMENT_FILE']; $email->addAttachment(FILE_ROOT.'upload/message_store/'.$file, $file); } } if(!$email->send()) { force_page('core', 'error&error_msg=Mail error: '.$email->ErrorInfo.'&menu=1'); exit(); } else { force_page('workorder', 'view&wo_id='.$wo_id.'&customer_id='.$customer_id.'&company_id='.$company_id.'&page_title=Ticket# '.$wo_id.''); exit(); } } $add_attachments=NULL; foreach ($VAR['add_attachments'] as $a){ $add_attachments.="<input type='hidden' name='add_attachments[]' value='$a'/>"; } $smarty->assign('add_attachments', $add_attachments); $smarty->display('workorder'.SEP.'send_email.tpl'); ?>

Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 11, Position 2 = 15
Branch analysis from position: 11
2 jumps found. (Code = 43) Position 1 = 86, Position 2 = 96
Branch analysis from position: 86
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 96
2 jumps found. (Code = 43) Position 1 = 113, Position 2 = 122
Branch analysis from position: 113
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 122
2 jumps found. (Code = 46) Position 1 = 132, Position 2 = 139
Branch analysis from position: 132
2 jumps found. (Code = 47) Position 1 = 135, Position 2 = 138
Branch analysis from position: 135
2 jumps found. (Code = 43) Position 1 = 140, Position 2 = 217
Branch analysis from position: 140
2 jumps found. (Code = 43) Position 1 = 145, Position 2 = 156
Branch analysis from position: 145
1 jumps found. (Code = 42) Position 1 = 163
Branch analysis from position: 163
2 jumps found. (Code = 43) Position 1 = 169, Position 2 = 175
Branch analysis from position: 169
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 175
2 jumps found. (Code = 77) Position 1 = 180, Position 2 = 215
Branch analysis from position: 180
2 jumps found. (Code = 78) Position 1 = 181, Position 2 = 215
Branch analysis from position: 181
1 jumps found. (Code = 42) Position 1 = 180
Branch analysis from position: 180
Branch analysis from position: 215
1 jumps found. (Code = 42) Position 1 = 247
Branch analysis from position: 247
2 jumps found. (Code = 43) Position 1 = 250, Position 2 = 255
Branch analysis from position: 250
2 jumps found. (Code = 43) Position 1 = 258, Position 2 = 483
Branch analysis from position: 258
2 jumps found. (Code = 43) Position 1 = 306, Position 2 = 315
Branch analysis from position: 306
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 315
2 jumps found. (Code = 43) Position 1 = 376, Position 2 = 378
Branch analysis from position: 376
2 jumps found. (Code = 43) Position 1 = 380, Position 2 = 382
Branch analysis from position: 380
2 jumps found. (Code = 43) Position 1 = 384, Position 2 = 386
Branch analysis from position: 384
2 jumps found. (Code = 43) Position 1 = 400, Position 2 = 457
Branch analysis from position: 400
2 jumps found. (Code = 43) Position 1 = 426, Position 2 = 435
Branch analysis from position: 426
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 435
2 jumps found. (Code = 77) Position 1 = 439, Position 2 = 456
Branch analysis from position: 439
2 jumps found. (Code = 78) Position 1 = 440, Position 2 = 456
Branch analysis from position: 440
1 jumps found. (Code = 42) Position 1 = 439
Branch analysis from position: 439
Branch analysis from position: 456
2 jumps found. (Code = 43) Position 1 = 461, Position 2 = 470
Branch analysis from position: 461
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 470
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 456
Branch analysis from position: 457
Branch analysis from position: 386
Branch analysis from position: 382
Branch analysis from position: 378
Branch analysis from position: 483
2 jumps found. (Code = 77) Position 1 = 486, Position 2 = 492
Branch analysis from position: 486
2 jumps found. (Code = 78) Position 1 = 487, Position 2 = 492
Branch analysis from position: 487
1 jumps found. (Code = 42) Position 1 = 486
Branch analysis from position: 486
Branch analysis from position: 492
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 492
Branch analysis from position: 255
Branch analysis from position: 215
Branch analysis from position: 156
2 jumps found. (Code = 43) Position 1 = 169, Position 2 = 175
Branch analysis from position: 169
Branch analysis from position: 175
Branch analysis from position: 217
2 jumps found. (Code = 43) Position 1 = 220, Position 2 = 247
Branch analysis from position: 220
2 jumps found. (Code = 43) Position 1 = 250, Position 2 = 255
Branch analysis from position: 250
Branch analysis from position: 255
Branch analysis from position: 247
Branch analysis from position: 138
Branch analysis from position: 139
Branch analysis from position: 15
filename:       /in/DDjv0
function name:  (null)
number of ops:  504
compiled vars:  !0 = $smarty, !1 = $login_id, !2 = $wo_id, !3 = $VAR, !4 = $company, !5 = $customer_id, !6 = $msg_type, !7 = $rep_date, !8 = $eml_template, !9 = $q, !10 = $db, !11 = $rs, !12 = $email_info, !13 = $company_email, !14 = $ticket_message, !15 = $all_messages, !16 = $m, !17 = $this_msg, !18 = $msg, !19 = $clean_msg, !20 = $sql, !21 = $result, !22 = $emailto, !23 = $email_from, !24 = $email_subject, !25 = $html, !26 = $email_priority, !27 = $email_cc, !28 = $subject, !29 = $mailer, !30 = $headers, !31 = $message, !32 = $email, !33 = $attachments_select, !34 = $attachments, !35 = $a, !36 = $file, !37 = $company_id, !38 = $add_attachments
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   FETCH_CONSTANT                                   ~39     'INCLUDE_URL'
          1        FETCH_CONSTANT                                   ~40     'SEP'
          2        CONCAT                                           ~41     ~39, ~40
          3        CONCAT                                           ~42     ~41, 'phpmailer%2Fclass.phpmailer.php'
          4        INCLUDE_OR_EVAL                                          ~42, REQUIRE
    3     5        INCLUDE_OR_EVAL                                          'popup.php', INCLUDE_ONCE
    4     6        INIT_FCALL_BY_NAME                                       'xml2php'
          7        SEND_VAL_EX                                              'workorder'
          8        DO_FCALL                                      0  $45     
          9        BOOL_NOT                                         ~46     $45
         10      > JMPZ                                                     ~46, ->15
    5    11    >   INIT_METHOD_CALL                                         !0, 'assign'
         12        SEND_VAL_EX                                              'error_msg'
         13        SEND_VAL_EX                                              'Error+in+language+file'
         14        DO_FCALL                                      0          
    7    15    >   FETCH_R                      global              ~48     '_SESSION'
         16        FETCH_DIM_R                                      ~49     ~48, 'login_id'
         17        ASSIGN                                                   !1, ~49
    8    18        INIT_METHOD_CALL                                         !0, 'assign'
         19        SEND_VAL_EX                                              'login_id'
         20        SEND_VAR_EX                                              !1
         21        DO_FCALL                                      0          
    9    22        FETCH_DIM_R                                      ~52     !3, 'wo_id'
         23        ASSIGN                                                   !2, ~52
   10    24        INIT_METHOD_CALL                                         !0, 'assign'
         25        SEND_VAL_EX                                              'wo_id'
         26        SEND_VAR_EX                                              !2
         27        DO_FCALL                                      0          
   11    28        FETCH_DIM_R                                      ~55     !3, 'company'
         29        ASSIGN                                                   !4, ~55
   12    30        INIT_METHOD_CALL                                         !0, 'assign'
         31        SEND_VAL_EX                                              'company'
         32        SEND_VAR_EX                                              !4
         33        DO_FCALL                                      0          
   13    34        FETCH_DIM_R                                      ~58     !3, 'customer_id'
         35        ASSIGN                                                   !5, ~58
   14    36        INIT_METHOD_CALL                                         !0, 'assign'
         37        SEND_VAL_EX                                              'customer_id'
         38        SEND_VAR_EX                                              !5
         39        DO_FCALL                                      0          
   17    40        FETCH_DIM_R                                      ~61     !3, 'msg_type'
         41        ASSIGN                                                   !6, ~61
   18    42        INIT_METHOD_CALL                                         !0, 'assign'
         43        SEND_VAL_EX                                              'msg_type'
         44        SEND_VAR_EX                                              !6
         45        DO_FCALL                                      0          
   19    46        INIT_METHOD_CALL                                         !0, 'assign'
         47        SEND_VAL_EX                                              'msg_id'
         48        CHECK_FUNC_ARG                                           
         49        FETCH_DIM_FUNC_ARG                               $64     !3, 'msg_id'
         50        SEND_FUNC_ARG                                            $64
         51        DO_FCALL                                      0          
   21    52        INIT_FCALL                                               'date'
         53        SEND_VAL                                                 'D%2C+d+M+Y+-+h%3Ai+A'
         54        DO_ICALL                                         $66     
         55        ASSIGN                                                   !7, $66
   23    56        ASSIGN                                                   !8, '%0A%3Ctable+align%3D%22center%22+cellpadding%3D%220%22+cellspacing%3D%220%22+style%3D%22margin%3A+0px+auto%3B+text-align%3A+left%3B+color%3A+rgb%28153%2C+153%2C+153%29%3B+line-height%3A+15pt%3B+font-family%3A+Arial%2C+Helvetica%2C+sans-serif%3B+font-size%3A+12px%3B+font-weight%3A+normal%3B+border-collapse%3A+collapse%3B%22+width%3D%22100%25%22%3E%0A%09%09%09%09%3Ctbody%3E%0A%09%09%09%09%09%3Ctr%3E%0A%09%09%09%09%09%09%3Ctd+bgcolor%3D%22%23ffffff%22+valign%3D%22top%22%3E%26nbsp%3B%3C%2Ftd%3E%0A%09%09%09%09%09%3C%2Ftr%3E%0A%09%09%09%09%09%3Ctr%3E%0A%09%09%09%09%09%09%3Ctd+bgcolor%3D%22%23ffffff%22+style%3D%22padding%3A+15px+20px%3B+color%3A+rgb%28102%2C+102%2C+102%29%3B+line-height%3A+15pt%3B%22%3E%0A%0A%09%09%09%09%09%09%3Chr+style%3D%22font-family%3A+Arial%2C+Helvetica%2C+sans-serif%3B+font-size%3A+12px%3B+border%3A1px+solid+%23f3f3f3%22%2F%3E%0A%09%09%09%09%09%09%3Cp+style%3D%22font-family%3A+Arial%2C+Helvetica%2C+sans-serif%3B+font-size%3A+12px%3B%22%3E%3Cinput+alt%3D%22%22+src%3D%22%5B%5Bemployee_pic%5D%5D%22+style%3D%22width%3A+50px%3B+height%3A+50px%3B+float%3A+left%3B+margin%3A+0px+10px%3B+border-width%3A+1px%3B+border-style%3A+solid%3B%22+type%3D%22image%22+%2F%3E%3Cspan+style%3D%22font-family%3Alucida+sans+unicode%2Clucida+grande%2Csans-serif%3B%22%3E%3Cspan+style%3D%22font-size%3A14px%3B%22%3E%5B%5Bfname%5D%5D+%5B%5Blname%5D%5D+-+%5B%5Bdate%5D%5D+%40+%5B%5Btime%5D%5D%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fp%3E%0A%0A%09%09%09%09%09%09%3Cdiv%3E%0A%09%09%09%09%09%09%3Cdiv+style%3D%22border%3A+0px+solid+rgb%28255%2C+255%2C+255%29%3B+padding%3A+5px+10px%3B+margin-left%3A+70px%3B+margin-top%3A+-10px%3B+background-image%3A+initial%3B+background-attachment%3A+initial%3B+background-color%3A+rgb%28255%2C+255%2C+255%29%3B+background-size%3A+initial%3B+background-origin%3A+initial%3B+background-clip%3A+initial%3B+background-position%3A+initial%3B+background-repeat%3A+initial%3B%22%3E%0A%09%09%09%09%09%09%3Cp%3E%3Cspan+style%3D%22font-family%3A+%27lucida+sans+unicode%27%2C+%27lucida+grande%27%2C+sans-serif%3B+font-size%3A+14px%3B+color%3A+rgb%28102%2C+102%2C+102%29%3B+line-height%3A+15px%3B+background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3C%2Fspan%3E%3Cspan+style%3D%22color%3A+rgb%28102%2C+102%2C+102%29%3B+line-height%3A+15px%3B+background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cfont+face%3D%22arial%2C+helvetica%2C+sans-serif%22%3E%5B%5Bmsg%5D%5D%3C%2Ffont%3E%3C%2Fspan%3E%3C%2Fp%3E%0A%0A%09%09%09%09%09%09%3Cp+style%3D%22font-family%3A+Arial%2C+Helvetica%2C+sans-serif%3B+font-size%3A+12px%3B%22%3E%26nbsp%3B%3C%2Fp%3E%0A%09%09%09%09%09%09%3C%2Fdiv%3E%0A%09%09%09%09%09%09%3C%2Fdiv%3E%0A%0A%09%09%09%09%09%09%3Chr+style%3D%22font-family%3A+Arial%2C+Helvetica%2C+sans-serif%3B+font-size%3A+12px%3B+border%3A1px+solid+%23f3f3f3%22%2F%3E%0A%09%09%09%09%09%09%3Cp+style%3D%22font-family%3A+Arial%2C+Helvetica%2C+sans-serif%3B+font-size%3A+12px%3B%22%3E%26nbsp%3B%3C%2Fp%3E%0A%09%09%09%09%09%09%3C%2Ftd%3E%0A%09%09%09%09%09%3C%2Ftr%3E%0A%09%09%09%09%09%3Ctr%3E%0A%09%09%09%09%09%09%3Ctd+height%3D%2220%22+style%3D%22line-height%3A+2px%3B+font-size%3A+2px%3B%22%3E%3Cimg+alt%3D%22%22+border%3D%220%22+height%3D%2220%22+src%3D%22http%3A%2F%2Fcomputergeeksrus.com%2Femail%2Fimages%2Fshadow620.gif%22+style%3D%22display%3A+block%3B%22+width%3D%22100%25%22+%2F%3E%3C%2Ftd%3E%0A%09%09%09%09%09%3C%2Ftr%3E%0A%09%09%09%09%3C%2Ftbody%3E%0A%09%09%09%3C%2Ftable%3E%0A'
   57    57        FETCH_CONSTANT                                   ~69     'PRFX'
         58        CONCAT                                           ~70     'SELECT+', ~69
         59        CONCAT                                           ~71     ~70, 'TABLE_WORK_ORDER.%2A%2C%0A+++++++++++++'
   58    60        FETCH_CONSTANT                                   ~72     'PRFX'
         61        CONCAT                                           ~73     ~71, ~72
         62        CONCAT                                           ~74     ~73, 'TABLE_CUSTOMER.%2A%0A++++++++++++++++FROM+'
   59    63        FETCH_CONSTANT                                   ~75     'PRFX'
         64        CONCAT                                           ~76     ~74, ~75
         65        CONCAT                                           ~77     ~76, 'TABLE_WORK_ORDER%0A++++++++++++++++LEFT+JOIN+'
   60    66        FETCH_CONSTANT                                   ~78     'PRFX'
         67        CONCAT                                           ~79     ~77, ~78
         68        CONCAT                                           ~80     ~79, 'TABLE_CUSTOMER+ON+'
         69        FETCH_CONSTANT                                   ~81     'PRFX'
         70        CONCAT                                           ~82     ~80, ~81
         71        CONCAT                                           ~83     ~82, 'TABLE_WORK_ORDER.CUSTOMER_ID+%3D+'
         72        FETCH_CONSTANT                                   ~84     'PRFX'
         73        CONCAT                                           ~85     ~83, ~84
         74        CONCAT                                           ~86     ~85, 'TABLE_CUSTOMER.CUSTOMER_ID+%0A++++++++++++++++WHERE+WORK_ORDER_ID%3D'
   61    75        INIT_METHOD_CALL                                         !10, 'qstr'
         76        SEND_VAR_EX                                              !2
         77        DO_FCALL                                      0  $87     
         78        CONCAT                                           ~88     ~86, $87
   57    79        ASSIGN                                                   !9, ~88
   63    80        INIT_METHOD_CALL                                         !10, 'execute'
         81        SEND_VAR_EX                                              !9
         82        DO_FCALL                                      0  $90     
         83        ASSIGN                                           ~91     !11, $90
         84        BOOL_NOT                                         ~92     ~91
         85      > JMPZ                                                     ~92, ->96
   64    86    >   INIT_FCALL_BY_NAME                                       'force_page'
         87        SEND_VAL_EX                                              'core'
         88        INIT_METHOD_CALL                                         !10, 'ErrorMsg'
         89        DO_FCALL                                      0  $93     
         90        CONCAT                                           ~94     'error%26error_msg%3DMySQL+Error%3A+', $93
         91        CONCAT                                           ~95     ~94, '%26menu%3D1%26type%3Ddatabase'
         92        SEND_VAL_EX                                              ~95
         93        DO_FCALL                                      0          
   65    94      > EXIT                                                     
         95*       JMP                                                      ->99
   67    96    >   INIT_METHOD_CALL                                         !11, 'GetArray'
         97        DO_FCALL                                      0  $97     
         98        ASSIGN                                                   !12, $97
   69    99        INIT_METHOD_CALL                                         !0, 'assign'
        100        SEND_VAL_EX                                              'email_info'
        101        SEND_VAR_EX                                              !12
        102        DO_FCALL                                      0          
   73   103        FETCH_CONSTANT                                   ~100    'PRFX'
        104        CONCAT                                           ~101    'SELECT+COMPANY_EMAIL+FROM+', ~100
        105        CONCAT                                           ~102    ~101, 'TABLE_COMPANY'
        106        ASSIGN                                                   !9, ~102
   74   107        INIT_METHOD_CALL                                         !10, 'execute'
        108        SEND_VAR_EX                                              !9
        109        DO_FCALL                                      0  $104    
        110        ASSIGN                                           ~105    !11, $104
        111        BOOL_NOT                                         ~106    ~105
        112      > JMPZ                                                     ~106, ->122
   75   113    >   INIT_FCALL_BY_NAME                                       'force_page'
        114        SEND_VAL_EX                                              'core'
        115        INIT_METHOD_CALL                                         !10, 'ErrorMsg'
        116        DO_FCALL                                      0  $107    
        117        CONCAT                                           ~108    'error%26error_msg%3DMySQL+Error%3A+', $107
        118        CONCAT                                           ~109    ~108, '%26menu%3D1%26type%3Ddatabase'
        119        SEND_VAL_EX                                              ~109
        120        DO_FCALL                                      0          
   76   121      > EXIT                                                     
   79   122    >   FETCH_OBJ_R                                      ~111    !11, 'fields'
        123        FETCH_DIM_R                                      ~112    ~111, 'COMPANY_EMAIL'
        124        ASSIGN                                                   !13, ~112
   80   125        INIT_METHOD_CALL                                         !0, 'assign'
        126        SEND_VAL_EX                                              'company_email'
        127        SEND_VAR_EX                                              !13
        128        DO_FCALL                                      0          
   85   129        FETCH_DIM_R                                      ~115    !3, 'msg_type'
        130        IS_NOT_EQUAL                                     ~116    ~115, 'new'
        131      > JMPZ_EX                                          ~116    ~116, ->139
        132    >   FETCH_DIM_R                                      ~117    !3, 'msg_type'
        133        IS_EQUAL                                         ~118    ~117, 'reply'
        134      > JMPNZ_EX                                         ~118    ~118, ->138
        135    >   FETCH_DIM_R                                      ~119    !3, 'msg_type'
        136        IS_EQUAL                                         ~120    ~119, 'forward'
        137        BOOL                                             ~118    ~120
        138    >   BOOL                                             ~116    ~118
        139    > > JMPZ                                                     ~116, ->217
   87   140    >   INIT_FCALL                                               'ctype_digit'
        141        FETCH_DIM_R                                      ~121    !3, 'msg_id'
        142        SEND_VAL                                                 ~121
        143        DO_ICALL                                         $122    
        144      > JMPZ                                                     $122, ->156
   88   145    >   FETCH_CONSTANT                                   ~123    'PRFX'
        146        CONCAT                                           ~124    'SELECT+MSG+FROM+', ~123
        147        ROPE_INIT                                     3  ~126    'TABLE_WORK_ORDER_MESSAGE+WHERE+MSG_WORK_ORDER_ID%3D%27'
        148        ROPE_ADD                                      1  ~126    ~126, !2
        149        ROPE_END                                      2  ~125    ~126, '%27+AND+MSG_ID%3D%27'
        150        CONCAT                                           ~128    ~124, ~125
        151        FETCH_DIM_R                                      ~129    !3, 'msg_id'
        152        CONCAT                                           ~130    ~128, ~129
        153        CONCAT                                           ~131    ~130, '%27+LIMIT+1'
        154        ASSIGN                                                   !9, ~131
        155      > JMP                                                      ->163
   90   156    >   FETCH_CONSTANT                                   ~133    'PRFX'
        157        CONCAT                                           ~134    'SELECT+MSG+FROM+', ~133
        158        ROPE_INIT                                     3  ~136    'TABLE_WORK_ORDER_MESSAGE+WHERE+MSG_WORK_ORDER_ID%3D%27'
        159        ROPE_ADD                                      1  ~136    ~136, !2
        160        ROPE_END                                      2  ~135    ~136, '%27+ORDER+BY+MSG_ID+DESC'
        161        CONCAT                                           ~138    ~134, ~135
        162        ASSIGN                                                   !9, ~138
   92   163    >   INIT_METHOD_CALL                                         !10, 'execute'
        164        SEND_VAR_EX                                              !9
        165        DO_FCALL                                      0  $140    
        166        ASSIGN                                           ~141    !11, $140
        167        BOOL_NOT                                         ~142    ~141
        168      > JMPZ                                                     ~142, ->175
   93   169    >   INIT_FCALL_BY_NAME                                       'force_page'
        170        SEND_VAL_EX                                              'core'
        171        SEND_VAL_EX                                              'error%26error_msg%3DCould+not+get+Messages'
        172        DO_FCALL                                      0          
   94   173      > EXIT                                                     
        174*       JMP                                                      ->178
   99   175    >   INIT_METHOD_CALL                                         !11, 'GetArray'
        176        DO_FCALL                                      0  $144    
        177        ASSIGN                                                   !14, $144
  103   178        ASSIGN                                                   !15, null
  105   179      > FE_RESET_R                                       $147    !14, ->215
        180    > > FE_FETCH_R                                               $147, !16, ->215
  106   181    >   INIT_FCALL                                               'str_replace'
        182        SEND_VAL                                                 '%5B%5Bmsg%5D%5D'
        183        FETCH_DIM_R                                      ~148    !16, 'MSG'
        184        SEND_VAL                                                 ~148
        185        SEND_VAR                                                 !8
        186        DO_ICALL                                         $149    
        187        ASSIGN                                                   !17, $149
  107   188        INIT_FCALL                                               'str_replace'
        189        SEND_VAL                                                 '%5B%5Bemployee_pic%5D%5D'
        190        INIT_FCALL_BY_NAME                                       'get_employee_profile_pic'
        191        SEND_VAR_EX                                              !1
        192        DO_FCALL                                      0  $151    
        193        SEND_VAR                                                 $151
        194        SEND_VAR                                                 !17
        195        DO_ICALL                                         $152    
        196        ASSIGN                                                   !17, $152
  108   197        INIT_FCALL                                               'str_replace'
        198        SEND_VAL                                                 '%5B%5Bdate%5D%5D'
        199        INIT_FCALL                                               'strtotime'
        200        FETCH_DIM_R                                      ~154    !16, 'MSG_CREATED_ON'
        201        SEND_VAL                                                 ~154
        202        DO_ICALL                                         $155    
        203        SEND_VAR                                                 $155
        204        SEND_VAR                                                 !17
        205        DO_ICALL                                         $156    
        206        ASSIGN                                                   !17, $156
  109   207        INIT_FCALL                                               'str_replace'
        208        SEND_VAL                                                 '%40+%5B%5Btime%5D%5D'
        209        SEND_VAL                                                 ''
        210        SEND_VAR                                                 !17
        211        DO_ICALL                                         $158    
        212        ASSIGN                                                   !17, $158
  110   213        ASSIGN_OP                                     8          !15, !17
  105   214      > JMP                                                      ->180
        215    >   FE_FREE                                                  $147
        216      > JMP                                                      ->247
  113   217    >   FETCH_DIM_R                                      ~161    !3, 'msg_type'
        218        IS_EQUAL                                                 ~161, 'new'
        219      > JMPZ                                                     ~162, ->247
  114   220    >   INIT_FCALL                                               'str_replace'
        221        SEND_VAL                                                 '%5B%5Bmsg%5D%5D'
        222        FETCH_DIM_R                                      ~163    !3, 'ticket_msg'
        223        SEND_VAL                                                 ~163
        224        SEND_VAR                                                 !8
        225        DO_ICALL                                         $164    
        226        ASSIGN                                                   !15, $164
  115   227        INIT_FCALL                                               'str_replace'
        228        SEND_VAL                                                 '%5B%5Bemployee_pic%5D%5D'
        229        INIT_FCALL_BY_NAME                                       'get_employee_profile_pic'
        230        SEND_VAR_EX                                              !1
        231        DO_FCALL                                      0  $166    
        232        SEND_VAR                                                 $166
        233        SEND_VAR                                                 !15
        234        DO_ICALL                                         $167    
        235        ASSIGN                                                   !15, $167
  116   236        INIT_FCALL                                               'str_replace'
        237        SEND_VAL                                                 '%5B%5Bdate%5D%5D'
        238        INIT_FCALL                                               'str_replace'
        239        SEND_VAL                                                 '+-+'
        240        SEND_VAL                                                 '+%40+'
        241        SEND_VAR                                                 !7
        242        DO_ICALL                                         $169    
        243        SEND_VAR                                                 $169
        244        SEND_VAR                                                 !15
        245        DO_ICALL                                         $170    
        246        ASSIGN                                                   !15, $170
  120   247    >   FETCH_DIM_R                                      ~172    !3, 'msg_type'
        248        IS_EQUAL                                                 ~172, 'forward'
        249      > JMPZ                                                     ~173, ->255
  121   250    >   INIT_METHOD_CALL                                         !0, 'assign'
        251        SEND_VAL_EX                                              'message_content'
        252        CONCAT                                           ~174    '%3Cbr%2F%3E%3Cbr%2F%3E%3Cbr%2F%3E%3Cdiv+style%3D%27text-align%3Acenter%3Bcolor%3A%23999%3B%27%3E----FORWARDED+EMAIL----%3C%2Fdiv%3E%3Cbr%2F%3E', !15
        253        SEND_VAL_EX                                              ~174
        254        DO_FCALL                                      0          
  126   255    >   FETCH_IS                                         ~176    '_POST'
        256        ISSET_ISEMPTY_DIM_OBJ                         0          ~176, 'send_email'
        257      > JMPZ                                                     ~177, ->483
  131   258    >   FETCH_DIM_R                                      ~178    !3, 'ticket_msg'
        259        ASSIGN                                                   !18, ~178
  132   260        INIT_FCALL                                               'preg_replace'
        261        SEND_VAL                                                 '%2F%3Cp%5B%5E%3E%5D%2A%3F%3E%2F'
        262        SEND_VAL                                                 ''
        263        SEND_VAR                                                 !18
        264        DO_ICALL                                         $180    
        265        ASSIGN                                                   !19, $180
  133   266        INIT_FCALL                                               'str_replace'
        267        SEND_VAL                                                 '%3C%2Fp%3E'
        268        SEND_VAL                                                 '%3Cbr+%2F%3E'
        269        SEND_VAR                                                 !19
        270        DO_ICALL                                         $182    
        271        ASSIGN                                                   !19, $182
  138   272        FETCH_CONSTANT                                   ~184    'PRFX'
        273        CONCAT                                           ~185    'INSERT+INTO+', ~184
        274        CONCAT                                           ~186    ~185, 'TABLE_WORK_ORDER_MESSAGE+SET+%0A+%09%09%09+MSG_WORK_ORDER_I

Generated using Vulcan Logic Dumper, using php 8.0.0