#INFO_XXX{objet_type, id_objet} is a tag that allows you to retrieve the value of a field in the database without necessarily making a boucle.
It takes three mandatory parameters:
- XXX: the name of the field
- object_type: this is the type of the object [1] function corresponding to the SQL table you want to query (e.g.: article for the spip_articles table, forum for the spip_forum table, etc.).
- object_id: this is the id of the targeted object.
Off-loop use
#INFO_TITRE{article, 13}
#INFO_NOM{auteur, 2}
This feature is optimised to avoid making multiple SQL queries on the same table. So you can use the tag several times on the same object without worrying.
#INFO_TITRE{article, 13}
#INFO_SOUSTITRE{article, 13}
#INFO_CHAPO{article, 13}
Also parameters can be passed dynamically:
#SET{id_breve, 3}
#INFO_TITRE{breve, #GET{id_breve}}
Use in a loop
<BOUCLE_article(ARTICLES){id_article}>
Here's the article #TITRE of the section #INFO_TITRE{rubrique, #ID_RUBRIQUE}
</BOUCLE_article>
...works well since #ID_RUBRIQUE is a field from the table spip_articles
Automatic processing
The tag applies the usual automatic processing to the requested information, exactly as when #TITRE or #TEXTE is requested in a loop of the object. It therefore takes into account multi tags or SPIP syntax on certain fields.
To disable them, it is necessary to add the asterisk [2], just like the other tags: #INFO_TEXTE*{article, 123}.
Specificities
For TITRE, the tag will look for the definition of the title field in the description of the editorial object [3], which then allows to use the same syntax whatever the content, even if in the database it is the "name" field that is important.
Thus #INFO_TITRE{auteur, 123} will return the signature of this user, stored in the "nom" field of "spip_auteurs".