$smarty->assign("achievement_added", $achievement['added']); $smarty->assign("achievement_lock", $achievement['lock']); $smarty->display('achievementBlockLarge.tpl'); break; //----------------------------------------------------------------------------------------------------------------------------------// //ACHIEVEMENT BLOCK MEMBER ADD //----------------------------------------------------------------------------------------------------------------------------------// //----------------------------------------------------------------------------------------------------------------------------------// //ACHIEVEMENT BLOCK MEMBER ADD //----------------------------------------------------------------------------------------------------------------------------------// case 'achievementBlockMemberAdd': $smarty->assign("Name", "Add Achievement to Member"); $id = db_clean_int($_GET['id']); $member = db_clean_int($_GET['member']); $smarty->assign("member_id", $member); $achievement = retreiveAchievement($id); $smarty->assign("achievement_id", $achievement['id']); $smarty->assign("achievement_category", $achievement['category']); $smarty->assign("achievement_name", $achievement['name']); $smarty->assign("achievement_image", $achievement['image']); $smarty->assign("achievement_description", $achievement['description']); $smarty->assign("achievement_goal", $achievement['goal']); $smarty->assign("achievement_points", $achievement['points']); $smarty->assign("achievement_added", $achievement['added']); $smarty->assign("achievement_lock", $achievement['lock']); $smarty->assign("progress", retreiveAchievementProgressValues($achievement['goal'])); $smarty->display('achievementBlockMemberAdd.tpl'); break; //----------------------------------------------------------------------------------------------------------------------------------// //LIST COMMITTEES //----------------------------------------------------------------------------------------------------------------------------------//
function increaseAchievementsEarnedProgress($id) { $query = "SELECT `achievement`, `progress` FROM achievements_earned WHERE `id` = " . $id . ";"; $result = mysql_query($query); $earned = mysql_fetch_row($result); $achievement = retreiveAchievement($earned[0]); $goal = $achievement['goal']; $progress = $earned[1]; //We aren't already at the goal so we can move our progress upward... if ($progress < $goal) { $query = "UPDATE achievements_earned SET `progress` = " . ($progress + 1) . ", `updated` = NOW() WHERE `id` = " . $id . ";"; $result = mysql_query($query); } }