Remove Euro Items

[Hean]

Well finally, I made it. For all the oldschool freaks =)

Here is the query:

USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 10897 AND 11416


UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 10897 AND 11416



UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 10897 AND 11416

[MentaL]

[shukamu]

love u ty very much!

[ahmed_ahmed9889]

and remove char 2?

[vantuto]

why dont remove all DB lol

[myShinichi]

How about euro items in shops ?

[Marvel]

wtf, why remove :D Add some euro items plezzzzzzz

[loveme]

thank you

[xxNukertube]

and to reverte situaction ?

[denise456]

thank u :D

[arracho]

Thank you very much for this, it really helped me.

[Jesus Enrique]

bro and if put Server = 0 and not dropcount, prob_relative , probaboslute ?

[blapanda]

Hm.
Isn't it already that easy disabling the service of EU declared items? teleport links and data? Mobs located to that areas? Same for the declared drops? Commenting out procedures related to EU operations and functions?

Oh well, I assume, most of the people here just don't even know how to modify stuff inside the SQL instance.

[B1QB0SS]

Update _RefObjCommon Set Service = '1' Where Codename128 like '%ITEM_EU%'

i think that's faster :3

[Johnny Nguyen]

Use this query make game server C++ runtime error

[watamela1]

and disable mods party ?