[Release] Best System for Weapon Dyes

goldenbird11 · 12/05/2023, 12:05

Released for the first time

A weapon glow system of my own and you will never find it on any other server or DB.
The system enables you to add specific Dye, remove specific Dye and mix all Dyes together on your weapon together at the same time using a very little code.

I made my system on 8 different Dyes, but you can add any number of weapon Dyes.

First thing you need to know, the possibility to mix 8 weapon Dyes will require from you to add 256 different weapons to your database (Number of possibilities for one weapon).

So, total amount of weapons 4096

I will release my lines from my game Aeon, these files are for all D14 Sun weapons, Here i will speak only about one weapon for saving spaces, But you can repeat same operation for all the 16 weapons.

DB & Media files (Particles,Media) :

So, for now lets work on TwoHanded Staff

Remember, You need to add 8 scrolls for Dyes adder and 8 scrolls for Dyes remover in your DB
I will not release this because I think everyone can add scrolls to game normally and control them.

Now the System starts lets go
Make a new Table with same number of Columns

For example lets call it _DyesSystem

ItemID	White	Black	Blue	Pink	Violet	Green	Yellow	Red
44545	0	0	0	0	0	0	0	0
44546	0	0	0	0	0	0	0	1
44547	0	0	0	0	0	0	1	0
44548	0	0	0	0	0	0	1	1
44549	0	0	0	0	0	1	0	0
44550	0	0	0	0	0	1	0	1
44551	0	0	0	0	0	1	1	0
44552	0	0	0	0	0	1	1	1
44553	0	0	0	0	1	0	0	0
44554	0	0	0	0	1	0	0	1
44555	0	0	0	0	1	0	1	0
44556	0	0	0	0	1	0	1	1
44557	0	0	0	0	1	1	0	0
44558	0	0	0	0	1	1	0	1
44559	0	0	0	0	1	1	1	0
44560	0	0	0	0	1	1	1	1
44561	0	0	0	1	0	0	0	0
44562	0	0	0	1	0	0	0	1
44563	0	0	0	1	0	0	1	0
44564	0	0	0	1	0	0	1	1
44565	0	0	0	1	0	1	0	0
44566	0	0	0	1	0	1	0	1
44567	0	0	0	1	0	1	1	0
44568	0	0	0	1	0	1	1	1
44569	0	0	0	1	1	0	0	0
44570	0	0	0	1	1	0	0	1
44571	0	0	0	1	1	0	1	0
44572	0	0	0	1	1	0	1	1
44573	0	0	0	1	1	1	0	0
44574	0	0	0	1	1	1	0	1
44575	0	0	0	1	1	1	1	0
44576	0	0	0	1	1	1	1	1
44577	0	0	1	0	0	0	0	0
44578	0	0	1	0	0	0	0	1
44579	0	0	1	0	0	0	1	0
44580	0	0	1	0	0	0	1	1
44581	0	0	1	0	0	1	0	0
44582	0	0	1	0	0	1	0	1
44583	0	0	1	0	0	1	1	0
44584	0	0	1	0	0	1	1	1
44585	0	0	1	0	1	0	0	0
44586	0	0	1	0	1	0	0	1
44587	0	0	1	0	1	0	1	0
44588	0	0	1	0	1	0	1	1
44589	0	0	1	0	1	1	0	0
44590	0	0	1	0	1	1	0	1
44591	0	0	1	0	1	1	1	0
44592	0	0	1	0	1	1	1	1
44593	0	0	1	1	0	0	0	0
44594	0	0	1	1	0	0	0	1
44595	0	0	1	1	0	0	1	0
44596	0	0	1	1	0	0	1	1
44597	0	0	1	1	0	1	0	0
44598	0	0	1	1	0	1	0	1
44599	0	0	1	1	0	1	1	0
44600	0	0	1	1	0	1	1	1
44601	0	0	1	1	1	0	0	0
44602	0	0	1	1	1	0	0	1
44603	0	0	1	1	1	0	1	0
44604	0	0	1	1	1	0	1	1
44605	0	0	1	1	1	1	0	0
44606	0	0	1	1	1	1	0	1
44607	0	0	1	1	1	1	1	0
44608	0	0	1	1	1	1	1	1
44609	0	1	0	0	0	0	0	0
44610	0	1	0	0	0	0	0	1
44611	0	1	0	0	0	0	1	0
44612	0	1	0	0	0	0	1	1
44613	0	1	0	0	0	1	0	0
44614	0	1	0	0	0	1	0	1
44615	0	1	0	0	0	1	1	0
44616	0	1	0	0	0	1	1	1
44617	0	1	0	0	1	0	0	0
44618	0	1	0	0	1	0	0	1
44619	0	1	0	0	1	0	1	0
44620	0	1	0	0	1	0	1	1
44621	0	1	0	0	1	1	0	0
44622	0	1	0	0	1	1	0	1
44623	0	1	0	0	1	1	1	0
44624	0	1	0	0	1	1	1	1
44625	0	1	0	1	0	0	0	0
44626	0	1	0	1	0	0	0	1
44627	0	1	0	1	0	0	1	0
44628	0	1	0	1	0	0	1	1
44629	0	1	0	1	0	1	0	0
44630	0	1	0	1	0	1	0	1
44631	0	1	0	1	0	1	1	0
44632	0	1	0	1	0	1	1	1
44633	0	1	0	1	1	0	0	0
44634	0	1	0	1	1	0	0	1
44635	0	1	0	1	1	0	1	0
44636	0	1	0	1	1	0	1	1
44637	0	1	0	1	1	1	0	0
44638	0	1	0	1	1	1	0	1
44639	0	1	0	1	1	1	1	0
44640	0	1	0	1	1	1	1	1
44641	0	1	1	0	0	0	0	0
44642	0	1	1	0	0	0	0	1
44643	0	1	1	0	0	0	1	0
44644	0	1	1	0	0	0	1	1
44645	0	1	1	0	0	1	0	0
44646	0	1	1	0	0	1	0	1
44647	0	1	1	0	0	1	1	0
44648	0	1	1	0	0	1	1	1
44649	0	1	1	0	1	0	0	0
44650	0	1	1	0	1	0	0	1
44651	0	1	1	0	1	0	1	0
44652	0	1	1	0	1	0	1	1
44653	0	1	1	0	1	1	0	0
44654	0	1	1	0	1	1	0	1
44655	0	1	1	0	1	1	1	0
44656	0	1	1	0	1	1	1	1
44657	0	1	1	1	0	0	0	0
44658	0	1	1	1	0	0	0	1
44659	0	1	1	1	0	0	1	0
44660	0	1	1	1	0	0	1	1
44661	0	1	1	1	0	1	0	0
44662	0	1	1	1	0	1	0	1
44663	0	1	1	1	0	1	1	0
44664	0	1	1	1	0	1	1	1
44665	0	1	1	1	1	0	0	0
44666	0	1	1	1	1	0	0	1
44667	0	1	1	1	1	0	1	0
44668	0	1	1	1	1	0	1	1
44669	0	1	1	1	1	1	0	0
44670	0	1	1	1	1	1	0	1
44671	0	1	1	1	1	1	1	0
44672	0	1	1	1	1	1	1	1
44673	1	0	0	0	0	0	0	0
44674	1	0	0	0	0	0	0	1
44675	1	0	0	0	0	0	1	0
44676	1	0	0	0	0	0	1	1
44677	1	0	0	0	0	1	0	0
44678	1	0	0	0	0	1	0	1
44679	1	0	0	0	0	1	1	0
44680	1	0	0	0	0	1	1	1
44681	1	0	0	0	1	0	0	0
44682	1	0	0	0	1	0	0	1
44683	1	0	0	0	1	0	1	0
44684	1	0	0	0	1	0	1	1
44685	1	0	0	0	1	1	0	0
44686	1	0	0	0	1	1	0	1
44687	1	0	0	0	1	1	1	0
44688	1	0	0	0	1	1	1	1
44689	1	0	0	1	0	0	0	0
44690	1	0	0	1	0	0	0	1
44691	1	0	0	1	0	0	1	0
44692	1	0	0	1	0	0	1	1
44693	1	0	0	1	0	1	0	0
44694	1	0	0	1	0	1	0	1
44695	1	0	0	1	0	1	1	0
44696	1	0	0	1	0	1	1	1
44697	1	0	0	1	1	0	0	0
44698	1	0	0	1	1	0	0	1
44699	1	0	0	1	1	0	1	0
44700	1	0	0	1	1	0	1	1
44701	1	0	0	1	1	1	0	0
44702	1	0	0	1	1	1	0	1
44703	1	0	0	1	1	1	1	0
44704	1	0	0	1	1	1	1	1
44705	1	0	1	0	0	0	0	0
44706	1	0	1	0	0	0	0	1
44707	1	0	1	0	0	0	1	0
44708	1	0	1	0	0	0	1	1
44709	1	0	1	0	0	1	0	0
44710	1	0	1	0	0	1	0	1
44711	1	0	1	0	0	1	1	0
44712	1	0	1	0	0	1	1	1
44713	1	0	1	0	1	0	0	0
44714	1	0	1	0	1	0	0	1
44715	1	0	1	0	1	0	1	0
44716	1	0	1	0	1	0	1	1
44717	1	0	1	0	1	1	0	0
44718	1	0	1	0	1	1	0	1
44719	1	0	1	0	1	1	1	0
44720	1	0	1	0	1	1	1	1
44721	1	0	1	1	0	0	0	0
44722	1	0	1	1	0	0	0	1
44723	1	0	1	1	0	0	1	0
44724	1	0	1	1	0	0	1	1
44725	1	0	1	1	0	1	0	0
44726	1	0	1	1	0	1	0	1
44727	1	0	1	1	0	1	1	0
44728	1	0	1	1	0	1	1	1
44729	1	0	1	1	1	0	0	0
44730	1	0	1	1	1	0	0	1
44731	1	0	1	1	1	0	1	0
44732	1	0	1	1	1	0	1	1
44733	1	0	1	1	1	1	0	0
44734	1	0	1	1	1	1	0	1
44735	1	0	1	1	1	1	1	0
44736	1	0	1	1	1	1	1	1
44737	1	1	0	0	0	0	0	0
44738	1	1	0	0	0	0	0	1
44739	1	1	0	0	0	0	1	0
44740	1	1	0	0	0	0	1	1
44741	1	1	0	0	0	1	0	0
44742	1	1	0	0	0	1	0	1
44743	1	1	0	0	0	1	1	0
44744	1	1	0	0	0	1	1	1
44745	1	1	0	0	1	0	0	0
44746	1	1	0	0	1	0	0	1
44747	1	1	0	0	1	0	1	0
44748	1	1	0	0	1	0	1	1
44749	1	1	0	0	1	1	0	0
44750	1	1	0	0	1	1	0	1
44751	1	1	0	0	1	1	1	0
44752	1	1	0	0	1	1	1	1
44753	1	1	0	1	0	0	0	0
44754	1	1	0	1	0	0	0	1
44755	1	1	0	1	0	0	1	0
44756	1	1	0	1	0	0	1	1
44757	1	1	0	1	0	1	0	0
44758	1	1	0	1	0	1	0	1
44759	1	1	0	1	0	1	1	0
44760	1	1	0	1	0	1	1	1
44761	1	1	0	1	1	0	0	0
44762	1	1	0	1	1	0	0	1
44763	1	1	0	1	1	0	1	0
44764	1	1	0	1	1	0	1	1
44765	1	1	0	1	1	1	0	0
44766	1	1	0	1	1	1	0	1
44767	1	1	0	1	1	1	1	0
44768	1	1	0	1	1	1	1	1
44769	1	1	1	0	0	0	0	0
44770	1	1	1	0	0	0	0	1
44771	1	1	1	0	0	0	1	0
44772	1	1	1	0	0	0	1	1
44773	1	1	1	0	0	1	0	0
44774	1	1	1	0	0	1	0	1
44775	1	1	1	0	0	1	1	0
44776	1	1	1	0	0	1	1	1
44777	1	1	1	0	1	0	0	0
44778	1	1	1	0	1	0	0	1
44779	1	1	1	0	1	0	1	0
44780	1	1	1	0	1	0	1	1
44781	1	1	1	0	1	1	0	0
44782	1	1	1	0	1	1	0	1
44783	1	1	1	0	1	1	1	0
44784	1	1	1	0	1	1	1	1
44785	1	1	1	1	0	0	0	0
44786	1	1	1	1	0	0	0	1
44787	1	1	1	1	0	0	1	0
44788	1	1	1	1	0	0	1	1
44789	1	1	1	1	0	1	0	0
44790	1	1	1	1	0	1	0	1
44791	1	1	1	1	0	1	1	0
44792	1	1	1	1	0	1	1	1
44793	1	1	1	1	1	0	0	0
44794	1	1	1	1	1	0	0	1
44795	1	1	1	1	1	0	1	0
44796	1	1	1	1	1	0	1	1
44797	1	1	1	1	1	1	0	0
44798	1	1	1	1	1	1	0	1
44799	1	1	1	1	1	1	1	0
44800	1	1	1	1	1	1	1	1

This previous table is so important for the system because the procedure collects data from this table and will not load on SQL MEMORY (SQL CODE PERFORMANCE)

now its time to release the procedures

These procedures works on VsroPlus filter, but you can handle the procedure to work on your own filter...

First, Adding Dyes to weapon :

PHP Code:


			
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_Add_Dyes]    Script Date: 12/5/2023 11:46:40 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER PROCEDURE [dbo].[_Add_Dyes]
 
 @CharID int,
 @ItemRefID int 

 AS

BEGIN
    SET NOCOUNT ON;
    SET XACT_ABORT ON;

 Declare @Item int = (Select RefItemID from _Items inner join _Inventory on ID64 = ItemID where CharID = @CharID and Slot = 13)
 Declare @Red tinyint = (Select Red from _DyesSystem where ItemID = @Item)
 Declare @Yellow tinyint = (Select yellow from _DyesSystem where ItemID = @Item)
 Declare @Green tinyint = (Select green from _DyesSystem where ItemID = @Item)
 Declare @Violet tinyint = (Select violet from _DyesSystem where ItemID = @Item)
 Declare @Pink tinyint = (Select pink from _DyesSystem where ItemID = @Item)
 Declare @Blue tinyint = (Select blue from _DyesSystem where ItemID = @Item)
 Declare @Black tinyint = (Select black from _DyesSystem where ItemID = @Item)
 Declare @White tinyint = (Select White from _DyesSystem where ItemID = @Item)
 Declare @CharName Varchar(64) = (Select CharName16 from _Char where CharID = @CharID)
 Declare @ItemCodeName Varchar(128)
 if ((@ItemRefID = ADDER_RED_DYE_SCROLL_ID and @Red = 0 ) and Exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
 Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 1)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
 if ((@ItemRefID = ADDER_YELLOW_DYE_SCROLL_ID and @Yellow = 0) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 2)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = ADDER_GREEN_DYE_SCROLL_ID and @Green = 0) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 4)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = ADDER_VIOLET_DYE_SCROLL_ID and @Violet = 0) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 8)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = ADDER_PINK_DYE_SCROLL_ID and @Pink = 0) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 16)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = ADDER_BLUE_DYE_SCROLL_ID and @Blue = 0) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 32)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = ADDER_BLACK_DYE_SCROLL_ID and @Black = 0) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item + 64)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = ADDER_WHITE_DYE_SCROLL_ID and @White = 0 ) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item +128)
 Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
END

Second, Remove Specific Dye:

PHP Code:


			
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_Remove_Dyes]    Script Date: 12/5/2023 11:54:18 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER PROCEDURE [dbo].[_Remove_Dyes]
 
 @CharID int,
 @ItemRefID int 

 AS

BEGIN
    SET NOCOUNT ON;
    SET XACT_ABORT ON;
 Select RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemRefID
 Select CharID from _Char where CharID = @CharID 
 
 Declare @Item int = (Select RefItemID from _Items inner join _Inventory on ID64 = ItemID where CharID = @CharID and Slot = 13)
 Declare @Red tinyint = (Select Red from _DyesSystem where ItemID = @Item)
 Declare @Yellow tinyint = (Select yellow from _DyesSystem where ItemID = @Item)
 Declare @Green tinyint = (Select green from _DyesSystem where ItemID = @Item)
 Declare @Violet tinyint = (Select violet from _DyesSystem where ItemID = @Item)
 Declare @Pink tinyint = (Select pink from _DyesSystem where ItemID = @Item)
 Declare @Blue tinyint = (Select blue from _DyesSystem where ItemID = @Item)
 Declare @Black tinyint = (Select black from _DyesSystem where ItemID = @Item)
 Declare @White tinyint = (Select White from _DyesSystem where ItemID = @Item)
 Declare @CharName Varchar(64) = (Select CharName16 from _Char where CharID = @CharID)
 Declare @ItemCodeName Varchar(128)

 if ((@ItemRefID = REMOVER_RED_DYE_SCROLL_ID and @Red = 1 ) and Exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
  Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 1)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
 if ((@ItemRefID = REMOVER_YELLOW_DYE_SCROLL_ID and @Yellow = 1) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 2)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = REMOVER_GREEN_DYE_SCROLL_ID and @Green = 1) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 4)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = REMOVER_VIOLET_DYE_SCROLL_ID and @Violet = 1) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 8)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = REMOVER_PINK_DYE_SCROLL_ID and @Pink = 1) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 16)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = REMOVER_BLUE_DYE_SCROLL_ID and @Blue = 1) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 32)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = REMOVER_BLACK_DYE_SCROLL_ID and @Black = 1) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 64)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
  if ((@ItemRefID = REMOVER_WHITE_DYE_SCROLL_ID and @White = 1 ) and exists (Select RefItemID from _Items inner join _DyesSystem on _DyesSystem.ItemID = RefItemID inner join _Inventory on ID64=_Inventory.ItemID where CharID = @CharID and Slot = 13  ))
 begin
   Set @ItemCodeName =  (Select CodeName128 from _RefObjCommon where ID = @Item - 128)
  Exec vPlus.._Char_MutateItemAt @CharID,13,@ItemCodeName
 end
END

Don't forget to replace ADDER_XXX_DYE_SCROLL_ID & REMOVER_XXX_DYE_SCROLL_ID with your scrolls ID

Now the system is complete, you can try that by yourself
If you have any questions, dont hesitate to write me

Thanks to all of you and goodluck
My discord : lordoflegendg
or [Dev]LordOfLegend#1555

Judgelemental · 12/05/2023, 13:22

Hi, do you have any pictures?

goldenbird11 · 12/05/2023, 13:50

Quote:

Originally Posted by Judgelemental

Hi, do you have any pictures?

I have a video from my game,
Check it :

T0o0P · 12/05/2023, 17:03

Nice

Fury70 · 12/12/2023, 06:20

Filters already have live switchers now , easy system just table with old/new item codename

goldenbird11 · 12/12/2023, 17:12

Quote:

Originally Posted by Fury70

Filters already have live switchers now , easy system just table with old/new item codename

filters cannot make my system that easy

Focus with my words, my system add 8 different colors (MIXED TOGETHER)
so, for example if you have Twohanded staff Nova D11, You will need to add 256 lines in your _RefObjCommon for that weapon.

Man, without my idea you wouldnt even understand that 8 colors to be mixed together, you will need 256 item of the same weapon to apply such system!
Its a mess

you will 100% do mistakes

if you will use your filter model switcher , how you going to make this ?

for example, if you will mix green, blue and red together on same weapon through filter ? how you are going to do this ?
Do you understand that you will put the previous ItemID and put the new ItemID to work with a specific scroll !

I explained my point of view, now tell me how you will make it on filter? its headache.

b0ykoe · 12/13/2023, 10:51

Quote:

Originally Posted by goldenbird11

filters cannot make my system that easy
Focus with my words, my system add 8 different colors (MIXED TOGETHER)
so, for example if you have Twohanded staff Nova D11, You will need to add 256 lines in your _RefObjCommon for that weapon.

Man, without my idea you wouldnt even understand that 8 colors to be mixed together, you will need 256 item of the same weapon to apply such system!
Its a mess you will 100% do mistakes

if you will use your filter model switcher , how you going to make this ?

for example, if you will mix green, blue and red together on same weapon through filter ? how you are going to do this ?
Do you understand that you will put the previous ItemID and put the new ItemID to work with a specific scroll !

I explained my point of view, now tell me how you will make it on filter? its headache.

Its actually not as hard as you think. You could keep track of the current color / effect of the weapon in a simple structure of the session. Then you just need to send that data to all clients and let the clients keep track of your color / effect. The client could modify the weapon / armor / whatever visually depending on the data it got from the filter.

SubZero** · 12/13/2023, 16:27

Quote:

Originally Posted by goldenbird11

filters cannot make my system that easy
Focus with my words, my system add 8 different colors (MIXED TOGETHER)
so, for example if you have Twohanded staff Nova D11, You will need to add 256 lines in your _RefObjCommon for that weapon.

Man, without my idea you wouldnt even understand that 8 colors to be mixed together, you will need 256 item of the same weapon to apply such system!
Its a mess you will 100% do mistakes

if you will use your filter model switcher , how you going to make this ?

for example, if you will mix green, blue and red together on same weapon through filter ? how you are going to do this ?
Do you understand that you will put the previous ItemID and put the new ItemID to work with a specific scroll !

I explained my point of view, now tell me how you will make it on filter? its headache.

by using org gs func that switch the item live without that complicated sql lines just the slot of the item and the new code name

goldenbird11 · 12/13/2023, 18:12

Quote:

Originally Posted by b0ykoe

Its actually not as hard as you think. You could keep track of the current color / effect of the weapon in a simple structure of the session. Then you just need to send that data to all clients and let the clients keep track of your color / effect. The client could modify the weapon / armor / whatever visually depending on the data it got from the filter.

b0ykoe, words are easy man

without my idea you wouldnt know what color you mix with what color, you will not even remember if you already added these colors or still wanna add, its 256 items

Quote:

Originally Posted by SubZero**

by using org gs func that switch the item live without that complicated sql lines just the slot of the item and the new code name

SubZero**, i already use function mutate item of vsroplus filter but i created this system to make it easier to work than putting previous item code and new item code and scroll item ID

you guys wanna add 4096 lines in live switcher ? and say that its easy to be done ! and that is only for one degree, one star and one model

and think my system of 75 lines SQL code is hard and complex ? xD

This is funny, anyway whoever like to show that my system is useless... don't bother yourself with the system, i already know everything in filters and know what i can do by filter, but anyway thanks for your advice

SubZero** · 12/13/2023, 20:41

Quote:

Originally Posted by goldenbird11

b0ykoe, words are easy man without my idea you wouldnt know what color you mix with what color, you will not even remember if you already added these colors or still wanna add, its 256 items

SubZero**, i already use function mutate item of vsroplus filter but i created this system to make it easier to work than putting previous item code and new item code and scroll item ID

you guys wanna add 4096 lines in live switcher ? and say that its easy to be done ! and that is only for one degree, one star and one model

and think my system of 75 lines SQL code is hard and complex ? xD

This is funny, anyway whoever like to show that my system is useless... don't bother yourself with the system, i already know everything in filters and know what i can do by filter, but anyway thanks for your advice

its not a race at the end, we are creating such a feature to make it easier for those using SQL like yo imagine what we can do.
small hint i dont need to change the item id or anything i can change the item data via the client itself but it will be custom func for that server wanna do prof way of dat.

goldenbird11 · 12/14/2023, 09:45

Quote:

Originally Posted by SubZero**

its not a race at the end, we are creating such a feature to make it easier for those using SQL like yo imagine what we can do.
small hint i dont need to change the item id or anything i can change the item data via the client itself but it will be custom func for that server wanna do prof way of dat.

I want to see in reality, not hear words bro

do this same project with your filter, and show me

b0ykoe · 12/14/2023, 18:07

Quote:

Originally Posted by goldenbird11

b0ykoe, words are easy man without my idea you wouldnt know what color you mix with what color, you will not even remember if you already added these colors or still wanna add, its 256 items

SubZero**, i already use function mutate item of vsroplus filter but i created this system to make it easier to work than putting previous item code and new item code and scroll item ID

you guys wanna add 4096 lines in live switcher ? and say that its easy to be done ! and that is only for one degree, one star and one model

and think my system of 75 lines SQL code is hard and complex ? xD

This is funny, anyway whoever like to show that my system is useless... don't bother yourself with the system, i already know everything in filters and know what i can do by filter, but anyway thanks for your advice

Not sure why you're so mad and why you think you're special in any way but here you go. Its a proof of concept, obviously I could send the packet from the filter to the client.

Not to mention its like 5 lines of code

SubZero** · 12/14/2023, 21:27

Quote:

Originally Posted by b0ykoe

Not sure why you're so mad and why you think you're special in any way but here you go. Its a proof of concept, obviously I could send the packet from the filter to the client.

Not to mention its like 5 lines of code

nope his sys still the best

goldenbird11 · 12/27/2023, 19:40

i'm not proving anything, but at least i post something useful for people, you guys don't see it useful, then its your problem, better keep your opinions for yourself... you posting me a video, great... what people need to do with your video ? people need something to use, not video to watch

and subzero, man i dont expect anything from you, i know you so well, i remember your filter was completely full of bugs and problems, and guess what ? your first version stolen from chernobyl, and you still buy or take files from him.... and don't ask me how i know it

and finally, you guys so smart and amazing, i post my own stuff to help people, you say filters do that ? then i post it for people who don't have filters lol

have a nice day all