Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Skilled Illusionist
Loyal Member
Joined
Jun 27, 2008
Messages
391
Reaction score
12
Download the attachment, then rename it so it has ".sql" at the end, so for an example, rename it "SkelegonAndSkelesaurusDrop110Equips.sql" without the ". Then, open it with MySQL and execute it.

The drop rate is 3,000. If you want to edit it, open up the script with notepad, then go to Edit > Replace. In the "Find What:" box, put 3000. In the "Replace With:" box, put the drop rate you want instead of 3000.

Since the drop rate is 3000, that means, if you had a 1x drop rate server, which is the normal drop rate, 1 out of every 3000 skelegons/skelesaurus' will drop a level 110 equip. That is just an estimation though.

BTW, I got this idea from LocalMS.
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Jun 28, 2008
Messages
48
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Well Skelegon and Skelesaurus are the strongest trainable monsters in the game. Wise choice. Very nice. Now Maplers will be able to hunt down for the ultimate weapons.
 
Junior Spellweaver
Joined
Jan 21, 2008
Messages
168
Reaction score
1
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Lol wee
now i can go kill my 110 shop xD
 
Newbie Spellweaver
Joined
Dec 12, 2007
Messages
93
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Smart Decision :]
Players now dont have to whine for 110 Armors..
 
Skilled Illusionist
Loyal Member
Joined
Jun 27, 2008
Messages
391
Reaction score
12
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Make them fight for their items!
 
for(alive>0){makeMoney()}
Loyal Member
Joined
Aug 1, 2006
Messages
357
Reaction score
68
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Great idea!
I was thinking of something simeler to this buy couldent pick a monster!
Added to my server, thanks a bunch.
 
Newbie Spellweaver
Joined
Jun 28, 2008
Messages
7
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

very nice release,thx..but even the drop rate is 50,i can find those eq easily tho..
 
Skilled Illusionist
Loyal Member
Joined
Jun 27, 2008
Messages
391
Reaction score
12
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Then change it higher. If you want it 1/3000 in 50x rates, do 50 x 3000 which is 1/150000.
 
Experienced Elementalist
Joined
Oct 26, 2006
Messages
260
Reaction score
62
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

God, when I add this in, there is going to be ton of people training there lol.
 
Initiate Mage
Joined
Jul 15, 2008
Messages
4
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

i try to run the sql but they dont drop any of the drops is there something i need to do to make able to drop the 110 items >.?
 
Newbie Spellweaver
Joined
Jun 18, 2008
Messages
11
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Then change it higher. If you want it 1/3000 in 50x rates, do 50 x 3000 which is 1/150000.


lol it's be 50 / 3000
x_X
because it makes it easier to find, not harder
 
Newbie Spellweaver
Joined
Aug 11, 2008
Messages
42
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Code:
INSERT INTO monsterdrops VALUES(0, 8190003, 1052076, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1052076, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1372032, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1372032, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1052072, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1052072, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1082167, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1082167, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1082163, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1082163, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1082164, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1082164, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1082168, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1082168, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1072269, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1072269, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1072272, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1072272, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1002547, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1002547, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1002550, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1002550, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1072273, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1072273, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1002551, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1002551, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1052071, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1052071, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1052075, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1052075, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1072268, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1072268, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1472051, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1472051, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1472052, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1472052, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1382036, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1382036, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1332050, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1332050, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1332049, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1332049, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1452044, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1452044, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1322052, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1322052, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1462039, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1462039, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1312031, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1312031, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1302059, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1302059, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1402036, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1402036, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1422028, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1422028, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1412026, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1412026, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1432038, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1432038, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1442045, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1442045, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1442002, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1442002, 3000);
INSERT INTO monsterdrops VALUES(0, 8190003, 1092042, 3000);
INSERT INTO monsterdrops VALUES(0, 8190004, 1092042, 3000);
Just execute it in MYSQL
 
Junior Spellweaver
Joined
May 20, 2008
Messages
153
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Cool release, saves alot of work for GMs
 
Newbie Spellweaver
Joined
Aug 8, 2008
Messages
50
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Nice release.. this is a wise choice of putting 'em in Skeles.
 
Newbie Spellweaver
Joined
Jun 20, 2008
Messages
43
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Agreed. Nice release.
And the short explanation about chance helped.
Didn't have a clear idea of how it worked before.
 
Newbie Spellweaver
Joined
Jul 19, 2008
Messages
11
Reaction score
0
Re: [Release][MySQL Script] Skelegons/Skelesaurus drop level 110 equips

Nice release :D
 
Back
Top