<%
	# $Id: wall-of-ancients-uncached.php,v 1.7 2005/10/23 02:23:12 hirokai Exp $

	$page = "options";
	$mesg = "input options:";
	include_once( "modules/utils.inc.php" );

%>
<!-- $Id: wall-of-ancients-uncached.php,v 1.7 2005/10/23 02:23:12 hirokai Exp $ -->

<title> Feed me links : Marvel at the WALL OF ANCIENTS </title>

<% 
	include( "$modules/header.inc.php" ); 
%>
<br />
<br />
<table>
<tr>
<td class="header">#</td>
<td class="header">user</td>
<td class="header">born on:</td>
<td class="header">links</td>
<td class="header"><%= getCatsName() %></td>
</tr>
<tr>
	<td colspan="4"></td>
</tr>
<%
	$con_wallOfAncients = mysql_connect();
	mysql_selectdb( getDBName() );
	$qs = "SELECT * from linksUsers ";
	$q = mysql_query( $qs );
	$numRows = mysql_num_rows($q);
	if( $numRows ) {
		$i = 0;
		while ($c < $numRows) {
			$c++;
		}
%> <%= $c %> linksters.<br />
<%
		while ($i < $numRows) {
		
			$id = mysql_result($q,$i,"id");
			$userId = mysql_result($q,$i,"userId");
			$email = urldecode( mysql_result($q,$i,"email"));
			$emails = $emails . $email . ", ";

			# count links
			$qs2 = "SELECT count(*) FROM links WHERE submitter='$userId'";
			$q2 = mysql_query( $qs2 );
			if( $q2 ) $numLinks = mysql_result($q2,0);

			# count folders
			$qs2 = "SELECT count(*) FROM linksGroups WHERE userid='$userId'";
			$q2 = mysql_query( $qs2 );
			if( $q2 ) $numFolders = mysql_result($q2,0);
			
			$qs2 = "SELECT min(createDate) FROM links WHERE createDate > 0 AND submitter='$userId'";
			$q2 = mysql_query( $qs2 );
			if( $q2 ) 
				$bornOnDate = mysql_result($q2,0);
			if( $numLinks > 1 ) {

%>
<tr>
		<td>
			<%= ($i + 1 < 10 ) ? "&nbsp;" . ($i + 1) : $i + 1 %>
		</td>
		<td>
			<%= makeUserLink( $userId ) %>
		</td>
		<td>
			<%= $bornOnDate ? formatTS( $bornOnDate ) : "(user has no links)" %>
		</td>

		<td>
		<%= $numLinks %> links
		</td>
		
		<td>
		<%= $numFolders %> <%= getCatsName() %>
		</td>

	</tr>
<%
		}
			$i++;
			}
			conClose( $con_wallOfAncients);
		}
%>

</table>
<br />
<% include( "$modules/footer.inc.php" ); %>