[Help Thread] Please post your questions here.

[Minotaurus-Rappelz]

Can someone explain the price ratio please (from MarketResource)

[tokesbowls]

Originally Posted by thndr

Your missing both the column "type" at the end of the column names and a value to enter in for "type" at the end of the value strings.

It does not allow nulls so you need to tell it there is a type column and you need to tell it what value you want in it.

"type" should come right after "texture_group"

Could you please show me the correct way it should be, Ive been trying all day to fix it and no luck
Thank you

[ThunderNikk]

USE [Arcadia]
GO
/****** Object: Table [dbo].[NPCResource] Script Date: 07/29/2011 21:13:54 ******/
DELETE FROM [dbo].[NPCResource] WHERE (id = 9934) OR (id = 9935) OR (id = 9936) OR (id = 9937)
INSERT [dbo].[NPCResource] ([id], [text_id], [name_text_id], [race_id], [sexsual_id], [x], [y], [z], [face], [local_flag], [is_periodic], [begin_of_period], [end_of_period], [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]) VALUES (9934, 100009934, 105009934, 5, 1, 222207, 19947, 0, 0, 0, 0, CAST(0x00008EAC00000000 AS DateTime), CAST(0x00008EAC00000000 AS DateTime), -1, -4, 14, N'npc_asf_common004', 106, 10204, 233301, 0, 0, 0, 0, 303401, 304302, 0, 0, 412100, 423102, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'0', N'NPC_aio_shop_contact()', -1, 0)

[tokesbowls]

Originally Posted by thndr

USE [Arcadia]
GO
/****** Object: Table [dbo].[NPCResource] Script Date: 07/29/2011 21:13:54 ******/
DELETE FROM [dbo].[NPCResource] WHERE (id = 9934) OR (id = 9935) OR (id = 9936) OR (id = 9937)
INSERT [dbo].[NPCResource] ([id], [text_id], [name_text_id], [race_id], [sexsual_id], [x], [y], [z], [face], [local_flag], [is_periodic], [begin_of_period], [end_of_period], [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]) VALUES (9934, 100009934, 105009934, 5, 1, 222207, 19947, 0, 0, 0, 0, CAST(0x00008EAC00000000 AS DateTime), CAST(0x00008EAC00000000 AS DateTime), -1, -4, 14, npc_asf_common004, 106, 10204, 233301, 0, 0, 0, 0, 303401, 304302, 0, 0, 412100, 423102, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NPC_aio_shop_contact(), -1, 0)

thank you very much, now i get this error:
Msg 195, Level 15, State 10, Line 3
'NPC_aio_shop_contact' is not a recognized built-in function name.

[ThunderNikk]

Try it again I made a change I shouldn't have and I have edited my first post.

[tokesbowls]

Originally Posted by thndr

Try it again I made a change I shouldn't have and I have edited my first post.

I would like to tell you thank you for the help you have been providing me.

[Strange2010]

Hi . I would like to know what does this command do exactly (I mean the sconv):

sconv("@90010009", "#@creature_name@#",tostring(get_creature_value( handle, "name" )) ,"#@creature_level@#",tostring(lv))

[THePLayboyII]

Hallo,
Ich brauche dringend Hilfe.
Mein Kumpel kann bei mir auf dem PServer nicht joinen.
Da steht immer der Server ist in Wartung. Bitte Probieren sie es später nochmal.
Gegen Leistung.
Wenn der Server Online kommt wird derjenige GM auf meinem Server.

skype: nico.meiners

[TheOnlyOneRaskim]

Schick mal nen Screen von der Fehlermeldung und eventuell die Gamelog.txt.

Zusätzlich solltest du deine gameserver.opt und Authserver.opt hier reinstellen.


Und ein gut gemeinter rat, sollte es soweit kommen. Nur weil jemand es schafft deinen Server on zu bringen, sollte das nicht nen GM Posten wert sein. (Zumal GM sein heutzutage in der Pserver Szene eh nichts mehr wert ist.)

[tokesbowls]

Hello,
I was wondering if anyone has any custom pets, that wouldn't mind letting me use for my home server. If so please let me know. also anything custom 8.2 (dungeons/items/gear) is always welcomed :-)
Thank you again

[rakanomar]

hey , guys
at last time i thinking to built amazing tool for CaptainHerlock ,
in any way , i got a small problem !
the problem was in ( CONSOLE - TELNET )
ok , when i login at telnet using ( PuTTy ) to connect to the console for CaptainHerlock 8.1
it's relay connected but he asked for ! a password

[game001] remote control session.
Password:

ok now every things is good . . after that
i go to ( gameserver.opt ) and edit it and set this value

S:console._password:mypass2013

ok ! then i restart the CaptainHerlock and login to console using the ( PuTTy )
and i paste the password !! but he said ( Invalid password .)
any one ! knows what this problem !!
it is just in 8.1 version

[ThunderNikk]

S:console._password:mypass2013

Is how you put the password in, in the opt file?

It is not hashed in any way?

[Kanaan]

Hi all!

I am new to this whole server set up thing. I have a server running, can go in run around and kill stuff level up and all the normal stuff. But... I have no clue how to edit files (merchant items, hv pass and the such) Is there a SQL / .lua for dummies I can DL???

In the gameserver console, when I put this in:
#add_state(1011, 90, 9000000, Rayven) //Atk Spd

I get this, and no buff (All buffs give me the same error):
[string "add_state(1011, 90, 9000000, Rayven) //Atk Spd"]:1: unexpected symbol near `/´

[rakanomar]

Originally Posted by thndr

S:console._password:mypass2013

Is how you put the password in, in the opt file?

It is not hashed in any way?

ammmm do you think i must hashed it ? !!!!
and what type of hashed i should used ?

[tokesbowls]

Fixed