Advanced Database Query Exercise: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann No edit summary |
imported>Hendrik Brummermann No edit summary |
||
| (9 intermediate revisions by the same user not shown) | |||
Line 1:
This is an advanced version
The same instructions apply:
Line 12:
The itemids and names of all items that have been touched by alice and malice in the last two days?
<source lang="sql">
Line 24 ⟶ 23:
(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.
| |||