<?php function maxlevel($x, $y) { $query = "select * from participer p where idpersonne='{$x}' and quete={$y} and where niv=(select max(n.id) from niveau n where n.queteid={$y}) ;"; $mysqli = new mysqli("localhost", "root", "", "greenapp"); if ($mysqli->query($query)) { return 1; } else { return 0; } } if (isset($_COOKIE['email']) && isset($_COOKIE['qid'])) { $email = $_COOKIE['email']; $qid = $_COOKIE['qid']; if (maxlevel($email, $qid)) { header('Location:quete?qid=$qid'); } else { $query = "SELECT min(id) from niveau where queteid={$qid} and id>=(select niv from participer where idpersonne='{$email}' and quete={$qid});"; $mysqli = new mysqli("localhost", "root", "", "greenapp"); $ress = $mysqli->query($query); $r = $ress->fetch_row(); $id = $r[0]; if (!($ress = $mysqli->query("select * from niveau where queteid={$qid} and id={$id};"))) { $req = "select min(id) from niveau where queteid={$qid}"; $ress = $mysqli->query($req); $val = $ress->fetch_row(); $req = "insert into participer values('" . $_COOKIE['email'] . "',0,{$qid});"; } $ress = $mysqli->query("select * from niveau where queteid={$qid} and id={$id};"); $rx = $ress->fetch_row();
<?php if (!maxlevel($_COOKIE['email'], $_GET['qid'])) { setcookie("qid", $_GET['qid']); echo "<span><a href='nexthint.php'><img src='img/hint.png' width=150></a></span>"; } ?> </div> <div class="mid"> <img src="<?php echo $photo; ?> " width=300> </div> </div> <?php if (maxlevel($_COOKIE['email'], $_GET['qid'])) { setcookie("qid", $_GET['qid']); echo "<form method='POST' action='addcontribution.php'><input type='text' name='contri' value='Lien multimedia de votre contribution'><input type='submit'></form>"; } else { } ?> </div> </div> </div> </section> </header> <div class="overlay navigation"> <nav> <ul> <?php include_once "menu.php";