Codeigniter

 

테이블 생성

CREATE TABLE  `geoip` (
     `id` int(10) unsigned NOT NULL auto_increment,
      `ip_start` varchar(15) NOT NULL,
      `ip_end` varchar(15) NOT NULL,
      `ipnum_start` float NOT NULL,
      `ipnum_end` float NOT NULL,
      `country_code` char(2) NOT NULL,
      `country` varchar(50) NOT NULL,
      PRIMARY KEY  (`id`),
      KEY `geoip_lookup` USING BTREE (`ipnum_start`,`ipnum_end`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

 

GeoIPCountryWhois.csv

https://dev.maxmind.com/geoip/legacy/csv/

 

위 파일을 다운로드 한 후  todo 의 tool 에서 임포트를 한다.

 

CI helper 에 다음 코드를  넣은 는다.

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
    /*
     * GeoIP Plugin for CodeIgniter/Blueflame - Version 1
     * Writted By Paul Trippett (paul_at_techxpert_co_uk)
     *
     * To use this plugin you must create a table in your database with
     * the following schema: -
     *
CREATE TABLE  `geoip` (
     `id` int(10) unsigned NOT NULL auto_increment,
      `ip_start` varchar(15) NOT NULL,
      `ip_end` varchar(15) NOT NULL,
      `ipnum_start` float NOT NULL,
      `ipnum_end` float NOT NULL,
      `country_code` char(2) NOT NULL,
      `country` varchar(50) NOT NULL,
      PRIMARY KEY  (`id`),
      KEY `geoip_lookup` USING BTREE (`ipnum_start`,`ipnum_end`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;     *
     *
     * Place this file in your application/plugins/ directory and download the
     * following files in to the {ci_root}/updates/geoip/ directory.
     *
     *      ftp://ftp.afrinic.net/pub/stats/afrinic/delegated-afrinic-latest
     *      ftp://ftp.apnic.net/pub/stats/apnic/delegated-apnic-latest
     *      ftp://ftp.arin.net/pub/stats/arin/delegated-arin-latest
     *      ftp://ftp.lacnic.net/pub/stats/lacnic/delegated-lacnic-latest
     *      ftp://ftp.ripe.net/ripe/stats/delegated-ripencc-latest
     *      ftp://ftp.apnic.net/pub/stats/iana/delegated-iana-latest
     *
     * You should then be able to use the following code in your controller: -
     *
     *      $this->load->plugin('geoip');
     *      
     *      geoip_update();
     *      geoip_lookup('xxx.xxx.xxx.xxx');
     *
     * geoip_update() needs only to be called _once_ after you update the files
     * from the RIR FTP sites.
     *
     * Should you wish to place the files in a different directory or use a
     * different table name you can put the following code in your
     * /application/config/config.php file: -
     *
     *      define('GEOIP_TABLENAME', 'geoip');
     *      define('GEOIP_FILESOURCE', 'updates/geoip/');
     * 
     */
    

	$ci =& get_instance();
    
    if (!defined('GEOIP_TABLENAME')) define('GEOIP_TABLENAME', $ci->db->dbprefix.'geoip');
    if (!defined('GEOIP_FILESOURCE')) define('GEOIP_FILESOURCE', 'updates/geoip/');


    /**
     * geoip_lookup
     *
     * Looks up GeoIP data from database.
     *
	 * @access	public
	 * @param	string	$ip	    The either a dotted decimal or integer or the ip address to lookup
	 * @return	string          The two letter country code of the ip address.
     */	
    function geoip_lookup($ip) {
        
        // If we are passed a string ip address convert it to a Long Integer
        $data = (is_string($ip)) ? ip2long($ip) : $ip;
        $CI =& get_instance();
        $query = $CI->db->query('SELECT * FROM ' . GEOIP_TABLENAME . ' WHERE ' . $data . ' BETWEEN ipnum_start AND ipnum_end');
        
        return (string) ($query->num_rows() > 0) ? $query->row()->country_code : '';
    }
	
	function geoip_country($ip) {
        
        // If we are passed a string ip address convert it to a Long Integer
        $data = (is_string($ip)) ? ip2long($ip) : $ip;
        $CI =& get_instance();
        $query = $CI->db->query('SELECT * FROM ' . GEOIP_TABLENAME . ' WHERE ' . $data . ' BETWEEN ipnum_start AND ipnum_end');
        
        return (string) ($query->num_rows() > 0) ? $query->row()->country: '';
    }
    
    /**
     * geoip_update
     *
     * Imports GeoIP data from RIR Data
     *
	 * @access	public
	 * @param	null
	 * @return	null
     */	
    function geoip_update() {
        
        // Prevent script timing out
        set_time_limit(0);
        
        // Get instance to CodeIgniter
        $CI =& get_instance();
        
        // Load Required Helpers
        $CI->load->helper('file');
        
        $CI->benchmark->mark('geoip_update_start');
        
        // Start a Transaction and clear out the old data.
        $CI->db->trans_start();
        $CI->db->simple_query(sprintf('DELETE FROM %s;', GEOIP_TABLENAME));
        
        // Process each file
        $source_files = get_filenames(GEOIP_FILESOURCE);
        if (empty($source_files)) show_error(sprintf('No RIR Data was found in the directory %s', GEOIP_FILESOURCE));
            
        foreach($source_files as $file) {
            
            echo sprintf('Importing %s... ', $file);
            geoip_update_file(GEOIP_FILESOURCE . $file);
            echo 'Done.<br />';
            
        }
        
        // Commit the changes 
        $CI->db->trans_complete();
        $CI->benchmark->mark('geoip_update_end');
        
        echo sprintf('GeoIP update completed. Processed %d files in %d seconds', count($source_files), $CI->benchmark->elapsed_time('geoip_update_start', 'geoip_update_end'));
        
    }
    
    /**
     * geoip_update_file
     *
     * Imports GeoIP data from a particular text file.
     *
     */	
    function geoip_update_file($file) {
      
		
        // Get instance to CodeIgniter
        $CI =& get_instance();
        
        $current_file = read_file($file);
       
       // $current_file = read_file("./updates/geoip/delegated-afrinic-latest");
		//$current_file = read_file("./updates/geoip/delegated-afrinic-latest");
        $query_start = sprintf('INSERT INTO %s VALUES ', GEOIP_TABLENAME);
        $query = '';
        $count = 0;
		$type = '';
        
        for ( $line = 1; $line < count($current_file); $line++ ) {
            
            $data = split('[\|]', rtrim($current_file[$line]));
            if (count($data) == 7) {
                list($registry, $cc, $type, $start, $value, $date, $status) = $data;
            } elseif (count($data) == 8) {
                list($registry, $cc, $type, $start, $value, $date, $status, $exception) = $data;
            }
            
            if ($type == 'ipv4') {
                
                $ip_start = $start;
                $ip_end = long2ip(ip2long($ip_start) + $value);
                $ipnum_start = ip2long($ip_start);
                $ipnum_end = ip2long($ip_end);
                
                if (!$count == 0) $query .= ',';
                $query .= sprintf("(0,'%s','%s',%d,%d,'%s')", $ip_start, $ip_end, $ipnum_start, $ipnum_end, $cc);
                $count++;
                
                if ($count == 50) {
                    $CI->db->simple_query($query_start . $query);
                    $count = 0;
                    $query = '';
                }
                
            }
            
        }
        
        // The number of records will probably not divide equally by 50
        // so we execute any remainder here.
        if ($count > 0) {
            $CI->db->simple_query($query_start . $query);
        }
        
    }

    

 

사용 방법

	$this->load->helper('geoip');    	

                   echo "<br>";
		echo "접속 국가 코드 ".geoip_lookup($this->input->ip_address());
		echo "<br>";
		
		echo "<br>";
		echo "접속 국가 ".geoip_country($this->input->ip_address());
		echo "<br>";

 

 

geoip_update 와 geoip_update_file 함수는 안 될 것이다.

 

 

 

다음과 같은 방법도 있다. dat 사용

http://codeigniter-kr.org/bbs/view/source?idx=7546

 

 

 

 

 

 

 

 

about author

PHRASE

Level 1  라이트

댓글 ( 1)

댓글 남기기

작성