المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : مشكله فل trade

ahmedbadrbedo
11-02-2017, 10:42 PM
انا عدلت عل trade بل query da

DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD
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%'

ولما اعمل trade ميش بيجيب gold وعامل الSET @NewQuot = 50.1
حل ؟
ahmedbadrbedo
11-02-2017, 10:49 PM
:111 (21):
Hamza FiGo
12-02-2017, 12:07 AM
مش بيجيب جولد بمعني اية ؟

التريد لية حلول كتير .. اقله غير اسعار الايتمات وخلاص اريحلك بدل اللعب بالكيرويهات
ahmedbadrbedo
12-02-2017, 11:18 AM
مش بيجيب جولد بمعني اية ؟

التريد لية حلول كتير .. اقله غير اسعار الايتمات وخلاص اريحلك بدل اللعب بالكيرويهات

منا عايز التريد :toobad:
Dev.Klito
12-02-2017, 12:24 PM
انت عامل السعر لما يبيعه من غير trade كام ؟؟
MasterioPayBack
12-02-2017, 01:34 PM
انا كانت تجيلي المشكله دي لما استخدم الكويري ده كتير
وولا حد عرف يساعدني فكان الحل هوا Restore DB
ahmedbadrbedo
12-02-2017, 02:28 PM
انت عامل السعر لما يبيعه من غير trade كام ؟؟

انا عايزها تجيب
18b
Mahmoud Rashwan
12-02-2017, 02:31 PM
استخدمـ ده USE [SRO_VT_SHARD]
GO

UPDATE dbo._RefObjCommon
SET Price = 383*20
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 191*20
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*20
WHERE Cost = 383
هتغير على الرقمـ 20 للسعر اللى انت عايزو ملحوظه التغير يعنى انك بتدرب فى الرقمـ ده مثل 40=1480000جولد
Dev.Klito
13-02-2017, 07:30 PM
انا عايزها تجيب
18b

استخدم دى كدا انا معدل عليها

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%'

النظام بتعها هو
هيشتريها بكام من SET @NewPrice = 9999

و لما يبعها من غير ميعمل trade من SET @NewSellPrice = 999

و عدد القطع اللى بيتحط في مربع واحد من SET @NewStack = 9999 و هي في الأصل 40

النسبة لما يعمل trade و دى بتتحسب على أساس و هو اضرب السعر الى اشتراه بيها في النسبة و الناتج اقسمه على 100 يبقى دا هو اللى هيكسبه لما يعمل trade ( دا المكسب بس يعنى من غير ثمن البضاعة اللى اشتراها يعنى اللى هيعمل trade هيجيلو المكسب من العملية الحسابية اللى فاتت + ثمن البضاعة ) و النسبة من SET @NewQuot = 99.9

أتمنى ان كل حاجة تكون واضحة
Dev.Klito
15-02-2017, 10:51 AM
يغلق حسب القانون
http://www.silkroad4arab.com/vb/showthread.php?t=526846
##