update_analytics.php 798 B

1234567891011121314151617181920212223
  1. <?php
  2. /*
  3. 统计三十天内的逐词译创建与更新
  4. */
  5. require_once "../config.php";
  6. require_once "../public/_pdo.php";
  7. require_once '../public/load_lang.php';
  8. require_once '../public/function.php';
  9. global $PDO;
  10. PDO_Connect(_FILE_DB_USER_WBW_);
  11. echo "Day Index,创建,更新\n";
  12. $end = strtotime("now") * 1000;
  13. $begin = strtotime("-1 day") * 1000;
  14. for ($i = 0; $i < 30; $i++) {
  15. $create = 0;
  16. $query = "SELECT count(*) from "._TABLE_USER_WBW_." where \"modify_time\" > " . $PDO->quote($begin) . " AND \"modify_time\" < " . $PDO->quote($end) . " AND owner = " . $PDO->quote($_COOKIE["username"]);
  17. $modify = PDO_FetchOne($query);
  18. echo date("m/d/Y", $begin / 1000) . ',' . $create . "," . $modify . "\n";
  19. $end = $begin;
  20. $begin = strtotime("-1 day", $end / 1000) * 1000;
  21. }