guild siege / war database datas

[blacksystem1990]

Do anyone know where is stored in database the following?

- guild siege/war winner/detentor
- most valuable player for the event

do anyone know the fields/database for it?
also one question, since i'm newbie to flyff, how guild siege works?
the detentors/mvp, will last until next siege/war?
what are the qualify requirements to partecipate in that event?

[blacksystem1990]

Bump

Anyone know?

[Flogolo]

The winning Guild and the MVP keep the crown/medal till the next Siege.
Requirements are simple: be on max level, deal much damage, and have life like hell xDD

[blacksystem1990]

Originally Posted by Flogolo

The winning Guild and the MVP keep the crown/medal till the next Siege.
Requirements are simple: be on max level, deal much damage, and have life like hell xDD

Ok but.. where is it located into database those details?

If I want to print out on my website the actual MVP and guild detentor of the current siege ? where do I take the datas?

[Flogolo]

Which website do u use? Sapphire?

[raventh1984]

The print out of GuildSiege is not located inside the Database.
The source will generate the output to an file.

[blacksystem1990]

Originally Posted by Flogolo

Which website do u use? Sapphire?

i dont use any of the "released" websites.
i have my own

Originally Posted by raventh1984

The print out of GuildSiege is not located inside the Database.
The source will generate the output to an file.

then how can peoples make theirs mvp and guild detentor print on their website?

[raventh1984]

I think you ment who the current mvp is and who the winning guildsiege is correct?

If so then I misunderstood your question.

Here you go

MVP

"SELECT TOP 1 m_szName FROM tblCombatJoinPlayer
			JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID
			LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER
			BY JP.CombatID DESC, Point DESC"

GuildSiegeWinner

SELECT TOP 1 m_szGuild FROM [tblCombatJoinGuild] JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC

To show the MVP on your website you need to fetch row m_szName
To show GS Winner you need to fetch row m_szGuild

Hope this is what you where asking.