diff options
Diffstat (limited to 'includes/playerStats.php')
| -rw-r--r-- | includes/playerStats.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/includes/playerStats.php b/includes/playerStats.php index f02c300..bc0b210 100644 --- a/includes/playerStats.php +++ b/includes/playerStats.php @@ -113,7 +113,7 @@ function addPlayerChampionPointsForMapsOfTheDay($mapExpireTime) -- Add the points for doing the weekly maps UPDATE solutions INNER JOIN mapOfTheDay ON mapOfTheDay.mapID = solutions.mapID - SET championPointsWorth = + SET solutions.championPointsWorth = ( SELECT IFNULL(".CP_MAX_WORTH_WEEKLY." * ( @@ -126,7 +126,7 @@ function addPlayerChampionPointsForMapsOfTheDay($mapExpireTime) FROM (SELECT * FROM solutions) AS s2 WHERE s2.mapID = mapOfTheDay.mapID ) + ".CP_MIN_WORTH_WEEKLY.", 0) - FROM (SELECT * FROM solutions) AS usersSolutions ON usersSolutions.mapID = mapOfTheDay.mapID + FROM (SELECT * FROM solutions) AS usersSolutions WHERE usersSolutions.ID = solutions.ID ) WHERE mapOfTheDay.mapExpireTime >= '$mapExpireTime' |