14 lines
693 B
Bash
Executable file
14 lines
693 B
Bash
Executable file
#!/bin/sh
|
|
|
|
. /home/web/default/petar.company/cfg_apps/petar/petar.cfg
|
|
|
|
if [ -z "$1" ];
|
|
then
|
|
PASSWD="/etc/master.passwd"
|
|
else
|
|
PASSWD=$1
|
|
fi
|
|
|
|
/usr/local/bin/sqlite3 ${PETARDB} 'DROP TABLE IF EXISTS MAILUSER'
|
|
/usr/local/bin/sqlite3 ${PETARDB} 'CREATE TABLE MAILUSER (login varchar(20) primary key, pwd varchar(50), gid varchar(6), email varchar(50), home varchar(30), shell varchar(20), domain varchar(50));'
|
|
cat ${PASSWD} | awk -F: '$3 > 2000 && $3 < 65000 { dom=$8; sub(/.*@/,"",dom); print "INSERT INTO MAILUSER VALUES (" "\047" $1 "\047" ",\047" $2 "\047" ",\047" $4 "\047" ",\047" $8 "\047" ",\047" $9 "\047" ",\047" $10 "\047" ",\047" dom "\047" ");"}' | /usr/local/bin/sqlite3 ${PETARDB}
|