Merge pull request #1 from arbradley/master

i tested things
Removed all of the DEFINER clauses

These are apparently auto generated when you dump MySQL, but don't work
when you re-import.  Surprisingly dumb...
Getting things working with PHP 5.4, mostly

Fixed several instances of <?, which is now deprecated -- you are
supposed to always say <?php.

Removed a bunch of permissions at admin login related to the forums that
we aren't using.

Replaced date() with gmdate(), since you aren't allowed to use date()
without a timezone any more.

Changed the DB connection info to match the trivial defaults that I am
using for development.
Fixed lots more <?php problems.
Merge pull request #2 from arbradley/master

Took a bunch of changes from Constance, mostly changing hardcoded Atlantian stuff to hardcoded Eastern stuff.
Set a default timezone

This is essentially required in modern PHP.  Put it in defines.php,
since it is essentially a configuration parameter.
Split the ridiculously long lines in db_empty

It is a generated file, and some lines have hundreds of records.  Broke
those down, to make them more comprehensible.  (Hopefully doesn't break
anything.)
Fixed all the hardcoded latin1 fields

These cause errors when trying to import UTF8 data, and I think they are
accidental export errors.
Merge pull request #3 from arbradley/master

Taking Constance's changes.  By and large, the files with names including "eastern" are going to be ignored, though, and eventually deleted in favor of more Kingdom-neutral names.
Fixed the problem with timing out during display of an order
Fixed (I think) display of gendered orders

It had hardcoded which orders had gendered descriptors, for reasons I
can't figure out.  The list wasn't right, and it was getting in the way,
so simply removed it.
We no longer display ENA in op_ind
Lots of tweaks and fixes

Biggest change is that we now take award_defines.php, from the OP
Compiler.  Rewrote the hardcoded award variables to be aliases to those.

Commented out tons of places where Atlantia's awards were hardcoded.

Removed more uses of get_preferred_sca_name, which is causing DB
timeouts.
Added the given_as field, to match the current data
Added a couple of DB fields
Use DISTINCT to remove idiotic duplications in op_ind

Doesn't fix the problem everywhere, but it's a start
Simplified the crazy-complex SQL in op_ind

It basically duplicated an enormous SELECT statement, where a simple OR
would do.
Security tweak: don't check in DB connections!

Pulled the connection info out of db.php, into the non-checked-in
db_conn.php.  Copy db_conn.php.template to db_conn.php, and set the
params locally.

Technically this change isn't necessary, but doing it in case anybody
modifies the code in place and checks it back in.
Changed default passwords to something decent

All passwords had been "password", which is always a recipe for trouble.
Created some decently secure passwords, and checked in just the hashed
forms.
Fixed the Precedence table per se

Made it match the East more correctly.