Newbie Spellweaver
- Joined
- Aug 6, 2023
- Messages
- 20
- Reaction score
- 2
this same files with post ?To view the content, you need to sign in or register
this same files with post ?To view the content, you need to sign in or register
not compataible for v2003To view the content, you need to sign in or register
v2003 vs?not compataible for v2003
sorry typo vs2003v2003 vs?
sorry typo vs2003
do you have link sir?try on 2007
add my discord @myrepublic , im on outside nowdo you have link sir?
Done sirsadd my discord @myrepublic , im on outside now
you looking for Ran GSanyone have ranthridparty ?
this source need ranthridpartyyou looking for Ran GS
if you don't like thirdparty use clean juver source and merge all the functions hereanyone have ranthridparty ?
i like but i need ranthridparty , because not avaible on the sourceif you don't like thirdparty use clean juver source and merge all the functions here
go to rangs thread, then get the thirdparty there,i like but i need ranthridparty , because not avaible on the source
i cant find himrangs thread
[SHARE] FULL GS SOURCE - No more selling, the name of the thread, its on the first page go to back to release section.i cant find him
thanks , i find thats right now, u super hero[SHARE] FULL GS SOURCE - No more selling, the name of the thread, its on the first page go to back to release section.
RanThirdParty.
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?global ranking
View attachment 239307
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?
i'm not use ranking function cuz for less flood server side and also sometime after server reset and it not update automaticUSE [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