[Epic Release](WSE)Weapon Stat Editor

01/06/2013 21:27 ahmed4ever2u#1
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



[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]




OOh please add this table to your DB
Code:
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
[Only registered and activated users can see links. Click Here To Register...]
01/08/2013 11:53 PortalDark#2
#approved
01/08/2013 12:21 OverLimits#3
In behave of "Whocares" group i thank you so much .
01/08/2013 13:15 IceAmStiel#4
Maybe you can make use of it.. [Only registered and activated users can see links. Click Here To Register...]

Code:
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
03/23/2013 10:47 Isoline*#5
where to put the lines in the media?, path?
09/28/2013 07:53 asanoftw#6
helpful program
10/07/2013 14:02 fun4joke#7
Now that's good one... Is it possible to make something like that for armors/accesories as well?
10/07/2013 23:17 Twix*#8
Awesome & helpful
thanks alot
11/07/2013 21:24 Akaly215#9
helpful work good for me thanks
11/11/2013 11:13 Dev Power#10
Nice ... Work 100%
11/15/2013 21:15 TheB1QB0SS#11
AweSome

You Have Recived My Thanks :)
03/18/2015 02:02 FantasticBoy1#12
nice
07/02/2015 07:34 Skitoz#13
Helpful Man
And Very THanks :)
09/26/2016 08:50 captain912#14
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
09/26/2016 10:41 ahmed4ever2u#15
Quote:
Originally Posted by captain912 View Post
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