User talk:Kymara: Difference between revisions

Jump to navigation Jump to search
Content deleted Content added
imported>Kymara
Translation: new section
imported>Kymara
Line 289: Line 289:
insert into pending_achievement(charname, achievement_id, param, cnt)
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;
SELECT source, XX, "", count(*) FROM gameEvents WHERE event='quest' AND param1= 'kill_enemy_army' AND param2 like 'done%' group by source;

-- 0.94
insert into pending_achievement(charname, achievement_id, param, cnt)
select name, 95, param1, 1 from looted_red_items where timedate<'2010-11-24' and name <>'';


</source>
</source>