Naslovnica Alatna traka Brza novost Tako je! Posjeti!  p.s. možda neće raditi!u beta je fazi!

Novi portal Ocjena: / 0 Autor: administrator    Saturday, 23 February 2008 Tako je! Posjeti!  p.s. možda neće raditi!u beta je fazi!    Recenzija:tt.Pack 1 Ocjena: / 0 Autor: administrator    Sunday, 10 February 2008 Evo da pokažemo prvu inačicu našeg programa. Zove se tt.Pack! Jednostavan je i na instalaciji: Pritisnete ACCEPT pa INSTALL i gotovo Onda se otvori - index.html - tt.Pack 1 Pogledajte sliku:   Zadnja Promjena ( Sunday, 10 February 2008 ) Opširnije...   Uskoro novi forum Ocjena: / 0 Autor: administrator    Saturday, 09 February 2008 Tako je.   Već je gotov! (naslovnica je Home i/ili Index)  Zadnja Promjena ( Saturday, 09 February 2008 ) Opširnije...   Više... Stari postovi Zadnji članci Novi portal Vratio se SMF forum Recenzija:tt.Pack 1 InternetC@fe Prezentacije Uskoro novi forum Popularno Stari postovi Uskoro novi forum Recenzija:tt.Pack 1 Zašto moja vijesti nije objavljena? Novi portal Glavni izbornik Naslovnica Blog Web preporuke Pretraživanje Često postavljena pitanja Technoforum(forum) Galerija Kontakt InternetC@fe Prijava Korisničko ime Šifra Zapamti Me Zaboravili ste šifru? Ako još nemate Korisnički račun, možete ga kreirati ovdje. Praćenje članaka Anketa Kako se osjećate uz instaliranu Joomlu!? Jednostavno je Jako lagano je Ne znam raditi Mrzim kad se instalira nešto novo na server Mrzim kad nema onoga što sam poželio/la Mrzim sve Mrzim što nema Zašto se registrirati? Ljubim sajt:)iliti: jako dobro   Tko je online Free Joomla! hosting powered by FreeJoomlas.com Template Design by funky-visions.de

 

1
SELECT folder, element, published, params
 FROM technotainmentmambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM technotainmentmenu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 1
3
SELECT template
 FROM technotainmenttemplates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
 LIMIT 1
4
DELETE FROM technotainmentsession
 WHERE ( time < '1283490255' )
 AND guest = 0 
 AND gid > 0
5
DELETE FROM technotainmentsession
 WHERE ( time < '1283490255' )
 AND guest = 1 
 AND userid = 0
6
SELECT access
 FROM technotainmentmenu
 WHERE id = 1
7
SELECT *
 FROM technotainmentmenu
 WHERE id = '1'
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,
 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 technotainmentcontent AS a
 INNER JOIN technotainmentcontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN technotainmentcategories AS cc ON cc.id = a.catid
 INNER JOIN technotainmentsections AS s ON s.id = a.sectionid
 LEFT JOIN technotainmentusers AS u ON u.id = a.created_by
 LEFT JOIN technotainmentcontent_rating AS v ON a.id = v.content_id
 LEFT JOIN technotainmentgroups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-03 00:19:15'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-03 00:19:15' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
9
SELECT COUNT( id )
 FROM technotainmentmenu 
 WHERE type = 'content_blog_section'
 AND published = 1
10
SELECT COUNT( id )
 FROM technotainmentmenu 
 WHERE type = 'content_blog_category'
 AND published = 1
11
SELECT COUNT( id )
 FROM technotainmentmenu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
12
SELECT folder, element, published, params
 FROM technotainmentmambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
13
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 20
14
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 20
15
SELECT id 
 FROM technotainmentmenu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
16
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 18
17
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 18
18
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 15
19
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 15
20
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 12
21
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 12
22
SELECT a.*
 FROM technotainmentcomponents AS a
 WHERE a.name = 'Syndicate'
23
SELECT id, name, link, parent, type, menutype
 FROM technotainmentmenu
 WHERE published = 1
 ORDER BY menutype, parent, ordering
24
SELECT id, title, module, position, content, showtitle, params
 FROM technotainmentmodules AS m
 INNER JOIN technotainmentmodules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= '0'
 AND m.client_id != 1
 AND ( mm.menuid = '1' OR mm.menuid = 0 )
 ORDER BY ordering
25
SELECT m.*
 FROM technotainmentmenu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
26
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM technotainmentcontent AS a
 INNER JOIN technotainmentcategories AS cc ON cc.id = a.catid
 INNER JOIN technotainmentsections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-03 06:19:15' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 06:19:15' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
27
SELECT a.id, a.title, a.sectionid, a.catid
 FROM technotainmentcontent AS a
 LEFT JOIN technotainmentcontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN technotainmentcategories AS cc ON cc.id = a.catid
 INNER JOIN technotainmentsections 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-09-03 00:19:15' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 00:19:15' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
 LIMIT 5
28
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 19
29
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 19
30
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 16
31
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 16
32
SELECT a.id, a.title, a.sectionid, a.catid
 FROM technotainmentcontent AS a
 LEFT JOIN technotainmentcontent_frontpage AS f ON f.content_id = a.id
 INNER JOIN technotainmentcategories AS cc ON cc.id = a.catid
 INNER JOIN technotainmentsections 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-09-03 00:19:15' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 00:19:15' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
 LIMIT 5
33
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 14
34
SELECT m.id 
 FROM technotainmentcontent AS i
 LEFT JOIN technotainmentsections AS s ON i.sectionid = s.id
 LEFT JOIN technotainmentmenu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
 AND i.id = 14
35
SELECT m.*
 FROM technotainmentmenu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
36
SELECT p.id, p.title
 FROM technotainmentpolls AS p
 INNER JOIN technotainmentpoll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
37
SELECT id, text
 FROM technotainmentpoll_data
 WHERE pollid = 14
 AND text != ''
 ORDER BY id
38
SELECT guest, usertype
 FROM technotainmentsession