New domain pew.cc
Mon, 29 Jun 2009 19:11 - Daniel - Other - Comments (0)
I've got a new domain: pew.cc. The old tac-ops.net was nice, but kinda long and some people told me that they couldn't remember it. The now one is only 5 chars even with the ending, so everyone should be able to remember it. Also, its the sound my laser gun makes when I shoot you ;).
All the stuff that was on tac-ops.net will remain that. For now I only moved the blog from dani.tac-ops.net to blog.pew.cc and redirected all the old links to the new domain. files.tac-ops.net and all the other stuff will stay the same for the time being.
I had quite a hard time setting up the name servers for pew.cc. My secondary NS woudn't fetch the zone file after an update. It turned out that the master NS wasn't sending notices to the slave NS. Well' he was sending updates, but not for the pew.cc domain. Everything seemed alright, until i discovered that the domain I use for the NS server aliases was also configured in the master NS, but the A records for the ns1 and ns2 subdomains were missing. When the master NS tried to look up adresses for nameserver to send the notices to he coudn't find the IP. Removing the old zone entry solved the problem.
Tags: domain pew.cc tac-ops.net bind dns
Flame Turn In WoW Addon
Sun, 21 Jun 2009 19:22 - Daniel - Other - Comments (0)
This add on automatically accepts and finished the Midsummer Fire Festival quests Honor the Flame and Desecrate this Fire. As soon as you open the gossip dialogue at a Horde Bonfire, Alliance Bonfire or a Flame Keeper it will accept the quest and finishes it. No configuration, no output, nothing else
Here's the project on wowace.com: Flame Turn In
Here's the download on curse.com: Flame Turn In
Also someone asked me how to get the total buyout value of your auctions. Here is a macro to do just this. Open the AH window and press it. It will print the sum of your buyout auctions to the default chat frame.
/script local sum=0; for i=1,GetNumAuctionItems("owner"),1 do local a = { GetAuctionItemInfo("owner",i) }; sum=sum+a[9]; end DEFAULT_CHAT_FRAME:AddMessage(floor(sum/10000).."g")
Tags: curse wow world of warcraft wow addon macro lua ace wowace
EU Die Todeskrallen realm statistics
Sat, 13 Jun 2009 22:34 - Daniel - Other - Comments (0)
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.
Tags: wow world of warcraft
Perfect Screenshot WoW Addon
Tue, 05 May 2009 13:26 - Daniel - Other - Comments (0)
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
Tags: wow world of warcraft wow addon perfect screenshot lua ace wowace
Importing mysql dumps from phpMyAdmin
Mon, 30 Mar 2009 16:12 - Daniel - Other - Comments (0)
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.
Tags: mysql charset character set phpmyadmin