Hi, I want to send e-mails to the participants of my events about news, updates etc., but I dont think this feature is in MyLanSite ?
I know about the Mass Email feature in Joomla, but that would send emails to all registered users wich is not what i want.
I tried to make a php-script wich would make a query in the 'mos_mls_events_participants' table, but this table doesn't include the email-address or any personal data. What 'mos_mls_events_participants' and 'mos_users' have in common is the value of id/userid, so this must be the "link". So here I am... what to do ?

Post edited by: LeviataN, at: 2006/05/09 23:09<br><br>Post edited by: LeviataN, at: 2006/05/09 23:13

QUOTE:
what to do ?

Learn SQL

Code:

SELECT u.id,u.name,u.username,u.email FROM `jos_mls_events_participants` AS `p` INNER JOIN `jos_users` AS `u` ON u.id=p.userid WHERE p.eventid='X' AND p.paid='1'

Which will give you all users with ID, fullname, Name and Email which registered for event with ID X and which have paid. -- Edit -- Yeah, but point taken. I might integrate myLANsite in one of the Newsletter components available. No need for me to re-invent the weel and build a newsletter component for myLANsite if some cool stuff already exists. Would be cool if some of you could review this link and let me know which component you find best. I think &quot;Letterman&quot; is not suitable as it does not support multiple lists. And I would wanna build something which will automatically create a list per event you create. Let me know your thoughts.<br><br>Post edited by: moensch, at: 2006/05/10 08:39

Thx again

The code I tried with earlier was

Code:

SELECT u.username, u.email, u.userid FROM mos_mls_events_participants AS p INNER JOIN mos_users AS u ON p.id = u.userid

... with no luck Probably the rest of the php-code is screwed up. I've tried with different combination. Right now the error is &quot;Unknown column 'u.userid' in 'field list'&quot; And sometimes it's just a blank page.

Yes, you copied the code wrongly. There IS no field u.userid as there is no field &quot;userid&quot; in the &quot;mos_users&quot; table.

(...) ON u.id = p.userid (...)

As I wrote. this will work.

Sorry !
I've mixed up some old code, my own from yesterday and the code you posted.
Working great now - thx

New question about query from DB :

I would like to have a script that can read/show users (username) and their selected seat (row &amp; col). The tables to get data from is (probably)mos_mls_events_participants, mos_users and mos_mls_seatmap_room_elements ?? What will the query look like ?

Edit :
...and my host use mysql v4.0.26 wich doesnt support the new feature in com_mls_event<br><br>Post edited by: LeviataN, at: 2006/06/09 22:43