Unicorn level 150 Skill fix.

[gavsta]

Because I am not able to access the nCarbon Dev forum, I will give MY fix for Unicorn level 150 Skill here, It might already be on nCarbon forum, because I gave it to wisp to put on there, I think she did not 100% sure,

Although I would like to say this is MY fix and I am NOT taking credit for something that isn't my own because it is ^_^ you can tell its ones of my fixes due to layout being noobish but makes skill work! so thats a + side :P

So here you are Enjoy!


Does not work correctly does not give negative on Unicorn as it should do gives positive

 Spoiler

Use Arcadia
update dbo.skillResource
set state_level_base = 0
where id = 45524 
Use Arcadia
update dbo.skillResource
set state_level_per_skl = 1.00
where id = 45524 
Use Arcadia
update dbo.skillResource
set state_level_per_skl = 1.00
where id = 45524 
Use Arcadia
update dbo.skillResource
set var1 = 0.000
where id = 45524 
Use Arcadia
update dbo.skillResource
set var2 = 1.500
where id = 45524 
Use Arcadia
update dbo.skillResource
set var6 = 0.000
where id = 45524 
Use Arcadia
update dbo.skillResource
set effect_type = 701
where id = 45524 
Use Arcadia
update dbo.skillResource
set target = 102
where id = 45524

Don't forget if you like hit that Thanks button!

[haxti]

Nice gavsta. I'm a bit depressed too since i sent some of my work to ne0 and never got an answer. I was about to give them a improved ranking page and some handy gm ingame commands but whatever. Maybe they are too 1337 *rolleyes*

I will take a look at this, maybe i find something. Thank you!

[ismokedrow]

No no, Ne0 is swamped with PM's I assure you he says so in shout all the time. He is a very busy man, anyone who puts up work that is helpful has a great chance to make it in. I will personally vote for you.

[Ne0@NCarbon]

Originally Posted by haxti

Nice gavsta. I'm a bit depressed too since i sent some of my work to ne0 and never got an answer. I was about to give them a improved ranking page and some handy gm ingame commands but whatever. Maybe they are too 1337 *rolleyes*

I will take a look at this, maybe i find something. Thank you!

Maybe you didn't imagine how many pm i receive for vip status on our forum (at this time 237 unread), be a little patient i can't be 24 hour a day on forum, i have a job and a real life ....

[SilentBill]

Kudos man, I spent many a night trying to figure out how to make this one work.
Lemme just make this query a little more efficient:

Use Arcadia
update dbo.skillResource
set state_level_base = 0
,state_level_per_skl = 1.00
,var1 = 0.000
,var2 = 1.500
,var6 = 0.000
,effect_type = 701
,target = 102
where id = 45524

EDIT: Oh...

Does not work correctly does not give negative on Unicorn as it should do gives positive

dangit, yeah, I got to that point too lol.
Good work anyway, gavsta.

[kaderebak]

@Gavsta

you open a forum, why shared ? everyone does it this well.


Buy a domain, a host on the rent,, I set up the system.

[gavsta]

Originally Posted by SilentBill

Kudos man, I spent many a night trying to figure out how to make this one work.
Lemme just make this query a little more efficient:

Use Arcadia
update dbo.skillResource
set state_level_base = 0
,state_level_per_skl = 1.00
,var1 = 0.000
,var2 = 1.500
,var6 = 0.000
,effect_type = 701
,target = 102
where id = 45524

EDIT: Oh...

dangit, yeah, I got to that point too lol.
Good work anyway, gavsta.

I have been thinking on this one I think that might need to be changed is:

Use Arcadia
update dbo.skillResource
set hate_mod = 1.00
where id = 45524

although I might be wrong never tested it so... if it doesn't get it as it should be then just change That back... which is:

Use Arcadia
update dbo.skillResource
set hate_mod = 0.00
where id = 45524

Originally Posted by kaderebak

@Gavsta

you open a forum, why shared ? everyone does it this well.


Buy a domain, a host on the rent,, I set up the system.

There is no point in me opening a forum due to I know I am not very good at stuff like this, stuff like this We have a forum here, I just stopped posting for a while because it seems the rules here is If you help some people you get banned I do have a Growth pot fix correctly I am going to write up another MSSQL query for this soon, when I am not busy sorting my server. Although The actual Skill for Growth pot isn't working, so theres no much point in me giving a fix for a pot that just gives a buff that has no effect.

[haxti]

Sorry Ne0 didn't want to attack you. It's just that i saw you read the pm and i never got an answer. well i'm waiting

[SilentBill]

No, the hate_mod only changes aggro generated by the skill.
The prblem is the target or something, I personally think it just plain won't work with these server files, since it's the only skill, along with the Staged Tortus' one that is cast by the pet and has a beneficial effect on the owner and a detrimental one on the pet.
I tried messing with several values on that, got it working well, as long as it was the owner that did the casting. :/

I'm very interested in your Growth Pot fix, btw :P