[Xerte-dev] Re: Management.php: List of User's Templates

[Pat L (pgogy)]

Suspect question answers itself

select td.*, tr.*, ld.*, od.login_id as owner_id, od.firstname as
owner_firstname, od.surname as owner_surname, od.username as owner_username
from
templatedetails td,
templaterights tr,
logindetails ld,
logindetails od where
tr.user_id = ld.login_id and
ld.login_id = login_id and
od.login_id = td.creator_id and
tr.template_id = td.template_id

they have to be the creator in terms of that list - alternative might be
the log in ID is crap - but that is posted in?

I would play the template - then look in the HTML code for the xml path
(say USER-FILES/560-cczjrt-Nottingham/) and that is the owner.


On Mon, Dec 9, 2013 at 11:32 AM, Julian Tenney <
Julian.Tenney at nottingham.ac.uk> wrote:

> Hi,
>
>
>
> Is there any reason why projects owned by a user wouldn’t show up in the
> list of projects on the Users Templates tab? I need to transfer ownership
> of two projects, but they aren’t in the list. The owner has confirmed they
> are in her workspace.
>
>
>
> Anyone noticed this elsewhere?
>
> This message and any attachment are intended solely for the addressee and
> may contain confidential information. If you have received this message in
> error, please send it back to me, and immediately delete it.   Please do
> not use, copy or disclose the information contained in this message or in
> any attachment.  Any views or opinions expressed by the author of this
> email do not necessarily reflect the views of the University of Nottingham.
>
> This message has been checked for viruses but the contents of an
> attachment may still contain software viruses which could damage your
> computer system, you are advised to perform your own checks. Email
> communications with the University of Nottingham may be monitored as
> permitted by UK legislation.
>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20131209/1f90a4f8/attachment.html>