[for fun] double click to remove this buff ?

09/17/2018 16:16 claro28111#1
helloz guys ;), i was away for a very long time like 3-4 years and i got my local 9.4 with friends and i was modding the server to be as crazy as we want and i was wondering if we can make any buff effect canceled by double click on it's icon like this buff (buff id 41529)

[Only registered and activated users can see links. Click Here To Register...]
09/17/2018 17:36 InkDevil#2
Quote:
Originally Posted by claro28111 View Post
helloz guys ;), i was away for a very long time like 3-4 years and i got my local 9.4 with friends and i was modding the server to be as crazy as we want and i was wondering if we can make any buff effect canceled by double click on it's icon like this buff (buff id 41529)

[Only registered and activated users can see links. Click Here To Register...]
Code:
UPDATE dbo.StateResource
SET state_time_type = 49
But be careful, that also overwrites worldbuff-time-type, etc.
09/17/2018 17:49 claro28111#3
Quote:
Originally Posted by InkDevil View Post
Code:
UPDATE dbo.StateResource
SET state_time_type = 49
But be careful, that also overwrites worldbuff-time-type, etc.
thank you ;)

Quote:
Originally Posted by InkDevil View Post
Code:
UPDATE dbo.StateResource
SET state_time_type = 49
But be careful, that also overwrites worldbuff-time-type, etc.
look can i edit it manually like i already knew i must coulmn state_time_type in table dbo.StateResource but is the state id is the same is skill id ? or what
09/18/2018 13:14 thefear511#4
Quote:
Originally Posted by claro28111 View Post
thank you ;)



look can i edit it manually like i already knew i must coulmn state_time_type in table dbo.StateResource but is the state id is the same is skill id ? or what
PHP Code:
UPDATE dbo.StateResource
SET state_time_type 
49 where skill_id 50123 
you can use this to mod indivisual skills. or

PHP Code:
UPDATE dbo.StateResource
SET state_time_type 
49 where skill_id 50123 or skill_id=50124 
to edit 2 skills

PHP Code:
UPDATE dbo.StateResource
SET state_time_type 
49 where skill_id between 50123 AND 50129 
to edit multiple skills within the number order.
09/18/2018 23:18 waahaha#5
@[Only registered and activated users can see links. Click Here To Register...] thanks a lot..could you have the other description of state_time_type? and the how to add Superimposed buff ?
10/05/2018 23:35 thefear511#6
Quote:
Originally Posted by waahaha View Post
@[Only registered and activated users can see links. Click Here To Register...] thanks a lot..could you have the other description of state_time_type? and the how to add Superimposed buff ?
sorry i deleted sql and im too lazy to install it, i hope someone else helps you:o.