Server side validation, / event loop

SP

SPABO 29 Nov, 2018

It worked nicely in CF4, but I cannot find how to set up a serverside validation, with an event loop in CF5

Any ideas on this??

Gr

GreyHead 29 Nov, 2018

Hi Kees,

Add the Server Validation action from the Validation actions group to the form On Submit event.

Bob

SP

SPABO 29 Nov, 2018

Hi Bob,
I have seen the Action, but where shoud I put this code in...

<?
$then = JFactory::getDate(JRequest::getString('datum', 'now'));
$now = JFactory::getDate();
$diff = $then->toUnix() - $now->toUnix();
if ($diff >100*24*60*60) {
$form->validation_errors['datum'] = 
"Sorry, u bent helaas te vroeg om in te schrijven!";
return false;
} elseif ($diff <11*24*60*60) {
$form->validation_errors['datum'] = 
"Sorry, u bent helaas te laat om u nog in te schrijven!";
return false;
}
?>
<?
$db =& JFactory::getDBO();
$pst = "SELECT COUNT(*) AS %s FROM %s
WHERE %s = %s";
$query = sprintf(
$pst,
$db->quoteName('items'),
$db->quoteName('zw30r_chronoforms_data_XXXXXXXXX'),
$db->quoteName('datum'),
$db->Quote(JRequest::getString('datum')));
$result = $db->loadObject();
$total = $result->items+1;
$form->data['total'] = $total;
if (($result->items+1)>54){
$form->validation_errors[''] = 
"Helaas, het maximum aantal deelnemers is reeds bereikt! Stuur een e-mail naar de wedstrijdleiding als u op de reservelijst wenst te komen.";
return false;}
?>
<?php
$datum = JRequest::getString('voornaam', '', 'post');
$user_info = JRequest::getString('achternaam', '', 'post');
if ( $datum && $user_info ) {
  $db =& JFactory::getDBO();
  $query = "
    SELECT COUNT(*)
      FROM `zw30r_chronoforms_data_XXXXXXXXX`
      WHERE `voornaam` = '{$datum}'
        AND `achternaam` = '{$user_info}';
  ";
  $db->setQuery($query);
  $count = $db->loadResult();
  if ( $count > 0 ) {
    $form->validation_errors[''] = "U heeft dit formulier reeds ingezonden.";
    return false;
  }}
?>

Pls advise...

Gr

GreyHead 30 Nov, 2018

Hi Kees,

For a custom server-side validation you can use the Event Switcher action. Please see this FAQ.

Bob

SP

SPABO 30 Nov, 2018

Pfffff.....why is everything changed, what was wrong with the Custom Server Validation?

Anyway, no clue how to handle teh old script in teh "Event Switcher"

Can I past teh former code into this??

SP

SPABO 30 Nov, 2018

Hold fire....I'm getting close...

SP

SPABO 30 Nov, 2018

Answer

Hi Bob,
With some little changes I managed to get it working now:
In the Events section of the Eventswitcher I put only "fail" in it
And an Eventloop in the Eventswitcher
Pls find the code

<?php
$valid = true;
$then = JFactory::getDate(JRequest::getString('datum', 'now'));
$now = JFactory::getDate();
$diff = $then->toUnix() - $now->toUnix();
if ($diff >500*24*60*60) {
$form->errors['datum'] = 'Sorry, u bent helaas te vroeg om u in te schrijven!';
return fail;
} elseif ($diff <11*24*60*60) {
$form->errors['datum'] = "Sorry, u bent helaas te laat om u nog in te schrijven!";
return fail;
}
?>
<?
$valid = true;
$db =& JFactory::getDBO();
$pst = "SELECT COUNT(*) AS %s FROM %s
WHERE %s = %s";
$query = sprintf(
$pst,
$db->quoteName('items'),
$db->quoteName('zw30r_chronoforms_data_MY DB'),
$db->quoteName('datum'),
$db->Quote(JRequest::getString('datum')));
$result = $db->loadObject();
$total = $result->items+1;
$form->data['total'] = $total;
if (($result->items+1)>54){
$form->errors[''] = 
"Helaas, het maximum aantal deelnemers is reeds bereikt! Stuur een e-mail naar de wedstrijdleiding als u op de reservelijst wenst te komen.";
return fail;}
?>
<?
$valid = true;
$user_info1 = JRequest::getString('voornaam', '', 'post');
$user_info2 = JRequest::getString('achternaam', '', 'post');
if ( $user_info1 && $user_info2 ) {
  $db =& JFactory::getDBO();
  $query = "
    SELECT COUNT(*)
      FROM `zw30r_chronoforms_data_MY DB`
      WHERE `voornaam` = '{$user_info1}'
        AND `achternaam` = '{$user_info2}';
  ";
  $db->setQuery($query);
  $count = $db->loadResult();
  if ( $count > 0 ) {
    $form->errors[''] = "U heeft dit formulier reeds ingezonden.";
    return fail;
  }}
?>

This is all working fine now!!!
Thanks sofar!!
Best regards
Kees

Forums

Server side validation, / event loop