[Librefm-commits] [1351] change owner to an integer

[Clint Adams]

Revision: 1351
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1351
Author:   clint
Date:     2009-05-08 03:14:45 +0000 (Fri, 08 May 2009)
Log Message:
-----------
change owner to an integer

Modified Paths:
--------------
    trunk/gnukebox/install.php
    trunk/nixtape/data/Group.php

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-08 03:10:33 UTC (rev 1350)
+++ trunk/gnukebox/install.php  2009-05-08 03:14:45 UTC (rev 1351)
@@ -81,7 +81,7 @@
        $adodb->Execute("CREATE TABLE Groups (
                id SERIAL PRIMARY KEY,
                groupname VARCHAR(64),
-               owner VARCHAR(64) REFERENCES Users(username),
+               owner INTEGER REFERENCES Users(uniqueid),
                fullname VARCHAR(255),
                bio TEXT,
                homepage VARCHAR(255),

Modified: trunk/nixtape/data/Group.php
===================================================================
--- trunk/nixtape/data/Group.php        2009-05-08 03:10:33 UTC (rev 1350)
+++ trunk/nixtape/data/Group.php        2009-05-08 03:14:45 UTC (rev 1351)
@@ -163,7 +163,7 @@
                // Create new group
                $q = sprintf('INSERT INTO Groups (groupname, owner, created, 
modified) VALUES (%s, %s, %d, %d)'
                                , $mdb2->quote($name, 'text')
-                               , $mdb2->quote($owner->name, 'text')
+                               , $mdb2->quote($owner->uniqueid, 'integer')
                                , time()
                                , time());
                $res = $mdb2->query($q);
@@ -248,7 +248,7 @@
                                . "avatar_uri=%s, "
                                . "modified=%d "
                                . "WHERE groupname=%s"
-                               , $mdb2->quote($this->owner->name, 'text')
+                               , $mdb2->quote($this->owner->uniqueid, 
'integer')
                                , $mdb2->quote($this->fullname, 'text')
                                , $mdb2->quote($this->homepage, 'text')
                                , $mdb2->quote($this->bio, 'text')