[Roamer]

Click here for a list of Commands and id's!
------------------
Latest update: Back to updating! - POST!
------------------
:Library Announcement:
+Click the SHOW button under what category you want and it will show it!

Easier way to find your tool/npc/command/ETC -

+You can do CLT+F and type in what your looking for, example.
' im looking for sera, ill do CLT+F and type in "sera" and it will take you to places where it says "sera".

+Or you can also use the search button, and type it there.
------------------
Library (Find releases, fixes, guides & more)

------------------
Orange --v55*
Purple --v56*
Red--v59*
Blue--v60*
Green--v61*
Cyan--v62*
Pink--v63*
Black--v74*

------------------
OdinMS Source Library
OdinMS Clean rev 988 Download
------------------
Click the SHOW button under what category you want and it will show it!
------------------
:MySQL Commands:

Spoiler:

:Table Of Contents:

1. Logged in fix/glitch
2. Adding/Setting Nx
3. Setting all shop prices
4. Removing an item sold in all shops
5. Setting an account as a GM
6. Removing a ban
7. Adding guild points to a guild
8. Removing skills from ALL players (in case of buggy)
9. Deleting chars
10. Setting a chars stats
11. Manual ban (account only)
12. Fixing inventory glitch (0 of an item)
13. Reg and Ranking Fix
14. Wedding Drops
15. Char wipe
16. Inventory wipe
17. Adding mesos to EVERYONES storage
18. Negative exp fix
19. Negative meso fix.
20. Added/Subtracting slots in storages.
21. Spirits and Scales drops
22. Setting price of one item to X
23. Setting price of a whole shop to X.
24. Deleting a item from droping from all monsters
25. Negative mesos in storage
26. Hp/Mp bug
27. Removal of pet equips

Logged in fix/glitch:

 Update accounts set loggedin = 0 

Added/Setting nx:

 To ADD: update accounts set nxcash = nxcash + [amount]

 To SET: update accounts set nxcash = [amount] 

Setting all shop prices:

 update shopitems set price = [amount] 

Removing an item sold in all shops

DELETE FROM shopitems WHERE itemid = [id]

Setting an account as a GM:

 update accounts where accountid = [id you want to be gm] set gm = 1

 and

 update characters where name = '[name]' set gm = 1 

Removing a ban:
This will unban ONLY an account, the ip and MAC will still be banned.

 update accounts where accountid = [id] set banned = 0 

Adding guild points to a guild:

 update guilds where guildid = [id] set GP = [amount] 

Removing skills from ALL players (in case of buggy)

 delete from skills where skillid = [id of skill to delete] 

Deleting chars:

 delete from characters where name = '[name]' 

Setting a chars stats:
Can do with hp/mp/maxhp/maxmp

 update characters where name = '[name]' set [stat (str, int, luk, dex)] = [amount] 

Manual ban:

 update accounts where accountid = [id] set banned = 1 

Fixing inventory glitch (0 of items in inv)
This will make it so stars arent deleted.

 First:
 update inventoryitems SET quantity = 1 where itemid = 2070006
 and 2070005
 and 2070016
 and 2070004
 and 2070007

 Then

 delete from inventoryitems where quantity = 0 

For reg and rankings problems execute these 3 codes:

 ALTER TABLE `accounts` MODIFY COLUMN `macs` TINYTEXT NULL DEFAULT NULL;
 ALTER TABLE `characters` ADD `rebirth` INTEGER UNSIGNED NOT NULL DEFAULT 0
 ALTER TABLE `accounts` MODIFY COLUMN `banreason` TEXT NULL DEFAULT NULL; 

Wedding Drops:

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (9300098, 2020020,2000);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (9300098, 5251003,2000);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (93000*** 5251003,2000);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (93000*** 2020020,2000); 

Char wipe
This will wipe all chars except ones with GM set to 1, good for beta wipe, ect.

 delete from characters where gm = 0 

Inventory Wipe
Should clear your whole `inventoryitems` table, good for beta wipe, ect.

 delete from inventoryitems where inventorytype = -1;
 delete from inventoryitems where inventorytype = 0;
 delete from inventoryitems where inventorytype = 1;
 delete from inventoryitems where inventorytype = 2;
 delete from inventoryitems where inventorytype = 3;
 delete from inventoryitems where inventorytype = 4;
 delete from inventoryitems where inventorytype = 5; 

Adding mesos to everyones storage

 UPDATE storages SET meso = meso + [amount] 

Negative exp fix

 UPDATE characters SET exp = 0 WHERE exp < 0 

Negative Meso Fix

 UPDATE storages SET meso = 0 WHERE meso < 0 

Adding/Subtracting slots in storage accounts
Meaning you can have more then 16 items in your storage

 For EVERYONE: update storages set slots = [amount]
 For a SINGLE person: update storages where accountid = [id] set slots = [amount] 

Spirits and Scales Drops
This will make it so you can get the items for the lvl 110 weapons quest.

INSERT INTO monsterdrops

 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8140701, 4000244, 10);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8140701, 4000245, 10);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8140702, 4000244, 10);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8140702, 4000245, 10);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8140703, 4000244, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8140703, 4000245, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150300, 4000244, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150300, 4000245, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150200, 4000244, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150200, 4000245, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150301, 4000244, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150301, 4000245, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150302, 4000244, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150302, 4000245, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150201, 4000244, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8150201, 4000245, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190000, 4000244, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190000, 4000245, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190005, 4000244, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190005, 4000245, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190003, 4000244, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190003, 4000245, 15);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190004, 4000244, 20);

 INSERT INTO monsterdrops
 (`monsterid`, `itemid`, `chance`)
 VALUES
 (8190004, 4000245, 20); 

Setting price of one item to X

update shopitems  where itemid = [id] set price = [amount]

Setting price of a whole shop to X

update shopitems where shopid = [id] set price = [amount]

Deleting a item from droping from all monsters

DELETE FROM monsterdrops WHERE itemid = [id]

Negative Mesos In Storage

UPDATE storages WHERE meso < 0 SET meso = [amount]

Bugged hp/mp Fix

UPDATE characters WHERE maxhp > 30000 SET maxhp = 30000

 UPDATE characters WHERE maxmp > 30000 SET maxmp=30000 

Another way to delete inventory

delete from inventoryitems

Remove pet equips
Incase characters are bugged/glitched

DELETE FROM `inventoryitems` WHERE `itemid` >= 1812000 AND `itemid` <= 1812010

DELETE FROM `inventoryitems` WHERE `itemid` >= 1802000 AND `itemid` <= 1802050

---------
:Npcs:

Spoiler:

Folderz Auto Job
Job Advancer NPC. HAX
Ultimate Warper
Region Exchanger
Gift Box
Fairy Tales Npc
Reward Exchanger NPC
Trapped until you say "Yes" NPC
Super info NPC
Russian Roulette NPC
Female Hair And Eyes at KIN npc GMMap
Chaos Scroll NPC
Crystal Ilbi Creator
Rick Roll NPC
White scroll maker NPC
Prank NPC
Custom skill maxer
Supreme Sera
Duey skill maxer + Echo of hero
Duey skill maxer (Maxes pirate skills!)
Stat maxer
Pet name changer
NimaKIN Explains GameMaster
GM List NPC MIA
Custom NPC (Rare NX)
Exp Seller
Rebirth NPC with AP Reset
Sera starter pack
Custom NX seller NPC
Gender changer
Custom NPC's
NPC that sells ALL NX
Custom NPC's V2
Meso bank NPC
Gambling NPC
Sera+Peter give starter packs + hair
Casino NPC v2
Food NPC
Spinel warper
Custom sera
all Teleporter NPC's
SurealStory NPC's
Buddy capacity seller
Pirate&Chaos Scrolls seller
Nana's in each town selling everything
WORKING 4th Job Advance (FIXED)
Beta wedding
Very funny npc pack
Jail Npc
New Equip Seller - Pirate NX codes and more !
Sera with Pirate Job (v58+ i think xD)--v59*
Rebirth NPC [No Compiling Needed]
Spinel has v.60 maps--v60*
Sera Starter pack
Punked Npc
Skill Maxer NPC including Pirates
Robo Egg Hatcher
Real Fame Seller
Tombstone - Crack Seller/warper
AP Resetter
Advanced Spinel
Super Monster V 1.0
FBI NPC
General Spawn Npc v1.0.1
Custom Sera

---------
:Shops:

Spoiler:

All In One Shop
All in one shop with Pirate Equips- V6
All job equips 70 - 110 NPC
Pet shop seller
Custom GM shop
Best shop ever!
Mu lung pot shop
All shops in maplestory
All shops
Kerning Wpn & Armour shops
Taxi's and shops v1
Summoning bag shop
Walkman shop--v59*
One meso shop
GM Custom shop
Fredrick pirate equips
Custom shop
Target multi shop
All shops in 1 SQL
Aprul fools shop
Missing NX shop
Spinel warp/shop
Ultimate NPC shop
4 in 1 ultimate shop
Level 70 weapon seller and Maple item seller
Emotion shops and set
Awesome shop
Lith harbor shop
Spindle shop
SHOPS| Level 35,43,64 Maple Weapons, 70, 90-110 Weapons
All job weapons and equip lvl 50-110
Fun shop
Almost all equips lvl 1-110 in Fredrick!
Lefrea shops
All 62 Shop NPC's
Showa Shop (Shinta)
Pirate Equip - Scroll Shop
Casey selling colored items
Nana(P) Selling all maple items and weapons
All Potions and Foods and Antidotes
All in one shop *NEW*
MapleIsland Shops
All 62 Shop NPC's

---------
:Maps:

Spoiler:

All-in-One Boss Summoning Training Map
Custom FM maps
Low gravity Ludi and Henesys Petpark Maps
HenesysGround new stlye!
Custom skelegon map
Monster Galore bosses map xmls
Forced Return Maps
SUPER Boss MAP
Pigcity (Pig Town)
Ultimate Musical Harp
OnePiece Fm v1.1 UpData With Boss Rm's~!
Crazy Boss Map
Ludibrum Training Grounds
Donators Island v2

---------
Drops:

Spoiler:

All Monster's drop NX
Drops for Scales and Spirts
Custom Horntail drops
Drops for Toki box tr / Bob
GMS like Zakum Drops
Lvl 101-200 monster drops
Lady boss , Bodyguard A,B & The Boss drops
Monster Drops lvl 51-60
Zakum B3 Drops
Green Snails Drops White Scrolls (they allways drop them when u kill one)
Headless Horseman Drops and soon more.
Official MS Monster Drops
Leafre ETC Drops
Big Puf Daddy drops 110 stuff
Flying Horseman Drops Stars
Skelegons/Skelesaurus drop level 110 equips
All boss drops
JrRog drops all lvl100 Weapons+Suprise
Anniversary Cake Full Drops && Big Puff Daddy
Real MS Drops
Zakum + Zakum Drops
Horntail Drops
Zakum Drops
Anniversary Cake Drops
NX Golden slime Full Drops
All Drops
Horned Tail drops for GMSDB
Item Drop's
All drops lv1-200 WITH CORRECT MESOS
All Drops!

---------
:Guides:

Spoiler:

How to Make a Server Launcher in Java with vote and etc
How to use Kiki's localhost (VIDEO TUT)
How to use Kiki's localhost
How to stop Leeching websites
How to add AP, HP, MP cap.
How to Set-Up Moogra MS Repack
How to fix Not registered ID/Cant pass Char Select/Chars dispear/Login Stick
Server going Public without Hamachi
All-in-one Guide to making your Odin Private Server (SeanPack)
Getting rid of :8080 when you are behind a router + EXTRA! 1.0
Everything you need for your sever Fixs/NPCs/Tuts/cool extras/
Get rid of hamachi without static IP
Setting up Registrations
Making Registration Website w/ wamp
How to make your own private server (SPECIAL FOR NOOBS!)
How to edit hp/mp on level up for all jobs
How to start your maple private server
Compiling with NetBeans
Setting Up Registrations with Abyss Web Server
Adding more locations to your !goto command
How to PortForward
All about channels. Multi-hosts / number of channels.
How to add NEW NPC in a map
How to fix ArrayIndexOutOfBound
How to change attack range cap of your client...
How To Make A Reg Page *noob Friendly*
Port Forwarding
Vote Popup
Characters Can't Past Character Selection
How to make shops
How to change Server Message/Event Message/World Name
Making items to stats9999 without others having it
Editing Clients with OllyDbg
How to make your server non-hamachi with a dynamic IP
Tempban
How to switch repacks/backup server files
MapleStory Cms/ Registration Page
How to get others within your database
Setting Up - Microsoft Loopback Adapter
How to Patch
How To Enable autoban if its disabled
How To Make A Server - Hamachi
SVN updating
How to edit monster's stats, spawns, and how to add spawn rate!
How to change DISREGARD THAT I......
Raising the level cap
How To Raise AP Cap
Setting Up
How to fix Field 'banreason' doesn't have a default value
How to fix 'Java' is not recognized as a external command
How to run/use DXwnd
Making a launcher with borland delph
How to Remove/Change the Magic Cap in the client.
How To Analize NPC Scripts

---------
:Commands:

Spoiler:

Commands list for ThePACK
Improved !job command
!goto - FIXED
!unbuffworld
@killplayer command
!SendHint
killall - PurpleMadness Style
OdinMS NPC editing commands
@clearslot Command, Clears item inventory slot
Alot of COMMANDS!
!gmscroll command
!castskill
!worldtrip (punish command)
save command
xprate command
Improved !job command
max all stats command
Meso Command
!leeton/!leetoff (Fun Command)
Suicide command
!str !dex etc etc command
!str !dex[playername] [amount] command
Skill maxing command!
giveItemBuff Npc command
!ap command
#job command auto givejob
!slap command
!hurt command
#stat command Auto Stat distribution
Unused Boss w.Drops and summon command.
PvP revive/heal command!
Avatar Smega Command
Mesos to nxCash Command
Improved !online command
Fame Command
!AllBoss Command
Improved !map command
eventboss command
Simple !showshop command
Improved !ap command
find command fix
Save all command and banning system!
Spawning freedom
@str, @dex, @luk, @int Command *UPDATED*(There's a new fix, check under Fixes)
Summon Commands
Proper @rebirth command
Improved !online command
Simple !showshop command
!MR Using mount speed while not on mount bug
!HealMap and !HealAll
Ingame Command to reload monsterdrops database

---------
:Events/PQ's:

Spoiler:

Custom X'mas Event
KPQ

---------
:GM tools/server tools:

Spoiler:

MapleStory Client Launcher
Java Codes
The original handbook
Tensyume's GM Handbook
Monster SQL Generator v2
Shop SQL Generator v1
ID Grabber - beta v8
Monster Drop SQL Generator 1.1 & OdinMS Shop Generator 1.0
ImGM v5.2
ImGM V3
GM tool
MapleStory Private Server Automatic Restarter
Server Restarter v.02
Hex Calculator
Hash Calc
C# EMULATOR - CHROCORE--v55*--v59*--v60*
Lots of Things Uploaded Repacks,Cms's,Maplestory Revs
2x better launchers(must have)
MSConsole v 1.0.3
GM Handbook V4
Easy Client Editor V2.2
Giro Game Launcher [Second Generation]
MapleStory Checker + Starter
MapleStory Server Manager (Launcher)
Latest add-on ID's--v61*
GM Handbook--v61*

---------
:Repacks/Sources:

Spoiler:

BubbleDev--v62*
Maple4U--v61*
ThePack Repack--v62*
** ThePack & SineMS Revisions--v55*--v62*
Clean Valhalla--v62*
Clean Vana--v62*
SineMS Repack v3.0 Final--v55*
The Extraordinary Repack--v56*
Fallen CitY Unlimited repack--v59*
PCMaple Re-Pack v2.5--v55*
MazollaV1.0 Repack--v55*
AbsolutMS 0.01 Beta--v60*
SeanPack 5.9 with PVP and Pets--v55*
Xuanms 1.0--v60*
Old CookieMS Repack--v55*
FairFrozen 0.1 Repack--v60*
PhoenixMS Repack--v55*
BLEACH MS repack--v62*
CelestialMs Source--v55*
NoriMS Repack 6.0--v62*
FrostyMS repack--v55*
SmexyStory--v55*--v61*--v62*
LaksaMS Repack--v61*
HurricaneMS source--v59*

---------
:Localhost:

Spoiler:

Localhost v.74
Localhost v62
Localhost v.62 (KiKI)
Localhost v.60
Editted Localhost v.60
Localhost v.59
Localhost v.58
Localhost v.57
LocalHost v.56
Localhost v.55
Localhost v.55 with Cashshop

---------
:CMS's/Websites:

Spoiler:

G-StarMS CMS
Cype CMS
Basil market CMS
LFS CMS v1.5
FlowsionMS CMS
FlowsionMS CMS (Edited, Fixed)
SinStory CMS
s0wh4t?'s CMS
FlareCMS V14
MapleStyle Web
Epic Invoker Cms
PlainCMS (v1-v2- v3)
XurpleCMS
SocialityMS Website
SkillMS Cms Plain! v.1
NYMS's CMS
CelestialMs Website files
PickleMSCMS - SinStory CMS Redone! -v1.0
Itsu MS CMS

---------
:CMS & Website Tools/Scripts:

Spoiler:

Vote Script
PHP NX Seller (WEB)
PHP Name Changer (WEB)
PHP Scripts
Pirates in rankings - s0wh4t's CMS
Rebirth on DarkMagics ranking
Avatar Ranking For s0wh4t? CMS
Website Add Ons

[Thread was half destroyed to due Thread limit, fixing atm!]

[DrFusion]

Good work Luke x]
Very useful

[nejevoli]

good job !

[Roamer]

Originally Posted by DrFusion

Good work Luke x] Very useful

Originally Posted by nejevoli

good job !

Thanks guys :]

[DeathMasta]

GJ, more organized

[Roamer]

Remember to post any new stuff that i can add :]

[DeathMasta]

Do you think you can find 4 Nanas selling stuff like Nana(H) for bow man...etc..?

[Roamer]

Originally Posted by DeathMasta

Do you think you can find 4 Nanas selling stuff like Nana(H) for bow man...etc..?

I have that,
its the 2nd shop in the shops section

[DeathMasta]

ok, thnx man! keep up the good work

[Roamer]

Originally Posted by DeathMasta

ok, thnx man! keep up the good work

Moved it to NPC's its the last one in NPC's :)
and thanks~

[xChibi]

Grats on Sticky! xD Thanx for the Library

[Roamer]

Originally Posted by xChibi

Grats on Sticky! xD Thanx for the Library

Thanks :)

[JusticeDK]

nice, u should put more stuff!

[Roamer]

Originally Posted by JusticeDK

nice, u should put more stuff!

I put that in,
what ideas have you got?

[DeathMasta]

this is new, there is lots more to add! =]

[Roamer]

Originally Posted by DeathMasta

this is new, there is lots more to add! =]

tell me what to add,
ideas plawx.

[JusticeDK]

Originally Posted by Roamer

I put that in, what ideas have you got?

i mean like when ppl release new stuff edit this thread cuz other nerver edit their threads...

[Roamer]

Originally Posted by JusticeDK

i mean like when ppl release new stuff edit this thread cuz other nerver edit their threads...

I will and did.

[Roamer]

Originally Posted by SaintsIan

now who was the faggot that reported me and got my first post deleted? It was not a spam, it was a state of disturbance and surprise.

No idea but its funny :]

-Thread updated, added npcs.

[Moogra]

Try to separate the odin and titan stuff

[Roamer]

Originally Posted by Moogra

Try to separate the odin and titan stuff

There shouldnt be titan,
please point out which ones are titan.

[get31720]

wow this is nice =D

[Roamer]

Adding Sections:
Xmls, wz's
and
MSSetups

[DeathMasta]

Here is SeanPack 5.9 with PVP and Pets
http://forum.ragezone.com/f427/release-seansource-v5-9-pets-pvp-pet-shop-mia-438321/

MS Setup V.59
Credits to SF of CEF for this
http://www.megaupload.com/?d=HP40E291
aZnLee for these

http://files.filefront.com/MapleStor.../fileinfo.html - Filefront
http://www.megaupload.com/?d=482RBKTP - Megaupload

incase u needed more

[Roamer]

Originally Posted by DeathMasta

Here is SeanPack 5.9 with PVP and Pets http://forum.ragezone.com/f427/release-seansource-v5-9-pets-pvp-pet-shop-mia-438321/ MS Setup V.59 Credits to SF of CEF for this http://www.megaupload.com/?d=HP40E291 aZnLee for these http://files.filefront.com/MapleStor.../fileinfo.html - Filefront http://www.megaupload.com/?d=482RBKTP - Megaupload incase u needed more

Added repack.
Adding mirror of v59
thanks,