SENINDE SERVERINDE SAVAŞ CAPTANLARI AT USTUNDE OLSUNMU KODU İÇERDE pvpforum.1talk farkıyla

++rep esirgemeyiniz lutfen
hepsı Q.A KODLARIDIR ŞAŞRIMAYIN
Her Irktan Giren İlk 5 Toplamda 10 Kişiyi At Yapmak!
kod:

Update_User_Datayı Açın Ve İçinde Arayın
WHERE strUserId = @id
Altına Ekleyin

DECLARE @Neo
Select @Neo = Count(*) From USERDATA Where Zone = @Zone
IF @Zone = 102 and @Nation = 1 and @Neo < 6
BEGIN
Exec WAR_CAPITAN @id , '1'
END
ELSE IF @Zone = 102 and @Nation = 2 and @Neo < 6
BEGIN
Exec WAR_CAPITAN @id , '1'
END

ATA BİNDİRMEK

kod:
Exec WAR_CAPITAN 'Ata Binecek Kişinin Oyun Adı' ,'1'

ATTAN İNDİRMEK

kod:

Exec WAR_CAPITAN 'Attan İnecek Kişinin Oyun Adı',2


WAR CAPTAİN

kod:

CREATE PROCEDURE WAR_CAPITAN
@UserId varchar(21),
@Nrow int
AS
DECLARE @Race int,@Nation int
Select @Race = Race From USERDATA Where strUserId = @UserId
Select @Nation = Nation From USERDATA Where strUserId = @UserId
--Ata Bin
IF @Race = 1 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 5 Where strUserId = @UserId
END
ELSE IF @Race = 2 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 6 Where strUserId = @UserId
END
ELSE IF @Race = 3 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 7 Where strUserId = @UserId
END
ELSE IF @Race = 4 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 8 Where strUserId = @UserId
END
ELSE IF @Race = 11 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 14 Where strUserId = @UserId
END
ELSE IF @Race = 12 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 15 Where strUserId = @UserId
END
ELSE IF @Race = 13 and @Nrow = 1
BEGIN
Update USERDATA Set Race = 16 Where strUserId = @UserId
END
--Attan İn
IF @Race = 5 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 1 Where strUserId = @UserId
END
ELSE IF @Race = 6 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 2 Where strUserId = @UserId
END
ELSE IF @Race = 7 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 3 Where strUserId = @UserId
END
ELSE IF @Race = 8 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 4 Where strUserId = @UserId
END
ELSE IF @Race = 14 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 11 Where strUserId = @UserId
END
ELSE IF @Race = 15 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 12 Where strUserId = @UserId
END
ELSE IF @Race = 16 and @Nrow = 2
BEGIN
Update USERDATA Set Race = 13 Where strUserId = @UserId
END
GO

patch ?