- Joined
- Sep 10, 2007
- Messages
- 968
- Reaction score
- 815
To view the content, you need to sign in or register
That link is the current SVN I have setup for my emulator. As of right now I have login and character list done. Just a bit busy with family in town, I'll try to make it to channels by tonight.
Edit:
DB.sql
Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Character]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Character](
[CID] [int] IDENTITY(1,1) NOT NULL,
[AID] [int] NOT NULL,
[Name] [varchar](16) NOT NULL,
[Level] [int] NOT NULL DEFAULT ((1)),
[Sex] [int] NOT NULL DEFAULT ((0)),
[Head] [int] NULL DEFAULT ((0)),
[Body] [int] NULL DEFAULT ((0)),
[Hands] [int] NULL DEFAULT ((0)),
[Legs] [int] NULL DEFAULT ((0)),
[Feet] [int] NULL DEFAULT ((0)),
[WeaponPrimary] [int] NULL DEFAULT ((0)),
[WeaponSecondary] [int] NULL DEFAULT ((0)),
[Melee] [int] NULL DEFAULT ((0)),
[ItemPrimary] [int] NULL DEFAULT ((0)),
[ItemSecondary] [int] NULL DEFAULT ((0)),
[RingPrimary] [int] NULL DEFAULT ((0)),
[RingSecondary] [int] NULL DEFAULT ((0)),
[CLID] [int] NULL DEFAULT ((0)),
[Kills] [int] NULL DEFAULT ((0)),
[Deaths] [int] NULL DEFAULT ((0)),
[TimePlayed] [bigint] NULL DEFAULT ((0)),
[MatchesWon] [int] NULL DEFAULT ((0)),
[Index] [int] NULL DEFAULT ((0)),
[Face] [int] NULL DEFAULT(0),
[Hair] [int] NULL DEFAULT(0),
[BP] [int] NULL DEFAULT(0),
[XP] [int] NULL DEFAULT(0)
CONSTRAINT [PK_Character] PRIMARY KEY CLUSTERED
(
[CID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Account]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Account](
[AID] [int] NOT NULL IDENTITY(1,1),
[UserID] [varchar](32) NOT NULL,
[Password] [varchar](64) NOT NULL,
[UGradeID] [int] NOT NULL,
[PGradeID] [int] NOT NULL,
[Name] [varchar](20) NULL,
[Email] [varchar](50) NULL,
[LastIP] [varchar](20) NULL,
[LastConnectDate] [datetime] NULL,
CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED
(
[AID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
![ThePhailure772 - [Development]Gunz GameServer - RaGEZONE Forums](https://forum.ragezone.com/images/404_image.png "ThePhailure772 - [Development]Gunz GameServer - RaGEZONE Forums")
]
