PHP Code:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[PointUyThac_by_NetBanBe] Script Date: 08/09/2016 00:47:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[PointUyThac_by_NetBanBe]
As
Begin
Declare
@PointUyThac int,
@SubUyThac varchar(50)
SET @PointUyThac=5 -- So PointUyThac tang
SET @SubUyThac='TL-1' --Ten Sub cho phep Uy Thac
UPDATE CHARACTER
SET PointUyThac = PointUyThac + @PointUyThac
FROM MEMB_STAT JOIN AccountCharacter ON MEMB_STAT.ConnectStat = 1 and
DATEDIFF(MINUTE, MEMB_STAT.ConnectTM, GETDATE()) >=4 and -- onl tren 4p moi tinh
MEMB_STAT.ServerName LIKE @SubUyThac and
MEMB_STAT.memb___id collate DATABASE_DEFAULT = AccountCharacter.Id collate DATABASE_DEFAULT
JOIN Character ON AccountCharacter.GameIDC = Character.Name AND ((Character.MapNumber=0 AND Character.MapNumber=3) OR (Character.MapNumber=0 AND (Character.MapPosX>95 OR Character.MapPosX<175 OR Character.MapPosY>90 OR Character.MapPosY<165)) OR (Character.MapNumber=3 AND (Character.MapPosX>165 OR Character.MapPosX<205 OR Character.MapPosY>85 OR Character.MapPosY<130)))
End
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[PointUyThac_by_NetBanBe] Script Date: 08/09/2016 00:47:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[PointUyThac_by_NetBanBe]
As
Begin
Declare
@PointUyThac int,
@SubUyThac varchar(50)
SET @PointUyThac=5 -- So PointUyThac tang
SET @SubUyThac='TL-1' --Ten Sub cho phep Uy Thac
UPDATE CHARACTER
SET PointUyThac = PointUyThac + @PointUyThac
FROM MEMB_STAT JOIN AccountCharacter ON MEMB_STAT.ConnectStat = 1 and
DATEDIFF(MINUTE, MEMB_STAT.ConnectTM, GETDATE()) >=4 and -- onl tren 4p moi tinh
MEMB_STAT.ServerName LIKE @SubUyThac and
MEMB_STAT.memb___id collate DATABASE_DEFAULT = AccountCharacter.Id collate DATABASE_DEFAULT
JOIN Character ON AccountCharacter.GameIDC = Character.Name AND ((Character.MapNumber=0 AND Character.MapNumber=3) OR (Character.MapNumber=0 AND (Character.MapPosX>95 OR Character.MapPosX<175 OR Character.MapPosY>90 OR Character.MapPosY<165)) OR (Character.MapNumber=3 AND (Character.MapPosX>165 OR Character.MapPosX<205 OR Character.MapPosY>85 OR Character.MapPosY<130)))
End