Register for your free account! | Forgot your password?

You last visited: Today at 23:06

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Español / Ingles Script auto

Discussion on Español / Ingles Script auto within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2012
Posts: 35
Received Thanks: 11
Español / Ingles Script auto

En español

Buen día Chicos, hace años vengo desarrollando mis propios Scrips mas que nada de SQL server y sitios Webs con PHP ahora me dedico y vendo servidores de shaiya, por aquí dejare un script de mi propiedad que debí liberar yo pero otra persona llamada jhon Jairo Arias publico (Libero), sin MI consentimiento, si quieren algo nuevo pueden escribirme vía whatsapp +584169256098 yo vendo servidores de shaiya en createsoftw.com scripts de CT SQL todo lo relacionado a shaiya si comparten no quiten mi SELLO de autor de los scripts por favor que de esto llevo de comer a mi casa la conciencia es importante gracias.

A continuación dejo este script que se encarga de equipar los personajes entren con set Encantado recreado o Link de lápices. útil para todas las razas asi mismo también se le pueden poner consumibles a gusto.

In English

Good morning Guys, years ago I have been developing my own Scrips more than anything about SQL server and websites with PHP now I dedicate myself and sell shaiya servers, here I will leave a script of my own that I should have released but another person named jhon Jairo Arias public (Libero), without MY consent, if you want something new you can write me via whatsapp +584169256098 I sell shaiya servers in createsoftw.com CT SQL scripts everything related to shaiya if you share do not remove my author SEAL from the scripts please that from this I bring to eat home consciousness is important thanks.

Next I leave this script that is responsible for equipping the characters enter with recreated Enchanted set or Pencil Link. Useful for all breeds as well can also be put consumables at ease.

Quote:
USE [PS_GameData]
GO
/****** Object: Trigger [dbo].[Equipar] Script Date: 02/17/2021 09:46:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =========================================
-- Diseño = [DEV]Juan
-- Fecha 23-9-2016
-- Auto Equipar Personajes en Shaiya
-- Wahtsapp +584169256098
-- Web Site: Createsoftw.com
-- NOTA: Comparte pero no borres esta linea es importante para mi gracias, de esto trabajo
-- Mas Scripts a continuacion en mis hilos como jvczxc hechos TODOS por mi persona como autor.
-- =========================================
CREATE TRIGGER [dbo].[Equipar]
ON [dbo].[Chars]
After INSERT
AS
DECLARE
@CharID INT,
@Gue_Family INT,
@Gue_Job INT,
@Gua_Family INT,
@Gua_Job INT,
@Caz_Family INT,
@Caz_Job INT,
@Pag_Family INT,
@Pag_Job INT,
@Ase_Family INT,
@Ase_Job INT,
@Ora_Family INT,
@Ora_Job INT,
@Luc_Family INT,
@Luc_Job INT,
@Def_Family INT,
@Def_Job INT,
@Cur_Family INT,
@Cur_Job INT,
@Arq_Family INT,
@Arq_Job INT,
@Ran_Family INT,
@Ran_Job INT,
@Mag_Family INT,
@Mag_Job INT,
-- Sets a colocar
--Guerrer-Guardian
@Casco_Raza_Gue_Gua int = 31001,
@Casco_Type_Raza_Gue_Gua int = 31,
@Casco_TypeID_Raza_Gue_Gua int = 1,

@Top_Raza_Gue_Gua int = 32002,
@Top_Type_Raza_Gue_Gua int = 32,
@Top_TypeID_Raza_Gue_Gua int = 2,

@Medias_Raza_Gue_Gua int = 33002,
@Medias_Type_Raza_Gue_Gua int = 33,
@Medias_TypeID_Raza_Gue_Gua int = 2,

@Guantes_Raza_Gue_Gua int = 35002,
@Guantes_Type_Raza_Gue_Gua int = 35,
@Guantes_TypeID_Raza_Gue_Gua int = 2,

@Zapatos_Raza_Gue_Gua int = 36002,
@Zapatos_Type_Raza_Gue_Gua int = 36,
@Zapatos_TypeID_Raza_Gue_Gua int = 2,

@Casco_Raza_Ase_Caz int = 31084,
@Casco_Type_Raza_Ase_Caz int = 31,
@Casco_TypeID_Raza_Ase_Caz int = 84,

@Top_Raza_Ase_Caz int = 32087,
@Top_Type_Raza_Ase_Caz int = 32,
@Top_TypeID_Raza_Ase_Caz int = 87,

@Medias_Raza_Ase_Caz int = 33087,
@Medias_Type_Raza_Ase_Caz int = 33,
@Medias_TypeID_Raza_Ase_Caz int = 87,

@Guantes_Raza_Ase_Caz int = 35087,
@Guantes_Type_Raza_Ase_Caz int = 35,
@Guantes_TypeID_Raza_Ase_Caz int = 87,

@Zapatos_Raza_Ase_Caz int = 36087,
@Zapatos_Type_Raza_Ase_Caz int = 36,
@Zapatos_TypeID_Raza_Ase_Caz int = 87,

@Casco_Raza_Pag_Ora int = 31171,
@Casco_Type_Raza_Pag_Ora int = 31,
@Casco_TypeID_Raza_Pag_Ora int = 171,

@Top_Raza_Pag_Ora int = 32172,
@Top_Type_Raza_Pag_Ora int = 32,
@Top_TypeID_Raza_Pag_Ora int = 172,

@Medias_Raza_Pag_Ora int = 33172,
@Medias_Type_Raza_Pag_Ora int = 33,
@Medias_TypeID_Raza_Pag_Ora int = 172,

@Guantes_Raza_Pag_Ora int = 35172,
@Guantes_Type_Raza_Pag_Ora int = 35,
@Guantes_TypeID_Raza_Pag_Ora int = 172,

@Zapatos_Raza_Pag_Ora int = 36172,
@Zapatos_Type_Raza_Pag_Ora int = 36,
@Zapatos_TypeID_Raza_Pag_Ora int = 172,
-- Sets de Luz
@Casco_Raza_Luc_Def int = 16001,
@Casco_Type_Raza_Luc_Def int = 16,
@Casco_TypeID_Raza_Luc_Def int = 1,

@Top_Raza_Luc_Def int = 17002,
@Top_Type_Raza_Luc_Def int = 17,
@Top_TypeID_Raza_Luc_Def int = 2,

@Medias_Raza_Luc_Def int = 18002,
@Medias_Type_Raza_Luc_Def int = 18,
@Medias_TypeID_Raza_Luc_Def int = 2,

@Guantes_Raza_Luc_Def int = 20002,
@Guantes_Type_Raza_Luc_Def int = 20,
@Guantes_TypeID_Raza_Luc_Def int = 2,

@Zapatos_Raza_Luc_Def int = 21002,
@Zapatos_Type_Raza_Luc_Def int = 21,
@Zapatos_TypeID_Raza_Luc_Def int = 2,

@Casco_Raza_Ran_Arq int = 16084,
@Casco_Type_Raza_Ran_Arq int = 16,
@Casco_TypeID_Raza_Ran_Arq int = 84,

@Top_Raza_Ran_Arq int = 17087,
@Top_Type_Raza_Ran_Arq int = 17,
@Top_TypeID_Raza_Ran_Arq int = 87,

@Medias_Raza_Ran_Arq int = 18087,
@Medias_Type_Raza_Ran_Arq int = 18,
@Medias_TypeID_Raza_Ran_Arq int = 87,

@Guantes_Raza_Ran_Arq int = 20087,
@Guantes_Type_Raza_Ran_Arq int = 20,
@Guantes_TypeID_Raza_Ran_Arq int = 87,

@Zapatos_Raza_Ran_Arq int = 21087,
@Zapatos_Type_Raza_Ran_Arq int = 21,
@Zapatos_TypeID_Raza_Ran_Arq int = 87,

@Casco_Raza_Mag_Cur int = 16171,
@Casco_Type_Raza_Mag_Cur int = 16,
@Casco_TypeID_Raza_Mag_Cur int = 171,

@Top_Raza_Mag_Cur int = 17172,
@Top_Type_Raza_Mag_Cur int = 17,
@Top_TypeID_Raza_Mag_Cur int = 172,

@Medias_Raza_Mag_Cur int = 18172,
@Medias_Type_Raza_Mag_Cur int = 18,
@Medias_TypeID_Raza_Mag_Cur int = 172,

@Guantes_Raza_Mag_Cur int = 20172,
@Guantes_Type_Raza_Mag_Cur int = 20,
@Guantes_TypeID_Raza_Mag_Cur int = 172,

@Zapatos_Raza_Mag_Cur int = 21172,
@Zapatos_Type_Raza_Mag_Cur int = 21,
@Zapatos_TypeID_Raza_Mag_Cur int = 172,

-- Escudo Furia
@escudo_Gua int = 34002,
@Type_escudo_Gua int = 34,
@TypeID_escudo_Gua int = 2,

-- Escudo Luz
@escudo_Def int = 19002,
@Type_escudo_Def int = 19,
@TypeID_escudo_Def int = 2,



-- Armas Furia a colocar
@Arma_Gue int = 5007,
@Type_Arma_Gue int = 5,
@TypeID_Arma_Gue int = 7,

@Arma_Gua int = 7007,
@Type_Arma_Gua int = 7,
@TypeID_Arma_Gua int = 7,

@Arma_Caz int = 13007,
@Type_Arma_Caz int = 13,
@TypeID_Arma_Caz int = 7,

@Arma_Ase int = 9002,
@Type_Arma_Ase int = 9,
@TypeID_Arma_Ase int = 2,

@Arma_Pag int = 12007,
@Type_Arma_Pag int = 12,
@TypeID_Arma_Pag int = 7,

@Arma_Ora int = 12007,
@Type_Arma_Ora int = 12,
@TypeID_Arma_Ora int = 7,

-- Armas Luz a colocar
@Arma_Luc int = 5002,
@Type_Arma_Luc int = 5,
@TypeID_Arma_Luc int = 2,

@Arma_Def int = 7002,
@Type_Arma_Def int = 7,
@TypeID_Arma_Def int = 2,

@Arma_Arq int = 13002,
@Type_Arma_Arq int = 13,
@TypeID_Arma_Arq int = 2,

@Arma_Ran int = 9002,
@Type_Arma_Ran int = 9,
@TypeID_Arma_Ran int = 2,

@Arma_Mag int = 12002,
@Type_Arma_Mag int = 12,
@TypeID_Arma_Mag int = 2,

@Arma_Cur int = 12002,
@Type_Arma_Cur int = 12,
@TypeID_Arma_Cur int = 2,


-- Consumibles

x@Consumible_1 int = 100091,
x@Type_Consumible_1 int = 100,
x@TypeID_Consumible_1 int = 91,
@car_1 INT = 1,
--cantidad 15

x@Consumible_2 int = 44225,
x@Type_Consumible_2 int = 44,
x@TypeID_Consumible_2 int = 225,
@car_2 INT = 1,
--cantidad 5

x@Consumible_3 int = 100074,
x@Type_Consumible_3 int = 100,
x@TypeID_Consumible_3 int = 74,
@car_3 INT = 1,
--cantidad 1

x@Consumible_4 int = 100053,
x@Type_Consumible_4 int = 100,
x@TypeID_Consumible_4 int = 53,
@car_4 INT = 1,

--cantidad 1
@Consumible_5 int = 100229,
@Type_Consumible_5 int = 100,
@TypeID_Consumible_5 int = 229
@car_5 INT = 1,

--cantidad 1
@Consumible_6 int = 100081,
@Type_Consumible_6 int = 100,
@TypeID_Consumible_6 int = 81,
@car_6 INT = 255

DECLARE
@UserUID INT

SET @CharID = (SELECT TOP 1 CharID FROM INSERTED)
SET @UserUID=(SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
SET @Gue_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 3)
SET @Gue_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 0)
SET @Gua_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 3)
SET @Gua_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 1)
SET @Caz_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 3)
SET @Caz_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 3)
SET @Pag_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 2)
SET @Pag_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 4)
SET @Ase_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 2)
SET @Ase_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 2)
SET @Ora_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 2)
SET @Ora_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 5)
SET @Luc_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 0)
SET @Luc_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 0)
SET @Def_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 0)
SET @Def_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 1)
SET @Cur_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 0)
SET @Cur_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 5)
SET @Arq_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 1)
SET @Arq_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 3)
SET @Ran_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 1)
SET @Ran_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 2)
SET @Mag_Family = (SELECT TOP 1 Family FROM INSERTED WHERE Family = 1)
SET @Mag_Job = (SELECT TOP 1 Job FROM INSERTED WHERE Job = 4)
----------------------------------------------------------------------------------------------------------------------------------------------------
--Guerrero
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Gue_Family and Job = @Gue_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
-- Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
-- Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Gue , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Gue, @TypeID_Arma_Gue , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Gue_Gua , @Casco_TypeID_Raza_Gue_Gua , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Gue_Gua , @Top_TypeID_Raza_Gue_Gua , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Gue_Gua , @Medias_TypeID_Raza_Gue_Gua , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Gue_Gua, @Guantes_TypeID_Raza_Gue_Gua , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Gue_Gua, @Zapatos_TypeID_Raza_Gue_Gua , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
--------------------------------------------------------------------------------------------------------------------
ELSE
--Guardian
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Gua_Family and Job = @Gua_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
-- Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Gua, @TypeID_Arma_Gua , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Gue_Gua , @Casco_TypeID_Raza_Gue_Gua , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Gue_Gua , @Top_TypeID_Raza_Gue_Gua , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Gue_Gua , @Medias_TypeID_Raza_Gue_Gua , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Gue_Gua, @Guantes_TypeID_Raza_Gue_Gua , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Gue_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Gue_Gua, @Zapatos_TypeID_Raza_Gue_Gua , '0' , '4' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @escudo_Gua , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_escudo_Gua, @TypeID_escudo_Gua , '0' , '4' , '1800' , '0' , '0' , '106' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Cazador
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Caz_Family and Job = @Caz_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Caz, @TypeID_Arma_Caz , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Ase_Caz , @Casco_TypeID_Raza_Ase_Caz , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Ase_Caz , @Top_TypeID_Raza_Ase_Caz , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Ase_Caz , @Medias_TypeID_Raza_Ase_Caz , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Ase_Caz, @Guantes_TypeID_Raza_Ase_Caz , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Ase_Caz, @Zapatos_TypeID_Raza_Ase_Caz , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Acesino
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Ase_Family and Job = @Ase_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Ase , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Ase, @TypeID_Arma_Ase , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Ase_Caz , @Casco_TypeID_Raza_Ase_Caz , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Ase_Caz , @Top_TypeID_Raza_Ase_Caz , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Ase_Caz , @Medias_TypeID_Raza_Ase_Caz , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Ase_Caz, @Guantes_TypeID_Raza_Ase_Caz , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Ase_Caz , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Ase_Caz, @Zapatos_TypeID_Raza_Ase_Caz , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Pagano
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Pag_Family and Job = @Pag_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Pag , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Pag, @TypeID_Arma_Pag , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Pag_Ora , @Casco_TypeID_Raza_Pag_Ora , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Pag_Ora , @Top_TypeID_Raza_Pag_Ora , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Pag_Ora , @Medias_TypeID_Raza_Pag_Ora , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Pag_Ora, @Guantes_TypeID_Raza_Pag_Ora , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Pag_Ora, @Zapatos_TypeID_Raza_Pag_Ora , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Oraculo
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Ora_Family and Job = @Ora_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Ora, @TypeID_Arma_Ora , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Pag_Ora , @Casco_TypeID_Raza_Pag_Ora , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Pag_Ora , @Top_TypeID_Raza_Pag_Ora , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Pag_Ora , @Medias_TypeID_Raza_Pag_Ora , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Pag_Ora, @Guantes_TypeID_Raza_Pag_Ora , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Pag_Ora , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Pag_Ora, @Zapatos_TypeID_Raza_Pag_Ora , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Luchador
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Luc_Family and Job = @Luc_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Luc , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Luc, @TypeID_Arma_Luc , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Luc_Def , @Casco_TypeID_Raza_Luc_Def , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Luc_Def , @Top_TypeID_Raza_Luc_Def , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Luc_Def , @Medias_TypeID_Raza_Luc_Def , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Luc_Def, @Guantes_TypeID_Raza_Luc_Def , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Luc_Def, @Zapatos_TypeID_Raza_Luc_Def , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Defensor
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Def_Family and Job = @Def_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Def, @TypeID_Arma_Def , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Luc_Def , @Casco_TypeID_Raza_Luc_Def , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Luc_Def , @Top_TypeID_Raza_Luc_Def , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Luc_Def , @Medias_TypeID_Raza_Luc_Def , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Luc_Def, @Guantes_TypeID_Raza_Luc_Def , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Luc_Def , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Luc_Def, @Zapatos_TypeID_Raza_Luc_Def , '0' , '4' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @escudo_DeF , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_escudo_Def, @TypeID_escudo_Def , '0' , '4' , '1800' , '0' , '0' , '106' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Arquero
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Arq_Family and Job = @Arq_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Arq, @TypeID_Arma_Arq , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Ran_Arq , @Casco_TypeID_Raza_Ran_Arq , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Ran_Arq , @Top_TypeID_Raza_Ran_Arq , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Ran_Arq , @Medias_TypeID_Raza_Ran_Arq , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Ran_Arq, @Guantes_TypeID_Raza_Ran_Arq , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Ran_Arq, @Zapatos_TypeID_Raza_Ran_Arq , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Ranger
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Ran_Family and Job = @Ran_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
-- Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Ran , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Ran, @TypeID_Arma_Ran , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Ran_Arq , @Casco_TypeID_Raza_Ran_Arq , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Ran_Arq , @Top_TypeID_Raza_Ran_Arq , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Ran_Arq , @Medias_TypeID_Raza_Ran_Arq , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Ran_Arq, @Guantes_TypeID_Raza_Ran_Arq , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Ran_Arq , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Ran_Arq, @Zapatos_TypeID_Raza_Ran_Arq , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Magos
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Mag_Family and Job = @Mag_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Mag , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Mag, @TypeID_Arma_Mag , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Mag_Cur , @Casco_TypeID_Raza_Mag_Cur , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Mag_Cur , @Top_TypeID_Raza_Mag_Cur , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Mag_Cur , @Medias_TypeID_Raza_Mag_Cur , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Mag_Cur, @Guantes_TypeID_Raza_Mag_Cur , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Mag_Cur, @Zapatos_TypeID_Raza_Mag_Cur , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
---------------------------------------------------------------------------------------------------------------------------------------
ELSE
--Sacerdote
IF EXISTS (SELECT TOP 1 CharID FROM INSERTED WHERE Family = @Cur_Family and Job = @Cur_job and CharID = @CharID)
BEGIN
-- Borrado de inventarios
DELETE PS_GameData.dbo.CharItems WHERE CharID = @CharID
--Consumibles
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID], [ItemID] , [ItemUID], [Type], [TypeID], [Bag], [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname], [Count], [Maketime], [Maketype], [Del]) VALUES
(@CharID, @Consumible_1 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_1, @TypeID_Consumible_1 , '1' , '1' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_1, GETDATE(), 'F', '0'),
(@CharID, @Consumible_2 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_2, @TypeID_Consumible_2 , '1' , '2' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_2, GETDATE(), 'F', '0'),
(@CharID, @Consumible_3 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_3, @TypeID_Consumible_3 , '1' , '3' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_3, GETDATE(), 'F', '0'),
(@CharID, @Consumible_4 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_4, @TypeID_Consumible_4 , '1' , '4' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_4, GETDATE(), 'F', '0'),
(@CharID, @Consumible_5 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_5, @TypeID_Consumible_5 , '1' , '5' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_5, GETDATE(), 'F', '0'),
(@CharID, @Consumible_6 , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Consumible_6, @TypeID_Consumible_6 , '1' , '6' , '0', '0' , '0', '0' , '0', '0' , '0' , '', @car_6, GETDATE(), 'F', '0');
--Arma
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES (@CharID , @Arma_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Type_Arma_Cur, @TypeID_Arma_Cur , '0' , '5' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080800000020', '1' , GETDATE() , 'F' , '0');
--Armadura
INSERT INTO [PS_GameData].[dbo].[CharItems]
([CharID] , [ItemID] , [ItemUID] , [Type] , [TypeID] , [Bag] , [Slot], [Quality] , [Gem1], [Gem2], [Gem3], [Gem4], [Gem5], [Gem6], [Craftname] , [Count] , [Maketime], [Maketype], [Del])
VALUES
(@CharID , @Casco_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Casco_Type_Raza_Mag_Cur , @Casco_TypeID_Raza_Mag_Cur , '0' , '0' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Top_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Top_Type_Raza_Mag_Cur , @Top_TypeID_Raza_Mag_Cur , '0' , '1' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Medias_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Medias_Type_Raza_Mag_Cur , @Medias_TypeID_Raza_Mag_Cur , '0' , '2' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Guantes_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Guantes_Type_Raza_Mag_Cur, @Guantes_TypeID_Raza_Mag_Cur , '0' , '3' , '1800' , '0' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0'),
(@CharID , @Zapatos_Raza_Mag_Cur , ABS(BINARY_CHECKSUM(NEWID()))+(1000000000000000000 +0000000000000000001) +100000000000000000 , @Zapatos_Type_Raza_Mag_Cur, @Zapatos_TypeID_Raza_Mag_Cur , '0' , '4' , '1800' , '106' , '0' , '0' , '0' , '0' , '0' , '08080808080808080870', '1' , GETDATE() , 'F' , '0');
END
jvczxc is offline  
Thanks
2 Users
Reply

« Shaiya Anti Cheat | banear per time is update for leavejoin »

Similar Threads Similar Threads
Hola me gustaria tener mi servidor de shaiya pero todo esta en ingles
02/25/2013 - Shaiya Private Server - 7 Replies
bueno nesecito crear mi servidor de shaiya me ayudarias a tenerlo esque e bucado mucho pero no e octenido : RTFM: nada nececito un tutorial si me quieres contactar aqui dejo mi skype porfavor ayudarme SKYPE:gamer-united o a este :thegameplayspro o por hotmail: [email protected] esque tambien lo e bucado en ingles y va todo bien ecepto una parte y no se que hacer entonces si me dejan un tutorial pues entendere y de todo corazon les pido un tutoriaL que me lo...
INGLES Juegan Un Rato Y Luego No Pueden Entrar ayuda
05/10/2010 - Metin2 Private Server - 1 Replies
ensiende every time the server is there at 4 bugue hours and keeps out all the server does not let them go out again if not until restart the server, leaving mistakes when connecting and SEND server is in the server image is after a bit of Ensenada http://img341.imageshack.us/img341/3901/presentac in1my.jpg
Alguien sabe algun server pirata que hablen español? o ingles?
04/27/2008 - Conquer Online 2 - 1 Replies
Hola soi jugador español, me gustaria saber de alguien que me ayude a instalar algun server pirata de conquista ^^ alguien es tan amable?



All times are GMT +1. The time now is 23:07.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.