commit - 45a721d19c951340b208718ff1d1486850ecd4ae
commit + 2b7a3d084d70b266db82faddd91b66d4da8686e6
blob - 39595563f2c6155ef05eb2e12184219c560fe411
blob + 243d3c6301c7f3a340fbd99bf5d78e1f0d16e087
--- user_fingerprint.org
+++ user_fingerprint.org
-# testing locally
-# testing remotely
#+TITLE: User fingerprinting and approval
#+DATE: <2024-09-21 Sat>
: 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