Rappelz server files

[DrakuLL777]

Fix of invisible walls!
Who has such problem!!!
In a folder "NewMap" your server there is a file "m010_003.nfa" from 10/6/2009 18:23 65,8 KB (67 392 byte).
Replace it with a file "m010_003.nfa" from 3/25/2009 17:19 62,4 KB (63 988 byte) - it is possible to take it from old releases of the server!!!

[lilnani]

any one have pet bug fix

[insaneblade87]

Originally Posted by lilnani

any one have pet bug fix

just download the new database repack 2 pages back. or go back 30+ pages and fix by hand like most did..

[kaizoku801]

Following Jw's guide perfectly till the end.. i noticed i crashed at login screen trying to login as admin, password admin

after few glances at files i tried
login: admin
pass: 2011

and it worked...

im not sure why it kicked me out tho (didnt change anything in between the password changes) but, TY jw for not giving up on us

1st time user of MS SQL and got it right at the first time.. easy to understand guide. ty

[Pyrok]

Originally Posted by khshe

portals in the dungeon is?

Broken. Along with the mob spawns. We do know what is wrong (missing actually) and how to fix it but it's going to take time. One of us will post the fixes once they are done.

[Ray9000]

Hey, i think i did alright but if i start the captainherlockserver.exe, theres a problem. I hope you can help me

[harmbasi]

@ Ray9000 everyone has that problem. Monsters don't spawn right now. Pyrok and the other devs are working on fixing that. You can still run your own server with those errors but there are limited mobs in certain areas.

[sharkattackz]

Thanks for the guide and all the work you guys put into this!
Which program do I have to use to change the 'permission' value in dbo.Character?

[njimko]

Originally Posted by sharkattackz

Thanks for the guide and all the work you guys put into this!
Which program do I have to use to change the 'permission' value in dbo.Character?

You have to go into Microsoft SQL Server Management Studio, connect to the database, go into the Telecaster database, under tables right click dbo.Character and hit Edit top 200 rows, then scroll to the right and put a 1 in the permission column.

[kaizoku801]

also you need to be logged out (preferably in the character selection screen) for the changes made through dbo.character to take effect

also jw, followin your guide (which was easy and no problems occured) upon opening creature formation it says "creature not found / creature does not exist" (one of those) so i cant even put the pet in there... there was a fix for it i think at pages 45-47 or so... but where exactly do i input those lines?

Thanks in advance ^^

[njimko]

Originally Posted by kaizoku801

also you need to be logged out (preferably in the character selection screen) for the changes made through dbo.character to take effect

also jw, followin your guide (which was easy and no problems occured) upon opening creature formation it says "creature not found / creature does not exist" (one of those) so i cant even put the pet in there... there was a fix for it i think at pages 45-47 or so... but where exactly do i input those lines?

Thanks in advance ^^

Here are all the values for 4 tables that involve creatures. They are in the Arcadia Database.
(dbo.StringLocalResource, dbo.SummonDefaultNameResource, dbo.SummonLevelResource, dbo.SummonResource)



Here are queries to CREATE the tables. (You have to delete the current tables in order to use the queries below.)

To use the queries goto Microsoft SQL Server Management Studio and connect to your databases, then click on New Query on the top left of the screen just under the file menu. It will probably open up the connection dialog again, just hit connect. Then in the blank area in the middle of the screen paste one of the queries below. After you pasted one hit the Execute button the the bar at the top of the screen. Repeat for each one.

After you run the queries you can copy the data from the excel files to the tables. To do this goto excel and open one of the files, hit Ctrl+A, then Ctrl+C, then goto Microsoft SQL Server Management Studio, and Edit the top 200 rows of the table you're working on, then left click on the blank area where the rows and column meet and right click and hit paste. Repeat for all.
(Picture below to explain exactly where I'm talking about)


dbo.StringLocalResource

 Spoiler

USE [Arcadia]
GO

/****** Object: Table [dbo].[StringLocalResource] Script Date: 05/11/2011 16:49:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[StringLocalResource](
[name] [varchar](64) NOT NULL,
[group_id] [int] NOT NULL,
[code] [int] NOT NULL,
[value] [nvarchar](3072) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

dbo.SummonDefaultNameResource:

 Spoiler

USE [Arcadia]
GO

/****** Object: Table [dbo].[SummonDefaultNameResource] Script Date: 05/11/2011 16:50:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SummonDefaultNameResource](
[sid] [int] NOT NULL,
[is_post_fix] [int] NOT NULL,
[text_id] [int] NULL
) ON [PRIMARY]

GO

dbo.SummonLevelResource:

 Spoiler

USE [Arcadia]
GO

/****** Object: Table [dbo].[SummonLevelResource] Script Date: 05/11/2011 16:50:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SummonLevelResource](
[level] [int] NOT NULL,
[normal_exp] [bigint] NOT NULL,
[growth_exp] [bigint] NOT NULL,
[evolve_exp] [bigint] NOT NULL,
CONSTRAINT [IX_SummonLevelResource] UNIQUE NONCLUSTERED
(
[level] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

dbo.SummonResource:

 Spoiler

USE [Arcadia]
GO

/****** Object: Table [dbo].[SummonResource] Script Date: 05/11/2011 16:50:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SummonResource](
[id] [int] NOT NULL,
[model_id] [int] NOT NULL,
[name_id] [int] NOT NULL,
[type] [int] NOT NULL,
[magic_type] [int] NOT NULL,
[rate] [tinyint] NOT NULL,
[stat_id] [int] NOT NULL,
[size] [decimal](10, 2) NOT NULL,
[scale] [decimal](10, 2) NOT NULL,
[target_fx_size] [decimal](10, 2) NOT NULL,
[standard_walk_speed] [int] NOT NULL,
[standard_run_speed] [int] NOT NULL,
[riding_speed] [int] NOT NULL,
[run_speed] [int] NOT NULL,
[is_riding_only] [tinyint] NOT NULL,
[riding_motion_type] [int] NOT NULL,
[attack_range] [decimal](10, 2) NOT NULL,
[walk_type] [int] NOT NULL,
[slant_type] [int] NOT NULL,
[material] [int] NOT NULL,
[weapon_type] [int] NOT NULL,
[attack_motion_speed] [int] NOT NULL,
[form] [int] NOT NULL,
[evolve_target] [int] NOT NULL,
[camera_x] [int] NOT NULL,
[camera_y] [int] NOT NULL,
[camera_z] [int] NOT NULL,
[target_x] [decimal](10, 2) NOT NULL,
[target_y] [decimal](10, 2) NOT NULL,
[target_z] [decimal](10, 2) NOT NULL,
[model] [varchar](256) NOT NULL,
[motion_file_id] [int] NOT NULL,
[face_id] [int] NOT NULL,
[face_file_name] [varchar](256) NOT NULL,
[card_id] [int] NOT NULL,
[script_text] [varchar](256) NOT NULL,
[illust_file_name] [varchar](256) NOT NULL,
[text_feature_id] [int] NOT NULL,
[text_name_id] [int] NOT NULL,
[skill1_id] [int] NOT NULL,
[skill1_text_id] [int] NOT NULL,
[skill2_id] [int] NOT NULL,
[skill2_text_id] [int] NOT NULL,
[skill3_id] [int] NOT NULL,
[skill3_text_id] [int] NOT NULL,
[skill4_id] [int] NOT NULL,
[skill4_text_id] [int] NOT NULL,
[skill5_id] [int] NOT NULL,
[skill5_text_id] [int] NOT NULL,
[texture_group] [int] NOT NULL,
[local_flag] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[Menille]

I have read some pages of this thread, and i didn't found how to spawn a boss.
Anyone can tell me how please ?
I have my server fully worked.

PS : this is my first post on this thread.

[pablunix]

help!! the server not work

[leduan]

Originally Posted by pablunix

help!! the server not work

thats my problem too =(

[insaneblade87]

Originally Posted by Pyrok

Broken. Along with the mob spawns. We do know what is wrong (missing actually) and how to fix it but it's going to take time. One of us will post the fixes once they are done.

start with CV the portals to CV are indeed there . maybe could find a way from there? we have the tele cords in db to each area i'm guessing it has something to do with the object+script maybe?







& yeah does anyone know how to spawn mobs at all yet?