komnda |
29-08-2013 06:46 PM |
1-
اعمل زى ما قلك او اعمل npc
جديد وريح بالك
http://www.silkroad4arab.com/vb/showthread.php?t=514213
2-
فى drop all
disable/enable drop "items" by Codename :
كود PHP:
update _RefDropItemAssign SET Service = 0 from _RefDropItemAssign p inner join _RefObjCommon a on a.ID = p.RefItemID where a.CodeName128 like '%_11_%' and p.Service = 1
(To Enable Set Service to 1 instead of 0, to change the items edit the "'%_11_%'" for anything else you want , '%_11_%' = all 11D Items! .)
____
Remove Euro Items
كود PHP:
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
_____
Delete Drop From Unique or Mobs
كود PHP:
USE SRO_VT_SHARD GO DELETE _RefDropItemAssign FROM _RefDropItemAssign Drops LEFT JOIN _RefObjCommon Objects ON (Drops.RefItemID = Objects.ID) WHERE CodeName128 like 'ITEMCODENAMEHERE'
|