[Help Thread] Please post your questions here.

Page 268 of 586 « First 168218258266267 268 269270278318368 Last »
12/12/2014 17:36 ThunderNikk#4006
You add items by adding them to the dbo.MarketResource

You would add them under the same market name that is in the NPC contact script.

You can modify most of the NPC texts by writing them directly in the lua for the NPC although the names and titles of the NPCs may be linked to a string in the string resource.

You can rewrite .lua files with any text editor although I personally prefer Notepad++ a beautiful open source text editor that works well preserving many text formats like .lua .html .xml and many more. There is also a hex plug in available so you can edit hex directly.

@ jimdegwada95

I am not aware of any bugs in the 7.4 auth account tables although I do know that you will need to fill out most of the fields to create a legitimate account.

If you are having trouble with what should be entered in some of the fields you can use an account creator for your first one. You will find a couple in the "Collection of tools" thread.
12/12/2014 18:11 rRINDVIEH#4007
hehe thanks for the first answers :) but i have some problems to follow you ^^ for an example : I have some NPC's in horizon, where I can buy cash shop items and so on, but I want to add more pet cards and other stuff ( I know the ID's for these items ) but I dont know how to add them in these NPC's... And in some NPC's are subordinations like I click on the NPC and then maybe I click on Cash Shop Items or Shield Items, I would like to add some more subordinations in these NPC's

its my first time that I try to work with lua files ^^ so you mean I could write any code of an item in the dbo.MarektResource and write the name of the item in it and price and so on and then its added in the game ? but I cant buy that added item by a NPC?
12/12/2014 20:23 ThunderNikk#4008
You will need to find the lua file for that NPC that sells cash shop items.

When you begin to read through it you will begin to understand how the menu choices work when your characters speak to an NPC.

Certain menu choices open certain markets.

If you want to add an item to that market then it gets added under the name of the market the NPC is opening in dbo.MarketResource.

Take a look at market resource and you will see how an item gets listed.
12/12/2014 20:58 rRINDVIEH#4009
does it has to look like that?



am I in the right section?
12/12/2014 21:41 jimdegwada95#4010
ok thanks thndr
12/12/2014 23:25 ThunderNikk#4011
Quote:
Originally Posted by rRINDVIEH View Post
does it has to look like that?

am I in the right section?
You have the correct database table. Now you just need to match your NPC with their .lua file and you will see how they all link up. Let me post an example for you.

Here is an NPC lua that opens a market from my database...

This lua was written by STARS that was included with the 7.4 server file leaks...


As you can see it starts with the contact_script which will link with the NPC in dbo.NPCResource...

function StarsOnlineShop_contact()

You will see the function called in the dbo.NPCResource in the column for contact_script in that column of the NPC that calls the script you will have...

StarsOnlineShop_contact()

Each function will contain a list of menus and each choice in a menu item will either lead to another function or execute a open_market command

dlg_title("StarsOnline")
dlg_text("Welcome to the rappelz free convenient mart")
dlg_menu("Armor and weapon supplies", "StarsOnline_tools()" )

That one leads to another function. Another function usually contains another list of menus.

function StarsOnline_tools()

dlg_title("StarsOnline")
dlg_text("What type of equipment are you looking for")
dlg_menu("Rank 4", "Rank4()")

This function directs you toward function listing rank 4 menu choices.

function Rank4()
dlg_title("StarsOnline")
dlg_text("All your rank 4 equipment needs")
dlg_menu("Rank 4 armor body", "open_market('shop_armor_body_4')" )

Now as you can see this menu item is finally opening a rank 4 market. In market resource there will be a bunch of items listed in a market named shop_armor_body_4

So I can run a query like this...

select * from arcadia.dbo.MarketResource where name = 'shop_armor_body_4'

Then I will get the following results...


The sort_id can be duplicated in different markets...in one single market it will control the order of the items in the NPCs list.

In a second market you could start over with 1 if you wanted.

Keeping unique sort IDs for each item even in different markets just gives searching for things in the tables more options.

I hope this helps more than confuses you. I have only included small section of each menu so it is easier to see the linking qualities in the menus.
12/12/2014 23:36 jimdegwada95#4012
ok now i can select the server but when i click I have an error message with weird symbol and the game close. do you know this type of bug?
12/13/2014 00:04 ThunderNikk#4013
Is your game server port 4504?

Not sure I have seen an error message on server selection ever unless it is a port issue.
12/13/2014 00:13 jimdegwada95#4014
that's what i was thinking too but my game port is 4504. So i don't where the problem can come from. I have check my gamerserver and authserver and all seems to be ok look:
auth server
S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S db.auth.port:1433
S app.name:auth
S io.auth.port:8841
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120

and gameserver

S app.name:Game Server
S auth.server_idx:1
S auth.server_name:War Rappelz


S db.user.work_total:
S db.user.work_pending:
S db.user.work_active:
S db.user.thread_active:
S db.user.thread_total:

S console.port:4515
S console._password:

S db.game.ip:127.0.0.1

S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.c.account:sa
S db.c._password:

S db.user.name:Telecaster
S db.user.server:127.0.0.1
S db.user.server:sa
S db.user._password:

S io.auth.ip:127.0.0.1
S io.ip_address:127.0.0.1
S io.port:4504

S game.server_screenshot_url:

S io.upload.port:4617
S io.upload.ip:your_website/external_ip
S game.guild_icon_base_url:[Only registered and activated users can see links. Click Here To Register...]
S game.url_list:guild_icon_upload.ip|your_website/external_ip|guild_icon_upload.port|4615

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:12
S game.gold_drop_rate:12
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50
12/13/2014 00:48 rRINDVIEH#4015
Does it need to be an existing NPC with available contact_script and localflag? I use 8.2 server files.

I got it with your explanation about the adding codes & scripts :)

Do I need to edit them with notepad++ ? where do I have to put the .lua file after I have edited and saved it? Do I have to create a new query in arcardia after I saved the .lua file?
12/13/2014 02:52 ThunderNikk#4016
Quote:
Originally Posted by rRINDVIEH View Post
Does it need to be an existing NPC with available contact_script and localflag? I use 8.2 server files.
You can use any NPC you want, it would be better if it was an NPC that was not in use and you can make them visible by changing their local flag to 1 and change their contact script to your .lua function.

Quote:
Originally Posted by rRINDVIEH View Post
Do I need to edit them with notepad++ ?
It is better if you do it help with making the formatting changes visible in color. It is free get it if you don't have it. Trust me you are going to love it.

Quote:
Originally Posted by rRINDVIEH View Post
where do I have to put the .lua file after I have edited and saved it?
In your game bin/resources/scripts folder with the rest of the .lua files.

Quote:
Originally Posted by rRINDVIEH View Post
Do I have to create a new query in arcardia after I saved the .lua file?
No but you may need to create new RDBs for the client for the tables you edited.
12/13/2014 03:03 jimdegwada95#4017
did you have the time to think abou my problem with the connection in the server after logging?
12/13/2014 03:28 rRINDVIEH#4018
Thank you so much for all your support and informations so far *_* :)

Quote:
Originally Posted by thndr View Post
you may need to create new RDBs for the client for the tables you edited.
one last question until I will try to modify or add some items and NPC :P

I feel so dumb now ^^ ehmm..

where can I create new RDBs for my client? Whats supposed to be in the RDBs
12/13/2014 03:56 ThunderNikk#4019
RDBs are the files that are packed into the client that match the database tables.

For most database tables there is an RDB in the client to give the client the same information the server has.

You will probably want to take a look at the resourcing topic ismokedrow wrote up...

[Only registered and activated users can see links. Click Here To Register...]

In some cases, not all, when you change the data in a database table you need to update the RDB with the new data, hash the name, and place it in the resource folder of the client.

BTW The topic is just a guide...do not use the tools from the topic there are many newer and better tools available in the collection of tools thread.
12/13/2014 16:44 rRINDVIEH#4020
I have to start these steps for a NPC ( correct me if im wrong ):

► SQL - Arcadia - Tables - dbo.NPCResource - contact_script

► Find a NPC who is not in use and make the localflag to 1

► Example: NPC_Jewelry_contact() was not in use for me and I turned the localflag from 0 to 1

► I'm opening Notepad++ and create a new query

►

► I'm going to save the file with "NPC_Jewelry.lua"

► I'm changing the contact script into "NPC_Jewelry()"

► I put the saved file into "game bin/resources/scripts folder"

► I start now the Rappelz RDB Tool 2.5.2 made by Glandu2

► Here are some screenshots from the RDB Tool 2.5.2

1.

2.

3.

4.

5.

► To be honest... Until this step it stops with the guide... Im a bit confused until this step now
Page 268 of 586 « First 168218258266267 268 269270278318368 Last »