33 : void
34 {
36
37 $usr_ids_to_request = array_diff($usr_ids, self::$requested_usr_ids);
38 self::$requested_usr_ids = array_merge(self::$requested_usr_ids, $usr_ids_to_request);
39 self::$requested_usr_ids_key_map = array_flip(self::$requested_usr_ids);
40
41 if ($usr_ids_to_request !== []) {
42 $in =
$DIC->database()->in(
'ud.usr_id', $usr_ids_to_request,
false,
'integer');
43 $query = "
44 SELECT ud.usr_id, login, firstname, lastname, title, gender,
45 pprof.value public_profile,pup.value public_upload, pupgen.value public_gender
46 FROM usr_data ud
47 LEFT JOIN usr_pref pprof ON pprof.usr_id = ud.usr_id AND pprof.keyword = %s
48 LEFT JOIN usr_pref pupgen ON pupgen.usr_id = ud.usr_id AND pupgen.keyword = %s
49 LEFT JOIN usr_pref pup ON pup.usr_id = ud.usr_id AND pup.keyword = %s
50 WHERE $in
51 ";
52
54 $query,
55 ['text', 'text', 'text'],
56 ['public_profile', 'public_gender', 'public_upload']
57 );
58
59 while ($row =
$DIC->database()->fetchAssoc(
$res)) {
61 $user->setId((int) $row['usr_id']);
62 $user->setLogin((string) $row['login']);
63 $user->setGender((string) $row['gender']);
64 $user->setTitle((string) $row['title']);
65 $user->setFirstname((string) $row['firstname']);
66 $user->setLastname((string) $row['lastname']);
67 $user->setPref('public_profile', $row['public_profile']);
68 $user->setPref('public_upload', $row['public_upload']);
69 $user->setPref('public_gender', $row['public_gender']);
70
71 self::$user_instances[(
int) $row[
'usr_id']] = $user;
72 }
73 }
74 }