طلب لبرنامج و كويرى

[androman2010]

1- عايز برنامج ألى بيعمل Auto BackUp كل وقت معين



2- انا استعملت الكويرى ده

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

و خليت الــ Trader تجيب 11B
بس لما حد بتقع منه و يلمها تانى و يجى يبعا بتتباع ب 900M !!

[-[Cyril]-]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

[androman2010]

أزاى أظبتو يعمل Backup كل 6 سعات مثلا ؟؟

[che_9299]

USE SRO_VT_SHARDLOG;
GO
BACKUP DATABASE SRO_VT_SHARDLOG
TO DISK = 'C:\EMAD\SRO_VT_SHARDLOG.Bak'
   WITH FORMAT,
      MEDIANAME = 'SRO_VT_SHARDLOG',
      NAME = 'Full Backup of SRO_VT_SHARDLOG';
GO

وده كويرى بردو تقدر تعمل بيه باك اب
مع تغيير الاسماء
SRO_VT_ACCOUNT
SRO_VT_SHARD
SRO_VT_SHARDLOG

[androman2010]

طب بلنسبة للــ Trader
!!