'491783481356', 'password' => 'laden');
$login = $mysms->ApiCall('json', '/user/login', $login_data);
$user_info = json_decode($login);
$_SESSION['AuthToken'] = $user_info->authToken;
$mysms->setAuthToken($user_info->authToken);
$msisdn = "+491783481356"; //jörg
$req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'address' => $msisdn,'offset' => 0,'limit' => 10); //providing
$ergebnis = $mysms->ApiCall('json', '/user/message/get/by/conversation', $req_data); //calling method ->ApiCall
$tmp1=$jsonrow->messages[0]->messageId;
$tmp2=$jsonrow->messages[0]->status;
$tmp3=$jsonrow->messages[0]->dateStatus; $tmp3=substr($tmp3, 0, -3);
*/
//----------------------------------------------------------------------------------------------------------------
//------------------------------------------------- abfragen neu versendet --------------------------------------
//----------------------------------------------------------------------------------------------------------------
$smstime = time();
$tmptime=$smstime-259200;
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE test=0 and messageId>0 and status!=2 and incoming!=1 and senddate>'".$tmptime."'");
if($abfrage['num_rows'] != 0) {
// echo $abfrage['smsID'];
// echo ""; print_r($abfrage); echo "
";
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id='".$abfrage['sender_id']."'");
if($row_sender['num_rows']!=0) {
//---- testvariable schreiben
$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['password']);
$login = $mysms->ApiCall('json', '/user/login', $login_data);
$user_info = json_decode($login);
$token = $user_info->authToken; // $_SESSION['AuthToken'] = $user_info->authToken; // unklar wofür
$req_data = array('address' => $abfrage['nummer'],'apiKey' => $row_sender['api-key'],'authToken' => $token,'offset' => 0,'limit' => 10);
$ergebnis = $mysms->ApiCall('json', '/user/message/get/by/conversation', $req_data); //calling method ->ApiCall
//-------------------------------------------------------------- unread phone
$req_data2 = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken']);
$unread = $mysms->ApiCall('json', '/user/call/count/unread', $req_data2);
//echo ""; print_r($req_data); echo "
";
$jsondata=json_decode($unread);
$GLOBALS['mysql']->insert("UPDATE gateway SET unread_tel='".$jsondata->unreadCount."' WHERE id='".$abfrage['sender_id']."'");
//------------------------------------------------------------------------
$jrow=json_decode($ergebnis);
$anzahl=count($jrow->messages);
if($anzahl!=0) {
for($i=0; $i < $anzahl; $i++) {
$tmp1=$jrow->messages[$i]->messageId;
$tmp2=$jrow->messages[$i]->status;
// if($tmp2==0) { $tmp2=1; }
$tmp3=$jrow->messages[$i]->dateStatus; $tmp3=substr($tmp3,0,-3);
echo $jrow->messages[$i]->message." - Status: ".$tmp2."";
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."',statusdate='".$tmp3."' WHERE messageId='".$tmp1."'");
// $GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."', WHERE messageId='".$tmp1."'");
// $GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE messageId='".$tmp1."'");
if($abfrage['tId']>0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE smsid='".$tmp1."'");
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE smsid='".$tmp1."'");
}
}
}
}
} else {
$GLOBALS['mysql']->insert("UPDATE log_sms SET test=0 WHERE logtime>'".$tmptime."'");
echo "keine SMS zu prüfen...";
}
//---------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------------------------------
$tmp = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE status=1");
if($tmp['num_rows'] != 0) {
$lat= $tmp['lat'];
$lng= $tmp['lng'];
$page1='http://nominatim.openstreetmap.org/reverse?format=json&lat='.$lat.'&lon='.$lng.'&email=frank@first-mp.de';
$html2 = file_get_contents($page1);
$jsonrow2=json_decode($html2);
if(isset($jsonrow2->address->town)) {
$datastreet=($jsonrow2->address->town);
} else {
if(isset($jsonrow2->address->city)) {
$datastreet=($jsonrow2->address->city);
} else {
if(isset($jsonrow2->address->city_district)) {
$datastreet=($jsonrow2->address->city_district);
} else {
$datastreet=($jsonrow2->address->village);
}
}
}
$datastreet=utf8_decode($datastreet);
if(strlen($tmp['street'])<5) {
$street=$tmp['street'].', '.$datastreet;
} else {
$street=$datastreet.', '.$tmp['street'];
}
$GLOBALS['mysql']->insert("UPDATE verkehr SET street='".$street."' WHERE id='".$tmp['id']."'");
$GLOBALS['mysql']->insert("UPDATE verkehr SET status=2 WHERE id='".$tmp['id']."'");
echo "Versbezeichnung:".$street;
//---------------------------------------------------------------------------------------------------------------------------
} else {
echo "keine geocoordinaten zu prüfen...";
}
//---------------------------------------------------------------------------------------------------------------------------
//----------------------------------------------------------- unread call
/*
for($i=1; $i < 4; $i++) {
echo'---'.$i.'---';
$gw = $GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id='".$i."'");
$api_key = $gw['api-key'];
$msisdn = $gw['nummer'];
$smspass= $gw['password'];
$mysms = new mysms($api_key);
$login_data = array('msisdn' => $msisdn , 'password' => $smspass);
$login = $mysms->ApiCall('json', '/user/login', $login_data);
$user_info = json_decode($login);
$_SESSION['AuthToken'] = $user_info->authToken;
$mysms->setAuthToken($user_info->authToken);
$req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken']);
$unread = $mysms->ApiCall('json', '/user/call/count/unread', $req_data);
echo ""; print_r($req_data); echo "
";
$jsondata=json_decode($unread);
echo ""; print_r($unread); echo "";
$GLOBALS['mysql']->insert("UPDATE gateway SET unread_tel='".$jsondata."' WHERE id='".$i."'");
$jrow=json_decode($ergebnis);
}
*/
//---------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------------------------------
?>