Quote:
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)
[Only registered and activated users can see links. Click Here To Register...]
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)
[Only registered and activated users can see links. Click Here To Register...]
dbo.StringLocalResource
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:
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:
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:
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