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, 'name' => $name);
149 private function yell($msg) {
151 'INSERT INTO messages (message,type,room,source) VALUES(?,?,?,?)',
152 'ssii', $msg, 'yell', $this->player
->room
, $this->player
->id
);
155 private function say($msg) {
157 'INSERT INTO messages (message,type,room,source) VALUES(?,?,?,?)',
158 'ssii', $msg, 'say', $this->player
->room
, $this->player
->id
);
161 private function move() {
164 private function poll() {
165 $time = isset($_SESSION['last_polled']) ?
$_SESSION['last_polled'] : 0;
166 $messages = $this->query(
167 'SELECT message, type, name, sent, players.id FROM messages LEFT JOIN players'
168 . ' ON destination = players.id'
169 . ' OR source = players.id'
170 . ' WHERE TIMESTAMPDIFF(MINUTE, sent, NOW()) < 5'
171 . ' AND UNIX_TIMESTAMP(sent) >= ?'
172 . ' AND (type = "yell"'
173 . ' OR (type = "tell" AND destination = ?)'
174 . ' OR (type = "say" AND messages.room = ?))',
175 'iii', $time, $this->player
->id
, $this->player
->room
);
176 $_SESSION['last_polled'] = time();
180 public function response($content) {
181 header('Content-Type: application/json');
182 echo json_encode($content);
185 public function command($cmd) {
187 $this->error(400, 'Missing command: expected `cmd` field');
188 if ($_GET['cmd'] != 'join' && $_GET['cmd'] != 'start' && !isset($_SESSION['id']))
189 $this->error(401, 'Missing user ID: please join first');
190 if (isset($_SESSION['id'])) $this->player
= new player($this);
193 $this->response($this->universe
->serialize());
196 $this->response($this->join());
199 $this->response(array('valid' => $this->move()));
205 $this->yell($_GET['msg']);
214 echo json_encode($this->poll());
217 $this->error(400, 'Unknown command');
221 private function error($status, $msg) {
222 header("HTTP/1.0 $status");
229 $mud->command($_GET['cmd']);