الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   سوال وبج (https://silkroad4arab.com/vb/showthread.php?t=542977)

Last_Fiddler 27-12-2013 05:22 PM
سوال وبج
 
السلام عليكم
انا عندى بج فى اسكل
http://www.m5zn.com/newuploads/2013/...e39182a036.jpg
عيز امسحه خالص
وكمان انا كونت عيز اعرف امسح ازاى 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 من الداتا بس عيز اشيله من الجيم نفسها الميديا يعنى
وحكاية السكل انا هحاول فيها وربنا يسهلها وان شاء الله انا الى هحلها


الساعة الآن 05:08 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.