Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 16:07

  • Please register to post and access all features, it's quick, easy and FREE!


[Request] need all skill ids ^^

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2012
Posts: 48
Received Thanks: 1
[Request] need all skill ids ^^

i want all skill ids +the name



claro28111 is offline  
Old 01/07/2015, 14:49   #2
 
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,007
Search in database for them.

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


TheOnlyOneRaskim is offline  
Thanks
1 User
Old 01/07/2015, 16:10   #3
 
elite*gold: 0
Join Date: Mar 2012
Posts: 48
Received Thanks: 1
okay how can i search for a value in the results

(i'm new in sql )
claro28111 is offline  
Old 01/07/2015, 16:19   #4
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,571
Received Thanks: 1,157
Select id, value from skillresource join stringresource on text_id = code where value like '%searchterm%' order by id


c1ph3r is offline  
Thanks
1 User
Old 01/07/2015, 20:26   #5
 
elite*gold: 0
Join Date: Dec 2014
Posts: 20
Received Thanks: 4
Quote:
Originally Posted by TheOnlyOneRaskim View Post
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!!
Stormyblueyez is offline  
Old 01/09/2015, 12:47   #6
 
elite*gold: 0
Join Date: Aug 2011
Posts: 532
Received Thanks: 232
You really gotta spoonfeed everything to these guys. -smh-
marekrndr is offline  
Old 01/09/2015, 16:35   #7
 
elite*gold: 0
Join Date: Dec 2014
Posts: 20
Received Thanks: 4
Quote:
Originally Posted by marekrndr View Post
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!
Stormyblueyez is offline  
Thanks
1 User
Old 01/09/2015, 21:01   #8
 
elite*gold: 0
Join Date: Mar 2012
Posts: 48
Received Thanks: 1
Quote:
Originally Posted by marekrndr View Post
You really gotta spoonfeed everything to these guys. -smh-
i'm 14 years old and i had built my own local server :P
claro28111 is offline  
Old 01/09/2015, 21:38   #9
 
elite*gold: 0
Join Date: Aug 2011
Posts: 532
Received Thanks: 232
Quote:
Originally Posted by claro28111 View Post
i'm 14 years old and i had built my own local server :P
marekrndr is offline  
Thanks
2 Users
Old 01/09/2015, 21:44   #10
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,426
ismokedrow is offline  
Thanks
1 User
Old 01/09/2015, 21:55   #11
 
elite*gold: 0
Join Date: Dec 2014
Posts: 20
Received Thanks: 4
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
Stormyblueyez is offline  
Thanks
1 User
Old 01/09/2015, 22:00   #12
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,571
Received Thanks: 1,157
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.
c1ph3r is offline  
Thanks
2 Users
Old 01/09/2015, 22:21   #13
 
elite*gold: 0
Join Date: Dec 2014
Posts: 20
Received Thanks: 4
Question

Quote:
Originally Posted by c1ph3r View Post
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!
Stormyblueyez is offline  
Old 01/11/2015, 17:02   #14
 
elite*gold: 0
Join Date: Mar 2012
Posts: 48
Received Thanks: 1
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
claro28111 is offline  
Old 01/11/2015, 17:43   #15
Moderator

 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,505
Received Thanks: 1,147
maybe ethereal_durability column in item resource table.

Make sure you write a new RDB.


ThunderNikk is offline  
Reply



« rappelz files 9.1 full ?? | [Request] Database Boss »

Similar Threads
[Request] GM skill
11/14/2013 - SRO PServer Ask the Experts - 1 Replies
Hello guys i need to know where i can find the files of the GM skill that comes from the command (/gmskill 0) ThnX in adv
[Request]Skill ID
02/09/2011 - CO2 PServer - Discussions / Questions - 1 Replies
does anyone have the skill id for counterkill if they do can they post it please thanks in advance.
[REQUEST] Skill Help
01/22/2011 - EO PServer Hosting - 4 Replies
I really want to add some new skills to my server but am having some troubles figuring it out. I was wondering if anyone could tell me what files/tables need to be edited to accomplish this. The help is really appreciated :)
[Request] a7 skill files and a6 skill fix
03/09/2010 - Dekaron Private Server - 12 Replies
Hey guys, i am looking for action 7 skill files and an action 6 skill fix. I used search but i didn't find anything for action 7 skill files. I found an action 6 skill fix, but it didn't worked. So maybe someone got some files for me?...



All times are GMT +2. The time now is 16:07.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.