Character Problem

Experienced Elementalist
Joined
Oct 1, 2006
Messages
287
Reaction score
0
Location
Romania
I select buton for created character i type name etc...

-Rob3r- - Character Problem - RaGEZONE Forums


And i press ok ....
-Rob3r- - Character Problem - RaGEZONE Forums


Help me please
 
Last edited:
Figure it out, and rewrite your remove proc so it updates CharIndex

Code:
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']."'");
	}
}
 
Upvote 0
Back