function deactivate($phone, $service) { $users_phone = removePlus($phone); $data = R::findOne('users', ' mobile_number = :phone', array('phone' => $users_phone)); //var_dump($data->id); exit; if (!$data) { $msg = "Sorry you are not a subscriber to any mHealth services. To subscribe text mhealth or the package name of your choice to 33121"; //echo $msg; echo smsSender($phone, $msg); exit; } if ($service == '' || strtoupper($service) == "MHEALTH") { // R::exec("delete from users where id =" . $data->id); R::exec("delete from subscription where user_phone =" . $phone); $msg = "You have been stopped from all mHealth services. To re-subscribe text mhealth or the package name of your choice to 33121"; //echo $msg; echo smsSender($phone, $msg); exit; } if (!($service == '' || strtoupper($service) == "MHEALTH")) { $cat_id = findUnsubcribeCategory($service); if ($cat_id != 0) { $sub_data = R::findOne('subscription', ' user_phone = :phone and category_id = :cat', array('phone' => $phone, 'cat' => $cat_id)); if (!$sub_data) { $msg = "Sorry you are not a subscriber to {$service} category. To subscribe under this category, text {$service} to 33121"; //echo $msg; echo smsSender($phone, $msg); exit; } else { R::exec("delete from subscription where user_phone =" . $phone); $msg = "You have been stopped from {$service} category on mHealth. To re-subscribe text mhealth or the package name of your choice to 33121"; echo smsSender($phone, $msg); //echo $msg; exit; } } else { //$msg = "Sorry you are not a subscriber to $service category. To subscribe under this category, text $service to 35123"; $msg = "The category you want to subscribe for doest not exist on mHealth services"; //echo $msg; echo smsSender($phone, $msg); exit; } } exit; }
$mtn = array('234803', '234806', '234703', '234706', '234810', '234813', '234814', '234816'); $mtn2 = array('+234803', '+234806', '+234703', '+234706', '+234810', '+234813', '+234814', '+234816'); $etisalat = array('234809', '234817', '234818', '234909'); $etisalat2 = array('+234809', '+234817', '+234818', '+234909'); $airtel = array('234802', '234708', '234808', '234812'); $airtel2 = array('+234802', '+234708', '+234808', '+234812'); $query2 = "select * from tip where schedule_time <= '" . $now . "' and processed = 0"; $result2 = mysql_query($query2) or die(mysql_error()); //$tip = mysql_fetch_array($result2); //var_dump($tip[2]); exit; while ($tip = mysql_fetch_array($result2)) { $query = "select * from subscription where expire_date >= '" . $today . "' and category_id = '" . $tip['category_id'] . "'"; $result = mysql_query($query) or die(mysql_error()); while ($subscribers = mysql_fetch_array($result)) { if (array_search(substr($subscribers['user_phone'], 0, 6), $mtn) || array_search(substr($subscribers['user_phone'], 0, 7), $mtn2)) { smsSender(checkDestination($subscribers['user_phone']), $tip['gist']); echo $subscribers['user_phone']; echo '<br/>'; echo $tip['gist']; echo '<br/>'; echo '35123'; echo '<br/>'; } elseif (array_search(substr($subscribers['user_phone'], 0, 6), $etisalat) || array_search(substr($subscribers['user_phone'], 0, 7), $etisalat2)) { smsSender3(checkDestination($subscribers['user_phone']), $tip['gist']); echo $subscribers['user_phone']; echo '<br/>'; echo $tip['gist']; echo '<br/>'; echo '32126'; echo '<br/>'; } elseif (array_search(substr($subscribers['user_phone'], 0, 6), $airtel) || array_search(substr($subscribers['user_phone'], 0, 7), $airtel2)) {
<?php set_include_path(dirname(__FILE__) . '/../lib' . PATH_SEPARATOR . dirname(__FILE__) . '/../lib/rb/' . PATH_SEPARATOR . get_include_path()); include_once 'rb.php'; include_once 'db.php'; include_once 'sms_sender.php'; $today = strtotime(date('d-M-Y')); $subscribers = R::getAll('select mobile_number from users where subscription_period >= :today and group_id = :group', array(':today' => $today, ':group' => 10)); $date = strtotime(date('d-M-Y')); $tip = R::find('tip', ' schedule_time = :date', array('date' => $date)); if ($tip) { $tip = array_shift($tip); foreach ($subscribers as $subscriber) { //echo $subscriber['mobile_number']; exit; smsSender(checkDestination($subscriber['mobile_number']), $tip->gist); } } //echo $count; function checkDestination($number) { $first = substr($number, 0, 1); if ($first == '+') { return $number; } else { return '+' . $number; } }
$bean->language = $_SESSION['language']; $bean->registration_completed = 1; $id = R::store($bean); $_SESSION['feedback_topic'] = "Registration Completed!"; $_SESSION['text'] = "Thanks {$lastname} {$firstname}, you have been successfully registered on m-Health. Your Registration ID is " . $_SESSION['sub_id']; smsSender($sms_number, $_SESSION['text']); header("Location: ../feedback.php"); } elseif ($_SESSION['status'] == 1) { $_SESSION['feedback_topic'] = "Registration Has been Completed Before!"; $_SESSION['text'] = "Thanks {$lastname} {$firstname}, you are already a registered user on m-Health"; header("Location: ../feedback.php"); } elseif ($_SESSION['status'] == 2) { R::exec("update users set\n first_name = '" . $firstname . "',\n last_name = '" . $lastname . "',\n email_addr = '" . $email . "',\n\t\t\t \t language_id = '" . $_SESSION['language'] . "',\n mobile_number = '" . $mobile_number . "',\n registration_completed = 1,\n reg_id = '" . $_SESSION['sub_id'] . "'\n where id ='" . $_SESSION['user_id'] . "'"); $_SESSION['feedback_topic'] = "Registration Completed!"; $_SESSION['text'] = "Thanks {$lastname} {$firstname}, you have been successfully registered on m-Health. Your Registration ID is " . $_SESSION['sub_id']; smsSender($sms_number, $_SESSION['text']); header("Location: ../feedback.php"); } function smsSender($dnrr, $msg) { $id = "m_health"; $pw = "WKYoDDoCV"; # ensure that you use the approved password on v2nmobile. $url = "http://v2nportal.com/sms/gateway/httpsend.php?U=" . urlencode($id) . "&P=" . urlencode($pw) . "&D=" . urlencode($dnrr) . "&S=" . urlencode("+35123") . "&M=" . urlencode($msg) . "&T=1"; /* invocation of URL */ if ($f = @fopen($url, "r")) { $answer = fgets($f, 255); //echo "<br>answer=$answer"; # remove this if you like return $answer; } else { return "gateway cannot be opened at the moment";