Thread:Project:Support desk/Where are saved data of pages ?/reply

Hi Ingrid,

the text for all pages is stored in the database table "text".

Finding the text of one special page it is a bit complicated, but it is not impossible. ;-) Here is what you have to do:

The text of a page itself is stored in the database table "text". To retrieve the text of an article, you must first search in the table "page": Search the field "page_title" for the page title, of which you want to get the text. When you found the right row, note the value of "page_latest".

Then, use the value of "page_latest" to search the table "revision". The value of "page_latest" will be present in the column "rev_id" (exactly in one row in this column). When you found the right row, note the value of "rev_text_id".

Finally use the value of "rev_text_id" to search the table "text". The value of "rev_text_id" will be present in exactly one row in the column "old_id". This is the row, which contains the content of the page.

What do you want to do?