[HELP]Creating Guild Problem

Khaosrogue · 09/12/2011, 09:27

Basically whenever i create a guild ingame the server crashes and nobody can get online until i restart it

if you need anymore info please ask

~~Xx.LaMin.xX~~ · 09/12/2011, 10:12

is there any log we can see to help you out?

-Dizzy- · 09/12/2011, 10:58

there you go but next time please google it

Code:

Use PS_gamedata

drop table [dbo].[Guilds]

CREATE TABLE [dbo].[Guilds] (
	[RowID] [int] IDENTITY (1, 1) NOT NULL ,
	[GuildID] [int] NOT NULL ,
	[GuildName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[MasterUserID] [varchar] (18) COLLATE Latin1_General_CI_AS NOT NULL ,
	[MasterCharID] [int] NOT NULL ,
	[MasterName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[Country] [tinyint] NOT NULL ,
	[TotalCount] [smallint] NOT NULL ,
	[GuildPoint] [int] NOT NULL ,
	[Del] [tinyint] DEFAULT (0) ,
	[CreateDate] [datetime] (getdate())  ,
	[DeleteDate] [datetime] (getdate()) 
) ON [PRIMARY]

Khaosrogue · 09/12/2011, 13:30

Thanks Dizzy