function e($name, $message)
{
$sql = "INSERT INTO `logs`" . " (`kind`, `name`, `message`, `createdAt`)" . " VALUES (?, ?, ?, ?)";
$statement = $this->db->prepare($sql);
return $statement->execute(array("e", $name, $message, current_date()));
}
function create_game($my_player)
{
return create_entry("game", array("date", "my_player"), array(), array("date" => current_date(), "my_player" => $my_player));
}
/**
* Sanitizes a comment.
*/
private function sanitize()
{
global $is_index, $index, $content;
// Sanitize user input
$this->message = sanitize_html($_POST['comment-message']);
$this->name = sanitize_string($_POST['comment-name']);
$this->email = $_POST['comment-email'];
$this->website = sanitize_url($_POST['comment-website']);
// Get date, time
$this->date = current_date();
$this->time = current_time();
}
function insert_into($live_id, $title)
{
$sql = "INSERT INTO `lives`" . " (`nicoLiveId`, `title`, `createdAt`)" . " VALUES (?, ?, ?)";
$statement = $this->db->prepare($sql);
return $statement->execute(array($live_id, $title, current_date()));
}
/**
* smspromote (german provider for sending paid SMS)
*
* @param unknown $param
* @return Ambigous <string>
*/
function churchdb_smspromote($param)
{
global $config, $user;
$url = "https://gateway.smspromote.de";
// Gateway URL
// $url = "https://gateway.smspromote.de/bulk/";
$request = "";
$param["key"] = $config["churchdb_smspromote_apikey"];
// Gateway Key
$param["route"] = "gold";
// use of Goldroute
// $param["route"] = "basic";// use of Basicroute
$param["debug"] = "0";
// SMS will not be send - Testmode
$param["message"] = utf8_decode($param["message"]);
foreach ($param as $key => $val) {
$request .= $key . "=" . urlencode($val) . "&";
}
/********************************************************
* through file, Problem, allow_url_fopen=on needed!
* // send SMS
* $response = @file($url."?".$request); // send request
* $response_code = intval($response[0]); // read response code
********************************************************/
/**
* Through FSOCKOPEN, SSL DON'T WORKS, DOES IT?
*/
//
// prepare connection
$host = "gateway.smspromote.de";
$script = "/";
$request_length = strlen($request);
$method = "POST";
// generate HTTP Header, currently use 1.0 to prevent chunked
$header = "{$method} {$script} HTTP/1.0\r\n";
$header .= "Host: {$host}\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: {$request_length}\r\n";
$header .= "Connection: close\r\n\r\n";
$header .= "{$request}\r\n";
// open connection
$socket = @fsockopen($host, 80, $errno, $errstr);
if ($socket) {
fputs($socket, $header);
// send Header
while (!feof($socket)) {
$output[] = fgets($socket);
// get Response
}
fclose($socket);
}
$response_code = intval($output[count($output) - 1]);
$response_code_arr = array();
$response_code_arr[0] = "Keine Verbindung zum Gateway";
$response_code_arr[10] = "Empfänger fehlerhaft";
$response_code_arr[20] = "Absenderkennung zu lang";
$response_code_arr[30] = "Nachrichtentext zu lang";
$response_code_arr[31] = "Messagetyp nicht korrekt";
$response_code_arr[40] = "Falscher SMS-Typ";
$response_code_arr[50] = "Fehler bei Login";
$response_code_arr[60] = "Guthaben zu gering";
$response_code_arr[70] = "Netz wird von Route nicht unterstützt";
$response_code_arr[71] = "Feature nicht über diese Route möglich";
$response_code_arr[80] = "SMS konnte nicht versendet werden";
$response_code_arr[90] = "Versand nicht möglich";
$response_code_arr[100] = "SMS wurde erfolgreich versendet.";
$body = $param["message"] . "<br><br><i>Status: " . $response_code_arr[$response_code] . "</i>";
db_query('INSERT INTO {cc_mail_queue} (receiver, sender, subject, body, htmlmail_yn, priority,
modified_date, modified_pid, send_date, error, reading_count)
VALUES (:receiver, :sender, :subject, :body, :htmlmail_yn, :priority,
:modified_date, :modified_pid, :send_date, :error, :reading_count)', array(":receiver" => $param["to"], ":sender" => "{$user->vorname} {$user->name}", ":subject" => shorten_string($param["message"], 30), ":body" => $body, ":htmlmail_yn" => 0, ":priority" => 1, ":modified_date" => current_date(), ":modified_pid" => $user->id, ":send_date" => current_date(), ":error" => $response_code == 100 ? 0 : 1, ":reading_count" => 0));
return $response_code_arr[$response_code];
}
$this->load->view('header');
$this->load->view('sidebar');
?>
<!--MAIN-->
<div id="main">
<!--POST PROJECT-->
<?php
$this->load->view('innerMenu');
$currentDate = current_date(get_est_time());
$mailCount = 0;
$unreadcount = 0;
$mailData = array();
$unreadmsg = array();
foreach ($mailList->result() as $mail) {
if (current_date($mail->created) == $currentDate) {
$mailCount = $mailCount + 1;
$mailData[$mailCount] = $mail->id;
}
$unreadcount = $unreadcount + 1;
$unreadmsg[$unreadcount] = $mail->id;
}
//Add comma between values for post values to controller
if (isset($mailData)) {
$mailData = implode(',', $mailData);
}
if (isset($unreadmsg)) {
$unreadmsg = implode(',', $unreadmsg);
}
$transactions1 = $transactions1;
//pr($transaction->result());
