-
Notifications
You must be signed in to change notification settings - Fork 0
/
model.py
321 lines (239 loc) · 12.5 KB
/
model.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
import tables
cu = tables.cu
class Select:
def getAllPlayers(self):
cu.execute("select id from players where location > 0")
return cu.fetchall()
def getAllPlayersWithIP(self):
cu.execute("select id from players where ip_addr <> NULL")
return cu.fetchall()
def getAllPlayerNames(self):
cu.execute("select name from players where location > 0")
return cu.fetchall()
def getAllPlayersInLoc(self, where):
cu.execute("select id from players where location = ?", (where,))
return cu.fetchall()
def getPlayerInRoom(self, loc, player):
cu.execute("select id from players where name = ? and location = ?", (player, loc))
return cu.fetchone()
def getPlayerByName(self, player):
cu.execute("select id,name from players where name = ?", (player,))
return cu.fetchone()
def getPlayerByID(self, pid):
cu.execute("select id,name from players where id = ?", (pid,))
return cu.fetchone()
def getPlayerDesc(self, loc, player):
cu.execute("select id,description,location,name from players \
where name = ? and location = ?", (player, loc))
return cu.fetchone()
def getItemsOnPlayer(self, pid, item):
cu.execute("select o.name, o.description from objects o, obj_instances oi where \
o.id = oi.o_id and oi.owner = ? and o.name = ?", (pid, item))
return cu.fetchone()
def getItemsOnNpc(self, npc):
cu.execute("select oi.o_id,o.id,o.name,oi.npc_owner \
from obj_instances oi,objects where oi.o_id = o.id\
and oi.npc_owner = ?", (npc,))
return cu.fetchall()
def getNpcInRoom(self, loc, npc):
cu.execute("select ni.id from npc_instances ni where ni.location = ? and \
ni.n_id = (select id from npcs where name = ?)", (loc, npc))
return cu.fetchone()
def getItem(self, loc, item):
#cu.execute("select id,o_id from obj_instances where location=? and \
#o_id = (select id from objects where name = ?)", (loc, item))
cu.execute("select id,o_id from obj_instances where location=? and owner is NULL and \
o_id = (select id from objects where name = ?)", (loc, item))
#cu.execute("select id,o_id from obj_instances where location=? and owner=? and \
#o_id = (select id from objects where name = ?)", (loc, None, item))
#cu.execute("select id,o_id from obj_instances where location=? and owner is NULL and \
#o_id = (select id from objects where name = ?)", (loc, item))
return cu.fetchone()
def getExit(self, loc, exit):
cu.execute("select origin, dest, exit from links where origin = ? and exit = ?", (loc, exit))
return cu.fetchone()
def getHelp(self, command):
cu.execute("select command, doc from helps where command = ?", (command,))
return cu.fetchone()
def getAllHelp(self):
cu.execute("select command from helps")
return cu.fetchall()
def getInventory(self, pid):
cu.execute("select o.name from objects o, obj_instances oi where oi.owner = ? and o.id = oi.o_id", (pid,))
return cu.fetchall()
def getRoomDesc(self, loc):
cu.execute("select s_desc,l_desc from rooms where id = ?", (loc,))
return cu.fetchone()
def getRoom(self, rid):
cu.execute("select id from rooms where id = ?", (rid,))
return cu.fetchone()
def getPlayersInRoom(self, loc):
cu.execute("select name from players where location = ?", (loc,))
return cu.fetchall()
def getNpcsInRoom(self, loc, named = None):
if not named:
cu.execute("select name from npcs where id in (select n_id from npc_instances where location = ?)", (loc,))
return cu.fetchall()
else:
cu.execute("select ni.id, npcs.name, npcs.description from npc_instances ni,npcs where \
npcs.id = ni.n_id and npcs.name = ? and ni.location = ?", (named, loc))
return cu.fetchone()
def getItemsInRoom(self, loc, pid, named = None):
if not named:
#cu.execute("select o.name,oi.o_id,count(*) from objects o,obj_instances oi where o.id = oi.o_id and oi.location = ?", (loc,))
#changed to
cu.execute("select o.name, oi.o_id, count (*) from objects o, obj_instances oi where \
oi.location = ? and o.id = oi.o_id group by oi.o_id", (loc,))
return cu.fetchall()
else:
cu.execute("select o.name, o.description from objects o, obj_instances oi where \
o.id = ? and o.name = ? and oi.location = ?", (pid, named, loc))
#cu.execute("select o.name, o.description from objects o, obj_instances oi where \
#o.id = oi.o_id and o.name = ? and oi.location = ?", (pid, named, loc))
#select o.name, o.description from objects o, obj_instances oi where o.id = 1 and o.name = 'club' and oi.location = 2
return cu.fetchone()
def getExitsInRoom(self, loc):
cu.execute("select exit,id from links where origin = ?", (loc,))
return cu.fetchall()
def getBan(self, player):
cu.execute("select banned from players where name = ?", (player,))
return cu.fetchone()
def getItemInstance(self, pid, object):
cu.execute("select oi.id, o.name from obj_instances oi, objects o \
where oi.owner = ? and o.name = ? and o.id = oi.o_id", (pid, object))
return cu.fetchone()
def getBannedPlayers(self):
cu.execute("select id, name from players where banned = 1")
return cu.fetchall()
def getAllRooms(self):
cu.execute("select id, s_desc from rooms")
return cu.fetchall()
def getLink(self, id):
cu.execute("select id from links where id = ?", (id, ))
return cu.fetchone()
def getLocation(self):
cu.execute("select id,name,location,ip_addr from players where location > 0")
return cu.fetchall()
def getAllItems(self):
cu.execute("select id,name,description from objects")
return cu.fetchall()
def getItemNameId(self, item):
cu.execute("select id, name from objects where id = ? or name = ?", (item, item))
return cu.fetchone()
def getNpc(self, npc):
cu.execute("select id,name from npcs where name = ?", (npc,))
return cu.fetchone()
def getPassword(self, player):
cu.execute("select passwd,salt from players where name = ?", (player,))
return cu.fetchone()
def getIP(self, player):
cu.execute("select id,ip_addr from players where name = ?", (player,))
return cu.fetchone()
def getEmail(self, player):
cu.execute("select name,email from players where name = ?", (player,))
return cu.fetchone()
def getColors(self, player):
cu.execute("select colors from players where id = ?", (player,))
return cu.fetchone()[0]
def listObjectInstances(self):
cu.execute("select id,o_id,owner,location from obj_instances")
return cu.fetchall()
def listNpcs(self):
cu.execute("select id,name,description from npcs")
return cu.fetchall()
def listPlayers(self):
cu.execute("select id,name,email from players")
return cu.fetchall()
class Update:
def setDescription(self, pid, line):
cu.execute("update players set description = ? where id = ?", (line, pid))
return cu.rowcount
def setItemOwner(self, new_owner, obj_id):
cu.execute("update obj_instances set owner = ?, location = NULL, npc_owner = NULL where id = ?", (new_owner, obj_id))
return cu.rowcount
def setItemNpcOwner(self, new_owner, obj_id):
cu.execute("update obj_instances set npc_owner = ?, location = NULL, owner = NULL where id = ?", (new_owner, obj_id))
return cu.rowcount
def dropItem(self, loc, obj_id):
cu.execute("update obj_instances set owner = NULL, location = ?, npc_owner = NULL where id = ?", (loc, obj_id))
return cu.rowcount
def setLocation(self, pid, where):
cu.execute("update players set location = ? where id = ?", (where, pid))
return cu.rowcount
def setColors(self, pid, color):
cu.execute("update players set colors = ? where id = ?", (color, pid))
return cu.rowcount
def banPlayer(self, player):
cu.execute("update players set banned = 1 where name = ?", (player,))
return cu.rowcount
def unbanPlayer(self, player):
cu.execute("update players set banned = 0 where name = ?", (player,))
return cu.rowcount
def setShortDesc(self, room, desc):
cu.execute("update rooms set s_desc = ? where id = ?", (desc, room))
return cu.rowcount
def setShortDesc(self, room, desc):
cu.execute("update rooms set l_desc = ? where id = ?", (desc, room))
return cu.rowcount
def setItemDescription(self, item, desc):
cu.execute("update objects set description = ? where name = ?", (desc, item))
return cu.rowcount
def setNpcDesc(self, npc, desc):
cu.execute("update npcs set description = ? where id = ?", (desc, npc))
return cu.rowcount
def setLastAction(self, time, pid):
cu.execute("update players set last_action = ? where id = ?", (time, pid))
def setIP(self, ip, pid):
cu.execute("update players set ip_addr = ? where id = ?", (ip, pid))
def LogoutPlayer(self, pid):
cu.execute("update players set location = 0, ip_addr = NULL where id = ?", (pid,))
def resetAllIPs(self):
cu.execute("update players set ip_addr = NULL")
class Insert:
def newPlayer(self, data):
cu.execute("insert into players(id,name,email,passwd,salt,location,description,colors)\
values (NULL,?,?,?,?,0,'Description not set',?)", data)
def addRoom(self, sdesc = None, room_id = None):
if sdesc:
cu.execute("insert into rooms(id, s_desc, l_desc) values(NULL,?,'Set description.')", (sdesc,))
elif room_id:
cu.execute("insert into rooms(id, s_desc, l_desc) values (%s,'A room', 'No description')" % (room_id,))
else:
cu.execute("insert into rooms(id, s_desc, l_desc) values (NULL,'A room','Set the description.')")
return cu.lastrowid
def addLink(self, orig, exit, dir):
cu.execute("insert into links(id, origin, dest, exit) values (NULL, ?, ?, ?)", (orig, exit, dir))
def addItem(self, name):
cu.execute("insert into objects(id,name,description) values (NULL, ?, 'Set description')", (name,))
return cu.lastrowid
def addNpc(self, name):
cu.execute("insert into npcs(id,name,description) values (NULL, ?, 'Set description.')", (name,))
return cu.lastrowid
def cloneItem(self, item, pid, time):
cu.execute("insert into obj_instances(id,o_id,owner,creation) values (NULL, ?, ?,?)", (item, pid, time))
def cloneNpc(self, npc, pid, item):
cu.execute("insert into npc_instances(id,n_id,location,creation) values (NULL,?,?,?)", (npc, pid, item))
class Delete:
def deleteRoom(self, id):
cu.execute("delete from rooms where id = ?", (id,))
return cu.rowcount
def deleteLink(self, id):
cu.execute("delete from links where origin = ? or dest = ?", (id,))
return cu.rowcount
def deleteLinkById(self, id):
cu.execute("delete from links where id = ?", (id,))
return cu.rowcount
def deleteItem(self, item):
cu.execute("delete from obj_instances where o_id = ?", (item,))
cu.execute("delete from objects where id = ?", (item,))
return cu.rowcount
def deleteObject(self, object):
cu.execute("delete from obj_instances where id = ?", (object,))
return cu.rowcount
def deleteNpc(self, npc):
cu.execute("delete from npcs where id = ?", (npc,))
def deleteNpcInst(self, npc):
cu.execute("delete from npc_instances where id = ?", (npc,))
return cu.rowcount
def deletePlayer(self, player):
cu.execute("delete from players where name = ?", (player,))