account

06/02/2012 11:23 tracker62#1
all account in the disorder

???????????
dbo.Users_Master

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

please
:handsdown:
06/02/2012 16:04 kraken.zhangar#2
First try to solve any problems you have, alone. And secondly UserUID is just nothing to this inconvenient
06/02/2012 16:17 tracker62#3
how it
06/02/2012 16:21 JohnHeatz#4
why would you need the to be in order anyways? that doesn't affect you on any way at all
06/02/2012 16:23 tracker62#5
ID to find faster
06/02/2012 16:37 JohnHeatz#6
Why not use a query?

Code:
select * from dbo.Users_Master where userUID = [number]
06/02/2012 17:51 tracker62#7
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Users_Master'.

??
06/02/2012 18:06 taZツ#8
Code:
select * from PS_UserData.dbo.Users_Master where userUID = 'number'
06/02/2012 18:32 JohnHeatz#9
yeah that or at the beginning just put

Code:
Use PS_UserData
pretty simple, I suggest that you read a little bit about SQL and how to work with it, it is fun, easy and you will be able to fix 99% of the errors you get
06/02/2012 18:33 tracker62#10
I have to do one by one
06/02/2012 18:37 JohnHeatz#11
Obviously, as it was said before, anyways the UserUID is nothing that will help you on absolutely anything, I certainly don't have any idea on why you would try getting them in order but if you want to use this (and again a simple SQL query that must be known if you work with databases)

Code:
Use PS_UserData
Select * from dbo.Users_Master order by UserUID asc
06/02/2012 18:44 tracker62#12
this to find faster the account name
06/03/2012 04:29 JohnHeatz#13
I won't really give you the query now, because this is really basic, but there is something that is called a "complex query" which is a query made by mixing 2 or more queries to find information quickly on a "big" database, so I will just give you the idea and with it you will be more than able to figure it out, or at least read a bit about SQL Queries.

If you want to find an "account name" you can use one toon's name of that account and look for it on the chars table, now that you have the toon's name, then you go with it, and look for the account, having the data that can be used on both of the tables you are going to use (chars and users_master) you can combine the information and bring up the account name.

This can be done not just with this kind of information but when you learn to use these kind of queries, you will be capable of finding any information you need having just one parameter easily.
06/03/2012 15:09 tracker62#14
thank you