Windows (Database question) Rep ++ (10 points)

[Nikkster]

Hello, I don't know if this question has been brought up before but, is it a way to search for a player directly using the database or certain mysql questions?

Because I want to find a easier way to add the points to the players account. Rep ++

 

[Chris]

SELECT * FROM `players` WHERE `name` = 'PLAYER_NAME_HERE'

 

[Nikkster]

What about accounts then?

 

[Master-m]

SELECT * FROM `accounts` WHERE `name` = 'accountname here' Not sure, don't know the new structure

 

[Nikkster]

SELECT * FROM `accounts` WHERE `name` = 'accountname here' Not sure, don't know the new structure

nope, didnt work =S

 

[Chris]

If you're using a server with account names:
SELECT * FROM `accounts` WHERE `name` = 'ACCOUNT_NAME_HERE'

If not:
SELECT * FROM `accounts` WHERE `id` = 'ACCOUNT_NUMBER_HERE'

 

[dabaflow]

makr0mango your rep is sick !!! sry for spam and off topic..

 

[Master-m]

Aff he use old system -,-.

 

[Nikkster]

If you're using a server with account names:
SELECT * FROM `accounts` WHERE `name` = 'ACCOUNT_NAME_HERE'

If not:
SELECT * FROM `accounts` WHERE `id` = 'ACCOUNT_NUMBER_HERE'

Thanks, it worked!