Fix guild on private server

07/25/2009 12:54 ImortalPain#1

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:bandit:

10/10/2010 19:56 patoringa#2

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!

10/10/2010 21:59 Sinthorn320#3

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.

10/11/2010 13:43 patoringa#4

Thx for help. :handsdown:

10/12/2010 11:52 ProfNerwosol#5

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):

Code:

[DeleteDate] datetime NULL

or run this (if you already recreated the table)

Code:

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:

Code:

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:

Code:

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

10/12/2010 15:36 Sinthorn320#6

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

08/13/2011 01:46 mss_pretty#7

nice ;) ty

08/13/2011 09:23 [GM]Twinky#8

this should help this is what i use for my server

Quote:

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]

08/13/2011 09:37 [GM]Recover#9

[Only registered and activated users can see links. Click Here To Register...]
its at the bottom of this thread
Twinky you Uploaded the wrong its guild not friends :)

08/13/2011 09:50 [GM]Twinky#10

ty recover i through i got guild :)