Changeset 3464
- Timestamp:
- Jun 26, 2009, 11:57:28 AM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/db/83-database.php
r3459 r3464 30 30 31 31 $query = ' 32 UPDATE '.COMMENTS_TABLE.' AS c , '.USERS_TABLE.' AS u 32 UPDATE 33 '.COMMENTS_TABLE.' AS c , 34 '.USERS_TABLE.' AS u, 35 '.USER_INFOS_TABLE.' AS i 33 36 SET c.author_id = u.'.$conf['user_fields']['id'].' 34 WHERE c.author = u.'.$conf['user_fields']['username'].' AND c.author_id is null 37 WHERE 38 c.author_id is null 39 AND c.author = u.'.$conf['user_fields']['username'].' 40 AND u.'.$conf['user_fields']['id'].' = i.user_id 41 AND i.registration_date <= c.date 35 42 ;'; 36 43
Note: See TracChangeset
for help on using the changeset viewer.