documentation

i was working on a spreadsheet for a customer and it had over 6000 cells in it. every single cell had a leading space. after much searching on google, i finally found the correct answer, and here it is.

  1. ctrl + f to open the search and replace dialog box
  2. enter ^[:space:]+ into the search box and leave the replace with box blank
  3. done!

 

so the other day i had to import an address book from windows live mail into gmail. the issue was that every time i did an export from windows live mail, it would mess up the csv, so when gmail read it it imported all the email addresses and data into the notes field. however, gmail could import a .vcf just fine. so i exported all the contacts to .vcf format and dumped them into one folder. then ran copy /B *.vcf all_in_one.vcf. this copied all the .vcf’s into one file. i was then able to import the file into gmail no problem.

wow. i never thought i would have to google how to right click using ubuntu on the powerbook.

apples powerbook touchpad has no middle or right mouse button – where this isnt a big problem using os x, in ubuntu it can generally be an issue.

after much googling i finally found that by default the mouse middle-click was f11 and the mouse right-click was f12. now these are mapped and can be changed by editing the /etc/sysctl.conf and mapping dev/mac_hid/mouse_button2_keycode and dev/mac_hid/mouse_button3_keycode to their corresponding key scan codes.

you can get the key scan codes by running sudo showkey then pressing the key or keys for which the scan codes are to be printed. to exit the key mapping software, press ctrl d.

C boot from cd or dvd
D force the boot device to be the internal hard drive
T start in firewire target disk mode – essentially turns your mac into a wicked expensive external hd
X force boot into mac os x (older macs that dual-boot into os 9 and x)
N boot from network drive
shift hold after power-up to boot into safe mode, hold after login to prevent startup items from opening
mouse button eject cd before booting normally
command-S boot into single user mode; type exit when done
command-option-O-F boot into the open firmware prompt
command-option-P-R reset PRAM
command-option-V verbose boot
command-option-shift-delete bypass internal hard drive and boot from external drive or cd
option shows the startup manager for all bootable drives
command-. when startup disk chooser is active, open the cd tray

you can run this using the run command, or access it via windows explorer address bar or create a shortcut. any way you do it will bring up a massive list tasks for windows 7. it was originally developed by the windows developers to show search results, so whenever you search for something in the control panel, this page is searched.

here it is -

shell:::{ED7BA470-8E54-465E-825C-99712043E01C}

i did this all on a ubuntu 11.04 server virtual machine inside of an ubuntu 11.04 host.

open /etc/apt/source.list in your favorite editor and add the following line
deb http://download.virtualbox.org/virtualbox/debian natty contrib

 

get the virtualbox public key
wget -q http://download.virtualbox.org/virtualbox/debian/oracle_vbox.asc -O- | sudo apt-key add -

 

update the package database
sudo apt-get update

 

now install virtualbox 4
sudo apt-get install linux-headers-$(uname -r) build-essential virtualbox-4.0 dkms

 

download and install the extension pack (this is required since virtualbox outsourced some funcionality)
cd /tmp/
sudo wget http://download.virtualbox.org/virtualbox/4.0.8/Oracle_VM_VirtualBox_Extension_Pack-4.0.8-71778.vbox-extpack
sudo VBoxManage extpack install Oracle_VM_VirtualBox_Extension_Pack-4.0.8-71778.vbox-extpack

 

add user to vboxusers group
sudo adduser mike vboxusers

 

now virtualbox is installed and ready to use. the next posts will be on configuring and using virtualbox via the command line and managing your vms via phpvirtualbox

 

in the linux world, we can always grep a command. today i needed to be able to do the same thing in dos.

help find

Searches for a text string in a file or files.

FIND [/V] [/C] [/N] [/I] [/OFF[LINE]] "string" [[drive:][path]filename[ ...]]

/V Displays all lines NOT containing the specified string.
/C Displays only the count of lines containing the string.
/N Displays line numbers with the displayed lines.
/I Ignores the case of characters when searching for the string.
/OFF[LINE] Do not skip files with offline attribute set.
"string" Specifies the text string to find.
[drive:][path]filename
Specifies a file or files to search.

If a path is not specified, FIND searches the text typed at the prompt
or piped from another command.

 

so, for example, if you wanted to find just the system model of a pc using systeminfo, you would type to following:

systeminfo | find /i "system model"

&

it can also be used with netstat

netstat -ano | find /i "80"

there are tons of guides out there on this topic. this is just here so i can get to it faster.

reset 10.5 leopard & 10.6 snow leopard password

  1. power on or restart your mac.
  2. at the grey screen hold down command+s on your keyboard to enter single-user mode
  3. it’s a good idea because it checks the consistency of the hard disk before moving on. at the prompt, type fsck –fy and press enter. wait for the checks to complete before going to the next step.
  4. type mount -uw / and press enter
  5. type launchctl load /system/library/launchdaemons/com.apple.directoryservices.plist and press enter.
  6. type dscl . -passwd /users/username password and replace “username” with one of the users displayed in the previous step. replace “password” with a new password of your choice. press enter.
  7. reboot

 

reset 10.4 tiger password

  1. power on or restart your mac
  2. at the grey screen hold down command+s on your keyboard to enter single-user mode
  3. type sh /etc/rc and press enter
  4. type passwd username and replace “username” with the short name of the user account for which you’d like to reset the password
  5. type your desired password and press enter
  6. reboot

 

from blizzard:

january 7-18

    general

    • broiled dragon feast is correctly being tracked by the guild achievement, set the oven to "cataclysmic".
    • the guild achievement lower blackrock spire guild run can now only be earned in a group of at least 4 players from the same guild in a 5-player party.
    • the achievement sunwell plateau guild run now requires a guild group to complete. this achievement can no longer be completed without the requirement of having 75% of the raid be guild members.
    • guild experience daily resets should no longer sometimes fail to occur.

    classes

    • death knights
      • necrotic strike is now affected by resilience.
    • druids
      • druids previously unable to learn nature’s grasp will be able to learn that spell now.
      • rejuvenation now consumes 16% of base mana, down from 26%, but still requires 26% of base mana in order to be cast. a patch will be required to address this discrepancy.
    • mages
      • rank 1 of pyromaniac no longer improperly gives 5% passive haste.
      • the mana costs of the following mage spells have been reduced, but they still require the previous percentage of base mana in order to be cast: arcane barrage (11% of base mana), arcane blast (7% of base mana), and fireball (12% of base mana). as an example, fireball requires 16% base mana to cast, but only consumes 12% of base mana. a patch will be required to address this discrepancy.
    • priests
      • sin and punishment is now properly causing its terror affect when dispelled. in addition, it no longer shares diminishing returns with fear effects. it now shares diminishing returns with horrify effects.
      • priests who were unable to learn holy nova will now be able to train the spell.
    • warlocks
      • while nightfall is active, doomguards will not instantly cast doom bolt.
    • warriors
      • a bug has been fixed where the shield block ability granted 25% more critical block chance than was intended for protection warriors with very high total chance to avoid attacks.

    dungeons & raids

    • it should no longer be possible for players to inadvertently be locked out of killing a raid boss depending on whether or not they were online when the boss was killed.
    • the battle resurrection counter will now correctly reset if players are not inside the dungeon when an encounter resets.
    • the bastion of twilight
      • the hotfix on january 5 to increase the damage of liquid ice during phase 3 of the ascendant council fight has been reverted. due to a separate bug with the size of the elementium monstrosity’s hitbox, it is often impossible for melee classes to avoid damage from this ability. this issue is slated to be addressed in patch 4.0.6 so that liquid ice damage can again be increased.
      • many adjustments to the behavior of various mechanics in the sinestra encounter have been made.
      • fester blood now hits everyone in the room instead of having a 20-yard radius on heroic difficulty during the cho’gall encounter.
      • valiona’s blackout can no longer be absorbed by grounding totem or reflected. its healing absorption effect has also been increased for 10-player normal difficulty.
    • blackwing descent
      • atramedes will now reset if the players targeted by sonic breath or obnoxious fiends attempt to leave the room.
      • zoning into the dungeon after a soft reset now causes all atramedes-related objects and creatures to reset completely. the introduction event will replay once the dwarves have been cleared. entering combat with atramedes forces the gongs to become usable and the fight will function normally from this point.
      • atramedes will no longer despawn when his tail passes through the area trigger in the entrance to his room. he will no longer despawn randomly during the fight. pulling him out of his room will now cause him to reset.
      • the damage of chimaeron’s caustic slime has been reduced for both raid sizes and dungeon difficulties.
      • chimaeron will not cast caustic slime on feral tanks in bear form unless there aren’t enough non-tank specialized targets available. this fix applies to magmaw’s targeting functionality as well.
      • rip and bane of doom damage is no longer affected by the damage increase of stolen power when engaging nefarian.
      • abberrations spawned during the maloriak encounter were displaying inappropriately high health values on heroic difficulty. this has been corrected.

    items

    • bloodthirsty gladiator’s badge of dominance and vicious gladiator’s insignia of dominance on-use effects now properly modify healing done.
    • darkmoon card: volcano now triggers from periodic damage.
    • divine shield and blessing of protection no longer remove the blind spot debuff from the normal and heroic versions of the jar of ancient remedies. when targeting an ally at very close range (2-3 yards) when using this item, it will still energize them instead of the user. this will be fixed in an upcoming patch.
    • free action potions now cannot be used above level 80.

    professions

    • archaeology keystone fragments can no longer be prospected.
    • lifebound alchemist stones can no longer be disenchanted.

    pvp

    • arenas
      • ring of valor has been temporarily disabled until select bugs can be fixed in an upcoming patch.
    • battlegrounds
      • teams who are in the rated battleground queue and have a member disconnect are now removed from the queue after 10 minutes if the player does not come back. the team is still at the top of the queue if the player comes back and the battleground will pop almost instantly.
      • battleground ratings, wins, and losses should now always update after every game when playing in rated battlegrounds. certain conditions were not causing this to happen previously.
      • players who do not show up to a rated battleground, either by leaving the queue or letting the battleground queue time out, are not being credited for a win.
      • players who are removed from a battleground when it closes due to a lack of players will not receive the deserter debuff.
      • players are again able to queue for more than one battleground at a time without issue.

    quests & creatures

    • darnassus
      • worgen character hearthstone location is now set to the craftsmen’s terrace in darnassus upon completing the quest "ruh’theran village".
    • deepholm
      • fungalmancer glop no longer grants experience and now rewards quest kill credit to all players who have damaged him.
    • tol barad peninsula
      • players will receive quest credit for killing any quest boss, regardless of party status, so long as they participate in killing these bosses.
      • problim can now be seen from a much larger distance.
      • cell watchers in d-block are no longer incorrectly tagged as elite.
      • "the leftovers", "swamp bait" and "a huge problim" can now be shared between members of the alliance. in addition, these quests now award the correct amount of gold and faction for the horde and alliance as well.
      • darkwood broodmothers no longer flee at 25% and periodically inflict targets with reckless toxin instead.
      • hungry ghouls and skeletal beastmasters now drop the cursed femur quest item when on the quest "salvaging the remains", and the tooltip also indicates these creatures drop the quest item.
      • restless infantry and restless soldiers now spawn more quickly.
    • twilight highlands
      • if reinforcements are not called after 60 seconds, skullcrusher will now despawn. when reinforcements are called, skullcrusher no longer improperly despawns.
    • uldum
      • titanic guardian’s burning gaze ability should no longer put everyone in the zone in combat.

source

epic enchants
epic enchants is a great site for going over all the enchants in the game. it is not limited to just the enchanting recipes, it also includes all the other professions, as well as the various rep required enchants.

 

wow gem finder
i know i have posted this here before, however, it is absolutely worth mentioning again. i have yet to see a better site dedicated to wow gems.

 

wow professions
i dont know to many people who dont use this site for help with there professions. it is incredibly detailed for every profession.