Chris Davenport: Tweaked the SQL so as not to include unpublished content. Changed name of images subdirectory.

2008-07-12T15:43:18Z

Tweaked the SQL so as not to include unpublished content. Changed name of images subdirectory.

Chris Davenport: New page: These are some brief notes about the process of creating a help screens SQL dump file that can be used to set up a local help server which can serve help screens for Joomla! 1.5 instances....

2008-07-06T20:26:28Z

New page: These are some brief notes about the process of creating a help screens SQL dump file that can be used to set up a local help server which can serve help screens for Joomla! 1.5 instances....

New page

These are some brief notes about the process of creating a help screens SQL dump file that can be used to set up a local help server which can serve help screens for Joomla! 1.5 instances. It is important to note that the help server must be running on Joomla! 1.0 at this time.

Note: These notes were written to document the process required to create a dump file from help.joomla.org. You will need to adapt the process to create a dump file from a different source.

# Log into the help server.
# Determine the section ID for the 1.5 help screens. (On help.joomla.org this is 42).
# Start up phpMyAdmin or a similar MySQL tool.
# For each of the SQL commands listed below:
#* Click <tt>SQL</tt>.
#* Enter the SQL command in the text box.
#* Click <tt>Export</tt> at the bottom of the screen (not the one at the top).
#* Deselect <tt>Structure</tt>.
#* Click <tt>Go</tt>.
#* Remove unwanted comments from the output.
#* Copy/paste into the appropriate file.
# Use the control panel or an SSH session and create a ZIP archive of the <tt><joomla-root>/images/stories/1_5_help_screens</tt> directory.
# Use a text editor to change <tt>mos_</tt> to <tt>#_</tt> in all the SQL files.
# Package the five SQL dump files, with the images ZIP file and a readme.txt file into a ZIP archive.
# Test.

<source lang="SQL">
SELECT * from mos_categories where section='42';
SELECT * from mos_content where sectionid='42';
SELECT * from mos_menu where menutype regexp '1.5' and name regexp 'Help Screens';
SELECT * from mos_modules where name='fakemenu';
SELECT * from mos_sections where id='42';
</source>

Note: On help.joomla.org the 1.5 help screens menu is part of mainmenu so there is no simple SQL command to export just the help screens menu module. Instead, the "fakemenu" menu is exported. Install it on a Joomla! 1.0 instance, change the fields you need to change, then re-export it, so you get the right SQL command. Alternatively, just use the one already set up as it's really unlikely to change.

@@ Line 14: / Line 14: @@
 #* Remove unwanted comments from the output.
 #* Copy/paste into the appropriate file.
-# Use the control panel or an SSH session and create a ZIP archive of the <tt><joomla-root>/images/stories/1_5_help_screens</tt> directory.
+# Use the control panel or an SSH session and create a ZIP archive of the <tt><joomla-root>/images/stories/help_screens_1.5</tt> directory.
 # Use a text editor to change <tt>mos_</tt> to <tt>#_</tt> in all the SQL files.
 # Package the five SQL dump files, with the images ZIP file and a readme.txt file into a ZIP archive.
@@ Line 21: / Line 21: @@
 <source lang="SQL">
 SELECT * from mos_categories where section='42';
-SELECT * from mos_content where sectionid='42';
+SELECT * from mos_content where sectionid='42' and state='1';
 SELECT * from mos_menu where menutype regexp '1.5' and name regexp 'Help Screens';
 SELECT * from mos_modules where name='fakemenu';

Creating a Joomla! 1.5 help screens SQL dump - Revision history

Chris Davenport: Tweaked the SQL so as not to include unpublished content. Changed name of images subdirectory.

Chris Davenport: New page: These are some brief notes about the process of creating a help screens SQL dump file that can be used to set up a local help server which can serve help screens for Joomla! 1.5 instances....