How can I display the name of the uploader with the picture info?
Warning: this is quite a complicated hack for a newbie to perform! Make sure to back up your original files before attempting this. Edit displayimage.php and search for: $info[$lang_picinfo[‘Filename’]] = htmlspecialchars($CURRENT_PIC_DATA[‘filename’]); add after it: $info[$lang_picinfo[‘Username’]] = htmlspecialchars($CURRENT_PIC_DATA[‘user_name’]);. Then open /include/functions.inc.php and search for following in function get_pic_data(): if($select_columns != ‘*’) $select_columns .= ‘, title, caption’; and replace it with: if($select_columns != ‘*’) $select_columns .= ‘, title, caption, user_name’;. After that search for: $result = cpg_db_query(“SELECT $select_columns from {$CONFIG[‘TABLE_PICTURES’]} WHERE aid=’$album’ $approved $ALBUM_SET ORDER BY $sort_order $limit”); and replace it with: $result = cpg_db_query(“SELECT $select_columns from {$CONFIG[‘TABLE_PICTURES’]} AS p LEFT JOIN {$CONFIG[‘TABLE_USERS’]} AS u ON u.user_id = p.owner_id WHERE p.aid=’$album’ $approved $ALBUM_SET ORD
