[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1351] change owner to an integer
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1351] change owner to an integer |
Date: |
Fri, 08 May 2009 03:14:46 +0000 |
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')
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1351] change owner to an integer,
Clint Adams <=