User talk:Kymara: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Kymara No edit summary |
imported>Kymara |
||
| Line 264: | Line 264: | ||
order by category, identifier; |
order by category, identifier; |
||
</source> |
</source> |
||
==Pending achievements== |
|||
<source lang = "sql"> |
<source lang = "sql"> |
||
insert into pending_achievement(charname, achievement_id, param, cnt) |
insert into pending_achievement(charname, achievement_id, param, cnt) |
||
select source, 17, "", count(*) from temp_elf_princess group by source; |
select source, 17, "", count(*) from temp_elf_princess group by source; |
||
stendhal> insert into pending_achievement(charname, achievement_id, param, cnt) select name, 26, param1, 1 from looted_all_items where timedate<'2010-11-24' and name <>'' and param1 IN ('chaos armor', 'chaos boots', 'chaos cloak', 'chaos helmet', 'chaos legs', 'chaos shield'); |
|||
Query OK, 20004 rows affected (0.46 sec) |
|||
Records: 20004 Duplicates: 0 Warnings: 0 |
|||
stendhal> insert into pending_achievement(charname, achievement_id, param, cnt) select name, 34, param1, 1 from looted_all_items where timedate<'2010-11-24' and name <>'' and param1 IN ('shadow armor', 'shadow boots', 'shadow cloak', 'shadow helmet', 'shadow legs', 'shadow shield'); |
|||
Query OK, 13100 rows affected (0.20 sec) |
|||
Records: 13100 Duplicates: 0 Warnings: 0 |
|||
stendhal> insert into pending_achievement(charname, achievement_id, param, cnt) select name, 40, param1, 1 from looted_all_items where timedate<'2010-11-24' and name <>'' and param1 IN ('black armor', 'black boots', 'black cloak', 'black helmet', 'black legs', 'black shield'); |
|||
Query OK, 1632 rows affected (0.17 sec) |
|||
Records: 1632 Duplicates: 0 Warnings: 0 |
|||
stendhal> insert into pending_achievement(charname, achievement_id, param, cnt) select name, 61, param1, 1 from looted_all_items where timedate<'2010-11-24' and name <>'' and param1 IN ('golden armor', 'golden boots', 'golden cloak', 'golden helmet', 'golden legs', 'golden shield'); |
|||
Query OK, 9562 rows affected (0.26 sec) |
|||
Records: 9562 Duplicates: 0 Warnings: 0 |
|||
</source> |
</source> |
||