Fix Strengthen item

[jaeker1]

this fix strengthen item
fix multi strengthen
you can select multi item for upgrade

see on video






edit database
use 2 query

USE [db_tank]
GO

/****** Object:  StoredProcedure [dbo].[SP_Users_Items_Update]    Script Date: 12/19/2012 12:45:00 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SP_Users_Items_Update]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[SP_Users_Items_Update]
GO

USE [db_tank]
GO

/****** Object:  StoredProcedure [dbo].[SP_Users_Items_Update]    Script Date: 12/19/2012 12:45:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




-- =============================================
-- Author:		<Ken>
-- ALTER  date: <2009-10-22>
-- Description:	<用户信息：更新人物物品信息>
-- =============================================
CREATE  PROCEDURE [dbo].[SP_Users_Items_Update]   
  @ItemID int, 
 @UserID int, 
 @TemplateID int, 
 @Place int, 
 @Count int, 
 @IsJudge bit, 
 @Color nvarchar(100), 
 @IsExist bit, 
 @StrengthenLevel int, 
 @AttackCompose int, 
 @DefendCompose int, 
 @LuckCompose int, 
 @AgilityCompose int, 
 @IsBinds bit, 
 @BeginDate DateTime, 
 @ValidDate int,
 @BagType int,
 @Skin nvarchar(50),
 @IsUsed bit,
 @RemoveDate datetime,
 @RemoveType int,
 @Hole1 int,
 @Hole2 int,
 @Hole3 int,
 @Hole4 int,
 @Hole5 int,
 @Hole6 int,
 @StrengthenTimes int,
 @Hole5Level int,
 @Hole5Exp int,
 @Hole6Level int,
 @Hole6Exp int,
 @IsGold bit,
 @StrengthenExp int
 AS    
   begin 
	/*if @Place>-1
	begin
		update Sys_Users_Goods set Place=-2 where UserID=@UserID and BagType=@BagType and Place=@Place and IsExist=1
	end*/

     UPDATE Sys_Users_Goods Set UserID=@UserID,BagType=@BagType, TemplateID=@TemplateID, Place=@Place, Count=@Count, IsJudge=@IsJudge, Color=@Color, IsExist=@IsExist, StrengthenLevel=@StrengthenLevel, AttackCompose=@AttackCompose, DefendCompose=@DefendCompose, LuckCompose=@LuckCompose, AgilityCompose=@AgilityCompose, IsBinds=@IsBinds, BeginDate=@BeginDate, ValidDate=@ValidDate,Skin=@Skin,IsUsed=@IsUsed,RemoveDate=@RemoveDate,RemoveType=@RemoveType,Hole1=@Hole1,Hole2=@Hole2,Hole3=@Hole3,Hole4=@Hole4,Hole5=@Hole5,Hole6=@Hole6,StrengthenTimes=@StrengthenTimes,Hole5Level=@Hole5Level,Hole5Exp=@Hole5Exp,Hole6Level=@Hole6Level,Hole6Exp=@Hole6Exp,IsGold=@IsGold,strengthenexp=@StrengthenExp WHERE ItemID =@ItemID


   end

GO

USE [db_tank]
GO

/****** Object:  StoredProcedure [dbo].[SP_Users_Items_Add]    Script Date: 12/19/2012 12:44:49 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SP_Users_Items_Add]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[SP_Users_Items_Add]
GO

USE [db_tank]
GO

/****** Object:  StoredProcedure [dbo].[SP_Users_Items_Add]    Script Date: 12/19/2012 12:44:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




-- =============================================
-- Author:		<Ken>
-- ALTER  date: <2009-10-22>
-- Description:	<用户信息：用户新增一个物品>
-- =============================================
CREATE  PROCEDURE [dbo].[SP_Users_Items_Add]   
  @ItemID int output, 
 @UserID int, 
 @TemplateID int, 
 @Place int, 
 @Count int, 
 @IsJudge bit, 
 @Color nvarchar(100), 
 @IsExist bit, 
 @StrengthenLevel int, 
 @AttackCompose int, 
 @DefendCompose int, 
 @LuckCompose int, 
 @AgilityCompose int, 
 @IsBinds bit, 
 @BeginDate DateTime, 
 @ValidDate int,
 @BagType int,
 @Skin nvarchar(50),
 @IsUsed bit,
 @RemoveType int,
 @Hole1 int,
 @Hole2 int,
 @Hole3 int,
 @Hole4 int,
 @Hole5 int,
 @Hole6 int,
 @StrengthenTimes int,
 @Hole5Level int,
 @Hole5Exp int,
 @Hole6Level int,
 @Hole6Exp int,
 @IsGold bit,
 @strengthenexp int
AS  
declare  @temp int
select @temp = count(*) from Sys_Users_Goods where ItemID=@ItemID
if @temp=0 
 begin 
	/*if @Place>-1
	begin
		update Sys_Users_Goods set Place=-2 where UserID=@UserID and BagType=@BagType and Place=@Place and IsExist=1
	end*/

     INSERT INTO Sys_Users_Goods( UserID, BagType,TemplateID, Place, Count, IsJudge, Color, IsExist, StrengthenLevel, AttackCompose, DefendCompose, LuckCompose, AgilityCompose, IsBinds, BeginDate, ValidDate,Skin,IsUsed,RemoveType,Hole1,Hole2,Hole3,Hole4,Hole5,Hole6,StrengthenTimes,Hole5Level,Hole5Exp,Hole6Level,Hole6Exp,IsGold,strengthenexp) 
     VALUES( @UserID, @BagType,@TemplateID, @Place, @Count, @IsJudge, @Color, @IsExist, @StrengthenLevel, @AttackCompose, @DefendCompose, @LuckCompose, @AgilityCompose, @IsBinds, @BeginDate, @ValidDate,@Skin,@IsUsed,@RemoveType,@Hole1,@Hole2,@Hole3,@Hole4,@Hole5,@Hole6,@StrengthenTimes, @Hole5Level, @Hole5Exp, @Hole6Level, @Hole6Exp, @IsGold,@strengthenexp)
     select @@identity as 'identity'
     set @ItemID=@@identity    
 end

GO

sorry my English is bad







[Only registered and activated users can see links. ]




Thank Trminhpc

[biendong1980]

use gunny II database

this error : can't read some para from database
không thể ghi thì đúng hơn fix para 1207 PlayerBussiness
SqlParameter[] para = new SqlParameter[34];
ok you can share Source?
sorry my English is bad

[silop1d]

Can you share ItemStrengthenHandler.cs file?
Tks...

[bi.kute01]

cái này vẫn bị lỗi biến hình thank ak rất nhiều

[hung3020]

are you crazy bi.kute01. is it China
Sorry is English my bad

[hoaloi]

Can you share ItemStrengthenHandler.cs file?
Tks...

Bạn cho minh cái file ItemStrengthenHandler.cs này của bạn đi, mình có cách lấy file của jaeker1 cho bạn

[biendong1980]

Bạn cho minh cái file ItemStrengthenHandler.cs này của bạn đi, mình có cách lấy file của jaeker1 cho bạn

Lấy dc cả Source jaeker1 không bạn lây dc share mình với

[hoaloi]

Lấy dc cả Source jaeker1 không bạn lây dc share mình với

Mình lấy được mình mới nói.Ngay cả file của silop1d mình lấy cũng được nhưng mình muốn đối chiếu lại chút thôi

[bachugacon122]

Mình lấy được mình mới nói.Ngay cả file của silop1d mình lấy cũng được nhưng mình muốn đối chiếu lại chút thôi

can you share it to me ??

[hoandd]

this fix strengthen item
fix multi strengthen
you can select multi item for upgrade

see on video






sorry my English is bad







[Only registered and activated users can see links. ]

Thank Trminhpc

Good. Can you send your yahoo for me? or you PM nick hoandd2612.