[Xerte-dev] Re: Changing Ownership in Management PHP

Tom Reijnders reijnders at tor.nl
Thu Feb 28 20:54:25 GMT 2013


I've got it...

This is the result:





Do you want me to check this in, or do you want the files first....

Tom

Op 28-2-2013 11:44, Pat @ Pgogy schreef:
> I will write a how to guide to do it, whilst doing it
>
> *returns to cave* *plots*
>
> Pgogy Webstuff - http://www.pgogywebstuff.com
> Makers of web things of a fair to middling quality
>
> On 28 Feb 2013, at 10:25, Tom Reijnders <reijnders at tor.nl 
> <mailto:reijnders at tor.nl>> wrote:
>
>> I'll have a look. I am not too familiar with Ajax and xot, but... one 
>> is never too old to learn ;-)
>>
>> Tom
>>
>> Op 28-2-2013 10:49, Julian Tenney schreef:
>>>
>>> I think you might be missing the subtle manager speak in 'would that 
>>> be hard to do'
>>>
>>> ;-)
>>>
>>> *From:*xerte-dev-bounces at lists.nottingham.ac.uk 
>>> [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On Behalf Of *Pat 
>>> @ Pgogy
>>> *Sent:* 28 February 2013 09:37
>>> *To:* For Xerte technical developers
>>> *Subject:* [Xerte-dev] Re: Changing Ownership in Management PHP
>>>
>>> Rewrite the query as a list of usernames, make the username an Ajax 
>>> function which fires and then returns just the data for that user
>>>
>>> One new js function, and splitting the existing php into two files
>>>
>>> Pgogy Webstuff - http://www.pgogywebstuff.com
>>>
>>> Makers of web things of a fair to middling quality
>>>
>>>
>>> On 28 Feb 2013, at 09:08, Julian Tenney 
>>> <Julian.Tenney at nottingham.ac.uk 
>>> <mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
>>>
>>>     It still times out. I think we probably need to limit the
>>>     searching to a particular user name, entered by the admin user.
>>>     I think that makes more sense, I don't really need to browse all
>>>     users LOs, would that be hard to do?
>>>
>>>     *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>>     <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>>     [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On Behalf Of
>>>     *Tom Reijnders
>>>     *Sent:* 28 February 2013 08:59
>>>     *To:* For Xerte technical developers
>>>     *Subject:* [Xerte-dev] Re: Changing Ownership in Management PHP
>>>
>>>     There were a lot of queries inside loops. If you have say 8000
>>>     LO's and 800 users, it would do at least 8800 queries.
>>>
>>>     Try this one (this is a minor rewrite just re-arranging queries,
>>>     it does 2 queries)
>>>
>>>     Tom
>>>
>>>     Op 27-2-2013 18:05, Pat @ Pgogy schreef:
>>>
>>>         Guess that page is timing out.
>>>
>>>         The page will need rewriting, or a new query doing I guess.
>>>
>>>         Pgogy Webstuff - http://www.pgogywebstuff.com
>>>
>>>         Makers of web things of a fair to middling quality
>>>
>>>
>>>         On 27 Feb 2013, at 16:23, Julian Tenney
>>>         <Julian.Tenney at nottingham.ac.uk
>>>         <mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
>>>
>>>             This is what happens:
>>>
>>>             <image001.png>
>>>
>>>             Nothing more.
>>>
>>>             *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>>             <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>>             [mailto:xerte-dev-bounces at lists.nottingham.ac.uk] *On
>>>             Behalf Of *Pat @ Pgogy
>>>             *Sent:* 27 February 2013 14:41
>>>             *To:* For Xerte technical developers
>>>             *Subject:* [Xerte-dev] Re: Changing Ownership in
>>>             Management PHP
>>>
>>>             Management.php is all ajaxed - so the front page should
>>>             work regardless.
>>>
>>>             You can watch the speed of requests in console in
>>>             firebug or chrome to see if that is a problem
>>>
>>>             Pgogy Webstuff - http://www.pgogywebstuff.com
>>>
>>>             Makers of web things of a fair to middling quality
>>>
>>>
>>>             On 27 Feb 2013, at 13:36, Julian Tenney
>>>             <Julian.Tenney at nottingham.ac.uk
>>>             <mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
>>>
>>>                 I had thought it was due to the size of the
>>>                 database, because I noticed it really starting slow
>>>                 up as the number of LOs increased -- we have about
>>>                 8000 now. Does management.php work OK on the sandpit
>>>                 On? You've got a similar number of LOs in there
>>>                 haven't you?
>>>
>>>                 *From:*xerte-dev-bounces at lists.nottingham.ac.uk
>>>                 <mailto:xerte-dev-bounces at lists.nottingham.ac.uk>
>>>                 [mailto:xerte-dev-bounces at lists.nottingham.ac.uk]
>>>                 *On Behalf Of *Pat @ Pgogy
>>>                 *Sent:* 27 February 2013 12:53
>>>                 *To:* For Xerte technical developers
>>>                 *Subject:* [Xerte-dev] Re: Changing Ownership in
>>>                 Management PHP
>>>
>>>                 Yes changing ownership has been there for ages.
>>>
>>>                 If it freezes it suggests a JavaScript problem has
>>>                 occurred
>>>
>>>                 Pgogy Webstuff - http://www.pgogywebstuff.com
>>>
>>>                 Makers of web things of a fair to middling quality
>>>
>>>
>>>                 On 27 Feb 2013, at 11:56, Julian Tenney
>>>                 <Julian.Tenney at nottingham.ac.uk
>>>                 <mailto:Julian.Tenney at nottingham.ac.uk>> wrote:
>>>
>>>                     Can I change ownership in management.php? When I
>>>                     log in, it just appears to freeze, clicking any
>>>                     of the top menus doesn't appear to do anything,
>>>
>>>
>>>
>>>
>>>
>>>
>>>                     _______________________________________________
>>>                     Xerte-dev mailing list
>>>                     Xerte-dev at lists.nottingham.ac.uk
>>>                     <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>>                     http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>>
>>>                 _______________________________________________
>>>                 Xerte-dev mailing list
>>>                 Xerte-dev at lists.nottingham.ac.uk
>>>                 <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>>                 http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>>
>>>             _______________________________________________
>>>             Xerte-dev mailing list
>>>             Xerte-dev at lists.nottingham.ac.uk
>>>             <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>>             http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>         _______________________________________________
>>>
>>>         Xerte-dev mailing list
>>>
>>>         Xerte-dev at lists.nottingham.ac.uk  <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>>
>>>         http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>>
>>>
>>>
>>>
>>>     -- 
>>>
>>>     --
>>>
>>>       
>>>
>>>     Tom Reijnders
>>>
>>>     TOR Informatica
>>>
>>>     Chopinlaan 27
>>>
>>>     5242HM Rosmalen
>>>
>>>     Tel: 073 5226191
>>>
>>>     Fax: 073 5226196
>>>
>>>       
>>>
>>>
>>>
>>>     _______________________________________________
>>>     Xerte-dev mailing list
>>>     Xerte-dev at lists.nottingham.ac.uk
>>>     <mailto:Xerte-dev at lists.nottingham.ac.uk>
>>>     http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>>
>>>
>>>
>>> _______________________________________________
>>> Xerte-dev mailing list
>>> Xerte-dev at lists.nottingham.ac.uk
>>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>>
>> -- 
>> --
>>
>> Tom Reijnders
>> TOR Informatica
>> Chopinlaan 27
>> 5242HM Rosmalen
>> Tel: 073 5226191
>> Fax: 073 5226196
>>
>>
>>
>>
>> _______________________________________________
>> Xerte-dev mailing list
>> Xerte-dev at lists.nottingham.ac.uk 
>> <mailto:Xerte-dev at lists.nottingham.ac.uk>
>> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev
>
>
>
>
>
> _______________________________________________
> Xerte-dev mailing list
> Xerte-dev at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte-dev

-- 
--

Tom Reijnders
TOR Informatica
Chopinlaan 27
5242HM Rosmalen
Tel: 073 5226191
Fax: 073 5226196

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130228/cc24038c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fcgabbgg.png
Type: image/png
Size: 23422 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130228/cc24038c/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bcachfib.png
Type: image/png
Size: 50918 bytes
Desc: not available
URL: <http://lists.nottingham.ac.uk/pipermail/xerte-dev/attachments/20130228/cc24038c/attachment-0003.png>


More information about the Xerte-dev mailing list