Opened 10 years ago

Closed 5 years ago

#289 closed improve feature (invalid)

Members Trads - Way to display who has translation on his profile

Reported by: jeanyves Owned by: jeanyves
Priority: major Milestone: unassigned
Component: BW Profile Keywords: profile memberstrads
Cc: steinwinde

Description

Currently the lib/prepare_profile_header.php file counts the available trads a members has (via the MOD_user::getTranslations($IdMember?);)
this is aimed to display in the profile header (layout/profilepage_header.php) to display flag according to theoric available translation for the profile.
It works, but this is a hight cost in sql ressource (each time a profile his displayed, all the records of the member in memberstrads are fetched in and array, only records of the language used by the current user (the one who sur the profile) are in fact needed, and, the way it is made, they have already been fetched from the database in another way.

Short term solution could be to change the query in MOD_user::getTranslations($IdMember?); only to count records and to fetch the list of distinct available languages for profile summary

More long term solution : I have the feeling this can be imporved a lot, but not ready to expose ideas here (feel free to propose)

Change History (4)

comment:1 Changed 10 years ago by jeanyves

I have introduce (and commentated) NewInsertIntoMembersTrads?, NewReplaceIntoMembersTrads?,NewInsertCrypted?, NewReplaceIntoCrypted?

they are the same as before except that they now manage the TableColumn? and IdRecord? to allow to make consistency checking

comment:2 Changed 9 years ago by philipp

  • freq_reported set to 1
  • Milestone changed from 0.2 - community to unassigned
  • show_on_bw set to 0

comment:3 Changed 5 years ago by jsfan

  • Milestone Future deleted

Milestone Future deleted

comment:4 Changed 5 years ago by shevek

  • Milestone set to unassigned
  • Resolution set to invalid
  • Status changed from new to closed

Problem might still be in the code but the mentioned files are no longer used. Closing.

Note: See TracTickets for help on using tickets.