Development v117.2 Source

Page 1 of 18 12345678911 ... LastLast
Results 1 to 15 of 270
  1. #1
    #Orion Eric is online now
    ModeratorRank
    Jan 2010 Join Date
    DEV CityLocation
    2,903Posts

    Development v117.2 Source


    RaGEZONE Recommends

    RaGEZONE Recommends

    This source has (iirc) a lot of copy-pasted code from my old v75/v83 sources I had used a while back and a lot of sloppy methods I never did clean up. This source is nowhere near "clean", and i'm not sure how stable it is either, so no h8 pls :(

    Oh, and do note, this was a very very WZ edited server. There may be links to a lot of customs here and there, though I will not be providing links to the WZs or the XMLs.

    Features:
    Code:
    Multi-World support was started and works. You don't see other players on other worlds. 
    
    Fixed damage calculation with no damage cap client, allows the actual damage to hit bosses and stuff
    
    Fixed 3rd party damages (doesnt show someone hitting 3mill when they hit 24 damage)
    
    Fixed 3rd party critical damage and shadow partner hits
    
    OdinMS v62 PvP system was implemented in here for a 1v1 system I implemented but removed. 
    
    All PQs work (even ones that dont in the other sources), * means they dont match GMS's text, + means they do
    [+] Mu Lung Dojo
    [+] Monster Carnival PQ
    [+] The 2nd Monster Carnival (Disabled)
    [+] Ariant PQ
    [+] El Nath PQ (Protect Tylus)
    [+] Ludi PQ (Dimensional Crack)
    [+] Romeo and Juliet PQ
    [+] Resurrection of the Hoblin King
    [+] MV's Lair (Guy Fawkes PQ)[*] Ravana Boss Fight (Golden Temple)[*] Kerning PQ (First Time Together)[*] Lord Pirate[*] Dragon's Nest[*] Monster Park[*] Visitor PQ[*] Moon Bunny PQ[*] Forest of Poison Haze[*] Zakum & Chaos Zakum Boss Fight[*] Von Leon Boss Fight[*] Pink Bean Boss Fight[*] Cygnus Boss Fight[*] Orbis PQ (Remnant of the Goddess)[*] Dual Raid[*] Fight For Azwan (Supply Mode)[*] Hilla PQ (Hilla Expedition)[*] Arkarium Boss Fight (TODO: Fix Squad warping?)[*] Amorian PQ 
    
    Battle Square PvP is fully functional, however I did not fix the merchant shop and I forgot if the packet for updating the pvp player stat still crashed or not. 
    
    Boats are functional, my TODO list was to fix all of them and make them GMS-like, but the Balrogs effect and spawn is working and you can travel around.
    
    For the most part Professions and Crafting etc should work.
    
    Skill Points are GMS-like, no skill maxing. All SP has been fixed and 4th job SP works too. The only thing I didn't fix was Job advancing SP. So after job advancing they'll have to level to get more SP which isnt gms-like
    
    Giant potions and most consumable items are working and don't map crash.
    
    I had started working on Azwan, i had copied some stuff from FuckMS and Helisium I think, not sure if I kept it.
    
    Knights of Cygnus work and I think their max level is 120. Creating Ultimate Explorers works as well, though it is not GMS-like yet.
    
    Amoria works. Weddings and marriages are working as well as Spouse Chat and Marriage Ring Effects which I don't think is on any source released.
    
    MiniGames are also fully working but not GMS-like. Hired Merchants are also fully working and fixed, Fredrick works as well. Player Shops are also working perfectly, however I did not finish the Matchcard games.
    
    3rd party effects have been fixed, so you're able to view other players' cash items and etc.
    
    I had started working on Mastery Books in summoning bags, though I never finished. The OP's/packets should be updated though.
    
    Guilds are working, guild skills should save, and the Guild Rank Board packet has been fixed so it loads the correct rankings.
    
    Ring effects are 100% working for all parties 1st to 3rd. Friendship/crush shirts work too.
    
    GM Hide works and when talking broadcasts only to GMs. Super Hide is implemented to hide Admins in which GMs can not see them.
    
    Commands work and are done using Java 7's String-switching feature rather than using methods.
    
    Bombs are working as AriantPQ was finished and working. You do however need WZ Edits to play because Nexon deleted the maps to Ariant in v117.2. By importing the AriantPQ maps back into v117.2, AriantPQ will be playable.
    
    The EXP Table was updated and matches v117.2 correctly, thanks to Dynamik.
    
    GMLog and DonorLog files which logs all commands used by GMs/Donors. Excludes Admins.
    
    Mu Lung Dojo was beginning to be implemented GMS-like. It has a working Dojo Ranking board but most functions weren't complete yet.
    
    The Reporting/Claim system works and also messages GMs the report/reason against the player after.
    
    Parties are also working and I have fixed Party Searching as well.
    
    I had implemented a Clan system to fit a server feature we were making. I think it's finished, though.
    
    The extra Pendant Slot and the Pocket slot is automatically assigned to GMs, but the GMS-like items/quests weren't worked on.
    
    The loginscreen was changed back to v117.1's Mihile design.
    
    I had implemented the ToS agreement but never finished it so it's disabled but in there still.
    Be warned:
    - you're going to see a lot of silly stuff in here along with some ancient RZ releases.
    - there's no property files, so if u get compiel eror pls help, this isn't for you
    - when i first worked on this source i named the server maple ascension, though the name got taken so i changed it to Development. you may see some maple ascension things in here.
    - no clue where i got my npc's but a lot of them include custom items and might dc you, watch out.

    Downloads:
    Mediafire: https://www.mediafire.com/?5laorcx03058bfn
    Localhostr (Includes WORKING SQL folder): https://hostr.co/AVeKB2pUcDtn

    Credits:
    Axed - Their source was the best base imo.
    Paul - Continued this because of him, and brought a lot of the text to NPC's
    Adrian - Spent hours getting GMS texts from every npc of every PQ and every notice available

    Some screenshots:
    Spoiler:









    As an addition, I'll be including Development's Launcher. It was something enjoyable to me because it was my first C# project I had ever worked on.

    Features:
    Code:
    Automatic WZ Patching (Checks for updates)
    
    Client Hacks:
    Infinite Flash Jump (Manual UFJ)
    Multi-client (Play 2 MapleStory's at once)
    Droppable NX (Drop NX items from Equip,Use, and Cash inventories without a command)
    
    Launcher design:
    Scrolling notice
    Animated slideshow of banners
    WPF Format for transparency
    Click-to-move window
    Top 5 rankings based on reborns and level (>More button)
    News, Announcements, and Updates section (>More button)
    Vote, Forum, and Website buttons
    
    What was left to do:
    Remove unused methods I randomly added but never finished
    Add in a Tray icon with functions
    Add in an Exit/Minimize button on design
    Update client addresses for Tubi,Super Tubi, UFJ, Infinite Text, Spam, and No Breath
    Download:
    Mediafire - https://www.mediafire.com/?85ymamnzkaz2tdq

    Credits:
    Kevin - design of the launcher
    AxedMS - used their WriteProcessMemory methods
    LittleClgt - provided me client addys
    DeathRight - I had ended up using this guy's Patcher because I got tired of working on my own.

    Screenshot:
    Last edited by Eric; 08-12-14 at 01:02 AM.


  2. #2
    Account Upgraded | Title Enabled! Lowsir is offline
    True MemberRank
    Mar 2011 Join Date
    1,010Posts

    Re: Development v117.2 Source

    Maybe, you should have released it on the christmas..x-mas..thing.

  3. #3
    Member TamixPro is offline
    MemberRank
    Oct 2014 Join Date
    Lima, PeruLocation
    34Posts

    Re: Development v117.2 Source

    Nice Good Job

  4. #4
    #Orion Eric is online now
    ModeratorRank
    Jan 2010 Join Date
    DEV CityLocation
    2,903Posts

    Re: Development v117.2 Source

    Quote Originally Posted by Lowsir View Post
    Maybe, you should have released it on the christmas..x-mas..thing.
    Well, I wasn't really planning on doing a Christmas release.. It just so happened to be released in December. Consider it an early Christmas release I guess xD

  5. #5
    Interesting... SharpAceX is offline
    SubscriberRank
    Oct 2008 Join Date
    1,901Posts

    Re: Development v117.2 Source

    Quick, take it down and repost this on Xmas!
    http://alanmorel.com/

    MapleStory Development Discord:
    https://discord.gg/9nv3GPQ

  6. #6
    #Orion Eric is online now
    ModeratorRank
    Jan 2010 Join Date
    DEV CityLocation
    2,903Posts

    Re: Development v117.2 Source

    Quote Originally Posted by BloodAngel13 View Post
    Quick, take it down and repost this on Xmas!
    Early Christmas presents are the best, bro! :(

  7. #7
    CSG sunnyboy is offline
    The OmegaRank
    Mar 2010 Join Date
    6,173Posts

    Re: Development v117.2 Source

    Quote Originally Posted by chunkarama View Post
    Early Christmas presents are the best, bro! :(
    early christmas leecher proof gift

    Code:
     public boolean is_inc_exp_item(int ItemID) {
            return ItemID / 10000 == 521;
        }

  8. #8
    Hardcore Member gaspartx is offline
    MemberRank
    Apr 2009 Join Date
    BrazilLocation
    102Posts

    Re: Development v117.2 Source



    I can not log in
    Last edited by gaspartx; 03-12-14 at 07:01 PM.

  9. #9
    #Orion Eric is online now
    ModeratorRank
    Jan 2010 Join Date
    DEV CityLocation
    2,903Posts

    Re: Development v117.2 Source

    @gaspartx did you compile? The ToS shouldn't popup after you've compiled because it was disabled in the SRC. The dist file that was compiled isn't updated.

    Oh, and I forgot to include the SQL for that. Nothing too complicated, just execute this (make sure 'ascension' is your default MySQL Schema):

    PHP Code:
    ALTER TABLE `accountsADD COLUMN `tosint(11unsigned NOT NULL DEFAULT '1'

  10. #10
    Hardcore Member gaspartx is offline
    MemberRank
    Apr 2009 Join Date
    BrazilLocation
    102Posts

    Re: Development v117.2 Source




    1 - Failed to load character... The database is complete?
    2 - I can not register a PIC, to enter the account says I already own a PIC

  11. #11
    CSG sunnyboy is offline
    The OmegaRank
    Mar 2010 Join Date
    6,173Posts

    Re: Development v117.2 Source

    Quote Originally Posted by gaspartx View Post



    Failed to load character... The database is complete?
    no ur missing clanid column because @chunkarama did not bother to also release an updated database so all the users of this src will have errors

  12. #12
    #Orion Eric is online now
    ModeratorRank
    Jan 2010 Join Date
    DEV CityLocation
    2,903Posts

    Re: Development v117.2 Source

    Quote Originally Posted by gaspartx View Post



    Failed to load character... The database is complete?
    The database SQL included is only missing a few int(11) columns in accounts/characters, which isn't too hard to figure out. But, if you wish, here's a copy of my SQL:

    Code:
    /*!40101 SET    @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET    @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET    @old_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    
    /*!40014 SET    @old_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    /*!40014 SET    @old_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    /*!40101 SET    @old_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    
    CREATE DATABASE IF NOT EXISTS ascension;
    USE ascension;
    
    DROP TABLE IF EXISTS `accounts`;
    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,
      `2ndpassword` varchar(134) DEFAULT NULL,
      `salt2` varchar(32) DEFAULT NULL,
      `loggedin` tinyint(1) unsigned 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,
      `macs` tinytext,
      `tempban` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
      `greason` tinyint(4) unsigned DEFAULT NULL,
      `ACash` int(11) NOT NULL DEFAULT '0',
      `mPoints` int(11) NOT NULL DEFAULT '0',
      `gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
      `SessionIP` varchar(64) DEFAULT NULL,
      `points` int(11) NOT NULL DEFAULT '0',
      `vpoints` int(11) NOT NULL DEFAULT '0',
      `monthvotes` int(11) NOT NULL DEFAULT '0',
      `totalvotes` int(11) NOT NULL DEFAULT '0',
      `lastvote` int(11) NOT NULL DEFAULT '0',
      `lastvote2` int(11) NOT NULL DEFAULT '0',
      `lastlogon` timestamp NULL DEFAULT NULL,
      `lastvoteip` varchar(64) DEFAULT NULL,
      `webadmin` int(1) DEFAULT '0',
      `rebirths` int(11) NOT NULL DEFAULT '0',
      `ip` text,
      `mainchar` int(6) NOT NULL DEFAULT '0',
      `nxcredit` int(11) unsigned NOT NULL DEFAULT '0',
      `nxprepaid` int(11) unsigned NOT NULL DEFAULT '0',
      `redeemhn` int(11) unsigned NOT NULL DEFAULT '0',
      `tos` tinyint(1) unsigned NOT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `name` (`name`),
      KEY `ranking1` (`id`,`banned`,`gm`),
      KEY `id` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `achievements`;
    CREATE TABLE  `achievements` (
      `achievementid` int(9) NOT NULL DEFAULT '0',
      `charid` int(9) NOT NULL DEFAULT '0',
      `accountid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`achievementid`,`charid`),
      KEY `achievementid` (`achievementid`),
      KEY `accountid` (`accountid`),
      KEY `charid` (`charid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `alliances`;
    CREATE TABLE  `alliances` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(13) NOT NULL,
      `leaderid` int(11) NOT NULL,
      `guild1` int(11) NOT NULL,
      `guild2` int(11) NOT NULL,
      `guild3` int(11) NOT NULL DEFAULT '0',
      `guild4` int(11) NOT NULL DEFAULT '0',
      `guild5` int(11) NOT NULL DEFAULT '0',
      `rank1` varchar(13) NOT NULL DEFAULT 'Master',
      `rank2` varchar(13) NOT NULL DEFAULT 'Jr.Master',
      `rank3` varchar(13) NOT NULL DEFAULT 'Member',
      `rank4` varchar(13) NOT NULL DEFAULT 'Member',
      `rank5` varchar(13) NOT NULL DEFAULT 'Member',
      `capacity` int(11) NOT NULL DEFAULT '2',
      `notice` varchar(100) NOT NULL DEFAULT '',
      PRIMARY KEY (`id`),
      UNIQUE KEY `name` (`name`),
      KEY `id` (`id`),
      KEY `leaderid` (`leaderid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `androids`;
    CREATE TABLE  `androids` (
      `uniqueid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(13) NOT NULL DEFAULT 'Android',
      `hair` int(11) NOT NULL DEFAULT '0',
      `face` int(11) NOT NULL DEFAULT '0',
      `skin` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`uniqueid`),
      KEY `uniqueid` (`uniqueid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=511 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `asc_news`;
    CREATE TABLE  `asc_news` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `title` varchar(100) NOT NULL,
      `msg` varchar(100) NOT NULL,
      `date` varchar(8) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `auth_server_channel_ip`;
    CREATE TABLE  `auth_server_channel_ip` (
      `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`)
    ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `battlelog`;
    CREATE TABLE  `battlelog` (
      `battlelogid` int(11) NOT NULL AUTO_INCREMENT,
      `accid` int(11) NOT NULL DEFAULT '0',
      `accid_to` int(11) NOT NULL DEFAULT '0',
      `when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (`battlelogid`),
      KEY `accid` (`accid`),
      CONSTRAINT `battlelog_ibfk_1` FOREIGN KEY (`accid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `bbs_replies`;
    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 '',
      `guildid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`replyid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=1335 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `bbs_threads`;
    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,
      `startpost` text NOT NULL,
      `guildid` int(10) unsigned NOT NULL,
      `localthreadid` int(10) unsigned NOT NULL,
      PRIMARY KEY (`threadid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `buddies`;
    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',
      `groupname` varchar(16) NOT NULL DEFAULT 'ETC',
      PRIMARY KEY (`id`),
      KEY `buddies_ibfk_1` (`characterid`),
      KEY `buddyid` (`buddyid`),
      KEY `id` (`id`),
      CONSTRAINT `buddies_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=5780 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `cashshop_limit_sell`;
    CREATE TABLE  `cashshop_limit_sell` (
      `serial` int(11) NOT NULL,
      `amount` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`serial`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `cashshop_modified_items`;
    CREATE TABLE  `cashshop_modified_items` (
      `serial` int(11) NOT NULL,
      `discount_price` int(11) NOT NULL DEFAULT '-1',
      `mark` tinyint(1) NOT NULL DEFAULT '-1',
      `showup` tinyint(1) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `priority` tinyint(3) NOT NULL DEFAULT '0',
      `package` tinyint(1) NOT NULL DEFAULT '0',
      `period` tinyint(3) NOT NULL DEFAULT '0',
      `gender` tinyint(1) NOT NULL DEFAULT '0',
      `count` tinyint(3) NOT NULL DEFAULT '0',
      `meso` int(11) NOT NULL DEFAULT '0',
      `unk_1` tinyint(1) NOT NULL DEFAULT '0',
      `unk_2` tinyint(1) NOT NULL DEFAULT '0',
      `unk_3` tinyint(1) NOT NULL DEFAULT '0',
      `extra_flags` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`serial`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `character_cards`;
    CREATE TABLE  `character_cards` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `accid` int(11) NOT NULL,
      `worldid` int(11) NOT NULL,
      `characterid` int(11) NOT NULL,
      `position` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `character_slots`;
    CREATE TABLE  `character_slots` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `accid` int(11) NOT NULL DEFAULT '0',
      `worldid` int(11) NOT NULL DEFAULT '0',
      `charslots` int(11) NOT NULL DEFAULT '6',
      PRIMARY KEY (`id`),
      KEY `accid` (`accid`),
      KEY `id` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `characters`;
    CREATE TABLE  `characters` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `accountid` int(11) NOT NULL DEFAULT '0',
      `world` tinyint(1) NOT NULL DEFAULT '0',
      `name` varchar(18) NOT NULL,
      `level` int(3) unsigned NOT NULL DEFAULT '0',
      `exp` int(11) NOT NULL DEFAULT '0',
      `str` int(5) NOT NULL DEFAULT '0',
      `dex` int(5) NOT NULL DEFAULT '0',
      `luk` int(5) NOT NULL DEFAULT '0',
      `int` int(5) NOT NULL DEFAULT '0',
      `hp` int(5) NOT NULL DEFAULT '0',
      `mp` int(5) NOT NULL DEFAULT '0',
      `maxhp` int(5) NOT NULL DEFAULT '0',
      `maxmp` int(5) NOT NULL DEFAULT '0',
      `meso` int(11) NOT NULL DEFAULT '0',
      `hpApUsed` int(5) NOT NULL DEFAULT '0',
      `job` int(5) NOT NULL DEFAULT '0',
      `skincolor` tinyint(1) NOT NULL DEFAULT '0',
      `gender` tinyint(1) NOT NULL DEFAULT '0',
      `fame` int(5) NOT NULL DEFAULT '0',
      `hair` int(11) NOT NULL DEFAULT '0',
      `face` int(11) unsigned NOT NULL DEFAULT '0',
      `demonMarking` int(11) NOT NULL DEFAULT '0',
      `ap` int(11) NOT NULL DEFAULT '0',
      `map` int(11) NOT NULL DEFAULT '0',
      `spawnpoint` int(3) NOT NULL DEFAULT '0',
      `gm` int(3) 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,
      `guildid` int(10) unsigned NOT NULL DEFAULT '0',
      `guildrank` tinyint(1) unsigned NOT NULL DEFAULT '5',
      `allianceRank` tinyint(1) unsigned NOT NULL DEFAULT '5',
      `guildContribution` int(11) NOT NULL DEFAULT '0',
      `pets` varchar(13) NOT NULL DEFAULT '-1,-1,-1',
      `sp` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0,0,0',
      `subcategory` int(11) NOT NULL DEFAULT '0',
      `rank` int(11) NOT NULL DEFAULT '1',
      `rankMove` int(11) NOT NULL DEFAULT '0',
      `jobRank` int(11) NOT NULL DEFAULT '1',
      `jobRankMove` int(11) NOT NULL DEFAULT '0',
      `marriageId` int(11) NOT NULL DEFAULT '0',
      `familyid` int(11) NOT NULL DEFAULT '0',
      `seniorid` int(11) NOT NULL DEFAULT '0',
      `junior1` int(11) NOT NULL DEFAULT '0',
      `junior2` int(11) NOT NULL DEFAULT '0',
      `currentrep` int(11) NOT NULL DEFAULT '0',
      `totalrep` int(11) NOT NULL DEFAULT '0',
      `gachexp` int(11) NOT NULL DEFAULT '0',
      `fatigue` tinyint(4) NOT NULL DEFAULT '0',
      `charm` mediumint(7) NOT NULL DEFAULT '0',
      `craft` mediumint(7) NOT NULL DEFAULT '0',
      `charisma` mediumint(7) NOT NULL DEFAULT '0',
      `will` mediumint(7) NOT NULL DEFAULT '0',
      `sense` mediumint(7) NOT NULL DEFAULT '0',
      `insight` mediumint(7) NOT NULL DEFAULT '0',
      `honourExp` int(10) unsigned NOT NULL DEFAULT '0',
      `honourLevel` int(10) unsigned NOT NULL DEFAULT '1',
      `damage` int(11) NOT NULL DEFAULT '0',
      `showdamage` int(11) DEFAULT '1',
      `totalWins` int(11) NOT NULL DEFAULT '0',
      `totalLosses` int(11) NOT NULL DEFAULT '0',
      `pvpExp` int(11) NOT NULL DEFAULT '0',
      `pvpPoints` int(11) NOT NULL DEFAULT '0',
      `rebirths` int(11) NOT NULL DEFAULT '0',
      `prefix` varchar(45) DEFAULT NULL,
      `reborns` int(11) NOT NULL DEFAULT '0',
      `apstorage` int(11) NOT NULL DEFAULT '0',
      `donatorPoints` int(11) NOT NULL DEFAULT '0',
      `gmtext` int(11) NOT NULL DEFAULT '0',
      `occupationId` int(11) unsigned NOT NULL DEFAULT '1',
      `occupationExp` int(11) unsigned NOT NULL DEFAULT '0',
      `occupationLevel` int(11) unsigned NOT NULL DEFAULT '1',
      `charToggle` int(11) unsigned NOT NULL DEFAULT '0',
      `jqlevel` int(11) unsigned NOT NULL DEFAULT '1',
      `jqexp` int(11) unsigned NOT NULL DEFAULT '0',
      `pvpKills` int(11) unsigned NOT NULL DEFAULT '1',
      `pvpDeaths` int(11) unsigned NOT NULL DEFAULT '1',
      `fametoggle` int(11) unsigned NOT NULL DEFAULT '0',
      `dps` bigint(20) unsigned NOT NULL DEFAULT '0',
      `msipoints` int(11) unsigned NOT NULL DEFAULT '0',
      `muted` tinyint(1) unsigned NOT NULL DEFAULT '0',
      `unmutetime` bigint(20) unsigned NOT NULL DEFAULT '0',
      `dgm` int(11) unsigned NOT NULL DEFAULT '0',
      `gml` int(11) unsigned NOT NULL DEFAULT '0',
      `noacc` int(11) unsigned NOT NULL DEFAULT '0',
      `location` int(11) unsigned NOT NULL DEFAULT '0',
      `birthday` int(11) unsigned NOT NULL DEFAULT '0',
      `found` int(11) unsigned NOT NULL DEFAULT '0',
      `todo` int(11) unsigned NOT NULL DEFAULT '0',
      `autobuff` int(11) unsigned NOT NULL DEFAULT '0',
      `autoap` int(11) unsigned NOT NULL DEFAULT '0',
      `autotoken` int(11) unsigned NOT NULL DEFAULT '0',
      `elf` int(11) unsigned NOT NULL DEFAULT '0',
      `clanid` int(11) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `accountid` (`accountid`),
      KEY `id` (`id`),
      KEY `guildid` (`guildid`),
      KEY `familyid` (`familyid`),
      KEY `marriageId` (`marriageId`),
      KEY `seniorid` (`seniorid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `cheatlog`;
    CREATE TABLE  `cheatlog` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) unsigned NOT NULL DEFAULT '0',
      `offense` tinytext NOT NULL,
      `count` int(11) unsigned NOT NULL DEFAULT '0',
      `lastoffensetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      `param` tinytext NOT NULL,
      PRIMARY KEY (`id`),
      KEY `cid` (`characterid`) USING BTREE
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `chrimg`;
    CREATE TABLE  `chrimg` (
      `id` int(11) NOT NULL,
      `hash` varchar(255) NOT NULL,
      PRIMARY KEY (`id`),
      KEY `id` (`id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `clans`;
    CREATE TABLE  `clans` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(12) NOT NULL,
      `level` int(11) NOT NULL,
      `members` int(11) NOT NULL,
      `wins` int(11) NOT NULL,
      `message` varchar(40) NOT NULL,
      `clantag` varchar(8) NOT NULL,
      `leaderid` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `compensationlog_confirmed`;
    CREATE TABLE  `compensationlog_confirmed` (
      `chrname` varchar(25) NOT NULL DEFAULT '',
      `donor` tinyint(1) NOT NULL DEFAULT '0',
      `value` int(11) NOT NULL DEFAULT '0',
      `taken` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`chrname`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `csequipment`;
    CREATE TABLE  `csequipment` (
      `inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` bigint(20) 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',
      `ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
      `itemEXP` int(11) NOT NULL DEFAULT '0',
      `durability` int(11) NOT NULL DEFAULT '-1',
      `enhance` tinyint(3) NOT NULL DEFAULT '0',
      `potential1` int(5) NOT NULL DEFAULT '0',
      `potential2` int(5) NOT NULL DEFAULT '0',
      `potential3` int(5) NOT NULL DEFAULT '0',
      `potential4` int(5) NOT NULL DEFAULT '0',
      `potential5` int(5) NOT NULL DEFAULT '0',
      `socket1` int(5) NOT NULL DEFAULT '-1',
      `socket2` int(5) NOT NULL DEFAULT '-1',
      `socket3` int(5) NOT NULL DEFAULT '-1',
      `incSkill` int(11) NOT NULL DEFAULT '-1',
      `charmEXP` smallint(6) NOT NULL DEFAULT '-1',
      `pvpDamage` smallint(6) NOT NULL DEFAULT '0',
      `equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
      `equipExp` int(11) unsigned NOT NULL DEFAULT '0',
      `equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`inventoryequipmentid`),
      KEY `inventoryitemid` (`inventoryitemid`),
      CONSTRAINT `csequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `csitems` (`inventoryitemid`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=4500 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `csitems`;
    CREATE TABLE  `csitems` (
      `inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `accountid` int(10) DEFAULT NULL,
      `packageid` int(11) 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,
      `GM_Log` tinytext,
      `uniqueid` int(11) NOT NULL DEFAULT '-1',
      `flag` int(2) NOT NULL DEFAULT '0',
      `expiredate` bigint(20) NOT NULL DEFAULT '-1',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `sender` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`inventoryitemid`),
      KEY `inventoryitems_ibfk_1` (`characterid`),
      KEY `characterid` (`characterid`),
      KEY `inventorytype` (`inventorytype`),
      KEY `accountid` (`accountid`),
      KEY `packageid` (`packageid`),
      KEY `characterid_2` (`characterid`,`inventorytype`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8379 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `dojo_ranks`;
    CREATE TABLE  `dojo_ranks` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(13) NOT NULL DEFAULT '',
      `time` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `id` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `donation`;
    CREATE TABLE  `donation` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `ip` varchar(255) NOT NULL DEFAULT '127.0.0.1',
      `username` varchar(13) NOT NULL,
      `quantity` smallint(5) DEFAULT NULL,
      `status` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `donorlog`;
    CREATE TABLE  `donorlog` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `accname` varchar(25) NOT NULL DEFAULT '',
      `accId` int(11) NOT NULL DEFAULT '0',
      `chrname` varchar(25) NOT NULL DEFAULT '',
      `chrId` int(11) NOT NULL DEFAULT '0',
      `log` varchar(4096) NOT NULL DEFAULT '',
      `time` varchar(25) NOT NULL DEFAULT '',
      `previousPoints` int(11) NOT NULL DEFAULT '0',
      `currentPoints` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `drop_data`;
    CREATE TABLE  `drop_data` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `dropperid` int(11) NOT NULL,
      `itemid` int(11) NOT NULL DEFAULT '0',
      `minimum_quantity` int(11) NOT NULL DEFAULT '1',
      `maximum_quantity` int(11) NOT NULL DEFAULT '1',
      `questid` int(11) NOT NULL DEFAULT '0',
      `chance` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `mobid` (`dropperid`)
    ) ENGINE=MyISAM AUTO_INCREMENT=45195 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `drop_data_global`;
    CREATE TABLE  `drop_data_global` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `continent` int(11) NOT NULL,
      `dropType` tinyint(1) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `minimum_quantity` int(11) NOT NULL DEFAULT '1',
      `maximum_quantity` int(11) NOT NULL DEFAULT '1',
      `questid` int(11) NOT NULL DEFAULT '0',
      `chance` int(11) NOT NULL DEFAULT '0',
      `comments` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `mobid` (`continent`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `dueyequipment`;
    CREATE TABLE  `dueyequipment` (
      `inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` bigint(20) 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',
      `ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
      `itemEXP` int(11) NOT NULL DEFAULT '0',
      `durability` int(11) NOT NULL DEFAULT '-1',
      `enhance` tinyint(3) NOT NULL DEFAULT '0',
      `potential1` int(5) NOT NULL DEFAULT '0',
      `potential2` int(5) NOT NULL DEFAULT '0',
      `potential3` int(5) NOT NULL DEFAULT '0',
      `potential4` int(5) NOT NULL DEFAULT '0',
      `potential5` int(5) NOT NULL DEFAULT '0',
      `socket1` int(5) NOT NULL DEFAULT '-1',
      `socket2` int(5) NOT NULL DEFAULT '-1',
      `socket3` int(5) NOT NULL DEFAULT '-1',
      `incSkill` int(11) NOT NULL DEFAULT '-1',
      `charmEXP` smallint(6) NOT NULL DEFAULT '-1',
      `pvpDamage` smallint(6) NOT NULL DEFAULT '0',
      `equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
      `equipExp` int(11) unsigned NOT NULL DEFAULT '0',
      `equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`inventoryequipmentid`),
      KEY `inventoryitemid` (`inventoryitemid`),
      CONSTRAINT `dueyequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `dueyitems` (`inventoryitemid`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `dueyitems`;
    CREATE TABLE  `dueyitems` (
      `inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `accountid` int(10) DEFAULT NULL,
      `packageid` int(11) 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,
      `GM_Log` tinytext,
      `uniqueid` int(11) NOT NULL DEFAULT '-1',
      `flag` int(2) NOT NULL DEFAULT '0',
      `expiredate` bigint(20) NOT NULL DEFAULT '-1',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `sender` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`inventoryitemid`),
      KEY `inventoryitems_ibfk_1` (`characterid`),
      KEY `characterid` (`characterid`),
      KEY `inventorytype` (`inventorytype`),
      KEY `accountid` (`accountid`),
      KEY `packageid` (`packageid`),
      KEY `characterid_2` (`characterid`,`inventorytype`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `dueypackages`;
    CREATE TABLE  `dueypackages` (
      `PackageId` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `RecieverId` int(10) NOT NULL,
      `SenderName` varchar(13) NOT NULL,
      `Mesos` int(10) unsigned DEFAULT '0',
      `TimeStamp` bigint(20) unsigned DEFAULT NULL,
      `Checked` tinyint(1) unsigned DEFAULT '1',
      `Type` tinyint(1) unsigned NOT NULL,
      PRIMARY KEY (`PackageId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `extendedslots`;
    CREATE TABLE  `extendedslots` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `itemId` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `famelog`;
    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 AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `familiars`;
    CREATE TABLE  `familiars` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `familiar` int(11) NOT NULL DEFAULT '0',
      `name` varchar(40) NOT NULL DEFAULT '',
      `fatigue` int(11) NOT NULL DEFAULT '0',
      `expiry` bigint(20) NOT NULL DEFAULT '0',
      `vitality` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3044 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `families`;
    CREATE TABLE  `families` (
      `familyid` int(11) NOT NULL AUTO_INCREMENT,
      `leaderid` int(11) NOT NULL DEFAULT '0',
      `notice` varchar(255) NOT NULL DEFAULT '',
      PRIMARY KEY (`familyid`),
      KEY `familyid` (`familyid`),
      KEY `leaderid` (`leaderid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `gifts`;
    CREATE TABLE  `gifts` (
      `giftid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `recipient` int(11) NOT NULL DEFAULT '0',
      `from` varchar(13) NOT NULL DEFAULT '',
      `message` varchar(255) NOT NULL DEFAULT '',
      `sn` int(11) NOT NULL DEFAULT '0',
      `uniqueid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`giftid`),
      KEY `recipient` (`recipient`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `gmlog`;
    CREATE TABLE  `gmlog` (
      `gmlogid` int(11) NOT NULL AUTO_INCREMENT,
      `cid` int(11) NOT NULL DEFAULT '0',
      `command` text NOT NULL,
      `mapid` int(11) NOT NULL DEFAULT '0',
      `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (`gmlogid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `guilds`;
    CREATE TABLE  `guilds` (
      `guildid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `leader` int(10) unsigned NOT NULL DEFAULT '0',
      `GP` int(11) 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',
      `alliance` int(10) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`guildid`),
      UNIQUE KEY `name` (`name`),
      KEY `guildid` (`guildid`),
      KEY `leader` (`leader`) USING BTREE
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `guildskills`;
    CREATE TABLE  `guildskills` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `guildid` int(11) NOT NULL DEFAULT '0',
      `skillid` int(11) NOT NULL DEFAULT '0',
      `level` smallint(3) NOT NULL DEFAULT '1',
      `timestamp` bigint(20) NOT NULL DEFAULT '0',
      `purchaser` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `hidelog`;
    CREATE TABLE  `hidelog` (
      `logid` int(11) NOT NULL AUTO_INCREMENT,
      `cid` int(11) NOT NULL DEFAULT '0',
      `text` text NOT NULL,
      `mapid` int(11) NOT NULL DEFAULT '0',
      `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (`logid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `hiredmerch`;
    CREATE TABLE  `hiredmerch` (
      `PackageId` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(10) unsigned DEFAULT '0',
      `accountid` int(10) unsigned DEFAULT NULL,
      `Mesos` int(10) unsigned DEFAULT '0',
      `time` bigint(20) unsigned DEFAULT NULL,
      PRIMARY KEY (`PackageId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `hiredmerchequipment`;
    CREATE TABLE  `hiredmerchequipment` (
      `inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` bigint(20) 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',
      `ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
      `itemEXP` int(11) NOT NULL DEFAULT '0',
      `durability` int(11) NOT NULL DEFAULT '-1',
      `enhance` tinyint(3) NOT NULL DEFAULT '0',
      `potential1` int(5) NOT NULL DEFAULT '0',
      `potential2` int(5) NOT NULL DEFAULT '0',
      `potential3` int(5) NOT NULL DEFAULT '0',
      `potential4` int(5) NOT NULL DEFAULT '0',
      `potential5` int(5) NOT NULL DEFAULT '0',
      `socket1` int(5) NOT NULL DEFAULT '-1',
      `socket2` int(5) NOT NULL DEFAULT '-1',
      `socket3` int(5) NOT NULL DEFAULT '-1',
      `incSkill` int(11) NOT NULL DEFAULT '-1',
      `charmEXP` smallint(6) NOT NULL DEFAULT '-1',
      `pvpDamage` smallint(6) NOT NULL DEFAULT '0',
      `equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
      `equipExp` int(11) unsigned NOT NULL DEFAULT '0',
      `equipMSIUpgrades` int(11) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`inventoryequipmentid`),
      KEY `inventoryitemid` (`inventoryitemid`),
      CONSTRAINT `hiredmerchequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `hiredmerchitems` (`inventoryitemid`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `hiredmerchitems`;
    CREATE TABLE  `hiredmerchitems` (
      `inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `accountid` int(10) DEFAULT NULL,
      `packageid` int(11) 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,
      `GM_Log` tinytext,
      `uniqueid` int(11) NOT NULL DEFAULT '-1',
      `flag` int(2) NOT NULL DEFAULT '0',
      `expiredate` bigint(20) NOT NULL DEFAULT '-1',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `sender` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`inventoryitemid`),
      KEY `inventoryitems_ibfk_1` (`characterid`),
      KEY `characterid` (`characterid`),
      KEY `inventorytype` (`inventorytype`),
      KEY `accountid` (`accountid`),
      KEY `packageid` (`packageid`),
      KEY `characterid_2` (`characterid`,`inventorytype`)
    ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `hyperrocklocations`;
    CREATE TABLE  `hyperrocklocations` (
      `trockid` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `mapid` int(11) DEFAULT NULL,
      PRIMARY KEY (`trockid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `imps`;
    CREATE TABLE  `imps` (
      `impid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `level` tinyint(3) unsigned NOT NULL DEFAULT '1',
      `state` tinyint(3) unsigned NOT NULL DEFAULT '1',
      `closeness` mediumint(6) unsigned NOT NULL DEFAULT '0',
      `fullness` mediumint(6) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`impid`),
      KEY `impid` (`impid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `inner_ability_skills`;
    CREATE TABLE  `inner_ability_skills` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `player_id` int(11) NOT NULL DEFAULT '0',
      `skill_id` int(11) NOT NULL DEFAULT '0',
      `skill_level` int(11) NOT NULL DEFAULT '0',
      `max_level` int(11) NOT NULL DEFAULT '0',
      `rank` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4284 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `internlog`;
    CREATE TABLE  `internlog` (
      `gmlogid` int(11) NOT NULL AUTO_INCREMENT,
      `cid` int(11) NOT NULL DEFAULT '0',
      `command` tinytext NOT NULL,
      `mapid` int(11) NOT NULL DEFAULT '0',
      `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (`gmlogid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `inventoryequipment`;
    CREATE TABLE  `inventoryequipment` (
      `inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` bigint(20) unsigned NOT NULL DEFAULT '0',
      `upgradeslots` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `str` int(6) NOT NULL DEFAULT '0',
      `dex` int(6) NOT NULL DEFAULT '0',
      `int` int(6) NOT NULL DEFAULT '0',
      `luk` int(6) NOT NULL DEFAULT '0',
      `hp` int(6) NOT NULL DEFAULT '0',
      `mp` int(6) NOT NULL DEFAULT '0',
      `watk` int(6) NOT NULL DEFAULT '0',
      `matk` int(6) NOT NULL DEFAULT '0',
      `wdef` int(6) NOT NULL DEFAULT '0',
      `mdef` int(6) NOT NULL DEFAULT '0',
      `acc` int(6) NOT NULL DEFAULT '0',
      `avoid` int(6) NOT NULL DEFAULT '0',
      `hands` int(6) NOT NULL DEFAULT '0',
      `speed` int(6) NOT NULL DEFAULT '0',
      `jump` int(6) NOT NULL DEFAULT '0',
      `ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
      `itemEXP` int(11) NOT NULL DEFAULT '0',
      `durability` mediumint(9) NOT NULL DEFAULT '-1',
      `enhance` tinyint(3) NOT NULL DEFAULT '0',
      `potential1` int(5) NOT NULL DEFAULT '0',
      `potential2` int(5) NOT NULL DEFAULT '0',
      `potential3` int(5) NOT NULL DEFAULT '0',
      `potential4` int(5) NOT NULL DEFAULT '0',
      `potential5` int(5) NOT NULL DEFAULT '0',
      `socket1` int(5) NOT NULL DEFAULT '-1',
      `socket2` int(5) NOT NULL DEFAULT '-1',
      `socket3` int(5) NOT NULL DEFAULT '-1',
      `incSkill` int(11) NOT NULL DEFAULT '-1',
      `charmEXP` int(6) NOT NULL DEFAULT '-1',
      `pvpDamage` int(6) NOT NULL DEFAULT '0',
      `equipLevel` int(11) unsigned NOT NULL DEFAULT '1',
      `equipExp` int(11) unsigned NOT NULL DEFAULT '0',
      `equipMSIUpgrades` int(11) unsigned 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=2281606 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `inventoryitems`;
    CREATE TABLE  `inventoryitems` (
      `inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `accountid` int(10) DEFAULT NULL,
      `packageid` int(11) 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,
      `GM_Log` tinytext,
      `uniqueid` int(11) NOT NULL DEFAULT '-1',
      `flag` int(2) NOT NULL DEFAULT '0',
      `expiredate` bigint(20) NOT NULL DEFAULT '-1',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `sender` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`inventoryitemid`),
      KEY `inventorytype` (`inventorytype`),
      KEY `accountid` (`accountid`),
      KEY `packageid` (`packageid`),
      KEY `characterid_2` (`characterid`,`inventorytype`)
    ) ENGINE=InnoDB AUTO_INCREMENT=127104082 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `inventorylog`;
    CREATE TABLE  `inventorylog` (
      `inventorylogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` int(10) unsigned NOT NULL DEFAULT '0',
      `msg` tinytext NOT NULL,
      PRIMARY KEY (`inventorylogid`),
      KEY `inventoryitemid` (`inventoryitemid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `inventoryslot`;
    CREATE TABLE  `inventoryslot` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(10) unsigned DEFAULT NULL,
      `equip` tinyint(3) unsigned DEFAULT NULL,
      `use` tinyint(3) unsigned DEFAULT NULL,
      `setup` tinyint(3) unsigned DEFAULT NULL,
      `etc` tinyint(3) unsigned DEFAULT NULL,
      `cash` tinyint(3) unsigned DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `characterid` (`characterid`),
      KEY `id` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `ipbans`;
    CREATE TABLE  `ipbans` (
      `ipbanid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `ip` varchar(40) NOT NULL DEFAULT '',
      PRIMARY KEY (`ipbanid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `iplog`;
    CREATE TABLE  `iplog` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `accid` int(11) NOT NULL,
      `accname` varchar(45) NOT NULL,
      `ip` varchar(45) NOT NULL,
      `time` varchar(45) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `ipvotelog`;
    CREATE TABLE  `ipvotelog` (
      `vid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `accid` int(11) NOT NULL DEFAULT '0',
      `ipaddress` varchar(255) NOT NULL DEFAULT '127.0.0.1',
      `votetime` bigint(20) NOT NULL DEFAULT '0',
      `votetype` tinyint(1) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`vid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `ipvotes`;
    CREATE TABLE  `ipvotes` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `ip` varchar(30) NOT NULL,
      `accid` int(11) NOT NULL,
      `lastvote` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `keymap`;
    CREATE TABLE  `keymap` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `key` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
      `action` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `keymap_ibfk_1` (`characterid`),
      CONSTRAINT `keymap_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=184038 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `macbans`;
    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=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `macfilters`;
    CREATE TABLE  `macfilters` (
      `macfilterid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `filter` varchar(30) NOT NULL,
      PRIMARY KEY (`macfilterid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `monsterbook`;
    CREATE TABLE  `monsterbook` (
      `id` int(10) NOT NULL AUTO_INCREMENT,
      `charid` int(10) unsigned NOT NULL DEFAULT '0',
      `cardid` int(10) unsigned NOT NULL DEFAULT '0',
      `level` tinyint(2) unsigned DEFAULT '1',
      PRIMARY KEY (`id`),
      KEY `id` (`id`),
      KEY `charid` (`charid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `mountdata`;
    CREATE TABLE  `mountdata` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(10) unsigned DEFAULT NULL,
      `Level` int(3) unsigned NOT NULL DEFAULT '0',
      `Exp` int(10) unsigned NOT NULL DEFAULT '0',
      `Fatigue` int(4) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      UNIQUE KEY `characterid` (`characterid`),
      KEY `id` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `mrush`;
    CREATE TABLE  `mrush` (
      `mesos` bigint(8) unsigned NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`mesos`)
    ) ENGINE=InnoDB AUTO_INCREMENT=9223372036854775808 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `mts_cart`;
    CREATE TABLE  `mts_cart` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `characterid` (`characterid`),
      KEY `id` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `mts_items`;
    CREATE TABLE  `mts_items` (
      `id` int(11) NOT NULL,
      `tab` tinyint(1) NOT NULL DEFAULT '1',
      `price` int(11) NOT NULL DEFAULT '0',
      `characterid` int(11) NOT NULL DEFAULT '0',
      `seller` varchar(13) NOT NULL DEFAULT '',
      `expiration` bigint(20) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `mtsequipment`;
    CREATE TABLE  `mtsequipment` (
      `inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` bigint(20) 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',
      `ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
      `itemEXP` int(11) NOT NULL DEFAULT '0',
      `durability` int(11) NOT NULL DEFAULT '-1',
      `enhance` tinyint(3) NOT NULL DEFAULT '0',
      `potential1` int(5) NOT NULL DEFAULT '0',
      `potential2` int(5) NOT NULL DEFAULT '0',
      `potential3` int(5) NOT NULL DEFAULT '0',
      `potential4` int(5) NOT NULL DEFAULT '0',
      `potential5` int(5) NOT NULL DEFAULT '0',
      `socket1` int(5) NOT NULL DEFAULT '-1',
      `socket2` int(5) NOT NULL DEFAULT '-1',
      `socket3` int(5) NOT NULL DEFAULT '-1',
      `incSkill` int(11) NOT NULL DEFAULT '-1',
      `charmEXP` smallint(6) NOT NULL DEFAULT '-1',
      `pvpDamage` smallint(6) NOT NULL DEFAULT '0',
      PRIMARY KEY (`inventoryequipmentid`),
      KEY `inventoryitemid` (`inventoryitemid`),
      CONSTRAINT `mtsequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `mtsitems` (`inventoryitemid`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `mtsitems`;
    CREATE TABLE  `mtsitems` (
      `inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `accountid` int(10) DEFAULT NULL,
      `packageId` int(11) 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,
      `GM_Log` tinytext,
      `uniqueid` int(11) NOT NULL DEFAULT '-1',
      `flag` int(2) NOT NULL DEFAULT '0',
      `expiredate` bigint(20) NOT NULL DEFAULT '-1',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `sender` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`inventoryitemid`),
      KEY `inventoryitems_ibfk_1` (`characterid`),
      KEY `characterid` (`characterid`),
      KEY `inventorytype` (`inventorytype`),
      KEY `accountid` (`accountid`),
      KEY `characterid_2` (`characterid`,`inventorytype`),
      KEY `packageid` (`packageId`) USING BTREE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `mtstransfer`;
    CREATE TABLE  `mtstransfer` (
      `inventoryitemid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `accountid` int(10) DEFAULT NULL,
      `packageid` int(11) 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,
      `GM_Log` tinytext,
      `uniqueid` int(11) NOT NULL DEFAULT '-1',
      `flag` int(2) NOT NULL DEFAULT '0',
      `expiredate` bigint(20) NOT NULL DEFAULT '-1',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `sender` varchar(13) NOT NULL DEFAULT '',
      PRIMARY KEY (`inventoryitemid`),
      KEY `inventoryitems_ibfk_1` (`characterid`),
      KEY `characterid` (`characterid`),
      KEY `inventorytype` (`inventorytype`),
      KEY `accountid` (`accountid`),
      KEY `packageid` (`packageid`),
      KEY `characterid_2` (`characterid`,`inventorytype`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `mtstransferequipment`;
    CREATE TABLE  `mtstransferequipment` (
      `inventoryequipmentid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `inventoryitemid` bigint(20) 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',
      `ViciousHammer` tinyint(2) NOT NULL DEFAULT '0',
      `itemEXP` int(11) NOT NULL DEFAULT '0',
      `durability` int(11) NOT NULL DEFAULT '-1',
      `enhance` tinyint(3) NOT NULL DEFAULT '0',
      `potential1` int(5) NOT NULL DEFAULT '0',
      `potential2` int(5) NOT NULL DEFAULT '0',
      `potential3` int(5) NOT NULL DEFAULT '0',
      `potential4` int(5) NOT NULL DEFAULT '0',
      `potential5` int(5) NOT NULL DEFAULT '0',
      `socket1` int(5) NOT NULL DEFAULT '-1',
      `socket2` int(5) NOT NULL DEFAULT '-1',
      `socket3` int(5) NOT NULL DEFAULT '-1',
      `incSkill` int(11) NOT NULL DEFAULT '-1',
      `charmEXP` smallint(6) NOT NULL DEFAULT '-1',
      `pvpDamage` smallint(6) NOT NULL DEFAULT '0',
      PRIMARY KEY (`inventoryequipmentid`),
      KEY `inventoryitemid` (`inventoryitemid`),
      CONSTRAINT `mtstransferequipment_ibfk_1` FOREIGN KEY (`inventoryitemid`) REFERENCES `mtstransfer` (`inventoryitemid`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `myinfo`;
    CREATE TABLE  `myinfo` (
      `infoid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `cid` int(11) NOT NULL,
      `location` int(11) NOT NULL,
      `todo` int(11) unsigned NOT NULL,
      `birthday` int(11) unsigned NOT NULL,
      `found` int(11) unsigned NOT NULL,
      PRIMARY KEY (`infoid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `news`;
    CREATE TABLE  `news` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `title` varchar(25) NOT NULL,
      `type` int(11) unsigned NOT NULL DEFAULT '0',
      `date` varchar(45) NOT NULL,
      `url` varchar(45) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `notes`;
    CREATE TABLE  `notes` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `to` varchar(13) NOT NULL DEFAULT '',
      `from` varchar(13) NOT NULL DEFAULT '',
      `message` text NOT NULL,
      `timestamp` bigint(20) unsigned NOT NULL,
      `gift` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `to` (`to`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `nxcode`;
    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=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `pets`;
    CREATE TABLE  `pets` (
      `petid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(13) DEFAULT NULL,
      `level` int(3) unsigned NOT NULL,
      `closeness` int(6) unsigned NOT NULL,
      `fullness` int(3) unsigned NOT NULL,
      `seconds` int(11) NOT NULL DEFAULT '0',
      `flags` smallint(5) NOT NULL DEFAULT '0',
      PRIMARY KEY (`petid`),
      KEY `petid` (`petid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=637 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `playernpcs`;
    CREATE TABLE  `playernpcs` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(13) NOT NULL,
      `hair` int(11) NOT NULL,
      `face` int(11) NOT NULL,
      `skin` int(11) NOT NULL,
      `x` int(11) NOT NULL DEFAULT '0',
      `y` int(11) NOT NULL DEFAULT '0',
      `map` int(11) NOT NULL,
      `charid` int(11) NOT NULL,
      `scriptid` int(11) NOT NULL,
      `foothold` int(11) NOT NULL,
      `dir` tinyint(1) NOT NULL DEFAULT '0',
      `gender` tinyint(1) NOT NULL DEFAULT '0',
      `pets` varchar(25) DEFAULT '0,0,0',
      PRIMARY KEY (`id`),
      KEY `scriptid` (`scriptid`),
      KEY `playernpcs_ibfk_1` (`charid`),
      CONSTRAINT `playernpcs_ibfk_1` FOREIGN KEY (`charid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=3739 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `playernpcs_equip`;
    CREATE TABLE  `playernpcs_equip` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `npcid` int(11) NOT NULL,
      `equipid` int(11) NOT NULL,
      `equippos` int(11) NOT NULL,
      `charid` int(11) NOT NULL,
      PRIMARY KEY (`id`),
      KEY `playernpcs_equip_ibfk_1` (`charid`),
      KEY `playernpcs_equip_ibfk_2` (`npcid`),
      CONSTRAINT `playernpcs_equip_ibfk_1` FOREIGN KEY (`charid`) REFERENCES `characters` (`id`) ON DELETE CASCADE,
      CONSTRAINT `playernpcs_equip_ibfk_2` FOREIGN KEY (`npcid`) REFERENCES `playernpcs` (`scriptid`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=63169 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `pokemon`;
    CREATE TABLE  `pokemon` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `monsterid` int(11) NOT NULL DEFAULT '0',
      `characterid` int(11) NOT NULL DEFAULT '0',
      `level` smallint(3) NOT NULL DEFAULT '1',
      `exp` int(11) NOT NULL DEFAULT '0',
      `name` varchar(255) NOT NULL DEFAULT '',
      `nature` tinyint(3) NOT NULL DEFAULT '0',
      `active` tinyint(1) NOT NULL DEFAULT '0',
      `accountid` int(11) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `gender` tinyint(2) NOT NULL DEFAULT '-1',
      `hpiv` tinyint(3) NOT NULL DEFAULT '-1',
      `atkiv` tinyint(3) NOT NULL DEFAULT '-1',
      `defiv` tinyint(3) NOT NULL DEFAULT '-1',
      `spatkiv` tinyint(3) NOT NULL DEFAULT '-1',
      `spdefiv` tinyint(3) NOT NULL DEFAULT '-1',
      `speediv` tinyint(3) NOT NULL DEFAULT '-1',
      `evaiv` tinyint(3) NOT NULL DEFAULT '-1',
      `acciv` tinyint(3) NOT NULL DEFAULT '-1',
      `ability` tinyint(2) NOT NULL DEFAULT '-1',
      PRIMARY KEY (`id`),
      KEY `id` (`id`),
      KEY `characterid` (`characterid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `proxyip`;
    CREATE TABLE  `proxyip` (
      `proxyid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `proxyip` varchar(40) NOT NULL,
      PRIMARY KEY (`proxyid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `pwreset`;
    CREATE TABLE  `pwreset` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(14) NOT NULL,
      `email` varchar(100) NOT NULL,
      `confirmkey` varchar(100) NOT NULL,
      `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
      `timestamp` varchar(100) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `questinfo`;
    CREATE TABLE  `questinfo` (
      `questinfoid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `quest` int(6) NOT NULL DEFAULT '0',
      `customData` varchar(555) DEFAULT NULL,
      PRIMARY KEY (`questinfoid`),
      KEY `characterid` (`characterid`),
      CONSTRAINT `questsinfo_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=45109 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `queststatus`;
    CREATE TABLE  `queststatus` (
      `queststatusid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `quest` int(6) NOT NULL DEFAULT '0',
      `status` tinyint(4) NOT NULL DEFAULT '0',
      `time` int(11) NOT NULL DEFAULT '0',
      `forfeited` int(11) NOT NULL DEFAULT '0',
      `customData` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`queststatusid`),
      KEY `characterid` (`characterid`),
      KEY `queststatusid` (`queststatusid`),
      CONSTRAINT `queststatus_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=23251946 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `queststatusmobs`;
    CREATE TABLE  `queststatusmobs` (
      `queststatusmobid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `queststatusid` int(10) unsigned NOT NULL DEFAULT '0',
      `mob` int(11) NOT NULL DEFAULT '0',
      `count` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`queststatusmobid`),
      KEY `queststatusid` (`queststatusid`),
      CONSTRAINT `queststatusmobs_ibfk_1` FOREIGN KEY (`queststatusid`) REFERENCES `queststatus` (`queststatusid`) ON DELETE CASCADE
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `reactordrops`;
    CREATE TABLE  `reactordrops` (
      `reactordropid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `reactorid` int(11) NOT NULL,
      `itemid` int(11) NOT NULL,
      `chance` int(11) NOT NULL,
      `questid` int(5) NOT NULL DEFAULT '-1',
      PRIMARY KEY (`reactordropid`),
      KEY `reactorid` (`reactorid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=841 DEFAULT CHARSET=latin1 PACK_KEYS=1;
    
    DROP TABLE IF EXISTS `regrocklocations`;
    CREATE TABLE  `regrocklocations` (
      `trockid` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `mapid` int(11) DEFAULT NULL,
      PRIMARY KEY (`trockid`),
      KEY `characterid` (`characterid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `reports`;
    CREATE TABLE  `reports` (
      `reportid` int(9) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `type` tinyint(2) NOT NULL DEFAULT '0',
      `count` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`reportid`,`characterid`),
      KEY `characterid` (`characterid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `rings`;
    CREATE TABLE  `rings` (
      `ringid` int(11) NOT NULL AUTO_INCREMENT,
      `partnerRingId` int(11) NOT NULL DEFAULT '0',
      `partnerChrId` int(11) NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `partnername` varchar(255) NOT NULL,
      PRIMARY KEY (`ringid`),
      KEY `ringid` (`ringid`),
      KEY `partnerChrId` (`partnerChrId`),
      KEY `partnerRingId` (`partnerRingId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=617 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `savedlocations`;
    CREATE TABLE  `savedlocations` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL,
      `locationtype` int(11) NOT NULL DEFAULT '0',
      `map` int(11) NOT NULL,
      PRIMARY KEY (`id`),
      KEY `savedlocations_ibfk_1` (`characterid`),
      CONSTRAINT `savedlocations_ibfk_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=541 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `scroll_log`;
    CREATE TABLE  `scroll_log` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `accId` int(11) NOT NULL DEFAULT '0',
      `chrId` int(11) NOT NULL DEFAULT '0',
      `scrollId` int(11) NOT NULL DEFAULT '0',
      `itemId` int(11) NOT NULL DEFAULT '0',
      `oldSlots` tinyint(4) NOT NULL DEFAULT '0',
      `newSlots` tinyint(4) NOT NULL DEFAULT '0',
      `hammer` tinyint(4) NOT NULL DEFAULT '0',
      `result` varchar(13) NOT NULL DEFAULT '',
      `whiteScroll` tinyint(1) NOT NULL DEFAULT '0',
      `legendarySpirit` tinyint(1) NOT NULL DEFAULT '0',
      `vegaId` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `shopitems`;
    CREATE TABLE  `shopitems` (
      `shopitemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `shopid` int(10) unsigned NOT NULL DEFAULT '0',
      `itemid` int(11) NOT NULL DEFAULT '0',
      `price` int(11) NOT NULL DEFAULT '0',
      `position` int(11) NOT NULL DEFAULT '0',
      `reqitem` int(11) NOT NULL DEFAULT '0',
      `reqitemq` int(11) NOT NULL DEFAULT '0',
      `rank` tinyint(3) NOT NULL DEFAULT '0',
      `category` tinyint(3) NOT NULL DEFAULT '0',
      `minLevel` int(11) NOT NULL DEFAULT '0',
      `expiration` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`shopitemid`),
      KEY `shopid` (`shopid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5005082 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `shopranks`;
    CREATE TABLE  `shopranks` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `shopid` int(11) NOT NULL DEFAULT '0',
      `rank` int(11) NOT NULL DEFAULT '0',
      `name` varchar(255) NOT NULL DEFAULT '',
      `itemid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `shops`;
    CREATE TABLE  `shops` (
      `shopid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `npcid` int(11) DEFAULT '0',
      PRIMARY KEY (`shopid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=170001 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `sidekicks`;
    CREATE TABLE  `sidekicks` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `firstid` int(11) NOT NULL DEFAULT '0',
      `secondid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `skillmacros`;
    CREATE TABLE  `skillmacros` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) NOT NULL DEFAULT '0',
      `position` tinyint(1) NOT NULL DEFAULT '0',
      `skill1` int(11) NOT NULL DEFAULT '0',
      `skill2` int(11) NOT NULL DEFAULT '0',
      `skill3` int(11) NOT NULL DEFAULT '0',
      `name` varchar(30) DEFAULT NULL,
      `shout` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `characterid` (`characterid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `skills`;
    CREATE TABLE  `skills` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `skillid` int(11) NOT NULL DEFAULT '0',
      `characterid` int(11) NOT NULL DEFAULT '0',
      `skilllevel` int(11) NOT NULL DEFAULT '0',
      `masterlevel` tinyint(4) NOT NULL DEFAULT '0',
      `expiration` bigint(20) NOT NULL DEFAULT '-1',
      `slot` int(11) NOT NULL DEFAULT '-1',
      `equipped` int(11) NOT NULL DEFAULT '-1',
      PRIMARY KEY (`id`),
      KEY `FK_skills_1` (`characterid`),
      CONSTRAINT `FK_skills_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=144034 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `skills_cooldowns`;
    CREATE TABLE  `skills_cooldowns` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `charid` int(11) NOT NULL,
      `SkillID` int(11) NOT NULL,
      `length` bigint(20) NOT NULL,
      `StartTime` bigint(20) unsigned NOT NULL,
      PRIMARY KEY (`id`),
      KEY `charid` (`charid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `speedruns`;
    CREATE TABLE  `speedruns` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `type` varchar(13) NOT NULL,
      `leader` varchar(13) NOT NULL,
      `timestring` varchar(1024) NOT NULL,
      `time` bigint(20) NOT NULL DEFAULT '0',
      `members` varchar(1024) NOT NULL DEFAULT '',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `stolen`;
    CREATE TABLE  `stolen` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `characterid` varchar(45) NOT NULL,
      `skillid` varchar(45) NOT NULL,
      `chosen` varchar(45) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `storages`;
    CREATE TABLE  `storages` (
      `storageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `accountid` int(11) NOT NULL DEFAULT '0',
      `slots` int(11) NOT NULL DEFAULT '0',
      `meso` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`storageid`),
      KEY `accountid` (`accountid`),
      CONSTRAINT `storages_ibfk_1` FOREIGN KEY (`accountid`) REFERENCES `accounts` (`id`) ON DELETE CASCADE
    ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `tournamentlog`;
    CREATE TABLE  `tournamentlog` (
      `logid` int(11) NOT NULL AUTO_INCREMENT,
      `winnerid` int(11) NOT NULL DEFAULT '0',
      `numContestants` int(11) NOT NULL DEFAULT '0',
      `when` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      PRIMARY KEY (`logid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `trocklocations`;
    CREATE TABLE  `trocklocations` (
      `trockid` int(11) NOT NULL AUTO_INCREMENT,
      `characterid` int(11) DEFAULT NULL,
      `mapid` int(11) DEFAULT NULL,
      PRIMARY KEY (`trockid`),
      KEY `characterid` (`characterid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `trolled`;
    CREATE TABLE  `trolled` (
      `trolledid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(255) NOT NULL,
      PRIMARY KEY (`trolledid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `vote_log`;
    CREATE TABLE  `vote_log` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `account` varchar(45) NOT NULL,
      `ip` varchar(45) NOT NULL,
      `date` int(10) unsigned NOT NULL,
      `times` int(10) unsigned NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `votecontrol`;
    CREATE TABLE  `votecontrol` (
      `name` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
      `time` int(11) NOT NULL,
      PRIMARY KEY (`name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `votecontrolgtop`;
    CREATE TABLE  `votecontrolgtop` (
      `name` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
      `time` int(11) NOT NULL,
      PRIMARY KEY (`name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `voteipcontrol`;
    CREATE TABLE  `voteipcontrol` (
      `ip` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
      `time` int(11) NOT NULL,
      PRIMARY KEY (`ip`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `voteipcontrolgtop`;
    CREATE TABLE  `voteipcontrolgtop` (
      `ip` varchar(45) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
      `time` int(11) NOT NULL,
      PRIMARY KEY (`ip`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `voterewards`;
    CREATE TABLE  `voterewards` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(45) NOT NULL,
      `claimed` tinyint(3) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `voterewardsgtop`;
    CREATE TABLE  `voterewardsgtop` (
      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `name` varchar(45) NOT NULL,
      `claimed` tinyint(3) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    DROP TABLE IF EXISTS `votingrecords`;
    CREATE TABLE  `votingrecords` (
      `account` varchar(13) NOT NULL DEFAULT '0',
      `ip` varchar(30) NOT NULL DEFAULT '0',
      `date` int(11) NOT NULL DEFAULT '0',
      `times` bigint(20) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`account`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `web_logs`;
    CREATE TABLE  `web_logs` (
      `idweb_logs` int(10) unsigned NOT NULL AUTO_INCREMENT,
      PRIMARY KEY (`idweb_logs`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `wishlist`;
    CREATE TABLE  `wishlist` (
      `characterid` int(11) NOT NULL,
      `sn` int(11) NOT NULL,
      KEY `characterid` (`characterid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `wz_clearedlife`;
    CREATE TABLE  `wz_clearedlife` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `mapid` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `wz_customlife`;
    CREATE TABLE  `wz_customlife` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `idd` int(11) NOT NULL,
      `f` int(11) NOT NULL,
      `fh` int(11) NOT NULL,
      `type` varchar(1) NOT NULL,
      `cy` int(11) NOT NULL,
      `rx0` int(11) NOT NULL,
      `rx1` int(11) NOT NULL,
      `x` int(11) NOT NULL,
      `y` int(11) NOT NULL,
      `mobtime` int(11) DEFAULT '1000',
      `mid` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `wz_itemadddata`;
    CREATE TABLE  `wz_itemadddata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `itemid` int(11) NOT NULL,
      `key` varchar(30) NOT NULL,
      `value1` int(11) NOT NULL DEFAULT '0',
      `value2` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=767 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_itemdata`;
    CREATE TABLE  `wz_itemdata` (
      `itemid` int(11) NOT NULL,
      `name` tinytext,
      `msg` varchar(4096) DEFAULT NULL,
      `desc` varchar(4096) DEFAULT NULL,
      `slotMax` smallint(5) NOT NULL DEFAULT '1',
      `price` varchar(255) NOT NULL DEFAULT '-1.0',
      `wholePrice` int(11) NOT NULL DEFAULT '-1',
      `stateChange` int(11) NOT NULL DEFAULT '0',
      `flags` smallint(4) NOT NULL DEFAULT '0',
      `karma` tinyint(1) NOT NULL DEFAULT '0',
      `meso` int(11) NOT NULL DEFAULT '0',
      `monsterBook` int(11) NOT NULL DEFAULT '0',
      `itemMakeLevel` smallint(6) NOT NULL DEFAULT '0',
      `questId` int(11) NOT NULL DEFAULT '0',
      `scrollReqs` tinytext,
      `consumeItem` tinytext,
      `totalprob` int(11) NOT NULL DEFAULT '0',
      `incSkill` varchar(255) NOT NULL DEFAULT '',
      `replaceid` int(11) NOT NULL DEFAULT '0',
      `replacemsg` varchar(255) NOT NULL DEFAULT '',
      `create` int(11) NOT NULL DEFAULT '0',
      `afterImage` varchar(255) NOT NULL DEFAULT '',
      PRIMARY KEY (`itemid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_itemequipdata`;
    CREATE TABLE  `wz_itemequipdata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `itemid` int(11) NOT NULL,
      `itemLevel` int(11) NOT NULL DEFAULT '-1',
      `key` varchar(30) NOT NULL,
      `value` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=280499 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_itemrewarddata`;
    CREATE TABLE  `wz_itemrewarddata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `itemid` int(11) NOT NULL,
      `item` int(11) NOT NULL,
      `prob` int(11) NOT NULL DEFAULT '0',
      `quantity` smallint(5) NOT NULL DEFAULT '0',
      `period` int(11) NOT NULL DEFAULT '-1',
      `worldMsg` varchar(255) NOT NULL DEFAULT '',
      `effect` varchar(255) NOT NULL DEFAULT '',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=16529 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_mobskilldata`;
    CREATE TABLE  `wz_mobskilldata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `skillid` int(11) NOT NULL,
      `level` int(11) NOT NULL,
      `hp` int(11) NOT NULL DEFAULT '100',
      `mpcon` int(11) NOT NULL DEFAULT '0',
      `x` int(11) NOT NULL DEFAULT '1',
      `y` int(11) NOT NULL DEFAULT '1',
      `time` int(11) NOT NULL DEFAULT '0',
      `prop` int(11) NOT NULL DEFAULT '100',
      `limit` int(11) NOT NULL DEFAULT '0',
      `spawneffect` int(11) NOT NULL DEFAULT '0',
      `interval` int(11) NOT NULL DEFAULT '0',
      `summons` varchar(1024) NOT NULL DEFAULT '',
      `ltx` int(11) NOT NULL DEFAULT '0',
      `lty` int(11) NOT NULL DEFAULT '0',
      `rbx` int(11) NOT NULL DEFAULT '0',
      `rby` int(11) NOT NULL DEFAULT '0',
      `once` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=789 DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `wz_oxdata`;
    CREATE TABLE  `wz_oxdata` (
      `questionset` smallint(6) NOT NULL DEFAULT '0',
      `questionid` smallint(6) NOT NULL DEFAULT '0',
      `question` varchar(200) NOT NULL DEFAULT '',
      `display` varchar(200) NOT NULL DEFAULT '',
      `answer` enum('o','x') NOT NULL,
      PRIMARY KEY (`questionset`,`questionid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    DROP TABLE IF EXISTS `wz_questactdata`;
    CREATE TABLE  `wz_questactdata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `questid` int(11) NOT NULL DEFAULT '0',
      `name` varchar(127) NOT NULL DEFAULT '',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `intStore` int(11) NOT NULL DEFAULT '0',
      `applicableJobs` varchar(1024) NOT NULL DEFAULT '',
      `uniqueid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `quests_ibfk_2` (`questid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7454 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_questactitemdata`;
    CREATE TABLE  `wz_questactitemdata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `itemid` int(11) NOT NULL DEFAULT '0',
      `count` smallint(5) NOT NULL DEFAULT '0',
      `period` int(11) NOT NULL DEFAULT '0',
      `gender` tinyint(1) NOT NULL DEFAULT '2',
      `job` int(11) NOT NULL DEFAULT '-1',
      `jobEx` int(11) NOT NULL DEFAULT '-1',
      `prop` int(11) NOT NULL DEFAULT '-1',
      `uniqueid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=8960 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `wz_questactquestdata`;
    CREATE TABLE  `wz_questactquestdata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `quest` int(11) NOT NULL DEFAULT '0',
      `state` tinyint(1) NOT NULL DEFAULT '2',
      `uniqueid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `wz_questactskilldata`;
    CREATE TABLE  `wz_questactskilldata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `skillid` int(11) NOT NULL DEFAULT '0',
      `skillLevel` int(11) NOT NULL DEFAULT '-1',
      `masterLevel` int(11) NOT NULL DEFAULT '-1',
      `uniqueid` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;
    
    DROP TABLE IF EXISTS `wz_questdata`;
    CREATE TABLE  `wz_questdata` (
      `questid` int(11) NOT NULL,
      `name` varchar(1024) NOT NULL DEFAULT '',
      `autoStart` tinyint(1) NOT NULL DEFAULT '0',
      `autoPreComplete` tinyint(1) NOT NULL DEFAULT '0',
      `viewMedalItem` int(11) NOT NULL DEFAULT '0',
      `selectedSkillID` int(11) NOT NULL DEFAULT '0',
      `blocked` tinyint(1) NOT NULL DEFAULT '0',
      `autoAccept` tinyint(1) NOT NULL DEFAULT '0',
      `autoComplete` tinyint(1) NOT NULL DEFAULT '0',
      PRIMARY KEY (`questid`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_questpartydata`;
    CREATE TABLE  `wz_questpartydata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `questid` int(11) NOT NULL DEFAULT '0',
      `rank` varchar(1) NOT NULL DEFAULT '',
      `mode` varchar(13) NOT NULL DEFAULT '',
      `property` varchar(255) NOT NULL DEFAULT '',
      `value` int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`),
      KEY `quests_ibfk_7` (`questid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP TABLE IF EXISTS `wz_questreqdata`;
    CREATE TABLE  `wz_questreqdata` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `questid` int(11) NOT NULL DEFAULT '0',
      `name` varchar(127) NOT NULL DEFAULT '',
      `type` tinyint(1) NOT NULL DEFAULT '0',
      `stringStore` varchar(1024) NOT NULL DEFAULT '',
      `intStoresFirst` varchar(1024) NOT NULL DEFAULT '',
      `intStoresSecond` varchar(1024) NOT NULL DEFAULT '',
      PRIMARY KEY (`id`),
      KEY `quests_ibfk_1` (`questid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=33615 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
    
    DROP VIEW IF EXISTS `readable_cheatlog`;
    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW  `readable_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,`cl`.`offense` AS `offense`,`cl`.`count` AS `count`,`cl`.`lastoffensetime` AS `lastoffensetime`,`cl`.`param` AS `param` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (`a`.`banned` = 0));
    
    DROP VIEW IF EXISTS `readable_last_hour_cheatlog`;
    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW  `readable_last_hour_cheatlog` AS select `a`.`name` AS `accountname`,`a`.`id` AS `accountid`,`c`.`name` AS `name`,`c`.`id` AS `characterid`,sum(`cl`.`count`) AS `numrepos` from ((`cheatlog` `cl` join `characters` `c`) join `accounts` `a`) where ((`cl`.`id` = `c`.`id`) and (`a`.`id` = `c`.`accountid`) and (timestampdiff(HOUR,`cl`.`lastoffensetime`,now()) < 1) and (`a`.`banned` = 0)) group by `cl`.`id` order by sum(`cl`.`count`) desc;
    Edit:
    You can't register a PIC because it shouldn't ever require one. It's Fake PIC, and by default is forced to 13337. All you should ever have to do is enter a random PIC.
    Last edited by Eric; 03-12-14 at 08:19 PM.

  13. #13
    Hardcore Member gaspartx is offline
    MemberRank
    Apr 2009 Join Date
    BrazilLocation
    102Posts

    Re: Development v117.2 Source



    Something is wrong with your database ...

  14. #14
    #Orion Eric is online now
    ModeratorRank
    Jan 2010 Join Date
    DEV CityLocation
    2,903Posts

    Re: Development v117.2 Source

    Quote Originally Posted by gaspartx View Post


    Something is wrong with your database ...
    Fixing a few columns isn't hard lol. I forgot the updated one was on my other OS, so I rebooted and have updated my previous post's SQL to the new one. Sorry for so many SQLs, but that should fix all your issues.

  15. #15
    Interesting... SharpAceX is offline
    SubscriberRank
    Oct 2008 Join Date
    1,901Posts

    Re: Development v117.2 Source

    The helplessness is real.
    http://alanmorel.com/

    MapleStory Development Discord:
    https://discord.gg/9nv3GPQ




Page 1 of 18 12345678911 ... LastLast

Advertisement