[help]fix Guild logo please.

[evildead2004]

how to fix Guild logo not show in game.
i add logo .BMP to guild logo.
but it's not show in my name guild

after i want edit logo. But......!!!!!

i can not edit logo.
:::*:

 

[CrazyGuardian]

bardiel/glogo/gbuff/nation/rankpvp/wenchant/cashshop/Reabinallmap is not working properly hence I'm not opening a private server

 

[evildead2004]

bardiel/glogo/gbuff/nation/rankpvp/wenchant/cashshop/Reabinallmap is not working properly hence I'm not opening a private server

Where is it ?

 

[Stunn]

USE [C9World]
GO
/****** Object: StoredProcedure [Game].[UspSetGuildMarkState] Script Date: 12/16/2015 11:02:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
** Name: UspSetGuildMarkState
** Desc: 길드마크 심의 테이블 등록
**
** Auth: 채석현
** Date: 20111024
*******************************************************************************
** Change History
*******************************************************************************
** Date: Author: Description:
** -------- -------- ---------------------------------------
*******************************************************************************/
ALTER PROCEDURE [Game].[UspSetGuildMarkState]
@pGuildNo BIGINT,
@pGuildMark BINARY(4096),
@pGuildMarkState TINYINT
AS
SET NOCOUNT ON -- 설명 : 결과 레코드 셋을 반환 안 시킨다.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

--- 변수 선언
DECLARE AerrNo INT,
@aRowCnt INT


--- 변수 초기화
SELECT AerrNo = 0, @aRowCnt = 0 -- 한줄에 초기화

-- 길드 존재하는지 확인
IF NOT EXISTS (
SELECT *
FROM Game.TblGuildBase
WHERE cGuildNo = @pGuildNo
)
BEGIN
SET AerrNo = 1 -- 존재하지 않는 길드
END
ELSE
BEGIN
IF EXISTS (
SELECT *
FROM Game.TblGuildMarkJudge
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMarkJudge
SET cGuildMarkJudge = @pGuildMark, cGuildMarkJudgeState = 3
WHERE cGuildNo = @pGuildNo




IF EXISTS (
SELECT *
FROM Game.TblGuildMark
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMark
SET cGuildMark = @pGuildMark
WHERE cGuildNo = @pGuildNo
END
ELSE
BEGIN
INSERT INTO Game.TblGuildMark (cGuildNo, cGuildMark)
VALUES (@pGuildNo, @pGuildMark)
END

END
-- 아무것도 없는 상태라면
ELSE
BEGIN
INSERT INTO Game.TblGuildMarkJudge (cGuildNo, cGuildMarkJudge, cGuildMarkJudgeState)
VALUES (@pGuildNo, @pGuildMark, 3)


IF EXISTS (
SELECT *
FROM Game.TblGuildMark
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMark
SET cGuildMark = @pGuildMark
WHERE cGuildNo = @pGuildNo
END
ELSE
BEGIN
INSERT INTO Game.TblGuildMark (cGuildNo, cGuildMark)
VALUES (@pGuildNo, @pGuildMark)
END
END


SELECT AerrNo = @@Error, @aRowCnt = @@RowCount
IF (@aRowCnt <> 1)
SET AerrNo = 3 -- DB오류
END








OBS: will only work when you restart server, like you changed the logo , you will have to restart the server, for all the guilds . ( currently bugged )

 

[evildead2004]

Thank you Stunn


Stunn what is input ?

 

[xlmansox]

i know how to make guild logo work. but i will not tell any thai pserver.

 

[evildead2004]

i know how to make guild logo work. but i will not tell any thai pserver.

Why...?
:$:

 

[xlmansox]

Why...?
:$:

just not like thai pserver.

 

[evildead2004]

just not like thai pserver.

You are the people of Thailand. Why. You can not help the people of Thailand.
:::

 

[xlmansox]

cause u guys are so greedy.

 

[CrazyGuardian]

who's greedy ?
c9 server files you shared yet?
if you know something tell !!!
if you don't want to say .What Are you doing in this forum ?

 

[evildead2004]

I do not want Help from you xlmansox.
I can do it.

I do not care.

 

[CrazyGuardian]

guild logo fix share forum thx

 

[Stunn]

@xlmansox / CrazyGuardian , actually the only one who's greedy here is Epicc9 Staff . And before people start arguing , take a breath and look in what we have now ,got it? Exactly ... nothing .

 

[xlmansox]

Good job but that script is mine. lol for the main thing is i release already. and they just fvcking lazy to search.

http://forum.ragezone.com/f933/fun-database-1088032/

 

[evildead2004]

USE [C9World]
GO
/****** Object:  StoredProcedure [Game].[UspSetGuildMarkState]    Script Date: 2016-03-04 17:49:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
** Name: UspSetGuildMarkState
** Desc: 길드마크 심의 테이블 등록
**
** Auth: 채석현
** Date: 20111024
*******************************************************************************
** Change History
*******************************************************************************
** Date: Author: Description:
** -------- -------- ---------------------------------------
*******************************************************************************/
ALTER PROCEDURE [Game].[UspSetGuildMarkState]
@pGuildNo BIGINT,
@pGuildMark BINARY(4096),
@pGuildMarkState TINYINT
AS
SET NOCOUNT ON -- 설명 : 결과 레코드 셋을 반환 안 시킨다.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

--- 변수 선언
DECLARE [USER=2000075974]Aer[/USER]rNo INT,
@aRowCnt INT


--- 변수 초기화 
SELECT [USER=2000075974]Aer[/USER]rNo = 0, @aRowCnt = 0 -- 한줄에 초기화 

-- 길드 존재하는지 확인
IF NOT EXISTS (
SELECT *
FROM Game.TblGuildBase
WHERE cGuildNo = @pGuildNo
)
BEGIN
SET [USER=2000075974]Aer[/USER]rNo = 1 -- 존재하지 않는 길드
END
ELSE
BEGIN
IF EXISTS (
SELECT *
FROM Game.TblGuildMarkJudge
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMarkJudge
SET cGuildMarkJudge = @pGuildMark, cGuildMarkJudgeState = 3
WHERE cGuildNo = @pGuildNo




IF EXISTS (
SELECT *
FROM Game.TblGuildMark
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMark
SET cGuildMark = @pGuildMark
WHERE cGuildNo = @pGuildNo
END
ELSE
BEGIN
INSERT INTO Game.TblGuildMark (cGuildNo, cGuildMark)
VALUES (@pGuildNo, @pGuildMark)
END

END
-- 아무것도 없는 상태라면
ELSE
BEGIN
INSERT INTO Game.TblGuildMarkJudge (cGuildNo, cGuildMarkJudge, cGuildMarkJudgeState)
VALUES (@pGuildNo, @pGuildMark, 3)


IF EXISTS (
SELECT *
FROM Game.TblGuildMark
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMark
SET cGuildMark = @pGuildMark
WHERE cGuildNo = @pGuildNo
END
ELSE
BEGIN
INSERT INTO Game.TblGuildMark (cGuildNo, cGuildMark)
VALUES (@pGuildNo, @pGuildMark)
END
END


SELECT [USER=2000075974]Aer[/USER]rNo = @@Error, @aRowCnt = @@RowCount
IF (@aRowCnt <> 1)
SET [USER=2000075974]Aer[/USER]rNo = 3 -- DB오류
END

 RETURN  [USER=2000075974]Aer[/USER]rNo

Script It work after Restart server.

 

[CrazyGuardian]

okey Stunn :hello: xlmansox open want to open.65lvl boring game files are missing.They're shutting down after 1 monthtt1:...
if possible, we need to keep the forum up to date.maybe you don't need
so maybe the latest update of the game.because we don't have the editor program.
impossible because gameserver/client 65lvl/tower20rd. remember!!!!
there is a little detail Reabin surv ???
It's been 4 months and I'm going crazy...I thinkI thinkI thinkI think these files are carved
they are playing a game with us...

 

[Stunn]

i'm just tired of c9 . Theres nothing much devs and we can do .