Closed markbasham closed 11 years ago
Items to include, all should be by daily, weekly, monthy and forever
stat_name profile_id
score 7,4,3,6,1,5
deaths 1,4,3,5,6,7
weapon_hit_count 0
hit_count 1,3,5,4,7,6
play_time 7,1,4,3,6,5
fire_count 4,6,7,5,1,3
medal_count 0
skill_points 0
weapon_deaths 0
weapon_fire_count 0
weapon_score 0
assist_count 0
weapon_play_time 0
facility_defended_count 0
By Faction weapon_killed_by 0 domination_count 0 revernge_count 0 weapon_vehicle_kills 0 weapon_damage_taken_by 0 killed_by 3,4,6,5,1,7, weapon_kills 0 kills 1,3,4,5,6,7 weapon_damage_given 0 facility_capture_count 0 weapon_headshots 0
So it looks like a the best way to do this is to create a new db entry for profile data, which would include all stats per profile, and the standard character should be extended
Data is all stored per character but not per class at the moment, but the principle works nicely.
Possibly worth getting the per character stats working, and also monitoring timing for requests with some logging messages.
Ok you live and learn, there is no way that the db can be used in the way i am using it as its jut too slow, however some extra exploration showed all the memcache stuff is much nicer, and in fact built for this more directly, so that may well be the way to go with storing and retrieving the data.
Memory cahce seems like a good way to go, and is pretty speedy, and it seems to work quite nicely. Simple stuff so far, but this can be built upon
Basic memcache implementation added, now it definalty needs extending and an appropriate sorting mechanism added
Only things left to add are the per faction statisitics, but these can go in quite easily now.
The main work is done in getting this to work.
All done
So just assemble the data from the stats and per empire stats sections.