def updateLocation(cursor, userid, location):
	queryDict = {
		DC.UserID: userid,
		DC.Location: location,
	}
	query = Q.UpdateLocation % queryDict
	pgDB.execute(cursor, query)
Exemple #2
0
def updateUserLocation(cursor, userid, roomid):
    queryDict = {
        DC.UserID: userid,
        DC.RoomID: roomid,
    }
    query = Q.UpdateUserRoomID % queryDict
    pgDB.execute(cursor, query)
Exemple #3
0
def updateUserLocation(cursor, userid, roomid):
	queryDict = {
		DC.UserID: userid,
		DC.RoomID: roomid,
	}
	query = Q.UpdateUserRoomID % queryDict
	pgDB.execute(cursor, query)
def createUser(cursor, nickname, charname, password, userlevel = Player):
	password = sha.new(password).hexdigest()
	queryDict = {
		DC.UserID: userid,
		DC.UserLevel: userlevel,
		DC.NickName: nickname,
		DC.FullName: charname,
		DC.Password: password,
	}
	query = Q.CreateUser % queryDict
	pgDB.execute(query)
Exemple #5
0
def createUser(cursor, nickname, charname, password, userlevel=Player):
    password = sha.new(password).hexdigest()
    queryDict = {
        DC.UserID: userid,
        DC.UserLevel: userlevel,
        DC.NickName: nickname,
        DC.FullName: charname,
        DC.Password: password,
    }
    query = Q.CreateUser % queryDict
    pgDB.execute(query)
def setThreadID(cursor, userid, threadid):
	query = Q.SetThreadID % {DC.UserID: userid, DC.CurrentThreadID: threadid}
	pgDB.execute(cursor, query)
def clearLoggedInUsers(cursor):
	query = Q.ClearLoggedInUsers
	pgDB.execute(cursor, query)
Exemple #8
0
def setThreadID(cursor, userid, threadid):
    query = Q.SetThreadID % {DC.UserID: userid, DC.CurrentThreadID: threadid}
    pgDB.execute(cursor, query)
Exemple #9
0
def clearLoggedInUsers(cursor):
    query = Q.ClearLoggedInUsers
    pgDB.execute(cursor, query)