Well, I'd figured you would find what you were looking for somewhere along that thread as well as other bits that you might be able to implement into your modifications.
This is the Database string to Dbase file... my image file "ABS003.jpg" is in folder Coppermine_Gallery/Albums/Quarrantine/Abstract. cpg140_pictures is the parent table name, 'pid' represents the picture id# in the database where lower numbers represent the oldest files and the highest numbers the most recent files. 'aid' would be the album id#.
`cpg140_pictures` SET `pid` = 16, `aid` = 29, `filepath` = 'quarrantine/Abstract/', `filename` = 'ABS003.jpg', `filesize` = 125390, `total_filesize` = 164344, `pwidth` = 1000, `pheight` = 666, `hits` = 0, `mtime` = '2005-08-25 23:16:40', `ctime` = 1123977064, `owner_id` = 1, `owner_name` = 'evj', `pic_rating` = 0, `votes` = 0, `title` = 'ABS003', `caption` = '', `keywords` = '"scenic sunset" artistic and abstract" all"', `approved` = 'YES', `galleryicon` = 0, `user1` = '', `user2` = '', `user3` = '', `user4` = '', `url_prefix` = 0, `pic_raw_ip` = '', `pic_hdr_ip` = '', `lasthit_ip` = '88.172.94.181', `position` = 0 WHERE `pid` = 16;
Note: Depending on your version of CPG, the table name can vary, i.e. cpg130_pictures, cpg133_pictures, etc. Open the update.sql file in your sql folder to find the proper prefix.
Hope that kind of leads you in the direction you are seeking.
Dennis