Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_content
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Function
Null
Value
id
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
title
varchar(255)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
alias
varchar(255)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
title_alias
varchar(255)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
introtext
mediumtext
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
<p>Joomla! provides plenty of flexibility when displaying your Web content. Whether you are using Joomla! for a blog site, news or a Web site for a company, you'll find one or more content styles to showcase your information. You can also change the style of content dynamically depending on your preferences. Joomla! calls how a page is laid out a <strong>layout</strong>. Use the guide below to understand which layouts are available and how you might use them. </p> <h2>Content </h2> <p>Joomla! makes it extremely easy to add and display content. All content is placed where your mainbody tag in your template is located. There are three main types of layouts available in Joomla! and all of them can be customised via parameters. The display and parameters are set in the Menu Item used to display the content your working on. You create these layouts by creating a Menu Item and choosing how you want the content to display.</p> <h3>Blog Layout<br /> </h3> <p>Blog layout will show a listing of all Articles of the selected blog type (Section or Category) in the mainbody position of your template. It will give you the standard title, and Intro of each Article in that particular Category and/or Section. You can customise this layout via the use of the Preferences and Parameters, (See Article Parameters) this is done from the Menu not the Section Manager!</p> <h3>Blog Archive Layout<br /> </h3> <p>A Blog Archive layout will give you a similar output of Articles as the normal Blog Display but will add, at the top, two drop down lists for month and year plus a search button to allow Users to search for all Archived Articles from a specific month and year.</p> <h3>List Layout<br /> </h3> <p>Table layout will simply give you a <em>tabular </em>list<em> </em>of all the titles in that particular Section or Category. No Intro text will be displayed just the titles. You can set how many titles will be displayed in this table by Parameters. The table layout will also provide a filter Section so that Users can reorder, filter, and set how many titles are listed on a single page (up to 50)</p> <h2>Wrapper</h2> <p>Wrappers allow you to place stand alone applications and Third Party Web sites inside your Joomla! site. The content within a Wrapper appears within the primary content area defined by the "mainbody" tag and allows you to display their content as a part of your own site. A Wrapper will place an IFRAME into the content Section of your Web site and wrap your standard template navigation around it so it appears in the same way an Article would.</p> <h2>Content Parameters</h2> <p>The parameters for each layout type can be found on the right hand side of the editor boxes in the Menu Item configuration screen. The parameters available depend largely on what kind of layout you are configuring.</p>
fulltext
mediumtext
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
state
tinyint(3)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
sectionid
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
mask
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
catid
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
created
datetime
NOW
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
--------
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
USER
CONCAT
created_by
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
created_by_alias
varchar(255)
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
modified
datetime
NOW
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
--------
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
USER
CONCAT
modified_by
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
checked_out
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
checked_out_time
datetime
NOW
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
--------
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
USER
CONCAT
publish_up
datetime
NOW
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
--------
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
USER
CONCAT
publish_down
datetime
NOW
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
--------
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
USER
CONCAT
images
text
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
urls
text
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
attribs
text
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
show_title= link_titles= show_intro= show_section= link_section= show_category= link_category= show_vote= show_author= show_create_date= show_modify_date= show_pdf_icon= show_print_icon= show_email_icon= language= keyref= readmore=
version
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
parentid
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
ordering
int(11)
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
metakey
text
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
metadesc
text
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
access
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
hits
int(11) unsigned
ASCII
CHAR
MD5
SHA1
ENCRYPT
RAND
LAST_INSERT_ID
COUNT
AVG
SUM
--------
SOUNDEX
LCASE
UCASE
NOW
PASSWORD
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
CONCAT
metadata
text
ASCII
CHAR
SOUNDEX
LCASE
UCASE
PASSWORD
MD5
SHA1
ENCRYPT
LAST_INSERT_ID
USER
CONCAT
--------
NOW
RAND
COUNT
AVG
SUM
CURDATE
CURTIME
FROM_DAYS
FROM_UNIXTIME
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
WEEKDAY
robots= author=
Save
Or
Insert as a new row
-- And --
Go back to previous page
Or
Insert another new row
Or
Go back to this page