Changing Guild Logos

[HuninHune]

Guild logos
The database TNGuildMark Stores Guild Logos

Table format is as such
master_id = The character ID for the guild leader
mark = The mark as a .tga in binary data
mark_jpg = unused
update = not important(set to 1)

To update a guild mark run this script

INSERT INTO [RohanGame].[dbo].[TNGuildMark](Master_ID, mark_jpg, mark)
SELECT 12374,'jpg.jpg', * FROM OPENROWSET(BULK N'C:\Mark.tga', SINGLE_BLOB) rs

Replace '12374' with the guild you want to updates ID
Replace 'C:Mark.tga' with the mark you want to use for the guild.

This only works with a very specific file type/size so here's an example of the correct filetype. If your file doesn't match this file in every aspect perfectly it wont work
chaosity.rar


So there you have it.
Any questions? post em.

[MentaL]

[kennethz008]

Works. Appreciate it

[Riche Saladaga]

Thanks Its Working . God Bless

[Rabbi]

Im trying to get this to work but its not for some reason or another, Ill sit here and figure it out eventually.
http://prntscr.com/488muo

Its registering on the query but the icon is not showing in the game


NEVERMIND I have it working.

[Hanzo Pro Alvin]

Help Me Please !!!

- - - Updated - - -

How to use chaosity.rar

- - - Updated - - -

HELP !! http://prntscr.com/73x5fl

[Hanzo Pro Alvin]

what code to mark his ??

[PenguinJoe]

wtf are you talking about? look at the 1st post.

[daingnabangus]

may I ask for your help in this..

master_id = The character ID for the guild leader <--i understand
mark = The mark as a .tga in binary data<--i didn't understand how to make the binary data but I made the .tga file according to the recommended specifications.please help, an example on how to make is greatly appreciated..thank you
mark_jpg = unused <--i understand
update = not important(set to 1)<--i understand

[PenguinJoe]

read the .tga file into a byte array and insert that into the mark column.

the tga file must be:

1. Must have 16x16 pixel dimensions.
2. Must be .tga format.
3. Must be exactly 1,068 bytes.
4. Must be saved in 32-bit mode.

[daingnabangus]

i successfully made a .tga file according to your recommended specifications.how to read the .tga file into a byte array?thank you for your time and sorry for my stupidity.