Help for working with images in the dev environment

[alice-blue]

I can’t find the images table in phpMyAdmin. The code seems to refer to an images table, for example, in lines 23-25 in image-util.php:

$result = mysql_query(
    "select $imgcol, format, copystat, copyright, userid
     from images where id='$key'", $db);

The readme for IFDB’s dev environment says

Game box-art images load from the production IFDB site, not the dev environment. IFDB uses a separate “images” database that isn’t part of the IFArchive backup. We’ll need to generate a backup of that database and make it available on IFArchive, or, at the very least, provide a way for developers to download images from the real IFDB.

So it’s not clear to me if it’s possible to work on a feature to allow users to enter image descriptions to be used in alt text.

I have also noticed that when I try to go to the large version of cover art (by clicking the small cover on the viewgame page) in the dev environment, I am instead sent to the live IFDB site. So if I want to add a link on the large-cover page to allow editing an image description, I don't know how to test it.

It would be helpful to be able to have

• a table with the columns of the images table, or a copy of the code that creates the table so that developers can create a similar table in the dev environment.
• the ability to access the large image page and any other relevant parts of the site--just enough to be able to test.
• Maybe a couple sample cover art images.

[alice-blue]

I realized that it's possible to add a "custom image descriptions" feature without using the images table if I store the custom text in the games table instead. Maybe that will work better anyway.

I'm still not sure how to test how things look on the large image page, though, after making changes to it.