Hi, I use this code to add a submission counter:

The counter code is:

//<code>
$db=JFactory::getDBO();
$db->setQuery("SELECT COUNT(`SubmissionId`) cnt FROM #__rsform_submissions WHERE FormId=2");
$db->query();
$result=$db->loadResult();
return intval($result)+1;
//</code>

However, the result is sometimes the same for 2 or more subsequent submissions (i.e. two submissions with the same counter value). I notice that is happening when submissions were sent close in time (< 5 or 10 min).

Is it related to cache? Is it related to server setting?

Thanks for helping me.

i have the same problem, did you find a solution?
thx

Hi

Are you running this code on form load or form submit (I don't recall the RSJoomla terms for these eventgs at the moment)? If the code runs at form load, you can very easily get duplicate numbers when the site is being used concurrently. For example, if I open the form, I get a form counter of COUNT + 1. While I'm filling out the form, you open the form. As I haven't submitted my form yet, the number of entries in the database hasn't changed. So your form also gets the same form counter of COUNT + 1. The result when we save is that we both save the same counter.

It would be better to determine the counter value when the form is saved. It is less likely that two users will submit the form at exactly the same moment, so it is more likely that we will get unique counter ids.

If you are running the code at form submit, please ignore my above wanderings

Ta ra 'wan

Cymdeithas Madog

Hello,

Look at the new code here :
www.rsjoomla.com/support/documentation/v...for-submissions.html

Didier

Hi i have similar problem and tried your code but i have a problem...

i used to have:
$db=JFactory::getDBO();
$db->setQuery("SELECT COUNT(`SubmissionId`) cnt FROM #__rsform_submissions WHERE FormId=5");
$db->query();
$result=$db->loadResult();
return intval($result)+1;

now i delete all that and typed:
$db = JFactory::getDbo();
$db->setQuery("SELECT COUNT(`SubmissionId`) FROM #__rsform_submissions WHERE FormId='".(int) $formId."'");
$_POST = $db->loadResult()+1;

My question is:
i used to send a thank you email saying:
Thanks for your submission your registration number is {counter:value}

Now with the new code this doesn't work, the value shows blank on the email.
How can i fix this?

also
where in the code do i type the form ID number 5 like i did before? or i don't need this anymore?

thx

You can try this:

hi

with your code the {counter:value} is always 1.
The message is always showing the same number 1 and is not increasing to 2, 3, 4, 5...etc

It seems that the $formId variable is not available in the "default value" area of the field. You will need to add the actual Id of the form as per the example above (change 1 to the actual ID)