Several things here to be considered. I don't know you so I can't say what it the exact problem is. But people always pinpoint one activity as the cause. Look at everything you do and think about the big picture sometimes. There's a chance that climbing may not even be the issue with the pain. You mentioned your curling up at night. You may be placing strain on the tissue depending on how you end up placing them. Maybe this is a cause rather than a symptom. Or, a slight issue caused you to get in to this habit and now its caused more problems similar to how a slight ankle twist can cause you to change the way you run and lead to a more significant injury in the knee.
Also, as a contractor, look at your habits there and see if something changed in the previous months.... Not days or weeks, but months. Increased work load? A busy period you may have never recovered from? In all likelyhood, climbing is a significant factor, but it would be narrow minded and a kneejerk reaction to attribute the pain to climbing without considering other aspects.
Now for my favorite part-- training. TAKE TIME OFF. Every athlete I deal with doesn't rest enough. They think they do, but they don't. As a result they can't go hard enough on their hard days and don't adapt. Then they think they need to train harder. Its a bad cycle unless you have the discipline to take time off. Don't climb every day. As a general rule, take at least one day off per week. And since your work is physical, make it a day off from work. Then, have recovery days. Again, physical work makes it a bit more challenging like the cyclists I train who commute by bike to work. But you have to have discipline to make it work. If you do have an injury, just scaling back will likely make things suck for a very long time rather than actually recovering. It sucks, but taking the time off may be the only real option to get better. With bug-con4, its not a bad time either. It may only take a couple weeks to have you back on the rock. And, detraining has several aspects. Some of them are fairly quick, such as 24 to 28 from your last exercise bout, to weeks. Its impossible to say exactly where you'll end up at this point. But on a good note, it doesn't take much activity to maintain some level of training. And that physical job that I said made things difficult helps here-- it could provide enough stimulus to help keep you form starting from 0. Somebody mentioned antagonistic muscle groups earlier. Thats a good consideration. But remember a couple of things--we have no clue what your fitness/training level is. You may sufficiently train those muscles in your current activity. Or, you may do things that make it worse. If you do decide to start training the antagonists, there are several things to consider. One is that it take several weeks before any measurable strength change is made through actual muscle adaptations--its neurological to begin with. Secondly, going and adding on additional training if you are in an overuse situation or overtrained will only make things worse. If you keep looking in to this stuff, realize that over training syndrome is very different from an over use injury and they have completely different causes and symptoms--changes in appetite and women stopping menstration doesn't usually happen with tennis elbow but do occur with too many miles. Does the pain cause you to not sleep or have you just had a lot of trouble sleeping in addition to the pain?-- Two very different things.
Man, as far as the pain meds--quite a few issues. One, you are possibly masking symptoms making it worse by hiding the signal yelling "hey wanker stop this, I'm hurt!" Then you go and workout and make it worse and don't realize it. So be very aware of yourself and even start documenting pain levels on a scale of 1 to 10 when you get up and say after lunch after working for a bit. Two, anti-inflamatorys can INHIBIT healing depending on the injury type. If it is just random inflammation, yeah they can help, but if the mechanism of injury is different, you can slow the healing process. Your body runs on signals and messangers. Many of things that seem bad may help in the long run. With inflamation, many of the cellular responses cause pain and swelling. But, they serve as a signal to heal a wound-- exactly how a typical cut heals. Its been shown that antinflamatories can inhibit proper adapation because they stop some of those signals that do cause you pain but also signal for reinforcements at the injury. Again, this depends on the injury etc. But its well documented with muscle soreness and training adaptations which utilize similar means to say "man, I'm broke. Get some help!"
Scheduled rest is huge. Its also unique to the individual. Some old school training had athletes take 2 weeks completlely off at the end of the season. This is a BS approach. Its unique to every athlete. If you did everything correct, you may need a week of other activities just to recharge mentally. If you're overtrained or injured, more time may be required. I have a guy who needs 3 weeks off after his goal races b/c of both training and family stress/life. The point is, scheduled rest is good. And its better to error on the side of extra rest. But avoid any advice that says "take exactly x days off."
Its hard to get things straightened out with such little information. As a bit of a shameless plug, PM me as I do provide training services and consulting for athletes. I'm not a doc so I can't say "your injury is this." But I do specialize in training plans for various life styles and goals for motivated athletes or evaluating and providing feedback on what you do with an objective eye. With most people, honestly, just having somebody say "this is too much and you can do more of this" from the outside provides most of the change. Like a food log, it makes you completely accountable rather than "well I felt hungry and figured one more chocolate wouldn't hurt." Same thing goes for intensity and rest. Oh, and I like bartering as a I realize climbers are a bit of a different demographic than my usual clients-- I've been known to be hanging around some cool people and treated to a few beers and then have my new found "buddy" walk away with a training plan that would equate to a mortgage payment.