vi ringrazio ho fatto come avete scritto e ho risolto ma il problema adesso è un altro ho installato questo mal...o template per la parte admin ho risolto il problema db ma rimane quello del template mi da scritte strane in fondo la pagina tipo:
SELECT *
FROM jos_session
WHERE session_id = 'a139af173389c150faa71cab02e4bbf9'
AND username = 'admin'
AND userid = 62--------------------------------------------------------------------------------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 < '1190375958' )
AND guest = 0
AND gid > 0
) OR (
( time < '1190375958' )
AND guest = 1
AND userid = 0
)--------------------------------------------------------------------------------6
SELECT id, published
FROM jos_mambots
WHERE element = 'coredesign'
AND folder = 'system'--------------------------------------------------------------------------------7
SELECT *
FROM jos_mambots
WHERE id = '32'--------------------------------------------------------------------------------8
SELECT id, published
FROM jos_modules
WHERE module = 'mod_cd_login'--------------------------------------------------------------------------------9
SELECT *
FROM jos_modules
WHERE id = '75'--------------------------------------------------------------------------------10
SELECT id, published
FROM jos_modules
WHERE module = 'mod_cd_rssfeed'--------------------------------------------------------------------------------11
SELECT id, published
FROM jos_modules
WHERE module = 'mod_cd_bookmarks'--------------------------------------------------------------------------------12
SELECT COUNT(*)
FROM jos_stats_agents
WHERE agent = 'MS Internet Explorer 6.0'
AND type = 0--------------------------------------------------------------------------------13
UPDATE jos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'MS Internet Explorer 6.0'
AND type = 0--------------------------------------------------------------------------------14
SELECT COUNT(*)
FROM jos_stats_agents
WHERE agent = 'Windows XP'
AND type = 1--------------------------------------------------------------------------------15
UPDATE jos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Windows XP'
AND type = 1--------------------------------------------------------------------------------16
SELECT COUNT(*)
FROM jos_stats_agents
WHERE agent = 'net'
AND type = 2--------------------------------------------------------------------------------17
UPDATE jos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'net'
AND type = 2--------------------------------------------------------------------------------18
SELECT *
FROM jos_menu
WHERE id = 1--------------------------------------------------------------------------------19
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 <= '2007-09-21 14:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-21 14:14' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0--------------------------------------------------------------------------------20
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 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
LEFT JOIN jos_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 <= '2007-09-21 14:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-21 14:14' )
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--------------------------------------------------------------------------------21
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
WHERE a.id = 12--------------------------------------------------------------------------------22
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering--------------------------------------------------------------------------------23
SELECT id
FROM jos_mambots
WHERE element = 'caldatebot'
AND folder = 'content'--------------------------------------------------------------------------------24
SELECT *
FROM jos_mambots
WHERE id = '33'--------------------------------------------------------------------------------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 = 12
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------26
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0--------------------------------------------------------------------------------27
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 0--------------------------------------------------------------------------------28
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '12'--------------------------------------------------------------------------------29
SELECT hits FROM jos_content WHERE id = '12'--------------------------------------------------------------------------------30
SELECT count(*) FROM jos_akocomment WHERE contentid='12' AND published='1'--------------------------------------------------------------------------------31
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'--------------------------------------------------------------------------------32
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--------------------------------------------------------------------------------33
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering--------------------------------------------------------------------------------34
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'othermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering--------------------------------------------------------------------------------35
SELECT lc.id AS idcomment, lc.contentid, lc.title AS titlecomment, lc.comment AS lastcomment, lc.date AS lastpost, lc.name AS authorcomment, lc.iduser AS userId, c.id AS id, c.title AS title, c.sectionid AS id_section
FROM jos_akocomment AS lc, jos_content AS c
WHERE c.id = lc.contentid AND lc.published='1'
ORDER BY lc.id DESC
LIMIT 5--------------------------------------------------------------------------------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 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 = 39
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------37
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 = 36
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------38
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 = 30
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------39
SELECT id, username, name, lastvisitDate
FROM jos_users
WHERE block='0' and lastvisitDate<>'0000-00-00 00:00:00'
ORDER BY lastvisitDate DESC LIMIT 5--------------------------------------------------------------------------------40
SELECT p.id, p.title
FROM jos_polls AS p
INNER JOIN jos_poll_menu AS pm ON pm.pollid = p.id
WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
AND p.published = 1--------------------------------------------------------------------------------41
SELECT id
FROM jos_menu
WHERE type = 'components'
AND published = 1
AND link = 'index.php?option=com_poll'--------------------------------------------------------------------------------42
SELECT id, text
FROM jos_poll_data
WHERE pollid = 14
AND text != ''
ORDER BY id--------------------------------------------------------------------------------43
SELECT id, text
FROM jos_poll_data
WHERE pollid = 16
AND text != ''
ORDER BY id--------------------------------------------------------------------------------44
SELECT guest, usertype
FROM jos_session--------------------------------------------------------------------------------45
SELECT count(id) as registered FROM jos_users WHERE usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------46
SELECT count(id) FROM jos_users WHERE to_days(registerDate) = to_days(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------47
SELECT count(id) FROM jos_users WHERE yearweek(registerDate) = yearweek(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------48
SELECT count(id) FROM jos_users WHERE month(registerDate) = month(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------49
SELECT username FROM jos_users WHERE block='0' AND usertype <> 'administrator' AND usertype <> 'superadministrator' ORDER BY registerDate DESC LIMIT 1
addirittura le vedo nella home in fondo la pagina aiutatemi per favore è un sito che ho fatto per un amica e se va distrutto mi uccide :-)
