--- a/lib/my_db.py	Sun Oct 12 11:11:31 2003 -0400
+++ b/lib/my_db.py	Fri Oct 17 15:05:17 2003 -0400
@@ -28,9 +28,9 @@
 	def create_user(self, name):
 		id = self.get_next_id('users')
 		self.crs.execute("""
-			INSERT INTO users(id, name)
-			VALUES (%d, %s);
-			""" % (id, sql_quote(name)))
+			INSERT INTO users(id, name, full_name)
+			VALUES (%d, %s, %s);
+			""" % (id, sql_quote(name), sql_quote(name)))
 		self.crs.execute("""
 			INSERT INTO keywords(id, userid, name)
 			VALUES (0, %d, '--');
@@ -60,15 +60,18 @@
 		self.cnx.commit()
 	def get_preferences(self):
 		self.crs.execute("""
-			SELECT keywords_box,
-			keywords_sort, keywords_reverse
-			FROM preferences WHERE userid = %d;
+			SELECT p.keywords_box,
+			p.keywords_sort, p.keywords_reverse,
+			u.full_name
+			FROM preferences p, users u
+			WHERE u.id = %d AND p.userid = u.id;
 			""" % (self.userid,))
 		res = self.crs.fetchone()
 		return {
 		   'keywords_box' : res[0],
 		   'keywords_sort' : res[1],
-		   'keywords_reverse': res[2]
+		   'keywords_reverse': res[2],
+		   'fullname': res[3]
 		   }
 	def set_preferences(self, prefs):
 	        if prefs['keywords_reverse']:
@@ -84,6 +87,12 @@
 			""" % (prefs['keywords_box'],
 			sql_quote(prefs['keywords_sort']),
 			rev, self.userid))
+		self.crs.execute("""
+			UPDATE users
+			SET full_name = %s
+			WHERE id = %d;
+			""" % (sql_quote(prefs["fullname"]),
+				self.userid))
 		self.cnx.commit()
 	def add_bookmark(self, bk):
 		id = self.get_next_id('bookmarks')