To get the 'user_no' from an account using your login name
Go to 'Query Analyzer' and enter with this code:
Code:
USE [Account];
GO
SELECT user_no FROM account.dbo.user_profile WHERE user_id = '[COLOR="Red"]PUT YOUR LOGIN NAME HERE[/COLOR]'
Then press Execute.
To get the 'character_no' from a character using the name of character use this (same previously process):
Code:
USE [Character];
GO
SELECT character_no FROM character.dbo.user_character WHERE character_name = '[COLOR="Red"]PUT YOUR CHARACTER NAME HERE[/COLOR]'