View file new_fo/edit/index.php

<?php
if (!defined('SECURED'))
{
	die("Unknown Error!");
}

title('GEOPAK FILE SHARE');
div('<b>File Share Area '.$config['site'].'</b>','b');
echo $msg;
echo $separator;
echo'<img src="images/k.gif" alt="[K]"/> <b><a href="'.$_SERVER['PHP_SELF'].'?mode=agreement&amp;'.SID.'"> Agreement</a></b><br/>';
echo $separator.'<img src="images/u.gif" alt="[U]"/> <b><a href="'.$_SERVER['PHP_SELF'].'?mode=upload&amp;'.SID.'">Upload file</a></b><br/>'.$separator;

echo'<b>New Files</b><br/>';
$today_midnight=mktime(0,0,0,date('m'),date('d'),date('Y'));
$yesterday_midnight=$today_midnight - (24*3600);
$and_for="uploaded>$today_midnight";
$and_for_yesterday="uploaded>$yesterday_midnight";
$files=mysql_result(mysql_query("select count(id) from files where $and_for;"),0);
echo'<img src="images/r.gif" alt="[N]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=new&amp;for=today&amp;'.SID.'">For today</a>('.$files.')<br/>';
$files_yesterday=mysql_result(mysql_query("select count(id) from files where $and_for_yesterday;"),0);
echo'<img src="images/r.gif" alt="[N]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=new&amp;for=yesterday&amp;'.SID.'">Yesterday</a>('.$files_yesterday.')<br/>';
echo $separator;
echo'<img src="images/top.gif" alt="[T]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=top&amp;for=users&amp;'.SID.'">Top 100 Users</a><br/>';
echo'<img src="images/top.gif" alt="[T]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=top&amp;for=files&amp;'.SID.'">?op 100 Files</a><br/>';
echo $separator;
echo'<img src="images/u.gif" alt="[U]"/> <b><a href="'.$_SERVER['PHP_SELF'].'?mode=upload&amp;'.SID.'">Upload file</a></b><br/>';
echo $separator;
$q=mysql_query("select * from categorys where parent='0' order by position;");
while($category=mysql_fetch_array($q))
{
	$files=mysql_result(mysql_query("select count(id) from files where refcat='".$category['id']."';"),0);
	$text='<img src="images/dir.gif" alt="[DIR]"/> <b><a href="'.$_SERVER['PHP_SELF'].'?mode=cat&amp;id='.$category['id'].'&amp;'.SID.'">'.$category['name'].'</a></b> ('.$files.')';
	div($text,'f');
	if(!empty($category['desc'])) echo $category['desc'].'<br/>';

}
if($auth)
{
$user_files = mysql_result(mysql_query("SELECT COUNT(*) FROM `files` WHERE `author`='".$user['id'].'|'.$login."';"),0);
$users_online = mysql_result(mysql_query('SELECT COUNT(*) FROM `users` WHERE `last`>'.(time()-1200)),0);
$abuses = mysql_result(mysql_query('SELECT COUNT(*) FROM `files` WHERE `abuse`>0;'),0);
	echo'You are logged in as <b>'.$login.'</b><br/>';
	if($level>1) echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=admin&amp;'.SID.'">Admin panel</a><br/>';
	if($level>0) echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=mpanel&amp;act=viewabuses&amp;'.SID.'">Complaints</a>('.$abuses.')<br/>';
	echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=profile&amp;'.SID.'">Private</a><br/>';

$q_noread = mysql_query("SELECT COUNT(*) FROM `privat` WHERE `tonick` = '".$login."' AND `read` = '0';");
$noread_msg = mysql_result($q_noread, 0);
$q_all = mysql_query("SELECT COUNT(*) FROM `privat` WHERE `tonick` = '".$login."';");
$allmsg = mysql_result($q_all, 0);
	echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=privat&amp;'.SID.'">Messages</a>('.$allmsg.'/'.$noread_msg.')<br/>';
	echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=myfiles&amp;'.SID.'">Your files</a>('.$user_files.')<br/>';
	///echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=online&amp;'.SID.'">Online</a>('.$users_online.')<br/>';
	echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?exit&amp;'.SID.'">Log out</a><br/>'.$separator;
} else
{
	echo '<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=auth&amp;'.SID.'">Login</a><br/>';
	echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=reg&amp;'.SID.'">Register</a><br/>'.$separator;
}
$all_users = mysql_result(mysql_query("select count(id) from users;"),0);

echo'<img src="images/co.gif" alt="[CO]"/> <a href="'.$_SERVER['PHP_SELF'].'?mode=top&amp;for=users&amp;all&amp;'.SID.'">For registered('.$all_users.')</a><br/>'.$separator;























?>