Originally Posted by
Wesley2012
Reparar o que ? oO
3 minutes:------- Atualizado -------
Originally Posted by
Demito
Luis primeiramente parabens pelo belo trabalho segundamente vc não teria a query do marry system que adicionei esse msm system na s6 só que to com uns problemas em relação a db ele n reconhece que tou casado e se dou /marry divorece ele avisa que n estou casado
desde já obrigado man
Código:
Create Procedure [dbo].[WZ_GetMarryInfo] @name varchar(10), @MarryCharacter varchar(10)
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @countYou int
DECLARE @countHim int
DECLARE @Startdate datetime2 = '2016-01-01 00:00:00.0000000';
DECLARE @marriedOnEnd datetime2
DECLARE @marriedOn int
DECLARE @nameGet1 varchar(10)
DECLARE @nameGet2 varchar(10)
/*DECLARE @marriedOn int*/
SELECT @countYou=Count(*) FROM [dbo].[Marry] WHERE Character = @name OR MarryCharacter = @name /*You are already married*/
SELECT @countHim=Count(*) FROM [dbo].[Marry] WHERE Character = @MarryCharacter OR MarryCharacter = @MarryCharacter /*He/She is already married*/
SELECT @nameGet1=MarryCharacter FROM [dbo].[Marry] WHERE Character = @name
SELECT @nameGet2=Character FROM [dbo].[Marry] WHERE MarryCharacter = @name
SELECT @marriedOnEnd=MarriedOn FROM [dbo].[Marry] WHERE Character = @name OR MarryCharacter = @name /*Married date*/
SELECT @marriedOn=DATEDIFF(SECOND, @Startdate, @marriedOnEnd)
SELECT @countYou AS CountYou, @countHim AS CountHim, @marriedOn AS MarriedOn, @nameGet1 AS NameGet1, @nameGet2 AS NameGet2
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO
CREATE Procedure [dbo].[WZ_SetMarryInfo] @name varchar(10), @MarryCharacter varchar(10)
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
INSERT INTO [dbo].[Marry] (Character, MarryCharacter) VALUES (@name , @MarryCharacter);
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO
CREATE Procedure [dbo].[WZ_SetDivorceInfo] @name varchar(10), @MarryCharacter varchar(10)
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
DELETE FROM [dbo].[Marry] where Character = @name OR MarryCharacter = @MarryCharacter
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
GO