http://www.pillarsforum.org

XLargeLargeNormal

• Links
• Contact Us
• News
• Home

Newsflash

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.

 

You are here Home

Document archive problems Written by Leif Mortensen    Tuesday, 27 July 2010 There has been some errors downloading documents from the document archive - it's solved now sorry for the delay. Well - isn't it a nice summer! Last Updated ( Tuesday, 27 July 2010 )

Who can become a member? Written by Leif Mortensen    Tuesday, 11 August 2009 For a while Pillars Forum has been visited by people who just try to registrate for "fun" or whatever reason they have. Let me point out that this homepage only is for English TEACHERS. They can either have visited NMLI in Ireland or been invited to join our group. It's a free page without desturbing adds. It's run by teachers for teachers, where they can share files, articles, sound files, drama, pictures etc. they can use if they want in their classrooms. Unserious registrants will be deleted. Leif Mortensen   Pictures from Kinsale Written by Leif Mortensen    Friday, 09 November 2007 To the right you can se 21 pictures from Kinsale in Ireland - please have a look at the beautiful coloured houses - that town is worth a visit. The same pictures you can find in the NEW gallery. Last Updated ( Sunday, 10 February 2008 )

More... Welcome to Pillars Forum

<< Start < Prev 1 2 Next > End >>

Results 1 - 4 of 6

Login

Username Password Remember me

Lost Password?

No account yet? Register

Main Menu

Home

News

Links

Contact Us

Search

FAQs

Gallery

Forum

Document archive

Image Rotator

Hello, you either have JavaScript turned off or an old version of Macromedia's Flash Player. Get the latest flash player.

Sudoku

Who's Online

Latest News

• Document archive problems
• Who can become a member?
• Lots of audiofiles in the archives
• Pictures from Kinsale
• Free E-books from project Gutenberg

Popular

• Welcome to Pillars Forum
• The Archives
• Try out the site
• Stunning
• Free E-books from project Gutenberg

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1280452185' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280452185' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 1
7
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups 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 <= '2010-07-30 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-30 01:24' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
8
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 jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups 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 <= '2010-07-30 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-30 01:24' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 4
9
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
10
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'
11
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 = 1 )
 ORDER BY ordering
12
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
13
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-30 01:24' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-30 01:24' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
14
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
15
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
16
SELECT name FROM jos_users WHERE id = 0
17
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
18
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT guest, usertype
 FROM jos_session
20
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections 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 <= '2010-07-30 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-30 01:24' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
21
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 29
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
22
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 28
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
23
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 15
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
24
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 26
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
25
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 25
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
26
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections 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 <= '2010-07-30 01:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-30 01:24' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
LIMIT 5
27
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 13
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 3
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
30
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
31
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 2
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
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 jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu 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 = 4
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
33
SELECT *
 FROM jos_banner
 WHERE showBanner=1
34
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 3