Gecko [ elibrary.unsap.ac.id ]

Name	Size	Permission	Date
.git	[ DIR ]	drwxrwxrwx	2025-04-27 13:16
.well-known	[ DIR ]	drwxrwxrwx	2024-09-05 02:01
asset	[ DIR ]	drwxrwxrwx	2025-04-27 15:34
include	[ DIR ]	drwxrwxrwx	2025-04-20 13:23
resource	[ DIR ]	drwxrwxrwx	2025-04-21 15:02
save	[ DIR ]	drwxrwxrwx	2025-04-21 13:47
upload	[ DIR ]	drwxrwxrwx	2025-02-11 02:56
Backup_13_Jan_2025_1736756652.sql	0 B	-rw-rw-rw-	2025-04-20 13:22
README.md	1.52 KB	-rw-rw-rw-	2024-09-07 01:58
admin.php	6.35 KB	-rw-rw-rw-	2024-09-04 22:54
agenda_surat_keluar.php	17 KB	-rw-rw-rw-	2024-09-04 22:54
agenda_surat_masuk.php	17.09 KB	-rw-rw-rw-	2024-09-04 22:54
backup.php	9.09 KB	-rw-rw-rw-	2024-09-04 22:54
cetak_disposisi.php	12.88 KB	-rw-rw-rw-	2024-09-04 22:54
disposisi.php	11.53 KB	-rw-rw-rw-	2024-09-04 22:54
edit_disposisi.php	12.92 KB	-rw-rw-rw-	2024-09-04 22:54
edit_klasifikasi.php	9.94 KB	-rw-rw-rw-	2024-09-04 22:54
edit_surat_keluar.php	22.76 KB	-rw-rw-rw-	2024-09-04 22:54
edit_surat_masuk.php	23.54 KB	-rw-rw-rw-	2024-09-04 22:54
edit_tipe_user.php	8.92 KB	-rw-rw-rw-	2024-09-04 22:54
enable-javascript.html	3.4 KB	-rw-rw-rw-	2024-09-04 22:54
file_sk.php	10.32 KB	-rw-rw-rw-	2024-09-04 22:54
file_sm.php	10.61 KB	-rw-rw-rw-	2024-09-04 22:54
fti-aset.sql	37.22 KB	-rw-rw-rw-	2024-09-05 02:19
galeri_sk.php	17.88 KB	-rw-rw-rw-	2024-09-04 22:54
galeri_sm.php	17.91 KB	-rw-rw-rw-	2024-09-04 22:54
google3afbb06bed30a512.html	53 B	-rw-rw-rw-	2025-04-27 15:35
hapus_disposisi.php	4.86 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_klasifikasi.php	4.15 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_surat_keluar.php	6.94 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_surat_masuk.php	7.02 KB	-rw-rw-rw-	2024-09-04 22:54
hapus_user.php	5.49 KB	-rw-rw-rw-	2024-09-04 22:54
index.php	11.43 KB	-rw-rw-rw-	2024-09-04 22:54
kode.php	847 B	-rw-rw-rw-	2025-02-01 14:35
logout.php	92 B	-rw-rw-rw-	2024-09-04 22:54
pengaturan.php	25.78 KB	-rw-rw-rw-	2024-09-04 22:54
profil.php	15.59 KB	-rw-rw-rw-	2024-09-04 22:54
referensi.php	22.04 KB	-rw-rw-rw-	2024-09-04 22:54
restore.php	10.75 KB	-rw-rw-rw-	2024-09-04 22:54
robots.txt	323 B	-rw-rw-rw-	2025-04-27 15:41
surat-fti.sql	11.87 KB	-rw-rw-rw-	2024-09-05 02:17
tambah_disposisi.php	11.71 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_klasifikasi.php	9.83 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_surat_keluar.php	19.99 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_surat_masuk.php	21.77 KB	-rw-rw-rw-	2024-09-04 22:54
tambah_user.php	12.69 KB	-rw-rw-rw-	2024-09-04 22:54
transaksi_surat_keluar.php	25.79 KB	-rw-rw-rw-	2024-09-04 22:54
transaksi_surat_masuk.php	27.32 KB	-rw-rw-rw-	2024-09-04 22:54
upload_referensi.php	11.5 KB	-rw-rw-rw-	2024-09-04 22:54
user.php	10.28 KB	-rw-rw-rw-	2024-09-04 22:54
web.config	655 B	-rw-rw-rw-	2024-09-07 01:34

Rename

<?php
    //cek session
    if(empty($_SESSION['admin'])){

$_SESSION['err'] = '<strong>ERROR!</strong> Anda harus login terlebih dahulu.';
        header("Location: ./");
        die();
    } else {

if($_SESSION['admin'] != 1){
            echo '<script language="javascript">
                    window.alert("ERROR! Anda tidak memiliki hak akses untuk membuka halaman ini");
                    window.location.href="./logout.php";
                  </script>';
        } else {

echo '
                <div class="row">
                    
                    <div class="col s12">
                        <div class="z-depth-1">
                            <nav class="secondary-nav">
                                <div class="nav-wrapper blue-grey darken-1">
                                    <div class="col m12">
                                        <ul class="left">
                                            <li class="waves-effect waves-light"><a href="?page=sett&sub=rest" class="judul"><i class="material-icons">storage</i> Restore Database</a></li>
                                        </ul>
                                    </div>
                                </div>
                            </nav>
                        </div>
                    </div>
                    
                </div>
                ';

if(isset($_SESSION['errEmpty'])){
                    $errEmpty = $_SESSION['errEmpty'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card red lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errEmpty.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['errEmpty']);
                }
                if(isset($_SESSION['errFormat'])){
                    $errFormat = $_SESSION['errFormat'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card red lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errFormat.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['errFormat']);
                }
                if(isset($_SESSION['errUpload'])){
                    $errUpload = $_SESSION['errUpload'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card red lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title red-text"><i class="material-icons md-36">clear</i> '.$errUpload.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['errUpload']);
                }
                if(isset($_SESSION['succRestore'])){
                    $succRestore = $_SESSION['succRestore'];
                    echo '<div id="alert-message" class="row">
                            <div class="col m12">
                                <div class="card green lighten-5">
                                    <div class="card-content notif">
                                        <span class="card-title green-text"><i class="material-icons md-36">done</i> '.$succRestore.'</span>
                                    </div>
                                </div>
                            </div>
                        </div>';
                    unset($_SESSION['succRestore']);
                }

// proses restore database dilakukan oleh fungsi
                function restore($file){
                	global $rest_dir;

//konfigurasi database
                	$koneksi=mysqli_connect("localhost","root","","ams");

$nama_file	= $file['name'];
                	$ukrn_file	= $file['size'];
                	$tmp_file	= $file['tmp_name'];

if($nama_file == "" || $_REQUEST['password'] == ""){
                        $_SESSION['errEmpty'] = 'ERROR! Semua Form wajib diisi';
                        header("Location: ./admin.php?page=sett&sub=rest");
                        die();
                    } else {

$password = $_REQUEST['password'];
                        $id_user = $_SESSION['id_user'];

$query = mysqli_query($koneksi, "SELECT password FROM tbl_user WHERE id_user='$id_user' AND password=MD5('$password')");
                        if(mysqli_num_rows($query) > 0){

$alamatfile	= $rest_dir.$nama_file;
                    		$templine	= array();

$ekstensi = array('sql');
                            $nama_file	= $file['name'];
                            $x = explode('.', $nama_file);
                            $eks = strtolower(end($x));

//validasi tipe file
                            if(in_array($eks, $ekstensi) == true){

if(move_uploaded_file($tmp_file , $alamatfile)){

$templine	= '';
                        			$lines		= file($alamatfile);

foreach ($lines as $line){
                        				if(substr($line, 0, 2) == '--' || $line == '')
                        					continue;

$templine .= $line;

if(substr(trim($line), -1, 1) == ';'){
                        					mysqli_query($koneksi, $templine);
                        					$templine = '';
                        				}
                        			}
                                    $_SESSION['succRestore'] = 'SUKSES! Database berhasil direstore';
                                    header("Location: ./admin.php?page=sett&sub=rest");
                                    die();
                        		} else {
                                    $_SESSION['errUpload'] = 'ERROR! Proses upload database gagal';
                                    header("Location: ./admin.php?page=ref&act=imp");
                                    die();
                    		    }
                            } else {
                                $_SESSION['errFormat'] = 'ERROR! Format file yang diperbolehkan hanya *.SQL';
                                header("Location: ./admin.php?page=sett&sub=rest");
                                die();
                            }
                        } else {
                            echo '<script language="javascript">
                                    window.alert("ERROR! Password salah. Anda mungkin tidak memiliki akses ke halaman ini");
                                    window.location.href="./logout.php";
                                  </script>';
                        }
                	}
                }

//restore database
                if(isset($_POST['restore'])){

restore($_FILES['file']);

} else {
                    echo '

<div class="row">
                        <div class="col m12">
                            <div class="card">
                                <div class="card-content">
                                    <span class="card-title black-text">Restore Database</span>
                                    <p class="kata">Silakan pilih file database lalu klik tombol <strong>"Restore"</strong> untuk melakukan restore database dari hasil backup yang telah dibuat sebelumnya. Jika belum ada file database hasil backup, silakan lakukan backup terlebih dahulu melalui menu <strong><a class="blue-text" style="text-transform: capitalize;margin-right: 0;" href="?page=sett&sub=back">"Backup Database"</a>.</strong></p><br/>

<p class="kata"><span class="red-text"><i class="material-icons">error_outline</i> <strong>PERINGATAN!</strong></span><br/>Berhati - hatilah ketika merestore database karena data yang ada akan diganti dengan data yang baru. Pastikan bahwa file database yang akan digunakan untuk merestore adalah <strong>"benar - benar"</strong> file backup database yang telah dibuat sebelumnya sehingga sistem dapat berjalan dengan normal dan tidak mengalami error.</p>
                                </div>
                                <div class="card-action">
                                    <form method="post" enctype="multipart/form-data">
                                        <div class="file-field input-field col m6 tooltipped" data-position="top" data-tooltip="Format file database yang diperbolehkan hanya *.SQL">
                                            <div class="btn light-green darken-1">
                                                <span>File</span>
                                                <input type="file" name="file" accept=".sql" required>
                                            </div>
                                            <div class="file-path-wrapper">
                                                <input class="file-path validate" placeholder="Upload file backup database sql" type="text">
                                             </div>
                                        </div>
                                        <div class="input-field col s4 tooltipped" data-position="top" data-tooltip="Masukkan password Anda">
                                            <i class="material-icons prefix md-prefix">lock</i>
                                            <input id="password_lama" type="password" class="validate" name="password" required>
                                            <label for="password_lama">Password</label>
                                        </div>&nbsp;&nbsp;&nbsp;&nbsp;
                                        <button type="submit" class="btn-large blue waves-effect waves-light" name="restore">RESTORE <i class="material-icons">restore</i></button>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>';
                }
            }
        }
?>