AlexWebDevelop

IP-based login limiting: SQL table

Mar 4th, 2021
773
141 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `login_attempts` (
  2.   `ip_address` varchar(255) NOT NULL,
  3.   `failed_logins` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  4.   `last_failed_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  5. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×