User talk:Kymara: Difference between revisions

Jump to navigation Jump to search
← Older editNewer edit →
Content deleted Content added
imported>Kymara
imported>Kymara
Line 120: Line 120:


== elfy ==
== elfy ==
<source lang = "sql">

mysql> create table temp_elf_princess select timedate, source from gameEvents where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought' and id < 58379295;
create table temp_elf_princess select timedate, source from gameEvents where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought' and id < 58379295;
Query OK, 562 rows affected (6.22 sec)
Query OK, 562 rows affected (6.22 sec)
Records: 562 Duplicates: 0 Warnings: 0
Records: 562 Duplicates: 0 Warnings: 0


-- yeah I could have done a union but I wanted to know counts and have more control
⚫
mysql> insert into temp_elf_princess select timedate, source from gameEvents_2009_08_17 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';
insert into temp_elf_princess
select timedate, source from gameEvents_2009_08_17
⚫
where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';
Query OK, 346 rows affected (5.67 sec)
Query OK, 346 rows affected (5.67 sec)
Records: 346 Duplicates: 0 Warnings: 0
Records: 346 Duplicates: 0 Warnings: 0


insert into temp_elf_princess
⚫
mysql> insert into temp_elf_princess select timedate, source from gameEvents_2009_02_19 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';
select timedate, source from gameEvents_2009_02_19
⚫
where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';
Query OK, 393 rows affected (6.40 sec)
Query OK, 393 rows affected (6.40 sec)
Records: 393 Duplicates: 0 Warnings: 0
Records: 393 Duplicates: 0 Warnings: 0


insert into temp_elf_princess
⚫
insert into temp_elf_princess select timedate, source from gameEvents_2008_08_21 where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';
select timedate, source from gameEvents_2008_08_21
⚫
where event='quest' and param1= 'elf_princess' and param2 = 'flower_brought';
Query OK, 131 rows affected (49.79 sec)
Query OK, 131 rows affected (49.79 sec)
Records: 131 Duplicates: 0 Warnings: 0
Records: 131 Duplicates: 0 Warnings: 0


⚫
select count(*) from temp_elf_princess;

⚫
mysql> select count(*) from temp_elf_princess;
+----------+
+----------+
| count(*) |
| count(*) |
Line 144: Line 150:
| 1432 |
| 1432 |
+----------+
+----------+
</source>


== loots for achievements ==
== loots for achievements ==
Retrieved from "https://meet.konsthol.eu/w/index.php?title=User_talk:Kymara"