[Arianne-bugs] [ arianne-Feature Requests-3102207 ] [Stendhal Website] Add reaching of achievement to events

[SourceForge.net <no...@so...>]

Feature Requests item #3102207, was opened at 2010-11-03 13:02
Message generated for change (Comment added) made by kymara
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=351111&aid=3102207&group_id=1111

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Stendhal Website
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: MadMetzger (madmetzger)
>Assigned to: Katie Russell (kymara)
Summary: [Stendhal Website] Add reaching of achievement to events

Initial Comment:
It would be nice if reaching an achievement could be displayed in the recent events page. There are two ways of retrieving reached achievements from the database:
1. From gameEvents:
SELECT * FROM gameEvents WHERE event='reach-achievement';
source denotes here the player who reached the achievement, within param1 you can see the category of the achievement. param2 consists of the title and textual identifying uniquename of the reached achievement. The column timedate is the point in time when this achievement was reached.
2. From the achievement tables:
SELECT timedate, charname, identifier, title, description, base_score FROM reached_achievement JOIN achievement ON achievement.id = reached_achievement.achievement_id GROUP BY charname;
timedate = when is achievement reached
charname = who reached the achievement
identifier, title, description, base_score = data from the reached achievement

----------------------------------------------------------------------

>Comment By: Katie Russell (kymara)
Date: 2010-11-03 22:59

Message:
It's not live but you can try testing it locally.

----------------------------------------------------------------------

Comment By: Katie Russell (kymara)
Date: 2010-11-03 22:24

Message:
For query 2, why would you group by charname?
Would you really get all achievements reached in the last few hours that
way?
The recent events display is usually all special events within the recent
time so I would propose something like:

SELECT  charname, title, description, timedate FROM reached_achievement
JOIN achievement ON achievement.id = reached_achievement.achievement_id
where timedate > subtime(now(),'06:00:00')  limit 20;

perhaps?



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=351111&aid=3102207&group_id=1111