no Taplat Drop in mobs 111-120 Only drop stone why !!!
Printable View
no Taplat Drop in mobs 111-120 Only drop stone why !!!
Use This..
Likeme. :8:Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Alchemy_Tablet]
SET [ProbGroup12] = '1'
WHERE MonLevel BETWEEN 111 AND 120
i try it
dont work
Well when u said "Taplat" Is tablets for make Stones?Quote:
Originally Posted by adminsxza
And if u need change the name of "SRO_VT_SHARD" for your DB. Or addme on Skipe: man.za1
mobs 111-120 only Drop Stone no gold no item etc i need help pless
1º
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Alchemy_ATTRStone]
SET [ProbGroup12] = '1'
WHERE MonLevel BETWEEN 111 AND 120
2º
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Alchemy_MagicStone]
SET [ProbGroup12] = '1'
WHERE MonLevel BETWEEN 111 AND 120
3º
4ºQuote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Ammo]
SET [ProbGroup1] = 1
,[ProbGroup2] = 1
,[ProbGroup3] = 1
,[ProbGroup4] = 1
,[ProbGroup5] = 1
,[ProbGroup6] = 1
WHERE MonLevel BETWEEN 111 AND 120
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Cure]
SET [ProbGroup5] = 1
WHERE MonLevel BETWEEN 111 AND 120
5º
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Equip]
SET [ProbGroup34] = 1
WHERE MonLevel BETWEEN 111 AND 113
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Equip]
SET [ProbGroup35] = 1
WHERE MonLevel BETWEEN 114 AND 117
6ºQuote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Equip]
SET [ProbGroup36] = 1
WHERE MonLevel BETWEEN 118 AND 120
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_RareEquip]
SET [ProbGroup34] = 1
WHERE MonLevel BETWEEN 111 AND 113
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_RareEquip]
SET [ProbGroup35] = 1
WHERE MonLevel BETWEEN 114 AND 117
7ºQuote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_RareEquip]
SET [ProbGroup36] = 1
WHERE MonLevel BETWEEN 118 AND 120
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Recover]
SET [ProbGroup5] = 1
,[ProbGroup6] = 1
,[ProbGroup7] = 1
WHERE MonLevel BETWEEN 111 AND 120
8º
9ºQuote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Reinforce]
SET [ProbGroup2] = 1
WHERE MonLevel BETWEEN 111 AND 120
10ºQuote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropClassSel_Scroll]
SET [ProbGroup1] = 1
,[ProbGroup2] = 1
,[ProbGroup3] = 1
WHERE MonLevel BETWEEN 111 AND 120
Quote:
UPDATE [SRO_VT_SHARD].[dbo].[_RefDropGold]
SET [DropProb] = '1'
,[GoldMin] = '413'
,[GoldMax] = '867'
WHERE MonLevel BETWEEN 111 AND 120
Change the values manually if you want for what u want.. Following theese Tables. Work 100%
Credits to Me.!!
11º
Quote:
Giveme a fcking Like. -.-
This service to Tablet is 0
i hope it work
Sure work 100% if no see changes is okay only active the tablests in _RefObjCommon. Service » 1
thx but now no Taplat D12 Drop and item is too low Drop from mobs 111-120
Where is my like? :sneaky2:Quote:
Originally Posted by adminsxza
And u can change the number manually in scale of % 1-100 in db. ¬¬
thx so much for ue help
but wahre i can change the number manually in scale of % 1-100 in db
Follow the tables.. and giveme a like.. i work much in this answer for u.. ¬¬
Taplat D12 stll no drop from mobs 111-120
Fuck "Like"
I Dont Need Like
any help ???
Help in? I think that the tread is solved.Quote:
Originally Posted by adminsxza
Sec i will help you
Use This Query
Give me like if this help youCode:USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefDropItemAssign
SET Service = 1
WHERE RefItemID BETWEEN 6679 AND 5414
UPDATE dbo._RefDropItemAssign
SET Service = 1
WHERE RefItemID BETWEEN 6082 AND 6371
UPDATE dbo._RefDropItemAssign
SET Service = 1
WHERE RefItemID BETWEEN 10501 AND 10527
UPDATE dbo._RefDropItemAssign
SET Service = 1
WHERE RefItemID BETWEEN 11499 AND 11668
UPDATE dbo._RefDropItemAssign
SET Service = 1
WHERE RefItemID BETWEEN 12554 AND 12569