Location: PHPKode > projects > VampMan: V:tR Character Manager > vampman-1.0.2/charlist.php
<?php

$username = "root";
$password = "";
$hostname = "localhost";
$database = "database";
$prefix = "PREFIX_";

$dbi = mysql_connect($hostname, $username, $password);
mysql_select_db($database, $dbi);

$query = "select charid,willpower, willpowertemp, currentvitae, maxvitae, dayscur, daysmax, fedtoday from ".$prefix."character_characters where active = '1' and vampire = '1'";
$result = mysql_query($query, $dbi);
$num = mysql_num_rows($result);
echo "charid\twillpower\twillpowertemp\tcurrentvitae\tmaxvitae\tdayscur\tdaysmax\tfedtoday\n";
while(list($charid, $willpower, $willpowertemp, $currentvitae, $maxvitae, $dayscur, $daysmax, $fedtoday) =mysql_fetch_array($result))
{
	echo $charid."\t".$willpower."\t\t".$willpowertemp."\t\t".$currentvitae."\t\t".$maxvitae."\t\t".$dayscur."\t".$daysmax."\t".$fedtoday."\n";
}



mysql_close($dbi);
?>
Return current item: VampMan: V:tR Character Manager