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

/home/kozerus/public_html/ka


# 	atsutil fonts -list
	ids="ka jsk jk sk jak1 jak2 jak3 gjw jsk2 am iperms konet byrdbellvjk pdf fb tl sl tm zm mp3 mp4 txt csv psv db3";
	ids="kups ka jsk jk sk jak1 jak2 jak3 gjw jsk2 am fb pdf mp3 mp4 txt csv psv db3";
	ids="bugs"
	ptsize="30";
	font="Bodoni 72 Book";
	font="";
#	font="Courier New";
	font="Arial"
#	font="Arial Bold";
#	font="PAPYRUS";
#	font="Papyrus";
#	font="Papyrus LET Plain";
#	font="Papyrus Condensed";
	font="Arial Narrow";
	font="yokkmokk OT"
#	font="/Volumes/ka1tbr2/ht/fonts/PAPYRUS.TTF";
#	font="/Volumes/ka1tbr2/ht/fonts/yokkmokk.ttf"

	png0="../imgs/btn/koeye.png";
	pngb0="../imgs/btn/koeyeb.png";
	pngw0="../imgs/btn/koeyew.png";
	for id in $ids; do
		png="./imgs/btn/koeye_$id.png";
		pngb="./imgs/btn/koeyeb_$id.png";
		pngw="./imgs/btn/koeyew_$id.png";

		printf "convert $png0 \\ \n";
		printf "	-gravity south \\ \n";
		printf "	-stroke '#000C' -strokewidth 2 -annotate 0 '$id' \\ \n";
		printf "	-stroke  none   -fill white    -annotate 0 '$id' \\ \n";
		printf "	$png\n";

#		printf "cp ../imgs/btn/koeye.png ./imgs/btn/koeye_$id.png\n"
#		printf "cp ../imgs/btn/koeyeb.png ./imgs/btn/koeyeb_$id.png\n"
#		printf "cp ../imgs/btn/koeyew.png ./imgs/btn/koeyew_$id.png\n"
#		montage -label "$id"  ../imgs/btn/koeye.png -geometry +0+0 -background Gold ./imgs/btn/koeye_$id.png



		if [ "$2" == "go" ]; then

#			if [  -f $png ]; then
				printf "PNG =$png \n";
				convert $png0 -gravity center -pointsize $ptsize -font $font -fill white -annotate 0 "$id" $png
#				convert $png0 \
#					-gravity center \
#					-pointsize 30 \
#					-font Arial
#					-fill white -annotate 0 "$id" \
#					$png
				printf "OPEN $png \n";
				open $png

#					-stroke  none   -fill white    -annotate 0 '$id' \
#					-stroke '#000C' -strokewidth 2 -annotate 0 '$id' \
#			else
#				printf "FOUND png=$png\n";
#				fi

#			if [  -f $pngb ]; then
				convert $pngb0 -gravity center -pointsize $ptsize -font $font -fill white -annotate 0 "$id" $pngb
#				convert $pngb0 \
#					-gravity center \
#					-fill white -annotate 0 "$id" \
#					$pngb

#					-stroke  none   -fill white    -annotate 0 '$id' \
#					-stroke '#000C' -strokewidth 2 -annotate 0 '$id' \
#			else
#				printf "FOUND pngb=$pngb\n";
#				fi

#			if [  -f $pngw ]; then
				convert $pngb0 -gravity center -pointsize $ptsize -font $font -fill white -annotate 0 "$id" $pngb
#				convert $pngw0 \
#					-gravity center \
#					-fill black    -annotate 0 "$id" \
#					$pngw

#					-stroke  none   -fill black    -annotate 0 '$id' \
#					-stroke '#000C' -strokewidth 2 -annotate 0 '$id' \
#			else
#				printf "FOUND pngw=$pngw\n";
#				fi

#			cp $png0 $png
#			cp $pngb0 $pngb
#			cp $pngw0 $pngw

#			open $png
#			open $pngb
#			open $pngw

			fi

		done



exit;
sqlite3 ko_center.db3 "drop table aureole;"
sqlite3 ko_center.db3 "drop table hw_chi;"
sqlite3 ko_center.db3 "drop table cabs;"
sqlite3 ko_center.db3 "drop table kocab;"
sqlite3 ko_center.db3 "drop table defrag_plan;"
sqlite3 ko_center.db3 "drop table kohw;"
sqlite3 ko_center.db3 "drop table defrag_plansum;"
sqlite3 ko_center.db3 "drop table kohw_cabs_defrag;"
sqlite3 ko_center.db3 "drop table es_hw;"
sqlite3 ko_center.db3 "drop table kohw_hrc;"
sqlite3 ko_center.db3 "drop table es_ip;"
sqlite3 ko_center.db3 "drop table kohw_hrc_defrag;"
sqlite3 ko_center.db3 "drop table kohw_unix;"
sqlite3 ko_center.db3 "drop table kohw_win;"
sqlite3 ko_center.db3 "drop table hrc_datacenters_equipment;"
sqlite3 ko_center.db3 "drop table hrc_datacenters_equipment_defrag;"
sqlite3 ko_center.dbe "drop table moveplan_details;"
sqlite3 ko_center.db3 "drop table hrc_dc_1307comm;"
sqlite3 ko_center.db3 "drop table hrc_dc_1307unix;"
sqlite3 ko_center.db3 "drop table hrc_dc_1307win;"
sqlite3 ko_center.db3 "drop table hrc_dc_btu;"
sqlite3 ko_center.db3 "drop table hrc_dc_comm;"
sqlite3 ko_center.db3 "drop table hrc_dc_explain;"
sqlite3 ko_center.db3 "drop table hrc_dc_hrc;"
sqlite3 ko_center.db3 "drop table hrc_dc_indy138k;"
sqlite3 ko_center.db3 "drop table hrc_dc_indy139k;"
sqlite3 ko_center.db3 "drop table hrc_dc_ports;"
sqlite3 ko_center.db3 "drop table hrc_dc_power;"
sqlite3 ko_center.db3 "drop table hrc_dc_unix;"
sqlite3 ko_center.db3 "drop table hrc_dc_win;"