Support:Queries: Difference between revisions

Jump to navigation Jump to search
Content deleted Content added
imported>Kymara
imported>Kymara
Line 33: Line 33:
FROM account, passwordChange
FROM account, passwordChange
WHERE account.id = passwordChange.player_id AND username ='[account]';
WHERE account.id = passwordChange.player_id AND username ='[account]';
</source>

=== Banning an IP ===
<source lang="SQL">
insert into banlist(address,mask,reason)
values ("[ip-address]","255.255.255.255","[reason]");
</source>
</source>