'); if($_REQUEST['id']!="")dpInterview($_REQUEST['id']); else dpInterviewFullList(); print(''); print('

'); if($_REQUEST['id']!=""){ dpInterviewList(3,$_REQUEST['id']); dpInterviewReview($_REQUEST['id']); } else dpBlogList(); print('
'); } //==================================================================== function dpInterviewInc($id){ global $db; $inv=""; if($id!=""){ $result=mysql_query("select feature_title,feature_filename from cz_feature where feature_status<10 and feature_id=".$id,$db); if( ($rs=mysql_fetch_array($result)) ){ $inv=$rs['feature_filename']; $gbMaintitle=$rs['feature_title']; } mysql_free_result($result); } if($inv!=""){ if(file_exists("../_incfile/interview/".$inv.".inc")){ include("../_incfile/interview/".$inv.".inc"); print("

"); mysql_query("update cz_feature set view_cnt=view_cnt+1,view_last_dt=now(),view_last_ip='".$_SERVER['REMOTE_ADDR']."' where view_last_ip<>'".$_SERVER['REMOTE_ADDR']."' and feature_id=".$id,$db); } else print("

Interview not found."); } else dpInterviewFullList(); } //==================================================================== function dpInterview($id){ global $db; $result=mysql_query("select * from cz_feature where feature_status<10 and feature_id=".$id,$db); if( ($rs=mysql_fetch_array($result)) ){ print(''); print(''); if($rs['feature_body']!="")print(''); print('
 Profile: '.$rs['artist_name'].'


'); print(''); print('Name: '.$rs['artist_name'].'
'); if($rs['artist_website']!="")print('Website: '.str_removehttp($rs['artist_website']).'
'); if($rs['artist_fb']!="")print('Facebook: '.str_removehttp($rs['artist_fb']).'
'); if($rs['artist_ethnicity']!="")print('Ethnicity: '.$rs['artist_ethnicity'].'
'); if($rs['artist_from']!="")print('From: '.$rs['artist_from'].'
'); print($rs['feature_bio'].'
 Introduction

'.str_replace("\n","
",$rs['feature_body']).'

 Interview: '.$rs['artist_name'].'
interviewed on '.fmtdate("F j,Y",$rs['feature_dt']).'

'); print('
    '); $rexult=mysql_query("select * from cz_feature_question where feature_id=".$id." order by qnum",$db); while( ($rx=mysql_fetch_array($rexult)) ){ print('
  1. '.$rx['question'].'

    '.$rx['answer'].'

    '); if($rx['hasimg']!=0)print('


    '); } mysql_free_result($rexult); print('
'); print('
'); } mysql_free_result($result); } //==================================================================== function str_removehttp($str){ if(substr($str,0,11)=="http://www.")return substr($str,11); if(substr($str,0,7)=="http://")return substr($str,7); } //======================================================= function dpInterviewReview($id){ GLOBAL $db,$gbMemID; divConfirm('confirmCmtDel','delete?','Delete','interviewCmtDelete(document.fmconfirmCmtDel);'); ?> Comments
'); if($gbMemID==0){ print('

Please Login to comment


'); } else{ print('


'); print('
  
'); } print('

'); //------------------------------------------ print(''); } //==================================================================== function dpInterviewFullList(){ global $db; $filename="interview.php"; $filter=""; $maxshown=10; $feacnt=0; //------------------------------------------ $result=mysql_query("select count(feature_id) as cnt from cz_feature where feature_status=1".$filter,$db); if( ($rs=mysql_fetch_array($result)) ){ $feacnt=$rs['cnt']; } mysql_free_result($result); if($feacnt==0){ return; } //------------------------------------------ $curpage=1; if(isset($_GET['st']))$curpage=$_GET['st']; $curpos=($curpage-1)*$maxshown+1; //------------------------------------------ $result=mysql_query("select * from cz_feature where feature_status=1".$filter." order by feature_dt desc LIMIT ".($curpos-1).",".($maxshown),$db); if( ($rs=mysql_fetch_array($result)) ){ $cnt=0; print(''); do{ if($cnt%2==0){ if($cnt>0)print(''); print(''); } print(''); ++$cnt; }while( ($rs=mysql_fetch_array($result)) ); if($cnt%2==1)print(''); if($cnt>0)print(''); print('
  Interviews ['.$feacnt.' Listed]


'. ''.$rs['feature_title'].'
'. 'featured on '.fmtdate("D, M.j.y",$rs['feature_dt']).'
'. cutstr($rs['feature_brief'],180).'
'); if($feacnt>$maxshown)print('
'.writepages($feacnt,$maxshown,$curpage,"interview.php?").'
'); } mysql_free_result($result); } ?>