5 private $config_file = '/etc/mud.ini';
8 public function __construct() {
9 $config = parse_ini_file($this->config_file
, true);
10 $this->db
= new mysqli(
11 $config['database']['domain'],
12 $config['database']['user'],
13 $config['database']['password'],
14 $config['database']['database']);
15 if (mysqli_connect_errno()) {
16 echo "Problem connecting to database: ";
17 echo mysqli_connect_error();
22 public function query() {
23 $args = func_get_args();
24 $statement = $this->db
->prepare(array_shift($args));
25 if ($args) call_user_func_array(array($statement, 'bind_param'), &$args);
26 $statement->execute();
27 $statement->store_result();
28 $statement->store_result();
29 $data = $statement->result_metadata();
30 $return = $row = $fields = array();
31 $fields[0] = &$statement;
32 while($field = $data->fetch_field())
33 $fields[] = &$row[$field->name
];
34 call_user_func_array("mysqli_stmt_bind_result", $fields);
36 while ($statement->fetch()) {
37 foreach ($row as $key=>$value) $return[$i][$key] = $value;
40 $statement->free_result();
44 public function insert() {
45 $args = func_get_args();
46 $statement = $this->db
->prepare(array_shift($args));
47 call_user_func_array(array($statement, 'bind_param'), &$args);
48 $statement->execute();
49 return $this->db
->insert_id
;
52 public function update() {
53 $args = func_get_args();
54 $statement = $this->db
->prepare(array_shift($args));
55 call_user_func_array(array($statement, 'bind_param'), &$args);
56 $statement->execute();
57 return $this->db
->insert_id
;
65 public $rooms = array();
67 public function __construct($db) {
68 $rooms = $db->query('SELECT id,x,y,state FROM rooms');
70 foreach ($rooms as $room) {
71 $this->rooms
[$room['x']][$room['y']] =
72 array('id' => $room['id'], 'state' => $room['state']);
75 $sql = 'INSERT INTO rooms (x,y,state) VALUES(?,?,?)';
77 for ($x = 0; $x < $this->columns
; $x++
) {
79 for ($y = 0; $y < $this->rows
; $y++
) {
80 $state = (rand(0, 9) < 2 ?
true : false);
81 $id = $db->insert($sql, $types, $x, $y, $state);
82 $this->rooms
[$x][$y] =
83 array('id' => $id, 'state' => $state);
89 public function serialize() {
91 for ($x = 0; $x < $this->columns
; $x++
) {
92 for ($y = 0; $y < $this->rows
; $y++
) {
93 $serial[$x][$y] = $this->rooms
[$x][$y]['state'];
109 public function __construct($db) {
110 $player = $db->query(
111 'SELECT players.id, players.name, players.room, rooms.x, rooms.y'
112 . ' FROM players LEFT JOIN rooms ON players.room = rooms.id'
113 . ' WHERE players.id = ?',
116 $player = $player[0];
117 $this->id
= $player['id'];
118 $this->name
= $player['name'];
119 $this->room
= $player['room'];
120 $this->x
= $player['x'];
121 $this->y
= $player['y'];
126 class mud
extends model
{
130 public function __construct() {
131 parent
::__construct();
133 $this->universe
= new universe($this);
136 private function join() {
139 $x = rand(0, count($this->universe
->rooms
)-1);
140 $y = rand(0, count($this->universe
->rooms
[0])-1);
141 } while ($this->universe
->rooms
[$x][$y]['state']);
142 $id = $this->insert('INSERT INTO players (name,room) VALUES(?,?)',
143 'si', $_GET['name'], $this->universe
->rooms
[$x][$y]['id']);
144 $_SESSION['id'] = $id;
145 //$others = $this->query('SELECT id, room FROM players WHERE id != ?', 'i', $this->player->id);
146 return array('x' => $x, 'y' => $y, 'id' => $id, 'poll' => $this->poll());
149 private function yell($msg) {
151 $this->error('400', 'expected `msg` field');
155 'INSERT INTO messages (message,type,room,source) VALUES(?,?,?,?)',
156 'ssii', $msg, 'yell', $this->player
->room
, $this->player
->id
);
159 private function say($msg) {
161 $this->error('400', 'expected `dest` field');
165 'INSERT INTO messages (message,type,room,source) VALUES(?,?,?,?)',
166 'ssii', $msg, 'say', $this->player
->room
, $this->player
->id
);
169 private function tell($dest, $msg) {
170 if (!$dest ||
!$msg) {
171 $this->error('400', 'expected `dest` and `msg` fields');
174 $player = $this->query('SELECT id FROM players where name = ?', 's', $dest);
175 if (!($player && $player['id'])) {
176 $this->error('400', "could not find a player with `name` == $dest");
180 'INSERT INTO messages (message,type,destination,source) VALUES(?,?,?,?)',
181 'ssii', $msg, 'say', $player['id'], $this->player
->id
);
184 private function move($direction) {
186 'north' => array('x' => $this->player
->x
, 'y' => $this->player
->y
-1),
187 'east' => array('x' => $this->player
->x+
1, 'y' => $this->player
->y
),
188 'south' => array('x' => $this->player
->x
, 'y' => $this->player
->y+
1),
189 'west' => array('x' => $this->player
->x
-1, 'y' => $this->player
->y
),
191 if ($directions[$direction]) {
192 $rooms = $this->query(
193 'SELECT id, state, description FROM rooms WHERE x = ? and y = ?',
194 'ii', $directions[$direction]['x'], $directions[$direction]['y']);
195 if ($rooms[0] && !$rooms[0]['state']) {
196 $this->update('UPDATE players SET room = ? WHERE players.id = ?',
197 'si', $rooms[0]['id'], $this->player
->id
);
198 return array('description' => $rooms[0]['description']);
200 $this->error(403, 'your path is blocked');
203 $this->error(400, 'expected `direction` field with value {north|east|south|west}');
206 private function poll() {
207 $time = isset($_SESSION['last_polled']) ?
$_SESSION['last_polled'] : 0;
208 $messages = $this->query(
209 'SELECT message, type, name, sent, players.id FROM messages LEFT JOIN players'
210 . ' ON destination = players.id'
211 . ' OR source = players.id'
212 . ' WHERE TIMESTAMPDIFF(MINUTE, sent, NOW()) < 5'
213 . ' AND UNIX_TIMESTAMP(sent) >= ?'
214 . ' AND (type = "yell"'
215 . ' OR (type = "tell" AND destination = ?)'
216 . ' OR (type = "say" AND messages.room = ?))',
217 'iii', $time, $this->player
->id
, $this->player
->room
);
218 $players = $this->query(
219 'SELECT players.id, name, x ,y '
220 . 'FROM players JOIN rooms '
221 . 'ON players.room = rooms.id');
222 $_SESSION['last_polled'] = time();
223 return array('messages' => $messages, 'players' => $players);
226 public function response($content) {
227 header('Content-Type: application/json');
228 echo json_encode($content);
231 public function command($cmd) {
233 $this->error(400, 'Missing command: expected `cmd` field');
234 if ($_GET['cmd'] != 'join' && $_GET['cmd'] != 'start' && !isset($_SESSION['id']))
235 $this->error(401, 'Missing user ID: please join first');
236 if (isset($_SESSION['id'])) $this->player
= new player($this);
239 $this->response($this->universe
->serialize());
242 $this->response($this->join());
245 $this->response($this->move($_GET['direction']));
248 $this->tell($_GET['msg']);
251 $this->yell($_GET['msg']);
254 $this->say($_GET['dest'], $_GET['msg']);
260 echo json_encode($this->poll());
263 $this->error(400, 'Unknown command');
267 private function error($status, $msg) {
268 header("HTTP/1.0 $status");
275 $mud->command($_GET['cmd']);