- if (substr($local_logline_array[$i],0,1) == '[') {
- $local_dummy = trim($local_logline_array[$i]);
- $local_sql_2 .= ", source_ip";
- $local_sql_3 .= ", '".substr($local_dummy, 1, strlen($local_dummy)-2)."'";
- } else {
-
- $local_element = explode("=", $local_logline_array[$i]);
-
- switch (strtolower($local_element[0])) {
- case "from":
- $local_sql_2 .= ", from_email";
- $local_sql_3 .= ", '".$local_element[1]."'";
- break;
- case "size":
- $local_sql_2 .= ", size";
- $local_sql_3 .= ", '".$local_element[1]."'";
- break;
- case "delay":
- $local_sql_2 .= ", delay";
- $local_sql_3 .= ", '".$local_element[1]."'";
- break;
- case "xdelay":
- $local_sql_2 .= ", xdelay";
- $local_sql_3 .= ", '".$local_element[1]."'";
- break;
- case "mailer":
- $local_sql_2 .= ", mailer";
- $local_sql_3 .= ", '".$local_element[1]."'";
- break;
- case "dsn":
- $local_sql_2 .= ", dsn";
- $local_sql_3 .= ", '".$local_element[1]."'";
- break;
- case "msgid":
- $local_sql_2 .= ", external_messageid";
- if (substr($local_element[1],0,1) == '<') {
- $local_sql_3 .= ", '";
- $local_sql_3 .= substr($local_element[1],1,(strlen($local_element[1])-2));
- $local_sql_3 .= "'";
- } else {
- $local_sql_3 .= ", '".$local_element[1]."'";
- }
-
- //As of this point we only deal with Status
- case "stat":
- $local_sql_2 .= ", status";
- $local_sql_3 .= ", '".$local_element[1]."'";
-
- $local_pos = strrpos (strtolower($local_element[$i]), "stat=");
- $local_len = strlen($local_logline_array[$i]) - $local_pos - 6;
- $local_sql_2 .= ", status_details";
- $local_sql_3 .= ", '".substr($local_logline_array[$i], $local_pos + 5, $local_len) . "'";
- break;
-
- case "status":
- $local_sql_2 .= ", status";
- $local_sql_3 .= ", '".$local_element[1]."'";
-
- $local_pos = strrpos (strtolower($local_logline_array[$i]), "status=");
- $local_len = strlen($local_logline_array[$i]) - $local_pos - 8;
- $local_sql_2 .= ", status_details";
- $local_sql_3 .= ", '".substr($local_logline_array[$i], $local_pos + 7, $local_len) . "'";
-
- break;
- default:
- if (substr(strtolower($local_element[0]),0,1) == "[") {
- $local_sql_2 .= ", destination_ip";
- $local_sql_3 .= ", '". substr($local_element[1], 1, strlen($local_element[1]) - 2)."'";
- }
-
- }
- }
- }
+ if (substr($local_logline_array[$i],0,1) == '[')
+ {
+ $local_dummy = trim($local_logline_array[$i]);
+ $local_sql_2 .= ", source_ip";
+ $local_sql_3 .= ", '".substr($local_dummy, 1, strlen($local_dummy)-2)."'";
+ }
+ else
+ {
+
+ $local_element = explode("=", $local_logline_array[$i]);
+
+ switch (strtolower($local_element[0]))
+ {
+ case "from":
+ $local_sql_2 .= ", from_email";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ break;
+
+ case "size":
+ $local_sql_2 .= ", size";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ break;
+
+ case "delay":
+ $local_sql_2 .= ", delay";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ break;
+
+ case "xdelay":
+ $local_sql_2 .= ", xdelay";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ break;
+
+ case "mailer":
+ $local_sql_2 .= ", mailer";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ break;
+
+ case "dsn":
+ $local_sql_2 .= ", dsn";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ break;
+
+ case "msgid":
+ $local_sql_2 .= ", external_messageid";
+ if (substr($local_element[1],0,1) == '<')
+ {
+ $local_sql_3 .= ", '";
+ $local_sql_3 .= substr($local_element[1],1,(strlen($local_element[1])-2));
+ $local_sql_3 .= "'";
+ }
+ else
+ {
+ $local_sql_3 .= ", '".$local_element[1]."'";
+ }
+ break;
+
+ //As of this point we only deal with Status
+ case "stat":
+ $local_sql_2 .= ", status";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+
+ $local_pos = strrpos (strtolower($local_logline_array[$i]), "stat=");
+ $local_len = strlen($local_logline_array[$i]) - $local_pos - 6;
+ $local_sql_2 .= ", status_details";
+ $local_sql_3 .= ", '".substr($local_logline_array[$i], $local_pos + 5, $local_len) . "'";
+ break;
+
+ case "status":
+ $local_sql_2 .= ", status";
+ $local_sql_3 .= ", '".$local_element[1]."'";
+
+ $local_pos = strrpos (strtolower($local_logline_array[$i]), "status=");
+ $local_len = strlen($local_logline_array[$i]) - $local_pos - 8;
+ $local_sql_2 .= ", status_details";
+ $local_sql_3 .= ", '".substr($local_logline_array[$i], $local_pos + 7, $local_len) . "'";
+ break;
+
+ default:
+ if (substr(strtolower($local_element[0]),0,1) == "[")
+ {
+ $local_sql_2 .= ", destination_ip";
+ $local_sql_3 .= ", '". substr($local_element[1], 1, strlen($local_element[1]) - 2)."'";
+ }
+ break;
+ }
+ }
+ }