Getting players+accname+pass in mysql.

[papkie]

Hello.

Someone knows how to retrieve data from the database to be such information:
Account Name, Password, Character Name?

I can, I just acc name and pass

For help rep++

Sorry for my english.

 

[chojrak]

Not sure if it's what u want tho. ;p

SELECT `players`.`name`, `accounts`.`name`, `accounts`.`password` FROM `accounts`, `players` WHERE `players`.`name` = 'papkie' AND `accounts`.`id` IN (SELECT `account_id` FROM `players` WHERE `name` = 'papkie' LIMIT 1);

 

[papkie]

I'm made remake for it:

SELECT `players`.`name` , `accounts`.`name` , `accounts`.`password` 
FROM `accounts` , `players` 
WHERE `players`.`account_id` = `accounts`.`id` 
AND `accounts`.`id`

Thx for sample! Rep++