Fix guild on private server

[ImortalPain]

Hello everyone, I still have bug on guild system, I have try alot way, I have set it up same as Twilight say on other forum but when i shut down server guild still disapear, also I noticed when i create a guild in game it dosent wrote any infos on guild.dbo table, it wrote only on guildchars.dbo.
Anyone can guide me on how fix it?
thanks

[patoringa]

I have the same problem here. The server is working fine. Some players have created a guild yesterday, and it worked until this morning.
When I rebooted the server, I was reported that the Guild has vanished.
I have checked the database and there is no guild there.
Help us!

[Sinthorn320]

Here are the fixes twilight had posted an to get them to work properly i would advise to delete ur old dbo.guilds an then run the query to create a whole new dbo. Heres the file. Credit goes to Twilight with this.

[patoringa]

Thx for help.

[ProfNerwosol]

There's an error in query. It will make every guild created to be auto dismissed.

[DeleteDate] [datetime] DEFAULT getdate() <-- you should not insert date here, instead change it to this (NOTE: remove brackets around date types):

[DeleteDate] datetime NULL

or run this (if you already recreated the table)

ALTER TABLE PS_GameData.dbo.Guilds ALTER COLUMN DeleteDate datetime NULL

I also recommend not to re-create tables unless it's necessary. This should solve your problem without recreating the table:

ALTER TABLE PS_GameData.dbo.Guilds ALTER COLUMN [GuildName] varchar (30) COLLATE Latin1_General_CI_AS NOT NULL;
ALTER TABLE PS_GameData.dbo.Guilds ALTER COLUMN [MasterUserID] varchar (18) COLLATE Latin1_General_CI_AS NOT NULL;
ALTER TABLE PS_GameData.dbo.Guilds ALTER COLUMN [MasterName] varchar (30) COLLATE Latin1_General_CI_AS NOT NULL;

There's no Primary Key on GuildID column as the original table had. Run this to restore it:

ALTER TABLE PS_GameData.dbo.Guilds ADD CONSTRAINT PK_GuildID PRIMARY KEY CLUSTERED (GuildID)

[Sinthorn320]

i had deleted my dbo.guilds an ran that quiry an i havent had a single problem with my guilds since o.O

[mss_pretty]

nice ty

[[GM]Twinky]

this should help this is what i use for my server

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]

[[GM]Recover]

its at the bottom of this thread
Twinky you Uploaded the wrong its guild not friends

[[GM]Twinky]

ty recover i through i got guild