function edit_profile($id){
if(isset($_POST['simpan'])){
if($_POST['simpan']){
if(!detectBlank($_POST)){
$nama = eraseStrange($_POST['nama']);
$title = eraseStrange($_POST['title']);
$narasi = eraseStrange($_POST['narasi']);
$status = preg_replace("@[^0-9]@i","",$_POST['status']);
$id = preg_replace("@[^0-9]@i","",$_POST['id']);
if($status=="") $status = "0";
$sql = "update tbl_boardmanager set name='$nama',jabatan='$title',deskripsi='$narasi',status='$status'
where id=$id";
//echo $sql;
//echo $_POST['id']."ini idi";
if($this->exQ($sql)){
$this->pesan = "Profile telah ditambahkan !";
return true;
}else{
//echo mysql_error();
redirect("../error.php?p=1");
die();
}
}else{
$this->pesan = "Isilah semua field yang disediakan !";
return false;
}
}
}
}
function edit_news($id){
if(isset($_POST['simpan'])){
if($_POST['simpan']){
if(!detectBlank($_POST)){
$kategori = eraseStrange($_POST['kategori']);
$judul = eraseStrange($_POST['jdl']);
$tanggal = eraseStrange($_POST['tgl']);
if(!preg_match("@[0-9]{2}\-[0-9]{2}\-[0-9]{4}@i",$tanggal,$tgl)){
$this->pesan = "Format tanggal tidak valid !";
return false;
}
$tgl = explode("-",$tanggal);
$tanggal = "$tgl[2]-$tgl[0]-$tgl[1]";
$cuplikan = eraseStrange($_POST['cuplikan']);
$isi = eraseStrange($_POST['berita']);
$status = preg_replace("@[^0-9]@i","",$_POST['status']);
if($status=="") $status = "0";
$sql = "update tbl_news set kategori='$kategori', judul='$judul', tanggal='$tanggal',
cuplikan='$cuplikan', isi='$isi', status='$status' where id=$id";
#echo $sql;
if($this->exQ($sql)){
$this->pesan = "Berita telah diedit !";
return true;
}else{
echo mysql_error();
#redirect("../error.php?p=1");
die();
}
}else{
$this->pesan = "Isilah semua field yang disediakan !";
return false;
}
}
}
return false;
}
$nfile = $rec[0];
if(!$tips->uploadFile(100000,$nfile)){
$meta = $links->pesan;
$smarty->assign('kembali',true);
$smarty->assign('id',$nfile);
$smarty->assign('aksi2',$aksi2);
}else{
$sql = "update tbl_links set gambar='$links->thumbName' where id=$rec[0]";
$tips->exQ($sql);
}
}
$smarty->assign('pesan',"Links added !<br>".$meta);
$smarty->assign('dShowMe',true);
}else{
$smarty->assign("link",eraseStrange($_POST['link']));
$smarty->assign("content",str_replace(array("\r","\n","\e"),"",eraseStrange($_POST['content'])));
$status = preg_replace("@[^0-9]@i","",$_POST['status']);
if($status==1){
$smarty->assign("checked","checked");
}else{
$smarty->assign("checked","");
}
$smarty->assign('pesan',$links->pesan);
}
$template = "links_add_edit.tpl";
break;
case "edit":
$id = @preg_replace("@[^0-9]@i","",$_GET['id']);
if($links->edit_news($id)){
if($_FILES['gambar']['size']>0){
if(!$links->uploadFile(100000,$id)){
}else{
$i = eraseStrange($_POST['kategori']);
$listkategori = $news->Kategori($i);
if(!array($listkategori)){
$smarty->assign("s",$listkategori['id']," selected");
} else {
$smarty->assign("s1"," selected");
}
$smarty->assign("jdl",eraseStrange($_POST['jdl']));
if($_POST['tgl']){
$smarty->assign("tgl",eraseStrange($_POST['tgl']));
}else{
$smarty->assign("tgl",date('m-d-Y'));
}
$smarty->assign("cuplikan",eraseStrange($_POST['cuplikan']));
$smarty->assign("berita",str_replace(array("\r","\n","\e"),"",eraseStrange($_POST['berita'])));
$status = preg_replace("@[^0-9]@i","",$_POST['status']);
if($status==1){
$smarty->assign("checked","checked");
}else{
$smarty->assign("checked","");
}
$smarty->assign('pesan',$news->pesan);
}
$template = "news_add_edit.tpl";
break;
case "edit":
$id = @preg_replace("@[^0-9]@i","",$_GET['id']);
if($news->edit_news($id)){
if($_FILES['gambar']['size']>0){
if(!$news->uploadFile(100000,$id)){
function simpanCaption(){
if(isset($_POST['id'])){
foreach($_POST['id'] as $idU){
$caption = eraseStrange($_POST['judul'.$idU]);
$status = preg_replace("@[^0-9]@i","",$_POST['status'.$idU]);
if(!$status) $status=0;
$sql = "update galery set caption='$caption', status='$status' where id=$idU";
if(!$this->exQ($sql)){
$this->pesan = "Data gagal diupdate !";
return false;
}else{
$this->pesan = "Data berhasil diupdate !";
}
}
return true;
}else{
$this->pesan = "Pilih salah satu gambar untuk diedit !";
return false;
}
}
}
$smarty->assign('aksi2',$aksi2);
switch($aksi2){
case "add":
if($gal->add_gal()){
$meta = '<meta http-equiv="refresh" content="3;url=\''.$_SERVER['SCRIPT_NAME'].'?aksi=galery&aksi2=gambar&id='.$gal->id_album.'" />';
$smarty->assign('pesan',$gal->pesan.$meta);
$smarty->assign('dShowMe',true);
}else{
$smarty->assign("album",eraseStrange($_POST['album']));
if($_POST['tanggal']){
$smarty->assign("tanggal",eraseStrange($_POST['tanggal']));
}else{
$smarty->assign("tanggal",date('m-d-Y'));
}
$smarty->assign("deskripsi",eraseStrange($_POST['deskripsi']));
$status = preg_replace("@[^0-9]@i","",$_POST['status']);
if($status==1){
$smarty->assign("status","checked");
}else{
$smarty->assign("status","");
}
$smarty->assign('pesan',$gal->pesan);
}
$template = "galery_add_edit.tpl";
break;
case "edit":
if(isset($_POST['simpan'])){
$id = preg_replace("@[^0-9]@i","",$_POST['id']);
if($gal->edit_gal($id)){
$smarty->assign("pesan",$gal->pesan.$meta);
function edit_news($id){
if(isset($_POST['simpan'])){
if($_POST['simpan']){
if(!detectBlank($_POST)){
$kategori = eraseStrange($_POST['kategori']);
$link = eraseStrange($_POST['link']);
$content = eraseStrange($_POST['content']);
$status = preg_replace("@[^0-9]@i","",$_POST['status']);
if($status=="") $status = "0";
$sql = "update tbl_tips set kategori='$kategori', content='$content', link='$link',
status='$status' where id=$id";
#echo $sql;
if($this->exQ($sql)){
$this->pesan = "Tips telah diedit !";
return true;
}else{
echo mysql_error();
#redirect("../error.php?p=1");
die();
}
}else{
$this->pesan = "Isilah semua field yang disediakan !";
return false;
}
}
}
return false;
}
