Include node coordinates on the data browser view for a node. Fixes #1856.

[rails.git] / app / models / acl.rb

diff --git a/app/models/acl.rb b/app/models/acl.rb
index dbcb38993b6b905f0e5be691147387488c6f5023..3ff19d35f6d8374bba709485641b3080ae62d595 100644 (file)
--- a/app/models/acl.rb
+++ b/app/models/acl.rb
@@ -1,13 +1,23 @@
 class Acl < ActiveRecord::Base
   def self.find_by_address(address, options)
 class Acl < ActiveRecord::Base
   def self.find_by_address(address, options)

-    self.with_scope(:find => {:conditions => ["? & netmask = address", address]}) do
+    self.with_scope(:find => {:conditions => ["#{inet_aton} & netmask = address", address]}) do

       return self.find(:first, options)
     end
   end
 
   def self.find_all_by_address(address, options)
       return self.find(:first, options)
     end
   end
 
   def self.find_all_by_address(address, options)

-    self.with_scope(:find => {:conditions => ["? & netmask = address", address]}) do
+    self.with_scope(:find => {:conditions => ["#{inet_aton} & netmask = address", address]}) do

       return self.find(:all, options)
     end
   end
       return self.find(:all, options)
     end
   end

+
+private
+
+  def self.inet_aton
+    if self.connection.adapter_name == "MySQL"
+      "inet_aton(?)"
+    else
+      "?"
+    end
+  end

 end
 end