esoma character db

General assistance and guidelines for editing the server side of Soma.

Re: esoma character db

Postby savate » Mon Jul 08, 2013 9:20 pm

I am 99% sure the 10GB limit only on the express edition.

I would share the full version but as I do not know the forums policy on this so I will refrain from doing so.

Savate
savate
SD Four Star
SD Four Star
 
Posts: 208
Joined: Fri Sep 12, 2008 9:54 am

Re: esoma character db

Postby TwitcH » Mon Jul 08, 2013 9:23 pm

I've got the full version now :) just trying to get DB working, looks like NGSCUSER has been deleted. Can you do me a favor and send me the info to recreate the table so i don't have to restore another database? :)

TwitcH
User avatar
TwitcH
SD Three Star
SD Three Star
 
Posts: 72
Joined: Fri Apr 18, 2008 4:42 pm

Re: esoma character db

Postby savate » Mon Jul 08, 2013 9:32 pm

TwitcH wrote:I've got the full version now :) just trying to get DB working, looks like NGSCUSER has been deleted. Can you do me a favor and send me the info to recreate the table so i don't have to restore another database? :)

TwitcH


Code: Select all

USE [soma]
GO

/****** Object:  Table [dbo].[NGSCUSER]    Script Date: 07/08/2013 21:29:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[NGSCUSER](
   [strUserId] [varchar](12) NOT NULL,
   [strPasswd] [varchar](12) NOT NULL,
   [wSerial] [int] NOT NULL,
   [strName] [varchar](20) NOT NULL,
   [strSocNo] [varchar](50) NULL,
   [strEmail] [varchar](50) NOT NULL,
   [strPostalCode] [varchar](7) NULL,
   [strAddr1] [varchar](50) NULL,
   [strAddr2] [varchar](50) NULL,
   [strPhoneNo] [varchar](20) NULL,
   [strHandNo] [varchar](20) NULL,
   [strQuery1] [varchar](50) NULL,
   [strReply1] [varchar](50) NULL,
   [strQuery2] [varchar](50) NULL,
   [strReply2] [varchar](50) NULL,
   [bAdmin] [tinyint] NULL,
   [timeReg] [varchar](50) NULL,
   [timeLog] [smalldatetime] NULL,
   [bEmail] [tinyint] NULL,
   [strRecmd] [varchar](12) NULL,
   [nPayCount] [smallint] NULL,
   [nRecmdCount] [smallint] NULL,
   [nFreeTime] [smallint] NULL,
   [bSoma] [tinyint] NULL,
 CONSTRAINT [PK_NGSCUSER] PRIMARY KEY CLUSTERED
(
   [strUserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[NGSCUSER] ADD  CONSTRAINT [DF_NGSCUSER_timeReg_1]  DEFAULT (getdate()) FOR [timeReg]
GO

ALTER TABLE [dbo].[NGSCUSER] ADD  CONSTRAINT [DF_NGSCUSER_bEmail_1]  DEFAULT ((1)) FOR [bEmail]
GO

ALTER TABLE [dbo].[NGSCUSER] ADD  CONSTRAINT [DF_NGSCUSER_nFreeTime]  DEFAULT ((0)) FOR [nFreeTime]
GO

ALTER TABLE [dbo].[NGSCUSER] ADD  CONSTRAINT [DF_NGSCUSER_bSoma_1]  DEFAULT ((0)) FOR [bSoma]
GO



This should recreate the table for you, don't forget to change the database at the top of the code to the name of your database.

Savate
savate
SD Four Star
SD Four Star
 
Posts: 208
Joined: Fri Sep 12, 2008 9:54 am

Re: esoma character db

Postby TwitcH » Mon Jul 08, 2013 9:34 pm

Cheers matey :) saved me a fair bit of time. Just found my beta char, hes a whopping level 6 lol

TwitcH
User avatar
TwitcH
SD Three Star
SD Three Star
 
Posts: 72
Joined: Fri Apr 18, 2008 4:42 pm

Re: esoma character db

Postby TwitcH » Mon Jul 08, 2013 11:20 pm

New problem, when launching the 1p1 i get this error. Is the database missing this aswell?

Image

TwitcH
User avatar
TwitcH
SD Three Star
SD Three Star
 
Posts: 72
Joined: Fri Apr 18, 2008 4:42 pm

Previous

Return to Server Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron