HDL

Town Square => Applications => Topic started by: Kriechentod on Sat, 2008-05-17 : 22:34

Title: Kriechentod application
Post by: Kriechentod on Sat, 2008-05-17 : 22:34
Character name(s), class(s), and level(s)

Kriechentod Warlock 70 - Affliction PVP machine and Alt Sugar Daddy
http://www.wowarmory.com/character-sheet.xml?r=Zul%27jin&n=Kriechentod

Totungrand Rogue 62 - Assassination PvP
http://www.wowarmory.com/character-sheet.xml?r=Zul%27jin&n=Totungrand

Player name - Joe K

Player age - [HDL] guild and Ventrilo chatter is for mature audiences only.

38

Where did you hear about [HDL]?

Novus Suscipio Motlen Core cannon fodder
Maelstrom 5th string raider
Followed the crowd I guess but Dust of Life is not for me. Looking for extreme casual and mostly battleground or world pvp - not much for arenas yet.

Why do you want to join [HDL]?
Casual fun with some folks that I knew from times past.


Will you dedicate 5 days a week to raiding? Not a chance

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

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?

Obvious - 2

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?

Easy - 2

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.

Thats a 2 also

Does .Net suck?

If you are talking Microsoft - then .net sucks, but it keeps me employed. If you are talking top level domains, then I love it. The more extensions you have, the more pages. The more pages out there in the net, the more I have to do at work.

Whiskey or whisky? Bushmills Original - single malt Irish FTW so that is whisky. Get that Tennessee barrel water outta here

Rank in importance to you: Raiding, Fun, PVP, Loot, Camaraderie, Wine, Women/Men, Music, Altaholism, Crafting.
Women (just in case my wife reads this), Fun, Camaraderie, PvP, Altaholism, Wine, Crafting, Loot, Raiding

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


#!/usr/bin/perl -w
use strict;
use Mysql;
my %server_data;

$host = "localhost";
$database = "store";
$tablename = "inventory";
$user = "username";
$pw = "password";

$connect = Mysql->connect($host, $database, $user, $pw);

$connect->selectdb($database);

$myquery = "INSERT INTO
$tablename (id, product, quantity)
VALUES (DEFAULT,'pineapples','15')";

$execute = $connect->query($myquery);

$affectedrows = $execute->affectedrows($myquery);

$lastid = $execute->insertid($myquery);

print $affectedrows."
";
print $lastid."
";

while (<DATA>) {
    next if /^\s*$/;
    chomp;
    my ($server, $data) = split /,\s*/;
    $server_data{$server}{$data}++;
}

foreach my $server (sort keys %server_data) {
    foreach my $data (sort keys %{$server_data{$server}}) {
        print "$server, $data\n";
    }
}

Can you follow kill order? Sure. Gnome, Pally, Priest, Dwarf, Night Elf, Human, Purple thing.

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

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

Really? Why do you still want to join [HDL]
Yes please. The game is more fun with like minded folk.


PS - Perl script is a collection of this and that which I found out there that sounded like it did something. If you want Cold Fusion and SQL, then I can be legit.  :-)
Title: Re: Kriechentod application
Post by: Vitandus on Sun, 2008-05-18 : 04:17
Hey, Kriechentod! Long time, no hear. I'll look for you in-game.
Title: Re: Kriechentod application
Post by: Vitandus on Mon, 2008-05-19 : 23:00
Invited.