diff options
| author | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-08 06:09:46 -0600 |
|---|---|---|
| committer | BlueRaja <BlueRaja.admin@gmail.com> | 2013-03-08 06:09:46 -0600 |
| commit | 79b1cd5c5b420289ae457f85600b27c94ee1ff30 (patch) | |
| tree | 6ebd9853408e2ce4cdc28105fb28c74c7f19105a /includes/playerStats.php | |
| parent | d0b8d2dfca3cd10cf93255ed012af41df18344f1 (diff) | |
| download | pathery-79b1cd5c5b420289ae457f85600b27c94ee1ff30.tar.xz | |
Fixing weekly maps not setting champion points correctly..
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' |