Kod:
DROP TALBE baslangic GO CREATE TABLE [dbo].[baslangic] ( [class] [smallint] NULL , [stritem] [varchar](400) NULL , ) ON [PRIMARY] GO

Kod:
DROP PROCEDURE baslangicitem GO CREATE PROCEDURE [dbo].[baslangicitem] @account varchar(21) AS --Modifiye : AKI begin declare @class smallint select @class = cast(substring(cast(class as varchar(3)),2,2) as varchar(2)) from userdata where struserid=@account if @class=1 or @class=5 or @class=6 set @class = 1 --War if @class=2 or @class=7 or @class=8 set @class = 2 -- Rog if @class=3 or @class=9 or @class=10 set @class = 3 --Mag if @class=4 or @class=11 or @class=12 set @class = 4 -- Pri update userdata set stritem = (select stritem from baslangic where class=@class) where struserid=@account end

Kod:
IF @@ERROR <> 0 BEGIN     ROLLBACK TRAN SET @nRet = 4 RETURN END COMMIT TRAN SET @nRet = 0

Kod:
exec baslangicitem @CharID

Kod:
İNVENTORY EDİTOR İLE BİR WARRİOR KARAKTERE BAŞLANGIÇ İTEMLERİ EKLEYİP ÇIKIN.

KARAKTER ADI : Warrior

VE DAHA SONRA ALTTAKİ KODU QA DA UYGULAYIN

Kod:
update baslangic set stritem = ( select stritem from USERDATA where struserid = 'Warrior' ) where class = '1'

Rogue ;
Kod:
update baslangic set stritem = ( select stritem from USERDATA where struserid = 'ROGUE' ) where class = '2'

Mage ;
Kod:
update baslangic set stritem = ( select stritem from USERDATA where struserid = 'Mage' ) where class = '3'

Priest ;
Kod:
update baslangic set stritem = ( select stritem from USERDATA where struserid = 'Priest' ) where class = '4'