زاى اخفي الحصان الأوروبي اللي الناس بتستخدمو عشان تعمل شخصيات من الكلينت

السلام عليكم

زاى اخفي الحصان الأوروبي اللي الناس بتستخدمو عشان تعمل شخصيات من الكلينت
 
close europe character
SQL:
[CODE=sql]USE [SRO_VT_SHARD]
GO
-- close europe character
UPDATE _RefObjCommon SET Service = '0' WHERE ID >= 14875 and ID <= 14900
UPDATE _RefCharGen SET Service = '0' WHERE RefObjID >= 14875 and RefObjID <= 14900



--remove drop eu



SQL:
USE [SRO_VT_SHARD]
GO
--remove drop eu
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
كود:
 

المرفقات

التعديل الأخير:
عودة
أعلى