Query To Drop D13

Welcome All

I Know Its Very Old And 90 % Do It But Begnnier Still Can't Do It !
So Today I Will Share This To Help Begnniers

Lets Start
First Query

Code:

---

UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup34='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup35='14.999' where MonLevel='130'
UPDATE [dbo].[_RefDropClassSel_RareEquip] set ProbGroup36='14.999' where MonLevel='130'

---

Query 2

Code:

---

UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='121'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='122'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup34='0.000403' where MonLevel='123'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='124'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='125'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='126'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup35='0.000416' where MonLevel='127'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='128'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='129'
UPDATE [dbo].[_RefDropClassSel_Equip] set ProbGroup36='0.000433' where MonLevel='130'

---

3 Step Add This Is Line To SRO_VT_SHARD/_RefDropItemAssign

Spoiler:

1 39002 50 100 -1 1
1 39003 50 100 -1 1
1 39004 50 100 -1 1
1 39005 50 100 -1 1
1 39006 50 100 -1 1
1 39007 50 100 -1 1
1 39008 50 100 -1 1
1 39009 50 100 -1 1
1 39010 50 100 -1 1
1 39011 50 100 -1 1
1 39012 50 100 -1 1
1 39013 50 100 -1 1
1 39014 50 100 -1 1
1 39015 50 100 -1 1
1 39016 50 100 -1 1
1 39017 50 100 -1 1
1 39018 50 100 -1 1
1 39019 50 100 -1 1
1 39020 50 100 -1 1
1 39021 50 100 -1 1
1 39022 50 100 -1 1
1 39023 50 100 -1 1
1 39024 50 100 -1 1
1 39025 50 100 -1 1
1 39026 50 100 -1 1
1 39027 50 100 -1 1
1 39028 50 100 -1 1
1 39029 50 100 -1 1
1 39030 50 100 -1 1
1 39031 50 100 -1 1
1 39032 50 100 -1 1
1 39033 50 100 -1 1
1 39034 50 100 -1 1
1 39035 50 100 -1 1
1 39036 50 100 -1 1
1 39037 50 100 -1 1
1 39038 50 100 -1 1
1 39039 50 100 -1 1
1 39040 50 100 -1 1
1 39041 50 100 -1 1
1 39042 50 100 -1 1
1 39043 50 100 -1 1
1 39044 50 100 -1 1
1 39045 50 100 -1 1
1 39046 50 100 -1 1
1 39047 50 100 -1 1
1 39048 50 100 -1 1
1 39049 50 100 -1 1
1 39050 50 100 -1 1
1 39051 50 100 -1 1
1 39052 50 100 -1 1
1 39053 50 100 -1 1
1 39054 50 100 -1 1
1 39055 50 100 -1 1
1 39056 50 100 -1 1
1 39057 50 100 -1 1
1 39058 50 100 -1 1
1 39059 50 100 -1 1
1 39060 50 100 -1 1
1 39061 50 100 -1 1
1 39062 50 100 -1 1
1 39063 50 100 -1 1
1 39064 50 100 -1 1
1 39065 50 100 -1 1
1 39066 50 100 -1 1
1 39067 50 100 -1 1
1 39068 50 100 -1 1
1 39069 50 100 -1 1
1 39070 50 100 -1 1
1 39071 50 100 -1 1
1 39072 50 100 -1 1
1 39073 50 100 -1 1
1 39074 50 100 -1 1
1 39075 50 100 -1 1
1 39076 50 100 -1 1
1 39077 50 100 -1 1
1 39078 50 100 -1 1
1 39079 50 100 -1 1
1 39080 50 100 -1 1
1 39081 50 100 -1 1
1 39082 50 100 -1 1
1 39083 50 100 -1 1
1 39084 50 100 -1 1
1 39085 50 100 -1 1
1 39086 50 100 -1 1
1 39087 50 100 -1 1
1 39088 50 100 -1 1
1 39089 50 100 -1 1
1 39090 50 100 -1 1
1 39091 50 100 -1 1
1 39092 50 100 -1 1
1 39093 50 100 -1 1
1 39094 50 100 -1 1
1 39095 50 100 -1 1
1 39096 50 100 -1 1
1 39097 50 100 -1 1
1 39098 50 100 -1 1
1 39099 50 100 -1 1
1 39100 50 100 -1 1
1 39101 50 100 -1 1
1 39102 50 100 -1 1
1 39103 50 100 -1 1
1 39104 50 100 -1 1
1 39105 50 100 -1 1
1 39106 50 100 -1 1
1 39107 50 100 -1 1
1 39108 50 100 -1 1
1 39109 50 100 -1 1
1 39110 50 100 -1 1
1 39111 50 100 -1 1
1 39112 50 100 -1 1
1 39113 50 100 -1 1
1 39114 50 100 -1 1
1 39115 50 100 -1 1
1 39116 50 100 -1 1
1 39117 50 100 -1 1
1 39118 50 100 -1 1
1 39119 50 100 -1 1
1 39120 50 100 -1 1
1 39121 50 100 -1 1
1 39122 50 100 -1 1
1 39123 50 100 -1 1
1 39124 50 100 -1 1
1 39125 50 100 -1 1
1 39126 50 100 -1 1
1 39127 50 100 -1 1
1 39128 50 100 -1 1
1 39129 50 100 -1 1
1 39130 50 100 -1 1
1 39131 50 100 -1 1
1 39132 50 100 -1 1
1 39133 50 100 -1 1
1 39134 50 100 -1 1
1 39135 50 100 -1 1
1 39136 50 100 -1 1
1 39137 50 100 -1 1
1 39138 50 100 -1 1
1 39139 50 100 -1 1
1 39140 50 100 -1 1
1 39141 50 100 -1 1
1 39142 50 100 -1 1
1 39143 50 100 -1 1
1 39144 50 100 -1 1
1 39145 50 100 -1 1
1 39146 50 100 -1 1
1 39147 50 100 -1 1
1 39148 50 100 -1 1
1 39149 50 100 -1 1
1 39150 50 100 -1 1
1 39151 50 100 -1 1
1 39152 50 100 -1 1
1 39153 50 100 -1 1
1 39154 50 100 -1 1
1 39155 50 100 -1 1
1 39156 50 100 -1 1
1 39157 50 100 -1 1
1 39158 50 100 -1 1
1 39159 50 100 -1 1
1 39160 50 100 -1 1
1 39161 50 100 -1 1

Done Finish
Credit To : King$ Not Other >> Dont Re Release Under Your Name ^^ <<

Have Fun All

old but it's useful for beginners :)

useless only add lines to refDropassign and it will work

Quote:

---

Originally Posted by InsaneDev

useless only add lines to refDropassign and it will work

---

Do u know what's this query for ?

First Query

To Active
To Active Mobs 121 - 130 Drop

And

Query 2

too
To Active Mobs 121 - 130 Drop

never wanted that query anyway i will look into the tables

can you tell me how stop 12dg item to drop and if iwant it drop agine what make when need stop and what make when need it drop?

no nononono :D i will change level 120 only :D

isnt ProbGroup34 to ProbGroup36 belongs to 12D Star/Moon/Sun.? for 13D it would be ProbGroup37 to 39.

Quote:

---

Originally Posted by InsaneDev

useless only add lines to refDropassign and it will work

---

yea useless lol it event hasnt all 13d items ~50% of them only but as exaple it will work for some guys

not work i got this in G.S

local overlap job exception!! : CServerProcessOverlap