[Release] Fix missing guilds

[BodySalvage]

Many people have the issue with guilds not being read and remaking the table will not solve it.

This may solve your issue. Default DB's on epvper all have this error and SQL 2012 reads it where other versions tend to miss it.

1. Navigate to your dbo.usp_Read_Guild2_R stored procedure
( PS_GameData > Programmability > Stored Procedures )

2. Right click and select "Modify" to enable editing

3. Locate the line containing "ORDER BY G.[Rank] DESC

4. Change that line to "ORDER BY H.[Rank] DESC" without quotes and execute to change it.

Example of the finished script. This can be run in SQL and will automatically apply the change mentioned.

 Spoiler

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

If this method has been released please close this post, otherwise I hope this helps resolve the missing guilds issue for those that cannot repair the problem with other released methods.

** NOTE ** I highly recommend this method tested before using the table remake method as it may solve the issue without loss of any already made data.

[Tyberius]

Vote to be put on index

[jenny2011]

Vielen Vielen Dank für die Hilfe Hat geholfen.

[accuface35]

next time please write in english and German