sql

01/24/2010 18:19 security0F#1

in sql how do i find a characters account name/no?

if you dont understand that then...assume a characters name was TEST and the account name of that character was TEST2, how would i find in sql the account name/no of the character TEST?

01/24/2010 18:54 janvier123#2

character name = user no
account id = user no

if user no = 000000001
characters will be found (if any) with 000000001

01/24/2010 18:58 Decima#3

Quote:

Originally Posted by janvier123

character name = user no
account id = user no

if user no = 000000001
characters will be found (if any) with 000000001

actually, character name == character_name :P

01/25/2010 15:46 nobleman80#4

Quote:

Originally Posted by Decima

actually, character name == character_name :P

*edited you shld go to bed nw.

01/25/2010 15:56 eLO21#5

Quote:

Originally Posted by nobleman80

shut up bitch! you shld go to bed nw.

You know that you broke the rules? infraction... ^_^ edit fast your post :P

01/25/2010 16:09 janvier123#6

now if your gonna report him hes gonna flame you so ...
but i dont care, rules are rules

01/26/2010 00:09 ~Twister~#7

#4 edited + infraction given

01/26/2010 01:38 daddycool.#8

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]'

01/26/2010 04:32 janvier123#9

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]