{ Berbagi, Menulis, Dan Mengajar } Ilmu… » 7. Operating System
bukti transfer First Media –> Tagihan 1, 14/02/2016
FirstMedia … Read entire article »
Filed under: 7. Operating System
Iso Elektra – Bos pom – Diesel Bengkel
PT. ISO-ELEKTRA JI. RAJAWALI NO. 82/1 SURABAYA, 60175 Indonesia View Map Phone: 31 353 7780 Fax: 31 353 7782 Dealer Type Service Dealer —— Pak Tisen, Rungkut – Cedak e pondok candra – 081336443277 … Read entire article »
Filed under: 7. Operating System
Excel Tabel Untuk Membuat Harga Barang Include PPN 10%
TabelHitungJualBarangIncludePPN … Read entire article »
Filed under: 7. Operating System
ini konfigurasi Mikrotik PTPN-11 untuk VPN
MikrotikDMS_VPN_SOED_FIX.backup –> Download File Ini dan Hapus Extension .(dot) txt Gunakan User : Admin, Passsword : okedeh Gunakan Port ke – 2 pada mikrotik RB 750 , colokkan kabel Ethernet ke PC Seting IP – Komputer / PC anda : 10.1.10.2 / 24 Gunakan Winbox, dan akses ke IP : 10.1.10.1 — Sebagai catatan, Link Masuk ke Server PG SOEDONO, 36.74.100.202 user : dms pass: okedeh root@SudonoServer:/home/dms# netstat -nr Kernel IP routing table Destination Gateway Genmask Flags MSS Window irtt Iface 0.0.0.0 10.1.10.1 0.0.0.0 UG 0 0 0 eth1 # link ke VPN 0.0.0.0 192.168.11.1 0.0.0.0 UG 0 0 0 eth0 # link ke Speedy 10.1.10.0 0.0.0.0 255.255.255.0 U 0 0 0 eth1 192.168.11.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0 ——- PENAMBAHAN ROUTING di Linux root@SudonoServer:/home/dms# route add -net 10.1.10.0 netmask 255.255.255.0 gw 10.1.10.1 root@SudonoServer:/home/dms# netstat -nr Kernel IP routing table Destination Gateway Genmask … Read entire article »
Filed under: 7. Operating System, mikrotik
Settingan Mikrotik RB 750 Rendy, Routing ke Gateway Lalu di Masquarade ke Jaringan Lokal
Ubah File. backup.txt –> Hilangkan Extension .txt-nya mikrotik_RB750_rendy MikroTik-05122015-1119.backup … Read entire article »
Filed under: 7. Operating System, mikrotik
ini SQL Query Mendelete Database Milik Hotel / Dispenda / MYSQL
Ada tiga Tabel Penting yang harus di bersihkan untuk mengurangi beban server Aplikasi Pajak Hotel, yaitu Tabel db_checkout_hotel, db_detail_reservasi, db_reservasi_hotel Delete Data Dilakukan pada transaksi diluar 4 bulan terakhir ——– … Read entire article »
Filed under: 7. Operating System
Query MYQL – DELETE DATA
USE dbHotelWismaKarya; SELECT * FROM db_checkout_hotel WHERE waktu_checkout LIKE ‘2015-11%'; ——— Untuk Melihat data yang akan kita pilih — USE dbHotelWismaKarya; SELECT * FROM db_checkout_hotel WHERE waktu_checkout NOT LIKE ‘2015-11%’ AND waktu_checkout LIKE ‘2015-10%’ AND waktu_checkout LIKE ‘2015-19%'; ——– — *. Untuk mendelete Data yang ditentukan USE dbHotelWismaKarya; DELETE FROM db_detail_reservasi WHERE checkin_date NOT LIKE ‘2015-11%’ AND checkin_date NOT LIKE ‘2015-10%’ AND checkin_date NOT LIKE ‘2015-09%'; … Read entire article »
Filed under: 7. Operating System
Referensi PDT Eclipse, PHP Eclipse
Apache IvyDE Repository http://www.apache.org/dist/ant/ivyde/updatesite Enabledcom.vaadin.update.site http://vaadin.com/eclipse Disabled Mars http://download.eclipse.org/releases/mars/ Enabled Mars http://download.eclipse.org/releases/mars/201506241002 Enabled Neon http://download.eclipse.org/releases/neon Enabled PDT PHP http://download.eclipse.org/tools/pdt/updates/latest/ Enabled The Eclipse Project Updates http://download.eclipse.org/eclipse/updates/4.6 Enabled webtools http://download.eclipse.org/webtools/updates/ Enabled http://ant.apache.org/ivy/ivyde/updatesite Disabled … Read entire article »
Filed under: 7. Operating System