[HELP] How to add skill effect in start zone tutorial

04/14/2014 14:08 except us#1
I need code for add skill effect , but how to add it ? :rtfm:
04/14/2014 18:12 lnwnuyhodd#2
RohanGame>Programmability>Stored Procedures>ROHAN_CreateCharacter

Quote:
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28668, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28667, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28669, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28628, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28627, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28648, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28647, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28646, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28638, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28651, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28629, 0, 7200000, 0, NULL)
04/15/2014 11:50 except us#3
Quote:
Originally Posted by lnwnuyhodd View Post
RohanGame>Programmability>Stored Procedures>ROHAN_CreateCharacter
Thank's :D . Btw , and then how to add other skill ?
Anyone to help it ? and change items on npc talgath? :rolleyes:
04/15/2014 12:39 PhytonMate#4
you should quit managing a server mate.
04/15/2014 13:10 except us#5
Quote:
Originally Posted by PhytonMate View Post
you should quit managing a server mate.
so why ? i just maked localhost ps , this ps just be for fun :confused:
04/15/2014 13:57 Dr.Dr.SheldonLeeCooper#6
Quote:
Originally Posted by except us View Post
so why ? i just maked localhost ps , this ps just be for fun :confused:
So try your Stuff by yourself. We all did that. You are just to lazy to work arround with it.
04/15/2014 14:00 except us#7
What I wrong if I ask ?
04/16/2014 16:08 tgrt2008#8
Exploring stuff and learning how to do them helps you more then anyone arround here could (Saying it from my own experience)



Anyway il help you by giving you some clues on how to edit talgath. Talgath it's an exchange npc meaning you have to exchange something for the item (Including crone or ip or other curency code)
04/16/2014 18:00 moooootie25#9
Spoon feeders here we come again
05/14/2015 08:28 torndes2#10
any one can tell me where I can find all skill and buff kind id?

well I just checked skill.bin and skilllevel.bin there is nothing refers to any skill id

or someone have skill id and buff id files? it would be nice if you can upload it here :)

thank you very much
05/14/2015 08:46 oziel235#11
you give up too easy. Look better. Old blood usual sucks
05/14/2015 08:53 torndes2#12
Quote:
Originally Posted by oziel235 View Post
you give up too easy. Look better. Old blood usual sucks
Just tell me dude, I have tried to convert it from hex to dec from this skill kind id

Code:
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28668, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28667, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28669, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28628, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28627, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28648, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28647, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28646, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28638, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28651, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28629, 0, 7200000, 0, NULL)
all I can get is nothing matched, just tell me how to find it, is it hard to tell someone mistake?
05/14/2015 09:08 oziel235#13
I answered by MP
05/14/2015 09:22 xpro99#14
Quote:
Originally Posted by torndes2 View Post
Just tell me dude, I have tried to convert it from hex to dec from this skill kind id

Code:
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28668, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28667, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28669, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28628, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28627, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28648, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28647, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28646, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28638, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28651, 0, 7200000, 0, NULL)
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28629, 0, 7200000, 0, NULL)
all I can get is nothing matched, just tell me how to find it, is it hard to tell someone mistake?
skill id= skill.bin
INSERT INTO dbo.TSkillAffect (char_id, kind, level, affect_time, event_time, param) VALUES (@char_id, -28651, 0, 7200000, 0, NULL)