[Mediawiki-l] Recent Changes page

[Mike Valstar]

SELECT count(*), cur_user_text FROM `cur` GROUP BY cur_user

SELECT count(*), old_user_text FROM `old` GROUP BY old_user

add the 2 values together and you have a change count per user

if you need to review every change your going to have to go into each 
page on your wiki and check the history

Gilad Ravid wrote:

>Thanks,
>
>1. When (what are the conditions) the recent changes table clean?
>2. How to obtain list of all changes ever made? I gave my students
>assignment to make changes to wiki site. I need to list all the changes in
>order to grade them.
>
>Again thanks,
>Gilad
>
>
>-----------------------------------------------------------
>Sure, the world is full of trouble. 
>But, as long as we have people undoing trouble, we have a pretty good world.
>  --Helen Keller
>
>Dr. Gilad Ravid
>Tel: +972-3-7781328
>Mobile: +972-52-5277220
>
>-----Original Message-----
>From: mediawiki-l-bounces at Wikimedia.org
>[mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of Mike Valstar
>Sent: Wednesday, September 07, 2005 4:30 PM
>To: MediaWiki announcements and site admin list
>Subject: Re: [Mediawiki-l] Recent Changes page
>
>the recent changes page uses a separate table to show the changes, this 
>table is cleaned out by mediawiki from time to time so it does not 
>contain ALL of the changes ever made.
>
>Gilad Ravid wrote:
>
>  
>
>>Greetings,
>>
>>I am using mediawiki (ver 1.4.4). I notice that the Special:Recentchanges
>>page is not listing all the changes made so far. 
>>How Can I solve this problem?
>>I changed number of days and number of records and still the first change
>>recorded as made at Aug 22. The revision page history for each page show
>>    
>>
>the
>  
>
>>correct changes made.
>>
>>Thanks,
>>
>>Gilad
>>
>>-----------------------------------------------------------
>>Sure, the world is full of trouble. 
>>But, as long as we have people undoing trouble, we have a pretty good
>>    
>>
>world.
>  
>
>> --Helen Keller
>>
>>Dr. Gilad Ravid
>>Tel: +972-3-7781328
>>Mobile: +972-52-5277220
>>
>>_______________________________________________
>>MediaWiki-l mailing list
>>MediaWiki-l at Wikimedia.org
>>http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>> 
>>
>>    
>>
>
>
>  
>


-- 
Mike Valstar
------------
My Gentoo Sites: http://gentoo-wiki.com http://gentoo-portage.com
My Site: http://thrasher7.net
Need Hosting: http://thrashcorp.com