I've written an SQL query to extract some data from our wikidb as follows:
select page_title, u.user_name, u.user_email, rev_timestamp, c.cl_to from page p join revision r on p.page_id = r.rev_page join user u on r.rev_user = u.user_id left join categorylinks c on p.page_id = c.cl_from where page_latest = r.rev_id into outfile "/tmp/report.txt";
I need to obtain the full page URI, not just the Page Title. I can't seem to find that stored in the wikidb. Am I just missing it or is it always dynamically generated?
Thanks Bill
Figured it out myself. I just used concat to prepend the wiki's URI to each page name.
On Thu, Nov 21, 2013 at 9:20 AM, Bill Traynor btraynor@gmail.com wrote:
I've written an SQL query to extract some data from our wikidb as follows:
select page_title, u.user_name, u.user_email, rev_timestamp, c.cl_to from page p join revision r on p.page_id = r.rev_page join user u on r.rev_user = u.user_id left join categorylinks c on p.page_id = c.cl_from where page_latest = r.rev_id into outfile "/tmp/report.txt";
I need to obtain the full page URI, not just the Page Title. I can't seem to find that stored in the wikidb. Am I just missing it or is it always dynamically generated?
Thanks Bill
No, no, no... It is dynamically generated, but you're not supposed to concat strings.
From PHP you use the Title class:
$title = Title::newFromText( 'Foo' ); if ( $title ) { // Invalid titles may be null $title->getLocalURL(); }
And from JS make sure that the 'mediawiki.Title' is loaded and use mw.Title: var title = Title::newFromText( 'Foo' ); if ( title ) { // Invalid titles may be null title->getUrl(); }
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://danielfriesen.name/]
On 2013-11-21 7:56 AM, Bill Traynor wrote:
Figured it out myself. I just used concat to prepend the wiki's URI to each page name.
On Thu, Nov 21, 2013 at 9:20 AM, Bill Traynor btraynor@gmail.com wrote:
I've written an SQL query to extract some data from our wikidb as follows:
select page_title, u.user_name, u.user_email, rev_timestamp, c.cl_to from page p join revision r on p.page_id = r.rev_page join user u on r.rev_user = u.user_id left join categorylinks c on p.page_id = c.cl_from where page_latest = r.rev_id into outfile "/tmp/report.txt";
I need to obtain the full page URI, not just the Page Title. I can't seem to find that stored in the wikidb. Am I just missing it or is it always dynamically generated?
Thanks Bill
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Thu, 21 Nov 2013 19:01:52 +0100, Daniel Friesen daniel@nadir-seen-fire.com wrote:
var title = Title::newFromText( 'Foo' ); if ( title ) { // Invalid titles may be null title->getUrl(); }
This was clearly supposed to be:
var title = mw.Title.newFromText( 'Foo' ); if ( title ) { // Invalid titles may be null title.getUrl(); }
:)
On Thu, Nov 21, 2013 at 1:01 PM, Daniel Friesen daniel@nadir-seen-fire.comwrote:
No, no, no... It is dynamically generated, but you're not supposed to concat strings.
All I'm after is a dump of some data from the wiki database that can be imported to a spreadsheet. In that data, page name needs to be a URI so the users can click from the spreadsheet and open the wiki page. Using concat from the mysql command line in a select statement seems to have worked for me.
I'm sure your way is more correct though, and I'll attempt to wrap the query in PHP and do it properly eventually. Thanks for the reply.
From PHP you use the Title class: $title = Title::newFromText( 'Foo' ); if ( $title ) { // Invalid titles may be null $title->getLocalURL(); }
And from JS make sure that the 'mediawiki.Title' is loaded and use mw.Title: var title = Title::newFromText( 'Foo' ); if ( title ) { // Invalid titles may be null title->getUrl(); }
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://danielfriesen.name/]
On 2013-11-21 7:56 AM, Bill Traynor wrote:
Figured it out myself. I just used concat to prepend the wiki's URI to each page name.
On Thu, Nov 21, 2013 at 9:20 AM, Bill Traynor btraynor@gmail.com
wrote:
I've written an SQL query to extract some data from our wikidb as
follows:
select page_title, u.user_name, u.user_email, rev_timestamp, c.cl_to from page p join revision r on p.page_id = r.rev_page join user u on r.rev_user = u.user_id left join categorylinks c on p.page_id = c.cl_from where page_latest = r.rev_id into outfile "/tmp/report.txt";
I need to obtain the full page URI, not just the Page Title. I can't
seem
to find that stored in the wikidb. Am I just missing it or is it always dynamically generated?
Thanks Bill
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
.http://pdf.cbpassiveincome.com/realsecret/download.php?vip=gabou2014
2013/11/21 Bill Traynor btraynor@gmail.com
On Thu, Nov 21, 2013 at 1:01 PM, Daniel Friesen daniel@nadir-seen-fire.comwrote:
No, no, no... It is dynamically generated, but you're not supposed to concat strings.
All I'm after is a dump of some data from the wiki database that can be imported to a spreadsheet. In that data, page name needs to be a URI so the users can click from the spreadsheet and open the wiki page. Using concat from the mysql command line in a select statement seems to have worked for me.
I'm sure your way is more correct though, and I'll attempt to wrap the query in PHP and do it properly eventually. Thanks for the reply.
From PHP you use the Title class: $title = Title::newFromText( 'Foo' ); if ( $title ) { // Invalid titles may be null $title->getLocalURL(); }
And from JS make sure that the 'mediawiki.Title' is loaded and use mw.Title: var title = Title::newFromText( 'Foo' ); if ( title ) { // Invalid titles may be null title->getUrl(); }
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://danielfriesen.name/]
On 2013-11-21 7:56 AM, Bill Traynor wrote:
Figured it out myself. I just used concat to prepend the wiki's URI to each page name.
On Thu, Nov 21, 2013 at 9:20 AM, Bill Traynor btraynor@gmail.com
wrote:
I've written an SQL query to extract some data from our wikidb as
follows:
select page_title, u.user_name, u.user_email, rev_timestamp, c.cl_to from page p join revision r on p.page_id = r.rev_page join user u on r.rev_user = u.user_id left join categorylinks c on p.page_id = c.cl_from where page_latest = r.rev_id into outfile "/tmp/report.txt";
I need to obtain the full page URI, not just the Page Title. I can't
seem
to find that stored in the wikidb. Am I just missing it or is it
always
dynamically generated?
Thanks Bill
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
((Sorry, screwed up, let me fix that)) No, no, no... It is dynamically generated, but you're not supposed to concat strings.
From PHP you use the Title class:
$title = Title::newFromText( 'Foo' ); if ( $title ) { // Invalid titles may be null $title->getLocalURL(); }
And from JS make sure that the 'mediawiki.Title' is loaded and use mw.Title: var title = mw.Title.newFromText( 'Foo' ); if ( title ) { // Invalid titles may be null title->getUrl(); }
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://danielfriesen.name/]
On 2013-11-21 7:56 AM, Bill Traynor wrote:
Figured it out myself. I just used concat to prepend the wiki's URI to each page name.
On Thu, Nov 21, 2013 at 9:20 AM, Bill Traynor btraynor@gmail.com wrote:
I've written an SQL query to extract some data from our wikidb as follows:
select page_title, u.user_name, u.user_email, rev_timestamp, c.cl_to from page p join revision r on p.page_id = r.rev_page join user u on r.rev_user = u.user_id left join categorylinks c on p.page_id = c.cl_from where page_latest = r.rev_id into outfile "/tmp/report.txt";
I need to obtain the full page URI, not just the Page Title. I can't seem to find that stored in the wikidb. Am I just missing it or is it always dynamically generated?
Thanks Bill
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org