Projects STRLCPY wifi_db Commits 9248b25b
🤬
  • ■ ■ ■ ■
    view.sql
    skipped 21 lines
    22 22  CREATE VIEW IF NOT EXISTS HandshakeAPUnique AS
    23 23  SELECT Handshake.bssid, AP.ssid, Handshake.mac, Client.manuf, Handshake.file, Handshake.hashcat
    24 24  FROM Handshake JOIN AP ON Handshake.bssid = AP.bssid JOIN Client ON Handshake.mac = Client.mac
    25  -GROUP BY AP.ssid ORDER BY Handshake.bssid;
     25 +WHERE hashcat != '' GROUP BY AP.ssid ORDER BY Handshake.bssid;
    26 26   
    27 27  CREATE VIEW IF NOT EXISTS IdentityAP AS
    28 28  SELECT Identity.bssid, AP.ssid, Identity.mac, Client.manuf, Identity.identity
    skipped 3 lines
Please wait...
Page is in error, reload to recover