2008/3/9 robelix <robelx-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>

1) Display the Seen-Eye in search list:

search.php-userseen.diff adds the seen-flag to the query. No template changes necessary.

--- ../videodb/search.php       2008-01-25 16:51:50.000000000 +0100
+++ search.php  2008-03-09 12:21:34.000000000 +0100
<at> <at> -211,11 +211,14 <at> <at>
                      video_codec, video_width, video_height, istv,
                      lastupdate, mediatype, created,
                      custom1, custom2, custom3, custom4,
+                       !ISNULL('.TBL_USERSEEN.'.video_id) AS seen,
                      '.TBL_LENT.'.who, '.TBL_USERS.'.name AS owner, '.TBL_MEDIATYPES.'.name AS mediatypename
                 FROM '.$TABLE.' '.TBL_DATA.'
            LEFT JOIN '.TBL_LENT.' ON '.TBL_DATA.'.diskid = '.TBL_LENT.'.diskid
            LEFT JOIN '.TBL_MEDIATYPES.' ON '.TBL_DATA.'.mediatype = '.TBL_MEDIATYPES.'.id
            LEFT JOIN '.TBL_USERS.' ON owner_id = '.TBL_USERS.'.id
+                       LEFT JOIN '.TBL_USERSEEN.'
+                                  ON '.TBL_DATA.'.id = '.TBL_USERSEEN.'.video_id AND '.TBL_USERSEEN.'.user_id = '.addslashes($_COOKIE['VDBuserid']).'
                WHERE 1=1 '.$QUERY.'
             ORDER BY title, subtitle';


--- ../videodb/index.php        2008-02-02 18:02:09.000000000 +0100
+++ index.php   2008-03-09 12:09:29.000000000 +0100
<at> <at> -234,12 +234,15 <at> <at>
                  video_codec, video_width, video_height, istv,
                  lastupdate, mediatype,
                  custom1, custom2, custom3, custom4,
-                  created, !ISNULL('.TBL_USERSEEN.'.video_id) AS seen
+                  created, !ISNULL('.TBL_USERSEEN.'.video_id) AS seen,
+                  '.TBL_MEDIATYPES.'.name AS mediatypename
             FROM '.TBL_DATA.'
        LEFT JOIN '.TBL_LENT.'
               ON '.TBL_DATA.'.diskid = '.TBL_LENT.'.diskid
        LEFT JOIN '.TBL_USERSEEN.'
               ON '.TBL_DATA.'.id = '.TBL_USERSEEN.'.video_id AND '.TBL_USERSEEN.'.user_id = '.addslashes($_COOKIE['VDBuserid']).'
+        LEFT JOIN '.TBL_MEDIATYPES.'
+               ON '.TBL_DATA.'.mediatype = '.TBL_MEDIATYPES.'.id
        LEFT JOIN '.TBL_USERS.'
               ON '.TBL_DATA.'.owner_id = '.TBL_USERS.".id
           $JOINS

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
videodb-devel mailing list
videodb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/videodb-devel

--
Krofinzki