| Index: trunk/phpwiki/fpw/special_recentchanges.php |
| — | — | @@ -68,10 +68,10 @@ |
| 69 | 69 | # the SQL query that retrieves all information |
| 70 | 70 | $sql = "SELECT cur_timestamp, cur_title, cur_comment, cur_user, |
| 71 | 71 | cur_user_text, cur_minor_edit, |
| 72 | | - COUNT(old_id) + (IF(cur_old_version = 0,0,1)) AS changes |
| | 72 | + COUNT(old_id) + (IF(cur_minor_edit = 2,0,1)) AS changes |
| 73 | 73 | FROM cur LEFT OUTER JOIN old ON cur_title = old_title |
| 74 | 74 | AND old_timestamp > SUBDATE(CURRENT_TIMESTAMP, INTERVAL $daysAgo DAY) |
| 75 | | - AND old_old_version <> 0 |
| | 75 | + AND old_minor_edit <> 2 |
| 76 | 76 | $fromCondOld |
| 77 | 77 | WHERE cur_timestamp > SUBDATE(CURRENT_TIMESTAMP, INTERVAL $daysAgo DAY) |
| 78 | 78 | $fromCondCur |
| — | — | @@ -121,10 +121,10 @@ |
| 122 | 122 | FROM old AS o1, old AS o2 |
| 123 | 123 | WHERE o1.old_title = o2.old_title |
| 124 | 124 | AND o2.old_timestamp > SUBDATE(CURRENT_TIMESTAMP, INTERVAL $daysAgo DAY) |
| 125 | | - AND o2.old_old_version <> 0 AND o2.old_minor_edit != 1 |
| | 125 | + AND o2.old_minor_edit = 0 |
| 126 | 126 | $fromCondOld2 |
| 127 | 127 | AND o1.old_timestamp > SUBDATE(CURRENT_TIMESTAMP, INTERVAL $daysAgo DAY) |
| 128 | | - AND o1.old_minor_edit != 1 |
| | 128 | + AND o1.old_minor_edit = 0 |
| 129 | 129 | $fromCondOld1 |
| 130 | 130 | GROUP BY o1.old_title, o1.old_timestamp |
| 131 | 131 | HAVING cur_timestamp = MAX(o2.old_timestamp) |