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

 

[shukamu]

Re: [TUT] Remove Euro Items

love u ty very much!

 

[ahmed_ahmed9889]

Re: [TUT] Remove Euro Items

and remove char 2?

 

[vantuto]

Re: [TUT] Remove Euro Items

why dont remove all DB lol

 

[myShinichi]

Re: [TUT] Remove Euro Items

How about euro items in shops ?

 

[Marvel]

wtf, why remove Add some euro items plezzzzzzz

 

[loveme]

thank you

 

[xxNukertube]

and to reverte situaction ?

 

[denise456]

thank u

 

[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 ?

 

[Blacksheep25]

and disable mods party ?

offtopic... but you cannot remove the party mobs unless you edit the server exe files. and noone has been able to do this yet.