EP9 Same as Bubu Shared

[SHARE] FULL GS SOURCE - No more selling, the name of the thread, its on the first page go to back to release section.

RanThirdParty.
thanks , i find thats right now, u super hero

```fatal error C1083: Cannot open include file: 'windows.h': No such file or directory```

i have problem with this on Compiling :(
 
Last edited:
im done implementing it to the source, but still the guild tab still not showing. anything that is needed to apply on DB or did i miss something?
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_GetClubRanking] Script Date: 8/11/2023 10:46:53 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[sp_GetClubRanking]
AS
SET NOCOUNT ON

SELECT G.GuName, G.GuRank, (SELECT SUM(ChaPkScore) from Chainfo where GUNum = G.GuNum) as Win, (SELECT SUM(ChaPKDeath) from Chainfo where GUNum = G.GuNum) as Lose, (SELECT count(*) from Chainfo where GUNum = G.GuNum and ChaDeleted = 0) as Draw, (SELECT TOP 1 ChaSchool from Chainfo where GUNum = G.GuNum and ChaDeleted = 0 and chanum = g.ChaNum) as School, g.GuNum FROM RanGame1.dbo.GuildInfo G

SET NOCOUNT OFF
i'm not use ranking function cuz for less flood server side and also sometime after server reset and it not update automatic
 
Back