//$hostname = "dienbicom1.ipagemysql.com";
//$username = "trobosdb2014";
//$password = "cmstrobos2014";
$hostname = "localhost:3306";
$username = "deirroc2_useragristreamtv";
$password = "cmsagristreamtv2016";
//$database = "trobos2014";
$database = "deirroc2_agristreamtv2016";
$db = @mysql_connect($hostname, $username, $password);
@mysql_select_db($database);
?>
$sql = "select * from banner order by id";
$qbanner = mysql_query($sql) or die ("data banner tidak terhubung");
$i = 1;
$banner = array();
$bannertype = array();
/*$bannertype[1] = 'width="100%" height = "100px"';
$bannertype[2] = 'width="250px" height="240px"';
$bannertype[3] = 'width="413px" height="120px"';
*/
$bannertype[4] = 'width="100%" height="120px"';
/*$bannertype[5] = 'width="250px" height="125px"';
$bannertype[6] = 'width="105px" height="589px"';
$bannertype[7] = 'width="600px" height="500px"';
*/
while ($banners = mysql_fetch_object($qbanner))
{
$banner[$i]['id'] = $banners->id;
$banner[$i]['posisi'] = $banners->posisi;
$banner[$i]['namaklien'] = $banners->namaklien;
$banner[$i]['bannerurl'] = $banners->bannerurl;
$banner[$i]['link'] = $banners->link;
$banner[$i]['statistik'] = $banners->statistik;
$cekswf = explode('\.', $banners->bannerurl);
if (count($cekswf) > 1) {
$isswf = (strtolower($cekswf[1]) == 'swf') ? 'ok' : 'fail';
} else $isswf ='fail';
switch ($banners->posisi) {
case 'banner 1': $dimensi = $bannertype[4]; break;
case 'banner 2': $dimensi = $bannertype[4]; break;
case 'banner 3': $dimensi = $bannertype[4]; break;
case 'banner 4': $dimensi = $bannertype[4]; break;
case 'banner 5': $dimensi = $bannertype[4]; break;
/*
case 'banner 3': $dimensi = $bannertype[4]; break;
case 'banner 4': $dimensi = $bannertype[3]; break;
case 'banner 5': $dimensi = $bannertype[4]; break;
case 'banner 6': $dimensi = $bannertype[3]; break;
case 'banner 7': $dimensi = $bannertype[4]; break;
case 'banner 8': $dimensi = $bannertype[3]; break;
case 'banner 9': $dimensi = $bannertype[4]; break;
case 'banner 10': $dimensi = $bannertype[3]; break;
case 'banner 11': $dimensi = $bannertype[1]; break;
case 'banner splash': $dimensi = $bannertype[7]; break;
case 'banner sayapkiri': $dimensi = $bannertype[6]; break;
case 'banner sayapkanan': $dimensi = $bannertype[6]; break;
case 'banner estalase1': $dimensi = $bannertype[2]; break;
case 'banner estalase2': $dimensi = $bannertype[2]; break;
case 'banner estalase3': $dimensi = $bannertype[2]; break;*/
}
if (trim($banners->namaklien)<>'') { //jika nama ada
if (trim($banners->link) <> '') { //setelah nama ada, cek apakah linknya ada, jika ada lakukan script dibawah ini
$banner[$i]['setklien'] = ''.$banners->namaklien.'';
$banner[$i]['setlink'] = ''.$banners->link.'';
if ($isswf=='ok') { //setelah nama ada, cek apakah linknya ada, apakah filenya swf jika ya maka lakukan script dibawah ini
$banner[$i]['setbanner'] = '';
//$banner[$i]['setlink'] = ''.$banners->link.'';
} else { //setelah nama ada, cek apakah linknya ada, apakah filenya swf jika tidak maka lakukan script dibawah ini
$banner[$i]['setbanner'] = '';
//$banner[$i]['setbanner'] = '
';
}
} else { //setelah nama ada, cek apakah linknya ada, jika tidak ada lakukan script dibawah ini
$banner[$i]['setklien'] = ''.$banners->namaklien.'';
$banner[$i]['setlink'] = ''.$banners->link.'';
if ($isswf=='ok') {
$banner[$i]['setbanner'] = '';
//$banner[$i]['setlink'] = ''.$banners->link.'';
} else {
$banner[$i]['setbanner'] = '
';
}
}
}
$i++;
}
mysql_free_result($qbanner);
?>Query failed: