Pet Error Log

[ejsayaaa]

thus this the cause of bug trap of Field Server?

[2014-08-16 03:11:15] In Packet Count 5/sec Traffic 215(bytes)/sec
[2014-08-16 03:11:15] Out Packet Count 488/sec Traffic 18621(bytes)/sec
[2014-08-16 03:11:15] Compress Count 132/sec Traffic 13530(bytes)/sec
[2014-08-16 03:11:15] Msg Queue Size 2997 Send 188055/1 Recv 24/975
[2014-08-16 03:11:24] ERROR : dwGUID>=m_dwMaxClient PetGUID : -1 dwMaxClient : 999
[2014-08-16 03:11:24] ERROR : dwGUID>=m_dwMaxClient SummonGUID : -1 dwMaxClient : 999
[2014-08-16 03:11:47] ERROR : dwGUID>=m_dwMaxClient PetGUID : -1 dwMaxClient : 999
[2014-08-16 03:11:47] ERROR : dwGUID>=m_dwMaxClient SummonGUID : -1 dwMaxClient : 999
[2014-08-16 03:11:53] ERROR : dwGUID>=m_dwMaxClient PetGUID : -1 dwMaxClient : 999
[2014-08-16 03:11:53] ERROR : dwGUID>=m_dwMaxClient SummonGUID : -1 dwMaxClient : 999
[2014-08-16 03:12:05] ERROR : dwGUID>=m_dwMaxClient PetGUID : -1 dwMaxClient : 999
[2014-08-16 03:12:05] ERROR : dwGUID>=m_dwMaxClient SummonGUID : -1 dwMaxClient : 999

[MentaL]

[Claimie Darel]

try this

USE [RanGame1]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetName]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetChaNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetChaNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetType]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetType]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetStyle]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetStyle]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetColor]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetColor]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetFull]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetFull]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeleted]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeleted]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCreateDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCreateDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeletedDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeletedDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetPutOnItems]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetPutOnItems]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinStartDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinStartDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinTime]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinTime]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinScale]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinScale]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinMID]
END

GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PetInfo]') AND type in (N'U'))
DROP TABLE [dbo].[PetInfo]
GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PetInfo](
[PetNum] [int] NOT NULL,
[PetName] [varchar](20) NOT NULL,
[PetChaNum] [int] NOT NULL,
[PetType] [int] NOT NULL,
[PetMID] [int] NOT NULL,
[PetSID] [int] NOT NULL,
[PetStyle] [int] NOT NULL,
[PetColor] [int] NOT NULL,
[PetFull] [int] NOT NULL,
[PetDeleted] [int] NOT NULL,
[PetCreateDate] [datetime] NOT NULL,
[PetDeletedDate] [datetime] NOT NULL,
[PetPutOnItems] [image] NOT NULL,
[PetCardMID] [int] NOT NULL,
[PetCardSID] [int] NOT NULL,
[PetUniqueNum] [int] IDENTITY(1,1) NOT NULL,
[PetSkinStartDate] [datetime] NULL,
[PetSkinTime] [datetime] NULL,
[PetSkinScale] [int] NULL,
[PetSkinSID] [int] NULL,
[PetSkinMID] [int] NULL,
CONSTRAINT [PK_PetInfo] PRIMARY KEY CLUSTERED 
(
[PetUniqueNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [SECONDARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetNum] DEFAULT ((0)) FOR [PetNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetName] DEFAULT ('') FOR [PetName]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetChaNum] DEFAULT ((0)) FOR [PetChaNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetType] DEFAULT ((0)) FOR [PetType]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetMID] DEFAULT ((0)) FOR [PetMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSID] DEFAULT ((0)) FOR [PetSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetStyle] DEFAULT ((0)) FOR [PetStyle]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetColor] DEFAULT ((0)) FOR [PetColor]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetFull] DEFAULT ((1000)) FOR [PetFull]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeleted] DEFAULT ((0)) FOR [PetDeleted]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCreateDate] DEFAULT (getdate()) FOR [PetCreateDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeletedDate] DEFAULT (getdate()) FOR [PetDeletedDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetPutOnItems] DEFAULT ('') FOR [PetPutOnItems]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardMID] DEFAULT ((0)) FOR [PetCardMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardSID] DEFAULT ((0)) FOR [PetCardSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinStartDate] DEFAULT (getdate()) FOR [PetSkinStartDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinTime] DEFAULT (getdate()) FOR [PetSkinTime]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinScale] DEFAULT ((0)) FOR [PetSkinScale]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinSID] DEFAULT ((0)) FOR [PetSkinSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinMID] DEFAULT ((0)) FOR [PetSkinMID]
GO

- - - Updated - - -

then remove Hp+Mp+sp pet skill and hp Recovery