<?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) ) {
		##############################################
		### Updating number of members (ab_bodies) ###
		##############################################
		$out.="\n\n=== Updating number of members ===\n";
		for( $i=2; $i>=1; $i-- ) {
			if( isset($setup['LoadNumMemDB'.$i]) && strlen($setup['LoadNumMemDB'.$i])>0 ) {
				$query="SELECT `BodyCode`, `MemberClaimed` AS `MemberNo` FROM `".addslashes($setup['LoadNumMemDB'.$i])."`.`ab_bodies`";
				if( $res=mysql_query($query) ) {
					// Read the AB data from Robert
					while( $row=mysql_fetch_array($res) ) {
						$Members[ $row['BodyCode'] ]=$row['MemberNo'];
						$MemberSource[ $row['BodyCode'] ]=$setup['LoadNumMemDB'.$i];
					}
					$query="SELECT `BodyCode`, `MemberNo` FROM `ab_bodies`";
					if( $res=doquery($query) ) {
						while( $row=mysql_fetch_array($res) ) {
							if( isset( $Members[ $row['BodyCode'] ] ) ) {
								// Body exists in local copy of DB
								if( $Members[ $row['BodyCode'] ]!=$row['MemberNo'] AND ( ($i==2 AND ($row['MemberNo']=="" OR $row['MemberNo']==0) ) OR $i==1) ) {
									// Entries differ
									$query="UPDATE `ab_bodies`
													SET `MemberNo`=".$Members[ $row['BodyCode'] ].",
															`MemberSource`='".addslashes($MemberSource[ $row['BodyCode'] ])."'
													WHERE `BodyCode`='".$row['BodyCode']."'";
									if( doquery($query) ) {
										$out.="\nUpdated successfully number of members for ".$row['BodyCode']." from ".$row['MemberNo']." to ".$Members[ $row['BodyCode'] ]."\n";
									}else {
										$out.="\nFailed updating number of members for ".$row['BodyCode']." from ".$row['MemberNo']." to ".$Members[ $row['BodyCode'] ]."\n";
									}
								}else {
									// Nothing changed, so nothing to update
								}
								unset( $Members[ $row['BodyCode'] ] );
							}
						}#/end of while
					}else {
						$out.="\nError reading data from local copy\n";
					}
				}else {
					$out.="\nFailed loading number of members\n";
				}
			}
		}
	}
?>