Exemplos de do_log_sql em PHP

Exemplo n.º 1

Arquivo: rkn-mikrotik.php Projeto: hakerillo66/mikbill_distr

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

Exemplo n.º 2

Arquivo: pcq_script_5x.php Projeto: hakerillo66/mikbill_distr

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

Exemplo n.º 3

Arquivo: sms_ukraine_balance.php Projeto: hakerillo66/mikbill_distr

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

Exemplo n.º 4

Arquivo: sms_2.php Projeto: hakerillo66/mikbill_distr

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