Dedecms common Statistics Code

Dedecms common Statistics Code

· A total of articles: **
{Dede: SQL = "select count (*) as c from dedede_archives where channel = 1"}. Articles in total: [field: c/] {/dede: SQL}
· A total of Atlas: **
{Dede: SQL = "select count (*) as c from dedede_archives where channel = 2"} · total Gallery: [field: c/] {/dede: SQL}
· A total of software: **
{Dede: SQL = "select count (*) as c from dedede_archives where channel = 3"} a total of software: [field: c/] {/dede: SQL}
· Comments: **
{Dede: SQL = "select count (*) as c from dede_feedback"}. Comments: [field: c/] {/dede: SQL}
· Total members: ** name
{Dede: SQL = "select count (mid) as c from dedede_member"}. Common member: [field: c/] name {/dede: SQL}
· Article reading: ** number of people
{Dede: SQL = "select sum (click) as c from dedede_archives"} reading: [field: c/] count {/dede: SQL}
· Updated today: **
{Dede: SQL = "SELECT count (*) AS c FROM dede_archives WHERE pubdate> UNIX_TIMESTAMP (CURDATE ()"} updated today: [field: c/] {/dede: SQL}
Total messages: {dede: SQL = "select count (*) as cc From dede_guestbook"} [field: cc/] {/dede: SQL}

I want you to calculate the data in dedecms, and the information will be much more N.