LAMPIRAN
201
L1 Admin session_start(); include ("dbConn.inc.php"); ?>
RAN <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script src="jsran.js" language="javascript">
include ("kiri.php") ?> :: <span id="judul"> :: include("contents.inc.php") ?>
include ("bawah.php") ?>
L2 Banner include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> if (($_REQUEST["action"] == "e") && ($_REQUEST["do"] == "s")) { $sqlh = "update banner set "; $sql = ""; if (basename($_FILES['filebanner']['name'][0]) != ""){ $sql = " header='" . $_FILES['filebanner']['name'][0] . "'"; } if (basename($_FILES['filebanner']['name'][1]) != ""){ if ($sql != "") $sql .= ","; $sql .= " companyinfo='" . $_FILES['filebanner']['name'][1] . "'"; } for ($i=2; $i<=8; $i++){ $k = $i - 1; if (basename($_FILES['filebanner']['name'][$i]) != ""){ if ($sql != "") $sql .= ","; $sql .= " sponsor$k='" . $_FILES['filebanner']['name'][$i] . "' "; } if ($sql != "") $sql .= ","; $sql .= " link$k='" . $_REQUEST["linksponsor"][$k-1] . "' "; } $sql = $sqlh . $sql; //echo $sql; return; db_query($sql, $con); $msg = "Data sudah tersimpan"; //BEGIN UPLOAD FILE //if ($_FILES['fgbr']['name'] != ""){ //foreach ($_FILES['fgbr']['name'] as nm => d) { $uploaddir = 'images/banner/'; if ($_FILES['filebanner']['name'][0] != ""){ $uploadfile = $uploaddir . basename($_FILES['filebanner']['name'][0]); if (($_FILES["filebanner"]["type"][0] == "image/gif") || ($_FILES["filebanner"]["type"][0] == "image/pjpeg") || ($_FILES["filebanner"]["type"][0] == "image/jpeg") && ($_FILES["filebanner"]["size"][0] < 500000)) { if (move_uploaded_file($_FILES['filebanner']['tmp_name'][0], $uploadfile)) { $param="msg=uploadok"; chmod($uploadfile, 0604); } else { $param = "msg=uploadfail"; break; } }else{ $param="msg=uploadfail"; break; } } if (basename($_FILES['filebanner']['name'][1]) != ""){ $uploadfile = $uploaddir . basename($_FILES['filebanner']['name'][1]);
L3 if (($_FILES["filebanner"]["type"][1] == "image/gif") || ($_FILES["filebanner"]["type"][1] == "image/pjpeg") || ($_FILES["filebanner"]["type"][1] == "image/jpeg") && ($_FILES["filebanner"]["size"][1] < 500000)) { if (move_uploaded_file($_FILES['filebanner']['tmp_name'][1], $uploadfile)) { $param="msg=uploadok"; chmod($uploadfile, 0604); } else { $param = "msg=uploadfail"; break; } }else{ $param="msg=uploadfail"; break; } } for ($i=2; $i<=8; $i++){ $uploadfile = $uploaddir . basename($_FILES['filebanner']['name'][$i]); if (basename($_FILES['filebanner']['name'][$i]) != ""){ if (($_FILES["filebanner"]["type"][$i] == "image/gif") || ($_FILES["filebanner"]["type"][$i] == "image/pjpeg") || ($_FILES["filebanner"]["type"][$i] == "image/jpeg") && ($_FILES["filebanner"]["size"][$i] < 500000)) { if (move_uploaded_file($_FILES['filebanner']['tmp_name'][$i], $uploadfile)) { $param="msg=uploadok"; chmod($uploadfile, 0604); } else { $param = "msg=uploadfail"; break; } }else{ $param="msg=uploadfail"; break; } } } //END UPLOAD FILE //echo $sql; return; $param = "msg=editok"; } else if ($_REQUEST["action"] == "d") { $sql = "delete from bank "; $sql .= " where norek='" . $_REQUEST["id"] . "'"; db_query($sql, $con); $msg = "Data sudah dihapus"; } $sql = "select * from banner "; $rs = db_query($sql, $con); ?>
L6 Beliitem include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); $action = $_REQUEST["action"]; if ($_REQUEST["action"] == "s"){ $sql = "insert into trbelirareitem (username, IDItem, transfer, konfirmasi, nick) "; $sql .= " values ('" . $_SESSION["sUsername"] . "', " . $_REQUEST["iditem"] . ", '" . $_REQUEST["transfer"] . "', '" . $_REQUEST["konfirmasi"] . "', '" . $_REQUEST["nick"] . "')"; db_query($sql, $con); Header("Location: http://".$host.$vname."index.php"); } ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="jsran.js"> <script> function fconfirmasi() { var d = confirm ("Anda yakin melakukan transaksi ini?"); if (d) return true; else return false; }
include ("atasmain.php") ?> include("bannerkiri.php") ?> include ("mainbanner.php")?> <span class="he1">Rare Item Shop if ($_SESSION["sSignIn"] == false) { ?> Anda harus melakukan Login terlebih dahulu include ("loginfrontalone.php"); } else {
L7 if ($action == "buy"){ ?> } else { ?> $sql = "select IDItem, NamaItem, ket, harga, Status "; $sql .= ", (select count(*) from trbelirareitem where IDItem=j.IDItem) as NumBooked"; $sql .= ", (select datediff(hh, min(tglpesan), { fn NOW()}) from trbelirareitem where iditem=j.iditem) as masaexpired"; $sql .= " , urlimage, tglterjual"; $sql .= " FROM trjualrareitem j "; $sql .= " where tglmulaijual <> ''"; $sql .= " and tglPembayaran is null"; //echo $sql; return; $rs = db_query($sql, $con); while (! $rs ->EOF ){ $numbooked = getRs($rs, 5); $masaExpired = (getRs($rs,5) * 48) - getRs($rs, 6); //echo $masaExpired; return; $n = ceil( $masaExpired / 48) -1;
L10 $masaExpired = $masaExpired - ($n * 48); $numbooked = ceil ($numbooked - (($numbooked * 48) ((getRs($rs,5) * 48) - getRs($rs, 6)))/48); //echo $n; return; $masaExpired .= " jam"; // . " jam "; $status = "Belum dipesan"; if ($numbooked > 0) { $status = "Sudah dipesan"; } //if(getRs($rs,4) == "1"){ if(getRs($rs,8) != ""){ $status = "Sudah terjual"; $numbooked = "-"; $masaExpired = "-"; } ?> Nama Barang = getRs($rs, 1) ?> Deskripsi = getRs($rs, 2) ?> Harga = getRs($rs, 3) ?> Number Booked = $numbooked ?> Status Pemesanan = $status ?> Batas Kadaluarsa Pemesanan = $masaExpired ?>
L11 < $rs->MOVENEXT; } ?>
} } ?>
include("bannerkanan.php") ?>
include ("bawahmain.php") ?>
Buygold include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); if ($_REQUEST["action"] == "s"){ $sql = "insert into trbeligold (username, jmlgold, transfer, konfirmasi, nick) "; $sql .= " values ('" . $_SESSION["sUsername"] . "', " . $_REQUEST["jumlah"] . ", '" . $_REQUEST["transfer"] . "', '" . $_REQUEST["konfirmasi"] . "', '" . $_REQUEST["nick"] . "')"; db_query($sql, $con); Header("Location: http://".$host.$vname."index.php"); } ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="jsran.js"> <script> function fconfirmasi() { var d = confirm ("Anda yakin melakukan transaksi ini?"); if (d) return true; else return false;
L12 }
include ("atasmain.php") ?> include("bannerkiri.php") ?> include ("mainbanner.php")?> if ($_SESSION["sSignIn"] == false) { ?> Anda harus melakukan Login terlebih dahulu include ("loginfrontalone.php"); } else { ?>
L15 } ?>
include("bannerkanan.php") ?>
include ("bawahmain.php") ?>
CekLogin include ("dbConn.inc.php") ?> if ($_REQUEST["kat"] == "user") { $sql = "select username, nama, passwd, nick from member"; $sql .= " where Username='". $_REQUEST["username"] . "' and [passwd] ='". $_REQUEST["passwd"] . "'"; $sql .= " and approved='1'"; if (! $rs = db_query($sql, $con)){ $errMsg = "Query Error"; return 0; }else{ if (!$rs->EOF){ session_start(); if (getRs($rs,2) == $_REQUEST["passwd"]){ $_SESSION["sUsername"] = getRs($rs,0); $_SESSION["sNick"] = getRs($rs,3); $_SESSION["sNama"] = getRs($rs,1); $_SESSION["sSignIn"] = true; Header("Location: http://".$host.$vname."index.php?msg=loginok&t=" . date('mns')); } }else{ Header("Location: http://".$host.$vname."index.php?ErrLogin=1"); } } } else { $sql = "select username, nama, passwd from admin"; $sql .= " where Username='". $_REQUEST["username"] . "' and [passwd] ='". $_REQUEST["passwd"] . "'"; if (! $rs = db_query($sql, $con)){ $errMsg = "Query Error"; return 0; }else{ if (!$rs->EOF){ session_start(); if (getRs($rs,2) == $_REQUEST["passwd"]){ $_SESSION["sUsername"] = getRs($rs,0); $_SESSION["sNama"] = getRs($rs,1);
L16 $_SESSION["sSignInAdmin"] = true; Header("Location: http://".$host.$vname."admin.php?msg=loginok&t=" . date('mns')); } }else{ Header("Location: http://".$host.$vname."admin.php?ErrLogin=1"); } } } ?> EditProfile include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); header("Cache-Control: no-cache"); header("Pragma: no-cache"); if ($_REQUEST["action"] == "s") { $sql = "update member set email='" . $_REQUEST["email"] . "', alamat='" . $_REQUEST["alamat"] . "', hp='" . $_REQUEST["hp"] . "'" ; $sql .= " where username='" . $_REQUEST["username"] . "'"; $rs = db_query($sql, $con); $msg = "Data Member sudah terupdate"; } ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
include ("atasmain.php") ?> include("bannerkiri.php") ?> include ("mainbanner.php")?> if ($_SESSION["sSignIn"] == true) { ?> echo $msg . " "; ?> } ?>
include("bannerkanan.php") ?>
L19 include ("bawahmain.php") ?>
ForgetPassword include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); header("Cache-Control: no-cache"); header("Pragma: no-cache"); if ($_REQUEST["action"] == "s") { $sql = "select passwd from member where username='" . $_REQUEST["username"] . "' and email='" . $_REQUEST["email"] . "'"; $rs = db_query($sql, $con); if ($rs->EOF){ $msg = "Email Error"; }else{ $msg = "Password has been sent to your email."; $pesan = "Password anda : " . getRs($rs, 0); //mail ($_REQUEST["email"], "Change Password", $pesan); } } ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
include ("atasmain.php") ?> include("bannerkiri.php") ?> include ("mainbanner.php")?> if ($_SESSION["sSignIn"] == false) { ?> echo $msg . " ";
L20 ?> } ?>
include("bannerkanan.php") ?>
include ("bawahmain.php") ?>
Hargagold include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> if (($_REQUEST["action"] == "a") && ($_REQUEST["do"] == "s")) { $sql = "insert into hargagold(gold, harga) values (" . $_REQUEST["gold"] . ", " . $_REQUEST["harga"] . ")"; db_query($sql, $con);
L22 $msg = "Data sudah tersimpan"; } else if (($_REQUEST["action"] == "e") && ($_REQUEST["do"] == "s")) { $sql = "update hargagold set harga=" . $_REQUEST["harga"]; $sql .= " where gold=" . $_REQUEST["gold"] ; db_query($sql, $con); $msg = "Data sudah tersimpan"; } else if (($_REQUEST["action"] == "d") && ($_REQUEST["do"] == "s")){ $sql = "delete from hargagold "; $sql .= " where gold=" . $_REQUEST["gold"]; db_query($sql, $con); $msg = "Data sudah dihapus"; } ?>
if (($_REQUEST["action"] == "a") || ($_REQUEST["action"] == "e") || ($_REQUEST["action"] == "d")){ echo "<span class='msg'>" . $msg . ""; if ($_REQUEST["action"] != "a"){ $sql = "select * from hargagold where gold=" . $_REQUEST["gold"]; $rs = db_query($sql, $con); if (($_REQUEST["action"] == "e")){ $isReadOnly= " readonly=true"; } if ($_REQUEST["action"] == "d"){ $isReadOnlyD= " readonly=true"; $isReadOnly= " readonly=true"; } } ?>
"> } else { ?>
Add New Record Jumlah Gold Harga Edit Del $sql = "select * from hargagold order by gold"; $rs = db_query($sql, $con); while (!$rs->EOF){ ?> = getRs($rs, 0) ?> = getRs($rs, 1) ?> ">edit ">del $rs->MOVENEXT; } ?>
} ?>
L24
Home
Home pphp uth... asfa Index include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); header("Cache-Control: no-cache"); header("Pragma: no-cache"); ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
include ("atasmain.php") ?> include("bannerkiri.php") ?> include ("mainbanner.php")?> if ($_SESSION["sSignIn"] == true) { ?> <span class="he1">Selamat Datang di Ran Online Gold Mencari gold di game Ran Online tidaklah mudah, tapi sekarang anda dapat membeli gold, menaikkan level, membeli rare item dengan melakukan pemesanan melalui website ini. Untuk apa mencari resiko dengan membeli gold dan rare item dari sumber yang tidak jelas? Untuk apa mencari resiko dengan mempercayakan character anda kepada joki yang tidak anda kenal? Ran Online Gold menyediakan pemecahan dari semua masalah itu. Selamat bermain dan jadilah juara !! } ?> if ($_SESSION["sSignIn"] == false) { if ($_REQUEST["ErrLogin"]=="1"){ echo ("<span class='errmsg'>Username dan Password salah"); } ?>
L25
} ?>
include("bannerkanan.php") ?>
include ("bawahmain.php") ?>
Inforareitem include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?>
if ( ($_REQUEST["action"] == "v")){ $iditem = $_REQUEST["iditem"];
L27 $isReadOnlyD= " readonly=true"; $isReadOnly= " readonly=true"; $sql = "select IDItem, NamaItem, ket, harga, Status, m.username, usernamepembeli, tglmulaijual, tglterjual"; $sql .= ", (select count(*) from trbelirareitem where IDItem=j.IDItem) as NumBooked"; $sql .= ", (select datediff(hh, min(tglpesan), { fn NOW()}) from trbelirareitem where iditem=j.iditem) as masaexpired"; $sql .= " FROM trjualrareitem j "; $sql .= " inner join member m on m.nick=j.nick"; $sql .= " where j.iditem=" . $iditem; $rs = db_query($sql, $con); if (!$rs->EOF){ $numbooked = getRs($rs, 9); $masaExpired = (getRs($rs,9) * 48) - getRs($rs, 10); $status = "Belum dipesan"; if (getRs($rs,4) == "1") { $status = "Sudah dipesan"; }else if(getRs($rs,4) == "2"){ $status = "Sudah terjual"; $numbooked = ""; $masaExpired = ""; } ?>
L29 } } else { ?>
Nama Item Num. booked Masa Expired Tgl Expired Username Penjual $sql = "select IDItem, NamaItem, Status, m.username, usernamepembeli"; $sql .= ", (select count(*) from trbelirareitem where IDItem=j.IDItem) as NumBooked"; $sql .= ", (select datediff(hh, min(tglpesan), { fn NOW()}) from trbelirareitem where iditem=j.iditem)"; $sql .= " FROM trjualrareitem j "; $sql .= " inner join member m on m.nick=j.nick"; $rs = db_query($sql, $con); while (!$rs->EOF){ $masaExpired = (getRs($rs,5) * 48) - getRs($rs, 6) . " Jam"; $tglExpired = (getRs($rs,5) * 48) - getRs($rs, 6); $tglExpired = ceil($tglExpired / 48); //$tglExpired = date("d m Y"); ?> "> = getRs($rs, 1) ?> = getRs($rs, 5) ?> = $masaExpired ?> = $tglExpired ?> = getRs($rs, 3) ?> $rs->MOVENEXT; } ?>
} ?> Infostok include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> if ($_REQUEST["action"] == "a"){ if ($_REQUEST["kat"] == "gold") {
L30 $sql = "Insert into dtStockGold (gold) values (" . $_REQUEST["gold"] . ")"; db_query($sql, $con); }elseif ($_REQUEST["kat"] == "voucher"){ $_40jp = $_REQUEST["40jp"]; if ($_40jp == "") $_40jp = 0; $_100jp = $_REQUEST["100jp"]; if ($_100jp == "") $_100jp = 0; $_200jp = $_REQUEST["200jp"]; if ($_200jp == "") $_200jp = 0; $sql = "Insert into dtStockvoucher ([40jp], [100jp], [200jp]) values (" . $_40jp . ", " . $_100jp . ", " . $_200jp . ")"; db_query($sql, $con); } } ?>
Stock Gold Adjustment : $sql = "select saldo = (sum(gold) - (select sum(jmlgold) from trbeligold where approval='1')) from dtstockgold "; $rs = db_query($sql, $con); if (!$rs->EOF){ echo "Stock Gold saat ini : " . getRs($rs, 0); } ?>
Tanggal Penambahan Gold $sql = "select * from dtstockgold order by tgl desc"; $rs = db_query($sql, $con); $n = 0; while ((!$rs->EOF) && $n++ < 10){ ?> = getRs($rs, 0) ?> = getRs($rs, 1) ?> $rs->MOVENEXT;
L31 } ?>
Stock Voucher Adjustment : 40jp : 100jp : 200jp : $sql = "select saldo40 = (sum([40jp]) - (select sum([40jp]) from trvoucher where approval='1')) "; $sql .= " , saldo100 = (sum([100jp]) - (select sum([100jp]) from trvoucher where approval='1'))"; $sql .= " , saldo200 = (sum([200jp]) - (select sum([200jp]) from trvoucher where approval='1'))"; $sql .= " from dtstockvoucher "; $rs = db_query($sql, $con); if (!$rs->EOF){ echo "Stock Voucher saat ini :
"; echo " 40 JP : " . getRs($rs, 0) . "
"; echo "100 JP : " . getRs($rs, 1) . "
"; echo "200 JP : " . getRs($rs, 2) . "
"; } ?>
Tanggal 40JP 100JP 200JP $sql = "select * from dtstockvoucher order by tgl desc"; $rs = db_query($sql, $con); $n = 0; while ((!$rs->EOF) && $n++ < 10){ ?> = getRs($rs, 0) ?> = getRs($rs, 1) ?> = getRs($rs, 2) ?> = getRs($rs, 3) ?>
L32 $rs->MOVENEXT; } ?>
Jualrareitem include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); $action = $_REQUEST["action"]; if ($_REQUEST["action"] == "s"){ $sql = "insert into trjualrareitem (nick, namaitem, ket, harga, tglpengajuan, norek, namabank"; $sql .= " , an, konfirmasi, status) "; $sql .= " values ('" . $_REQUEST["nick"] . "', '" . $_REQUEST["namaitem"] . "', '" . $_REQUEST["ket"] . "', " . $_REQUEST["harga"]; $sql .= ", getdate(), '" . $_REQUEST["norek"] . "', '" . $_REQUEST["bank"] . "', '"; $sql .= $_REQUEST["an"] . "', '" . $_REQUEST["konfirmasi"] . "', '0')"; //echo $sql; return; db_query($sql, $con); Header("Location: http://".$host.$vname."index.php"); } ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="jsran.js"> <script> function fconfirmasi() { var d = confirm ("Anda yakin melakukan transaksi ini?"); if (d) return true; else return false; }
include ("atasmain.php") ?>
L33 include("bannerkiri.php") ?> include ("mainbanner.php")?> if ($_SESSION["sSignIn"] == false) { ?> Anda harus melakukan Login terlebih dahulu include ("loginfrontalone.php"); } else { ?> } ?>
include("bannerkanan.php") ?>
include ("bawahmain.php") ?>
Jualvoucher include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> session_start(); $action = $_REQUEST["action"]; if ($_REQUEST["action"] == "s"){ $sql = "insert into trvoucher (username, [40jp], [100jp], [200jp], transfer, konfirmasi) ";
L37 $sql .= " values ('" . $_SESSION["sUsername"] . "', '" . $_REQUEST["40jp"] . "', '" . $_REQUEST["100jp"] . "', '" . $_REQUEST["200jp"] . "', '" . $_REQUEST["transfer"] . "', '" . $_REQUEST["konfirmasi"] . "')"; //echo $sql; return; db_query($sql, $con); Header("Location: http://".$host.$vname."index.php"); } ?>
Ran Online Gold <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="jsran.js"> <script> var total=0; function fconfirmasi() { var d = confirm ("Anda yakin melakukan transaksi ini?"); if (d) return true; else return false; } function hitung(f, val) { if (val == 1) document.getElementById("hrg" + val).innerHTML = f.value * 10000; if (val == 2) document.getElementById("hrg" + val).innerHTML = f.value * 50000; if (val == 3) document.getElementById("hrg" + val).innerHTML = f.value * 100000; //if (document.getElementById("hrg1").value > 0) total = (document.getElementById("40jp").value * 10000); if (document.getElementById("100jp").value > 0) total = total + (document.getElementById("100jp").value * 50000); if (document.getElementById("200jp").value > 0) total = total + (document.getElementById("200jp").value * 100000); document.getElementById("total").innerHTML = total; }
include ("atasmain.php") ?> include("bannerkiri.php") ?> include ("mainbanner.php")?>
L38 if ($_SESSION["sSignIn"] == false) { ?> Anda harus melakukan Login terlebih dahulu include ("loginfrontalone.php"); } else { ?> } ?>
include("bannerkanan.php") ?>
include ("bawahmain.php") ?>
Login session_start(); if ($_REQUEST["msg"] == "logoutok"){ $msg = ""; //"
Logout Sukses
"; echo "<span class=\"msg\">".$msg.""; }else if ($_REQUEST["ErrLogin"] == "1"){ $msg = "
Login Error
"; echo "<span class=\"errmsg\">".$msg.""; } if (!$_SESSION["sSignInAdmin"]) { ?>
} else { if ($_REQUEST["msg"] == "loginok"){ $msg = ""; //"
Login Sukses
"; } echo "<span class=\"msg\">".$msg.""; } ?> Loginfrontalone session_start(); ?>
if ($_SESSION["sSignIn"] == false) { ?>
} ?> Member include ("dbConn.inc.php"); ?> include ("fungsi.php"); ?> if (($_REQUEST["action"] == "a") && ($_REQUEST["do"] == "s")) { //$sql = "insert into member(username, nama, nick, email, alamat, hp, jnsklm, tgllhir) "; //$sql .= " values ('" . $_REQUEST["norek"] . "', '" . $_REQUEST["nama"] . "', '" . $_REQUEST["nmbank"] . "')"; //db_query($sql, $con); //$msg = "Data sudah tersimpan"; $msg = "Query SQL BLM DIBUAT, HRSNYA ADD MEMBER DARI FRONT END"; } else if (($_REQUEST["action"] == "e") && ($_REQUEST["do"] == "s")) { $sql = "update member set approved= '" . $_REQUEST["approved"] . "'"; $sql .= " where username='" . $_REQUEST["username"] . "'"; db_query($sql, $con); $msg = "Data sudah tersimpan"; $_REQUEST["action"] = ""; } else if (($_REQUEST["action"] == "d") && ($_REQUEST["do"] == "s")){ //$sql = "delete from member "; //$sql .= " where USERNAME='" . $_REQUEST["id"] . "'"; //db_query($sql, $con); //$msg = "Data member " . $_REQUEST["username"] . " sudah dihapus"; } ?>
if (($_REQUEST["action"] == "a") || ($_REQUEST["action"] == "e") || ($_REQUEST["action"] == "d") || ($_REQUEST["action"] == "v")){ echo "<span class='msg'>" . $msg . ""; $sql = "select * from member where username='" . $_REQUEST["id"] . "'"; $rs = db_query($sql, $con); if ($_REQUEST["action"] == "e"){ $isReadOnlyD= " readonly=true"; } ?>
L45 "> <span class="Label3">Member Username : > Nama : > Nick Character : > E-mail : > Alamat : >= str_replace("\n", " ", getRs($rs, 5)) ?> No. HP : > Jenis Kelamin : Pria
L46 Wanita Tanggal Lahir : <select name="tgl"> $tgl = substr (getRs($rs, 8),6); $bln = substr(getRs($rs, 8),4,2); $thn = substr(getRs($rs, 8),0, 4); for ($i=1; $i<=31; $i++ ) { $k = "". $i; if ($i < 10) $k = "0". $i; echo "" . $i . " "; } ?> <select name="bln"> for ($i=1; $i<=12; $i++ ) { $k = "". $i; if ($i < 10) $k = "0". $i; echo "" . $i . " "; } ?> <select name="thn"> for ($i=2007; $i>=1900; $i-- ) { echo "" . $i . " "; } ?> Approval : Approved Rejected
L47 } else { ?>
Nick Character Name E-mail Status $sql = "select * from member"; $rs = db_query($sql, $con); while (!$rs->EOF){ if (getRs($rs, 9) == "1" ){ $status = "Approved"; }else{ $status = "Rejected"; } ?> = getRs($rs, 2) ?> "> = getRs($rs, 2) ?> = getRs($rs,4) ?> = $status ?> $rs->MOVENEXT; } ?>
} ?>