Support:Queries: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara |
imported>Kymara |
||
| Line 40: | Line 40: | ||
insert into banlist(address,mask,reason) |
insert into banlist(address,mask,reason) |
||
values ("[ip-address]","255.255.255.255","[reason]"); |
values ("[ip-address]","255.255.255.255","[reason]"); |
||
</source> |
|||
=== Summarise activity from one IP address === |
|||
<source lang="SQL"> |
|||
-- may wish to add 'service' into the FROM and GROUP BY |
|||
select username, result, count(*) |
|||
from loginEvent, account |
|||
where account.id=player_id and address='[ip-address]' |
|||
group by username, result |
|||
order by username, result; |
|||
</source> |
</source> |
||