Re^2: dereference array

I absolutely agree with you that this is a horrible way to get the structure.

The original problem was getting the recent changes from a mediawiki site. I use the excellent mod:MediaWiki::Bot module to retrieve the info using the Mediawiki API.

What you get is then an array of hashes with this structure:

$VAR50 = {
           'revid' => 174,
           'ns' => 0,
           'comment' => '',
           'timestamp' => '2013-04-01T12:30:28Z',
           'user' => 'user',
           'title' => 'page title',
           'type' => 'edit',
           'pageid' => 50,
           'old_revid' => 173,
           'rcid' => 180
         };
[download]

But I then need to put it all together per user: pages edited, number of edits, etc. It would be much easier if I had database access but that is a no-no Thanks for taking the time to look into this.

Comment on Re^2: dereference array Download Code

Replies are listed 'Best First'.
Re^3: dereference array by GrandFather (Saint) on Dec 03, 2013 at 13:55 UTC
Have you looked at DBD::SQLite? It's completely stand alone - just install the module and you've got the whole thing. Maybe the advice in Yes, even you can use CPAN may help too? True laziness is hard work	[reply]
Re^4: dereference array by natxo (Scribe) on Dec 03, 2013 at 14:50 UTC
That is something I had not thought of, self contained sql. Nice, I'll look into it.	[reply]