[HELP] price matematic rent server

[AlexandreDiaz]

I want set
30 days = 10 slot > 80k gc
30 days = 30 slots > 120k gc

60 days = 10 slot > 140k gc
60 days = 30 slots > 200k gc

But i can't understnd how it work.
Embed code:

You must be registered to see links

ALTER PROCEDURE [dbo].[WZ_ServerGetPrices]ASBEGIN    SET NOCOUNT ON;
    select 0 as ResultCode        -- GAMESERVER prices    select        0            as 'Base_US',        -- 8500 base price per server per month in US region. 0 if region is disabled        80000    as 'Base_EU',        -- 8500 base price per server per month in europe region. 0 if region is disabled        0            as 'Base_RU',        -- 8500 base price per server per month in russian region. 0 if region is disabled        90000    as 'Base_SA',        -- South america. Should be 3x price of US\EU server due to high cost of renting server equipment in Brazil        -- percents of base price per each option        0        as 'PVE',        0        as 'PVP',        800        as 'Slot1',            -- 10 plr        1200        as 'Slot2',            -- 20 plr        -10        as 'Slot3',            -- 30 plr        -10        as 'Slot4',            -- 40 plr        -10        as 'Slot5',            -- 50 plr        0        as 'Passworded',        0        as 'MonthX2',        --         -10        as 'MonthX3',        --         -15        as 'MonthX6',        -70        as 'WeekX1', -- for renting one week only        0        as 'OptNameplates',        0        as 'OptCrosshair',        0        as 'OptTracers'            -- STRONGHOLD prices    select        0        as 'Base_US',        -- base price per server per month in US region. 0 if region is disabled        0        as 'Base_EU',        -- base price per server per month in europe region. 0 if region is disabled        0        as 'Base_RU',        -- base price per server per month in russian region. 0 if region is disabled        0        as 'Base_SA',        -- percents of base price per each option        0        as 'PVE',        0        as 'PVP',        0        as 'Slot1',            -- 10 plr        50        as 'Slot2',            -- 20 plr        100        as 'Slot3',            -- 30 plr        150        as 'Slot4',            -- 40 plr        200        as 'Slot5',            -- 50 plr        0        as 'Passworded',        0        as 'MonthX2',        --         0        as 'MonthX3',        --         0        as 'MonthX6',        -40        as 'WeekX1', -- for renting one week only        0        as 'OptNameplates',        0        as 'OptCrosshair',        0        as 'OptTracers'            -- games CAPACITY report    declare    [USER=21783]Game[/USER]s_US int = 0    declare    [USER=21783]Game[/USER]s_EU int = 0    declare    [USER=21783]Game[/USER]s_RU int = 0    declare    [USER=21783]Game[/USER]s_SA int = 0    select    [USER=21783]Game[/USER]s_US = count(*) from ServersList where ServerRegion=1  and WorkHours<RentHours and ServerMap<>3    select    [USER=21783]Game[/USER]s_EU = count(*) from ServersList where ServerRegion=10 and WorkHours<RentHours and ServerMap<>3    select    [USER=21783]Game[/USER]s_RU = count(*) from ServersList where ServerRegion=20 and WorkHours<RentHours and ServerMap<>3    select    [USER=21783]Game[/USER]s_SA = count(*) from ServersList where ServerRegion=30 and WorkHours<RentHours and ServerMap<>3
    select        -- modify numbers here. 1st is global server capacity. 2nd is our HOSTED server number        -- mul by 2 as with hibernate we can support more servers now        (650*4) - 0 as 'Capacity_US',    [USER=21783]Game[/USER]s_US as 'Games_US',        (50*1) - 0 as 'Capacity_EU',    [USER=21783]Game[/USER]s_EU as 'Games_EU',        (50*4)      as 'Capacity_RU',    [USER=21783]Game[/USER]s_RU as 'Games_RU',        (100*3) - 0  as 'Capacity_SA',    [USER=21783]Game[/USER]s_SA as 'Games_SA'
    -- strongholds CAPACITY report    select    [USER=21783]Game[/USER]s_US = count(*) from ServersList where ServerRegion=1  and WorkHours<RentHours and ServerMap=3    select    [USER=21783]Game[/USER]s_EU = count(*) from ServersList where ServerRegion=10 and WorkHours<RentHours and ServerMap=3    select    [USER=21783]Game[/USER]s_RU = count(*) from ServersList where ServerRegion=20 and WorkHours<RentHours and ServerMap=3    select    [USER=21783]Game[/USER]s_SA = count(*) from ServersList where ServerRegion=30 and WorkHours<RentHours and ServerMap=3
    select        -- modify numbers here. 1st is global server capacity. 2nd is our HOSTED server number        -- mul by 4 as with hibernate we can support more servers now        (650*4) - 0 as 'Capacity_US',    [USER=21783]Game[/USER]s_US as 'Games_US',        (50*1) - 0 as 'Capacity_EU',    [USER=21783]Game[/USER]s_EU as 'Games_EU',        (50*4)      as 'Capacity_RU',    [USER=21783]Game[/USER]s_RU as 'Games_RU',        (100*3) - 0  as 'Capacity_SA',    [USER=21783]Game[/USER]s_SA as 'Games_SA'        END

 

[IKaruzI15]

best solution is to rewrite the whole poop.