[insert_php]

global $wpdb;

$brain_id = $_GET[‘brain_id’];
$label = $_GET[‘label’];

$results = $wpdb->get_results(“SELECT Navigator_section.jp2Image, Navigator_section.slideIndex FROM Navigator_section WHERE Navigator_section.brain_id=$brain_id AND Navigator_section.label=’$label’ AND Navigator_section.isDamaged=0 AND Navigator_section.reImage=0 ORDER BY Navigator_section.slideIndex ASC”);

$new_images = array();
$new_images_index = array();
if ($results) {
foreach ($results as $row) {
$new_images[] = $row->jp2Image;
$new_images_index[] = $row->slideIndex;
}
}

if($label == ‘N’){
$video_results = $wpdb->get_results(“SELECT Navigator_video.video_link FROM Navigator_video WHERE Navigator_video.brain_id=$brain_id AND Navigator_video.label=’$label'”);

$new_video = array();
if ($video_results) {
foreach ($video_results as $row) {
$new_video[] = $row->video_link;
}
echo do_shortcode(“

‘;
}
}

echo do_shortcode(“

for ($x = 0; $x <= sizeof($new_images); $x++) { $image = $new_images[$x]; $image_slide_index = $new_images_index[$x]; $image_link = explode('||', $image); $less_image = explode('.jp2',$image_link[0]); $link_address = $image_link[1].split('?')[1]; $pid_and_fid = $link_address.split('?')[1]; $ol_image = 'http://mitra.brain.riken.jp/openlayers/ol4_cross.html?brain_id='.$brain_id.'&label='.$label.'&'.$link_address; $jak_image = 'http://mitra.brain.riken.jp:3000/adore-djatoka/viewer/viewer2.html?brain_id='.$brain_id.'&label='.$label.'&'.$pid_and_fid; echo '

‘;
echo ‘‘;
echo ‘slide: ‘.$image_slide_index.’‘;
echo ‘OLs‘;
//echo ‘IIP‘;
echo ‘

‘;
}
[/insert_php]