Smallerko MYKO DATABASE Oyuna Giriş Sorunu

ALTER PROCEDURE [dbo].[baslangicitem]

@account varchar(21)

AS

begin



declare   [MENTION=2874]class[/MENTION] smallint



select   [MENTION=2874]class[/MENTION] = cast(substring(cast(class as varchar(3)),2,2) as smallint) from userdata where struserid=@account



if   [MENTION=2874]class[/MENTION]=1 or   [MENTION=2874]class[/MENTION]=5 or   [MENTION=2874]class[/MENTION]=6

set   [MENTION=2874]class[/MENTION] = 1



if   [MENTION=2874]class[/MENTION]=2 or   [MENTION=2874]class[/MENTION]=7 or   [MENTION=2874]class[/MENTION]=8

set   [MENTION=2874]class[/MENTION] = 2



if   [MENTION=2874]class[/MENTION]=3 or   [MENTION=2874]class[/MENTION]=9 or   [MENTION=2874]class[/MENTION]=10

set   [MENTION=2874]class[/MENTION] = 3



if   [MENTION=2874]class[/MENTION]=4 or   [MENTION=2874]class[/MENTION]=11 or   [MENTION=2874]class[/MENTION]=12

set   [MENTION=2874]class[/MENTION] = 4



update userdata set  stritem = (select stritem from baslangic where class   [MENTION=2874]class[/MENTION]) where struserid=@account



end