$topikp2 = substr_replace($topikp2, "", -1, 1);
//$tengah.=$topikp2.'<br>';
///////////////////////////////////////
$totals = $koneksi_db->sql_query("SELECT id FROM artikel WHERE publikasi=1 AND topik in({$topikp2})");
$jumlah = $koneksi_db->sql_numrows($totals);
$a = new paging($limit);
$hasil = $koneksi_db->sql_query("SELECT * FROM artikel WHERE publikasi=1 AND topik in({$topikp2}) ORDER BY id DESC LIMIT {$offset}, {$limit}");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$hits = $data['hits'];
$data[6] = datetimes($data['tgl']);
$gambar = $data[8] == '' ? '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;" src="' . $url_situs . '/timthumb.php?src=' . $url_situs . '/mod/news/images/normal/news-default.jpg&w=120&h=90&zc=1">' : '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;" src="' . $url_situs . '/timthumb.php?src=' . $url_situs . '/mod/news/images/normal/' . $data[8] . '&w=120&h=90&zc=1" alt="' . $data['judul'] . '"/>';
$tengah .= '<div class="news">
<h4><a href="' . $url_situs . '/view-' . $data[11] . '.html" title="' . $data[1] . '">' . $data[1] . '</a></h4>
' . $gambar . '
<div class="date">' . $data[6] . ' • oleh : ' . $data[3] . ' • <img align="absmiddle" src="/images/read.gif"/> DIBACA : ' . $hits . '</div>
' . limitTXT(strip_tags($data[2]), 300) . '</div>';
}
//end while
if ($jumlah > 10) {
$tengah .= '<div class="border">';
$tengah .= "<center>";
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
$offset = 0;
}
if (empty($_GET['pg']) and !isset($_GET['pg'])) {
$pg = 1;
}
if (empty($_GET['stg']) and !isset($_GET['stg'])) {
$stg = 1;
}
$tengah .= $a->getPaging($jumlah, $pg, $stg);
$content .= '<div class="border">';
$content .= '<table width="100%">';
$JUDULCAL = array();
$TMPpesan = array();
$awalbulandengannol = $t['mon'] >= 10 ? $t['mon'] : '0' . $t['mon'];
$varwaktucalender = $t['year'] . '-' . $awalbulandengannol . '-' . $t['mday'];
$awalbulandengannol2 = $u['mon'] >= 10 ? $u['mon'] : '0' . $u['mon'];
$varwaktucalender2 = $u['year'] . '-' . $awalbulandengannol2 . '-' . $u['mday'];
$cekdate = mysql_query("SELECT `judul`,`waktu_mulai`,`waktu_akhir`,`isi` FROM `tbl_kalender` WHERE `waktu_mulai` = '{$varwaktucalender}' OR `waktu_akhir` = '{$varwaktucalender2}' ORDER BY `waktu_mulai`");
while ($getdate = mysql_fetch_assoc($cekdate)) {
// print_r($getdate);
$WKTMULAI = $getdate['waktu_mulai'];
$WKTAKHIR = $getdate['waktu_akhir'];
$GTTGL = (int) substr($WKTMULAI, -2, 2);
$TGLMULAI[$GTTGL] = $GTTGL;
//
$JUDULCAL[$GTTGL] = $getdate['judul'];
$idssss = '<b>' . $getdate['judul'] . '</b><br><small>Periode Awal : ' . converttgl($WKTMULAI) . '<br>Periode Akhir : ' . converttgl($WKTAKHIR) . '</small>
<br>' . limitTXT($getdate['isi'], 150) . '';
$content .= '<tr><td style="font-weight:bold;border-bottom:solid 1px #efefef">' . $getdate['judul'] . '</td></tr>';
$content .= '<tr><td style="color:orange">' . converttgl($WKTMULAI) . ' S/D ' . converttgl($WKTAKHIR) . '</td></tr>';
$content .= '<tr><td style="border-bottom:solid 1px #efefef">' . nl2br($getdate['isi']) . '</td></tr>';
$content .= '<tr><td> </td></tr>';
}
$content .= '</table>';
$content .= '</div>';
}
echo $content;
?>
<th></th>
<th style="text-align:center;padding:10px 5px 10px 5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">Nama&Email</th>
<th style="text-align:center;padding:10px 5px 10px 5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">Blog</th>
<th style="text-align:center;padding:10px 5px 10px 5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">Konten</th>
<th style="text-align:center;padding:10px 5px 10px 5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">Tgl</th>
<th style="text-align:center;padding:10px 5px 10px 5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">Publikasi</th>
<th style="text-align:center;padding:10px 5px 10px0 5px;border-right:1px solid #ccc;border-top:1px solid #ccc;border-left:1px solid #ccc;width:100px;">Aksi</th>
</tr>';
$no = 1;
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$komentarartikel = $data['artikel'];
$nama = $data['nama'];
$data_tgl = $data['tgl'];
$hasil2 = $koneksi_db->sql_query("SELECT * FROM artikel WHERE id = {$komentarartikel}");
$data2 = $koneksi_db->sql_fetchrow($hasil2);
$blog = limitTXT(strip_tags($data2['judul']), 20);
$published = $data['publikasi'] == 1 ? '<a href="admin.php?pilih=news&mod=yes&aksi=unpubkomentar&id=' . $data[0] . '"><img src="images/ya.png" border="0" alt="ya" /></a>' : '<a href="admin.php?pilih=news&mod=yes&aksi=pubkomentar&id=' . $data[0] . '"><img src="images/tidak.png" border="0" alt="no" /></a>';
$deleted = '<a href=admin.php?pilih=news&mod=yes&aksi=delkomentar&id=' . $data[0] . '><font color=red>delete</font></a>';
$admin .= '
<tr valign="top">
<td style="text-align:center;width:10px;padding:5px;border-left:1px solid #ccc;border-top:1px solid #ccc;">' . $no . '</td>
<td style="width:20px;padding:5px;border-left:1px solid #ccc;border-top:1px solid #ccc;" valign="top"><input type=checkbox name=check' . $no . ' value=' . $data[0] . '></td>
<td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $nama . '<br>' . $data['email'] . '</td>
<td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $blog . '</td>
<td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $data['konten'] . '</td>
<td style="text-align:left;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;">' . $data_tgl . '</td>
<td style="text-align:center;padding:5px;border-top:1px solid #ccc;border-left:1px solid #ccc;width:5px;">' . $published . '</td>
<td style="text-align:center;padding:5px;border-right:1px solid #ccc;border-top:1px solid #ccc;border-left:1px solid #ccc;width:5px;">' . $deleted . '</td>
</tr>';
$no++;
}
$data_topik = $koneksi_db->sql_fetchrow($hasil_topik);
$datatt['tgl'] = datetimes($data['tgl']);
$gambar = $data['gambar'] == '' ? '<img src="mod/news/images/normal/news-default.jpg" alt="' . $data[1] . '"/>' : '<img src="mod/news/images/normal/' . $data['gambar'] . '" alt="' . $data[1] . '"/>';
echo '' . $gambar . '
<div class="info" >
<div class="headjud"><a href="article-' . AuraCMSSEO($data[1]) . '.html">' . $data['1'] . '</a></div>
<p class="headket">' . limitTXT(strip_tags($data[2]), 110) . '</p>
</div>
</div>';
}
// End Berita 03 ====================================================================================
// Berita 04 ====================================================================================
echo '<div id="fragment-4" class="ui-tabs-panel ui-tabs-hide">';
global $koneksi_db, $maxdata, $maxkonten;
$hasil = $koneksi_db->sql_query("SELECT * FROM `artikel` where publikasi='1' ORDER BY `id` DESC LIMIT 3,1");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$hasil_topik = $koneksi_db->sql_query("SELECT * FROM `topik` WHERE id='{$data['topik']}'");
$data_topik = $koneksi_db->sql_fetchrow($hasil_topik);
$datatt['tgl'] = datetimes($data['tgl']);
$gambar = $data['gambar'] == '' ? '<img src="mod/news/images/normal/news-default.jpg" alt="' . $data[1] . '"/>' : '<img src="mod/news/images/normal/' . $data['gambar'] . '" alt="' . $data[1] . '"/>';
echo '' . $gambar . '
<div class="info" >
<div class="headjud"><a href="article-' . AuraCMSSEO($data[1]) . '.html">' . $data['1'] . '</a></div>
<p class="headket">' . limitTXT(strip_tags($data[2]), 110) . '
</div>
</div>';
}
echo '</div>';
// End Berita 04 ====================================================================================
//$gambar = '<iframe width="300" height="200" src="//www.youtube.com/embed/'.$link.'" frameborder="0" allowfullscreen></iframe>';
$gambar = '
<img src="http://img.youtube.com/vi/' . $link . '/0.jpg"/>';
$tengah .= '<h4 class="bg">' . $kategori . ' <span class="date2">' . datetimes($tgl) . '</span></h4>';
$tengah .= '<div class="box2"><ul>';
$tengah .= '<li>' . $gambar . '</li>';
$query = $koneksi_db->sql_query("SELECT * FROM video_peristiwa WHERE topik in({$katid}) ORDER BY id DESC LIMIT 0,4");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$oleh = $datas['user'];
$idperistiwa = $datas['id'];
$judul = $datas['judul'];
$tgl = $datas['tgl'];
$seftitle = $datas['seftitle'];
$konten = $datas['konten'];
$tengah .= '<li><a href="detailvideo-' . $seftitle . '.html" title ="' . limitTXT(strip_tags($konten), 280) . '">' . $datas['judul'] . '</a></li>';
}
$tengah .= '</ul></div>';
$tengah .= '</div></td></tr></table>';
///////////////////////////////////////////
$tengah .= '</td></tr></table>';
}
if ($_GET['aksi'] == "lihat") {
$judul = $_GET['judul'];
if (file_exists("images/6.gif")) {
$ikon_2 = "<img src=\"images/6.gif\" alt=\"\" border=\"0\" />";
}
if (file_exists("images/7.gif")) {
$ikon_3 = "<img src=\"images/7.gif\" alt=\"\" border=\"0\" />";
}
$hasil = $koneksi_db->sql_query("SELECT * FROM video_peristiwa WHERE seftitle='{$judul}'");
$tengah .= '<td width="305" valign="top"><div class="borderluar">
<h3 class="bg3"><a href="#">ARTIKEL ' . $topik . ' TERBARU</a></h3>';
$query = $koneksi_db->sql_query("SELECT * FROM artikel WHERE publikasi=1 ORDER BY id DESC LIMIT 0,1");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$oleh = $datas['user'];
$id = $datas['id'];
$judul = $datas['judul'];
$tgl = $datas['tgl'];
$hits = $datas['hits'];
$seftitle = $datas['seftitle'];
$gambar = $datas['gambar'] == '' ? '<img style="float:left; margin-right:10px; border:1px solid #dddddd;" src="mod/news/images/normal/news-default.jpg"height="60"width="80" alt="' . $datas['judul'] . '" />' : '<img style="float:left; margin-right:10px; border:1px solid #dddddd;" src="mod/news/images/normal/' . $datas['gambar'] . '"height="60"width="80" alt="' . $datas['judul'] . '" />';
$tengah .= '<div class="borderdalam">
<div class="date">' . datetimes($tgl) . '</div>
<h4><a href="article-' . $seftitle . '.html" title="' . $judul . '">' . $datas['judul'] . '</a></h4>
' . $gambar . '' . limitTXT(strip_tags($datas[2]), 280) . '';
}
$tengah .= '</div>';
$tengah .= '<div class="box2"><ul>';
$query = $koneksi_db->sql_query("SELECT * FROM artikel WHERE topik in(43) and publikasi=1 ORDER BY id DESC LIMIT 1,3");
$no = 0;
while ($datas = $koneksi_db->sql_fetchrow($query)) {
$id = $datas['id'];
$judul = $datas['judul'];
$hits = $datas['hits'];
$seftitle = $datas['seftitle'];
$tengah .= '<li><a href="article-' . $seftitle . '.html" title="' . $judul . '">' . $datas['judul'] . '</a></li>';
}
$tengah .= '</ul></div>';
$tengah .= '</div></td></tr></table>';
///////////////////////////
$idkursus = $_GET['id'];
$hasil = $koneksi_db->sql_query("SELECT * FROM materi where idkursus='{$idkursus}' order by id desc");
$admin .= '<div class="panel-heading"><b>Daftar Materi</b></div>';
$admin .= '<table id="example" class="table table-hover">
<thead><tr>
<th width="5%">No</th>
<th>Judul</th>
<th width="15%">Kelas</th>
<th width="15%">File</th>
<th width="25%">Aksi</th>
</tr></thead><tbody>';
$no = 1;
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$idmateri = $data['id'];
$idkelas = $data['kelas'];
$konten = limitTXT(strip_tags($data['konten']), 200);
$materi = $data['materi'];
$kelas = $data['kelas'];
$hasil2 = $koneksi_db->sql_query("SELECT * FROM kelas where id='{$kelas}'");
$data2 = $koneksi_db->sql_fetchrow($hasil2);
$kelas2 = $data2['kelas'];
if ($materi != "") {
$available = "<a href='mod/materi/download/{$data['materi']}' target='new'><span class='btn btn-success'>{$materi}</span></a>";
} else {
$available = "";
}
$admin .= '<tr>
<td><b>' . $no . '</b></td>
<td>' . $data['judul'] . '</td>
<td>' . lihatkelas($data['kelas']) . '</td>
';
$rss->useCached();
$rss->title = $judul_situs;
$rss->description = $slogan;
$rss->link = $url_situs;
$rss->feedURL = $url_situs . "/" . $_SERVER['PHP_SELF'];
$rss->syndicationURL = $url_situs;
$rss->cssStyleSheet = NULL;
$image = new FeedImage();
$image->title = $slogan;
$image->url = "{$url_situs}/images/browser-48x48.png";
$image->link = $url_situs;
$image->description = "Feed provided by Teamworks Creative. Click to visit.";
$rss->image = $image;
// Ngambil dari database
$hasil = $koneksi_db->sql_query("SELECT * FROM katalog WHERE publikasi=1 ORDER BY id DESC LIMIT 10");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$tanggal = $data['tgl'];
$judulnya = $data[1];
$isinya = $data[2];
$id = $data[0];
$author = $data[3];
$item = new FeedItem();
$item->title = $judulnya;
$item->link = $url_situs . "/produk/" . $id . "/" . AuraCMSSEO($judulnya) . ".html";
$item->description = limitTXT(strip_tags($isinya), 250);
$item->date = strtotime($tanggal);
$item->source = $url_situs;
$item->author = $author;
$rss->addItem($item);
}
$rss->outputFeed("RSS2.0");
$pg = int_filter(@$_GET['pg']);
$stg = int_filter(@$_GET['stg']);
$hasil2 = $koneksi_db->sql_query("SELECT * FROM artikel WHERE ((judul LIKE '%{$query}%' OR konten LIKE '%{$query}%' OR user LIKE '%{$query}%')AND publikasi=1) ORDER By id LIMIT {$offset},{$limit}");
$tengah .= '<div class="border">';
$tengah .= "Ditemukan <b>" . $jumlah . "</b> artikel mengandung kata: <b>{$query}</b>";
$tengah .= '</div>';
$tengah .= '<div class="border">';
while ($data = $koneksi_db->sql_fetchrow($hasil2)) {
$warna = empty($warna) ? 'bgcolor="#efefef"' : '';
$data['tgl'] = datetimes($data['tgl']);
$gambar = $data[8] == '' ? '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;max-height:150px;max-width:150px;" src="mod/news/images/normal/news-default.jpg">' : '<a href="' . $url_situs . '/mod/news/images/normal/' . $data[8] . '" onclick="return hs.expand(this)">
<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;max-height:150px;max-width:150px;" src="mod/news/images/normal/' . $data[8] . '" alt="' . $data['judul'] . '"/></a>';
$ikon_readmore = '<a href="article-' . AuraCMSSEO($data['seftitle']) . '.html" title="' . $data['judul'] . '" class="readmore"><img src=images/readmore.jpg border=0></a>';
$tengah .= '<table class="border" width="100%"><tr><td><a href="article-' . AuraCMSSEO($data[1]) . '.html" title="' . $data[1] . '" class="readmore"><h4>' . $data[1] . '</h4></a>' . $gambar . '
<span class="date">' . $data['tgl'] . '</span><br>
' . limitTXT(strip_tags($data[2]), 300) . '<br>' . $ikon_readmore . '</td></tr></table>';
$no++;
}
if ($jumlah > $limit) {
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
$offset = 0;
}
if (empty($_GET['pg']) and !isset($_GET['pg'])) {
$pg = 1;
}
if (empty($_GET['stg']) and !isset($_GET['stg'])) {
$stg = 1;
}
$tengah .= '<div class="border"><center>';
$tengah .= $ada->getPaging($jumlah, $pg, $stg);
$tengah .= '</center></div>';
$limit = 10;
$offset = int_filter(@$_GET['offset']);
$pg = int_filter(@$_GET['pg']);
$stg = int_filter(@$_GET['stg']);
$totals = $koneksi_db->sql_query("SELECT id FROM artikel WHERE publikasi=1 AND topik={$topik}");
$jumlah = $koneksi_db->sql_numrows($totals);
$a = new paging($limit);
if ($jumlah > 0) {
$hasil = $koneksi_db->sql_query("SELECT * FROM artikel WHERE publikasi=1 AND topik={$topik} ORDER BY id DESC LIMIT {$offset}, {$limit}");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$data[6] = datetimes($data['tgl']);
$gambar = $data[8] == '' ? '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;" src="timthumb.php?src=mod/news/images/normal/news-default.jpg&w=80&h=60&zc=1">' : '<img style="margin-right:5px; margin-top:5px; padding:1px; background:#f2f2f2; border:1px solid #cccccc; float:left;" src="timthumb.php?src=mod/news/images/normal/' . $data[8] . '&w=90&h=60&zc=1" alt="' . $data['judul'] . '"/>';
//$tengah .='<div class="border"><a href="article-'.$data[0].'-'.AuraCMSSEO($data[1]).'.html" title="'.$data[1].'" class="readmore"><h4>'.$data[1].'</h4></a>'.$gambar.'
$tengah .= '<table class="border" width="100%"><tr><td><a href="article-' . AuraCMSSEO($data[1]) . '.html" title="' . $data[1] . '" class="readmore"><h4>' . $data[1] . '</h4></a>' . $gambar . '
<span class="date">' . $data[6] . '- oleh : ' . $data[4] . '</span><br>
' . limitTXT(strip_tags($data[2]), 300) . '</td></tr></table>';
}
//end while
if ($jumlah > 10) {
$tengah .= '<div class="border">';
$tengah .= "<center>";
if (empty($_GET['offset']) and !isset($_GET['offset'])) {
$offset = 0;
}
if (empty($_GET['pg']) and !isset($_GET['pg'])) {
$pg = 1;
}
if (empty($_GET['stg']) and !isset($_GET['stg'])) {
$stg = 1;
}
$tengah .= $a->getPaging($jumlah, $pg, $stg);