Register for your free account! | Forgot your password?

You last visited: Today at 19:31

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



sql

Discussion on sql within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2010
Posts: 27
Received Thanks: 3
sql

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?
security0F is offline  
Old 01/24/2010, 18:54   #2
 
janvier123's Avatar
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
character name = user no
account id = user no

if user no = 000000001
characters will be found (if any) with 000000001
janvier123 is offline  
Old 01/24/2010, 18:58   #3
 
Decima's Avatar
 
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
Quote:
Originally Posted by janvier123 View Post
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
Decima is offline  
Old 01/25/2010, 15:46   #4
 
elite*gold: 0
Join Date: Jan 2009
Posts: 397
Received Thanks: 66
Quote:
Originally Posted by Decima View Post
actually, character name == character_name :P
*edited you shld go to bed nw.
nobleman80 is offline  
Old 01/25/2010, 15:56   #5
 
eLO21's Avatar
 
elite*gold: 0
Join Date: Sep 2007
Posts: 1,511
Received Thanks: 983
Quote:
Originally Posted by nobleman80 View Post
shut up *****! you shld go to bed nw.
You know that you broke the rules? infraction... ^_^ edit fast your post :P
eLO21 is offline  
Old 01/25/2010, 16:09   #6
 
janvier123's Avatar
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
now if your gonna report him hes gonna flame you so ...
but i dont care, rules are rules
janvier123 is offline  
Old 01/26/2010, 00:09   #7

 
elite*gold: 0
Join Date: Oct 2008
Posts: 2,040
Received Thanks: 598
#4 edited + infraction given
~Twister~ is offline  
Old 01/26/2010, 01:38   #8
 
daddycool.'s Avatar
 
elite*gold: 0
Join Date: Dec 2009
Posts: 296
Received Thanks: 165
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]'
daddycool. is offline  
Old 01/26/2010, 04:32   #9
 
janvier123's Avatar
 
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876

janvier123 is offline  
Reply




All times are GMT +1. The time now is 19:31.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.