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.";