}
print "Database update add an accomplishments table and fill it for all users.<br />\n";
$sql = "DROP TABLE IF EXISTS accomplishments";
$run = $objDatabase->execSQL($sql);
$sql = "CREATE TABLE accomplishments (\n observer VARCHAR(255) NOT NULL DEFAULT '',\n messierBronze INT(1) NOT NULL DEFAULT 0,\n messierSilver INT(1) NOT NULL DEFAULT 0,\n messierGold INT(1) NOT NULL DEFAULT 0,\n messierDrawingsBronze INT(1) NOT NULL DEFAULT 0,\n messierDrawingsSilver INT(1) NOT NULL DEFAULT 0,\n messierDrawingsGold INT(1) NOT NULL DEFAULT 0,\n caldwellBronze INT(1) NOT NULL DEFAULT 0,\n caldwellSilver INT(1) NOT NULL DEFAULT 0,\n caldwellGold INT(1) NOT NULL DEFAULT 0,\n caldwellDrawingsBronze INT(1) NOT NULL DEFAULT 0,\n caldwellDrawingsSilver INT(1) NOT NULL DEFAULT 0,\n caldwelldrawingsGold INT(1) NOT NULL DEFAULT 0,\n herschelBronze INT(1) NOT NULL DEFAULT 0,\n herschelSilver INT(1) NOT NULL DEFAULT 0,\n herschelGold INT(1) NOT NULL DEFAULT 0,\n herschelDiamond INT(1) NOT NULL DEFAULT 0,\n herschelPlatina INT(1) NOT NULL DEFAULT 0,\n herschelDrawingsBronze INT(1) NOT NULL DEFAULT 0,\n herschelDrawingsSilver INT(1) NOT NULL DEFAULT 0,\n herschelDrawingsGold INT(1) NOT NULL DEFAULT 0,\n herschelDrawingsDiamond INT(1) NOT NULL DEFAULT 0,\n herschelDrawingsPlatina INT(1) NOT NULL DEFAULT 0,\n herschelIIBronze INT(1) NOT NULL DEFAULT 0,\n herschelIISilver INT(1) NOT NULL DEFAULT 0,\n herschelIIGold INT(1) NOT NULL DEFAULT 0,\n herschelIIDiamond INT(1) NOT NULL DEFAULT 0,\n herschelIIPlatina INT(1) NOT NULL DEFAULT 0,\n herschelIIDrawingsBronze INT(1) NOT NULL DEFAULT 0,\n herschelIIDrawingsSilver INT(1) NOT NULL DEFAULT 0,\n herschelIIDrawingsGold INT(1) NOT NULL DEFAULT 0,\n herschelIIDrawingsDiamond INT(1) NOT NULL DEFAULT 0,\n herschelIIDrawingsPlatina INT(1) NOT NULL DEFAULT 0,\n drawingsNewbie INT(1) NOT NULL DEFAULT 0,\n drawingsRookie INT(1) NOT NULL DEFAULT 0,\n drawingsBeginner INT(1) NOT NULL DEFAULT 0,\n drawingsTalented INT(1) NOT NULL DEFAULT 0,\n drawingsSkilled INT(1) NOT NULL DEFAULT 0,\n drawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n drawingsExperienced INT(1) NOT NULL DEFAULT 0,\n drawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n drawingsSenior INT(1) NOT NULL DEFAULT 0,\n drawingsExpert INT(1) NOT NULL DEFAULT 0,\n cometObservationsNewbie INT(1) NOT NULL DEFAULT 0,\n cometObservationsRookie INT(1) NOT NULL DEFAULT 0,\n cometObservationsBeginner INT(1) NOT NULL DEFAULT 0,\n cometObservationsTalented INT(1) NOT NULL DEFAULT 0,\n cometObservationsSkilled INT(1) NOT NULL DEFAULT 0,\n cometObservationsIntermediate INT(1) NOT NULL DEFAULT 0,\n cometObservationsExperienced INT(1) NOT NULL DEFAULT 0,\n cometObservationsAdvanced INT(1) NOT NULL DEFAULT 0,\n cometObservationsSenior INT(1) NOT NULL DEFAULT 0,\n cometObservationsExpert INT(1) NOT NULL DEFAULT 0,\n cometsObservedNewbie INT(1) NOT NULL DEFAULT 0,\n cometsObservedRookie INT(1) NOT NULL DEFAULT 0,\n cometsObservedBeginner INT(1) NOT NULL DEFAULT 0,\n cometsObservedTalented INT(1) NOT NULL DEFAULT 0,\n cometsObservedSkilled INT(1) NOT NULL DEFAULT 0,\n cometsObservedIntermediate INT(1) NOT NULL DEFAULT 0,\n cometsObservedExperienced INT(1) NOT NULL DEFAULT 0,\n cometsObservedAdvanced INT(1) NOT NULL DEFAULT 0,\n cometsObservedSenior INT(1) NOT NULL DEFAULT 0,\n cometsObservedExpert INT(1) NOT NULL DEFAULT 0,\n cometDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n cometDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n cometDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n cometDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n cometDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n cometDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n cometDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n cometDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n cometDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n cometDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n openClusterNewbie INT(1) NOT NULL DEFAULT 0,\n openClusterRookie INT(1) NOT NULL DEFAULT 0,\n openClusterBeginner INT(1) NOT NULL DEFAULT 0,\n openClusterTalented INT(1) NOT NULL DEFAULT 0,\n openClusterSkilled INT(1) NOT NULL DEFAULT 0,\n openClusterIntermediate INT(1) NOT NULL DEFAULT 0,\n openClusterExperienced INT(1) NOT NULL DEFAULT 0,\n openClusterAdvanced INT(1) NOT NULL DEFAULT 0,\n openClusterSenior INT(1) NOT NULL DEFAULT 0,\n openClusterExpert INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n openClusterDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n globularClusterNewbie INT(1) NOT NULL DEFAULT 0,\n globularClusterRookie INT(1) NOT NULL DEFAULT 0,\n globularClusterBeginner INT(1) NOT NULL DEFAULT 0,\n globularClusterTalented INT(1) NOT NULL DEFAULT 0,\n globularClusterSkilled INT(1) NOT NULL DEFAULT 0,\n globularClusterIntermediate INT(1) NOT NULL DEFAULT 0,\n globularClusterExperienced INT(1) NOT NULL DEFAULT 0,\n globularClusterAdvanced INT(1) NOT NULL DEFAULT 0,\n globularClusterSenior INT(1) NOT NULL DEFAULT 0,\n globularClusterExpert INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n globularClusterDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaNewbie INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaRookie INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaBeginner INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaTalented INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaSkilled INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaIntermediate INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaExperienced INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaAdvanced INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaSenior INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaExpert INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n planetaryNebulaDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n galaxyNewbie INT(1) NOT NULL DEFAULT 0,\n galaxyRookie INT(1) NOT NULL DEFAULT 0,\n galaxyBeginner INT(1) NOT NULL DEFAULT 0,\n galaxyTalented INT(1) NOT NULL DEFAULT 0,\n galaxySkilled INT(1) NOT NULL DEFAULT 0,\n galaxyIntermediate INT(1) NOT NULL DEFAULT 0,\n galaxyExperienced INT(1) NOT NULL DEFAULT 0,\n galaxyAdvanced INT(1) NOT NULL DEFAULT 0,\n galaxySenior INT(1) NOT NULL DEFAULT 0,\n galaxyExpert INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n galaxyDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n nebulaNewbie INT(1) NOT NULL DEFAULT 0,\n nebulaRookie INT(1) NOT NULL DEFAULT 0,\n nebulaBeginner INT(1) NOT NULL DEFAULT 0,\n nebulaTalented INT(1) NOT NULL DEFAULT 0,\n nebulaSkilled INT(1) NOT NULL DEFAULT 0,\n nebulaIntermediate INT(1) NOT NULL DEFAULT 0,\n nebulaExperienced INT(1) NOT NULL DEFAULT 0,\n nebulaAdvanced INT(1) NOT NULL DEFAULT 0,\n nebulaSenior INT(1) NOT NULL DEFAULT 0,\n nebulaExpert INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n nebulaDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n objectsNewbie INT(1) NOT NULL DEFAULT 0,\n objectsRookie INT(1) NOT NULL DEFAULT 0,\n objectsBeginner INT(1) NOT NULL DEFAULT 0,\n objectsTalented INT(1) NOT NULL DEFAULT 0,\n objectsSkilled INT(1) NOT NULL DEFAULT 0,\n objectsIntermediate INT(1) NOT NULL DEFAULT 0,\n objectsExperienced INT(1) NOT NULL DEFAULT 0,\n objectsAdvanced INT(1) NOT NULL DEFAULT 0,\n objectsSenior INT(1) NOT NULL DEFAULT 0,\n objectsExpert INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsNewbie INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsRookie INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsBeginner INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsTalented INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsSkilled INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsIntermediate INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsExperienced INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsAdvanced INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsSenior INT(1) NOT NULL DEFAULT 0,\n objectsDrawingsExpert INT(1) NOT NULL DEFAULT 0,\n PRIMARY KEY (observer) \n )";
$run = $objDatabase->execSQL($sql);
// We loop over all observers
$observers = $objObserver->getSortedObservers("id");
foreach ($observers as $key => $value) {
$sql = "INSERT INTO accomplishments (observer, messierBronze, messierSilver, messierGold, messierDrawingsBronze, messierDrawingsSilver, messierDrawingsGold, caldwellBronze, caldwellSilver, caldwellGold, caldwellDrawingsBronze, caldwellDrawingsSilver, caldwelldrawingsGold, herschelBronze, herschelSilver, herschelGold, herschelDiamond, herschelPlatina, herschelDrawingsBronze, herschelDrawingsSilver, herschelDrawingsGold, herschelDrawingsDiamond, herschelDrawingsPlatina, herschelIIBronze, herschelIISilver, herschelIIGold, herschelIIDiamond, herschelIIPlatina, herschelIIDrawingsBronze, herschelIIDrawingsSilver, herschelIIDrawingsGold, herschelIIDrawingsDiamond, herschelIIDrawingsPlatina, drawingsNewbie, drawingsRookie, drawingsBeginner, drawingsTalented, drawingsSkilled, drawingsIntermediate, drawingsExperienced, drawingsAdvanced, drawingsSenior, drawingsExpert, cometObservationsNewbie, cometObservationsRookie, cometObservationsBeginner, cometObservationsTalented, cometObservationsSkilled, cometObservationsIntermediate, cometObservationsExperienced, cometObservationsAdvanced, cometObservationsSenior, cometObservationsExpert, cometsObservedNewbie, cometsObservedRookie, cometsObservedBeginner, cometsObservedTalented, cometsObservedSkilled, cometsObservedIntermediate, cometsObservedExperienced, cometsObservedAdvanced, cometsObservedSenior, cometsObservedExpert, cometDrawingsNewbie, cometDrawingsRookie, cometDrawingsBeginner, cometDrawingsTalented, cometDrawingsSkilled, cometDrawingsIntermediate, cometDrawingsExperienced, cometDrawingsAdvanced, cometDrawingsSenior, cometDrawingsExpert, openClusterNewbie, openClusterRookie, openClusterBeginner, openClusterTalented, openClusterSkilled, openClusterIntermediate, openClusterExperienced, openClusterAdvanced, openClusterSenior, openClusterExpert, openClusterDrawingsNewbie, openClusterDrawingsRookie, openClusterDrawingsBeginner, openClusterDrawingsTalented, openClusterDrawingsSkilled, openClusterDrawingsIntermediate, openClusterDrawingsExperienced, openClusterDrawingsAdvanced, openClusterDrawingsSenior, openClusterDrawingsExpert, globularClusterNewbie, globularClusterRookie, globularClusterBeginner, globularClusterTalented, globularClusterSkilled, globularClusterIntermediate, globularClusterExperienced, globularClusterAdvanced, globularClusterSenior, globularClusterExpert, globularClusterDrawingsNewbie, globularClusterDrawingsRookie, globularClusterDrawingsBeginner, globularClusterDrawingsTalented, globularClusterDrawingsSkilled, globularClusterDrawingsIntermediate, globularClusterDrawingsExperienced, globularClusterDrawingsAdvanced, globularClusterDrawingsSenior, globularClusterDrawingsExpert, planetaryNebulaNewbie, planetaryNebulaRookie, planetaryNebulaBeginner, planetaryNebulaTalented, planetaryNebulaSkilled, planetaryNebulaIntermediate, planetaryNebulaExperienced, planetaryNebulaAdvanced, planetaryNebulaSenior, planetaryNebulaExpert, planetaryNebulaDrawingsNewbie, planetaryNebulaDrawingsRookie, planetaryNebulaDrawingsBeginner, planetaryNebulaDrawingsTalented, planetaryNebulaDrawingsSkilled, planetaryNebulaDrawingsIntermediate, planetaryNebulaDrawingsExperienced, planetaryNebulaDrawingsAdvanced, planetaryNebulaDrawingsSenior, planetaryNebulaDrawingsExpert, galaxyNewbie, galaxyRookie, galaxyBeginner, galaxyTalented, galaxySkilled, galaxyIntermediate, galaxyExperienced, galaxyAdvanced, galaxySenior, galaxyExpert, galaxyDrawingsNewbie, galaxyDrawingsRookie, galaxyDrawingsBeginner, galaxyDrawingsTalented, galaxyDrawingsSkilled, galaxyDrawingsIntermediate, galaxyDrawingsExperienced, galaxyDrawingsAdvanced, galaxyDrawingsSenior, galaxyDrawingsExpert, nebulaNewbie, nebulaRookie, nebulaBeginner, nebulaTalented, nebulaSkilled, nebulaIntermediate, nebulaExperienced, nebulaAdvanced, nebulaSenior, nebulaExpert, nebulaDrawingsNewbie, nebulaDrawingsRookie, nebulaDrawingsBeginner, nebulaDrawingsTalented, nebulaDrawingsSkilled, nebulaDrawingsIntermediate, nebulaDrawingsExperienced, nebulaDrawingsAdvanced, nebulaDrawingsSenior, nebulaDrawingsExpert, objectsNewbie, objectsRookie, objectsBeginner, objectsTalented, objectsSkilled, objectsIntermediate, objectsExperienced, objectsAdvanced, objectsSenior, objectsExpert, objectsDrawingsNewbie, objectsDrawingsRookie, objectsDrawingsBeginner, objectsDrawingsTalented, objectsDrawingsSkilled, objectsDrawingsIntermediate, objectsDrawingsExperienced, objectsDrawingsAdvanced, objectsDrawingsSenior, objectsDrawingsExpert) " . "VALUES (\"" . $value . "\", " . $objAccomplishments->calculateMessier($value)[0] . ", " . $objAccomplishments->calculateMessier($value)[1] . ", " . $objAccomplishments->calculateMessier($value)[2] . ", " . $objAccomplishments->calculateMessierDrawings($value)[0] . ", " . $objAccomplishments->calculateMessierDrawings($value)[1] . ", " . $objAccomplishments->calculateMessierDrawings($value)[2] . ", " . $objAccomplishments->calculateCaldwell($value)[0] . ", " . $objAccomplishments->calculateCaldwell($value)[1] . ", " . $objAccomplishments->calculateCaldwell($value)[2] . ", " . $objAccomplishments->calculateCaldwellDrawings($value)[0] . ", " . $objAccomplishments->calculateCaldwellDrawings($value)[1] . ", " . $objAccomplishments->calculateCaldwellDrawings($value)[2] . ", " . $objAccomplishments->calculateHerschel($value)[0] . ", " . $objAccomplishments->calculateHerschel($value)[1] . ", " . $objAccomplishments->calculateHerschel($value)[2] . ", " . $objAccomplishments->calculateHerschel($value)[3] . ", " . $objAccomplishments->calculateHerschel($value)[4] . ", " . $objAccomplishments->calculateHerschelDrawings($value)[0] . ", " . $objAccomplishments->calculateHerschelDrawings($value)[1] . ", " . $objAccomplishments->calculateHerschelDrawings($value)[2] . ", " . $objAccomplishments->calculateHerschelDrawings($value)[3] . ", " . $objAccomplishments->calculateHerschelDrawings($value)[4] . ", " . $objAccomplishments->calculateHerschelII($value)[0] . ", " . $objAccomplishments->calculateHerschelII($value)[1] . ", " . $objAccomplishments->calculateHerschelII($value)[2] . ", " . $objAccomplishments->calculateHerschelII($value)[3] . ", " . $objAccomplishments->calculateHerschelII($value)[4] . ", " . $objAccomplishments->calculateHerschelIIDrawings($value)[0] . ", " . $objAccomplishments->calculateHerschelIIDrawings($value)[1] . ", " . $objAccomplishments->calculateHerschelIIDrawings($value)[2] . ", " . $objAccomplishments->calculateHerschelIIDrawings($value)[3] . ", " . $objAccomplishments->calculateHerschelIIDrawings($value)[4] . ", " . $objAccomplishments->calculateDrawings($value)[0] . ", " . $objAccomplishments->calculateDrawings($value)[1] . ", " . $objAccomplishments->calculateDrawings($value)[2] . ", " . $objAccomplishments->calculateDrawings($value)[3] . ", " . $objAccomplishments->calculateDrawings($value)[4] . ", " . $objAccomplishments->calculateDrawings($value)[5] . ", " . $objAccomplishments->calculateDrawings($value)[6] . ", " . $objAccomplishments->calculateDrawings($value)[7] . ", " . $objAccomplishments->calculateDrawings($value)[8] . ", " . $objAccomplishments->calculateDrawings($value)[9] . ", " . $objAccomplishments->calculateCometObservations($value)[0] . ", " . $objAccomplishments->calculateCometObservations($value)[1] . ", " . $objAccomplishments->calculateCometObservations($value)[2] . ", " . $objAccomplishments->calculateCometObservations($value)[3] . ", " . $objAccomplishments->calculateCometObservations($value)[4] . ", " . $objAccomplishments->calculateCometObservations($value)[5] . ", " . $objAccomplishments->calculateCometObservations($value)[6] . ", " . $objAccomplishments->calculateCometObservations($value)[7] . ", " . $objAccomplishments->calculateCometObservations($value)[8] . ", " . $objAccomplishments->calculateCometObservations($value)[9] . ", " . $objAccomplishments->calculateCometsObserved($value)[0] . ", " . $objAccomplishments->calculateCometsObserved($value)[1] . ", " . $objAccomplishments->calculateCometsObserved($value)[2] . ", " . $objAccomplishments->calculateCometsObserved($value)[3] . ", " . $objAccomplishments->calculateCometsObserved($value)[4] . ", " . $objAccomplishments->calculateCometsObserved($value)[5] . ", " . $objAccomplishments->calculateCometsObserved($value)[6] . ", " . $objAccomplishments->calculateCometsObserved($value)[7] . ", " . $objAccomplishments->calculateCometsObserved($value)[8] . ", " . $objAccomplishments->calculateCometsObserved($value)[9] . ", " . $objAccomplishments->calculateCometDrawings($value)[0] . ", " . $objAccomplishments->calculateCometDrawings($value)[1] . ", " . $objAccomplishments->calculateCometDrawings($value)[2] . ", " . $objAccomplishments->calculateCometDrawings($value)[3] . ", " . $objAccomplishments->calculateCometDrawings($value)[4] . ", " . $objAccomplishments->calculateCometDrawings($value)[5] . ", " . $objAccomplishments->calculateCometDrawings($value)[6] . ", " . $objAccomplishments->calculateCometDrawings($value)[7] . ", " . $objAccomplishments->calculateCometDrawings($value)[8] . ", " . $objAccomplishments->calculateCometDrawings($value)[9] . ", " . $objAccomplishments->calculateOpenClusters($value)[0] . ", " . $objAccomplishments->calculateOpenClusters($value)[1] . ", " . $objAccomplishments->calculateOpenClusters($value)[2] . ", " . $objAccomplishments->calculateOpenClusters($value)[3] . ", " . $objAccomplishments->calculateOpenClusters($value)[4] . ", " . $objAccomplishments->calculateOpenClusters($value)[5] . ", " . $objAccomplishments->calculateOpenClusters($value)[6] . ", " . $objAccomplishments->calculateOpenClusters($value)[7] . ", " . $objAccomplishments->calculateOpenClusters($value)[8] . ", " . $objAccomplishments->calculateOpenClusters($value)[9] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[0] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[1] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[2] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[3] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[4] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[5] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[6] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[7] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[8] . ", " . $objAccomplishments->calculateOpenClusterDrawings($value)[9] . ", " . $objAccomplishments->calculateGlobularClusters($value)[0] . ", " . $objAccomplishments->calculateGlobularClusters($value)[1] . ", " . $objAccomplishments->calculateGlobularClusters($value)[2] . ", " . $objAccomplishments->calculateGlobularClusters($value)[3] . ", " . $objAccomplishments->calculateGlobularClusters($value)[4] . ", " . $objAccomplishments->calculateGlobularClusters($value)[5] . ", " . $objAccomplishments->calculateGlobularClusters($value)[6] . ", " . $objAccomplishments->calculateGlobularClusters($value)[7] . ", " . $objAccomplishments->calculateGlobularClusters($value)[8] . ", " . $objAccomplishments->calculateGlobularClusters($value)[9] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[0] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[1] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[2] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[3] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[4] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[5] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[6] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[7] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[8] . ", " . $objAccomplishments->calculateGlobularClusterDrawings($value)[9] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[0] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[1] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[2] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[3] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[4] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[5] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[6] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[7] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[8] . ", " . $objAccomplishments->calculatePlanetaryNebulae($value)[9] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[0] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[1] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[2] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[3] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[4] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[5] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[6] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[7] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[8] . ", " . $objAccomplishments->calculatePlanetaryNebulaDrawings($value)[9] . ", " . $objAccomplishments->calculateGalaxies($value)[0] . ", " . $objAccomplishments->calculateGalaxies($value)[1] . ", " . $objAccomplishments->calculateGalaxies($value)[2] . ", " . $objAccomplishments->calculateGalaxies($value)[3] . ", " . $objAccomplishments->calculateGalaxies($value)[4] . ", " . $objAccomplishments->calculateGalaxies($value)[5] . ", " . $objAccomplishments->calculateGalaxies($value)[6] . ", " . $objAccomplishments->calculateGalaxies($value)[7] . ", " . $objAccomplishments->calculateGalaxies($value)[8] . ", " . $objAccomplishments->calculateGalaxies($value)[9] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[0] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[1] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[2] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[3] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[4] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[5] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[6] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[7] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[8] . ", " . $objAccomplishments->calculateGalaxyDrawings($value)[9] . ", " . $objAccomplishments->calculateNebulae($value)[0] . ", " . $objAccomplishments->calculateNebulae($value)[1] . ", " . $objAccomplishments->calculateNebulae($value)[2] . ", " . $objAccomplishments->calculateNebulae($value)[3] . ", " . $objAccomplishments->calculateNebulae($value)[4] . ", " . $objAccomplishments->calculateNebulae($value)[5] . ", " . $objAccomplishments->calculateNebulae($value)[6] . ", " . $objAccomplishments->calculateNebulae($value)[7] . ", " . $objAccomplishments->calculateNebulae($value)[8] . ", " . $objAccomplishments->calculateNebulae($value)[9] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[0] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[1] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[2] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[3] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[4] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[5] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[6] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[7] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[8] . ", " . $objAccomplishments->calculateNebulaDrawings($value)[9] . ", " . $objAccomplishments->calculateDifferentObjects($value)[0] . ", " . $objAccomplishments->calculateDifferentObjects($value)[1] . ", " . $objAccomplishments->calculateDifferentObjects($value)[2] . ", " . $objAccomplishments->calculateDifferentObjects($value)[3] . ", " . $objAccomplishments->calculateDifferentObjects($value)[4] . ", " . $objAccomplishments->calculateDifferentObjects($value)[5] . ", " . $objAccomplishments->calculateDifferentObjects($value)[6] . ", " . $objAccomplishments->calculateDifferentObjects($value)[7] . ", " . $objAccomplishments->calculateDifferentObjects($value)[8] . ", " . $objAccomplishments->calculateDifferentObjects($value)[9] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[0] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[1] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[2] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[3] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[4] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[5] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[6] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[7] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[8] . ", " . $objAccomplishments->calculateDifferentObjectDrawings($value)[9] . ");";
$objDatabase->execSQL($sql);
// We check for all observers if they have at least one observation... If they do, they have at least
// one accomplishment and we can send a message.
if ($objAccomplishments->calculateDifferentObjects($value)[0] == 1) {
$sql = "select firstname from observers where id = \"" . $value . "\"";
$run = $objDatabase->selectRecordset($sql);
$get = $run->fetch(PDO::FETCH_OBJ);
$firstname = $get->firstname;
$sql = "select language from observers where id = \"" . $value . "\"";
$run = $objDatabase->selectRecordset($sql);
$get = $run->fetch(PDO::FETCH_OBJ);
if ($get->language == "nl") {
$subject = 'Je hebt één of meerdere realisaties in DeepskyLog!';
$content = 'Proficiat ' . $firstname;
$content = $content . ', <br/><br/>Je hebt één of meerdere realisaties in DeepskyLog!<br/><br/>';
$content = $content . 'Bekijk je realisaties op <a href="http://www.deepskylog.be/index.php?indexAction=detail_observer&user='******'">http://www.deepskylog.be/index.php?indexAction=detail_observer&user='******'</a>';
$content = $content . '<br /><br />Het DeepskyLog team';
} else {
if ($get->language == "en") {
$subject = 'You have one of more realisations in DeepskyLog!';
$content = 'Congratulations ' . $firstname;
