Restricting media file play count.

I've run the wizard and added the session details - works perfectly...

I have a question that maybe someone can help with...

I have three pages - login.php, home.php and player.php... The login page is self explanatory and after the individual is logged in we return the following session variables:

ID, USER, PRODUCT, PATH, PLAYS and TOTAL

On the home page I'm returning a recordset loop filtered by the EID to display the product title, product link, plays available and total plays purchased... The recordset returns all the data correctly and even loads the flash file correctly... But when I istitute a simple math equation, e.g. PLAYS > TOTAL, it behaves correctly for an exceeded plays and behaves incorrectly for a non exceeded plays - meaning both redirect to the expired.php page.

The first question is - Does SecurityAssist (or Webassist to a greater extent) have something that can do a better job with the following equation?

<?php
	$ePlays = $row_eVideo['ePlays'];
	$ePlayed = $row_eVideo['ePlayed']; 

    if ($ePlayed > $ePlays) { 
		header('Location: expired.php');
	}
	else{
	}
	
?>

The second question is - Is there a way to add +1 to a table on a page load versus an update form? An example would be adding 1 to 4 in ePlayed to equal 5... I would like the player.php page to add a 1 to the total 'ePlayed' for that EID...

I know I'm asking a lot - but - I'm kinda stuck!

Thanks,
Ted

the first question is what is the value in both of those columns?

second question, what is the default value for those columns?

in your database you should make sure that the default value for both of those columns is 0. if it is NULL any math equation attempted will always fail.

NULL is the absence of a value.

NULL cannot be less then 1 or 2 because NULL does not exist.


as for updateing the value on page load, you can use the Before Page load trigger in the update record server behavior to accomplish this.

Thanks @Jason for the reply...

I changed the code to the following

$updateSQL = sprintf("UPDATE eVideo SET eVideo.ePlayed = %s +1 WHERE eVideo.eid = %s",

on Form submit add's the +1 to the db... It works perfectly now for ONE record returned - if there are multiple records, however, with one exceeding the ePlayed the other not exceeding ePlayed, the code defaults to the exceeded redirect.

As an example - I have page 1 and page 2... instead of having a form submit on page 1 I can have the same form on page 2 and set it "before page loads"?

If so I think I've solved one of my MANY problems...

Ted

If you are using the data assist update record server behavior, one of the available triggers will be before page load.