[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1323] switch member field to user ids
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1323] switch member field to user ids |
Date: |
Fri, 08 May 2009 01:43:30 +0000 |
Revision: 1323
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1323
Author: clint
Date: 2009-05-08 01:43:29 +0000 (Fri, 08 May 2009)
Log Message:
-----------
switch member field to user ids
Modified Paths:
--------------
trunk/nixtape/data/Group.php
Modified: trunk/nixtape/data/Group.php
===================================================================
--- trunk/nixtape/data/Group.php 2009-05-08 01:42:14 UTC (rev 1322)
+++ trunk/nixtape/data/Group.php 2009-05-08 01:43:29 UTC (rev 1323)
@@ -183,7 +183,7 @@
// Group owner must be a member of the group
$q = sprintf('INSERT INTO Group_Members (grp, member, joined)
VALUES (%s, %s, %d)'
, $mdb2->quote($grp, 'integer')
- , $mdb2->quote($owner->name, 'text')
+ , $mdb2->quote($owner->uniqueid, 'integer')
, time());
$res = $mdb2->query($q);
if (PEAR::isError($res))
@@ -208,7 +208,7 @@
."LEFT JOIN Group_Members gm ON gm.grp=g.id "
."GROUP BY g.id, g.owner, g.fullname, g.bio,
g.homepage, g.created, g.modified, g.avatar_uri, g.grouptype) gc "
."ON m.grp=gc.id "
- ."WHERE m.member=".$mdb2->quote($user->name,
'text'));
+ ."WHERE
m.member=".$mdb2->quote($user->uniqueid, 'integer'));
}
else
{
@@ -299,7 +299,7 @@
{
$res = $mdb2->query("SELECT u.* "
. "FROM Users u "
- . "INNER JOIN Group_Members gm ON
u.username=gm.member "
+ . "INNER JOIN Group_Members gm ON
u.uniqueid=gm.member "
. "WHERE
gm.grp=".$mdb2->quote($this->gid,'integer')
. " ORDER BY gm.joined");
if ($res->numRows())
@@ -353,7 +353,7 @@
global $mdb2;
$res = $mdb2->query(sprintf("DELETE FROM Group_Members WHERE
grp=%s AND member=%s",
$mdb2->quote($this->gid, 'integer'),
- $mdb2->quote($user->name, 'text')));
+ $mdb2->quote($user->uniqueid, 'integer')));
if(PEAR::isError($res))
return false;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1323] switch member field to user ids,
Clint Adams <=