[1.310] Fix warehouse/inventory saving

tarafından **Hello EMO** Çarş. Ara. 02, 2009 4:04 am

If Jonny can paste his UPDATE_WAREHOUSE_PW procedure so I can see how that worked again, I can update mine to work decently with the password, but other than that, here are the fixed procs:

Kod:: -- Use CREATE PROCEDURE instead of ALTER PROCEDURE if you don't already have this procedure ALTER PROCEDURE [dbo].[UPDATE_WAREHOUSE_PW] @strAccountID varchar(21), @strWarehousePw varchar(20), @Money int, @dwTime int, @strWarehouseData varchar(1600), @strSerial varchar(1600) AS BEGIN DECLARE @FirstRun int SELECT @FirstRun = COUNT(*) FROM WAREHOUSE WHERE strAccountID = @strAccountID AND strWarehousePw IS NULL IF @FirstRun = 0 BEGIN SELECT @strWarehousePw = strWarehouseNo FROM TB_USER WHERE strAccountID = @strAccountID END UPDATE WAREHOUSE SET strWarehousePw = @strWarehousePw, dwTime = @dwTime, nMoney = @Money, WareHouseData = @strWarehouseData, strSerial = @strSerial WHERE strAccountID = @strAccountID END

Kod:: ALTER PROCEDURE [dbo].[UPDATE_WAREHOUSE] @accountid varchar(21), @Money int, @dwTime int, @strItem varchar(1600), @strSerial varchar(1600) AS UPDATE WAREHOUSE Set nMoney = @Money, dwTime = @dwTime, WarehouseData = @strItem, strSerial = @strSerial WHERE strAccountID = @accountid ALTER PROCEDURE [dbo].[UPDATE_USER_DATA] @id varchar(21), @Nation tinyint, @Race tinyint, @Class smallint, @HairColor tinyint, @Rank tinyint, @Title tinyint, @Level tinyint, @Exp int, @Loyalty int, @Face tinyint, @City tinyint, @Knights smallint, @Fame tinyint, @Hp smallint, @Mp smallint, @Sp smallint, @Str tinyint, @Sta tinyint, @Dex tinyint, @Intel tinyint, @Cha tinyint, @Authority tinyint, @Points tinyint, @Gold int, @Zone tinyint, @Bind smallint, @PX int, @PZ int, @PY int, @dwTime int, @QuestTotal smallint, @strSkill varchar(20), @strItem varchar(400), @strSerial varchar(400), @strQuest varchar(400), @MannerPoint int, @LoyaltyMonthly int AS DECLARE @KnightsIndex smallint IF @Zone > 2 -- battle zone user BEGIN SELECT @KnightsIndex=Knights FROM USERDATA WHERE strUserId=@id IF @KnightsIndex = -1 -- expel user BEGIN SET @Knights = 0 SET @Fame = 0 END END UPDATE USERDATA Set Nation = @Nation, Race = @Race, Class = @Class, HairColor = @HairColor, Rank = @Rank, Title = @Title, [Level] = @Level, [Exp] = @Exp, Loyalty = @Loyalty, Face = @Face, City = @City, Knights = @Knights, Fame = @Fame, Hp = @Hp, Mp = @Mp, Sp = @Sp, Strong = @Str, Sta = @Sta, Dex = @Dex, Intel = @Intel, Cha = @Cha, Authority = @Authority, Points = @Points, Gold = @Gold, [Zone] = @Zone, Bind = @Bind, PX = @PX, PZ = @PZ, PY = @PY, dwTime = @dwTime, strSkill = @strSkill, strItem = @strItem, strSerial = @strSerial, -- 2002 11. 12 sQuestCount = @QuestTotal, -- 2003.04.09 strQuest = @strQuest, -- 2003.04.09 MannerPoint = @MannerPoint, -- 2004.01.30 LoyaltyMonthly = @LoyaltyMonthly, -- 2004.04.22 UpdateTime = getdate() WHERE strUserId = @id