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

[Pat @ Pgogy]

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> 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> 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] 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> 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] 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> 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] 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> 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
>> 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
>> _______________________________________________
>> Xerte-dev mailing list
>> 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
>> 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
> 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/20130228/f3e4fa9d/attachment-0001.html>