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);
