[aur-dev] [PATCH] Notify users when a package is updated.

Nicolas Cornu nicolac76 at yahoo.fr
Fri Jul 27 17:41:20 EDT 2012


Le 27/07/2012 23:24, Mario Mueller a écrit :
> Just to get a better understanding...
> why do you need to select the whole fieldset from CommentNotify if you
> do not use a single value of it?
>
> SELECT u.Email FROM Users u
> INNER JOIN CommentNotify cn ON u.ID=cn.UserID
> AND cn.UserID != $uid
> AND cn.PkgID = $packageID
>
> does the same from my point of view and returns only one field or do I
> miss something?
>
In fact, I don't try to "optimize" this request, I only copy the one in 
./web/lib/pkgfuncs.inc.php in the add_package_comment function.


More information about the aur-dev mailing list