I've modified my copy of photo album to use the order_n field to sort photos. The order_n values can be modfied on the album edit page.
I recommend coordinating your changes with Rocael whom I've sent my changes and is committing many of them along with his own work to the OpenACS repository.
/Bart