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 ""; print_r($abfrage); echo "
";
$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 ""; 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'];
$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");
}
}
?>