Advanced Database Query Exercise: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Hendrik Brummermann No edit summary |
imported>Hendrik Brummermann No edit summary |
||
| Line 1: | Line 1: | ||
This is an advanced version |
This is an advanced version focusing on RPG related queries. You should probably do basic [[Database Query Exercise]] first |
||
The same instructions apply: |
The same instructions apply: |
||
| Line 12: | Line 12: | ||
The itemids and names of all items that have been touched by alice and malice in the last two days? |
The itemids and names of all items that have been touched by alice and malice in the last two days? |
||
<source lang="sql"> |
<source lang="sql"> |
||
| Line 24: | Line 23: | ||
(Assuming today is 2011-09-14) |
(Assuming today is 2011-09-14) |
||
== Task 1: Players == |
|||
What is the account name of the character alice? |
|||
Which other characters belong to that account? |
|||
What player created a new character looking like alice? |
|||
== Task 2: Kills == |
|||
Who was directly or indirectly involved in the recent player killing of alice? |
|||
In which zones were black dragons killed in the last 3 days? |
|||
== Task 3: Items == |
|||
Which items did alice drop after 2011-09-14 12:56:31? |
|||
Who owns those items now? |
|||
Who owned the items in between? |
|||
Have those items been given away or was something trade against them using the trade system? |
|||
Was something traded against the contraband using the old trading style of putting items on the floor instead? |
|||
Were third players used to conceal trades? |
|||
== Task 4: Be creative == |
|||
Explain two approaches how to detect bots and how to verify the discovery. |
|||