1
Soporte / Ayudas / Re: studPE
« Posteado: January 16, 2018, 11:58:06 PM »
Usa Lib Hook o Dlib Attach tambien podes usar lord pe.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
CREATE procedure WZ_GuildCreate
@GuildName nvarchar(8),
@Name nvarchar(10)
as
BEGIN
DECLARE @ErrorCode int
DECLARE @reset int
SET @ErrorCode = 0
SET XACT_ABORT OFF
Set nocount on
begin transaction
SELECT @reset=[Resets] from [Character] where [Name]=@Name
INSERT INTO Guild (G_Name, G_Master) valueS (@GuildName, @Name)
IF ( @reset > 100 )
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 1
END
IF ( @reset < 100 ) IF ( @@Error <> 1 )
BEGIN
SET @ErrorCode = 1
END
IF ( @ErrorCode = 0 )
BEGIN
INSERT GuildMember (Name, G_Name, G_Level) values (@Name, @GuildName, 1)
IF ( @@Error <> 0 )
BEGIN
SET @ErrorCode = 2
END
END
IF ( @ErrorCode <> 0 )
rollback transaction
ELSE
commit transaction
select @ErrorCode
Set nocount off
SET XACT_ABORT ON
END
GO