* * File Name : screenshots.html * Last Update : 2010-12-29 */ include('glob/start.php'); create_thispage($thispage['id'],$thispage['uri'],$thispage['title']); $convertotoo = array(1=>'added-'.$column['default_direction']['added'],2=>'update-'.$column['default_direction']['update']); if($_GET['s'] && $convertotoo[$o]) $o = $convertotoo[$o]; $c_inheadOFFF = '

'; $result = $sm_db->query("SELECT i.id, i.topic_id, i.filename FROM img_i as i LEFT JOIN (img_d as d, img_d as d2, img_d as d3) ON d.img_i=i.id and d2.img_i=d.img_i and d3.img_i=d.img_i WHERE i.page_id='".SITE_PAGE_GAMES."' and (d.size='400' or d.size='600') and d.server!='' and d.status='1' and d2.size='100' and d2.server!='' and d2.status='1' and d3.size='150' and d3.server!='' and d3.status='1' GROUP BY i.id ORDER BY d.dateon DESC, i.filename DESC") or mysql_die($sm_db); while($result && $db = mysqli_fetch_assoc($result)){ if($games_online[$db['topic_id']]){ $res[$db['topic_id']]['title'] = $games_title[$db['topic_id']]; $res[$db['topic_id']]['filename'][] = $db['filename']; } } if($res){ $c_body .= '

'; foreach($res as $key=>$val){ $c_i++; $c_body .= '

'.$res[$key]['title'].'Screenshots

'; if($c_i>=6) break; } $c_body .= '

'; unset($res); } $page[PAGE_ID]['columns'] = array('title'=>1,'added'=>1,'update'=>1); $order_check = explode('-',$o); if(!$page[PAGE_ID]['columns'][$order_check[0]] || !$column['direction'][$order_check[1]]) $o = 'update-1'; $order = explode('-',$o); $start = (!$start or !is_int($start/LIST_LIMIT) or $start!=abs(intval($start))) ? 0:$start; $comments_total = $games_comp_count['img']; /* $result = $sm_db->query("SELECT g.id, MIN(d.dateon) as dateadd, MAX(d.dateon) as dateedit, date_format(MAX(d.dateon), '%d.%m.%y') as showdateedit, date_format(MIN(d.dateon), '%d.%m.%y') as showdateadd, COUNT(DISTINCT d2.img_i) as total FROM games as g LEFT JOIN (img_i as i, img_d as d, img_d as d2) ON i.page_id='".SITE_PAGE_GAMES."' and i.topic_id=g.id WHERE g.gal!='' and g.status='1' and d.img_i=i.id and (d.size='400' or d.size='600') and d.server!='' and d.status='1' and d2.img_i=d.img_i and d2.size='100' and d2.server!='' and d2.status='1' GROUP BY g.id ORDER BY ".$column['mysql'][$order[0]]." ".$column['direction'][$order[1]]." LIMIT ".$start.",".LIST_LIMIT) or mysql_die($sm_db); $querynum2++; while($result && $db = mysqli_fetch_assoc($result)){ $res[$db['id']]['title'] = $games_title[$db['id']]; $res[$db['id']]['total'] = $db['total']; $res[$db['id']]['dateadd'] = $db['showdateadd']; $res[$db['id']]['dateedit'] = $db['showdateedit']; $ttt++; } */ $result = $sm_db->query("SELECT g.id, MIN(d.dateon) as dateadd, MAX(d.dateon) as dateedit, date_format(MAX(d.dateon), '%d.%m.%y') as showdateedit, date_format(MIN(d.dateon), '%d.%m.%y') as showdateadd, COUNT(DISTINCT d2.img_i) as total FROM games as g LEFT JOIN (img_i as i, img_d as d, img_d as d2) ON i.page_id='".SITE_PAGE_GAMES."' and i.topic_id=g.id WHERE d.img_i=i.id and (d.size='400' or d.size='600') and d.server!='' and d.status='1' and d2.img_i=d.img_i and d2.size='100' and d2.server!='' and d2.status='1' GROUP BY g.id ORDER BY ".$column['mysql'][$order[0]]." ".$column['direction'][$order[1]]." LIMIT ".$start.",".LIST_LIMIT) or mysql_die($sm_db); $querynum2++; while($result && $db = mysqli_fetch_assoc($result)){ $res[$db['id']]['title'] = $games_title[$db['id']]; $res[$db['id']]['total'] = $db['total']; $res[$db['id']]['dateadd'] = $db['showdateadd']; $res[$db['id']]['dateedit'] = $db['showdateedit']; $ttt2++; } $c_body .= ' '; if($res){ $c_body .= ' '; foreach($res as $key=>$val){ $c_body .= ' '; } } ////// p a g e s $c_body .= '

Titel (Bilder)	Erstellt	Update
'.$res[$key]['title'].' ('.$res[$key]['total'].')	'.$res[$key]['dateadd'].'	'.$res[$key]['dateedit'].'

'.BrowsePages(PAGE_PARENT_ID,$start,0,$comments_total,LIST_LIMIT); include('glob/end.php'); ?>