EU Die Todeskrallen realm statistics
Saturday, 13. June 2009 19:34 - daniel - Other - 0 Comments
I did some small data mining on the armory data for my realm. I analyzed about 1200 guilds and 22.000 characters for there enchants, gems and glyphs. There are quite some other thing I could extract from this dataset, but for the moment I'm to lazy to do anything further.
EU-Die Todeskrallen statistics
The tools used to generate this report can also be used to generate statistics for other realms or, if I had a large enough dataset, for the entire WoW population. But until I have a good reason to do this, I'm not interested in doing anything further.
Perfect Screenshot WoW Addon
Tuesday, 5. May 2009 10:26 - daniel - Other - 0 Comments
Perfect Screenshot is an addon for World of Warcraft to automatically set some graphic options prior to taking a screenshot. It disables viewports (like aperture), hides the UI and adjusts name display settings. After the screenshot has been taken everything is restored to the previous settings.
I wrote it because I didn't like to disable aperture, hide my UI, display all names etc. prior to taking a killshot (or any screenshot that is). Also, I wanted to try a bit of lua coding. Perfect Screenshot also uses Ace-3.0 for config, saved variables, profiles, etc.
Here's the project on wowace.com: Perfect Screenshot
Here's the download on curse.com: Perfect Screenshot
Importing mysql dumps from phpMyAdmin
Monday, 30. March 2009 13:12 - daniel - Other - 0 Comments
Every time I move a website from a shared hosting account to my own server I have to export the databases with phpMyAdmin. But since these dumps can get pretty big, it's not a good idea to import then with phpMyAdmin. Usually you use the command line mysql client. But here comes the problem: Database dumps from phpMyAdmin are usually UTF8, but mysql expects ISO-8859-1 or something else and special chars like ä or ü end up as weird signs.
I've done some crazy shit before to fis this, like manually replacing those occurences, or converting the dump with iconv. I guess I should have read the man page more carefully, because mysql has an option to tell it which charset your file is in: default_character_set
Use mysql --default-character-set utf8 < dump.sql to im import your dump and everything works fine.
Wednesday, 25. February 2009 21:00 - daniel - Other - 0 Comments
Click to enlarge
E160 constantly disconnecting
Monday, 23. February 2009 11:22 - daniel - Other - 13 Comments
Yesterday I had to use my E160 UMTS stick on my windows PC at home, because my normal internet connection went down. The E160 works quite well and I have a pretty strong signal at home, so no problem there. Web browsing and teamspeak was fine, but World of Warcraft kept disconnecting every few seconds.
After a bit of research it turned out, that my E160 probably has a faulty firmware installed. Updating the firmware to 11.604.21.00.156.B409 should fix the problem.
For some reason Huawei doesn't provide this update on their homepage, so it took me quite a while to find it. I finally got it from drei.at. I have a different service provider, but the update works nevertheless. It only updates the firmware and keeps the Mobile Partner software intact.
I haven't played World of Warcraft after I updated the firmware, but everything seems fine. In fact I'm writing this post while using my E160.
To make a long story short: Here is the download link for the firmware update if you happen to be in the same situation as me.
E160Update_116042100156B409.zip 7406 KB