- Joined
- Aug 4, 2004
- Messages
- 138
- Reaction score
- 29
Ill do this in order on how to fix it 100% after installing the 6.0.7 server files and following the Sql install from the Guid here ... after tables are installed and you have it all setup created these tables ....
Add these to ROM_ImportDB
WeekInstances
Table_ItemCombine <--- Thanks to LifeFire
BuffSchedule
Next you have to fix your RoleData table in ROM_World, So add these 5 columns like this
Next you have to Fix the Missing tables in ROM_Account by adding theses
Make sure you add in your AccountTable with the correct login and password based on the Account you made prier to this ... This will be your Login for RA_Server Monitor
That should fix the DB issues when you login .... Now lets fix the missing tables that throw errors Later as you login to the game .... add these Next with ....
Your all done So far for me there has been NO sql errors reported to LOGs if i see any more ill post another Topic .... Thanks all hope this helps .......
would be the last one....
<---------- Click the Thumbs up if you like thanks ....
Add these to ROM_ImportDB
WeekInstances
Code:
CREATE TABLE [dbo].[WeekInstances](
[WorldID] [int] NOT NULL,
[ZoneID] [int] NOT NULL,
[ZoneGroupID] [int] NOT NULL,
[Clock] [int] NOT NULL,
[SysTime] [bigint] NOT NULL,
[SysTime_Base] [bigint] NOT NULL,
[PKType] [int] NOT NULL,
[NowStr] [int] NOT NULL,
[Now] [bigint] NOT NULL,
[Now_Float] [float] NOT NULL,
[Day] [int] NOT NULL,
[IsPvE] [int] NOT NULL,
[TimeZone] [int] NULL,
[MaxVocCount] [int] NOT NULL
) ON [PRIMARY]
GOTable_ItemCombine <--- Thanks to LifeFire
Code:
CREATE TABLE [dbo].[Table_ItemCombine](
[GUID] [int] IDENTITY(1,1) NOT NULL,
[GroupID] [int] NOT NULL,
[ProductID] [int] NOT NULL,
[ProductCount] [int] NOT NULL,
[SourceID1] [int] NOT NULL,
[SourceID2] [int] NOT NULL,
[SourceID3] [int] NOT NULL,
[SourceID4] [int] NOT NULL,
[SourceID5] [int] NOT NULL,
[SourceCount1] [int] NOT NULL,
[SourceCount2] [int] NOT NULL,
[SourceCount3] [int] NOT NULL,
[SourceCount4] [int] NOT NULL,
[SourceCount5] [int] NOT NULL,
CONSTRAINT [PK_Table_ItemCombine] PRIMARY KEY CLUSTERED
(
[GUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GOBuffSchedule
Code:
CREATE TABLE [dbo].[BuffSchedule](
[WorldID] [int] NOT NULL,
[ZoneID] [int] NOT NULL,
[BuffID] [int] NOT NULL,
[BuffLv] [int] NOT NULL,
[StartTime] [real] NOT NULL,
[EndTime] [real] NOT NULL
) ON [PRIMARY]
GONext you have to fix your RoleData table in ROM_World, So add these 5 columns like this
Code:
ALTER TABLE RoleData
ADD mirrorcoin [int] NOT NULL CONSTRAINT [DF_RoleData_mirrorcoin] DEFAULT ((0)),
phantom [int] NOT NULL CONSTRAINT [DF_RoleData_phantom] DEFAULT ((0)),
weekinstance binary(20) NULL,
weekinstday [int] NOT NULL CONSTRAINT [DF_RoleData_weekinstday] DEFAULT ((0)),
weekresetcount [int] NOT NULL CONSTRAINT [DF_RoleData_weekresetcount] DEFAULT ((0))
GO
UPDATE [ROM_World].[dbo].[RoleData]
set weekinstance = CONVERT(BINARY,'')
GONext you have to Fix the Missing tables in ROM_Account by adding theses
Code:
CREATE TABLE [dbo].[AccountTable](
[Account] varchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Password] varchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ManageLv] int DEFAULT ((0)) NOT NULL,
[LoggedIn] int DEFAULT ((0)) NOT NULL,
[DateDiff] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ActionLog](
[Account] [varchar](32) NOT NULL,
[Action] [varchar](64) NOT NULL,
[Time] [smalldatetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LoginHistory](
[Account] [varchar](32) NOT NULL,
[Type] [varchar](32) NOT NULL,
[Time] [smalldatetime] NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[ActionLog] ALTER COLUMN [Account] VARCHAR(250)
ALTER TABLE [dbo].[ActionLog] ALTER COLUMN [Action] VARCHAR(250)
GOMake sure you add in your AccountTable with the correct login and password based on the Account you made prier to this ... This will be your Login for RA_Server Monitor
That should fix the DB issues when you login .... Now lets fix the missing tables that throw errors Later as you login to the game .... add these Next with ....
Code:
USE [ROM_ImportDB]
GO
/***** LoginBonus sql ********/
DROP TABLE [dbo].[LoginBonusDescription];
DROP TABLE [dbo].[LoginBonusConstraint];
DROP TABLE [dbo].[LoginBonusBase];
DROP TABLE [dbo].[LoginBonusStamp];
DROP TABLE [dbo].[LoginBonusReceipt];
DROP TABLE [dbo].[LoginBonusItem];
DROP TABLE [dbo].[LoginBonusBoost];
/**** Healthtime sql *****/
DROP TABLE [dbo].[HealthTime];
/**** Bank Sql ******/
DROP TABLE [dbo].[ImportMoney];
DROP TABLE [dbo].[Bank];
DROP TABLE [dbo].[BankLog];
/****** Object: Table [dbo].[LoginBonusxxxxx] Script Date: 1/29/2020 11:53:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoginBonusDescription](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[Description] nvarchar(512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] smalldatetime DEFAULT ((0)) NOT NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LoginBonusConstraint](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[BaseGUID] int DEFAULT ((0)) NOT NULL,
[Type] int DEFAULT ((0)) NOT NULL,
[Value1] int DEFAULT ((0)) NOT NULL,
[Value2] int DEFAULT ((0)) NOT NULL,
[Value3] int DEFAULT ((0)) NOT NULL,
[Value4] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LoginBonusBase](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[ToWho] int DEFAULT ((0)) NOT NULL,
[StartDate] smalldatetime DEFAULT ((0)) NOT NULL,
[EndDate] smalldatetime DEFAULT ((0)) NOT NULL,
[Money] int DEFAULT ((0)) NOT NULL,
[Status] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LoginBonusStamp](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[Account] int DEFAULT ((0)) NOT NULL,
[WorldID] int DEFAULT ((0)) NOT NULL,
[PlayerDBID] int DEFAULT ((0)) NOT NULL,
[Date] smalldatetime DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LoginBonusReceipt](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[BaseGUID] int DEFAULT ((0)) NOT NULL,
[PlayerDBID] int DEFAULT ((0)) NOT NULL,
[Account] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoginBonusItem](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[BaseGUID] int DEFAULT ((0)) NOT NULL,
[OrgObjID] int DEFAULT ((0)) NOT NULL,
[Count] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoginBonusBoost](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[BaseGUID] int DEFAULT ((0)) NOT NULL,
[MagicID] int DEFAULT ((0)) NOT NULL,
[MagicLv] int DEFAULT ((0)) NOT NULL,
[EffectTime] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
/*****************************************/
CREATE TABLE [dbo].[ImportMoney](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[Money1] int DEFAULT ((0)) NOT NULL,
[ProcessTime] int DEFAULT ((0)) NOT NULL,
[ToAccount] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Bank](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[Money1] int DEFAULT ((0)) NOT NULL,
[Account] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[BankLog](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[Source] int DEFAULT ((0)) NOT NULL,
[Account] int DEFAULT ((0)) NOT NULL,
[Amount] int DEFAULT ((0)) NOT NULL,
[Money1_Old] int DEFAULT ((0)) NOT NULL,
[Money1_New] int DEFAULT ((0)) NOT NULL
) ON [PRIMARY]
GO
/*******************************/
CREATE TABLE [dbo].[HealthTime](
[GUID] bigint IDENTITY(1,1) NOT NULL,
[ID] int DEFAULT ((0)) NOT NULL,
[LastRecordTime] datetime DEFAULT (getdate()) NOT NULL,
[HealthTime] datetime DEFAULT (getdate()) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WebShopBag]
ADD Account_ID varchar(63) NOT NULL
goYour all done So far for me there has been NO sql errors reported to LOGs if i see any more ill post another Topic .... Thanks all hope this helps .......
Code:
ALTER TABLE WebShopBag
ADD Account_ID varchar(63) NOT NULL
gowould be the last one....
<---------- Click the Thumbs up if you like thanks ....
Last edited:
