Would it be possible to restrict each user with a group to submitting only one photo to a public album?

I'm would like to limit users to uploading one photo and am still unable to resolve this. In include/init.inc.php around line 172, I am trying unsuccessfully with the following code:

if ($ugroup['can_upload_pictures'] == 1) {

$query = "SELECT pid FROM ".$xoopsDB->prefix("xcgal_pictures")." WHERE owner_id=".USER_ID." ";
$user_count = mysql_num_rows($query);

if ($user_count >= 1) {
$USER_DATA['can_upload_pictures'] = 0;
}


if ($user_count < 1) {
$USER_DATA['can_upload_pictures'] = $ugroup['can_upload_pictures'];
}
}

I made this function but you need to test it:

add onlyonepic function to include/functions.inc.php file


edit upload.php file then add:

onlyonepic($owner_id);

after this line at the top:

require('include/init.inc.php');

Thank you!! Your code helped put me on the right track and now it's working perfectly from within init.inc.php at line 172. I've modified it further to only search certain albums and assigned "finished" to enable certain messages.

if ($ugroup['can_upload_pictures'] == 1) {


$onepic = "SELECT COUNT(*) FROM ".$xoopsDB->prefix('xcgal_pictures')." WHERE (aid = 1 OR aid = 2 OR aid = 3) AND owner_id = '".$xoopsUser->getVar('uid')."'";
$resultlimit = $xoopsDB->query($onepic);
list($count) = $xoopsDB->fetchRow($resultlimit);
if ($count != 0) {
$USER_DATA['can_upload_pictures'] = 0;
$USER_DATA['finished'] = 1;
}
if ($count == 0) {
$USER_DATA['can_upload_pictures'] = $ugroup['can_upload_pictures'];
$USER_DATA['finished'] = 0;
}
}