- Kod:
[color=#000000][font=Courier New][color=#0000bb]CREATE PROCEDURE [/color][color=#007700][[/color][color=#0000bb]clan_human[/color][color=#007700]] @[/color][color=#0000bb]IDName char[/color][color=#007700]([/color][color=#0000bb]21[/color][/font][font=Courier New][color=#007700]) AS
declare @[/color][color=#0000bb]IDNo smallint[/color][color=#007700],@[/color][color=#0000bb]irk tinyint[/color][color=#007700],@[/color][color=#0000bb]c1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]acc char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]acc1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]acc3 char[/color][color=#007700]([/color][color=#0000bb]21[/color][/font][font=Courier New][color=#007700])
[/color][color=#0000bb]select [/color][color=#007700]@[/color][color=#0000bb]IDNo [/color][color=#007700]= [/color][color=#0000bb]IDNum from Knights where IDName [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]IDName
select [/color][color=#007700]@[/color][color=#0000bb]irk [/color][color=#007700]= [/color][color=#0000bb]Nation From Knights where IDNUM [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]IDNo
select [/color][color=#007700]@[/color][color=#0000bb]c1 [/color][color=#007700]= [/color][color=#0000bb]strUserId from userdata where Knights [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]IDNo
select [/color][color=#007700]@[/color][color=#0000bb]acc [/color][color=#007700]= [/color][color=#0000bb]strAccountID from account_char where strCharID1 [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]c1
select [/color][color=#007700]@[/color][color=#0000bb]acc1 [/color][color=#007700]= [/color][color=#0000bb]strAccountID from account_char where strCharID2 [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]c1
select [/color][color=#007700]@[/color][color=#0000bb]acc3 [/color][color=#007700]= [/color][color=#0000bb]strAccountID from account_char where strCharID3 [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]c1
[/color][color=#007700]declare @[/color][color=#0000bb]k1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]k2 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]k3 char[/color][color=#007700]([/color][color=#0000bb]21[/color][/font][font=Courier New][color=#007700])
[/color][color=#0000bb]select [/color][color=#007700]@[/color][color=#0000bb]k1 [/color][color=#007700]= [/color][color=#0000bb]strCharID1 from account_char where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc
select [/color][color=#007700]@[/color][color=#0000bb]k2 [/color][color=#007700]= [/color][color=#0000bb]strCharID2 from account_char where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc1
select [/color][color=#007700]@[/color][color=#0000bb]k3 [/color][color=#007700]= [/color][color=#0000bb]strCharID3 from account_char where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc3
[/color][color=#007700]if @[/color][color=#0000bb]irk [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]2
begin
[/color][color=#007700]print [/color][/font][color=#dd0000][font=Courier New]'Zaten clan human'
[/font][/color][font=Courier New][color=#0000bb]end
[/color][color=#007700]if @[/color][color=#0000bb]irk [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]1
begin
update account_char set bNation[/color][color=#007700]=[/color][color=#dd0000]'2' [/color][color=#0000bb]where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc
update account_char set bNation[/color][color=#007700]=[/color][color=#dd0000]'2' [/color][color=#0000bb]where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc1
update account_char set bNation[/color][color=#007700]=[/color][color=#dd0000]'2' [/color][color=#0000bb]where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc3
update Knights set Nation[/color][color=#007700]=[/color][color=#dd0000]'2' [/color][color=#0000bb]where IDNum [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and [/color][color=#0000bb]Nation [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]1
update userdata set Nation[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],[/color][color=#0000bb]Zone[/color][color=#007700]=[/color][color=#dd0000]'21' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and [/color][color=#0000bb]Nation [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]1
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]warriorsa
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'11'[/color][color=#007700],Class=[/color][color=#dd0000]'201' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]101
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'205' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]105
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'206' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]106
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'11'[/color][color=#007700],Class=[/color][color=#dd0000]'201' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]101
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'205' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]105
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'206' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]106
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'11'[/color][color=#007700],Class=[/color][color=#dd0000]'201' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]101
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'205' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]105
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'206' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]106
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'11'[/color][color=#007700],Class=[/color][color=#dd0000]'201' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]101
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'205' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]105
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'206' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]106
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]roguesa
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'202' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]102
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'207' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]107
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'208' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]108
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'202' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]102
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'207' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]107
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'208' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]108
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'202' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]102
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'207' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]107
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'208' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]108
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'202' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]102
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'207' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]107
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'208' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]108
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]magese
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'203' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]103
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'209' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]109
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'210' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]110
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'203' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]103
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'209' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]109
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'210' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]110
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'203' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]103
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'209' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]109
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'210' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]110
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'203' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]103
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'209' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]109
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'210' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]110
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]priestse
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'204' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]104
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'211' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]111
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'212' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]112
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'204' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]104
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'211' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]111
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'212' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]112
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'204' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]104
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'211' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]111
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'212' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]112
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'204' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]104
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'211' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]111
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'212' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][color=#0000bb][font=Courier New]112
end
GO [/font]
[/color][/color]
- Kod:
[color=#000000][font=Courier New][color=#0000bb]CREATE PROCEDURE [/color][color=#007700][[/color][color=#0000bb]clan_karus[/color][color=#007700]] @[/color][color=#0000bb]IDName char[/color][color=#007700]([/color][color=#0000bb]21[/color][/font][font=Courier New][color=#007700]) AS
declare @[/color][color=#0000bb]IDNo smallint[/color][color=#007700],@[/color][color=#0000bb]irk tinyint[/color][color=#007700],@[/color][color=#0000bb]c1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]acc char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]acc1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]acc3 char[/color][color=#007700]([/color][color=#0000bb]21[/color][/font][font=Courier New][color=#007700])
[/color][color=#0000bb]select [/color][color=#007700]@[/color][color=#0000bb]IDNo [/color][color=#007700]= [/color][color=#0000bb]IDNum from Knights where IDName [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]IDName
select [/color][color=#007700]@[/color][color=#0000bb]irk [/color][color=#007700]= [/color][color=#0000bb]Nation From Knights where IDNUM [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]IDNo
select [/color][color=#007700]@[/color][color=#0000bb]c1 [/color][color=#007700]= [/color][color=#0000bb]strUserId from userdata where Knights [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]IDNo
select [/color][color=#007700]@[/color][color=#0000bb]acc [/color][color=#007700]= [/color][color=#0000bb]strAccountID from account_char where strCharID1 [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]c1
select [/color][color=#007700]@[/color][color=#0000bb]acc1 [/color][color=#007700]= [/color][color=#0000bb]strAccountID from account_char where strCharID2 [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]c1
select [/color][color=#007700]@[/color][color=#0000bb]acc3 [/color][color=#007700]= [/color][color=#0000bb]strAccountID from account_char where strCharID3 [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]c1
[/color][color=#007700]declare @[/color][color=#0000bb]k1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]k2 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),@[/color][color=#0000bb]k3 char[/color][color=#007700]([/color][color=#0000bb]21[/color][/font][font=Courier New][color=#007700])
[/color][color=#0000bb]select [/color][color=#007700]@[/color][color=#0000bb]k1 [/color][color=#007700]= [/color][color=#0000bb]strCharID1 from account_char where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc
select [/color][color=#007700]@[/color][color=#0000bb]k2 [/color][color=#007700]= [/color][color=#0000bb]strCharID2 from account_char where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc1
select [/color][color=#007700]@[/color][color=#0000bb]k3 [/color][color=#007700]= [/color][color=#0000bb]strCharID3 from account_char where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc3
[/color][color=#007700]if @[/color][color=#0000bb]irk [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]1
begin
[/color][color=#007700]print [/color][/font][color=#dd0000][font=Courier New]'Zaten clan karus'
[/font][/color][font=Courier New][color=#0000bb]end
[/color][color=#007700]if @[/color][color=#0000bb]irk [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]2
begin
update account_char set bNation[/color][color=#007700]=[/color][color=#dd0000]'1' [/color][color=#0000bb]where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc
update account_char set bNation[/color][color=#007700]=[/color][color=#dd0000]'1' [/color][color=#0000bb]where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc1
update account_char set bNation[/color][color=#007700]=[/color][color=#dd0000]'1' [/color][color=#0000bb]where strAccountID [/color][color=#007700]= @[/color][/font][font=Courier New][color=#0000bb]acc3
update Knights set Nation[/color][color=#007700]=[/color][color=#dd0000]'1' [/color][color=#0000bb]where IDNum [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and [/color][color=#0000bb]Nation [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]2
update userdata set Nation[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],[/color][color=#0000bb]Zone[/color][color=#007700]=[/color][color=#dd0000]'21' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and [/color][color=#0000bb]Nation [/color][color=#007700]= [/color][/font][font=Courier New][color=#0000bb]2
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]warriorsa
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'101' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]201
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'105' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]205
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'106' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]206
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'101' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]201
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'105' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]205
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'106' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]206
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'101' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]201
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'105' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]205
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'106' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]206
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'101' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]201
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'105' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]205
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'1'[/color][color=#007700],Class=[/color][color=#dd0000]'106' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]206
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]roguesa
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'102' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]202
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'107' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]207
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'108' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]208
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'102' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]202
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'107' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]207
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'108' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]208
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'102' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]202
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'107' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]207
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'108' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]208
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'102' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]202
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'107' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]207
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'2'[/color][color=#007700],Class=[/color][color=#dd0000]'108' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]208
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]magese
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'103' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]203
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'109' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]209
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'110' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]210
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'103' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]203
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'109' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]209
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'110' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]210
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'103' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]203
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'109' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]209
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'3'[/color][color=#007700],Class=[/color][color=#dd0000]'110' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]210
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'12'[/color][color=#007700],Class=[/color][color=#dd0000]'103' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]203
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'109' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]209
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'13'[/color][color=#007700],Class=[/color][color=#dd0000]'110' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]210
[/color][color=#007700]-- [/color][/font][font=Courier New][color=#0000bb]priestse
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'104' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]204
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'111' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]211
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'112' [/color][color=#0000bb]where Knights [/color][color=#007700]= @[/color][color=#0000bb]IDNo [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]212
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'104' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]204
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'111' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]211
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'112' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k1 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]212
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'104' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]204
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'111' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]211
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'112' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k2 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]212
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'104' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]204
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'111' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][font=Courier New][color=#0000bb]211
update userdata set Race[/color][color=#007700]=[/color][color=#dd0000]'4'[/color][color=#007700],Class=[/color][color=#dd0000]'112' [/color][color=#0000bb]where strUserId [/color][color=#007700]= @[/color][color=#0000bb]k3 [/color][color=#007700]and Class= [/color][/font][color=#0000bb][font=Courier New]212
end
GO [/font]
[/color][/color]