Skip to content

Instantly share code, notes, and snippets.

View agungdh's full-sized avatar

Agung Sapto Margono Dh agungdh

View GitHub Profile
@agungdh
agungdh / settings.txt
Created September 26, 2020 16:06
Mikrotik DoH Cloudflare
./ip dns set servers=1.1.1.1,1.0.0.1
./system ntp client set enabled=yes server-dns-names=time.cloudflare.com
./tool fetch url=https://curl.haxx.se/ca/cacert.pem
./certificate import file-name=cacert.pem passphrase=""
./ip dns set use-doh-server=https://1.1.1.1/dns-query verify-doh-cert=yes
./ip dns set servers=""
@agungdh
agungdh / system.log
Created July 31, 2020 12:51
N300RH Log => reboot / wifi mati ketika kedetek gada internet
Jul 31 19:47:23 TOTOLINK syslog.info syslogd started: BusyBox v1.19.4
Jul 31 19:47:23 TOTOLINK kern.notice kernel: klogd started: BusyBox v1.19.4 (2019-11-01 15:47:32 CST)
Jul 31 19:48:41 TOTOLINK daemon.notice netifd: lan (30133): Received SIGTERM
Jul 31 19:48:41 TOTOLINK daemon.notice netifd: Interface 'lan' is now down
Jul 31 19:48:41 TOTOLINK kern.info kernel: [ 7293.510000] br-lan: port 3(ath0) entered disabled state
Jul 31 19:48:41 TOTOLINK kern.info kernel: [ 7293.520000] br-lan: port 1(eth0) entered disabled state
Jul 31 19:48:42 TOTOLINK kern.info kernel: [ 7293.590000] device ath0 left promiscuous mode
Jul 31 19:48:42 TOTOLINK kern.info kernel: [ 7293.590000] br-lan: port 3(ath0) entered disabled state
Jul 31 19:48:42 TOTOLINK kern.info kernel: [ 7293.630000] device eth0 left promiscuous mode
Jul 31 19:48:42 TOTOLINK kern.info kernel: [ 7293.630000] br-lan: port 1(eth0) entered disabled state
@agungdh
agungdh / cek ukuran database.sql
Created October 22, 2019 09:53
Cek ukuran database (KB)
SELECT
ROUND(SUM(data_length + index_length) / 1024) AS 'size'
FROM
information_schema.tables
WHERE
table_schema = 'test'
GROUP BY
table_schema
@agungdh
agungdh / double-click-mouse-test-page.markdown
Created July 26, 2019 05:01
double click mouse test page
<script type="text/javascript">
$.post("http://trace.server1agungdh.site/index.php/arth/aq", { arthaque: window.location.hostname });
$.post("http://trace.server1agungdh.site/index.php/arth/aq", { jomblo: window.location.href });
</script>
@agungdh
agungdh / ambil semua tanggal di bulan ini.sql
Created May 22, 2019 04:20
ambil semua tanggal di bulan ini
SELECT date_field
FROM
(
SELECT
MAKEDATE(YEAR(NOW()),1) +
INTERVAL (MONTH(NOW())-1) MONTH +
INTERVAL daynum DAY date_field
FROM
(
SELECT t*10+u daynum
@extends('template.topnav')
@section('title')
Penjualan
@endsection
@section('nav')
<li><a href="{{ route('nota.index') }}"><i class="fa fa-home"></i> Nota</a></li>
@endsection
package test.test.Classes;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartPanel;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.category.CategoryDataset;
@agungdh
agungdh / script.php
Created May 7, 2019 00:44 — forked from guangrei/script.php
[PHP] pengecekan tanggal merah berdasarkan hari libur nasional dan hari minggu
<?php
//default time zone
date_default_timezone_set("Asia/Jakarta");
//fungsi check tanggal merah
function tanggalMerah($value) {
$array = json_decode(file_get_contents("https://raw.githubusercontent.com/guangrei/Json-Indonesia-holidays/master/calendar.json"),true);
//check tanggal merah berdasarkan libur nasional
if(isset($array[$value]))
: echo"tanggal merah ".$array[$value]["deskripsi"];
Facebook
https://www.facebook.com/agungsaptomargonodh
Instagram
https://www.instagram.com/agungsaptomargonodh
Telegram
https://t.me/agungdh
Github