[Epic Release](WSE)Weapon Stat Editor

[ahmed4ever2u]

UMAD ?

• Q : What is this tool ?
  
• A : its weapons stats editor
  
• Q : why i will use it?
  
• A : simple Pvp server may want to create low power weapons or stronger weapons this tool edit the Original stats for any weapon depends on your increase or decrease percent
  
• Q : AM I SPAMMER ?
  
• A : if you see me like this I'll ask you something UMAD ?

OOh and btw i give some credits for sladlejrhfpq for his amazing selection script













OOh please add this table to your DB

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[Modified_wepons]    Script Date: 01/06/2013 22:08:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Modified_wepons](
    [CodeName] [varchar](150) NULL,
    [LinkID] [varchar](150) NULL,
    [percent] [varchar](150) NULL,
    [date] [varchar](150) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

download

[PortalDark]

#approved

[OverLimits]

In behave of "Whocares" group i thank you so much .

[IceAmStiel]

Maybe you can make use of it..

Declare	@Coln varchar(max),
	@Query nvarchar(max),
	@Rate real;
		
SELECT @Coln = 'SELECT r.ID, r.CodeName128, ',
 
/*						### 1 = 100%
						*/
		@Rate = 0.9;
/*						### e.g. 0.1 = 10% (-90%)
						*/
						
SELECT @Coln = @Coln + 'ROUND(CASE WHEN i.' + name + ' = 0 THEN 0 WHEN ROUND(i.' + name + ' * ' + CONVERT(varchar(9), @Rate) + ', CASE WHEN CHARINDEX(''.'',i.' + name + ') > 0 THEN 1 ELSE 0 END) <= 0 THEN 1 ELSE i.' + name + ' * ' + CONVERT(varchar(9), @Rate) + ' END, CASE WHEN CHARINDEX(''.'',i.' + name +') > 0 THEN 1 ELSE 0 END)' + ' as ' + name + ', ' FROM sys.columns WHERE object_id = OBJECT_ID('_RefObjItem') AND (column_id BETWEEN 8 AND 30 OR column_id BETWEEN 40 AND 62)
SELECT @Query = LEFT(@Coln, LEN(@Coln) - 1) + ' FROM _RefObjCommon r JOIN _RefObjItem i on r.Link = i.ID WHERE TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 in (1,2,3,4,5,6,9,10,11) AND TypeID4 <= 15 AND [Service] = 1'

exec sp_executesql @Query

[Isoline*]

where to put the lines in the media?, path?

[asanoftw]

helpful program

[fun4joke]

Now that's good one... Is it possible to make something like that for armors/accesories as well?

[Twix*]

Awesome & helpful
thanks alot

[Akaly215]

helpful work good for me thanks

[Dev Power]

Nice ... Work 100%

[TheB1QB0SS]

AweSome

You Have Recived My Thanks

[FantasticBoy1]

nice

[Skitoz]

Helpful Man
And Very THanks

[captain912]

hi pro first thanks for the program secound when i open the program there some thing is show up and told me to put (SQL host -User-Password-Data base) what i do in all of this

[ahmed4ever2u]

Originally Posted by captain912

hi pro first thanks for the program secound when i open the program there some thing is show up and told me to put (SQL host -User-Password-Data base) what i do in all of this

please show photo