Return to convert_dgl-login.sh CVS log

Up to [contributed] / dgamelaunch-openbsd

Annotation of dgamelaunch-openbsd/convert_dgl-login.sh, Revision 1.1

1.1     ! rubenllo    1: #!/bin/sh
        !             2: #
        !             3: # This script converts the flat-text password file
        !             4: # to the new sqlite3 database.
        !             5: #
        !             6:
        !             7:
        !             8: TEMPFILE="dgl-login.tmp"
        !             9: FLATDB="dgl-login"
        !            10: DBFILE="dgamelaunch.db"
        !            11:
        !            12:
        !            13: if [ -e "$TEMPFILE" ]; then
        !            14:     echo "$TEMPFILE already exists.";
        !            15:     exit;
        !            16: fi
        !            17: if [ -e "$DBFILE" ]; then
        !            18:     echo "$DBFILE already exists.";
        !            19:     exit;
        !            20: fi
        !            21: if [ ! -e "$FLATDB" ]; then
        !            22:     echo "$FLATDB does not exist.";
        !            23:     exit;
        !            24: fi
        !            25:
        !            26:
        !            27: sqlite3 "$DBFILE" "create table dglusers (id integer primary key, username text, email text, env text, password text, flags integer);"
        !            28:
        !            29: cat "$FLATDB" | sed -e "s/'/''/g" -e "s/^\([^:]*\):\([^:]*\):\([^:]*\):/insert into dglusers (username, email, password, env, flags) values ('\1', '\2', '\3', '', 0); /g" > "$TEMPFILE"
        !            30:
        !            31: sqlite3 "$DBFILE" ".read $TEMPFILE"
        !            32:
        !            33: rm -f "$TEMPFILE"