What you will need: Microsoft Visual C++ 2008 Express Maple Story .52 Client MySQL Server 5.0 MySQL Query Browser Fixed Server Files
Step 1
1. Install VC++ 2008 Express (You may need .NET Framework 3.5)
2. Install the Maple Story client. (If you already have a .52 client, use it)
3. Install MySQL Server. Leave everything default. (Unless if you know MySQL, feel free to change settings)
4. Install MySQL Query Browser.
5. Open Query Browser and login your database. Right click on the tree on the right and click on 'Create New Schema'.
6. Name it maplestory.
7. In the textbox on the top, put in the following and press 'Execute' button.
Code: create table users(ID int auto_increment primary key, username varchar(20), password varchar(20), pin int, gender int);
# Do step #7 again for the following:
Code: create table characters(ID int auto_increment primary key, name varchar(12), userid int, level tinyint default 1, job smallint default 0, str smallint, dex smallint, intt smallint, luk smallint, chp smallint default 50, mhp smallint default 50, cmp smallint default 50, mmp smallint default 50, ap smallint default 0, sp smallint default 0, exp smallint default 0, fame smallint default 0, map int default 0, pos smallint default 0, gender tinyint, skin tinyint, eyes int, hair int, mesos int default 0);
Code: create table equip(equipid int, type tinyint, charid int, pos smallint default 0, slots tinyint default 7, scrolls smallint default 0, istr smallint default 0, idex smallint default 0, iint smallint default 0, iluk smallint default 0, ihp smallint default 0, imp smallint default 0, iwatk smallint default 0, imatk smallint default 0, iwdef smallint default 0, imdef smallint default 0, iacc smallint default 0, iavo smallint default 0, ihand smallint default 0, ispeed smallint default 0, ijump smallint default 0);
Code: :
create table items(itemid int, charid int, inv tinyint, pos smallint, amount smallint);
Code: create table keymap(charid int, pos0 int default 0, pos1 int default 0, pos2 int default 2564, pos3 int default 3076, pos4 int default 3332, pos5 int default 4612, pos6 int default 5380, pos7 int default 0, pos8 int default 0, pos9 int default 0, pos10 int default 0, pos11 int default 0, pos12 int default 0, pos13 int default 0, pos14 int default 0, pos15 int default 0, pos16 int default 2052, pos17 int default 1284, pos18 int default 4, pos19 int default 1028, pos20 int default 0, pos21 int default 0, pos22 int default 0, pos23 int default 260, pos24 int default 0, pos25 int default 4868, pos26 int default 3588, pos27 int default 3844, pos28 int default 0, pos29 int default 13317, pos30 int default 0, pos31 int default 516, pos32 int default 0, pos33 int default 0, pos34 int default 3456, pos35 int default 2820, pos36 int default 0, pos37 int default 772, pos38 int default 0, pos39 int default 5124, pos40 int default 4100, pos41 int default 0, pos42 int default 0, pos43 int default 2308, pos44 int default 12805, pos45 int default 13061, pos46 int default 1540, pos47 int default 0, pos48 int default 0, pos49 int default 0, pos50 int default 1796, pos51 int default 0, pos52 int default 0, pos53 int default 0, pos54 int default 0, pos55 int default 0, pos56 int default 13573, pos57 int default 0, pos58 int default 0, pos59 int default 25606, pos60 int default 25862, pos61 int default 26118, pos62 int default 26374, pos63 int default 26630, pos64 int default 26886, pos65 int default 27142, pos66 int default 0, pos67 int default 0, pos68 int default 0, pos69 int default 0, pos70 int default 0, pos71 int default 0, pos72 int default 0, pos73 int default 0, pos74 int default 0, pos75 int default 0, pos76 int default 0, pos77 int default 0, pos78 int default 0, pos79 int default 0, pos80 int default 0, pos81 int default 0, pos82 int default 0, pos83 int default 0, pos84 int default 0, pos85 int default 0, pos86 int default 0, pos87 int default 0, pos88 int default 0, pos89 int default 0);
# Now, to make an account. Double click on 'users' table in the tree. Then, click on 'Execute' button. Click on 'Edit' button at the bottom. Double-click on Username field, put in your username. Do again for Password field. Put in '0' without quotes in PID and Gender. When done, click on 'Apply Changes' button.
# Close MySQL Query Browser.
# Unzip the server files you just downloaded from the list above.
# Find MapleStoryServer.sln and double click on it. It should open VC++ 2008 Express. If not, run VC++ and load the file.
# In the menu, click on Build -> Build Solution.
# Wait. I suggest drinking a Pepsi can.
# When it says at bottom-left 'Build succeeded', click on the green arrow.
# Wait for the server to be ready.
# Ta-da!
To get your client to connect to a server:
Download
Modified Client
Open "c:\windows\system32\drivers\etc\hosts" with notepad or your favorite text editor.
Add at bottom:
Code: 127.0.0.1 login.odinms.de
or those who cannot connect to DB (see error in server) Follow the steps:
* Open VC++.
* Go to MapleStoryServer -> Source Files -> DataBaseManager -> MySQLM.cpp
* Find:
Code: if(!mysql_real_connect(&maple_db, "localhost", "root", "", "maplestory", 3306, NULL, 0)){
# Change any DB info you set. (The blank "" after "root" is the password).
# After changing, click File -> Save.
# Then, rebuild.[color=red]
Commands / IDds
!map [mapid]
!summon [mobid] ([amount])
!notice [text]
!item [itemid] ([amount])
!shop
!job [jobid]
!level [level]
!sp [amount]
!ap [amount]
Jobs
ID Job Name
500 GM
510 Super GM
000 Beginner
100 Warrior (1)
110 Fighter (2)
120 Page (2)
130 Spearman (2)
111 Crusader (3)
121 White Knight (3)
131 Dragon Knight (3)
112 Hero (4)
122 Paladin (4)
132 Dark Knight (4)
200 Magician (1)
210 Fire/Poison Wizard (2)
220 Ice/Lightning Wizard (2)
230 Cleric (2)
211 Fire/Poison Mage (3)
221 Ice/Lightning Mage (3)
231 Priest (3)
212 Fire/Poison Arch Mage (4)
222 Ice/Lightning Arch Mage (4)
231 Bishop (4)
300 Bowman (1)
310 Hunter (2)
320 Crossbowman (2)
311 Ranger (3)
321 Sniper (3)
312 Bow Master (4)
322 Crossbow Master (4)
400 Thief (1)
410 Assassin (2)
420 Bandit (2)
411 Hermit (3)
421 Chief Bandit (3)
412 Nights Lord (4)
422 Shadower (4)
Pets
ID Name
5000000 Brown Kitty
5000001 Brown Puppy
5000002 Pink Bunny
5000003 Mini Kargo
5000004 Black Kitty
5000005 White Bunny
5000006 Husky
5000007 Black Pig
5000008 Panda
5000009 Dino Boy
5000010 Dino Girl
5000011 Monkey
5000012 White Tiger
5000013 Elephant
5000014 Rudolph
5000015 Dasher
5000017 Robot
5000018 Husky
5000020 Mini Yeti
5000021 Monkey
5000022 Turkey
5000023 Penguin
5000024 Jr. Balrog
5000025 Golden Pig
5000028 Dragon
5000030 Green Dragon
5000031 Red Dragon
5000032 Blue Dragon
5000033 Black Dragon
5000034 Black Bunny
5000036 Jr. Reaper
5000037 Husky
5000039 Porcupine
5000041 Snowman
Throwing Stars
ID Name
2070000 Subi
2070001 Wolbi
2070008 Snowball
2070002 Mokbi
2070009 Wooden Top
2070012 Paper Fighter Plane
2070013 Orange
2070003 Kumbi
2070010 Icicle
2070011 Maple Throwing-Stars
2070004 Tobi
2070005 Steely
2070006 Ilbi
2070007 Hwabi
2070014 Devil Rain
Morph Items
ID Name Monster
5300000 Fungus Scroll Orange Mushroom
5300001 Oinker Delight Pig
5300002 Zeta Nightmare Alien
Summoning Bags
ID Name Summons
2101050 GM event Sack1 “Slime Storm”
2101051 GM event Sack2 “Mushroom Boom”
2101052 GM event Sack3 “Pigs in a Blanket”
2101053 GM event Sack4 “Eye See You”
2101054 GM event Sack5 “Alien Armada”
2101055 GM event Sack6 “Toying Around”
2101056 GM event Sack7 “Crimson Crash”
2100017 Alien Sack Various Omega Sector Aliens
2100000 Black Sack Jr. Balrog
2100014 Brand New Monster Galore Gargoyle
2100016 Different Sack Various Ludibrium Monsters
2100001 Monster Sack 1 Various Monsters Lvl 1 – 10
2100002 Monster Sack 2 Various Monsters Lvl 10 – 20
2100003 Monster Sack 3 Various Monsters Lvl 20 – 30
2100004 Monster Sack 4 Various Monsters Lvl 30 – 40
2100005 Monster Sack 5 Various Monsters Lvl 40 – 50
2100006 Monster Sack 6 Various Monsters Lvl 50 – 60
2100007 Monster Sack 7 Various Monsters Lvl 60 – 70
2101013 Summon Showa Boss Male Boss (Guy with gun)
2100015 Summoning "Dances with Balrog's Clone" Dances with Balrog's Clone
2101001 Summoning Athena Pierce's Clone Athena Pierce's Clone
2101008 Summoning Bag of Birds Chirppy and Tweeters
2101007 Summoning Crimson Balrog Crimson Balrog
2101000 Summoning Dark Lord's Clone Dark Lord's Clone
2100009 Summoning Dark Yeti & Pepe Dark Yeti & Pepe
2101004 Summoning Grendel the Really Old's Clone Grendel the Really Old's Clone
2101005 Summoning Horned Tail A Head A of Horned Tail
2101006 Summoning Horned Tail C Head C of Horned Tail
2100008 Summoning Lycanthrope Lycanthrope
2101002 Summoning Mushmom Mushmom
2101003 Summoning New-Type Balrog Two Crimson Balrogs
2100018 Summoning Superslime King Slime
2100019 Summoning Tauromacis Tauromacis
2100010 Summoning Taurospear Taurospear
2100011 Summoning the Boss Random Boss
2100012 Summoning Werewolf Werewolf
2100013 Summoning Yeti & Pepe Yeti & Pepe
2100031 Toy Robot Sack Toy Robots
2100032 Toy Trojan Sack Toy Trojans
Super Scrolls (10% Scrolls that work 100% of the time)
ID Type
2040603 Bottomwear for DEF
2044503 Bow for ATT
2041024 Cape for Magic Def.
2041025 Cape for Weapon Def.
2044703 Claw for ATT
2044603 Crossbow for ATT
2043303 Dagger for ATT
2040807 Gloves for ATT
2040806 Gloves for DEX
2040006 Helmet for DEF
2040007 Helmet for HP
2043103 One-Handed Axe for ATT
2043203 One-Handed BW for ATT
2043003 One-Handed Sword for ATT
2040506 Overall Armor for DEX
2044403 Pole Arm for ATT
2040903 Shield for DEF
2040709 Shoes for DEX
2040710 Shoes for Jump
2040711 Shoes for Speed
2044303 Spear for ATT
2043803 Staff for Magic Att.
2040403 Topwear for DEF
2044103 Two-handed Axe for ATT
2044203 Two-handed BW for ATT
2044003 Two-handed Sword for ATT
2043703 Wand for Magic Att.
Other Useful Items
ID Name Additional Info
5070000 Cheap Megaphone Everyone on map
5071000 Megaphone Everyone in channel
5072000 Super Megaphone Everyone in world
5050000 AP Reset
5050001 SP Reset (1st job)
5050002 SP Reset (2nd job)
5050003 SP Reset (3rd job)
5050004 SP Reset (4th job)
5090000 Note Sends note to offline character
5100000 Congratulatory Song Plays song on current map
5180000 Water of Life Revives pets
5211001 From NEXON Warning message for hackers
5220000 Gachapon Ticket
5220001 Event Ticket Needed to enter event map
5330000 Quick Delivery Ticket Send package with message
5401000 Character Transfer Transfers character to other world
5400000 Character Name Change Changes character's name
2022245 Heartstopper +60 Attack and Speed (1 minute)
2022068 Yellow Cider +35 Magic Attack (5 minutes)
2022108 Horned Tail Squad : Victory +30 Atk, +40 Matk, +200 Def (1 hour)
2022118 Admin's Congrats 20 minute long buff to say thanks to player.
2022273 Ssiws Cheese +220 Magic Attack (2 minutes)
2022179 Onyx Apple Recovers HP/MP and gives 10 min super buff
Levels 1-10
ID Name Level HP
9400504 Coolie Zombie (Undead) 1 600
9400202 Golden Slime 1 100
9500400 Gourd (Boss) 1 10,000
9500000 Making a wish to full moon (Boss) 1 100,000
9400500 Malady (Boss) 1 4,200
100100 snail 1 8
9400567 Loki Box Tr 1 3
9400566 Loki Box Ex 1 100,000
9409001 Tutorial Drumming Rabbit 1 8
9300018 Tutorial Jr. Sentinel 1 8
9409000 Tutorial Leatty 1 8
8810024 Summon Horned Tail's Left Head 1 40,000
8810025 Summon Horned Tail's Right Head 1 40,000
8810026 Summon Horned Tail 1 40,000
8810018 Horned Tail 1 2,090,000,000
100101 Blue snail 2 15
120100 Shroom 2 20
130101 Red snail 4 45
130100 Stump 4 65
9400501 Jr. Wraith (Undead) 5 600
9400503 Stirge (Boss) 5 300
9400502 Wraith (Undead Boss) 5 2,800
210100 Slime 6 50
9300063 Stirge 6 60
9400505 Turkey 6 50
1210100 Pig 7 75
9500203 Zoo Pig (Boss) 7 10,000
9300062 Flyeye 8 80
9420001 Frog 8 75
1210102 Orange Mushroom 8 80
9400513 Candle Mob (2nd) 10 250
9400506 Candle Monster 10 550
9500144 Coke snail 10 120
1210101 Ribbon Pig 10 120
1110101 Dark Stump 10 250
9500204 Zoo Ribbon Pig (Boss) 10 10,000
Levels 11-20
ID Name Level HP
9300064 Goblin Fire 11 155
9400511 Yellow Eggy Pop 11 250
1120100 Octopus 12 200
9400005 ??? 15 275
1210103 Bubbling 15 240
9500151 Coke Slime 15 240
1110100 Green Mushroom 15 250
9420005 White Rooster 15 230
1130100 Axe Stump 17 300
1140100 Ghost Stump 19 330
9400538 Street Slime 19 320
2220100 Blue Mushroom 20 350
9500152 Coke Mushroom 20 350
2100100 Desert Rabbit (F) 20 350
9600001 Rooster 20 340
2300100 Stirge 20 300
9400568 Turkey Commando 20 350
Levels 21-30
ID Name Level HP
2100101 Desert Rabbit (M) 21 400
2130103 Jr. Necki 21 285
9400539 Urban Fungus 21 350
9400565 Glutton Ghoul 21 300
9600002 Duck 22 380
2110200 Horny Mushroom 22 300
2130100 Dark Axe Stump 22 550
2230108 Pinboom 22 400
9300027 Devil Slime 23 1,000
5200000 Jr. Sentinel 23 600
2230105 Seacle 23 500
2230103 Trixter 23 450
2230110 Wooden Mask 23 500
2230107 Krappy 24 500
2230111 Rocky Mask 24 600
2230101 Zombie Mushroom (Undead) 24 500
2230106 Cico 25 550
9500153 Coketump 25 560
9400000 Crow 25 550
9400540 Killa Bee 25 730
9600003 Sheep 25 550
2230102 Wild Boar 25 550
9420004 Yellow Lizard 25 500
9400547 Boomer 27 700
2230100 Evil Eye 27 720
9400508 Mad Turkey 27 720
2230109 Bubble Fish 28 740
2230104 Green Trixter 28 780
9420000 Toad 28 720
2230200 Flower Fish 29 790
9400006 ??? 30 1,050
3000005 Brown Teddy 30 950
9400512 Cake Mob (2nd) 30 950
9400507 Cake Monster 30 1,200
9400002 Cloud Fox 30 920
9500154 Coketump Lite 30 930
3230400 Drumming Bunny 30 950
3000001 Fairy 30 800
9400001 Fire Raccoon 30 900
5200002 Fire Sentinel 30 900
9600004 Goat 30 900
5200001 Ice Sentinel 30 900
9500169 Fake Jr. Balrog (Boss) 30 3,094
3000006 Krip 30 900
9400518 Magik Fierry B 30 800
9400548 Mighty Maple Eater 30 950
9300061 moon Bunny 30 5,000
3000000 Sentinel 30 900
9400557 Psycho Jack Box 30 10
9400558 Psycho Jack 30 850
9300093 Tylus 30 100,000Cap
ID Name Description
1000000 Blue Beanie
1000001 Fine Black Hanbok Hat
1000002 Fine Blue Hanbok Hat
1000003 Scream Mask
1000004 Old School Uniform Hat
1000005 Men's Ninja Hat
1000006 Samurai Hair-do
1000007 Hat of Death
1000008 Detective Hat
1000009 Mesoranger Red Helmet
1000010 Mesoranger Blue Helmet
1000011 Mesoranger Green Helmet
1000012 Mesoranger Black Helmet
1000013 Yellow Crown
1000014 Green Crown
1000015 Blue Crown
1000016 Red Crown
1000017 Van Hat
1000018 Kuniragi Hat
1000019 Goya Hat 3
1000020 Chief Hat
1000021 General's Wig
1000022 General's Wig
1000023 Race Ace Cap
1000025 Pilgrim Hat
1000026 Santa Boy Hat
1000027 Lunar Celebration Cap
1000029 Wedding veil
1000030 Sachiel Wig (M)
1000031 Veamoth Wig (M)
1000032 Janus Wig (M)
1001000 Orange Beanie
1001001 Hanbok Jobawi
1001002 Witch Hat
1001003 Pink Nurse Hat
1001004 White Nurse Hat
1001005 Women's Ninja Hat
1001006 SF Ninja Hat
1001007 Female Wig
1001008 A Ladylike Hat
1001009 Ribbon
1001010 Teddy Bear Hat
1001011 Strawberry Headgear
1001012 Tiara
1001013 Beret
1001014 Mesoranger Pink Helmet
1001015 Mesoranger Yellow Helmet
1001016 Mesoranger Black Helmet
1001017 Princess Tiara
1001018 Lady Blue
1001019 Lady Pink
1001020 Lady Yellow
1001021 The Gabera Hat
1001022 Van Hat w/ Heart
1001023 Picnic Hat
1001024 Diamond Tiara
1001025 Ruby Tiara
1001026 Red-Feathered Indian Bandana
1001027 Blue-Feathered Indian Bandana
1001028 Jami Wig
1001029 Yellow Bride's Veil Flowing veil that brides wear on their Wedding Day.
1001030 Diao Chan Headpiece
1001031 White Cat Ears
1001032 Black Cat Ears
1001033 Maid Hat
1001035 Maplehontas
1001036 Santa Girl Hat
1001037 Leopard Print Hat
1001038 Korean Dress Wig
1001039 Lunar Celebration Ornament
1001042 Purple Bride's Veil Flowing veil that brides wear on their Wedding Day.
1001043 Royal Tiara Hand crafted Tiara that brides wear on their Wedding Day
1001044 Green Bride's Veil Flowing veil that brides wear on their Wedding Day.
1001045 Sachiel Wig (F)
1001046 Veamoth Wig (F)
1001047 Janus Wig (F)
1001048 Gothic Mini Hat
1001049 Gothic Headband
1002000 Brown Flight Headgear
1002001 Metal Gear
1002002 Metal Koif
1002003 Steel Helmet
1002004 Great Brown Helmet
1002005 Iron Burgernet Helm
1002006 Bone Helm
1002007 Steel Full Helm
1002008 Brown Skullcap
1002009 Steel Football Helmet
1002010 Brown Winter Hat
1002011 Iron Viking Helm
1002012 Red Baseball Cap
1002013 Golden Pride
1002014 Red Headband
1002015 Red Swimming Goggle
1002016 Green Wizardry Hat
1002017 Brown Apprentice Hat
1002018 Green Camping Hat
1002019 White Bandana
1002020 Red Starry Bandana
1002021 Steel Nordic Helm
1002022 Old Steel Nordic Helm
1002023 Jousting Helmet
1002024 Emerald Dome
1002025 Red Duke
1002026 Brown Bamboo Hat
1002027 Steel Sharp Helm
1002028 Silver Crusader Helm
1002029 Red Oriental Helmet
1002030 Silver Planet
1002031 Cat Hat
1002032 Puffy Brown Hat
1002033 Old Wisconsin
1002034 Blue Jester
1002035 Pink Jester
1002036 Green Jester
1002037 Black Jester
1002038 Brown Jester
1002039 Bronze Helmet
1002040 Mithril Helmet
1002041 Yellow Metal Gear
1002042 Blue Metal Gear
1002043 Bronze Koif
1002044 Mithril Koif
1002045 Blue Bone Helm
1002046 Red Bone Helm
1002047 Great Red Helmet
1002048 Great Blue Helmet
1002049 Gold Burgernet Helm
1002050 Orihalcon Burgernet Helm
1002051 Bronze Full Helm
1002052 Mithril Full Helm
1002053 Green Skullcap
1002054 Red Skullcap
1002055 Bronze Football Helmet
1002056 Mithril Football Helmet
1002057 Green Winter Hat
1002058 Mithril Viking Helm
1002059 Bronze Viking Helm
1002060 Black Baseball Cap
1002061 Yellow Baseball Cap
1002062 Brown Baseball Cap
1002063 Blue Baseball Cap
1002064 Bronze Pride
1002065 Steel Pride
1002066 Black Headband
1002067 Green Headband
1002068 Yellow Headband
1002069 Blue Headband
1002070 Green Swimming Goggle
1002071 Blue Swimming Goggle
1002072 Blue Wizardry Hat
1002073 Red Wizardry Hat
1002074 Blue Apprentice Hat
1002075 Red Apprentice Hat
1002076 Red Flight Headgear
1002077 Blue Flight Headgear
Making a Private Server Of ms 
