楼主可以替换1299部分表如 k_monster k_monster_item K_npc K_npcpos
不能保存可以了换成1299的,用命令换,先删除原来的表.
如建仓库(===内的代码)
===========================
CREATE TABLE [WAREHOUSE] (
[strAccountID] [varchar] (21) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NOT NULL ,
[nMoney] [int] NOT NULL CONSTRAINT [DF_WAREHOUSE_nMoney] DEFAULT (0),
[dwTime] [int] NOT NULL CONSTRAINT [DF_WAREHOUSE_dwTime] DEFAULT (0),
[WarehouseData] [varchar] (1600) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[strSerial] [varchar] (1600) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[strwarehousepw] [char] (16) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL CONSTRAINT [DF_WAREHOUSE_strwarehousepw] DEFAULT ('000000'),
CONSTRAINT [PK_WAREHOUSE] PRIMARY KEY CLUSTERED
(
[strAccountID]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
==========================
建角色表
==========================
CREATE TABLE [USERDATA] (
[strUserId] [varchar] (23) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NOT NULL ,
[Nation] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Nation] DEFAULT (0),
[Race] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Race] DEFAULT (1),
[Class] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Class] DEFAULT (0),
[HairColor] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Gender] DEFAULT (0),
[Rank] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Rank] DEFAULT (0),
[Title] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Title] DEFAULT (0),
[Level] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Level] DEFAULT (1),
[Exp] [int] NOT NULL CONSTRAINT [DF_USERDATA_Exp] DEFAULT (1),
[Loyalty] [int] NOT NULL CONSTRAINT [DF_USERDATA_Loyalty] DEFAULT (50),
[Face] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Religion] DEFAULT (0),
[City] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_City] DEFAULT (0),
[Knights] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Knights] DEFAULT (0),
[Fame] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Fame] DEFAULT (0),
[Hp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Hp] DEFAULT (100),
[Mp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Mp] DEFAULT (100),
[Sp] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_Sp] DEFAULT (100),
[Strong] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Str] DEFAULT (0),
[Sta] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Sta] DEFAULT (0),
[Dex] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Dex] DEFAULT (0),
[Intel] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Intel] DEFAULT (0),
[Cha] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Cha] DEFAULT (0),
[Authority] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Authority] DEFAULT (1),
[Points] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Points] DEFAULT (0),
[Gold] [int] NOT NULL CONSTRAINT [DF_USERDATA_Gold] DEFAULT (0),
[Zone] [tinyint] NOT NULL CONSTRAINT [DF_USERDATA_Zone] DEFAULT (1),
[Bind] [smallint] NULL ,
[PX] [int] NOT NULL CONSTRAINT [DF_USERDATA_PX] DEFAULT (268100),
[PZ] [int] NOT NULL CONSTRAINT [DF_USERDATA_PZ] DEFAULT (131000),
[PY] [int] NOT NULL CONSTRAINT [DF_USERDATA_PY] DEFAULT (0),
[dwTime] [int] NOT NULL CONSTRAINT [DF_USERDATA_dwTime] DEFAULT (0),
[strSkill] [varchar] (10) COLLATE Chinese_PRC_Stroke_CI_AS NULL CONSTRAINT [DF_USERDATA_strSkill] DEFAULT (0x00),
[strItem] [varchar] (400) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[strSerial] [varchar] (400) COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS NULL ,
[sQuestCount] [smallint] NOT NULL CONSTRAINT [DF_USERDATA_sQuestCount_1] DEFAULT (0),
[strQuest] [varchar] (400) COLLATE Chinese_PRC_Stroke_CI_AS NULL ,
[MannerPoint] [int] NOT NULL CONSTRAINT [DF_USERDATA_MannerPoint] DEFAULT (500),
[LoyaltyMonthly] [int] NOT NULL CONSTRAINT [DF_USERDATA_LoyaltyMonthly] DEFAULT (0),
[CreateTime] [smalldatetime] NOT NULL CONSTRAINT [DF_USERDATA_CreateTime_1] DEFAULT (getdate()),
[UpdateTime] [smalldatetime] NULL ,
[d_id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_USERDATA] PRIMARY KEY CLUSTERED
(
[strUserId]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
=============================
以上两个表就可以解决装备保存的问题了.
仓库密码方面还需要要过程. |
惨至今1299中。。
