<?php
if ($logged) {
$sql = "SELECT * FROM post WHERE status = 'PUBLISH' ORDER BY id";
// sesuaikan dengan tabel artikel Anda
$array_post = RowData($sql, $conn);
$xml = '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
if ($array_post) {
foreach ($array_post as $data) {
$xml .= '<url>
<loc>' . $link_source . 'page/post/' . $data['seo'] . '</loc>
<lastmod>' . $data['tanggal'] . '</lastmod>
<changefreq>daily</changefreq>
<priority>0.8</priority>
</url>';
}
}
$xml .= '</urlset>';
$a = fopen('sitemap.xml', "w");
fputs($a, $xml);
fclose($a);
}
session_start();
}
//pemanggil season bahasa
if (isset($_GET['bahasa']) && $_GET['bahasa'] != "") {
$_SESSION['bhs'] = $_GET['bahasa'];
header("Location: " . $_SERVER['HTTP_REFERER']);
}
//load data dari folder bahsa berdasarkan settingan default
if (isset($_SESSION['bhs']) && $_SESSION['bhs'] != "") {
$bhs_on = $_SESSION['bhs'];
} else {
$bhs_on = WEB_SETTING("bahasa", $conn);
}
$sql = "SELECT * FROM bahasa WHERE kode='{$bhs_on}'";
$set_bhs = TampilData($sql, $conn);
//load database
//load file bahasa
require_once DIR_BAHASA . $set_bhs['namafile'];
//load file di folder berdasarkan $route
//jika $route terisi dan nilai $route terdapat dalam array controller maka load file dalam controller
if (isset($route) && $route != "" && in_array($route . ".php", ArrayDir(DIR_BAHASA . $set_bhs['folder'] . "/"))) {
Load(DIR_BAHASA . $set_bhs['folder'] . "/" . $route . ".php");
} else {
//jika $route tidak di isi maka yang di load adalah home dan home harus ada di array controller
Load(DIR_BAHASA . $set_bhs['folder'] . "/" . "home.php");
}
//Bahasa pada header
$sql = "SELECT * FROM bahasa WHERE status = '1'";
$array_bahasa = RowData($sql, $conn);
$text_bahasa = $set_bhs['nama'];
define("BHS_ON", $bhs_on);
<?php
// tittle
$text_meta_title = "Kontak | " . $text_meta_title;
///keyword tanpa host
//image
// deskripsi
//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;
<?php
$text_meta_discription = $web_discription;
$sql = "SELECT post.judul_" . $bhs_on . " as nama, post.isi_" . $bhs_on . " as diskripsi, post.seo, post.foto FROM post WHERE status='PUBLISH' ORDER BY post.id DESC LIMIT 0, 10";
$array_post_child = RowData($sql, $conn);
//profile
$sql = "SELECT judul_{$bhs_on} as judul, isi_{$bhs_on} as profile FROM post WHERE seo = 'profile'";
$viewprofile = TampilData($sql, $conn);
$text_profile = $viewprofile['judul'];
$text_profile_discription = $viewprofile['profile'];
//banner
$sql = "SELECT * FROM banner_detail WHERE id_banner = '1'";
$homebanner = RowData($sql, $conn);
//skill
$sql = "SELECT judul_{$bhs_on} as judul, isi_{$bhs_on} as skill FROM post WHERE seo = 'my-skill'";
$viewskill = TampilData($sql, $conn);
$text_skill = $viewskill['judul'];
$text_skill_isi = $viewskill['skill'];
if ($halaman["metadiskripsi"]) {
$metadiskripsi = $halaman["metadiskripsi"];
} else {
$metadiskripsi = $isi_post;
}
$metakeyword = $halaman["metakeyword"];
$sql = "SELECT kategori_post.id_post, post.judul_" . $bhs_on . " as nama, post.isi_" . $bhs_on . " as diskripsi, post.seo, post.foto, post.tanggal FROM kategori_post INNER JOIN post ON kategori_post.id_post=post.id WHERE kategori_post.id_kategori='{$kategoriakhir}' AND post.id!='{$idpostingan}' AND post.status='PUBLISH' ORDER BY post.id DESC LIMIT 0, 10";
$array_terkait = RowData($sql, $conn);
if ($halaman["foto"]) {
$text_meta_foto = $halaman["foto"];
}
//breadcrumb setting
$breadcrumbs[] = array("text" => $halaman["judul_{$bhs_on}"], "href" => AutoLink($link_source, $route, $menu, $halaman['seo'], "", ""));
///////////// relasi setting
$sql = "SELECT relasi.id_relasi as id, post.judul_{$bhs_on} as nama, post.foto, post.isi_{$bhs_on} as diskripsi, post.seo FROM relasi INNER JOIN post ON relasi.id_relasi=post.id WHERE id_post='" . $halaman['id'] . "'";
$data_datarelasi = RowData($sql, $conn);
}
/////////////////
$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) {
<?php
//breadcrumb setting
$breadcrumbs[] = array("text" => "User Setting", "href" => "#");
$link_filter = AutoLink($link_source, $route, $menu, $idpost, $judulpost, $aksi) . $hub;
if ($idpost == "" || $idpost == $querystring) {
$detailuser = false;
$query_pencarian = "";
if (isset($_GET['nama']) && $_GET['nama'] != "") {
$query_pencarian = "WHERE nama LIKE '%" . FormSet($_GET['nama']) . "%'";
}
if (isset($_GET['filter_bylevel']) && $_GET['filter_bylevel'] != "") {
$query_pencarian = "WHERE level ='" . FormSet($_GET['filter_bylevel']) . "'";
}
$sql = "SELECT * FROM user {$query_pencarian} ORDER BY nama ASC";
$array_user = RowData($sql, $conn);
} else {
$detailuser = true;
$sql = "SELECT * FROM user WHERE id='{$idpost}'";
$tampiluser = TampilData($sql, $conn);
$nama_user = $tampiluser["nama"];
$id_user = $tampiluser["id"];
$email_user = $tampiluser["email"];
$level_user = $tampiluser["level"];
$status_user = $tampiluser["status"];
$foto_user = $tampiluser["foto"];
}
if (isset($_POST['add-data'])) {
$input_email = FormSet($_POST['email']);
$input_nama = FormSet($_POST['nama']);
$input_level = FormSet($_POST['level']);
<?php
$detailbanner = true;
$sql = "SELECT * FROM banner ORDER BY nama ASC";
$array_banner = RowData($sql, $conn);
if ($idpost == "" || $idpost == $querystring) {
$detailbanner = false;
} else {
$sql = "SELECT * FROM banner_detail WHERE id_banner='{$idpost}' ORDER BY urutan ASC";
$listbanner = RowData($sql, $conn);
$sql = "SELECT * FROM banner WHERE id='{$idpost}'";
$nama_banner = TampilData($sql, $conn);
}
if (isset($_POST['add-banner'])) {
$namabanner = FormSet($_POST['nama']);
$sql = "INSERT INTO banner (nama) VALUES ('{$namabanner}')";
if ($conn->query($sql) === true) {
$_SESSION['kalimat_status'] = "Silahkan Masukan Slide Banner Anda";
header("Location: " . LINK_LANJUT . "idpost=" . IdTerakhir($conn) . "&status=berhasil");
} else {
$_SESSION['kalimat_status'] = "GAGAL: error tidak diketahui";
header("Location: " . LINK_LANJUT . "status=gagal");
}
}
if (isset($_POST['add-slide-banner'])) {
foreach ($array_bahasa as $data_bhs) {
if ($data_bhs) {
$colom[] = "caption_" . $data_bhs['kode'];
$value[] = "'" . FormSet($_POST['caption_' . $data_bhs['kode']]) . "'";
}
}
function RootKategori($id, $bhs_on, $conn)
{
$sql = "SELECT kategori_post.id_kategori, kategori.id, kategori.parent, kategori.seo, kategori.nama_{$bhs_on} as nama FROM kategori_post INNER JOIN kategori ON kategori_post.id_kategori = kategori.id WHERE kategori_post.id_post='{$id}'";
$array_kategori = RowData($sql, $conn);
if ($array_kategori) {
foreach ($array_kategori as $data) {
if ($data) {
$kat_teratas = "";
if ($data['parent'] > 0) {
//array menu kiri
$sql = "SELECT * FROM kategori WHERE id='" . $data['parent'] . "'";
$first_child = TampilData($sql, $conn);
$kat_teratas = $first_child['seo'];
if ($first_child['parent'] > 0) {
//array menu kiri
$sql = "SELECT * FROM kategori WHERE id='" . $first_child['parent'] . "'";
$second_child = TampilData($sql, $conn);
$kat_teratas = $second_child['seo'];
if ($second_child['parent'] > 0) {
//array menu kiri
$sql = "SELECT * FROM kategori WHERE id='" . $second_child['parent'] . "'";
$third_child = TampilData($sql, $conn);
$kat_teratas = $third_child['seo'];
if ($third_child['parent'] > 0) {
//array menu kiri
$sql = "SELECT * FROM kategori WHERE id='" . $third_child['parent'] . "'";
$four_child = TampilData($sql, $conn);
$kat_teratas = $four_child['seo'];
}
}
}
}
///batas pertama
$iddata[] = array("id" => $data['id_kategori'], "text" => $data['nama'], "parent" => $data['parent'], "seo" => $data['seo'], "induk" => $kat_teratas);
}
}
} else {
$iddata = false;
}
return $iddata;
}
$seo_link = RowData($sql, $conn);
if ($seo_link) {
foreach ($seo_link as $data) {
$array_seo[] = $data['seo'];
}
}
if ($idpost == "" || $idpost == $querystring) {
$sql = "SELECT * FROM kategori WHERE {$sql_filter} ORDER BY nama_" . $bhs_on . ", parent ASC";
$array_kategori = RowData($sql, $conn);
$view_detail = false;
} else {
$sql = "SELECT * FROM kategori WHERE id = '{$idpost}' ";
$halaman = TampilData($sql, $conn);
$nama_kategori = $halaman['nama_' . $bhs_on];
$sql = "SELECT * FROM kategori ORDER BY parent, nama_" . $bhs_on . " ASC";
$array_kategori = RowData($sql, $conn);
$view_detail = true;
if (isset($_POST['update-data'])) {
if ($_POST['seo'] == "") {
$_POST['seo'] = "Posting";
}
$update_seo = FormSet(linkbersih($_POST['seo']));
if (in_array($update_seo, $array_seo)) {
$jumlah_seo = false;
foreach ($array_seo as $data) {
if ($data == $update_seo && $halaman['seo'] != $update_seo) {
$jumlah_seo = $idpost;
}
}
}
$update_seo = $update_seo . $jumlah_seo;
echo "Anda harus login";
}
$id_pengguna = $_SESSION['id'];
if ($id_pengguna) {
include '../../config.php';
}
include '../data/class.php';
include '../data/fungsi.php';
include '../data/dataweb.php';
include '../setting/url.php';
$filternama = "";
if (isset($_GET['namafile']) && $_GET['namafile'] != "") {
$filternama = "WHERE nama LIKE '%" . $_GET['namafile'] . "%'";
}
$sql = "SELECT * FROM filemanager {$filternama} ORDER BY nama ASC";
$array_file = RowData($sql, $conn);
?>
<script>
$(document).ready(function() {
$('.galeri-box>.container-box>.close').click(function() {
$('.galeri-area').removeAttr('data-control');
$('.galeri-area .galeri-box').remove();
$('.galeri-area script').remove();
});
$('.galeri-box .close').click(function() {
var target_close = $(this).attr('data-toggle');
$(target_close).toggle();
});
$('#btn-filternamafile').click(function() {
var NamaFile = $('#filternamafile').val();
$('.galeri-area').load('website/ajax/filemanager.php?namafile='+NamaFile);
if (isset($_GET['filter'])) {
if (isset($_GET['dari']) && $_GET['dari'] != "") {
$Array_Filter[] = " nama LIKE '%" . $_GET['dari'] . "%'";
}
if (isset($_GET['mulai']) && $_GET['mulai'] != "" && (isset($_GET['hingga']) && $_GET['hingga'] != "")) {
$Array_Filter[] = " tanggal >= '" . $_GET['mulai'] . "' AND tanggal <= '" . $_GET['hingga'] . "'";
}
if (isset($_GET['about']) && $_GET['about'] != "") {
$Array_Filter[] = " tentang='" . $_GET['about'] . "'";
}
if (isset($Array_Filter)) {
$filter_data = "WHERE " . implode(" AND ", $Array_Filter);
}
}
$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");
}
$detailmenu = true;
$array_menu_form = RowMenu($idpost, 0, $conn, $bhs_on, $link_source);
$sql = "SELECT * FROM menu WHERE id_menu='{$idpost}' AND parent='0' ORDER BY urutan ASC";
$array_semuamenu = RowData($sql, $conn);
if ($array_semuamenu) {
foreach ($array_semuamenu as $semuamenu) {
if ($semuamenu) {
$menuparent[] = array("id" => $semuamenu['id'], "text" => TextMenu($semuamenu['route'], $semuamenu['menu'], $semuamenu['idpost'], $conn, $bhs_on));
$sql = "SELECT * FROM menu WHERE id_menu='{$idpost}' AND parent='" . $semuamenu['id'] . "' ORDER BY urutan ASC";
$array_semuamenu_2 = RowData($sql, $conn);
if ($array_semuamenu_2) {
foreach ($array_semuamenu_2 as $semuamenu_2) {
if ($semuamenu_2) {
$menuparent[] = array("id" => $semuamenu_2['id'], "text" => TextMenu($semuamenu['route'], $semuamenu['menu'], $semuamenu['idpost'], $conn, $bhs_on) . " > " . TextMenu($semuamenu_2['route'], $semuamenu_2['menu'], $semuamenu_2['idpost'], $conn, $bhs_on));
$sql = "SELECT * FROM menu WHERE id_menu='{$idpost}' AND parent='" . $semuamenu_2['id'] . "' ORDER BY urutan ASC";
$array_semuamenu_3 = RowData($sql, $conn);
if ($array_semuamenu_3) {
foreach ($array_semuamenu_3 as $semuamenu_3) {
if ($semuamenu_3) {
$menuparent[] = array("id" => $semuamenu_3['id'], "text" => TextMenu($semuamenu['route'], $semuamenu['menu'], $semuamenu['idpost'], $conn, $bhs_on) . " > " . TextMenu($semuamenu_2['route'], $semuamenu_2['menu'], $semuamenu_2['idpost'], $conn, $bhs_on) . " > " . TextMenu($semuamenu_3['route'], $semuamenu_3['menu'], $semuamenu_3['idpost'], $conn, $bhs_on));
}
}
}
}
}
}
}
}
}
$sql = "SELECT * FROM main_menu WHERE id='{$idpost}'";
$nama_menu = TampilData($sql, $conn);
<?php
///////////////////////////
$sql = "SELECT * FROM setting ORDER BY sort ASC";
$array_websett = RowData($sql, $conn);
$opt_theme = ArrayDir(DIR_THEMES);
$sql = "SELECT * FROM bahasa ORDER BY nama";
$opt_bahasa = RowData($sql, $conn);
//breadcrumb setting
$breadcrumbs[] = array("text" => "General Setting", "href" => "#");
if (isset($_POST['btnsetting'])) {
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");
}
