export source code to produce a listing

[dvh]

Is there a way to export the full source code (that includes content of pages, stylesheets, custom tags, etc...) to get it all in an old fashion text listing ?
I guess it is a matter of querying the DB where CMSMS tables are stored ?

[Duketown]

dvh,

CMSMS is table driven and has therefor hardly anything to do with something like a flat file.
Maybe I'm misreading what you give us?
Can you give an idea what you try to achieve?

Duketown

[dvh]

I'm not a web designer nor PHP/HTML/CSS/... expert. Actually it the first time I'm building a web site so I learn whilst using it. (I know I don't fit the minimal criterias to use that thing, but I'm not that stupid either if I get explained  at least, you don't need to teach me MySQL).
If you know PowerBuilder, you probably know it is sometimes difficult to find in which event you put some piece of code.
That is the feeling I have here with CMSMS.
I know there is some tool to extract code from PBL (PoweBuilder Libraries) to generate a flat file and I am search for a similar tool for CMSMS.

May be I should change my way of working with CMSMS (i.e. openning new tab for each page of code I am editing and flipping thru them). Any idea of method of working is welcome.

Dave.

[Pierre M.]

May be you are looking for wget ?

Pierre M.

[Dr.CSS]

I'm not sure you have explained what it is you are trying to do/accomplish maybe a little more about the end result you are looking for would help...

[dvh]

Well, I just want to produce that old fashion listing of code    sth. like:

PAGE page_name : is [not] active, [default], ...
TEMPLATE template_name
CONTENT is as follow:
[ content stuff
...
{custom_tag}
...
END of content ]

TEMPLATE template_name : is [not] active
CONTENT is as follow:
[ content stuff
...
{custom_tag}
...
END of content ]

STYLESHEET my_stylesheet
MEDIA TYPE : ...
CONTENT is as follow:
[ content stuff
...
{custom_tag}
...
END of content ]

USER DEFINED TAG custom_tag
CODE is as follow
[code stuff
...
do_something();
...
END of code]

What is wget? Is it a kind of website grabber ? Not exactly what I am looking for. A site grabber will give me the result of what I coded in CMSMS. I want to see the source code.

[Pierre M.]

Some SQL SELECT/export might help you.

Pierre M.

[Duketown]

dvh,

Code: Select all

I want to see the source code.

I would say look in the source (PHP/menus/pages/news/...other modules).
Is there a problem that you are facing if you want this type of listing?

Duketown

[jmcgin51]

I think DVH wants all the source code at once in a single file, for ease of searching, which I don't think is really possible.  Why not use a text editor (like Notepad++) that has a "search in files" capability?  Type in your search phrase and select the root directory (fully recursive, all directories and files).

[dvh]

Some SQL SELECT/export might help you.

Pierre M.

That is my idea. Is there a description of the DB structure I could use to write sth. I that could help me ? Just to know which tables/columns hold the code you type when in (i.e.) the admin/page/content edtion page.
I am using dbForge Studio Express for MySQL.

I think DVH wants all the source code at once in a single file, for ease of searching, which I don't think is really possible.  Why not use a text editor (like Notepad++) that has a "search in files" capability?  Type in your search phrase and select the root directory (fully recursive, all directories and files).

Pfiouw! At least somebody understands. But I don't think searching files would help since the code you write is stored in the database (unless you write some "external" php modules/extensions of your own).

[Pierre M.]

So if I understand well you don't want to "search in files" with a text editor from a HTML wget extraction but you'd rather work at the SQL level. I don't know if the data model is in the dev doc but you might be interested by thread about pages creation/import with SQL INSERTs : these posts should have enough data model information to begin with.

Pierre M.