Loss of guilds

12/28/2012 22:25 .Santa.#1
I used [Only registered and activated users can see links. Click Here To Register...] guide for that to fixed a bug with the loss of the guilds, but I could not. Guild on disappear. Can someone help me with this?
12/28/2012 23:57 Billie Joe#2
Add me on skype, and we can talk about it
12/29/2012 00:00 STIV123#3
Maybe try removing the dbo.guild table and creating new.



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]
I found the script on this topic: [Only registered and activated users can see links. Click Here To Register...]
12/29/2012 01:02 .Santa.#4
Quote:
Originally Posted by STIV123 View Post
Maybe try removing the dbo.guild table and creating new.



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]
I found the script on this topic: [Only registered and activated users can see links. Click Here To Register...]

I receive an error when running the script
Code:
Msg 102, Level 15, State 1, Line 16
Incorrect syntax near '('.
12/29/2012 01:39 JohnHeatz#5
#Moved to the right section
12/29/2012 02:27 MysteryAviate#6
Try This...

Code:
USE [PS_GameData]
GO
/****** Creation Guild Fixed by sandolkakos: Shaiya-UGO Server - [url=http://www.universalgamesonline.com.br]Bem Vindo a Universal Games Online[/url]  ******/
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) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterUserID] [varchar](18) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterCharID] [int] NOT NULL,
	[MasterName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS 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 (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
12/29/2012 22:21 VolterKnecht#7
Or Use this..



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] ,
[DeleteDate] [datetime]
) ON [PRIMARY]