Can someone help me to fix the error? i really don't know what happen :(::(:
Printable View
Can someone help me to fix the error? i really don't know what happen :(::(:
i really don't know what error
2 1 2 2 2 3 0 row(s) affected 0.000 sec 2 4 2 5 2 6 0.000 sec 2 7 0 row(s) affected 0.000 sec 2 8 2 9 0.000 sec 1 10 1 11 DROP VIEW IF EXISTS `readable_cheatlog` 0.000 sec 2 12 03:30:22 REATE TABLE `readable_cheatlog` (
`accountname` varchar(13),
`accountid` int(11),
`name` varchar(13),
`characterid` int(11),
`offense` tinytext,
`count` int(11),
`lastoffensetime` timestamp,
`tinytextparam`
)0 row(s) affected 0.016 sec 1 13 03:30:22 --
-- Temporary table structure for view `readable_gmlog`
--
DROP TABLE IF EXISTS `readable_gmlog`0 row(s) affected, 1 warning(s):
1051 Unknown table 'readable_gmlog'0.000 sec 1 14 03:30:22 DROP VIEW IF EXISTS `readable_gmlog` 0 row(s) affected, 1 warning(s):
1051 Unknown table 'xiuzsource.readable_gmlog'0.000 sec 2 15 03:30:22 CREATE TABLE `readable_gmlog` (
`logentryid` int(11),
`accountname` varchar(13),
`charname` varchar(13),
`command` tinytext,
`when` timestamp
)0 row(s) affected 0.015 sec 1 16 03:30:22 -
-- Temporary table structure for view `readable_last_hour_cheatlog`
--
DROP TABLE IF EXISTS `readable_last_hour_cheatlog`0 row(s) affected, 1 warning(s):
1051 Unknown table 'readable_last_hour_cheatlog'0.000 sec 1 17 03:30:22 DROP VIEW IF EXISTS `readable_last_hour_cheatlog` 0 row(s) affected, 1 warning(s):
1051 Unknown table 'xiuzsource.readable_last_hour_cheatlog'0.000 sec 2 18 03:30:22 CREATE TABLE `readable_last_hour_cheatlog` (
`accountname` varchar(13),
`accountid` int(11),
`name` varchar(13),
`characterid` int(11),
`numrepos` decimal(32,0)
)0 row(s) affected 0.000 sec 1 19 03:30:22 --
-- Definition of table `accounts`
--
DROP TABLE IF EXISTS `accounts`0 row(s) affected, 1 warning(s):
1051 Unknown table 'accounts'0.000 sec 2 20 03:30:22 CREATE TABLE `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL DEFAULT '',
`password` varchar(128) NOT NULL DEFAULT '',
`salt` varchar(32) DEFAULT NULL,
`loggedin` tinyint(4) NOT NULL DEFAULT '0',
`lastlogin` timestamp NULL DEFAULT NULL,
`createdat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`birthday` date NOT NULL DEFAULT '0000-00-00',
`banned` tinyint(1) NOT NULL DEFAULT '0',
`banreason` text,
`gm` tinyint(1) NOT NULL DEFAULT '0',
`email` tinytext,
`emailcode` varchar(40) DEFAULT NULL,
`forumaccid` int(11) NOT NULL DEFAULT '0',
`macs` tinytext,
`lastknownip` tinytext NOT NULL,
`lastpwemail` timestamp NOT NULL DEFAULT '2002-12-31 17:00:00',
`tempban` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`greason` tinyint(4) DEFAULT NULL,
`paypalNX` int(11) DEFAULT NULL,
`mPoints` int(11) DEFAULT NULL,
`cardNX` int(11) DEFAULT NULL,
`donorPoints` tinyint(1) DEFAULT NULL,
`guest` tinyint(1) NOT NULL DEFAULT '0',
`LastLoginInMilliseconds` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `forumaccid` (`forumaccid`),
KEY `ranking1` (`id`,`banned`,`gm`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 21 03:30:22 --
-- Dumping data for table `accounts`
--
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'accounts' doesn't have this option0.000 sec 2 22 03:30:22 INSERT INTO `accounts` (`id`,`name`,`password`,`salt`,`loggedin`,`lastlogin`,`createdat`,`birthday`,`banned`,`banreason`,`gm`,`email`,`emailcode`,`forumaccid`,`macs`,`lastknownip`,`lastpwemail`,`tempban`,`greason`,`paypalNX`,`mPoints`,`cardNX`,`donorPoints`,`guest`,`LastLoginInMilliseconds`) VALUES
(1,'Admin','XiuzSource',NULL,0,'2009-09-04 12:53:57','2009-09-04 12:48:01','0000-00-00',0,NULL,0,'no@email.provided',NULL,0,'00-1E-68-7C-8E-CF','127.0.0.1','2002-12-31 17:00:00','0000-00-00 00:00:00',NULL,0,0,0,0,0,1252093987680)1 row(s) affected 0.000 sec 1 23 03:30:22 /*!40000 ALTER TABLE `accounts` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'accounts' doesn't have this option0.000 sec 1 24 03:30:22 --
-- Definition of table `alliance`
--
DROP TABLE IF EXISTS `alliance`0 row(s) affected, 1 warning(s):
1051 Unknown table 'alliance'0.000 sec 2 25 03:30:22 CREATE TABLE `alliance` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(13) NOT NULL,
`notice` varchar(128) NOT NULL DEFAULT '',
`capacity` int(10) unsigned NOT NULL DEFAULT '2',
`rank_title1` varchar(45) NOT NULL DEFAULT 'Master',
`rank_title2` varchar(45) NOT NULL DEFAULT 'Jr.Master',
`rank_title3` varchar(45) NOT NULL DEFAULT 'Member',
`rank_title4` varchar(45) NOT NULL DEFAULT 'Member',
`rank_title5` varchar(45) NOT NULL DEFAULT 'Member',
`guild1` int(10) NOT NULL DEFAULT '-1',
`guild2` int(10) NOT NULL DEFAULT '-1',
`guild3` int(10) NOT NULL DEFAULT '-1',
`guild4` int(10) NOT NULL DEFAULT '-1',
`guild5` int(10) NOT NULL DEFAULT '-1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 26 03:30:22 --
-- Dumping data for table `alliance`
--
/*!40000 ALTER TABLE `alliance` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'alliance' doesn't have this option0.000 sec 1 27 03:30:22 /*!40000 ALTER TABLE `alliance` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'alliance' doesn't have this option0.000 sec 1 28 03:30:22 --
-- Definition of table `bbs_replies`
--
DROP TABLE IF EXISTS `bbs_replies`0 row(s) affected, 1 warning(s):
1051 Unknown table 'bbs_replies'0.000 sec 2 29 03:30:22 CREATE TABLE `bbs_replies` (
`replyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`threadid` int(10) unsigned NOT NULL,
`postercid` int(10) unsigned NOT NULL,
`timestamp` bigint(20) unsigned NOT NULL,
`content` varchar(26) NOT NULL DEFAULT '',
PRIMARY KEY (`replyid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 30 03:30:22 --
-- Dumping data for table `bbs_replies`
--
/*!40000 ALTER TABLE `bbs_replies` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'bbs_replies' doesn't have this option0.000 sec 1 31 03:30:22 /*!40000 ALTER TABLE `bbs_replies` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'bbs_replies' doesn't have this option0.000 sec 1 32 03:30:22 --
-- Definition of table `bbs_threads`
--
DROP TABLE IF EXISTS `bbs_threads`0 row(s) affected, 1 warning(s):
1051 Unknown table 'bbs_threads'0.000 sec 2 33 03:30:22 CREATE TABLE `bbs_threads` (
`threadid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`postercid` int(10) unsigned NOT NULL,
`name` varchar(26) NOT NULL DEFAULT '',
`timestamp` bigint(20) unsigned NOT NULL,
`icon` smallint(5) unsigned NOT NULL,
`replycount` smallint(5) unsigned NOT NULL DEFAULT '0',
`startpost` text NOT NULL,
`guildid` int(10) unsigned NOT NULL,
`localthreadid` int(10) unsigned NOT NULL,
PRIMARY KEY (`threadid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 34 03:30:22 --
-- Dumping data for table `bbs_threads`
--
/*!40000 ALTER TABLE `bbs_threads` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'bbs_threads' doesn't have this option0.000 sec 1 35 03:30:22 /*!40000 ALTER TABLE `bbs_threads` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'bbs_threads' doesn't have this option0.000 sec 1 36 03:30:22 --
-- Definition of table `buddies`
--
DROP TABLE IF EXISTS `buddies`0 row(s) affected, 1 warning(s):
1051 Unknown table 'buddies'0.000 sec 2 37 03:30:22 CREATE TABLE `buddies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL,
`buddyid` int(11) NOT NULL,
`pending` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `buddies_ibfk_1` (`characterid`),
CONSTRAINT `buddies_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.015 sec 1 38 03:30:22 --
-- Dumping data for table `buddies`
--
/*!40000 ALTER TABLE `buddies` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'buddies' doesn't have this option0.000 sec 1 39 03:30:22 /*!40000 ALTER TABLE `buddies` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'buddies' doesn't have this option0.000 sec 1 40 03:30:22 --
-- Definition of table `cashshop`
--
DROP TABLE IF EXISTS `cashshop`0 row(s) affected, 1 warning(s):
1051 Unknown table 'cashshop'0.000 sec 2 41 03:30:22 CREATE TABLE `cashshop` (
`sn` int(11) NOT NULL,
`arg1` int(11) NOT NULL DEFAULT '0',
`arg2` int(11) NOT NULL DEFAULT '0',
`arg3` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 42 03:30:22 --
-- Dumping data for table `cashshop`
--
/*!40000 ALTER TABLE `cashshop` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'cashshop' doesn't have this option0.000 sec 1 43 03:30:22 /*!40000 ALTER TABLE `cashshop` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'cashshop' doesn't have this option0.000 sec 1 44 03:30:22 --
-- Definition of table `channelconfig`
--
DROP TABLE IF EXISTS `channelconfig`0 row(s) affected, 1 warning(s):
1051 Unknown table 'channelconfig'0.000 sec 2 45 03:30:22 CREATE TABLE `channelconfig` (
`channelconfigid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`channelid` int(10) unsigned NOT NULL DEFAULT '0',
`name` tinytext NOT NULL,
`value` tinytext NOT NULL,
PRIMARY KEY (`channelconfigid`),
KEY `channelid` (`channelid`),
CONSTRAINT `channelconfig_ibfk_1` FOREIGN KEY (`channelid`) REFERENCES `channels` (`channelid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 46 03:30:22 --
-- Dumping data for table `channelconfig`
--
/*!40000 ALTER TABLE `channelconfig` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'channelconfig' doesn't have this option0.000 sec 2 47 03:30:22 INSERT INTO `channelconfig` (`channelconfigid`,`channelid`,`name`,`value`) VALUES
(1,2,'net.sf.odinms.channel.net.port','7576'),
(2,3,'net.sf.odinms.channel.net.port','7577'),
(3,4,'net.sf.odinms.channel.net.port','7578'),
(4,5,'net.sf.odinms.channel.net.port','7589'),
(5,6,'net.sf.odinms.channel.net.port','7590'),
(6,7,'net.sf.odinms.channel.net.port','7591'),
(7,8,'net.sf.odinms.channel.net.port','7592'),
(8,9,'net.sf.odinms.channel.net.port','7593'),
(9,10,'net.sf.odinms.channel.net.port','7594'),
(10,11,'net.sf.odinms.channel.net.port','7595'),
(11,12,'net.sf.odinms.channel.net.port','7596'),
(12,13,'net.sf.odinms.channel.net.port','7597'),
(13,14,'net.sf.odinms.channel.net.port','7598'),
(14,15,'net.sf.odinms.channel.net.port','7599'),
(15,16,'net.sf.odinms.channel.net.port','7600'),
(16,17,'net.sf.odinms.channel.net.port','7601'),
(17,18,'net.sf.odinms.channel.net.port','7602'),
(18,19,'net.sf.odinms.channel.net.port','7603'),
(19,20,'net.sf.odinms.channel.net.port','7604')19 row(s) affected
Records: 19 Duplicates: 0 Warnings: 00.016 sec 1 48 03:30:22 /*!40000 ALTER TABLE `channelconfig` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'channelconfig' doesn't have this option0.000 sec 1 49 03:30:22 --
-- Definition of table `channels`
--
DROP TABLE IF EXISTS `channels`0 row(s) affected, 1 warning(s):
1051 Unknown table 'channels'0.000 sec 2 50 03:30:22 CREATE TABLE `channels` (
`channelid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`world` int(11) NOT NULL DEFAULT '0',
`number` int(11) DEFAULT NULL,
`key` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`channelid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 51 03:30:22 --
-- Dumping data for table `channels`
--
/*!40000 ALTER TABLE `channels` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'channels' doesn't have this option0.000 sec 2 52 03:30:22 INSERT INTO `channels` (`channelid`,`world`,`number`,`key`) VALUES
(1,0,1,'2062e90b3ea10a86ff666a76c41aa0d9e9d88f4e'),
(2,0,2,'5dfc64fff3b07c7c01ebd39706ec3cf3e6c37464'),
(3,0,3,'f47ef28d4a014d8de91de9f28ae6fcd52dfb5f77'),
(4,0,4,'33fd56a7b827c7b0b2df8ea1224521cd7c00e4e4'),
(5,0,5,'113f78f519e010e65853241bfcb14450c4fccb66'),
(6,0,6,'4abba5486022346a2b309c1c2ea6a0da41a88090'),
(7,0,7,'76134d11fe0c2b337e2b786bfcc738b975fcf40a'),
(8,0,8,'5688c244c56a884a50984130a17d0b61d06743a3'),
(9,0,9,'6e59a6559033c70b98148f1bd67e1b63aaeedf30'),
(10,0,10,'603dd499e4b134bf9925600b7f150644f9e9a50b'),
(11,0,11,'b48f4c3c803f58950b005d785cf828027a83eac4'),
(12,0,12,'52a9458618abed6a42e228b33ade9cdf5ded10b4'),
(13,0,13,'190535a9ffb4d4d688ac1f3fa7dc09a6c81c3b86'),
(14,0,14,'5ce2b432ac85290b411ef0975b96712c1c35591a'),
(15,0,15,'7d8bae4945561008426174be907142196ed84275'),
(16,0,16,'da0517603d42ce6f9d9bdf4871bc1ecbf7a20c3c'),
(17,0,17,'87c56d1e33cf26f48ac76f1bd76b6637cddd9548'),
(18,0,18,'fbce35ee8db37d9bf02f444c65e49fb8a9685c28'),
(19,0,19,'51a2bb10ecf4e2e28fe62b405106baadb0d11090'),
(20,0,20,'9a071c700e4c051c354817f7e2482d148380d574')20 row(s) affected
Records: 20 Duplicates: 0 Warnings: 00.000 sec 1 53 03:30:22 /*!40000 ALTER TABLE `channels` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'channels' doesn't have this option0.000 sec 1 54 03:30:22 --
-- Definition of table `characters`
--
DROP TABLE IF EXISTS `characters`0 row(s) affected, 1 warning(s):
1051 Unknown table 'characters'0.000 sec 2 55 03:30:22 CREATE TABLE `characters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`accountid` int(11) NOT NULL DEFAULT '0',
`world` int(11) NOT NULL DEFAULT '0',
`name` varchar(13) NOT NULL DEFAULT '',
`level` int(11) NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`maxhp` int(11) NOT NULL DEFAULT '0',
`maxmp` int(11) NOT NULL DEFAULT '0',
`meso` int(11) NOT NULL DEFAULT '0',
`hpApUsed` int(11) NOT NULL DEFAULT '0',
`mpApUsed` int(11) NOT NULL DEFAULT '0',
`job` int(11) NOT NULL DEFAULT '0',
`skincolor` int(11) NOT NULL DEFAULT '0',
`gender` int(11) NOT NULL DEFAULT '0',
`fame` int(11) NOT NULL DEFAULT '0',
`hair` int(11) NOT NULL DEFAULT '0',
`face` int(11) NOT NULL DEFAULT '0',
`ap` int(11) NOT NULL DEFAULT '0',
`sp` int(11) NOT NULL DEFAULT '0',
`map` int(11) NOT NULL DEFAULT '0',
`spawnpoint` int(11) NOT NULL DEFAULT '0',
`gm` int(11) NOT NULL DEFAULT '0',
`party` int(11) NOT NULL DEFAULT '0',
`buddyCapacity` int(11) NOT NULL DEFAULT '25',
`createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`rank` int(10) unsigned NOT NULL DEFAULT '1',
`rankMove` int(11) NOT NULL DEFAULT '0',
`jobRank` int(10) unsigned NOT NULL DEFAULT '1',
`jobRankMove` int(11) NOT NULL DEFAULT '0',
`guildid` int(10) unsigned NOT NULL DEFAULT '0',
`guildrank` int(10) unsigned NOT NULL DEFAULT '5',
`allianceRank` int(10) unsigned NOT NULL DEFAULT '5',
`messengerid` int(10) unsigned NOT NULL DEFAULT '0',
`messengerposition` int(10) unsigned NOT NULL DEFAULT '4',
`reborns` int(11) NOT NULL DEFAULT '0',
`pvpkills` int(9) NOT NULL DEFAULT '0',
`pvpdeaths` int(9) NOT NULL DEFAULT '0',
`clan` tinyint(1) NOT NULL DEFAULT '-1',
`mountlevel` int(9) NOT NULL DEFAULT '1',
`mountexp` int(9) NOT NULL DEFAULT '0',
`mounttiredness` int(9) NOT NULL DEFAULT '0',
`married` int(10) unsigned NOT NULL DEFAULT '0',
`partnerid` int(10) unsigned NOT NULL DEFAULT '0',
`cantalk` int(10) unsigned NOT NULL DEFAULT '1',
`zakumlvl` int(10) unsigned NOT NULL DEFAULT '0',
`marriagequest` int(10) unsigned NOT NULL DEFAULT '0',
`omok` int(4) DEFAULT NULL,
`matchcard` int(4) DEFAULT NULL,
`omokwins` int(4) DEFAULT NULL,
`omoklosses` int(4) DEFAULT NULL,
`omokties` int(4) DEFAULT NULL,
`matchcardwins` int(4) DEFAULT NULL,
`matchcardlosses` int(4) DEFAULT NULL,
`matchcardties` int(4) DEFAULT NULL,
`MerchantMesos` int(11) NOT NULL DEFAULT '0',
`HasMerchant` tinyint(1) unsigned NOT NULL DEFAULT '0',
`gmtext` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `accountid` (`accountid`),
KEY `party` (`party`),
KEY `ranking1` (`level`,`exp`),
KEY `ranking2` (`gm`,`job`)
) ENGINE=InnoDB AUTO_INCREMENT=30002 DEFAULT CHARSET=latin10 row(s) affected 0.062 sec 1 56 03:30:22 --
-- Dumping data for table `characters`
--
/*!40000 ALTER TABLE `characters` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'characters' doesn't have this option0.000 sec 2 57 03:30:22 INSERT INTO `characters` (`id`,`accountid`,`world`,`name`,`level`,`exp`,`str`,`dex`,`luk`,`int`,`hp`,`mp`,`maxhp`,`maxmp`,`meso`,`hpApUsed`,`mpApUsed`,`job`,`skincolor`,`gender`,`fame`,`hair`,`face`,`ap`,`sp`,`map`,`spawnpoint`,`gm`,`party`,`buddyCapacity`,`createdate`,`rank`,`rankMove`,`jobRank`,`jobRankMove`,`guildid`,`guildrank`,`allianceRank`,`messengerid`,`messengerposition`,`reborns`,`pvpkills`,`pvpdeaths`,`clan`,`mountlevel`,`mountexp`,`mounttiredness`,`married`,`partnerid`,`cantalk`,`zakumlvl`,`marriagequest`,`omok`,`matchcard`,`omokwins`,`omoklosses`,`omokties`,`matchcardwins`,`matchcardlosses`,`matchcardties`,`MerchantMesos`,`HasMerchant`,`gmtext`) VALUES
(30001,1,0,'XiuzSource',1,0,4,4,4,4,50,5,50,5,0,0,0,0,0,0,0,30030,20000,9,0,0,0,0,-1,20,'2009-09-04 12:53:38',1,0,1,0,0,5,5,0,4,0,0,0,-1,1,0,0,0,0,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0)1 row(s) affected 0.000 sec 1 58 03:30:22 /*!40000 ALTER TABLE `characters` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'characters' doesn't have this option0.000 sec 1 59 03:30:22 --
-- Definition of table `cheatlog`
--
DROP TABLE IF EXISTS `cheatlog`0 row(s) affected, 1 warning(s):
1051 Unknown table 'cheatlog'0.000 sec 2 60 03:30:22 CREATE TABLE `cheatlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`offense` tinytext NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
`lastoffensetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`param` tinytext NOT NULL,
PRIMARY KEY (`id`),
KEY `cid` (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.031 sec 1 61 03:30:22 --
-- Dumping data for table `cheatlog`
--
/*!40000 ALTER TABLE `cheatlog` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'cheatlog' doesn't have this option0.000 sec 1 62 03:30:22 /*!40000 ALTER TABLE `cheatlog` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'cheatlog' doesn't have this option0.000 sec 1 63 03:30:22 --
-- Definition of table `cooldowns`
--
DROP TABLE IF EXISTS `cooldowns`0 row(s) affected, 1 warning(s):
1051 Unknown table 'cooldowns'0.000 sec 2 64 03:30:22 CREATE TABLE `cooldowns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`charid` int(11) NOT NULL,
`SkillID` int(11) NOT NULL,
`length` bigint(20) unsigned NOT NULL,
`StartTime` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `charid` (`charid`,`SkillID`),
UNIQUE KEY `charid_2` (`charid`,`SkillID`),
UNIQUE KEY `charid_3` (`charid`,`SkillID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.047 sec 1 65 03:30:23 --
-- Dumping data for table `cooldowns`
--
/*!40000 ALTER TABLE `cooldowns` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'cooldowns' doesn't have this option0.000 sec 1 66 03:30:23 /*!40000 ALTER TABLE `cooldowns` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'cooldowns' doesn't have this option0.000 sec 1 67 03:30:23 --
-- Definition of table `dueyitems`
--
DROP TABLE IF EXISTS `dueyitems`0 row(s) affected, 1 warning(s):
1051 Unknown table 'dueyitems'0.000 sec 2 68 03:30:23 CREATE TABLE `dueyitems` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`PackageId` int(10) unsigned NOT NULL DEFAULT '0',
`itemid` int(10) unsigned NOT NULL DEFAULT '0',
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) DEFAULT '0',
`level` int(11) DEFAULT '0',
`str` int(11) DEFAULT '0',
`dex` int(11) DEFAULT '0',
`int` int(11) DEFAULT '0',
`luk` int(11) DEFAULT '0',
`hp` int(11) DEFAULT '0',
`mp` int(11) DEFAULT '0',
`watk` int(11) DEFAULT '0',
`matk` int(11) DEFAULT '0',
`wdef` int(11) DEFAULT '0',
`mdef` int(11) DEFAULT '0',
`acc` int(11) DEFAULT '0',
`avoid` int(11) DEFAULT '0',
`hands` int(11) DEFAULT '0',
`speed` int(11) DEFAULT '0',
`jump` int(11) DEFAULT '0',
`owner` varchar(13) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `PackageId` (`PackageId`),
CONSTRAINT `dueyitems_ibfk_1` FOREIGN KEY (`PackageId`) REFERENCES `dueypackages` (`PackageId`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.047 sec 1 69 03:30:23 --
-- Dumping data for table `dueyitems`
--
/*!40000 ALTER TABLE `dueyitems` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'dueyitems' doesn't have this option0.000 sec 1 70 03:30:23 /*!40000 ALTER TABLE `dueyitems` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'dueyitems' doesn't have this option0.000 sec 1 71 03:30:23 --
-- Definition of table `dueypackages`
--
DROP TABLE IF EXISTS `dueypackages`0 row(s) affected, 1 warning(s):
1051 Unknown table 'dueypackages'0.000 sec 2 72 03:30:23 CREATE TABLE `dueypackages` (
`PackageId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`RecieverId` int(10) unsigned NOT NULL,
`SenderName` varchar(13) NOT NULL,
`Mesos` int(10) unsigned DEFAULT '0',
`TimeStamp` varchar(10) NOT NULL,
`Checked` tinyint(1) unsigned DEFAULT '1',
`Type` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`PackageId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.094 sec 1 73 03:30:23 --
-- Dumping data for table `dueypackages`
--
/*!40000 ALTER TABLE `dueypackages` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'dueypackages' doesn't have this option0.000 sec 1 74 03:30:23 /*!40000 ALTER TABLE `dueypackages` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'dueypackages' doesn't have this option0.000 sec 1 75 03:30:23 --
-- Definition of table `eventstats`
--
DROP TABLE IF EXISTS `eventstats`0 row(s) affected, 1 warning(s):
1051 Unknown table 'eventstats'0.000 sec 2 76 03:30:23 CREATE TABLE `eventstats` (
`eventstatid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`event` varchar(30) NOT NULL,
`instance` varchar(30) NOT NULL,
`characterid` int(11) NOT NULL,
`channel` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`eventstatid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 77 03:30:23 --
-- Dumping data for table `eventstats`
--
/*!40000 ALTER TABLE `eventstats` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'eventstats' doesn't have this option0.000 sec 1 78 03:30:23 /*!40000 ALTER TABLE `eventstats` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'eventstats' doesn't have this option0.000 sec 1 79 03:30:23 --
-- Definition of table `famelog`
--
DROP TABLE IF EXISTS `famelog`0 row(s) affected, 1 warning(s):
1051 Unknown table 'famelog'0.000 sec 2 80 03:30:23 CREATE TABLE `famelog` (
`famelogid` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`characterid_to` int(11) NOT NULL DEFAULT '0',
`when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`famelogid`),
KEY `characterid` (`characterid`),
CONSTRAINT `famelog_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.031 sec 1 81 03:30:23 --
-- Dumping data for table `famelog`
--
/*!40000 ALTER TABLE `famelog` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'famelog' doesn't have this option0.000 sec 1 82 03:30:23 /*!40000 ALTER TABLE `famelog` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'famelog' doesn't have this option0.000 sec 1 83 03:30:23 --
-- Definition of table `gmlog`
--
DROP TABLE IF EXISTS `gmlog`0 row(s) affected, 1 warning(s):
1051 Unknown table 'gmlog'0.000 sec 2 84 03:30:23 CREATE TABLE `gmlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`command` tinytext NOT NULL,
`when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 85 03:30:23 --
-- Dumping data for table `gmlog`
--
/*!40000 ALTER TABLE `gmlog` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'gmlog' doesn't have this option0.000 sec 1 86 03:30:23 /*!40000 ALTER TABLE `gmlog` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'gmlog' doesn't have this option0.000 sec 1 87 03:30:23 --
-- Definition of table `guilds`
--
DROP TABLE IF EXISTS `guilds`0 row(s) affected, 1 warning(s):
1051 Unknown table 'guilds'0.000 sec 2 88 03:30:23 CREATE TABLE `guilds` (
`guildid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`allianceId` int(10) unsigned DEFAULT '0',
`leader` int(10) unsigned NOT NULL DEFAULT '0',
`GP` int(10) unsigned NOT NULL DEFAULT '0',
`logo` int(10) unsigned DEFAULT NULL,
`logoColor` smallint(5) unsigned NOT NULL DEFAULT '0',
`name` varchar(45) NOT NULL,
`rank1title` varchar(45) NOT NULL DEFAULT 'Master',
`rank2title` varchar(45) NOT NULL DEFAULT 'Jr. Master',
`rank3title` varchar(45) NOT NULL DEFAULT 'Member',
`rank4title` varchar(45) NOT NULL DEFAULT 'Member',
`rank5title` varchar(45) NOT NULL DEFAULT 'Member',
`capacity` int(10) unsigned NOT NULL DEFAULT '10',
`logoBG` int(10) unsigned DEFAULT NULL,
`logoBGColor` smallint(5) unsigned NOT NULL DEFAULT '0',
`notice` varchar(101) DEFAULT NULL,
`signature` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`guildid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 89 03:30:23 --
-- Dumping data for table `guilds`
--
/*!40000 ALTER TABLE `guilds` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'guilds' doesn't have this option0.000 sec 1 90 03:30:23 /*!40000 ALTER TABLE `guilds` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'guilds' doesn't have this option0.000 sec 1 91 03:30:23 --
-- Definition of table `hiredmerchant`
--
DROP TABLE IF EXISTS `hiredmerchant`0 row(s) affected, 1 warning(s):
1051 Unknown table 'hiredmerchant'0.000 sec 2 92 03:30:23 CREATE TABLE `hiredmerchant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ownerid` int(11) DEFAULT '0',
`itemid` int(10) unsigned NOT NULL DEFAULT '0',
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) DEFAULT '0',
`level` int(11) DEFAULT '0',
`str` int(11) DEFAULT '0',
`dex` int(11) DEFAULT '0',
`int` int(11) DEFAULT '0',
`luk` int(11) DEFAULT '0',
`hp` int(11) DEFAULT '0',
`mp` int(11) DEFAULT '0',
`watk` int(11) DEFAULT '0',
`matk` int(11) DEFAULT '0',
`wdef` int(11) DEFAULT '0',
`mdef` int(11) DEFAULT '0',
`acc` int(11) DEFAULT '0',
`avoid` int(11) DEFAULT '0',
`hands` int(11) DEFAULT '0',
`speed` int(11) DEFAULT '0',
`jump` int(11) DEFAULT '0',
`owner` varchar(13) DEFAULT '',
`type` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.063 sec 1 93 03:30:23 --
-- Dumping data for table `hiredmerchant`
--
/*!40000 ALTER TABLE `hiredmerchant` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'hiredmerchant' doesn't have this option0.000 sec 1 94 03:30:23 /*!40000 ALTER TABLE `hiredmerchant` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'hiredmerchant' doesn't have this option0.000 sec 1 95 03:30:23 --
-- Definition of table `hiredmerchanttemp`
--
DROP TABLE IF EXISTS `hiredmerchanttemp`0 row(s) affected, 1 warning(s):
1051 Unknown table 'hiredmerchanttemp'0.000 sec 2 96 03:30:23 CREATE TABLE `hiredmerchanttemp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ownerid` int(11) DEFAULT '0',
`itemid` int(10) unsigned NOT NULL DEFAULT '0',
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) DEFAULT '0',
`level` int(11) DEFAULT '0',
`str` int(11) DEFAULT '0',
`dex` int(11) DEFAULT '0',
`int` int(11) DEFAULT '0',
`luk` int(11) DEFAULT '0',
`hp` int(11) DEFAULT '0',
`mp` int(11) DEFAULT '0',
`watk` int(11) DEFAULT '0',
`matk` int(11) DEFAULT '0',
`wdef` int(11) DEFAULT '0',
`mdef` int(11) DEFAULT '0',
`acc` int(11) DEFAULT '0',
`avoid` int(11) DEFAULT '0',
`hands` int(11) DEFAULT '0',
`speed` int(11) DEFAULT '0',
`jump` int(11) DEFAULT '0',
`owner` varchar(13) DEFAULT '',
`type` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.031 sec 1 97 03:30:23 --
-- Dumping data for table `hiredmerchanttemp`
--
/*!40000 ALTER TABLE `hiredmerchanttemp` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'hiredmerchanttemp' doesn't have this option0.000 sec 1 98 03:30:23 /*!40000 ALTER TABLE `hiredmerchanttemp` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'hiredmerchanttemp' doesn't have this option0.000 sec 1 99 03:30:23 --
-- Definition of table `htsquads`
--
DROP TABLE IF EXISTS `htsquads`0 row(s) affected, 1 warning(s):
1051 Unknown table 'htsquads'0.000 sec 2 100 03:30:23 CREATE TABLE `htsquads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`channel` int(10) unsigned NOT NULL,
`leaderid` int(10) unsigned NOT NULL DEFAULT '0',
`status` int(10) unsigned NOT NULL DEFAULT '0',
`members` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 101 03:30:23 --
-- Dumping data for table `htsquads`
--
/*!40000 ALTER TABLE `htsquads` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'htsquads' doesn't have this option0.000 sec 1 102 03:30:23 /*!40000 ALTER TABLE `htsquads` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'htsquads' doesn't have this option0.000 sec 1 103 03:30:23 --
-- Definition of table `inventoryequipment`
--
DROP TABLE IF EXISTS `inventoryequipment`0 row(s) affected, 1 warning(s):
1051 Unknown table 'inventoryequipment'0.000 sec 2 104 03:30:23 CREATE TABLE `inventoryequipment` (
`inventoryequipmentid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`inventoryitemid` int(10) unsigned NOT NULL DEFAULT '0',
`upgradeslots` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '0',
`dex` int(11) NOT NULL DEFAULT '0',
`int` int(11) NOT NULL DEFAULT '0',
`luk` int(11) NOT NULL DEFAULT '0',
`hp` int(11) NOT NULL DEFAULT '0',
`mp` int(11) NOT NULL DEFAULT '0',
`watk` int(11) NOT NULL DEFAULT '0',
`matk` int(11) NOT NULL DEFAULT '0',
`wdef` int(11) NOT NULL DEFAULT '0',
`mdef` int(11) NOT NULL DEFAULT '0',
`acc` int(11) NOT NULL DEFAULT '0',
`avoid` int(11) NOT NULL DEFAULT '0',
`hands` int(11) NOT NULL DEFAULT '0',
`speed` int(11) NOT NULL DEFAULT '0',
`jump` int(11) NOT NULL DEFAULT '0',
`ringid` int(11) NOT NULL DEFAULT '-1',
`locked` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`inventoryequipmentid`),
KEY `inventoryitemid` (`inventoryitemid`),
CONSTRAINT `inventoryequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `inventoryitems` (`inventoryitemid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 105 03:30:23 --
-- Dumping data for table `inventoryequipment`
--
/*!40000 ALTER TABLE `inventoryequipment` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'inventoryequipment' doesn't have this option0.000 sec 2 106 03:30:23 INSERT INTO `inventoryequipment` (`inventoryequipmentid`,`inventoryitemid`,`upgradeslots`,`level`,`str`,`dex`,`int`,`luk`,`hp`,`mp`,`watk`,`matk`,`wdef`,`mdef`,`acc`,`avoid`,`hands`,`speed`,`jump`,`ringid`,`locked`) VALUES
(6,6,7,0,0,0,0,0,0,0,0,0,3,0,0,0,0,0,0,-1,0),
(7,7,7,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,-1,0),
(8,8,5,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,-1,0),
(9,9,7,0,0,0,0,0,0,0,17,0,0,0,0,0,0,0,0,-1,0),
(10,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0)5 row(s) affected
Records: 5 Duplicates: 0 Warnings: 00.015 sec 1 107 03:30:23 /*!40000 ALTER TABLE `inventoryequipment` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'inventoryequipment' doesn't have this option0.000 sec 1 108 03:30:23 --
-- Definition of table `inventoryitems`
--
DROP TABLE IF EXISTS `inventoryitems`0 row(s) affected, 1 warning(s):
1051 Unknown table 'inventoryitems'0.000 sec 2 109 03:30:23 CREATE TABLE `inventoryitems` (
`inventoryitemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`characterid` int(11) DEFAULT NULL,
`storageid` int(10) unsigned DEFAULT NULL,
`itemid` int(11) NOT NULL DEFAULT '0',
`inventorytype` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '0',
`owner` tinytext NOT NULL,
`petid` int(11) NOT NULL DEFAULT '-1',
PRIMARY KEY (`inventoryitemid`),
KEY `inventoryitems_ibfk_1` (`characterid`),
KEY `characterid` (`characterid`),
KEY `inventorytype` (`inventorytype`),
KEY `storageid` (`storageid`),
KEY `characterid_2` (`characterid`,`inventorytype`),
CONSTRAINT `inventoryitems_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 110 03:30:23 --
-- Dumping data for table `inventoryitems`
--
/*!40000 ALTER TABLE `inventoryitems` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'inventoryitems' doesn't have this option0.000 sec 2 111 03:30:23 INSERT INTO `inventoryitems` (`inventoryitemid`,`characterid`,`storageid`,`itemid`,`inventorytype`,`position`,`quantity`,`owner`,`petid`) VALUES
(6,30001,NULL,1040002,-1,-5,1,'',-1),
(7,30001,NULL,1060002,-1,-6,1,'',-1),
(8,30001,NULL,1072001,-1,-7,1,'',-1),
(9,30001,NULL,1302000,-1,-11,1,'',-1),
(10,30001,NULL,1702132,-1,-111,1,'',-1)5 row(s) affected
Records: 5 Duplicates: 0 Warnings: 00.000 sec 1 112 03:30:23 /*!40000 ALTER TABLE `inventoryitems` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'inventoryitems' doesn't have this option0.000 sec 1 113 03:30:23 --
-- Definition of table `ipbans`
--
DROP TABLE IF EXISTS `ipbans`0 row(s) affected, 1 warning(s):
1051 Unknown table 'ipbans'0.000 sec 2 114 03:30:23 CREATE TABLE `ipbans` (
`ipbanid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(40) NOT NULL DEFAULT '',
PRIMARY KEY (`ipbanid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 115 03:30:23 --
-- Dumping data for table `ipbans`
--
/*!40000 ALTER TABLE `ipbans` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'ipbans' doesn't have this option0.000 sec 1 116 03:30:23 /*!40000 ALTER TABLE `ipbans` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'ipbans' doesn't have this option0.000 sec 1 117 03:30:23 --
-- Definition of table `iplog`
--
DROP TABLE IF EXISTS `iplog`0 row(s) affected, 1 warning(s):
1051 Unknown table 'iplog'0.000 sec 2 118 03:30:23 CREATE TABLE `iplog` (
`iplogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`accountid` int(11) NOT NULL DEFAULT '0',
`ip` varchar(30) NOT NULL DEFAULT '',
`login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`iplogid`),
KEY `accountid` (`accountid`,`ip`),
KEY `ip` (`ip`),
CONSTRAINT `iplog_ibfk_1` FOREIGN KEY (`accountid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 119 03:30:23 --
-- Dumping data for table `iplog`
--
/*!40000 ALTER TABLE `iplog` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'iplog' doesn't have this option0.000 sec 2 120 03:30:23 INSERT INTO `iplog` (`iplogid`,`accountid`,`ip`,`login`) VALUES
(1,1,'127.0.0.1','2009-09-04 12:52:56'),
(2,1,'127.0.0.1','2009-09-04 12:53:07')2 row(s) affected
Records: 2 Duplicates: 0 Warnings: 00.000 sec 1 121 03:30:23 /*!40000 ALTER TABLE `iplog` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'iplog' doesn't have this option0.000 sec 1 122 03:30:23 --
-- Definition of table `keymap`
--
DROP TABLE IF EXISTS `keymap`0 row(s) affected, 1 warning(s):
1051 Unknown table 'keymap'0.000 sec 2 123 03:30:23 CREATE TABLE `keymap` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`characterid` int(11) NOT NULL DEFAULT '0',
`key` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
`action` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `characterid` (`characterid`,`key`,`type`,`action`),
UNIQUE KEY `characterid_2` (`characterid`,`key`,`type`,`action`),
UNIQUE KEY `characterid_3` (`characterid`,`key`,`type`,`action`),
UNIQUE KEY `characterid_4` (`characterid`,`key`,`type`,`action`),
KEY `keymap_ibfk_1` (`characterid`),
CONSTRAINT `keymap_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 124 03:30:23 --
-- Dumping data for table `keymap`
--
/*!40000 ALTER TABLE `keymap` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'keymap' doesn't have this option0.000 sec 2 125 03:30:23 INSERT INTO `keymap` (`id`,`characterid`,`key`,`type`,`action`) VALUES
(38,30001,2,4,10),
(39,30001,3,4,12),
(40,30001,4,4,13),
(41,30001,5,4,18),
(42,30001,6,4,24),
(43,30001,7,4,21),
(44,30001,16,4,8),
(45,30001,17,4,5),
(46,30001,18,4,0),
(47,30001,19,4,4),
(48,30001,23,4,1),
(49,30001,25,4,19),
(50,30001,26,4,14),
(51,30001,27,4,15),
(52,30001,29,5,52),
(53,30001,31,4,2),
(54,30001,34,4,17),
(55,30001,35,4,11),
(56,30001,37,4,3),
(57,30001,38,4,20),
(58,30001,40,4,16),
(59,30001,41,4,23),
(60,30001,43,4,9),
(61,30001,44,5,50),
(62,30001,45,5,51),
(63,30001,46,4,6),
(64,30001,48,4,22),
(65,30001,50,4,7),
(66,30001,56,5,53),
(67,30001,57,5,54),
(68,30001,59,6,100),
(69,30001,60,6,101),
(70,30001,61,6,102),
(71,30001,62,6,103),
(72,30001,63,6,104),
(73,30001,64,6,105),
(74,30001,65,6,106)37 row(s) affected
Records: 37 Duplicates: 0 Warnings: 00.015 sec 1 126 03:30:23 /*!40000 ALTER TABLE `keymap` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'keymap' doesn't have this option0.000 sec 1 127 03:30:23 --
-- Definition of table `loginserver`
--
DROP TABLE IF EXISTS `loginserver`0 row(s) affected, 1 warning(s):
1051 Unknown table 'loginserver'0.000 sec 2 128 03:30:23 CREATE TABLE `loginserver` (
`loginserverid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(40) NOT NULL DEFAULT '',
`world` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`loginserverid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 129 03:30:23 --
-- Dumping data for table `loginserver`
--
/*!40000 ALTER TABLE `loginserver` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'loginserver' doesn't have this option0.000 sec 2 130 03:30:23 INSERT INTO `loginserver` (`loginserverid`,`key`,`world`) VALUES
(1,'d3703816f23fdee7fce6ba061244736b83c88fc5',0)1 row(s) affected 0.000 sec 1 131 03:30:23 /*!40000 ALTER TABLE `loginserver` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'loginserver' doesn't have this option0.000 sec 1 132 03:30:23 --
-- Definition of table `macbans`
--
DROP TABLE IF EXISTS `macbans`0 row(s) affected, 1 warning(s):
1051 Unknown table 'macbans'0.000 sec 2 133 03:30:23 CREATE TABLE `macbans` (
`macbanid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mac` varchar(30) NOT NULL,
PRIMARY KEY (`macbanid`),
UNIQUE KEY `mac_2` (`mac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 134 03:30:23 --
-- Dumping data for table `macbans`
--
/*!40000 ALTER TABLE `macbans` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'macbans' doesn't have this option0.000 sec 1 135 03:30:23 /*!40000 ALTER TABLE `macbans` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'macbans' doesn't have this option0.000 sec 1 136 03:30:23 --
-- Definition of table `macfilters`
--
DROP TABLE IF EXISTS `macfilters`0 row(s) affected, 1 warning(s):
1051 Unknown table 'macfilters'0.000 sec 2 137 03:30:23 CREATE TABLE `macfilters` (
`macfilterid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filter` varchar(30) NOT NULL,
PRIMARY KEY (`macfilterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.031 sec 1 138 03:30:23 --
-- Dumping data for table `macfilters`
--
/*!40000 ALTER TABLE `macfilters` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'macfilters' doesn't have this option0.000 sec 1 139 03:30:23 /*!40000 ALTER TABLE `macfilters` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'macfilters' doesn't have this option0.000 sec 1 140 03:30:23 --
-- Definition of table `marriages`
--
DROP TABLE IF EXISTS `marriages`0 row(s) affected, 1 warning(s):
1051 Unknown table 'marriages'0.000 sec 2 141 03:30:23 CREATE TABLE `marriages` (
`marriageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`husbandid` int(10) unsigned NOT NULL DEFAULT '0',
`wifeid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`marriageid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 142 03:30:23 --
-- Dumping data for table `marriages`
--
/*!40000 ALTER TABLE `marriages` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'marriages' doesn't have this option0.000 sec 1 143 03:30:23 /*!40000 ALTER TABLE `marriages` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'marriages' doesn't have this option0.000 sec 1 144 03:30:23 --
-- Definition of table `monsterdrops`
--
DROP TABLE IF EXISTS `monsterdrops`0 row(s) affected, 1 warning(s):
1051 Unknown table 'monsterdrops'0.000 sec 2 145 03:30:23 CREATE TABLE `monsterdrops` (
`monsterdropid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`monsterid` int(11) NOT NULL DEFAULT '0',
`itemid` int(11) NOT NULL DEFAULT '0',
`chance` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`monsterdropid`),
UNIQUE KEY `monsterid` (`monsterid`,`itemid`),
UNIQUE KEY `monsterid_2` (`monsterid`,`itemid`),
UNIQUE KEY `monsterid_3` (`monsterid`,`itemid`),
UNIQUE KEY `monsterid_4` (`monsterid`,`itemid`),
UNIQUE KEY `monsterid_5` (`monsterid`,`itemid`),
UNIQUE KEY `monsterid_6` (`monsterid`,`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=10424 DEFAULT CHARSET=latin10 row(s) affected 0.015 sec 1 146 03:30:23 --
-- Dumping data for table `monsterdrops`
--
/*!40000 ALTER TABLE `monsterdrops` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'monsterdrops' doesn't have this option0.000 sec 2 147 03:30:23 INSERT INTO `monsterdrops` (`monsterdropid`,`monsterid`,`itemid`,`chance`) VALUES
(1,9400567,2022251,600),
(2,100100,1061002,2400),
(3,100100,1302000,7000),
(4,100100,1040002,2400),
(5,100100,1002067,2400),
(6,100100,2060000,200),
(7,100100,2061000,200),
(8,100100,2000000,400),
(9,100100,2041001,12000),
(10,100100,2041004,12000),
(11,100100,2040002,8000),
(12,100100,4000019,5),
(13,100100,4020000,600),
(14,100100,4010000,600),
(15,100101,1040006,2400),
(16,100101,1040013,2400),
(17,100101,1060004,2400),
(18,100101,1041012,2400),
(19,100101,1060013,2400),
(20,100101,1040017,2400),
(21,100101,2060000,200),
(22,100101,2061000,200),
(23,100101,2000000,400),
(24,100101,2041006,4500),
(25,100101,2041001,12000),
(26,100101,4000000,5),
(27,100101,4020001,600),
(28,100101,4010001,600),
(29,120100,1312004,7000),
(30,120100,1060007,2400),
(31,120100,1062000,2400),
(32,120100,1041007,2400),
(33,120100,1061009,2400),
(34,120100,2060000,200),
(35,120100,2061000,200),
(36,120100,2000000,400),
(37,120100,2041007,12000),
(38,120100,4000011,5),
(39,120100,4020002,600),
(40,120100,4010002,600),
(41,130101,1072005,2400),
(42,130101,1041006,2400),
(43,130101,1032003,2400),
(44,130101,1322007,7000),
(45,130101,1372002,7000),
(46,130101,1072060,2400),
(47,130101,1060022,2400),
(48,130101,2060000,200),
(49,130101,2061000,200),
(50,130101,2000000,400),
(51,130101,2041009,4500),
(52,130101,2040502,8000),
(53,130101,4000016,5),
(54,130101,4020004,600),
(55,130101,4010004,600),
(56,130100,1442012,7000),
(57,130100,1041002,2400),
(58,130100,1322005,7000),
(59,130100,1082003,2400),
(60,130100,1072007,2400),
(61,130100,1452003,7000),
(62,130100,1332000,7000),
(63,130100,2000000,400),
(64,130100,2041008,8000),
(65,130100,2040402,8000),
(66,130100,4000003,5),
(67,130100,4020003,600),
(68,130100,4030009,300),
(69,130100,4010003,600),
(70,210100,1060002,2400),
(71,210100,1442012,7000),
(72,210100,1002019,2400),
(73,210100,1442029,7000),
(74,210100,1412012,7000),
(75,210100,1072023,2400),
(76,210100,1082019,2400),
(77,210100,1060031,2400),
(78,210100,2000000,400),
(79,210100,2040602,8000),
(80,210100,2041018,4500),
(81,210100,2041001,12000),
(82,210100,2040505,8000),
(83,210100,4000010,5),
(84,210100,4000004,5),
(85,210100,4020001,600),
(86,210100,4020005,600),
(87,210100,4030000,300),
(88,210100,4010005,600),
(89,1210100,1442012,7000),
(90,1210100,1002008,2400),
(91,1210100,1041012,2400),
(92,1210100,1041014,2400),
(93,1210100,1062002,2400),
(94,1210100,1472000,7000),
(95,1210100,1040034,2400),
(96,1210100,2000000,400),
(97,1210100,2041021,4500),
(98,1210100,2040702,8000),
(99,1210100,4000021,200),
(100,1210100,4000017,900),
(101,1210100,4003004,200),
(102,1210100,4020006,600),
(103,1210100,4030011,300),
(104,1210100,4010006,600),
(105,9420001,1060002,2400),
(106,9420001,1442012,7000),
(107,9420001,2000000,400),
(108,9420001,4000247,5),
(109,1210102,1312000,7000),
(110,1210102,1072004,2400),
(111,1210102,1002043,2400),
(112,1210102,1072015,2400),
(113,1210102,1082012,2400),
(114,1210102,1072031,2400),
(115,1210102,2000000,400),
(116,1210102,2040001,12000),
(117,1210102,2040705,8000),
(118,1210102,4000001,5),
(119,1210102,4020007,600),
(120,1210102,4030001,300),
(121,1210102,4010000,600),
(122,9400506,4031305,300),
(123,9400506,4031306,300),
(124,2130100,1002097,2400),
(125,2130100,1002055,2400),
(126,2130100,1041028,2400),
(127,2130100,1061026,2400),
(128,2130100,1060063,2400),
(129,2130100,1472006,7000),
(130,2130100,1472004,7000),
(131,2130100,1072087,2400),
(132,2130100,1072085,2400),
(133,2130100,1472009,7000),
(134,2130100,2012002,400),
(135,2130100,2000003,400),
(136,2130100,2000001,400),
(137,2130100,2044202,8000),
(138,2130100,2070009,10000),
(139,2130100,4000215,50),
(140,2130100,4000018,5),
(141,2130100,4006001,1500),
(142,2130100,4020007,600),
(143,2130100,4010001,600),
(144,1110101,1092003,5000),
(145,1110101,1442013,7000),
(146,1110101,1002001,2400),
(147,1110101,1032001,2400),
(148,1110101,1002...2198 row(s) affected
Records: 2198 Duplicates: 0 Warnings: 00.110 sec 2 148 03:30:23 INSERT INTO `monsterdrops` (`monsterdropid`,`monsterid`,`itemid`,`chance`) VALUES
(2220,4230120,1002141,2400),
(2221,4230120,1051030,2400),
(2222,4230120,1051031,2400),
(2223,4230120,1002135,2400),
(2224,4230120,1082084,2400),
(2225,4230120,1452008,7000),
(2226,4230120,1051039,2400),
(2227,4230120,1040084,2400),
(2228,4230120,1060073,2400),
(2229,4230120,2061000,200),
(2230,4230120,2000004,400),
(2231,4230120,2000002,400),
(2232,4230120,2040804,12000),
(2233,4230120,4006001,1500),
(2234,4230120,4010005,600),
(2235,4230125,1002081,2400),
(2236,4230125,1072126,2400),
(2237,4230125,1422007,7000),
(2238,4230125,1082059,2400),
(2239,4230125,1382019,7000),
(2240,4230125,1050052,2400),
(2241,4230125,1072108,2400),
(2242,4230125,2000003,400),
(2243,4230125,2000002,400),
(2244,4230125,4010000,600),
(2245,4230125,4010004,600),
(2246,4130100,1050022,2400),
(2247,4130100,1322016,7000),
(2248,4130100,1002045,2400),
(2249,4130100,1302010,7000),
(2250,4130100,1072133,2400),
(2251,4130100,1082064,2400),
(2252,4130100,1382001,7000),
(2253,4130100,1050046,2400),
(2254,4130100,1002138,2400),
(2255,4130100,1040079,2400),
(2256,4130100,1060069,2400),
(2257,4130100,1072125,2400),
(2258,4130100,1472012,7000),
(2259,4130100,1472032,7000),
(2260,4130100,2000004,400),
(2261,4130100,2044702,8000),
(2262,4130100,4000030,5),
(2263,4130100,4000014,5),
(2264,4130100,4006001,1500),
(2265,4130100,4020008,600),
(2266,4130100,4010005,600),
(2267,9400004,1302025,7000),
(2268,9400004,1060077,2400),
(2269,9400004,1382001,7000),
(2270,9400004,1061080,2400),
(2271,9400004,2041005,8000),
(2272,9400004,2070004,10000),
(2273,9400004,4004004,1500),
(2274,9400004,4020002,600),
(2275,9400004,4020007,600),
(2276,9400004,4010002,600),
(2277,4230400,1032018,2400),
(2278,4230400,1072126,2400),
(2279,4230400,1072116,2400),
(2280,4230400,1050047,2400),
(2281,4230400,1082071,2400),
(2282,4230400,1041082,2400),
(2283,4230400,1061081,2400),
(2284,4230400,1002184,2400),
(2285,4230400,2060000,200),
(2286,4230400,2061000,200),
(2287,4230400,2000003,400),
(2288,4230400,2000004,400),
(2289,4230400,2000002,400),
(2290,4230400,2044001,12000),
(2291,4230400,4000178,5),
(2292,4230400,4004001,1500),
(2293,4230400,4020008,600),
(2294,4230400,4010001,600),
(2295,4230110,1302013,7000),
(2296,4230110,1002004,2400),
(2297,4230110,1041084,2400),
(2298,4230110,1072135,2400),
(2299,4230110,1040088,2400),
(2300,4230110,1060077,2400),
(2301,4230110,1002144,2400),
(2302,4230110,1082081,2400),
(2303,4230110,1041067,2400),
(2304,4230110,1002170,2400),
(2305,4230110,1462019,7000),
(2306,4230110,1082083,2400),
(2307,4230110,1040082,2400),
(2308,4230110,1060071,2400),
(2309,4230110,1002181,2400),
(2310,4230110,2060000,200),
(2311,4230110,2061000,200),
(2312,4230110,2000004,400),
(2313,4230110,2000002,400),
(2314,4230110,2040504,12000),
(2316,4230110,2044301,12000),
(2318,4230110,2044002,8000),
(2319,4230110,4000102,5),
(2320,4230110,4004000,1500),
(2321,4230110,4020008,600),
(2322,4230106,1302016,7000),
(2323,4230106,1082036,2400),
(2324,4230106,1040086,2400),
(2325,4230106,1060075,2400),
(2326,4230106,1051032,2400),
(2327,4230106,1002216,2400),
(2328,4230106,1060070,2400),
(2329,4230106,1072118,2400),
(2330,4230106,1040081,2400),
(2331,4230106,1050052,2400),
(2332,4230106,1082045,2400),
(2333,4230106,1002210,2400),
(2334,4230106,1041080,2400),
(2335,4230106,1061079,2400),
(2336,4230106,2000003,400),
(2337,4230106,2000002,400),
(2338,4230106,2041012,4500),
(2339,4230106,2040705,8000),
(2340,4230106,2070002,10000),
(2341,4230106,4000060,5),
(2342,4230106,4003004,200),
(2343,4230106,4006000,1500),
(2344,4230106,4004001,1500),
(2345,4230106,4020005,600),
(2346,4230106,4010004,600),
(2347,4230300,1032011,2400),
(2348,4230300,1302016,7000),
(2349,4230300,1102001,2400),
(2350,4230300,1072109,2400),
(2351,4230300,2000003,400),
(2352,4230300,2000006,400),
(2353,4230300,2000002,400),
(2354,4230300,2070002,10000),
(2355,4230300,4000021,200),
(2356,4230300,4006000,1500),
(235...2151 row(s) affected
Records: 2151 Duplicates: 0 Warnings: 00.078 sec 2 149 03:30:23 INSERT INTO `monsterdrops` (`monsterdropid`,`monsterid`,`itemid`,`chance`) VALUES
(4381,8141300,1061118,3000),
(4382,8141300,1092027,5000),
(4383,8141300,1002271,3000),
(4384,8141300,1051095,3000),
(4385,8141300,1072207,3000),
(4386,8141300,1002365,3000),
(4387,8141300,1452011,8000),
(4388,8141300,1072183,3000),
(4389,8141300,1050089,3000),
(4390,8141300,1051083,3000),
(4391,8141300,1061117,3000),
(4392,8141300,2020013,400),
(4393,8141300,2000006,400),
(4394,8141300,2002001,400),
(4395,8141300,2000002,400),
(4396,8141300,2040701,12000),
(4397,8141300,4004004,1500),
(4398,8141300,4020006,600),
(4399,8141300,4030012,300),
(4400,8141300,4010006,600),
(4401,8142000,1442010,7000),
(4402,8142000,1432007,8000),
(4403,8142000,1082116,3000),
(4404,8142000,1002339,3000),
(4405,8142000,1072212,3000),
(4406,8142000,1040111,3000),
(4407,8142000,1060100,3000),
(4408,8142000,1051056,3000),
(4409,8142000,1051096,3000),
(4410,8142000,1082107,3000),
(4411,8142000,1050076,3000),
(4412,8142000,1082112,3000),
(4413,8142000,1452013,8000),
(4414,8142000,1050091,3000),
(4415,8142000,1041100,3000),
(4416,8142000,1060099,3000),
(4417,8142000,1040110,3000),
(4418,8142000,1332023,8000),
(4419,8142000,1060097,3000),
(4420,8142000,2020015,400),
(4421,8142000,2000005,400),
(4422,8142000,2002001,400),
(4423,8142000,2000002,400),
(4424,8142000,2041022,12000),
(4425,8142000,2044001,12000),
(4426,8142000,4004004,1500),
(4427,8142000,4000149,5),
(4428,8142000,4006000,1500),
(4429,8142000,4020003,600),
(4430,8140702,1082141,3000),
(4431,8140702,1050092,3000),
(4432,8140702,1072206,3000),
(4433,8140702,1452017,9000),
(4434,8140702,1002325,3000),
(4435,8140702,1061116,3000),
(4436,8140703,1072212,3000),
(4437,8140703,1442020,9000),
(4438,8140703,1322029,9000),
(4439,8140703,1040122,3000),
(4440,8140703,1060111,3000),
(4441,8140703,1082151,3000),
(4442,8140703,1051082,3000),
(4443,8140703,1082159,3000),
(4444,8140703,4000265,5),
(4445,8150300,1082129,3000),
(4446,8150300,1002365,3000),
(4447,8150300,1072223,3000),
(4448,8150300,1050089,3000),
(4449,8150300,1050090,3000),
(4450,8150300,1452017,9000),
(4451,8150300,1060106,3000),
(4452,8150300,1061116,3000),
(4453,8150300,1040117,3000),
(4454,8150300,2000006,400),
(4455,8150300,2000005,400),
(4456,8150300,4006001,1500),
(4457,8142100,1032017,3000),
(4458,8142100,1422010,8000),
(4459,8142100,1092025,5000),
(4460,8142100,1412009,8000),
(4461,8142100,1092026,5000),
(4462,8142100,1092028,5000),
(4463,8142100,1072197,3000),
(4464,8142100,1072220,3000),
(4465,8142100,1050095,3000),
(4466,8142100,1051097,3000),
(4467,8142100,1050090,3000),
(4468,8142100,1051084,3000),
(4469,8142100,1060099,3000),
(4470,8142100,1040110,3000),
(4471,8142100,1002325,3000),
(4472,8142100,1041118,3000),
(4473,8142100,2000005,400),
(4474,8142100,2040804,12000),
(4475,8142100,2040801,12000),
(4476,8142100,4006001,1500),
(4478,8142100,4010004,600),
(4479,8142100,4130000,1000),
(4480,8142100,4130001,1000),
(4481,8141100,1082105,3000),
(4482,8141100,1051080,3000),
(4483,8141100,1402015,8000),
(4484,8141100,1050081,3000),
(4485,8141100,1051058,3000),
(4486,8141100,1050093,3000),
(4487,8141100,1082134,3000),
(4488,8141100,1072165,3000),
(4489,8141100,1072185,3000),
(4490,8141100,1462012,8000),
(4491,8141100,1050077,3000),
(4492,8141100,1051083,3000),
(4493,8141100,1041107,3000),
(4494,8141100,1332023,8000),
(4495,8141100,1082119,3000),
(4496,8141100,1002329,3000),
(4497,8141100,1061115,3000),
(4498,8141100,1060106,3000),
(4499,8141100,2000006,400),
(4500,8141100,2000005,400),
(4501,8141100,2043002,8000),
(4502,8141100,4004004,1500),
(4503,8141100,4000135,5),
(4504,8141100,4006001,1500),
(4505,8141100,4020008,600),
(4506,8141100,4130011,1000),
(4507,8141100,4131003,1000),
(4508,8143000,1092016,5000),
(4509,8143000,1002339,3000),
(4510,8143000,1082117,3000),
(4511,8143000,1422012,8000),
(4512,8143000,1082130,3000),
(4513,8143000,1041119,3000),
(4514,8143000,1061118,3000),
(4515,8143000,1082122,3000),
(4516,8143000,...2164 row(s) affected
Records: 2164 Duplicates: 0 Warnings: 00.062 sec 2 150 INSERT INTO `monsterdrops` (`monsterdropid`,`monsterid`,`itemid`,`chance`) VALUES
(6620,2230107,1402000,7000),
(6621,2230107,1082026,2400),
(6622,2230107,2041004,12000),
(6623,2230107,1041034,2400),
(6624,2230107,1062006,2400),
(6625,2230107,4020005,600),
(6626,2230107,1072051,2400),
(6627,2230107,1332004,7000),
(6628,2230107,1041051,2400),
(6629,2230107,1061047,2400),
(6630,2230107,1061054,2400),
(6631,2230107,1041058,2400),
(6632,2230106,4000163,5),
(6633,2230106,2040001,12000),
(6634,2230106,1061033,2400),
(6635,2230106,1002146,2400),
(6636,2230106,1002158,2400),
(6637,2230106,2040401,12000),
(6638,2230106,1041050,2400),
(6639,2230106,1061046,2400),
(6640,2230106,1332009,7000),
(6641,2230106,1040040,2400),
(6642,2230106,1060060,2400),
(6643,2230105,4000161,5),
(6644,2230105,2040900,4500),
(6645,2230105,1312003,7000),
(6646,2230105,1322004,7000),
(6647,2230105,1072007,2400),
(6648,2230105,1082016,2400),
(6649,5130104,2060000,200),
(6650,5130104,2061000,200),
(6651,5130104,1332017,7000),
(6652,2230104,2060000,200),
(6653,2230104,2061000,200),
(6654,2230104,1332010,7000),
(6655,2230104,1002162,2400),
(6656,2230104,1082042,2400),
(6657,5130105,4000021,200),
(6658,5130105,4010005,600),
(6659,5130105,1041086,2400),
(6660,5130105,1041082,2400),
(6661,5130105,1061081,2400),
(6662,5130105,1002208,2400),
(6663,5130105,1002216,2400),
(6664,5130105,1032021,2400),
(6665,5130105,1102015,2400),
(6666,5130105,1072138,2400),
(6667,5130105,1082059,2400),
(6668,5130105,1082090,2400),
(6669,5130105,1092010,5000),
(6670,5130105,1040102,3000),
(6671,5130105,1060090,3000),
(6672,7110300,2000006,400),
(6673,7110300,4020001,600),
(6674,7110300,4010003,600),
(6675,7110300,2043701,12000),
(6676,7110300,2044701,12000),
(6677,7110300,4004000,1500),
(6678,7110300,4006000,1500),
(6679,7110300,2040302,8000),
(6680,7110300,1050055,2400),
(6681,7110300,1041094,2400),
(6682,7110300,1061093,2400),
(6683,7110300,1050069,2400),
(6684,7110300,1040102,3000),
(6685,7110300,1060090,3000),
(6686,7110300,1082100,3000),
(6687,7110300,1041102,3000),
(6688,7110300,1061101,3000),
(6689,7110300,1002254,3000),
(6690,7110300,1002288,3000),
(6691,7110300,1092015,5000),
(6692,7110300,1332018,8000),
(6693,7110300,1402012,8000),
(6694,7110300,1472029,8000),
(6695,7110300,1322020,8000),
(6696,7110300,1002273,3000),
(6697,7110300,1002339,3000),
(6698,7110300,1051066,3000),
(6699,7110300,1041105,3000),
(6700,7110300,1061104,3000),
(6701,7110300,4000362,5),
(6702,2230103,1302003,7000),
(6703,7110301,2000006,400),
(6704,7110301,2000004,400),
(6705,7110301,4010004,600),
(6706,7110301,4020006,600),
(6707,7110301,4004003,1500),
(6708,7110301,2044601,12000),
(6709,7110301,1051044,2400),
(6710,7110301,1002029,2400),
(6711,7110301,1002248,2400),
(6712,7110301,1051041,2400),
(6713,7110301,1072147,2400),
(6714,7110301,1072150,2400),
(6715,7110301,1072145,2400),
(6716,7110301,1051053,2400),
(6717,7110301,1002094,3000),
(6718,7110301,1002253,3000),
(6719,7110301,1051062,3000),
(6720,7110301,1040105,3000),
(6721,7110301,1060093,3000),
(6722,7110301,1050063,3000),
(6723,7110301,1402012,8000),
(6724,7110301,1040108,3000),
(6725,7110301,1060097,3000),
(6726,7110301,1072210,3000),
(6727,7110301,1002275,3000),
(6728,7110301,1072177,3000),
(6729,7110301,4000361,5),
(6730,2230102,2060000,200),
(6731,2230102,1072033,2400),
(6732,2230102,4031226,300),
(6733,2230102,2061000,200),
(6734,2230102,1002151,2400),
(6735,2230102,1060050,2400),
(6736,2230102,1452005,7000),
(6737,2230102,1462004,7000),
(6738,2230102,1002166,2400),
(6739,2230102,1412005,7000),
(6740,5130103,4020007,600),
(6741,5130103,1051038,2400),
(6742,2230101,2060000,200),
(6743,2230101,2061000,200),
(6744,2230101,1040009,2400),
(6745,2230101,4010003,600),
(6746,2230101,2000002,400),
(6747,2230101,1050030,2400),
(6748,2230101,1050031,2400),
(6749,2230101,1432003,7000),
(6750,2230101,1002035,2400),
(6751,2230101,1312007,7000),
(6752,2230101,1040021,2400),
(6753,5130100,2002004,400),
(6754,5130100,109200...2144 row(s) affected
Records: 2144 Duplicates: 0 Warnings: 00.063 sec 2 151 03:30:23 INSERT INTO `monsterdrops` (`monsterdropid`,`monsterid`,`itemid`,`chance`) VALUES
(8833,9400202,1072095,1477),
(8834,9400202,1072096,1477),
(8835,9400202,1072097,1477),
(8836,9400202,1072180,1477),
(8837,9400202,1072175,1477),
(8838,9400202,1072181,1477),
(8839,9400202,1072186,1477),
(8840,9400202,1072187,1477),
(8841,9400202,1072188,1477),
(8842,9400202,1072189,1477),
(8843,9400202,1072190,1477),
(8844,9400202,1072191,1477),
(8845,9400202,1072199,1477),
(8846,9400202,1072200,1477),
(8847,9400202,1072202,1477),
(8848,9400202,1072217,1477),
(8849,9400202,1072218,1477),
(8850,9400202,1072219,1477),
(8851,9400202,1072230,1477),
(8852,9400202,1072231,1477),
(8853,9400202,1072232,1477),
(8854,9400202,1072233,1477),
(8855,9400202,1072234,1477),
(8856,9400202,1072235,1477),
(8857,9400202,1072236,1477),
(8858,9400202,1072237,1477),
(8859,9400202,1072240,1477),
(8860,9400202,1072241,1477),
(8861,9400202,1072242,1477),
(8862,9400202,1072243,1477),
(8863,9400202,1072244,1477),
(8864,9400202,1072245,1477),
(8865,9400202,1072246,1477),
(8866,9400202,1072247,1477),
(8867,9400202,1072250,1477),
(8868,9400202,1072251,1477),
(8869,9400202,1072252,1477),
(8870,9400202,1072253,1477),
(8871,9400202,1072254,1477),
(8872,9400202,1072255,1477),
(8873,9400202,1072256,1477),
(8874,9400202,1072257,1477),
(8875,9400202,1072258,1477),
(8876,9400202,1072259,1477),
(8877,9400202,1072260,1477),
(8878,9400202,1072265,1477),
(8879,9400202,1072266,1477),
(8880,9400202,1072267,1477),
(8881,9400202,1072270,1477),
(8882,9400202,1072271,1477),
(8883,9400202,1072274,1477),
(8884,9400202,1072276,1477),
(8885,9400202,1072277,1477),
(8886,9400202,1072278,1477),
(8887,9400202,1072279,1477),
(8888,9400202,1072280,1477),
(8889,9400202,1072327,1477),
(8890,9400202,1072328,1477),
(8891,9400202,1072329,1477),
(8892,9400202,1072336,1477),
(8893,9400202,1072333,1477),
(8894,9400202,1072334,1477),
(8895,9400202,1072335,1477),
(8896,9400202,1072337,1477),
(8897,9400202,1072330,1477),
(8898,9400202,1072331,1477),
(8899,9400202,1072332,1477),
(8900,9400202,1072348,1477),
(8901,9400202,1702152,1477),
(8902,9400202,1702144,1477),
(8903,9400202,1702148,1477),
(8904,9400202,1702151,1477),
(8905,9400202,1702136,1477),
(8906,9400202,1702141,1477),
(8907,9400202,1702142,1477),
(8908,9400202,1702124,1477),
(8909,9400202,1702143,1477),
(8910,9400202,1702137,1477),
(8911,9400202,1702138,1477),
(8912,9400202,1702139,1477),
(8913,9400202,1702114,1477),
(8914,9400202,1702140,1477),
(8915,9400202,1702118,1477),
(8916,9400202,1702119,1477),
(8917,9400202,1702120,1477),
(8918,9400202,1702123,1477),
(8919,9400202,1702115,1477),
(8920,9400202,1702102,1477),
(8921,9400202,1702121,1477),
(8922,9400202,1702000,1477),
(8923,9400202,1702001,1477),
(8924,9400202,1702004,1477),
(8925,9400202,1702005,1477),
(8926,9400202,1702006,1477),
(8927,9400202,1702007,1477),
(8928,9400202,1702008,1477),
(8929,9400202,1702010,1477),
(8930,9400202,1702011,1477),
(8931,9400202,1702012,1477),
(8932,9400202,1702013,1477),
(8933,9400202,1702015,1477),
(8934,9400202,1702016,1477),
(8935,9400202,1702018,1477),
(8936,9400202,1702019,1477),
(8937,9400202,1702020,1477),
(8938,9400202,1702021,1477),
(8939,9400202,1702022,1477),
(8940,9400202,1702023,1477),
(8941,9400202,1702027,1477),
(8942,9400202,1702028,1477),
(8943,9400202,1702036,1477),
(8944,9400202,1702037,1477),
(8945,9400202,1702039,1477),
(8946,9400202,1702041,1477),
(8947,9400202,1702042,1477),
(8948,9400202,1702043,1477),
(8949,9400202,1702044,1477),
(8950,9400202,1702045,1477),
(8951,9400202,1702047,1477),
(8952,9400202,1702048,1477),
(8953,9400202,1702050,1477),
(8954,9400202,1702051,1477),
(8955,9400202,1702052,1477),
(8956,9400202,1702053,1477),
(8957,9400202,1702054,1477),
(8958,9400202,1702056,1477),
(8959,9400202,1702057,1477),
(8960,9400202,1702058,1477),
(8961,9400202,1702059,1477),
(8962,9400202,1702060,1477),
(8963,9400202,1702063,1477),
(8964,9400202,1702064,1477),
(8966,9400202,1702066,1477),
(8967,9400202,1702065...1515 row(s) affected
Records: 1515 Duplicates: 0 Warnings: 00.047 sec 1 152 03:30:23 /*!40000 ALTER TABLE `monsterdrops` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'monsterdrops' doesn't have this option0.000 sec 1 153 03:30:23 --
-- Definition of table `monsterquestdrops`
--
DROP TABLE IF EXISTS `monsterquestdrops`0 row(s) affected, 1 warning(s):
1051 Unknown table 'monsterquestdrops'0.000 sec 2 154 03:30:23 CREATE TABLE `monsterquestdrops` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`itemid` int(10) unsigned NOT NULL,
`monsterid` int(10) unsigned NOT NULL,
`chance` int(10) unsigned NOT NULL,
`questid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 155 03:30:23 --
-- Dumping data for table `monsterquestdrops`
--
/*!40000 ALTER TABLE `monsterquestdrops` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'monsterquestdrops' doesn't have this option0.000 sec 2 156 03:30:23 INSERT INTO `monsterquestdrops` (`id`,`itemid`,`monsterid`,`chance`,`questid`) VALUES
(82,4001004,3230100,9600,2001),
(83,4031164,9500108,320,2084),
(84,4031098,4230113,1200,3231),
(85,4001005,5130102,2400,2047),
(86,4001005,5130102,2400,2044),
(87,4031146,1110100,80,2065),
(88,4031147,1130100,80,2065),
(89,4031311,5300000,80,3093),
(90,4031405,3210100,4800,2017),
(91,4031405,9420503,4800,2017),
(92,4031189,6230300,1800,3448),
(93,4031195,6230300,1200,3449),
(94,4031846,1210100,600,2173),
(95,4031846,130101,600,2173),
(96,4031412,7130501,2400,3712),
(97,4031413,8140111,2400,3712),
(98,4031414,8150201,2400,3712),
(99,4031415,8150302,2400,3712),
(100,8150100,4031255,2400,3078),
(101,8150100,4031254,2400,3078),
(102,8150100,4031252,2400,3078),
(103,8150101,4031255,2400,3078),
(104,8150101,4031254,2400,3078),
(105,8150101,4031252,2400,3078),
(106,4031831,2230102,320,2071),
(107,4031259,2230105,600,3080),
(108,4031260,2230106,600,3080),
(109,4031261,2230108,600,3080),
(110,4031262,2230200,600,3081),
(111,4031263,2230111,600,3081),
(112,4031264,2230109,600,3081),
(113,4031265,4230200,600,3082),
(114,4031266,4230123,600,3082),
(115,4031267,4230124,600,3082),
(116,4031568,2100108,800,3911),
(117,4031523,9400509,240,8848),
(118,4031527,3110101,320,8849),
(119,4031102,4240000,80,3413),
(120,4031103,4230116,2400,3414),
(121,4031104,4230117,1600,3414),
(122,4031105,4230118,800,3414),
(123,4031106,4240000,80,3414),
(124,4031309,3230200,1200,3088),
(125,4031309,4230106,1200,3088),
(126,4031309,5120000,1200,3088),
(127,4031251,8140600,800,3076),
(128,4031256,8140600,1800,3076),
(129,4031253,8510000,50,3076),
(130,4031253,8520000,50,3076),
(131,4001075,8150200,1600,7301),
(132,4001076,8180000,50,7301),
(133,4001078,8150200,1600,7301),
(134,4001077,8150300,800,7301),
(135,4001077,8150301,800,7301),
(136,4001077,8150302,800,7301),
(137,4001103,8150200,1600,7303),
(138,4001104,8180000,50,7303),
(139,4001078,8150200,1600,7303),
(140,4001105,8150300,800,7303),
(141,4001105,8150301,800,7303),
(142,4001105,8150302,800,7303),
(143,4031135,3230400,320,3438),
(144,4031140,3230400,320,3440),
(145,4031674,4230116,240,4916),
(146,4001006,3210200,9600,2048),
(147,4001006,3210201,9600,2048),
(148,4001006,6130100,9600,2048),
(149,4001006,9420511,9600,2048),
(150,4031232,7130400,1,3611),
(151,4031233,7130401,1,3611),
(152,4031234,7130402,1,3611),
(153,4031680,9400543,120,4914),
(154,4031681,9400546,120,4915),
(155,4031170,6230400,240,7100),
(156,4031170,6130200,240,7100),
(157,4031170,6230300,240,7100),
(158,4031170,6230500,240,7100),
(159,4031175,6230400,80,7101),
(160,4031175,6130200,80,7101),
(161,4031175,6230300,80,7101),
(162,4031175,6230500,80,7101),
(163,4031171,7130300,120,7101),
(164,4031172,8160000,800,7103),
(165,4031172,8170000,800,7103),
(166,4000299,5120506,320,3803),
(167,4031433,6130209,600,3804),
(168,4031159,3230306,800,2074),
(169,4001094,8810018,1,3706),
(170,4031090,4230119,600,3227),
(171,4001118,9300119,600,3814),
(172,4031525,3230308,320,8868),
(173,4031243,4230119,800,3441),
(174,4031089,3230302,800,3223),
(175,4031524,3210201,240,8848),
(176,4031269,2230106,800,3631),
(177,4031268,5100003,240,3631),
(178,4031115,4230112,600,3416),
(179,4031279,3210208,30,3632),
(180,4031222,6130201,1200,3621),
(181,4031200,4230105,9600,3048),
(182,4031212,4230100,240,2096),
(183,4031213,6230100,240,2097),
(184,4031214,7130100,240,2097),
(185,4031215,7130101,240,2097),
(186,4031675,4230113,320,4917),
(187,4031218,5130107,1200,3071),
(188,4031218,5130108,1200,3071),
(189,4031432,5120506,1800,3810),
(190,4031773,130100,320,2145),
(191,4031773,1110101,280,2145),
(192,4031773,1130100,240,2145),
(193,4031773,2130100,200,2145)112 row(s) affected
Records: 112 Duplicates: 0 Warnings: 00.000 sec 1 157 03:30:23 /*!40000 ALTER TABLE `monsterquestdrops` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'monsterquestdrops' doesn't have this option0.000 sec 1 158 03:30:23 --
-- Definition of table `mts_cart`
--
DROP TABLE IF EXISTS `mts_cart`0 row(s) affected, 1 warning(s):
1051 Unknown table 'mts_cart'0.000 sec 2 159 03:30:23 CREATE TABLE `mts_cart` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.015 sec 1 160 03:30:23 --
-- Dumping data for table `mts_cart`
--
/*!40000 ALTER TABLE `mts_cart` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'mts_cart' doesn't have this option0.000 sec 1 161 03:30:23 /*!40000 ALTER TABLE `mts_cart` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'mts_cart' doesn't have this option0.000 sec 1 162 03:30:23 --
-- Definition of table `mts_items`
--
DROP TABLE IF EXISTS `mts_items`0 row(s) affected, 1 warning(s):
1051 Unknown table 'mts_items'0.000 sec 2 163 03:30:23 CREATE TABLE `mts_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tab` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
`itemid` int(10) unsigned NOT NULL DEFAULT '0',
`quantity` int(11) NOT NULL DEFAULT '1',
`seller` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '0',
`bid_incre` int(11) DEFAULT '0',
`buy_now` int(11) DEFAULT '0',
`position` int(11) DEFAULT '0',
`upgradeslots` int(11) DEFAULT '0',
`level` int(11) DEFAULT '0',
`str` int(11) DEFAULT '0',
`dex` int(11) DEFAULT '0',
`int` int(11) DEFAULT '0',
`luk` int(11) DEFAULT '0',
`hp` int(11) DEFAULT '0',
`mp` int(11) DEFAULT '0',
`watk` int(11) DEFAULT '0',
`matk` int(11) DEFAULT '0',
`wdef` int(11) DEFAULT '0',
`mdef` int(11) DEFAULT '0',
`acc` int(11) DEFAULT '0',
`avoid` int(11) DEFAULT '0',
`hands` int(11) DEFAULT '0',
`speed` int(11) DEFAULT '0',
`jump` int(11) DEFAULT '0',
`locked` int(11) DEFAULT '0',
`isequip` int(1) DEFAULT '0',
`owner` varchar(16) DEFAULT '',
`sellername` varchar(16) NOT NULL,
`sell_ends` varchar(16) NOT NULL,
`transfer` int(2) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 164 03:30:23 --
-- Dumping data for table `mts_items`
--
/*!40000 ALTER TABLE `mts_items` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'mts_items' doesn't have this option0.000 sec 1 165 03:30:23 /*!40000 ALTER TABLE `mts_items` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'mts_items' doesn't have this option0.000 sec 1 166 --
-- Definition of table `notes`
--
DROP TABLE IF EXISTS `notes`0 row(s) affected, 1 warning(s):
1051 Unknown table 'notes'0.000 sec 2 167 03:30:23 CREATE TABLE `notes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`to` int(10) unsigned NOT NULL,
`from` varchar(13) NOT NULL DEFAULT '',
`message` text NOT NULL,
`timestamp` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 1 168 03:30:23 --
-- Dumping data for table `notes`
--
/*!40000 ALTER TABLE `notes` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'notes' doesn't have this option0.000 sec 1 169 03:30:23 /*!40000 ALTER TABLE `notes` ENABLE KEYS */ 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'notes' doesn't have this option0.000 sec 1 170 03:30:23 --
-- Definition of table `nxcode`
--
DROP TABLE IF EXISTS `nxcode`0 row(s) affected, 1 warning(s):
1051 Unknown table 'nxcode'0.000 sec 2 171 03:30:23 CREATE TABLE `nxcode` (
`code` varchar(15) NOT NULL,
`valid` int(11) NOT NULL DEFAULT '1',
`user` varchar(13) DEFAULT NULL,
`type` int(11) NOT NULL DEFAULT '0',
`item` int(11) NOT NULL DEFAULT '10000',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin10 row(s) affected 0.000 sec 2 172 03:30:23 --
-- Dumping data for table `nxcode`
--
/*!40000 ALTER TABLE `nxcode` DISABLE KEYS */0 row(s) affected 0.000 sec 2 03:30:23 /*!40000 ALTER TABLE `nxcode` ENABLE KEYS */ 0 row(s) affected 0.000 sec 1 174 03:30:23 --
-- Definition of table `pets`
--
DROP TABLE IF EXISTS `pets`0 row(s) affected, 1 warning(s):
1051 Unknown table 'pets'0.000 sec 2 CREATE TABLE `pets` (
`petid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(13) DEFAULT NULL,
`level` int(10) unsigned NOT NULL,
`closeness` int(10) unsigned NOT NULL,
`fullness` int(10) unsigned NOT NULL,
PRIMARY KEY (`pe
) ENGINE=InnoDB DEFAULT CHARSET=latin10 row(s) affected 0.016 sec 1 176 03:30:23 --
-- Dumping data for table `pets`
--
/*!40000 ALTER TABLE `pets` DISABLE KEYS */0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'pets' doesn't have this option0.000 sec 1 177 0 row(s) affected, 1 warning(s):
1031 Table storage engine for 'pets' doesn't have this option0.000 sec 178 03:30:23 0 row(s) affected, 1 warning(s):
1051 Unknown table 'playernpcs'0.000 sec 0 179 03:30:23
What the..? Why are you posting the whole script? Post the specific error you get.
Any kind person would like to help me :(
Quote:
Originally Posted by LazyHoe
.....Quote:
Originally Posted by Fraysa
http://img541.imageshack.us/img541/6668/soqq.jpgQuote:
Originally Posted by Fraysa
Please help me :( i can let you remote my RDC :( Million thanks
Is you export this sql from query browser or navicat ??Quote:
Originally Posted by LazyHoe
This maybe caused by incompatible of SQL syntax if I not mistaken
The image is very small, but from what I can see..
Line 16.
Before:
There is:Quote:
-- Temporary table structure for view `readable_last_hour_cheatlog`
Change that to:Quote:
-
Quote:
--
So any method to fix? :(Quote:
Originally Posted by chaos3312
I don't get what your mean :(
I don't get what your mean :(Quote:
Originally Posted by Fraysa
1. Right click your SQL Script -> Open with... Notepad.Quote:
Originally Posted by LazyHoe
2. Hold the ctrl key and the F key and the same time.
3. A little box should pop up.
4. Enter "-- Temporary table structure for view `readable_last_hour_cheatlog`" (Without "") in the text field.
5. Press "Find Next".
6. Locate the little:
7. Replace that with:Quote:
-
8. ???Quote:
--
9. PROFIT.
Conclusion: The MapleStory community gets dumber every year and is dead. Also your avatar shows as if you're suffering from a sexual transmitted disease. That or you're just homosexual.
Xiuzsource SQL file's near line 11470.
Are there Syntax Error?
Modify to:Quote:
Originally Posted by LazyHoe
"(`pe" -->> "(`petid`)"PHP Code:CREATE TABLE `pets` (
`petid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(13) DEFAULT NULL,
`level` int(10) unsigned NOT NULL,
`closeness` int(10) unsigned NOT NULL,
`fullness` int(10) unsigned NOT NULL,
PRIMARY KEY (`petid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Quote:
Conclusion: The MapleStory community gets dumber every year and is dead.
People don't even try to think anymore. They see an error and instantly go "OMFG THIS SO HARDDDDDDD!"
90% of the time it's people who can't even set-up a server.