Hello, on Donnerstag, 23. Dezember 2010, pistazienfresser (see profile) wrote:
Am 21/12/10 19:21, schrieb Christian Boltz:
SELECT *, date(now()) AS date FROM page;
Then we "only" need a tool that calculates the diff in page_counter for two given dates - that's not too difficult to write ;-) A self-JOIN might be enough, something like (untested!)
There is a small patten on every page of the openSUSE wikis (on the original wiki a bit less small) with the number of accesses "This page has been accessed 299,292 times."
Yes, that's exactly what is stored in the page_counter column.
Maybe there is a history for the corresponding data and the difference between a pair of data from different times could be computed?
AFAIK mediawiki doesn't store historic data for the the page_counter. That's why I asked for daily dumps of the page table ;-) Regards, Christian Boltz -- Nicht das ich frei von Paranoia Schueben waere ;), aber wenn Dir das passiert spiel sofort Lotto, bei dem Glueck bekommst Du bestimmt 4 Wochen den 6er mit Superzahl. [Maik Holtkamp in suse-linux] -- To unsubscribe, e-mail: opensuse-wiki+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-wiki+help@opensuse.org