Changeset 11893 for trunk/include/ws_functions.inc.php
- Timestamp:
- Aug 2, 2011, 9:20:50 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/ws_functions.inc.php
r11827 r11893 55 55 if ( is_numeric($params['f_min_rate']) ) 56 56 { 57 $clauses[] = $tbl_name.' average_rate>'.$params['f_min_rate'];57 $clauses[] = $tbl_name.'rating_score>'.$params['f_min_rate']; 58 58 } 59 59 if ( is_numeric($params['f_max_rate']) ) 60 60 { 61 $clauses[] = $tbl_name.' average_rate<='.$params['f_max_rate'];61 $clauses[] = $tbl_name.'rating_score<='.$params['f_max_rate']; 62 62 } 63 63 if ( is_numeric($params['f_min_hit']) ) … … 124 124 $matches[1][$i] = DB_RANDOM_FUNCTION.'()'; break; 125 125 } 126 $sortable_fields = array('id', 'file', 'name', 'hit', ' average_rate',126 $sortable_fields = array('id', 'file', 'name', 'hit', 'rating_score', 127 127 'date_creation', 'date_available', DB_RANDOM_FUNCTION.'()' ); 128 128 if ( in_array($matches[1][$i], $sortable_fields) ) … … 193 193 194 194 $infos['version'] = PHPWG_VERSION; 195 195 196 196 $query = 'SELECT COUNT(*) FROM '.IMAGES_TABLE.';'; 197 197 list($infos['nb_elements']) = pwg_db_fetch_row(pwg_query($query)); … … 444 444 // which is an element in the XML output. The "hierarchy" output is 445 445 // only compatible with json/php output. 446 446 447 447 return new PwgError(405, "The tree_output option is only compatible with json/php output formats"); 448 448 } … … 472 472 $where[] = 'status = "public"'; 473 473 $where[] = 'visible = "true"'; 474 474 475 475 $join_user = $conf['guest_id']; 476 476 } … … 480 480 // categories. Function calculate_permissions will only return 481 481 // categories that are either locked or private and not permitted 482 // 482 // 483 483 // calculate_permissions does not consider empty categories as forbidden 484 484 $forbidden_categories = calculate_permissions($user['id'], $user['status']); … … 519 519 ) 520 520 ); 521 521 522 522 $row['comment'] = strip_tags( 523 523 trigger_event( … … 527 527 ) 528 528 ); 529 529 530 530 array_push($cats, $row); 531 531 } … … 533 533 534 534 if ($params['tree_output']) 535 { 535 { 536 536 return categories_flatlist_to_tree($cats); 537 537 } … … 782 782 } 783 783 //------------------------------------------------------------- related rates 784 $rating = array('score'=>$image_row[' average_rate'], 'count'=>0, 'average'=>null);784 $rating = array('score'=>$image_row['rating_score'], 'count'=>0, 'average'=>null); 785 785 if (isset($rating['score'])) 786 786 { … … 1029 1029 return new PwgError(401, 'Access denied'); 1030 1030 } 1031 1031 1032 1032 if (!$service->isPost()) 1033 1033 { … … 1055 1055 return new PwgError(WS_ERR_INVALID_PARAM, "Invalid rank"); 1056 1056 } 1057 1057 1058 1058 // does the image really exist? 1059 1059 $query=' … … 1069 1069 return new PwgError(404, "image_id not found"); 1070 1070 } 1071 1071 1072 1072 // is the image associated to this category? 1073 1073 $query = ' … … 1138 1138 { 1139 1139 global $conf; 1140 1140 1141 1141 ws_logfile('[ws_images_add_chunk] welcome'); 1142 1142 // data … … 1159 1159 continue; 1160 1160 } 1161 1161 1162 1162 ws_logfile( 1163 1163 sprintf( … … 1219 1219 { 1220 1220 global $conf; 1221 1221 1222 1222 ws_logfile('[merge_chunks] input parameter $output_filepath : '.$output_filepath); 1223 1223 … … 1287 1287 { 1288 1288 include_once(PHPWG_ROOT_PATH.'admin/include/functions_upload.inc.php'); 1289 1289 1290 1290 $file_path = file_path_for_type($file_path, $type); 1291 1291 … … 1298 1298 ws_logfile('[add_file] file_path : '.$file_path); 1299 1299 ws_logfile('[add_file] upload_dir : '.$upload_dir); 1300 1300 1301 1301 if (!is_dir($upload_dir)) { 1302 1302 umask(0000); … … 1446 1446 $where_clause = "file = '".$params['original_filename']."'"; 1447 1447 } 1448 1448 1449 1449 $query = ' 1450 1450 SELECT … … 1550 1550 require_once(PHPWG_ROOT_PATH.'admin/include/functions_metadata.php'); 1551 1551 update_metadata(array($image_id=>$file_path)); 1552 1552 1553 1553 invalidate_user_cache(); 1554 1554 } … … 1571 1571 return new PwgError(405, "The image (file) parameter is missing"); 1572 1572 } 1573 1573 1574 1574 $params['image_id'] = (int)$params['image_id']; 1575 1575 if ($params['image_id'] > 0) … … 1677 1677 ;'; 1678 1678 list($file_path) = pwg_db_fetch_row(pwg_query($query)); 1679 1679 1680 1680 require_once(PHPWG_ROOT_PATH.'admin/include/functions_metadata.php'); 1681 1681 update_metadata(array($image_id=>$file_path)); … … 1732 1732 list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();')); 1733 1733 $res['current_datetime'] = $dbnow; 1734 1734 1735 1735 return $res; 1736 1736 } … … 1827 1827 1828 1828 $image_ids = array_slice($image_ids, (int)($params['per_page']*$params['page']), (int)$params['per_page'] ); 1829 1829 1830 1830 $image_tag_map = array(); 1831 1831 if ( !empty($image_ids) and !$params['tag_mode_and'] ) … … 1963 1963 { 1964 1964 global $conf; 1965 1965 1966 1966 if (!is_admin()) 1967 1967 { … … 2002 2002 } 2003 2003 } 2004 2004 2005 2005 if ('filename' == $conf['uniqueness_mode']) 2006 2006 { … … 2481 2481 { 2482 2482 global $conf; 2483 2483 2484 2484 if (!is_admin()) 2485 2485 { … … 2519 2519 return new PwgError(WS_ERR_INVALID_PARAM, "Invalid image_id"); 2520 2520 } 2521 2521 2522 2522 // does the image really exist? 2523 2523 $query=' … … 2612 2612 return; 2613 2613 } 2614 2614 2615 2615 include_once(PHPWG_ROOT_PATH.'admin/include/functions.php'); 2616 2616 delete_categories($category_ids, $params['photo_deletion_mode']); … … 2621 2621 { 2622 2622 global $conf, $page; 2623 2623 2624 2624 if (!is_admin()) 2625 2625 { … … 2661 2661 // we can't move physical categories 2662 2662 $categories_in_db = array(); 2663 2663 2664 2664 $query = ' 2665 2665 SELECT … … 2684 2684 ) 2685 2685 ); 2686 2686 2687 2687 return new PwgError( 2688 2688 403, … … 2699 2699 { 2700 2700 $unknown_category_ids = array_diff($category_ids, array_keys($categories_in_db)); 2701 2701 2702 2702 return new PwgError( 2703 2703 403, … … 2717 2717 return new PwgError(403, 'Invalid parent input parameter'); 2718 2718 } 2719 2719 2720 2720 if (0 != $params['parent']) { 2721 2721 $params['parent'] = intval($params['parent']); … … 2766 2766 $ret['message'] = ready_for_upload_message(); 2767 2767 $ret['ready_for_upload'] = true; 2768 2768 2769 2769 if (!empty($ret['message'])) 2770 2770 { 2771 2771 $ret['ready_for_upload'] = false; 2772 2772 } 2773 2773 2774 2774 return $ret; 2775 2775 } … … 2778 2778 { 2779 2779 global $conf; 2780 2780 2781 2781 if (!is_admin()) 2782 2782 { … … 2818 2818 { 2819 2819 global $template; 2820 2820 2821 2821 if (!is_admin()) 2822 2822 { … … 2834 2834 $errors = $plugins->perform_action($params['action'], $params['plugin']); 2835 2835 2836 2836 2837 2837 if (!empty($errors)) 2838 2838 { … … 2852 2852 { 2853 2853 global $template; 2854 2854 2855 2855 if (!is_admin()) 2856 2856 { … … 2867 2867 $themes = new themes(); 2868 2868 $errors = $themes->perform_action($params['action'], $params['theme']); 2869 2869 2870 2870 if (!empty($errors)) 2871 2871 { … … 3045 3045 ); 3046 3046 } 3047 3047 3048 3048 $upgrade_status = $extension->extract_plugin_files('upgrade', $revision, $extension_id); 3049 3049 $extension_name = $extension->fs_plugins[$extension_id]['name'];
Note: See TracChangeset
for help on using the changeset viewer.