3v4l.org

run code in 300+ PHP versions simultaneously
<?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); $rep_date=date('D, d M Y - h:i A'); /* Get Work Order and customer 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); /*Update The Work order*/ if(isset($_POST['Submit'])) { //Remove Extra Slashes caused by Magic Quotes $description_string = $VAR['description']; $description_string = preg_replace("</p>", "br /", $description_string); $description_string2=("<br/><hr><u>Replied On $rep_date by $login </u><br/>$description_string"); $q = "UPDATE ".PRFX."TABLE_WORK_ORDER SET WORK_ORDER_DESCRIPTION = CONCAT('$description_string2',WORK_ORDER_DESCRIPTION), LAST_ACTIVE =".$db->qstr( time() )." 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; } /*Get Full Description to send to Email*/ $q = mysql_query("SELECT * FROM ".PRFX."TABLE_WORK_ORDER WHERE WORK_ORDER_ID='$wo_id' LIMIT 1"); $q=mysql_fetch_array($q); $wo_description=$q['WORK_ORDER_DESCRIPTION']; /*Strip Tags*/ $wo_description=str_replace("Â","",$wo_description); /*Send the email*/ require_once('../../include/phpmailer/class.phpmailer.php') or die("error class"); /* OLD CODE $emailto=$VAR["email_to"]; $email_from=$VAR["email_from"]; $email_subject=$VAR["email_subject"]; $html="<br/></section>--reply above this line to respond--<br><br/>$wo_description</section><br/>--end email content--"; $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><body style="background:#ffffff">'; $message .= $html; $message .= "</body></html>"; $headers .= "Cc: $email_cc \r\n"; mail($emailto, $subject, $message, $headers); OLD CODE */ $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){ //select all attachments $q = "SELECT ".PRFX."TABLE_WORK_ORDER.WORK_ORDER_ID, ".PRFX."TABLE_WORK_ORDER_ATTACHMENTS.*, ".PRFX."TABLE_EMPLOYEE.EMPLOYEE_ID, ".PRFX."TABLE_EMPLOYEE.EMPLOYEE_DISPLAY_NAME FROM ".PRFX."TABLE_WORK_ORDER INNER JOIN ".PRFX."TABLE_WORK_ORDER_ATTACHMENTS ON ".PRFX."TABLE_WORK_ORDER.WORK_ORDER_ID=".PRFX."TABLE_WORK_ORDER_ATTACHMENTS.WO_ID LEFT JOIN ".PRFX."TABLE_EMPLOYEE ON ".PRFX."TABLE_WORK_ORDER_ATTACHMENTS.ATTACHMENT_UPLOADED_BY=".PRFX."TABLE_EMPLOYEE.EMPLOYEE_ID WHERE WORK_ORDER_ID=".$db->qstr($wo_id)." 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(); echo "debug\n\n"; print_r($attachments); die(); $email->addAttachment('/tmp/image.jpg', 'new.jpg'); } 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(); } } $smarty->display('workorder'.SEP.'send_email.tpl'); ?>
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 6, Position 2 = 10
Branch analysis from position: 6
2 jumps found. (Code = 43) Position 1 = 68, Position 2 = 78
Branch analysis from position: 68
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 78
2 jumps found. (Code = 43) Position 1 = 95, Position 2 = 104
Branch analysis from position: 95
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 104
2 jumps found. (Code = 43) Position 1 = 114, Position 2 = 326
Branch analysis from position: 114
2 jumps found. (Code = 43) Position 1 = 153, Position 2 = 162
Branch analysis from position: 153
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 162
2 jumps found. (Code = 43) Position 1 = 210, Position 2 = 212
Branch analysis from position: 210
2 jumps found. (Code = 43) Position 1 = 214, Position 2 = 216
Branch analysis from position: 214
2 jumps found. (Code = 43) Position 1 = 218, Position 2 = 220
Branch analysis from position: 218
2 jumps found. (Code = 43) Position 1 = 234, Position 2 = 300
Branch analysis from position: 234
2 jumps found. (Code = 43) Position 1 = 279, Position 2 = 288
Branch analysis from position: 279
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 288
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 300
2 jumps found. (Code = 43) Position 1 = 304, Position 2 = 313
Branch analysis from position: 304
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 313
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 220
Branch analysis from position: 216
Branch analysis from position: 212
Branch analysis from position: 326
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 10
filename:       /in/C91gd
function name:  (null)
number of ops:  333
compiled vars:  !0 = $smarty, !1 = $login_id, !2 = $wo_id, !3 = $VAR, !4 = $company, !5 = $customer_id, !6 = $rep_date, !7 = $q, !8 = $db, !9 = $rs, !10 = $email_info, !11 = $company_email, !12 = $description_string, !13 = $description_string2, !14 = $login, !15 = $wo_description, !16 = $email, !17 = $email_from, !18 = $mailer, !19 = $email_cc, !20 = $subject, !21 = $message, !22 = $emailto, !23 = $email_priority, !24 = $attachments, !25 = $company_id
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   INCLUDE_OR_EVAL                                          'popup.php', INCLUDE_ONCE
    4     1        INIT_FCALL_BY_NAME                                       'xml2php'
          2        SEND_VAL_EX                                              'workorder'
          3        DO_FCALL                                      0  $27     
          4        BOOL_NOT                                         ~28     $27
          5      > JMPZ                                                     ~28, ->10
    5     6    >   INIT_METHOD_CALL                                         !0, 'assign'
          7        SEND_VAL_EX                                              'error_msg'
          8        SEND_VAL_EX                                              'Error+in+language+file'
          9        DO_FCALL                                      0          
    7    10    >   FETCH_R                      global              ~30     '_SESSION'
         11        FETCH_DIM_R                                      ~31     ~30, 'login_id'
         12        ASSIGN                                                   !1, ~31
    8    13        INIT_METHOD_CALL                                         !0, 'assign'
         14        SEND_VAL_EX                                              'login_id'
         15        SEND_VAR_EX                                              !1
         16        DO_FCALL                                      0          
    9    17        FETCH_DIM_R                                      ~34     !3, 'wo_id'
         18        ASSIGN                                                   !2, ~34
   10    19        INIT_METHOD_CALL                                         !0, 'assign'
         20        SEND_VAL_EX                                              'wo_id'
         21        SEND_VAR_EX                                              !2
         22        DO_FCALL                                      0          
   11    23        FETCH_DIM_R                                      ~37     !3, 'company'
         24        ASSIGN                                                   !4, ~37
   12    25        INIT_METHOD_CALL                                         !0, 'assign'
         26        SEND_VAL_EX                                              'company'
         27        SEND_VAR_EX                                              !4
         28        DO_FCALL                                      0          
   13    29        FETCH_DIM_R                                      ~40     !3, 'customer_id'
         30        ASSIGN                                                   !5, ~40
   14    31        INIT_METHOD_CALL                                         !0, 'assign'
         32        SEND_VAL_EX                                              'customer_id'
         33        SEND_VAR_EX                                              !5
         34        DO_FCALL                                      0          
   16    35        INIT_FCALL                                               'date'
         36        SEND_VAL                                                 'D%2C+d+M+Y+-+h%3Ai+A'
         37        DO_ICALL                                         $43     
         38        ASSIGN                                                   !6, $43
   19    39        FETCH_CONSTANT                                   ~45     'PRFX'
         40        CONCAT                                           ~46     'SELECT+', ~45
         41        CONCAT                                           ~47     ~46, 'TABLE_WORK_ORDER.%2A%2C%0A+++++++++++++'
   20    42        FETCH_CONSTANT                                   ~48     'PRFX'
         43        CONCAT                                           ~49     ~47, ~48
         44        CONCAT                                           ~50     ~49, 'TABLE_CUSTOMER.%2A%0A++++++++++++++++FROM+'
   21    45        FETCH_CONSTANT                                   ~51     'PRFX'
         46        CONCAT                                           ~52     ~50, ~51
         47        CONCAT                                           ~53     ~52, 'TABLE_WORK_ORDER%0A++++++++++++++++LEFT+JOIN+'
   22    48        FETCH_CONSTANT                                   ~54     'PRFX'
         49        CONCAT                                           ~55     ~53, ~54
         50        CONCAT                                           ~56     ~55, 'TABLE_CUSTOMER+ON+'
         51        FETCH_CONSTANT                                   ~57     'PRFX'
         52        CONCAT                                           ~58     ~56, ~57
         53        CONCAT                                           ~59     ~58, 'TABLE_WORK_ORDER.CUSTOMER_ID+%3D+'
         54        FETCH_CONSTANT                                   ~60     'PRFX'
         55        CONCAT                                           ~61     ~59, ~60
         56        CONCAT                                           ~62     ~61, 'TABLE_CUSTOMER.CUSTOMER_ID+%0A++++++++++++++++WHERE+WORK_ORDER_ID%3D'
   23    57        INIT_METHOD_CALL                                         !8, 'qstr'
         58        SEND_VAR_EX                                              !2
         59        DO_FCALL                                      0  $63     
         60        CONCAT                                           ~64     ~62, $63
   19    61        ASSIGN                                                   !7, ~64
   25    62        INIT_METHOD_CALL                                         !8, 'execute'
         63        SEND_VAR_EX                                              !7
         64        DO_FCALL                                      0  $66     
         65        ASSIGN                                           ~67     !9, $66
         66        BOOL_NOT                                         ~68     ~67
         67      > JMPZ                                                     ~68, ->78
   26    68    >   INIT_FCALL_BY_NAME                                       'force_page'
         69        SEND_VAL_EX                                              'core'
         70        INIT_METHOD_CALL                                         !8, 'ErrorMsg'
         71        DO_FCALL                                      0  $69     
         72        CONCAT                                           ~70     'error%26error_msg%3DMySQL+Error%3A+', $69
         73        CONCAT                                           ~71     ~70, '%26menu%3D1%26type%3Ddatabase'
         74        SEND_VAL_EX                                              ~71
         75        DO_FCALL                                      0          
   27    76      > EXIT                                                     
         77*       JMP                                                      ->81
   29    78    >   INIT_METHOD_CALL                                         !9, 'GetArray'
         79        DO_FCALL                                      0  $73     
         80        ASSIGN                                                   !10, $73
   31    81        INIT_METHOD_CALL                                         !0, 'assign'
         82        SEND_VAL_EX                                              'email_info'
         83        SEND_VAR_EX                                              !10
         84        DO_FCALL                                      0          
   35    85        FETCH_CONSTANT                                   ~76     'PRFX'
         86        CONCAT                                           ~77     'SELECT+COMPANY_EMAIL+FROM+', ~76
         87        CONCAT                                           ~78     ~77, 'TABLE_COMPANY'
         88        ASSIGN                                                   !7, ~78
   36    89        INIT_METHOD_CALL                                         !8, 'execute'
         90        SEND_VAR_EX                                              !7
         91        DO_FCALL                                      0  $80     
         92        ASSIGN                                           ~81     !9, $80
         93        BOOL_NOT                                         ~82     ~81
         94      > JMPZ                                                     ~82, ->104
   37    95    >   INIT_FCALL_BY_NAME                                       'force_page'
         96        SEND_VAL_EX                                              'core'
         97        INIT_METHOD_CALL                                         !8, 'ErrorMsg'
         98        DO_FCALL                                      0  $83     
         99        CONCAT                                           ~84     'error%26error_msg%3DMySQL+Error%3A+', $83
        100        CONCAT                                           ~85     ~84, '%26menu%3D1%26type%3Ddatabase'
        101        SEND_VAL_EX                                              ~85
        102        DO_FCALL                                      0          
   38   103      > EXIT                                                     
   41   104    >   FETCH_OBJ_R                                      ~87     !9, 'fields'
        105        FETCH_DIM_R                                      ~88     ~87, 'COMPANY_EMAIL'
        106        ASSIGN                                                   !11, ~88
   42   107        INIT_METHOD_CALL                                         !0, 'assign'
        108        SEND_VAL_EX                                              'company_email'
        109        SEND_VAR_EX                                              !11
        110        DO_FCALL                                      0          
   46   111        FETCH_IS                                         ~91     '_POST'
        112        ISSET_ISEMPTY_DIM_OBJ                         0          ~91, 'Submit'
        113      > JMPZ                                                     ~92, ->326
   49   114    >   FETCH_DIM_R                                      ~93     !3, 'description'
        115        ASSIGN                                                   !12, ~93
   50   116        INIT_FCALL                                               'preg_replace'
        117        SEND_VAL                                                 '%3C%2Fp%3E'
        118        SEND_VAL                                                 'br+%2F'
        119        SEND_VAR                                                 !12
        120        DO_ICALL                                         $95     
        121        ASSIGN                                                   !12, $95
   51   122        ROPE_INIT                                     6  ~98     '%3Cbr%2F%3E%3Chr%3E%3Cu%3EReplied+On+'
        123        ROPE_ADD                                      1  ~98     ~98, !6
        124        ROPE_ADD                                      2  ~98     ~98, '+by+'
        125        ROPE_ADD                                      3  ~98     ~98, !14
        126        ROPE_ADD                                      4  ~98     ~98, '+%3C%2Fu%3E%3Cbr%2F%3E'
        127        ROPE_END                                      5  ~97     ~98, !12
        128        ASSIGN                                                   !13, ~97
   53   129        FETCH_CONSTANT                                   ~102    'PRFX'
        130        CONCAT                                           ~103    'UPDATE+', ~102
        131        ROPE_INIT                                     3  ~105    'TABLE_WORK_ORDER+SET%0A%09%09%09WORK_ORDER_DESCRIPTION+%3D+CONCAT%28%27'
   54   132        ROPE_ADD                                      1  ~105    ~105, !13
        133        ROPE_END                                      2  ~104    ~105, '%27%2CWORK_ORDER_DESCRIPTION%29%2C%0A%09%09%09LAST_ACTIVE%09%09%09%3D'
        134        CONCAT                                           ~107    ~103, ~104
   55   135        INIT_METHOD_CALL                                         !8, 'qstr'
        136        INIT_FCALL                                               'time'
        137        DO_ICALL                                         $108    
        138        SEND_VAR_NO_REF_EX                                       $108
        139        DO_FCALL                                      0  $109    
        140        CONCAT                                           ~110    ~107, $109
        141        CONCAT                                           ~111    ~110, '%0A%09%09%09WHERE++WORK_ORDER_ID%3D'
   56   142        INIT_METHOD_CALL                                         !8, 'qstr'
        143        SEND_VAR_EX                                              !2
        144        DO_FCALL                                      0  $112    
        145        CONCAT                                           ~113    ~111, $112
   53   146        ASSIGN                                                   !7, ~113
   58   147        INIT_METHOD_CALL                                         !8, 'execute'
        148        SEND_VAR_EX                                              !7
        149        DO_FCALL                                      0  $115    
        150        ASSIGN                                           ~116    !9, $115
        151        BOOL_NOT                                         ~117    ~116
        152      > JMPZ                                                     ~117, ->162
   59   153    >   INIT_FCALL_BY_NAME                                       'force_page'
        154        SEND_VAL_EX                                              'core'
        155        INIT_METHOD_CALL                                         !8, 'ErrorMsg'
        156        DO_FCALL                                      0  $118    
        157        CONCAT                                           ~119    'error%26error_msg%3DMySQL+Error%3A+', $118
        158        CONCAT                                           ~120    ~119, '%26menu%3D1%26type%3Ddatabase'
        159        SEND_VAL_EX                                              ~120
        160        DO_FCALL                                      0          
   60   161      > EXIT                                                     
   65   162    >   INIT_FCALL_BY_NAME                                       'mysql_query'
        163        FETCH_CONSTANT                                   ~122    'PRFX'
        164        CONCAT                                           ~123    'SELECT+%2A+FROM++', ~122
        165        ROPE_INIT                                     3  ~125    'TABLE_WORK_ORDER+WHERE+WORK_ORDER_ID%3D%27'
        166        ROPE_ADD                                      1  ~125    ~125, !2
        167        ROPE_END                                      2  ~124    ~125, '%27+LIMIT+1'
        168        CONCAT                                           ~127    ~123, ~124
        169        SEND_VAL_EX                                              ~127
        170        DO_FCALL                                      0  $128    
        171        ASSIGN                                                   !7, $128
   66   172        INIT_FCALL_BY_NAME                                       'mysql_fetch_array'
        173        SEND_VAR_EX                                              !7
        174        DO_FCALL                                      0  $130    
        175        ASSIGN                                                   !7, $130
   67   176        FETCH_DIM_R                                      ~132    !7, 'WORK_ORDER_DESCRIPTION'
        177        ASSIGN                                                   !15, ~132
   70   178        INIT_FCALL                                               'str_replace'
        179        SEND_VAL                                                 '%C3%82'
        180        SEND_VAL                                                 ''
        181        SEND_VAR                                                 !15
        182        DO_ICALL                                         $134    
        183        ASSIGN                                                   !15, $134
   75   184        INCLUDE_OR_EVAL                                          <true>, REQUIRE_ONCE
  105   185        NEW                                              $137    'PHPMailer'
        186        DO_FCALL                                      0          
        187        ASSIGN                                                   !16, $137
  106   188        ASSIGN_OBJ                                               !16, 'From'
        189        OP_DATA                                                  !17
  107   190        ASSIGN_OBJ                                               !16, 'FromName'
        191        OP_DATA                                                  !18
  108   192        INIT_METHOD_CALL                                         !16, 'addReplyTo'
        193        SEND_VAR_EX                                              !17
        194        DO_FCALL                                      0          
  109   195        INIT_METHOD_CALL                                         !16, 'addCC'
        196        SEND_VAR_EX                                              !19
        197        DO_FCALL                                      0          
  110   198        ASSIGN_OBJ                                               !16, 'Subject'
        199        OP_DATA                                                  !20
  111   200        ASSIGN_OBJ                                               !16, 'Body'
        201        OP_DATA                                                  !21
  112   202        INIT_METHOD_CALL                                         !16, 'AddAddress'
        203        SEND_VAR_EX                                              !22
        204        DO_FCALL                                      0          
  113   205        INIT_METHOD_CALL                                         !16, 'isHTML'
        206        SEND_VAL_EX                                              <true>
        207        DO_FCALL                                      0          
  114   208        IS_EQUAL                                                 !23, 'Medium'
        209      > JMPZ                                                     ~148, ->212
        210    >   ASSIGN_OBJ                                               !16, 'Priority'
        211        OP_DATA                                                  3
  115   212    >   IS_EQUAL                                                 !23, 'High'
        213      > JMPZ                                                     ~150, ->216
        214    >   ASSIGN_OBJ                                               !16, 'Priority'
        215        OP_DATA                                                  1
  116   216    >   IS_EQUAL                                                 !23, 'Low'
        217      > JMPZ                                                     ~152, ->220
        218    >   ASSIGN_OBJ                                               !16, 'Priority'
        219        OP_DATA                                                  5
  117   220    >   INIT_METHOD_CALL                                         !16, 'AddCustomHeader'
        221        NOP                                                      
        222        FAST_CONCAT                                      ~154    'X-MSMail-Priority%3A+', !23
        223        SEND_VAL_EX                                              ~154
        224        DO_FCALL                                      0          
  118   225        INIT_METHOD_CALL                                         !16, 'AddCustomHeader'
        226        NOP                                                      
        227        FAST_CONCAT                                      ~156    'Importance%3A+', !23
        228        SEND_VAL_EX                                              ~156
        229        DO_FCALL                                      0          
  120   230        FETCH_DIM_R                                      ~158    !3, 'add_attachments'
        231        COUNT                                            ~159    ~158
        232        IS_SMALLER                                               0, ~159
        233      > JMPZ                                                     ~160, ->300
  123   234    >   FETCH_CONSTANT                                   ~161    'PRFX'
        235        CONCAT                                           ~162    'SELECT+', ~161
        236        CONCAT                                           ~163    ~162, 'TABLE_WORK_ORDER.WORK_ORDER_ID%2C%0A+++++++++++++'
  124   237        FETCH_CONSTANT                                   ~164    'PRFX'
        238        CONCAT                                           ~165    ~163, ~164
        239        CONCAT                                           ~166    ~165, 'TABLE_WORK_ORDER_ATTACHMENTS.%2A%2C%0A+++++++++++++'
  125   240        FETCH_CONSTANT                                   ~167    'PRFX'
        241        CONCAT                                           ~168    ~166, ~167
        242        CONCAT                                           ~169    ~168, 'TABLE_EMPLOYEE.EMPLOYEE_ID%2C%0A+++++++++++++'
  126   243        FETCH_CONSTANT                                   ~170    'PRFX'
        244        CONCAT                                           ~171    ~169, ~170
        245        CONCAT                                           ~172    ~171, 'TABLE_EMPLOYEE.EMPLOYEE_DISPLAY_NAME%0A++++++++++++++FROM+'
  127   246        FETCH_CONSTANT                                   ~173    'PRFX'
        247        CONCAT                                           ~174    ~172, ~173
        248        CONCAT                                           ~175    ~174, 'TABLE_WORK_ORDER+%0A++++++++++++++INNER+JOIN+'
  128   249        FETCH_CONSTANT                                   ~176    'PRFX'
        250        CONCAT                                           ~177    ~175, ~176
        251        CONCAT                                           ~178    ~177, 'TABLE_WORK_ORDER_ATTACHMENTS+ON+'
        252        FETCH_CONSTANT                                   ~179    'PRFX'
        253        CONCAT                                           ~180    ~178, ~179
        254        CONCAT                                           ~181    ~180, 'TABLE_WORK_ORDER.WORK_ORDER_ID%3D'
        255        FETCH_CONSTANT                                   ~182    'PRFX'
        256        CONCAT                                           ~183    ~181, ~182
        257        CONCAT                                           ~184    ~183, 'TABLE_WORK_ORDER_ATTACHMENTS.WO_ID%0A++++++++++++++LEFT+JOIN+'
  129   258        FETCH_CONSTANT                                   ~185    'PRFX'
        259        CONCAT                                           ~186    ~184, ~185
        260        CONCAT                                           ~187    ~186, 'TABLE_EMPLOYEE+ON+'
        261        FETCH_CONSTANT                                   ~188    'PRFX'
        262        CONCAT                                           ~189    ~187, ~188
        263        CONCAT                                           ~190    ~189, 'TABLE_WORK_ORDER_ATTACHMENTS.ATTACHMENT_UPLOADED_BY%3D'
        264        FETCH_CONSTANT                                   ~191    'PRFX'
        265        CONCAT                                           ~192    ~190, ~191
        266        CONCAT                                           ~193    ~192, 'TABLE_EMPLOYEE.EMPLOYEE_ID%0A++++++++++++++WHERE+WORK_ORDER_ID%3D'
  130   267        INIT_METHOD_CALL                                         !8, 'qstr'
        268        SEND_VAR_EX                                              !2
        269        DO_FCALL                                      0  $194    
        270        CONCAT                                           ~195    ~193, $194
        271        CONCAT                                           ~196    ~195, '+ORDER+BY+ATTACHMENT_ID+DESC'
  123   272        ASSIGN                                                   !7, ~196
  132   273        INIT_METHOD_CALL                                         !8, 'execute'
        274        SEND_VAR_EX                                              !7
        275        DO_FCALL                                      0  $198    
        276        ASSIGN                                           ~199    !9, $198
        277        BOOL_NOT                                         ~200    ~199
        278      > JMPZ                                                     ~200, ->288
  133   279    >   INIT_FCALL_BY_NAME                                       'force_page'
        280        SEND_VAL_EX                                              'core'
        281        INIT_METHOD_CALL                                         !8, 'ErrorMsg'
        282        DO_FCALL                                      0  $201    
        283        CONCAT                                           ~202    'error%26error_msg%3DMySQL+Error%3A+', $201
        284        CONCAT                                           ~203    ~202, '%26menu%3D1%26type%3Ddatabase'
        285        SEND_VAL_EX                                              ~203
        286        DO_FCALL                                      0          
  134   287      > EXIT                                                     
  137   288    >   INIT_METHOD_CALL                                         !9, 'GetArray'
        289        DO_FCALL                                      0  $205    
        290        ASSIGN                                                   !24, $205
  138   291        ECHO                                                     'debug%0A%0A'
  139   292        INIT_FCALL                                               'print_r'
        293        SEND_VAR                                                 !24
        294        DO_ICALL                                                 
  140   295      > EXIT                                                     
  141   296*       INIT_METHOD_CALL                                         !16, 'addAttachment'
        297*       SEND_VAL_EX                                              '%2Ftmp%2Fimage.jpg'
        298*       SEND_VAL_EX                                              'new.jpg'
        299*       DO_FCALL                                      0          
  145   300    >   INIT_METHOD_CALL                                         !16, 'send'
        301        DO_FCALL                                      0  $209    
        302        BOOL_NOT                                         ~210    $209
        303      > JMPZ                                                     ~210, ->313
  146   304    >   INIT_FCALL_BY_NAME                                       'force_page'
        305        SEND_VAL_EX                                              'core'
        306        FETCH_OBJ_R                                      ~211    !16, 'ErrorInfo'
        307        CONCAT                                           ~212    'error%26error_msg%3DMail+error%3A+', ~211
        308        CONCAT                                           ~213    ~212, '%26menu%3D1'
        309        SEND_VAL_EX                                              ~213
        310        DO_FCALL                                      0          
  147   311      > EXIT                                                     
        312*       JMP                                                      ->326
  149   313    >   INIT_FCALL_BY_NAME                                       'force_page'
        314        SEND_VAL_EX                                              'workorder'
        315        CONCAT                                           ~215    'view%26wo_id%3D', !2
        316        CONCAT                                           ~216    ~215, '%26customer_id%3D'
        317        CONCAT                                           ~217    ~216, !5
        318        CONCAT                                           ~218    ~217, '%26company_id%3D'
        319        CONCAT                                           ~219    ~218, !25
        320        CONCAT                                           ~220    ~219, '%26page_title%3DTicket%23+'
        321        CONCAT                                           ~221    ~220, !2
        322        CONCAT                                           ~222    ~221, ''
        323        SEND_VAL_EX                                              ~222
        324        DO_FCALL                                      0          
  150   325      > EXIT                                                     
  154   326    >   INIT_METHOD_CALL                                         !0, 'display'
        327        FETCH_CONSTANT                                   ~224    'SEP'
        328        CONCAT                                           ~225    'workorder', ~224
        329        CONCAT                                           ~226    ~225, 'send_email.tpl'
        330        SEND_VAL_EX                                              ~226
        331        DO_FCALL                                      0          
  156   332      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
150.71 ms | 1424 KiB | 23 Q