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

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   ازاى اقدر اغير سعر حاجه فى الـ NPC و ازاى ازود نسبه نجاح البلص (https://silkroad4arab.com/vb/showthread.php?t=576766)

karimeg 21-01-2015 01:40 AM

ازاى اقدر اغير سعر حاجه فى الـ NPC و ازاى ازود نسبه نجاح البلص
 
عايز اعرف ازاى اقدر اغير اسعار حاجات فى الـ NPC ؟ و ازاى ازود نسبه نجاح البلس ؟

FS50 21-01-2015 03:07 AM

تغير الاسعار من التابل ده RefPricePolicy
في الداتا و المديا
:kiss2:

karimeg 21-01-2015 06:51 PM

ازاى ازود نسبه نجاح البلص ؟

elbattawy1st 21-01-2015 07:16 PM

انت ال database degree كام

karimeg 21-01-2015 08:29 PM

14dg

elbattawy1st 21-01-2015 08:53 PM

استخدم ال query دا
كود:

USE [SRO_VT_SHARD]

DECLARE @LEGENDKNIGHT1 VARCHAR (129)
DECLARE @LEGENDKNIGHT2 VARCHAR (129)
DECLARE @LEGENDKNIGHT3 VARCHAR (129)
DECLARE @LEGENDKNIGHT4 VARCHAR (129)
DECLARE @LEGENDKNIGHT5 VARCHAR (129)
DECLARE @LEGENDKNIGHT6 VARCHAR (129)

SET @LEGENDKNIGHT1 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_13'
SET @LEGENDKNIGHT2 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_14'
SET @LEGENDKNIGHT3 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_15'
SET @LEGENDKNIGHT4 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_13'
SET @LEGENDKNIGHT5 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'
SET @LEGENDKNIGHT6 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_15'

Declare @D15x2 int SET @D15x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT6)
Declare @D13 int SET @D13 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT1)
Declare @D14 int SET @D14 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT2)
Declare @D15 int SET @D15 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT3)
Declare @D13x2 int SET @D13x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT4)
Declare @D14x2 int SET @D14x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT5)

UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D14x2

param2 و param3 و param 4 دا هو نسبة نجاح ال plus وعلشان تعرف النسة استخدم البرنامج دا
https://www.mediafire.com/?ztijz5qzl9m1413


الساعة الآن 07:30 AM.

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