مشاهدة النسخة كاملة : سوال وبج
Last_Fiddler
27-12-2013, 05:22 PM
السلام عليكم
انا عندى بج فى اسكل
http://www.m5zn.com/newuploads/2013/12/27/jpg//m5zn_60320e39182a036.jpg (http://www.m5zn.com/out.php?code=15121853)
عيز امسحه خالص
وكمان انا كونت عيز اعرف امسح ازاى npc مهمات
وكمان انا كونت عيز اعرف ازاى ازود نسبة الجولد بتاع التريدر
انا كونت عيز اعرف كمان
الكتب بتاع العالم المنسى عندى بتديك لما تيجى تسلمها دجرى 14 عيز اخليها تدينى دجرى 11
وكمان كنت عيز اعرف ازاى اخلى اسلحة دجرى 14 اخليها شكلها بالافيكت بتعها دجرى 11
ممكن مسعده بس بسرعه
che_9299
27-12-2013, 08:57 PM
2- تمسح NPC
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'NPC_Name'
USE [SRO_VT_SHARD]
SELECT [dwTacticsID] FROM [dbo].[Tab_RefTactics] WHERE (dwObjID LIKE 'ID')
USE [SRO_VT_SHARD]
SELECT [dwNestID] FROM [dbo].[Tab_RefNest] WHERE (dwTacticsID LIKE 'ID')
هتجيب NPC NAme من TExtdata_Object الكود اللى قدام الاسم
ولما التستخدمو اخر كويرى روح على RefNest وامسح السطر بتاعو
3- تزو جولد التردا
use [SRO_VT_SHARD]
DECLARE @NewQuot FLOAT
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999 -- Goods Price @ the Shop
SET @NewStack = 9999 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999 -- Goods Price if you sell them directly again - without trading.
-- Profit %
UPDATE [dbo].[_ItemQuotation]
SET ****Quot = ****Quot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET ****Quot = ****Quot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET ****Quot = ****Quot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
-- Price / SellPrice
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672
-- MaxStack
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160
-- Price
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCode**** like '%ITEM_ETC_TRADE%'
Last_Fiddler
28-12-2013, 12:49 AM
السلام عليكم شكرا للرد عليه انا هجرب بتاع التاجر
وى على الكورى عملته ادنى خطء
Msg 102, Level 15, State 1, Line 15
Incorrect syntax near '*'.
Msg 102, Level 15, State 1, Line 27
Incorrect syntax near '*'.
Msg 102, Level 15, State 1, Line 39
Incorrect syntax near '*'.
Msg 102, Level 15, State 1, Line 94
Incorrect syntax near '*'.
وممكن تعرفنى ازاى اضع سعر مثلا الشراء انهون ولما يجى يبعها بكام مثلان
وممكن السكى بى بتاعك ضرورى
انا بتاعى badr.mohamed15
che_9299
28-12-2013, 01:00 AM
طب استخدم ده
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefObjCommon
SET Price = 3830
WHERE Price = 383
UPDATE dbo._RefObjCommon
SET SellPrice = 1910
WHERE SellPrice = 191
UPDATE dbo._RefPricePolicyOfItem
SET Cost = 114900
WHERE Cost = 16024
che_9299
28-12-2013, 01:00 AM
بالنسبه للسكيل صعبه شويه علشان تمسحو
Last_Fiddler
28-12-2013, 01:04 AM
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
بس مش تفهمنى ايه فيدة الكورى ده ولو للترادا تعرفنى اعمل السعر الى انا عيزه ازاى
che_9299
28-12-2013, 01:15 AM
SET @NewPrice = 9999 -- Goods Price @ the Shop
SET @NewSellPrice = 999 -- Goods Price if you sell them directly again - without trading.
دول سعرها من ال SHOP
والتانيه سعر الشراء
حضرتك اشتغل على الكويرى الاول طب مشكلة الايرورات دى هنحلها ازاى روح كده على RefObjCommon
RefPriceOfPolicyItem
RefObjItem
وتعمل على كل واحد Desgin
على ID
وتخلىis Identity خليها yes لو No
وجرب وقولى
Last_Fiddler
28-12-2013, 01:29 AM
عملت زى ما بتقول بس فى اخطاء فى الى معلمهم بالاحمر
use [SRO_VT_SHARD]
DECLARE @NewQuot FLOAT
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999 -- Goods Price @ the Shop
SET @NewStack = 9999 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999 -- Goods Price if you sell them directly again - without trading.
-- Profit %
UPDATE [dbo].[_ItemQuotation]
SET ****Quot = ****Quot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET ****Quot = ****Quot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET ****Quot = ****Quot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
-- Price / SellPrice
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672
-- MaxStack
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160
-- Price
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCode**** like '%ITEM_ETC_TRADE%'
معلشى تعبك معيه
وكمان هوه مش ااضر اشيل التاجر من الميديا بس وله لازم من الداتا وكفيه مش لازم ميديا كمان ؟
Last_Fiddler
28-12-2013, 11:01 PM
السلام عليكم شباب
ايه مفيش حد يقضر يسعيدنى فى حكاية انى امسح السكل الى بيجبلى بج يا جماعه ؟
انا منتضر حد يعرف يحلهالى
والكورى بتاع التريدر غلط وانا اخزته عدلت عليه الصح اتفضلو اهوت
use [SRO_VT_SHARD]
DECLARE @NewQuot FLOAT
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999 -- Goods Price @ the Shop
SET @NewStack = 9999 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999 -- Goods Price if you sell them directly again - without trading.
-- Profit %
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
-- Price / SellPrice
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672
-- MaxStack
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160
-- Price
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCodeName LIKE '%ITEM_ETC_TRADE%'
ياريت حد يشوف الى انا طلبه بس بسرعه
che_9299
28-12-2013, 11:23 PM
اعمل ال service بتاع ال NPC اللى انت عازيو 0 فى RefObjCommon
che_9299
28-12-2013, 11:23 PM
السكيل صعب متوجعش دماغك
Last_Fiddler
29-12-2013, 10:19 PM
السلام عليكم
شكراا لردودك
وكمان انا قافل NPC من الداتا بس عيز اشيله من الجيم نفسها الميديا يعنى
وحكاية السكل انا هحاول فيها وربنا يسهلها وان شاء الله انا الى هحلها
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc