# 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(dirname(__FILE__).'/include/config.inc.php');
if(isset($_GET['zid'])) {
require(dirname(__FILE__).'/include/members.inc.php');
$numero = $_GET['zid'];
if (IsProjectAdmin()) {
if (@$_GET['action'] == "ok")
{
$titre = harmonise_magic_quotes_gpc(addslashes(utf8_decode($_POST['version'])));
$id = $_GET['id'];
$projet = $_GET['p'];
if($titre == "")
{
mysql_query("DELETE FROM ct2_os_todo_v WHERE id = '$id' AND projet = '$projet' ") or die (mysql_error());
}
else
{
$testingreq = mysql_query("SELECT * FROM ct2_os_todo_v WHERE projet = '$projet' AND id = '$id' ");
if (mysql_num_rows($testingreq) == 0)
{
mysql_query("INSERT INTO ct2_os_todo_v (id,version,projet) VALUES ('$id','$titre','$projet') ") or die (mysql_error());
}
elseif (mysql_num_rows($testingreq) == 1)
{
mysql_query("UPDATE ct2_os_todo_v SET version = '$titre' WHERE id = '$id' AND projet = '$projet' ") or die (mysql_error());
}
}
}
elseif($_POST['typedeformulaire'] == "todolist") {
$id = $_GET['id'];
$titre = harmonise_magic_quotes_gpc(addslashes(utf8_decode($_POST['titre'])));
mysql_query("INSERT INTO ct2_os_todo (projet,etat,description) VALUES ('$id','0','$titre') ") or die (mysql_error());
mysql_insert_id();
}
Header('Location: '.$_GET['p'].'-todo_'.$ct_lang.'.html');
} else { exit('Error'); }
}
$code = $_GET['p'];
$ma = mysql_query("SELECT * FROM ct2_os WHERE adresse = '$code' ");
if (mysql_num_rows($ma) == 0) {
require('include/erreurs.inc.php');
GenerateErrorPage ("404","Not Found",$txt);
exit();
}
$ma = mysql_query("SELECT * FROM ct2_os WHERE adresse = '$code' ");
$mb = mysql_fetch_array($ma);
$titre = $mb['titre'];
$desc = $mb['description'];
$numero = $mb['id'];
$cadreonecat = "os";
$ct_title = utf8_encode(htmlspecialchars($titre)). ' - CodingTeam.net : '.CODINGTEAM_GAUCHE_24;
require(dirname(__FILE__).'/prepend.core.php'); ?>
-
".CODINGTEAM_PROJETLIBRE_131."";
$abc=0;
$select_lalala = mysql_query("SELECT * FROM ct2_os_todo WHERE projet = '$numero' ORDER BY etat ASC") or die (mysql_error());
while($rowz = mysql_fetch_array($select_lalala))
{
$abc=$abc+1;
echo "
# ".$abc."
".utf8_encode(htmlspecialchars($rowz['description']))." (";
if ($rowz['etat'] == 2)
{
echo "".CODINGTEAM_PROJETLIBRE_128."";
}
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_129."";
}
if ($rowz['etat'] != 2 && $rowz['etat'] != 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."";
}
echo ")
";
}
}
else
{
$u = 0;
while($rz = mysql_fetch_array($stock))
{
$version[$u] = utf8_encode(htmlspecialchars($rz['version']));
$u++;
}
echo "".CODINGTEAM_PROJETLIBRE_131."
";
$abc=0;
$select_lalala = mysql_query("SELECT * FROM ct2_os_todo WHERE projet = '$numero' ORDER BY etat ASC") or die (mysql_error());
while($rowz = mysql_fetch_array($select_lalala))
{
$v = $rowz['id'];
$stockb = mysql_query("SELECT * FROM ct2_os_todo_v WHERE projet = '$code' AND id = '$v' ");
if(mysql_num_rows($stockb) == 0)
{
$abc=$abc+1;
echo "# ".$abc."
".utf8_encode(htmlspecialchars($rowz['description']))." (";
if ($rowz['etat'] == 2)
{
echo "".CODINGTEAM_PROJETLIBRE_128."";
}
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_129."";
}
if ($rowz['etat'] != 2 && $rowz['etat'] != 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."";
}
echo ")
";
}
}
echo "
";
for ($a=0; $a < $u; $a++)
{
echo "".$version[$a]."
";
$v = $version[$a];
$abc=0;
$stocka = mysql_query("SELECT * FROM ct2_os_todo_v WHERE projet = '$code' AND version = '$v' ");
while($ro= mysql_fetch_array($stocka))
{
$to = $ro['id'];
$select_lalala = mysql_query("SELECT * FROM ct2_os_todo WHERE id = '$to' ORDER BY etat ASC") or die (mysql_error());
while($rowz = mysql_fetch_array($select_lalala))
{
$abc++;
echo "# ".$abc."
".utf8_encode(htmlspecialchars($rowz['description']))." (";
if ($rowz['etat'] == 2)
{
echo "".CODINGTEAM_PROJETLIBRE_128."";
}
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_129."";
}
if ($rowz['etat'] != 2 && $rowz['etat'] != 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."";
}
echo ")
";
}
}
echo "
";
}
}
?>
# ".$abc." ".utf8_encode(htmlspecialchars($rowz['description']))."
";
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."
";
}
else
{
echo "".CODINGTEAM_PROJETLIBRE_129."
";
echo "".CODINGTEAM_PROJETLIBRE_128."
";
echo "".CODINGTEAM_PROJETLIBRE_30."
";
echo CODINGTEAM_PROJETLIBRE_132."
";
?>
";
}
}
}
else ///////// AFFICHAGE DE LA TODO LIST POUR LES VISITEURS
{
$stock = mysql_query("SELECT * FROM ct2_os_todo_v WHERE projet = '$code' GROUP BY version ORDER BY version ASC");
if (mysql_num_rows($stock) == 0)
{
$abc=0;
$select_lalala = mysql_query("SELECT * FROM ct2_os_todo WHERE projet = '$numero' ORDER BY etat ASC") or die (mysql_error());
while($rowz = mysql_fetch_array($select_lalala))
{
$abc=$abc+1;
echo "# ".$abc."
".utf8_encode(htmlspecialchars($rowz['description']))." (";
if ($rowz['etat'] == 2)
{
echo "".CODINGTEAM_PROJETLIBRE_128."";
}
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_129."";
}
if ($rowz['etat'] != 2 && $rowz['etat'] != 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."";
}
echo ")
";
}
}
else
{
$u = 0;
while($rz = mysql_fetch_array($stock))
{
$version[$u] = utf8_encode(htmlspecialchars($rz['version']));
$u++;
}
$abc=0;
$select_lalala = mysql_query("SELECT * FROM ct2_os_todo WHERE projet = '$numero' ORDER BY etat ASC") or die (mysql_error());
while($rowz = mysql_fetch_array($select_lalala))
{
$v = $rowz['id'];
$stockb = mysql_query("SELECT * FROM ct2_os_todo_v WHERE projet = '$code' AND id = '$v' ");
if(mysql_num_rows($stockb) == 0)
{
$abc=$abc+1;
echo "# ".$abc."
".utf8_encode(htmlspecialchars($rowz['description']))." (";
if ($rowz['etat'] == 2)
{
echo "".CODINGTEAM_PROJETLIBRE_128."";
}
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_129."";
}
if ($rowz['etat'] != 2 && $rowz['etat'] != 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."";
}
echo ")
";
}
}
echo "
";
for ($a=0; $a < $u; $a++)
{
echo "".$version[$a]."
";
$v = $version[$a];
$abc=0;
$stocka = mysql_query("SELECT * FROM ct2_os_todo_v WHERE projet = '$code' AND version = '$v' ");
while($ro= mysql_fetch_array($stocka))
{
$to = $ro['id'];
$select_lalala = mysql_query("SELECT * FROM ct2_os_todo WHERE id = '$to' ORDER BY etat ASC") or die (mysql_error());
while($rowz = mysql_fetch_array($select_lalala))
{
$abc++;
echo "# ".$abc."
".utf8_encode(htmlspecialchars($rowz['description']))." (";
if ($rowz['etat'] == 2)
{
echo "".CODINGTEAM_PROJETLIBRE_128."";
}
if ($rowz['etat'] == 1)
{
echo "".CODINGTEAM_PROJETLIBRE_129."";
}
if ($rowz['etat'] != 2 && $rowz['etat'] != 1)
{
echo "".CODINGTEAM_PROJETLIBRE_130."";
}
echo ")
";
}
}
echo "
";
}
}
}
?>