Guild Emblem / Frame

USE [Server01]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_GetGuildInfo] Script Date: 04/18/2013 22:41:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_GetGuildInfo]( @GuildNo INT )
AS
begin
SELECT
GuildNo,
GuildType,
GuildName,
0 AS MaxMemberNum, --MaxMemberNum, -- 사용 안함
RegDate,
'' AS Deleted, --Deleted, -- 속도 향상
ISNULL(GuildUrl, '') as GuildUrl,
ISNULL(GuildNotice, '') as GuildNotice,
ISNULL(GuildIntro, '') as GuildIntro,
'2001-01-01' AS GuildEmblemCreateDate, --ISNULL(GuildEmblemCreateDate, '2001-01-01') as GuildEmblemCreateDate, -- 속도 향상
'' AS NameChangedDate, --ISNULL(NameChangedDate, '') as NameChangedDate, -- 속도 향상
0 AS GuildColor, --ISNULL(GuildColor, 0) as GuildColor, -- 속도 향상
[Level],
Point,
Lock
FROM Guild
WHERE GuildNo = @GuildNo
end

i faund this in db meibe need to create emblem event to make it worck in sv

USE [Server01]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_GuildModify] Script Date: 04/18/2013 22:48:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: 박상범
-- Create date: 2011-12-20
-- Description: 길드 수정
-- =============================================
ALTER PROCEDURE [dbo].[cabal_tool_GuildModify]
(
@GuildNo INT,
@GuildType INT,
@GuildName varchar(50),
@MaxMemberNum INT,
@RegDate varchar(14),
@Deleted varchar(14),
@GuildUrl varchar(80),
@GuildNotice varchar(240),
@GuildIntro varchar(240),
@GuildEmblemCreateDate dateTime,
@NameChangedDate varchar(8),
@GuildColor INT,
@Level INT,
@Point INT,
@Lock INT
)
AS
BEGIN
IF @RegDate = ''
SET @RegDate = CONVERT(VARCHAR(14), GETDATE(), 112) + '000000'
SET @NameChangedDate = CONVERT(VARCHAR(14), GETDATE(), 112)
UPDATE [dbo].[Guild]
SET [GuildType] = @GuildType
,[GuildName] = @GuildName
,[RegDate] = @RegDate
,[GuildUrl] = @GuildUrl
,[GuildNotice] = @GuildNotice
,[GuildIntro] = @GuildIntro
,[nameChangedDate] = @NameChangedDate
,[level] = @Level
,[Point] = @Point
,[Lock] = @Lock
WHERE GuildNo = @GuildNo
END

this 1 to meybe some 1 figure haw to add

Off:
@pierr32 Exactly the same emblem as the one i added for FairyTail guild on a server. (I wont mention the name of it bcz u all know it probably)
Attachment 128188

On: Read up spikes reply because he mentioned something that might help u guys figure out how to get emblems to work and how to work with them.:thumbup1:

Quote:

---

Originally Posted by Acnathon

Off:
@pierr32 Exactly the same emblem as the one i added for FairyTail guild on a server. (I wont mention the name of it bcz u all know it probably)
Attachment 128188

On: Read up spikes reply because he mentioned something that might help u guys figure out how to get emblems to work and how to work with them.:thumbup1:

---

Edit Sql Or Client or linux Show Guild Icon

UPDATE [dbo].[Guild] SET
[GuildEmblemCreateDate] = 2013-04-18
WHERE GuildNo = '1'

Invalid column name 'GuildEmblemCreateDate' :lol:

meybe need to create column ?

you don't need to edit anything to make guild icons work, file format is like this: int sv_idx, int guild_idx, int texture_size and the texture itself, now there are a few problems .... we can't change the texture data (seems encrypted) and sv_idx and guild_idx have some kind of xor on them ... here's the template i've made so far

Quote:

---

typedef enum <byte> {
ID_1 = 99h,
ID_2 = 9Ah,
ID_3 = 9Bh,
ID_4 = 64h,
ID_5 = 65h,
ID_6 = 66h,
ID_7 = 67h,
ID_8 = 60h,
ID_9 = 61h,
ID_10 = 62h,
ID_11 = 63h,
ID_12 = 6Ch,
ID_13 = 6Dh,
ID_14 = 6Eh,
} server;

server SERVER;
byte unk[3];
int GUILD;

---

hope it helps :D

Quote:

---

Originally Posted by x30unlimited

you don't need to edit anything to make guild icons work, file format is like this: int sv_idx, int guild_idx, int texture_size and the texture itself, now there are a few problems .... we can't change the texture data (seems encrypted) and sv_idx and guild_idx have some kind of xor on them ... here's the template i've made so far


nope it helps :D

---

Scrip Work Good Jobb
Thx X30

Quote:

---

Originally Posted by x30unlimited

you don't need to edit anything to make guild icons work, file format is like this: int sv_idx, int guild_idx, int texture_size and the texture itself, now there are a few problems .... we can't change the texture data (seems encrypted) and sv_idx and guild_idx have some kind of xor on them ... here's the template i've made so far


hope it helps :D

---

Thx just edit gld file work emblem but fix emblem more dev
Attachment 128648

Quote:

---

Originally Posted by elvise

Thx just edit gld file work emblem but fix emblem more dev
Attachment 128648

---

์Nice a pet
you can share :D:
**Aw korea Ep10 Epdate

that's in newest korea test client

I read this about 10 minutes and I created template
x30unlimited thank for post here is the effect
Attachment 128860
here Template for SweetScape
Guild.bt

Code:

---


typedef enum <int> {
    Hidden = 0,
    Visible = 1,
} state;

typedef enum <byte> {
ID_1 = 99h,
ID_2 = 9Ah,
ID_3 = 9Bh,
ID_4 = 64h,
ID_5 = 65h,
ID_6 = 66h,
ID_7 = 67h,
ID_8 = 60h,
ID_9 = 61h,
ID_10 = 62h,
ID_11 = 63h,
ID_12 = 6Ch,
ID_13 = 6Dh,
ID_14 = 6Eh,
} server;

server SERVER;
byte unk[3];
int GUILD;

---

"sv_idx and guild_idx have some kind of xor on them"

here's the updated version of the template ( yamachi style <3 ) :P

Code:

---

//--------------------------------------##
// Game: CABAL Online
// File Format: GLD
// Description: Template for CABAL's Guild Emblem files
//--------------------------------------##
// Author: x30
// Website: http://cabal.ws
//--------------------------------------##

//-Enumerations-------------------------

typedef struct {
  uint xoredValue;
} xoredUInt <read=xoredUIntRead, write=xoredUIntWrite>;

//-Functions----------------------------

string xoredUIntRead(xoredUInt &x) {
    uint realValue = (x.xoredValue & 0xFFFFFFFF ^ 0x2147E4) - 0x59077C;
    string s;
    SPrintf(s, "%d", realValue);
    return s;
}

void xoredUIntWrite(xoredUInt &x, string s ) {
    uint realValue;
    SScanf(s, "%d", realValue);
    x.xoredValue = (realValue & 0xFFFFFFFF) + 0x59077C ^ 0x2147E4;
}

//-Main---------------------------------

xoredUInt serverId;
xoredUInt guildId;
uint textureSize;
ubyte xoredTextureData[textureSize];

---

and here is a script to xor texture data :)

Code:

---

//--------------------------------------##
// Game: CABAL Online
// File Format: GLD
// Description: Do a XOR operation on a given texture data
//--------------------------------------##
// Author: x30
// Website: http://cabal.ws
//--------------------------------------##

//-Functions----------------------------

ubyte[] textureXor(ubyte textureData[]){   
    uint i;
    for(i=1;i<sizeof(textureData);++i){
        if(i%2>0) textureData[i]=textureData[i] ^ 0x5D;
        else textureData[i]=textureData[i] ^ 0xD7;
    }
    return textureData;
}

//-Main---------------------------------

textureXor(xoredTextureData);

---

i want some1 to make a tool and share it (for newbies), if you do, i'll offer something interesting :P

Anyone can do a nub free tutorial? This part of client i can't understand ^^

Nice... now Title for killing a GM, Old timed Chaos Arena (I know it's there) and Tierra del Bruto left. :)

Thank you ^^