With this pipeline, plugins can change the status of a section (e.g. each section is published at its creation).
This pipeline can do everything but in order to modify the status/dates fields, it must modify the statut_tmp/date_tmp fields like this:
sql_updateq('spip_rubriques', array('date_tmp' => '0000-00-00 00:00:00', 'statut_tmp' => 'prive'));Because SQL queries aren’t transactional in SPIP, these temporary fields are necessary in order to be sure that the database won’t be broken during the calculation process.
This pipeline is called here: http://trac.rezo.net/trac/spip/brow...