[Release] Query To Drop D13

10/20/2012 20:46 Alexiuns#1

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

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

Have Fun All

10/22/2012 20:19 Alexiuns#2

thane to @$$ and thebigbod to press thanks :D

10/22/2012 20:43 intercsaki#3

Quote:

Originally Posted by Special-Magician

thane to @$$ and thebigbod to press thanks :D

I think this is a quite unnecessarry post (not to mention it's double posting).

@ON: Nice release for beginners, thanks. :)

01/14/2013 17:09 hayalet1086#4

SR_gameServer Ovarlop Errors :S

Pls Help Me

01/16/2013 18:22 Crue*#5

Quote:

Originally Posted by intercsaki

I think this is a quite unnecessarry post (not to mention it's double posting).

@ON: Nice release for beginners, thanks. :)

01/16/2013 20:03 SyncOnline#6

old but nice

11/27/2018 06:20 gmroske#7

Quote:
Originally Posted by Alexiuns
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

Crash Sr_GameServer :(

11/27/2018 10:28 cristianxi#8

Quote:

Originally Posted by gmroske

Crash Sr_GameServer :(

Crash because on :
3 Step Add This Is Line To SRO_VT_SHARD/_RefDropItemAssign
this must be ur Item ID from _RefObjCommon
1 URITEMID 50 100 -1 1
GL ;)

12/02/2018 07:51 gmroske#9

Quote:

Originally Posted by cristianxi

Crash because on :
3 Step Add This Is Line To SRO_VT_SHARD/_RefDropItemAssign
this must be ur Item ID from _RefObjCommon
1 URITEMID 50 100 -1 1
GL ;)

yes Bro i Do this and agian Sr_GameServer Crash :(

03/25/2019 12:02 Dev.L0RdReVaN#10

Quote:

Originally Posted by gmroske

yes Bro i Do this and agian Sr_GameServer Crash :(

yes same problem

look like , we have to activate D13 in GS
look like GS not support D13 Drop