changed NATURAL JOINs to INNERs to avoid conflicting keys

[sql-web.git] / lib / display.lib.php

<?php

## FORMATTING FUNCTIONS

function sprintSize($bytes, $float=2) {
	if (is_null($bytes)) return null;
	$kb = round($bytes / 1024, $float);
	$mb = round($bytes / 1024 / 1024, $float);
	$gb = round($bytes / 1024 / 1024 / 1024, $float);
	
	return ($bytes<1||$kb<1?$bytes.' B':($mb<1?$kb.' KB':($gb<1?$mb.' MB':$gb.' GB')));
}

function sprintTS($timestamp) {	
	return substr($timestamp,0,4).
		'-'.substr($timestamp,4,2).
		'-'.substr($timestamp,6,2).
		' '.substr($timestamp,8,2).
		':'.substr($timestamp,10,2).
		':'.substr($timestamp,12,2);
}

function printBar($percent, $txt1 = '', $txt2 = '') {
	$color1 = 'black';
	$color2 = 'white';
	$color3 = 'white';
	$color4 = 'black';
	if ($percent>1) {
		$percent = $percent/100;
	} /*
	} elseif (!is_integer($percent) && $percent<2) {
		$percent = $percent*100;
	} elseif ($percent == 1) {
		$percent = 100;
	} */
	$per1 = $per2 = ceil($percent*100);
	$per2 = 100 - $per2;
	$per1 .= "%";
	$per2 .= "%";
	return '<table cellpadding=0 cellspacing=0 width="100%" class="bargraph">
				<tr>
				<td class="bar" align="left" width="'.$per1.'"><div style="position: relative;"><div style="left: 0; display: inline; position: absolute;">&nbsp;'.$txt1.'&nbsp;</div>&nbsp;</div></td>
				<td class="fill" width="'.$per2.'"><div style="position: relative;">&nbsp;<div style="right: 0; display: inline; position: absolute;">'.$txt2.'&nbsp;<em>'.$per1.'</em></div></div></td>
				</tr></table>';
}

?>