85 lines
3.7 KiB
Transact-SQL
85 lines
3.7 KiB
Transact-SQL
-- LosaDev 2014: procedures whose 2012 parameter list is shorter than what the 2014 game server sends
|
|
-- ("has too many arguments specified"). The extra parameters get defaults; behaviour otherwise unchanged.
|
|
USE [LosaGame];
|
|
GO
|
|
|
|
-- query 22: the 2014 server pages the gear list (last index, account, page size)
|
|
ALTER PROCEDURE [dbo].[game_item_extra_get_list]
|
|
(
|
|
@lastIndex int
|
|
, @accountIDX int = 0
|
|
, @pageSize int = 0
|
|
)
|
|
AS
|
|
SET NOCOUNT ON
|
|
SELECT TOP (CASE WHEN @pageSize > 0 THEN @pageSize ELSE 2147483647 END) idx
|
|
, item1_type, item1_reinforce, item1_slotindex, item1_tradetype, item1_limitType, item1_mcustom, item1_fcustom, item1_limitDate
|
|
, item2_type, item2_reinforce, item2_slotindex, item2_tradetype, item2_limitType, item2_mcustom, item2_fcustom, item2_limitDate
|
|
, item3_type, item3_reinforce, item3_slotindex, item3_tradetype, item3_limitType, item3_mcustom, item3_fcustom, item3_limitDate
|
|
, item4_type, item4_reinforce, item4_slotindex, item4_tradetype, item4_limitType, item4_mcustom, item4_fcustom, item4_limitDate
|
|
, item5_type, item5_reinforce, item5_slotindex, item5_tradetype, item5_limitType, item5_mcustom, item5_fcustom, item5_limitDate
|
|
, item6_type, item6_reinforce, item6_slotindex, item6_tradetype, item6_limitType, item6_mcustom, item6_fcustom, item6_limitDate
|
|
, item7_type, item7_reinforce, item7_slotindex, item7_tradetype, item7_limitType, item7_mcustom, item7_fcustom, item7_limitDate
|
|
, item8_type, item8_reinforce, item8_slotindex, item8_tradetype, item8_limitType, item8_mcustom, item8_fcustom, item8_limitDate
|
|
, item9_type, item9_reinforce, item9_slotindex, item9_tradetype, item9_limitType, item9_mcustom, item9_fcustom, item9_limitDate
|
|
, item10_type, item10_reinforce, item10_slotindex, item10_tradetype, item10_limitType, item10_mcustom, item10_fcustom, item10_limitDate
|
|
FROM userItemExtraDB WHERE accountIDX = @accountIDX AND idx > @lastIndex ORDER BY idx
|
|
GO
|
|
|
|
-- query 26: same paging for the decoration item list (last index, account, page size)
|
|
ALTER PROCEDURE [dbo].[game_item_get_data_list]
|
|
(
|
|
@lastIndex int
|
|
, @accountIDX int = 0
|
|
, @pageSize int = 0
|
|
)
|
|
AS
|
|
SET NOCOUNT ON
|
|
SELECT TOP (CASE WHEN @pageSize > 0 THEN @pageSize ELSE 2147483647 END)
|
|
idx, item1_type, item1_code, item2_type, item2_code, item3_type, item3_code,
|
|
item4_type, item4_code, item5_type, item5_code, item6_type, item6_code,
|
|
item7_type, item7_code, item8_type, item8_code, item9_type, item9_code,
|
|
item10_type, item10_code, item11_type, item11_code, item12_type, item12_code,
|
|
item13_type, item13_code, item14_type, item14_code, item15_type, item15_code,
|
|
item16_type, item16_code, item17_type, item17_code, item18_type, item18_code,
|
|
item19_type, item19_code, item20_type, item20_code
|
|
FROM userItemDB WHERE accountIDX = @accountIDX AND idx > @lastIndex ORDER BY idx
|
|
GO
|
|
|
|
-- query 12: the 2014 server adds the relative grade init code as 15th value (not stored here)
|
|
ALTER PROCEDURE [dbo].[game_game_save]
|
|
(
|
|
@accountIDX int
|
|
, @userState int
|
|
, @gameMoney bigint
|
|
, @conn_count int
|
|
, @connDate datetime
|
|
, @userLevel int
|
|
, @userEXP int
|
|
, @playTime int
|
|
, @regionType int
|
|
, @userFishingLevel int
|
|
, @userFishingEXP int
|
|
, @refillData int
|
|
, @userExcavationLevel int
|
|
, @userExcavationEXP int
|
|
, @relativeInitCode int = 0
|
|
)
|
|
AS
|
|
UPDATE userGameDB SET
|
|
gameMoney = @gameMoney
|
|
, userState = @userState
|
|
, playTime = playTime + Round((@playTime/1000)/60,0)
|
|
, conn_count = @conn_count
|
|
, userLevel = @userLevel
|
|
, userEXP = @userEXP
|
|
, userFishingLevel = @userFishingLevel
|
|
, userFishingEXP = @userFishingEXP
|
|
, regionType = @regionType
|
|
, connDate = @connDate
|
|
, refillData = @refillData
|
|
, userExcavationLevel = @userExcavationLevel
|
|
, userExcavationEXP = @userExcavationEXP
|
|
WHERE accountIDX = @accountIDX
|
|
GO
|