HOW to Changed DK/PL Transformation CD time

[huhu521bt5]

HOW to Changed DK/PL Transformation CD time from 1hr to 10 mins....

can anyone help and tell me how to change it?


thanks!!

[MentaL]

[huhu521bt5]

no one answer.....thanks..

[dontknown]

dbo.Vocation contains a column that holds the last time one used transskill. There's no stored procedues targeting that database, your best bet is modifying that column everytime you use trans, which is a pain.

A simple hack would be changing this value everytime one uses transskill, allowing to use trans 1 time on every map with no cooldown. I did this trigger script, however I can't test it right now.

Run this as a query on MSSQL database (untested)

USE [heroes]
GO

/****** Object:  Trigger [dbo].[noTransCD]    Script Date: 10/21/2016 12:06:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[noTransCD] ON [dbo].[Vocation]
FOR UPDATE
AS
	declare @Cid int;

	select @Cid=i.CID from inserted i;	
	
	UPDATE dbo.Vocation SET LastTransform = '2000-01-01' WHERE CID = @Cid;



GO

[huhu521bt5]

thank you so much！this may works great ！ i will try to test it if it works！

[dontknown]

Just tested my script. Pushing retry doesn't refresh trans, but making a new boat DOES. As a side effect, you get 0 trans exp, but since it's a private for test purposes it doesn't matter.

[huhu521bt5]

Just tested my script. Pushing retry doesn't refresh trans, but making a new boat DOES. As a side effect, you get 0 trans exp, but since it's a private for test purposes it doesn't matter.

yes it dosent matter, just a test and i can set the trans exp with lv1=lv10 etc lol keep trying !!