46 lines
No EOL
2.2 KiB
PHP
46 lines
No EOL
2.2 KiB
PHP
<?php
|
|
|
|
$tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['id']."'");
|
|
//echo "<pre>"; print_r($tour); echo "</pre>";
|
|
if ($tour['smsstatus']!=2) {
|
|
|
|
$sms1 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$tour['smsid']."'");
|
|
|
|
|
|
//rückgabe sms1['text']
|
|
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM benutzer WHERE id='".$sms1['sender_id']."'");
|
|
if($row_sender['num_rows']!=0) {
|
|
if($row_sender['num_rows']!=0) {
|
|
$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);
|
|
$user_info = json_decode($login); $_SESSION['AuthToken'] = $user_info->authToken;
|
|
$req_data = array('authToken' => $_SESSION['AuthToken'], 'address'=> $sms1['nummer'], 'query'=> utf8_decode($sms1['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);
|
|
if(isset($jsonrow->messages[0])) { /////
|
|
for($i=0; $i < count($jsonrow->messages); $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==$sms1['messageId']) {
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$sms1['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$sms1['smsID']."'");
|
|
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$tour['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$tour['id']."'");
|
|
$tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['id']."'");
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
$template->assign('test', $tour);
|
|
|
|
|
|
$template->assign('content', 'tpl/ajax/smsstatus1.tpl');
|
|
?>
|