+ dbtype=rm
+ olddbip=192.168.1.128
+ olduser=userpass
+ oldpass=userpass
+ olddbname=DB
+ oldport=3306
+ madconf=configs/config.ini
+ [[ -f configs/config.ini ]]
++ awk -F: '/^dbip/{print $2}' configs/config.ini
++ awk -F# '{print $1}'
++ sed -e 's,[[:space:]]*$,,' -e 's,^[[:space:]]*,,'
+ dbip=192.168.1.128
++ awk -F: '/^dbusername/{print $2}' configs/config.ini
++ sed -e 's,[[:space:]]*$,,' -e 's,^[[:space:]]*,,'
++ awk -F# '{print $1}'
+ user=userpass
++ awk -F: '/^dbpassword/{print $2}' configs/config.ini
++ sed -e 's,[[:space:]]*$,,' -e 's,^[[:space:]]*,,'
++ awk -F# '{print $1}'
+ pass=userpass
++ awk -F: '/^dbname/{print $2}' configs/config.ini
++ awk -F# '{print $1}'
++ sed -e 's,[[:space:]]*$,,' -e 's,^[[:space:]]*,,'
+ dbname=DB
++ awk -F: '/^dbport/{print $2}' configs/config.ini
++ awk -F# '{print $1}'
++ sed -e 's,[[:space:]]*$,,' -e 's,^[[:space:]]*,,'
+ port=
+ [[ userpass == '' ]]
+ [[ '' == '' ]]
+ port=3306
+ case "$dbtype" in
+ import_rm
+ read -r spawn_id lat lon old _
++ oldquery 'select distinct spawnpoint.id, spawnpoint.latitude, spawnpoint.longitude, max(spawnpointdetectiondata.tth_secs) from spawnpoint join spawnpointdetectiondata on spawnpoint.id=spawnpointdetectiondata.spawnpoint_id'
++ /usr/bin/mysql -N -B -u userpass -D DB -puserpass -h 192.168.1.128 -P 3306 -e 'select distinct spawnpoint.id, spawnpoint.latitude, spawnpoint.longitude, max(spawnpointdetectiondata.tth_secs) from spawnpoint join spawnpointdetectiondata on spawnpoint.id=spawnpointdetectiondata.spawnpoint_id'
mysql: [Warning] Using a password on the command line interface can be insecure.
+ spawn_exists
+ read -r spawnpoint endtime _
++ query 'select spawnpoint, calc_endminsec from trs_spawn where spawnpoint='\''9355946000805'\'''
++ /usr/bin/mysql -N -B -u userpass -D DB -puserpass -h 192.168.1.128 -P 3306 -e 'select spawnpoint, calc_endminsec from trs_spawn where spawnpoint='\''9355946000805'\'''
mysql: [Warning] Using a password on the command line interface can be insecure.
+ [[ -n 9355946000805 ]]
+ [[ 50:53 == \N\U\L\L ]]
+ echo 'spawn 9355946000805 already exists in the db'
+ return 69
+ continue
+ read -r spawn_id lat lon old _