query field - substitution number groupjive

Thanks for your response

Sorry i was not clear. Can I add, each time an user create a group, this sql request in "about tab" of group

SELECT AVG(bestscore) AS avgscore
FROM score, groupjive_users
WHERE score.id=groupjive_users.user_id
AND groupjive_users.group=24

But in the "about tab" of group number 1 the last line of request should be "AND groupjive_users.group=1"
In the "about tab" of group number 2 the last line of request should be "AND groupjive_users.group=2"

You can't add that to the About tab. It does not process substitutions. Nor does it execute SQL or PHP. You'll need to do as suggested in my previous reply and modify the template files to add your query directly to it. In the Group template files you'll have access to the GJ group object which contains its ID and various other information.

Ok

If i modify the template, i have default of hack. Each time I upgrade groupjive, i should start all hover again.

The best way, will be have a "Hello world" pluggin for groupjive. Have you got this ?

If i modify the template, i have default of hack. Each time I upgrade groupjive, i should start all hover again.

The template system supports overrides. Create a new folder (e.g. "mytemplate") in the templates folder. Now copy over the file you want to modify from "default" to "mytemplate". Navigate to GJ configuration and change the template to "mytemplate". Now modify the file you copied over. Your custom template changes will not be lost on upgrade or re-install.

The best way, will be have a "Hello world" pluggin for groupjive. Have you got this ?

Yes, that's basically what the About integration is. It's the absolute most simple working integration for GJ. It should be used as an example or even modified if you like.