Auto Equip Item When Create Char

[SnickQ]

Or

USE PS_GameData
GO
CREATE VIEW NewID
AS
SELECT NewID() AS NewID

USE [PS_GameData]
GO

/****** Object:  UserDefinedFunction [dbo].[ItemUID]    Script Date: 31.07.2013 00:03:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Euphoria Dev Team
-- =============================================
CREATE FUNCTION [dbo].[ItemUID]
()
RETURNS BIGINT
AS
BEGIN
	
	DECLARE [MENTION=1134588]item[/MENTION]UID BIGINT

	NEWUID:
	SET [MENTION=1134588]item[/MENTION]UID = ABS(CAST(HASHBYTES('SHA1',CAST((SELECT NewID FROM PS_GameData.dbo.NewID) AS NVARCHAR(MAX))) AS BIGINT))

	IF EXISTS(SELECT * FROM PS_GameData.dbo.CharItems WHERE ItemUID = [MENTION=1134588]item[/MENTION]UID) OR
	EXISTS(SELECT * FROM PS_GameData.dbo.GuildStoredItems WHERE ItemUID = [MENTION=1134588]item[/MENTION]UID) OR
	EXISTS(SELECT * FROM PS_GameData.dbo.MarketItems WHERE ItemUID = [MENTION=1134588]item[/MENTION]UID) OR
	EXISTS(SELECT * FROM PS_GameData.dbo.UserStoredItems WHERE ItemUID = [MENTION=1134588]item[/MENTION]UID)
	GOTO NEWUID

	RETURN [MENTION=1134588]item[/MENTION]UID

END
GO

And put in Proc [dbo].[usp_Create_Char_R]

if (@Job in (0,1,2,3) and [MENTION=395373]Chari[/MENTION]D [MENTION=395373]Chari[/MENTION]D )
	begin
	
	INSERT INTO CharItems (CharID, ItemID, ItemUID, Type, TypeID, Bag, Slot, Quality, Gem1, Gem2, Gem3, Gem4, Gem5, Gem6, Craftname, Count, Maketime, Maketype, Del)
			VALUES  [MENTION=395373]Chari[/MENTION]D, 16004 , dbo.ItemUID(), 16, 4, 1, 1, (SELECT Quality FROM PS_GameDefs.dbo.Items WHERE ItemID = 16004), 5, 33, 12, 0, 0, 0, '05050505050505050555', 1, GETDATE(), 'S', 0)

Credits for Phillip