Changeset 6213 for extensions
- Timestamp:
- May 17, 2010, 10:10:09 PM (14 years ago)
- Location:
- extensions/GrumPluginClasses
- Files:
-
- 1 added
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/GrumPluginClasses/classes/GPCRequestBuilder.class.inc.php
r6208 r6213 164 164 * @return Boolean : true if registering is Ok, otherwise false 165 165 */ 166 static public function register($pluginName, $fileName , $dialogBoxObject)166 static public function register($pluginName, $fileName) 167 167 { 168 168 $config=Array(); … … 172 172 'name' => $pluginName, 173 173 'fileName' => $fileName, 174 'dialogBox' => $dialogBoxObject,175 174 'date' => date("Y-m-d H:i:s"), 176 175 'version' => self::$version, … … 400 399 $tmpBuild=Array( 401 400 'FROM' => Array( 402 '('.IMAGES_TABLE.' pit LEFT JOIN '.IMAGE_CATEGORY_TABLE.' pic ON pit.id = pic.image_id)', //JOIN IMAGES & IMAGE_CATEGORY tables 401 '('.IMAGES_TABLE.' pit LEFT JOIN '.IMAGE_CATEGORY_TABLE.' pic ON pit.id = pic.image_id)' /*JOIN IMAGES & IMAGE_CATEGORY tables*/ 402 .' JOIN '.USER_CACHE_CATEGORIES_TABLE.' pucc ON pucc.cat_id=pic.category_id', /* IMAGE_CATEGORY & USER_CACHE_CATEGORIES_TABLE tables*/ 403 403 404 ), 404 405 'WHERE' => Array(), 405 'JOIN' => Array( ),406 'JOIN' => Array(999=>'pucc.user_id='.$user['id']), 406 407 'GROUPBY' => Array( 407 408 'pit.id' … … 464 465 unset($tmpBuild['FROM']); 465 466 466 467 467 /* build WHERE 468 468 */ … … 532 532 static private function getPage($requestNumber, $pageNumber, $numPerPage) 533 533 { 534 global $conf ;534 global $conf, $user; 535 535 $request=self::getRequest($requestNumber); 536 536 … … 561 561 'FROM' => Array( 562 562 // join rb result_cache table with piwigo's images table, joined with the piwigo's image_category table, joined with the categories table 563 'RB' => "(( ".self::$tables['result_cache']." pgrc563 'RB' => "(((".self::$tables['result_cache']." pgrc 564 564 RIGHT JOIN ".IMAGES_TABLE." pit 565 565 ON pgrc.image_id = pit.id) 566 566 RIGHT JOIN ".IMAGE_CATEGORY_TABLE." pic 567 567 ON pit.id = pic.image_id) 568 RIGHT JOIN piwigo_categories pct 569 ON pct.id = pic.category_id ", 568 RIGHT JOIN ".CATEGORIES_TABLE." pct 569 ON pct.id = pic.category_id) 570 RIGHT JOIN ".USER_CACHE_CATEGORIES_TABLE." pucc 571 ON pucc.cat_id = pic.category_id", 570 572 ), 571 573 'WHERE' => Array( 572 'RB' => "pgrc.id=".$requestNumber ,574 'RB' => "pgrc.id=".$requestNumber." AND pucc.user_id=".$user['id'], 573 575 ), 574 576 'JOIN' => Array(),
Note: See TracChangeset
for help on using the changeset viewer.