1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
| <?php
include "../db.php";
session_start();
$con = new DBConnect();
if (@$_SESSION["ok"] != 1) {
$sql= "SELECT * FROM `user` WHERE `nom` = '".@$_POST["nom"]."' AND `pass` = '".@ $_POST["pass"]."'";
$res = $con->sendSql($sql);
$nres = mysql_num_rows($res);
if ($nres == 1) {
$_SESSION["ok"] = 1;
$_SESSION["user"] = mysql_fetch_array($res, MYSQL_ASSOC);
}else{
include "securite.php";
exit;
}
}
if ($_SESSION["user"]["droits"][0] == 1) {
echo '<A href="listmeetings.php?action=add">Ajouter une inscription</A></br>';
echo '<A href="listmeetings.php">Retour aux inscriptions</A></br></br>';
}
if (@$_GET["action"] == "del") { // on efface
$sql = "DELETE FROM `inscript` WHERE ID = ".$_GET["id"];
$con->sendSql($sql);
}
if (@$_GET["action"] == "add") {
$action = "addExec";
include "formmeetings.php";
}
if (@$_POST["action"] == "addExec") {
foreach($_POST as $k => $v){
$p[$k] = addslashes($v);
}
?><?
$sql = "INSERT INTO `inscript` (`randoVTT`, `randoVTTnoms`, `familleVTT`, `familleVTTnoms`, `coursemoins12`, `coursemoins12noms`, `courseplus12`, `courseplus12noms`, `courseVTT10a15`, `courseVTT10a15noms`, `conference`, `nbpersonnes`, `conferencenoms`, `volontaires`, `volontairesnoms`, `adresse`, `ville`, `telephone`, `mail`, `Divers`)
VALUES ( '".$p["randoVTT"]."', '".$p["randoVTTnoms"]."', '".$p["familleVTT"]."', '".$p["familleVTTnoms"]."', '".$p["coursemoins12"]."', '".$p["coursemoins12noms"]."', '".$p["courseplus12"]."', '".$p["courseplus12noms"]."', '".$p["courseVTT10a15"]."', '".$p["courseVTT10a15noms"]."', '".$p["conference"]."', '".$p["nbpersonnes"]."', '".$p["conferencenoms"]."', '".$p["volontaires"]."', '".$p["volontairesnoms"]."', '".$p["adresse"]."', '".$p["ville"]."', '".$p["telephone"]."', '".$p["mail"]."', '".$p["Divers"]."')";
$con->sendSql($sql);
}
if (@$_GET["action"] == "edit") {
$sql ="SELECT * FROM `inscript` WHERE `ID` =".$_GET["id"];
$res = $con->sendSql($sql);
$row = mysql_fetch_array($res, MYSQL_ASSOC);
$action = "editExec";
include "formmeetings.php";
}
if (@$_POST["action"] == "editExec") {
foreach($_POST as $k => $v){
$p[$k] = addslashes($v);
}
$sql = "UPDATE `inscript` SET
`randoVTT` = '".$p["randoVTT"]."',
`randoVTTnoms` = '".$p["randoVTTnoms"]."',
`familleVTT` = '".$p["familleVTT"]."',
`familleVTTnoms` = '".$p["familleVTTnoms"]."',
`coursemoins12` = '".$p["coursemoins12"]."',
`courseplus12` = '".$p["courseplus12"]."',
`courseplus12noms` = '".$p["courseplus12noms"]."',
`courseVTT10a15` = '".$p["courseVTT10a15"]."',
`courseVTT10a15noms` = '".$p["courseVTT10a15noms"]."',
`conference` = '".$p["conference"]."',
`nbpersonnes` = '".$p["nbpersonnes"]."',
`conferencenoms` = '".$p["conferencenoms"]."',
`volontaires` = '".$p["volontaires"]."',
`volontairesnoms` = '".$p["volontairesnoms"]."',
`adresse` = '".$p["adresse"]."',
`ville` = '".$p["ville"]."',
`telephone` = '".$p["telephone"]."',
`mail` = '".$p["mail"]."',
`Divers` = '".$p["Divers"]."'
WHERE `ID` = ".$p["id"]." LIMIT 1;";
$con->sendSql($sql);
}?><p><strong>Randonnée à VTT</strong></p><?
$sql = "SELECT * FROM `inscript` WHERE `randoVTT` LIKE \"randoVTT\" ORDER BY `randoVTTnoms` ASC";
$res = $con->sendSql($sql);
echo '';
while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {
?>
<body bgcolor="">
<tr><?=stripslashes($row["randoVTTnoms"])?></br>
<font color="#999999"><?=stripslashes($row["adresse"])?> ; <?=stripslashes($row["ville"])?> ; <?=stripslashes($row["telephone"])?> ; <?=stripslashes($row["mail"])?> ; <?=stripslashes($row["divers"])?></font>  //
<?
//ajouter, editer, effacer
?>
<?
if ($_SESSION["user"]["droits"][1] == 1) {
echo '<A href="listmeetings.php?action=edit&id='.$row["id"].'">Editer</A> ';
}
if ($_SESSION["user"]["droits"][2] == 1) {
echo '<A href="listmeetings.php?action=del&id='.$row["id"].'">Supprimer</A>';
}
?></br></br>
<?
}
?>
<p><strong>Course relais familiale VTT / Course à pied</strong></p><?
$sql1 = "SELECT * FROM `inscript` WHERE `familleVTT` LIKE \"familleVTT\" ORDER BY `familleVTTnoms` ASC";
$res1 = $con->sendSql($sql1);
echo '';
while ($row1 = mysql_fetch_array($res1, MYSQL_ASSOC)) {
?>
<body bgcolor="">
<tr><?=stripslashes($row1["familleVTTnoms"])?></br><font color="#999999"><?=stripslashes($row1["adresse"])?> ; <?=stripslashes($row1["ville"])?> ; <?=stripslashes($row1["telephone"])?> ; <?=stripslashes($row1["mail"])?> ; <?=stripslashes($row1["divers"])?></font>  //
<?
//ajouter, editer, effacer
?>
<?
if ($_SESSION["user"]["droits"][1] == 1) {
echo '<A href="listmeetings.php?action=edit&id='.$row1["id"].'">Editer</A> ';
}
if ($_SESSION["user"]["droits"][2] == 1) {
echo '<A href="listmeetings.php?action=del&id='.$row1["id"].'">Supprimer</A>';
}
?></br></br>
<?
}
?>
<p><strong>Course à pied enfants garçons et filles – jusqu’à 12 ans</strong></p><?
$sql2 = "SELECT * FROM `inscript` WHERE `coursemoins12` LIKE \"coursemoins12\" ORDER BY `coursemoins12noms` ASC";
$res2 = $con->sendSql($sql2);
echo '';
while ($row2 = mysql_fetch_array($res2, MYSQL_ASSOC)) {
?>
<body bgcolor="">
<tr><?=stripslashes($row2["coursemoins12noms"])?></br><font color="#999999"><?=stripslashes($row2["adresse"])?> ; <?=stripslashes($row2["ville"])?> ; <?=stripslashes($row2["telephone"])?> ; <?=stripslashes($row2["mail"])?> ; <?=stripslashes($row2["divers"])?></font>  //
<?
//ajouter, editer, effacer
?>
<?
if ($_SESSION["user"]["droits"][1] == 1) {
echo '<A href="listmeetings.php?action=edit&id='.$row2["id"].'">Editer</A> ';
}
if ($_SESSION["user"]["droits"][2] == 1) {
echo '<A href="listmeetings.php?action=del&id='.$row2["id"].'">Supprimer</A>';
}
?></br></br>
<?
}
?>
</table>
<?
@$con->Uconn();
?> |
