Way to limit # of free ads by users?

[TVAS]

I'm running a heavily modified version of V3.0.11 Developer.

We have 4 listing packages, one of them is Free.

Is there a way to limit how many ads a user can place in the Free listing package?

[juven14]

Yes - you'd have to count the number of products from the product table made by user id and product #. Then redirect them to a message.

I don't have 3.0.11 nor can I take into account any other mods you might have made so you should adapt this code to your own.

Within Step 3 - usercheckout.php just below:

PHP Code:

$productid=(int)@$_REQUEST['productid']; 


Add in:

PHP Code:

//begin max free ads
$freeID = 'id of free listing package';
if($productid==$freeID)
{
$totalAllowedFree = 'number of free ads allowed';

$sSQL = sprintf("SELECT oOwnerID FROM ".PREFIX."orders WHERE oOwnerID=%s AND oProductID=%s)",
GetSQLValueString($userid, "int"),
GetSQLValueString($freeID, "int"));
$result=$db->query($sSQL);
$numrows = $result->size();

if($numrows > $totalAllowedFree)
{
    //They have too many free ads redirect.
    $location="usercheckout.php";
    $class_tpl->assign('title',"Failure");
    $class_tpl->assign('forward',FALSE);
    $class_tpl->assign('location',$location);
    $class_tpl->assign('msg'," You have exceeded the max free listings. <a href='".$location."'>Place an Ad</a>");
    $class_tpl->assign('body','forward.tpl.php');
    $class_tpl->display('layout.tpl.php');
    exit;
}//end max free ads redirect
}//end max free ads 


Now I haven't tested this so be sure to back up your files and test the results. Let me know how this works out.