index.inc

不错的东西

<?PHP
/*
*	Modified: 09/14/05
*	Added date message - addon
*/
?>
<div style='float: left;'>Welcome <strong><?=$_SESSION['auth']['username']?></strong> to your administration area!</div><div style='float:right;margin-right:10px;'>Today is <? echo date('l, M dS, Y');?></div><br>

<fieldset>
<legend>Account Overview</legend>
<?php
$query = $sql->query("SELECT id FROM accounts WHERE status = '1' AND level = '0' ");
$total['pending'] = mysql_num_rows($query);

$query = $sql->query("SELECT a.id FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) WHERE a.level = '0' AND a.status = '2' AND b.pkg_type = '1'");
$total['free'] = mysql_num_rows($query);

$query = $sql->query("SELECT a.id FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) WHERE a.level = '0' AND a.status = '2' AND b.pkg_type = '2'");
$total['shared'] = mysql_num_rows($query);

$query = $sql->query("SELECT a.id FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) WHERE a.level = '0' AND a.status = '2' AND b.pkg_type = '3'");
$total['reseller'] = mysql_num_rows($query);

$query = $sql->query("SELECT a.id FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id) WHERE a.level = '0' AND a.status = '6' AND b.pkg_type = '1'");
$total['hold'] = mysql_num_rows($query);
?>
<table width="50%" align="center">
<tr><td><b>Counting...</b></td><td><b>Total</b></td></tr>
<tr><td>Pending Accounts</td><td><?=$total['pending']?></td></tr>
<tr><td>Free Accounts</td><td><?=$total['free']?></td></tr>
<tr><td>Paid Shared Accounts</td><td><?=$total['shared']?></td></tr>
<tr><td>Paid Reseller Accounts</td><td><?=$total['reseller']?></td></tr>
<tr><td>Hold Accounts</td><td><?=$total['hold']?></td></tr>
<tr><td>Paid Accounts</td><td><?=($total['shared'] + $total['reseller'])?></td></tr>
<tr><td>Accounts</td><td><?=($total['pending'] + $total['free'] + $total['shared'] + $total['reseller'] + $total['hold'])?></td></tr>
</table>
</fieldset><BR>

<fieldset>
<legend>Support Overview</legend>
<?php
$query = $sql->query("SELECT id FROM tickets WHERE status = '1'");
$total['open'] = mysql_num_rows($query);

$query = $sql->query("SELECT id FROM tickets WHERE status = '2'");
$total['hold'] = mysql_num_rows($query);

$query = $sql->query("SELECT id FROM tickets WHERE status = '0'");
$total['closed'] = mysql_num_rows($query);
?>
<table width="50%" align="center">
<tr><td><b>Counting...</b></td><td><b>Total</b></td></tr>
<tr><td>Open Tickets</td><td><?=$total['open']?></td></tr>
<tr><td>Tickets On Hold</td><td><?=$total['hold']?></td></tr>
<tr><td>Closed Tickets</td><td><?=$total['closed']?></td></tr>
<tr><td>Total Tickets</td><td><?=($total['open'] + $total['hold'] + $total['closed'])?></td></tr>
</table>
</fieldset><BR>

<fieldset>
<legend>Network Overview</legend>
<?php
if(count($servers) < 1)
{
	?>

	<p>No servers found!</p>

	<?php
}
else
{
	$query = $sql->query("SELECT status_array FROM status ORDER BY id DESC LIMIT 1"); 
	/*
	*  Justin Osterholt
	*  11/29/05
	*  Empty status table fix
	*/
	if($sql->affectedRows !=0) {
		if(!empty($query)) {
			$data = unserialize(mysql_result($query, 0));
		}
		?>
	
		<table>
		<tr>
			<td><strong>Hostname</strong></td>
		<?php
		foreach(array_keys(current($data)) as $key => $value)
		{
			echo "<td><strong>$value</strong></td>";		
		}
		?>
			<td><strong>ACCT #</strong></td>
			<td><strong>EDIT</strong></td>
			<td><strong>DELETE</strong>
		</tr>
	
		<?php
		foreach($data as $key => $value)
		{
			echo "<tr><td>" . $servers[$key]['hostname'] . "</td>";
	
			foreach($value as $key2 => $value2)
			{
				if($value2 == 1)
				{
					echo "<td style=\"color: green;\">Online</td>\n";
				}
				else
				{
					echo "<td style=\"color: red;\">Offline</td>\n";
				}
			}

			echo "<td>" . count(listaccts(long2ip($servers[$key]['inet']), $servers[$key]['username'], $servers[$key]['access_key'], $servers[$key]['usessl'])) . "</td><td><a href=\"?page=edit_server&sid=$key&inet={$servers[$key]['inet']}\">EDIT</a></td><td><a href=\"?page=del_server&sid=$key&inet={$servers[$key]['inet']}\">DELETE</a></td></tr>";
	
		}	
	} else {
		echo "Data not available";
	}
	?>

	</table>

	<?php	
}
?>
</fieldset><br />
<fieldset>
<legend> [ VST ] </legend>
<b><h3>Enjoy This Release by VST. <a href='http://www.vsteam.ws'>Visit our Site and Support Us so we can get more scripts like this!</a></h3></b>
</fieldset>