diff options
author | rvelices <rv-github@modusoptimus.com> | 2011-11-14 20:10:37 +0000 |
---|---|---|
committer | rvelices <rv-github@modusoptimus.com> | 2011-11-14 20:10:37 +0000 |
commit | 2f87684e097c087b18b6630878e5545c5c37699e (patch) | |
tree | 3745a7076294bec0b339cbe5769ed9a99b95262f /include | |
parent | f59e5bf46ab8de2e54538bd43e85b33b68cc7a18 (diff) |
feature 2486: Add an admin view for rates by user
git-svn-id: http://piwigo.org/svn/trunk@12624 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r-- | include/calendar_base.class.php | 4 | ||||
-rw-r--r-- | include/ws_functions.inc.php | 39 |
2 files changed, 40 insertions, 3 deletions
diff --git a/include/calendar_base.class.php b/include/calendar_base.class.php index a64e20fe9..15f20f7f3 100644 --- a/include/calendar_base.class.php +++ b/include/calendar_base.class.php @@ -215,9 +215,7 @@ SELECT DISTINCT('.$this->calendar_levels[$level]['sql'].') as period, COUNT(DISTINCT id) as nb_images'. $this->inner_sql. $this->get_date_where($level).' - GROUP BY period - ORDER BY period ASC -;'; + GROUP BY period;'; $level_items = simple_hash_from_query($query, 'period', 'nb_images'); diff --git a/include/ws_functions.inc.php b/include/ws_functions.inc.php index 1ebb7502a..47d7d32f1 100644 --- a/include/ws_functions.inc.php +++ b/include/ws_functions.inc.php @@ -1883,6 +1883,45 @@ SELECT ); } +function ws_rates_delete($params, &$service) +{ + global $conf; + + if (!$service->isPost()) + { + return new PwgError(405, 'This method requires HTTP POST'); + } + + if (!is_admin()) + { + return new PwgError(401, 'Access denied'); + } + + $user_id = (int)$params['user_id']; + if ($user_id<=0) + { + return new PwgError(WS_ERR_INVALID_PARAM, 'Invalid user_id'); + } + + $query = ' +DELETE FROM '.RATE_TABLE.' + WHERE user_id='.$user_id; + + if (!empty($params['anonymous_id'])) + { + $query .= ' AND anonymous_id=\''.$params['anonymous_id'].'\''; + } + + $changes = pwg_db_changes(pwg_query($query)); + if ($changes) + { + include_once(PHPWG_ROOT_PATH.'include/functions_rate.inc.php'); + update_rating_score(); + } + return $changes; +} + + /** * perform a login (web service method) */ |