Method: DatabaseMethodsWifi_1#wifi_get_max_tunnel_id

Defined in:
lib/freewifi/database/mysql/database_methods_wifi.rb

#wifi_get_max_tunnel_id ⇒ Object 



26
27
28
29
30
31
32
33
34
 
# File 'lib/freewifi/database/mysql/database_methods_wifi.rb', line 26

def wifi_get_max_tunnel_id
  client = Mysql2::Client.new(:host => database_host, :username => database_username, :password => database_password)
  client.query("use mtsPortalWiFI", :cast => false)
  client.query("SELECT MAX(EoIP_ID) AS EoIP_ID FROM List_mikroTik_eoip_tunnels",:as => :array).each do |row|
    client.close
    #"row" + row[0]
    return row [0]
  end
end