Tuesday, 06 January 2009

You are not authorised to view this resource. You need to login.

Main Menu Top Home (2.0) The Store GeneticMemory's Blog CyberHood Tool Time Links FAQs Nano's Forums News Search Contact Us Our Story Voice & Video Chat Web2.0 Clock Loading Clock... Who's Online Syndicate Visitors: 33370 Sections Science nano - Forums Tool Time The Wu Files News Designed by: Joomla Templates Hosting services

http://geneticmemory.org/joomla, Powered by Joomla and Designed by SiteGround web hosting

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 8 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1231218940' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1231220940' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
5
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
10
SELECT *
 FROM jos_menu
 WHERE id = 8
11
SELECT a.*
 FROM jos_components 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'
12
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_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 = 8 )
 ORDER BY ordering
13
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
14
SELECT guest, usertype
 FROM jos_session
15
SELECT SUM( hits ) AS count
 FROM jos_stats_agents
 WHERE type = 1
16
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM jos_sections as a
 LEFT JOIN jos_content as b ON a.id = b.sectionid
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2009-01-05 23:04' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2009-01-05 23:04' )
 WHERE a.scope = 'content'
 AND a.published = 1
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 5
17
SELECT m.id AS Itemid, m.componentid AS sectionid
 FROM jos_menu AS m
 WHERE ( m.type = 'content_section' OR m.type = 'content_blog_section' )
 AND m.published = 1
 AND ( m.componentid=6 OR m.componentid=5 OR m.componentid=4 OR m.componentid=9 OR m.componentid=1 OR m.componentid=0 )
 ORDER BY m.type DESC, m.id DESC