.http://pdf.cbpassiveincome.com/realsecret/download.php?vip=gabou2014
2013/11/21 Bill Traynor <[email protected]> > On Thu, Nov 21, 2013 at 1:01 PM, Daniel Friesen > <[email protected]>wrote: > > > 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 <[email protected]> > > 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 > > > [email protected] > > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > > _______________________________________________ > > MediaWiki-l mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
