红月服务器之关键数据!

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是物品种类,特

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值