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

Dishaa

Dishaa

السلام عليكم

زاى اخفي الحصان الأوروبي اللي الناس بتستخدمو عشان تعمل شخصيات من الكلينت​
 
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
كود:
 

المرفقات

التعديل الأخير:
يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.
عودة
أعلى