check_data('check_intF');
$i_screen = new lp_input('screen','G',1);
$screen = $i_screen->check_data('check_intF');
if($site != 0){
$query = "SELECT * from sites where id = '$site'";
$sq = $mydb->do_query($query);
$data = $mydb->fetch_assoc($sq);
if(empty($data)){
$site = 0;
$screen = 1;
}
}
if($site == 0){
$rot = array(3,3,3,3,3,2,2,1);
shuffle($rot);
$rand = end($rot);
$query = "SELECT * from sites where rotation = '$rand' ORDER by RAND() limit 1";
$sq = $mydb->do_query($query);
$data = $mydb->fetch_assoc($sq);
$site = $data['id'];
}
// get screen
$query = "SELECT SQL_CALC_FOUND_ROWS sortorder, image, para from screens where site_id='$site' and para != '' ORDER BY ( sortorder = '$screen' ) DESC, sortorder Limit 1";
$cq = $mydb->do_query($query);
list($data['snum'],$data['screen'],$data['para']) = $mydb->fetch_row($cq);
$query = "SELECT FOUND_ROWS()";
$fq = $mydb->do_query($query);
list($screens) = $mydb->fetch_row($fq);
$screens = $screens + 0;
$screenlinks = '';
if($screens > 1){
$screenlinks = '
';
for($i=1;$i<$screens+1;$i++){
if($i == $screen){
$screenlinks .= ' | ';
}else{
$link = 'portfolio.html?site='.$site.'&screen='.$i;
$screenlinks .= ' | ';
}
$screenlinks .= ' | ';
}
$screenlinks .= '
';
}
$data['url'] = trim($data['url']);
if( strpos($data['url'],'http://') === 0 ){
$url = '';
$slasha = '';
$launch = '';
} else {
$url = '';
$slasha = '';
$launch = '';
}
$urltext = (empty($data['url'])) ? '' : '('.str_replace('http://','',$data['url']).')';
$query = "SELECT id, linkimage, title from sites where id != '$site' order by sortorder < 1, sortorder, id ";
$lq = $mydb->do_query($query);
$links = array();
while($row = $mydb->fetch_assoc($lq)){
$links[] = ' | ';
}
$linktable = '';
$chunked = array_chunk($links, 3);
$rowspan = count($chunked) ;
$rowspan = $rowspan + $rowspan - 1;
$spacer = ' | ';
$spacers = array($spacer,$spacer,$spacer);
$row1 = array_shift($chunked);
$linetd = ' | ';
$linktable .= ''.$row1[0].$linetd.$row1[1].$linetd.$row1[2].'
';
$linktable .= ''.implode('',$spacers)."
\n";
foreach($chunked as $onerow){
$onerow = array_pad($onerow, 3, ' | ');
$linktable .= ''.implode('',$onerow)."
\n";
$linktable .= ''.implode('',$spacers)."
\n";
}
$linktable .= '
';
include_once('./portfolio.tmpl');
include_once('./template.html');
?>