Changeset 6464
- Timestamp:
- Jun 4, 2010, 9:39:02 PM (14 years ago)
- Location:
- branches/2.1
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.1/admin/stats.php
r6364 r6464 117 117 SELECT 118 118 date, 119 HOUR(time) AS hour,119 hour(time) AS hour, 120 120 MAX(id) AS max_id, 121 121 COUNT(*) AS nb_pages … … 123 123 WHERE summarized = \'false\' 124 124 GROUP BY 125 date, 126 hour 127 ORDER BY 125 128 date ASC, 126 HOUR(time)ASC129 hour ASC 127 130 ;'; 128 131 $result = pwg_query($query); -
branches/2.1/include/dblayer/functions_pdo-sqlite.inc.php
r6342 r6464 47 47 48 48 $link->sqliteCreateFunction('now', 'pwg_now', 0); 49 $link->sqliteCreateFunction('hour', 'pwg_hour', 1); 49 50 $link->sqliteCreateFunction('unix_timestamp', 'pwg_unix_timestamp', 0); 50 51 $link->sqliteCreateFunction('md5', 'md5', 1); … … 571 572 } 572 573 574 function pwg_hour($datetime) 575 { 576 return strftime('%H', $datetime); 577 } 578 573 579 function pwg_unix_timestamp() 574 580 { -
branches/2.1/include/dblayer/functions_sqlite.inc.php
r6342 r6464 56 56 57 57 $link->createFunction('now', 'pwg_now', 0); 58 $link->createFunction('hour', 'pwg_hour', 1); 58 59 $link->createFunction('unix_timestamp', 'pwg_unix_timestamp', 0); 59 60 $link->createFunction('md5', 'md5', 1); … … 583 584 } 584 585 586 function pwg_hour($datetime) 587 { 588 return strftime('%H', $datetime); 589 } 590 585 591 function pwg_unix_timestamp() 586 592 {
Note: See TracChangeset
for help on using the changeset viewer.