Paramètres d'appel de la page :
<ul>
<li>aucun</li>
</ul>
-->
<?php
define('BASE', './');
require_once BASE . 'lib/debug.php';
require_once BASE . 'lib/http_request.php';
require_once BASE . 'lib/smartplug.php';
//
ini_set('max_execution_time', 300);
// ouverture de la connexion à la base de données
require_once BASE . 'lib/connect_db.php';
open_mysql_connection();
// lecture de la liste des prises
$sql = "select * from plug where 1=1 ";
//$sql .= " and ip_address = '192.168.0.191'"; //pour debug
//if ($group!="") $sql .= " and id_group = ".$group;
$sql .= " order by name";
if ($debug) {
echo "sql={$sql}<br>";
}
$glb_err = false;
$res = mysql_query($sql, $conn);
if (!$res) {
$glb_err = true;
$msg = "Echec de la requête SQL : " . mysql_error();
} else {
if (mysql_num_rows($res) > 0) {
//$port="465";
$sms_sent = 0;
$sms_unsent = 0;
$email_sent = 0;
$sms_count = 0;
// CHECK FOR DEMON LOCK
if (file_exists("/var/lock/skol_sendsms")) {
echo "SKOL Send SMS Already Running Time:" . date("Y-M-d H:m:s") . "\n";
exit;
}
echo "SKOL SMS Script Started --------------------\n";
// Creating Touch Lock file
touch("/var/lock/skol_sendsms");
echo "Start Time: " . date("Y-M-d H:i:s") . "\n";
// Connecting DB ::
$dbhandle = open_mysql_connection($hostname, $username, $password);
// Selecting DB
$selected = use_data_base($dbhandle, $db_name);
$sms_send = true;
if ($sms_send != false) {
// Fetech Record from student_test_schedule_view
$result = mysql_query("SELECT * FROM student_test_schedule_view");
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
while ($row = mysql_fetch_array($result)) {
// collect user information
$user_fname = $row['user_fname'];
$email_id = $row['user_email'];
$subject_title = "SKOL Test remainder";
$user_phone = $row['user_phone'];
$message_body = "Dear " . $row['user_fname'] . ", \nThere is an Test coming up in " . $row['course_name'] . " - " . $row['subject_name'] . " - " . $row['test_name'] . " on tomorrow Date " . $row['schedule'] . "\nAll The Best. \nThanks and Regards \nSKOL System \nadmin@skolsystem.com.";
