[xiph-commits] r14711 - branches/dir.xiph.org/inc

[balbinus at svn.xiph.org]

Author: balbinus
Date: 2008-04-11 12:12:18 -0700 (Fri, 11 Apr 2008)
New Revision: 14711

Modified:
   branches/dir.xiph.org/inc/class.mountpoint.php
   branches/dir.xiph.org/inc/class.server.php
Log:
ARGL UPDATES W/O WHERE! I must be dumb.

Modified: branches/dir.xiph.org/inc/class.mountpoint.php
===================================================================
--- branches/dir.xiph.org/inc/class.mountpoint.php	2008-04-11 18:25:21 UTC (rev 14710)
+++ branches/dir.xiph.org/inc/class.mountpoint.php	2008-04-11 19:12:18 UTC (rev 14711)
@@ -206,7 +206,8 @@
 		            .'`description` = %3$s, `url` = %4$s, `listeners` = %5$d, '
 		            .'`current_song` = %6$s, `media_type_id` = %7$d, '
 		            .'`bitrate` = "%8$s", `channels` = %9$s, '
-		            .'`samplerate` = %10$s, `cluster_password` = %11$s;';
+		            .'`samplerate` = %10$s, `cluster_password` = %11$s '
+		            .'WHERE `id` = %12$d;';
         }
 	    $query = sprintf($query, self::$table_name,
 	                             mysql_real_escape_string($this->stream_name),
@@ -218,7 +219,8 @@
 							     mysql_real_escape_string($this->bitrate),
 							     ($this->channels != null) ? intval($this->channels) : 'NULL',
 							     ($this->samplerate != null) ? intval($this->samplerate) : 'NULL',
-							     ($this->cluster_password != null) ? '"'.mysql_real_escape_string($this->cluster_password).'"' : 'NULL');
+							     ($this->cluster_password != null) ? '"'.mysql_real_escape_string($this->cluster_password).'"' : 'NULL',
+							     intval($this->mountpoint_id));
 							     
 	    if ($this->mountpoint_id == 0)
 	    {

Modified: branches/dir.xiph.org/inc/class.server.php
===================================================================
--- branches/dir.xiph.org/inc/class.server.php	2008-04-11 18:25:21 UTC (rev 14710)
+++ branches/dir.xiph.org/inc/class.server.php	2008-04-11 19:12:18 UTC (rev 14711)
@@ -193,7 +193,7 @@
     		        .'`current_song` = %4$s, `listen_url` = "%5$s", '
     		        .'`listeners` = %6$d, `last_touched_at` = %7$s, '
     		        .'`last_touched_from` = INET_ATON("%8$s"), '
-    		        .'`checked` = %9$d;';
+    		        .'`checked` = %9$d WHERE `id` = %10$d;';
         }
 	    $query = sprintf($query, self::$table_name,
 	                             $this->mountpoint_id,
@@ -203,7 +203,8 @@
 							     ($this->listeners != null) ? $this->listeners : 0,
 							     ($this->last_touched_at != null) ? '"'.mysql_real_escape_string($this->last_touched_at).'"' : 'NOW()',
 							     mysql_real_escape_string($this->last_touched_from),
-							     ($this->checked != null) ? $this->checked : 0);
+							     ($this->checked != null) ? $this->checked : 0,
+							     intval($this->server_id));
 	    
 		if ($this->server_id == 0)
 		{