query_single("SELECT * FROM log_sms WHERE status=8 and errorId=0 and messageId>0 limit 0,1");
if($abfrage['num_rows'] != 0) {
echo ""; print_r($abfrage); echo "
";
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM benutzer WHERE id='".$abfrage['sender_id']."'");
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);
// echo ""; print_r(json_decode($login)); echo "
"; // 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 ""; print_r(json_decode($ergbniss)); echo "
";
$jsonrow=json_decode($ergbniss);
//-----------------------------------------------------------
// echo count($jsonrow->messages);
// echo $abfrage['smsID'];
if(isset($jsonrow->messages[0])) { /////
$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']."'");
} else {
if($anzahl<2) {
$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 (1);
}
//}
?>