[Request] need all skill ids ^^

[claro28111]

i want all skill ids +the name

[TheOnlyOneRaskim]

Search in database for them.

Select id, value from skillresource join stringresource on text_id = code order by id

[claro28111]

okay how can i search for a value in the results

(i'm new in sql )

[c1ph3r]

Select id, value from skillresource join stringresource on text_id = code where value like '%searchterm%' order by id

[Stormyblueyez]

Originally Posted by TheOnlyOneRaskim

Search in database for them.

Select id, value from skillresource join stringresource on text_id = code order by id

Is this also where I can find the skill for the loot pets, I am having a very hard time fixing the issue where my loot pets do not have the "Return of Item" skill and cannot seem to find it anywhere.

Thanks!!

[marekrndr]

You really gotta spoonfeed everything to these guys. -smh-

[Stormyblueyez]

Originally Posted by marekrndr

You really gotta spoonfeed everything to these guys. -smh-

Well EXCUSE me... I have learned enough in the last 2 weeks to set up my own server alone just by what I have learned on here with no past training on any of this ****... this might come easy to some but for others it is a learning process.
I THOUGHT this sight was to help people. Do you not remember when you were a noob at all this and don't tell me you never asked questions or got help from someone...
Oh and not to mention, I only ask when I cant find it in the forums AND have spent hours NOT finding it in the files of the game, which happens to be the case here...
Who are you to judge. If you don't want to help, or just say, sorry I don't know... or better yet, say NOTHING... instead of being rude.

Thanks for reading anyhow!

[claro28111]

Originally Posted by marekrndr

You really gotta spoonfeed everything to these guys. -smh-

i'm 14 years old and i had built my own local server :P

[marekrndr]

Originally Posted by claro28111

i'm 14 years old and i had built my own local server :P

[ismokedrow]

[Stormyblueyez]

Amazing how one can take time for condescension instead of just, "sure I can help... you can find this here"... but hey condescension is much more rewarding I am sure.

:-P

[c1ph3r]

Without these funny posts the rappelz forum will become boring XD just keep it as entertainment and to be fair i ****** up with the looties from time to time too. If the Skill is in you skillresource check skilltreeresource too. All looties do have a skilltree entry too! Skill should be in skillres and skilltreeresource. And take care of the correct petresource in client. At least in 7.4 there are two different petresource-rdbs.

[Stormyblueyez]

Originally Posted by c1ph3r

Without these funny posts the rappelz forum will become boring XD just keep it as entertainment and to be fair i ****** up with the looties from time to time too. If the Skill is in you skillresource check skilltreeresource too. All looties do have a skilltree entry too! Skill should be in skillres and skilltreeresource. And take care of the correct petresource in client. At least in 7.4 there are two different petresource-rdbs.

Thank you for taking the time to answer.

I have it in dbo.skillresource and in dbo.skilltreeresource plus of course in dbo.itemresource and dbo.petresource, so I guess I am just overlooking something... probably quite minor.

The looters are all good except the actual skill itself, its just a black box. Hovering over it shows the right tooltip info... the skill itself is just not there.
LOL!
I am going lootpet crazy! ...but determined to keep looking.

Thanks again!

[claro28111]

okay i could change every thing about skills Thanks guys

but can some one tell me how can i edit the durability of an item ^^

:P sorry for being stupid

[ThunderNikk]

maybe ethereal_durability column in item resource table.

Make sure you write a new RDB.