$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;