hko.rar converted into *.sql Files

[ParSalian]

• Save the following text as hko.sql​
• Make in navicat a new Database named hko​
• Right klick on the new Database​
• Klick on "Execute Batch Files"​

You have now 7 Tables (account,folder,guild,item.mail,member,player}​

/*
MySQL Data Transfer
Source Host: localhost
Source Database: hko
Target Host: localhost
Target Database: hko
Date: 07.04.2009 04:16:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
CREATE TABLE `account` (
`AccountId` int(11) NOT NULL auto_increment,
`Username` varchar(100) NOT NULL default '',
`Password` varchar(100) NOT NULL default '',
`Actived` tinyint(1) NOT NULL default '0',
`FromIP` varchar(100) NOT NULL default '',
`LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
`LastLogout` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`AccountId`,`Username`),
FULLTEXT KEY `Username` (`Username`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for folder
-- ----------------------------
CREATE TABLE `folder` (
`FolderId` int(11) NOT NULL default '0',
`PlayerId` int(11) NOT NULL default '0',
`Name` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild
-- ----------------------------
CREATE TABLE `guild` (
`GuildId` int(11) NOT NULL default '0',
`PlayerId` int(11) NOT NULL default '0',
`Name` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for item
-- ----------------------------
CREATE TABLE `item` (
`ItemId` int(11) NOT NULL default '0',
`FolderId` int(11) NOT NULL default '0',
`ItemType` varchar(100) NOT NULL default '',
`ItemCount` varchar(100) NOT NULL default '',
`ItemPos` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for mail
-- ----------------------------
CREATE TABLE `mail` (
`MailId` int(11) NOT NULL default '0',
`PlayerId` int(11) NOT NULL default '0',
`SenderId` int(11) NOT NULL default '0',
`Flags` varchar(100) NOT NULL default '',
`SenderName` varchar(100) NOT NULL default '',
`Title` varchar(100) NOT NULL default '',
`Text` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for member
-- ----------------------------
CREATE TABLE `member` (
`GuildId` int(11) NOT NULL default '0',
`PlayerId` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for player
-- ----------------------------
CREATE TABLE `player` (
`PlayerId` int(11) NOT NULL auto_increment,
`AccountId` int(11) NOT NULL default '0',
`Name` varchar(100) NOT NULL default '',
`Property` longblob NOT NULL,
PRIMARY KEY (`PlayerId`,`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=26790 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `account` VALUES ('1', 'sean', 'sean', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('2', 'alex', 'alex', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('3', 'npc', 'npc', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('4', 'test0', 'test0', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('5', 'pin', 'pin', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('6', 'test1', 'test1', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('46', 'test7', 'test7', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('8', 'test3', 'test3', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('9', 'test4', 'test4', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('10', 'test5', 'test5', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('11', 'test6', 'test6', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('45', 'test2', 'test2', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('13', 'test8', 'test8', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('15', 'woody', 'woody', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('16', 'alex2', 'alex2', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('17', 'kent', 'kent', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('18', 'npcgm', 'npcgm', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('20', 'kidd', 'kidd', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('21', 'joe', 'joe', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('22', 'jerry', 'jerry', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('23', 'mint', 'mint', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('24', 'nano', '1234', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('48', 'karl', 'karl', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('26', 'mikko', 'mikko', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('27', 'mandy', 'mandy', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('28', 'vigi', 'vigi', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('29', 'silvia', 'silvia', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('30', 'merlin', 'merlin', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('31', 'van', 'van', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('32', 'kiki', 'kiki', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('33', 'jerry', 'jerry', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('34', 'xeno', 'xeno', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('35', 'tk', 'tk', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('36', 'wood', 'wood', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('37', 'press1', 'press1', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('38', 'press2', 'press2', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('39', 'press3', 'press3', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('40', 'press0', 'press0', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('41', 'test9', 'test9', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('44', 'kent2', 'kent2', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `account` VALUES ('47', 'karl3', 'karl3', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `player` VALUES ('26533', '36', 'aloha', 0xA000CD0100000000CD0B000004050000616C6F686100CDCDCDCDCDCDCDCDCDCD05000000380000000000000000000000DD05000061090000B90B0000A20F0000000000000000000000000000000000000000000000000000000C02040C15041400CDCDCD030046005E00600064006E006E006C00640064006C006C006A0017270000010070170000C3450F00CDCDCDCDCDCDCDCDCDCDCDCDA567000000000000);
INSERT INTO `player` VALUES ('6606', '17', 'kent', 0xA000CD010000000067030000370300006B656E7400CDCDCDCDCDCDCDCDCDCDCD03000000330000000000000000000000DD050000E2070000BB0B0000B50F0000000000000000000000000000000000000000000000000000000100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F270000010000000000C7550F005B1A0000CDCDCDCDCDCDCDCDCE19000000000000);
INSERT INTO `player` VALUES ('6586', '1', 'Sean', 0xA000CD010A0000000E0200001D0200005365616E00CDCDCDCDCDCDCDCDCDCDCD03000000330000000000000000000000E2050000E5070000C40B0000C90F0000000000000000000000000000000000000000000000000000000102040101041400CDCDCD0C0055006100620064009B009B009000640064009000900085003B2700000100C60C000007E116005C1A0000CDCDCDCDCDCDCDCDBA19000000000000);
INSERT INTO `player` VALUES ('8664', '35', 'sadfsdf', 0xA000CD010000000024090000780600007361646673646600CDCDCDCDCDCDCDCD06000000410000000000000000000000FB050000E5070000BF0B0000911000009D1100000000000000000000751700000000000000000000010100040101041400CDCDCD0200640064006400640069006900680064006400680068006700132700000100140000003F420F0011220000CDCDCDCDCDCDCDCDD821000000000000);
INSERT INTO `player` VALUES ('11009', '35', 'werw', 0xA000CD010000000033000000C4FFFFFF7765727700CDCDCDCDCDCDCDCDCDCDCD050000003E0000000000000000000000DF050000DF070000C30B000005100000000000000000000000000000751700000000000000000000000102040101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD012B000000000000);
INSERT INTO `player` VALUES ('7895', '26', 'MIKKO', 0xA000CD0100000000E5030000A30600004D494B4B4F00CDCDCDCDCDCDCDCDCDCD060000003F0000000000000000000000FB050000E3070000BE0B000073100000FC1100000000000000000000741700000000000000000000010100040101041400CDCDCD07006400640064006400820082007C00640064007C007C007600272700000100500000003F420F00D81E0000CDCDCDCDCDCDCDCDD71E000000000000);
INSERT INTO `player` VALUES ('25703', '29', 'silvia2', 0xA000CD0100000000BD080000C905000073696C7669613200CDCDCDCDCDCDCDCD060000003F0000000000000000000000E2050000DC070000BB0B0000C90F00009D1100000000000000000000711700000000000000000000010B02040B1E041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD6764000000000000);
INSERT INTO `player` VALUES ('7885', '24', '11', 0xA000CD01000000007E08000045060000313100CDCDCDCDCDCDCDCDCDCDCDCDCD050000003E0000000000000000000000E2050000DB070000D80B000073100000FC1100000000000000000000731700000000000000000000000102040101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCDCD1E000000000000);
INSERT INTO `player` VALUES ('7894', '34', 'xeno1', 0xA000CD0100000000E70C00002C09000078656E6F3100CDCDCDCDCDCDCDCDCDCD03000000330000000000000000000000DD050000E5070000BE0B000005100000021200000000000000000000000000000000000000000000000200040210041400CDCDCD030064006400640064006E006E006C00640064006C006C006A001727000001001E000000CB1A0F00841F0000CDCDCDCDCDCDCDCDD61E000000000000);
INSERT INTO `player` VALUES ('25708', '43', 'rol rol', 0xA000CD0100000000110A00005D070000726F6C20726F6C00CDCDCDCDCDCDCDCD06000000400000000000000000000000DD050000E0070000BC0B0000051000009D1100000000000000000000711700000000000000000000010100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F270000010000000000DF0A0600F6660000CDCDCDCDCDCDCDCD6C64000000000000);
INSERT INTO `player` VALUES ('7305', '20', 'kiddy', 0xA000CD0100000000E3080000BA0600006B6964647900CDCDCDCDCDCDCDCDCDCD080000004A0000000000000000000000DD05000075090000E50C00002D100000000000000000000000000000000000000000000000000000010C02000C01041400CDCDCD010064006400640064006400640064006400640064006400640064000000010000000000000000008A1C0000CDCDCDCDCDCDCDCD891C000000000000);
INSERT INTO `player` VALUES ('25845', '23', 'mint2', 0xA000CD01000000009D0A00009C0700006D696E743200CDCDCDCDCDCDCDCDCDCD08000000400000000000000000000000DD0500009B080000E60C000087100000000000000000000000000000000000000000000000000000010B02040B1E041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCDF564000000000000);
INSERT INTO `player` VALUES ('25846', '32', 'kikikiki', 0xA000CD0100000000CD0A00000D0800006B696B696B696B6900CDCDCDCDCDCDCD04000000380000000000000000000000DD050000CD080000BC0B0000A30F000000000000000000000000000000000000000000000000000000030104030B041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCDF664000000000000);
INSERT INTO `player` VALUES ('25952', '22', 'jerry', 0xA000CD0100000000DF0C0000160900006A6572727900CDCDCDCDCDCDCDCDCDCD03000000330000000000000000000000DD050000D2070000B90B0000A20F0000000000000000000000000000000000000000000000000000000100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD6065000000000000);
INSERT INTO `player` VALUES ('7254', '36', 'merc', 0xA000CD01000000003E020000B50100006D65726300CDCDCDCDCDCDCDCDCDCDCD06000000400000000000000000000000DD05000075090000E60C000087100000000000000000000000000000000000000000000000000000010B03010B01041400CDCDCD07000A005200580064007C008E007C0064006400760088007C00760000000100504600008C0A0000881C0000CDCDCDCDCDCDCDCD561C000000000000);
INSERT INTO `player` VALUES ('26401', '44', 'kent2', 0xA000CD010000000059010000FD0000006B656E743200CDCDCDCDCDCDCDCDCDCD060000003F0000000000000000000000DD05000075090000E50C000087100000000000000000000000000000000000000000000000000000010400040401041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD2167000000000000);
INSERT INTO `player` VALUES ('26439', '12', 'jojo', 0xA000CD0100000000AF040000840300006A6F6A6F00CDCDCDCDCDCDCDCDCDCDCD06000000440000000000000000000000E505000075090000E60C000073100000000000000000000000000000000000000000000000000000010100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F270000010000000000171F0F0048670000CDCDCDCDCDCDCDCD4767000000000000);
INSERT INTO `player` VALUES ('26759', '28', 'vigigi', 0xA000CD01000000001B090000B905000076696769676900CDCDCDCDCDCDCDCDCD040000003D0000000000000000000000DD050000CD080000B90B0000B50F0000000000000000000000000000000000000000000000000000000C010D0C01041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD0000000000000000);
INSERT INTO `player` VALUES ('26760', '29', 'dog', 0xA000CD0100000000CC0A000080050000646F6700CDCDCDCDCDCDCDCDCDCDCDCD060000003F0000000000000000000000DD05000036080000BA0B0000A20F0000000000000000000000000000000000000000000000000000010C00040C01041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD8868000000000000);
INSERT INTO `player` VALUES ('26762', '45', 'roletta1', 0xA000CD0100000000830A000047060000726F6C657474613100CDCDCDCDCDCDCD070000004A0000000000000000000000FB050000DE070000BC0B0000051000009D1100000000000000000000000000000000000000000000010100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD8A68000000000000);
INSERT INTO `player` VALUES ('26763', '45', 'roletta2', 0xA000CD0100000000AD070000CF040000726F6C657474613200CDCDCDCDCDCDCD06000000400000000000000000000000DD05000075090000E50C00002D100000000000000000000000000000000000000000000000000000010100050101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD8B68000000000000);
INSERT INTO `player` VALUES ('26764', '6', 'chih', 0xA000CD0100000000960700005F0400006368696800CDCDCDCDCDCDCDCDCDCDCD050000003D0000000000000000000000DD05000061090000B90B0000A20F0000000000000000000000000000000000000000000000000000000100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD8C68000000000000);
INSERT INTO `player` VALUES ('26765', '45', 'roletta', 0xA000CD01000000002A0B0000EE040000726F6C6574746100CDCDCDCDCDCDCDCD060000003F0000000000000000000000DD050000E0070000BD0B000073100000F91100000000000000000000741700000000000000000000010100040101041400CDCDCD01006400640064006400640064006400640064006400640064000F2700000100000000003F420F00CDCDCDCDCDCDCDCDCDCDCDCD8D68000000000000);
INSERT INTO `player` VALUES ('26766', '3', 'NPC1', 0x8C00CC04000000000C0800003A0500004E50433100CCCCCCCCCCCCCCCCCCCCCC03000000340000000000000000000000DD050000A5080000BC0B0000A20F0000000000000000000000000000000000000000000000000000E8030000CCCCCCCCCCCCCCCCCCCCCCCC00000000CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC00010000000000000000000000);
INSERT INTO `player` VALUES ('26767', '3', 'NPC2', 0x8C00CC0400000000740900005E0600004E50433200CCCCCCCCCCCCCCCCCCCCCC03000000340000000000000000000000E5050000C1080000BF0B000019100000000000000000000000000000000000000000000000000000E9030000CCCCCCCCCCCCCCCCCCCCCCCC00000000CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC00020000000000000000000000);
INSERT INTO `player` VALUES ('26768', '3', 'NPC3', 0x8C00CC0400000000960A00006C0500004E50433300CCCCCCCCCCCCCCCCCCCCCC03000000340000000000000000000000DD050000C1080000BC0B000019100000000000000000000000000000000000000000000000000000EA030000CCCCCCCCCCCCCCCCCCCCCCCC00000000CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC00030000000000000000000000);
INSERT INTO `player` VALUES ('26769', '3', '​

 

[kn95951135]

thankx for release~

 

[Bubsy]

I have a Error by Players ^^

 

[ParSalian]

The player commando lines are to long for quote.
Copy it to your Notepad an delete the space between the numbers in the player commando lines.

 

[Krashnburnz]

I fixed the errors that you would get from using navicat and also saved it in sql format for ease of use. Just extract the sql file out of the archive, and inside Navicat you just right click the 'hko' database you created, and execute batch file. Find where you unziped the sql and click it.

Download Links:
[Mirror 1]:

You must be registered to see links

[Mirror 2]:

You must be registered to see links

[Mirror 3]:

You must be registered to see links

[Mirror 4]:

You must be registered to see links

 

[MidnightTiger]

All those links are dead

 

[abgafro]

All those links are dead

HKO Database.rar ( 3.37kB )

You must be registered to see links

 

[vitvn]

How to login server??????????????????

 

[nultar]

can anybody help me? i get this error:

[Err] 1366 - Incorrect string value: '\xABO\xC3\xB9' for column 'Name' at row 1
[Err] INSERT INTO `player` VALUES ('26769', '3', '�Où', 0x8C00CC04000000001E0B00002F070000AB4FC3B900CCCCCCCCCCCCCCCCCCCCCC03000000330000000000000000000000DD050000A5080000BC0B0000A20F000000000000000000000000000000000000000000000000000045000000CCCCCCCCCCCCCCCCCCCCCCCC00000000CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC00000000000000000000000000);
[Msg] Finished - Unsuccessfully
--------------------------------------------------