ls -Ao  --time-style=long-iso 2006-*/*.jpg > newpix.sql
ls -Ao  --time-style=long-iso 2006-*/*.JPG >> newpix.sql
ls -Ao  --time-style=long-iso 2006-*/*.gif >> newpix.sql
ls -Ao  --time-style=long-iso 2006-*/*.GIF >> newpix.sql
ls -Ao  --time-style=long-iso 2006-*/*.avi >> newpix.sql
ls -Ao  --time-style=long-iso 2006-*/*.AVI >> newpix.sql
Replace "\/" "\"\,fnam=\"" newpix.sql
Replace "\." "\"\,ftyp=\"" newpix.sql
Replace "jpg" "jpg\"\;" newpix.sql
Replace "JPG" "JPG\"\;" newpix.sql
Replace "gif" "gif\"\;" newpix.sql
Replace "GIF" "GIF\"\;" newpix.sql
Replace "avi" "avi\"\;" newpix.sql
Replace "AVI" "AVI\"\;" newpix.sql
Replace "    " " " newpix.sql
Replace "   " " " newpix.sql
Replace "  " " " newpix.sql
Replace "-rw-rw-r-- 1 jess " "\[" newpix.sql
Replace "-rw-rw-r-- 1 root " "\[" newpix.sql
Replace "-rw-r--r-- 1 jess " "\[" newpix.sql
Replace "-rw-r--r-- 1 root " "\[" newpix.sql
Replace "\[ " "\[" newpix.sql
Replace ":00 " ":00\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":01 " ":01\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":02 " ":02\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":03 " ":03\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":04 " ":04\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":05 " ":05\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":06 " ":06\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":07 " ":07\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":08 " ":08\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":09 " ":09\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":10 " ":10\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":11 " ":11\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":12 " ":12\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":13 " ":13\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":14 " ":14\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":15 " ":15\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":16 " ":16\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":17 " ":17\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":18 " ":18\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":19 " ":19\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":20 " ":20\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":21 " ":21\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":22 " ":22\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":23 " ":23\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":24 " ":24\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":25 " ":25\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":26 " ":26\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":27 " ":27\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":28 " ":28\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":29 " ":29\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":30 " ":30\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":31 " ":31\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":32 " ":32\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":33 " ":33\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":34 " ":34\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":35 " ":35\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":36 " ":36\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":37 " ":37\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":38 " ":38\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":39 " ":39\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":40 " ":40\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":41 " ":41\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":42 " ":42\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":43 " ":43\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":44 " ":44\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":45 " ":45\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":46 " ":46\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":47 " ":47\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":48 " ":48\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":49 " ":49\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":50 " ":50\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":51 " ":51\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":52 " ":52\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":53 " ":53\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":54 " ":54\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":55 " ":55\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":56 " ":56\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":57 " ":57\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":58 " ":58\"\,rURL=\"pix\/camera\/" newpix.sql
Replace ":59 " ":59\"\,rURL=\"pix\/camera\/" newpix.sql
Replace " " "|" newpix.sql
Replace "|00:" " 00:" newpix.sql
Replace "|01:" " 01:" newpix.sql
Replace "|02:" " 02:" newpix.sql
Replace "|03:" " 03:" newpix.sql
Replace "|04:" " 04:" newpix.sql
Replace "|05:" " 05:" newpix.sql
Replace "|06:" " 06:" newpix.sql
Replace "|07:" " 07:" newpix.sql
Replace "|08:" " 08:" newpix.sql
Replace "|09:" " 09:" newpix.sql
Replace "|10:" " 10:" newpix.sql
Replace "|11:" " 11:" newpix.sql
Replace "|12:" " 12:" newpix.sql
Replace "|13:" " 13:" newpix.sql
Replace "|14:" " 14:" newpix.sql
Replace "|15:" " 15:" newpix.sql
Replace "|16:" " 16:" newpix.sql
Replace "|17:" " 17:" newpix.sql
Replace "|18:" " 18:" newpix.sql
Replace "|19:" " 19:" newpix.sql
Replace "|20:" " 20:" newpix.sql
Replace "|21:" " 21:" newpix.sql
Replace "|22:" " 22:" newpix.sql
Replace "|23:" " 23:" newpix.sql
#### Replace "\|" "\,made=\"" newpix.sql
Replace "\[" "INSERT INTO imgdb SET status=\"NEW\"\,host=\"jick.net\"\,fsize=" newpix.sql
Replace "jpg\"\;" "jpg\",imgtyp=\"CL\_PHO\",medium=\"Photo\",bwcl=\"Color\"\;" newpix.sql
Replace "JPG\"\;" "JPG\",imgtyp=\"CL\_PHO\",medium=\"Photo\",bwcl=\"Color\"\;" newpix.sql
Replace "avi\"\;" "avi\",imgtyp=\"CL\_MOV\",medium=\"Movie\",bwcl=\"Color\"\;" newpix.sql
Replace "AVI\"\;" "AVI\",imgtyp=\"CL\_MOV\",medium=\"Movie\",bwcl=\"Color\"\;" newpix.sql
Replace "\;" ",owner=\"JHBrewer\",auth=\"JHBrewer\",entby=\"JHBrewer\"\;" 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 " "