[Tiny-Release] Item update

[SnickQ]

Hey all
As you know Castor in last ShStudio add one awsome think import SQL defs to new! We dont need now edit items one by one in Item.SData but we can edit more then one item with sql query.
But what the point? My little app was create new item with same stats.
For examle we want create 3 different armor Adamas Goddess, Adamas Legend and Justa but we want for all 3 same stats. All what you need is put ItemID from item (For example Conflict) and To ItemID fot item what we want change. When we use it we get for new item stats like conflict have.

requires Net Frame 4.5.1

Virus Total:

https://www.virustotal.com/pl/url/12ebe435fa5b8d932acc9652c3c5e3b8236ad02d1f0c8107fe1a35188e000110/analysis/1448224755/

[SkuulCandy]

Nice

[Truth1010]

Not a bad little tool, but people should still be using Zerosignals scripts, or variants of, to do their client editing.

It would be a simple, copy paste in excel (or notepad), then change TypeID to get the same result as your tool.

Only problem i can see with your tool (i havn't used it) would be if someone wanted to "clone" the stats from a 1H sword, to a staff. If my thinking is correct, it would make it useable to fighters/defenders/archers, and not mage/priest, as the "use by" field will be changed to match that of sword. Could see this bringing more problems than solving for people who want everything handed to them and have no interest in learning that they are trying to do before hand.

Again, i havn't used your tool, so sorry if this isn't the case
(and if it is, it may be something for you to look into stopping/adjusting. For the times when this problem happens and people come crying here that it broke their items )

[SnickQ]

Truth1010 as you say this tool copy all from item 1 to item 2. If some don't know this so i guess they also dont know how use python for this. And yes you need to change fighter to mage class. After you use this tool you can import defs from sql with Castor tool and is faster like python

USE PS_GAmeDefs
Declare @Reqlevel smallint,
@ItemID int ='From Item' -- Here put ItemID to copy values
@ItemID2 int ='To Item' --Here put itemID to new item 
@Country tinyint,
@Attackfighter tinyint,
@Defensefighter tinyint,
@Patrolrogue tinyint,
@Shootroguetinyint tinyint,
@Attackmage tinyint,
@Defensemage tinyint,
@Grow tinyint,
@ReqStr smallint,
@ReqDex smallint,
@ReqRec smallint,
@ReqInt smallint,
@ReqWis smallint,
@Reqluc smallint,
@ReqVg smallint,
@ReqOg tinyint,
@ReqIg tinyint,
@Range smallint,
@AttackTime tinyint,
@Attrib tinyint,
@Special tinyint,
@Slot tinyint,
@Quality smallint ,
@Effect1 smallint,
@Effect2 smallint,
@Effect3 smallint,
@Effect4 smallint,
@ConstHP smallint,
@ConstSP smallint ,
@ConstMP smallint,
@ConstStr smallint,
@ConstDex smallint,
@ConstRec smallint,
@ConstInt smallint,
@ConstWis smallint,
@ConstLuc smallint,
@Speed tinyint,
@Exp tinyint,
@Buy int,
@Sell int,
@Grade smallint,
@Server tinyint,
@Count tinyint,
@New tinyint

Set @Reqlevel =(Select Reqlevel from Items where ItemID=@ItemID)
Set @Country =(Select Country from Items where ItemID=@ItemID)
set @Attackfighter =(Select Attackfighter from Items where ItemID=@ItemID)
set @Defensefighter =(Select Defensefighter from Items where ItemID=@ItemID)
set @Patrolrogue =(Select Patrolrogue from Items where ItemID=@ItemID)
Set @Shootroguetinyint =(Select Shootrogue from Items where ItemID=@ItemID)
Set @Attackmage =(Select Attackmage from Items where ItemID=@ItemID)
Set @Defensemage =(Select Defensemage from Items where ItemID=@ItemID)
Set @Grow =(Select Grow from Items where ItemID=@ItemID)
Set @ReqStr =(Select ReqStr from Items where ItemID=@ItemID)
Set @ReqDex =(Select ReqDex from Items where ItemID=@ItemID)
Set @ReqRec =(Select ReqRec from Items where ItemID=@ItemID)
Set @ReqInt =(Select ReqInt from Items where ItemID=@ItemID)
Set @ReqWis =(Select ReqWis from Items where ItemID=@ItemID)
Set @Reqluc =(Select Reqluc from Items where ItemID=@ItemID)
Set @ReqVg =(Select ReqVg from Items where ItemID=@ItemID)
Set @ReqOg =(Select ReqOg from Items where ItemID=@ItemID)
Set @ReqIg =(Select ReqIg from Items where ItemID=@ItemID)
Set @Range =(Select Range from Items where ItemID=@ItemID)
Set @Attrib =(Select Attrib from Items where ItemID=@ItemID)
Set @AttackTime =(Select AttackTime from Items where ItemID=@ItemID)
Set @Special =(Select Special from Items where ItemID=@ItemID)
Set @Slot =(Select Slot from Items where ItemID=@ItemID)
Set @Quality  =(Select Quality from Items where ItemID=@ItemID)
Set @Effect1 =(Select Effect1 from Items where ItemID=@ItemID)
Set @Effect2 =(Select Effect2 from Items where ItemID=@ItemID)
Set @Effect3 =(Select Effect3 from Items where ItemID=@ItemID)
Set @Effect4 =(Select Effect4 from Items where ItemID=@ItemID)
Set @ConstHP =(Select ConstHP from Items where ItemID=@ItemID)
Set @ConstSP  =(Select ConstSP from Items where ItemID=@ItemID)
Set @ConstMP =(Select ConstMP from Items where ItemID=@ItemID)
Set @ConstStr =(Select ConstStr from Items where ItemID=@ItemID)
Set @ConstDex =(Select ConstDex from Items where ItemID=@ItemID)
Set @ConstRec =(Select ConstRec from Items where ItemID=@ItemID)
Set @ConstInt =(Select ConstInt from Items where ItemID=@ItemID)
Set @ConstWis =(Select ConstWis from Items where ItemID=@ItemID)
Set @ConstLuc =(Select ConstLuc from Items where ItemID=@ItemID)
Set @Speed =(Select Speed from Items where ItemID=@ItemID)
Set @Exp =(Select Exp from Items where ItemID=@ItemID)
Set @Buy =(Select Buy from Items where ItemID=@ItemID)
Set @Sell =(Select Sell from Items where ItemID=@ItemID)
Set @Grade =(Select Grade from Items where ItemID=@ItemID)
set @Server=(Select Server from Items where ItemID=@ItemID)
set @Count =(Select Count from Items where ItemID=@ItemID)

Update Items
SET Reqlevel = @Reqlevel,
Country = @Country,
Attackfighter= @Attackfighter,
Defensefighter= @Defensefighter,
Patrolrogue = @Patrolrogue ,
Shootrogue = @Shootroguetinyint,
Attackmage= @Attackmage ,
Defensemage= @Defensemage ,
Grow= @Grow ,
ReqStr= @ReqStr ,
ReqDex=@ReqDex ,
ReqRec= @ReqRec ,
ReqInt= @ReqInt ,
ReqWis= @ReqWis ,
Reqluc= @Reqluc ,
ReqVg= @ReqVg ,
ReqOg= @ReqOg ,
ReqIg= @ReqIg ,
Range= @Range ,
AttackTime= @AttackTime , 
Attrib= @Attrib ,
Special = @Special ,
Slot= @Slot ,
Quality= @Quality ,
Effect1= @Effect1 ,
Effect2= @Effect2 ,
Effect3= @Effect3 ,
Effect4= @Effect4 ,
ConstHP= @ConstHP ,
ConstSP= @ConstSP ,
ConstMP= @ConstMP ,
ConstStr= @ConstStr ,
ConstDex= @ConstDex ,
ConstRec= @ConstRec ,
ConstInt= @ConstInt ,
ConstWis= @ConstWis ,
ConstLuc= @ConstLuc ,
Speed=@Speed ,
Exp=@Exp ,
Buy=@Buy ,
Sell=@Sell ,
Grade=@Grade ,
Server =@Server ,
Count= @Count 

where ItemID=@ItemID2

[V8Banana]

HOW TO USE?

[escuelar]

Good tool will be useful to me