MR D.B
20-05-2015, 12:41 AM
http://im62.gulfup.com/l1GddT.gif
للناس الى عاوز تعمل سيرفر Chiness بس
نبتدى
http://im62.gulfup.com/X8cNWi.jpg
Query
عشان تمسح item الاروبى من الجيم
USE [SRO_VT_SHARD_INIT] By MRD.B
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
http://im62.gulfup.com/b2rYYq.jpg
query
عشان تقفل الاميل الاروبى من الجيم
USE [SRO_VT_SHARD] By MRD.B
UPDATE _RefObjCommon SET Service = '0' WHERE ID >= 14875 and ID <= 14900
UPDATE _RefCharGen SET Service = '0' WHERE RefObjID >= 14875 and RefObjID <= 14900
http://im62.gulfup.com/X8cNWi.jpg
ودلوقتى هتحمل الملف ده و تعملو import فى Data بتاعت Client
http://files.fm/u/twpugat
بسورد فك الضغط MrD.B
http://im62.gulfup.com/X8cNWi.jpg
http://im62.gulfup.com/b2rYYq.jpg
http://im62.gulfup.com/KOZGo7.jpg
http://im62.gulfup.com/KOZGo7.jpg
http://im62.gulfup.com/VBo2c5.jpg
للناس الى عاوز تعمل سيرفر Chiness بس
نبتدى
http://im62.gulfup.com/X8cNWi.jpg
Query
عشان تمسح item الاروبى من الجيم
USE [SRO_VT_SHARD_INIT] By MRD.B
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
http://im62.gulfup.com/b2rYYq.jpg
query
عشان تقفل الاميل الاروبى من الجيم
USE [SRO_VT_SHARD] By MRD.B
UPDATE _RefObjCommon SET Service = '0' WHERE ID >= 14875 and ID <= 14900
UPDATE _RefCharGen SET Service = '0' WHERE RefObjID >= 14875 and RefObjID <= 14900
http://im62.gulfup.com/X8cNWi.jpg
ودلوقتى هتحمل الملف ده و تعملو import فى Data بتاعت Client
http://files.fm/u/twpugat
بسورد فك الضغط MrD.B
http://im62.gulfup.com/X8cNWi.jpg
http://im62.gulfup.com/b2rYYq.jpg
http://im62.gulfup.com/KOZGo7.jpg
http://im62.gulfup.com/KOZGo7.jpg
http://im62.gulfup.com/VBo2c5.jpg