function gw_customcmd() { // update user's age $c_date = date("Y-m", time()); $db_query = "SELECT uid,birthday FROM playsms_tblUser WHERE birthday LIKE '{$c_date}%' AND NOT (birthday='0000-00-00')"; $db_result = dba_query($db_query); while ($db_row = dba_fetch_array($db_result)) { $c_uid = $db_row["uid"]; $c_birthday = strtotime($db_row["birthday"]); $c_age = ceil(intval(time() - $c_birthday) / 31536000); $db_query1 = "UPDATE playsms_tblUser SET age='{$c_age}' WHERE uid='{$c_uid}'"; $db_result1 = dba_query($db_query1); } // force check to clickatell.com for outgoing sms with status 0 or 1 (not yet 3) $db_query = "SELECT * FROM playsms_tblSMSOutgoing WHERE p_status=0 OR p_status=1"; $db_result = dba_query($db_query); while ($db_row = dba_fetch_array($db_result)) { $gpid = ""; $gp_code = ""; $uid = $db_row[uid]; $smslog_id = $db_row[smslog_id]; $p_datetime = $db_row[p_datetime]; $p_update = $db_row[p_update]; $gpid = $db_row[p_gpid]; $gp_code = gpid2gpcode($gpid); clktl_gw_set_delivery_status($gp_code, $uid, $smslog_id, $p_datetime, $p_update); } }
<?php if (!defined("_SECURE_")) { die("Intruder: IP " . $_SERVER['REMOTE_ADDR']); } $op = $_GET[op]; $gpid = $_GET[gpid]; switch ($op) { case "edit": if ($err) { $content = "<p><font color=red>{$err}</font><p>"; } $content .= "\n\t <h2>Edit group</h2>\n\t <p>\n\t <form action=menu.php?inc=dir_edit&op=edit_yes&gpid={$gpid} method=POST>\n\t <p>Group Name: <input type=text name=dir_name value=\"" . gpid2gpname($gpid) . "\" size=50>\n\t <p>Group Code: <input type=text name=dir_code value=\"" . gpid2gpcode($gpid) . "\" size=10> (please use uppercase and make it short)\n\t <p>Note: Group Code used by code BC (broadcast SMS from single SMS)\n\t <p><input type=submit class=button value=\"Save\"> \n\t </form>\n\t"; echo $content; break; case "edit_yes": $dir_name = $_POST[dir_name]; $dir_code = strtoupper(trim($_POST[dir_code])); if ($dir_name && $dir_code) { $db_query = "SELECT gp_code FROM playsms_tblUserGroupPhonebook WHERE uid='{$uid}' AND gp_code='{$dir_code}' AND NOT gpid='{$gpid}'"; $db_result = dba_query($db_query); if ($db_row = dba_fetch_array($db_result)) { header("Location: fr_right.php?err=" . urlencode("No changes has been made on group `{$dir_name}` code `{$dir_code}`")); die; } else { $db_query = "UPDATE playsms_tblUserGroupPhonebook SET gp_name='{$dir_name}',gp_code='{$dir_code}' WHERE uid='{$uid}' AND gpid='{$gpid}'"; $db_result = dba_query($db_query); header("Location: fr_right.php?err=" . urlencode("Group `{$dir_name}` with code `{$dir_code}` has been edited")); die; } }
function getsmsstatus() { global $gateway_module; $db_query = "SELECT * FROM playsms_tblSMSOutgoing WHERE p_status='0' AND p_gateway='{$gateway_module}'"; $db_result = dba_query($db_query); while ($db_row = dba_fetch_array($db_result)) { $gpid = ""; $gp_code = ""; $uid = $db_row[uid]; $smslog_id = $db_row[smslog_id]; $p_datetime = $db_row[p_datetime]; $p_update = $db_row[p_update]; $gpid = $db_row[p_gpid]; $gp_code = gpid2gpcode($gpid); gw_set_delivery_status($gp_code, $uid, $smslog_id, $p_datetime, $p_update); } }
$db_result = dba_query($db_query); while ($db_row = dba_fetch_array($db_result)) { $content .= "\"{$db_row['p_desc']}\",\"{$db_row['p_num']}\",\"{$db_row['p_email']}\"\n"; } ob_end_clean(); header("Content-Type: application/octet-stream"); header("Content-Disposition: attachment;filename=\"{$filename}\""); echo $content; die; break; case "import": if ($gpid) { if ($err) { $content = "<p><font color=red>{$err}</font><p>"; } $content .= "\n\t\t\t\t<h2>Import phonebook (Group code: " . gpid2gpcode($gpid) . ")</h2>\n\t\t\t\t<p>\n\t\t\t\t<form action=\"menu.php?inc=phonebook_exim&op=import_confirmation&gpid={$gpid}\" enctype=\"multipart/form-data\" method=\"post\">\n\t\t\t\t Please select CSV file for phonebook's entries (format : Name,Mobile Number,Email)<br>\n\t\t\t\t <p><input type=\"file\" name=\"fnpb\">\n\t\t\t\t <p><input type=\"checkbox\" name=\"replace\" value=\"ok\"> Same item(s) will be replaced\n\t\t\t\t <p><input type=\"submit\" value=\"Import\" class=\"button\">\n\t\t\t\t</form>\n\t\t\t "; } else { // FIXME } echo $content; break; case "import_confirmation": $replace = $_POST['replace']; $fnpb = $_FILES[fnpb]; $fnpb_tmpname = $_FILES[fnpb][tmp_name]; $content = "\n\t\t\t <h2>Import confirmation</h2>\n\t\t\t <p>\n\t\t\t <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\">\n\t\t\t <tr>\n\t\t\t\t<td class=\"box_title\" width=\"4\">*</td>\n\t\t\t\t<td class=\"box_title\" width=\"40%\">Name</td>\n\t\t\t\t<td class=\"box_title\" width=\"30%\">Mobile Number</td>\n\t\t\t\t<td class=\"box_title\" width=\"30%\">Email</td>\n\t\t\t </tr>\n\t\t\t"; if (file_exists($fnpb_tmpname)) { $fp = fopen($fnpb_tmpname, "r"); $file_content = fread($fp, filesize($fnpb_tmpname)); fclose($fp); $parse_phonebook = explode("\r\n", $file_content);