• Payment Plugins Poll

    We need your feedback on the need for updated payment plugins. Please go here and give us your feedback.

  • Joomla 5.1

    For running J!5.1 you must install Fabrik 4.1
    See also Announcements

  • Subscription and download (Fabrik 4.1 for J!4.2+ and J!5.1) are working now

    See Announcement
    Please post subscription questions and issues here

    We have resolved the issue with the J! updater and this will be fixed in the next release.

  • Update & Changlog URL Fixer

    At the present time the update site URL for Fabrik is incorrect in all installations up to and including 4.1. This will be corrected in 4.2, however, if you wish to update Fabrik via the J! Updater you can download and install this plugin.

    This file is installed just like any other extension through the J! Extension Installation panel. It will not however actually install anything. Its sole purpose is to fix the Update Site and Changlog URL's. Once done it will simply exit.

    As always, we recommend you perform a site backup priot to installation.

Date element validation rule

jo-ka

Member
Hello,

Can you please help me find the best way to set a validation rule where the date shouldn't be greater that "today"?

Thank's in advance.
 
Hi

This is what I use in a date element to check the date against a predefined one in another table.

PHP:
date_default_timezone_set('UTC');
$db = & JFactory::getDBO();
$tour = (int)'{table___tournament_raw}';
$current = strtotime(gmdate('Y-m-d H:i:s'));
$query = "SELECT deadline FROM table WHERE id = $tour";
$db->setQuery( $query );
$dt = $db->loadResult();
$deadline = strtotime($dt);
return $deadline > $current;

I think it can help u to start or modify it to get what u want.
 
Well, thanks guys.
I need to have the today's system date and not a fixed date.

So, shall something like this would work? I've tried but all I've got is a blank page...

return $data <= CURDATE();
 
I'm not sure about timezones, nor of $data nor of date()...
If it's relevant do some var_dump
 
Well, first make sure it's an issue before trying to solve it. Dump your $data ...

var_dump($data, date('Y-m-d 00:00:00');exit;

... and see if it looks like you need to figure TZ's out.

-- hugh
 
Back
Top