User talk:Kymara: Difference between revisions

-- after 0.92 if we want a kill enemy army achievement, can do

-- highest number so far is about 40 and there's nothing in older gameEvents tables

insert into pending_achievement(charname, achievement_id, param, cnt)

SELECT source, XX, "", count(*) FROM gameEvents WHERE event='quest' AND param1= 'kill_enemy_army' AND param2 like 'done%' group by source;