نسبة البلص [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

مشاهدة النسخة كاملة : نسبة البلص

mahmoudtarek5

21-03-2015, 04:57 PM

حضرتكو انا عاوز اخلى نسبى البلص +12 وا انتو عطيطونى كويرى دلوقتى انا عملتها +10 علشان يبقى با الادفنس +12 دلوقتى دا بيعمل +12 من غير ادفنس عادى وا انا كتبو +10 يعنى بيعدى الى انا كاتبو وا كمان مش بيعمل فيلد من 1 الى 10 دا اية بقى

Mr Z!dane

21-03-2015, 06:29 PM

اتفضل هتغير اللي عندك بي دي
IF (@Operation = 90 AND @strDesc like '%Opt: +11%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 10 WHERE Serial64 = @ItemSerial
END

mahmoudtarek5

21-03-2015, 06:55 PM

دا احط فى انهى حتا فى الداتا

Hamza FiGo

21-03-2015, 10:41 PM

_AddLogItem Procedure in LOG DB

mahmoudtarek5

22-03-2015, 01:24 AM

يالهوى دا يبطلع لحد +12 بردو مافيش فيلد ولا مرة

Hamza FiGo

22-03-2015, 01:33 AM

ظبط الرات ياباشا الاول من refObjItem

mahmoudtarek5

22-03-2015, 01:44 AM

المفروض بياخد 1لكى عند البلص 5 لا دا بياخود لكى عند البلص 9 ا 10

mahmoudtarek5

22-03-2015, 02:17 AM

طيب انهى حتة فى الريف ابجيكت

mahmoudtarek5

22-03-2015, 02:26 AM

عندى كدا
11469100200100000000000000000000000000000000000000 0000000000000000001MATTR_LUCK0? 0, 0, 0, 0 0? 0, 0, 0, 0100xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx000

mahmoudtarek5

22-03-2015, 02:27 AM

طيب اعرف الاى دى ازاى ولا اعمل اية وا مافيش كويرى يعمل كول دا

Hamza FiGo

22-03-2015, 10:38 AM

المفروض بياخد 1لكى عند البلص 5 لا دا بياخود لكى عند البلص 9 ا 10

كدة معناه ان الرات معمول غلط . يعني معمول من +1 لــ +8 = 100%

فية موضوع ياباشا في قسم الشروحات خاص بنسبة البلاص

مشروح فية كل حاجة

رافعلك برنامج في المرفقات ظبط الرات اللي انت عايزة وخد منة الرات حطة في الكيوري دا

USE [SRO_VT_SHARD]
----------------------------Made By [Dev]LegendKnight----------------------------
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= @D15
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
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D15x2

mahmoudtarek5

22-03-2015, 03:28 PM

تمام هوا البرنامج اسمو AlchemyRate انا فتحتو وا لقيت 1+ وا 2+ وا جنبوهو0 اكتب اية فى ال0 دا مش فاهم

Hamza FiGo

22-03-2015, 03:35 PM

http://s26.postimg.org/4uabjoq3d/image.jpg

100-90-80 دول نسب البلاص اللي انت عايزة

هتاخد بقا الارقام اللي نزلت تحت دي وتحطها في الكيوري بدل اللي موجودة

Mr.R3B

22-03-2015, 03:37 PM

والنعمه انتا برنس يا حمزة

mahmoudtarek5

22-03-2015, 03:47 PM

USE [SRO_VT_SHARD]
UPDATE _RefObjItem SET Param2 = 1684300900, Param3 = 1346122280, Param4 = 504629765 WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%PROB_UP_A%') جالى دول

mahmoudtarek5

22-03-2015, 04:15 PM

جالى كدة

Msg 155, Level 15, State 2, Line 3
'Legend' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Line 4
'Legend' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Line 5
'Legend' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Line 6
'Legend' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Line 7
'Legend' is not a recognized CURSOR option.
Msg 155, Level 15, State 2, Line 8
'Legend' is not a recognized CURSOR option.
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near 'Legend'.
Msg 102, Level 15, State 1, Line 18
Incorrect syntax near 'Legend'.
Msg 102, Level 15, State 1, Line 19
Incorrect syntax near 'Legend'.
Msg 102, Level 15, State 1, Line 20
Incorrect syntax near 'Legend'.
Msg 102, Level 15, State 1, Line 21
Incorrect syntax near 'Legend'.
Msg 102, Level 15, State 1, Line 22
Incorrect syntax near 'Legend'.

mahmoudtarek5

22-03-2015, 04:18 PM

دا ليها حل near 'Legend'.

mahmoudtarek5

22-03-2015, 04:51 PM

20335020010000000000000000000000000000000000000000 00000000000000001??16843009001,2,3,4 13461222805,6,7,85046297659,10,11,12-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx-1xxx000

mahmoudtarek5

22-03-2015, 05:09 PM

http://postimg.org/image/ouitv1p2l/

Hamza FiGo

22-03-2015, 06:43 PM

اية اللي انت عاملة دا يا باشا؟

انا بقول حد الرات الجديد في الكيوري اللي انا مديهولك وخدة الكيوري كلة حطة عندك

mahmoudtarek5

22-03-2015, 07:48 PM

Mr Z!dane

22-03-2015, 11:32 PM

هات النسبة اللي حضرتك عايزها و انا هعملهالك

mahmoudtarek5

23-03-2015, 05:14 PM

1684300900

336860180

336202245

Hamza FiGo

24-03-2015, 06:01 PM

مع تغيير اسم الداتا بيز بتاعتك اتفضل

USE [SRO_VT_SHARD]
----------------------------Made By [Dev]LegendKnight----------------------------
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='336860180',Param4='336 202245' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='336860180',Param4='336 202245' where ID= @D15x2

mahmoudtarek5

24-03-2015, 06:56 PM

طيب لو عاوز ازود نسبة الدروب النوفا وا نسبة السن وا كلول النوفا اعمل اية

Hamza FiGo

24-03-2015, 11:35 PM

من server.cfg

لو سمحت ركز في مشكلتك بتاع الموضوع لو اتحلت قول اتحلت واعمل موضوع جديد بمشكلة جديدة

mahmoudtarek5

25-03-2015, 05:11 PM

مهو حضرتك كلو نسب انا مزود النسب من ال Server بس بيقولولى من لزم تتزود النسبة من الداتا

Hamza FiGo

25-03-2015, 09:57 PM

لا ياباشا في Server.cfg بس

يغلق

##