Module - Unmanned Trader / UTS

Back

Price	$200
Module	name: `fix.unmanned_trader` config: `unmanned_trader.json`
Short Description	Allow buying and selling using the cash points, and configure the tax percentage for the cost of cash points for all races.

Watch example here

Config	Value	Description
`enable_dalant_regist`	`true` / `false`	`true` enable UTS using Money `false` disable UTS using Money
`race_condition_dalant`	`true` / `false`	`true` only same race (UTS using Money) `false` all races (UTS using Money)
`race_condition_cash_shop`	`true` / `false`	`true` only same race (UTS using Cash Points) `false` all races (UTS using Cash Points)
`tax_cash_shop`	`0 ~ 1`	Fee for putting item to be listed on UTS Cost Cash Points taken from Price Input, 0.05 = 5% / 0.6 = 60%
`min_price_cash_shop`	`0 ~ 2000000000`	Minimum price (cash points) of item to be listed on UTS If you wish to disable UTS using Cash Points, set it to 2000000000
`sell_turn_dalant`	`72`	Expire item at UTS Money after (default 72 hour = 3 days)
`sell_turn_cash_shop`	`72`	Expire item at UTS Cash Points after (default 72 hour = 3 days)

If you enable all races UTS, you need to modify procedure pSelect_utsellinfo or run query below

Solution

            
USE [RF_WORLD]
GO
ALTER PROCEDURE [dbo].[pSelect_utsellinfo] @type tinyint,
@serial int,
@race tinyint
AS
  IF @type = 0
  BEGIN
    SELECT
      s.[price],
      s.[owner],
      b.[Race],
      b.[Dalant],
      g.[GuildSerial],
      b.[AccountSerial],
      b.[Account],
      b.[Name]
    FROM [dbo].[tbl_utsellinfo] AS s
    JOIN [dbo].[tbl_base] AS b
      ON s.[type] = @type
      AND s.[serial] = @serial
      --AND s.[race] = @race
      AND b.[Serial] = s.[owner]
      AND b.[dck] = 0
    JOIN [dbo].[tbl_general] AS g
      ON g.[Serial] = s.[owner]
  END
  ELSE
  BEGIN
    SELECT
      s.[price],
      s.[owner],
      b.[Race],
      0,
      g.[GuildSerial],
      b.[AccountSerial],
      b.[Account],
      b.[Name]
    FROM [dbo].[tbl_utsellinfo] AS s
    JOIN [dbo].[tbl_base] AS b
      ON s.[type] = @type
      AND s.[serial] = @serial
      AND b.[Serial] = s.[owner]
      AND b.[dck] = 0
    JOIN [dbo].[tbl_general] AS g
      ON g.[Serial] = s.[owner]
  END