"; $terkini= mysql_query("SELECT * FROM berita,user WHERE user.id_user=berita.id_user ORDER BY id_berita DESC LIMIT 3"); while($t=mysql_fetch_array($terkini)){ $tgl = tgl_indo($t[tanggal]); echo "
"; $umum=mysql_query("SELECT * FROM pengumuman ORDER BY id_pengumuman DESC LIMIT 3"); while($u=mysql_fetch_array($umum)){ $tgl=tgl_indo($u[tanggal]); echo "
$tgl
$u[judul]
"; } echo "
"; } // Detail Berita elseif ($_GET[module]=='detailberita'){ $detail=mysql_query("SELECT * FROM berita,user WHERE user.id_user=berita.id_user AND id_berita='$_GET[id]'"); $d = mysql_fetch_array($detail); $tgl = tgl_indo($d[tanggal]); echo "
"; // Apabila berita dibuka, maka tambahkan counternya mysql_query("UPDATE berita SET counter=$d[counter]+1 WHERE id_berita='$_GET[id]'"); } // Bagian Berita elseif ($_GET[module]=='berita'){ echo "
» Berita
"; $p = new Paging; $batas = 8; $posisi = $p->cariPosisi($batas); $sql = "SELECT * FROM berita,user WHERE user.id_user=berita.id_user ORDER BY id_berita DESC LIMIT $posisi,$batas"; $hasil = mysql_query($sql); while($r=mysql_fetch_array($hasil)){ $tgl = tgl_indo($r[tanggal]); echo "
$r[hari], $tgl
"; echo "
$r[judul]
"; echo "
"; // Tampilkan hanya sebagian isi berita $isi_berita = nl2br($r[isi_berita]); $isi = substr($isi_berita,0,380); // ambil sebanyak 410 karakter $isi = substr($isi_berita,0,strrpos($isi," ")); // spasi antar kalimat echo "$isi ... Selengkapnya
"; } // Bagian Hasil Pencarian elseif ($_GET[module]=='hasilcari'){ echo "
» Hasil Pencarian
"; // Hanya mencari berita, apabila diperlukan bisa ditambahkan utk mencari agenda, pengumuman, dll $cari = mysql_query("SELECT * FROM berita WHERE isi_berita LIKE '%$_POST[kata]%' OR judul LIKE '%$_POST[kata]%'"); $jumlah = mysql_num_rows($cari); if ($jumlah > 0){ echo "
Ditemukan $jumlah berita dengan kata kunci $_POST[kata] :
"; // Tampilkan banner dalam bentuk gambar $banner=mysql_query("SELECT * FROM banner ORDER BY id_banner DESC"); while($b=mysql_fetch_array($banner)){ echo "
"; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM agenda ORDER BY id_agenda DESC"); } else{ $tampil=mysql_query("SELECT * FROM agenda WHERE id_user='$_SESSION[namauser]' ORDER BY id_agenda DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tgl_mulai = tgl_indo($r[tgl_mulai]); $tgl_selesai = tgl_indo($r[tgl_selesai]); echo "
"; break; case "editagenda": $edit = mysql_query("SELECT * FROM agenda WHERE id_agenda='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Agenda
"; break; } ?>
mod_banner.php Banner
no
judul
link
tgl. posting
aksi
"; $tampil=mysql_query("SELECT * FROM banner ORDER BY id_banner DESC"); $no=1; while ($r=mysql_fetch_array($tampil)){ $tgl=tgl_indo($r[tgl_posting]); echo "
"; break; case "editbanner": $edit = mysql_query("SELECT * FROM banner WHERE id_banner='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Banner
"; break; } ?>
mod_berita.php Berita
no
judul
tgl. posting
aksi
"; $p = new Paging; $batas = 10; $posisi = $p->cariPosisi($batas); if ($_SESSION[leveluser]=='admin'){ $tampil = mysql_query("SELECT * FROM berita ORDER BY id_berita DESC limit $posisi,$batas"); } else{ $tampil=mysql_query("SELECT * FROM berita WHERE id_user='$_SESSION[namauser]' ORDER BY id_berita DESC"); } $no = $posisi+1; while($r=mysql_fetch_array($tampil)){ $tgl_posting=tgl_indo($r[tanggal]);
"; if ($_SESSION[leveluser]=='admin'){ $jmldata = mysql_num_rows(mysql_query("SELECT * FROM berita")); } else{ $jmldata = mysql_num_rows(mysql_query("SELECT * FROM berita WHERE id_user='$_SESSION[namauser]'")); } $jmlhalaman = $p->jumlahHalaman($jmldata, $batas); $linkHalaman = $p->navHalaman($_GET[halaman], $jmlhalaman); echo "
$linkHalaman
"; break; case "tambahberita": echo "
Tambah Berita
"; break; case "editberita": $edit = mysql_query("SELECT * FROM berita WHERE id_berita='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Berita
"; break; } ?>
mod_hubungi.php Hubungi Kami
no
nama
email
subjek
tanggal
aksi
"; $no=1; $tampil=mysql_query("SELECT * FROM hubungi ORDER BY id_hubungi desc"); while ($r=mysql_fetch_array($tampil)){ $tgl=tgl_indo($r[tanggal]); echo "
$no
$r[nama]
$r[email]
$r[subjek]
$tgl
Hapus
"; $no++; } echo "
";
break; case "balasemail": $tampil = mysql_query("SELECT * FROM hubungi WHERE id_hubungi='$_GET[id]'"); $r = mysql_fetch_array($tampil); echo "
Reply Email
"; break; case "kirimemail": mail($_POST[email],$_POST[subjek],$_POST[pesan],"From: [email protected]"); echo "
"; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM khotbah ORDER BY id_khotbah DESC"); } else{ $tampil=mysql_query("SELECT * FROM khotbah WHERE id_user='$_SESSION[namauser]' ORDER BY id_khotbah DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tanggal=tgl_indo($r[tanggal]); echo "
$no
$r[introitus]
$r[ogen]
$r[khotbah]
$r[thema]
$tanggal
Edit | Hapus
"; $no++; } echo "
"; break; case "tambahkhotbah": echo "
Tambah Bimbingan Khotbah
"; break; case "editkhotbah": $edit = mysql_query("SELECT * FROM khotbah WHERE id_khotbah='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Bimbingan Khotbah
"; break; } ?>
mod_modul.php Modul
no
nama modul
link
publish
aktif
status
aksi
"; $tampil=mysql_query("SELECT * FROM modul ORDER BY urutan"); while ($r=mysql_fetch_array($tampil)){ echo "
"; break; case "editmodul": $edit = mysql_query("SELECT * FROM modul WHERE id_modul='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Modul
"; break; } ?>
mod_pengumuman.php Pengumuman
no
judul
tanggal
aksi
"; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM pengumuman ORDER BY id_pengumuman DESC"); } else{ $tampil=mysql_query("SELECT * FROM pengumuman WHERE id_user='$_SESSION[namauser]' ORDER BY id_pengumuman DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tanggal=tgl_indo($r[tanggal]); echo "
$no
$r[judul]
$tanggal
Ed it | Hapus
"; $no++; } echo "
"; break; case "tambahpengumuman": echo "
Tambah Pengumuman
"; break; case "editpengumuman": $edit = mysql_query("SELECT * FROM pengumuman WHERE id_pengumuman='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Pengumuman
"; break; } ?>
mod_renungan.php Renungan
no
judul
tanggal
aksi
"; if ($_SESSION[leveluser]=='admin'){ $tampil=mysql_query("SELECT * FROM renungan ORDER BY id_renungan DESC"); } else{ $tampil=mysql_query("SELECT * FROM renungan
WHERE id_user='$_SESSION[namauser]' ORDER BY id_renungan DESC"); } $no=1; while ($r=mysql_fetch_array($tampil)){ $tanggal=tgl_indo($r[tanggal]); echo "
$no
$r[judul]
$tanggal
Edit | Hapus
"; $no++; } echo "
"; break; case "tambahrenungan": echo "
Tambah Renungan
"; break; case "editrenungan": $edit = mysql_query("SELECT * FROM renungan WHERE id_renungan='$_GET[id]'"); $r = mysql_fetch_array($edit); echo "
Edit Renungan
"; break; } ?>
mod_user.php User
no
username
nama lengkap
email
aksi
"; $tampil=mysql_query("SELECT * FROM user ORDER BY id_user"); $no=1; while ($r=mysql_fetch_array($tampil)){ echo "
// Input berita elseif ($module=='berita' AND $act=='input'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $tipe_file = $_FILES['fupload']['type']; $nama_file = $_FILES['fupload']['name']; $acak = rand(000000,999999); $nama_file_unik = $acak.$nama_file; // Apabila ada gambar yang diupload if (!empty($lokasi_file)){ // Apabila tipe gambar bukan jpeg akan tampil peringatan if ($tipe_file != "image/jpeg" AND $tipe_file != "image/pjpeg"){ echo "Gagal menyimpan data !!! Tipe file $nama_file : $tipe_file Tipe file yang diperbolehkan adalah : JPG/JPEG. "; echo "Ulangi Lagi"; } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file_unik"); mysql_query("INSERT INTO berita(judul,id_kategori,isi_berita, id_user,jam,tanggal,hari,gambar) VALUES('$_POST[judul]', '$_POST[kategori]','$_POST[isi_berita]','$_SESSION[namauser]','$jam_seka rang','$tgl_sekarang','$hari_ini','$nama_file_unik')"); header('location:media.php?module='.$module); } } else{ mysql_query("INSERT INTO berita(judul,id_kategori,isi_berita, id_user,jam,tanggal,hari) VALUES('$_POST[judul]','$_POST[kategori]', '$_POST[isi_berita]','$_SESSION[namauser]','$jam_sekarang','$tgl_sekaran g','$hari_ini')"); header('location:media.php?module='.$module); } } // Update berita elseif ($module=='berita' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE berita SET judul = '$_POST[judul]', id_kategori = '$_POST[kategori]',isi_berita = '$_POST[isi_berita]'
WHERE id_berita = '$_POST[id]'"); } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE berita SET judul = '$_POST[judul]', id_kategori = '$_POST[kategori]',isi_berita = '$_POST[isi_berita]', gambar = '$nama_file'WHERE id_berita = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Input banner elseif ($module=='banner' AND $act=='input'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila ada gambar yang diupload if (!empty($lokasi_file)){ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("INSERT INTO banner(judul,url,tgl_posting,gambar) VALUES('$_POST[judul]','$_POST[link]','$tgl_sekarang','$nama_file')"); } else{ mysql_query("INSERT INTO banner(judul,tgl_posting,url) VALUES('$_POST[judul]','$tgl_sekarang','$_POST[link]')"); } header('location:media.php?module='.$module); } // Update banner elseif ($module=='banner' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE banner SET judul = '$_POST[judul]', url = '$_POST[link]'WHERE id_banner = '$_POST[id]'"); } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE banner SET judul = '$_POST[judul]', url = '$_POST[link]',gambar = '$nama_file'WHERE id_banner = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Update profil elseif ($module=='profil' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE modul SET static_content = '$_POST[isi]'WHERE id_modul = '$_POST[id]'"); }
else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE modul SET static_content = '$_POST[isi]', gambar = '$nama_file'WHERE id_modul = '$_POST[id]'"); } header('location:media.php?module='.$module); } // Update Susunan Kepengurusan Pusat GBKP elseif ($module=='pengurus' AND $act=='update'){ $lokasi_file = $_FILES['fupload']['tmp_name']; $nama_file = $_FILES['fupload']['name']; // Apabila gambar tidak diganti if (empty($lokasi_file)){ mysql_query("UPDATE modul SET static_content = '$_POST[isi]' WHERE id_modul = '$_POST[id]'"); } else{ move_uploaded_file($lokasi_file,"foto_berita/$nama_file"); mysql_query("UPDATE modul SET static_content = '$_POST[isi]', gambar = '$nama_file' WHERE id_modul = '$_POST[id]'"); } header('location:media.php?module='.$module); } ?>
// Bagian Beranda if ($_GET[module]=='beranda'){ echo "
Selamat Datang
Hai $_SESSION[namauser], silahkan klik menu pilihan yang berada di sebelah kiri untuk mengelola content website.
Login Hari ini: "; echo tgl_indo(date("Y m d")); echo " | "; echo date("H:i:s"); echo "
"; } // Bagian Profil Lembaga elseif ($_GET[module]=='profil'){ $sql = mysql_query("SELECT * FROM modul WHERE id_modul='11'"); $r = mysql_fetch_array($sql); echo "