Free Forum Hosting

Links Home

Main Menu Home Search Administrator Login Form Username Password Remember me Lost Password? No account yet? Register Syndicate Home There are no Items to display Latest News Welcome to Popular Welcome to Polls Who's Online

Powered by fJoomla.com - Free Joomla! Hosting Setup your own free CMS Joomla! now | Free Forum © 2008 Image Hosting Joomla! is Free Software released under the GNU/GPL License. | Design by ah-68 |

1
SELECT folder, element, published, params
 FROM image4freemambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM image4freemenu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
3
SELECT template
 FROM image4freetemplates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM image4freesession
 WHERE (
 ( time < '1227448098' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1227448098' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM image4freemenu
 WHERE id = 1
6
SELECT COUNT(a.id)
 FROM image4freecontent AS a
 INNER JOIN image4freecontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN image4freecategories AS cc ON cc.id = a.catid
 INNER JOIN image4freesections AS s ON s.id = a.sectionid
 LEFT JOIN image4freeusers AS u ON u.id = a.created_by
 LEFT JOIN image4freegroups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-23 15:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-23 15:03' )
 AND s.published = 1
 AND cc.published = 1
7
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM image4freecontent AS a
 INNER JOIN image4freecontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN image4freecategories AS cc ON cc.id = a.catid
 INNER JOIN image4freesections AS s ON s.id = a.sectionid
 LEFT JOIN image4freeusers AS u ON u.id = a.created_by
 LEFT JOIN image4freegroups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-23 15:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-23 15:03' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
LIMIT 4
8
SELECT a.*
 FROM image4freecomponents AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
9
SELECT id, title, module, position, content, showtitle, params
 FROM image4freemodules AS m
 INNER JOIN image4freemodules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 1 )
 ORDER BY ordering
10
SELECT m.*
 FROM image4freemenu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
11
SELECT m.*
 FROM image4freemenu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
12
SELECT m.*
 FROM image4freemenu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 ORDER BY parent, ordering
13
SELECT id, name, link, parent, type, menutype, access
 FROM image4freemenu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
14
SELECT a.id, a.title, a.sectionid, a.catid
 FROM image4freecontent AS a
 LEFT JOIN image4freecontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN image4freecategories AS cc ON cc.id = a.catid
 INNER JOIN image4freesections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-23 15:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-23 15:03' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
15
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM image4freecontent AS i
 LEFT JOIN image4freesections AS s ON i.sectionid = s.id
 LEFT JOIN image4freemenu AS ms ON ms.componentid = s.id 
 LEFT JOIN image4freecategories AS c ON i.catid = c.id
 LEFT JOIN image4freemenu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 1
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
16
SELECT id 
 FROM image4freemenu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
17
SELECT id 
 FROM image4freemenu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
18
SELECT a.id, a.title, a.sectionid, a.catid
 FROM image4freecontent AS a
 LEFT JOIN image4freecontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN image4freecategories AS cc ON cc.id = a.catid
 INNER JOIN image4freesections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-23 15:03' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-23 15:03' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
LIMIT 5
19
SELECT p.id, p.title
 FROM image4freepolls AS p
 INNER JOIN image4freepoll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
20
SELECT id
 FROM image4freemenu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
21
SELECT guest, usertype
 FROM image4freesession