question

11/28/2010 18:18 hahe123#1

hello

can some1 help me

i need know other players ID and PW

How can i get them im owner of server

11/29/2010 06:05 -8gX#2

@vikitooo-do not post unless you have something to contribute. Sure; it may be a dumb question... No need to take it past that and insult him.

Your answer resides in your enterprise manager -> going to your db -> selecting account db and scrolling down to your Tbl_User table. Right click -> return all rows and viola. You have all your accounts and passwords.

11/29/2010 10:01 pieter#3

open query Analizer
hit connect in the popup
copy and past this code

Code:

SELECT 
 t.user_id as 'Login', 
 t.user_pwd as 'Password', 
 t.user_mail as 'E-mail address', 
 p.ipt_time as 'Joined us on (date)',
 p.login_time as 'Last played on (date)'
FROM account..tbl_user t 
 JOIN account..user_profile p
 ON t.user_no = p.user_no
ORDER BY p.ipt_time DESC

then press ALT+X to execute and get your list :)