Content added Content deleted
imported>mutante mNo edit summary |
imported>mutante mNo edit summary |
||
| Line 5: | Line 5: | ||
=== A page being requested === |
=== A page being requested === |
||
==== get |
==== get page_id ==== |
||
SELECT page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Ogg' LIMIT 1 |
SELECT page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Ogg' LIMIT 1; |
||
==== get |
==== get page_latest ==== |
||
SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '17369' LIMIT 1 |
SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '17369' LIMIT 1; |
||
after having page_latest (32808) ,which is = rev_id in revision we can: |
|||
==== get revision_text_id ==== |
|||
SELECT rev_text_id from revision where rev_id=32808; |
|||
after having rev_text_id (32770), which is = old_id, we can finally: |
|||
==== get the actual content ==== |
==== get the actual content ==== |
||
SELECT old_text,old_flags FROM `text` WHERE old_id = ' |
SELECT old_text,old_flags FROM `text` WHERE old_id = '32770'; |
||
<pre> |
|||
brion: mutante: old_id=rev_text_id |
brion: mutante: old_id=rev_text_id |
||
brion: rev_id=page_latest |
brion: rev_id=page_latest |
||
</pre> |
|||
Revision as of 22:42, 5 January 2006
Ok, enough of trying to find the right queries after the upgrade to 1.5 mediawiki.
Lets just log the sql queries from the server.
A page being requested
get page_id
SELECT page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Ogg' LIMIT 1;
get page_latest
SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '17369' LIMIT 1;
after having page_latest (32808) ,which is = rev_id in revision we can:
get revision_text_id
SELECT rev_text_id from revision where rev_id=32808;
after having rev_text_id (32770), which is = old_id, we can finally:
get the actual content
SELECT old_text,old_flags FROM `text` WHERE old_id = '32770';
brion: mutante: old_id=rev_text_id brion: rev_id=page_latest