HDL

General Info

Character name(s), class(s), build(s), and level(s)

Doncalmeray - 84 goblin hunter, beast master, secondary survival

Player name (We operate on a first name basis in HDL)

Max

Player age - [HDL] guild and Ventrilo chatter is for mature audiences only. If you are not 18+, you will need to be sponsored by a guild member in good standing.

41

Where did you hear about [HDL]?

mindflayer - Patrick

Why do you want to join [HDL]?

the stories mindflayer has told me about the guild make it sound interesting

What is your guild membership history? Why did you leave or want to leave?

Doncalmedon is in Death Legion on another realm, would be happy to switch.  Doncalmeray is currently in Prodigal on Zul - a friend from work invited me there and then he left, nice enough guild but i do not know anyone and I like what i hear about HDL

What do you want from a guild?

Fun, casual raiding, casual PvP - I actually enjoy the trolling that happens in trade chat, can be very entertaining

Can you follow kill order?

yes

Are you a Casual player, Raiding oriented player, or a PvP oriented player?  If you think you are a combination of any of those, what percentage of time would you spend on each?

Casual + PvP (mostly BGs), have not raided much but am very interested in raids.

Raiding Questions

Will you dedicate 5 days a week to raiding?

No

If you answered ""Yes" to the question above, are you aware that [HDL] is not a hard core raiding guild?

Will you dedicate 2 nights a week to raiding?

I can

Are you willing to take/accept criticism to make you a better player?

What?  Do you mean you think i am not good enough to join?  This is #*#**#!  I mean yes

We do require Omen and Deadly Boss Mods. Do you have these installed?

I love Omen as a DPS and I know of DBM but have not used it, will be installing it tonight

What is your primary and secondary talent build? Which do you prefer?

Primary is beast mastery, secondary is survival (started that because I read it was good for raiding) - once I started with survival I stuck with it, though I do like beast mastery too

What is your rotation for your primary and secondary builds?

95% secondary, 5% primary

Explain your gear choices, including gems and enchants.

I like to mix between dungeons and BGs, prefer both of those over questing - with the hunter I have stuck with a decent PvE build and that has done me pretty well for PvP too (i used to try to keep two gear sets but that got to be a PITA for me).  I do my best to max out my iLevel via AH when possible, gems I prefer gems with haste, strength, or stamina buffs, enchants - currently fully enchanted across all gear with buffs for critical strike, agility, haste, and stamina

What do you think of Gearscore?

Before iLevel I liked it, i don't use it anymore, but I always understood that GS != skill

PVP Questions

You are headed to run an instance with non-guildies when you spot a flagged gnome. What is the proper course of action: 1) Ignore the gnome and head to the instance, 2) Send a message to the guild of your find. flag immediately, and kill the gnome, leaving the PUG to wait, or 3) neither. If you selected 3, what course of action would you take?


3) Leave PUG, messge guild,  flag, kill


You are headed to an instance with the guild when you spot a flagged gnome. What is the proper course of action: 1) Ignore the gnome and head to the instance, 2) Send a message to the guild of your find, flag immediately, and kill the gnome, leaving the group to wait, or 3) neither. If you selected 3, what course of action would you take?


3) Message the guild / group and then kill if guildies are interested or continue to instance if no one in the group is


A tea bag is 1) a small porous bag containing tea leaves or powdered tea, onto which boiling water is poured in order to make a drink of tea, or 2) a verb.


Both - one is much more socially acceptable than the other, but for some the less acceptable one may be more exciting.


Do you prefer Battlegrounds, Arenas, or World PVP? Why?


BG and PvP over Arenas - I have not done arenas with this toon but i have with others and i didn't enjoy it so much, i like the idea of arenas, but the chase is much more fun with BGs / PvP.


What is your favorite battleground? Why?


Strand of the Ancient and Arathai Basin - both have great chases and lots of intense extended PvP battles in my opinion - though I have done Arathai a lot it is still my favorite BG map of all of them.


Rank in important to stack for an Arena battle: Resilience, Attack Power/Spell Power, Critical Strike, Hit Rating.


I have only done a little arena, so can't give an answer here that would be based on anything but guessing.


Social Questions

How would you rate yourself as a World of Warcraft player?


Average skill wise but socially above average.


Does .Net suck?


Nah - Curse is cool, C# is an interesting language, and I like the idea of Mono


Whiskey or whisky?


You tell me, tough guy.  mod_speling or mod_spelling?


Rank in importance to you: Raiding, Fun, PVP, Loot, Camaraderie, Wine, Women/Men, Music, Altaholism, Crafting.


Fun, camaraderie, Raiding, PvP, Music, crafting,  altahalism, women/men, wine.


Please provide a perl script that will sort a CSV file by first column, then second, and then insert into a mysql database.

Sample data:


f1,f2,f3
I,am,writing a script
I,be,using perl for it
That,should,sort first by column one
That,will,sort second by column two
Finally,will,insert into the database
All,data,that it finds


Script:


#!/usr/bin/perl

use strict;
use warnings;
use DBI;
use Tie::Handle::CSV;

my $CSV_FILE = $ARGV[0] || die "$0 csv-file";

my $DSN = q{DBI:mysql:database=test;host=localhost};
my $DBH = DBI->connect($DSN, 'test', 'test', { 'RaiseError' => 1 });

my $FH = Tie::Handle::CSV->new($CSV_FILE, header => 1);

my $HASH = {};

while (my $csv = <$FH>) {

  if (! defined($HASH->{$csv->{'f1'}}->{$csv->{'f2'}})) {
    $HASH->{$csv->{'f1'}}->{$csv->{'f2'}} = [];
  }

  push(@{ $HASH->{$csv->{'f1'}}->{$csv->{'f2'}} }, $csv);

}

my $STH = $DBH->prepare( q{ INSERT INTO t1 VALUES(?, ?, ?) } )
            || die "Prepare failed: $!";

for my $f1_key (sort keys %{$HASH}) {
  for my $f2_key (sort keys %{$HASH->{$f1_key}}) {
    my @array = @{ $HASH->{$f1_key}->{$f2_key} };
    for my $line (@array) {
      $STH->execute($f1_key, $f2_key, $line);
    }
  }
}

END {
  close($FH) if defined $FH;
  $DBH->disconnect if defined $DBH;
}


MySQL output:


+---------+--------+-----------------------------------------+
| f1      | f2     | f3                                      |
+---------+--------+-----------------------------------------+
| All     | data   | All,data,"that it finds"                |
| Finally | will   | Finally,will,"insert into the database" |
| I       | am     | I,am,"writing a script"                 |
| I       | be     | I,be,"using perl for it"                |
| That    | should | That,should,"sort first by column one"  |
| That    | will   | That,will,"sort second by column two"   |
+---------+--------+-----------------------------------------+


What is your favorite instance? What is your favorite boss fight?


Just ran Grim Batol last night for the first time and really enjoyed that one.  I am really enjoying the cata instances (except for VP because I have run that so many times) because they are new content.


Are you easily offended? Is your hot button race, religion, sex, or politics?


Not easily offended


Are you aware the [HDL] is largely a collection of angry and cynical players and under-geared toons?

Yes, mindflayer gave me the heads up

Really? Why do you still want to join [HDL]

I work with mindflayer and like what he says about HDL

Does Pat make you call him Mindflayer at work? That explains so much.

Only on 'instance days' - which means on Tuesdays we get to call him by his Real ID (tm) as opposed to his toon 'name of the day.' 

The "doesn't offend easily" is answered by the "I work with Pat".

Quote from: obemathortai on Sun, 2011-05-15 : 21:32
Please provide a perl script that will sort a CSV file by first column, then second, and then insert into a mysql database.

Sample data:


f1,f2,f3
I,am,writing a script
I,be,using perl for it
That,should,sort first by column one
That,will,sort second by column two
Finally,will,insert into the database
All,data,that it finds


Script:


#!/usr/bin/perl

use strict;
use warnings;
use DBI;
use Tie::Handle::CSV;

my $CSV_FILE = $ARGV[0] || die "$0 csv-file";

my $DSN = q{DBI:mysql:database=test;host=localhost};
my $DBH = DBI->connect($DSN, 'test', 'test', { 'RaiseError' => 1 });

my $FH = Tie::Handle::CSV->new($CSV_FILE, header => 1);

my $HASH = {};

while (my $csv = <$FH>) {

  if (! defined($HASH->{$csv->{'f1'}}->{$csv->{'f2'}})) {
    $HASH->{$csv->{'f1'}}->{$csv->{'f2'}} = [];
  }

  push(@{ $HASH->{$csv->{'f1'}}->{$csv->{'f2'}} }, $csv);

}

my $STH = $DBH->prepare( q{ INSERT INTO t1 VALUES(?, ?, ?) } )
            || die "Prepare failed: $!";

for my $f1_key (sort keys %{$HASH}) {
  for my $f2_key (sort keys %{$HASH->{$f1_key}}) {
    my @array = @{ $HASH->{$f1_key}->{$f2_key} };
    for my $line (@array) {
      $STH->execute($f1_key, $f2_key, $line);
    }
  }
}

END {
  close($FH) if defined $FH;
  $DBH->disconnect if defined $DBH;
}


MySQL output:


+---------+--------+-----------------------------------------+
| f1      | f2     | f3                                      |
+---------+--------+-----------------------------------------+
| All     | data   | All,data,"that it finds"                |
| Finally | will   | Finally,will,"insert into the database" |
| I       | am     | I,am,"writing a script"                 |
| I       | be     | I,be,"using perl for it"                |
| That    | should | That,should,"sort first by column one"  |
| That    | will   | That,will,"sort second by column two"   |
+---------+--------+-----------------------------------------+

*golf clap*

Thsnk you, thank you - for my next stupid coding trick I shall perform 'Hello World!' In the key of C and return void to show I am a hawt coder - return codes are for whimps.

Do you keyboard turn?

You must have meant "does your keyboard turn?," and the answer is yes, it does, if I manually move it (unlike many of you, I did not get a motorized keyboard)

While it requires manual effort, my keyboard features a 360 degree turning radius on flat surfaces, and just this year I modded it so that I can also rotate it through the Z axis, which is really handy when it needs cleaning!