يا جماعة المشرفيين فين دية المرة الالف اعمل فيها نفس الموضوع و مفيش حل
انا عندي ال Trade لو اشتريت بضاعة و سافرت بيها من jangan to alex or any place ببيعها بنفس التمن كأني معملتش حاجة و جربت اغير الاسعار من المديا و الداتا في كل حاجة itemdata_5000 and ref obj common and refpriceofitem in data and media
طيب كدة المشكلة منين بقا
و جربت الكيوري ده عشان يغير ال Rates و بردوا ولا اي حاجة
كود PHP:
DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 2.0 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
-- 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
ساعدوني بالله عليكوا
يا رب يسعدوني
كمان في رسالة لاخظت انها بتيجي اول لما ابيع ال Trade