get_results($sql);
$talkfile_link = '';
if($rows){
$talkfile_link = $rows[0]->talkfile_link;
}
# add log
$date = date('Y-m-d H:i:s');
$a = array('user_no'=>$user_no, 'speaker_id'=>$rows[0]->id,'talkfile_link'=>$talkfile_link,'create_datetime'=>$date);
$a['ip']=isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] :'';
$a['user_agent']=isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] :'';
$a['session_id']=session_id();
$wpdb->insert(TBL_AGENDA_FILE_LOG, $a);
# redirect...
if($talkfile_link){
header('location:'.$talkfile_link);
echo'file link: '.$talkfile_link.'';
}else{
echo'not found file.';
}