ls -Ao  --time-style=long-iso 2010-*/*.jpg > newpix.sql
ls -Ao  --time-style=long-iso 2010-*/*.JPG >> newpix.sql
ls -Ao  --time-style=long-iso 2010-*/*.gif >> newpix.sql
ls -Ao  --time-style=long-iso 2010-*/*.GIF >> newpix.sql
ls -Ao  --time-style=long-iso 2010-*/*.avi >> newpix.sql
ls -Ao  --time-style=long-iso 2010-*/*.AVI >> newpix.sql
./editnewpix "-rw-rw-r--\. 1 jess " "\["
./editnewpix "-rw-rw-r--\. 1 root " "\["
./editnewpix "-rwxr--r--\. 1 jess " "\["
./editnewpix "-rwxr--r--\. 1 root " "\["
./editnewpix "-rw-r--r--\. 1 jess " "\["
./editnewpix "-rw-r--r--\. 1 root " "\["
./editnewpix "\/" "\"\,fnam=\""
./editnewpix "\." "\"\,ftyp=\""
./editnewpix "jpg" "jpg\"\;"
./editnewpix "JPG" "JPG\"\;"
./editnewpix "gif" "gif\"\;"
./editnewpix "GIF" "GIF\"\;"
./editnewpix "avi" "avi\"\;"
./editnewpix "AVI" "AVI\"\;"
./editnewpix "    " " "
./editnewpix "   " " "
./editnewpix "  " " "
./editnewpix "\[ " "\["
./editnewpix ":00 " ":00\"\,rURL=\"pix\/camera\/"
./editnewpix ":01 " ":01\"\,rURL=\"pix\/camera\/"
./editnewpix ":02 " ":02\"\,rURL=\"pix\/camera\/"
./editnewpix ":03 " ":03\"\,rURL=\"pix\/camera\/"
./editnewpix ":04 " ":04\"\,rURL=\"pix\/camera\/"
./editnewpix ":05 " ":05\"\,rURL=\"pix\/camera\/"
./editnewpix ":06 " ":06\"\,rURL=\"pix\/camera\/"
./editnewpix ":07 " ":07\"\,rURL=\"pix\/camera\/"
./editnewpix ":08 " ":08\"\,rURL=\"pix\/camera\/"
./editnewpix ":09 " ":09\"\,rURL=\"pix\/camera\/"
./editnewpix ":10 " ":10\"\,rURL=\"pix\/camera\/"
./editnewpix ":11 " ":11\"\,rURL=\"pix\/camera\/"
./editnewpix ":12 " ":12\"\,rURL=\"pix\/camera\/"
./editnewpix ":13 " ":13\"\,rURL=\"pix\/camera\/"
./editnewpix ":14 " ":14\"\,rURL=\"pix\/camera\/"
./editnewpix ":15 " ":15\"\,rURL=\"pix\/camera\/"
./editnewpix ":16 " ":16\"\,rURL=\"pix\/camera\/"
./editnewpix ":17 " ":17\"\,rURL=\"pix\/camera\/"
./editnewpix ":18 " ":18\"\,rURL=\"pix\/camera\/"
./editnewpix ":19 " ":19\"\,rURL=\"pix\/camera\/"
./editnewpix ":20 " ":20\"\,rURL=\"pix\/camera\/"
./editnewpix ":21 " ":21\"\,rURL=\"pix\/camera\/"
./editnewpix ":22 " ":22\"\,rURL=\"pix\/camera\/"
./editnewpix ":23 " ":23\"\,rURL=\"pix\/camera\/"
./editnewpix ":24 " ":24\"\,rURL=\"pix\/camera\/"
./editnewpix ":25 " ":25\"\,rURL=\"pix\/camera\/"
./editnewpix ":26 " ":26\"\,rURL=\"pix\/camera\/"
./editnewpix ":27 " ":27\"\,rURL=\"pix\/camera\/"
./editnewpix ":28 " ":28\"\,rURL=\"pix\/camera\/"
./editnewpix ":29 " ":29\"\,rURL=\"pix\/camera\/"
./editnewpix ":30 " ":30\"\,rURL=\"pix\/camera\/"
./editnewpix ":31 " ":31\"\,rURL=\"pix\/camera\/"
./editnewpix ":32 " ":32\"\,rURL=\"pix\/camera\/"
./editnewpix ":33 " ":33\"\,rURL=\"pix\/camera\/"
./editnewpix ":34 " ":34\"\,rURL=\"pix\/camera\/"
./editnewpix ":35 " ":35\"\,rURL=\"pix\/camera\/"
./editnewpix ":36 " ":36\"\,rURL=\"pix\/camera\/"
./editnewpix ":37 " ":37\"\,rURL=\"pix\/camera\/"
./editnewpix ":38 " ":38\"\,rURL=\"pix\/camera\/"
./editnewpix ":39 " ":39\"\,rURL=\"pix\/camera\/"
./editnewpix ":40 " ":40\"\,rURL=\"pix\/camera\/"
./editnewpix ":41 " ":41\"\,rURL=\"pix\/camera\/"
./editnewpix ":42 " ":42\"\,rURL=\"pix\/camera\/"
./editnewpix ":43 " ":43\"\,rURL=\"pix\/camera\/"
./editnewpix ":44 " ":44\"\,rURL=\"pix\/camera\/"
./editnewpix ":45 " ":45\"\,rURL=\"pix\/camera\/"
./editnewpix ":46 " ":46\"\,rURL=\"pix\/camera\/"
./editnewpix ":47 " ":47\"\,rURL=\"pix\/camera\/"
./editnewpix ":48 " ":48\"\,rURL=\"pix\/camera\/"
./editnewpix ":49 " ":49\"\,rURL=\"pix\/camera\/"
./editnewpix ":50 " ":50\"\,rURL=\"pix\/camera\/"
./editnewpix ":51 " ":51\"\,rURL=\"pix\/camera\/"
./editnewpix ":52 " ":52\"\,rURL=\"pix\/camera\/"
./editnewpix ":53 " ":53\"\,rURL=\"pix\/camera\/"
./editnewpix ":54 " ":54\"\,rURL=\"pix\/camera\/"
./editnewpix ":55 " ":55\"\,rURL=\"pix\/camera\/"
./editnewpix ":56 " ":56\"\,rURL=\"pix\/camera\/"
./editnewpix ":57 " ":57\"\,rURL=\"pix\/camera\/"
./editnewpix ":58 " ":58\"\,rURL=\"pix\/camera\/"
./editnewpix ":59 " ":59\"\,rURL=\"pix\/camera\/"
./editnewpix " " "|"
./editnewpix "|00:" " 00:"
./editnewpix "|01:" " 01:"
./editnewpix "|02:" " 02:"
./editnewpix "|03:" " 03:"
./editnewpix "|04:" " 04:"
./editnewpix "|05:" " 05:"
./editnewpix "|06:" " 06:"
./editnewpix "|07:" " 07:"
./editnewpix "|08:" " 08:"
./editnewpix "|09:" " 09:"
./editnewpix "|10:" " 10:"
./editnewpix "|11:" " 11:"
./editnewpix "|12:" " 12:"
./editnewpix "|13:" " 13:"
./editnewpix "|14:" " 14:"
./editnewpix "|15:" " 15:"
./editnewpix "|16:" " 16:"
./editnewpix "|17:" " 17:"
./editnewpix "|18:" " 18:"
./editnewpix "|19:" " 19:"
./editnewpix "|20:" " 20:"
./editnewpix "|21:" " 21:"
./editnewpix "|22:" " 22:"
./editnewpix "|23:" " 23:"
#### ./editnewpix "\|" "\,made=\""
./editnewpix "\[" "INSERT INTO imgdb SET status=\"NEW\"\,host=\"jick.net\"\,fsize="
./editnewpix "jpg\"\;" "jpg\",imgtyp=\"CL\_PHO\",medium=\"Photo\",bwcl=\"Color\"\;"
./editnewpix "JPG\"\;" "JPG\",imgtyp=\"CL\_PHO\",medium=\"Photo\",bwcl=\"Color\"\;"
./editnewpix "avi\"\;" "avi\",imgtyp=\"CL\_MOV\",medium=\"Movie\",bwcl=\"Color\"\;"
./editnewpix "AVI\"\;" "AVI\",imgtyp=\"CL\_MOV\",medium=\"Movie\",bwcl=\"Color\"\;"
./editnewpix "\;" ",owner=\"JHBrewer\",auth=\"JHBrewer\",entby=\"JHBrewer\"\;"
echo " "
echo "   Now MANUALLY replace the FIRST '|' in each line with  ',made=\"'"
echo "   then check for any symlinks (lrwxrwxrwx at the beginning of the line)"
## echo "      and then replace the SECOND '|' in each line with '\",rURL=\"pix/camera/'"
echo "         and edit in any other stuff you want."
echo " "