User talk:Kymara: Difference between revisions
Content deleted Content added
imported>Kymara |
imported>Kymara |
||
Line 284:
Query OK, 9562 rows affected (0.26 sec)
Records: 9562 Duplicates: 0 Warnings: 0
-- 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;
</source>
| |||