Code-Bin #213

untitled PHP Code
Posted by: sixers | January 14, 2009 @ 12:06am

PHP Code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
$curdir = getcwd ();
chdir('forum');
require_once(global.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>

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>

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.72 / 8
198 Votes