estuve intentando personalizar stats e items iniciales en cada raza distinta pero al modificar inventario o skills iniciales el personaje ya no carga y queda pantalla negra , ademas al intentar crear nuevos personajes despues de eso dice que ya existe pj con ese nombre
pude personalizar la query de forma general , stats iniciales , resets y esas cosas pero con skills e inventario no hay forma
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'Bonus' AND type = 'TR')
DROP TRIGGER Bonus
GO
CREATE TRIGGER Bonus ON Dbo.Character FOR INSERT
AS
BEGIN
DECLARE
@FuerzaBK smallint,@AgilidadBK smallint,@VitalidadBK smallint,@EnergiaBK smallint,
@FuerzaSM smallint,@AgilidadSM smallint,@VitalidadSM smallint,@EnergiaSM smallint,
@FuerzaELF smallint,@AgilidadELF smallint,@VitalidadELF smallint,@EnergiaELF smallint,
@FuerzaMG smallint,@AgilidadMG smallint,@VitalidadMG smallint,@EnergiaMG smallint,
@InvenBK varbinary(760),@InvenSM varbinary(760),@InvenELF varbinary(760),@InvenMG varbinary(760),
@SkillBK varbinary(60),@SkillSM varbinary(60),@SkillELF varbinary(60),@SkillMG varbinary(60),
@Zen INT,
@Char varchar(10),
@PK int,
@quest varbinary(50),
@Tipo tinyint
SELECT @Char = Name FROM INSERTED
SELECT @Tipo = Class FROM INSERTED
--bk class= 16
--sm class= 0
--elf class= 32
--mg class= 48
SET @FuerzaSM = 10 --
SET @AgilidadSM = 15 --
SET @VitalidadSM = 5 --
SET @EnergiaSM = 30 --
SET @FuerzaBK = 30 --
SET @AgilidadBK = 15 --
SET @VitalidadBK = 5 --
SET @EnergiaBK = 10 --
SET @FuerzaELF = 10 --
SET @AgilidadELF = 30 --
SET @VitalidadELF = 5 --
SET @EnergiaELF = 15 --
SET @FuerzaMG = 20 --
SET @AgilidadMG = 15 --
SET @VitalidadMG = 5 --
SET @EnergiaMG = 20 --
SET @SkillBK = 0x290000FF0000FF0000FF0000F0000FF0000...........
SET @SkillSM = 0x110000FF0000FF0000FF0000FF0000FF000...........
SET @SkillMG = 0X110000290000FF0000FF0000FF0000FF00............
SET @SkillELF = 0x1A00001B00001C0000FF0000FF0000FF00...........
SET @InvenMG = 0x20001200003C7E000100C0001600003C81003907FFFFFFFFFFFFFF
SET @InvenBK = 0x01001600000000000100C0001600000000003907FFFFFFFFFFFFFFF
SET @InvenSM = 0xA000FF00000000000000C000FF00000000000000FFFFFFFFFFFFFFF
SET @InvenELF = 0x8F00FF0000000000000080801400003CC8000000FFFFFFFFFFFFFFF
SET
@quest= 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
SET @PK= -100
SET @Zen = 1000000 -- Cantidad de zen
if (@Tipo = 0)
begin
UPDATE Dbo.Character
SET Strength = @FuerzaSM,Dexterity = @AgilidadSM, Vitality = @VitalidadSM, Energy = @EnergiaSM, Money = @zen, Inventory= @InvenSM, MagicList= @SkillSM, Quest=
@quest, PkTime= @PK
WHERE Name = @Char and Class = 0
end
else if (@Tipo = 16)
begin
UPDATE Dbo.Character
SET Strength = @FuerzaBK,Dexterity = @AgilidadBK, Vitality = @VitalidadBK, Energy = @EnergiaBK, Money = @zen, Inventory= @InvenBK, MagicList= @SkillBK, Quest=
@quest, PkTime= @PK
WHERE Name = @Char and Class = 16
end
else if (@Tipo = 32)
begin
UPDATE Dbo.Character
SET Strength = @FuerzaELF,Dexterity = @AgilidadELF, Vitality = @VitalidadELF, Energy = @EnergiaELF, Money = @zen, Inventory= @InvenELF, MagicList= @SkillELF, Quest=
@quest, PkTime= @PK
WHERE Name = @Char and Class = 32
end
else
begin
UPDATE Dbo.Character
SET Strength = @FuerzaMG,Dexterity = @AgilidadMG, Vitality = @VitalidadMG, Energy = @EnergiaMG, Money = @zen, Inventory= @InvenMG, MagicList= @SkillMG, Quest=
@quest, PkTime= @PK
WHERE Name = @Char and Class = 48
end
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Home
TOP Ranking MU
Magichand
Fanpage
Tags
Login
Register
Topic: AYUDA CON QUERY 97D DARKSTEAM (Visto 402 veces)
April 23, 2020, 04:21:25 PM