Experienced Elementalist
- Joined
- Jan 21, 2015
- Messages
- 235
- Reaction score
- 202
about the guild mark (guild crest) i managed to get it work , and like what i though there is someone (admin/GM) who must accept any new guild crest (stupid system -_-) , if anyone know any way so the guild crest accepted automatically it will be better
if you requested a guild crest excute this query to get it work BUT you need to restart the server
you need to modify the guild ID here instead of 1 put your guild id
cGuildMarkJudgeState =1 (requested)
cGuildMarkJudgeState =2 (rejected)
cGuildMarkJudgeState =3 (accepted)
cGuildMark= hex representation of an image binary data
if you requested a guild crest excute this query to get it work BUT you need to restart the server
you need to modify the guild ID here instead of 1 put your guild id
declare @GuildID int =1
update C9World.game.TblGuildMark set cGuildMark=
(select cGuildMark from C9World.game.TblGuildMarkJudge where cGuildNo=@GuildID)
where cGuildNo=@GuildID
update C9World.game.TblGuildMarkJudge set
cGuildMarkJudgeState=3
where cGuildNo=@GuildID
cGuildMarkJudgeState =1 (requested)
cGuildMarkJudgeState =2 (rejected)
cGuildMarkJudgeState =3 (accepted)
cGuildMark= hex representation of an image binary data
Last edited: