CREATE TABLE [dbo].[tblBillID] (
[Version2] [int] NOT NULL ,
[BillID] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Password] [varchar] (28) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FirstLogin] [datetime] NULL ,
[LastLogin] [datetime] NULL ,
[LastLogout] [datetime] NULL ,
[TotalRunTime] [int] NULL ,
[ThisMonthTime] [int] NULL ,
[FreeLevel] [int] NULL ,
[FreeTimer] [int] NULL ,
[FreeDate] [datetime] NULL ,
[TempFreeDate] [datetime] NULL ,
[TempModifyDate] [datetime] NULL ,
[SecurityNum1] [int] NOT NULL ,
[SecurityNum2] [int] NOT NULL ,
[EMail] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[Address] [char] (120) COLLATE Chinese_PRC_CI_AS NULL ,
[Name] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[TelephoneNumber] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[Profile] [char] (92) COLLATE Chinese_PRC_CI_AS NULL ,
[Memo] [char] (512) COLLATE Chinese_PRC_CI_AS NULL ,
[BillState] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[FirstLoginMethod] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[Note1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note2] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note3] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note4] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note5] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note6] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note7] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note8] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note9] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note10] [char] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[tblSpecialItem1] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ItemKind] [int] NOT NULL ,
[ItemIndex] [int] NOT NULL ,
[ItemDurability] [int] NOT NULL ,
[Position] [int] NOT NULL ,
[Map] [int] NOT NULL ,
[X] [int] NOT NULL ,
[Y] [int] NOT NULL ,
[TileKind] [int] NOT NULL ,
[GameID] [varchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[WindowKind] [int] NOT NULL ,
[WindowIndex] [int] NOT NULL ,
[MiscTime] [datetime] NOT NULL ,
[AttackGrade] [int] NOT NULL ,
[StrengthGrade] [int] NOT NULL ,
[SpiritGrade] [int] NOT NULL ,
[DexterityGrade] [int] NOT NULL ,
[PowerGrade] [int] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblGameID1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblGameID1]
GO
CREATE TABLE [dbo].[tblGameID1] (
[Version] [int] NOT NULL ,
[GameID] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BillID] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Lvl] [int] NOT NULL ,
[Face] [tinyint] NOT NULL ,
[Map] [int] NOT NULL ,
[X] [int] NOT NULL ,
[Y] [int] NOT NULL ,
[TileKind] [bit] NOT NULL ,
[Item] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Equipment] [varchar] (280) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Skill] [varchar] (120) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SpecialSkill] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Strength] [int] NOT NULL ,
[Spirit] [int] NOT NULL ,
[Dexterity] [int] NOT NULL ,
[Power] [int] NOT NULL ,
[Fame] [int] NOT NULL ,
[Experiment] [int] NOT NULL ,
[HP] [int] NOT NULL ,
[MP] [int] NOT NULL ,
[SP] [int] NOT NULL ,
[DP] [int] NOT NULL ,
[Bonus] [int] NOT NULL ,
[Money] [int] NOT NULL ,
[QuickItem] [varchar] (160) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[QuickSkill] [int] NOT NULL ,
[QuickSpecialSkill] [int] NOT NULL ,
[BankMoney] [int] NOT NULL ,
[BankItem] [varchar] (400) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SETimer] [varchar] (400) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[PKTimer] [int] NOT NULL ,
[Color1] [int] NULL ,
[Color2] [int] NULL ,
[PoisonUsedDate] [datetime] NOT NULL ,
[LovePoint] [int] NOT NULL ,
[ArmyHired] [int] NOT NULL ,
[ArmyMarkIndex] [int] NOT NULL ,
[Permission] [int] NOT NULL ,
[BonusInitCount] [int] NOT NULL ,
[StoryQuestState] [int] NOT NULL ,
[QuestItem] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SubQuestKind] [int] NOT NULL ,
[SubQuestDone] [int] NOT NULL ,
[SubQuestClientNPCID] [varchar] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SubQuestClientNPCFace] [int] NOT NULL ,
[SubQuestClientNPCMap] [int] NOT NULL ,
[SubQuestItem] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SubQuestDestFace] [int] NOT NULL ,
[SubQuestDestMap] [int] NOT NULL ,
[SubQuestTimer] [int] NOT NULL ,
[SubQuestGiftExperience] [int] NOT NULL ,
[SubQuestGiftFame] [int] NOT NULL ,
[SubQuestGiftItem] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[OPArmy] [int] NOT NULL ,
[OPPKTimer] [int] NOT NULL ,
[SurvivalEvent] [int] NOT NULL ,
[SurvivalTime] [int] NOT NULL ,
[Bonus2] [int] NOT NULL ,
[SBonus] [int] NOT NULL ,
[STotalBonus] [int] NOT NULL ,
[PKPenaltyCount] [int] NOT NULL ,
[PKPenaltyDecreaseTimer] [int] NOT NULL ,
[SigMoney] [int] NOT NULL ,
[BankSigMoney] [int] NOT NULL ,
[BankItem2] [varchar] (400) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[TLETimer] [varchar] (400) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
如何在人物身上加入装备
在数据库里有个表文件tblSpecialItem1中。。把水代码200换上,人物名写上就行
ID不用填,系统自动编号;Itemkind是物品种类,特