Monday, 26 March 2018

How Do Remove a Service from Computer Management Services Extension

Here is how I did that:
  1. Run Regedit or Regedt32.
  2. Go to the registry entry "HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services"
  3. Look for the service that you want delete and delete it. You can look at the keys to know what files the service was using and delete them as well (if necessary).

Fungsi-fungsi SQL dan Kegunaannya

1. SELECT DISTINCT: Berfungsi untuk 'hanya' menampilkan/mencari data yang berbeda dari semua data yang sama.
  1. SELECT DISTINCT column-name
  2. FROM table-name
Contoh:
  1. SELECT DISTINCT Country
  2. FROM Supplier
  3. ORDER BY COUNTRY
Source: http://www.dofactory.com/sql/select-distinct

if(isset($_GET['verif']))
{
$tgl=$_GET['verif'];
$result=mysql_query("SELECT count(*) FROM user WHERE unametes != '0' AND lastlogin LIKE '$tgl'");
echo mysql_result($result, 0);
}

SELECT pass, uname, COUNT( 1 ) AS CNT
FROM user
GROUP BY pass
HAVING COUNT( 1 ) >1


Saturday, 24 March 2018

ExamBrowser yang bisa atur IPnya

ExamBrowser adalah aplikasi yang digunakan untuk mengunci tombol pada saat menggunakan web browser.
Hal ini biasanya diterapkan pada saat Ujian Berbasi Komputer.
Berikut link download ExamBrowser yang bisa diatur alamat IPnya:
1. Extramedia : https://drive.google.com/open?id=1VIaAD9DrhenwjYgrGiiiblrfwnRoEHXd
2. Exambro Final v16.0316 : https://drive.google.com/open?id=1BrKI8GvbKFZ__Ji6imxLlN_B0B1FGdHq

Sunday, 18 March 2018

Fungsi-fungsi PHP dan Kegunaannya

Untuk membuat huruf kapital di awal kata: php.net/manual/en/function.ucfirst.php

Shell: https://drive.google.com/open?id=1dipSGSpP9w4YKpE14IubD4hfHHWeThjq

Wednesday, 14 March 2018

Stephen Hawking Meninggal



The belief that heaven or an afterlife awaits us is a "fairy story" for people afraid of death, Stephen Hawking has said.
THE greatest mind of the generation — physicist Professor Stephen Hawking — has died at the age of 76 after a long struggle with motor neurone disease.
His children Lucy, Robert and Tim said in a statement: “We are deeply saddened that our beloved father passed away today.”
If you hadn’t seen the wheelchair-bound genius on documentaries or the news, you’d probably have had a window to his early life through the movie The Theory of Everything.



Project Text-Speech and Speech-Text

My reference:
1. https://ttsreader.com/
2. https://speechlogger.appspot.com/en/
3. https://speech-to-text-demo.ng.bluemix.net/
4. http://www.wizzardsoftware.com/text-to-speech-sdk.php
5. https://www.naturalreaders.com/online/
6. http://www.text2speech.org/
7. https://acapela-box.com/AcaBox/index.php
8. http://oddcast.com/home/demos/tts/tts_example.php

Kumpulan Murrotal

Berikut beberapa referensi kumpulan murrotal:
1. https://archive.org/details/AhmadSaud_Kitabkuning
2. https://islamdownload.net/123882-download-murottal-ahmad-saud.html

Tuesday, 13 March 2018

Belajar Android Studio

Berikut link-link yang mungking berguna untuk belajar Android Studio:
1. https://www.okedroid.com/p/belajar-android.html

2. https://www.twoh.co/mudengdroid-belajar-android-bersama-twohs-engineering/basic-belajar-membuat-aplikasi-android-untuk-pemula-di-android-studio

Wirda Ingin Beli YouTube

Ya namanya juga bercita-cita, seperti yang sering orang tua katakan, bercita-citalah setinggi langit.

 Tembus 100 Ribu Subscriber, Putri Yusuf Mansur Ingin Beli YouTube

akarta - Kisah putri ustad dan pengusaha Yusuf Mansur, Wirda Salamah Ulya tembus 100 ribu suscriber di channel atau akun YouTube-nya viral. Penyebabnya ia mengunggah keterangan berkeinginan membeli situs raksasa berbagi video, YouTube.

Semua orang memang harus punya mimpi. Pun begitu dengan Wirda yang akrab dikenal Wirda Mansur. Mungkin membeli YouTube adalah mimpi Wirda suatu saat.

Dalam posting-annya, Wirda Mansur menambahkan foto paket yang ia terima dari YouTube. Tapi ia malah mencoret nama CEO YouTube dan menambahkan keterangan sedikit mengejutkan.

"Beberapa hari yang lalu, gue dapet kiriman paket dari @youtube. Isinya, Silver Play Button 100,000 Subscribers (also, gue ingin berterimakasih kepada teman-teman yang udah subscribe, juga nonton, walaupun gue rasa masih kurang berfaedah hahaha). Doain ya, mudah-mudahan makin rajin upload kedepannya. Aamiin. Saat gue ngebuka boxnya, dan ngeliat Silver Play Button." tulis Wirda di akunnya, @wirda_mansur dikutip detikHOT, Rabu (31/5).

"Gue diem. I asked myself, gue bertanya sama diri gue sendiri. "Do I wanna be a YouTuber?", "Apakah gue pengen jadi YouTuber?". Then I continued my sentence, setelah itu gue lanjutin kalimat gue. "No. I want to buy YouTube.", "Gue pengen beli YouTube." That is dream. Dream itu soal keberanian. Berani ngucap, berani ngomong, berani nulis, berani yakin. Go big, or go-blo... 'on. hehe. Akhirnya gue ambil kertas tulisan dari YouTube, dan gue coret nama CEOnya jadi nama gue. Tanda tangannya juga jadi tanda tangan gue. Insya Allah jadi langkah awal buat menuju ngebeli beneran. Ntar namanya jadi You-Suf, pake Mansur. Hahahaha. Sip," tambah Wirda lagi.

Mahasiswi di University of Oxford Inggris itu juga dikenal sebagai penyanyi selain aktif sebaga vlogger. Belum sampai setahun, single-nya yang bertajuk 'Cahaya Cinta' beredar.

Cewek remaja manis ini memang menyita perhatian sejak awal kemunculannya. Ia juga dikenal hobi traveling.

Berkuliah di Inggris juga memudahkan Wirda Mansur berkeliling Eropa. Kini kisah Wirda Mansur ingin membeli YouTube pun ramai dibicarakan. Banyak yang memuji tekadnya.



Sumber: https://hot.detik.com/celeb/d-3516270/tembus-100-ribu-subscriber-putri-yusuf-mansur-ingin-beli-youtube

Monday, 12 March 2018

TOKI - Silabus Pemrograman Kompetitif Dasar

Silabus Pemrograman Kompetitif Dasar

1. Perkenalan

  • Motivasi
  • Soal ad hoc

2. Matematika Diskret Dasar

  • Aritmetika modular
  • Faktor bilangan dan sifatnya
  • FPB dan KPK
  • Prime generation
  • Prinsip inklusi eksklusi
  • Pigeon Hole Principle
  • Kombinatorik

3. Brute Force

  • Konsep
  • Teknik umum
  • Studi kasus (umum)

4. Divide and Conquer

  • Konsep
  • Studi kasus: Merge Sort dan QuickSort

5. Greedy

  • Konsep
  • Studi kasus: Coin Change
  • Studi kasus: Activity Selection

6. Dynamic Programming

  • Konsep
  • Studi kasus: Coin Change
  • Studi kasus: Knapsack
  • Studi kasus: Matrix Chain Multiplication (diadopsi menjadi Cutting Stick, UVa 10003)

7. Struktur Data Linear

  • Linked list
  • Stack
  • Queue

8. Perkenalan Graph

  • Konsep
  • Jenis dan sifat graph
  • Representasi graph
  • Graph traversal (Breadth First Search, Depth First Search)
  • Graph khusus: tree, directed acyclic graph

9. Struktur Data Non-Linear

  • Heap
  • Heap Sort
  • Disjoint Set

10. Komputasi Geometri Dasar

  • Titik
  • Garis
  • Segmen garis
  • Segitiga
  • Sudut
  • Lingkaran
  • Representasi elemen geometri dalam pemrograman

11. Memenangkan Kompetisi

  • Tips untuk menghadapi kompetisi sekaligus penutup
Sumber: https://github.com/ia-toki/training-gate-id/blob/master/topik/pemrograman-kompetitif-dasar/SILABUS.md

TOKI - Silabus Pemrograman Dasar

Silabus Pemrograman Dasar

1. Perkenalan

  • Perkenalan konsep pemrograman (memprogram, kompilasi, eksekusi)
  • Perkenalan dan instalasi Pascal
  • Perkenalan IDE dan instalasi
  • Program Hello World

2. Variabel dan Tipe Data

  • Pengenalan konsep variabel
  • Tipe data sederhana
  • Tipe data buatan (struct)
  • Dekalarasi variabel

3. Ekspresi dan Masukan/Keluaran

  • Ekspresi numerik
  • Ekspresi boolean (predikat)
  • Ekspresi relasional
  • Prioritas pengerjaan
  • Input output (read, readln, write, writeln)
  • Penjelasan tentang STDIO

4. Penunjang Pemrograman Dasar

  • Komentar
  • Pesan kesalahan IDE
  • I/O redirection

5. Percabangan

  • If ...
  • If ... else ...
  • If ... elseif ... else ...
  • case ... of ...
  • Pengenalan tentang blok "begin ... end"

6. Perulangan

  • Pengulangan dengan pencacah (for)
  • Pengulangan dengan kondisi awal (while)
  • Pengulangan dengan kondisi akhir (repeat until)

7. Perulangan Lanjut

  • Break & continue
  • Perulangan berlapis

8. Analisis Kompleksitas

  • Pengenalan Big-Oh sederhana
  • Penjelasan tentang apa pentingnya menghitung kompleksitas

9. Array

  • Konsep array
  • Deklarasi Array
  • Mengisi array (baca)
  • Menulis isi array (tulis)
  • Array multidimensi

10. Fungsi dan Prosedur

  • Prosedur
  • Fungsi
  • Scope
  • Parameter dan passing parameter

11. Pendalaman String

  • Penjelasan bahwa string pada Pascal merupakan array of char
  • Fungsi-fungsi dasar pada string (length, copy, delete, insert, pos, str, val)

12. Pencarian

  • Linear search
  • Binary search
  • Analisis kompleksitas

13. Pengurutan Dasar

  • Bubble sort
  • Insertion sort
  • Selection sort
  • Analisis kompleksitas
  • Kapan menggunakan insertion sort, kapan selection sort, dsb

14. Rekursi

  • Mengapa perlu ada rekursi
  • Rekursi tanpa cabang
  • Analsis kompleksitas

15. Rekursi Lanjut

  • Rekursi dengan cabang
  • Analsis kompleksitas
Sumber: https://github.com/ia-toki/training-gate-id/blob/master/topik/pemrograman-dasar/SILABUS.md

Friday, 9 March 2018

Bitwise - Rahasia Kalkulasi Super Cepat


Tadinya saya sempat tidak paham kenapa anak TOKI yang menjadi pemateri ToT ICT bisa melakukan komputasi yang seharusnya dilakukan dengan kurun waktu +- 25 detik menjadi hanya 1 detik. Tapi sampai saat tulisan ini  saya tulis pun masih belum paham kok. :-)
Intinya, penggunaan BitWise ini dapat merubah nilai dari desimal menjadi Biner (0,1), sehingga membuat komputer mudah mengerti dan melakukan komputasi / perhitungan pun menjadi lebih mudah.

Misal:

Comparing Bits: The Bitwise and Operator
Bitwise and is a binary operator that uses the following syntax
Operand1 and Operand2
This operator considers two values and compares the bit of each with the corresponding bit of the other value. If both corresponding bits are 1, the comparison produces 1. Otherwise, that is, if either bit is 0, the comparison produces 0. This comparison is resumed as follows:
Bit1Bit2Bit1 and Bit2
000
100
010
111
Imagine you have two byte values represented as 187 and 242. Based on Appendix C, the binary value of decimal 187 is 1011 1011 (and its hexadecimal value is 0xBB). The binary value of decimal 242 is 1111 0010 (and its hexadecimal value is 0xF2). Let’s compare these two values bit by bit, using the bitwise AND operator:
 Binary Decimal
N110111011187
N211110010242
N1 and N210110010178

Most of the times, you will want the compiler to perform this operation and use the result in your program. This means that you can get the result of this operation and possibly display it on the console. The above operation can be performed by the following program:
program Project1;

{$APPTYPE CONSOLE}

const N1 = 187;
const N2 = 242;

begin
 Writeln(N1, ' and ', N2, ' = ', (N1 and N2));

 Write('Press any key to continue...');
 Readln;
end.
This would produce:
187 and 242 = 178
Press Enter key to exit...


Source: http://www.functionx.com/objectpascal/Lesson09.htm

Kumpulan Situs Web untuk IDE atau Compiler Source Code berbagai Bahasa Pemrograman

Situs web berikut gunanya untul menjalankan Source Code Program yang kita tulis, tanpa harus menginstall terlebih dahulu program dari Bahasa Pemrograman tersebut.
1. rextester.com/main
2. https://www.jdoodle.com
3. https://www.tutorialspoint.com/compile_pascal_online.php
4. www.compileonline.com
5. www.onlinecompiler.net
6. https://tio.run/
7. https://www.codechef.com/ide
8. https://ideone.com

Wednesday, 7 March 2018

Download Materi Olimpiade Kompoter

Materi Olimpiade Komputer dari TOKI dapat didownload di:
www.toki.or.id/downloads/

Soal OSK 2018 TIK: https://drive.google.com/open?id=19winw1GL9l7QdccaLU-48ohfuyHLl5BK

Tuesday, 6 March 2018

MySQL Command Line Cheatsheet




SHOW databases;
CREATE DATABASE ppdbmankoraya;
USE ppdbmankoraya;
SHOW tables;
CREATE TABLE `haldepan` (
  `id` int(5) NOT NULL,
  `konten` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `dashboard` (
  `id` int(11) NOT NULL,
  `konten` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Access monitor: mysql -u [username] -p; (will prompt for password)
Show all databases: show databases;
Access database: mysql -u [username] -p [database] (will prompt for password)
Create new database: create database [database];
Select database: use [database];
Determine what database is in use: select database();
Show all tables: show tables;
Show table structure: describe [table];
List all indexes on a table: show index from [table];
Create new table with columns: CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME);
Adding a column: ALTER TABLE [table] ADD COLUMN [column] VARCHAR(120);
Adding a column with an unique, auto-incrementing ID: ALTER TABLE [table] ADD COLUMN [column] int NOT NULL AUTO_INCREMENT PRIMARY KEY;
Inserting a record: INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]');
MySQL function for datetime input: NOW()
Selecting records: SELECT * FROM [table];
Explain records: EXPLAIN SELECT * FROM [table];
Selecting parts of records: SELECT [column], [another-column] FROM [table];
Counting records: SELECT COUNT([column]) FROM [table];
Counting and selecting grouped records: SELECT *, (SELECT COUNT([column]) FROM [table]) AS count FROM [table] GROUP BY [column];
Selecting specific records: SELECT * FROM [table] WHERE [column] = [value]; (Selectors: <>!=; combine multiple selectors with ANDOR)
Select records containing [value]SELECT * FROM [table] WHERE [column] LIKE '%[value]%';
Select records starting with [value]SELECT * FROM [table] WHERE [column] LIKE '[value]%';
Select records starting with val and ending with ueSELECT * FROM [table] WHERE [column] LIKE '[val_ue]';
Select a range: SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2];
Select with custom order and only limit: SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value];(Order: DESCASC)
Updating records: UPDATE [table] SET [column] = '[updated-value]' WHERE [column] = [value];
Deleting records: DELETE FROM [table] WHERE [column] = [value];
Delete all records from a table (without dropping the table itself): DELETE FROM [table]; (This also resets the incrementing counter for auto generated columns like an id column.)
Delete all records in a table: truncate table [table];
Removing table columns: ALTER TABLE [table] DROP COLUMN [column];
Deleting tables: DROP TABLE [table];
Deleting databases: DROP DATABASE [database];
Custom column output names: SELECT [column] AS [custom-column] FROM [table];
Export a database dump (more info here): mysqldump -u [username] -p [database] > db_backup.sql
Use --lock-tables=false option for locked tables (more info here).
Import a database dump (more info here): mysql -u [username] -p -h localhost [database] < db_backup.sql
Logout: exit;

Aggregate functions

Select but without duplicates: SELECT distinct name, email, acception FROM owners WHERE acception = 1 AND date >= 2015-01-01 00:00:00
Calculate total number of records: SELECT SUM([column]) FROM [table];
Count total number of [column] and group by [category-column]SELECT [category-column], SUM([column]) FROM [table] GROUP BY [category-column];
Get largest value in [column]SELECT MAX([column]) FROM [table];
Get smallest value: SELECT MIN([column]) FROM [table];
Get average value: SELECT AVG([column]) FROM [table];
Get rounded average value and group by [category-column]SELECT [category-column], ROUND(AVG([column]), 2) FROM [table] GROUP BY [category-column];

Multiple tables

Select from multiple tables: SELECT [table1].[column], [table1].[another-column], [table2].[column] FROM [table1], [table2];
Combine rows from different tables: SELECT * FROM [table1] INNER JOIN [table2] ON [table1].[column] = [table2].[column];
Combine rows from different tables but do not require the join condition: SELECT * FROM [table1] LEFT OUTER JOIN [table2] ON [table1].[column] = [table2].[column]; (The left table is the first table that appears in the statement.)
Rename column or table using an aliasSELECT [table1].[column] AS '[value]', [table2].[column] AS '[value]' FROM [table1], [table2];

Users functions

List all users: SELECT User,Host FROM mysql.user;
Create new user: CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
Grant ALL access to user for * tables: GRANT ALL ON database.* TO 'user'@'localhost';

Find out the IP Address of the Mysql Host

SHOW VARIABLES WHERE Variable_name = 'hostname';



Other ref: https://www.geeksforgeeks.org/sql-tutorial/

Example

The following code block is an example, which creates a CUSTOMERS table with an ID as a primary key and NOT NULL are the constraints showing that these fields cannot be NULL while creating records in this table −
SQL> CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),       
   PRIMARY KEY (ID)
);
You can verify if your table has been created successfully by looking at the message displayed by the SQL server, otherwise you can use the DESCcommand as follows −
SQL> DESC CUSTOMERS;
+---------+---------------+------+-----+---------+-------+
| Field   | Type          | Null | Key | Default | Extra |
+---------+---------------+------+-----+---------+-------+
| ID      | int(11)       | NO   | PRI |         |       |
| NAME    | varchar(20)   | NO   |     |         |       |
| AGE     | int(11)       | NO   |     |         |       |
| ADDRESS | char(25)      | YES  |     | NULL    |       |
| SALARY  | decimal(18,2) | YES  |     | NULL    |       |
+---------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
Now, you have CUSTOMERS table available in your database which you can use to store the required information related to customers.

Monday, 5 March 2018

Otomatis isi Pemilihan Paket dan Jadwal Ujian UAMBN BK 2018

Karena tahun ini perdana diadakan UAMBN-BK, maka fiturnya pun masih perlu penyempurnaan.
Gunakan saja fitur yang ada tahun ini.
Adapun biasanya yang sekolahnya memiliki banyak siswa, maka protek harus sabar mengisi data satu-persatu agar siswa tersebut bisa mengikuti Ujian.

Untuk meringankan sedikit beban kerja Protek, berikut tutorial Otomatis isi Pemilihan Paket dan Jadwal Ujian UAMBN BK 2018:
https://www.youtube.com/watch?v=YZSqrfEiGcA

Atau berikut yang menggunakan Looping atau pengulangan:
https://m.youtube.com/watch?v=PxYtqPzTUXg

Friday, 2 March 2018

Visual vcredist 2012 atau C++ Redistributable for Visual Studio 2012 Update 4

The Visual C++ Redistributable Packages install runtime components that are required to run C++ applications built with Visual Studio 2012.
Supported Operating System
Windows 7 Service Pack 1, Windows 8, Windows 8.1, Windows Server 2003, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, Windows Server 2012, Windows Vista Service Pack 2, Windows XP
    • 900 MHz or faster processor
    • 512 MB of RAM
    • 50 MB of available hard disk space
    • 5400 RPM hard drive
    • DirectX 9-capable video card running at 1024 x 768 or higher display resolution

Aplikasi (runtime ini) ini digunakan pada aplikasi UAMBN-BK 2018. yang mana biasanya muncul notifikasi atau pemberitahuan pada komputer client (siswa) sehingga siswa tidak bisa mengerjakan soal UAMnya.




Download di: https://drive.google.com/open?id=1j02pQpEXpYlZfxBEmR71XvJwJmBK8UN5

Sumber: https://www.microsoft.com/en-us/download/details.aspx?id=30679