Exemple #1
0
function sendsomesms($destination, $sender, $msgs, $counter, $user_sess, $sms_count)
{
    $con = mysqli_connect("localhost", "root", "", "dlr");
    //connection
    // $con=mysqli_connect("localhost","root","","dlr"); //connection
    $count = 0;
    while ($count < $counter) {
        $number = $destination[$count];
        $msisdn = preg_replace('/\\D/', '', $number);
        $msisdn = msisdn_prep($msisdn);
        //put msisdn in proper format
        $network = which_network($msisdn);
        $id = uniqid('NS', true);
        return $sql = "INSERT INTO logs(id, username, msisdn, sender, sms_count, network, message, status) VALUES ('{$id}', '{$user_sess}', '{$msisdn}', '{$sender}','{$sms_count}','{$network}','{$msgs}','ack')";
        mysqli_query($con, $sql);
        // $msgs = urlencode($msgs);
        // $url = "http://168.144.175.52:13013/cgi-bin/sendsms?username=tester&password=foobar&to=" . $msisdn . "&from=" . $sender . "&text=" . $msgs . "&smsc=buzismsc1&dlr-mask=31";
        // $url = "http://5.231.54.137:13013/cgi-bin/sendsms?username=tester&password=foobar&to=" . $msisdn . "&from=" . $sender . "&text=" . $msgs . "&smsc=buzismsc1&dlr-mask=31";
        // $urloutput = file_get_contents($url);
        $count++;
    }
    $rem_start_point = $count;
    $rem_array = array_slice($destination, $rem_start_point);
    $no_rem = count($rem_array);
    $msisdn_string = implode($rem_array, ',');
    $sql2 = "INSERT INTO q_msgs (username, msisdn, sender, msg, sms_count, status ) \n\t\t\t\tVALUES ('{$user_sess}', '{$msisdn_string}', '{$sender}', '{$msgs}', '{$sms_count}','pending' )";
    if (mysqli_query($con, $sql2)) {
        // return $no_rem;
    }
}
Exemple #2
0
     $new_bal = $curr_bal - $tot_cost + $rejected_cost;
     //new balance
     $q2 = "UPDATE credit SET new_bal = '{$new_bal}' WHERE username = '******'";
     //updates the new balance
     mysqli_query($con, $q2);
     $new_credit_used = $credit_used + $tot_cost;
     mysqli_query($con, "UPDATE credit SET credit_used = '{$new_credit_used}' WHERE username = '******'");
     //updates credit used
     $logged = $nummsisdn - $no_rej_msisdn;
 } else {
     $count = 0;
     $job_id = $user_sess . date('YmdHis');
     while ($count < $counter) {
         $number = $destination[$count];
         $msisdn = preg_replace('/\\D/', '', $number);
         $msisdn = msisdn_prep($msisdn);
         //put msisdn in proper format
         if (is_numeric($msisdn)) {
             if (substr($msisdn, 0, 1) == '1') {
                 $code = substr($msisdn, 0, 1);
                 $ccLength = strlen($code);
             } elseif (substr($msisdn, 0, 2) == '44') {
                 $code = substr($msisdn, 0, 2);
                 $ccLength = strlen($code);
             } else {
                 $code = substr($msisdn, 0, 3);
                 $ccLength = strlen($code);
             }
             $network = which_network($msisdn);
             $id = uniqid('NS', true);
             checkCode($code);