[Egzotik Forum Farkıyla!] Otomatik Irk Vermek!..

if @nRet = 0
begin

-- Code By Ganks - Ko-Cuce.Com
declare @k int , @h int
select @k = count(strAccountID) from KO_S1.dbo.ACCOUNT_CHAR where bNation = 1
select @h = count(strAccountID) from KO_S1.dbo.ACCOUNT_CHAR where bNation = 2

if @k < @h --eğer karuslar daha az ise;
begin
insert into KO_S1.dbo.ACCOUNT_CHAR (strAccountID, bNation, bCharNum) values (@AccountID, @k, 0)
end

if @h < @k --eğer humanlar daha az ise;
begin
insert into KO_S1.dbo.ACCOUNT_CHAR (strAccountID, bNation, bCharNum) values (@AccountID, @h, 0)
end


if @h = @k
begin
insert into KO_S1.dbo.ACCOUNT_CHAR (strAccountID, bNation, bCharNum) values (@AccountID, @h, 0)
end

INSERT INTO WAREHOUSE ( strAccountID ) VALUES (@AccountID)