- Joined
- Jul 10, 2008
- Messages
- 199
- Reaction score
- 56
PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.red {
color: #800000;
}
.grey {
color: #000000;
}
.gold {
color: #BEC402;
}
.blue {
color: #0080FF;
}
.green {
color: #00FF40;
}
.themain {
background: #901b1b;
-moz-border-radius: 8px 8px 8px 8px;
}
.topp1 {
background: #b02c2c;
color: #ffcfcf;
font-weight: bold;
-moz-border-radius: 8px 0 0 0;
}
.topp2 {
background: #b02c2c;
color: #ffcfcf;
font-weight: bold;
}
.topp3 {
background: #b02c2c;
color: #ffcfcf;
font-weight: bold;
-moz-border-radius: 0 8px 0 0;
}
.trhover {
background: #FFFFFF;
}
.trhover:hover{background: #ffeab0;}
.trhover:active{background: #ffeab0;}
-->
</style>
</head>
<body>
<table width="70%" align="center" cellspacing="0" cellpadding="0">
<tr align="center">
<td><span style="font-size: 30px;color: #901b1b;font-weight: bold;">Married Users</span></td>
</tr>
<tr>
</tr>
</table>
<BR>
<div align="center">
<table width="50%" class="themain" align="center" cellspacing="0" cellpadding="2"><tr><td>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td align="center" class="topp1">Wife</td>
<td align="center" class="topp3">Husband</td>
</tr>
<?
$query=mssql_query("select TOP 50 * from MuOnline.dbo.Character Where (SCFMarried = '1') and (class like '34') or (SCFMarried = '1') and (class like '33') or (SCFMarried = '1') and (class like '32') or (SCFMarried = '1') and (class like '80') or (SCFMarried = '1') and (class like '81') or (SCFMarried = '1') and (class like '82') order by Name ASC");
while($row=mssql_fetch_assoc($query)){
$namez=$row['Name'];
$marriedwith=$row['SCFMarryHusbandWife'];
?>
<tr>
<td class="trhover" align="center"><?=$namez;?></a></td>
<td class="trhover" align="center"><?=$marriedwith;?></td>
</tr>
<?
}
?>
</table>
</td></tr></table><BR>
</div>
</body>
</html>
Credits: GamezEventosMu
