[Help Thread] Please post your questions here.

Can someone explain the price ratio please (from MarketResource)

Quote:

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

:cool:

Quote:

Originally Posted by thndr Code: 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) :cool:

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.

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

Quote:

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.

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

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.)

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

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
ok now every things is good . . after that
i go to ( gameserver.opt ) and edit it and set this value
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 !! [Only registered and activated users can see links. Click Here To Register...][Only registered and activated users can see links. Click Here To Register...]
it is just in 8.1 version [Only registered and activated users can see links. Click Here To Register...]

S:console._password:mypass2013

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

It is not hashed in any way?

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 `/´

Quote:

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 ?

Fixed