function charIndex($name)
{
$query = mssql_query("SELECT AID FROM Character WHERE Name ='".$name."'");
$aid = mssql_fetch_row($query);
// Walk through Character list and fix CharIndex's
$query = mssql_query("SELECT * FROM Character WHERE AID='".$aid[0]."'");
$num = mssql_num_rows($query);
// Approx. time for CharIndex fix 0.01 seconds
for($i = 0; $i < $num; ++$i)
{
$result = mssql_fetch_array($query);
mssql_query("UPDATE Character SET CharIndex = $i WHERE Name = '".$result['Name']."'");
}
}