index.php0000644000175000017500000000674314303661715012546 0ustar bitnamibitnami"; ?> client->messages()->get(null, $query_params); // If response <> 200, freak out. Later // print $response->statusCode() . "\n"; // print_r($response->headers()); // print $response->body() . "\n"; $res = json_decode($response->body()); if(isset($res) && isset($res->messages) && count($res->messages) > 0) { process_messages($res->messages); } else { echo "No match"; } // dd($res); // echo is_countable($res); // echo is_countable($res->messages); // echo "count: " . count($res->messages); } catch (Exception $ex) { echo 'Caught exception: '. $ex->getMessage(); } } function lookup_msgid($m) { global $KEY; $sg = new \SendGrid($KEY); action_log($_SESSION["user"], "looking up message detail"); try { $response = $sg->client->messages()->_($m)->get(); // If response <> 200, freak out. Later // print $response->statusCode() . "\n"; // print_r($response->headers()); // print $response->body() . "\n"; $res = json_decode($response->body()); if(isset($res)) { process_message($res); } else { echo "No match"; } // dd($res); // echo is_countable($res); // echo is_countable($res->messages); // echo "count: " . count($res->messages); } catch (Exception $ex) { echo 'Caught exception: '. $ex->getMessage(); } } function process_message($blap) { echo "
"; echo "From: " . $blap->from_email . "
"; echo "To: " . $blap->to_email . "
"; echo "Subject: " . $blap->subject . "
"; echo "Status: " . $blap->status . "
"; $count = count($blap->events); for($i = 0; $i < $count; $i++) { echo "Event: " . $blap->events[$i]->event_name . "
"; echo "Reason: " . $blap->events[$i]->reason . "
"; echo "When: " . convert_time_to_CET($blap->events[$i]->processed) . "
"; } echo "
\n
\n"; // dd($blap); } function convert_time_to_CET($tt) { $t = new DateTime($tt); // echo $t->format('Y-m-d H:i:s') . "\n"; $pl_time = new DateTimeZone('Europe/Warsaw'); $t->setTimezone($pl_time); return $t->format('Y-m-d H:i:s') . " CET"; } function process_messages($blap) { $count = count($blap); date_default_timezone_set('UTC'); for($i = 0; $i < $count; $i++) { echo "
"; echo "From: " . $blap[$i]->from_email . "
"; echo "To: " . $blap[$i]->to_email . "
"; echo "Subject: " . $blap[$i]->subject . "
"; echo "Status: " . $blap[$i]->status . "
"; $t = convert_time_to_CET($blap[$i]->last_event_time); echo "When: " . $t . "
"; echo "More info"; echo "
\n
\n"; } // dd($blap); } // echo ""; ?>
Enter email:
libsql.php0000644000175000017500000000743614303514772012725 0ustar bitnamibitnamiquery($sql); ce($sql); return $MASTER->insert_id; // should probably return $MASTER->insert_id; } /* function sinsql($sql, $vals) { global $link; if(!$link) { $link = connect(); } $mysqli->autocommit(FALSE); $stmt = $mysqli->prepare($sql); //$stmt2 = $mysqli->prepare("INSERT INTO tbl2 (id, name) VALUES (?, ?)"); foreach ($vals as $k => $v) { $stmt->bind_param(", $v); $stmt2->bind_param('ss', $str3,$str4); $r = $link->query($sql); ce($sql); return $link->insert_id; // should probably return $link->insert_id; } */ function squery($sql) { global $MASTER; if(!$MASTER) { $MASTER = connect(); } $r = $MASTER->query($sql); ce($sql); return $r; } // count function snum($res) { return mysqli_num_rows($res); } // check error function ce($sql) { global $MASTER; if(!$MASTER) { echo "Couldn't connect"; exit; } if(mysqli_errno($MASTER)) { echo "
Sql: " . $sql . "
"; echo mysqli_error($MASTER); die; return 0; } } function get_once($sql) { $sql .= " LIMIT 1"; $res = squery($sql); $ret = mysqli_fetch_array($res); return $ret; } function get_single($sql) { $tmp = get_once($sql); return $tmp[0]; } function dd($str, $extra = 0) { $a = print_r($str, true); if($extra) return $a; echo "
DUMP ($extra):
";
    echo $a;
    echo "

)"; } function c($str) { if(is_object($str)) { return $str; } if(is_numeric($str)) { return $str; } global $MASTER; if(!$MASTER) { $MASTER = connect(); dd($MASTER, "LINK"); } mysqli_real_escape_string($MASTER, $str); ce($str); return $ret; } // Get the company name function getCompany($c) { $sql = "SELECT name FROM companies WHERE id = '$c'"; return get_single($sql); } function slugify($text) { // replace non letter or digits by - $text = preg_replace('~[^\pL\d]+~u', '-', $text); // transliterate $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text); // remove unwanted characters $text = preg_replace('~[^-\w]+~', '', $text); // trim $text = trim($text, '-'); // remove duplicate - $text = preg_replace('~-+~', '-', $text); // lowercase $text = strtolower($text); if (empty($text)) { return 'n-a'; } return $text; } function action_log($user, $action) { global $MASTER; if(!$MASTER) { $MASTER = connect(); } if(!$user && !$action) { die("Missing person or action in audit log"); } $s = prep("INSERT INTO audit (user, action) VALUES (?, ?)"); mysqli_stmt_bind_param($s, "ss", $user, $action); echo mysqli_error($MASTER); mysqli_stmt_execute($s); echo mysqli_error($MASTER); } // return 0 for fail, function check_user($u, $p) { global $MASTER; if(!$MASTER) { $MASTER = connect(); } if(!$u && !$p) { die("Missing login details in check_user"); } $s = prep("SELECT user FROM users WHERE user = ? AND pass = ?"); mysqli_stmt_bind_param($s, "ss", $u, $p); mysqli_stmt_execute($s); mysqli_stmt_store_result($s); $num_rows = mysqli_stmt_num_rows($s); return $num_rows; } function prep($sql) { global $MASTER; $s = mysqli_prepare($MASTER, $sql); if(!$s) { echo mysqli_error($MASTER); die; } return $s; } ?>login.php0000644000175000017500000000113614303510407012525 0ustar bitnamibitnami
Username:
Password: