[Release]9.4 Official Files

[darkjorg]

Originally Posted by ThunderNikk

The girl NPC may still be there.

She is what I use for my custom NPC item shop stuff, well her and the abomination in some areas.

It was originally written by Stars Online wherever they went and I can post the .lua and market resource entries if you want. I did do some work cleaning it up but it is stall old and you would have to add items to it to get up to date with 9.4

To get rid on them remove the hashed NPC and ascii NPC resource from the resource folder.

That's great this sound like this server will gonna be fun !! I still learning

Thanks ThunderNikk I'll be with attention to see the new post.

Originally Posted by Ghost Informatics

this is our prvate system .. you can use rdu file to update the database then you will have a clean database without our system functions.

Maybe this thread is to old, but I am trying to find out to make work
DBUpdater and update my basedate

I have checked out this post and nothing


S db.preset_00:Test|127.0.0.1|1433|Arcadia|sa|space. . with normal password, with RappelzHash password and nothing

Thanks Ghost

[XavierDeFawks]

Originally Posted by darkjorg

Maybe this thread is to old, but I am trying to find out to make work
DBUpdater and update my basedate

I have checked out this post and nothing


S db.preset_00:Test|127.0.0.1|1433|Arcadia|sa|space. . with normal password, with RappelzHash password and nothing

Thanks Ghost

That looks about right. The password is the same hashed password that the game server uses and I believe it has to have the | at the end of it or it will error. Not sure on that though.

[Gangor]

Originally Posted by darkjorg

That's great this sound like this server will gonna be fun !! I still learning

Thanks ThunderNikk I'll be with attention to see the new post.




Maybe this thread is to old, but I am trying to find out to make work
DBUpdater and update my basedate

I have checked out this post and nothing


S db.preset_00:Test|127.0.0.1|1433|Arcadia|sa|space. . with normal password, with RappelzHash password and nothing

Thanks Ghost

You need using DES crypto for that working.

[darkjorg]

Originally Posted by Gangor

You need using DES crypto for that working.

it work !, but now I decided to leave everything, I have the impression that the original db could be a real headache with a lot of bugs xD.. is better continue testing and use that NPC to something useful..

Thanks !

[ThunderNikk]

Here are the files that go along with the NPC shops in my client.

Again they are not mine I only cleaned them up a lot with item order and pricing and changed some timed items out for permanent.

The original work is by stars online and as you can see the files are still named for the people that worked on them.

The only reason I feel it is OK to share them here is because they were originally shared with a server file release of 7.4

There is nothing fancy it is not long lines of SQL they are just two Microsoft excel files and it is enough to copy paste them into the server file tables, and the controlling .lua script file.

Place the .lua in your server script files and you will need to have changed over from .ela loading to .lua loading in order for it to work. (I think or you can try compressor encrypting it and adding another number to your .ela count .opt entry...)

N:game.ela_count:40

will become

N:game.ela_count:41

but I am not sure if that will work. More than welcome to try.

For the two excel files.

The market resource is straight forward.

1. Select every excel cell that has data in it do not select empty cells or rows or columns. Copy all of the data (right click context menu copy, edit menu copy, control + c copy however you want to do it)

2. When you paste into the SQL table open your table for editing by finding dbo.MarketResource in arcadia and right click select "edit ____ rows" depending on your SQL option settings for editor it may say a number of rows or it may say all rows but whatever it says choose edit.

3. Scroll down to the last row in the SQL table which will be an empty place holder row. Select to the left of the row (not the first cell but the left of that which would be like selecting an entire row in excel) right click and select paste. It will paste all of the data from the excel sheet into the SQL table.

4. For the NPC resource excel sheet do the same thing except you will notice there are two data sets for NPC resource 8.x and earlier and 9.x and later select the correct cells for your server files. Copy them. Paste them into the dbo.NPCResource in arcadia.

You do NOT need to create any resource files for the client. Even if you are not running my client with my NPC resource the NPCs will show up without the RDB. The market resource will load this items server sided you do not need the RDB for that either. For those that do have my client the NPC resource was converted to RDB for other reasons and that is why you have the NPCs without the SQL table edits.

As I said before they are old and you will need to customize them a little and add items to get them up to date for 9.4.

For those running a cash shop these are not for you.

PS. I added some mounts to the Hidden Village mount NPC in some of those market resource entries also.

[thefear511]

Originally Posted by darkjorg

Hello guys
Somebody notice this npc

I am using Sframe and Server files 9.4 from Revo, and Rappelz Client 9.4 from ThunderNikk but, somebody can teach how to fix it to learn and if it possible add the NPC revo from the server files 9.1, for example I want to add the possibility to get TP using a NPC also.

There is two old files.. is it neccesary to add a new NPC?
NPC_REVO_MAIN.lua
NPC_REVO_MAIN_EN.lua

Would be nice to know that. BTW the server look and feel nice <3 i didnt notice if it necessary.. but anyway I have applied the LamiaCore Fix Scripts.

Thank again for this great release

about the NPC , the NPC is already there in the horizon and other cities, use this query to find them

SELECT id, text_id, name_text_id, race_id, sexsual_id, x, y, z, face, local_flag, face_x, face_y, face_z, model_file, hair_id, face_id, body_id, weapon_item_id,
shield_item_id, clothes_item_id, helm_item_id, gloves_item_id, boots_item_id, belt_item_id, mantle_item_id, necklace_item_id, earring_item_id,
ring1_item_id, ring2_item_id, motion_id, is_roam, roaming_id, standard_walk_speed, standard_run_speed, walk_speed, run_speed, attackable,
offensive_type, spawn_type, chase_range, regen_time, [level], stat_id, attack_range, attack_speed_type, hp, mp, attack_point, magic_point, defence,
magic_defence, attack_speed, magic_speed, accuracy, avoid, magic_accuracy, magic_avoid, ai_script, contact_script, texture_group, type
FROM NPCResource
WHERE (contact_script LIKE '%twagod_sys()%')

if you want to run the current npc just make a .lua with this function

function get_module_name()
return "twagod_sys"
end
function twagod_sys()
dlg_title("Cute Girl")
dlg_text("ahem")
dlg_menu("English", "NPC_cute_contact_EN()")
dlg_menu("Arabic", "NPC_cute_contact_AR()")
dlg_menu( "<#FF0000>End", "" )
dlg_show()

this will make the girl in horizon to talk to you , then you add options etc.

or else you can delete the rows in sql and make ones with different coordinates and contact script.

[YuhaBah]

I have disabled dismantle, how can i enable it and why it happened?
For example if i try dismantle pet card for awakening stones or some weapon for e-power, i take message about unsuccsess dismantle.
TY

[ThunderNikk]

Could you post your gameserver.opt

[YuhaBah]

Originally Posted by ThunderNikk

Could you post your gameserver.opt

First i check it myself, but didnt find about =(

 Spoiler

PHP Code:

S:app.name:Rappelz
N:auth.server_idx:1
S:auth.server_name:Rappelz
S:db.c.name:Arcadia
S:db.c._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
S:db.c.account:sa
S:db.c.server:127.0.0.1
S:db.user._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
S:db.user.account:sa
S:db.user.name:Telecaster
S:db.user.server:127.0.0.1
N:game.AdultServer:0
S:game.allowed_special_char:@.
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.cash_usable_server:1
F:game.chaos_drop_rate:0.6
F:game.exp_rate:1
F:game.gold_drop_rate:1
F:game.item_drop_rate:3
N:game.local_flag:8192
N:game.max_level:190
N:game.PKServer:1
F:game.premium_pcbang_bonus_rate:1
F:game.premium_pcbang_chaos_bonus_rate:0.1
F:game.pvp_damage_rate_for_player:0.01
F:game.pvp_damage_rate_for_summon:0.035
N:game.use_auto_trap:0
N:game.use_auto_jail:0
N:game.use_delete_security:0
N:game.use_guild_donation_point:0
N:game.use_play_point:0
N:game.use_security:0
N:CodePage:1256
N:game.ServiceServer:1
S:game.guild_icon_base_url:http://guilds.rappelz.ae/gicons/
S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html
S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html
S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html
S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html
S:game.resource:Resource
S:game.server_screenshot_url:https://room.rappelz.ae/Launcher/AR/server.html
N:game.update.version:17
S:game.url_list:guild.url|http://guilds.rappelz.ae/gicons/|guild_test_download.url|gicons/|web_download|guilds.rappelz.ae|web_download_port|0|shop.url|http://room.rappelz.ae/shop.html|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|51.254.58.230|guild_icon_upload.port|4615
N:game.version:201507080
S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:io.ip_address:127.0.0.1
N:io.port:49999
T:game.enhance_fail_type:2
S:io.user_count_ip_mask:127.0.0.1
S:log.ip:127.0.0.1
S:log.working:1
S:io.upload.ip:127.0.0.1
S:io.upload.port:4617
S:upload.server_name:Upload
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
N:console.port:44452
T:game.min_global_chat_usable_level:1
S:console.allow_ip:127.0.0.1
N:game.PKPenaltyLevel:10
N:game.use_account_authority_db:1
N:game.use_time_based_event_db:0
N:game.term_for_time_based_event_db:0
N:game.item_expert_cube :1
N:game.item_expert_grade:0
N:game.gold_drop_base:5000
F:game.gold_drop_percent:0.75
N:game.min_speed:50
N:game.amplify_level:0
N:game.amplify_hp:0
N:game.exception_arabic:0
N:game.exception_921:0
F:game.card_drop_rate:1.0
N:game.enhance_chance:1
N:game.enhance_chance_min:1
N:game.enhance_chance_max:10
N:game.enhance_destroy_level:10
F:game.quest_bonus_rate:1.0
N:game.quest_bonus_level:130.0
N:game.HardcoreServer:0
N:game.check_area:0
F:game.party_exp_rate_0:1
F:game.party_exp_rate_1:2
F:game.party_exp_rate_2:2
F:game.party_exp_rate_3:2
F:game.party_exp_rate_4:3
F:game.party_exp_rate_5:3
F:game.party_exp_rate_6:4
N:game.party_exp_penalty_level:5
N:game.summon_exp_penalty_level:10
F:game.killed_drop:0.03
I:game.crime_state:1
I:game.crime_party:1
F:game.killed_exp_percentage:1.0
F:game.kill_immoral_percentage:1.0
F:game.monster_regen_boss:5
F:game.monster_regen:5
N:game.max_characters_per_account:8
T:game.log.working:1
T:log.chat.working:1 


[YuhaBah]

Originally Posted by LamiaCore

If you restored the arcadia from this thread, you won't be able to dismantle/decompose anything, because the table is empty ^^

Generally, if any1 wants to fix it, and you don't have added too much own entries in dropgroupresource, you can use my attached archive
(includes my DropGroupResource + DecomposeResource).
It works fine without any more issues, and haven't added any additional line to original released one.

Also thanks @ to tell me where to search to solve the issue.
If there should be a problem with these scripts, tell me and I'll do it somehow else.

Hy, its working pretty good! Thanks !!!

Also, if role of DecomposeResource is clearly white for my, what is the DropGroupResource?

[InkDevil]

Originally Posted by YuhaBah

Hy, its working pretty good! Thanks !!!

Also, if role of DecomposeResource is clearly white for my, what is the DropGroupResource?

In DropGroupResource is the main-issue, because there are 'invalid' entries.
And thanks for feedback (always good to know if something works for others, too, and not just for my local server)

[yardenhx]

link is broken?

[king1king]

Originally Posted by Audric123

Problem is here

Model are character in database:


Model are numeric in rdb:




Other problem I see dbo.DecomposeResource is empty ?

Problem too
how i can fix it ?

[ThunderNikk]

The post you quoted...

Read this thread from there forward. Starts on about page 8.

[toyfarm]

its time to learn this for myself. but im looking at the guide and the first bak to restore is auth_gameportal.bak, but where is this ? ive never dont this before so pardon the dumb questions