$limit = "LIMIT {$start} , {$paging}";
}
//$sql = "SELECT * FROM ".$app['table']['page']." $where $sort $limit";
$sql = "SELECT a.id, a.id_bahasa, a.nama, a.alamat, a.htm, b.username FROM " . $app['table']["destinasi_bahasa"] . " a LEFT JOIN " . $app['table']["pengguna"] . " b ON(a.id_user=b.id) {$where} {$sort} {$limit}";
//echo $sql;exit;
$dbu->query($sql, $rsbrowse, $nr_browse);
include "tmp_browse.php";
exit;
}
/*******************************************************************************
* Action : del
*******************************************************************************/
if ($act == "delete") {
$admlib->validate('tour_del');
if (!empty($_REQUEST[item])) {
$sql = "DELETE FROM " . $app['table']["destinasi_bahasa"] . " WHERE `id` IN (" . $admlib->item_delete($_REQUEST[item]) . ")";
$dbu->qry($sql);
$_SESSION['msg'] = "data destinasi_bahasa yang terpilih berhasil dihapus ....";
$_SESSION['alt'] = "danger";
header("location: " . $urlx->get_referer());
}
exit;
}
/*******************************************************************************
* Action : single delete
*******************************************************************************/
if ($act == "s_delete") {
//print_r($_REQUEST);exit;
if (!empty($p_id)) {
$sql = "DELETE FROM " . $app['table']["destinasi_bahasa"] . " WHERE id = '" . $p_id . "'";
//echo $sql;exit;
if ($paging > 0) {
$limit = "LIMIT {$start} , {$paging}";
}
//$sql = "SELECT * FROM ".$app['table']['page']." $where $sort $limit";
$sql = "SELECT a.*, b.bahasa as bahasa FROM " . $app['table']["konfig_bahasa"] . " a LEFT JOIN " . $app['table']["bahasa"] . " b ON(a.id_bahasa=b.id) {$where} {$sort} {$limit}";
//echo $sql;exit;
$dbu->query($sql, $rsbrowse, $nr_browse);
include "tmp_browse.php";
exit;
}
/*******************************************************************************
* Action : del
*******************************************************************************/
if ($act == "delete") {
if (!empty($_REQUEST[item])) {
$sql = "DELETE FROM " . $app['table']["provinsi"] . " WHERE `id` IN (" . $admlib->item_delete($_REQUEST[item]) . ")";
$dbu->qry($sql);
$_SESSION['msg'] = "data action yang terpilih berhasil dihapus ....";
$_SESSION['alt'] = "danger";
header("location: " . $urlx->get_referer());
}
exit;
}
/*******************************************************************************
* Action : single delete
*******************************************************************************/
if ($act == "s_delete") {
//print_r($_REQUEST);exit;
if (!empty($p_id)) {
$sql = "DELETE FROM " . $app['table']["provinsi"] . " WHERE id = '" . $p_id . "'";
//echo $sql;exit;
if ($paging > 0) {
$limit = "LIMIT {$start} , {$paging}";
}
//$sql = "SELECT * FROM ".$app['table']['page']." $where $sort $limit";
$sql = "SELECT a.*, b.bahasa as bahasa FROM " . $app['table']["berita_kategori"] . " a LEFT JOIN " . $app['table']["bahasa"] . " b ON(a.id_bahasa=b.id) {$where} {$sort} {$limit}";
//echo $sql;exit;
$dbu->query($sql, $rsbrowse, $nr_browse);
include "tmp_browse.php";
exit;
}
/*******************************************************************************
* Action : del
*******************************************************************************/
if ($act == "delete") {
if (!empty($_REQUEST[item])) {
$sql = "DELETE FROM " . $app['table']["berita_kategori"] . " WHERE `id` IN (" . $admlib->item_delete($_REQUEST[item]) . ")";
$dbu->qry($sql);
$_SESSION['msg'] = "data kategori destinasi yang terpilih berhasil dihapus ....";
$_SESSION['alt'] = "danger";
header("location: " . $urlx->get_referer());
}
exit;
}
/*******************************************************************************
* Action : single delete
*******************************************************************************/
if ($act == "s_delete") {
//print_r($_REQUEST);exit;
if (!empty($p_id)) {
$sql = "DELETE FROM " . $app['table']["berita_kategori"] . " WHERE id = '" . $p_id . "'";
//echo $sql;exit;
if ($paging > 0) {
$limit = "LIMIT {$start} , {$paging}";
}
//$sql = "SELECT * FROM ".$app['table']['page']." $where $sort $limit";
$sql = "SELECT a.id as id, c.kategori as kategori, b.status as status, b.hit as hit, a.judul as judul, d.username as uname, c.id_bahasa as idbahasa FROM " . $app['table']["berita_bahasa"] . " a join " . $app['table']["berita"] . " b on a.id_berita=b.id join " . $app['table']["berita_kategori"] . " c on c.id=b.id_kat JOIN " . $app['table']["pengguna"] . " as d ON (d.id = b.id_user) {$where} {$sort} {$limit}";
//echo $sql;exit;
$dbu->query($sql, $rsbrowse, $nr_browse);
include "tmp_browse.php";
exit;
}
/*******************************************************************************
* Action : del
*******************************************************************************/
if ($act == "delete") {
if (!empty($_REQUEST[item])) {
$sql = "DELETE a,b FROM " . $app['table']["berita"] . " a join " . $app['table']["berita_bahasa"] . " b on a.id=b.id_berita WHERE a.id =" . $admlib->item_delete($_REQUEST[item]) . "";
$dbu->qry($sql);
$_SESSION['msg'] = "data action yang terpilih berhasil dihapus ....";
$_SESSION['alt'] = "danger";
header("location: " . $urlx->get_referer());
}
exit;
}
/*******************************************************************************
* Action : single delete
*******************************************************************************/
if ($act == "s_delete") {
//print_r($_REQUEST);exit;
if (!empty($p_id)) {
$sql = "DELETE FROM " . $app['table']["berita"] . " WHERE id = '" . $p_id . "'";
//echo $sql;exit;
if ($paging > 0) {
$limit = "LIMIT {$start} , {$paging}";
}
//$sql = "SELECT * FROM ".$app['table']['page']." $where $sort $limit";
$sql = "SELECT * FROM " . $app['table']['pengguna'] . " a {$where} {$sort} {$limit}";
//echo $sql;exit;
$dbu->query($sql, $rsbrowse, $nr_browse);
include "tmp_browse.php";
exit;
}
/*******************************************************************************
* Action : del
*******************************************************************************/
if ($act == "delete") {
if (!empty($_REQUEST[item])) {
$sql = "DELETE FROM " . $app['table']['pengguna'] . " WHERE `id` IN (" . $admlib->item_delete($_REQUEST[item]) . ")";
$dbu->qry($sql);
$_SESSION['msg'] = "data pengguna yang terpilih berhasil dihapus ....";
$_SESSION['alt'] = "danger";
header("location: " . $urlx->get_referer());
}
exit;
}
/*******************************************************************************
* Action : single delete
*******************************************************************************/
if ($act == "s_delete") {
//print_r($_REQUEST);exit;
if (!empty($p_id)) {
$sql = "DELETE FROM " . $app['table']['pengguna'] . " WHERE id = '" . $p_id . "'";
//echo $sql;exit;
$limit = "LIMIT {$start} , {$paging}";
}
//$sql = "SELECT * FROM ".$app['table']['page']." $where $sort $limit";
$sql = "SELECT a.id, c.nama as destinasi FROM " . $app['table']["komunitas_destinasi"] . " as a LEFT JOIN " . $app['table']["destinasi"] . " as b ON(a.id_destinasi=b.id) LEFT JOIN " . $app[table][destinasi_bahasa] . " as c ON(b.id_reff=c.id_reff) {$where} {$sort} {$limit}";
//echo $sql;exit;
$dbu->query($sql, $rsbrowse, $nr_browse);
include "tmp_browse.php";
exit;
}
/*******************************************************************************
* Action : del
*******************************************************************************/
if ($act == "delete") {
$admlib->validate('community_del');
if (!empty($_REQUEST[item])) {
$sql = "DELETE FROM " . $app['table'][komunitas_destinasi] . " WHERE `id` IN (" . $admlib->item_delete($_REQUEST[item]) . ")";
$dbu->qry($sql);
$_SESSION['msg'] = "data destinasi komunitas " . $dbu->lookup("nama", $app[table][komunitas], "id ='" . $p_id . "'") . " yang terpilih berhasil dihapus ....";
$_SESSION['alt'] = "danger";
header("location: " . $urlx->get_referer());
}
exit;
}
/*******************************************************************************
* Action : single delete
*******************************************************************************/
if ($act == "s_delete") {
//print_r($_REQUEST);exit;
if (!empty($p_id)) {
$sql = "DELETE FROM " . $app['table']["komunitas_destinasi"] . " WHERE id = '" . $p_id . "'";
//echo $sql;exit;
