1. Fabrik 3.8.1 has been released. It is mostly bug fixes and feature enhancements, but does include two new plugins (push notifications, and the sequence element). As usual we strongly recommend testing the new release on a sandbox if your application is mission critical, and always do an Akeeba backup before updating.
    Dismiss Notice

There?s any tutorial for submission plug-ins?

Discussion in 'Community' started by Raymond, Jun 7, 2010.

  1. Raymond

    Raymond New Member

    Level: Community
    Hi,
    I am trying to summarize hours by member when a form is submitted from transaction table in order to update user table as ?minsel? for total minutes. I. tried many possibilities without success. There?s any tutorial for submission plug-ins?
    So far I did:
    $db = JFactory::getDBO();
    $sql = DELETE FROM fra_SoldeMinSel;
    $db->setQuery($sql);
    $sql = INSERT INTO fra_SoldeMinSel SELECT fabrik_internal_id, time_date, membre_id, sum(minsel) AS SoldeMinSel FROM Fra_HreSel GROUP BY membre_id LIMIT 0 , 30;
    $db->setQuery($sql);
    $results = $db->loadObjectList();
    But it doesn?t work
    Thanks
    Raymond
     

Share This Page