guild siege / war database datas

07/31/2015 23:02 blacksystem1990#1

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?

08/06/2015 16:08 blacksystem1990#2

Bump

Anyone know?

08/07/2015 00:11 Flogolo#3

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

08/09/2015 19:03 blacksystem1990#4

Quote:

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?

08/13/2015 09:40 Flogolo#5

Which website do u use? Sapphire?

08/13/2015 10:55 raventh1984#6

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

08/13/2015 21:25 blacksystem1990#7

Quote:

Originally Posted by Flogolo

Which website do u use? Sapphire?

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

Quote:

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?

08/14/2015 18:21 raventh1984#8

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

Code:

"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

Code:

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.