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,
- When (what are the conditions) the recent changes table clean?
- 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@Wikimedia.org [mailto:mediawiki-l-bounces@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@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l