![]() |
|
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
![]() |
|
أدوات الموضوع | انواع عرض الموضوع |
![]() |
#1 | ||||||||||||
![]() ![]()
|
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%' بس لما حد بتقع منه و يلمها تانى و يجى يبعا بتتباع ب 900M !! |
||||||||||||
|
![]() |
#2 | ||||||||||||
![]() ![]()
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
|
||||||||||||
|
![]() |
#3 | ||||||||||||
![]() ![]()
|
أزاى أظبتو يعمل Backup كل 6 سعات مثلا ؟؟ ![]() |
||||||||||||
|
![]() |
#4 | ||||||||||||
![]() ![]()
|
كود:
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 |
||||||||||||
|
![]() |
#5 | ||||||||||||
![]() ![]()
|
طب بلنسبة للــ Trader !! |
||||||||||||
|
![]() |
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|