Mass Deleting Comments from Spammers in Gallery

In case anyone needs this:

If you had a gallery installation where the comments where open to guests and started getting spammers, you can do this:

delete from g2_Comments where g_comment like '[url=%';

or to do by IP address since they are alike usually:
delete from g2_Comments where g_host like '197.66.55%';

Then when you think you've got the junk out, run cleanup:
delete g2_ChildEntity, g2_Entity from g2_ChildEntity, g2_Entity where g2_ChildEntity.g_id=g2_Entity.g_id and g2_Entity.g_entityType='GalleryComment' and g2_Entity.g_id not in (select g_id from g2_Comment)

Topics: 

Dreamhost...sigh

<rant>
Why in the world does Dreamhost not enable certain libraries I have no idea.   I wanted to try out some new accounting stuff (PHP based) and it doesnt work because the bcmath library is needed.   Yea yea yea, I know I could do a custom installation of PHP but come on...you should enable just about everything unless you have good security reasons not to.  

</rant>

Topics: 

Signs that you might be driving in California!

I figured I would come up with a list.    Signs you might be driving in California....these I've actually seen and experience on a day to day basis

  1. When a Full size pickup with a 20" lift, 8" aluminum blocks, 35" tires and bling bling 20" rims doing 85mph
  2. When you have been patiently waiting for 10 minutes in the turn lane for the freeway ramp only for some asshat to pass everyone, then block the thru traffic to butt in line, and cut you off right at the turn.
  3. When drivers speeding in the right turn only lane to by-pass traffic and swerve into the middle lane when the right turn lane ends.
  4. when all the slow drivers are in the fast lane while no one is in the slow lanes.
  5. when people leave 2 car lengths in front of them at a red light so it never trips the light sensors.
  6. when it rains, everyone slows down to 25 mph in a 65mph because they've never seen rain before.  
  7. When drivers think that the blinkers are accessories instead of a necessity
  8. When drivers think that they turn on their blinkers, they expect you to move out of the way while they force themselves over and cause you to slam on your brakes to avoid collision. 
  9. When those old vietnamese women who can barely drive talk on the cell phone and pull a U-turn over double yellow solid lines and turn right in front of you.  
  10. When you bought a new car and had been rear-ended twice in 3 months.
  11. When drivers in the fast lane drive at the same slow speed as the person in the next lane, not allowing you to pass.
  12. When the drivers commit any of the above and when you honk at them, they flip you off and cuss thinking its your fault. 
  13. When the drivers speed and drive over the 200 foot limit in the center turn lane.  
  14. When the drivers pull out in front of fast traffic causing you to slam on your brakes. 
  15. Improper lane changes for no reason.   They change lanes without using their blinkers even if they dont need to get around or pass any other cars.
  16. When the drivers drive on the right shoulder for many blocks, that is clearly NOT a marked lane
  17. When the person merges onto the freeway does a quadruple lane change to the fast lane when noone else is in front of them.
Topics: 

Keep El Dorado Trails OPEN!

Like to Hike, Bike, Offroad in Eldorado national forest??

In support of keeping the trails and routes of the Eldorado National
Forest open for OHV’s, hikers, campers, fishermen, hunters and more, preserveourtrails.com drafted the following letter to the Forest Supervisor in charge of
the proposed route closures and OHV access options. The 45-day review
period is coming to an end on September 4th and they need as much support
as possible to show that the OHV community is committed to keeping the
Eldorado National Forest trails and routes open.

CLICK HERE TO SIGN THE PETITION

Topics: 

Losing our recreational land that we pay for!

Guess what?   Taxpayers are losing access to public recreational lands!

Please sign this petition to help save our right to access what we
already have!   AND PLEASE, SHARE THIS WITH EVERYONE YOU RIDES/WHEELS/CAMPS on public land! Never assume everyone who WOULD sign receives word that there is
a current need for attention.

See link below:

Hi All
Our best offense against the sweeping Wilderness proposals is a good
defense. You can do your part by signing the petition to preserve
Multiple Use Lands at:

CLICK HERE TO SIGN THE PETITION

Topics: