Permasalahan seputar Scrip tambahan Erefill (YMRemote, AutoPilot, YMReport, AutoStart Dll)

Discussion in 'Software Pulsa ERefill' started by alatsari, Aug 7, 2010.

  1. alatsari

    alatsari Member

    Messages:
    96
    Likes Received:
    8
    Trophy Points:
    18
    Mohon Bantuan Cara setting YmRemote Erefill?
    - Cara memasukan Scrip ke SW Erefill?
    - Apa maksudnya Formay perintah YM remote (menutup parsing, membuka parsing, cek status parsing) dan cara aplikasinya bagaimana?
    - mohon bantuan para sesepuh, para master, para pengguna erefilll, nih lagi puyeng nggak bisa bisa...:cry::cry:
     
    wongmanis likes this.
  2. adwitya

    adwitya New Member

    Messages:
    166
    Likes Received:
    14
    Trophy Points:
    0
    Kenapa enggak langsung BUZZ begawan.nya Gan..? Mr.Black sama Mr. Solih. Ada juga tritnya kok...:thumb::thumb::thumb:
     
  3. arieemdee

    arieemdee Moderator Moderator

    Messages:
    258
    Likes Received:
    272
    Trophy Points:
    73
  4. alatsari

    alatsari Member

    Messages:
    96
    Likes Received:
    8
    Trophy Points:
    18
    KALO INI DAH JALAN LANCAR.....:rock::rock::rock::clap::clap::clap: (YM REMOTE....:cry::cry::cry:)


    <?php session_start();
    ?>
    <html>
    <head>
    <title>AutoPilot For Erefill2007</title>
    <meta name="generator" http-equiv="content-type" content="text/html">
     
    <meta http-equiv="refresh" content="60" >
    <style type="text/css">
    body {
    background-color: #FFFFFF;
    color: #004080;
    font-family: Arial;
    font-size: 12px;
    }
    .bd {
    background-color: #FFFFFF;
    color: #004080;
    font-family: Arial;
    font-size: 12px;
    }
    .tbl {
    background-color: #FFFFFF;
    }
    a:link {
    color: #FF0000;
    font-family: Arial;
    font-size: 12px;
    }
    a:active {
    color: #0000FF;
    font-family: Arial;
    font-size: 12px;
    }
    a:visited {
    color: #800080;
    font-family: Arial;
    font-size: 12px;
    }
    .hr {
    background-color: #336699;
    color: #FFFFFF;
    font-family: Arial;
    font-size: 12px;
    }
    a.hr:link {
    color: #FFFFFF;
    font-family: Arial;
    font-size: 12px;
    }
    a.hr:active {
    color: #FFFFFF;
    font-family: Arial;
    font-size: 12px;
    }
    a.hr:visited {
    color: #FFFFFF;
    font-family: Arial;
    font-size: 12px;
    }
    .dr {
    background-color: #FFFFFF;
    color: #000000;
    font-family: Arial;
    font-size: 12px;
    }
    .sr {
    background-color: #FFFFCF;
    color: #000000;
    font-family: Arial;
    font-size: 12px;
    }
    </style>
    </head>
    <body>
    <?php echo "<table class=\"bd\" width=\"100%\"><tr><td class=\"hr\"><h2>AutoPilot For Erefill2007</h2></td></tr></table>" ?>
    <?php
    $conn = connect();
    $datetime = date('Y-m-d H:i:s');
    $date = date('Y-m-d');
    $showrecs = 20;
    $pagerange = 5;
    $page = @$_GET["page"];
    if (isset($_GET["wholeonly"])) $wholeonly = @$_GET["wholeonly"] == "on";
    if (!isset($page)) $page = 1;
    select();
     
    mysql_close($conn);
    ?>
    <?php echo "<table class=\"bd\" width=\"100%\"><tr><td class=\"hr\">..:: Alatsari Reload - Love you full ::..</td></tr></table>" ?>
    </body>
    </html>
    <?php function select()
    {
    global $conn;
    global $showrecs;
    global $page;
    global $nextid;
    global $row;
    global $datetime;
    global $i;
    $i = 0;

    //ambil trx yang statusnya menunggu di tabel transaksi
    $res = sql_select();
    $count = sql_getrecordcount();
    if ($count % $showrecs != 0) {
    $i = i+1;
    $pagecount = intval($count / $showrecs) + 1;
    $nextid = $count;
    }
    else {
    $pagecount = intval($count / $showrecs);
    }
    $startrec = $showrecs * ($page - 1);
    if ($startrec < $count) {mysql_data_seek($res, $startrec);}
    $reccount = min($showrecs * $page, $count);
    ?>
    <table class="bd" border="0" cellspacing="1" cellpadding="4">
    <tr><td>LIST TRANSAKSI MENUNGGU</td></tr>
    <tr><td><?php echo "Records shown " . ($startrec + 1) . " - " . ($reccount) . " of " . ($count) . "" ?></td></tr>
    </table>
    <hr size="1" noshade>
    <?php showpagenav($page, $pagecount); ?>
    <br>
    <table class="tbl" border="0" cellspacing="1" cellpadding="5"width="100%">
    <tr>
    <td class="hr"><?php echo "id" ?></td>
    <td class="hr"><?php echo "kode_transaksi" ?></td>
    <td class="hr"><?php echo "datetime_sms" ?></td>
    <td class="hr"><?php echo "datetime_transaksi" ?></td>
    <td class="hr"><?php echo "kode_produk" ?></td>
    <td class="hr"><?php echo "tujuan" ?></td>
    <td class="hr"><?php echo "kode_reseller" ?></td>
    <td class="hr"><?php echo "hp_reseller" ?></td>
    <td class="hr"><?php echo "deposit_awal" ?></td>
    <td class="hr"><?php echo "deposit_akhir" ?></td>
    <td class="hr"><?php echo "harga_beli" ?></td>
    <td class="hr"><?php echo "harga_dasar" ?></td>
    <td class="hr"><?php echo "terminal" ?></td>
    <td class="hr"><?php echo "status" ?></td>
    <td class="hr"><?php echo "keterangan" ?></td>
    </tr>
    <?php
    for ($i = $startrec; $i < $reccount; $i++)
    {
    $row = mysql_fetch_assoc($res);
    $style = "dr";
    if ($i % 2 != 0) {
    $style = "sr";
    }
    ?>
    <tr>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["id"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["kode_transaksi"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["datetime_sms"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["datetime_transaksi"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["kode_produk"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["tujuan"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["kode_reseller"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["hp_reseller"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["deposit_awal"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["deposit_akhir"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["harga_beli"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["harga_dasar"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["terminal"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["status"]) ?></td>
    <td class="<?php echo $style ?>"><?php echo htmlspecialchars($row["keterangan"]) ?></td>
    </tr>
     
    <?php
    global $conn;
    global $datetime;
    global $date;
    $jmlrecord = sql_getrecordcount();
    $kodeproduk = $row["kode_produk"];
    $tujuan = $row["tujuan"];
    $trx_id = $row["kode_transaksi"];
    $terminal = $row["terminal"];
    //setting interval untuk menentukan lama waktu ulang trx
    $interval = "03:00";
    // echo "Trx akan diulang otomatis setiap :", $interval, " detik sekali. TimeStamps : ", $datetime;
     
    $start_time = $row["datetime_transaksi"];
    $end_time = $datetime;
    $waktu_tunggu_trx = calculate_time_past($start_time, $end_time, "i:s"); // will output 00:02:45 when format is overridden
     
    //jika waktu tunggu melebihi waktu interval, maka ulang trx
    if ($waktu_tunggu_trx > $interval)
    {

     
    //cek trx_id di antrian job, di tabel job_quenue
    $query = "SELECT trx_id FROM job_quenue WHERE trx_id ='$trx_id'";
    $result = mysql_query($query, $conn) or die ("<p class=err>Error - Proses select pada tabel job_quenue gagal: ".mysql_error()."</p>");
    $num_rows = mysql_num_rows($result);
    //cek di inbox apakah sudah ada jawaban trx sebelumnya, rptd by omblack
    //$query2 = "SELECT pesan FROM inbox WHERE (terminal = '$terminal' ) and ((pesan like 'Transaksi%') and (pesan like '%".$tujuan."%') and (datetime = '$date'))";
    $query2 = "SELECT pesan FROM inbox WHERE ((pesan like '%".$tujuan."%' and (pesan like '%BERHASIL%' or pesan like '%SUKSES%' or pesan like '%GAGAL%' or pesan like '%MENUNGGU%' or pesan like '%proses.%' or pesan like '%diterima%' or pesan like '%diterima,%' or pesan like '%antrian.%')) and terminal = '$no_terminal' and datetime = '$date')";
    $result2 = mysql_query($query2, $conn) or die ("<p class=err>Error - Proses select pada tabel inbox gagal: ".mysql_error()."</p>");
    $num_rows2 = mysql_num_rows($result2);
    //cek apakah data kosong?
    $datavalid = false;
    if ((!empty($row[kode_produk])) or (!empty($row[tujuan])) or (!empty($perintah2)) or (!empty($row[kode_reseller])) or (!empty($row[hp_reseller])) or (!empty($row[terminal])) or (!empty($row[kode_transaksi])))
    {
    $datavalid =true;
    }
     
    if (($num_rows) or ($num_rows2))
    {
    //jika ditemukan,
    //while ($myrow = mysql_fetch_row($result))
    // {
    // $trxid = $myrow[0];
    //jangan diulang
    // }
    }
    else if ($datavalid)
    {

     
    //Tambahan fitur option pengulangan : Ada history atau tidak ada history, rptd by pulsa_amanah
    //Blok jika tidak digunakan (//), hapus blok (//) jika akan digunakan.
     
    //OPTION KE 1 : ADA HISTORY
    // //update dulu status transaksi yang menunggu menjadi gagal (0 = GAGAL)
    // $updated = "update transaksi set status = 0, keterangan = 'Transaksi dibatalkan oleh AutoPilot, untuk diulang' where kode_transaksi = $trx_id and status = 2";
    // mysql_query($updated, $conn) or die ("<p class=err>Error - Proses update tabel transaksi gagal: ".mysql_error()."</p>");
    //OPTION KE 2 : TIDAK ADA HISTORY
    //hapus dulu transaksi yang akan diulang
    $updated = "delete from transaksi where kode_transaksi = $trx_id and status = 2";
    mysql_query($updated, $conn) or die ("<p class=err>Error - Proses delete tabel transaksi gagal: ".mysql_error()."</p>");
    //hapus dulu transaksi_ yang akan diulang -- bila menggunakan optimize data
    $updated = "delete from transaksi_ where kode_transaksi = $trx_id and status = 2";
    mysql_query($updated, $conn) or die ("<p class=err>Error - Proses delete tabel transaksi gagal: ".mysql_error()."</p>");
     
     LANJUTANNYA DIBAWAH...
     
    harytop likes this.
  5. dahagil

    dahagil Member

    Messages:
    81
    Likes Received:
    12
    Trophy Points:
    18
    mav bos sy newbie...masukinnya satu2 mang suka ga bs..tapi masukinya satu tempat bos di SQL Maestronya

    misal disatu tempat "tr_inbox" bs jalan semua scrip nya..jd satu tempat itu isinya semua (YMRemote, YMReport, insert SN, dll)

    tapi klo autopilot tinggal masukin ke AppServ\www\AutPiotErefill.php deh bos tinggal setting samain ma database sampean

    trs klo bwt autostart...tu kan dah Dot EXE jadi tingal instal bos..psti langsung masuk C:\Program Files\Mobile Media Erefill ---> tinggal set z di "setting.ini" mna terminal yg mau di jalanin nya....

    mav klo salah bos ..maklum newbie :peace::peace::peace:
     
  6. adwitya

    adwitya New Member

    Messages:
    166
    Likes Received:
    14
    Trophy Points:
    0
    Kalau yang Merah Tebal, sy suka pake bawaan EF. Udah Maknyuss kok..:thumb::thumb::thumb:
     
  7. alatsari

    alatsari Member

    Messages:
    96
    Likes Received:
    8
    Trophy Points:
    18
    autopilot dak maknyuss bos...ymremote masih bingung, itu khan ada parsing, close dan open, parsing ym remote ditaruh dimana ya...????
     
  8. alatsari

    alatsari Member

    Messages:
    96
    Likes Received:
    8
    Trophy Points:
    18
    Menutup Parsing
    Format : CLOSE KD_PRODUK TERMINAL PIN
    Contoh : CLOSE S5 57 1234
    Membuka Parsing
    Format : OPEN KD_PRODUK TERMINAL PIN
    Contoh : OPEN S5 59 1234
    Cek Status Parsing
    Format : STATUS KD_PRODUK TERMINAL PIN
    Contoh : STATUS S5 59 1234

    INI LHO BOSS...... INI APLIKASINE PIYE, DITARUH DIMANA?
     
  9. bilot

    bilot <font color=red><b>Dalam Pengawasan</b></font>

    Messages:
    282
    Likes Received:
    39
    Trophy Points:
    0


    kalau gak salah......m....m...m... taru di
    KULKAS BIAR DINGIN....:pound::pound::pound:
     
  10. alatsari

    alatsari Member

    Messages:
    96
    Likes Received:
    8
    Trophy Points:
    18

    udah tak coba saran bang bilot.....:D, kok masih bingung ya....., nggak muat sihhhhh, Hayo ini teka teki, ditaruh dimana dong....:loveeye:
     
  11. mr black

    mr black New Member

    Messages:
    96
    Likes Received:
    30
    Trophy Points:
    0
    semua script dijamin bisa jalan semuanya, silahkan minta pertanggung jawaban ke tempat anda beli scriptnya.

    kalo ngak jalan dijamin uang kembali 100% tanpa potongan apapun :peace:

    Buat om msolih maaf code autopilotnya ada yang copas disini :) maklum tidak tau tatakrama seperti aku :pound:
    smoga ilmunya jadi amalan buat om msolih, seperti yang om katakan walau satu huruf yang di bagikan Insya Allah jadi Amalan kelak ... amin
     
  12. alatsari

    alatsari Member

    Messages:
    96
    Likes Received:
    8
    Trophy Points:
    18
    betul itu om ilmu itu harus dibagikan... walau 1 huruf pasti dapat ganjaran..... nih ilmu autopilot berapa huruf ya...:loveeye:. Mudah2 an om msolih dapat ganjaran, maaf kalo ada yng tidak berkenan atas copas script ini, mohon maaf sebesar besarnya krn mendapatkan script ini tanpa ada pemberitahuan dr yg memberi kalo ini tidak boleh di copas, dan mohon maaf tidak tahu kalo ada tata kramanya...:sorry::sorry::sorry:
     

Share This Page