Show
Ignore:
Timestamp:
05/13/06 15:50:29 (6 years ago)
Author:
dom
Message:

Fix up.

Location:
wiki-toolkit-plugin-categoriser/trunk
Files:
3 modified

Legend:

Unmodified
Added
Removed

  • wiki-toolkit-plugin-categoriser/trunk/MANIFEST

    r261 r265  
    22MANIFEST 
    33Makefile.PL 
    4 README 
    54lib/Wiki/Toolkit/Plugin/Categoriser.pm 
    65t/categoriser.t 

  • wiki-toolkit-plugin-categoriser/trunk/Makefile.PL

    r261 r265  
    22WriteMakefile( NAME         => "Wiki::Toolkit::Plugin::Categoriser", 
    33               VERSION_FROM => "lib/Wiki/Toolkit/Plugin/Categoriser.pm", 
    4                PREREQ_PM    => { 'Wiki::Toolkit',  
     4               PREREQ_PM    => { 'Wiki::Toolkit' => 0,  
    55                                 'Test::More' => 0, 
    66                                 'Carp' => 0 

  • wiki-toolkit-plugin-categoriser/trunk/lib/Wiki/Toolkit/Plugin/Categoriser.pm

    r262 r265  
    125125    my ($self, %args) = @_; 
    126126    my $dbh = $self->datastore->dbh; 
    127     my $sth = $dbh->prepare( " 
    128 SELECT metadata.metadata_value FROM metadata, node WHERE node.name = ? AND metadata.node = node.name AND metadata.version = node.version AND metadata.metadata_type = 'category' 
    129     " ); 
     127    my $sth = $dbh->prepare( "SELECT metadata_value FROM node INNER JOIN metadata ON (node_id = id) WHERE name = ? AND metadata_type = 'category'" ); 
    130128    $sth->execute( $args{node} ); 
    131129    my @categories;