5
It's easy when you know some mysql. By the way this gallery is one of the best around.
To do that you will have to get to php and find go to your xoopsdatabase. Go to SQL tab and paste this code. You will have to change 'yourbeginning' to whatever your database tables do starts. If lets say you name like 'xoops_xcgal_pictures' then you would issue that.
UPDATE `yourbeginning_xcgal_pictures` SET `approved` = 'YES';
Of course the same thing can be done from command line.
1.mysql -u root -p (enter MySQL password)
2.select xoopsdatabasename
3.UPDATE `yourbeginning_xcgal_pictures` SET `approved` = 'YES';
Oh la la. All pictures are approved!
Gediminas