[Read bevor you ask] Answer to the most question![FAQ]

Quote:

Originally Posted by Lord.Flame

Where I put that code for fix guild deletion when restart server?

All you have to do if your guilds that were in game then disappear after restart of your server, by seeing it will say its in your database still but in game it is not, how to fix go to the database edit table guilds.dbo then copy all that to a notepad, then delete guild.dbo table and open new query and paste the code that you got when editing guild.dbo table, where you pasted it to your notepad then execute, that should fix the glitch sometimes it will glitch up if you are not careful when editing in database or such as that.
[Only registered and activated users can see links. Click Here To Register...]

Code:

USE [PS_GameData]
GO
/****** Object:  Table [dbo].[Guilds]    Script Date: 09/14/2013 21:24:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Guilds](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[GuildID] [int] NOT NULL,
	[GuildName] [varchar](30) NOT NULL,
	[MasterUserID] [varchar](12) NOT NULL,
	[MasterCharID] [int] NOT NULL,
	[MasterName] [varchar](30) NOT NULL,
	[Country] [tinyint] NOT NULL,
	[TotalCount] [smallint] NOT NULL,
	[GuildPoint] [int] NOT NULL,
	[Del] [tinyint] NOT NULL CONSTRAINT [DF_Guilds_Del]  DEFAULT (0),
	[CreateDate] [datetime] NOT NULL,
	[DeleteDate] [datetime] NULL,
 CONSTRAINT [PK_Guilds] PRIMARY KEY CLUSTERED 
(
	[GuildID] 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