- Timestamp:
- 12/29/05 16:29:35 (7 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/wifidog-auth/wifidog/classes/Content/PatternLanguage/PatternLanguage.php
r874 r877 168 168 169 169 $sql = "SELECT * FROM (SELECT DISTINCT ON (content_group_element_id) content_group_element_id, first_display_timestamp FROM content_display_log AS cdl JOIN content_group_element AS cge ON (cdl.content_id = cge.content_group_element_id) JOIN content ON (content.content_id = cge.content_group_id) where user_id = '{$user->getId()}' AND cge.content_group_id = '{$this->getId()}' AND content.content_type = 'PatternLanguage') AS patterns ORDER BY first_display_timestamp"; 170 $db-> ExecSql($sql, $rows, false);170 $db->execSql($sql, $rows, false); 171 171 172 172 if ($rows) { … … 198 198 199 199 $sql = "SELECT DISTINCT user_id FROM content_display_log AS cdl JOIN content_group_element AS cge ON (cdl.content_id = cge.content_group_element_id) JOIN content ON (content.content_id = cge.content_group_id) WHERE content_type = 'PatternLanguage'"; 200 $db-> ExecSql($sql , $rows, false);200 $db->execSql($sql , $rows, false); 201 201 202 202 if ($rows) {
