Drupal DKP Module

The Drupal DKP module will allow you to pull data from an existing eqdkp installation and display DKP stats directly in your Drupal setup. Currently this version is very beta, and there are no options. Your EQDKP installation needs to be in the same database as Drupal, and needs to have ‘eqdkp_’ in front of all table names. You can see it in action on guilds website.

Pulls DKP information from an existing EQDKP installation and displays it in Drupal.

Details

Drupal DKP integrates with EQDKP by giving you the following functionality:

• Display current standings
• Display loot distribution
• Display raid history
• Display individual member history (loot, raids etc)

Dependencies

The loot linking relies on functions from the drupal_armory module, which is located at http://losmuertos.houseofbob.net.

Installation

1. Download the module archive and expand it (you’ve likely already done this).
2. Put the ‘dkp’ folder in your modules directory. Since the /modules/ folder is typically reserved for Drupal core modules, as of version 5.x you should create a sites/all/modules/ directory and put uploaded modules there.
3. Go to administer > site building > modules. Check the ‘Enabled’ box next to the module and then click the ‘Save Configuration’ button at the bottom.
4. Go to administer > users > access control and make sure you set the permissions up, otherwise nobody else will be able to view the page.
5. Go to administer > site building > menus and create add a menu item (typically in your primary links). The name and description are arbitrary, but the path needs to be ‘dkp’.

Configuration

There are currently no configuration options available.

Known Issues

• The wow_armory plugin has many known bugs and is officially unsuported. You may find that item names (typically ones with symbols in the name) will not link properly. This is a bug of wow_armory, and there is nothing I can do. The workaround is to enter the item ID in EQDKP instead of the name.

Frequently Asked Questions

What do I do if my eqdkp tables start with something other than ‘eqdkp_’.

You’ll need to go through the dkp.module file and replace every instance of ‘eqdkp_’ with whatever your tables start with. I hard coded the table names because I built this module for personal use, I never planned for it to be release to the public.

What do I do if my eqdkp database is not in the same location as my drupal database.

Because I built this module for personal use, I never planned for this. Without making significant changes to the code, its just not possible.

Anything else?

That about does it – enjoy!

WordPress 2.3 should have been WordPress 3.0

Grr. So it seems there are lots of problems with the plugins I use also, because the brilliant minds over at WordPress.org decided to restructure both the database, and the admin files. These two changes, in my mind make it so that many plugins, themes and customizations no longer work.

Moving Servers

I’ll be spending today moving Indemnity83.com to a new server, so if you may see some downtime. Because the site is fairly static I plan on bringing up the second location in parallel with this one and then correcting the DNS to point to the new server so the downtime should be minimal.

Indemnity83.com is huge as far as personal websites go, comming in at just under 4.5GB but luckily the new server and old server are in the same data center, so I can transfer at full network speeds. I’ll still be with 1&1, and would highly recomend them to anyone for web hosting. I originally got on a 3 year free contract, and recently was offered the Developer Package at 50% as an upgrade on my 3-year contract. Indemnity83.com is on its own Developer package at the moment, but I have no need for two packages, so thats why I’m moving.

So now that I’ve bored everybody with my reasons, I should actually get started and stop wasting time.

======

Files have all been copied, and the new site is setup to run from the existing database, I’m just waiting on the domain move and DNS to update. If everything goes well you’ll never notice the downtime.

======

Everything is all transfered. Leave me a comment if you notice anything out of whack.

Pixel-Lated

http://www.pixel-lated.com

I helped a buddy out over the weekend by building him a phpBB forum and migrating all his data out of the overpriced crap he was using before (ZeroForum). It took up most of my weekend, but I’m pretty happy with how well it went, and I know he’s happy. He went with 1&1 for his hosting and is paying $5 / mo instead of $20. I have some more interesting news about my own 1&1 account, but I’ll bring it up later.

The ZeroForum software is proprietary, so getting data out of it was like pulling teeth. I wasn’t able to migrate users passwords, since I didn’t know what type of encryption was used, but that turned out to not be as big of a deal as I thought, I had the system generate 128 bit random passwords (dont want anybody complaining about my reducing the security of their account!) and just had all the users go though the “I forgot my password” process to have it reset to their liking. Any information I was able to get out of ZeroForum was only in XML files. So my migration process went something like this:

1. Export data from ZeroForum into a series of XML files.
2. Import the XML into an access database to get it usable
3. Dump those tables to an SQL transaction using Bullzip‘s Access to MySQL utility (highly recommended)
4. Run the transactions against the MySQL database
5. Write query’s to insert the new data into the phpBB tables doing any data transformation necessary along the way.
6. And finally, touch up the data, do things like encode IP addresses, rebuild the search tables and recount user posts.

The plan is to eventually add photoblogging (using b2evolution or perferable WordPress) and a more professional gallery (Gallery2) that would be for premium members. Right now there is a simple photo album that allows users to post up pictures, but no bigger than 800 pixels on a side and the image gets watermarked with the site logo.

I would encourage you to go take a look at the new site, if you like photography and design you’ll probably find it a great distraction.