miscellaneous

Just another fun thing similar to http://bots4.net/forum/8/5229 whats the highest level without only using fists

I was surprised by this:

mysql> SELECT id, username, botname, expToLevel(exp) AS level
    -> FROM bots
    -> WHERE NOT EXISTS
    ->   (SELECT NULL
    ->   FROM inventory
    ->   WHERE
    ->       inventory.bot_id = bots.id
    ->       AND (location = 'primary' OR location = 'secondary'))
    -> ORDER BY exp DESC
    -> LIMIT 10;
+-------+-----------+-----------+-------+
| id    | username  | botname   | level |
+-------+-----------+-----------+-------+
| 14426 | Hozay     | Hozay     |    37 |
| 14419 | Seinfield | Seinfield |    35 |
| 14421 | Whorehey  | Whorehey  |    31 |
| 15467 | slut13    | slut13    |    28 |
| 11590 | Sm1       | Sm1       |    28 |
|  5893 | kud2      | kud2      |    27 |
| 18387 | Eve10     | Eve Loses |    27 |
|  5892 | kud1      | kud1      |    27 |
| 12077 | magicman  | magicman  |    26 |
| 13449 | Grit      | Grit      |    26 |
+-------+-----------+-----------+-------+

hm... this would probably be a lot easier than the crab whistler bot challenge