Search Enter Keywords:
Saturday, 04 July 2009 Links Contact Us News Home
Home Newsflash Mambo 4.5 is 'Power In Simplicity'!. It has never been easier to create your own dynamic site. Manage all your content from the best CMS admin interface. Newsflash 1 Mambo 4.5 is 'Power In Simplicity'!. It has never been easier to create your own dynamic site. Manage all your content from the best CMS admin interface. Newsflash 2 Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the need for better RAM was due to some fool increasing the front-side bus speed. In future, busses will be told to slow down in residential motherboards. Newsflash 3 Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.	Who's Online We have 3 guests online Polls Popular Example FAQ Item 1 Example News Item 1 Newsflash 3 Newsflash 1 Newsflash 2	Main Menu Home Blog Links Contact Us Search User Menu Your Details Submit News Submit WebLink Check-In My Items Logout MamboServer MamboForge Administrator Login Form Username Password Remember me Forgotten your password? No account yet? Create one Syndicate Template Chooser JavaBean rhuk_planetfall rhuk_solarflare_ii Latest News Newsflash 1 Newsflash 2 Newsflash 3 Example News Item 1 Example FAQ Item 1

Copyright 2000 - 2005 Miro International Pty Ltd. All rights reserved.

Mambo is Free Software released under the GNU/GPL License.

1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1246760590)
5
SELECT * FROM mos_session WHERE session_id='5d9a0383633dbe508105b281dfa2ac3e'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('7879fc2dea22525af168012a2acc1c43')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '1d7320942104644018ab732065c9eaf0','1246761490','','0','1' )
8
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
13
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
14
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
15
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
16
SELECT access FROM mos_menu WHERE id='1'
17
SELECT * FROM mos_menu WHERE id='1'
18
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-07-04 14:38:10'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-04 14:38:10' )
 ORDER BY f.ordering
19
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
20
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
21
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
22
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
23
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
24
SELECT * FROM mos_mambots WHERE id='16'
25
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=2
26
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
27
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
28
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
29
SELECT * FROM mos_mambots WHERE id='16'
30
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=3
31
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
32
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
33
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
34
SELECT * FROM mos_mambots WHERE id='16'
35
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=4
36
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
37
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
38
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
39
SELECT m.* FROM mos_menu AS m
WHERE menutype='topmenu' AND published='1' AND parent='0'
ORDER BY ordering
40
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
41
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
42
SELECT a.id
 FROM mos_content AS a
 INNER JOIN mos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 14:38:10') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 14:38:10')
 AND catid='3' 
 ORDER BY a.ordering
43
SELECT * FROM mos_content WHERE id='2'
44
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
45
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
46
SELECT * FROM mos_mambots WHERE id='16'
47
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=2
48
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
49
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
50
SELECT p.id, p.title
FROM mos_poll_menu AS pm, mos_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
51
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 14:38:10' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 14:38:10' )
 ORDER BY a.hits DESC LIMIT 5
52
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
53
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
54
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
55
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=10
56
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
57
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=6
58
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
59
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=4
60
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
61
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=2
62
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
63
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=3
64
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
65
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent,ordering
66
SELECT m.* FROM mos_menu AS m
WHERE menutype='usermenu' AND published='1'
ORDER BY parent,ordering
67
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1'
ORDER BY parent,ordering
68
SELECT name FROM mos_users WHERE id = 0
69
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 14:38:10' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 14:38:10' )
 ORDER BY a.created DESC LIMIT 5
70
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
71
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
72
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
73
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=2
74
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
75
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=3
76
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
77
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=4
78
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
79
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=6
80
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0
81
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=10
82
SELECT id 
FROM mos_menu 
WHERE type='content_blog_section' AND published='1' AND componentid=0