query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and tag='".$tag."' and smsid>0 and smsstatus<2");
//$abfrage = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE jahr='".$jahr."' and smsid>0 and smsstatus=0");
while($row = $abfrage->fetch_assoc()) {
// echo ""; print_r($row); echo "
";
$row_logsms = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$row['smsid']."' and sender_id>0"); // and sender_id>0
if($row_logsms['num_rows']!=0) {
// echo ""; print_r($row_logsms); echo "
";
// echo $row_logsms['sender_id'];
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE name='".$row_logsms['sender']."'");
if($row_logsms['sender_id']==2) {
$api_key = 'EPOcWC8smWfdOWNHzSLANw';
$mysms = new mysms($api_key);
$login_data = array('msisdn' => '4916094934507', 'password' => 'maxdata-01');
$login = $mysms->ApiCall('json', '/user/login', $login_data); //providing REST type(json/xml), resource from http://api.mysms.com/index.html and POST data
$user_info = json_decode($login); //decode json string to get AuthToken
$_SESSION['AuthToken'] = $user_info->authToken; //saving auth Token in session for more calls
$sms_nummer=$row_logsms['nummer'];
$req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> $row_logsms['text']); //
// $req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> '*'); //
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data);
echo ""; print_r(json_decode($ergbniss)); echo "
";
$jsonrow=json_decode($ergbniss);
$tmp2=$jsonrow->messages[0]->status;
}
if($row_logsms['sender_id']==18) {
$api_key = 'OvHiwonvVKneoYttEOE64g';
$mysms = new mysms($api_key);
$login_data = array('msisdn' => '491783481356', 'password' => 'laden');
$login = $mysms->ApiCall('json', '/user/login', $login_data); //providing REST type(json/xml), resource from http://api.mysms.com/index.html and POST data
$user_info = json_decode($login); //decode json string to get AuthToken
$_SESSION['AuthToken'] = $user_info->authToken; //saving auth Token in session for more calls
$sms_nummer=$row_logsms['nummer'];
$req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> $row_logsms['text']); //
// $req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> '*'); //
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data); $jsonrow=json_decode($ergbniss); $tmp2=$jsonrow->messages[0]->status;
}
if($row_logsms['sender_id']==116) {
$api_key = 'OvHiwonvVKneoYttEOE64g';
$mysms = new mysms($api_key);
$login_data = array('msisdn' => '4915754357504', 'password' => 'Aly1Any');
$login = $mysms->ApiCall('json', '/user/login', $login_data); //providing REST type(json/xml), resource from http://api.mysms.com/index.html and POST data
$user_info = json_decode($login); //decode json string to get AuthToken
$_SESSION['AuthToken'] = $user_info->authToken; //saving auth Token in session for more calls
$sms_nummer=$row_logsms['nummer'];
$req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> $row_logsms['text']); //
// $req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> '*'); //
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data); $jsonrow=json_decode($ergbniss); $tmp2=$jsonrow->messages[0]->status;
}
if($row_logsms['sender_id']>0) {
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row['id']."'");
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row_logsms['smsID']."'");
echo ""; print_r(json_decode($ergbniss)); echo "
";
}
}
// $GLOBALS['mysql']->insert("UPDATE tourenliste SET timestamp='".date("Y-m-d H:i:s", $startzeit)."' WHERE id='".$row['id']."'");
}
echo"fertig";
?>