<?php
	/**
	 * Copyright 2000, 2001, 2002 Philipp von Klitzing
	 * Copyright 2003, 2004, 2005, 2006, 2007, 2008, 2009 Wim van Ravesteijn
	 *
	 * This file is part of AEGEE-Europe Statutory Event Applications.
	 *
	 * AEGEE-Europe Statutory Event Applications is free software: you can
	 * redistribute it and/or modify it under the terms of the GNU General
	 * Public License as published by the Free Software Foundation, either
	 * version 3 of the License, or (at your option) any later version.
	 *
	 * AEGEE-Europe Statutory Event Applications is distributed in the hope
	 * that it will be useful, but WITHOUT ANY WARRANTY; without even the
	 * implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
	 * PURPOSE.  See the GNU General Public License for more details.
	 *
	 * You should have received a copy of the GNU General Public License
	 * along with AEGEE-Europe Statutory Event Applications.  If not, see
	 * <http://www.gnu.org/licenses/>.
	 */
	if( isset($setup) ) {
		#######################################
		### Update Address Book (ab_bodies) ###
		#######################################
		$out.="\n\n=== Updating Address Book copy ===\n";
		$ABconn = mysql_connect(MYSQL_AB_HOST, MYSQL_AB_USER, MYSQL_AB_PASS, true);
		mysql_select_db(MYSQL_AB_DB,$ABconn);
		$query="SELECT `BodyCode`, `BodyName`, `Email`, `BodyStatus`, `BodyCategory`, `BodyCategoryOrder`, `MemberNo`, `BodyNameAscii`, `NetcomCode`, `CountryCode` FROM `bodies`";
		if( $res=mysql_query($query,$ABconn) ) {
			// Read the AB data from Karl
			while( $row=mysql_fetch_array($res) ) {
				$AB[ $row['BodyCode'] ]['BodyName']=$row["BodyName"];
				$AB[ $row['BodyCode'] ]['Email']=$row["Email"];
				$AB[ $row['BodyCode'] ]['BodyStatus']=$row["BodyStatus"];
				$AB[ $row['BodyCode'] ]['BodyCategory']=$row["BodyCategory"];
				$AB[ $row['BodyCode'] ]['BodyCategoryOrder']=$row['BodyCategoryOrder'];
				$AB[ $row['BodyCode'] ]['MemberNo']=$row['MemberNo'];
				$AB[ $row['BodyCode'] ]['BodyNameAscii']=$row["BodyNameAscii"];
				$AB[ $row['BodyCode'] ]['NetcomCode']=$row["NetcomCode"];
				$AB[ $row['BodyCode'] ]['CountryCode']=$row["CountryCode"];
				if( strlen($AB[ $row['BodyCode'] ]['CountryCode'])==0 ) $AB[ $row['BodyCode'] ]['CountryCode']="XXX";
			}
			$query="SELECT `BodyCode`, `BodyName`, `Email`, `BodyStatus`, `BodyCategory`, `BodyCategoryOrder`, `MemberNo`, `BodyNameAscii`, `NetcomCode`, `CountryCode`
							FROM `ab_bodies` WHERE `BodyCategoryOrder`>=0";
			if( $res=doquery($query) ) {
				while( $row=mysql_fetch_array($res) ) {
					if( isset( $AB[ $row['BodyCode'] ] ) ) {
						// Entry already in local copy of DB
						if( $AB[ $row['BodyCode'] ]['BodyName']!=$row['BodyName'] OR
								$AB[ $row['BodyCode'] ]['Email']!=$row['Email'] OR
								$AB[ $row['BodyCode'] ]['BodyStatus']!=$row['BodyStatus'] OR
								$AB[ $row['BodyCode'] ]['BodyCategory']!=$row['BodyCategory'] OR
								$AB[ $row['BodyCode'] ]['BodyCategoryOrder']!=$row['BodyCategoryOrder'] OR
								$AB[ $row['BodyCode'] ]['BodyNameAscii']!=$row['BodyNameAscii'] OR
								$AB[ $row['BodyCode'] ]['NetcomCode']!=$row['NetcomCode'] OR
								$AB[ $row['BodyCode'] ]['CountryCode']!=$row['CountryCode'] ) {
							// Entries differ
							$query="UPDATE `ab_bodies` SET `BodyName`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['BodyName'])."',
												`Email`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['Email'])."',
												`BodyStatus`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['BodyStatus'])."',
												`BodyCategory`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['BodyCategory'])."',
												`BodyCategoryOrder`=".mysql_real_escape_string($AB[ $row['BodyCode'] ]['BodyCategoryOrder']).",
												`BodyNameAscii`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['BodyNameAscii'])."',
												`NetcomCode`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['NetcomCode'])."',
												`CountryCode`='".mysql_real_escape_string($AB[ $row['BodyCode'] ]['CountryCode'])."'
											WHERE `BodyCode`='".mysql_real_escape_string($row['BodyCode'])."'";
							if( doquery($query) ) {
								$out.="\nUpdated successfully ".$row['BodyCode'].":\n";
							}else {
								$out.="\nFailed updating ".$row['BodyCode'].":\n";
							}
							$out.="BodyName: ".$row['BodyName']." ==> ".$AB[ $row['BodyCode'] ]['BodyName']."\n";
							$out.="Email: ".$row['Email']." ==> ".$AB[ $row['BodyCode'] ]['Email']."\n";
							$out.="BodyStatus: ".$row['BodyStatus']." ==> ".$AB[ $row['BodyCode'] ]['BodyStatus']."\n";
							$out.="BodyCategory: ".$row['BodyCategory']." ==> ".$AB[ $row['BodyCode'] ]['BodyCategory']."\n";
							$out.="BodyCategoryOrder: ".$row['BodyCategoryOrder']." ==> ".$AB[ $row['BodyCode'] ]['BodyCategoryOrder']."\n";
							$out.="BodyNameAscii: ".$row['BodyNameAscii']." ==> ".$AB[ $row['BodyCode'] ]['BodyNameAscii']."\n";
							$out.="NetcomCode: ".$row['NetcomCode']." ==> ".$AB[ $row['BodyCode'] ]['NetcomCode']."\n";
							$out.="CountryCode: ".$row['CountryCode']." ==> ".$AB[ $row['BodyCode'] ]['CountryCode']."\n";
						}else {
							// Nothing changed, so nothing to update
						}
						unset( $AB[ $row['BodyCode'] ] );
					}else {
						// Entry does not exist any more in master
						$query="SELECT `PersonID` FROM `persons` WHERE `BodyCode`='".mysql_real_escape_string($row['BodyCode'])."'";
						if( mysql_num_rows( doquery($query) ) ) {
							// Already people from this local applied
							$query="UPDATE `ab_bodies` SET `BodyName`='<i>Deleted body (".mysql_real_escape_string($row['BodyName']).")</i>', `BodyStatus`='D',
													`BodyCategory`=-1, `BodyCategoryOrder`=-1, `MemberNo`=-1, `BodyNameAscii`='<i>Deleted body (".mysql_real_escape_string($row['BodyNameAscii']).")</i>',
													`NetcomCode`='X', `CountryCode`='XXX'
											WHERE `BodyCode`='".mysql_real_escape_string($row['BodyCode'])."'";
							if( doquery($query) ) {
								$out.="\nDeactivated ".$row['BodyCode'].", there were already applications under this body.\n";
							}else {
								$out.="\nFailed deactivating ".$row['BodyCode']."\n";
							}
						}else {
							// We can delete this entry, it is not in use currently
							$query="DELETE FROM `ab_bodies` WHERE `BodyCode`='".mysql_real_escape_string($row['BodyCode'])."'";
							if( doquery($query) ) {
								$out.="\nSuccessfully deleted ".$row['BodyCode']."\n";
							}else {
								$out.="\nFailed deleting ".$row['BodyCode'].". Error: ".mysql_error()."\n";
							}
						}
					}
				}#/end of while
				// Check if there are new bodies in the master AB
				$bodies=array_keys($AB);
				for($i=0; $i<count($bodies); $i++) {
					$query="INSERT INTO `ab_bodies` (`BodyCode`, `BodyName`, `Email`, `BodyStatus`, `BodyCategory`, `BodyCategoryOrder`,
											`BodyNameAscii`, `NetcomCode`, `CountryCode`) VALUES
										('".mysql_real_escape_string($bodies[$i])."', '".mysql_real_escape_string($AB[ $bodies[$i] ]['BodyName'])."',
											'".mysql_real_escape_string($AB[ $bodies[$i] ]['Email'])."', '".mysql_real_escape_string($AB[ $bodies[$i] ]['BodyStatus'])."',
											'".mysql_real_escape_string($AB[ $bodies[$i] ]['BodyCategory'])."', ".mysql_real_escape_string($AB[ $bodies[$i] ]['BodyCategoryOrder']).",
											'".mysql_real_escape_string($AB[ $bodies[$i] ]['BodyNameAscii'])."', '".mysql_real_escape_string($AB[ $bodies[$i] ]['NetcomCode'])."',
											'".mysql_real_escape_string($AB[ $bodies[$i] ]['CountryCode'])."')";
					if( doquery($query) ) {
						$out.="\nSuccessfully inserted ".$bodies[$i]."\n";
					}else {
						$out.="\nFailed inserting ".$bodies[$i].", error: ".mysql_error()."\n";
					}
					$out.="BodyName: ".$AB[ $bodies[$i] ]['BodyName']."\n";
					$out.="Email: ".$AB[ $bodies[$i] ]['Email']."\n";
					$out.="BodyStatus: ".$AB[ $bodies[$i] ]['BodyStatus']."\n";
					$out.="BodyCategory: ".$AB[ $bodies[$i] ]['BodyCategory']."\n";
					$out.="BodyCategoryOrder: ".$AB[ $bodies[$i] ]['BodyCategoryOrder']."\n";
					$out.="BodyNameAscii: ".$AB[ $bodies[$i] ]['BodyNameAscii']."\n";
					$out.="NetcomCode: ".$AB[ $bodies[$i] ]['NetcomCode']."\n";
					$out.="CountryCode: ".$AB[ $bodies[$i] ]['CountryCode']."\n";
				}
			}else {
				$out.="\nError reading data from local copy\n";
			}
		}else {
			$out.="\nFailed loading body data\n";
		}
	}
?>