Changeset 356

Show
Ignore:
Timestamp:
10/24/07 23:15:12 (2 years ago)
Author:
eevee
Message:

Removed the only use of the evchains.base column. Mostly in preparation for the eventual database cleanup, but also so I can close #20 with a clean conscience.

Location:
veekun/trunk/lib/Vee
Files:
2 modified

Legend:

Unmodified
Added
Removed
  • veekun/trunk/lib/Vee/Controller/Dex.pm

    r354 r356  
    427427        # chain order for this region, and then let the normal id sorting sort 
    428428        # them within each chain 
    429         @extra_order = "base_pokemon.$col ASC"; 
     429        @extra_order = "MIN(pokemon.$col) ASC"; 
    430430 
    431431        # grab the gen number from @Generations 
     
    448448        %query, 
    449449    }, { 
    450         join     => { evchain => [qw[ base_pokemon pokemon ]] }, 
     450        join     => { evchain => 'pokemon' }, 
    451451        prefetch => { pokemon_abilities => 'ability' }, 
    452452        group_by => [ 'me.id', 'pokemon_abilities.abilityid' ], 
  • veekun/trunk/lib/Vee/Schema/EvChains.pm

    r350 r356  
    1111# My SOLE EXCEPTION to this is Manaphy, which is the base of its chain, but 
    1212# only because that's not a real chain anyway. 
     13# NOTE AGAIN: 
     14# Nevermind!  base is now unused.  Delete to your heart's content. 
    1315 
    1416=head1 NAME