query("SELECT * FROM log_sms WHERE status!=2 and sender_id!=0");
while($row = $row_logsms->fetch_assoc()) {
echo ""; print_r($row); echo "
";
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM benutzer WHERE id='".$row['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);
$user_info = json_decode($login); $_SESSION['AuthToken'] = $user_info->authToken;
$req_data = array('authToken' => $_SESSION['AuthToken'], 'address'=> $row['nummer'], 'query'=> utf8_decode($row['text']));
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data);
// echo ""; print_r(json_decode($ergbniss)); echo "
";
$jsonrow=json_decode($ergbniss);
//-----------------------------------------------------------
if(isset($jsonrow->messages[0])) {
$tmp1=$jsonrow->messages[0]->messageId; $tmp2=$jsonrow->messages[0]->status; $tmp3=$jsonrow->messages[0]->dateStatus; $tmp3=substr($tmp3, 0, -3);
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[1])) {
$tmp1=$jsonrow->messages[1]->messageId; $tmp2=$jsonrow->messages[1]->status; $tmp3=$jsonrow->messages[1]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[2])) {
$tmp1=$jsonrow->messages[2]->messageId; $tmp2=$jsonrow->messages[2]->status; $tmp3=$jsonrow->messages[2]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[3])) {
$tmp1=$jsonrow->messages[3]->messageId; $tmp2=$jsonrow->messages[3]->status; $tmp3=$jsonrow->messages[3]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[4])) {
$tmp1=$jsonrow->messages[4]->messageId; $tmp2=$jsonrow->messages[4]->status; $tmp3=$jsonrow->messages[4]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[5])) {
$tmp1=$jsonrow->messages[5]->messageId; $tmp2=$jsonrow->messages[5]->status; $tmp3=$jsonrow->messages[5]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[6])) {
$tmp1=$jsonrow->messages[6]->messageId; $tmp2=$jsonrow->messages[6]->status; $tmp3=$jsonrow->messages[6]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[7])) {
$tmp1=$jsonrow->messages[7]->messageId; $tmp2=$jsonrow->messages[7]->status; $tmp3=$jsonrow->messages[7]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[8])) {
$tmp1=$jsonrow->messages[8]->messageId; $tmp2=$jsonrow->messages[8]->status; $tmp3=$jsonrow->messages[8]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
//-----------------------------------------------------------
if(isset($jsonrow->messages[9])) {
$tmp1=$jsonrow->messages[9]->messageId; $tmp2=$jsonrow->messages[9]->status; $tmp3=$jsonrow->messages[9]->dateStatus;
if($tmp1==$row['messageId']) {
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row['smsID']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$row['smsID']."'");
}
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE smsid='".$row['messageId']."'");
if($row_tour['num_rows']!=0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row_tour['id']."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$row_tour['id']."'");
}
}
}
// $GLOBALS['mysql']->insert("UPDATE tourenliste SET timestamp='".date("Y-m-d H:i:s", $startzeit)."' WHERE id='".$row['id']."'");
sleep (2);
}
echo"fertig";
?>