profile.inc

不错的东西

<?php
$query = $sql->query("SELECT a.id, a.firstname, a.lastname, a.company, a.address, a.city, a.state, a.zip, a.country, a.phone_num, a.fax_num, a.email, a.referrer, a.username, a.pay_method, a.package, a.level, a.status, a.hostname, a.date, c.pkg_type AS acct_type, IF(a.domain_type = 3, a.domain, CONCAT(a.domain, '.', b.domain)) AS domain FROM accounts AS a LEFT JOIN subdomains AS b ON (a.sdid = b.id) LEFT JOIN packages AS c ON (a.package = c.id) WHERE a.id = '" . $_SESSION['auth']['uid'] . "' AND level = '0' LIMIT 1") or die(mysql_error());

if(mysql_num_rows($query) == 1)
{
	$data = mysql_fetch_assoc($query);
	?>

	<table>
	<tr>
		<td>ID:</td>
		<td><?=$data['id']?></td>
	</tr>
	<tr>
		<td>Firstname:</td>
		<td><?=$data['firstname']?></td>
	</tr>
	<tr>
		<td>Lastname:</td>
		<td><?=$data['lastname']?></td>
	</tr>
	<tr>
		<td>Company:</td>
		<td><?=$data['company']?></td>
	</tr>
	<tr>
		<td>Address:</td>
		<td><?=$data['address']?></td>
	</tr>
	<tr>
		<td>City:</td>
		<td><?=$data['city']?></td>
	</tr>
	<tr>
		<td>State/Province:</td>
		<td><?=$states[$data['state']]?></td>
	</tr>
	<tr>
		<td>Zip Code:</td>
		<td><?=$data['zip']?></td>
	</tr>
	<tr>
		<td>Country:</td>
		<td><?=$countries[$data['country']]?></td>
	</tr>
	<tr>
		<td>Phone #:</td>
		<td><?=$data['phone_num']?></td>
	</tr>
	<tr>
		<td>Fax #:</td>
		<td><?=$data['fax_num']?></td>
	</tr>
	<tr>
		<td>Email Address:</td>
		<td><a href="mailto:<?=$data['email']?>"><?=$data['email']?></a></td>
	</tr>
	<tr>
		<td>Referrer:</td>
		<td><?=$data['referrer']?></td>
	</tr>
	<tr>
		<td>Account Type:</td>
		<td><?=$_acct_type[$data['acct_type']]?></td>
	</tr>
	<tr>
		<td>Username:</td>
		<td><?=$data['username']?></td>
	</tr>
	<tr>
		<td>Pay Method:</td>
		<td><?=$_pay_method[$data['pay_method']]?></td>
	</tr>
	<tr>
		<td>Package:</td>
		<td><?=$_SESSION['packages'][$data['package']]['pkg_name']?></td>
	</tr>
	<tr>
		<td>Domain Name:</td>
		<td><?=$data['domain']?></td>
	</tr>
	<tr>
		<td>Account Level</td>
		<td><?=$_acct_level[$data['level']]?></td>
	</tr>
	<tr>
		<td>Account Status</td>
		<td><?=$_acct_status[$data['status']]?></td>
	</tr>
	<tr>
		<td>Hostname:</td>
		<td><?=long2ip($data['hostname'])?></td>
	</tr>
	<tr>
		<td>Signup Date:</td>
		<td><?=$data['date']?></td>
	</tr>
	</table>
<?php
}
?>