[thesite] new styles for beo, leo, meo, and print

[Daniel J. Cody]

rudy -

i've got this 'more or less' working. more in the sense that when you 
post a comment, *you* won't get a notification, but everyone else in the 
thread will..

less in the sense that if you'll recieve a notification for each time 
you've posted in the thread. 5 posts in a thread ==  5 notification 
emails. the problem is we don't have any sort of index in the replies 
table that says, "this person has already posted for this thread" or 
something like that.. otherwise the query loops the recordset, grabbing 
each userid, getting an email for that and sending an email. rather 
rinse repeat. for example:

SQL =
SELECT
     		users.email,
     		users.notify,
     		users.userid,
     		users.firstname,
     		replies.contentid,
     		replies.userid
      	FROM
     		users,
     		replies
      	WHERE
     		users.userid = replies.userid
       	AND replies.contentid = 3509
	AND users.userid != 5 #this is so it doesnt email the person 					#that just posted..

this sends out an email to each userid that has commented on that 
article, with no regard for if they've already got a notification..

is there some better query to only grab each userid once? sorry about 
being a dumbass, my head is really really really foggy and still 
dripping out bong resin and shit.. thanks :)

.djc.
rudy wrote:


> add to issues:   notify article author when somebody adds a comment