summaryrefslogtreecommitdiff
path: root/bin/create_account.sh
diff options
context:
space:
mode:
Diffstat (limited to 'bin/create_account.sh')
-rwxr-xr-xbin/create_account.sh94
1 files changed, 0 insertions, 94 deletions
diff --git a/bin/create_account.sh b/bin/create_account.sh
deleted file mode 100755
index f073a48..0000000
--- a/bin/create_account.sh
+++ /dev/null
@@ -1,94 +0,0 @@
-#!/bin/bash
-# Run every minute
-
-MAIL_FROM='user@host'
-MAIL_FROM_NAME='The Mana World server'
-MAIL_SUBJECT='The Mana World account registration'
-
-
-SQL_HOST='localhost'
-SQL_USER='user'
-SQL_PASSWORD='password'
-SQL_DATABASE='db'
-SQL_TABLE='table'
-
-LADMIN_DIR='/path/to/tmwserver/login/'
-LADMIN_BIN='tmwa-admin'
-
-### end configuration
-
-
-mail_command()
-{
-# no arguments; takes a message on stdin
- /usr/sbin/sendmail -t
-}
-
-die()
-{
- echo "$@"
- exit 1
-}
-
-one_word()
-{
- test $# -eq 1 || die "Error: evil spaces!"
-}
-
-one_word $SQL_HOST
-one_word $SQL_USER
-one_word $SQL_PASSWORD
-one_word $SQL_DATABASE
-one_word $SQL_TABLE
-
-send_email()
-{
-# Note: USERNAME and EMAIL are captured
-mail_command << __EOF__
-From: $MAIL_FROM_NAME <$MAIL_FROM>
-To: $USERNAME <$EMAIL>
-Subject: $MAIL_SUBJECT
-
-Hello $USERNAME,
-
-$@
-__EOF__
-}
-
-do_mysql()
-{
- # SQL statements on stdin
- mysql --host="$SQL_HOST" --user="$SQL_USER" --password="$SQL_PASSWORD" "$SQL_DATABASE"
-}
-
-frob_accounts()
-{
- IFS=$'\t'
- while read ID USERNAME PASSWORD EMAIL GENDER
- do
- if test "$GENDER" = '1'; then GENDER=M; fi
- if test "$GENDER" = '2'; then GENDER=F; fi
-
- RESULT=$(cd $LADMIN_DIR; $LADMIN_BIN <<< "create $USERNAME $GENDER $EMAIL $PASSWORD" 2>&1)
- echo RESULT: "$RESULT"
- if grep -q 'successfully created' <<< "$RESULT"
- then
- send_email 'Your account was created successfully. Have fun playing The Mana World!'
- STATE=1
- else
- send_email $'Something went wrong when automatically creating your account.\nError message:' "$RESULT"
- STATE=2
- fi
- do_mysql << __EOF__
-update $SQL_TABLE set state = $STATE, password = '' where id = $ID
-__EOF__
- done
-}
-
-do_mysql << __EOF__ | tail -n+2 | frob_accounts
-select id, username, password, email, gender
-from $SQL_TABLE
-where state = 0
-__EOF__
-
-echo Everything is Ok.