I would like to know if it is possible to add fields to PCP that are not part of the user table?
For instance I've got a table with the professions of my guild mates in World of Warcraft and I would like to display thoses professions in the viewtopic left
I can manage to make this completely manually by adding a new query in the viewtopic.php and send the new fields received in some new zones of the viewtopic template. However since PCP has been developped for this purpose I am trying to add this fields only with PCP.
So I created a "linked table" with a join like this:
- Code: Select all
LEFT JOIN WRFR_skill AS [METIERS] ON ([METIERS].char=[USERS].username AND [METIERS].type = "MÃÂÂ ©tiers" AND [METIERS].purelevel > 1)
(METIERS means Profession/skill in french)
but unfortunately I do not see the new fields that should appear with this new Join anywhere so I guess we can only "import" fields that are part of the user table
Whisky