[Help Thread] Please post your questions here.

[ThunderNikk]

Originally Posted by Azreil

(0 row(s) affected)

Worked for me (10 row(s) affected)

Not sure why it will not work for you.

Originally Posted by asthos

Ok now another Question about deleting (or hiding) xmas things

I want to hide the xmas objekts (Tree and Gifts)
The Event_NPC's are in the nirvans (local_flag!=0)

but where cani find the tree?

USE Arcadia
UPDATE FieldPropResource
SET local_flag = -1
WHERE file_name LIKE '%common_event_rangifer%'

This works

local permission = gv("permission")
	
	if permission == 100 then
		notice(gv ("name") , "is now connected.")
	end

Just prints it with a colon like this...

GM BlahBlahBlah: is now connected

[asthos]

Ok next Question about .lua Files

If i want to crate a new file with the heading:

function get_module_name()
    return "Meine_Lua"
end

function test_contact()
    	dlg_title("Subject")
	dlg_text("What do you want?")
        dlg_menu("Back.", "")
	dlg_show()
end

1.Question:

How do i have to name the .lua?
my other .lua-files in a folder look like:
9436be3b0987ccc10977e838ae234d88.lua
Is it dispending to the return "meine_lua"?

2.Question:

What makes the "dlg_title" nowhere i see something with "Subect"
when i klick on an NPC, but it is important to use, else
there are ?????????? in the text

3.Question
What is important for return?

[Azreil]

May I re-ask about questions #1 and #3 please?
(Masters Hammer not working)
and
(A more ....detailed guide on how to edit npc items)

Thank you for any consideration guys. Really do appreciate all the help....you've been really amazing.

[ThunderNikk]

I just tested master hammer on my server and it worked fine.

You need to use the repair window and place the broken armor in the target slot and the hammer in the materials slot.

Maybe you have the wrong item IDs

But it does not work in the combine window as you were saying before. It says right on the hammer tool tip to use the repair window.

[Minotaurus-Rappelz]

Hi! My DEVs just let me alone to make NPCs and others. So I need some help.


1. How to make a shop NPC

2. I made a function to add a tp but how to make it so it costs JP.

3. How to take off the X-Mas NPCs


Also need a link to SQL Dev plz

[Azreil]

Originally Posted by thndr

I just tested master hammer on my server and it worked fine.

You need to use the repair window and place the broken armor in the target slot and the hammer in the materials slot.

Maybe you have the wrong item IDs

But it does not work in the combine window as you were saying before. It says right on the hammer tool tip to use the repair window.

And that is what the prob was. I must have scrambled the ID during one of my item insertion trials. Thank you for pointing me in right direction.

One last question remains....precisely how to edit (add/ change the price of) the npcs items? I read the "guide" on custom NPCs...but it is ...somewhat vague on a few details...and I'm not sure if it is compatible with the 8.1 files.
There use to be a comprehensive guide on this....but ...it seems to have vanished.

[tokesbowls]

Hello,
Quick couple questions, Maybe someone could answer them for me.
1. how to rename a custom npc
2. Looking for a retail dbo.marketresource, dont want anyones added stuff or kts stuff. want to add me own stuff.
3. looking for added dungeons or pets or other stuff to add to my server
4. how to change the pictures on game start
5. anyone got any codes for Lillith and Mephisto
Thank you again

[asthos]

Originally Posted by Minotaurus-Rappelz

Hi! My DEVs just let me alone to make NPCs and others. So I need some help.

1. How to make a shop NPC

2. I made a function to add a tp but how to make it so it costs JP.

3. How to take off the X-Mas NPCs

Also need a link to SQL Dev plz

To #1:

 Spoiler

what kind of shop?
Have there be only items? so u first have to insert the items in the MarketResource in the Db: Arcadia
like:

USE [Arcadia]
GO
INSERT INTO [dbo].[MarketResource]([sort_id],[name],[code],[price_ratio],[huntaholic_ratio],[arena_ratio])
VALUES ((select MAX(sort_id) FROM MarketResource)+1,'my_super_duper_market' ,ITEM ID,1,0,0)
GO


And then add in an function of a lua file with:

.
.
.
dlg_menu( "@90010062", "open_market( 'my_super_duper_market' )" )
.
.
.

BUT:
You couln't add in a market window tamed pets!!

Correct me if I'm wrong, i am just a hobby-developper who teach this stuff myself in 6 days

To #2:

 Spoiler

try something like this:

function change_tp_for_jp()
         local jp = get_value("jp")
        jp = tonumber(jp)
        local tp = get_value("tp")
        tp = tonumber(tp)
        if jp >= 1000000 then
               sv("jp", jp-100000)
               sv("tp", tp+1)
        else then
            notice("Hey everyone, "..get_value("name").." has not enough JP to change :D")
        end
end

To #3:

 Spoiler

In Your DB use the script 3 posts before.

Originally Posted by thndr

USE Arcadia
UPDATE NPCResource
SET local_flag = -1
WHERE contact_script LIKE '%NPC_event_2012_Xmas%'

Originally Posted by tokesbowls

Hello,
Quick couple questions, Maybe someone could answer them for me.
1. how to rename a custom npc
2. Looking for a retail dbo.marketresource, dont want anyones added stuff or kts stuff. want to add me own stuff.
3. looking for added dungeons or pets or other stuff to add to my server
4. how to change the pictures on game start
5. how to make a custom launcher

Thank you again

First of all:
What do you really want to do?
Do you want to make it professional or for hobby?
I think some numbers (#3, #4) seems to be needed more time you need for doing this.

#2:
what do you mean with "own stuff"?
stuff which you createt at your PC?
then you have to insert first the stuff in the DB. like in the db.ItemResource

if you have this section done then you can insert the id off the stuff in the Market Resource

see the post #1943 above

#5:


For awnsering two questions i think maybe nobody would read my question two pages before:

Originally Posted by asthos

Ok next Question about .lua Files

If i want to crate a new file with the heading:

function get_module_name()
    return "Meine_Lua"
end

function test_contact()
    	dlg_title("Subject")
	dlg_text("What do you want?")
        dlg_menu("Back.", "")
	dlg_show()
end

1.Question:

How do i have to name the .lua?
my other .lua-files in a folder look like:
9436be3b0987ccc10977e838ae234d88.lua
Is it dispending to the return "meine_lua"?

2.Question:

What makes the "dlg_title" nowhere i see something with "Subect"
when i klick on an NPC, but it is important to use, else
there are ?????????? in the text

3.Question
What is important for return?

[tokesbowls]

Originally Posted by asthos

To #1:

 Spoiler

what kind of shop?
Have there be only items? so u first have to insert the items in the MarketResource in the Db: Arcadia
like:

USE [Arcadia]
GO
INSERT INTO [dbo].[MarketResource]([sort_id],[name],[code],[price_ratio],[huntaholic_ratio],[arena_ratio])
VALUES ((select MAX(sort_id) FROM MarketResource)+1,'my_super_duper_market' ,ITEM ID,1,0,0)
GO


And then add in an function of a lua file with:

.
.
.
dlg_menu( "@90010062", "open_market( 'my_super_duper_market' )" )
.
.
.

BUT:
You couln't add in a market window tamed pets!!

Correct me if I'm wrong, i am just a hobby-developper who teach this stuff myself in 6 days

To #2:

 Spoiler

try something like this:

function change_tp_for_jp()
         local jp = get_value("jp")
        jp = tonumber(jp)
        local tp = get_value("tp")
        tp = tonumber(tp)
        if jp >= 1000000 then
               sv("jp", jp-100000)
               sv("tp", tp+1)
        else then
            notice("Hey everyone, "..get_value("name").." has not enough JP to change :D")
        end
end

To #3:

 Spoiler

In Your DB use the script 3 posts before.

First of all:
What do you really want to do?
Do you want to make it professional or for hobby?
I think some numbers (#3, #4) seems to be needed more time you need for doing this.

#2:
what do you mean with "own stuff"?
stuff which you createt at your PC?
then you have to insert first the stuff in the DB. like in the db.ItemResource

if you have this section done then you can insert the id off the stuff in the Market Resource

see the post #1943 above

#5:


For awnsering two questions i think maybe nobody would read my question two pages before:

1. Id like to the shop to be names what its selling, like say a weapon shop or pet shop, so forth
2. im looking for a retail dbo.itemresource. one with out the kts adds or someones shop adds. the one im currently using has been modded/added to. Im not sure what to remove with out hurting the game.
5. thank you

[asthos]

Originally Posted by tokesbowls

1. Id like to the shop to be names what its selling, like say a weapon shop or pet shop, so forth

2. im looking for a retail dbo.itemresource. one with out the kts adds or someones shop adds. the one im currently using has been modded/added to.

Im not sure what to remove with out hurting the game.

it's hard to find a retail db.itemresource.


and here i have found some interesting links for You from M>M:


to add server state checker to your launcher

all what you need to know abut the client and resource

to add skills of all classes and pets to the Cube [ENT] pet

learn some tricks to help you on your Server

enjoy a All In One NPC in your server

make it easier for you to find items codes from you DB

backup and clean you data faster and better

may be some thearets are old, but there you can get a some good backround knowledge

[tokesbowls]

Hello,
Could anyone tell me how to make a npc at:
222334, 20869

thank you

[ThunderNikk]

Originally Posted by tokesbowls

Hello,
Could anyone tell me how to make a npc at:
222334, 20869

thank you

Set your x , y for those values.

Set your local flag 1

Set periodic false

Set everything else for what NPC you want.

Set your contact_script for your lua.

[tokesbowls]

Can anyone please tell me how to rename a shop

So ive been trying to make a launcher with visual basic 2010
apon make my start button, in the video im watching it has me direct it to the games exe.
well im using a .bat and it doesnt work. does anyone know what im supposed to put in there?
thank you again

[ThunderNikk]

Originally Posted by tokesbowls

Can anyone please tell me how to rename a shop

1. Edit the two name columns for the NPC in the dbo.StringResource

2. Create a new db_string(ascii).rdb for the client after editing the server database.

Or

1. Change the string value in the name columns for a string value that says what you want it too.

Then there is no need for client update.

Use a query to search your string DB to find strings you may like, something like...

select * from arcadia.dbo.stringresource where (Type field you want to search here) like '%(search term here)%'

Just enter the field and the term without the ()

Originally Posted by tokesbowls

So ive been trying to make a launcher with visual basic 2010
apon make my start button, in the video im watching it has me direct it to the games exe.
well im using a .bat and it doesnt work. does anyone know what im supposed to put in there?
thank you again

I am not sure what you are doing but I dont think you can direct it toward your .bat but I think you need to type your .bat arguments in.

Like you need to use the command line

C:\Rappelz\Sframe.exe /auth_ip:xxx.xxx.xxx.xxx /auth_port:8841 / Yada Yada Yada

For where ever your install is.

[Minotaurus-Rappelz]

HELP!

I'm trying to delete these NPCs

Originally Posted by asthos

To #2:

[spoiler]
try something like this:

function change_tp_for_jp()
         local jp = get_value("jp")
        jp = tonumber(jp)
        local tp = get_value("tp")
        tp = tonumber(tp)
        if jp >= 1000000 then
               sv("jp", jp-100000)
               sv("tp", tp+1)
        else then
            notice("Hey everyone, "..get_value("name").." has not enough JP to change :D")
        end
end

Does not work...