view_account.inc

不错的东西

<?php
$query = $sql->query("SELECT *, a.id AS account_id, b.pkg_type AS acct_type, IF(a.domain_type = 3, a.domain, CONCAT(a.domain, '.', c.domain)) AS domain FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) LEFT JOIN subdomains AS c ON (a.sdid = c.id) WHERE a.id = '" . mysql_escape_string($_GET['uid']) . "' AND level = '0' LIMIT 1") or die(mysql_error());
if(mysql_num_rows($query) == 1)
{
	while($data = mysql_fetch_assoc($query))
	{
		?>

		<table>
		<tr>
			<td>ID:</td>
			<td><?=$data['account_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>
		</table>

		<table>
		<tr>
		<?php
		if($data['status'] != 3 && $data['status'] != 5)
		{
			?>

			<td><a href="?page=suspend_account&uid=<?=$data['account_id']?>">SUSPEND</a></td>
			<td><a href="?page=del_account&uid=<?=$data['account_id']?>">DELETE</a></td>
			<td><a href="?page=edit_account&uid=<?=$data['account_id']?>">EDIT</a></td>

			<?php
		}
		elseif($data['status'] == 3 && $data['status'] != 5)
		{
			?>

			<td><a href="?page=unsuspend_account&uid=<?=$data['account_id']?>">UNSUSPEND</a></td>
			<td><a href="?page=del_account&uid=<?=$data['account_id']?>">DELETE</a></td>
			<td><a href="?page=edit_account&uid=<?=$data['account_id']?>">EDIT</a></td>

			<?php
		}
		elseif($data['status'] != 5)
		{
			?>

			<td><a href="?page=del_account&uid=<?=$data['account_id']?>">DELETE</a></td>

			<?php
		}
		?>
		</tr>
		<tr>
			<td colspan="3"><a href="?page=send_welcome_email&uid=<?=$data['account_id']?>">Send Welcome Email</a></td>
		</tr>
		</table>

		<?php
	}
}
else
{
	header("Location: ?page=view_accounts");
}
?>