Statistik 24.06.2011, 17:07

Social

Übersicht:

{exp:stats cache="yes" channel="lehrerfreund" refresh="60" status="open" show_pages="no"}

0 Artikel
0 Kommentare (letzter Kommentar am {last_comment_date format="%d.%m.%Y, %G:%i"} verfasst)

{snp_anzahlAbonnenten} Newsletter-Abonnent/innen

Meiste gleichzeitige Besucher/innen in den letzten Wochen: {most_visitors} am {most_visitor_date format="%d.%m.%Y, %G:%i"} (letzte Besucher/in: {last_visitor_date format="%d.%m.%Y, %G:%i"})
Aktuell {total_guests} Personen online (3min Timeout)

{/exp:stats}

Meistkommentierteste Beiträge der letzten 100 Tage

    {exp:query sql="SELECT c.entry_id, c.comment_date, COUNT(c.entry_id) AS comment_count, t.url_title AS url_titel, t.title FROM exp_comments c, exp_channel_titles t WHERE c.entry_id = t.entry_id AND UNIX_TIMESTAMP() - c.comment_date <= (100*24*60*60) GROUP BY c.entry_id ORDER BY comment_count DESC, c.comment_date DESC LIMIT 10"}
  • {title} - {comment_count} Kommentar{if comment_count != 1}e{/if}
  • {/exp:query}

Kommentare pro Monat

{exp:query sql="SELECT YEAR(FROM_UNIXTIME(comment_date)) AS my_year, MONTHNAME(FROM_UNIXTIME(comment_date)) AS my_month_name, MONTH(FROM_UNIXTIME(comment_date)) AS my_month, MAX(YEAR(FROM_UNIXTIME(comment_date))) AS year_upper, MIN(YEAR(FROM_UNIXTIME(comment_date))) AS year_lower, COUNT(comment_id) AS my_count FROM exp_comments WHERE channel_id=1 GROUP BY my_year, my_month WITH ROLLUP"} {if my_month != ""} {if:elseif my_year != ""} {if:else} {/if} {/exp:query}
Anzahl Kommentare
{my_month_name} {my_year} {my_count}
Gesamt im Jahr {my_year} {my_count}
Gesamt: {year_lower} - {year_upper} {my_count}

Artikel pro Monat

{exp:query sql=" SELECT YEAR(FROM_UNIXTIME(entry_date)) AS my_year, MONTHNAME(FROM_UNIXTIME(entry_date)) AS my_month_name, MONTH(FROM_UNIXTIME(entry_date)) AS my_month, MAX(YEAR(FROM_UNIXTIME(entry_date))) AS year_upper, MIN(YEAR(FROM_UNIXTIME(entry_date))) AS year_lower, COUNT(entry_id) AS my_count FROM `exp_channel_titles` WHERE channel_id=1 AND status='open' GROUP BY my_year, my_month WITH ROLLUP"} {if my_month != ""} {if:elseif my_year != ""} {if:else} {/if} {/exp:query}
Anzahl Artikel
{my_month_name} {my_year} {my_count}
Gesamt im Jahr {my_year} {my_count}
Gesamt: {year_lower} - {year_upper} {my_count}

Anzeige
Anzeige