Get the latest com_mls_events and have a look at the admin.mls_events.php file.

Check out the "showMLS_events_participants" function, you get the query there.

I might build a CSV export function for Excel later, is this what you are looking for?

lol... good fun. We just cross-posted

Hrm, I know whatcha mean. You cannot do it in one single query then, you have to do one query for the users and then loop over the results and run a query for each single user to get the seat information. So you actually need a php script to do this.

I was getting a little confused, I edited my post 3 times in 30 seconds...
I used the same query that you wrote earler for my e-mail question, just changed it to :

Code:

SELECT u.id,row,col FROM mos_mls_seatmap_room_elements AS p INNER JOIN mos_users AS u ON u.id = p.userid WHERE p.status='1' ORDER BY row,col;

It shows like this : ID | Row | Col 293 | 1 | 9 393 | 1 | 11 369 | 1 | 12 368 | 1 | 13 139 | 1 | 14 417 | 1 | 16 etc.... I cant get the Username to show up, only ID, but thats why I think you have to get the username from mls_event_participants like you did with the e-mail query Edit : typo's<br><br>Post edited by: LeviataN, at: 2006/06/09 22:56

No, the names are in the mos_users table. Your query is nearly perfect. I just add the name/username fields and also allow you to just run it by specifying an eventid:

Code:

SELECT u.id,u.name,u.username,u.email,s.row,s.col FROM `mos_mls_seatmap_room_elements` AS `s` INNER JOIN `mos_users` AS `u` ON u.id = s.userid INNER JOIN `mos_mls_seatmap_rooms` AS `r` ON r.id = s.roomid WHERE s.status='1' AND r.eventid=X ORDER BY s.row,s.col

ok, nice Thx !