الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**Last_Fiddler** · 27-12-2013, 05:22 PM

السلام عليكم
انا عندى بج فى اسكل

عيز امسحه خالص
وكمان انا كونت عيز اعرف امسح ازاى 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

السلام عليكم شباب
ايه مفيش حد يقضر يسعيدنى فى حكاية انى امسح السكل الى بيجبلى بج يا جماعه ؟
انا منتضر حد يعرف يحلهالى
والكورى بتاع التريدر غلط وانا اخزته عدلت عليه الصح اتفضلو اهوت

كود بلغة HTML:

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 من الداتا بس عيز اشيله من الجيم نفسها الميديا يعنى
وحكاية السكل انا هحاول فيها وربنا يسهلها وان شاء الله انا الى هحلها

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
سؤال و جواب - لو لك أي سؤال في الدين إتفضل وضعه هنا	°•.♥ H3ll King ♥.•°	بـعـيـدآ عـن سـيـلـك رود	25	25-01-2012 02:31 PM
22 سؤال من قسيس امام سؤال واحد فقط من مسلم	omar007	بـعـيـدآ عـن سـيـلـك رود	15	08-10-2008 09:58 AM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	تسجيل الدخول دائمآ