Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 15:38

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

 

[Help Thread] Please post your questions here.

Reply
 
Old   #526
 
elite*gold: 0
Join Date: May 2011
Posts: 49
Received Thanks: 7
Hello!
Tell me please, where edit announcement sieges? It is duplicated. Sorry for my bad English



Blackcat2011 is offline  
Old   #527
 
elite*gold: 0
Join Date: Jul 2011
Posts: 71
Received Thanks: 12
does anyone know how to do a search query in the database for a certain field mob ?


Levelz is offline  
Old   #528
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
First of all you will need a correct dbo.StringResource because the StringResource in the Infinite Files isn't readable for me. You can Import the db_string.rdb out of your client with pyrok's dumper + string editor.

After that you need to run the following command:

Code:
SELECT StringResource.value, id
FROM dbo.MonsterResource 
LEFT JOIN dbo.StringResource 
on name_id=StringResource.code 
where StringResource.value like '%[B][I]Mobname[/I][/B]%'
c1ph3r is offline  
Thanks
1 User
Old   #529
 
elite*gold: 0
Join Date: May 2008
Posts: 339
Received Thanks: 69
Code:
SELECT level, model, string.value -- Selects a skill and it's text_id and gives out the string value

FROM Arcadia.dbo.MonsterResource, Arcadia.dbo.StringResource string -- tells the query where to look for le files

WHERE name_id = string.code -- connected to the FROM-command: shows the string(readable name) assigned to the text_id

ORDER BY level ASC -- Sorted by order: ascending, desc would be descending, means, all values are sorted by a logical alphabet (special characters, 0-9, A-Z)
if you know the name, just change ORDER BY level, into ORDER BY value, and they will appear in alphabetical order

credits to haxti


kaizoku801 is offline  
Thanks
1 User
Old   #530
 
elite*gold: 0
Join Date: Jul 2011
Posts: 71
Received Thanks: 12
thanks guys

one more question, where can i add attack skills to bosses ? im looking in monsterskillresources .. is this the right location ? if not then where in the database can i edit it in ? does it need to be coded client side also ?

thanks for all the helpful people out there
Levelz is offline  
Old   #531
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Levelz View Post
thanks guys

one more question, where can i add attack skills to bosses ? im looking in monsterskillresources .. is this the right location ? if not then where in the database can i edit it in ? does it need to be coded client side also ?

thanks for all the helpful people out there
Yes the monsterskillresource is connected with the monserresource via the monster_skill_link_id (monsterskillresource.id=monserresource.monster_sk ill_link_id).

Use this command to show th skill-ids of a mob:

Code:
SELECT StringResource.value, MonsterResource.id, MonsterSkillResource.Skill1_id,  MonsterSkillResource.Skill3_id,  MonsterSkillResource.Skill2_id, MonsterSkillResource.Skill4_id, MonsterSkillResource.Skill5_id, MonsterSkillResource.Skill6_id
FROM dbo.MonsterResource, 
 dbo.StringResource,
 dbo.MonsterSkillResource 
where name_id=StringResource.code and monster_skill_link_id=MonsterSkillResource.id 
and StringResource.value like [B][I]'%Mobname%'[/I][/B]
c1ph3r is offline  
Thanks
2 Users
Old   #532
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
hi
i have 2 questions
1-is there a fix for the TP disappear on log-out ?
2-how can i add TP per login ?

Quote:
Originally Posted by Strange2010 View Post
hi
i have 2 questions
1-is there a fix for the TP disappear on log-out ?
2-how can i add TP per login ?
never expected a fast reply .... np i FIXED it

how ? insert this line in your on_login.lua insert it under the server buffs
sv("tp","10")
change 10 to the amount u want
Strange2010 is offline  
Old   #533
 
elite*gold: 0
Join Date: May 2012
Posts: 12
Received Thanks: 0
Smile

Hi guys

Ok, so i know you guys hate people that ask the same question over and over and over again...

I have been installing my server for 3 days now without asking anything.

I have looked over and over again trying to fix this issue I've had over a day now...

Ok, so i got the files from the German dude, gavsta something? The holly 100% working!!! one lol

Well, when i try to make my character it gives me this "You may not create this character.

I have looked under the dbo.Account,IPBan,Resource... ect. Idk where the issue is coming from. I finally give up at trying to figure it out and ask others for help ^_^

Thanks in advance. If anyone is having issues setting there SQL up, let me know, so you give the others a break on that. hehe

~blake.
LuckyOne2Three is offline  
Old   #534
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Do you use an updated official 7.3 client? Looks like you are using a wrong client. You need a full updated rappelz 7.3 client.
c1ph3r is offline  
Thanks
1 User
Old   #535
 
elite*gold: 0
Join Date: May 2012
Posts: 12
Received Thanks: 0
Ahhh, ok. Thats one thing i was wondering. I guess Gavsta's files are outdated in the character database which doesn't fit with that epic or what so ever.

1st, I get that from download center website--- 7.3 working 100% right?

and 2nd, how do i shift over the new files to the database once i have it?

ps: I got my files from this thread--http://www.elitepvpers.com/forum/rappelz-private-server/1850182-rappelz-epic-7-3-100-working-also-cash-shop-100-a.html

~blake

EDIT: I got the new server files, backed up/restored my databases with the new back up files (arcadia/auth/tele) and I ran the game, went to make a new character, same issue again.

Not sure what the problem is here =/

One thing that came to my mind...When i restored Telecaster, i restored it to may 6 which was yesterday, could that be the issue?

Going to wait for a response and go to bed so i don't mess up any further lol ^^

~blake
LuckyOne2Three is offline  
Old   #536
 
elite*gold: 0
Join Date: Jul 2011
Posts: 71
Received Thanks: 12
Quote:
Originally Posted by c1ph3r View Post
Yes the monsterskillresource is connected with the monserresource via the monster_skill_link_id (monsterskillresource.id=monserresource.monster_sk ill_link_id).

Use this command to show th skill-ids of a mob:

Code:
SELECT StringResource.value, MonsterResource.id, MonsterSkillResource.Skill1_id,  MonsterSkillResource.Skill3_id,  MonsterSkillResource.Skill2_id, MonsterSkillResource.Skill4_id, MonsterSkillResource.Skill5_id, MonsterSkillResource.Skill6_id
FROM dbo.MonsterResource, 
 dbo.StringResource,
 dbo.MonsterSkillResource 
where name_id=StringResource.code and monster_skill_link_id=MonsterSkillResource.id 
and StringResource.value like [B][I]'%Mobname%'[/I][/B]

thanks champ that works perfect.


also i edited the mob and gave it skills but... when i changed its level to 180 it still displays lvl 50 but hits like a 180 .. do i also need to change this client side or is there another location in the database that needs editing so it will display its true level 180 ? and how would i make it display as 180??
Levelz is offline  
Old   #537
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Don't know exactly but you could try to edit this in the db_monster.rdb. Looks like the displayed level is in the client. Extract it with the dumper and hex the lvlvalue in the rdb-file put it back into the client with the Rappelz Data Editor.
c1ph3r is offline  
Thanks
1 User
Old   #538
 
elite*gold: 0
Join Date: Jul 2011
Posts: 71
Received Thanks: 12
will do. thanks champ
Levelz is offline  
Old   #539
 
elite*gold: 0
Join Date: Oct 2011
Posts: 52
Received Thanks: 4
@ lucky

you have to not just dl the offical rappelz client but also run the launcher so that it will fully update. the client that gpotato offers isnt completely up to date.
Judge12 is offline  
Old   #540
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by LuckyOne2Three View Post
Ahhh, ok. Thats one thing i was wondering. I guess Gavsta's files are outdated in the character database which doesn't fit with that epic or what so ever.

1st, I get that from download center website--- 7.3 working 100% right?

and 2nd, how do i shift over the new files to the database once i have it?

ps: I got my files from this thread--http://www.elitepvpers.com/forum/rappelz-private-server/1850182-rappelz-epic-7-3-100-working-also-cash-shop-100-a.html

~blake

EDIT: I got the new server files, backed up/restored my databases with the new back up files (arcadia/auth/tele) and I ran the game, went to make a new character, same issue again.

Not sure what the problem is here =/

One thing that came to my mind...When i restored Telecaster, i restored it to may 6 which was yesterday, could that be the issue?

Going to wait for a response and go to bed so i don't mess up any further lol ^^

~blake
The database isn't the problem! You need to run the official launcher to update your game client.


c1ph3r 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 15:38.


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

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