commit 2b7a3d084d70b266db82faddd91b66d4da8686e6
from: barth <barth@freeirc.org>
date: Mon Sep 30 19:00:10 2024 UTC

Merged shell, email, bouncer source blocks in user_fingerprint.org. Added got_usage file

commit - 45a721d19c951340b208718ff1d1486850ecd4ae
commit + 2b7a3d084d70b266db82faddd91b66d4da8686e6
blob - 39595563f2c6155ef05eb2e12184219c560fe411
blob + 243d3c6301c7f3a340fbd99bf5d78e1f0d16e087
--- user_fingerprint.org
+++ user_fingerprint.org
@@ -1,5 +1,3 @@
-# testing locally
-# testing remotely
 #+TITLE: User fingerprinting and approval
 #+DATE: <2024-09-21 Sat>
 
@@ -55,46 +53,6 @@ See : [[eww:https://wiki.ircnow.org/?n=Police.Fingerpr
 : ZidBot|39.38.109.231|20240920
 : ZidBot|39.38.109.231|20240920
 
-** Find if user has already requested a shell account
-
-#+begin_src sh :results output
-   EMAIL="mendoanp45@gmail.com";
-   USER="samin";
-
-   doas su botnow -c "sqlite3 /var/www/botnow/botnow.db \
-   'select id, ircid, username, email from shell where email =\"$EMAIL\" \
-   or username = \"$USER\";'"
-#+end_src
-
-#+RESULTS:
-
-** Find if user has already requested a bnc account
-
-#+begin_src sh :results output
-  EMAIL="mendoanp45@gmail.com";
-  USER="samin";
-  doas su botnow -c "sqlite3 /var/www/botnow/botnow.db \
-  'select id, ircid, username, email from bnc where email =\"$EMAIL\" \
-  or username = \"$USER\";'"
-#+end_src
-
-#+RESULTS:
-: test
-: 109|4929705759429656576|samin|mendoanp45@gmail.com
-
-** Find if user has already requested an email account
-
-#+begin_src sh :results output
-  EMAIL="mendoanp45@gmail.com";
-  USER="samin";
-
-   doas su botnow -c "sqlite3 /var/www/botnow/botnow.db \
-   'select id, ircid, username, email from mail where email =\"$EMAIL\" \
-   or username = \"$USER\";'"
-#+end_src
-
-#+RESULTS:
-
 ** Find if user has already requested an email, bnc, shell account
 
 #+begin_src sh :results output