<div id="c-console" style="background-color:#e9e9eb; padding:15px; margin-top:25px;"> <a href="./admin-shop.php" class="btn" style="text-decoration:none;">Retour</a> <table style="margin-top:15px;margin-bottom:15px;width:100%; padding:15px;border:1px solid #9da3a6; border-radius:5px; background-color:#fff;"> <tr style="padding:5px;font-size:1.2em;"> <td style="width:60%;">Nom de l'article</td> <td>Acheteur</td> <td>Prix</td> </tr> <?php $db = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password); $sql = "SELECT * FROM `web_shop_history_2` ORDER BY `date` DESC"; $req = $db->prepare($sql); $req->execute(); $req->setFetchMode(PDO::FETCH_ASSOC); while ($row = $req->fetch()) { echo '<form action="admin-shop-remove.php" method="POST">'; echo '<input type="hidden" name="update_id" value="' . $row['id'] . '";'; echo '<tr style="padding:5px;">'; echo '<td>' . utf8_decode(stripslashes($row['name'])) . ''; echo '<td>' . $dev->getName(utf8_decode(stripslashes($row['uuid']))) . '</td>'; echo '<td>' . $row['price'] . '€</td>'; echo '</tr>'; echo '</form>'; } ?> </table> </div> </body> </html>
array_push($asked, $row); } else { array_push($friends, $row); } } } switch ($source) { case 'web': if (count($asked) > 0) { echo '<div id="title">- Demandes -</div>'; foreach ($asked as $row) { $img = file_exists('../../uploads/avatars/' . $row['uuid2'] . '.png') ? '<img src="../../uploads/avatars/' . $row['uuid2'] . '.png" id="img_avatar"/>' : '<img src="../../uploads/avatars/default.png" id="img_avatar"/>'; echo '<div id="friend"> <div id="friend_avatar">' . $img . '</div> <div id="friend_container"> <div id="name">' . $dev->getName($row['uuid2']) . '</div> <div id="status"> <div id="button" style="float:left;margin-right:10px;height:16px;width:45px;font-size:0.8em;" onClick="confirmFriendShip(' . $row['uuid1'] . ',' . $row['uuid2'] . ');">Accepter</div> <div id="button" style="float:left;margin-right:10px;height:16px;width:45px;font-size:0.8em;" onClick="un_confirmFriendShip(' . $row['uuid1'] . ',' . $row['uuid2'] . ');">Refuser</div> </div> <div style="clear:both;"></div> </div> </div>'; } } if (count($friends) > 0) { echo '<div id="title">- Amis -</div>'; foreach ($friends as $row) { $img = file_exists('../../uploads/avatars/' . $row['uuid2'] . '.png') ? '<img src="../../uploads/avatars/' . $row['uuid2'] . '.png" id="img_avatar"/>' : '<img src="../../uploads/avatars/default.png" id="img_avatar"/>'; $ip = $json->call('players.name', array($dev->getName($row['uuid2'])))[0]['success']['ip']; $online = $ip == 'offline' ? '<span style="color:red;">Déconnecté.</span>' : '<span style="color:green;">Connecté.</span>';
<div id="containermid"></div> <div id="container1"> <table style="width:100%;"> <?php $db = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password); $sql = "SELECT * FROM `web_task` ORDER BY `task_level` DESC"; $req = $db->prepare($sql); $req->execute(); $req->setFetchMode(PDO::FETCH_ASSOC); while ($row = $req->fetch()) { echo '<div class="cnt">'; echo '<div id="title">' . utf8_encode(stripslashes($row['task_name'])) . '</div>'; echo '<div id="status">' . getTranslation($row['task_level'] . "_tlevel") . '</div>'; echo '<div style="clear:both;"></div>'; echo '<div id="more">'; echo '<div id="creator">Tache créée par : ' . $dev->getName($row['uuid_creator']) . '</div>'; echo '<div id="date">' . dateFR($row['date_created']) . '</div>'; echo '<div style="clear:both;"></div>'; echo '</br>'; echo '<div id="desc">' . getHTMLfromBB($row['task_desc']) . '</div>'; echo '</div>'; echo '</div>'; } ?> </table> </div> <div id="container2"></div> </div> </div> </body> </html>
die("error"); } $req = $db->prepare($sql_req); $req->execute(); $req->setFetchMode(PDO::FETCH_ASSOC); if ($req->rowCount() > 0) { while ($row = $req->fetch()) { echo '<div id="news"> <div id="date"> <div id="month">' . getMonth($row["date"]) . '</div> <div id="day">' . getDay($row["date"]) . '</div> </div> <div id="header">' . stripslashes(utf8_encode($row["title"])) . '</div> <div id="content"> <div id="detail"> <div style="float:left;">Par <a id="link" href="/profiles/?id=' . $row["uuid_author"] . '">' . $dev->getName($row["uuid_author"]) . '</a></div>'; $db_2 = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password); $sql_2 = "SELECT * FROM web_news_comments WHERE `news_id`= " . $row['id'] . ";"; $req_res = $db_2->prepare($sql_2); $req_res->execute(); $req_res->setFetchMode(PDO::FETCH_ASSOC); echo '<div class="clearfix"></div> </div></br> ' . utf8_encode(getHTMLfromBB($row["content"])) . ' </div> </div>'; } } else { ?> <div id="news"> <div id="header">cette news n'existe pas</div>
} echo '</div> <table style="width:100%; margin:5px; margin-bottom:10px;"> <tr> <td style="width:12%; vertical-align:top;"> <div id="profileholder"> <div id="avatar">'; if (file_exists('../uploads/avatars/' . $key['uuid_author'] . '.png')) { echo '<img src="../uploads/avatars/' . $key['uuid_author'] . '.png" style="width:90%; margin:2.5%;"/>'; } else { echo '<img src="../uploads/avatars/default.png" style="width:90%; margin:2.5%;"/>'; } echo ' </div> <div id="user"> <span id="username" onClick="window.location.href=`../profiles/?id=' . $key['uuid_author'] . '`">' . utf8_encode($dev->getName($key['uuid_author'])) . '</span></br> <span id="rank">' . getTranslation($dev->getAdminLevel($key['uuid_author']) . '_level') . '</span> </div> <div id="desc"> <div id="row">Posté à ' . getTime($key['date_written']) . ' le ' . getDate2($key['date_written']) . '</div> </div> </div> </td> <td style="vertical-align:top; padding:10px;padding-top:0;"> ' . getHTMLfromBB(utf8_encode(stripslashes($key['content']))) . ' </td> </tr> </table> </div>'; } }
<div id="c-console" style="background-color:#e9e9eb; padding:15px; margin-top:25px;"> <a href="./admin-news-add.php" class="btn" style="text-decoration:none;">Ajouter une news</a> </br> <table style="margin-bottom:15px;width:100%; padding:15px;border:1px solid #9da3a6; border-radius:5px; background-color:#fff;margin-top:15px;"> <tr style="padding:5px;font-size:1.2em;"> <td style="width:65%;">Titre</td> <td>Auteur</td> <td>Supprimer</td> </tr> <?php $db = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password); $sql = "SELECT * FROM web_news ORDER BY `date` DESC"; $req = $db->prepare($sql); $req->execute(); $req->setFetchMode(PDO::FETCH_ASSOC); while ($row = $req->fetch()) { echo '<form action="admin-news-remove.php" method="POST">'; echo '<input type="hidden" name="news_id" value="' . $row['id'] . '";'; echo '<tr style="padding:5px;">'; echo '<td>' . stripslashes($row['title']) . '</td>'; echo '<td>' . $dev->getName($row['uuid_author']) . '</td>'; echo '<td style="line-height:10px;"><input type="submit" Value="Supprimer" class="btn" name="delete" /></td>'; echo '</tr>'; echo '</form>'; } ?> </table> </div> </body> </html>
$sql_req = "SELECT * FROM `web_news` ORDER BY `date` DESC LIMIT 5"; } $req = $db->prepare($sql_req); $req->execute(); $req->setFetchMode(PDO::FETCH_ASSOC); if ($req->rowCount() > 0) { while ($row = $req->fetch()) { echo '<div id="news"> <div id="date"> <div id="month">' . getMonth($row["date"]) . '</div> <div id="day">' . getDay($row["date"]) . '</div> </div> <div id="header">' . stripslashes(utf8_encode($row["title"])) . '</div> <div id="content"> <div id="detail"> <div style="float:left;">Par <a id="link" href="/profiles/?id=' . $row["uuid_author"] . '">' . $dev->getName($row["uuid_author"]) . '</a></div>'; $db_2 = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password); $sql_2 = "SELECT * FROM web_news_comments WHERE `news_id`= " . $row['id'] . ";"; $req_res = $db_2->prepare($sql_2); $req_res->execute(); $req_res->setFetchMode(PDO::FETCH_ASSOC); echo '<div style="float:right;"><a id="link" href="news.php?id=' . $row['id'] . '">' . $req_res->rowCount() . ' Commentaires</a></div> <div class="clearfix"></div> </div></br> ' . utf8_encode(getHTMLfromBB($row["content"])) . ' </div> </div>'; } } else { ?> <div id="news">