public function addServer() { if ($this->validateFields()) { try { $query = new \Classes\MinecraftServerPing($this->ip_address, $this->port); $info = $query->Query(); } catch (\Classes\MinecraftPingException $e) { $this->data['error'][] = 'За да бъде записан,сървърът трябва да е ОНЛАЙН.'; return false; } $sql = 'SELECT server_id FROM servers WHERE ip_address=? AND port=?'; $sth = $this->db->prepare($sql); $sth->execute(array($this->ip_address, $this->port)); if ($sth->rowCount() != 0) { $this->data['error'][] = 'Има вече сървър с такова IP:Port'; return false; } else { if ($this->server_name == null) { $this->server_name = $info['motd']; } $sql = 'INSERT INTO servers (ip_address,port,motd,description,tags,user_id,youtubevid,favicon,website,players,maxplayers,status) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)'; $sth = $this->db->prepare($sql); $user_id = \Frame\Application::getInstance()->getSession()->user_info['user_id']; $sth->execute(array($this->ip_address, $this->port, $this->server_name, $this->description, $this->tags, $user_id, $this->youtubeVideo, $info['favicon'], $this->website, $info['players'], $info['maxplayers'], $info['status'])); $id = $this->db->lastInsertId(); $this->data['message'][] = "Благодарим ви за добавянето на сървъра"; $this->data['message'][] = 'Страница на сървъра: <a href="' . URL . $id . '-' . \Classes\Common::createSlug($this->server_name) . '">ТУК</a>'; } } else { return false; } }
<a class="button" style="width:120px;height:22px;font-size: 16px" href="<?php echo URL . 'vote/' . $this->data['server_info']['server_id']; ?> ">Гласувай</a> </div> </div> <div id="tab5" class="tab"><span class="tab-h">Server Baner</span> <img alt="Server Baner" style="display:block;margin-left: 5px;" src="<?php echo URL . $this->data['server_info']['server_id'] . '-' . \Classes\Common::createSlug($this->data['server_info']['motd']) . '.png'; ?> "> <textarea style="margin-top:15px;width: 700px;height:100px;font-size:15px;" onClick="this.select()" readonly="readonly" ><a href="<?php echo URL . $this->data['server_info']['server_id'] . '-' . \Classes\Common::createSlug($this->data['server_info']['motd']) . '.png'; ?> " title="<?php echo $this->data['title']; ?> " target="_blank"><img alt="Server baner" src="<?php echo URL . $this->data['server_info']['server_id'] . '.png'; ?> " /></a></textarea> </div> </div> <?php $this->script = <<<EOT <script> \$(document).ready(function() {
public function json() { if ($_POST) { header('Content-Type: application/json'); // escape your parameters to prevent sql injection $param = $_POST['term']; $options = array(); // fetch a title for a better user experience maybe.. $sth = $this->db->prepare("SELECT motd,server_id FROM servers\n\n WHERE motd LIKE CONCAT('%' , ? , '%') ORDER BY status DESC,server_id DESC"); $sth->execute(array($param)); $servers = $sth->fetchAll(); for ($i = 0; $i < count($servers); $i++) { $servers[$i]['slug'] = \Classes\Common::createSlug($servers[$i]['motd']); } echo json_encode($servers); } else { header('Location:' . URL . 'error'); } }
echo $name; ?> " width="32" height="32" alt="<?php echo $row['motd']; ?> " src="<?php echo URL; ?> server/image/<?php echo $row["server_id"]; ?> "></p></td> <td><a class="zag" href="<?php echo URL; echo $row["server_id"] . '-' . \Classes\Common::createSlug($name); ?> "> <?php echo $name; ?> </a><br><p class="podzag"><?php echo $host . $port; ?> </p> </td> <td style="width: 90px;text-align: center;" class="players<?php echo $row["server_id"]; ?> "><p class="tdp"><?php echo $row["players"] . '/ ' . $row["maxplayers"]; ?>