1. <?
2.                  /**
3.          * This method checks whether the number of rows in the devlog table exceeds the limit
4.          * If yes, 10% of that amount is deleted, with older records going first
5.          *
6.          * @return      void
7.          */
8.         function checkRowLimit() {
9.                         // Get the total number of rows, if not already defined
10.                 if (!isset($this->numRows)) {
11.                         $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('COUNT(uid)', 'tx_devlog', '');
12.                         $result = $GLOBALS['TYPO3_DB']->sql_fetch_row($res);
13.                         $this->numRows = $result[0];
14.                         $GLOBALS['TYPO3_DB']->sql_free_result($res);
15.                 }
16.                         // Check if number of rows is above the limit and clean up if necessary
17.                 if ($this->numRows > $this->extConf['maxRows']) {
18.                                 // Select the row from which to start cleaning up
19.                                 // To achieve this, order by creation date (so oldest come first)
20.                                 // then offset by 10% of maxRows and get the next record
21.                                 // This will return a timestamp that is used as a cut-off date
22.                         $numRowsToRemove = round(0.1 * $this->extConf['maxRows']);
23.                         $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('crdate', 'tx_devlog', '', '', 'crdate', $numRowsToRemove.',1');
24.                         $result = $GLOBALS['TYPO3_DB']->sql_fetch_row($res);
25.                         $crdate = $result[0];
26.                         $GLOBALS['TYPO3_DB']->sql_free_result($res);
27.                                 // Delete all rows older or same age as previously found timestamp
28.                                 // This will problably delete a bit more than 10% of maxRows, but will at least
29.                                 // delete complete log runs
30.                         $GLOBALS['TYPO3_DB']->exec_DELETEquery('tx_devlog', "crdate <= '".$crdate."'");
31.                         $numRemovedRows = $GLOBALS['TYPO3_DB']->sql_affected_rows();
32.                                 // Update (cached) number of rows
33.                         $this->numRows -= $numRemovedRows;
34.                                 // Optimize the table (if option is active)
35.                         if ($this->extConf['optimize']) {
36.                                 $GLOBALS['TYPO3_DB']->sql_query('OPTIMIZE table tx_devlog');
37.                         }
38.                 }
39.         }
40. }
41. ?>
42.