emlog官方缓存类统计代码-站长杂谈下载

emlog官方缓存类统计代码

开通本站Svip会员,全站资源免费下
先说调用代码:<?php $sta_cache = Cache::getInstance()->readCache('sta');?>5 \$ M* X! A! ^$ p9 e
<?php echo $sta_cache['内容'];?>
( O$ _8 g" i7 i% H例如调用日志数量- A* @) X0 d7 i8 V
<?php echo $sta_cache['lognum'];?>1 |1 d. s4 q% Q1 P. K5 ?
注意了这里的日志数量是前台显示出来的日志数量,未包含未审核以及隐藏的文章数量。1 T* \) \( N+ v- B# ^+ D$ g8 R
lognum 游客可见日志总数" ~0 H  Y9 F. o  C+ W/ @% e
draftnum  草稿,也就是隐藏文件数量# {- e2 r5 s9 O& |' i2 y& T7 a8 M" ?
comnum  未隐藏的评论数量
) u. T1 u) f. n( j+ E3 ]# O0 B: C; xcomnum_all  所有评论数量/ P0 j- O/ J! M! r# k
hidecomnum  被隐藏的评论数量
. _$ o! {2 S# W) ?0 D+ }+ Q" ytwnum  微语数量6 E! C  y: E7 W3 c* @- Q
checknum 未审核的文章数量
( F5 @1 R# X3 B0 k3 W% _, \8 S
" V, g) f% V5 g2 ?- s0 g$ W

博客访问次数:

2014-8-13更新,来源于em论坛,缺点加载比较慢,把下面代码放入到模板module.php文件中
  1. <?php
    * I, I' B& e; J  e! k' j: e# S
  2. //统计文章总数1 x8 N. i: }$ V* ~3 F6 b. i% Z
  3. function count_log_all(){
    / M3 Q2 H; \' h" ?# K* O
  4. $db = MySql::getInstance();
    8 w( {6 `# h/ {) z  F: a
  5. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE type = 'blog'");
    - p, |9 q7 E1 H+ S; X( Z& _+ {
  6. return $data['total'];5 s( v# ^2 R! n( b/ V# j) o
  7. }! w4 q! ^4 j6 X8 |+ Q( h% z$ r
  8. //置顶文章数% e3 K" w$ P2 M
  9. function count_log_top(){
    , K# D2 k0 l) H3 h& j! C% X
  10. $db = MySql::getInstance();/ {" u  k- a( {# x% \; _6 u
  11. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE  top = 'y' or sortop = 'y' AND type = 'blog'");; H$ f! x) k5 J8 D( ?
  12. return $data['total'];
    2 f; M" g6 i% x- v* y+ w/ m2 O
  13. }1 g4 @5 x+ @# }* [( |
  14. //隐藏文章数
    9 N4 n9 x* n! d8 n" u0 f* b
  15. function count_log_hide(){+ G" I, n$ \" Z6 J: x6 L
  16. $db = MySql::getInstance();
    ' j2 f  `8 J* G- }6 _. J5 I
  17. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE hide = 'y' AND type = 'blog'");
    4 n" A/ P5 R8 B1 _  R# ]
  18. return $data['total'];
    3 m- W! c; w; ?
  19. }
    + o7 e& _3 r8 q% P" t0 |3 v
  20. 9 x8 f$ n8 J7 \1 z3 L' m
  21. //未审核文章数
    . g$ c* c% }$ G- }/ A3 r
  22. function count_log_check(){
    8 U- Q- ]' g- T" G7 P" U' T
  23. $db = MySql::getInstance();& j4 M/ ?- @. G1 {
  24. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE checked = 'n' AND type = 'blog'");" k4 e, }0 u+ S3 [) r( O
  25. return $data['total'];
    6 k: X6 ?. e& n5 z0 P; ]1 J2 B4 h
  26. }: W0 |4 o5 N# Q7 V8 e% O
  27. //加密文章数
    % G7 k& [( i7 y5 N7 w( u& s2 L
  28. function count_log_pass(){
    7 r- J! d: k/ K$ R- V0 F& a. K0 x% b
  29. $db = MySql::getInstance();, a( r  g' v) \* x
  30. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE  password !='' AND type = 'blog'");/ r' l4 I$ \; e+ e
  31. return $data['total'];
    * Q9 r: ^5 \4 g
  32. }
    + v& m$ w& m- B! J6 i

  33. 5 J! ]' O2 M, A3 k& t
  34. //统计页面总数& d0 Y) d7 A8 r3 Z/ a6 v) w9 h3 f
  35. function count_page_all(){% S0 [# l9 m3 E+ @  O- p
  36. $db = MySql::getInstance();# B/ B! K' @7 m1 s/ {
  37. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE type = 'page'");
    / P# G6 Q, V% A6 @
  38. return $data['total'];* C7 U' m4 w8 I. E9 [5 s
  39. }
      k& P% [& {* R7 P& W: f4 G5 X2 [

  40. - z) f4 Y0 W2 A1 g# r$ l
  41. //统计评论总数
    . Q! s( G; y3 u
  42. function count_com_all(){' C* j2 z" ]& f% W& k
  43. $db = MySql::getInstance();
    , q$ ]5 \7 r' o8 Z7 I3 @0 j3 x- K
  44. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "comment");
    , l4 M" g1 m5 ~6 `
  45. return $data['total'];
    ' e) ?- @# R: C3 E8 p
  46. }
    & W, F0 e0 t8 X0 s
  47. //统计友链总数$ g0 A7 T7 o% o  L
  48. function count_link_all(){$ u- V5 t! ]- i
  49. $db = MySql::getInstance();
    1 n& |" q* d- M5 W# x
  50. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "link");( @4 h7 f( v7 S$ x* j: Y2 A
  51. return $data['total'];9 Z+ R( @- X- f8 |1 m
  52. }
    2 T' j1 h$ [  a$ F; U" O* E6 o
  53. " T* u! A8 E  U- |
  54. //统计微语评论总数. Z. v7 ]! I& i$ i! K+ X/ |
  55. function count_treply_all(){# Q- P  T6 [& R% I3 b3 M! b( O
  56. $db = MySql::getInstance();) q; x; y+ r; `0 l- e4 i# Z; _, c
  57. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "reply");/ x( ~/ p% @* H$ n2 j  M& i
  58. return $data['total'];* N1 [* I9 c5 D" m' A: ]5 f
  59. }
    # m" N4 b# @3 B% ~
  60. //统计分类总数7 G% J  w4 _4 [
  61. function count_sort_all(){# g- S: X/ B& A' p: S
  62. $db = MySql::getInstance();' e* i) @* E! I0 L
  63. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "sort");/ X3 L, K. i: c% R/ T) y
  64. return $data['total'];1 X1 D4 Q+ J& ~+ o
  65. }
    4 n) [" \* e# c1 K
  66. //统计子分类数9 G& L2 ?+ ?7 C
  67. function count_sort_mod(){
    2 Z# d8 [- E  m
  68. $db = MySql::getInstance();
    8 ~% K$ |" T- ~: p+ ^
  69. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "sort WHERE pid != 0");
    5 I( y, _2 `' j. j4 x
  70. return $data['total'];
    1 u% z/ F4 |- E
  71. }
    ( k/ Y) `, \+ y( [; @; S

  72. # t! r4 e, {2 }) S3 ^$ p* Q
  73. //统计TAG.html" target="_blank" class="relatedlink">标签总数
    6 D! v) U8 z, q3 H
  74. function count_tag_all(){
    - `9 G! e% ^1 K" d
  75. $db = MySql::getInstance();, `' V! Y/ Y0 n, p* a
  76. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "tag");
      `8 s5 e) b# S! |- U7 E( l
  77. return $data['total'];
    $ v0 H7 d# R! [7 v5 g' x
  78. }
    # _( w% q0 |0 N. T% ~8 y
  79. //统计微语总数/ w& C6 u0 v+ t& n5 R* z3 M
  80. function count_tw_all(){+ v+ T: u; \' }4 _$ ^5 e5 E/ p. ]
  81. $db = MySql::getInstance();
    " @& `8 `. u9 \' l% M0 h9 T3 T5 V
  82. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "twitter");
      h% q& _2 ~& O- j9 J# k
  83. return $data['total'];
    & r% z1 z! u# `1 k. W
  84. }
    4 L! j' }1 U% Y9 o: w

  85. 4 O4 [- l( T3 W. v) T; [  @! m
  86. //统计用户总数3 d; Q7 s+ \. [) D* d6 N
  87. function count_user_all(){
    / x" f. y2 j6 Y, [8 ]
  88. $db = MySql::getInstance();
    / Q1 i2 R5 Y7 L3 U' s0 y; u3 q
  89. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user");
    9 b9 Z0 y5 |6 \6 n7 O' L
  90. return $data['total'];
    0 ^/ I: M+ A' J& Q
  91. }
    & ?( s9 Q- e) N+ b5 a& L

  92. $ x: H% g' b) b
  93. //统计管理员总数
    & e7 A3 z* E9 n( t, L; m
  94. function count_user_admin(){
    & Z: Q1 @% \6 k! r: w
  95. $db = MySql::getInstance();5 @  X# @' `$ f. s' g5 q! f& ]
  96. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user WHERE role = 'admin'");0 V2 t: E& V! p9 s- }5 W
  97. return $data['total'];" u6 k9 e$ w, q$ s( k
  98. }4 h" S0 V' W9 Z

  99. * q; s& [9 B* L3 h9 R
  100. //统计作者总数2 ]/ `6 V  k' J  N7 {
  101. function count_user_writer(){
    ) \1 D8 A% h: H1 Z
  102. $db = MySql::getInstance();
    6 V% d1 P" m( R! }
  103. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user WHERE role = 'writer'");
    0 {0 i; O! S0 Q6 U
  104. return $data['total'];0 w, C7 ]5 a2 ^6 f
  105. }
    / y  }8 @6 I' j% L: S
  106. //统计附件总数  }8 c4 m/ a; K- Q) A
  107. function count_att_all(){
    ; o. U# r: G4 M8 Y3 w+ D6 z; n5 q" ]
  108. $db = MySql::getInstance();
    & h  }- \' {6 q, \; b
  109. $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "attachment");; s- _2 _) x$ S2 f
  110. return $data['total'];
    6 f2 a* s. ^4 b* k# B
  111. }; _! ]5 b+ H7 v4 g

  112. 7 \0 S9 P( [1 N+ A5 q. }9 w+ h
  113. //最后发表文章时间 function last_post_log(){. _" ?7 t& g8 O) t
  114. $db = MySql::getInstance();
    0 q" T5 [3 }. `+ C3 s5 X- N
  115. $sql = "SELECT * FROM " . DB_PREFIX . "blog WHERE type='blog' ORDER BY date DESC LIMIT 0,1";, s& K6 v3 [. x5 a. W3 I! h
  116. $res = $db->query($sql);
    # E" L( u! _* L0 t" r# \- p% l$ t% H# @
  117. $row = $db->fetch_array($res);
    7 a1 }1 [% B- Q7 T& R4 n5 w. g
  118. $date = date('Y-n-j H:i',$row['date']);
    6 c1 P3 o# z3 W8 K- e$ B
  119. return $date;      
    : Z1 K' }4 o, z3 q9 w' p, N* [
  120. };?>
复制代码
在对应的位置插入<?php echo count_link_all();?>其中count_link_all()代表友链数量
: P/ n& E3 d) T/ |0 A% S" T

全部评论 0

您需要登录后才可以回帖 立即登录
登录
0
0
0
返回顶部