- Joined
- Sep 30, 2006
- Messages
- 735
- Reaction score
- 207
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
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
View attachment chaosity.rar
So there you have it.
Any questions? post em.
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
Code:
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
View attachment chaosity.rar
So there you have it.
Any questions? post em.
Attachments
You must be registered for see attachments list
Last edited: