|
You last visited: Today at 10:59
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
06/27/2013, 00:25
|
#1996
|
elite*gold: 0
Join Date: Jun 2013
Posts: 22
Received Thanks: 0
|
Can someone explain the price ratio please (from MarketResource)
|
|
|
06/27/2013, 03:28
|
#1997
|
elite*gold: 0
Join Date: Nov 2009
Posts: 307
Received Thanks: 32
|
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
|
|
|
06/27/2013, 03:59
|
#1998
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,779
Received Thanks: 1,461
|
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, 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)
|
|
|
06/27/2013, 04:20
|
#1999
|
elite*gold: 0
Join Date: Nov 2009
Posts: 307
Received Thanks: 32
|
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)
|
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.
|
|
|
06/27/2013, 04:44
|
#2000
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,779
Received Thanks: 1,461
|
Try it again I made a change I shouldn't have and I have edited my first post.
|
|
|
06/27/2013, 04:59
|
#2001
|
elite*gold: 0
Join Date: Nov 2009
Posts: 307
Received Thanks: 32
|
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.
|
|
|
06/27/2013, 14:15
|
#2002
|
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 294
|
Hi . I would like to know what does this command do exactly (I mean the sconv):
Code:
sconv("@90010009", "#@creature_name@#",tostring(get_creature_value( handle, "name" )) ,"#@creature_level@#",tostring(lv))
|
|
|
06/27/2013, 18:56
|
#2003
|
elite*gold: 0
Join Date: Nov 2011
Posts: 38
Received Thanks: 3
|
Keiner kann bei meinem Pserver joinen
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
|
|
|
06/27/2013, 20:49
|
#2004
|
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,011
|
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.)
|
|
|
06/28/2013, 00:45
|
#2005
|
elite*gold: 0
Join Date: Nov 2009
Posts: 307
Received Thanks: 32
|
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
|
|
|
06/28/2013, 09:46
|
#2006
|
elite*gold: 0
Join Date: Jun 2012
Posts: 49
Received Thanks: 49
|
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
Code:
[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
Code:
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
|
|
|
06/28/2013, 13:16
|
#2007
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,779
Received Thanks: 1,461
|
S:console._password:mypass2013
Is how you put the password in, in the opt file?
It is not hashed in any way?
|
|
|
06/28/2013, 15:20
|
#2008
|
elite*gold: 0
Join Date: May 2013
Posts: 14
Received Thanks: 0
|
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 `/´
|
|
|
06/28/2013, 15:27
|
#2009
|
elite*gold: 0
Join Date: Jun 2012
Posts: 49
Received Thanks: 49
|
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 ?
|
|
|
06/28/2013, 18:21
|
#2010
|
elite*gold: 0
Join Date: Nov 2009
Posts: 307
Received Thanks: 32
|
Fixed
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +2. The time now is 10:59.
|
|