[Help Thread] Please post your questions here.

[Sandro1029]

Originally Posted by harmbasi

Hi everyone,

I want to have the mobs be able to drop 'points' in some format that are used for the cash shop items. If that is too much work, how can I add points every hour?

Edit: also how do I remove the jlvl being half of level limit?

Thanks,

First question:
You can do it 3 ways:
1) Script on dead, direct insert or drop near character-killer (x,y) (Character which killed the mob is a function-caller)
2) MonsterDropTableResource
3) DropGroupResource (Need a link from MonsterDropTableResource)

If you want to add it directly as a cash shop value, you should create an item to do that. Or a script with sql query (MongrelDog made an understandable guide for that)

Or you can use cash shop cards as a base (They're hardcoded in sframe), but don't mess with your smps.


Second question:
Only source-side

[harmbasi]

Does the gamserver only support IP addresses and not domain names? When I try to use a domain name it doesn't work. I have to hardcode the IP in the OPT file. My ISP periodically changes my IP which causes a lot of issues. Any way around this?

Thanks

[Rappelz Divine]

Originally Posted by harmbasi

Does the gamserver only support IP addresses and not domain names? When I try to use a domain name it doesn't work. I have to hardcode the IP in the OPT file. My ISP periodically changes my IP which causes a lot of issues. Any way around this?

Thanks

It needs to be hardcoded with the IP, though the domain could be set in the launcher argument "if it's static IP in the domain".

[Aigens1337]

i have bought a domain already and the question is how to link the domain to the root server using xampp atm and i did A record @ 192.xx.x.x but if i try to open the domain in browser it gives me error "404 not found" how to fix this ?

[harmbasi]

Originally Posted by Aigens1337

i have bought a domain already and the question is how to link the domain to the root server using xampp atm and i did A record @ 192.xx.x.x but if i try to open the domain in browser it gives me error "404 not found" how to fix this ?

Your question isn't really related to rappelz. You're asking about setting up the webserver.
-Make sure apache is using port 80, otherwise you have to specify the port at the end ie.. 192.xx.x.x:xx
To have the server be available externally
-Make sure your ISP allows port 80 to be access externally
-Either case/ whichever port you use, make sure your router has port forwarding set up for those ports
-If using other ports, you have to log into your domain providers site and update settings to include custom ports

[chet108]

hello guys. i need create new drop table from 0. anyone can give me info about right way for do it? for epic 5 and 6. how to be correct find monsters and know they location or something else

[Sandro1029]

Originally Posted by chet108

hello guys. i need create new drop table from 0. anyone can give me info about right way for do it? for epic 5 and 6. how to be correct find monsters and know they location or something else

Can you show e5 monster resource table? At least first 5 columns.

[chet108]

column with drop?
or 5 first?

[Sandro1029]

Originally Posted by chet108

column with drop?
or 5 first?

Is that monster resource table on the 1st screenshot?
Exactly locations stored in location_id which bound to your StringResource table. So in your case mob with ID 11 is bound to location 160000011.
It is Trainee Island, as you can see it in your string table. As well in new epics it's 15001. So basically you can make a new view to make it easier for you, like this one:

SELECT
mob.[id] as "Monster ID",
str2.[value] as "Monster Name",
mob.[location_id] as "Location ID",
str.[value] as "Location Name"
FROM
dbo.MonsterResource mob LEFT JOIN dbo.StringResource str ON mob.[location_id] = str.code
LEFT JOIN dbo.StringResource str2 on str2.code = mob.[name_id]
ORDER BY location_id ASC
OFFSET 0 ROWS;

About drop table - these negative values are pointers to DropGroupResource. Like for example, if random drops you -104022 "item", it gonna random additional time, in drop group which it bound to.

(If I wasn't misunderstood you)


About data types - in drop group resource it's:
id - int
drop_item_id_xx - int
drop_min_count_xx -- bigint
drop_max_count_xx -- bigint
drop_percentage_xx -- decimal


So, for example, mob with ID 106003 has -851100 in his drop_item_id_00. Let's go to the DropGroupResource and search for this ID.
It says:
806005 item ID gonna have .16000000 (16%) chance to be dropped
806605 item ID gonna have .16000000 (16%) chance to be dropped
etc, etc.
If there is somewhere chance 0, then it won't even count and won't even read the item ID as itself.

Let's return back to MonsterResource. It says drop_min_count_00 and drop_max_count_00 == 1. It means that you will get only 1 item from this drop group resource, no more.

I hope it was useful for you. At least, a bit

[chet108]

can i be know what monster from dungeon?

[Sandro1029]

This is more hard. There are scripts called random_respawn, monster_respawn and monster_roaming, search in them. There gonna be a lot of korean comments about mobs like:

--------------------------------------------------------------------------------------------------------------		
--------------------------------------숨겨진 사룡의 그늘 보스 몬스터 리젠 설정-----------------------------------------------
--------------------------------------------------------------------------------------------------------------	

	elseif ID == 1908001 then
		monster_ID = {10185002,0,0,0,0,0}
		density = { 0.1, 0.1, 0.1, 0.1, 0.1, 0.1 }
		interval = { 3000, 1000, 1200, 1500, 2000, 3000 }
		
		monster_ID = {10185002,0,0,0,0,0}
		Raidmob_density = { 0.37, 0.37, 0.37, 0.37, 0.37, 0.37 }
		Raidmob_interval = { 10000, 10000, 12000, 15000, 20000, 30000 }

So 숨겨진 사룡의 그늘 보스 몬스터 리젠 설정 translates as Hidden Dragon's Shadow Boss Monster Regen Settings
Obiviously it's from TOE. Just google translate these comments (Prepare yourself to get a pain in the **** coz of a lot of lines here )

[chet108]

wow i thought location id from World Location. but isn't

[Sandro1029]

Originally Posted by chet108

wow i thought location id from World Location. but isn't

Location which exist in your monster resource is a string. It uses only in quest window to make easier to find a mob (it will appear when you're hovering mouse cursor to a mob which you need to kill for a quest in quest window)

World location table for your minimap text and on entering location event (the big location name text appears on the center of your screen)

[chet108]

1. how to replace "new horizon" in OpenRZ to old horizon?
2. anyone have lua for rdb tools for OpenRZ?

[SilentWisdom]

Originally Posted by chet108

1. how to replace "new horizon" in OpenRZ to old horizon?
2. anyone have lua for rdb tools for OpenRZ?

Can't remember if released openrz client has the OceanWisdom Horizon or Horizon v3 (based on inkdevils horizon v2)

Eitherway.

1. Dump `m009_004` files from a retail 72 client
2. Replace the the map files in the target client
3. Put all .nf*, .qpf in Server/Newmap
4. Run `update` query to select original npc locations from a vanilla 72 table (rdb?) and apply them to the npcs (to reset them to stock location)

I don't think we ever put new regions (.nfc) in the `new` horizon so shouldn't need to edit worldlocation