<html>
<head>
<title>Welcome to TycoonEden</title>
</head>
<body link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" text="#FFFFFF" bgcolor="#000000">
<p align="center"><img border="0" src="http://www.tycooneden.com/banner.jpg" width="480" height="100"></p>
<p align="center"><b><i><font size="5">Welcome to TycoonEden.com!</font></i></b><b><font size="5"><i><br>
</p></i></font></b><i><b><left><font size="4">The creator of the T.E.C.C. topsite clan system</font></left></b></i><left><b><font size="4">.
</font></b><br>
This is the new look TECC. The system is designed to be a topsite system for RCT
and RCT2 sites, but, it has a brilliant twist. It is winning competitions that
promote you up the chart. Each site owner gets full access to an admin area
which is fully automated. This allows you to add, delete and edit members. </left>
<p>To sign up to the TECC, email the following address:
<a href="mailto:zingbats_tyc@hotmail.com?subject=tecc">zingbats_tyc@hotmail.com</a> </p>
<p><br>
</p>
<div align="center">
<center>
<table border="3" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="80%" id="AutoNumber1" bordercolorlight="#999999" bordercolordark="#333333" bordercolor="#808080">
<?php
/* Connecting, selecting database */
$link = mysql_connect("localhost", "username", "password")
or die("Could not connect");
mysql_select_db("tycooneden_com") or die("Could not select database");
$query = "SELECT * FROM clans ORDER BY 'clan_points' DESC";
$result = mysql_query($query) or die("Query failed");
$num=0;
while($foo=mysql_fetch_array($result)){
$clan_url=$foo['clan_url'];
$clan_logo=$foo['clan_logo'];
$clan_admin=$foo['clan_admin'];
$clan_admin_email=$foo['clan_admin_email'];
$clan_forum=$foo['clan_forum'];
$clan_name=$foo['clan_name'];
$clan_logo_height=$foo['clan_logo_height'];
$clan_logo_width=$foo['clan_logo_width'];
$clan_points=$foo['clan_points'];
$num++;
}
?>
<tr>
<td width="13%" bgcolor="#CCFFFF"><font color="#000000">Position:</font></td>
<td width="70%" bgcolor="#CCFFFF"><font color="#000000">Clan Details</font></td>
<td width="17%" bgcolor="#CCFFFF"><font color="#000000">Points</font></td>
</tr>
<tr>
<td width="13%" bgcolor="#CCFFFF"><font color="#000000"><?=$num?></font> </td>
<td width="70%" bgcolor="#CCFFFF">
<a href="<?=$clan_url?>"><font color="#000000"><?=$clan_name?></font></a><font color="#000000"><br>
</b><br>
<?
$logo_location = "$clan_logo";
$fp = @fopen($logo_location,"r");
if ($fp == ""){
if ($clan_logo ==""){
?>
<font color="#000000">Sorry, no image has been specified
<?
}
else
{
?>
Sorry, no picture is avaliable for the clan <?=$clan_name?>
<?
}
} else {
?>
<img border="0" src="<?=$clan_logo?>" width="<?=$clan_logo_width?>" height="<?=$clan_logo_height?>">
<?
@fclose($fp);
?>
</font></font></font></td>
<td width="17%" bgcolor="#CCFFFF"><font color="#000000"><?=$clan_points?></font> </td>
</tr>
<?
}
?>
</table>
</center>
</div>
</body>
</html>
Take a look at http://www.tycooneden.com/tecc.php to see the what is going wrong.
