query("SELECT catid,catname FROM phpcms_category where channelid=$chanid and catid!=122 order by listorder asc"); while($rsm=$db->fetch_array($result)) { $catid=$rsm['catid']; $menulist=$rsm['catname']; $menulist=''.$menulist.' | '; $listmenu=$listmenu.$menulist; } $listmenu='باش بەت |'.$listmenu.''; //$listmenu='باش بەت |'.$listmenu.''; $db->free_result($result); return $listmenu; } //=================================== //=================================== function showOnemenu($catid) { global $db; $result = $db->query("SELECT catid,catname FROM phpcms_category where channelid=32 and catid=".$catid.""); if($rsm=$db->fetch_array($result)) { $menulist=$rsm['catname']; $menulist=''.$menulist.''; } $listmenu=$listmenu.''; $db->free_result($result); return $menulist; } /* 显示专辑演唱者姓名 */ function ShowCDsinger($chilid) { global $db; $sql="SELECT specialid,specialname FROM phpcms_special where specialid =".$chilid." and parentid!=0"; $result = $db->query($sql); while($rsm=$db->fetch_array($result)) { $spname=$rsm['specialname']; } $db->free_result($result); return $spname; } /* 显示专辑演唱者姓名 */ function ShowCDname($chilid) { global $db; $sql="SELECT specialid,specialname,keyid FROM phpcms_special where arrchildid =".$chilid." and parentid=0"; $result = $db->query($sql); while($rsm=$db->fetch_array($result)) { $spname=$rsm['specialname']; $spname=''.$spname.''; } $db->free_result($result); return $spname; } /* 函数功能:读取最新，热门，推荐歌曲 */ function ShowMusicList($num,$isflag,$catid,$vorder,$numjan) { global $db; $sql="SELECT movieid,title,thumb,my_singer,catid,hits FROM ".channel_table('movie', 32)." where status=3 AND my_bianhao='' "; switch($isflag) { case 1: $sql=$sql." and catid=".$catid." "; break; case 2: $sql=$sql." and specialid=".$catid." "; break; default: $sql=$sql; break; } $sql=$sql."ORDER BY ".$vorder." DESC LIMIT ".$num.""; $result=$db->query($sql); $html=$html.''; $html=$html.''; //$i=0; //onclick="BasbaPlyer(\'player/Anglash.php?check='.$songid.'&catid='.$catid.'\',\'BasbasPlayer\',\'width=651,height=531\')" while($rs=$db->fetch_array($result)) { //$i=$i+1; $songname=$rs['title']; $songid=$rs['movieid']; $singer=$rs['my_singer']; if($singer==''){ $singername='نامەلۇم'; }else{ $singername=$singer; } $hits=$rs['hits']; $catid=$rs['catid']; $html=$html.''; $html=$html.''; if($vorder=='hits'){ $html=$html.''; }else{ $html=$html.''; } //$html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; } $html=$html.''; //$html=$html.''; $html=$html.''; $html=$html.''; $html=$html.'
'.$hits.'
'.$songname.'
'; $html=$html.''; $html=$html.' '; $html=$html.' 
'; $db->free_result($result); return $html; } //=============================== function ShowCDMusicList($num,$spid,$vorder) { global $db; $sql="SELECT movieid,title,thumb,my_singer,catid,specialid FROM ".channel_table('movie', 32)." where status=3 and specialid=".$spid." "; $sql=$sql."ORDER BY ".$vorder." DESC LIMIT ".$num.""; $result=$db->query($sql); $html=$html.''; $html=$html.''; while($rs=$db->fetch_array($result)) { $songname=$rs['title']; $songid=$rs['movieid']; $singer=$rs['my_singer']; $catid=$rs['catid']; $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; } $html=$html.''; //$html=$html.''; $html=$html.''; $html=$html.''; $html=$html.'
'.$singer.''.$songname.'
'; $html=$html.''; $html=$html.' '; $html=$html.' 
'; $db->free_result($result); return $html; } //============================== function ShowLeftMusicList($num,$isflag,$catid,$vorder) { global $db; $sql="SELECT movieid,title,thumb,my_singer,catid,hits FROM ".channel_table('movie', 32)." where status=3 AND my_bianhao='' "; switch($isflag) { case 1: $sql=$sql." and catid=".$catid." "; break; default: $sql=$sql; break; } $sql=$sql."ORDER BY ".$vorder." DESC LIMIT ".$num.""; $result=$db->query($sql); $i=0; $html=$html.''; while($rs=$db->fetch_array($result)) { $i=$i+1; $songname=$rs['title']; $songid=$rs['movieid']; $singer=$rs['my_singer']; $catid=$rs['catid']; $hits=$rs['hits']; $html=$html.''; //$html=$html.''; //$html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; } $html=$html.''; $html=$html.'
'.$hits.''.$songname.''.shownumber($i).'
'; $db->free_result($result); return $html; } function ShowPlayMusicList($num,$isflag,$catid,$vorder) { global $db; $sql="SELECT movieid,title,thumb,my_singer,catid,hits FROM ".channel_table('movie', 32)." where status=3 AND my_bianhao='' "; switch($isflag) { case 1: $sql=$sql." and catid=".$catid." "; break; default: $sql=$sql; break; } $sql=$sql."ORDER BY ".$vorder." DESC LIMIT ".$num.""; $result=$db->query($sql); $i=0; $html=$html.''; while($rs=$db->fetch_array($result)) { $i=$i+1; $songname=$rs['title']; $songid=$rs['movieid']; $singer=$rs['my_singer']; $catid=$rs['catid']; $hits=$rs['hits']; if($i%2==0){ $iscolor='#FFFFFF'; }else{ $iscolor='#FDF8F2'; } $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; $html=$html.''; } $html=$html.''; $html=$html.'
'.$songname.''.shownumber($i).'
'; $db->free_result($result); return $html; } //============================== //ShowCD(9,32,'specialid',3,80,90) function ShowCD($num,$chid,$vorder,$ismod,$imgW,$imgH) { global $db; $sql="SELECT specialid,arrchildid,specialname,keyid,specialpic,addtime,keyid,hits FROM phpcms_special where keyid=".$chid." and parentid=0 ORDER BY ".$vorder." DESC LIMIT ".$num.""; $result=$db->query($sql); $html=''; $html=$html.''; $i=0; while($rs=$db->fetch_array($result)) { $i=$i+1; $picurl=$rs['specialpic']; $specialname=$rs['specialname']; $spsinger=ShowCDsinger($rs['arrchildid']); $addtime=date('Y-m-d',$rs['addtime']); $hits=$rs['hits']; $html=$html.''; /* $html=$html.''; } } $html=$html.''; $html=$html.'
پىلاستىنكا:'.$specialname.''; $html=$html.'
تۈرى :'.$spsinger; if($vorder!='hits'){ $html=$html.'
ۋاقىت:'.$addtime; }else{ $html=$html.'
ئاۋاتلىقى :'.$hits; } $html=$html.'
ئاڭلاش'; $html=$html.'
'; */ $html=$html.'
'.str_cut($specialname,28).''; $html=$html.'
'.$spsinger; if($vorder!='hits'){ $html=$html.'
ۋاقىت:'.$addtime; }else{ //$html=$html.'
'.$hits; } //$html=$html.'
ئاڭلاش'; $html=$html.'
'; if($i%$ismod==0) { $html=$html.'
'; $db->free_result($result); return $html; } //============================= function ShowAllCD($chid,$imgW,$imgH) { global $db; $sql="SELECT specialid,arrchildid,specialname,keyid,specialpic,addtime,hits FROM phpcms_special where arrchildid=".$chid." and parentid=0 and specialid>0 and keyid='32' ORDER BY specialid DESC"; $result=$db->query($sql); $html=''; while($rs=$db->fetch_array($result)) { $html=$html.''; $picurl=$rs['specialpic']; $specialname=$rs['specialname']; $spsinger=ShowCDsinger($rs['arrchildid']); $addtime=date('Y-m-d',$rs['addtime']); $hits=$rs['hits']; $html=$html.''; $html=$html.''; } $html=$html.'
نامى:'.str_cut($specialname,40).''; $html=$html.'
تۈرى :'.$spsinger; if($vorder!='hits'){ $html=$html.'
ۋاقىت'.$addtime; $html=$html.'
ئاۋاتلىقى:'.$hits; } //$html=$html.'
ئاڭلاش'; $html=$html.'
'; $html=$html.'
'; $db->free_result($result); return $html; } //============================= function shownumber($number) { if($number<=9) { $numberList='0'.$number; }else{ $numberList=$number; } return $numberList; } //======================================= function ShowMTVList($num,$isflag,$vorder,$modnum,$imgW,$imgH,$keywords) { global $db; $divW=$imgW+3; $divH=$imgH+3; $sql="SELECT movieid,catid,title,thumb,my_singer FROM ".channel_table('movie', 15)." where status=3 "; switch($isflag) { case 1: $sql=$sql." and title like '%".$keywords."%' "; break; case 2: $sql=$sql." and my_singer like '%".$keywords."%' "; break; case 3: $sql=$sql." and title like '%".$keywords."%' "; break; default: $sql=$sql; break; } $sql=$sql."ORDER BY ".$vorder." DESC LIMIT ".$num; $result = $db->query($sql); $i=0; $html=''; $html=$html.''; while($rs = $db->fetch_array($result)) { $i=$i+1; $mtvid=$rs['movieid']; $keywords='uploadfile'; $okey='uploadfile_mtv'; $listurl=$rs['thumb']; $murl=explode("/",$listurl); $lurl=$murl[2]; if($lurl!=$okey){ $listurl=str_replace($keywords,$okey,$lurl); $listurl='/uploadfile/mtv/'.$listurl.'/'.$murl[3].'/'.$murl[4]; }else{ $listurl='/'.$listurl; } $mtvname=$rs['title']; $html=$html.''; if($i%$modnum==0) { $html=$html.''; } } $html=$html.''; $html=$html.'
'; //$html=$html.'
'; $html=$html.'
'; $html=$html.''; $html=$html.'
'; $html=$html.'
'; $html=$html.''.str_cut($mtvname,24).''; $html=$html.'
'; //$html=$html.'
'; //$html=$html.''.$mtvname.''; //$html=$html.'
'; $html=$html.'
'; $db->free_result($result); return $html; } //================================= function ShowSinger($catid) { global $db; $sql="SELECT my_singer from phpcms_movie_32 where catid=".$catid." and my_singer!='' group by my_singer"; $rstur=$db->query($sql); while($rs=$db->fetch_array($rstur)) { $my_singer=$rs['my_singer']; $mysinger=$mysinger.'['.$my_singer.']'.'   '; } $db->free_result($rstur); return $mysinger; } function ShowCD_new($num,$chid,$vorder,$ismod,$imgW,$imgH,$bigimg=0) { global $db; $sql="SELECT specialid,arrchildid,specialname,keyid,specialpic,addtime,keyid,hits FROM phpcms_special where keyid=".$chid." and parentid=0 ORDER BY ".$vorder." DESC LIMIT ".$num.""; $result=$db->query($sql); $html=''; $html=$html.''; $i=0; while($rs=$db->fetch_array($result)) { $i=$i+1; $picurl=$rs['specialpic']; $specialname=$rs['specialname']; $spsinger=ShowCDsinger($rs['arrchildid']); $addtime=date('Y-m-d',$rs['addtime']); $hits=$rs['hits']; $html=$html.''; if($i%$ismod==0) { $html=$html.''; } } $html=$html.''; $html=$html.'
'; $html=$html.'
'; $html=$html.'
'.str_cut($specialname,33).'
'; $html=$html.'
'; $db->free_result($result); return $html; } ?> bilqut.com
نۆۋەتتىكى ئورنىڭىز: باش بەت >>
0 and catid=".$catid." group by specialid order by specialid desc"; $rstur=$db->query($sql); ?> num_rows($rstur); $filename='AwazTur.php?catid='.$catid.'&'; $currpage=$page? intval($page):$page=1; if(!is_int($currpage)) $currpage=1; if(intval($currpage)<1)$currpage=1; if(intval($currpage-1)*$pagesize>$total)$currpage=1; if(($total%$pagesize)==0) { $totalpage=intval($total/$pagesize); } else $totalpage=intval($total/$pagesize)+1; if ($total!=0&&$currpage>1) mysql_data_seek($rstur,(($currpage-1)*$pagesize)); $i=0; while($rs=$db->fetch_array($rstur)) { $arrchildid=$rs['specialid']; $i++; if($i>$pagesize)break; ?> "); } } ?> free_result($rstur); ?>

جەمىئىي تال ئۇچۇر بار  باش بەت ئالدىنقى بەت  كىيىنكى بەت ئاخىرقى بەت  بەت :  تال/بەت  
 
ئاۋات ئەسەرلەر
ئاۋات ئەسەرلەر