Kenyon Ripstop Repair Tape
As for your tent, it's perfectly repairable. The rock put in a tear, right? So you can match the torn edges together. You have two options. One is a homemade fix, involving a fair amount of repair material such as Kenyon Ripstop Repair Tape ($3 a roll; www.rei.com) or Kenyon K Tape (same price). Use the K Tape for the tent fly. Use the Ripstop tape for the inner tent. Just mate up the torn tent edges and tape away, using tape along the tear and, at intervals, at right angles to the tear. It won't be terribly aesthetic, but it'll hold up and work fine. And the fly will be waterproof.
Alternatively, you can send the tent either to The North Face for a repair, or to a good outdoor-gear repair specialist such as Rainy Pass Repair (www.rainypass.inc) in Seattle. I would expect to pay around $50 or so for a good-quality fix.
Get it fixed, use it for a few more years, then retire it and hang it on the wall with all its battle scars.
For more essential tent-care tips, read "Respect the Roof" from Outside's 2004 Buyer's Guide .