• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

hko.rar converted into *.sql Files

Status
Not open for further replies.
Newbie Spellweaver
Joined
Jan 19, 2007
Messages
81
Reaction score
5
  • 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', '​
 
Newbie Spellweaver
Joined
Jan 19, 2007
Messages
81
Reaction score
5
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.
 
Newbie Spellweaver
Joined
Feb 28, 2006
Messages
11
Reaction score
0
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]: http://rapidshare.com/files/235457299/HKO_database.rar.html
[Mirror 2]: http://www.filefactory.com/file/ag1cd5f/n/HKO_database_rar
[Mirror 3]: http://rapidshare.de/files/47242753/HKO_database.rar.html
[Mirror 4]: http://www.zshare.net/download/603091389ef4c85d/
 
Newbie Spellweaver
Joined
May 8, 2009
Messages
7
Reaction score
0
How to login server??????????????????
 
Newbie Spellweaver
Joined
Aug 3, 2010
Messages
68
Reaction score
2
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
--------------------------------------------------
 
Status
Not open for further replies.
Back
Top