pink_panther
Excellent OT User
I want to exclude anyone with an active BAN. Needs to exclude any player who’s account ID exists in
Heres the currenct query.
SELECT
account_bans
and the current time (epoch) is < account_bans
.expires_at
timeHeres the currenct query.
SELECT
p
.name
, p
.level
, p
.vocation
, za
.flag
, ps
.value
AS value
FROM players
AS p
INNER JOIN znote_accounts
AS za
ON p
.account_id
=za
.account_id
INNER JOIN player_storage
AS ps
ON (p
.id
=ps
.player_id
AND ps
.key
= 15999) WHERE p
.group_id
< 4 ORDER BY ps
.value
DESC LIMIT 0, 300;