How to have GMap Usermap show real name?
I am using the GMap User Map (tiki-gmap_usermap.php) to create a "mashup" of all users on my Tiki. It works great... except the map points use each users' login — I want to display the real name (when available).
In looking at the code, I see this query:
Copy to clipboard
$query = "SELECT `login`, `avatarType`, `avatarLibName`, p1.`value` as lon, p2.`value` as lat FROM `users_users` as u "; $query.= "left join `tiki_user_preferences` as p1 on p1.`user`=u.`login` and p1.`prefName`=? "; $query.= "left join `tiki_user_preferences` as p2 on p2.`user`=u.`login` and p2.`prefName`=? ";
Now, I wouldn't know a left join from an inner join but it looks like the query is trying to pull something from the tiki_user_preferences table. How can I make Tiki grab the realName field?
Ideally, I'd like to grab both the login and realName of each user.
Tx,
-R