<?php
	/**
	 * Copyright 2005 Wim van Ravesteijn
	 *
	 * This file is part of AEGEE-Europe Photo Page.
	 *
	 * AEGEE-Europe Photo Page 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 Photo Page 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 Photo Page.  If not, see
	 * <http://www.gnu.org/licenses/>.
	 */
	#######################################
	### Update Address Book (ab_bodies) ###
	#######################################
	if( $rundaily!="yes" ) {
		// no access
		exit();
	}
	
	$out.="\n\n=== Creating dummy events ===\n";
	// Load the eventcodes for which we have books existing
	$query="SELECT `eventcode`, COUNT(`id`) AS `count` FROM `book`
					WHERE `uid`=0 AND `photocount`=0 AND `title`='Empty dummy book'
					GROUP BY `eventcode`";
	if( @mysql_num_rows( $res=doquery($query) )>0 ) {
		$books=array();
		$books[]="dummy";
		while( $row=mysql_fetch_array($res) ) {
			#$out.="Number of books for ".$row['eventcode'].": ".$row['count']."\n";
			$books[]=$row['eventcode'];
		}
		// Check if the event has a book linked to it, if not, create a dummy
		$query="SELECT `eventcode` FROM `event`";
		if( @mysql_num_rows( $res=doquery($query) )>0 ) {
			while( $row=mysql_fetch_array($res) ) {
				if( !array_search($row['eventcode'], $books) ) {
					// Event does not have any book connected to it
					$query2="INSERT INTO `book` (`uid`, `eventcode`, `photocount`, `title`)
									 VALUES (0, '".addslashes($row['eventcode'])."', 0, 'Empty dummy book')";
					if( doquery($query2) ) {
						$out.="Inserted dummy book for: ".$row['eventcode']."\n";
					}else {
						$out.="Failed inserting dummy book for: ".$row['eventcode']."\n";
					}
				}
			}
		}
	}
?>