View file index.php

File size: 2.82Kb
<?php
session_start();

require 'config.php';
require 'php/functions.php';

require 'lang/'.LANG.'.php';

@mysql_connect(DB_HOST, DB_USER, DB_PASS) or die('Please view the <b>config.php</b> file.');
@mysql_select_db(DB_NAME) or die('Please view the <b>config.php</b> file.');

define('WEB', ($_SERVER['SCRIPT_NAME'] == '/index.php')?'/':dirname($_SERVER['SCRIPT_NAME']).'/');
define('HTTP', 'http://'.$_SERVER['HTTP_HOST'].WEB);

// Album request
if(isset($_GET['a']))
{
	$album_id = alphaID($_GET['a'], true);
	
	if(mysql_num_rows($result = mysql_query('SELECT `date`, `upload_id` FROM `album` WHERE `id`='.$album_id)))
	{
		$row = mysql_fetch_row($result);
		
		$album_date = $row[0];
		
		if($row[1])
		{
			mysql_query('UPDATE `album` SET `upload_id`=NULL WHERE `id`='.$album_id);
		}
		
		$album = mysql_query('SELECT `id`, `extension`, `size`, `views` FROM `image` WHERE `album_id`='.$album_id.' ORDER BY `id` DESC');
		
		$image = mysql_fetch_assoc($album);
		
		if(mysql_num_rows($album) == 1)
		{
			unset($album);
		} else
		{
			mysql_data_seek($album, 0);
		}
	}
} else

// Image request
if(isset($_GET['i']))
{
	$image_id = alphaID($_GET['i'], true);
	
	if(mysql_num_rows($result = mysql_query('SELECT `id`, `album_id`, `extension`, `size`, `views` FROM `image` WHERE `id`='.$image_id)))
	{
		$image = mysql_fetch_assoc($result);
		
		$row = mysql_fetch_row(mysql_query('SELECT `date` FROM `album` WHERE `id`='.$image['album_id']));
		
		$album_date = $row[0];
		
		$album = mysql_query('SELECT `id`, `extension` FROM `image` WHERE `album_id`='.$image['album_id'].' ORDER BY `id` DESC');
		
		$album_id = $image['album_id'];
		
		if(mysql_num_rows($album) == 1) unset($album);
	}
}

if(isset($image))
{
	$alpha = alphaID($image['id']);
	
	mysql_query('UPDATE `image` SET `views`='.(++$image['views']).' WHERE `id`='.$image['id']);
	
	# Slides
	if(isset($album))
	{
		$slide = isset($_GET['slide'])?((int) $_GET['slide']):-1;
		
		$max_slide = ceil(mysql_num_rows($album)/6) - 1;
		
		if($slide < 0 || $slide > $max_slide)
		{
			$index = 0;
			
			while($tmp = mysql_fetch_assoc($album))
			{
				$index++;
				
				if($tmp['id'] == $image['id']) break;
			}
			
			$slide = ceil($index/6) - 1;
			
			mysql_data_seek($album, 0);
		}
	}
	
	require 'view/album.html';
} else
{
	$recent = mysql_query('SELECT `id` FROM `album` WHERE `upload_id` IS NULL ORDER BY `id` DESC LIMIT 0,12');
	
	$total_albums = mysql_fetch_row(mysql_query('SELECT COUNT(*) FROM album'));
	$total_images = mysql_fetch_row(mysql_query('SELECT COUNT(*) FROM image'));
	
	$total_amounts = sprintf($lang['total_amounts'],
		'<span>'.sprintf($lang['total_albums'], number_format($total_albums[0], 0, '.', $lang['thousand_separator'])).'</span>',
		'<span>'.sprintf($lang['total_images'], number_format($total_images[0], 0, '.', $lang['thousand_separator'])).'</span>'
	);
	
	require 'view/upload.html';
}