72 lines
No EOL
4.3 KiB
PHP
72 lines
No EOL
4.3 KiB
PHP
<?php
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
error_reporting(E_ALL); ini_set('display_errors',1);
|
|
require('lib/config.php');
|
|
session_name(CONFIG_SESSION); session_start();
|
|
require('lib/mysql.class.php');
|
|
include('lib/class.mysms.php');
|
|
$GLOBALS['mysql'] = new mysql(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
|
|
date_default_timezone_set('Europe/London');
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
//------------------------------------------------- abfragen neu versendet --------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
$smstime = time();
|
|
$tmptime=$smstime-604800;
|
|
for($i=0; $i < 2; $i++) {
|
|
// $abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE errorId=0 and test=0 and messageId>0 and logtime>'".$tmptime."' ORDER BY smsID DESC");
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE test=0 and messageId>0 and logtime>'".$tmptime."' ORDER BY smsID DESC");
|
|
if($abfrage['num_rows'] != 0) {
|
|
// echo $abfrage['smsID'];
|
|
// echo "<pre>"; print_r($abfrage); echo "</pre>";
|
|
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM benutzer WHERE id='".$abfrage['sender_id']."'");
|
|
if($row_sender['num_rows']!=0) {
|
|
//-------------------------------------------------------------
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET test=1 WHERE smsID='".$abfrage['smsID']."'");
|
|
//-------------------------------------------------------------
|
|
$mysms = new mysms($row_sender['api-key']);
|
|
$login_data = array('msisdn' => $row_sender['nummer'], 'password' => $row_sender['passwd']);
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data);
|
|
echo "<pre>"; print_r(json_decode($login)); echo "</pre>"; // login prüfren
|
|
$user_info = json_decode($login); $_SESSION['AuthToken'] = $user_info->authToken;
|
|
$req_data = array('authToken' => $_SESSION['AuthToken'], 'address'=> $abfrage['nummer'], 'query'=> utf8_decode($abfrage['text']));
|
|
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data);
|
|
echo "<pre>"; print_r(json_decode($ergbniss)); echo "</pre>";
|
|
$jsonrow=json_decode($ergbniss);
|
|
//-----------------------------------------------------------
|
|
// echo count($jsonrow->messages);
|
|
// echo $abfrage['smsID'];
|
|
$test=1;
|
|
if(isset($jsonrow->messages[0])) { /////
|
|
$tmp1=$jsonrow->messages[$i]->messageId; $tmp2=$jsonrow->messages[$i]->status; $tmp3=$jsonrow->messages[$i]->dateStatus; $tmp3=substr($tmp3, 0, -3);
|
|
// $GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$abfrage['smsID']."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$abfrage['smsID']."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$abfrage['tId']."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$abfrage['tId']."'");
|
|
|
|
$anzahl=count($jsonrow->messages);
|
|
for($i=0; $i < $anzahl; $i++) {
|
|
if(isset($jsonrow->messages[$i])) {
|
|
$tmp1=$jsonrow->messages[$i]->messageId; $tmp2=$jsonrow->messages[$i]->status; $tmp3=$jsonrow->messages[$i]->dateStatus; $tmp3=substr($tmp3, 0, -3);
|
|
if($tmp1==$abfrage['messageId']) {
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$abfrage['tId']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$abfrage['tId']."'");
|
|
$test=0;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
if($test>0) {
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET status=99 WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate=99 WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus=99 WHERE id='".$abfrage['tId']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate=99 WHERE id='".$abfrage['tId']."'");
|
|
}
|
|
}
|
|
sleep (5);
|
|
} else {
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET test=0");
|
|
}
|
|
}
|
|
?>
|