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(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l