#!/bin/bash eval "`/var/www/cgi-bin/proccgi $*`" ASTERISK_SERVER='ASTERISK URL' MYSQL_USER='root' MYSQL_PASSWORD='passw0rd' YAPPER_DB='teleyapper' echo Content-type: text/html echo /bin/cat << EOM2 Teleyapper Number Entry EOM2 if [[ $FORM_Status = "Change" ]] ; then if echo ' insert into callees (id, phonenum) values ("'$FORM_Name'", "'$FORM_number'") on duplicate key update phonenum="'$FORM_number'";' | mysql -p$MYSQL_PASSWORD -u $MYSQL_USER $YAPPER_DB ; then echo 'Success' else echo 'Failed' fi fi if [[ $FORM_Status = "Delete" ]] ; then if echo 'delete from callees where `id` = "'$FORM_Name'";' | mysql -p$MYSQL_PASSWORD -u $MYSQL_USER $YAPPER_DB ; then echo 'Success' else echo 'Failed' fi fi if [[ $FORM_Status = "Add" ]] ; then if echo 'insert into callees (`name`,`phonenum`,`group`) value ("'$FORM_Name'","'$FORM_number'","'$FORM_group'");' | mysql -p$MYSQL_PASSWORD -u $MYSQL_USER $YAPPER_DB ; then echo 'Success' else echo 'Failed' fi fi echo '
' echo '

People in the System:

' if [[ $FORM_listgroup = '' ]] ; then echo 'select name,phonenum,`group` from callees order by `group`,name;' | mysql -u $MYSQL_USER -p$MYSQL_PASSWORD $YAPPER_DB | grep -v name > /tmp/checkin.tmp else echo 'select name,phonenum,`group` from callees where `group` = "'$FORM_listgroup'" order by `group`,name;' | mysql -u $MYSQL_USER -p$MYSQL_PASSWORD $YAPPER_DB | grep -v name > /tmp/checkin.tmp fi let LENGTH=`wc -l /tmp/checkin.tmp | cut -f 1 -d ' '` echo '
' echo '' echo '' for i in `seq 1 $LENGTH` ; do read TEST1 TEST2 TEST3 TEST4 echo -n "" echo -n "" echo "" done < /tmp/checkin.tmp echo '
NameNumberGroup
$TEST1 $TEST2$TEST3$TEST4
' echo '
' echo '' echo '
' echo 'select id, name from callees order by name;' | mysql -u $MYSQL_USER -p$MYSQL_PASSWORD $YAPPER_DB | grep -v name > /tmp/checkin.tmp /bin/cat << EOM1

Change or Delete a Number


Add a New Number

Name
Number
Group

Show Only People in One Group

EOM1