عايز طلبين علي السريع Query

[PowerBalance]

اول طلب عايز الـ Query بتاع تغير الـ Title

اللي هو احط فيه اسم الاكونت و تحتيه رقم الـ title و بس كده
--------

تاني طلب عايز حد يديني Query يبقي مظبوط بالـ alchemy rate ده

+1,+2 100%
+3 90%
+4 80%
+5 70%
+6 50%
+7 35%
+8 20%

بعد كده 5% ياربيت محدش يديني حاجه غلط في ال ++ :S

و شكرا ^_^

[Islam.Chalabi]

1 :


USE SRO_VT_SHARD/--_INIT

Declare @CharNick varchar(64)
Declare @Hwanlvl tinyint

SET @CharNick = '' --Your Ingame Nick
SET @Hwanlvl = '' --Your desired Hwan Title e.g. '6'

/* Hwan Title Explanation:
CH '1' Captain
CH '2' General
CH '3' Senior General
CH '4' Chief General
CH '5' Vice General Lord
CH '6' General Lord
EU '1' Knight
EU '2' Baronet
EU '3' Baron
EU '4' Count
EU '5' Marquis
EU '6' Duke */

UPDATE dbo._Char
SET HwanLevel = @Hwanlvl
WHERE CharName16 like @CharNick



2 :


مـــوضــوع خــاص بــنــسبة نــجاح الــ Alchemy (http://www.silkroad4arab.com/vb/showthread.php?t=499060)

[Mr Z!dane]

اتفضل

USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684298320',Param3='1177690900',Param4='84 215045' where ID='2044'

##