Changeset 26759
- Timestamp:
- Jan 15, 2014, 9:00:38 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/comments.php
r26461 r26759 373 373 } 374 374 375 $query = '376 SELECT COUNT(DISTINCT(com.id))377 FROM '.IMAGE_CATEGORY_TABLE.' AS ic378 INNER JOIN '.COMMENTS_TABLE.' AS com379 ON ic.image_id = com.image_id380 LEFT JOIN '.USERS_TABLE.' As u381 ON u.'.$conf['user_fields']['id'].' = com.author_id382 WHERE '.implode('383 AND ', $page['where_clauses']).'384 ;';385 list($counter) = pwg_db_fetch_row(pwg_query($query));386 387 $url = PHPWG_ROOT_PATH.'comments.php'388 .get_query_string_diff(array('start','edit','delete','validate','pwg_token'));389 390 $navbar = create_navigation_bar($url,391 $counter,392 $start,393 $page['items_number'],394 '');395 396 $template->assign('navbar', $navbar);397 398 375 // +-----------------------------------------------------------------------+ 399 376 // | last comments display | … … 405 382 406 383 $query = ' 407 SELECT com.id AS comment_id,384 SELECT SQL_CALC_FOUND_ROWS com.id AS comment_id, 408 385 com.image_id, 409 386 com.author, … … 422 399 WHERE '.implode(' 423 400 AND ', $page['where_clauses']).' 424 GROUP BY comment_id, 425 com.image_id, 426 com.author, 427 com.author_id, 428 com.date, 429 com.content, 430 com.validated 401 GROUP BY comment_id 431 402 ORDER BY '.$page['sort_by'].' '.$page['sort_order']; 432 403 if ('all' != $page['items_number']) … … 443 414 $element_ids[] = $row['image_id']; 444 415 } 416 list($counter) = pwg_db_fetch_row(pwg_query('SELECT FOUND_ROWS()')); 417 418 $url = PHPWG_ROOT_PATH.'comments.php' 419 .get_query_string_diff(array('start','edit','delete','validate','pwg_token')); 420 421 $navbar = create_navigation_bar($url, 422 $counter, 423 $start, 424 $page['items_number'], 425 ''); 426 427 $template->assign('navbar', $navbar); 428 445 429 446 430 if (count($comments) > 0)
Note: See TracChangeset
for help on using the changeset viewer.