Category: Informative

Posted on

For those who want to cross the auckland harbour bridge sunday 24th

One day in May, 1959…
50 years ago the Auckland
Harbour Bridge was opened to
pedestrians for one day;
since then only motor vehicles
have been permitted.

The NZ Transport Agency refuses to let Aucklanders walk and
cycle over the Auckland Harbour Bridge. But their reasons just
don’t stack up (see over for the facts). After years of trying to
negotiate with them, it’s clear that they just want to build more
roads for more motor vehicles. So join community leaders and
Walk Auckland for a peaceful march over the Bridge.
Come along, rain or shine!
Bring your family and friends
for a fun time and take part
in a unique demonstration of
support for the walk/cycle way!

meet at Point Erin (south side of the Bridge) at 9am for a 9:30am march

Will it be safe?

Yes. We’ve asked the NZ Transport Agency and Police to help
make this a safe event by keeping the Western clip-on lanes
closed for the morning. (These lanes are currently closed each
night for major strengthening work on the Bridge.) We will not
force our way onto the Bridge. But we will be very clear that we
want to get across. We have chosen a day and time to avoid
interrupting the traffic.

What if they don’t let us across the bridge?

We hope to get across. But if we don’t, we’ll still be showing
the NZ Transport Agency and government that many Auck-
landers strongly support the walk and cycle way.
This demonstration of people power will help overturn

NZ Transport Agency’s longstanding opposition. And if we’re turned back, we can always try again next month! ck, we can always try again next month!

Once we’re across, how do we get back?

There are several options. We’ve asked for the western clip-on
lanes to be closed to traffic until 11:30am. This gives plenty of
time to walk the 2 km in each direction. Otherwise, walk to
Akoranga Busway Station to catch a bus, or bring your bike and
cycle back using the Devonport or Bayswater ferries. See
www.maxx.co.nz for details of public transport options.
This demonstration of people power will help overturn
NZ Transport Agency’s longstanding opposition. And if
we’re turned back, we can always try again next month!

Can we afford it?

Yes. The Government’s just announced an extra $1 billion over
the next three years for the State Highway network, so the
money’s definitely available. In these tough economic times,
people need low-cost transport. Walking and cycling are the
cheapest (and most environmentally-friendly) options.

Why is this a priority for the region?

access will boost walking and cycling in the region. The
walk/cycleway will make Auckland’s harbour much more
accessible and enjoyable for all.

Could it be part of the National Cycleway?

Yes! The walk/cycleway will create many jobs while it’s being
built and will generate long-term tourism. It will make for a
spectacular day trip and encourage visitors to spend more time
in Auckland.
What would we call it?
The 10,000 who have already registered their support at
www.getacross.org.nz strongly prefer naming the walkway and
cycleway in honour of Sir Edmund Hillary.  This seems
appropriate: Sir Ed loved the Hauraki Gulf and encouraged
people to be physically active.
So why does the NZ Transport Agency oppose it?
The NZ Transport Agency are fundamentally road builders who
think they can solve transport problems with bigger roads.
They have a long history of giving motor vehicles priority over
walking and cycling. Their opposition to walking and cycling
access on the Bridge goes back many years and there is a
history of excuses and broken promises – see
www.getacross.org.nz for details and how each excuse can be
addressed. Their latest excuse is that the walk/cycleway would
affect the clip-ons’ ability to carry heavy trucks in the future.
But their recent decision to ban trucks from the clip-ons means
this reason no longer stacks up.
What else can you do?
• Visit http://www.getacross.org.nz to learn more and get the
latest updates. Read about the NZ Transport Agency’s history
of broken promises and excuses for not allowing walking and
cycling over Bridge
• Donate! Contributions to help cover printing and advertising
costs are much appreciated.  Please direct credit our ASB
bank a/c: 12-3057-0824362-01
• Pass it on to your friends and family, and invite them along –
we need as many people as possible
• Print or photocopy this flyer and put it around cafes, your
gym, your workplace… anywhere you think people may be
interested
To offer help or for further information that’s
not online contact:
Please contact us!…  e-mail andy.smith@livingstreets.org.nz or
phone 021 474 740

See you rain or shine at 9am Sunday 24 May!

Please excuse any weirdness in the text, its from copy/pasting between a PDF and my blog 🙂

Posted on

Howto Manually Merge 2 categories in wordpress

So I had imported a few different blogs and other websites when i put together this one. the idea was that i could be rid of the 4 other websites or so and just have the 1. This was great in theory and i was a wordpress virgin. Everything previously used was ‘roll your own’ stuff I had written from scratch. This time I decided I would give it a go, and i stuck with it.

The importer worked brilliantly and imported blogger.com and other things all over the show. Some copy/paste was required for my own stuff, but for the most part a few well thought out SQL queries worked nicely.

My problem was that I had a couple of double up categories. Like “Facts” and “Informative”, and also “Humour” and “Funny” . I wanted to merge these together without having to manually edit every single post.

I found a few different plugins – however they were for earlier versions of wordpress. Then Apon googleing i found the following page which gave a great rundown!

http://www.franzone.com/2008/10/02/how-to-manually-merge-wordpress-tags/

Okay this is the dumbed down version for people NOT familiar with computering and SQL. Find PHPMyAdmin – its a pretty web interface thats probably installed on your server that interacts with the database.

Select your database name. Export your entire database and save it to your HDD. This is important, you might screw things up ok? No biggie if you do, you can restore it.

Now login to your WordPress backend. Click on “Categories” which shows your categories.  On the right hand side of each Category it shows how many posts are in each one. If you hover your mouse over that you can see the link goes to yoururl.com/wp-admin/edit.php?cat=xxx  in your status bar. If unsure then you can click the link and it will be in your URL.

The xxx is a number, That number is the category number which is the key to it all.

So find your 2 numbers of the ones you want to merge. Choose one of them as the one you want to merge into the other (ie if you have say 25 and 26 you are going to merge 25 INTO 26).

Now, heres the fun part. Updating the posts.

Open your PHPMyAdmin, click the tab at the top that says SQL. It will have a big empty box with the name at the top “Run SQL query/queries on database”

Into this box you need to type

UPDATE `wp_term_relationships`
SET `term_taxonomy_id` = xx1
WHERE `term_taxonomy_id` = xx2;

replace the xx1 and xx2 with the 2 categories you want to merge. xx1 would be the one you want to move them FROM, and xx2 is the one they are all going to move to.

If you get an error on this, by all means stop what you are doing and consult somebody else, Probably means you have that post in both categories already.

If it runs and says something along the lines of ‘complete, updated xxx posts’ then we win. Now you can remove any leftover garbage and the category. Do not run this if you have any errors.

DELETE FROM `wp_terms` WHERE `term_id` = xx1;
DELETE FROM `wp_term_taxonomy` WHERE `term_id` = xx1;

When i have xx1 here i mean use the same number you replaced earlier with xx1, the ones you moved posts out of. It should be fairly empty already.

This will not delete any posts. If all goes wrong then the most it will do is put your posts into Uncategorized.

Good luck!