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
[Problem] Honor Rank 07/05/2021 - SRO Private Server - 22 Replies hey guys,
i have a problem in honor rank where players aren't at top as they should be
http://i.epvpimg.com/jclGc.png
there is many others like him
*he is like this for 7 days so.. where is the problem ?
.is there a way to fix it without removing the graduates ?
thx all.
Battlepoints' rank problem 10/19/2013 - Seafight - 4 Replies I have achieved 20 battlepoint' rank but I can not open bookmark Cabin/Battle points (white pages). Do you know someone how to purchase Agwe's Battle Booster (id=items_Buff_23)?
Level Rank Problem 03/09/2013 - Shaiya Private Server - 0 Replies Hello Friends
Web PvP rank my site, I want to kill ranking, but I rank level
Example;
TruvaGames
[Help] Problem in Honor Rank 02/28/2013 - SRO Private Server - 1 Replies Hello everybody , i have big problem i can't fix it
So , I Fix honor rank but , When the server is honor updating something strange happens when I go to see Honor Rank eliminates No. 2 and leaves
only 1 , i can't told what i mean .. but i think some members can help
Thanks , hope to help me :facepalm:
[Problem] Rank 7 cloak 03/01/2012 - Rappelz Private Server - 1 Replies Hi i have one problem,
i have white and red clock of lv150 ( epic7.2) but i can't trade it,
what i will do?