Shaiya Guild Problem DE

[RapSandy]

Ich habe ein Problem ich restarte meinen Server und es gehen die gilden weg in der Datenbank sehe ich die noch wie im PvP Rank Script kann mir jemand dabei helfen bzw. nen Fix dafür geben ich glaube es liegt an eine Prozudure

Mfg RapSandy

[Lugat]

Lösch die Tabelle dbo.Guilds




USE [PS_GameData]
GO
/****** Creation Guild Fixed by sandolkakos: Shaiya-UGO Server - ******/
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

[jenny2011]

Neue Abfrage,einfügen,fertig. lg



USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_Guild2_R] Script Date: 10/12/2012 11:56:06 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO






ALTER Proc [dbo].[usp_Read_Guild2_R]

AS

SET NOCOUNT ON

SELECT G.GuildID, G.GuildName, G.MasterName, G.Country, G.GuildPoint,
ISNULL(H.[Rank],31) [Rank], ISNULL(H.Etin,0) Etin, ISNULL(H.UseHouse,0) UseHouse, ISNULL(H.Remark, '') Remark, ISNULL( H.BuyHouse,0) BuyHouse, ISNULL(H.EtinReturnCnt, 0 ) EtinReturnCnt, ISNULL(H.KeepEtin, 0) KeepEtin
FROM Guilds G
LEFT OUTER JOIN GuildDetails H ON G.GuildID = H.GuildID
WHERE G.Del=0
ORDER BY H.[Rank] DESC

SET NOCOUNT OFF