<%@page import="com.smsnet.database.DatabaseObject" %>
<%@page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%
String ip = request.getRemoteAddr();
boolean isTurkey = isTurkey(ip);
if(!isTurkey)
    response.sendRedirect("Operations.html");
else
    response.sendRedirect("under_construction.html");
%>

<%!
   public static boolean isTurkey(String ip)
   {
       boolean turkey = false;
       long intIp = getIntIp(ip);
       Hashtable table = getIpRanges();

       Set set = table.entrySet();
       Iterator it = set.iterator();
       while (it.hasNext())
       {
           Map.Entry entry = (Map.Entry) it.next();
           long intBegin = (Long) entry.getKey();
           long intEnd = (Long) entry.getValue();
           if(intBegin<intIp && intIp<intEnd)
               turkey = true;
       }
       return turkey;
   }

   public static Hashtable getIpRanges()
   {
       DatabaseObject dObject = new DatabaseObject("net.sourceforge.jtds.jdbc.Driver", "jdbc:jtds:sqlserver://192.168.33.228:1433/COMMON", "dk1985", "KARAKULE");
       Hashtable table = new Hashtable();

       try
       {
           Statement statement = dObject.con.createStatement();
           String query = "select INT_BEGIN, INT_END from IP_COUNTRY WHERE Location_Long = 'TURKEY'";
           ResultSet rs = statement.executeQuery(query);

           while(rs.next())
           {
               long intBegin = rs.getLong("INT_BEGIN");
               long intEnd = rs.getLong("INT_END");
               table.put(intBegin, intEnd);

           }
       }
       catch(Exception e)
       {
           System.out.println(e.toString());
       }

       return table;

   }

   public static long getIntIp(String IP)
   {
        String[] IPBL = IP.replace('.',',').split(",");
        long total = 0;
        for (int i =  0 ;  i < IPBL.length;i++)
        {
            total = total * 256;
            total  = total + Integer.parseInt(IPBL[i]);
        }
        return total;
    }
%>