spip / SPIP

		"R.id_rubrique AS id, max(A.date) AS date_h",

		"spip_rubriques AS R JOIN spip_articles AS A ON R.id_rubrique = A.id_rubrique",

		"A.date>R.date_tmp AND A.statut='publie' $postdates ", "R.id_rubrique");

	while ($row = sql_fetch($r)) {

		sql_updateq("spip_rubriques", array("statut_tmp" => 'publie', "date_tmp" => $row['date_h']),

			"id_rubrique=" . intval($row['id']));

	}

			"R.id_rubrique AS id, max(SR.date_tmp) AS date_h",

			"spip_rubriques AS R JOIN spip_rubriques AS SR ON R.id_rubrique = SR.id_parent",

			"(SR.date_tmp>R.date_tmp OR R.statut_tmp<>'publie') AND SR.statut_tmp='publie' ", "R.id_rubrique");

		while ($row = sql_fetch($r)) {

			sql_updateq('spip_rubriques', array('statut_tmp' => 'publie', 'date_tmp' => $row['date_h']),

				"id_rubrique=" . intval($row['id']));

			$continuer = true;

		}

	} while ($continuer);