function get_nas($LINK, $stdlog) { $query = "SELECT * FROM " . BILL_NAS_TABLE . " WHERE usessh=1 and nastype='mikrotik'"; $result = mysql_query($query, $LINK) or do_log_sql($stdlog, "#1 " . mysql_error($LINK), $child); for ($i = 0; $i < mysql_num_rows($result); $i++) { $res = mysql_fetch_array($result); $nases[$i] = $res; } mysql_free_result($result); return $nases; }
function billing_init_packets_by_nas($nasid, $LINK, $stdlog) { $packets = array(); $result = mysql_query("SELECT * FROM " . BILL_PACKET_TABLE . " WHERE gid in (SELECT gid FROM " . BILL_PACKET_NAS_TABLE . " WHERE nasid=" . $nasid . ")", $LINK) or do_log_sql($stdlog, "#1 " . mysql_error($LINK), $child); for ($i = 0; $i < mysql_num_rows($result); $i++) { $res = mysql_fetch_array($result); $packets[$res["gid"]] = $res; } mysql_free_result($result); return $packets; }
function get_user_by_uid($uid, $LINK, $stdlog) { $SQL_Querry = "SELECT uid,user,deposit,sms_tel,mob_tel,phone FROM " . BILL_AUTH_TABLE . " WHERE `uid` = " . $uid; $result = mysql_query($SQL_Querry, $LINK) or do_log_sql($stdlog, "#deposit error " . mysql_error($LINK), $LINK); for ($i = 0; $i <= mysql_num_rows($result); $i++) { $res = mysql_fetch_array($result); $users_list[$i] = $res; } mysql_free_result($result); return $users_list; }
function get_users_birth($LINK, $stdlog) { $cur_date = "%-" . date('m-d'); # var_dump($cur_date); $SQL_Querry = "SELECT uid,user,deposit,sms_tel,mob_tel,phone FROM " . BILL_AUTH_TABLE . " WHERE date_birth LIKE '" . $cur_date . "'"; $result = mysql_query($SQL_Querry, $LINK) or do_log_sql($stdlog, "#deposit error " . mysql_error($LINK), $LINK); for ($i = 0; $i <= mysql_num_rows($result); $i++) { $res = mysql_fetch_array($result); $users_list[$i] = $res; } mysql_free_result($result); return $users_list; }