From 79b1cd5c5b420289ae457f85600b27c94ee1ff30 Mon Sep 17 00:00:00 2001 From: BlueRaja Date: Fri, 8 Mar 2013 06:09:46 -0600 Subject: Fixing weekly maps not setting champion points correctly.. --- includes/playerStats.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'includes/playerStats.php') 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' -- cgit v1.2.3