Register for your free account! | Forgot your password?

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

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

 

[Help Thread] Please post your questions here.

Reply
 
Old   #3241
 
elite*gold: 0
Join Date: Jul 2012
Posts: 231
Received Thanks: 65
Quote:
Originally Posted by KirieZ View Post
How can I check the level of a pet skill? via script
try this :
Code:
declare @owner_name NVARCHAR(55)
SET @owner_name = 'character's name'

SELECT pet_skill.owner_id, STRINGRES.value as skillname, CHAR.name as owner_name, CHAR.account
FROM Telecaster.dbo.Skill pet_skill 
INNER JOIN Telecaster.dbo.Character CHAR
on CHAR.sid = pet_skill.owner_id 
INNER JOIN Arcadia.dbo.skillresource skillres
on skillres.id = pet_skill.skill_id
INNER JOIN Arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = skillres.text_id
WHERE CHAR.name = @owner_name
ORDER BY pet_skill.owner_id ASC
credit Ismokedrow



eziorav is offline  
Old   #3242
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
This will not work on a npc, right? I'm trying to check if player's pet has a skill and in which level it is, in game.


KirieZ is offline  
Old   #3243
 
elite*gold: 0
Join Date: Jul 2012
Posts: 231
Received Thanks: 65
Quote:
Originally Posted by KirieZ View Post
This will not work on a npc, right? I'm trying to check if player's pet has a skill and in which level it is, in game.
well first you said just how to get skill level without referring that it need to be in npc, so here is what you will need to do
1- use this guide how run queries from lua script (easy to find just by using that search button)
2-use the sql query given in previous post
3-use some dev(Lua-Sql) skills to adjust your Query & Script
eziorav is offline  
Thanks
1 User
Old   #3244
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
Quote:
Originally Posted by eziorav View Post
well first you said just how to get skill level without referring that it need to be in npc, so here is what you will need to do
1- use this guide how run queries from lua script (easy to find just by using that search button)
2-use the sql query given in previous post
3-use some dev(Lua-Sql) skills to adjust your Query & Script
I will try again, have tried something like that when I started and couldn't get to work, but I'll give it a chance. Do you have any ideia of how to make a wait function? because I couldn't find a way to wait until the value is returned (by creating a new variable)


KirieZ is offline  
Old   #3245
 
elite*gold: 0
Join Date: Jul 2012
Posts: 231
Received Thanks: 65
Quote:
Originally Posted by KirieZ View Post
I will try again, have tried something like that when I started and couldn't get to work, but I'll give it a chance. Do you have any ideia of how to make a wait function? because I couldn't find a way to wait until the value is returned (by creating a new variable)
sorry can't help you with that because i still haven't figured out how to develop a wait fonction
eziorav is offline  
Old   #3246
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
How can I allow special characters ( etc) in chat and npc dialogues? Thanks in Advance
I tried changing localinfo, codepage and country but couldn't resolve.
KirieZ is offline  
Old   #3247
 
elite*gold: 0
Join Date: Jan 2014
Posts: 65
Received Thanks: 15
Quote:
Originally Posted by KirieZ View Post
How can I allow special characters ( etc) in chat and npc dialogues? Thanks in Advance
I tried changing localinfo, codepage and country but couldn't resolve.
Write the message in the string resource and then write the code instead of the text
Prentis is offline  
Old   #3248
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
Even so it doesn't work. The text get cut before the character.
KirieZ is offline  
Old   #3249
 
elite*gold: 0
Join Date: Jan 2014
Posts: 65
Received Thanks: 15
Right Country + String Resource works for me maybe your doing something wrong or maybe I did something more let me check that.
Prentis is offline  
Old   #3250
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 983
It may be the abuse_list.txt

Check to see if they are listed as blocked characters.

You will need to resource an override file that will correct the filters.
ThunderNikk is offline  
Old   #3251
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
I added an empty abuse_list.txt and banword.rdb and tried adding localeinfo.ini too (ascii and normal), nothing changes, NPC names, item names and main menu works well, but NPC text, menu and chat doesn't. thanks
KirieZ is offline  
Old   #3252
 
elite*gold: 0
Join Date: Apr 2011
Posts: 273
Received Thanks: 69
Iam wondering what is the parameter of learn_creature_skill gameserver command ...

Quote:
Originally Posted by KirieZ View Post
I added an empty abuse_list.txt and banword.rdb and tried adding localeinfo.ini too (ascii and normal), nothing changes, NPC names, item names and main menu works well, but NPC text, menu and chat doesn't. thanks
Buddy ... just save lua file in np++ and convert it to UTF-8 without BOM ...
TheSuperKiller is offline  
Old   #3253
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 983
creature_learn_skill is the registered command maybe that's why no one can figure out...

learn_creature_skill
ThunderNikk is offline  
Old   #3254
 
elite*gold: 0
Join Date: Oct 2011
Posts: 42
Received Thanks: 5
Quote:
Originally Posted by TheSuperKiller View Post
Iam wondering what is the parameter of learn_creature_skill gameserver command ...

Buddy ... just save lua file in np++ and convert it to UTF-8 without BOM ...
Thanks, but didn't work
KirieZ is offline  
Old   #3255
 
elite*gold: 0
Join Date: Mar 2014
Posts: 11
Received Thanks: 0
Heya!

Tried to make my own NPC, followed i guide i got by a good friend.

Everything worked fine, Added the NPC files into my Folder. Restarted everything.

And then...my server don't work.

The herlock server on goes to (Something about 4 strings,then event state succesfully.)

After that it closes and gives me crash dump files.

I have tried to removce those files that i have added, but it doesn't work that either.

Anybody could help me?


Jullovich is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



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


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

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