DIR : /home/kozerus/public_html/ka/tls.sh

/home/kozerus/public_html/ka

# tls.sh

progid="tls.sh"
dttm=`date +"%Y%m%d_%H%M%S"`

db3fil="tl/db3/tl.db3"
tbl="fb"


imgs="
/fb/jtfdcr/shoebox/zn/zn_dcgroup(1).jpg
/fb/jtfdcr/shoebox/zn/zn_jak3.jpg
/fb/jtfdcr/shoebox/zn/zn_jak2b.jpg
/fb/jtfdcr/shoebox/zn/zn_emma_and_dexter.jpg
/fb/jtfdcr/shoebox/zn/zn_zn_big_snow.jpg
/fb/jtfdcr/shoebox/zn/zn_jenna_and_mom.jpg
/fb/jtfdcr/shoebox/zn/zn_jenna_and_josh.jpg
/fb/jtfdcr/shoebox/zn/zn_jsk_winecellar_Image395.jpg
/fb/jtfdcr/shoebox/zn/zn_cwjsk_winecellar_Image402.jpg
/fb/jtfdcr/shoebox/zn/zn_rudi_Image405.jpg
/fb/jtfdcr/shoebox/zn/zn_JULIA3.jpg
/fb/jtfdcr/shoebox/zn/zn_JKassil-R1-010-eA.jpg
/fb/jtfdcr/shoebox/zn/zn_jtfdc_2001.jpg
/fb/jtfdcr/shoebox/zn/zn_jessie.jpg
/fb/jtfdcr/shoebox/zn/zn_Image367.jpg
/fb/birthday/jak1/pages/zn/zn_Image367.jpg
/fb/birthday/jak1/pages/zn/zn_Image357a.jpg
/fb/birthday/jak1/pages/zn/zn_Image354.jpg
/fb/birthday/jak1/pages/zn/zn_Image350.jpg
/fb/birthday/jak1/pages/zn/zn_Image341.jpg
/fb/birthday/jak1/pages/zn/zn_Image332.jpg
/fb/birthday/jak1/pages/zn/zn_Image285.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_detail_bw.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_08.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_detail_preview.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_07.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_detail_sasc.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_06.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_detail_buie.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_05.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_detail_konet.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_detail_konet.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_04.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_03.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_02.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_2000_01.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_1990_skillset.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_1990_02.jpg
/fb/jtfdcr/shoebox/zn/zn_jkresume_1990_01.jpg
/fb/jtfdcr/shoebox/zn/zn_bg_swoorl2.jpg
/fb/jtfdcr/shoebox/zn/zn_bg_swoorl1.jpg
/fb/jtfdcr/shoebox/zn/zn_bg_noise2.jpg
/fb/jtfdcr/shoebox/zn/zn_bg_noise3.jpg
/fb/jtfdcr/shoebox/zn/zn_bg_noise1.jpg
/fb/jtfdcr/shoebox/zn/zn_swedish_woman_onbench.jpg
/fb/jtfdcr/shoebox/zn/zn_danish_woman.jpg
/fb/jtfdcr/shoebox/zn/zn_austrian.jpg
/fb/jtfdcr/shoebox/zn/zn_blackforest_stroll.jpg
/fb/jtfdcr/shoebox/zn/zn_bavarian.jpg
/fb/jtfdcr/shoebox/zn/zn_hall_guards.jpg
/fb/jtfdcr/shoebox/zn/zn_hall_woman_park_knitting.jpg
/fb/jtfdcr/shoebox/zn/zn_hall_window_watcher.jpg
/fb/jtfdcr/shoebox/zn/zn_bavaria_lake_mountain.jpg
/fb/jtfdcr/shoebox/zn/zn_blackforest.jpg
/fb/jtfdcr/shoebox/zn/zn_amsterdam_rooftops.jpg
/fb/jtfdcr/shoebox/zn/zn_heidleberg_tibet_painting.jpg
/fb/jtfdcr/shoebox/zn/zn_denmark_window_view.jpg
/fb/jtfdcr/shoebox/zn/zn_heidleberg_tibet_panel.jpg
/fb/jtfdcr/shoebox/zn/zn_woodcarvershop_blackforest.jpg
/fb/jtfdcr/shoebox/zn/zn_amsterdam_bridges.jpg
/fb/jtfdcr/shoebox/zn/zn_door_locks_vienna.jpg
/fb/jtfdcr/shoebox/zn/zn_woodcarver_blackforest.jpg
/fb/jtfdcr/shoebox/zn/zn_castle.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_24.jpg
/fb/jtfdcr/shoebox/zn/zn_mozart_aviary.jpg
/fb/jtfdcr/shoebox/zn/zn_swedish_stump.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_40.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_34.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_33.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_32.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_31.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_30.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_29.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_28.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_27.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_26.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_25.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_12.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_11.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_10.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_08.jpg
/fb/jtfdcr/shoebox/zn/zn_jam_200710_07.jpg
/fb/jtfdcr/shoebox/zn/zn_prison10.jpg
/fb/jtfdcr/shoebox/zn/zn_prison09.jpg
/fb/jtfdcr/shoebox/zn/zn_prison08.jpg
/fb/jtfdcr/shoebox/zn/zn_prison07.jpg
/fb/jtfdcr/shoebox/zn/zn_prison06.jpg
/fb/jtfdcr/shoebox/zn/zn_prison05.jpg
/fb/jtfdcr/shoebox/zn/zn_prison04.jpg
/fb/jtfdcr/shoebox/zn/zn_prison03.jpg
/fb/jtfdcr/shoebox/zn/zn_prison02.jpg
/fb/jtfdcr/shoebox/zn/zn_prison01.jpg
/fb/jtfdcr/shoebox/zn/zn_PASA01_2.jpg
/fb/jtfdcr/shoebox/zn/zn_PASA01_3.jpg
/fb/jtfdcr/shoebox/zn/zn_PASA01_1.jpg
/fb/jtfdcr/shoebox/zn/zn_http___ko2.jpg
/fb/jtfdcr/shoebox/zn/zn_flagged_coffins.jpg
/fb/jtfdcr/shoebox/zn/zn_oldpeople12.jpg
/fb/jtfdcr/shoebox/zn/zn_oldpeople11.jpg
/fb/jtfdcr/shoebox/zn/zn_oldpeople10.jpg
/fb/jtfdcr/shoebox/zn/zn_oldpeople9.jpg
/fb/jtfdcr/shoebox/zn/zn_oldpeople9.jpg
"


if [ "$1" == "" ]; then
	echo "imgs=$imgs"

	echo "$progid $dttm db3fil=$db3fil tbl=$tbl"
	if [ ! -f $db3fil ]; then
		echo "$progid $dttm NOTFOUND db3fil=$db3fil"
	else
		echo "$progid $dttm ___FOUND db3fil=$db3fil"
		fi
	
	echo ""
	echo "./$progid vi"
	echo "./$progid go"
	echo "./$progid go go"
	echo "./$progid sql3"
	echo "./progid ins"
	exit
	fi

if [ "$1" == "vi" ] || [ "$1" == "vi" ]; then
	if [ -f $progid ]; then
		vi $progid
	else
		echo "ERR_100 NOTFOUND progid=$progid"
		fi
	exit
	fi


if [ "$1" == "go" ] || [ "$1" == "go" ]; then
	j=0; k=0;
	imgs=`find ./fb/shoebox/pages/zn -type f`
	for img in $imgs; do
#		fbimg="..$img"
#		timg=`echo $fbimg | sed -e "s:../fb/zn_:./fb/shoebox/pages:"`
		pg=`echo $img | sed -e "s:/zn/zn_:/:"`
		tn=`echo $img | sed -e "s:/zn/zn_:/tn/tn_:" | sed -e "s:.jpg:.png:"`
		if [ -f $fbimg ]; then
			echo "$j, $k $img ___FOUND"
			echo "magick $img -resize 650x $pg"
			echo "magick $img -resize 200x $tn"

			if [ "$2" == "go" ]; then
#				cp $fbimg ./im/shoebox/imgs/
				magick $img -resize 650x $pg
				magick $img -resize 650x $tn
				fi
		else
			echo "$j, $k $fbimg NOTFOUND"
			fi
		done
		
#	identify ./im/shoebox/imgs/*.*
	identify ./fb/shoebox/pages/*.jpg
	identify ./fb/shoebox/pages/tn/tn_*.png
	exit
	fi

if [ "$1" == "sql3" ] || [ "$1" == "sql3" ]; then
# select * from fb where tlid != '' and rowid>0 and status is NULL order by startdate,starttime desc limit 100;

#	sqlite3 $db3fil -header "select * from $tbl"
	sqlite3 $db3fil -header "select * from $tbl where tlid != '' and rowid>0 and status is NULL order by startdate,starttime desc;" > fball.psv
#	sqlite3 $db3fil -header "select * from $tbl where tlid != '' and rowid>0 and status is NULL order by startdate,starttime desc limit 100;"

	exit
	fi
	
if [ "$1" == "ins" ] || [ "$1" == "ins" ]; then
sqlfil="tls.sql"
# imgs=`find ./fb/shoebox/pages -maxdepth 1 -name "*.jpg"`
# imgs=`find ./im/jtfdcr/imgs -maxdepth 1 -name "*.jpg" | head -100`
# imgs=`find ./aud/ -maxdepth 1 -name "*.mp3"`
# mp4=`find ./vid -maxdepth 2 -name "*.mp4"`
# fbs=`find ./fb -maxdepth 2 -name "pages" | sed -e "s:/pages::"`
# imgs=`find ./im/konet/imgs -maxdepth 1 -name "*.jpg"`
imgs="./fb/jsk/pages
./fb/jsk2/pages
./fb/kassils_euro
./fb/kassils_usa
./aud/german_navy_song3.mp3			
./aud/marlene_dietrich_mussi_denn.mp3
./aud/library_of_congress.mp3			
./aud/plangger_liebeslied.mp3
./vid/hubert_von_goisern_hauskonzerte10-meiner_seel_36.mp4
./vid/marlene_dietrich_lili_marleen.mp4
./vid/marlene_dietrich_wenn_die_soldaten.mp4
./vid/plangger_fenzl_tropferl_im_meer_ilse_teilt_musik_genuss.mp4
./vid/plangger_fenzl_troperl_im_meer.mkv
./zm/operation/TileGroup0/0-0-0.jpg
https://www.youtube.com/watch?v=XfJMJw3uwxk
https://www.youtube.com/watch?v=bshyhvoimOY"


	flds="tlid,startdate,starttime,enddate,endtime,title,headline,caption,credit,media"
	tlid="test"; 
	startdate="2025,06,06"; starttime="8:01";
	enddate="2024,12,31"; endtime="23:39";
	title="title"; headline="_headline_"; caption="_caption_"; credit="_credit_";
	echo "" > $sqlfil
	j=0;k=0;

	sqlite3 $db3fil "delete from $tbl where tlid like '$tlid'"
	for img in $imgs; do
		let j=j+1; 
		title=`echo "$img" | sed -e "s:./fb/shoebox/pages/::"`
		title="title_$j"; headline="headline_$j"; caption="caption_$j"; credit="credit_$j";
		media="$img"
		vals="'$tlid','$startdate','$starttime','$enddate','$endtime','$title','$headline','$caption','$credit','$media'"
		echo "insert into fb ($flds) values ($vals);" >> $sqlfil
		done

	sqlite3 $db3fil < $sqlfil
	sqlite3 $db3fil -header "select * from $tbl where tlid like '$tlid'" 
	sqlite3 $db3fil -header "select * from $tbl where tlid like '$tlid'"  > tls.psv


	exit
	fi