Joomla/Mambo-DB

The following examples are probably more useful when you logic imported. They all give you access to a table in a generic way or for certain types (like the currently logged in user). The properties represent the fields of that table. If want to use SQL instead there is also sql:query and sql:update.
Note: the where parameter is currently added to a SQL statement without additional checking (so be careful with that parameter).
(To use most of them, you need to import mambo_export; in addition some may require logic_export as well)

joomla/mambo
nameoutputcode
mambo:get
var, scope(optional), class(optional), id(optional), where(optional),
table(optional), id-field(optional)

where, order is only valid with table-parameter.
name=Administrator; usertype=Super Administrator
name=Administrator; usertype=Super Administrator
name=Administrator; usertype=Super Administrator
 {mambo:get var="user" class="mosUser" id="62"/}
{c:out value="name=${user.name}; usertype=${user.usertype}"/}<br/>
{mambo:get var="user2" table="#__users" id="62"/}
{c:out value="name=${user2.name}; usertype=${user2.usertype}"/}<br/>
{mambo:get var="result" table="#__users" where="id = 62"/}
{c:set var="user3" value="${result[0]}"/}
{c:out value="name=${user3.name}; usertype=${user3.usertype}"/}<br/>
user:get
var, scope(optional), id(optional), where(optional), order(optional)
 name=Administrator; usertype=Super Administrator
name=Administrator; usertype=Super Administrator
 {user:get var="user" id="62"/}
{c:out value="name=${user.name}; usertype=${user.usertype}"/}<br/>
{user:get var="result" where="id = 62"/}
{c:set var="user2" value="${result[0]}"/}
{c:out value="name=${user2.name}; usertype=${user2.usertype}"/}<br/>
user:getcurrent
var, scope(optional)
 You are currently not logged in. {user:getcurrent var="user"/}
{c:choose}
{c:when test="${!empty user}"}
{c:out value="name=${user.name}; usertype=${user.usertype}"/}
{/c:when}
{c:otherwise}
You are currently not logged in.
{/c:otherwise}
{/c:choose}
content:get
var, scope(optional), id(optional), where(optional), order(optional)
 title=Welcome to Mambo; title_alias=Welcome
found 8 entries
title=Newsflash 3; title_alias=
title=Newsflash 2; title_alias=
title=Newsflash 1; title_alias=
title=News feed added; title_alias=
title=Example News Item 4; title_alias=News4
title=Example News Item 3; title_alias=News3
title=Example News Item 2; title_alias=News2
title=Example News Item 1; title_alias=News1
 {content:get var="content" id="1"/}
{c:out value="title=${content.title}; title_alias=${content.title_alias}"/}<br/>
{content:get var="contentList" where="title LIKE '%News%'" order="title DESC"/}
{c:out value="found ${fn:length(contentList)} entries"/}<br/>
{c:forEach var="entry" items="${contentList}"}
{c:set var="content2" value="${entry.value}"/}
{c:out value="title=${content2.title}; title_alias=${content2.title_alias}"/}<br/>
{/c:forEach}
category:get
var, scope(optional), id(optional), where(optional), order(optional)
 title=Latest; name=Latest News
found 2 entries
title=Latest; name=Latest News
title=Newsflash; name=Newsflash
 {category:get var="category" id="1"/}
{c:out value="title=${category.title}; name=${category.name}"/}<br/>
{category:get var="categoryList" where="name LIKE '%News%'" order="title"/}
{c:out value="found ${fn:length(categoryList)} entries"/}<br/>
{c:forEach var="entry" items="${categoryList}"}
{c:set var="category2" value="${entry.value}"/}
{c:out value="title=${category2.title}; name=${category2.name}"/}<br/>
{/c:forEach}
section:get
var, scope(optional), id(optional), where(optional), order(optional)
 title=News; name=The News
found 2 entries
title=News; name=The News
title=Newsflashes; name=Newsflashes
 {section:get var="section" id="1"/}
{c:out value="title=${section.title}; name=${section.name}"/}<br/>
{section:get var="sectionList" where="name LIKE '%News%'" order="title"/}
{c:out value="found ${fn:length(sectionList)} entries"/}<br/>
{c:forEach var="entry" items="${sectionList}"}
{c:set var="section2" value="${entry.value}"/}
{c:out value="title=${section2.title}; name=${section2.name}"/}<br/>
{/c:forEach}
menu:get
var, scope(optional), id(optional), where(optional), order(optional)
 name=; menutype=
found 4 entries
name=News; menutype=mainmenu
name=Submit News; menutype=usermenu
name=News; menutype=topmenu
name=News Feeds; menutype=mainmenu
 {menu:get var="menu" id="1"/}
{c:out value="name=${menu.name}; menutype=${menu.menutype}"/}<br/>
{menu:get var="menuList" where="name LIKE '%News%'"/}
{c:out value="found ${fn:length(menuList)} entries"/}<br/>
{c:forEach var="entry" items="${menuList}"}
{c:set var="menu2" value="${entry.value}"/}
{c:out value="name=${menu2.name}; menutype=${menu2.menutype}"/}<br/>
{/c:forEach}
weblink:get
var, scope(optional), id(optional), where(optional), order(optional)
 title=Joomla; description=Home of Joomla
found 0 entries
 {weblink:get var="weblink" id="1"/}
{c:out value="title=${weblink.title}; description=${weblink.description}"/}<br/>
{weblink:get var="weblinkList" where="title LIKE '%Mambo%'"/}
{c:out value="found ${fn:length(weblinkList)} entries"/}<br/>
{c:forEach var="entry" items="${weblinkList}"}
{c:set var="weblink2" value="${entry.value}"/}
{c:out value="title=${weblink2.title}; description=${weblink2.description}"/}<br/>
{/c:forEach}