ls -AoT 2008-*/*.jpg > newpix.sql
ls -AoT 2008-*/*.JPG >> newpix.sql
ls -AoT 2008-*/*.gif >> newpix.sql
ls -AoT 2008-*/*.GIF >> newpix.sql
ls -AoT 2008-*/*.avi >> newpix.sql
ls -AoT 2008-*/*.AVI >> newpix.sql
~jess/bin/Replace "\/" "'\,fnam='" newpix.sql
~jess/bin/Replace "2008 2008-" "2008'\,rURL='pix\/camera\/2008-" newpix.sql
~jess/bin/Replace "\." "'\,ftyp='" newpix.sql
~jess/bin/Replace "jpg" "jpg'\;" newpix.sql
~jess/bin/Replace "JPG" "JPG'\;" newpix.sql
~jess/bin/Replace "gif" "gif'\;" newpix.sql
~jess/bin/Replace "GIF" "GIF'\;" newpix.sql
~jess/bin/Replace "avi" "avi'\;" newpix.sql
~jess/bin/Replace "AVI" "AVI'\;" newpix.sql
~jess/bin/Replace "    " " " newpix.sql
~jess/bin/Replace "   " " " newpix.sql
~jess/bin/Replace "  " " " newpix.sql
~jess/bin/Replace "-rw-rw-r-- 1 jess " "\[" newpix.sql
~jess/bin/Replace "-rw-rw-r-- 1 root " "\[" newpix.sql
~jess/bin/Replace "-rw-r--r-- 1 jess " "\[" newpix.sql
~jess/bin/Replace "-rw-r--r-- 1 root " "\[" newpix.sql
~jess/bin/Replace "\[ " "\[" newpix.sql
#### ~jess/bin/Replace "\|" "\,made='" newpix.sql
~jess/bin/Replace "\[" "INSERT INTO imgdb SET status='NEW'\,host='jick.net'\,fsize=" newpix.sql
~jess/bin/Replace "jpg'\;" "jpg',imgtyp='CL\_PHO',medium='Photo',bwcl='Color'\;" newpix.sql
~jess/bin/Replace "JPG'\;" "JPG',imgtyp='CL\_PHO',medium='Photo',bwcl='Color'\;" newpix.sql
~jess/bin/Replace "avi'\;" "avi',imgtyp='CL\_MOV',medium='Movie',bwcl='Color'\;" newpix.sql
~jess/bin/Replace "AVI'\;" "AVI',imgtyp='CL\_MOV',medium='Movie',bwcl='Color'\;" newpix.sql
~jess/bin/Replace "\;" ",owner='JHBrewer',auth='JHBrewer',entby='JHBrewer'\;" newpix.sql
~jess/bin/Replace " 1 " "'\,made='1 " newpix.sql
~jess/bin/Replace " 2 " "'\,made='2 " newpix.sql
~jess/bin/Replace " 3 " "'\,made='3 " newpix.sql
~jess/bin/Replace " 4 " "'\,made='4 " newpix.sql
~jess/bin/Replace " 5 " "'\,made='5 " newpix.sql
~jess/bin/Replace " 6 " "'\,made='6 " newpix.sql
~jess/bin/Replace " 7 " "'\,made='7 " newpix.sql
~jess/bin/Replace " 8 " "'\,made='8 " newpix.sql
~jess/bin/Replace " 9 " "'\,made='9 " newpix.sql
~jess/bin/Replace " 10 " "'\,made='10 " newpix.sql
~jess/bin/Replace " 11 " "'\,made='11 " newpix.sql
~jess/bin/Replace " 12 " "'\,made='12 " newpix.sql
~jess/bin/Replace " 13 " "'\,made='13 " newpix.sql
~jess/bin/Replace " 14 " "'\,made='14 " newpix.sql
~jess/bin/Replace " 15 " "'\,made='15 " newpix.sql
~jess/bin/Replace " 16 " "'\,made='16 " newpix.sql
~jess/bin/Replace " 17 " "'\,made='17 " newpix.sql
~jess/bin/Replace " 18 " "'\,made='18 " newpix.sql
~jess/bin/Replace " 19 " "'\,made='19 " newpix.sql
~jess/bin/Replace " 20 " "'\,made='20 " newpix.sql
~jess/bin/Replace " 21 " "'\,made='21 " newpix.sql
~jess/bin/Replace " 22 " "'\,made='22 " newpix.sql
~jess/bin/Replace " 23 " "'\,made='23 " newpix.sql
~jess/bin/Replace " 24 " "'\,made='24 " newpix.sql
~jess/bin/Replace " 25 " "'\,made='25 " newpix.sql
~jess/bin/Replace " 26 " "'\,made='26 " newpix.sql
~jess/bin/Replace " 27 " "'\,made='27 " newpix.sql
~jess/bin/Replace " 28 " "'\,made='28 " newpix.sql
~jess/bin/Replace " 29 " "'\,made='29 " newpix.sql
~jess/bin/Replace " 30 " "'\,made='30 " newpix.sql
~jess/bin/Replace " 31 " "'\,made='31 " newpix.sql
echo " "
echo "   Now MANUALLY replace the FIRST \"|\" in each line with \",made='\""
## echo "      and then replace the SECOND '|' in each line with \"',rURL='pix/camera/'\""
echo "         and edit in any other stuff you want."
echo " "