Nowo?ci

Zainstaluj i korzystaj!
Oceny: / 0
Autor: Stefan Wajda   
17.07.2007.

Tworzenie witryn w Joomla! opiera si? na zasadzie: zainstaluj i korzystaj.
Zmieniony ( 21.07.2011. )
Czytaj całość
 
Krok 1: Instalujemy Joomla!
Oceny: / 0
Autor: Stefan Wajda   
17.07.2007.

Instalacja i konfiguracja Joomla! przebiega w kilku prostych krokach.
Zmieniony ( 21.07.2011. )
Czytaj całość
 
Krok 3: Ustalamy struktur? i system nawigacji
Oceny: / 0
Autor: Stefan Wajda   
17.07.2007.

Dobra struktura to klucz do sukcesu: u?yteczno?ci witryny i satysfakcji internautów.
Zmieniony ( 21.07.2011. )
Czytaj całość
 
Zobacz też…
36 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM prv_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM prv_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM prv_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM prv_session
 WHERE (
 ( time < '1732372300' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1732372300' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT COUNT(*)
 FROM prv_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
7
UPDATE prv_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
8
SELECT COUNT(*)
 FROM prv_stats_agents
 WHERE agent = '_ADM_UNKNOWN'
 AND type = 1
9
UPDATE prv_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = '_ADM_UNKNOWN'
 AND type = 1
10
SELECT COUNT(*)
 FROM prv_stats_agents
 WHERE agent = 'com'
 AND type = 2
11
UPDATE prv_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
12
SELECT *
 FROM prv_menu
 WHERE id = 1
13
SELECT COUNT(a.id)
 FROM prv_content AS a
 INNER JOIN prv_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN prv_categories AS cc ON cc.id = a.catid
 INNER JOIN prv_sections AS s ON s.id = a.sectionid
 LEFT JOIN prv_users AS u ON u.id = a.created_by
 LEFT JOIN prv_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 <= '2024-11-23 15:46' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 15:46' )
 AND s.published = 1
 AND cc.published = 1
14
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
 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM prv_content AS a
 INNER JOIN prv_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN prv_categories AS cc ON cc.id = a.catid
 INNER JOIN prv_sections AS s ON s.id = a.sectionid
 LEFT JOIN prv_users AS u ON u.id = a.created_by
 LEFT JOIN prv_groups AS g ON a.access = g.id
 LEFT JOIN prv_content_rating AS v ON a.id = v.content_id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-23 15:46' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 15:46' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
LIMIT 7
15
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM prv_content AS a
 LEFT JOIN prv_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 22
16
SELECT folder, element, published, params
 FROM prv_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
17
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM prv_content AS a
 LEFT JOIN prv_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 23
18
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM prv_content AS a
 LEFT JOIN prv_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 25
19
SELECT a.*
 FROM prv_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'
20
SELECT id, name, link, parent, type, menutype, access
 FROM prv_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
21
SELECT id, title, module, position, content, showtitle, params
 FROM prv_modules AS m
 INNER JOIN prv_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
22
SELECT m.*
 FROM prv_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND parent = 0
 ORDER BY ordering
23
SELECT m.*
 FROM prv_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
24
SELECT m.*
 FROM prv_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 ORDER BY parent, ordering
25
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
 FROM prv_content
 WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
 GROUP BY created_year DESC, created_month DESC
LIMIT 10
26
SELECT COUNT( id ) AS count_users
 FROM prv_users
27
SELECT COUNT( id ) AS count_items
 FROM prv_content
28
SELECT COUNT( id ) AS count_links
 FROM prv_weblinks
 WHERE published = 1
29
SELECT SUM( hits ) AS count
 FROM prv_stats_agents
 WHERE type = 1
30
SELECT a.id, a.title, a.sectionid, a.catid
 FROM prv_content AS a
 LEFT JOIN prv_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN prv_categories AS cc ON cc.id = a.catid
 INNER JOIN prv_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 <= '2024-11-23 15:46' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-23 15:46' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
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 prv_content AS i
 LEFT JOIN prv_sections AS s ON i.sectionid = s.id
 LEFT JOIN prv_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN prv_categories AS c ON i.catid = c.id
 LEFT JOIN prv_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 = 71
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT id 
 FROM prv_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
33
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 prv_content AS i
 LEFT JOIN prv_sections AS s ON i.sectionid = s.id
 LEFT JOIN prv_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN prv_categories AS c ON i.catid = c.id
 LEFT JOIN prv_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 = 21
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
34
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 prv_content AS i
 LEFT JOIN prv_sections AS s ON i.sectionid = s.id
 LEFT JOIN prv_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN prv_categories AS c ON i.catid = c.id
 LEFT JOIN prv_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 = 20
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35
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 prv_content AS i
 LEFT JOIN prv_sections AS s ON i.sectionid = s.id
 LEFT JOIN prv_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN prv_categories AS c ON i.catid = c.id
 LEFT JOIN prv_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 = 19
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
36
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 prv_content AS i
 LEFT JOIN prv_sections AS s ON i.sectionid = s.id
 LEFT JOIN prv_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN prv_categories AS c ON i.catid = c.id
 LEFT JOIN prv_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 = 18
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id