[Release] Model Switcher

[Eslam Galull]

my Crapyy Code was working on Galullians & yea it will work with you to



- AddLogItem

  if (@ItemRefID = 43054)
  BEGIN
  EXEC SRO_VT_SHARDLOG.dbo._NOVA_SWITCHER  @CharID
  END

- Query

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  StoredProcedure [dbo].[_NOVA_SWITCHER]    Script Date: 6/6/2015 2:42:04 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

/****** Object:  StoredProcedure [dbo].[_NOVA_SWITCHER]    Script Date: 6/6/2015 8:10:36 AM ******/

CREATE PROCEDURE [dbo].[_NOVA_SWITCHER] 
-- ============================================= 
/*
Eslam Galull
*/
-- ============================================= 
  @CharID INT 


AS 
BEGIN 
--//---------------------------------------------------------------   
    

	DECLARE @INVSIZE TINYINT,
				@Top1Wep int,
				@OldItm int 
	
		Set @InvSize = (select InventorySize from sro_vt_shard.._char where charid = @charid)
		set @Top1Wep = (select top 1 inv.itemid from sro_vt_shard.._inventory inv inner join sro_vt_shard.._items itm on inv.itemid = itm.id64
			where itm.refitemid in (select ItemID from _ModelSwitcher) and itm.serial64 > 0 and inv.itemid <> 0 and inv.slot between 13 and @InvSize and inv.charid = @charid )
		Set @OldItm = (select top 1 refitemid from sro_vt_shard.._items where id64 <> 0 and id64 = @Top1Wep and serial64 > 0)
	if @Top1Wep > 0
	Begin
		Declare @NewItm int = case
			When @olditm in (select ItemID from _ModelSwitcher)
				then (select top 1 Newitemid from _ModelSwitcher where ItemID = @olditm )
		 end /* will destroy any item that he tries to switch if he dont have required items */
		update sro_vt_shard.._items set RefItemID = @NewItm   where RefItemID = @OldItm and ID64 = @Top1Wep and Serial64 > 0
	End

	END


GO

- table ( so here u should put the olditem id .. and the new one id ) thats all

like that

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_ModelSwitcher]    Script Date: 6/6/2015 2:43:23 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ModelSwitcher](
	[ItemID] [int] NOT NULL,
	[ItemCode] [varchar](max) NOT NULL,
	[NewitemID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[Hamza FiGo]

Thanks alot soul.

[imTormentor]

keep up

[salah15]

is this a message system ? @its.soul

[Eslam Galull]

No Dude its a

[Release] Model Switcher

[Syloxx]

its a upgrade system and not a model switcher

model switcher works like this:
-you are able to switch a Item (Glavie in this case) in different degrees not only "upgrade" to a static item.
-there should be 1 Scroll for every degree only (Model Switcher D1, Model Switcher D2 etc) NOT (Model Switcher D1 (Glavie), Model Switcher D1 (Bow) etc)

this isnt possible with your system and btw a better version of this upgrade system is already released by me

[Eslam Galull]

Originally Posted by Syloxx

its a upgrade system and not a model switcher

model switcher works like this:
-you are able to switch a Item (Glavie in this case) in different degrees not only "upgrade" to a static item.
-there should be 1 Scroll for every degree only (Model Switcher D1, Model Switcher D2 etc) NOT (Model Switcher D1 (Glavie), Model Switcher D1 (Bow) etc)

this isnt possible with your system and btw a better version of this upgrade system is already released by me

1. it doesn't matter the owner will just put the new model ID in table !
2. it already a 1 Scroll

if (@ItemRefID = 43054)
BEGIN
EXEC SRO_VT_SHARDLOG.dbo._NOVA_SWITCHER @CharID
END

at the end the query nt the perfect nd i told ppl that in the main thread ..

my Crapyy Code was working on Galullians & yea it will work with you to

so if you wanna help ( not just flame ) share your perfect one !

[Syloxx]

Originally Posted by its.soul

so if you wanna help ( not just flame ) share your perfect one !

thats what i just did in the post approve?

[Eslam Galull]

after the skype conference ..

yea you are right its a ****

[kareemzone]

good job

[​Exo]

I guess I released this thing some months ago, it's an actual Model Switch. Pretty faster as well.

[spinal2]

That Release Change Item IMG to news one only or Change all item status ?

[**Lost_Hunter**]

i think this already released

[Mody13337]

Good job

[spinal2]

Base in @ItsSoul Release . iam Start Work in a Model Swith Same Elamidas Itens .
So, Well actualy Iam Study Elamidas Engine and see alots Things Goods ..

Well See me Work based in @itsSoul Release and Elamidas ENGINE .

Model Swith