--- DarthVader/docs/install_GL_PARAM.sh	2006/09/07 08:50:38	1.2
+++ DarthVader/docs/install_GL_PARAM.sh	2007/04/17 11:58:39	1.5
@@ -3,23 +3,12 @@
 USERNAME=${PAM_DBUSER}
 HOST=""
 DBNAME=""
-COUNT=0;for word in `echo ${PAM_DBHOST} | tr [\/] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
+FORCE="no"
+STATIC="no"
+COUNT=0;for word in `echo ${PAM_DBHOST} | tr [\/] [" "] |tr [?] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
 PASSWORD=${PAM_DBPSW}
 if [ $# -gt 0 ]; then
-    I=1
-    while [ $I -le $# ]; do
-	if [ $I -eq 1 ]; then 
-	    INPUT=$1
-	fi
-	if [ $I -eq 2 ]; then 
-	    INPUT=$2
-	fi
-	if [ $I -eq 3 ]; then 
-	    INPUT=$3
-	fi
-	if [ $I -eq 4 ]; then 
-	    INPUT=$4
-	fi
+    for INPUT in $*; do 
 	if [ $INPUT == "--help" ] || [ $INPUT == "-h" ]; then
 	    echo ""
 	    echo " Usage: ./install_GL_PARAM.sh [options] "
@@ -32,6 +21,10 @@
 	    echo ""
 	    echo " --psw=password :  MySQL password"
 	    echo ""
+	    echo " --force :  do not wait [default: wait]"	    
+	    echo ""
+	    echo " --static :  use static path instead of symbolic ones ($PAM_CALIB) [default: no]"	    
+	    echo ""
 	    exit 0
 	fi
 	TEST=`echo $INPUT | sed 's/--user=//g'`
@@ -41,7 +34,7 @@
 	fi
 	TEST=`echo $INPUT | sed 's/--host=//g'`
 	if [ $TEST != $INPUT  ]; then
-	    COUNT=0;for word in `echo $TEST | tr [\/] [" "] |sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
+	    COUNT=0;for word in `echo $TEST | tr [\/] [" "] |tr [?] [" "]|sed 's/mysql://g' `; do if [ $COUNT -eq 0 ]; then HOST=`echo $word`; fi; if [ $COUNT -eq 1 ]; then DBNAME=`echo $word`; fi; let COUNT=$COUNT+1; done
 	    export DBNAME;
 	    export HOST;
 	fi
@@ -50,7 +43,14 @@
 	    PASSWORD=`echo $TEST`
 	    export PASSWORD;
 	fi
-	let I=$I+1
+	if [ "$INPUT" == "--force" ]; then
+	    FORCE="yes";
+	    export FORCE;
+	fi
+	if [ "$INPUT" == "--static" ]; then
+	    STATIC="yes";
+	    export STATIC;
+	fi
     done
 else
     if [ "$USERNAME" == "" ] || [ "$HOST" == "" ] || [ "$DBNAME" == "" ]; then
@@ -70,9 +70,14 @@
 fi;
 echo ""
 echo " Updating GL_PARAM table on DB $DBNAME, $HOST with user $USERNAME and password $PASSWORD "
-echo "               (you have 30 seconds to stop me using CTRL+c)       "
 echo ""
-sleep 30;
+if [ "$FORCE" == "no" ]; then
+    echo " WARNING: if already existing the GL_PARAM table will be RECREATED and you will LOSE all data in that table! "
+    echo ""
+    echo "    =======>   You have 30 seconds to stop me using CTRL+c  <=======    "
+    echo ""
+    sleep 30;
+fi;
 echo " Updating GL_PARAM table"
 #
 rm -rf ${THISDIR}/temp.sql
@@ -81,14 +86,19 @@
 echo "delete from GL_PARAM;" > ${THISDIR}/temp.sql
 mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
 #
-cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql
+if [ "$STATIC" == "no" ]; then
+    cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/$PAM_CALIB/g' >> ${THISDIR}/temp.sql
+else
+    cat ${THISDIR}/install_GL_PARAM.sql | sed 's/fullpathgoesere/'${PAM_CALIB2}'/g' >> ${THISDIR}/temp.sql
+fi;    
 mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
 #
 echo " done! "
 echo ""
 echo "GL_PARAM TABLE NOW CONTAINS:"
 echo ""
-echo "select * from GL_PARAM;" > ${THISDIR}/temp.sql
+echo "SET time_zone='+0:00';" > ${THISDIR}/temp.sql
+echo "select * from GL_PARAM;" >> ${THISDIR}/temp.sql
 mysql --user=$USERNAME --password=$PASSWORD --host=$HOST $DBNAME < ${THISDIR}/temp.sql 
 echo ""
 echo "Please check that path and names are correct."