Query for Bank Balance

[leonmagmo]

Hello,
Anyone know a query to check the money that the players have in bank?

 

[Techrlz]

You can use this function to check balance:

getPlayerBalance(cid)

 

[leonmagmo]

Hmm, you have a ready query for a test?
My programmer is offline :X

 

[Techrlz]

i didn't search the query that this function use =(

 

[kamilwxx]

Here you go

SELECT `balance` FROM `players` WHERE `name` = "leonmagmo";

 

[Techrlz]

Nice

 

[leonmagmo]

Worked, Thanks!
But have other for check all players that have more than 5k?
I need to check if someone cloned

 

[Techrlz]

I'm bad with querys , but i can make using the function.

 

[kamilwxx]

I'm not sure that I understood you well. Do you need a query which returns a list of players with the balance more than 5000? If yes, here you go

SELECT `name` FROM `players` WHERE `balance` > 5000;

 

[leonmagmo]

Thanks