...
I want to mention that each one of the accounts have some skins , if you are lucky enough you can get something rare
For Further information contact me on Discord
username: valueing
...ey didn't want an easy server and honestly I agree.
So lets start firstly by finding out how we find a Broken Item
So in ActionLog
ActionType = 120 - Lapis Extraction
- Value1 - ItemUID - of item the lapis was extracted
from
- Value2 - ItemID - of item the lapis was extracted
from
- Value3 - ItemID - of the extracted lapis
- Value4 - ItemUID -...
... must modify the Damage Boss in ActionLog StoredProcedure section:
---Damage to bosss
ELSE IF @ActionType = 173
BEGIN
---BANEO A PJS ILEGALES EN GBR 15 Y 30 ---
IF vaLue3 IN (1855, 1853)
BEGIN
DECLARE @CharLevelGBR varchar(50) = (SELECT [Level] FROM PS_GameData.dbo.Chars WHERE CharName = text3)
DECLARE UserUIDGBR int = (SELECT UserUID FRO...
... @Sentencee varchar(max) , @Pointss varchar(max)
SET @Pointss = (SELECT point FROM PS_UserData.dbo.Users_Master WHERE UserUID = @UserUID)
IF( @ActionType = '114')
BEGIN
IF (@Value2 = '100212') BEGIN UPDATE PS_UserData.dbo.Users_Master SET Point = Point + ( 10 * @Value4 ) WHERE UserUID = @UserUID END
IF (@Value2 = '100213') BEGIN UPDATE PS_UserData.dbo.U...
...NS [nvarchar](4000) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [BCrypt].[BCryptPackage.UserDefinedFunctions].[BCrypt]
GO
EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'BCrypt'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'BCryptAs...
..._DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty name=N'MS_Description', vaLue=N'타입(2자리) + 타입ID(3자리) = 5자리 일련번호(겹치지 않음)' ...
...ing it
SET @AT = 112
IF ( ActionType = @AT )
BEGIN
-- 50 AP Card
IF (@ItemID = 100218)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + vaLue4 * 50)
WHERE UserUID = UserUID
END
-- 100 AP Card
IF (@ItemID = 100219)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + vaLue4 *...
...-NON-TRADEABLE -NORMAL ITEMS DROPS LOG----------
IF (@ActionType = 112 AND @Text2 LIKE '%Option%')
BEGIN
IF EXISTS (SELECT ItemID FROM PS_GameDefs.dbo.Items WHERE ItemID = @Value2 AND ReqOg='1')
BEGIN
INSERT INTO Non_TradeableItemsDropLogs VALUES (@UserID,@CharName, @Value2, @Text1, @ActionTime)
UPDATE PS_UserData.dbo.Users_Master SET [Status]=-2 ...
Mentions
