1
Gestione siti di Sport / Re:moduli joomlaleague
« il: 28 Ago 2009, 19:09:34 »
devi specificare l'id del progetto nel modulo tutto quì e devi anche attivarlo se non l'hai fatto,ciao :-)
Visualizza post
Questa sezione ti permette di visualizzare tutti i post inviati da questo utente. N.B: puoi vedere solo i post relativi alle aree dove hai l'accesso.
Pagine: [1]
2
Gestione siti di Sport / Re:Nuovo arrivato in joomla league
« il: 08 Ago 2009, 23:03:13 »
ciao lui su joomleague italia stò creando tutte le rose del campionato di serie A DA INSERIRE IN JOOMLEAGUE, se ti interessa visita: http://joomleagueitalia.altervista.org
3
Gestione siti di Sport / Re:Ridurre dimensione titoli dei componenti
« il: 08 Ago 2009, 23:00:14 »
devi agire sui files con estensione .tpl
visita il nuovo sito di supporto http://joomleagueitalia.altervista.org ciao!
visita il nuovo sito di supporto http://joomleagueitalia.altervista.org ciao!
4
Gestione siti di Sport / Re:Problema: ordinare i ruoli della squadra nella rosa
« il: 08 Ago 2009, 22:57:22 »
certo cancella tutto e ricomincia al contrario attaccante,centrocampista,difensore,portiere.
se ti fà piacere visita il nuovo sito di supporto http://joomleagueitalia.altervista.org ciao!
se ti fà piacere visita il nuovo sito di supporto http://joomleagueitalia.altervista.org ciao!
5
Gestione siti di Sport / joomleague italia
« il: 04 Ago 2009, 15:47:46 »
salve ragazzi sono il gestore di joomleague italia,la nuova comunità di supporto a joomleague.de basata principalmente sulla grafica e i proggetti già pronti, da importare in joomleague, se vi interessa far crescere il nuovo proggetto e aiutarci nella creazione di nuova grafica e proggetti, allora vi aspetto tutti su :http://joomleagueitalia.altervista.org
6
Joomsites / Re:joomleague italia forum
« il: 15 Mag 2009, 00:39:37 »è nato un nuovo forum di supporto per joomleague, tutto italiano, collabora anche tu clicca quì http://joomleagueitalia.altervista.org
7
Gestione siti di Sport / nuovo sito di supporto
« il: 30 Apr 2009, 00:20:06 »
nuovo portale di supporto a joomleague.de: http://joomleagueitalia.altervista.org.
non voglio rubbare niente a nessuno,ma voglio soltanto collaborare alla creazione di un sito di supporto indipendente, senza mancare di rispetto a joomleague.de,insomma solo essere indipendenti e portare avanti questo proggetto collaborando sulle traduzioni,grafica,miglioramento del codice ecc... ecc... mantenendo sempre rapporti stretti con joomleague.de.
è tutto,vi ringrazio sperando nel vostro appoggio !
non voglio rubbare niente a nessuno,ma voglio soltanto collaborare alla creazione di un sito di supporto indipendente, senza mancare di rispetto a joomleague.de,insomma solo essere indipendenti e portare avanti questo proggetto collaborando sulle traduzioni,grafica,miglioramento del codice ecc... ecc... mantenendo sempre rapporti stretti con joomleague.de.
è tutto,vi ringrazio sperando nel vostro appoggio !
8
Joomsites / nuovo forum
« il: 31 Mar 2009, 22:33:02 »
è nato un nuovo forum di supporto per joomleague, tutto italiano, collabora anche tu clicca quì http://joomleagueitalia.altervista.org
9
I Template di Joomla 1.5.x / Re: non mi visualizza il template
« il: 20 Gen 2009, 12:07:25 »
grazie sei stato gentilissimo ricontrollo il file xml,speriamo bene! ciao,alla prox.
10
I Template di Joomla 1.5.x / non mi visualizza il template
« il: 20 Gen 2009, 11:25:58 »
salve sono nuovo di post e chiedo un piccolo aiutino, ho creato un template col vostro manuale facendo tutto come era scritto, alla fine ho publicato il template sul mio spazio web, si installa correttamente ma mi succede una cosa strana forse per voi banale dopo averlo installato vado per impostarlo come default ma nella lista dei template non si vede. bah ho riprovato e riprovato ma non so dove sbaglio, aiutatemi per favore grazie.
11
Joomla! 1.5 / non visualizza il template
« il: 19 Gen 2009, 22:47:41 »
salve sono nuovo di post e chiedo un piccolo aiutino, ho creato un template col vostro manuale facendo tutto come era scritto, alla fine ho publicato il template sul mio spazio web, si installa correttamente ma mi succede una cosa strana forse per voi banale dopo averlo installato vado per impostarlo come default ma nella lista dei template non si vede. bah ho riprovato e riprovato ma non so dove sbaglio, aiutatemi per favore grazie.
12
Gestione e-commerce / Re: mercatino con vm
« il: 16 Nov 2007, 00:06:34 »
voglio solo sapere se con joomla si può creare un mercatino fra urenti tutto quì..se qualcuno mi può dare un suggerimento ne sarò molto grato grazie!
13
Gestione e-commerce / mercatino con vm
« il: 15 Nov 2007, 03:35:41 »
prima di tutto un saluto al forum con tutti i miei complimenti e vengo subito al dunque gestisco un sito per una piccola comunità italiana e volevo chiedervi se con virtuemart si poteva creare un piccolo mercatino tra utenti registrati tipo compra e vendi se sì se potete spiegarmi come si fà oppure se esiste qualche guida per farlo non sono molto esperto in materia vi ringrazio e attendo risposta con pazienza e rispetto.
14
Sezione dedicata ai Server / problema spostamento in un altra cartella
« il: 23 Set 2007, 16:31:01 »
ciao ho un problema ammetto di nn essere molto essperto sul campo cmq vengo al dunque ho introdotto un intro in flash e ho spostato tutto il sito in un altra cartella chiamata dall'ndex dell'intro e mi da questo errore che devo fare?
Warning: main() [function.main]: Unable to access /var/www/netsons.org/peopleitalynet/includes/version.php in /var/www/netsons.org/peopleitalynet/peopleitalynet/includes/joomla.php on line 71
Warning: main(/var/www/netsons.org/peopleitalynet/includes/version.php) [function.main]: failed to open stream: No such file or directory in /var/www/netsons.org/peopleitalynet/peopleitalynet/includes/joomla.php on line 71
Fatal error: main() [function.require]: Failed opening required '/var/www/netsons.org/peopleitalynet/includes/version.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/netsons.org/peopleitalynet/peopleitalynet/includes/joomla.php on line 71
Warning: main() [function.main]: Unable to access /var/www/netsons.org/peopleitalynet/includes/version.php in /var/www/netsons.org/peopleitalynet/peopleitalynet/includes/joomla.php on line 71
Warning: main(/var/www/netsons.org/peopleitalynet/includes/version.php) [function.main]: failed to open stream: No such file or directory in /var/www/netsons.org/peopleitalynet/peopleitalynet/includes/joomla.php on line 71
Fatal error: main() [function.require]: Failed opening required '/var/www/netsons.org/peopleitalynet/includes/version.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/netsons.org/peopleitalynet/peopleitalynet/includes/joomla.php on line 71
15
Sezione dedicata ai Server / aiuto problrma template amministrazione
« il: 21 Set 2007, 14:19:36 »
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 :-)
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 :-)
16
Sezione dedicata ai Server / aiuto problema template amministrazione
« il: 21 Set 2007, 12:39:28 »
HO JOOMLA ULTIMA VERSIONE 1.0.3 HO INSTALLATO UN TEMPLATE PER LA PARTE ADMIN MA PRIMA DI FARLO HO FATTO IL BECKUP DEL DATABASE DOPO DI QUESTO HO PROCEDUTO ALL'INSTALLAZIONE DEL TEMPLATE MA MI è SUCCESSO UN CASINO MI DAVA DELLE SCRITTE SU TUTTA LA PAGINA E HO DOVUTO ELIMINARE TUTTO IL DATA BASE E ADESSO HO UN ALTRO PROBLEMA NN RIESCO A RIPRISTINARLO MI DA QUESTO ERRORE
Errore
query SQL:
-- phpMyAdmin SQL Dump
-- version
-- http://www.phpmyadmin.net
--
-- Host: mysql4.netsons.org
-- Generato il: 20 Set, 2007 at 10:09 PM
-- Versione MySQL: 4.1.22
-- Versione PHP: 4.4.4-8+etch4
--
-- DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Struttura della tabella `cpg1411_albums`
--
CREATE TABLE `cpg1411_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) TYPE = MYISAM AUTO_INCREMENT =4 COMMENT = 'Used to store albums' AUTO_INCREMENT =4;
Messaggio di MySQL:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
CREATE TABLE `cpg1411_albums` (
`aid` int(11) NOT NULL auto_increment,
' at line 1
Errore
query SQL:
-- phpMyAdmin SQL Dump
-- version
-- http://www.phpmyadmin.net
--
-- Host: mysql4.netsons.org
-- Generato il: 20 Set, 2007 at 10:09 PM
-- Versione MySQL: 4.1.22
-- Versione PHP: 4.4.4-8+etch4
--
-- DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Struttura della tabella `cpg1411_albums`
--
CREATE TABLE `cpg1411_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) TYPE = MYISAM AUTO_INCREMENT =4 COMMENT = 'Used to store albums' AUTO_INCREMENT =4;
Messaggio di MySQL:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
CREATE TABLE `cpg1411_albums` (
`aid` int(11) NOT NULL auto_increment,
' at line 1
Pagine: [1]
|
|