<?php
# ***** BEGIN LICENSE BLOCK *****
#
# This file is part of CodingTeam.
# CodingTeam is the legal property of Erwan Briand <xbright2005@gmail.com>
# Copyright (c) 2007 Erwan Briand
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 2 as
# published by the Free Software Foundation
#
# This program 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 this program; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
#
# ***** END LICENSE BLOCK *****
session_start();
require_once("include/config.inc.php");
require_once("include/members.inc.php");

if (IsLogged() && IsAdmin($pseudo)) {

	$projet = $_GET['id'];
	if (!ereg("^([0-9]*)$" , $projet))
		exit('Error.');
		
	if(isset($_GET['adresse']))
	{
		if (!ereg("^[0-9A-Za-z ]+$" , $_GET['adresse']))
			exit('Error.');
	
		// Le travail est terminé	
		echo 'Projet : <b>'.$_GET['adresse'].'</b><br />';
		if(file_exists(dirname(__FILE__).'/code/'.$_GET['adresse'].'')) {
			echo 'SVN : <b>'.dirname(__FILE__).'/code/'.$_GET['adresse'].'</b> <i>suppression manuelle requise</i><br />';
		}
		echo 'Supprimé !';
		// Suppression du projet 
		mysql_query("DELETE FROM ct2_os WHERE id = '$projet' LIMIT 1") or die( mysql_error() );			
	
	}
	else
	{
		
		$req = mysql_query("SELECT adresse FROM ct2_os WHERE id = '$projet' LIMIT 1");
		if (mysql_num_rows($req) == 1)
		{
			$adr = mysql_fetch_array($req);
			$adresse = $adr['adresse'];
	
			// Suppression des actualités
			mysql_query("DELETE FROM ct2_os_actu WHERE projet = '$projet' ") or die( mysql_error() );
		
			// Suppression des téléchargements (nombre)
			$suppr = mysql_query("SELECT file FROM ct2_os_bin WHERE projet =  '$projet' ") or die( mysql_error() );	
 			while($row = mysql_fetch_array($suppr))
 			{
				$img = explode($racine, $row['file']);
				$img2 = explode($racineconflit, $row['file']);
				
				if (file_exists(dirname(__FILE__).'/'.$img[1]) && !empty($img[1])) {
					unlink(dirname(__FILE__).'/'.$img[1]);
				} elseif (file_exists(dirname(__FILE__).'/'.$img2[1]) && !empty($img2[1])) {
					unlink(dirname(__FILE__).'/'.$img2[1]);
				}
	 
 				mysql_query("DELETE FROM ct2_os_nb WHERE fichier = '".$row['file']."' AND projet = '$projet' ") or die( mysql_error() );
			}
			mysql_query("DELETE FROM ct2_os_bin WHERE projet =  '$projet' ") or die( mysql_error() );	
		
			// Suppression des bugs (fermés, réponses)
			$delete = mysql_query("SELECT id FROM ct2_os_bug WHERE projet = '$projet' ") or die( mysql_error() );
			while($row = mysql_fetch_array($delete))
			{
				mysql_query("DELETE FROM ct2_os_bug_closed WHERE idbug = '".$row['id']."' ") or die( mysql_error() );
				mysql_query("DELETE FROM ct2_os_bug_reply WHERE idrep = '".$row['id']."' ") or die( mysql_error() );
			}
			mysql_query("DELETE FROM ct2_os_bug WHERE projet = '$projet' ") or die( mysql_error() );
		
			// Suppression des commentaires (forum de discussion)
			mysql_query("DELETE FROM ct2_os_com WHERE projet = '$projet' ") or die( mysql_error() );	
		
			// Suppression de l'étât d'avancement
			mysql_query("DELETE FROM ct2_os_etat WHERE idprojet = '$projet' LIMIT 1") or die( mysql_error() );	
		
			// Suppression des copies d'écran
			$suppr = mysql_query("SELECT img FROM ct2_os_screen WHERE projet =  '$projet' ") or die( mysql_error() );	
 			while($row = mysql_fetch_array($suppr))
 			{
				$img = explode($racine, $row['img']);
				$img2 = explode($racineconflit, $row['img']);
				
				if (file_exists(dirname(__FILE__).'/'.$img[1]) && !empty($img[1])) {
					unlink(dirname(__FILE__).'/'.$img[1]);
				} elseif (file_exists(dirname(__FILE__).'/'.$img2[1]) && !empty($img2[1])) {
					unlink(dirname(__FILE__).'/'.$img2[1]);
				}
	 
			}
			mysql_query("DELETE FROM ct2_os_screen WHERE projet =  '$projet' ") or die( mysql_error() );	
		
			// Suppression de la page pour le dépôt SVN
			mysql_query("DELETE FROM ct2_os_svn WHERE idprojet = '$projet' LIMIT 1") or die( mysql_error() );
		
			// Suppression des administrateurs du projet
			mysql_query("DELETE FROM ct2_os_team WHERE idprojet = '$projet' ") or die( mysql_error() );
		
			// Suppression des objectifs (planifiés)
			$delete = mysql_query("SELECT id FROM ct2_os_todo WHERE projet = '$projet' ") or die( mysql_error() );
			while($row = mysql_fetch_array($delete))
			{
				mysql_query("DELETE FROM ct2_os_todo_v WHERE id = '".$row['id']."' ") or die( mysql_error() );
			}
			mysql_query("DELETE FROM ct2_os_todo WHERE projet = '$projet' ") or die( mysql_error() );			

			// Suppression des traductions (propositions, étât, modèles)
			mysql_query("DELETE FROM ct2_os_trad WHERE projet = '$projet' ") or die( mysql_error() );
			mysql_query("DELETE FROM ct2_os_trad_prop WHERE idprojet = '$projet' ") or die( mysql_error() );
			mysql_query("DELETE FROM ct2_os_trad_state WHERE idprojet = '$projet' ") or die( mysql_error() );
			mysql_query("DELETE FROM ct2_os_trad_tem WHERE idprojet = '$projet' ") or die( mysql_error() );
	
			// Suppression des pages de wiki (fermées)
			$delete = mysql_query("SELECT id FROM ct2_os_wiki WHERE projet = '$projet' ") or die( mysql_error() );
			while($row = mysql_fetch_array($delete))
			{
				mysql_query("DELETE FROM ct2_os_wiki_lock WHERE idpage = '".$row['id']."' AND idprojet = '$projet' ") or die( mysql_error() );
			}
			mysql_query("DELETE FROM ct2_os_wiki WHERE projet = '$projet' ") or die( mysql_error() );		

			// Redirection pour suppression définitive
			Header('Location: osverif20.php?id='.$projet.'&adresse='.$adresse);

		}
		else
		{
			exit('Error.');
		}

	}

}
else
{
	exit('Error.');
}
?>