game_servers.host

gistfile1.txt

-- phpMyAdmin SQL Dump
-- version 3.3.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 21, 2011 at 03:49 AM
-- Server version: 5.1.54
-- PHP Version: 5.3.5-1ubuntu7.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `tabula4`
--

-- --------------------------------------------------------

--
-- Table structure for table `game_servers`
--

CREATE TABLE IF NOT EXISTS `game_servers` (
  `server_id` int(11) NOT NULL,
  `host` int(11) unsigned NOT NULL,
  `port` int(11) NOT NULL,
  `age_limit` int(11) NOT NULL,
  `pk_flag` int(11) NOT NULL,
  `current_users` int(11) NOT NULL,
  `max_users` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `check_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `static` int(11) NOT NULL,
  PRIMARY KEY (`host`,`port`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `game_servers`
--

INSERT INTO `game_servers` (`server_id`, `host`, `port`, `age_limit`, `pk_flag`, `current_users`, `max_users`, `status`, `check_time`, `static`) VALUES
(53, 16777343, 8001, 18, 1, 1, 100, 1, '2011-05-01 18:04:50', 1),
(234, 3313215680, 8001, 18, 0, 0, 10, 1, '2011-08-20 19:31:37', 1);

My server = 192.168.123.197
reversed = 197.123.168.192
integer = 3313215680
(see http://www.ipaddresslocation.org/convertip.php)