Decoded for: [email protected]

<?php
class db_layout {
    var $classname = "db_layout";
    var $db_name;
    var $db_user;
    var $db_password;
    var $db_host;
    var $db_link_ptr;
    var $tables;
    var $fields;
}
class db_mysql extends db_layout {
    var $classname = "db_mysql";
    var $db_result;
    var $db_affected_rows;
    var $saved_results = array();
    var $results_saved = 0;
    function error($where = "", $error, $errno) {
        echo "<meta http-equiv=\"refresh\" content=\"0; url=index.php\">";
        die();
    }
    function error_msg() {
        echo "<meta http-equiv=\"refresh\" content=\"0; url=index.php\">";
    }
    function PushResults() {
        $this->saved_results[$this->results_saved] = array($this->db_result, $this->db_affected_rows);
        $this->results_saved++;
    }
    function PopResults() {
        $this->results_saved--;
        $this->db_result = $this->saved_results[$this->results_saved][0];
        $this->db_affected_rows = $this->saved_results[$this->results_saved][1];
    }
    function db_mysql($host, $user, $passwd, $db, $create = "") {
        $this->db_name = $db;
        $this->db_user = $user;
        $this->db_passwd = $passwd;
        $this->db_host = $host;
        $this->db_link_ptr = @mysql_connect($host, $user, $passwd) or $this->error("", mysql_error(), mysql_errno());
        $this->dbhandler = @mysql_select_db($db);
        if (!$this->dbhandler) {
            if ($create == "1") {
                @mysql_create_db($db, $this->db_link_ptr) or $this->error("imposible crear la base de datos.", mysql_error(), mysql_errno());
                $this->dbhandler = @mysql_select_db($db);
            }
        }
    }
    function reselect_db($db) {
        $this->dbhandler = @mysql_select_db($db);
    }
    function closeDB() {
        @mysql_close($this->db_link_ptr);
    }
    function create_table($tblName, $tblStruct) {
        if (is_array($tblStruct)) $theStruct = implode(",", $tblStruct);
        else $theStruct = $tblStruct;
        @mysql_query("create table $tblName ($theStruct)") or $this->error("create table $tblName ($theStruct)", mysql_error(), mysql_errno());
    }
    function drop_table($tblName) {
        @mysql_query("drop table if exists $tblName") or $this->error("drop table $tblName", mysql_error(), mysql_errno());
    }
    function raw_query($sql_stat) {
        $this->db_result = @mysql_query($sql_stat) or $this->error($sql_stat, mysql_error(), mysql_errno());
        $this->db_affected_rows = @mysql_num_rows($this->db_result);
    }
    function count_records($table, $filter = "") {
        $this->db_result = @mysql_query("select count(*) as num from $table" . (($filter != "") ? " where $filter" : ""));
        $xx = @mysql_result($this->db_result, 0, "num");
        return $xx;
    }
    function select($fields, $tables, $where = "", $order_by = "", $group_by = "", $having = "", $limit = "") {
        $sql_stat = " select $fields from $tables ";
        if (!empty($where)) $sql_stat.= "where $where ";
        if (!empty($group_by)) $sql_stat.= "group by $group_by ";
        if (!empty($order_by)) $sql_stat.= "order by $order_by ";
        if (!empty($having)) $sql_stat.= "having $having ";
        if (!empty($limit)) $sql_stat.= "limit $limit ";
        $this->db_result = @mysql_query($sql_stat) or $this->error($sql_stat, mysql_error(), mysql_errno());
        $this->db_affected_rows = @mysql_num_rows($this->db_result);
        return $sql_stat;
    }
    function list_tables() {
        $this->db_result = @mysql_list_tables($this->db_name);
        $this->db_affected_rows = @mysql_num_rows($this->db_result);
        return $this->db_result;
    }
    function describe($tablename) {
        $this->result = @mysql_query("describe $tablename");
    }
    function table_exists($tablename) {
        $this->pushresults();
        $description = $this->describe($tablename);
        $this->popresults();
        if ($description) $exists = true;
        else $exists = false;
        return $exists;
    }
    function tablename($tables, $tbl) {
        return mysql_tablename($tables, $tbl);
    }
    function insert_id() {
        return mysql_insert_id();
    }
    function insert($table, $fields = "", $values = "") {
        $sql_stat = "insert into $table ";
        if (is_array($fields)) $theFields = implode(",", $fields);
        else $theFields = $fields;
        if (is_array($values)) $theValues = "'" . implode("','", $values) . "'";
        else $theValues = $values;
        $theValues = str_replace("'now()'", "now()", $theValues);
        if (!empty($theFields)) $sql_stat.= "($theFields) ";
        $sql_stat.= "values ($theValues)";
        @mysql_query($sql_stat) or $this->error($sql_stat, mysql_error(), mysql_errno());
    }
    function update($table, $newvals, $where = "") {
        if (is_array($newvals)) $theValues = implode(",", $newvals);
        else $theValues = $newvals;
        $sql_stat = "update $table set $theValues";
        if (!empty($where)) $sql_stat.= " where $where";
        @mysql_query($sql_stat) or $this->error($sql_stat, mysql_error(), mysql_errno());
    }
    function delete($table, $where = "") {
        $sql_stat = "delete from $table ";
        if (!empty($where)) $sql_stat.= "where $where ";
        $db_result2 = @mysql_query($sql_stat) or $this->error($sql_stat, mysql_error(), mysql_errno());
        $this->db_affected_rows = @mysql_affected_rows($this->db_result2);
    }
    function free() {
        @mysql_free_result($this->db_result) or $this->error("", mysql_error(), mysql_errno());
    }
    function fetch_row() {
        $row = mysql_fetch_row($this->db_result);
        return $row;
    }
    function result($recno, $field) {
        if ($this->num_rows() > 0) {
            return mysql_result($this->db_result, $recno, $field);
        }
    }
    function num_fields() {
        return mysql_num_fields($this->db_result);
    }
    function fetch_array() {
        $row = mysql_fetch_array($this->db_result);
        return $row;
    }
    function fetch_field() {
        $row = mysql_fetch_field($this->db_result);
        return $row;
    }
    function num_rows() {
        $row = mysql_num_rows($this->db_result);
        return $row;
    }
    function dataku($field, $username) {
        $this->select($field, "member", "username='$username'");
        if ($this->num_rows() > 0) {
            $dt = $this->result(0, $field);
        }
        return $dt;
    }
    function dataku2($field, $username) {
        $this->select($field, "member2", "username='$username'");
        if ($this->num_rows() > 0) {
            $dt = $this->result(0, $field);
        }
        return $dt;
    }
    function databankku($field, $username) {
        $this->select($field, "bank", "idpec='$username'");
        if ($this->num_rows() > 0) {
            $dt = $this->result(0, $field);
        }
        return $dt;
    }
    function dataahliwarisku($field, $username) {
        $this->select($field, "ahliwaris", "idpec='$username'");
        if ($this->num_rows() > 0) {
            $dt = $this->result(0, $field);
        }
        return $dt;
    }
    function subkat($kat, $sub) {
        $this->select($kat, "katagori", "sub='$sub'");
        $dt = $this->result(0, $kat);
        return $dt;
    }
    function data($field, $table, $cond) {
        $this->select($field, $table, $cond);
        $dt = $this->result(0, $field);
        return $dt;
    }
    function iklan_lama($username) {
        $this->select("no, judul", "iklan", "userid='$username' and status=0");
        $j = $this->num_rows();
        if ($j > 0) {
            $ada = $j;
        } else {
            $ada = 0;
        }
        return $ada;
    }
    function publikasi($username) {
        $this->select("no, judul", "berita", "username='$username'");
        $j = $this->num_rows();
        if ($j > 0) {
            $ada = $j;
        } else {
            $ada = 0;
        }
        return $ada;
    }
    function katiklan($no) {
        $this->select("id, title", "categories", "id='$no'");
        $kat = $this->fetch_row();
        return $kat[1];
    }
    function config($field) {
        $sql = mysql_query("select $field from configuration where id=1");
        $row = mysql_fetch_row($sql);
        $kat = $row[0];
        return $kat;
    }
    function config2($field) {
        $sql = mysql_query("select $field from configuration where id=2");
        $row = mysql_fetch_row($sql);
        $kat = $row[0];
        return $kat;
    }
    function downline($level, $st, $username) {
        $jdl = 0;
        $sql = mysql_query("select * from member where $level='$username' and status=$st");
        $jdl = mysql_num_rows($sql);
        return $jdl;
    }
    function downline2($level, $st, $username) {
        $jdl = 0;
        $sql = mysql_query("select * from member2 where $level='$username' and status=$st");
        $jdl = mysql_num_rows($sql);
        return $jdl;
    }
    function klik($username) {
        $cl = 0;
        $this->select("*", "click", "refid='$username'");
        $cl = $this->num_rows();
        return $cl;
    }
    function totbonus($username, $st, $sp) {
        $tb = 0;
        $sql = mysql_query("select rp1, rp2 from member where $sp='$username' and status=$st");
        while ($row = mysql_fetch_row($sql)) {
            if ($sp == "sponsor") {
                $tb = $tb + $row[0];
            } else {
                $tb = $tb + $row[1];
            }
        }
        return $tb;
    }
    function totbonus2($username, $st, $sp) {
        $tb = 0;
        $sql = mysql_query("select rp1, rp2 from member2 where $sp='$username' and status=$st");
        while ($row = mysql_fetch_row($sql)) {
            if ($sp == "sponsor") {
                $tb = $tb + $row[0];
            } else {
                $tb = $tb + $row[1];
            }
        }
        return $tb;
    }
    function topmenu() {
        $sql = $this->select("id, name, alias, link", "menu", "published=1", "ordering");
        $n = $this->num_rows();
        echo "<ul>";
        for ($i = 0;$i < $n;$i++) {
            $mx = explode("=", $this->result($i, "link"));
            $ma = $mx[2];
            $mb = explode("&", $mx[1]);
            $catid = $mb[1];
            if ($m == "contact") {
                $cl = "class=current";
            } else {
                $cl = "";
            }
            echo "<li><a href='" . $this->result($i, "link") . "' $cl><span>" . $this->result($i, "name") . "</span>$m</a></li>";
        }
        echo "</ul>";
    }
    function delete_html($form_name) {
        $form_name = str_replace("[", "", "$form_name");
        $form_name = str_replace("]", "", "$form_name");
        $not = "\"'*\abcdefghijklmnopqrstuvwxyz1234567890&#225;&#233;&#237;&#243;&#250;&#253;&#226;&#234;&#238;&#244;&#251;&#224;&#232;&#236;&#242;&#249;&#231;&#228;&#235;&#239;&#246;&#252;&#255;=~`@#$%^&*()_{}\n\t\r\ /;:.!?,+-";
        $form_name = eregi_replace("(</)+[$not]+(>)", "", "$form_name");
        $form_name = eregi_replace("(<)+[$not]+(>)", "", "$form_name");
        $form_name = str_replace("<", "", $form_name);
        $form_name = str_replace(">", "", $form_name);
        $form_name = htmlspecialchars($form_name);
        return $form_name;
    }
    function crops($teks, $jh) {
        $ISIBERITA = $teks;
        $b_bagianberita = $jh;
        $TMPBAGIANBERITA = array();
        $TMP = explode(" ", $ISIBERITA);
        for ($i = 0;$i <= $b_bagianberita;$i++) {
            $TMPBAGIANBERITA[$i] = $TMP[$i];
        }
        $BAGIANBERITA = implode(" ", $TMPBAGIANBERITA);
        $dt = $BAGIANBERITA;
        return $dt;
    }
    function news($ref) {
        $this->select("id, title, maintext, created", "content", "catid=4 and published=1", "created desc", "", "", "3");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            echo "<h4><a href='?m=news&nid=" . $this->result($i, "id") . "'>" . $this->result($i, "title") . "</a></h4>";
            echo "<div class='author'>" . formatgl($tgcr) . "</div>";
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text0...";
            echo "<br/>";
            echo "<br/>";
        }
    }
    function office($ref) {
        $this->select("id, title, maintext, created", "content", "catid=48 and published=1", "created desc", "", "", "1");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function layanan($ref) {
        $this->select("id, title, maintext, created", "content", "catid=49 and published=1", "created desc", "", "", "1");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function goldenways($ref) {
        $this->select("id, title, maintext, created", "content", "catid=55 and published=1", "created desc", "", "", "1");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function smsaktivasi($ref) {
        $this->select("id, title, maintext, created", "content", "catid=50 and published=1", "created desc", "", "", "1");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function presentasi($ref) {
        $this->select("id, title, maintext, created", "content", "catid=51 and published=1", "created desc", "", "", "1");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function event($ref) {
        $this->select("id, title, maintext, created", "content", "catid=34 and published=1", "created desc", "", "", "3");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            echo "<h4><a href='?m=news&nid=" . $this->result($i, "id") . "&id=$sponsor'>" . $this->result($i, "title") . "</a></h4>";
            echo "<div class='author'>" . formatgl($tgcr) . "</div>";
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text0...";
            echo "<br/>";
            echo "<br/>";
        }
    }
    function newshead($ref) {
        $this->select("id, title, maintext, created", "content", "catid=42 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function marketing($ref) {
        $this->select("id, title, maintext, created", "content", "catid=3 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function gallery($ref) {
        $this->select("id, title, maintext, created", "content", "catid=41 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function company($ref) {
        $this->select("id, title, maintext, created", "content", "catid=33 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function download($ref) {
        $this->select("id, title, maintext, created", "content", "catid=47 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function tips($ref) {
        $this->select("id, title, maintext, created", "content", "catid=45 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function pensiunmayjen($ref) {
        $this->select("id, title, maintext, created", "content", "catid=43 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function pensiunjendral($ref) {
        $this->select("id, title, maintext, created", "content", "catid=44 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function stokis($ref) {
        $this->select("id, title, maintext, created", "content", "catid=46 and published=1", "created desc", "", "", "");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            $text0 = $this->crops($this->delete_html($text), 8);
            echo "$text";
        }
    }
    function newssum($ref) {
        $this->select("id, title, maintext, created", "content", "catid=4 and published=1", "created desc", "", "", "5");
        $ada = $this->num_rows();
        for ($i = 0;$i < $ada;$i++) {
            $text = $this->result($i, "maintext");
            $tgcr = $this->result($i, "created");
            echo "<h4><a href='?m=news&nid=" . $this->result($i, "id") . "'>" . $this->result($i, "title") . "</a></h4>";
            echo "<div class='author'>" . formatgl($tgcr) . "</div>";
            echo "<br/>";
            $text0 = $this->crops($this->delete_html($text), 125);
            echo "$text0...<a href='?m=news&nid=" . $this->result($i, "id") . "'>" . "read more" . "</a>";
            echo "<br/>";
            echo "<br/>";
        }
    }
    function dataupline($field, $username) {
        $dup = "";
        $this->select("$field", "upline", "username='$username'");
        $row = $this->fetch_row();
        $dup = $row[0];
        return $dup;
    }
    function dataupline2($field, $username) {
        $dup = "";
        $this->select("$field", "upline2", "username='$username'");
        $row = $this->fetch_row();
        $dup = $row[0];
        return $dup;
    }
    function tree($username) {
        $tr = "";
        $this->select("id", "tree", "username='$username'");
        $tr = $this->result(0, "id");
        return $tr;
    }
    function tree2($username) {
        $tr = "";
        $this->select("id", "tree2", "username='$username'");
        $tr = $this->result(0, "id");
        return $tr;
    }
    function levelmbr($username, $posisine) {
        $jlv = 0;
        $slv = "select * from upline order by level desc";
        $rlv = mysql_query($slv);
        $slev = mysql_fetch_array($rlv);
        $jmlev = $slev["level"];
        $sqlki = "select a.username, b.status from upline as a inner join member as b on a.username=b.username where a.upline0='$username' and a.posisi='$posisine' and b.status=1";
        $rki = mysql_query($sqlki);
        $kir = mysql_fetch_array($rki);
        $adaki = mysql_num_rows($rki);
        $user = $kir[0];
        if ($adaki > 0) {
            for ($i = 0;$i < $jmlev;$i++) {
                $sql2 = "select a.username, b.status from upline as a inner join member as b on a.username=b.username where upline$i='$user' and b.status=1";
                $res = mysql_query($sql2);
                $jml = array();
                $jml[$i] = mysql_num_rows($res);
                $lv = 1 + $i;
                if ($jml[$i] > 0) {
                    $jl = $lv;
                }
            }
            $tb = 1;
        } else {
            $jl = 0;
            $tb = 0;
        }
        $jlv = $jl + $tb;
        return $jlv;
    }
    function levelmbr2($username, $posisine) {
        $jlv = 0;
        $slv = "select * from upline2 order by level desc";
        $rlv = mysql_query($slv);
        $slev = mysql_fetch_array($rlv);
        $jmlev = $slev["level"];
        $sqlki = "select a.username, b.status from upline2 as a inner join member2 as b on a.username=b.username where a.upline0='$username' and a.posisi='$posisine' and b.status=1";
        $rki = mysql_query($sqlki);
        $kir = mysql_fetch_array($rki);
        $adaki = mysql_num_rows($rki);
        $user = $kir[0];
        if ($adaki > 0) {
            for ($i = 0;$i < $jmlev;$i++) {
                $sql2 = "select a.username, b.status from upline2 as a inner join member2 as b on a.username=b.username where upline$i='$user' and b.status=1";
                $res = mysql_query($sql2);
                $jml = array();
                $jml[$i] = mysql_num_rows($res);
                $lv = 1 + $i;
                if ($jml[$i] > 0) {
                    $jl = $lv;
                }
            }
            $tb = 1;
        } else {
            $jl = 0;
            $tb = 0;
        }
        $jlv = $jl + $tb;
        return $jlv;
    }
    function match($username) {
        $mt = "";
        $kia = memberkiri($username, "and b.status=1");
        $kaa = memberkanan($username, "and b.status=1");
        if ($kia > $kaa) {
            $match = $kaa;
            $ki_unmatch = $kia - $kaa;
            $ka_unmatch = $kaa - $kia;
        } else {
            $match = $kia;
            $ki_unmatch = $kaa - $kia;
            $ka_unmatch = $kia - $kaa;
        }
        $mt = $match;
        return $mt;
    }
    function matchkit($username) {
        $mt = "";
        $kia = memberkiri($username, "and b.status=1");
        $kta = membertengah($username, "and b.status=1");
        if ($kia > $kta) {
            $matchkit = $kta;
            $ki_unmatch = $kia - $kta;
            $kt_unmatch = $kta - $kia;
        } else {
            $matchkit = $kia;
            $ki_unmatch = $kta - $kia;
            $kt_unmatch = $kia - $kta;
        }
        $mt = $matchkit;
        return $mt;
    }
    function matchkat($username) {
        $mt = "";
        $kta = membertengah($username, "and b.status=1");
        $kaa = memberkanan($username, "and b.status=1");
        if ($kaa > $kta) {
            $matchkat = $kta;
            $kt_unmatch = $kaa - $kta;
            $ka_unmatch = $kta - $kaa;
        } else {
            $matchkat = $kaa;
            $kt_unmatch = $kta - $kaa;
            $ka_unmatch = $kaa - $kta;
        }
        $mt = $matchkat;
        return $mt;
    }
    function match2($username) {
        $mt = "";
        $kia = memberkiri($username, "and b.status=1");
        $kaa = memberkanan($username, "and b.status=1");
        if ($kia > $kaa) {
            $match = $kaa;
            $ki_unmatch = $kia - $kaa;
            $ka_unmatch = $kaa - $kia;
        } else {
            $match = $kia;
            $ki_unmatch = $kaa - $kia;
            $ka_unmatch = $kia - $kaa;
        }
        $mt = $match;
        return $mt;
    }
    function jumlahdl($username, $status) {
        $lev = mysql_query("select level from upline order by level desc");
        $lv = mysql_fetch_row($lev);
        $jmlev = $lv[0];
        for ($i = 0;$i < $jmlev;$i++) {
            $sql = mysql_query("SELECT a.username, b.status FROM upline as a INNER JOIN member as b on a.username=b.username WHERE a.upline$i='$username' AND b.status='$status'");
            $ada = mysql_num_rows($sql);
            $td = $td + $ada;
        }
        $jdl = $td;
        return $jdl;
    }
    function jumlahdl2($username, $status) {
        $lev = mysql_query("select level from upline2 order by level desc");
        $lv = mysql_fetch_row($lev);
        $jmlev = $lv[0];
        for ($i = 0;$i < $jmlev;$i++) {
            $sql = mysql_query("SELECT a.username, b.status FROM upline2 as a INNER JOIN member2 as b on a.username=b.username WHERE a.upline$i='$username' AND b.status='$status'");
            $ada = mysql_num_rows($sql);
            $td = $td + $ada;
        }
        $jdl = $td;
        return $jdl;
    }
    function jumlahsp($username) {
        $j = 0;
        $sql = mysql_query("select username from member where sponsor='$username' and status=1");
        $j = mysql_num_rows($sql);
        return $j;
    }
    function jumlahsp2($username) {
        $j = 0;
        $sql = mysql_query("select username from member2 where sponsor='$username' and status=1");
        $j = mysql_num_rows($sql);
        return $j;
    }
    function aktivasi($username) {
        $clientdate = (date("Y-m-d H:i:s"));
        $tgl_skr = (date("Y-m-d"));
        $dtfrom = "$tgl_skr 00:00:00";
        $dtto = "$tgl_skr 23:59:59";
        $jam = date("H:i:s");
        $sponsore = $this->dataku("sponsor", $username);
        $this->insert("topsponsor", "", "'', '$sponsore', '$clientdate', 0");
        $this->update("member", "status=1, tglaktif='$clientdate'", "username='$username'");
        $this->select("username", "komisi", "dari='$username'");
        if ($this->num_rows() == 0) {
            $k_spon = $this->config("komisi_sponsor");
            $k_gen = explode("|", $this->config("komgenerasi"));
            if ($sponsore) {
                $this->insert("komisi", "", "'', '$sponsore', '$k_spon', '$clientdate', '0', '', 'komsponsor', '$username'");
                $jsp = $this->jumlahsp($sponsore);
                $this->update("upline", "sp='$jsp'", "username='$sponsore'");
                $this->update("topsponsor", "sp='$jsp'", "username='$sponsore'");
            }
            $level = $this->dataupline("level", $username);
            $level = $this->dataupline("level", $username);
            $kompas = $this->config("kompasangan");
            $kompase = explode("|", $kompas);
            $k_pas = $kompase[0];
            $k_pas2 = $kompase[1];
            $kompls = $this->config("kompulsa");
            $komplse = explode("|", $kompls);
            $k_paspls = $komplse[0];
            $k_paspls2 = $komplse[1];
            $flush = $this->config("flushout");
            $flushe = explode("|", $flush);
            $fo = $flushe[0];
            $fo2 = $flushe[1];
            for ($i = 0;$i < $level;$i++) {
                $upli = $this->dataupline("upline$i", $username);
                $matchnow = $this->matchkit($upli);
                $matchnowe = $this->matchkat($upli);
                $uql = mysql_query("select username from komisi where jenis='kompasangan' and username='$upli'");
                $matchkit = mysql_num_rows($uql);
                $usp = explode("-", $upli);
                $sql_fo = mysql_query("select username from komisi where jenis='kompasangan' and username='$usp[0]' and (tglbayar between '$dtfrom' and '$dtto')");
                $ada_fo = mysql_num_rows($sql_fo);
                if ($matchnow == $matchkit + 1) {
                    if ($ada_fo < $fo) {
                        $this->insert("komisi", "", "'', '$upli', '$k_pas', '$clientdate', '0', '', 'kompasangan', '$username'");
                        $this->insert("komisi", "", "'', '$upli', '$k_paspls', '$clientdate', '0', '', 'kompulsa', '$username'");
                        $sponsoreup = $this->dataku("sponsor", $upli);
                        $sponsor1 = $this->dataku("sponsor", $sponsoreup);
                        $sponsor2 = $this->dataku("sponsor", $sponsor1);
                        $sponsor3 = $this->dataku("sponsor", $sponsor2);
                        $sponsor4 = $this->dataku("sponsor", $sponsor3);
                        $sponsor5 = $this->dataku("sponsor", $sponsor4);
                        $sponsor6 = $this->dataku("sponsor", $sponsor5);
                        $sponsor7 = $this->dataku("sponsor", $sponsor6);
                        $sponsor8 = $this->dataku("sponsor", $sponsor7);
                        $sponsor9 = $this->dataku("sponsor", $sponsor8);
                        $sponsor10 = $this->dataku("sponsor", $sponsor9);
                        $this->insert("komisi", "", "'', '$sponsoreup', '$k_gen[0]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor1', '$k_gen[1]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor2', '$k_gen[2]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor3', '$k_gen[3]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor4', '$k_gen[4]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor5', '$k_gen[5]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor6', '$k_gen[6]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor7', '$k_gen[7]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor8', '$k_gen[8]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor9', '$k_gen[9]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                    } else {
                        if ($ada_fo == $fo) {
                            $prestasi = $this->config("prestasi");
                            $aku = (int)$prestasi;
                            $this->insert("prestasi", "", "'', '$usp[0]', '$aku', '$clientdate'");
                        }
                    }
                }
                if ($matchnowe == $match + 1) {
                    if ($ada_fo < $fo2) {
                        $this->insert("komisi", "", "'', '$upli', '$k_pas2', '$clientdate', '0', '', 'kompasangan', '$username'");
                        $this->insert("komisi", "", "'', '$upli', '$k_paspls2', '$clientdate', '0', '', 'kompulsa', '$username'");
                        $sponsoreup = $this->dataku("sponsor", $upli);
                        $sponsor1 = $this->dataku("sponsor", $sponsoreup);
                        $sponsor2 = $this->dataku("sponsor", $sponsor1);
                        $sponsor3 = $this->dataku("sponsor", $sponsor2);
                        $sponsor4 = $this->dataku("sponsor", $sponsor3);
                        $sponsor5 = $this->dataku("sponsor", $sponsor4);
                        $sponsor6 = $this->dataku("sponsor", $sponsor5);
                        $sponsor7 = $this->dataku("sponsor", $sponsor6);
                        $sponsor8 = $this->dataku("sponsor", $sponsor7);
                        $sponsor9 = $this->dataku("sponsor", $sponsor8);
                        $sponsor10 = $this->dataku("sponsor", $sponsor9);
                        $this->insert("komisi", "", "'', '$sponsoreup', '$k_gen[0]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor1', '$k_gen[1]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor2', '$k_gen[2]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor3', '$k_gen[3]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor4', '$k_gen[4]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor5', '$k_gen[5]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor6', '$k_gen[6]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor7', '$k_gen[7]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor8', '$k_gen[8]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi", "", "'', '$sponsor9', '$k_gen[9]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                    } else {
                        if ($ada_fo == $fo2) {
                            $prestasi = $this->config("prestasi");
                            $aku = (int)$prestasi;
                            $this->insert("prestasi", "", "'', '$usp[0]', '$aku', '$clientdate'");
                        }
                    }
                }
                $jdl = $this->jumlahdl($upli, "1");
                $this->update("upline", "dl='$jdl'", "username='$upli'");
            }
            $tkt = $this->config("kedalaman");
            $kolev = $this->config("komlev");
            for ($i = 0;$i < $level;$i++) {
                $j = $i + 1;
                $komlev = explode("|", $kolev);
                $upli = $this->dataupline("upline$i", $username);
                if ($upli) {
                    $this->insert("komisi", "", "'', '$upli', '$komlev[$i]', '$clientdate', '0', '', 'komlev$j', '$username'");
                }
            }
        }
        $sponstok = $this->dataku("sponsor", $sponsore);
        $kos = explode("|", $this->config("royalti_stockist"));
        if ($sponstok) {
            $this->insert("stockist_komisi", "", "'', '$sponstok', '$kos[0]', '$clientdate', '$sponsore', 0");
        }
    }
    function aktivasi2($username) {
        $clientdate = (date("Y-m-d H:i:s"));
        $tgl_skr = (date("Y-m-d"));
        $dtfrom = "$tgl_skr 00:00:00";
        $dtto = "$tgl_skr 23:59:59";
        $jam = date("H:i:s");
        $sponsore = $this->dataku2("sponsor", $username);
        $this->insert("topsponsor2", "", "'', '$sponsore', '$clientdate', 0");
        $this->update("member2", "status=1, tglaktif='$clientdate'", "username='$username'");
        $this->select("username", "komisi2", "dari='$username'");
        if ($this->num_rows() == 0) {
            $k_spon = $this->config2("komisi_sponsor");
            $k_gen = explode("|", $this->config2("komgenerasi"));
            if ($sponsore) {
                $this->insert("komisi2", "", "'', '$sponsore', '$k_spon', '$clientdate', '0', '', 'komsponsor', '$username'");
                $jsp = $this->jumlahsp2($sponsore);
                $this->update("upline2", "sp='$jsp'", "username='$sponsore'");
                $this->update("topsponsor2", "sp='$jsp'", "username='$sponsore'");
            }
            $level = $this->dataupline2("level", $username);
            $k_pas = $this->config2("kompasangan");
            $k_paspls = $this->config2("kompulsa");
            $fo = $this->config2("flushout");
            for ($i = 0;$i < $level;$i++) {
                $upli = $this->dataupline2("upline$i", $username);
                $matchnow = $this->match2($upli);
                $uql = mysql_query("select username from komisi2 where jenis='kompasangan' and username='$upli'");
                $match2 = mysql_num_rows($uql);
                $usp = explode("-", $upli);
                $sql_fo = mysql_query("select username from komisi2 where jenis='kompasangan' and username='$usp[0]' and (tglbayar between '$dtfrom' and '$dtto')");
                $ada_fo = mysql_num_rows($sql_fo);
                if ($matchnow == $match2 + 1) {
                    if ($ada_fo < $fo) {
                        $this->insert("komisi2", "", "'', '$upli', '$k_pas', '$clientdate', '0', '', 'kompasangan', '$username'");
                        $this->insert("komisi2", "", "'', '$upli', '$k_paspls', '$clientdate', '0', '', 'kompulsa', '$username'");
                        $sponsoreup = $this->dataku2("sponsor", $upli);
                        $sponsor1 = $this->dataku2("sponsor", $sponsoreup);
                        $sponsor2 = $this->dataku2("sponsor", $sponsor1);
                        $sponsor3 = $this->dataku2("sponsor", $sponsor2);
                        $sponsor4 = $this->dataku2("sponsor", $sponsor3);
                        $sponsor5 = $this->dataku2("sponsor", $sponsor4);
                        $sponsor6 = $this->dataku2("sponsor", $sponsor5);
                        $sponsor7 = $this->dataku2("sponsor", $sponsor6);
                        $sponsor8 = $this->dataku2("sponsor", $sponsor7);
                        $sponsor9 = $this->dataku2("sponsor", $sponsor8);
                        $sponsor10 = $this->dataku2("sponsor", $sponsor9);
                        $this->insert("komisi2", "", "'', '$sponsoreup', '$k_gen[0]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor1', '$k_gen[1]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor2', '$k_gen[2]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor3', '$k_gen[3]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor4', '$k_gen[4]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor5', '$k_gen[5]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor6', '$k_gen[6]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor7', '$k_gen[7]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor8', '$k_gen[8]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                        $this->insert("komisi2", "", "'', '$sponsor9', '$k_gen[9]', '$clientdate', '0', '', 'komgenerasi', '$username'");
                    } else {
                        $tomorrow = date("Y-m-d H:i:s", mktime(01, 0, 0, date("m"), date("d") + 1, date("Y")));
                        $this->insert("komisi2", "", "'', '$usp[0]', '$k_pas', '$tomorrow', '0', '', 'kompasangan', '$username'");
                        $this->insert("komisi2", "", "'', '$usp[0]', '$k_paspls', '$tomorrow', '0', '', 'kompulsa', '$username'");
                    }
                }
                $jdl = $this->jumlahdl2($upli, "1");
                $this->update("upline2", "dl='$jdl'", "username='$upli'");
            }
            $tkt = $this->config2("kedalaman");
            $kolev = $this->config2("komlev");
            for ($i = 0;$i < $level;$i++) {
                $j = $i + 1;
                $komlev = explode("|", $kolev);
                $upli = $this->dataupline2("upline$i", $username);
                if ($upli) {
                    $this->insert("komisi2", "", "'', '$upli', '$komlev[$i]', '$clientdate', '0', '', 'komlev$j', '$username'");
                }
            }
        }
        $sponstok = $this->dataku2("sponsor", $sponsore);
        $kos = explode("|", $this->config2("royalti_stockist"));
        if ($sponstok) {
            $this->insert("stockist_komisi", "", "'', '$sponstok', '$kos[0]', '$clientdate', '$sponsore', 0");
        }
    }
    function bonuspasangan($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='kompasangan' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function bonuspasangan2($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi2 where jenis='kompasangan' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function bonuscrosline($username, $dtgl) {
        $bm = 0;
        $cr = explode("|", $this->config("crosline"));
        $cros = $cr[0] / 100;
        $sy = $cr[1];
        $sql = mysql_query("select posisi, upline0 from upline where username='$username'");
        $row = mysql_fetch_row($sql);
        $posisi = $row[0];
        $upline0 = $row[1];
        if ($posisi == "KIRI") {
            $sql_pos = mysql_query("select kanan from upline where username='$upline0'");
        } else {
            $sql_pos = mysql_query("select kiri from upline where username='$upline0'");
        }
        if (mysql_num_rows($sql_pos) > 0) {
            $pas = mysql_fetch_row($sql_pos);
            $bm = $cros * $this->bonuspasangan($pas[0], $dtgl);
        }
        $ceksp = mysql_query("select * from member where sponsor='$username' and status=1");
        $adasp = mysql_num_rows($ceksp);
        if ($adasp >= $sy) {
            $bm = $bm;
        } else {
            $bm = 0;
        }
        return $bm;
    }
    function bonuscrosline2($username, $dtgl) {
        $bm = 0;
        $cr = explode("|", $this->config2("crosline"));
        $cros = $cr[0] / 100;
        $sy = $cr[1];
        $sql = mysql_query("select posisi, upline0 from upline2 where username='$username'");
        $row = mysql_fetch_row($sql);
        $posisi = $row[0];
        $upline0 = $row[1];
        if ($posisi == "KIRI") {
            $sql_pos = mysql_query("select kanan from upline2 where username='$upline0'");
        } else {
            $sql_pos = mysql_query("select kiri from upline2 where username='$upline0'");
        }
        if (mysql_num_rows($sql_pos) > 0) {
            $pas = mysql_fetch_row($sql_pos);
            $bm = $cros * $this->bonuspasangan2($pas[0], $dtgl);
        }
        $ceksp = mysql_query("select * from member2 where sponsor='$username' and status=1");
        $adasp = mysql_num_rows($ceksp);
        if ($adasp >= $sy) {
            $bm = $bm;
        } else {
            $bm = 0;
        }
        return $bm;
    }
    function bonusgenerasi($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='komgenerasi' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function bonusgenerasi2($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi2 where jenis='komgenerasi' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function bonusprestasi($username) {
        $bp = 0;
        $sqlpas = mysql_query("select point from prestasi where username='$username'");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function bonusprestasi2($username) {
        $bp = 0;
        $sqlpas = mysql_query("select point from prestasi where username='$username'");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function matchingupline2($username, $dtgl) {
        $m = 0;
        $sql = mysql_query("select username from upline2 where upline0='$username'");
        while ($row = mysql_fetch_row($sql)) {
            $bp = $bp + $this->bonuspasangan2($row[0], $dtgl);
        }
        $mu = explode("|", $this->config2("matchingupline"));
        if ($bp > 0) {
            $mu1 = $mu[0] * $bp;
        }
        $sql2 = mysql_query("select username from upline2 where upline2='$username'");
        while ($row2 = mysql_fetch_row($sql2)) {
            $bp2 = $bp2 + $this->bonuspasangan2($row2[0], $dtgl);
        }
        if ($bp2 > 0) $mu2 = $mu[1] * $bp2;
        $sql3 = mysql_query("select username from upline2 where upline6='$username'");
        while ($row3 = mysql_fetch_row($sql3)) {
            $bp3 = $bp3 + $this->bonuspasangan2($row3[0], $dtgl);
        }
        if ($bp3 > 0) $mu3 = $mu[2] * $bp3;
        $totmu = $mu1 + $mu2 + $mu3;
        $ceksp = mysql_query("select * from member2 where sponsor='$username' and status=1");
        $adasp = mysql_num_rows($ceksp);
        if ($adasp >= $mu[3]) {
            $m = $totmu;
        } else {
            $m = 0;
        }
        return $m;
    }
    function matchingupline($username, $dtgl) {
        $m = 0;
        $sql = mysql_query("select username from upline where upline0='$username'");
        while ($row = mysql_fetch_row($sql)) {
            $bp = $bp + $this->bonuspasangan($row[0], $dtgl);
        }
        $mu = explode("|", $this->config("matchingupline"));
        if ($bp > 0) {
            $mu1 = $mu[0] * $bp;
        }
        $sql2 = mysql_query("select username from upline where upline2='$username'");
        while ($row2 = mysql_fetch_row($sql2)) {
            $bp2 = $bp2 + $this->bonuspasangan($row2[0], $dtgl);
        }
        if ($bp2 > 0) $mu2 = $mu[1] * $bp2;
        $sql3 = mysql_query("select username from upline where upline6='$username'");
        while ($row3 = mysql_fetch_row($sql3)) {
            $bp3 = $bp3 + $this->bonuspasangan($row3[0], $dtgl);
        }
        if ($bp3 > 0) $mu3 = $mu[2] * $bp3;
        $totmu = $mu1 + $mu2 + $mu3;
        $ceksp = mysql_query("select * from member where sponsor='$username' and status=1");
        $adasp = mysql_num_rows($ceksp);
        if ($adasp >= $mu[3]) {
            $m = $totmu;
        } else {
            $m = 0;
        }
        return $m;
    }
    function komisishare($username, $rank, $dtgl) {
        $s = 0;
        $rep = str_replace("tglbayar", "tglaktif", $dtgl);
        $repe = str_replace("tglbayar", "a.tglaktif", $dtgl);
        $share = explode("|", $this->config("komisishare"));
        $sqtot = mysql_query("select * from member where status=1 $rep");
        $totmbr = mysql_num_rows($sqtot);
        $ceksp = mysql_query("select a.username, b.sp from member as a inner join upline as b on a.username=b.username where a.sponsor='$username' and b.sp>0 $repe");
        $ada = mysql_num_rows($ceksp);
        if ($ada >= $share[0]) {
            $ks1 = $share[1];
            $r1 = ($totmbr * $ks1) / $ada;
            while ($row = mysql_fetch_row($ceksp)) {
                $ceksp2 = mysql_query("select username from member where sponsor='$row[0]' $rep");
                $ada2 = $ada2 + mysql_num_rows($ceksp2);
            }
            if ($ada2 >= $share[2]) $ks2 = 0;
        } else {
            $r1 = 0;
            $ks2 = 0;
        }
        if (!$rank) {
            $s = $r1 + $ks2;
        } else if ($rank == $share[4]) {
            $s = $r1;
        } else if ($rank == $share[5]) {
            $s = $ks2;
        } else {
            $s = 0;
        }
        $ceksql = mysql_query("select * from komisi where jenis='share' and username='$username' $dtgl");
        $adashare = mysql_num_rows($ceksql);
        if ($adashare == 0 and $s > 0) {
            $this->insert("komisi", "", "'', '$username', '0', '$tomorrow', '0', '', 'share', ''");
        }
        $b = date("m");
        $tglskr = date("Y-m-d");
        $tgshare = "2009-$b-$share[6]";
        if ($tglskr >= $tgshare) {
            $s = $s;
        } else {
            $s = 0;
        }
        $ceksql2 = mysql_query("select * from komisi where jenis='share' and username='$username'");
        $adashare2 = mysql_num_rows($ceksql2);
        if ($adashare2 > 12) {
            $sh = 0;
        } else {
            $sh = $s;
        }
        return $sh;
    }
    function komisishare2($username, $rank, $dtgl) {
        $s = 0;
        $rep = str_replace("tglbayar", "tglaktif", $dtgl);
        $repe = str_replace("tglbayar", "a.tglaktif", $dtgl);
        $share = explode("|", $this->config2("komisishare"));
        $sqtot = mysql_query("select * from member2 where status=1 $rep");
        $totmbr = mysql_num_rows($sqtot);
        $ceksp = mysql_query("select a.username, b.sp from member2 as a inner join upline2 as b on a.username=b.username where a.sponsor='$username' and b.sp>0 $repe");
        $ada = mysql_num_rows($ceksp);
        if ($ada >= $share[0]) {
            $ks1 = $share[1];
            $r1 = ($totmbr * $ks1) / $ada;
            while ($row = mysql_fetch_row($ceksp)) {
                $ceksp2 = mysql_query("select username from member2 where sponsor='$row[0]' $rep");
                $ada2 = $ada2 + mysql_num_rows($ceksp2);
            }
            if ($ada2 >= $share[2]) $ks2 = 0;
        } else {
            $r1 = 0;
            $ks2 = 0;
        }
        if (!$rank) {
            $s = $r1 + $ks2;
        } else if ($rank == $share[4]) {
            $s = $r1;
        } else if ($rank == $share[5]) {
            $s = $ks2;
        } else {
            $s = 0;
        }
        $ceksql = mysql_query("select * from komisi2 where jenis='share' and username='$username' $dtgl");
        $adashare = mysql_num_rows($ceksql);
        if ($adashare == 0 and $s > 0) {
            $this->insert("komisi2", "", "'', '$username', '0', '$tomorrow', '0', '', 'share', ''");
        }
        $b = date("m");
        $tglskr = date("Y-m-d");
        $tgshare = "2009-$b-$share[6]";
        if ($tglskr >= $tgshare) {
            $s = $s;
        } else {
            $s = 0;
        }
        $ceksql2 = mysql_query("select * from komisi2 where jenis='share' and username='$username'");
        $adashare2 = mysql_num_rows($ceksql2);
        if ($adashare2 > 12) {
            $sh = 0;
        } else {
            $sh = $s;
        }
        return $sh;
    }
    function insertkomjual($username, $harga) {
        $clientdate = (date("Y-m-d H:i:s"));
        $tkt = $this->config("kedalaman");
        $level = $this->dataupline("level", $username);
        $kdlm = explode("|", $tkt);
        $kd = $kdlm[1];
        $kolev = $this->config("komjual");
        for ($i = 0;$i < $level;$i++) {
            if ($level <= 10) {
                $j = $i + 1;
                $komlev = explode("|", $kolev);
                $upli = $this->dataupline("upline$i", $username);
                $tj = ($komlev[$i] * $harga) / 100;
                if ($upli) {
                    $this->insert("komisi", "", "'', '$upli', '$tj', '$clientdate', '0', '', 'komjual$j', '$username'");
                }
            }
        }
    }
    function insertkomjual2($username, $harga) {
        $clientdate = (date("Y-m-d H:i:s"));
        $tkt = $this->config2("kedalaman");
        $level = $this->dataupline2("level", $username);
        $kdlm = explode("|", $tkt);
        $kd = $kdlm[1];
        $kolev = $this->config2("komjual");
        for ($i = 0;$i < $level;$i++) {
            if ($level <= 10) {
                $j = $i + 1;
                $komlev = explode("|", $kolev);
                $upli = $this->dataupline2("upline$i", $username);
                $tj = ($komlev[$i] * $harga) / 100;
                if ($upli) {
                    $this->insert("komisi2", "", "'', '$upli', '$tj', '$clientdate', '0', '', 'komjual$j', '$username'");
                }
            }
        }
    }
    function totalbonuspasangan($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='kompasangan' and username like '%$username%' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function totalbonuspasanganpulsa($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='kompulsa' and username like '%$username%' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function BonusSponsor($username, $jenis, $dtgl) {
        $b = 0;
        if ($username) {
            $sql = mysql_query("select bayar from komisi where username like '%$username%' and jenis='$jenis' $dtgl");
            while ($row = mysql_fetch_row($sql)) {
                $b = $b + $row[0];
            }
        }
        return $b;
    }
    function BonusLevel($username, $dtgl) {
        $b = 0;
        $sql = mysql_query("select bayar from komisi where username like '%$username%' and jenis like '%komlev%' $dtgl");
        while ($row = mysql_fetch_row($sql)) {
            $b = $b + $row[0];
        }
        return $b;
    }
    function bonuscroslinepaket($username, $dtgl) {
        $bc = 0;
        $sql = mysql_query("select paket from upline where username='$username'");
        $row = mysql_fetch_row($sql);
        $paket = $row[0];
        for ($i = 0;$i < $paket;$i++) {
            if ($i == 0) {
                $user = $username;
            } else {
                $user = $username . "-0$i";
            }
            $bc = $bc + $this->bonuscrosline($user, $dtgl);
        }
        return $bc;
    }
    function tanggalan($dtgl) {
        $h = "";
        $hari = array("Minggu", "Senin", "Selasa", "Rabu", "Kamis", "Jumat", "Sabtu");
        $bulan = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");
        $w = date("w", strtotime($dtgl));
        $b = date("m", strtotime($dtgl));
        $t = date("d", strtotime($dtgl));
        $h = $hari[$w] . ", $t " . $bulan[$b - 1] . " " . date("Y", strtotime($dtgl));
        return $h;
    }
    function NetGrowth($username, $jenis, $dtgl) {
        $n = 0;
        if ($jenis == "komlev") {
            $sql = mysql_query("select * from komisi where jenis like '%komlev%' and username='$username' $dtgl");
            $n = mysql_num_rows($sql);
        } else if ($jenis == "fo") {
            $sqle = mysql_query("select * from komisi where jenis='kompasangan' and username='$username' $dtgl");
            $fo = $this->config("flushout");
            $afo = mysql_num_rows($sqle);
            if ($afo > $fo) $n = 1;
        } else {
            $sql = mysql_query("select * from komisi where jenis='$jenis' and username='$username' $dtgl");
            $n = mysql_num_rows($sql);
        }
        return $n;
    }
    function BonusPenjualan($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='komjual' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function bonuspasanganpulsa($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='kompulsa' and username like '%$username%' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function totalkomisicash($username, $dtgl) {
        $kom = 0;
        $kom = $this->totalkomisi($username, $dtgl) - $this->totalkomisipulsa($username, $dtgl);
        return $kom;
    }
    function totalkomisi($username, $dtgl) {
        $kom = "";
        $sql = mysql_query("select paket from upline where username='$username'");
        $row = mysql_fetch_row($sql);
        $paket = $row[0];
        if ($paket > 1) {
            $cros = $this->bonuscroslinepaket($username, $dtgl);
        } else {
            $cros = $this->bonuscrosline($username, $dtgl);
        }
        $skom = "SELECT bayar FROM komisi WHERE username like '%$username%' and status=0 $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
        } else {
            $komi = 0;
        }
        $kom = $komi + $cros + $this->royaltistockist($username, $dtgl) + $this->komisistockist($username, $dtgl) + $this->komisishare($username, $rank, $dtgl) + $this->matchingupline($username, $dtgl) + $this->komisiro($mid, "", $dtgl) + $this->rewardleader($mid, "", $dtgl);
        return $kom;
    }
    function ditransfer($jenis, $kode) {
        $d = 0;
        $sql = mysql_query("select $jenis, userid, tglbayar, indek, pph from transfer where kode='$kode'");
        $row = mysql_fetch_row($sql);
        $index = $row[4];
        $totcash0 = $row[0] - ($row[0] * $row[3]);
        $totcash = $totcash0 - ($totcash0 * $index / 100);
        if ($jenis == "pulsa") {
            $autocash = $this->AutoCash($row[1], "pulsa", "and tglbayar='" . date("Y-m-d", strtotime($row[2])) . "'");
        } else {
            $autocash = $this->AutoCash($row[1], "cash", "and tglbayar='" . date("Y-m-d", strtotime($row[2])) . "'");
        }
        $d = $totcash - $autocash;
        return $d;
    }
    function TarikTransfer($jenis, $kode) {
        $t = 0;
        if ($jenis == "pulsa") {
            $sql = mysql_query("select rp from transfer where kode='$kode' and tujuan='HP Member'");
        } else {
            $sql = mysql_query("select rp from transfer where kode='$kode' and tujuan<>'HP Member'");
        }
        $row = mysql_fetch_row($sql);
        $t = $row[0];
        return $t;
    }
    function TotalTransfer($username, $jenis, $dtgl) {
        $d = 0;
        $sql = mysql_query("select kode from transfer where userid='$username' and status=1 $dtgl");
        while ($row = mysql_fetch_row($sql)) {
            $d = $d + $this->ditransfer($jenis, $row[0]);
        }
        return $d;
    }
    function bonusroi($username, $dtgl) {
        $b = 0;
        $spk = mysql_query("select a.paket, b.tgl from upline as a inner join member as b on a.username=b.username where a.username='$username'");
        $row = mysql_fetch_row($spk);
        $pk = $row[0];
        $tgjoin = $row[1];
        if ($tgjoin) {
            $newsplit = explode("-", $dtgl);
            $newsplit2 = explode("-", $tgjoin);
            $jd = date("m", mktime(00, 00, 00, $newsplit[1] - $newsplit2[1], $newsplit[2], $newsplit[0]));
            $j = $jd * 1;
            $roi = explode("|", $this->config("roi"));
            $td = date("Y-m-d", mktime(00, 00, 00, $newsplit2[1], $newsplit2[2] + 30, $newsplit2[0]));
            if (date("Y-m-d", strtotime($dtgl)) >= $td) {
                $b = $roi[$j] * $pk;
            } else {
                $b = 0;
            }
        }
        return $b;
    }
    function rewardleader($username, $dtgl) {
        $bp = 0;
        $sqlpas = mysql_query("select bayar from komisi where jenis='rewardleader' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sqlpas)) {
            $bp = $bp + $row[0];
        }
        return $bp;
    }
    function totalkomisi2($username, $dtgl) {
        $kom = "";
        $cros = $this->bonuscrosline2($username, $dtgl);
        $skom = "SELECT bayar FROM komisi2 WHERE username='$username' and status=0 $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $kom = $komi + $cros + $this->royaltistockist2($username, $dtgl) + $this->komisistockist2($username, $dtgl) + $this->komisishare2($username, $rank, $dtgl) + $this->matchingupline2($username, $dtgl);
        } else {
            $kom = 0 + $cros + $this->royaltistockist2($username, $dtgl) + $this->komisistockist2($username, $dtgl) + $this->komisishare2($username, $rank, $dtgl) + $this->matchingupline2($username, $dtgl);
        }
        return $kom;
    }
    function totalkomisipulsax($username, $dtgl) {
        $kom = "";
        $skom = "SELECT * FROM komisi WHERE username like '%$username%' AND jenis='kompulsa' $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[2];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function TransferKomisi($username, $jenis, $dtgl) {
        $kom = 0;
        $skom = "SELECT $jenis FROM transfer WHERE userid='$username' $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function AutoCash($username, $jenis, $dtgl) {
        $a = 0;
        $sql = mysql_query("select $jenis from autocash where username='$username' $dtgl");
        while ($row = mysql_fetch_row($sql)) {
            $a = $a + $row[0];
        }
        return $a;
    }
    function totalkomisipulsa($username, $dtgl) {
        $kom = "";
        $skom = "SELECT * FROM komisi WHERE username like '%$username%' AND jenis='kompulsa' $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[2];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function totalkomisipulsa2($username, $dtgl) {
        $kom = "";
        $skom = "SELECT * FROM komisi2 WHERE username='$username' AND jenis='kompulsa' $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[2];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function totalkomisipulsapaket2($username, $dtgl) {
        $kom = "";
        $spk = mysql_query("select paket from upline2 where username='$username'");
        $row = mysql_fetch_row($spk);
        $pk = $row[0];
        $tkm = 0;
        for ($i = 0;$i < $pk;$i++) {
            if ($i == 0) {
                $user = $username;
            } else {
                $user = "$username-0$i";
            }
            $skom = "SELECT * FROM komisi2 WHERE username='$user' AND jenis='kompulsa' $dtgl";
            $dkom = mysql_query($skom);
            $ada = mysql_num_rows($dkom);
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[2];
            }
            $tkm = $tkm + $komi;
        }
        $kom = $tkm;
        return $kom;
    }
    function totalkomisipulsapaket($username, $dtgl) {
        $kom = "";
        $spk = mysql_query("select paket from upline where username='$username'");
        $row = mysql_fetch_row($spk);
        $pk = $row[0];
        $tkm = 0;
        for ($i = 0;$i < $pk;$i++) {
            if ($i == 0) {
                $user = $username;
            } else {
                $user = "$username-0$i";
            }
            $skom = "SELECT * FROM komisi WHERE username='$user' AND jenis='kompulsa' $dtgl";
            $dkom = mysql_query($skom);
            $ada = mysql_num_rows($dkom);
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[2];
            }
            $tkm = $tkm + $komi;
        }
        $kom = $tkm;
        return $kom;
    }
    function komisiro($username, $dtgl) {
        $ks = 0;
        $sql = mysql_query("select bayar from komisi where jenis='komjual' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sql)) {
            $ks = $ks + $row[0];
        }
        return $ks;
    }
    function komisiro2($username, $dtgl) {
        $ks = 0;
        $sql = mysql_query("select bayar from komisi2 where jenis='komjual' and username='$username' $dtgl");
        while ($row = mysql_fetch_row($sql)) {
            $ks = $ks + $row[0];
        }
        return $ks;
    }
    function komisistockist($username, $dtgl) {
        $ks = 0;
        $rep = str_replace("tglbayar", "tgl_aktivasi", $dtgl);
        $sql = mysql_query("select * from card where status=1 and dealer='$username' $rep");
        $ada = mysql_num_rows($sql);
        $kos = explode("|", $this->config("stockist"));
        $ks = $ada * $kos[0];
        return $ks;
    }
    function komisistockist2($username, $dtgl) {
        $ks = 0;
        $rep = str_replace("tglbayar", "tgl_aktivasi", $dtgl);
        $sql = mysql_query("select * from card where status=1 and dealer='$username' $rep");
        $ada = mysql_num_rows($sql);
        $kos = explode("|", $this->config2("stockist"));
        $ks = $ada * $kos[0];
        return $ks;
    }
    function royaltistockist($username, $dtgl) {
        $ks = 0;
        $sqls = mysql_query("select jumlah from stockist_komisi where username='$username' $dtgl");
        while ($rows = mysql_fetch_row($sqls)) {
            $r = $r + $rows[0];
        }
        $rep = str_replace("tglbayar", "a.tglbayar", $dtgl);
        $sql = mysql_query("select a.`jumlah`, b.username from `stockist_order` as a inner join member as b on a.stockistid=b.username where b.sponsor='$username'");
        while ($row = mysql_fetch_row($sql)) {
            if ($row[0] < 0) {
                $ks0 = $ks0 + ($row[0] * -1);
            }
        }
        $sql0 = mysql_query("select jumlah from `stockist_order` where stockistid='$username' $dtgl");
        while ($row0 = mysql_fetch_row($sql0)) {
            if ($row0[0] < 0) {
                $ksu = $ksu + ($row0[0] * -1);
            }
        }
        $ro = explode("|", $this->config("royalti_stockist"));
        $ks = ($ks0 * $ro[1]) + ($ksu * $ro[0]) + $r;
        return $ks;
    }
    function royaltistockist2($username, $dtgl) {
        $ks = 0;
        $sqls = mysql_query("select jumlah from stockist_komisi where username='$username' $dtgl");
        while ($rows = mysql_fetch_row($sqls)) {
            $r = $r + $rows[0];
        }
        $rep = str_replace("tglbayar", "a.tglbayar", $dtgl);
        $sql = mysql_query("select a.`jumlah`, b.username from `stockist_order` as a inner join member2 as b on a.stockistid=b.username where b.sponsor='$username'");
        while ($row = mysql_fetch_row($sql)) {
            if ($row[0] < 0) {
                $ks0 = $ks0 + ($row[0] * -1);
            }
        }
        $sql0 = mysql_query("select jumlah from `stockist_order` where stockistid='$username' $dtgl");
        while ($row0 = mysql_fetch_row($sql0)) {
            if ($row0[0] < 0) {
                $ksu = $ksu + ($row0[0] * -1);
            }
        }
        $ro = explode("|", $this->config2("royalti_stockist"));
        $ks = ($ks0 * $ro[1]) + ($ksu * $ro[0]) + $r;
        return $ks;
    }
    function bayarkomisi($username, $dtgl) {
        $kom = "";
        $skom = "SELECT rp FROM transfer WHERE userid='$username' AND status=1 $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function bayarkomisi2($username, $dtgl) {
        $kom = "";
        $skom = "SELECT rp FROM transfer2 WHERE userid='$username' AND status=1 $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function bayarkomisipulsa($username, $dtgl) {
        $kom = "";
        $skom = "SELECT rp FROM transfer WHERE userid='$username' AND tujuan='HP Member'  AND status=1 $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function bayarkomisipulsa2($username, $dtgl) {
        $kom = "";
        $skom = "SELECT rp FROM transfer2 WHERE userid='$username' AND tujuan='HP Member'  AND status=1 $dtgl";
        $dkom = mysql_query($skom);
        $ada = mysql_num_rows($dkom);
        if ($ada > 0) {
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $kom = $komi;
        } else {
            $kom = 0;
        }
        return $kom;
    }
    function jmlmember($username, $field) {
        $jm = 0;
        $this->select("a.username, a.status, a.blokir, b.sponsor", "member as a inner join upline as b on a.username=b.username", $field);
        $jm = $this->num_rows();
        return $jm;
    }
    function jmlmember2($username, $field) {
        $jm = 0;
        $this->select("a.username, a.status, a.blokir, b.sponsor", "member2 as a inner join upline2 as b on a.username=b.username", $field);
        $jm = $this->num_rows();
        return $jm;
    }
    function myewalet($username) {
        $te = 0;
        $te = $this->myewaletdone($username);
        return $te;
    }
    function myewaletpending($username) {
        $te = 0;
        $sql = mysql_query("select username, jumlah, tujuan from dataewalet where tujuan='$username' and status=0");
        $a = mysql_num_rows($sql);
        $ted = 0;
        while ($row = mysql_fetch_row($sql)) {
            $ted = $ted + $row[1];
        }
        $sqla = mysql_query("select username, jumlah, tujuan from dataewalet where username='$username' and status=0");
        $tek = 0;
        while ($rowa = mysql_fetch_row($sqla)) {
            $tek = $tek + $rowa[1];
        }
        $te = $ted + $tek;
        return $te;
    }
    function myewaletdone($username) {
        $te = 0;
        $sql = mysql_query("select username, jumlah, tujuan from dataewalet where tujuan='$username' and status=1");
        $a = mysql_num_rows($sql);
        $ted = 0;
        while ($row = mysql_fetch_row($sql)) {
            $ted = $ted + $row[1];
        }
        $sqla = mysql_query("select username, jumlah, tujuan from dataewalet where username='$username' and status=1");
        $tek = 0;
        while ($rowa = mysql_fetch_row($sqla)) {
            $tek = $tek + $rowa[1];
        }
        $te = $ted - $tek;
        return $te;
    }
    function saldoadmin($dtgl) {
        $this->select("jumlah, status", "transaksi", $dtgl);
        $sa = 0;
        while ($row = $this->fetch_row()) {
            if ($row[1] > 0) {
                $ja = $row[0];
            } else {
                $ja = - ($row[0]);
            }
            $sa = $sa + $ja;
        }
        return $sa;
    }
    function saldoadmin2($dtgl) {
        $this->select("jumlah, status", "transaksi2", $dtgl);
        $sa = 0;
        while ($row = $this->fetch_row()) {
            if ($row[1] > 0) {
                $ja = $row[0];
            } else {
                $ja = - ($row[0]);
            }
            $sa = $sa + $ja;
        }
        return $sa;
    }
    function banner() {
        $this->select("id, nama, banner, url", "banner", "published=1", "ordering");
        while ($row = $this->fetch_row()) {
            echo "<a href='http://$row[3]' target='_blank'><img src='images/banner/$row[2]' title='$row[1]' border=0 /></a><br><br>";
        }
    }
    function bannerrek() {
        $this->select("id, nama, banner, url", "banner_rek", "published=1", "ordering");
        while ($row = $this->fetch_row()) {
            echo "<a href='http://$row[1]' target='_blank'><img src='images/banner/$row[2]' title='$row[1]' border=0 /></a>

                <br>

                $row[3]

                <br><br>";
        }
    }
    function bannerkiri() {
        $this->select("id, nama, banner, url", "banner_kiri", "published=1", "ordering");
        while ($row = $this->fetch_row()) {
            echo "<a href='http://$row[3]' target='_blank'><img src='images/banner/$row[2]' title='$row[1]' border=0 /></a>

                <br><br>";
        }
    }
    function bannerbawah() {
        $this->select("id, nama, banner, url", "banner_bawah", "published=1", "ordering");
        while ($row = $this->fetch_row()) {
            echo "<a href='http://$row[3]' target='_blank'><img src='images/banner/$row[2]' title='$row[1]' border=0 /></a>&nbsp";
        }
    }
    function banneratas() {
        $this->select("id, nama, banner, url", "banner_atas", "published=1", "ordering");
        while ($row = $this->fetch_row()) {
            echo "<a href=http://$row[3] target=''><img src='images/banner/$row[2]' title='$row[1]' border=0 /></a>";
        }
    }
    function bannerkanan() {
        $this->select("id, nama, banner, url", "banner_kanan", "published=1", "ordering");
        while ($row = $this->fetch_row()) {
            echo "<a href='http://$row[3]' target='_blank'><img src='images/banner/$row[2]' width='465' title='$row[1]' border=0 /></a>
                <br><br>";
        }
    }
    function komisipaket($username, $dtgl) {
        $kom = 0;
        $spk = mysql_query("select paket from upline where username='$username'");
        $row = mysql_fetch_row($spk);
        $pk = $row[0];
        $tkm = 0;
        for ($i = 0;$i < $pk;$i++) {
            if ($i == 0) {
                $user = $username;
            } else {
                $user = "$username-0$i";
            }
            $cros = $cros + $this->bonuscrosline($user, $dtgl);
            $skom = "SELECT bayar FROM komisi WHERE username='$user' and status=0 $dtgl";
            $dkom = mysql_query($skom);
            $ada = mysql_num_rows($dkom);
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $tkm = $tkm + $komi;
        }
        $kom = $tkm + $cros + $this->royaltistockist($username, $dtgl) + $this->komisistockist($username, $dtgl) + $this->komisishare($username, $rank, $dtgl) + $this->matchingupline($username, $dtgl);
        return $kom;
    }
    function komisipaket2($username, $dtgl) {
        $kom = 0;
        $spk = mysql_query("select paket from upline2 where username='$username'");
        $row = mysql_fetch_row($spk);
        $pk = $row[0];
        $tkm = 0;
        for ($i = 0;$i < $pk;$i++) {
            if ($i == 0) {
                $user = $username;
            } else {
                $user = "$username-0$i";
            }
            $cros = $cros + $this->bonuscrosline2($user, $dtgl);
            $skom = "SELECT bayar FROM komisi2 WHERE username='$user' and status=0 $dtgl";
            $dkom = mysql_query($skom);
            $ada = mysql_num_rows($dkom);
            $komi = 0;
            while ($rkom = mysql_fetch_row($dkom)) {
                $komi = $komi + $rkom[0];
            }
            $tkm = $tkm + $komi;
        }
        $kom = $tkm + $cros + $this->royaltistockist2($username, $dtgl) + $this->komisistockist2($username, $dtgl) + $this->komisishare2($username, $rank, $dtgl) + $this->matchingupline2($username, $dtgl);
        return $kom;
    }
    function ym($i, $n) {
        $ym = "";
        $ymn = explode(",", $this->config("ym"));
        $cn = count($ymn);
        echo "<a href='ymsgr:sendIM?$ymn[$i]'><img src='http://opi.yahoo.com/online?u=$ymn[$i]&m=g&t=1' border='0' title='$n'></a>";
    }
    function freemember($status) {
        $this->select("username, nama, hp, kota, rupiah", "member", "status=$status and paket=1", "tgl asc", "", "", "10");
        while ($data = $this->fetch_row()) {
            echo "<center><table cellpadding=\"0\" cellspacing=\"0\" width=\"50px\" height=\"50px\" border=\"0\" align=\"left\" bgcolor=\"#F9F9F9\"><tr><td width=\"100%\" align=\"center\"><img src=\"images/no_avatarA.gif\" width=\"50px\" height=\"50px\"></td></tr></table>$data[0]<br /> $data[1] <br />($data[3])<br /><br /><br /></center>";
        }
    }
    function newmember($status) {
        $this->select("username, nama, hp, kota, rupiah", "member", "status=$status and paket=1", "tglaktif desc", "", "", "10");
        while ($data = $this->fetch_row()) {
            echo "<center><table cellpadding=\"0\" cellspacing=\"0\" width=\"50px\" height=\"50px\" border=\"0\" align=\"left\" bgcolor=\"#F9F9F9\"><tr><td width=\"100%\" align=\"center\"><img src=\"images/no_avatarA.gif\" width=\"50px\" height=\"50px\"></td></tr></table>$data[0]<br /> $data[1] <br />($data[3])<br /><br /><br /></center>";
        }
    }
    function newmember2($status) {
        $this->select("username, nama, hp, kota, rupiah", "member2", "status=$status and paket=1", "tglaktif desc", "", "", "10");
        while ($data = $this->fetch_row()) {
            echo "<center><table cellpadding=\"0\" cellspacing=\"0\" width=\"50px\" height=\"50px\" border=\"0\" align=\"left\" bgcolor=\"#F9F9F9\"><tr><td width=\"100%\" align=\"center\"><img src=\"images/no_avatarB.gif\" width=\"50px\" height=\"50px\"></td></tr></table>$data[0]<br /> $data[1] <br />($data[3])<br /><br /><br /></center>";
        }
    }
    function stockRO($username, $field) {
        $s = 0;
        $sql = mysql_query("select $field from stockist_order where stockistid='$username'");
        while ($row = mysql_fetch_row($sql)) {
            $s = $s + $row[0];
        }
        return $s;
    }
    function komsp($username, $dtgl) {
        $j = 0;
        $sql = mysql_query("select * from komisi where jenis='komsponsor' and username='$username' $dtgl");
        $j = mysql_num_rows($sql);
        return $j;
    }
    function komsp2($username, $dtgl) {
        $j = 0;
        $sql = mysql_query("select * from komisi2 where jenis='komsponsor' and username='$username' $dtgl");
        $j = mysql_num_rows($sql);
        return $j;
    }
    function topsponsor($dtgl, $limit) {
        $dtfrom = "$dtgl-01";
        $dtto = "$dtgl-31";
        $sql = mysql_query("select a.username, b.nama, a.sp from topsponsor as a inner join member as b on a.username=b.username where  (a.tglbayar between '$dtfrom' and '$dtto') order by a.sp desc limit $limit");
        $nom = 1;
        while ($data = mysql_fetch_row($sql)) {
            echo "$nom. $data[1] ($data[2])<br>";
            $nom++;
        }
    }
    function topsponsor2($dtgl, $limit) {
        $dtfrom = "$dtgl-01";
        $dtto = "$dtgl-31";
        $sql = mysql_query("select a.username, b.nama, a.sp from topsponsor2 as a inner join member2 as b on a.username=b.username where  (a.tglbayar between '$dtfrom' and '$dtto') order by a.sp desc limit $limit");
        $nom = 1;
        while ($data = mysql_fetch_row($sql)) {
            echo "$nom. $data[1] ($data[2])<br>";
            $nom++;
        }
    }
    function kirimsms($sender, $username, $pesan) {
        $tglskr = strtotime(date("Y-m-d H:i:s"));
        $hp = $this->dataku("hp", $username);
        $this->insert("messages", "Direction, Type, StatusDetails, Status, ChannelID, ScheduledTimeSecs, Sender, Recipient, Body", "'2', '2', '200', '1', '1001', '$tglskr', '$sender', '$hp', '$pesan'");
    }
    function hpku($nohp) {
        $hpku = "";
        $sql = mysql_query("select nama from member where hp='$nohp'");
        $row = mysql_fetch_row($sql);
        $hpku = $row[0];
        return $hpku;
    }
    function hpku2($nohp) {
        $hpku = "";
        $sql = mysql_query("select nama from member2 where hp='$nohp'");
        $row = mysql_fetch_row($sql);
        $hpku = $row[0];
        return $hpku;
    }
    function automaintain($username) {
        $au = 0;
        $sql = mysql_query("select jumlah from dataewalet where tujuan='$username' and uraian like '%Automantain%' and status=1");
        while ($row = mysql_fetch_row($sql)) {
            $au = $au + $row[0];
        }
        return $au;
    }
};
?>