//breadcrumb setting
$breadcrumbs[] = array("text" => "Kontak", "href" => AutoLink($link_source, "", "", "", "", ""));
$sql = "SELECT * FROM banner_detail WHERE id_banner='5'";
$ads_banner_side = RowData($sql, $conn);
$id_menu = 2;
$array_contak_info = RowMenu($id_menu, '0', $conn, $bhs_on, $link_source);
$sql = "SELECT * FROM main_menu WHERE id='{$id_menu}'";
$arraymenu_kontak = TampilData($sql, $conn);
$namamenu_kontak = $arraymenu_kontak['nama'];
$acakkode = acakangkahuruf(5);
if (isset($_POST['kontak'])) {
if (FormSet($_POST['kode']) == FormSet($_POST['kon-kode'])) {
$input_nama = FormSet($_POST['nama']);
$input_email = FormSet($_POST['email']);
$input_subjek = FormSet($_POST['subjek']);
$input_pesan = FormSet($_POST['pesan']);
$nama_pengguna = $input_nama;
$sql = "INSERT INTO kontak (tanggal, nama, email, subjek, pesan) VALUES ('{$tanggal}', '{$input_nama}','{$input_email}','{$input_subjek}', '{$input_pesan}')";
if ($conn->query($sql) === TRUE) {
$log_txt = "{$input_nama} mengisi form kontak\n";
LogSys($log_txt, "normal");
$email_to = $web_email;
$email_subject = $input_subjek;
$email_pesan = $input_pesan;
$email_from = "{$input_nama}<{$input_email}>";
$email_reply = $input_email;
KirimEmail($web_email, $email_subject, $email_pesan, $email_from, $email_reply);
$_SESSION['kalimat_status'] = "Pesan Anda berhasil dikirim, terima kasih";
header("Location: " . LINK_LANJUT . "status=berhasil");
}
} else {
/////////////////
$text_meta_title = "{$text_title} | {$web_title}";
if ($metadiskripsi) {
$text_meta_discription = $metadiskripsi;
}
if ($halaman["foto"] != "") {
$text_meta_foto = Thumbnail($halaman["foto"], 250);
}
$text_meta_keyword = $metakeyword;
//////////////////////////////////////////////
//////////////////////// form control
if ($logged) {
if (isset($_POST['update-data'])) {
foreach ($array_bahasa as $data_bhs) {
if ($data_bhs) {
$input_nama = FormSet($_POST['nama_' . $data_bhs['kode']]);
$input_diskripsi = FormSet($_POST['diskripsi_' . $data_bhs['kode']]);
$listnama[] = "nama_" . $data_bhs['kode'] . "='{$input_nama}', diskripsi_" . $data_bhs['kode'] . "='{$input_diskripsi}'";
}
}
$editkolom = implode(", ", $listnama);
$sql = "UPDATE kategori SET {$editkolom} WHERE id='{$idpostingan}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . LINK_LANJUT . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Gagal";
header("Location: " . LINK_LANJUT . "status=gagal");
}
}
}
$input_level = FormSet($_POST['level']);
$input_status = FormSet($_POST['status']);
$input_foto = FormSet($_POST['foto']);
$sql = "UPDATE user SET email='{$input_email}', nama='{$input_nama}', level='{$input_level}', status='{$input_status}', foto='{$input_foto}' WHERE id='{$idpost}'";
if ($conn->query($sql) === TRUE) {
$log_txt = "{$nama_pengguna} Update User id={$idpost} nama='{$input_nama}'\n";
LogSys($log_txt, "normal");
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . LINK_LANJUT . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Gagal";
header("Location: " . LINK_LANJUT . "status=gagal");
}
}
if (isset($_POST['delete-user'])) {
if ($id_pengguna != $id_user) {
$sql = "DELETE FROM user WHERE id='{$idpost}'";
if ($conn->query($sql) === TRUE) {
$log_txt = "{$nama_pengguna} menghapus User id={$idpost} nama='" . FormSet($_POST['nama']) . "'\n";
LogSys($log_txt, "delete");
$_SESSION['kalimat_status'] = "Delete user berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Delete Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=gagal");
}
} else {
$_SESSION['kalimat_status'] = "Anda Tidak dapat menghapus diri anda sendiri";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=gagal");
}
}
}
if (isset($_POST['direktori' . $sa])) {
delete_files($_POST['direktori' . $sa]);
}
}
}
}
$_SESSION['kalimat_status'] = "Delete File berhasil";
header("Location: " . $link_form_eksekusi_berhasil);
}
if (isset($_POST['buat-folder'])) {
if ($_POST['folder-baru'] == "") {
$_POST['folder-baru'] = "NewFolder";
}
$namafolderbaru = linkbersih($_POST['folder-baru']);
$folder_baru = $dir_images . FormSet($namafolderbaru);
if (!file_exists($folder_baru)) {
mkdir($folder_baru);
$log_txt = "{$nama_pengguna} membuat folder photo <strong>'{$namafolderbaru}'</strong>\n";
LogSys($log_txt, "normal");
$_SESSION['kalimat_status'] = "Buat Folder berhasil";
header("Location: " . $link_form_eksekusi_berhasil);
} else {
$_SESSION['kalimat_status'] = "Buat Folder berhasil";
header("Location: " . $link_form_eksekusi_gagal);
}
}
if (isset($_POST['clear-cache'])) {
$array_images = ArrayDir('cache/');
if ($array_images) {
foreach ($array_images as $data_gbr) {
<?php
//$array_level User
$array_level[] = array("text" => "Admin", "value" => "admin");
$array_level[] = array("text" => "Klien", "value" => "klien");
$array_level[] = array("text" => "Subscriber", "value" => "subscriber");
$array_level[] = array("text" => "Webmaster", "value" => "webmaster");
if (isset($_GET['f']) && $_GET['f'] != "") {
$_SESSION['history'] = $_GET['f'];
}
//login
if (isset($_POST['tombol-login'])) {
$inputusername = FormSet($_POST['email']);
$inputpassword = md5($_POST['password']);
$sql = "SELECT * FROM user WHERE email='{$inputusername}' AND password='******' AND status='AKTIF'";
$loginuser = TampilData($sql, $conn);
if ($loginuser) {
$loginStrGroup = $loginuser['level'];
$loginUsername = $loginuser['email'];
$_SESSION['id'] = $loginuser['id'];
$_SESSION['emailpengguna'] = $inputusername;
$_SESSION['levelpengguna'] = $loginStrGroup;
$go_to = $webURL;
if ($_SESSION['history'] != "") {
$go_to = $_SESSION['history'];
}
header("Location: " . $go_to);
} else {
$_SESSION['kalimat_status'] = "Password dan Email tidak cocok! ";
header("Location: " . LINK_LANJUT . "status=berhasil");
}
$input_isi = FormSet($_POST['isi_' . $data_bhs['kode']]);
$colom[] = "judul_" . $data_bhs['kode'] . ", isi_" . $data_bhs['kode'];
$value[] = "'{$input_judul}', '{$input_isi}'";
}
}
if ($_POST['seo'] == "") {
$_POST['seo'] = $_POST['judul_' . $bhs_on];
}
$input_seo = input_seo($_POST['seo'], "post", $conn);
$input_type = FormSet($_POST['type']);
$input_status = FormSet($_POST['save-data']);
$input_metakeyword = FormSet($_POST['metakeyword']);
$input_metadiskripsi = FormSet($_POST['metadiskripsi']);
$input_oleh = $id_pengguna;
$input_foto = FormSet($_POST['foto']);
$input_tags = FormSet($_POST['tags']);
$new_kolom = ", " . implode(", ", $colom);
$new_value = ", " . implode(", ", $value);
$sql = "INSERT INTO post (seo, metakeyword, metadiskripsi, type, oleh, foto, status, tags {$new_kolom}) VALUES ('{$input_seo}', '{$input_metakeyword}', '{$input_metadiskripsi}', '{$input_type}','{$input_oleh}', '{$input_foto}', '{$input_status}','{$input_tags}' {$new_value})";
//input id post
if ($conn->query($sql) === TRUE) {
$id_terakhir = $conn->insert_id;
}
$log_txt = "{$nama_pengguna} Entry Posting id={$id_terakhir} '{$input_judul}'\n";
LogSys($log_txt, "normal");
//cari idinput_post
$a = 0;
$input_kategori = "";
foreach ($array_kategori_form as $data) {
if ($data) {
$a++;
$ads_banner_side = RowData($sql, $conn);
$id_menu = 5;
$array_contak_info = RowMenu($id_menu, '0', $conn, $bhs_on, $link_source);
$sql = "SELECT * FROM main_menu WHERE id='{$id_menu}'";
$arraymenu_kontak = TampilData($sql, $conn);
$namamenu_kontak = $arraymenu_kontak['nama'];
if ($logged) {
$_SESSION['bolehdownload'] = $TargetForm;
}
if (isset($_POST['kontak'])) {
$input_nama = FormSet($_POST['nama']);
$input_email = FormSet($_POST['email']);
$input_subjek = FormSet($_POST['subjek']);
$input_pesan = FormSet($_POST['pesan']);
$code = FormSet($_POST['kode']);
$konfirmcode = FormSet($_POST['kon-kode']);
$nama_pengguna = $input_nama;
if ($code == $konfirmcode) {
$sql = "INSERT INTO kontak (tanggal, nama, email, subjek, pesan) VALUES ('{$tanggal}', '{$input_nama}','{$input_email}','{$input_subjek}', '{$input_pesan}')";
if ($conn->query($sql) === TRUE) {
$_SESSION['bolehdownload'] = $TargetForm;
$dari = "{$input_nama}<{$input_email} >";
KirimEmail($web_email, $input_subjek, $input_pesan, $dari, $input_email);
$log_txt = "{$input_nama} Entri kontak \n";
LogSys($log_txt, "normal");
} else {
$_SESSION['kalimat_status'] = $text_nokontak;
header("Location: " . LINK_LANJUT . "status=gagal");
}
} else {
$_SESSION['kalimat_status'] = $text_nokontak . $kodetidakcocok;
$sql = "UPDATE banner SET nama='{$namabanner}' WHERE id='{$idpost}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update Banner Berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Banner Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=gagal");
}
}
if (isset($_POST['edit-slide-banner'])) {
foreach ($array_bahasa as $data_bhs) {
if ($data_bhs) {
$input_update[] = "caption_" . $data_bhs['kode'] . "='" . FormSet($_POST['caption_' . $data_bhs['kode']]) . "'";
}
}
$input_update[] = "urutan='" . FormSet($_POST['urutan']) . "'";
$input_update[] = "link='" . FormSet($_POST['link']) . "'";
$input_update[] = "src='" . FormSet($_POST['src']) . "'";
$input_update[] = "lebar='" . FormSet($_POST['lebar']) . "'";
$input_update[] = "tinggi='" . FormSet($_POST['tinggi']) . "'";
$id_slide = FormSet($_POST['id']);
$editkolom = implode(", ", $input_update);
$sql = "UPDATE banner_detail SET {$editkolom} WHERE id='{$id_slide}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update Banner Berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Banner Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=gagal");
}
}
function input_seo($input, $table, $conn)
{
$sql = "SELECT seo FROM {$table} ORDER BY seo ASC";
$seo_link = RowData($sql, $conn);
foreach ($seo_link as $data) {
$array_seo[] = $data['seo'];
}
$input_seo = FormSet(linkbersih($input));
if ($input_seo == "") {
$input_seo = "posting";
}
if (in_array($input_seo, $array_seo)) {
foreach ($array_seo as $data) {
if ($data == $input_seo) {
$dataseoyangada[] = $data;
}
}
}
if (count($dataseoyangada) >= 1) {
$jumlah_seo = acakhuruf(5);
$jumlah_seo .= "-";
}
$input_seo = $input_seo . $jumlah_seo;
return $input_seo;
}
}
$input_seo = FormSet(linkbersih($_POST['seo']));
if (in_array($input_seo, $array_seo)) {
$jumlah_seo = 0;
foreach ($array_seo as $data) {
if ($data == $input_seo) {
$jumlah_seo++;
$jumlah_seo = "-" . $jumlah_seo + 1;
}
}
}
$input_seo = $input_seo . $jumlah_seo;
$input_type = FormSet($_POST['type']);
$input_link_status = FormSet($_POST['link_status']);
$input_top = FormSet($_POST['top']);
$input_parent = FormSet($_POST['parent']);
$new_kolom = ", " . implode(", ", $colom);
$new_value = ", " . implode(", ", $value);
$sql = "INSERT INTO kategori (seo, type, parent, link_status, top {$new_kolom}) VALUES ('{$input_seo}','{$input_type}','{$input_parent}', '{$input_link_status}', '{$input_top}' {$new_value})";
if ($conn->query($sql) === TRUE) {
$id_terakhir = $conn->insert_id;
$log_txt = "{$nama_pengguna} Entry Kategori id={$id_terakhir} '{$input_nama}'\n";
LogSys($log_txt, "normal");
$_SESSION['kalimat_status'] = "Entry berhasil";
header("Location: " . LINK_LANJUT . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Entry Data Gagal";
header("Location: " . LINK_LANJUT . "status=gagal");
}
}
//end new (save)
$sql = "SELECT * FROM kontak {$filter_data} ORDER BY id DESC";
$array_report = RowData($sql, $conn);
$total_inquery = count($array_report);
} else {
$detailview = true;
$sql = "SELECT * FROM kontak WHERE id='{$idpost}' ORDER BY id DESC";
$detail_report = TampilData($sql, $conn);
}
if (isset($_POST['delete-data'])) {
$sql = "DELETE FROM kontak WHERE id='{$idpost}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Delete berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Delete Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=gagal");
}
}
if (isset($_POST['update-data'])) {
$tanggal_inquery = FormSet($_POST['tanggal']);
$dari_inquery = FormSet($_POST['dari']);
$isi_inquery = FormSet($_POST['isi']);
$sql = "UPDATE kontak SET tanggal='{$tanggal_inquery}', nama='{$dari_inquery}', pesan='{$isi_inquery}' WHERE id='{$idpost}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . LINK_LANJUT . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Gagal";
header("Location: " . LINK_LANJUT . "status=gagal");
}
}
$conn->query($sql);
$log_txt = "{$nama_pengguna} Upload File <strong>'{$nama_file}'</strong>\n";
LogSys($log_txt, "normal");
$_SESSION['kalimat_status'] = "Upload File berhasil";
header("Location: " . LINK_LANJUT . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "ERROR: error tidak diketahui";
header("Location: " . LINK_LANJUT . "status=gagal");
}
}
}
if (isset($_POST['edit-file'])) {
$nama_file = $diskripsi_file = "";
$nama_file = FormSet($_POST['nama']);
$password_file = FormSet($_POST['password']);
$diskripsi_file = FormSet($_POST['diskripsi']);
$statusganti = ",file tidak diganti";
if ($_FILES["file"]["name"]) {
$DotType_file = strtolower(pathinfo($_FILES['file']['name'], PATHINFO_EXTENSION));
$target_file = DIR_FILE . $today . "_" . linkbersih($_FILES['file']['name']);
$ContentType_file = $_FILES['file']['type'];
$size_file = $_FILES['file']['size'];
$src_file = $link_source . $target_file;
$array_DotType = $alow_type_file;
$uploadstatus = 1;
$error_status = false;
//cek tipe
if (!in_array($DotType_file, $array_DotType)) {
$uploadstatus = 0;
$error_status[] = "Type {$DotType_file} tidak di izinkan untuk di upload";
}
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=gagal");
}
}
if (isset($_POST['delete-mainmenu'])) {
$idmenu = FormSet($_POST['id-menu']);
$sql = "DELETE FROM menu WHERE id_menu='{$idmenu}'";
$conn->query($sql);
$sql = "DELETE FROM main_menu WHERE id='{$idmenu}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Delete Slide Berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Delete Slide Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . $hub . "status=gagal");
}
}
if (isset($_POST['edit-mainmenu'])) {
$namamenu = FormSet($_POST['nama-menu']);
$sql = "UPDATE main_menu SET nama='{$namamenu}' WHERE id='{$idpost}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update Banner Berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=berhasil");
} else {
$_SESSION['kalimat_status'] = "Update Banner Gagal";
header("Location: " . AutoLink($link_source, $route, $menu, $idpost, "", "") . $hub . "status=gagal");
}
}
foreach ($array_websett as $data_input) {
$namasettingan = $data_input['setting'];
$result_value = FormSet($_POST["{$namasettingan}"]);
$sql = "UPDATE setting SET value='{$result_value}' WHERE setting='{$namasettingan}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . "&status=berhasil");
}
}
}
if (isset($_POST['edit-setting'])) {
$sort_set = FormSet($_POST['sort']);
$nama_set = FormSet($_POST['nama']);
$setting_set = FormSet($_POST['setting']);
$type_set = FormSet($_POST['type']);
$sql = "UPDATE setting SET nama='{$nama_set}',setting='{$setting_set}', type='{$type_set}' WHERE sort='{$sort_set}'";
if ($conn->query($sql) === TRUE) {
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . AutoLink($link_source, $route, $menu, "", "", "") . "&status=berhasil");
}
}
if (isset($_POST['tambah-setting'])) {
$nama = FormSet($_POST["nama"]);
$setting = FormSet($_POST["setting"]);
$value = FormSet($_POST["value"]);
$type = FormSet($_POST["type"]);
$sql = "INSERT INTO setting (nama, setting, value, type) VALUES ('{$nama}', '{$setting}', '{$value}', '{$type}')";
$conn->query($sql);
$_SESSION['kalimat_status'] = "Update berhasil";
header("Location: " . LINK_LANJUT . "status=berhasil");
}
