<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
chdir ($curdir);
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Svex</title>
<?php include 'header.php
'; ?> <link rel="stylesheet" type="text/css" href="scripts/css/svex.css" />
<script src="scripts/js/svexmenu.js" type="text/javascript"> </script>
<style type="text/css">
<!--
div.svexmenu {color:#5B6275; font-family: Arial; font-size: 17px}
div.svexmenu a {color:#5B6275; font-family: Arial; font-size: 17px}
div.svexmenu a:hover {color:#3C404D; font-family: Arial; font-size: 17px}
div.svextitle {color:#FFFFFF; font-family: Arial; font-size: 22px}
div.svextitle a {color:#FFFFFF; font-family: Arial; font-size: 22px}
div.svextitle a:hover {color:#5B6275; font-family: Arial; font-size: 22px}
div.svexuser {color:#DCDFE1; font-family: Arial; font-size: 17px}
div.svexuser a {color:#DCDFE1; font-family: Arial; font-size: 17px}
div.svexuser a:hover {color:#5B6275; font-family: Arial; font-size: 17px}
.style34 {
font-family: Arial;
color: #5B6275;
}
a:link {
color: #FFFFFF;
}
a:visited {
color: #FFFFFF;
}
a:hover {
color: #A8AEB8;
}
a:active {
color: #FFFFFF;
}
.style36 {color: #000000}
body,td,th {
color: #FFFFFF;
}
-->
</style>
</head>
<body>
<?php
/* CONNECTION VARIABLES */
$db_hostname = ""; // Usually "localhost"
$db_username = "";
$db_password = "";
$db_name = "";
$table = "";
$sql = "SELECT * FROM WHERE cat1 = 'SimCity 4' AND validator !='' ORDER BY id DESC LIMIT 0,6";
$result=mysql_query($sql);
$row = @mysql_fetch_array($result);
$sql = "SELECT * FROM WHERE cat1 = 'SimCity 4' AND validator !='' ORDER BY id DESC LIMIT 0,6";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
$archive = $row['archive'];
?>
<div style="width: 748px; height: 200px; background-color:#A8AEB8;">
<div style="width: 748px; height: 21px; background-image:url(images/index/common/headblue.jpg); background-color:#A8AEB8;"> <?php echo $row['cat2']; ?> > <?php echo $row['cat3']; ?> </div>
<div style="width: 261px; float: left; padding-left: 6px; height: 200px; background-color:#A8AEB8;">
<div style="width: 257px; height: 148px; padding-top: 22px; background-color:#A8AEB8;">
<img src="<?php echo $row['thumburl1']; ?>" alt="" width="254" height="148" border="3" style="border-color: #5B6275;"
/>
</div>
</div>
<div style="float: left; width: 480px; height: 200px; background-color:#A8AEB8;">
<div class="svextitle" style="float: left; width: 480px;"> <a href="http://simvision.net/svex.php?p=details&id=<?php echo $row['id']; ?> "><?php echo $row['name']; ?></a></div>
<div class="svexuser" style="float: left; width: 480px;"> <a href="http://www.simvision.net/svex.php?p=user&id=<?php echo $row['userid']; ?>">by <?php echo $row['username']; ?></a> </div>
<div style="float: left; width: 480px; height: 100px;"><?php echo substr($row['descrip'],0,150); ?>... </div>
<div style="float: left; width: 480px; background-color:#B5B5B5; height: 35px;">
<?=date("F j, Y",$row["dt"])?> | Views <?php echo $row['views']; ?> | Downloads: <?php echo $row['dls']; ?> |
<?php $score = $row['score'];
$votes = $row['votes'];
if ( $votes == 0 ) {
echo "No Votes";
} else {
$total = $score / $votes;
$stars = $total / 2;
$starstotal = ceil($stars);
switch ($starstotal){
case "1":
?> <img src="images/index/common/star.png" /><?php
break;
case "2":
?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
break;
case "3":
?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
break;
case "4":
?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
break;
case "5":
?><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /><img src="images/index/common/star.png" /> <?php
break;
}
?>
</div>
</div>
</div>
<div style="height: 10px; width: 748px; color: #FFFFFF"> </div>
<?php
}
}
die(mysql_error())
?>
</body>
</html>