Nuno Luciano - Open Source Development

SELECT * FROM (prefix)_config WHERE (conf_modid = '0' AND conf_catid = '1' AND conf_name = 'language') ORDER BY conf_order ASC

SELECT conf_name,conf_value,conf_valuetype FROM (prefix)_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC

SELECT * FROM (prefix)_modules

SELECT conf_name,conf_value,conf_valuetype FROM (prefix)_config WHERE (conf_modid = '3') ORDER BY conf_order ASC

SELECT * FROM (prefix)_modules WHERE isactive = '1' ORDER BY weight ASC, mid ASC

SELECT sess_data FROM (prefix)_session WHERE sess_id = 'ft9fr5dqs7m3aa8d6d8pm2e3b0'

SELECT conf_name,conf_value,conf_valuetype FROM (prefix)_config WHERE (conf_modid = '9') ORDER BY conf_order ASC

SELECT DISTINCT gperm_itemid FROM (prefix)_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid=3

SELECT b.* FROM (prefix)_newblocks b, (prefix)_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (1,2,9,26,8) ORDER BY b.weight,b.bid

SELECT * FROM (prefix)_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC

SELECT * FROM (prefix)_group_permission WHERE (gperm_modid = '1' AND gperm_name = 'module_read' AND gperm_groupid = '3')

SELECT conf_name,conf_value,conf_valuetype FROM (prefix)_config WHERE (conf_modid = '11') ORDER BY conf_order ASC

SELECT distinct c.cat_id FROM (prefix)_page_categories c LEFT JOIN (prefix)_page_category_permissions cp ON c.cat_permission_id=cp.cat_id WHERE (`groupid`=3)

SELECT cat_id,pid,cat_title,cat_vpath FROM (prefix)_page_categories WHERE (`cat_id` IN (0,1,2,3,4,5,6)) ORDER BY cat_order_in_tree

SELECT f.*, s.tpl_source FROM (prefix)_tplfile f LEFT JOIN (prefix)_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'legacy_block_mainmenu.html') ORDER BY tpl_refid

Render template: db:legacy_block_mainmenu.html

SELECT f.*, s.tpl_source FROM (prefix)_tplfile f LEFT JOIN (prefix)_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'legacy_block_themes.html') ORDER BY tpl_refid

Render template: db:legacy_block_themes.html

SELECT conf_name,conf_value,conf_valuetype FROM (prefix)_config WHERE (conf_modid = '4') ORDER BY conf_order ASC

SELECT f.*, s.tpl_source FROM (prefix)_tplfile f LEFT JOIN (prefix)_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'user_block_login.html') ORDER BY tpl_refid

Render template: db:user_block_login.html

SELECT f.*, s.tpl_source FROM (prefix)_tplfile f LEFT JOIN (prefix)_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'legacy_dummy.html') ORDER BY tpl_refid

Render template: db:system_dummy.html

Render template: xcl-flex-starter/theme.html